Senior Analyst, Audience Measurement Lead
- The Home Depot
- Full-Time
- Atlanta Metropolitan Area
- Oct 2021 - Present · 8 mos
Leveraging digital marketing and analytical capabilities to further Thermo Fisher’s goal of enabling customers to make the world healthier, cleaner and safer.
• Lead the conception, development, and maintenance of a comprehensive, Alteryx powered operations dashboard for Caterpillar’s largest engineering group that enabled Senior Engineers and Managers to identify cost reduction opportunities across sourcing, logistics, performance, and quality.
• Responsible for the planning, partnership and implementation of an ETL solution that improved the load time of data by 50% at no additional cost and enabled the team to democratize data thereby fueling innovation across the organization.
• Managing the development/maintenance of dashboards with an annual spend of $1.2 Billion
• Responsible for day-to-day analytics @ Caterpillars largest engineering group- IPSD
• Adept at handling disparate data sources- 6 databases, multiple spreadsheets in 2 Tableau dashboards. Alteryx designer core certified.
• Spearheaded the development of weekly templates, dashboards, and reporting systems that allowed for constant refinement and reflection implementing Continuous Improvement approach for Michigan’s largest energy provider.
• Initiated the migration process of the largest operations group, Distributed Ops from a spreadsheet-based ecosystem to a SAP, Maximo, SQL, Power BI and Tableau based live weekly reporting system.
• Developed operational metrics and weekly forecast dashboards that facilitated operational calls, reviews and tracked performance to targets which promoted Continuous Improvement efforts across the organization.
• Provided support across DTE Energy’s key verticals of Business Process Analysis, Continuous Improvement Model (CIM), Operational Metrics (safety, cost, quality, delivery), and Forecast analysis.
• Planned and executed the development of DRM, a Data Relationship Management tool for J.D.Power’s top client, Mercedes-Benz Financial Services that helped review and analyze dealership performance across the United States.
• Developed live dashboards for J.D.Power’s primary client reporting tool, VoX, including Breakdown charts, Gap charts, Heat Maps, Performance and Mix charts, Rank charts, Swoop chart, Trend charts, and Gauge charts.
• Built predictive models for the Global Research Operations Team (GRO Team) on the 2017 U.S. Dealer Financial Satisfaction study; this included significance tests, distributions, scorecards, rank charts, Key Performance Index (KPI’s) for clients such as Mercedes-Benz Financial Services, Ford Credit, Toyota Financial Services, and BMW Financial Services.
• Performed quality checks on data, simulators, and models constructed for the 2017 Finance and Wealth reports; ran models to research, retrieve and deliver data using SQL, Microsoft Excel, mTAB and SPSS extensively;
• Conducted quantitative data gathering for ACCESS, one of the largest non-profit organization in Michigan.
• Interacted with internal and external stakeholders to understand the true objective of the survey.
• Designed a survey instrument to capture maximum emotion based on the seven-point Likert scale.
• Administered the survey at multiple venues across varying timeframes.
• Improved data quality by replacing missing data, correcting spelling errors and detecting anomalies.
• Performed univariate and inferential statistical analysis.
• Carried out secondary research on competitive strategies
• Documented research findings, composed written reports, and presented the results to internal administration and external clients.
• Coordinated client-handling and communication with internal and external stakeholders.
• Collected, analyzed, and reported findings to the key stakeholders in the $74 billion automobile market in India.
• Performed Demographic segmentation and identified key patterns in automobile consumption based on website visits, Web activity, and social media response, helping Gaadikey improve customer retention by 25%.
• Analyzed customer data over the lifecycle of a project to recognize preferred mode of information consumption. Planned and produced relevant video content thereby increasing engagement by 300% and acquisition by 20%.
• Conducted an analytics workshop and coached Starsports.com employees thereby reducing support dependency on Voiro by 56%.
• Performed exhaustive competitor analysis, Customer profiling and developed ranking systems to kick start Voiro.com’s marketing campaign.
• Cleaned and analyzed historical data to identify most valuable clients, most valuable products and most favorable seasons. This facilitated the hyper-aggressive pursuit of targets resulting in 30% increase in sales.
• Visualized sales data and developed supply-chain patterns thus enabling us to target and serve key customers early.
• Developed systematic reporting processes and procedures to ensure visualizations and user permissions were delivered in a
timely manner for all ad hoc requests.
• Analyzed customer data to develop a classification model that could identify customer affinity towards product lines
using customer demographics and purchase information.