Richard Huff Email & Phone Number

Framingham, Ma, Us

El Paso, Texas, Us

• Freed up team leaders to develop new executive reporting by managing the back end ETL and RPA scripting for our published market share and category insight reporting.• Streamlined the processing and report preparation time from 2.5 days to 8 hours. • Trained in WinAutomation, PowerAutomate, DAX, M Code, and Power Query for Power BI and Excel.• Recreated RPA scripting from WinAutomation in Power Automate; avoided reporting down time and any changes needed to the SQL queries.• Developed relationship with Nielsen Account Manager for migration, troubleshooting, and communication of user training.• Recreated 93 extracts from Nielsen Answers to 63 in Nielsen Discover; reduced the Excel files handled from 93 to 3. Eliminated an entire WinAutomation flow.• Guided the IT team through the reporting process for migration to Snowflake; performed UAT.• Prototyped a Power BI tool for quickly surveying product sales performance by retailer.• Compared Nielsen POS data and IQVIA FAN/Flu illness population data to identify dollar volume and market share changes to executive management for our Humidifiers and Thermometer categories.• Provided customized trend analysis reporting for key accounts, including Walmart and CVS.

El Paso, Texas, Us

• Proactively collaborates with stakeholders, identifying needs and solving problems with analytical prototypes that present insight to Executive, Marketing, Engineering, and Quality teams. • Proactively advocates for future data modeling needs, scalable reporting tools, and data visualizations.• Prepared and improved the Direct-to-Consumer (DTC) Flash Report, showing monthly-to-daily gross sales from orders shipped and open orders in process (Power BI, Power Query, DAX, Excel).• Prototyped an interactive Consumer Relations transaction dashboard featuring time series line charting, treemaps, and doughnut data visualizations, to monitor operational transactions for sales, warranty, and refund orders (Oracle Analytics).• Developed the monthly review of Demand Planning’s unit forecast to ensure inventory for direct consumer sales and warranty orders (Oracle BI, Excel).• Identifies emerging trends for hundreds of Braun, Honeywell, PUR, and Vicks consumer product SKUs within the air purifiers, humidifiers, thermometers, and water treatment product lines (Excel).• Designed monthly, quarterly, and semi-annual management reporting of consumer feedback, featuring advanced visualizations and interactive pivot charts and tables (Excel). • Partnered with IT to publish consumer feedback for six product lines (SharePoint).• Developed Python scripts to extract, merge, clean and process large data sets to produce insight like top contact reasons and claims volume.

Extracting actionable insights from complex data sets with ETL mining, statistic, modeling, and visualization techniques. • Fraud Case Study: Extracted 400,000 lines of sales transactions from Excel to clean, describe, and impute sales, salesperson, product, pricing, and inspection information: http://rpubs.com/rhuff/fraudcasestudy • Urban School District Capstone Project: Partnered with the data manager of an actual New England school district to extract and transform 17,000 Excel achievement test score records to compute, compare, and visualize student, cohort, test, and school performance information featuring relationships and trends within multi-dimensional demographic variables. http://rpubs.com/rhuff/schooldistrict• Burning Glass Technologies “xCase”: Extracted 1,000,000 lines of job posting records from a .txt file to clean, explore, transform, and analyze job market and skills data to form recommendations for allocating funds to programs that address skills gaps in the New York City. Developed relational schema and queries, as well as interactive dashboards and visuals to communicate return-on-investment (ROI) opportunity. Link to award: https://www.northeastern.edu/rise/presentations/building-a-national-job-market-analytics-platform-would-accelerate-hiring-and-bring-fair-compensation/ • Stattleship “xCase”: Extracting 100,000+ player and game data records to develop a new, predictive baseball metric. Cleansed data and developed R code for descriptive analysis, inferential analysis, and 3D visualization. • EdX Lab: Building a relational database using MySQL Workbench and SQL Server to enable this online education company to perform complex SQL queries and calculations within its course registration records.• EY Interview Assessment: Scored 97% for aptitude with Excel pivot tables and VLOOKUP formulas. • Amazon Interview Assessment: Developed an interactive project management dashboard in Tableau.

Intermediate Data Analytics, Data Modeling/Warehousing And Database Administration

Bachelor’S Degree, Business Administration, Management Information Systems

Professional Certification As Project Management Professional, Project Management