Gaurav Panchal profile photo 1 on Tal

Gaurav Panchal

Business Analyst | Ex - Analyst Coordinator @BM2K Global Pvt Ltd | Python • SQL • Excel • Power BI • Data management

Delhi

4+ years of work experience

BM2K Global Enterprises Pvt. Ltd.
Jan 20241 yrDec 2024

BM2K Global Enterprises Pvt. Ltd.
May 20238 mosDec 2023

• Utilized SQL and automation tools to extract and process data from primary and secondary sources, improving data retrieval efficiency by 36%. • Developed and optimized databases, restructuring data for enhanced readability and accessibility, reducing query processing time. • Performed data integrity checks by identifying and rectifying coding errors and inconsistencies, ensuring high-quality datasets. • Conducted statistical analyses to detect trends, patterns, and anomalies, enabling data-driven business decisions. • Designed and deployed SSIS packages to automate data migration from various formats (.txt, .csv, .xlsx) into SQL Server and vice versa. • Developed Power BI dashboards that provided actionable insights, supporting business performance assessment and strategic planning. • Generated detailed reports for senior management, analyzing local, national, and global trends to predict industry impacts.
Indian Oil Corp Limited
Mar 20221 yr 1 moMar 2023

Delhi, India

• Implemented data management processes in SAP, ensuring compliance with regulatory frameworks and improving inventory accuracy. • Analyzed operational risks associated with inventory processes, reducing errors by 14%. • Generated detailed monthly reports using Advanced Excel functions, enhancing decision-making efficiency by 33%. Improved inventory accuracy by 14% through streamlined data management processes in SAP. • Generated detailed monthly reports using advanced Excel functions, enhancing decision-making efficiency by 33%. • Collaborated with cross-departmental teams to update product databases and ensure data integrity. • Supported the rollout of organizational initiatives to enhance customer satisfaction and operational efficiency. • Collaborate with cost estimators/quantity surveyors to enhance data completeness.
Mar 20202 yrs 1 moMar 2022

Uttar Pradesh, India

• Employed Advanced Excel functions (VLOOKUP, Pivot Tables) for in-depth data analysis and report creation, reducing manual work by 2 hours and increasing workflow efficiency • Proficient in creating precise technical drawings, layouts, and 3D models for architectural, engineering, and product design projects.

Education

Internshala Trainings

Data Science Certification Course, Data Science

Internshala Trainings

20241 yr2025

Join Gaurav and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Gaurav Panchal on Tal

Headline

Business Analyst | Ex - Analyst Coordinator @BM2K Global Pvt Ltd | Python • SQL • Excel • Power BI • Data management

About

I’m a Data analyst → Graduated with a BA degree → Having no career guidance what to do (wasted to much time to decide) → Different mindset at different stages → Promoted to Analyst Executive, the dove headfirst into data → Learned SQL, Power BI, Tableau, and dashboard design by solving real business problems → Most recently worked at BM2K Global Pvt Ltd as an analytics coordinator, building analytics products After a recent layoff, I’m exploring what’s next—ideally something that blends my love of product thinking, user behavior, and data storytelling in a more technical role. I’m especially passionate about business analytics, and I love helping others grow in their careers—especially those coming from non-traditional backgrounds like mine.

Location

Delhi

Work experience

Analyst Coordinator at BM2K Global Enterprises Pvt. Ltd., Jan 2024 - Dec 2024 · 1 yr

Analytic Executive at BM2K Global Enterprises Pvt. Ltd., May 2023 - Dec 2023 · 8 mos, • Utilized SQL and automation tools to extract and process data from primary and secondary sources, improving data retrieval efficiency by 36%. • Developed and optimized databases, restructuring data for enhanced readability and accessibility, reducing query processing time. • Performed data integrity checks by identifying and rectifying coding errors and inconsistencies, ensuring high-quality datasets. • Conducted statistical analyses to detect trends, patterns, and anomalies, enabling data-driven business decisions. • Designed and deployed SSIS packages to automate data migration from various formats (.txt, .csv, .xlsx) into SQL Server and vice versa. • Developed Power BI dashboards that provided actionable insights, supporting business performance assessment and strategic planning. • Generated detailed reports for senior management, analyzing local, national, and global trends to predict industry impacts.

Apprentice at Indian Oil Corp Limited, Mar 2022 - Mar 2023 · 1 yr 1 mo, Delhi, India, • Implemented data management processes in SAP, ensuring compliance with regulatory frameworks and improving inventory accuracy. • Analyzed operational risks associated with inventory processes, reducing errors by 14%. • Generated detailed monthly reports using Advanced Excel functions, enhancing decision-making efficiency by 33%. Improved inventory accuracy by 14% through streamlined data management processes in SAP. • Generated detailed monthly reports using advanced Excel functions, enhancing decision-making efficiency by 33%. • Collaborated with cross-departmental teams to update product databases and ensure data integrity. • Supported the rollout of organizational initiatives to enhance customer satisfaction and operational efficiency. • Collaborate with cost estimators/quantity surveyors to enhance data completeness.

Autocad Designer at K B Machine Tools, Mar 2020 - Mar 2022 · 2 yrs 1 mo, Uttar Pradesh, India, • Employed Advanced Excel functions (VLOOKUP, Pivot Tables) for in-depth data analysis and report creation, reducing manual work by 2 hours and increasing workflow efficiency • Proficient in creating precise technical drawings, layouts, and 3D models for architectural, engineering, and product design projects.

Education

Data Science Certification Course, Data Science, Internshala Trainings

Gaurav Panchal - Analyst Coordinator in Delhi | Tal