Functional Skills
Agile Software Development
Project Management
Budgeting
Customer Relationship Management
Accounting
Benchmarking
Accounts Receivable
Data Management
Data Migration
SQL Analysis
Revenue Cycle Optimization
Process Improvements
Data Analysis
Business Analysis
Variance Analysis
Software Skills
Microsoft Excel
Microsoft Access
SQL
Microsoft Office
VBA
T-SQL
SQL Server
Dax
Sector Experience
Business Services
Healthcare
Manufacturing
Technology
Transportation & Logistics
Experience
Multiple Clients
Management Consulting
Management Consultant
5/2018 - 3/2024
Multiple Clients May 2018 – March 2024
Contract (7 month) Project: MyEyeDr (Finance)
• Budgeting, forecasting, reporting, and analytics for Labor & Sales using Planful
• Redeveloped business processes for financial data management
• Created statistical model for estimating the effects of weather event impacts.
• Automated reporting using PowerBI DAX, Excel, and VBA
Contract (7 month) Project: MyEyeDr (Finance)
• Budgeting, forecasting, reporting, and analytics for Labor & Sales using Planful
• Redeveloped business processes for financial data management
• Created statistical model for estimating the effects of weather event impacts.
• Automated reporting using PowerBI DAX, Excel, and VBA
Prism Healthcare Partners LTD
Data Science / Analytics
Senior Analytics Consultant
10/2013 - 5/2018
• Co-founded a dedicated Analytics division for medium-sized healthcare consulting firm. This division performed statistical analysis and data tool/reporting development/programming for multiple consulting projects at hospitals throughout the country.
● • Designed and built out the company's internal benchmarking data warehouse
● • Developed, in T-SQL, machine-learning tools for processing and interpreting large datasets.
● • As a senior member of the team, I mentored and developed junior analysts, and coordinated larger projects.
● • My primary area of focus in Revenue Cycle, but also significant work in Supply Chain and other service lines.
● • Resident expert on Excel, Access, VBA, SQL, T-SQL, Tableau, Monarch, and other tools & technologies.
● • Designed and built out the company's internal benchmarking data warehouse
● • Developed, in T-SQL, machine-learning tools for processing and interpreting large datasets.
● • As a senior member of the team, I mentored and developed junior analysts, and coordinated larger projects.
● • My primary area of focus in Revenue Cycle, but also significant work in Supply Chain and other service lines.
● • Resident expert on Excel, Access, VBA, SQL, T-SQL, Tableau, Monarch, and other tools & technologies.
Multiple Clients
Management Consulting
Management Consultant
10/2006 - 4/2014
Contract (10 month) Project: Wockhardt USA (Finance)
• Investigated and fixed problematic process for determining financial chargeback credits.
• Analyzed & documented existing process and tools for handling returned goods credits, to identify and prevent erroneous and/or fraudulent claims.
• Designed a new process and tools. Created tools using Excel, Access, and VBA.
• Documented and trained new process
Contract (1 year 5 month) Project: University of Chicago (Marketing/IS)
• Developed custom VBA-based tool for a data migration need.
• Designed and created reporting infrastructure using SAP Webi, Excel, Access, and VBA in a SunGard Advance environment.
• Developed training materials for Webi users.
Contract (1 year 5 month) Project: Huron Consulting Group (Programmer)
• Principal designer of custom Microsoft Access/VBA database software package and related data-handling practices for internal use
Contract (8 month) Project: Northwestern University (Marketing/Programmer)
• Gener
• Investigated and fixed problematic process for determining financial chargeback credits.
• Analyzed & documented existing process and tools for handling returned goods credits, to identify and prevent erroneous and/or fraudulent claims.
• Designed a new process and tools. Created tools using Excel, Access, and VBA.
• Documented and trained new process
Contract (1 year 5 month) Project: University of Chicago (Marketing/IS)
• Developed custom VBA-based tool for a data migration need.
• Designed and created reporting infrastructure using SAP Webi, Excel, Access, and VBA in a SunGard Advance environment.
• Developed training materials for Webi users.
Contract (1 year 5 month) Project: Huron Consulting Group (Programmer)
• Principal designer of custom Microsoft Access/VBA database software package and related data-handling practices for internal use
Contract (8 month) Project: Northwestern University (Marketing/Programmer)
• Gener
O-I
Operations
Production Manager
3/2005 - 8/2006
• Supervision of 9 production supervisors
• Management of all aspects of production department
• Offered a third promotion to Factory Manager, but I was unable to relocate
Maintenance Supervisor / Project Manager
• Oversaw the day-to-day operations of the Preventative Maintenance team
• Managed a project re-designing the practices used to plan and document the Preventative Maintenance program for entire plant
• The process and tools I developed were documented by corporate engineering as "Best Practices"
Production Supervisor
• Supervision of 50 full-time union production workers making compression-molded plastic closures
• Broke single-day record for production
• Management of all aspects of production department
• Offered a third promotion to Factory Manager, but I was unable to relocate
Maintenance Supervisor / Project Manager
• Oversaw the day-to-day operations of the Preventative Maintenance team
• Managed a project re-designing the practices used to plan and document the Preventative Maintenance program for entire plant
• The process and tools I developed were documented by corporate engineering as "Best Practices"
Production Supervisor
• Supervision of 50 full-time union production workers making compression-molded plastic closures
• Broke single-day record for production