Prachi Deshpande
920-***-**** *****************@*****.*** https://www.linkedin.com/in/prachideshpande010/
Experienced analytics professional with 7 years of overall experience, including 5.5 years of relevant expertise in data visualization, reporting, dashboarding, and insight analysis. Proficient in SQL, Excel, Power BI, and Python, with strong analytical thinking, problem-solving skills, and a proactive, growth-oriented mindset.
TECHNICAL SKILLS
Power BI Desktop
Excel
Python
Data Modelling
Power BI Service
SQL
NumPy
Data Visualization
Power Query (M- Query)
MySQL
Pandas
Data Cleaning
DAX
WORK EXPERIENCE
SQL Server
Machine learning models
Data Storytelling
Data Analyst Barclays – [Infosys Limited, India] Apr 2016 – Apr 2017
Executed large-scale data validation on over 5 million records for a Pricing and Billing Engine (PBE) migration project under the Structural Reform Program (SRP), ensuring compliance with UK ring-fencing regulations.
Conducted row count reconciliation, duplicate detection, and source-to-target comparisons, achieving 99.9% accuracy in post-migration data.
Developed SQL scripts to analyze datasets of over 10 million rows, reducing defect turnaround time by 35%.
Created dashboards and reports to support compliance and audit readiness, enhancing data transparency for stakeholders.
Automated key data validation processes using Excel macros, improving data quality checks, and reducing manual effort by 40%.
Data Analyst UnitedHealth Group – [Syntel Limited, India] Oct 2011– Mar 2016
Supported data migration from UNISON Facets to CSP Facets, alongside transitioning from Sybase to Oracle databases, ensuring data accuracy across critical healthcare operations.
Conducted detailed data validation and transformation analysis for claims, eligibility, and provider data, achieving a 100% match rate during production deployment.
Analyzed DataStage ETL mappings and verified business rules aligned with EDI standards (834, 837, 270/271).
Built robust documentation for data flows, mapping rules, and compliance tracking for audit readiness and stakeholder reporting.
Facilitated cross-platform data consistency by performing parallel comparisons and resolving anomalies between legacy and modern systems.
Test Analyst Daimler Trucks North America- [Syntel Limited, India] July 2010 – Sep 2011
Performed ETL testing to validate data extraction, transformation, and loading of warranty and service data across multiple systems.
Designed and executed functional, regression, and system integration test cases for new enhancement requests (ERs).
Validated data mappings, prepared test scenarios, and ensured data accuracy across staging and target systems.
Collaborated with onsite counterparts and developers to resolve data issues and improve test coverage.
Maintained test logs, defect reports, and contributed to peer reviews and daily status reporting.
CERTIFICATIONS
Post Graduate program in Data Science and Business Analytics (University of Texas) 08/2024 – 04/2025
EDUCATION
Bachelor of Engineering in Electronics and Telecommunication 06/2006 – 07/2009