Apurva Khandelwal
Product Management
Delhi, India
Skills
Data Analysis
SQL
Database Management
Data Engineering
Agile
Business Process Management (BPM)
Data Visualization
Documentation Development
Kanban
Looker Studio
mySQL
Pandas
PostgreSQL
Power BI (Microsoft)
Powerpoint
Tableau
Applied Statistics
About
Apurva has excelled in database management, significantly enhancing query efficiency by 20-30% for the Actioned Revenue 2.0 Dashboard. With six years of work experience, she utilizes Google SQL, Data Studio, and PLX Dashboard to design comprehensive reporting and data visualization solutions, ensuring dashboards are up-to-date and user-friendly. Apurva collaborates cross-functionally to provide informed business recommendations, manages product development projects, and conducts bi-weekly quality checks for data accuracy. With prior experience as a Data Analyst cum Manager and Data Analyst, she has led high-performing teams, optimized workflow processes, and facilitated efficient data analysis and reporting.
View more
Acomplishments
Project Management: Managed the development and updates of products, overseeing progress tracking, logic adjustments, and forecasting project completion timelines for Q1.
Project Management: Managed and coordinated projects such as SAP implementation and data migration, demonstrating strong leadership and project management skills.
Data Handling and Analysis: Devised and implemented procedures for data handling and analysis, ensuring accuracy and efficiency. Regularly presented reports to stakeholders.
ERP Maintenance: Maintained internal ERP system spreadsheets and troubleshooted errors as needed.
Work Experience
Data Analyst
Google Operations Center
February 2022 - Present
- Design and development of Dashboard and data pipeline using Looker studio and SQL ensuring the proper storing of both raw and processed data.
- Creation of materialized/ Temp tables, unit testing, and integration testing framework for data accuracy and automation using SQL.
- Creation of temp table functions, macros, and constants in SQL module files.
- Automated workflows and pipeline creation using the build, and maintain codebase in different environments used for testing and production.
- Deployment of code to Google code repository using in-built tools and analysing them using different analytic functions.
- Resolution of bugs/anomalies in the pipeline within defined TAT/SLAs.
- RCA of Dashboard Data.
Data Analyst cum Manager
Pearl Alloys Private Limited
August 2019 - February 2022
- Implement manual resource management techniques as decided by higher management.
- Provide assistance to the management in extracting the relevant business insight.
- Devise and implement procedures for data handling and analysis with attention to all technical aspects.
- Assist with (and create) reports and data extraction when needed. Regularly present them to stakeholders.
- Monitor and analyze information and data systems to make them efficient. Facilitating knowledge transfer sessions to assist team members.
- Maintenance of the spreadsheets being used as an internal ERP system using RBAC. Also, troubleshoot when there are errors.
- Bridging the gap between IT and the business using data analytics.
- Defining business requirements and reporting them back to stakeholders. Actively contributing to team meetings, offering insights and feedback.
- Review current processes to identify improvement opportunities and work with key stakeholders to validate improvements, mitigate risk associated and show benefits.
- Manage and coordinate Projects like SAP for implementing the SAP S4 HANA and migration of all data on SAP Server. Talking, negotiating and evaluating all vendors for Servers and SAP implementation partners.
Data Analyst
RCM Aeroservices Ltd
January 2017 - December 2017
- Performing data manipulation and filtration by Excel and SQL. Using Database SQL to maintain the data.
- Predicting the required aircraft's components for the coming period by using Statistical concepts, so that they can manage their stock accordingly.
- Preparing reports for aviation data. Prediction of Flight interruptions based on historical data using trend analysis using Excel by Markov steady state. Report Quality checking by looking for errors and rectifying them and finalizing it for the client. Projects
Education
