Arpit Bhatnagar

Arpit Bhatnagar Email and Phone Number

Senior Specialist (Business Intelligence and Analytics) @ MSD
Gurugram, HR, IN
Arpit Bhatnagar's Location
Gurugram, Haryana, India, India
About Arpit Bhatnagar

Dedicated and detail-oriented Business Analyst with 3.5+ years of experience, skilled in delivering data-driven insights to enhance business operations. Proficient in SQL & Business Intelligence, with expertise in Sales, Production, Finance, Supply Chain, internal audit and risk management Analysis. Strong communicator experienced in consulting and delivering solutions to global clients.

Arpit Bhatnagar's Current Company Details
MSD

Msd

View
Senior Specialist (Business Intelligence and Analytics)
Gurugram, HR, IN
Website:
msd.com
Employees:
40390
Arpit Bhatnagar Work Experience Details
  • Msd
    Senior Specialist (Business Intelligence And Analytics)
    Msd
    Gurugram, Hr, In
  • Msd
    Senior Specialist (Business Intelligence & Analytics)
    Msd Oct 2024 - Present
    Manesar, Haryana, India
    Data Visualization & Analytics - SQL, ETL, Data Warehousing, Advance Excel & Automation.Project Management – Agile Methodologies, Scrum & Kanban.Requirement Gatherings – User Stories, Epics, BRD & FRD, Jira tool.ERP Tools – Process Integration – SAP (S4 HANA) SD MM, Ariba & Frappe.Business Intelligence & Insights - PowerBi Services, Power Query, Dax, TSQL, SSIS, SSRS, Aera- Integration.KPI management – Reporting, Implementation & Optimization.Vendor Management – Purchase Requests, Purchase orders, GRN , GIN, MRN, MIN, Audit & SLA’s.Evaluate 25+ KPI’s including OEE%, KAIZEN, OTD (LIFR & IOTF) for finding insights and which included defining new fleet management procedures to generate a 25% reduction in transportation cost.Crafted and automated over 20 interactive dashboards that led to a 30% increase in user engagement for strategic business units using advance DAX queries, RLS and SSIS in Power Bi services.Improvised ETL methodologies using SQL to import data into Power BI, resulting in a significant boost in data reliability.Cultivated data-driven culture by conducting workshops on Power BI usage, enhancing team capabilities.Collaborated with internal audit teams to identify risk areas, leading to enhanced control measures and a 20% reduction in audit discrepancies.Created a suite of financial dashboards that provided real-time financial metrics including budget management and forecasting enabling executives to make timely and informed business decisions.Led a team in implementing a new ERP (SAP) system that improved the order fulfillment process, increasing efficiency by 25%.Managed a cross-functional team of 15 sites globally with supply chain coordinators to execute automation reporting using AERA, which improved lead time by 18% and resulted in a $200K reduction in annual costs.Defined FRD’s for training and standardizing process for training of SAP-Aera reports.Cultivated a culture of continuous improvement that boosted on-time delivery rates.
  • Cloudextel
    Business Analyst
    Cloudextel Aug 2023 - Oct 2024
    Gurugram, Haryana, India
    Gained extensive knowledge in data mining , analysis and reporting.• Created data models to identify trends and patterns in the data.• Developed SQL queries to retrieve and manipulate data.• Responsible for data mining, data extraction, validation, and sanity checks.as per the client/project requirement.* Key responsibilities include understanding scope and requirements, developing scripts in SQL to read the data extracts and analyze the data. Develop scripts and modify them as per the client business requirements.Developed statistical models and forecasting techniques to anticipate future trends and behaviors• Built data visualizations and presentations to effectively communicate insights• Collaborated with internal and external stakeholders to ensure delivery of accurate and timely results
  • Hfcl Limited
    Data Analyst
    Hfcl Limited Jun 2022 - Aug 2023
    Gurugram, Haryana, India
    Working on large and complex data sets related to telecom industry, developing and improving metrics for business performance, and creating intuitive visualizations and dashboards using Power Bi & SQL.Track user behavior , performance/usage analytics on the web/mobile application with a range of metrics and share insights for business decisions . Collaborating across verticals, building analytics & visualisations for data-driven insights serving ~11 Mn customers • Engineering transformation pipelines within Data clusters for analysing ~50 Mn data points to build KPI’s • Orchestrating proactive workflows, resulting in over 600K customers able to self resolve their issue • Designing & managing interactive tools for care agents.Perform event based analysis to track the behavior of users as they engage and explore our product. Share inferences and conclusions to improve the user experience. Measure engagement, apply complex technologies to solve problems.As a PMO, Monthly target presentation to the State Construction Head (SCH) and NHQ.Maintaining and reporting an updated status of project on the weekly and monthly basis using ability, analytical skills using SQL and Power BI
  • Ercon
    Analyst
    Ercon Jan 2021 - Jun 2022
    Gurugram, Haryana, India
    My first organization as an Analyst has provided valuable opportunities to develop my technical skills and gain hands-on experience in the field of Data Engineering. During my time at the organization, I have been involved in various projects that have allowed me to work with large datasets and implement data-driven solutions.I have gained expertise in various tools and technologies, including SQL, Python & Power Bi. I am also proficient in data modeling and database design, and I have experience in ETL processes and data integration.My organization has provided me with a supportive environment where I have been able to learn from experienced professionals in the field. I have also had the opportunity to work on cross-functional teams, which has allowed me to develop my communication and collaboration skills.

Arpit Bhatnagar Education Details

Frequently Asked Questions about Arpit Bhatnagar

What company does Arpit Bhatnagar work for?

Arpit Bhatnagar works for Msd

What is Arpit Bhatnagar's role at the current company?

Arpit Bhatnagar's current role is Senior Specialist (Business Intelligence and Analytics).

What schools did Arpit Bhatnagar attend?

Arpit Bhatnagar attended Maharshi Dayanand University.

Who are Arpit Bhatnagar's colleagues?

Arpit Bhatnagar's colleagues are Krassimir K., Rahul Suthar, Shaik Moin Uddin, Agnieszka Kirszanowski, Surabhi Suman, Jingwen Zhang, Deivys Rodriguez.

Not the Arpit Bhatnagar you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.