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.