Business Intelligence Product Development

SHUBHAM GARG

**************@*****.*** 857-***-**** linkedin.com/in/shubhamg2

SUMMARY

Experienced Data and BI professional with 4+ years of expertise in streamlining reporting processes and driving data-driven decisions through collaboration with multidisciplinary teams. Adept at developing scalable dashboards using Tableau, designing ETL pipelines, SQL, and Python

TECHNICAL SKILLS

Business Intelligence: Tableau (Desktop/Server), Power BI, Looker, Google Analytics, BigQuery Data Engineering: Alteryx, Talend, GCP, Snowflake, Redshift, PostgreSQL, MSSQL, MySQL, Oracle Data Mining: SQL (Advanced), Python

Project Management: Advance Excel, Oracle ERP, Quip, SharePoint, Agile, JIRA, BRD, FRD, SDLC, Microsoft Office PROFESSIONAL EXPERIENCE

CVS Health, Providence, RI March 2021- Present

Manager, Analytics and Strategy, Pharmacy Product Development Jan 2024- Present

Own the reporting portfolio for the Pharmacy Health and Services overseeing 3 different outreach programs.

Led the creation of backend reporting infrastructure in Snowflake, powering user-friendly Tableau dashboards, enabling 50% faster data retrieval, and delivering actionable insights to 1500+ stakeholders. Senior Data and BI Consultant, Pharmacy Product Development Mar 2021- Dec 2023

Automated 20+ excel reports using SQL and Python, saving 15 hours/week, driving data-driven decisions around Patient’s behavior and vaccinations, boosting productivity and program efficiency.

Developed 15+ key metrics by collaborating with cross-functional teams to portfolio performance, detail status, estimate forecast, trends and variance for FY 2021 and beyond across 10k+ CVS stores.

Led the creation of singe source of truth patient and vaccine level reporting to drive insights on patient behavior and inform outreach team strategy by leveraging outreach channels and patient demographic data.

Achieved a 30% improvement in data accessibility and database performance through efficient data pipelines and SQL performance tuning, enhancing reporting efficiency for Retail and Field Leadership.

Spearheaded the creation of a 40+ document repository for tools, reports, and metadata enhancements, streamlining reporting processes and improving knowledge sharing. Amazon Robotics, North Reading, MA Jan 2020 – June 2020 Business Intelligence Analyst

Led ETL efforts from Redshift to establish a "single source of truth" BI solution in Tableau, tracking a 2-year timeline with critical milestones and developments across new AR launch sites for Executive leadership and 25 teams.

Designed and developed a Compliance Dashboard, achieving 100% team accountability, eliminating cross-functional dependencies, and generating actionable recommendations.

Achieved a 92% accuracy rate in predicting demand signals using product data, collaborating with customers and partners across 4 teams and 2 business units.

Generated insights by writing complex SQL scripts for ongoing metrics, reports, and ad-hoc reports, supporting cross- functional customers.

Contributed to process improvement and standardization by creating BRD and FRD documents around workflows and processes.

Indian Oil Corporation Ltd., India April 2017- Aug 2018 Business Data Analyst

Analyzed consumer behavior, identifying patterns, measuring product interactions, and reducing churn by 15%.

Developed metrics, dashboards and enhanced reporting to aid product owner track performance and mitigate risk. PROJECT

Centralized Retail Data Warehouse (ETL, Alteryx, PostgreSQL, Oracle, SQL Server, MySQL) December 2019

Developed a Star schema dimensional data model by extracting data from multiple data sources.

Built bulk ETL pipelines to ensure one-click load for the entire data warehouse in 20 minutes.

Constructed Slowly Changing Dimensions (SCDs) to handle changing customer’s information.

Developed interactive dashboards to analyze KPIs for over 20M transactions using SQL, Tableau and PowerBI. EDUCATION

M.S. Engineering Management, Northeastern University, Boston, MA Sep 2018- Aug 2020 M.Tech Computer Science and Software Engineering, India Aug 2012- July 2017

Contact this candidate