Anam Reddy

Capgemini Technology Services

Email: adpv63@r.postjobfree.com

Ph No : +91-889*******

PROFESSIONAL SUMMARY :

Well versed with automated test tools(execution as part of regression pack) like Eggplant and UFT and defect reporting tools like H.P ALM, Q.C 9.0, Change Synergy, Tele Logic, Radar and ETL Tools like Informatica, Data Stage and DTS.

Very good knowledge and understanding Oracle technology.

Expert in manual testing and DWH/ETL/Database/Data Migration and having very good knowledge on Data warehouse Concepts

Report any product defects or non-compliance with business/functional requirements

Reviews and interprets all documentation including business requirements, functional and design specification, etc.

Performs maintenance and support duties and Ensuring conformance and application of test process management tools process and guidelines

Expert in Preparing Test plan and Test cases in line with complex requirements

Extensively involved in Estimations, Master Test Plan preparation as project lead.

Extensively Involved to one to one appraisal meeting as project lead.

Extensively Involved to motivate the team and conduct KT sessions on new technologies.

Expert on testing of Regulatory reports with respect to Dodd Frank Act Title VII, EMIR, MAS, ASIC, CSA, HKMA

Good knowledge on various Front office applications such as SUMMIT

Extensively involved in Agile Methodologies (Sprint, Scrum and Kanban) and SDTC

Designs, develops, deploys and maintains new test packages (high and low-level test scenarios, development and maintenance, test execution plans and test data development, management and maintenance.)

Involved in Management reporting and stakeholder communication on various reports such as Sign off reports.

Good interpersonal skills, commitment, result oriented, hardworking and learn new technologies

Technical Skills :

Operating System

UNIX, Windows

Database

Oracle 10g, MySQL and SQL Server2008

Languages

C, C++

Testing Concepts

STLC, Testing Levels, Testing Types, Test Management.

ETL tools

Informatica 9.6.1, SSIS

Test management tools

HP ALM

ACHIEVEMENTS :

Received Star of the Month award (off shore) by Synchrony Financial.

PROFESSIONAL EXPERIENCE

Project#1: Synchrony Financial Services - (April 2019 – Till Date)

(Role) Individual Contributor

Customer Insights project is one of the major projects under EDL (Enterprise Data Lake) Team. EDL team deals with various projects related to credit card. This project deals with ingesting customer complaints received through various channels like chat, workstations, voice calls, IVR, VOC,MicroServices Reporeting etc. to Hive with transformations as required by business needs. We interact with reporting team for requirement and provide them required data as solution. Raw data (Source Tables) are ingested to hive tables through Ab Initio.

Roles and Responsibilities :

Test strategy definition, test planning, test scenario and test data creation

Developing and executing formal test plans/test scripts for quality releases

Reviewing and getting the test artifacts approved

Understand the stories and prepared the test case and updated QA acceptance criteria as per request and provide the story points

Involved in the test execution on curation tables in Big Data (hive) and Data Warehouse platforms

Involved the in Raw injection data validation using variant abinitio products such as Acquire IT, GDE and Mhub and Control center

Involved to give the sprint demos to internal clients and external stakeholders

Test execution, defect management and test results reporting

Defining and tracking QA metrics like defect count by stages and cycles

Imparting the process knowledge to the testing team members and publish best practices on an ongoing basis

Performing quality audits across the sprints to ensure client specific standards, procedures and methodologies

Preparing and maintaining Requirements Traceability Matrix

Experience working independently as a tester and QA lead

Knowledge of test standards and process

Working with the business and IT team diligently to execute the activities in a timely manner

Working in testing effort estimations using industry standard methods

Working in defect life cycle management – logging, kreplication, triaging, verification, closing, metrics reporting, etc.

Good communication, client presentation demo and leadership skill

Added advantage as possess prior experience of improving test coverage and has test automation tool exposure.

Environment: SQL Developer, Hive, HP ALM, Putty and WinSCP

Project#2: Manulife TCoE Investiment - ( Sept 2017 – March 2019)

(Role) Test Lead

The Information Environment project is key component Global Optimization (GO) program.This project is part of effort to implement Manulife's Enterprise Data Lake (EDL) for investments. The informational environmental utilizes the Enterprise Data Lake (EDL) which is Big data platform that uses hadoop-on-cloud.to deliver data capabilities supporting analytic InSite across a large, broad and diverse and date at efficient scale.

Below are the key architecture layers of the new informational environment:

Rawzone(Landing Layer): Collection area of all source data, with data written and stored in the same format and structure as received. Data in this zone requires no modeling and no further processing.

Data Injection Layer: Manages how data is ingested from source systems into Enterprise Data Lake (EDL) environment. The Ingestion frame work establishes ingestion patterns as well as reusable component services.

