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. 


 ADVANCEd   Excel                                     Access                 databases                                       VBA macros                                       SQL scripts                                       BI Reports                                         data   integrity                                          big data                                             data science                                   data mining                                     data mapping                                   data profiling                                 data   visualization                                   data modeling                                 financial     analysis                                           SCORE CARDS                                     BENCHMARKS                                     PERFORMANCE   KPI METRICS

Print Print | Sitemap Recommend this page Recommend this page
© Ray Erden

This website was created using 1&1 IONOS MyWebsite.