May 2022 – Feb 2023 · 9 mos · Gurugram, Haryana, India · Hybrid

• Worked as a Power BI Developer, delivering analytics and data visualization solutions for global pharmaceutical clients, with a strong focus on pricing intelligence, inflation analysis, and executive‑level reporting.
• Delivered a comprehensive Pricing Inflation Tracker Dashboard for a global pharmaceutical organization, enabling leadership teams to analyze pricing trends, inflation impact, and budget variance across multiple markets, regions, and product hierarchies, supporting data‑driven commercial and strategic decisions.
• Key Responsibilities & Impact:
• Designed and delivered end‑to‑end Power BI dashboards, replacing manual Excel‑based pricing analysis and reducing monthly reporting effort by ~40%, while improving reporting accuracy and consistency.
• Built customized visuals for Pricing Index (Category, Corporation, Brand, Market Tier) and Inflation vs Budget analysis, enabling faster identification of pricing deviations and improving insight visibility by ~30–35%.
• Designed optimized data models, created relationships between fact and dimension tables, and implemented calculated columns and complex DAX measures, improving report performance by ~30% and KPI accuracy by ~25%.
• Wrote and optimized SQL queries and workflows, supporting data preparation from Snowflake and relational sources, reducing data preparation and refresh cycles by ~35%.
• Enabled self‑service analytics through intuitive dashboard design and standardized KPIs, reducing ad‑hoc reporting requests by ~30%.
• Worked closely with business stakeholders to gather requirements and deliver executive‑ready analytical solutions.
• Prepared functional documentation, KPI definitions, and user guides to support adoption and maintainability.
• Provided Power BI training and mentoring to freshers and junior analysts on Power BI fundamentals, data modeling, DAX basics, and dashboard best practices, helping onboard new team members 25–30% faster.
• Tools & Technologies: Power BI, SQL Server, Snowflake, Excel

Apr 2021 – Apr 2022 · 1 yr · New Delhi, Delhi, India · On-site

• Worked as a Deputy Manager – IT (Power BI Developer Lead) at a leading FMCG organization, delivering internal enterprise BI solutions.
• Collaborated closely with stakeholders across IT, Infrastructure, Applications, Sales & Marketing, Finance, HR, and Operations teams to understand analytics needs and deliver decision‑driven Power BI dashboards.
• Acted as the single point of contact for BI initiatives, owning the end‑to‑end lifecycle from requirement gathering, BRD creation and sign‑off, solution design, development, testing, deployment, and post‑go‑live support. Designed interactive dashboards and data stories using advanced DAX, aligned to department KPIs.
• Worked extensively on Power BI Premium, managed enterprise distribution via Power BI Apps, implemented Row‑Level Security (RLS), configured scheduled and incremental refresh, resolved user queries, and created user guides and documentation to drive adoption and self‑service analytics.
• Key Dashboards & Impact:
• eSaarthi Sales Performance Dashboard (Sales & Marketing):
• Enabled visibility into monthly outlet activity, SKU count, and performance by Region, State, and City, helping teams identify under‑performing territories and product penetration gaps. Achieved ~60–70% active adoption and reduced ad‑hoc sales queries by ~40%.
• IT Data Governance Dashboard:
• Delivered a consolidated view of vendor‑wise budget vs expense utilization, IT spend, ticket volumes, and SLA % resolution, supporting better vendor governance, cost control, and SLA prioritization. Achieved ~75–80% adoption and reduced manual reporting effort by ~35%.
• Finance Paginated Reports (Finance Team):
• Developed Power BI Paginated Reports for structured financial reporting used in monthly close and audits, achieving ~85% adoption, reducing manual effort by ~30%, and improving review turnaround time.
• Tools & Technologies:
• Power BI Desktop & Service, Power BI Report Builder, Power BI Premium, DAX, SQL Server, Impala, Hadoop, Advance Excel

Dec 2019 – Mar 2021 · 1 yr 3 mos · Faridabad, Haryana, India · On-site

