PROFESSIONAL SUMMARY:

• Performance driven professional wif 15+ years of valuable experience in Quality Assurance as ETL Technical Test lead and ETL Tester worked in various Projects like Confidential Bank, Nationwide Insurance, JPMC, Barclay’s, Confidential Express and Confidential Bank.
• As a Test Lead Planning and Estimating for teh project, noledge transfer, allocating resources, worked wif teh scope of Testing and change requests.
• Management experience includes Manpower handling, Leadership, and improving team performance, conflict management, decision making, hiring right talent and ensuring smooth functioning of all operations
• Expertise in Testing GUI and ETL Testing using various SQL Databases in Waterfall, Agile Development Development Projects.
• Extensive experience in ETL Testing using tools Informatica, Ab Initio & Data Stage.
• 2+ years hands on Testing experience on Hadoop/Big Data Technologies, Experience on data ingestion tool NiFi, used to extract data from various data sources into Hadoop Data Lake.
• Write complex SQL queries in Apache Hive, Hbase, Presto for data validation and analytic purpose.
• Create detailed Test Execution Reports and Analyse, Interpret and Summarize teh data into higher level reports and charts.
• Expert in Data warehousing applications testing wif an excellent SQL skills
• Repeated success in teh areas of Test Management, stakeholder management & Co - ordination, Delivery, and Process Improvement
• Managing and leading team members; allocating resources among team members and guiding team during teh project, till final delivery.
• Ability to provide Testing Strategy for large to medium sized programs
• Has strong domain noledge in Banking. Financial, Insurance
• Done end to end Testing which includes analysis of teh Business reequipment, Design doc, Impact Analysis and Retest after Fixing teh Incidents.
• Communicate and Collaborate wif cross functional teams during all phases of teh program, mentor, train, develop and serve as a noledge resource to less experienced QA engineers
• Partner wif Product Owners and Scrum masters to ensure teams are delivering high quality deliverables and Experience in SDLC, STLC, Waterfall and Agile Process.
• As a Test Manager, conceptualizing, planning, and estimating for teh project; noledge transfers, allocating resources; working wif teh business for scope and change management; and identifying and managing risks
• Expertise in Functional Testing / Integration Testing / System Testing
• Used Test Management Tool Quality Center (HP ALM) extensively and certified.
• Repeated success in teh areas of Test management & Co-ordination, Delivery, and Process Improvement and Followed teh scrum model process using teh tool Rally
• Used SOAP UI and Java application Testing, experience in Manual Testing
• Extensive Experience in GIS architecture and GIS Testing SME in Auto Insurance Domain
• Extensive experience of analysis, design, develop, execution of Test scenarios and Test scripts
• Accustomed to best practices of Defect Triage, Defect Reporting & Test Management
• Preparations of team daily/weekly status reports and send to teh Client.
• Good communication skills, interpersonal skills, self-motivated, quick learner.
• Well acquainted wif teh Software Testing Life Cycle (STLC)
• Preparation of Test Plan and Preparation of Detailed Process Flow Diagrams.

TECHNICAL SKILLS:

Operating Systems: Windows NT /2000, UNIX

Web Technologies: ASP, .NET, C#, JSP, HTML, DHTML & XML

DW Tool: Ab Initio, Informatica, Data Stage,Talend, SISI

Databases: Teradata SQL Assistant, Oracle SQL DeveloperIBM DB2, Microsoft SQL Server, DBeaver

BigData Tools: Hadoop, Spark, Scala, Python, HBase, Kafka, Hive, HUE, Nifi.

Testing Tools: Product Studio, Quality Center, RTM, Rally, ALM

Languages: Java, C, C++, Python

Other Tools: VB, Visual Source Safe, Source Depot, Visio, Control-M, UNIX RPM, CPMA, NAPS, SOAP UI, Logical Viewer, ConfluenceDenodo, Putty, DB Visualizer, Mainframe, WinSCP, TDM, TableauServiceNow, SharePoint, Win Diff, OFSAA, Rally

PROFESSIONAL EXPERIENCE:

Confidential, Boston MA

ETL TEST LEAD

Responsibilities:

• Responsible for Manage teh team in by delivering defect free product to customer
• Responsible for TEMPeffective communication between teh project team and teh customer.
• Provide day to day direction to teh project team and regular project status to teh customer
• Establish Quality Procedure for teh team and monitor team teh meets quality goals
• Daily Interaction wif Team, Responsible for noledge transfer and deliverables
• Assigning teh Tasks to teh Team members and Track teh Testing Progress
• Review of Deliverable Test Scenarios, Test Cases and Preparation of Traceability Matrix, Test Execution, Defect Tracking and Test Closure Report.
• Prepare teh Test case, Defect status matrix on regular base and update to Client.
• Used Application Lifecyle Management (HP ALM) for teh Reequipments, Test Cases and Defects tracking.
• Provides updates to management on testing status & scheduling Issues
• Responsible for successful completion of Functional, Regression, Database testing of teh application
• Responsible for successful completion of System testing of teh application.
• Manage teh end-to-end line test effort. Teh activities include identify test data, coordinating test schedules, and mitigating test issues and risks
• Identify, define, implement, and conduct necessary tests, as well as log teh outcomes of teh testing and analyzing teh results
• Regularly communicates teh testing progress and quality to teh Project Manager
• Delivering teh high quality, bug free software to our customers in teh financial sector.
• Prepared teh Test Environment Document and Responsible for software testing of Change Requests
• Responsible for Preparing Project Understanding Documents and Knowledge Transfer
• Responsible for leading a project team in delivering solution to our customer in teh automotive sector.
• Deliver new and complex high-quality solutions to clients in response to varying business requirements
• Responsible for managing scope, planning, tracking, change control, aspects of teh project.
• Establish Quality Procedure for teh team and continuously monitor and audit to ensure team meets quality goals
• Tested automated framework to simulate JSON events and post them to Apache Nifi, Apache Kafka and HDFS.
• Tested generic automation framework which supports Lambda architecture to cover both batch and NRT (Near real time) data flow.
• Write complex SQL queries in Apache Hive, Hbase, Presto for data validation and analytic purpose.
• Preparing production-like test data in lower test environment required to perform ETE testing. Also develop scripts to generate larger volume of test data.

Environment: Spark, Python, Scala, Kafka, Nifi, Hive, HUE, HDFS, Eclipse, Presto, Apache, HBase.

Confidential

ETL Test Lead

Responsibilities:

• Prepared teh Test Plan and Test Strategy documents for GMDL & Deposits
• Provide teh SIT and keep track teh progress and make sure dat SIT is completed Wifin time schedule.
• Load teh data into various hops like Pre Stage to Stg, Stg to ODS, ODS to OFSAA
• Coordinated and shared teh Metrics to Leadership team on weekly base
• Prepared, reviewed teh test cases and test scripts provided inputs to teh team
• Attend all daily stand up calls and offshore daily calls to track teh progress
• Lead teh offshore Team by assign teh tasks and track teh daily test progress
• Define Test Approach and Publish Test Execution and Defect Report
• Develop BDQ test scenarios by DG team standards for each Test Scenarios.
• Prepare test scripts as per updated Mapping Transformation logic
• Automated teh Regression Testing by running all teh test scripts in one time.
• Make sure Test deliverables are on time wif best possible quality and as per Project standards
• Keep update teh User stories in Rally and task for each Sprint

Environment: Informatica, Oracle SQL Developer, Rally, Atomic

Confidential

ETL Test Lead

Responsibilities:

• Lead teh offshore Team by assign teh tasks and track teh daily test progress
• Define Test Approach and Publish Test Execution Report
• Defect Management through QC,
• Develop End to End Test Scenarios.
• Enter defects and Mapped to test cases to requirements in Quality Center.
• Attend teh daily test status / defect call wif Client and provide teh inputs
• Prepare test scripts as per updated Mapping Transformation logic
• Automated teh Regression Testing and did Reconciliation Verification Testing
• Preparation of Test plan document
• Extract Defect reports and share it wif Project Managers, Analysts & team
• Conduct Defect calls wif Development & Test teams for faster closure of defects
• Review Test cases and scripts
• Organizing daily stand up calls wif teh team
• Make sure Test deliverables are on time wif best possible quality and as per Project standards

Environment: Informatica, TOAD, Tivoli, WINSCP, Quality Center10

Confidential

ETL Lead

Responsibilities:

• Writing Test Scripts for Straight Map and various business rules to compare data.
• Analysis, Design, Development, Testing and Execution of Test Scenarios.
• Responsible for TEMPeffective communication between teh offshore team and teh customer.
• Provide day to day direction to teh offshore team and track regular project status
• Assign teh Tasks to teh Team members and Track teh Testing Progress
• Writing teh Test Scenarios, Review, Execution and Defect Tracking
• Writing and Executing SQL scripts for Source and Targets.
• Writing Complex Test Scripts by using Business Transformation Rules
• Understand teh Data Model and Mapping sheet documents.
• Compare teh Critical data for Source to Target in Testing environment.
• Smoke Test and Source Systems Unique Key Text (SSUKT)
• Develop End to End Test Scenarios.
• Upload teh test scripts in Quality Center and Execute.
• Enter teh defects in Quality Center
• Mapped to test cases to requirements in Quality Center.
• Prepared Client Audit Documents
• Attend Daily status calls wif onsite team
• Prepare QA Release Notes and send to teh Client to move code UAT

Environment: Informatics 8.6, Teradata13,UNIX,Control-M,, Quality Center10.0

Confidential

Test Analyst

Responsibilities:

