Prachi Tyagi
Ghaziabad
Summary
Results-driven data analyst with extensive experience at EXL Service, utilizing SQL and Tableau to provide actionable insights that improved billing accuracy and operational efficiency. Skilled in data cleaning and ETL processes, fostering collaboration to enhance data-driven decision-making. Proven ability to optimize performance across diverse datasets, contributing to organizational success.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Data Analyst
EXL Service
06.2025 - Current
- Analyzed large-scale electricity billing and energy consumption datasets to evaluate usage patterns and revenue trends.
- Performed data cleaning, validation, and transformation to ensure accuracy and consistency across billing cycles.
- Used SQL and Excel to extract, aggregate, and analyze meter readings and transactional billing data.
- Identified anomalies in electricity consumption, irregular billing patterns, and peak usage trends.
- Developed interactive dashboards and reports to monitor KPIs such as energy usage, billing variance, revenue realization, and payment compliance.
- Conducted exploratory data analysis (EDA) to uncover consumption behavior across different customer segments.
- Delivered actionable insights that improved billing accuracy, reduced discrepancies, and enhanced operational efficiency.
- Collaborated with cross-functional teams to support data-driven decision-making and reporting requirements.
Software Developer
Spexoid Tech Pvt Ltd
05.2024 - 11.2024
- Analyzed sales and customer datasets to evaluate sales performance, revenue trends, and customer behavior patterns.
- Performed data cleaning, transformation, and exploratory data analysis (EDA) to ensure data accuracy and consistency.
- Used SQL and Excel to extract, aggregate, and analyze transactional data, identifying high-performing products, regional sales trends, and customer segmentation patterns.
- Developed interactive dashboards and reports to track KPIs such as revenue growth, conversion rates, and customer retention.
- Delivered actionable insights that supported business strategy, demand planning, and sales optimization.
Software Developer
Qboid IoTech Pvt Ltd
01.2024 - 05.2024
- Extensive experience in database management and data analysis with a strong focus on SQL Server and relational database design.
- Worked on a real-time supply chain management system for Oright, analyzing live operational data integrated into SQL Server via WebSockets.
- Performed data validation, transformation, and querying to support real-time reporting and operational insights.
Apprentice
Ducat
Noida
07.2023 - 12.2023
- Gained expertise in .NET and WPF through an apprenticeship at Ducat.
- Designed, developed, and maintained desktop applications using MVVM architecture.
- Implemented data binding and custom control development to enhance user experience.
- Optimized application performance through responsive UI designs and backend integration.
- Integrated services via Entity Framework and REST APIs to improve functionality.
Education
Bachelor of Technology -
Shobhit University
Saharanpur, India01.2023
Intermediate -
Lord Krishna Public School
Saharanpur, India01.2019
HighSchool -
Lord Krishna Public School
Saharanpur, India01.2017
Skills
- HTML and CSS
- Bootstrap framework
- SQL Server and Oracle
- Reactjs and Nextjs
- JavaScript and Redux
- WordPress development
- GitHub version control
- JIRA project management
- Data cleaning and ETL
- Tableau data visualization
- Power Pivot analysis
- Python programming
- NumPy library
Personal Information
Date of birth: 08/11/01
Certification
- Web Development, Daily E-Learning
- React JS Developer, Ducat Noida, 6 months
Languages
- Hindi
- English
Timeline
Data Analyst
EXL Service
06.2025 - Current
Software Developer
Spexoid Tech Pvt Ltd
05.2024 - 11.2024
Software Developer
Qboid IoTech Pvt Ltd
01.2024 - 05.2024
Apprentice
Ducat
07.2023 - 12.2023
Bachelor of Technology -
Shobhit University
Intermediate -
Lord Krishna Public School
HighSchool -
Lord Krishna Public School