• Worked as an Assistant Manager – Data Analyst in the Sales & Marketing Department, reporting directly to the Head of Sales and the CEO. Played a key role in supporting leadership through sales analytics, market intelligence, competitive analysis, and BI reporting, enabling informed business and strategic decisions.
• Key Responsibilities & Contributions:
• Collaborated directly with the CEO and Head of Sales on incubation and growth initiatives, helping design Market Intelligence roadmaps to support strategic planning and market expansion.
• Prepared and delivered sales performance and MIS reports for Construction Equipment products including Backhoe Loaders, Cranes, and Road Rollers, improving visibility into regional trends, dealer performance, and demand patterns.
• Transitioned into the Tractor Division, supporting sales leadership for Powertrac and Farmtrac tractors through structured sales reports and analytical insights for planning and reviews.
• Designed, developed, and deployed reports and dashboards using Power BI Service, improving automation and reducing reliance on manual Excel‑based reporting by ~30–35%.
• Performed ETL (Extract, Transform, Load) from multiple data sources and tools, improving data consistency and reducing reconciliation issues by ~25%.
• Designed and implemented a BI framework, developing intuitive dashboards and scorecards with real‑time and daily KPIs to track sales performance, market trends, and competitive positioning.
• Conducted in‑depth competitive and market intelligence analysis using Off‑Highway Research, ICEMA, and other industry reports, supporting pricing, positioning, and product strategy discussions.
• Provided data‑driven insights for key initiatives, enabling leadership to identify trends ~25–30% faster than earlier manual reporting processes.
• Demonstrated strong capability in analyzing high‑volume, high‑dimensional datasets from diverse sources and worked closely with Sales & Marketing teams to reduce repeated ad‑hoc data requests.

Jan 2019 – Nov 2019 · 10 mos · Gurgaon, Haryana, India

• Worked as an Associate Data Analyst, supporting Sales, Market Quality, and Warranty Analysis teams through structured reporting and analytical dashboards. Reported directly to the Department Head and collaborated closely with regional and field teams.
• Key Responsibilities & Contributions:
• Preparation of Sales & Warranty Dashboards with Plant‑wise, Zone‑wise, KM‑wise, and Model‑wise quantity analysis, incorporating PPM (Parts Per Million) metrics to support market quality and warranty monitoring.
• Prepared and published Daily, Weekly, and Monthly Dispatch & Quantity reports for the Market Quality department, ensuring timely and consistent delivery of operational insights.
• Provided timely and accurate Sales KPI reports to field and regional teams, responding to queries by sharing supporting data and detailed analysis.
• Extracted and analyzed data from Oracle databases and supporting flat files to build datasets for reports and dashboards.
• Worked closely with the Warranty Analysis team to create reports highlighting bike parts failure trends and recurring quality issues.
• Designed analytical visuals such as CAGR (Compound Annual Growth Rate) charts and Pareto graphs to support trend analysis and prioritization of critical failure drivers.
• Supported sales, quality, and leadership teams with data‑backed insights for discussions on sales performance, warranty behavior, and product quality.
• Maintained strong standards of data accuracy, consistency, and reliability across reports used for operational and management reviews.
• Data Sources & Tools:
• Oracle, Power BI (Reporting), Excel

Jun 2017 – Dec 2018 · 1 yr 6 mos · Gurgaon, India

