Sparsh Bansal
Moradabad
Summary
Detail-oriented professional with expertise in SQL, Python, PySpark, and Power BI. Proven ability to build efficient data models, optimize queries, and create impactful dashboards. Extensive experience in interpreting complex data sets and utilizing statistical software for data mining and predictive modeling. Recognized for enhancing operational efficiency through trend identification and improved data reporting processes.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Application Engineer
Microchip Technology
07.2023 - Current
- Conducted exploratory data analysis on datasets exceeding 10 million records, identifying trends that boosted operational efficiency by 30%.
- Developed and maintained interactive dashboards in Power BI, enabling real-time tracking of KPIs for stakeholders.
- Wrote complex SQL queries to extract, transform, and analyze data across multiple databases, reducing report generation time by 70%.
- Built automated ETL pipelines with Python and PySpark, saving over 15 hours of manual processing weekly.
- Collaborated with cross-functional teams to forecast demand using regression models, resulting in a 30% reduction in procurement costs.
Intern
Microchip Technology
01.2023 - 06.2023
- Facilitated data collection, cleaning, and visualization for customer behavior analysis, yielding actionable recommendations.
- Generated SQL queries to produce ad-hoc reports, reducing data request response time by 40%.
- Delivered weekly updates to senior analysts and management regarding project status and insights.
- Enhanced data accuracy by 20% through effective cleaning and preprocessing using Python (Pandas and NumPy).
Education
M.Tech -
NIT Kurukshetra
05-2023
B.Tech -
GALGOTIA COLLEGE OF ENGINEERING
GREATER NOIDA07.2017
Skills
- Python and SQL
- Data visualization tools
- Data manipulation and cleaning
- Statistical analysis techniques
- Predictive modeling and regression
- Jupyter Notebook and VS Code
- Version control with GitHub
- ETL processes and data reporting
Certification
- Coding Ninjas (Complete Data Analyst program)
- HackerRank (SQL)
Projects
PhonePe digital payments EDA, GitHub, Python (Pandas, NumPy, Matplotlib)
E-commerce data analysis, GitHub, SQL (DML, DQL, DDL, window functions, joins)
Retail analytics case study, GitHub, advanced SQL
AtliQ Hardware Analysis Report, GitHub, Advanced SQL
Timeline
Application Engineer
Microchip Technology
07.2023 - Current
Intern
Microchip Technology
01.2023 - 06.2023
M.Tech -
NIT Kurukshetra
B.Tech -
GALGOTIA COLLEGE OF ENGINEERING
Similar Profiles
Patrick J. HazlettPatrick J. Hazlett
Senior Manager, Governance, Risk, Compliance & Insider Threat at Microchip TechnologySenior Manager, Governance, Risk, Compliance & Insider Threat at Microchip Technology
RANDY WURANDY WU
Principal Field Applications Engineer at Microchip TechnologyPrincipal Field Applications Engineer at Microchip Technology
Richard HarrisRichard Harris
Process Enhancement Specialist at Microchip technologyProcess Enhancement Specialist at Microchip technology
MAHAK FATIMAMAHAK FATIMA
Travel Consultant at Manager AssistantTravel Consultant at Manager Assistant
Dr. Siddhartha BhatnagarDr. Siddhartha Bhatnagar
SR. SPECIALIST,HIS IMPLEMENTATION,DIGITAL HEALTH at INDIA HEALTH ACTION TRUST,UPTSUSR. SPECIALIST,HIS IMPLEMENTATION,DIGITAL HEALTH at INDIA HEALTH ACTION TRUST,UPTSU