Rory L.

Rory L.

Python Developer Specializing in Fully Automated Solutions for Analytics and Visualizations

Peoria , United States

Experience: 19 Years

Rory

Peoria , United States

Python Developer Specializing in Fully Automated Solutions for Analytics and Visualizations

USD / Year

  • Start Date / Notice Period end date:

19 Years

Now you can Instantly Chat with Rory!

About Me

2+ years Python development for fully automated data ETL solutions for Enterprise Cloud Platform capacity reporting and demand analytics

2+ years Tableau Desktop / Server developer of interactive dashboards / visualizations

2+ year...

2+ years PostgreSQL data warehouse administration and management

R and RStudio caret Machine Learning Algorithms to include Random Forest, SVM, and GBT for classification and regression

Alteryx Designer developer of end-to-end automation solutions with integrated Python scripts and PDF parsing (textract)

Show More

Portfolio Projects

Description

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

Show More Show Less

Description

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%.

Show More Show Less

https://www.americanexpress.com/

Excel VBA Desktop Automation for Amex Billed Business

Contribute

Lead Developer and Agile Project Manager for this Project - supervised six people - 2 VBA developer contractors and 4 business analysts for development and testing.

Description

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%.

Show More Show Less

Description

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 modelsexpanded 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

Show More Show Less

Description

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

Show More Show Less

Description


• 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

Show More Show Less