Architha ThirumalaReddy

Phone: +91-630*******

Gmail: adyamx@r.postjobfree.com

Career Objective:

Seeking to continue my professionalism, where my dedication, expertise and talent will definitely bring the organization creating a sharper edge within the industry. Aspire for a challenging position to contribute to the company’s growth and in turn ensuring personal growth within the organization. Professional Summary:

● Having 3.3 years of IT experience in ETL Testing.

● Expertise in preparing Test Cases.

● End to End testing in Data Warehouse (including source to reporting layer).

● Sound knowledge on DWH concepts like Fact Tables, Dimension Tables, Schemas, SCDs and Different DWH architectures.

● Understanding the Transformation rules which exists in Mapping Document and involved in Mapping Document walk through calls with BA Team.

● Loading the data from external systems to target system and validated data once data is loaded into target systems.

● A skillful team player with excellent communication skills and has ability to work in a team and individual environment.

● Quick learner, efficient, self-motivated and success oriented. Excellent written and communication skills and ability to work independently in a time sensitive environment.

● Strong analytical and problem-solving abilities, with quick adaptation to new technologies, methodologies, and systems.

Technical Skills:

Operating Systems Windows

Database Skills SQL SERVER

Test Management Tools JIRA

Testing ETL testing/Data warehouse Testing

Other Tools SAP HCM

1

2

Professional Experience:

Worked as Senior Software Engineer with Deloitte (Payroll: High Noon Consulting Pvt. Ltd) from Aug 2022 to April 2023.

Worked as Software Engineer in Eric Services, Hyderabad from January 2020 to June 2022. Academics:-

Masters of Computer Applications from Chaitanya PG College in 2018.

Bachelor of Science (MPCS) from St. Ann's College for Women in 2015. Professional Experience:

Project : STAFIT APPLICATION

Client : Deloitte Touché Tohmatsu Limited

Domain : HR Application

Environment : Advanced Excel concepts, SAP HCM (T - codes) Role : Data Analyst

Client Description:

Staffit is an HR application where Resource managers search for the resources who are suitable to the available role and hire them in their projects. One People Master (OPM) is the Master data source where all the Deloitte employees complete information. Here Staffit receives data from two types of sources Synaptica and OPM. Synaptica comprises of all the function and level details for an employee where as OPM comprises of other information related to the employee. Roles and Responsibilities:

Worked with bulk employee data and prepared dashboards with practitioner level details for all the global member firms.

Worked on OPM and Synaptica tools.

Consistently attended meetings with the client subject matter experts to understand functional business requirements.

Provided detailed documentation on Analytical deliverables.

Worked on Global Skills creation and skills cleanup using Fuzzy logic.

Contact with clients to determine their needs, gather and document requirements, communicate with clients throughout the development project to manage their expectations, resolve issues and provide project status.

Developing and implementing databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.

Managing the progress of projects by tracking activity, resolving issues, and recommending actions, provides senior management and project management with Project- 1 August 2022 to April 2023

3

regular updates on deliverable timeline and project status. Project : Cigna Global Health Insurance

Domain : Insurance

Databases : SQL Server, Oracle

Environment : Informatica, Jira

Role : ETL Tester

Client Description:

Cigna Global Health Benefits provides health insurance and health services for globally mobile employees and their dependents. They ensure customer to have quick and easy access to their Cigna benefits and services anytime and anywhere they need them. Cigna Envoy Portal allows the Clients and members to register themselves, submit claims and avail insurance benefits.

Roles and Responsibilities:

Analyzing the Mapping Document and finalizing test scenarios.

Involved in mapping document walk through calls with BA Team

Understanding the phases of data movement from source to Target and finalizing the test scenarios.

Writing SQL Scripts for Initial and Incremental load Testing as part of SIT Testing as per the Test Plan.

Validating the Audit Fields as part of SCD Type2 validation.

Preparation of Test Data to perform test validation when data is not available in source tables.

Involved in Performance load testing.

Involved in Functional, Non -functional and Sanity Testing.

Responsible for reviewing the test cases for team members to ensure high quality deliverables.

Attending Daily Standup Meetings, Sprint Planning Meetings, Sprint review meetings and Sprint retrospective meetings.

Raising the Defects in JIRA according to mismatches and assigning corresponding Team members.

Attending the Defect Triage meetings to discuss on Defect related issues.

Sending Daily Test Status reports to Test lead.

Updating the Daily work status in Team Foundation Server.

KT sessions to new team members on application functionality. Project- 2 Jan 2020 to June 2022

4

Contact this candidate