Etl Testing Technology Services
Resume:
Anam Reddy
Capgemini Technology Services
Email: ****.*****@*********.***
Ph No : +91-800**-*****
PROFESSIONAL SUMMARY :
Having 15+ years of data testing(ETL Testing) experience 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 and very good exposure on various domains such as Financial Banking (Snchrony,MUFG, ANZ), Investment Banking and Private Banking (Hsbc) and HealthCare(NHS -Hospitals,UK), QBE-UK
Expert and having exceptionally good knowledge in ETL/Database/Data Migration testing
Extensively Involved for Data testing (ETL Testing) in Cloud environments
Report any product defects or non-compliance with business/functional requirements.
Reviews and interprets all documentation including business requirements, functional and design specification, test artifacts which was created by test team (Test Scenarios, Test Cases. SQL Scripts)
Extensively involved in Estimations, Master Test Plan, Test Strategy and Test Plan Preparations as Project lead
Good interpersonal skills, commitment, result oriented, hardworking and learn new technologies
As Capgemini Data & ETL Testing COE (Practice) Core Memer, will be extensivly involving as below resposibilities
Leading to eveluate to our Data & ETL Testing practice for internal bench/roll Off profile's to fulfil the right associates as per custemer/client demands.
Leading & Supporting to our staffing team to fulfil the requirements as per project critical demands across all accounts in Capgemini.
Leading to collect the panels from practise and supply to TA team to fullfil our critical deamnds as per customer demands
Attend the account team calls and understanding their demadns and fulfil their critical positions.
Finally taking care of single point of contact for providing required support to Staffing/TA/ Account teams to fulfil the critical demands as per client/customer requirments across all accounts which are under Data & ETL Testing practice in the organisation.
Technical Skills :
Operating System
UNIX, Windows
Database
Oracle 10g, MySQL and SQL Server2008, Synapse
Languages
C, C++
Testing Concepts
STLC, Testing Levels, Testing Types, Test Management
ETL tools/Cloud
Informatica 9.6.1, SSIS, Azure
Test management tools
HP ALM, JIIRA
ACHIEVEMENTS :
Received Star of the Month award (offshore) by Synchrony Financial.
Received Start of the year of 2024 by Data & ETL Testing Practice
Certified ScrumMaster by SCRUM ALLIANCE
Certified DP_900_Azure Data Fundamentals
PROFESSIONAL EXPERIENCE
Project#1: Transactional Data Mart (TDM) Expansion Squad (Sept 2023 to Till Date)
(Role) Test Manager
Data that is currently provided by DEA is not at a granular enough level which result in reporting and analytics being manual intensive (rekeying/data ingest/preparation of reports) and complex, in addition, Actuarial make predictions for trends based on approximated values from the cumulative data.
Actuarial team requires to build ad-hoc reports and dashboards for business because of limited access to the actuarial data.
Large part of the process of reserving model are undertaken in excel spreadsheets and low trust due tool limitation and misses a due diligence framework on built models.
Hence there is a need to build and deliver core policy and claim data repository on Data Hub that will enable enhanced Actuarial MI capabilities. Data consistency to ensure Finance and Actuarial are using the same data sources. Strategic solution developed in line with both Architecture and Data strategies and provides more opportunities for IT system rationalization in future.
Roles and responsibilities:
Building up and leading the Testing Team to the success of project and deploying and managing resources for testing in entire account level. Managed a Team of 15 members.
Defining the scope of testing within the context of each release / delivery
Planning, deploying, and managing the testing effort for any given engagement.
Provide the Story Estimations based on acceptance Criteria/Story Description and Developing Test Strategy/test plans/ test scenario and test data creation for quality releases.
As a team lead, supporting team to resolves the issues within team to deliver the project as per deadline. Reviewing and getting the test artifacts (Test Scripts, Test Cases. etc.) approved which was developed by team.
As a team lead, motivate the team and support to the team when they will require for additional support irrespective to get the details from various teams and reduce the work pressure to complete our deliverables as per deadline.
As a team lead, collaborate with team during holidays/weekends/late nights to reach our deadlines to avoid customer escalations (For Ex: MNC Extracts files generation which be impacted on third party vendor). will be the first person to solve the problems when team is facing any issues/Risks in work.
Taking care of to be completed appraisals within entire account level testing resources from Offshore. Taking care of all testing resources management/SPOC for all testing resources in QBE Offshore.
Working as mentor for all testing resource who are in PIP and any other project issues to resolves as much as we can. support to team to work on complex queries. Qualified in Agile and follow the rules in sprint.
Performing quality audits across the sprints to ensure client specific standards, procedures, and methodologies
Working with the business and IT team diligently to execute the activities in a timely manner
Environment: Agile Methodoligy, DevOps, Azure ADF, Data Bricks, Synapse DB and JIIRA
Project#2: Critical Report Assurance (CRA) (Jan 2022 to Aug 2023)
(Role) Individual Contributor
Critical Report Assurance seeks to increase ANZ's maturity to manage data related risk that might impact the accuracy and quality of data that support our critical reporting (regulatory reporting, attestations, and other key decision-making outputs). This is also in line with:
Increased regulatory focus and guidance such as APRA's CPG-235 Managing Data Risk; and progresses recommendations from the Section 95 review.
The Business needs
ANZ NZ needs 'assurance' that our most critical data driven reports (regulatory, financial, and key for internal decision -making) have been built and maintained to an appropriate standard. Well-built reports reduce the regulatory, reputational, and financial risks to the organization that may occur if inaccurate outputs are provided to external parties or using poor data to make any internal decisions.
Roles and responsibilities:
Understand the stories and prepared the test case and updated QA acceptance criteria as per request and provide the story points.
Understand the user stories and prepare and execute the test cases as per acceptance criteria and mapping details mentioned in stories.
Prepare the SQL queries and validate the data in between database to database and files to data bases as per requirements.
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 development team 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 defect life cycle management – logging, replication, triaging, verification, closing, metrics reporting, etc.
Excellent communication, client presentation demo and leadership skill
Environment: Agile Methodology, Tera Data, JIIRA, Putty and WinSCP
Project#3: Customer Insights project (Synchrony Financial Service) (Jan 2016– Dec 2021)
(Role) Test Lead
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 Reporting 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:
Managed a Team of 5 members.
Test strategy definition, test planning, test scenario and test data creation.
Developing Test Strategy/test plans for quality releases
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.
Involved to give the sprint demos to internal clients and external stakeholders.
Test execution, defect management and test results reporting to stake holders.
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
Working with the business and IT team diligently to execute the activities in a timely manner
Effective communication, client presentation demo and leadership skill
Added advantage as possess prior experience of improving test coverage and has test automation tool exposure.
Environment: JIIRA, Hadoop/Big Table, Big Query, Pub Sub and Cloud SQL (Google Cloud Platform), WinSCP, HP ALM and TOSCA Automation Tool
Project#4: Manulife TCoE Investment - (APR 2014 – Dec 2015)
(Role) Individual Contributor
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:
Raw zone (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 framework 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 stories and prepared the test case and updated QA acceptance criteria as per request and provide the story points.
Understand the user stories and prepare and execute the test cases as per acceptance criteria and mapping details mentioned in stories.
Prepare the SQL queries and validate the data in between database to database and files to data bases as per requirements.
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 development team 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 defect life cycle management – logging, replication, triaging, verification, closing, metrics reporting, etc.
Environment: SQL Developer, Informatica9.6.1, Putty and WinSCP
Project#5: AIA-Malaysia - (Sept 2013 – Mar 2014)
(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 various 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 into stage tables and from Stage to ODS.
Roles and Responsibilities:
Managed a Team of three members.
Understand the testing effort by analyzing the requirements project.
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#6: Global Decision Data Store (GDDS) -(Sec 2011 –Aug 2013)
(Role) Test Analyst
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:
Prepared High Level and Low-Level Test Scenarios and Test Cases
Prepare the Coverage Matrix and Requirement Traceability Matrix.
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.
Involved to Prepare 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 Offshore lead to update the status on daily basis.
Environment: Oracle 10g, SQL Server 2008, Informatica 9.5
Project#7: Data Service Layer (DSL) -(Nov 2008 – Aug 2011)
(Role) Test Analyst
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:
Prepared High Level and Low-Level Test Scenarios and Test Cases
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 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.
Evaluated 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 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:
SKD University, Anantapur A.P, India, MCA, 2004
Nagarjuna University, Guntur, A. P, India, B.sc, 2000
PROFESSIONAL ORAGANIZATIONS:
Capgemini (Jan 2016 to Present)
Birla Soft India Pvt Ltd (Aug 2011 to Dec 2015)
CSC Ind Pvt Ltd (Oct 2008 to Aug 2011)
Contact this candidate