May 2016 – Aug 2020 · 4 yrs 3 mos

• Led a team of 9 associates across multiple engineering disciplines including big data, structure and unstructured data, R and python ETL scripts, as well as BI tools such as Tableau to engineer and report on Home Depot Delivery performance. Team managed over 1,500 curated and purpose built tables, 80+ tableau dashboards as well as performed analytics on the data to monitor the heath and performance of all delivery lines of business.

Aug 2014 – May 2016 · 1 yr 9 mos

• Responsible for managing multiple financial budgeting models, invoice reconciliation processes, and providing insights at a deep level for big data sets in the billions of rows.
• Also train new employees on financial systems and teach them how to get comfortable with navigating medium to large size data sets and build financial models.

Apr 2013 – Aug 2014 · 1 yr 4 mos

• Built Financial Budgeting Models from the ground-up that plan over $1B of expense annually at very low levels of granularity. All models runs in Microsoft SQL Server, handle multiple data transformations of millions of rows, user input overrides, and smoothing of historical data to remove any noise or outliers. The models also have a simple user front end to allow for adjustments without the end-user needing to ever write a SQL statement. The models provide a full walk of the data from historicals to plan to help build credibility on the data, allow for easy research and variance explanation for P&L analysis. Models have provided new insights to business partners and are giving them actionable information to help them drive cost out.

Apr 2012 – Apr 2013 · 1 yr

• Responsible for creating a bi-annual outbound freight budget for all US distribution centers, optimizing the current financial reporting systems, and consolidating multiple data sources and processes into a simple and quick solution. Also involved in freight forecasting strategy and optimization.

Oct 2010 – Apr 2012 · 1 yr 6 mos

• Responsible for sourcing and developing the new distribution reporting SQL Server and cutting all daily processes down to simple and quick solutions.
• When initially brought into the job, there were over 200 different spreadsheets, Access db's, emailed reports, and other various data feeds that were being maintained by the analysts on a daily basis. This issue would come to light daily if the analyst responsible for a report was out of the office because everything involved in their reports was custom to their desktop setup and could not run on another analyst's machine.
• After only six months on the job and learning the business, I started work on creating and implementing a robust, searchable SQL Server database that would draw all the reporting source needs into one normalized, well constructed database that would automatically update and require no human intervention to push data. To do this, I had to learn SSIS on the job with only google as my teacher as well as work with 3rd party vendors to establish standards and protocols for how they delivered our data on a daily basis. Within 3 months after starting the single source endeavor, all data feeds were sourced into the sql server through SSIS, would automatically update, and required no human intervention (Data updates controlled solely by SQL job agent and FTP transfer).
• I also re-engineered all the distribution Excel reports with my advanced vba skills to follow a specific structure and layout that anyone could learn quickly if necessary. These reports would pull from the newly constructed SQL Server via a view or a stored procedure. Once all the reports were re-designed, anyone on the reporting team would be able to run a report on demand within less than a minute and with no training needed. Before this change of the business, all reports required 4 to 5 analysts and a full 40 hours per week per analyst. Now, all reports can be ran by one analyst in less than 20 minutes.

May 2009 – Oct 2010 · 1 yr 5 mos

• Responsible for negotiating, procuring, and managing the logistics of baggage handling product from Autocad engineering inception to the final delivered product to the airport job site. Worked with multiple vendors, coordinated and expedited equipment to multiple job sites, while maintaining 6 - 8 multi-million dollar product cost budgets simultaneously.