• Worked as a Commercial Executive in the AMC (Service Agreement) and Insurance business, supporting sales operations, portfolio analytics, incentive programs, and management decision‑making through structured reports and dashboards.
• Reported to Product Managers and collaborated closely with Sales, Finance, and Regional/Zonal teams.
• Key Responsibilities & Contributions:
• Prepared Portfolio Dashboards for Region‑wise, Segment‑wise, and Model‑wise sales for AMC (Service Agreements) and Insurance, covering MTD, YTD, Penetration %, and shared insights with Top Management for decision‑making.
• Created and published Target and Forecast reports for SASM (Sales Team) and Dealerships, supporting planning and performance tracking.
• Developed Target vs Actual and % Achievement reports, including participation metrics, enabling sales leadership to monitor progress against defined goals.
• Identified Qualifiers and Winners for various field incentive programs based on defined criteria for Sales Teams (SASM) and Dealerships on monthly and quarterly cycles.
• Designed and maintained incentive calculation and performance reports to ensure accuracy and transparency across sales programs.
• Created and published Daily Eicher Secure (Insurance) policy reports for All‑India stakeholders, providing visibility into insurance performance.
• Prepared daily, weekly, ad‑hoc, monthly, and quarterly reports for HD and LMD Trucks and Buses, supporting sales performance reviews.
• Coordinated with the Finance team to ensure timely disbursement of incentives to SASM and dealership networks.
• Handled code creation in SAP and supported Accounts Receivable (AR) management in coordination with regional offices.
• Provided reports and resolved data queries from Regional and Zonal Offices, ensuring timely and accurate information for field operations.
• Maintained strong focus on data accuracy, consistency, and reporting discipline across all commercial and sales reports.
• Tools & Technologies:
• Power BI, Excel, SAP

Nov 2014 – Jun 2017 · 2 yrs 7 mos · Gurugram, Haryana, India

• Worked as a Senior Analyst supporting global clients in the Australia and New Zealand (AU & NZ) Superannuation domain, which is a retirement savings and pension system for employees in Australia and New Zealand.
• The role involved a combination of backend operational activities, detailed data analysis, and MIS reporting, delivered within strict SLA and TAT timelines.
• Key Responsibilities & Contributions:
• Performed backend operational activities supporting end‑to‑end AU & NZ superannuation processes, ensuring smooth, accurate, and timely execution of retirement operations.
• Conducted detailed data analysis and reporting to ensure clients received the correct and optimal retirement benefits as per superannuation guidelines.
• Delivered ad‑hoc analysis and client reports within defined timelines, consistently maintaining 100% quality standards and meeting SLA requirements.
• Worked extensively with Superannuation data across multiple operational functions, including:
• Contribution Loading
• Reconciliation
• Cashflow Accounting
• MST (Member Statement) Loading
• Prepared and maintained MIS (Management Information System) reports to track processing status, operational volumes, and SLA performance for internal teams and management.
• Collaborated with cross‑functional teams to ensure data accuracy, consistency, and completeness across all reporting and backend processing activities.
• Proactively identified and resolved data discrepancies and process issues, supporting smoother downstream operations and reducing rework.
• Ensured strong audit readiness and regulatory compliance through accurate documentation and validation of client deliverables.
• Played a key role in maintaining client trust and operational stability through reliable data handling and on‑time delivery.
• Tools & Technologies:
• Citrix, MS Excel, MS Power Point, MS Word, MS Access.

Jun 2013 – Oct 2014 · 1 yr 4 mos · Gurugram, Haryana, India · On-site

• Worked as a Process Associate as part of the CMS (Compliance Management System) project for US‑based banking clients, operating in an LPO (Legal Process Outsourcing) environment. Supported compliance and backend operational activities for major US banks including JP Morgan, Wells Fargo, and Bank of America.
• Key Responsibilities & Contributions:
• Worked in the CMS backend operations team, supporting compliance processes related to foreclosure eligibility checks for US banking clients.
• Performed checks to verify military status (active duty or within the last 12 months) as per US regulations, where properties linked to eligible military personnel cannot undergo foreclosure.
• Ensured strict adherence to compliance rules and regulatory guidelines, supporting accurate and compliant decision‑making for US banks.
• Prepared and shared Daily, Weekly, and Monthly MIS reports summarizing team productivity, case status, and compliance metrics.
• Compiled and delivered daily team status reports to leadership, enabling visibility into workload, processing volumes, and SLA adherence.
• Handled backend processing activities, including data validation, case tracking, and documentation review within CMS workflows.
• Maintained high standards of data accuracy, attention to detail, and operational discipline, contributing to compliance reliability and client trust.
• Collaborated closely with team members and supervisors to ensure timely completion of tasks within defined SLAs.
• Tools & Technologies:
• Citrix, Excel, MS Office