Designed, created, tested, and deployed an end to end, Excel-based desktop automation program to extract and consolidate daily and monthly statistical data for all American Express Billed Business and Cards in Force reporting. The daily automation handles 221 individual text files on a daily and basis and converts, formats, maps, and consolidates the data into Flat File submissions for the Statistics Essbase Cube. The automation process creates approx. 520k statistical records on a monthly basis for Essbase and has generated a savings of over 5,000 hours annually compared to previous manual processes and reduced the error rate by almost 100%.

Provide end-to-end Software Capitalization (SW Cap) reporting and analysis for the AET development portfolio annually generating over $1BM in SW Cap benefits and over $700M in amortization expenses • Developed and implemented a customized monthly Visual Basic reporting automation program that combines over 100K lines of data from three separate reports into a single comprehensive file to provide previously unavailable detailed-level SW Cap reporting. Reporting file provides greater transparency of data and significantly enhances the analytics capability of the SW Cap team

Designed, created, tested, and deployed an end to end, Excel-based desktop automation program to extract and consolidate daily and monthly statistical data for all American Express Billed Business and Cards in Force reporting. The daily automation handles221 individual text files on a daily and basis and converts, formats, maps, and consolidates the data into Flat File submissions for the Statistics Essbase Cube. The automation process creates approx. 520k statistical records on a monthly basis for Essbase and has generated a savings of over 5,000 hours annually compared to previous manual processes and reduced the error rate by almost 100%. 

Directly supported the Global Business Transformation team to create advanced financial models to validate reengineering initiatives for Gemini ($4.7M annual savings), Incentive Effectiveness ($2.3M annual savings) and My Enterprise Training ($8.7M annual soft savings). These advanced models expanded the scope of variables to include fully loaded S&B costs, refined estimates on vendor savings, and incorporating technology development and infrastructure costs. • Developed and taught 27 advanced Excel and Visual Basic Application (VBA) internal training sessions in 2 hour increments to over 500 employees in 2011 and 2012, investing 90 hours of personal time toward further mentoring and skill development for American Express employees. • Validated annual reengineering savings of $500M through advanced Excel modeling, Visual Basic automation, and data mining.  Increased efficiency by over 50% and improved accuracy of validation process through automated tools to process and organize data into standard reporting templates

Developed and enhanced an automated regional performance tool used to provide executives with a more consistent and accurate view of operating results for a region on a monthly basis. Report used extensive VBA programming to provide the ability to download up to 1.5M data points to populate 40 different schedules and improved the time to produce the report from 5 days to 1 day for 36 districts and 5 regions

 • Provided profitability analyses for over 100 global and premier travel agency contracts in North America. Accounts collectively produced over 25% of annual company revenue ($500M). Close collaboration with over 100 sales account directors to model accurate and detailed contract terms in the financial model, analyze P&L impacts due to new contracts, refine and maintain an advanced financial modeling engine in Excel, and monitor and adjust computer and printer pricing for all North American travel agencies.  • Created an advanced Excel modeling tool with extensive VBA programming to automate contracts with travel agencies used by over 300 sales managers in the North American region which processed over 500 contracts annually, representing over 50M bookings