Senior ETL Test Engineer/Lead

* ***** ** ************ ********** in IT industry with key specializations in DWBI/ETL/Data Centric Testing.

Joyeta has 5 years of experience in ETL/Abinitio/DWBI/Data centric Testing and is currently working ith CTS as a Technical Lead.

Process in Software Testing Life Cycle as a part of CMMI Level5 projects

ETL Testing -Tool Ab-Initio

IBM DB2

UNIX Shell Scripting

End-to-End SDLC & STLC and Agile Metodology.

Summary

Work Experience as a Data warehouse BI Ab initio developer for 6 months and Ab initio ETL Tester for 4.5 years, with very good knowledge on the DWBI concepts.

Experienced resource in providing Estimation, Design, Code, and Execution, Reports, Reviews and Monitoring skills with ability to work on multiple projects simultaneously.

Verifying that data is transformed correctly according to various business requirements and rules, Make sure that all projected data is loaded into the data warehouse without any data loss and truncation, Make sure that ETL application appropriately rejects, replaces with default values and reports invalid data, Make sure that data is loaded in data warehouse within prescribed and expected time frames to confirm improved performance and scalability.

Exposure in data ware house testing in BFSI domain with knowledge in Data warehouse and ETL Processes.

Understand user requirements and mapping documents to design test cases with suitable test design techniques.Expertise in SDLC and STLC process.

Expertise in defect tracking and Provide status report against the Run plan assigned on daily basis.

Exposure in handling multiple software test plan, test cases, RTM, testing execution projects based on Banking & Financial sectors.

Expertise with VISA related process and logistics especially with VISA business level.

Abinitio, UNIX, SQL, DB2, ETL, Datawarehouse, CA Workload, HP QC ALM with all modules, TMM, ClearQuest, Mainframe.

Running scripts in both Abinitio and Unix with fluent SQL and datawarehouse and database knowledge.

Exposure to domain knowledge on Electronic Payments System.

Have Abinitio Development experience with mainframe.

Have experience in MAintenace, Production Batch Support.

An effective communicator with honed relationship management, analytical, logical and problem-solving abilities.

Exposure in DWBI/ETL/Data Centric Testing, Functional Testing, Regression Testing, Integration Testing, Unit Testing, Data Preparation, etc.

Exposure in White Box Testing running scripts in different servers.

Having strengths on ETL Testing, Abinitio, UNIX, SQL, etc.

Have knowledge in Data Integration, data loading, data profiling.

Currently going on through big data Hadoop, Informatica and Talend training.

Excellent written and verbal communication and presentation skills.

Worked extensively to create, schedule, and monitor the workflows and to send the notification messages to the concerned personnel in case of process failures.

Test Management Tools:

-HP Quality Center (Test Plan and Test Execution Tabs)

-IBM Clear Case (Version Maintenance for all deliverables)

-ALM

Defect Tracking Tool:

-IBM Clear Quest

Self-motivated, hardworking and goal-oriented with a high degree of flexibility, creativity, resourcefulness, commitment and optimism.

Good interpersonal skills and an effective team player with exceptional planning and execution skills coupled with a systematic approach and quick adaptability.

Excellent communication and presentation skills.

Education and Work Experience

B.Tech(CSE) With 4 Years 11 months of experience as ETL/DCT Testing and Leading Offshore Team members.

Currently working with Cognizant Technology Solutions as an Associate.

Worked with Wipro Technologies as Senior Software Engineer for 8 months.

Worked with R S Software India Ltd. for 3 years, 11 months

Technical-Skills:

Operating System: UNIX

Data base: IBM DB2

Tools: Quality Center, Clear Quest and CA Workload.

Technologies: Ab-Initio,ETL and DWBI Testing.

Scripting: UNIX Shell Scripting

Cognizant Technology Solutions - Project Profile

Project #1

Title: RLG Pathway– INSURANCE (July 2016 – Till Date)

Description: Royal London Group Pathway (RLG).

The Royal London Mutual Insurance Society Limited, along with its subsidiaries, is the largest mutual insurer in the United Kingdom, with Group funds under management of £87.9 billion.

Royal London is the largest mutual life, pensions and investment company in the UK, while also providing protection products in Ireland.

Royal London is registered in England with its head office in the City of London. It has other large offices in Wilmslow and Edinburgh, with smaller offices in Bath, Glasgow and Dublin.

Role: Associate/Team Lead

Team Size: 8

Operating Systems: Unix-AIX,Linux.

Languages: ETL/SSIS.

Test Tool: HP QC

Databases: Sql server/Oracle.

Responsibilities:

Lead a team of 8 following Onshore-Offshore Model.

Maintain co-ordination between clients and team members

Monitoring the Team's Deliverables

Participation in the requirement analysis and business requirement walkthrough meetings.

Preparation of Test Strategy,mentoring TP/TC with tem members.

Execution of Testing deliverables.

Wipro Technologies Ltd. - Project Profile

Project #1

Title: VISA– CARDS – GMR (Sep 2015 – Feb 2016)

Description: GMR (Global Merchant Repository)

The merchant data sent by the Acquirer undergoes a certification process where it is matched with transaction data to measure the quality of the Acquirer sent data. After the certification process the data passes through a series of robust data quality checks through an automated process.The maintenance and enrichment of the data is extremely important as it is used by several downstream applications.

Role: Senior Software Engineer (Act as Offshore Lead)

Team Size: 10

Technology: Ab-initio

Scheduler: CA Workload

Operating System: UNIX

Responsibilities:

Involved in the application maintenance and production support.

Provides Application Production L3 Level support for the GMR application

