Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Pratiksha Jamdade

Data Analyst
Pune

Summary

Experienced Data Analyst with 2 years and 4 months of experience using SQL, Excel, and DAX for data processing and transformation. Designed and implemented Power BI dashboards to highlight key trends. Assisted with project onboarding and worked with a team of 8 members. Previously served as a Quality Analyst, focusing on defect resolution, documentation, and quality assurance within an Agile framework.

Overview

6
6
years of professional experience
4
4
years of post-secondary education
5
5
Certifications

Work History

Data Analyst

Capgemini
8 2021 - Current
  • Collaborated closely with engineering and business teams using Scrum/Agile methodologies, gathered requirements from stakeholders, created detailed user stories for sprints in Jira with 60% improvement in communication
  • Maintained comprehensive documentation in Confluence, improving project delivery efficiency by 25%
  • ETL (Extract, Transform, Load) Technology- data accuracy and enrichment for banking purposes
  • Collaborated with cross-functional Teams to define Key Performance Indicators (KPI) and develop performance tracking metrics, achieving 15 % increase in operational efficiency
  • Prepared Dashboards in Power BI to monitor and analyze Team customer-related activities, extracting data from Excel
  • Conducted Data Analysis using SQL queries and Excel leading to actionable insights and process improvements
  • New Team Member on-boarding process and providing Knowledge Transition sessions.
  • Improved decision-making processes with accurate data analysis and visualization techniques.
  • Worked with business intelligence software and various reports to glean insights into trends and prospects.

Quality Analyst

Atos- Syntel
08.2018 - 08.2021
  • Handled automation scripting using python robot framework internally
  • Responsible for test case design based on business requirements and manual execution
  • Automation scripting reduced 50% of manual effort
  • Implemented Agile methodology in Project which improved 20% end-to-end process and communication among offshore and on-site members
  • Conducted detailed requirement elicitation for test cases and scenarios, developed comprehensive test plans, and executed tests in sprints, resulting in 25% reduction in defect leakage and improved product quality
  • Have provided 30 % contribution in UAT Testing, executed UAT Test Cases
  • Regression Testing
  • Diagnosed and documented 200+ software defects monthly, implementing systematic tracking process that enhanced resolution efficiency by 40% and reduced recurring issues by 25%.

Education

Bachelor of Engineering -

Jawaharlal Nehru Engineering College
Aurangabad, Maharashtra
06.2014 - 05.2018

Skills

    SQL

    Data Visualization and Presentations

    Data Cleaning

    Power BI Service

    Power BI Desktop

    Advance Excel

    Data Modelling

    Python

    Agile

    Jira/ Bit Bucket/Confluence

    DAX

    Power Query (ETL)

    Data Warehousing

    SQL Server

    UAT Testing

Certification

Udemy- Data Analysis using Excel (2023)

Timeline

Quality Analyst

Atos- Syntel
08.2018 - 08.2021

Bachelor of Engineering -

Jawaharlal Nehru Engineering College
06.2014 - 05.2018

Data Analyst

Capgemini
8 2021 - Current
Pratiksha JamdadeData Analyst