Subhi Pandey profile photo 1 on Tal

Subhi Pandey

Data analyst || Power BI || SQL || Excel || python|| Data visualization|| Business intelligence|| Data & AI Engineer | | GenAI • ML • Data Engineering || Building AI-Driven Automation & Scalable Data Systems ||

Greater Delhi Area

1+ year of work experience

Cache Digitech Pvt Ltd.
Jul 20251 yrPresent

Delhi, India

Data & AI Specialist | Cache Digitech Pvt. Ltd. • Designed and maintained automated ETL pipelines to extract, transform, and load large-scale datasets from multiple sources, improving data availability by 35%. • Performed data cleaning, transformation, validation, and integration to ensure high-quality datasets for analytics, reporting, and business intelligence initiatives. • Developed interactive Power BI dashboards and KPI reports for sales, operations, and business performance monitoring, enabling data-driven decision-making for stakeholders. • Analyzed large datasets using SQL, Excel, and Python to identify trends, patterns, and business insights that supported operational improvements and strategic planning. • Automated reporting workflows and business processes using Generative AI solutions, reducing manual reporting efforts by 40% and improving team productivity. • Implemented data quality validation checks and monitoring frameworks, maintaining data accuracy, consistency, and integrity above 99%. • Collaborated with cross-functional teams to gather business requirements, define KPIs, and deliver scalable analytics solutions aligned with organizational objectives. • Utilized Machine Learning techniques for predictive analysis, forecasting, and business insights generation to support proactive decision-making. • Created and maintained technical documentation, data dictionaries, ETL workflows, and reporting specifications to support governance and knowledge sharing. 🔹 Technologies & Tools: SQL | Power BI | Microsoft Excel | Python | ETL | Data Analytics | Dashboard Development | Business Intelligence | Data Modeling | KPI Reporting | Machine Learning | Generative AI | Workflow Automation
JNS INSTRUMENTS LIMITED
Aug 20244 mosNov 2024

Manesar, Haryana, India

• Managed and analyzed production and quality-related data for PCB manufacturing operations. • Developed and maintained structured databases for component and inspection data, improving data accessibility and reporting efficiency. • Collected, cleaned, validated, and transformed data from production logs, quality reports, and machine records. • Designed and maintained a centralized defect tracking system to monitor quality issues and inspection outcomes. • Conducted defect trend analysis, frequency analysis, and root cause analysis to identify recurring quality issues. • Created daily, weekly, and monthly KPI reports tracking defect rates, yield rates, rejection rates, and production quality metrics. • Utilized Excel, SQL, Pivot Tables, and reporting tools to transform raw manufacturing data into actionable business insights. • Improved defect identification accuracy by 15% through structured data management and analytical reporting. • Collaborated with production, quality assurance, and engineering teams to support process improvement initiatives.
YBI Foundation
Jul 20232 mosAug 2023

Gurugram, Haryana, India

YBI Foundation
Jul 20232 mosAug 2023

Delivered full EDA with Pandas, NumPy, Matplotlib, and Seaborn; completed capstone covering feature engineering and insight storytelling.

Education

DPG Institute of Technology and Management

Bachelor of Technology - BTech, Computer Science

DPG Institute of Technology and Management

20214 yrs2025

10th/12th(Head girl)

Sri Pal Singh Vidhya Mandir Maigalganj UP

20183 yrs2021

Join Subhi and 10k+ other professionals on

Tal Boss

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

Download Tal Boss

Subhi Pandey on Tal

Headline

Data analyst || Power BI || SQL || Excel || python|| Data visualization|| Business intelligence|| Data & AI Engineer | | GenAI • ML • Data Engineering || Building AI-Driven Automation & Scalable Data Systems ||

About

