PROFESSIONAL SUMMARY

SKILLSET

EDUCATION

Mobile : +1-512-***-****

Email: ad4ju7@r.postjobfree.com

Linkedin: https:// www.linkedin.com/in/sowmya-reddy

• Experienced Senior Data Warehouse Analyst with a solution-oriented approach and 5 years of professional work experience.

• Extensive experience in writing complex SQL queries for business logic validation and transformations.

• Solid understanding of data warehousing concepts, including star and snowflake schemas.

• Proficiency in system integration testing, with a focus on SQL query development and execution.

• Thorough knowledge of Agile (Scrum) software development methodologies.

• Hands-on experience with star schema/snowflake schema analysis and source system evaluation.

• Skilled in requirement analysis, test case preparation, execution, and defect management processes.

• Expertise in data modeling and proficient in transformations.

• Strong ability in preparation of test data according to transformations.

• Familiarity with ETL processes in system integration testing.

• Experienced in HP-ALM Test Management tool for efficient test case management.

• Proven track record in writing test cases for initial and incremental loads, as well as SCD Type 2 testing.

• Testing experience with Informatica Power Center.

• Proficient in UNIX commands and Windows operating systems.

• Excellent documentation and presentation skills.

• Effective collaboration with project teams for scoping, prioritization, and issue resolution.

• Active involvement in daily standup meetings, Scrum meetings, sprint reviews, and mapping document walkthrough calls.

• Skills : ETL Testing, Data Modelling, Data Warehousing, MySQL

• Databases Worked On : SQL Server, Oracle, Teradata

• Programming Languages : SQL

• Tools : SQL Server Management Studio, Oracle SQL Developer, Teradata SQL Assistant, Beyond Compare tool,

• Defect Management Tool : HP Quality Center, HP ALM

• Operating System. : Unix & Windows

• Cloud Technologies : AWS

• Master of Science in Computer Science from Texas A&M University, Kingsville, Texas, May 2024(Expected).

• Bachelor of Technology in Computer Science(2012-2016) from J Bhaskar Rao Institute Of Engineering And Technology, Hyderabad.

Description:

Mphasis Pvt Ltd

Mar 2021-Oct 2021

F&G is the Insurance company, which gets its revenue by selling the policies. F&G needs agents or brokers to sell policies. NTT is one of the FGL agent, which is a Third-Party Administrator. All the policy administration work is handled by NTT. F&G is associated with Mphasis for Testing requirements and similarly with other vendors like DTCC. Roles and Responsibilities:

• Running the Informatica Jobs in SIT Environment to load the Data from source to Target.

• Preparation of Test Data as part of Incremental load Testing when source data is not available.

• Raising the Defects while executing the Initial and Incremental load Testing.

• Attending the calls with Dev team to discuss about the Defects that found during the SIT and Re- Testing them once they got fixed.

• Attending the Test case walk through calls along with Test Lead with BA Team.

• Going through the Mapping Document and analyzing the requirements.

• Understanding the Business Requirements which exists in Mapping Document.

• Writing the required SQL to verify the Source and Target Data.

• Raising the Defects in HP-QC according to Mismatches. Project #1

PRUDENTIAL LIFE INSURANCE

Databases– Oracle, Teradata

Domain – Insurance

Duration – Oct 2019 to Feb 2021.

Description:

WIPRO Technologies

Jan 2017- Feb 2021

Prudential is a leading life insurance and financial services institution in the United States, offering a diverse range of financial products and services both domestically and internationally. Renowned for its extensive portfolio, Prudential ranks as the second-largest institution by revenue. Specializing in retirement solutions, Prudential offers the following primary products:

1) Defined Contribution Plan

2) Defined Benefit Plan

3) Non-Qualified Plan

Roles and Responsibilities:

• Analyzed mapping documents to discern project requirements and ensure alignment with business objectives.

• Interpreted and translated business requirements outlined in mapping documents into actionable testing strategies.

• Developed SQL queries to validate source and target data, ensuring data accuracy and integrity.

• Prepared test data for incremental load testing to evaluate system performance and reliability. PROFESSIONAL EXPERIENCE

• Participated in various testing phases including Functional, Non-Functional, System Integration Testing (SIT), and User Acceptance Testing (UAT).

• Conducted comprehensive verification of audit fields during incremental load testing to maintain data traceability and compliance.

• Identified and documented defects during initial and incremental load testing phases, facilitating prompt resolution and improving system robustness

Project #2

WALGREENS

Databases– SQL Server, Oracle Environment – Informatica, HP QC Domain – Retail

Duration –Jan 2017 to Sep 2019

Description:

Implemented Sales Data Warehouse project to analyze sales of major brands and promotional schemes, utilizing historical data from various Walgreen stores. Generated comprehensive reports using Business Objects to analyze sales and profits on a monthly and yearly basis

Roles and Responsibilities:

• Execute Informatica jobs in SIT Environment for data loading.

• Prepare test data for Incremental load Testing.

• Proficient in creating, reviewing, and executing Test cases using HP-QC Test Management Tool.

• Validate source and Target data through test case execution.

• Report defects in HP-QC based on discrepancies.

• Participate in Test case, Defect validation, and Defect Triage meetings.

• Attend Daily Standup, Sprint Planning, and Sprint Review meetings, updating status in Team Foundation Server.

• Conduct test case walkthroughs with Business Analysis Team.

• Engage in Performance Testing for Informatica job execution time evaluation.

• Conduct Sanity Testing by reviewing Informatica Mapping and Workflow Details.

• Collaborate with BA & Dev teams to resolve issues effectively.

Contact this candidate