Curation Layer: Storage area data which has been validated, standardized, transformed and ingested for specific business purposes.

Data Access Layer: Pre-defined views and data access API that consolidates data from across the Enterprise Data Lake,for end user/system consumption

SimCorp Data Warehouse (SCD DW): Testing of customs extensions requirements in the SimCorp Data Warehouse (i.e. validating and verifying the custom tables/columns into SCW DW schema)

Roles and Responsibilities :

Understand the testing effort by analyzing the requirements project

Managed a Team of 10 members

Understand the testing effort by analyzing the requirements project

Involved in Estimations, Master Test Plan preparation as project lead

Involved to one to one appraisal meeting as project lead.

Involved in test execution and reported the defects into HP ALM

Organize the testing kick-off meeting

Involved into Risk based testing (without proper test data for delta loads).

Develop the test plan and test strategy for the tasks, dependencies and participants required and obtain stakeholder support for this plan.

Arrange the Hardware and software requirement for the Test Setup.

Assign task to all Testing Team members and ensure that all of them have sufficient work in the project.

Ensure content and structure of all Testing documents / artifacts is documented and maintained.

Document, implement, monitor, and enforce all processes for testing as per standards defined by the organization.

Check / Review the Test Cases documents.

Keep track of the new requirements / change in requirements of the Project.

Escalate the issues about project requirements (Software, Hardware, Resources) to Project Manager / Sr. Test Manager.

Organize the status meetings and send the Status Report (Daily, Weekly etc.) to the Client

Communication with the Client (If required).

Act as the single point of contact between Development and Testers.

Track and prepare the report of testing activities like test testing results, test case coverage, required resources, defects discovered and their status, performance baselines etc.

Review various reports prepared by Test engineers.

Environment: SQL Developer, Informatica9.6.1, Putty and WinSCP

Project#3: AIA-Malaysia - ( Sept 2016 – Aug 2017)

(Role) Test Lead

The Enterprise Data Warehouse (EDW) project aims at building a reporting solution for the Multiple Businesses. Before EDW ODS layer is built and is loaded with Insurance related data from different subject areas. We have used Informatica as an ETL tool which pulls the data from different sources and dumps it into ODS. The data is pulled based on different conditions for which mappings are developed at Informatica. Here ODS layer is built on Oracle Database platform. In this project, twelve Source systems data from different database are loaded in to stage tables and from Stage to ODS.

Roles and Responsibilities:

Managed a Team of 10 members

Understand the testing effort by analyzing the requirements project

Involved in Estimations, Master Test Plan preparation as project lead

Involved to one to one appraisal meeting as project lead.

Involved to motivate the team and conduct KT sessions on new technologies.

Organize the testing kick-off meeting

Involved into Risk based testing (without proper test data for delta loads).

Develop the test plan and test strategy for the tasks, dependencies and participants required and obtain stakeholder support for this plan.

Arrange the Hardware and software requirement for the Test Setup.

Assign task to all Testing Team members and ensure that all of them have sufficient work in the project.

Ensure content and structure of all Testing documents / artifacts is documented and maintained.

Document, implement, monitor, and enforce all processes for testing as per standards defined by the organization.

Check / Review the Test Cases documents.

Keep track of the new requirements / change in requirements of the Project.

Escalate the issues about project requirements (Software, Hardware, Resources) to Project Manager / Sr. Test Manager.

Organize the status meetings and send the Status Report (Daily, Weekly etc.) to the Client

Communication with the Client (If required).

Act as the single point of contact between Development and Testers.

Track and prepare the report of testing activities like test testing results, test case coverage, required resources, defects discovered and their status, performance baselines etc.

Review various reports prepared by Test engineers.

Ensure the timely delivery of different testing milestones.

Environment: SQL Developer, Informatica9.6.1.

Project#4: LRM Access Layer (AL) - (Jan 2016- Aug 2016)

TDP Access is being built and enhanced to store transformed data from EDW tables to ease downstream and reporting requirement. Informatica tool will be used to perform ETL (Extract, Transform & Load) operations and load the transformed data into TDP access layer tables. This data will be used for various programs like FRF –WKFS, FICS, TOVI enhancements, Liquidity, EDW Release 2.0 etc.; this layer will serve as a Standard data publication framework and Self-Service data platform for BI data where data is organized to align with business products

Roles and Responsibilities:

Managed a Team of 8 members

Understand the testing effort by analyzing the requirements of project

Involved in Estimations, Master Test Plan preparation as project lead

Involved to one to one appraisals meetings as project lead.

Involved to motivate the team and conduct KT sessions on new technologies.

Organize the testing kick-off meeting

Develop the test plan for the tasks, dependencies and participants required to mitigate the risks to system quality and obtain stakeholder support for this plan.