Provide coaching and mentoring to less experienced team members

Handle critical issues in the production environment and code and fix the issues under tight deadlines

Research and evaluate alternative solutions and make recommendations to avoid repetitive manual interventions and failures

Involved heavily in writing complex SQL queries based on the given requirements.

Responsible for on-time project / L3 Releases delivery with high-quality code

Involved in creation of Implementation and Install plans and provide warranty support.

Project #2

Title: VISA– CARDS – CDI(Mar 2016 – May 2016)

Description: CDI (Common Data Infrastructure)

CDI is the platform through which Visa Inc. provides business intelligent data to its Internal as well as External customer as a different format of Reports. The user community consists of internal staff as well as external Members of Visa such as Various Banks in the different regions of the world. These projects have several inbuilt reports ready to be used by users.

CDI-SI is secured and audit able access of Common Data Infrastructure (CDI) data to applications via Web Services. The purpose of different CDI-SI web services are to provide Payment Details, Fraud Details, Exception Details, Account history depending upon the various business criteria like date, transaction history, card number, transaction id etc.

Role: Senior Software Engineer (Act as Sole Testing Member)

Team Size: 7

Technology: Web Based Testing

Responsibilities:

Involved in the web based testing for the application.

To check if the requirements needed in the new pages for Reporting are getting added in the web page as designed.

R S Software India Ltd. - Project Profile

Project #1

Title: VISA– CARDS – VMPD (Sep 2011 – Jan 2012)

Description: Visa Merchant Profile Database (VMPD) deals with editing and storing of merchant data provided by acquirers. VMPD provides merchant information to various sub applications and third party clients like IRS. Acquirers send merchant master data to VMPD, VMPD validates, edits, enriches the merchant data and store the data into DB2 repository.

Role: Trainee Software Engineer

Team Size: 8

Operating Systems: Z/OS 390, Windows

Languages: COBOL, JCL, CICS.

Databases: DB2, VSAM

Responsibilities:

Enhanced existing COBOL-DB2 based programs

Worked with DBA and Fine-tuned existing COBOL-DB2 application

Performed end to end development and testing – ensured on-time delivery and error-free deliverables

Co-ordinated with QA testers for end to end unit testing, regression testing and integration testing

Drafted technical documents.

Project #2

Title: VISA– CARDS – CMLS (Feb 2012 – June 2012)

Description: CMLS is the alias of the Consolidated Master Log Service. It is related to the CREDIT/DEBIT card processing methodology of a leading payment system operator in Electronic Payment industry. This includes online transaction processing also. Working in this project is related to the enhancement of the existing business logic and development of new logic and Support for Upstream and Downstream application.

Role: Associate Software Engineer

Team Size: 70

Technology: Ab-initio

Scheduler: ESP

Operating System: UNIX

Responsibilities:

Involved in the phases of Requirement gathering, Analysis, Design, coding and Testing.

Development of all the transformation graphs.

Presented all the Software deliverables to the client directly.

Responsible for developing the re-useable graphs for loading tables.

Responsible for creation of UNIX scripts which would call the graph for execution.

R S Software India Ltd. - Project Profile

Project #3

Title: VISA– CARDS – VDM, DPS, CDIMI (July 2012 – Aug 2015)

Description: VDM (Visa Data Manager) Visa Data Manager (VDM) is a best-in-class data warehousing, analytics and reporting platform designed to gather and aggregate all of your card transaction data so you can make smarter and potentially more profitable business decisions. To help you better manage your business, VDM automatically gathers and aggregates billions of historic transactions and cardholder records stored and managed by Visa DPS. VDM then turns it all into easy-to-understand information about cardholders, merchants, ATMs and card activity and delivers it right to your desktop so you can get a clear picture of your business.

The real distinction of Visa DPS is the calibre and commitment of our people. Visa professionals have significant experience in delivering high quality advice, tools and support on behalf of our clients, in such areas as:

• Fraud rules and case management

• Managing chargebacks and disputes

• Cardholder call services, including card activation and lost or stolen card processing

CDI-MI is a Java based web application, which acts as a gateway to other applications that require data from the CDI Data Warehouse. This application is a virtual platform that sets-up and validates access to MSTR projects used by Visa Members.

Role: Software Engineer

Team Size: 20

Technology: Ab-initio ETL Testing

Database: IBM DB2

Bug Tracking Tool: Clear Quest

Operating System: UNIX

Test Tool: ALM, Quality Centre

Responsibilities:

Lead a team of 10 following Onshore-Offshore Model.

Maintain co-ordination between clients and team members

Monitoring the Team's Deliverables

Participation in the requirement analysis and business requirement walkthrough meetings.

Seeking Clarifications on the requirements whenever required.

Maintaining the requirements in the Clear case.

Providing estimations after the analysis of the requirements.

Preparation of the Testing Strategy, Test Plan, Test Script (All the Test Deliverable).

HP Quality Center is used for storing test cases and performing test execution.

Responsible for the automation of the regression process by the creation of graphs for all the regression requirements which would improve the performance of the regression testing for the major releases.

Involved in End to End integration testing, Functional (Component wise) white box testing, Smoke testing etc.

Involved in Test Execution using IBM DB2.

Testing effectively and finding the defects at initial stages.

Responsible for tracking defects and reporting them through Clear Quest.

Participated in team meetings and review meetings to ensure that project complies with Visa’ security and quality policies.

Involved in the Designing of test scripts.

Personal Details:

Name: JOYETA SARKAR

PAN: BKCPS3529P

Passport: J7592053

Languages: English, Hindi, Bengali, Spanish

Current Location: Kolkata, India.

Contact this candidate