Manoj Kumar
Data Analyst
Noida,UP
Summary
Result driven Data Analyst delivering scalable analytics solutions using Python, SQL, Snowflake, Power BI, and Tableau. Proven expertise in data extraction, transformation, data modeling, dashboard development, and performance optimization. Strong background in building automated reporting dashboards, optimizing complex SQL queries, and translating business requirements into actionable insights. Hands-on experience working with cloud data platforms, enterprise systems, and cross-functional stakeholders in product-driven environments.
Overview
7
7
years of professional experience
1
1
Certificate
Work History
Data Analyst
Ericsson India Pvt. Ltd.
09.2021 - Current
- Utilized Python (Pandas, NumPy) to clean, transform, and analyze structured datasets, enabling automated reporting workflows.
- Automated, repetitive data preparation and validation tasks using Python scripts, reducing manual effort by 50%.
- Developed and optimized complex SQL queries across Snowflake, SAP HANA, and Snowflake to extract, transform, and analyze large-scale datasets for business reporting and analytics.
- Built high-performance datasets using CTEs, window functions, indexing, and query optimization techniques, reducing query execution time by up to 40%.
- Designed and delivered interactive dashboards in Power BI and Tableau, enabling real-time KPI monitoring and executive reporting.
- Built advanced DAX measures, calculated fields, drill-down reports, and time-intelligence metrics.
- Partnered with business stakeholders to gather requirements, define KPIs, and translate business needs into scalable analytics solutions.
- Delivered ad-hoc analysis, root cause investigations, and trend analysis to support data-driven decision-making.
Software Developer
72 Networks Pvt. Ltd.
01.2019 - 08.2021
- Developed a custom web-based stock management system to manage inbound, outbound inventory, stock availability, and order status tracking.
- Designed and implemented backend services and business logic for inventory movement, order lifecycle, and reconciliation.
- Built a relational database schema and optimized SQL queries, indexes, and stored procedures for high-volume transactions.
- Automated stock updates and validations eliminate manual errors and improve inventory accuracy by over 30%.
- Developed dashboards and reports to track inventory health, aging orders, and fulfillment KPIs.
- Improved application performance and reliability through query optimization and transaction management.
- Contributed to a positive team environment through effective communication, problem-solving, and collaboration skills.
- Collaborated with operations and business teams to align system functionality with real-world workflows.
Education
Bachelor of Technology - Computer Science
Krishna Institute of Engineering And Technology
Ghaziabad, India 04.2001 -
Skills
SQL (Advanced Queries, Joins, CTEs, Window Functions, Performance Tuning)
Python (Pandas, NumPy, Data Processing, Automation)
Power BI (DAX, Data Modeling, Power Query, Dashboard Optimization)
Tableau (Calculated Fields, Performance Tuning, Extracts)
ETL Processes
KPI Design & Metrics Engineering
Data Cleaning & Transformation
Git
JIRA
Data modeling
Data formatting
Analytical problem solving
Certification
Gen AI Application Development
Timeline
Gen AI Application Development
10-2025
Data Analyst
Ericsson India Pvt. Ltd.
09.2021 - Current
Software Developer
72 Networks Pvt. Ltd.
01.2019 - 08.2021
Bachelor of Technology - Computer Science
Krishna Institute of Engineering And Technology
04.2001 -