Arrange the Hardware and software requirement for the Test Setup.

Assign task to all Testing Team members and ensure that all of them have sufficient work in the project.

Ensure content and structure of all Testing documents / artifacts is documented and maintained.

Document, implement, monitor, and enforce all processes for testing as per standards defined by the organization.

Check / Review the Test Cases documents.

Keep track of the new requirements / change in requirements of the Project.

Escalate the issues about project requirements (Software, Hardware, Resources) to Project Manager / Sr. Test Manager.

Organize the status meetings and send the Status Report (Daily, Weekly etc.) to the Client

Communication with the Client (If required).

Act as the single point of contact between Development and Testers.

Track and prepare the report of testing activities like test testing results, test case coverage, required resources, defects discovered and their status, performance baselines etc.

Review various reports prepared by Test engineers.

Ensure the timely delivery of different testing milestones.

Environment: SQL Developer,Informatica 9.6.1, UNIX.

Project#5: Global Decision Data Store (GDDS) -(Dec 2013 –Aug 2016)

The purpose of the GDDS project is to develop and implement a flexible tool to deploy the risk analytic outcomes into Group Standard Decision tools such as SMG3 and TRIAD. To meet and support the requirement from Analytics and Decision Center of Excellence (DCOE); this proposed tool will offer maximum business control with minimal to no IT intervention. This will allow Analytics to customize at its discretion, decision data to the relevant predictive model and to realize their benefits quickly.

Roles and Responsibilities:

Managed a Team of 5 members.

Monitoring the defects and identified risk issues and updated the management with status.

Prepare the Coverage Matrix and Requirement Traceability Matrix.

Preparation of different types of reports such as test completion report, defect status report and CAM and TSR reports.

Prepare complex SQL Queries to validate the Counts and data validation between Interface Files (Source) and GDDS (Staging) and Risk Gateway (Target).

Interacted and worked with the development team to solve the problems encountered in the test Scenario run.

Regular interaction with Onsite Manager to update the status

Environment: Oracle 10g, SQL Server 2008, Informatica 9.5

Project#6: Data Service Layer (VDSL) -(Aug 2011 – Aug 2013)

(Role) Test Analyst (Individual Contributor)

The Data Service Layer (DSL) provides acquisition, transformation, enrichment and distribution services for producers and consumers of HSBC transaction data. The data from the Primary Trading System (Summit, Global Calypso, Murex, TRI, PMC, APO, NFOS, Trinity, Phoenix and Sophis) is converted into Standard FpML messages after applying business rule to enable for distribution to DTCC (Depository Trust & Clearing Corporation) regulatory reporting to get acknowledgement for the data reported.

Roles and Responsibilities:

Involved in review of HLD and LIRD Documents and Prepared Test Plan Document

Prepared High Level and Low-Level Test Scenarios

Reviewed test cases which has been prepared by my team members

Having effective discussions in analyzing and understanding the requirements for a specific requirements and planning project calls for discussions with Business on any issues or gaps.

Proactively conducted meetings with ETL design heads for any discrepancies and also with source system (SUMMIT, MUREX, NFOS, APO, BRA, PMC, PHNX and SOPHIS)

Monitoring the defects status in Quality Center and following with various teams in their resolution and updating the project plans and test docs respectively.

Preparation of different types of reports such as DSR, Test completion report, Defect status report

Interacted and worked with the BA and development teams to solve the problems encountered in the test Scenario run (Agile Methodologies).

Regular interaction with Onsite Manager to update the status

Co-Ordinated with various stake holders in FX and Equities Teams

Prepared High Level and Low-Level Test Scenarios and reviewed test cases which has been prepared by my team members

Involved in global leads meeting and update the status in weekly scrums.

Execution of ETL Test Cases and tracking the defects by using the QC Management Tool

Involved in the Baseline Testing, System Integration Testing and Regression testing as part of ETL Process.

Tested various Regulatory reports for CFTC, MAS, EMIR and HKMA to validate the using Oracle Developer.

Involved in FPML Views (RKV, TV and RKV_TV) and XSLT Validations.

Having got the requirements cleared and final, working closely with ETL development team in developing reconciliations.

Environment : Informatica 8.6, Oracle 10g, SQL Server 2008, UNIX.

ACADEMIC INFORMATION :

JNT University, Visakhapatnam,A.P,India, MCA, 2004

Andhra University, Visakhapatnam, A.P,India, B.sc, 2000

PROFESSIONAL ORAGANIZATIONS:

Capgemini (Jan 2016 to Present)

Birla Soft India Pvt Ltd (Aug 2011 to Dec 2015)

CSC India Pvt Ltd (Oct 2008 to Jul 2011)

Contact this candidate