"EASY BUTTON"
EXAMPLE PROJECTS
Sr. Agent Workload Report
An ETL & Dashboard project in which an extract from the existing database is combined with multiple workbooks outside the database.
​
Results
-
95% reduction in time for basic report production.
-
100% reduction in production errors.
-
Additional insight previously unavailable.
Contract Task Order Merge
A data normalization, reconciliation and migration project, preparing multiple related but vastly different data sources for incorporation into a successor database.
​
Results
-
Accomplished in 8 hours what was initially estimated at 200+ hours.
-
Runtime to incorporate additional data files 1.5 minutes.
Activity Tracker
Utilizing VBA, Power Pivot, and DAX this application links Excel and Outlook to scrub the Outlook calendar for relevant meetings, task, etc... producing a report PDF formatted to the client's specifics. This report is subsequently attached to an email for submission.
​
Results
-
68.2% increase in timely report submission
-
95% time savings
Data Reconciliation Tool
Utilizing VBA, this reconciliation tool performs a cell-by-cell analysis detecting and documenting variances. Designed as a stand-alone tool or one that can easily be incorporated into a larger process.
​
Results
-
In just 2yrs. of use this tool has saved 1,000 + hours
-
The larger the data sets, the better it performs against manual reconciliation methods.