MS Excel (1995-2019) – Advanced power user/developer with VBA (Industry)
SAP/HANNA 7 Master Data financials and supply chain modules (Industry)
Excel Analysis Office to interact with SAP & OCEAN financials module (Industry)
SSIS packages of SQL Server 2012 for ETL processing (Industry)
SSRS - SQL Server reporting module (industry)
MS Access Reports (2003-2016, Forms, SQL, VBA Data Modeling (Industry)
Hyperion 7X Essbase Solutions – BI Tool (Industry)
Tableau Professional Ver. 7.0 (Industry)
(Rapid Analytics and BI dev. Tool - Training)
SAS 9.0 with Enterprise Guide 4.0 (Training/Industry)
SAS Desktop version Business Objects Versions 6.5 and XI and Crystal Reports 11 (Training/Industry)
Oracle 8i –Certification Training, Oracle 11g with Toad & PL/SQL (Training/Industry)
SPSS Statistical package (Graduate School)
TSP – Time Series Analysis Processor (Graduate School)
GB STAT (Graduate School) PeopleSoft (Industry)
People Tools SQL modules Cognos Impromptu and PowerPlay (Industry)
Business Intelligence Microsoft PowerBI (Industry)
Alteryx BI Data Management Software (Industry)
MS Excel Power Pivot and Power Query with DAX code (industry)
AQT (Advance Query Tool for database navigation) (Industry)
DBVisualizer (Database SQL navigation tool) (Industry)
DBeaver (Database SQL navigation tool) (Industry)
CA Agile Central / Rally (Industry) MS Visio (Industry)
TSF (Team Foundation Server of SQL Server) (Industry)
Teradata Database (Industry) Teradata SQL Assistant (Industry)
ALM - Application Lifecycle Management (Industry)
JIRA - Defect and IT project status management (Industry)
Oracle 19 SQL Developer (Industry)
MySQL (Personal Interest)
Power Builder (training)
Visual Basic - Stand Alone (training)
My core strength is in a functional combination of business, finance and technology skills generating sufficient synergies which drive value add for those who consume information generated from comprehensive analytical processes.
My career path has offered me countless valuable lessons and opportunities to develop skills and expertise working with technology and business executives in finance, sales, marketing, IT, project management along with product owners, developers, data modelers, data and solutions architects, operations managers and analysts.
Can communicate at the professional level effectively both verbally and in writing.
Highly organized, self driven, focus without waiting for directions and taking initiative, comfortable working with leadership teams.
Fluent with presentations, not hesitant of delving into new technologies, methodologies and tools and a good team member for productive and efficient collaborations.
In this section my goal is to provide a reasonable insight regarding what I can do using Excel in data analyst role at a large organization. I do hope that for the potential hiring manager this section carries sufficient amount of information to form a general idea about my skills level in utilizing Excel tackling with complex data problems.
SELECT EXCEL PROJECTS DELIVERED:
BASF - BIT application (Excel component). This tool was designed using input from SAP staged and stored in Access database files and text files and fed into the Excel Power Pivots and Power BI model built on DAX functions for sales team to track their performance.
Wells Fargo - Wealth Management / Trust Services - System testing scheduling tool for the testing team to track weekly UAT and SIT testing activities. Reviewed, improved and streamlined an automated reporting tool interacting with SQL Server data sets and posting them to SharePoint in support of wide range of audience as an input for multiple reporting needs.
MHFA (Minnesota Housing Finance Agency) - Developed custom tool in Excel working with Access to gather incoming data sets from the field and feed housing financing database to track the program status.
Prime Therapeutics - Maintained and improved the existing tool tracking activities for quality control and management for the online prescription delivery. It was interacting with the monthly quality reporting system via VBA based structure.
UHG/Optum (Care Solutions) - Developed a reporting dashboard for the senior leadership team. This tool was interacting with Access database files via ODBC and Excel query functions via pivots and VBA routines to update the dashboard.
GMAC-RFC - (currently dba Ally Financial) Developed pivot based reporting system which was producing 300 pages long performance reports tracking activities in asset based investments in the mortgage investment area.
NCR - (National Car Rental)Created a tool in support of Access based system feeding the OROS ABC (activity based accounting) software to monitor and analyze the financial data and tying it directly to individual car rental activities using unit based metrics.
Standardized tests are designed to measure one's ability to use the built-in Excel functions that are provided through the menu options on the ribbon. On the other hand, there is not a single test that can even remotely measure one's ability to be fully productive in Excel by creating VBA procedures, user defined functions, complex and lengthy formulas and creative solutions.
If you need a candidate who can bring truly comprehensive solutions to complex data issues in Excel, try to gauge his or her capabilities by providing a real life problem as a project and ask to resolve this in areal life time frame whether it is couple hours, a day or a week instead of putting that person through a standardized, timed test module where test taking abilities are evaluated in reality instead of true skills and capabilities.
I was tested on my Excel skills numerous times on standardized Excel skills tests. On the average my scores hover around the neighborhood of 90% at mid to advance level tests. I’d place myself at 9 out of 10 for my Excel skills and that is very satisfactory for the most part. I understand that by using this test they gauge candidates and narrow down their options as anyone can claim expertise in Excel and even if they sincerely think they know a lot about it without even realizing what they are not even aware of.
Most of the client needs fall into the category that can be handled without leveraging the true power of Excel. In this case it makes sense that they use standardized tests. On the other hand, it certainly does not measure the more advanced skills, abilities and creativity of the power user or developer in order to create highly complex spreadsheets nor it shows how the user tackles a certain problem for data manipulation as there are literally numerous ways to resolve a problem. For more complex task such as creating a pricing decision tool in already complex setting like a trade room, or complex rate sheet development or a scorecard development working with large backend databases typical Excel skills simply do not cut.
There are two dimensions to Excel, one is that most people are familiar with and that is Excel’s user interface and spreadsheet along with some functions and formulas utilizing the formula line pivot tables and MS Query and for a lot of job descriptions this might constitute advance skills and this indeed would be classified as such for the average user. Even Advance Excel classes that they cover in technical colleges do not go any further than that. The other dimension of Excel is wide open.
This dimension is in the space of Visual Basic for Applications programming and using Excel only as a platform by creating UDF modules, sub procedures and routines. There is simply no standardized Excel test or maybe I have not come across with one like that which can measure the kinds of capabilities that I am referring to here. The best way to gauge this sort of capability would be to put the person on a task or send him or her a complex problem with sample data set and through explanation of the problem scenario along with the requirements and see how he or she works towards a solution.
In a DA role using Excel as the de-facto data processing and presentation tool for the end users in a connected environment to external data sources and in conjunction with various other tools for the most part I was involved with ETL type of functions. The bulk of this job was in the letter T part for data transforming but more recently Power Query, Power Pivots and merging my work with Power BI helped me immensely to increase my efficiencies in any kind of challenging data transformation jobs as my source data was all over the place to feed automated reporting processes in addition to utilizing VBA and SQL scripting throughout my career working with MS Excel. My current view of Excel is such that it has evolved into a completely integrated development environment supporting many BI type projects in a rather comprehensive and powerful manner.
US Bank - PPP (Payment Protection Plan) tracking application to measure banker cross sale performance to base bonus calculations for each campaign period and to support quarterly marketing campaigns.
GMAC-RFC - Application to measure and track monthly mortgage servicer performance which was submitted to the senior leadership team.
BASF - BIT (Business Intelligence Tool - Access component) application to process SAP data and to provide dynamic reporting solutions for sales team and executives.
BASF - Pricing database application to communicate individualized letters to each customer for contract term updates.
Ameriprise - Net cash flow tracking application
OptumHealth Care Solutions: Executive BI application summarizing the financial, operational, claims and HR activities.
Wells fargo/Trust Services - Data migration testing scheduler application.
Minnesota Housing Finance Agency (MHFA) - Access based reporting application for the business users to track program delivery status.
Express Scripts - Tool to facilitate a detective analysis to identify certain types of transactions and tracing them to find patterns.
National Car Rental (NCR) - Application to support ABC (activity based accounting) and quarterly marketing campaigns.
Access Work Content: My typical work with Microsoft Access has been usually geared towards the BI reporting environment. In this capacity I created Access tools helping leadership teams to track the key business indicators. These tools were used to track product, asset or sales performance, operational and financial status for mid level and executive managers via scorecards, benchmark reports and similar.
Access SQL/Excel skills apply to most of the jobs listed on my resumeHighly 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 CrimesUsed 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. UHG ITUsed 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. BASFControlled 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 ServicesGenerated 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.Wells Fargo Compliance – Financial Crime Data ServicesTeradata database and SQL assistant to interact with very large data sets. Wrote SQL test queries as part of UAT testing project for various migration projects. Mercer Outbound Data Configuration/SQL WorkRan PL/SQL statements on UI to update and modify backend Oracle tables. Reviewed and prepared SQL blocks based on client file requirements.
To illustrate some of my personal Power BI files I added this page. Since sharing the actual work files would not be permissiable here I decided to provide a few personal samples. The underlying data sets of these visuals are from my contracting job history details in Excel encompassing analysis period of the last 9 years. In their native environment these are all drillable graphics based on further manipulated data via DAX functions to the lowest detail. They were placed here as image files which can be enlarged.