• Led design, development, and implementation of new suite of tools that centralized data, enabled flexible cross client reporting, eliminated the need for 1,000+ Excel spreadsheets, and reduced the time and effort involved to generate forecasts.
• Implemented automated data flows and innovative data architecture, reducing or eliminating manual intervention, and increasing accuracy and reliability of data sources.

Designed and developed custom ETL based on XML data files that once received triggered several processes including validation, logging the transaction in the database, sending out an email to the customer, and providing an return XML confirming success or failure.

• Launched client into next phase of Business Intelligence by setting up beautiful visualizations with Tableau to replace Excel pivot table reports.
• Implemented framework for data storage solution and provided leadership and training for a more robust and automated Business Intelligence environment.

• Designed and implemented SOAP web service for standard communication with the credit card merchant as well as accurate tracking and reporting of online transactions.