Access SQL/Excel skills apply to most of the jobs listed on my resume
- Highly experienced with Access SQL both
constructing via GUI to construct a complex query or creating a script for data manipulation and action queries which cannot be created by GUI.
- Using embedded SQL in VBA modules in
Access/Excel that were running based on user action or certain database actions also to maintain the data integrity.
- Created user forms with user functions
triggering stored queries that are activated by certain user actions.
Optum (UHG), Target Supply Chain, Wells Fargo Wholesale Banking and Wells Fargo Compliance/Financial
- Used various database management tools
to write SQL statements against large databases such as Teradata, Oracle, DB2, SQL Server or Hadoop (Big Data), Data Lakes and Azure.
- Worked with tools such as AQT
(Advance Query Tool), Oracle Toad, DB Visualizer, DBeaver and Teradata SQL Assistant to write SQL scripts.
- Used SSIS packages to store SQL
scripts and ran against Oracle tables at UHG IT to update tables stored in Oracle whihc provided data sets feeding tables running on client web sites.
- Controlled SQL statements in Excel macros
embedded in VBA running against external data sources such as SAP master data.
- Power Pivots as an add on in Excel
connecting to any external data source via ODBC and running from within macro statements stored in VBA modules.
- Utilized DAX code which is the native code
for Excel Power Pivots and Power Query.
- Developed Excel and Access based business
intelligence tool for the sales and financial managers.
Wells Fargo Trust Services
- Generated weekly reports by modifying
and running SQL scripts from SQL Server database, modified and maintained the code as needed.
- Built Excel based UAT scheduling tool to
manage general testing activities.
- Modified excel based automated reporting
process based on VBA functions and procedures.
My core strength is in functional combination of business, finance and technology skills generating sufficient synergies which drive value add for those who consume
information generated from adavance analytical processes.
Ever increasing need to handle tremendous amounts of data to make sound business sense from all of the available digital sources originating in many different formats in a data
driven enterprise offer the opportunities for me.
My career path so far has afforded me countless valuable lessons and opportunities to develop skills and expertise working with technology
and business executives in finance, sales, marketing, IT, project management also with product owners, developers, data modelers, solution architects, operations
managers and analysts.
Effective communicator both verbally and in writing, highly organized, self sufficient and self-motivated with a good drive, can anticipate where to focus without waiting
for directions, fairly comfortable working with executive leadership team, fluent with presentations, not hesitant of delving into new technologies, methodologies