Himanshu Garg

Business Analyst

Gurugram, Haryana, India4 yrs 3 mos experience

Most Likely To Switch

Key Highlights

Over 4 years of experience in data analysis.
Expert in SQL and Power BI for actionable insights.
Proven track record of optimizing data workflows.

Stackforce AI infers this person is a Data Analyst with expertise in SaaS and Healthcare industries.

Contact

Skills

Core Skills

Data AnalysisData VisualizationBusiness Analysis

Other Skills

AWS S3Amazon AthenaAmazon S3Amazon Web Services (AWS)Analytical SkillsDAXExcelMicrosoft ExcelMicrosoft Power BIPivot TablesPython (Programming Language)Python NumpyPython PandasSQLTableau

About

Results-driven Data Analyst with 4+ years of experience in analyzing, designing, and transforming complex datasets to deliver actionable insights that drive business performance. Skilled in SQL, Excel, Power BI, and Python, with a strong ability to translate business requirements into data-driven solutions. Experienced in building interactive dashboards, extracting data, and performing deep-dive analyses to identify trends, optimize processes, and support strategic decision-making.

Experience

Demandbase

Data Analyst

Jan 2023 – Present · 3 yrs 2 mos · Hyderabad, Telangana, India · Hybrid

Optimized project workflows by developing pipelines in AWS Athena driven by Advanced SQL Queries, Automated Recurring Tasks and significantly improving operational effectiveness thereby reducing the delivery period by more than 30%.
Created Compelling and Interactive Dashboards in Power BI to aid sales team in pitching to prospective clients.
Conducted comprehensive data quality analysis using Advanced Excel Functions, ensuring data integrity and validity to uphold the highest standards of accuracy.
Utilized Python and SQL for a comprehensive cleaning and automation, resulting in a 25% reduction in cleaning time and a post-cleaning accuracy rate of 90% thus contributed to the enhancement in targeted marketing accuracy, leading to a 15% increase in sales within the specific customer segment for the client.
Strategically compiled and categorized an extensive list of companies and contacts, meticulously evaluating and aligning them with client requirements by filtering the data from a complicated dataset comprising of more than 300 Million rows across multiple tables.

Pivot TablesData VisualizationPython (Programming Language)SQLMicrosoft Power BIPython Numpy+6

Zs

Business Operations Associate

Dec 2021 – Jan 2023 · 1 yr 1 mo · Gurugram, Haryana, India

Handled work streams for a Pharmaceutical Client that involves Incentive Compensation Payouts of 1700+ Sales Representatives.
Maintained and Build workflows using SQL on Javelin Incentive Manager.
Processed Incentives for client sales team worth 22.3 Million Dollars as a part of Quarterly Incentive Processing.
Leveraged optimization techniques to guide clients and ZS teams to the best decisions by synthesizing and communicating the solutions to the team.
Designed Power BI Dashboards to drive insights and take informed strategic decisions.
Performed quantitative data analysis on large, complicated data sets using SQL and Excel models, and delivered insights.

Business AnalysisPivot TablesMicrosoft ExcelData AnalysisSQLMicrosoft Power BI+1