Data Analysis Life Cycle

Swarnim Shrivastava

+1-945-***-**** *******************@*****.*** LinkedIn/swarnim-shrivastava-293466117 Austin, TX No Sponsorship Required I U.S. L2 Visa I EAD Approved PROFESSIONAL SUMMARY

* ***rs of experience in ETL\Datawarehouse testing, data analysis, data reconciliation, data integration, optimizing data processes, UI Testing and ensuring high-quality data across complex systems.

Strong knowledge of different phases of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC), Defect life cycle with concentration on testing of various applications.

Responsible for design/Review of testing documents such as test plan, test scenarios, test cases, test estimation and project status report.

Proven ability to manage end-to-end testing and deliver high-quality results within project timelines.

Strong track record of improving efficiency and data accuracy through automation and optimized testing processes.

TECHNICAL SKILLS

o ETL (Extract, Transform, Load) Testing: Data Validation, data transformation, data migration, data analysis, data optimization, test automation, data quality checks. o ETL Tools: Informatica, Policy Migration Tool.

o Databases: SQL Server, Oracle, MySQL, SAP HANA, PostgreSQL, Teradata o Big Data Technologies: Apache Hive, Hadoop, HDFS, Apache Sqoop. o Programming & Scripting: SQL, Python, PL/SQL, Shell Scripting o Defect Tracking Tools: JIRA, Target deployment port (TDP) o Data Warehousing: Star Schema, Snowflake Schema, Dimensional Modeling o Operating Systems: Unix/Linux

o Visualization Tool: Tableau

WORK EXPERIENCE

Sr. Software Engineer — Zensar Technologies — Pune, India Feb 2021 - Dec 2024

Insurance Domain: Led the migration of policies from legacy system using Microsoft SQL Server, PostgreSQL and SQL Developer database applications and Policy Centre Migration tool for ETL operations to a new system called Policy Centre Management System for a U.S. Insurance Company, ensuring seamless data integration, data analysis, data reconciliation and synchronization.

Automated key testing processes and regression tests including count and table structure reconciliation with data validation, using PL/SQL and Python scripts.

Diagnosed and troubleshooted operational defects by developing optimized and complex SQL queries for functional, integration, regression and UI testing. Utilized JIRA Agile to track progress, resolve defects, and ensure smooth collaboration between teams

Collaborated with U.S.-based business analysts, architects, developers, and QA teams to troubleshoot issues during migration and testing phases, while also working as a Test Data Architect to create detailed mapping documents that bridge business requirements with testing efforts.

Key Achievements:

o Achieved seamless migration of 10,000+ policies from a legacy system to a new platform, ensuring 98% data consistency and minimal disruption during the transition. o Reduced testing time to 40% with a 50% increase in data validation accuracy by Developing and automating key testing processes streamlining execution workflows and improving overall efficiency. o Reduced downtime by 30% and enhanced system reliability by Conducting root cause analysis of production issues

Sr. Software Engineer — Amdocs Limited — Pune, India Oct 2016 - Feb 2021

Telecommunication Domain: Led the ETL testing and migration of Customer Resource Management

(CRM) data of customer accounts from AT&T's U-verse (IPTV service) to DirectTV (streaming service) within the Order Management System (OMS), ensuring a seamless transition of services for U.S.-based customers.

Validated system functionality across diverse database environments including Oracle, Teradata, SAP HANA and MySQL ensuring compatibility and stability throughout the migration process.

Executed data migration processes using Informatica as ETL Tools and PL/SQL scripts to ensure accurate and efficient data transfer, reducing the risk of data discrepancies and ensuring customer information was correctly transferred between systems.

Tested AT&T's network performance during peak periods on bulk accounts by validating shell scripts for file processing in Unix and Oracle environments, ensuring data accuracy. Collaborated with cross- functional teams to ensure seamless data transfers and accurate file transmission, using JIRA for task management and issue tracking.

Leveraged Apache Sqoop to efficiently import large volumes of customer account data from MySQL to HDFS and used Apache Hive for processing and querying the data, optimizing the ETL pipeline for faster, more accurate data integration.

Key Achievements:

o Achieved successful migration of 50,000+ customer accounts with a 95% success rate, minimizing data discrepancies during the conversion process.

o Ensured 99% accuracy in post-conversion account classifications for 20,000+ customers, verifying correct service classifications after migration.

o Managed 15+ sub-projects within the Alliance Data Mart initiative, overseeing 1,000+ test cases to ensure the integrity and reliability of the overall system. EDUCATION

Bachelor of Engineering in Electronics and Communication June 2016 Rajiv Gandhi Technical University, Bhopal, India CGPA: 7.8 CERTIFICATIONS

Databases and SQL for Data Science with Python – Coursera: Gained proficiency in SQL for querying and manipulating relational databases, and integrated SQL with Python for data analysis, cleaning, and visualization using tools including Pandas and Matplotlib.

Crash Course in Python – Coursera: Learned Python programming fundamentals, developed problem- solving skills by working on coding exercises. Gained practical experience for applying Python in real- world scenarios.

Data Visualization with Tableau – Coursera: Integrate diverse data effortlessly, leveraging Tableau's unparalleled data blending, joining, and computation to create insightful visuals.

Contact this candidate