• Created Tableau dashboard to track all of Consolidated’s travel & expenses spending through deeply learning the third-party vendor database (Concur) and implementing advanced Tableau functional logic to address data duplications caused by the vendor’s incorrect setup of their database on the backend.

• Created Tableau reporting to track driver fuel card activity and worked closely with fraud and security personnel to catch over 10 individual instances of fraud detected by this reporting – totaling over $100,000.

• Created SQL Queries that used advanced methods to enhance current reporting capabilities through improving performance and reducing erroneous data.

• Utilized Python scripting to automate mundane tasks (e.g. downloading email reports and appending to csv files).

• Worked with IT and management to establish data pipelines for fuel card and travel and expense data through utilizing vendor database tools and ETL tools to build processes for performing advanced data transformations and producing reporting data.

• Improved department’s continuous auditing reporting through utilizing advanced Tableau logic to automate risk score card calculations for all the company’s branches. Saving the department over 40 hours quarterly.

• Innovated PwC revenue testing controls by reducing the time needed to pull detailed customer transactional data from 20 hours bi-monthly to 10 minutes through identifying an opportunity to replace the department’s Tableau report with a proper process built in Tableau Prep to generate .csv exports for sharing with PwC.

• Execute SOX control assignments and field audit work in timely and successful fashion as directed.

• Work with management to identify new opportunities relating to automation, data analysis, and reporting.

• Prepare detailed validation testing and documentation for all department dashboards as created or directed.

Technologies Used: SQL, Python, Tableau, Tableau Prep, Alteryx, ETL, Data pipelines, Data Modeling, Data Analysis, Reporting, Access, Excel

• Innovated company’s reporting by initiating discussion with management that lead to switch from Google Docs reporting to Google Data Studio – saving over 40 hours a month of Account Manager time.

• Advocated for utilizing Google BigQuery for intensive data analysis needs and prepared scripting and automated push reports for improved visibility using JavaScript and Google BigQuery.

• Lead reporting for all clients under supervision and performed ad-hoc analysis as needed.

• Built Google Sheet and Google Ads scripts using JavaScript to produce push reports and add functionality.

• Architected the company’s first ever automated account error and performance handling system that utilized Six-Sigma principles to statistically isolate performance breaks or trouble areas for all the company’s clients on a 24/7 basis.

• Discovered a way to automate assisted number pulls from the Google Analytics interface using Supermetrics. Saving the analytics team an estimated 2-3 hours a month on reporting and allowing for more detailed levels of analysis.

Technologies Used: JavaScript, PostgreSQL, Google Data Studio, ETL, Excel, Reporting, Data Analysis, Google Analytics, Supermetrics, Zapier

• Innovated company’s consumer data archives by cleaning and merging Business Reply Card (BRC) data with company online customer product feedback data through utilizing Excel Power Query (M-script) to clean, organize, and combine BRC and online customer survey data – producing a centralized location for all the company’s consumer data.

• Created Consumer Shopper Profiles and Reports for Kobayashi’s key brands (HotHands, Grabber, Mediheat, and Be Koool) through analyzing all the company’s newly synchronized consumer data.

• Developed advanced Excel dashboard that tracks the company’s overall online customer review ratings for every brand, retailer, and product type across over 30 key retailer accounts.

• Made Excel competitor tracking files for the Magic Cool and SPACE outdoor brands to provide quarterly insights on competitor product pricing, competitor dollars spent per square inch of fabric, and competitor overall online customer review ratings.

• Maintained marketing campaign tracking files for HotHands and Be Koool digital marketing campaigns.