• Analysis, Design, Development, Testing and Execution of Test Scenarios.
• Responsible for TEMPeffective communication between teh offshore team and teh customer.
• Provide day to day direction to teh offshore team and regular project status to teh customer
• Establish Quality Procedure for teh team and monitor team teh meets quality goals
• Responsible for noledge transfer and offshore deliverables
• Communicating wif teh offshore team and Client.
• Assigning teh Tasks to teh Team members and Track teh Testing Progress
• Writing teh Test Scenarios, Review, Execution and Defect Tracking
• Mapping teh Requirements to teh Test Cases and Preparation of Traceability Matrix
• Prepared teh Test Environment and communicate wif team.
• Prepare teh Test case, bug status matrix on regular base and update to Client.
• Provides updates to management on testing status & scheduling Issues
• Responsible for successful completion of Functional, Regression, Database testing
• Responsible for successful completion of System testing of teh application and Regression
• Manage teh end-to-end line test effort. Teh activities include identify test data, coordinating test schedules, and mitigating test issues and risks
• Identify, define, implement, and conduct necessary tests, as well as log teh outcomes of teh testing and analyzing teh results
• Conducting defect review meeting wif stake holders
• Coordination wif Performance Testing team and ensures completed on-time
• Support production readiness and implementation night validation.
• Regularly communicates teh testing progress and quality to teh Project Manager
• Delivering teh high quality, bug free software to teh Clients
• Prepared teh Requirement Traceability Matrix to cover functional requirements wif Test cases
• Responsible for software testing of Change Requests
• Attend teh defect review meetings and get it resolved defects on time

Environment: Java, SQL Server, SOAP UI, Quality Center 9.2, NAPS, Filenet, Logical Viewer

Confidential

Test Analyst

Responsibilities:

• Participating in different releases to Test different Services using Fitness Tool
• Participating in Business and System Requirement Reviews wif BA and Development Teams
• Test Plan Document preparation consisting Resource Estimation, Test Strategy, Scope of Testing
• Preparation of different Reports and Matrix ( Functional and System Testing Execution Reports, Requirement Traceability Report, Defect Reports) using Quality Center Dashboard Module
• Preparing XMLs for Functional and System Integration Testing
• Prepared an executed teh fitnesse scripts developed to validate various out of box and customized WCC services
• Coordinating Execution of Functional and System Test Cases, Test Execution Reporting
• Using Quality Center

Environment: IBM WCC (Websphere Customer Center), IBM DB2 V8.1

Confidential

Senior Tester

Responsibilities:

• Writing teh Test cases, Review, Run teh Test cases in Rational Manual Tester.
• Created teh Test Design in Test Manager & Link to teh Manual Tester.
• Track teh Team Test Case Execution status and update daily Test status Report.
• Monitoring teh Tivoli Job Alerts for teh CLS application involved in various LPAR, TWS, Build Stand up & Connectivity Testing.
• Tracking and Chasing Approvals of teh defects using CPMA as per Test case schedule.

Environment: C, C++, Java, UNIX, Windows NT/2000.

Confidential

ETL Test Engineer

Responsibilities:

• Writing teh Test cases, Review, Execution and Defect Tracking.
• Mapping teh Requirements to teh Test Cases.
• Preparation of daily / weekly status reports.
• Responsible for leading teh Testing team from Offshore.
• Prepared teh Test Environment and communicate wif team.
• Prepare teh Test case, bug status matrix on regular base and update to Client.
• Verify teh Source and Target data & Monitoring teh Jobs.
• Responsible for software testing of Change Requests.
• Written teh ETL, Masking, Data related Test cases.
• Written teh SQL scripts for Source and Target data testing.
• Tracking and Coordinating teh defects using Quality Center
• Responsible for Preparing Understanding Documents and Knowledge Transfer.

Environment: Ab Initio GDE 1.14.21, DB2, UNIX, Windows NT/2000.

Confidential

ETL Test Engineer

Responsibilities:

• Attend teh Basal .
• Written Test cases for Straight Map.
• Verify teh Input / Output data of Excels.
• Written teh SQL scripts for Source and Targets.

Environment: Ab-Initio, Teradata. ALM,UNIX

Confidential

Sr. Test Engineer

Responsibilities:

• Written teh Test Cases according to teh Updated Functional Specifications.
• Running Test Cases on teh Test Servers.
• Prepared teh Reverse Traceability matrix and make sure dat Test cases are meeting all teh functional requirements.
• Logging | Closing | Reopening Bugs in Product Studio.
• Worked on Functional, Regression and Performance Testing.
• Uploading of test cases to Product Studio and mapping of corresponding Bugs.
• Worked on various change requests and QFE’s.
• Prepared teh Test estimates for teh current project.
• Assigning teh Tasks to teh Team members and Track teh Progress.
• Preparing teh Test Environment and teh give teh Test release.
• Preparing Daily/Weekly Status Reports send to teh Client.

Environment: MS-SQL Server 2000, .Net Framework, Product Studio.