🚀 Data Analyst with hands-on experience in SQL, Power BI, Excel, Python, ETL, and Data Visualization, passionate about transforming raw data into actionable business insights. Currently working in the Data & AI domain, where I build ETL pipelines, develop interactive dashboards, automate reporting workflows, and analyze large datasets to support business decision-making. Experienced in KPI reporting, data cleaning, data modeling, and business intelligence solutions that improve operational efficiency and drive measurable outcomes. Skilled in leveraging SQL for data analysis, Power BI for dashboard development, Excel for reporting and analytics, and Python for automation and data processing. Strong understanding of data analytics, performance monitoring, trend analysis, and stakeholder reporting. In addition to analytics, I have experience working with Machine Learning and Generative AI solutions, enabling me to combine traditional data analysis with modern AI-driven technologies to solve real-world business challenges. 🔹 Core Skills: SQL | Power BI | Excel | Python | Data Analysis | Dashboard Development | Data Visualization | Business Intelligence | ETL | Data Modeling | KPI Reporting | Generative AI 💡 Open to opportunities in Data Analytics, Business Intelligence, Reporting Analytics, and Data-driven AI Solutions. Let's connect and turn data into meaningful business decisions.

Location

Greater Delhi Area

Work experience

Data Specialist at Cache Digitech Pvt Ltd., Jul 2025 - Present · 1 yr, Delhi, India, Data & AI Specialist | Cache Digitech Pvt. Ltd. • Designed and maintained automated ETL pipelines to extract, transform, and load large-scale datasets from multiple sources, improving data availability by 35%. • Performed data cleaning, transformation, validation, and integration to ensure high-quality datasets for analytics, reporting, and business intelligence initiatives. • Developed interactive Power BI dashboards and KPI reports for sales, operations, and business performance monitoring, enabling data-driven decision-making for stakeholders. • Analyzed large datasets using SQL, Excel, and Python to identify trends, patterns, and business insights that supported operational improvements and strategic planning. • Automated reporting workflows and business processes using Generative AI solutions, reducing manual reporting efforts by 40% and improving team productivity. • Implemented data quality validation checks and monitoring frameworks, maintaining data accuracy, consistency, and integrity above 99%. • Collaborated with cross-functional teams to gather business requirements, define KPIs, and deliver scalable analytics solutions aligned with organizational objectives. • Utilized Machine Learning techniques for predictive analysis, forecasting, and business insights generation to support proactive decision-making. • Created and maintained technical documentation, data dictionaries, ETL workflows, and reporting specifications to support governance and knowledge sharing. 🔹 Technologies & Tools: SQL | Power BI | Microsoft Excel | Python | ETL | Data Analytics | Dashboard Development | Business Intelligence | Data Modeling | KPI Reporting | Machine Learning | Generative AI | Workflow Automation

Data Specialist at JNS INSTRUMENTS LIMITED, Aug 2024 - Nov 2024 · 4 mos, Manesar, Haryana, India, • Managed and analyzed production and quality-related data for PCB manufacturing operations. • Developed and maintained structured databases for component and inspection data, improving data accessibility and reporting efficiency. • Collected, cleaned, validated, and transformed data from production logs, quality reports, and machine records. • Designed and maintained a centralized defect tracking system to monitor quality issues and inspection outcomes. • Conducted defect trend analysis, frequency analysis, and root cause analysis to identify recurring quality issues. • Created daily, weekly, and monthly KPI reports tracking defect rates, yield rates, rejection rates, and production quality metrics. • Utilized Excel, SQL, Pivot Tables, and reporting tools to transform raw manufacturing data into actionable business insights. • Improved defect identification accuracy by 15% through structured data management and analytical reporting. • Collaborated with production, quality assurance, and engineering teams to support process improvement initiatives.

Data Visualization And Data Transfor at YBI Foundation, Jul 2023 - Aug 2023 · 2 mos, Gurugram, Haryana, India

Data Specialist at YBI Foundation, Jul 2023 - Aug 2023 · 2 mos, Delivered full EDA with Pandas, NumPy, Matplotlib, and Seaborn; completed capstone covering feature engineering and insight storytelling.

Education

Bachelor of Technology - BTech, Computer Science, DPG Institute of Technology and Management

10th/12th(Head girl), Sri Pal Singh Vidhya Mandir Maigalganj UP