Arpit Bhatnagar Email & Phone Number

Gurugram, Hr, In

Gurugram, Hr, In

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.

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

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

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.