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, Confidential Insurance, Confidential, Confidential ’s, Confidential and Confidential Bank.
• As a Test Lead Planning and Estimating for the project, knowledge transfer, allocating resources, worked wif the 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 DevelopmentProjects.
• 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 the data into higher level reports and charts.
• Expert in Data warehousing applications testing wif an excellent SQL skills
• Repeated success in the 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 the project, till final delivery.
• Ability to provide Testing Strategy for large to medium sized programs
• Has strong domain knowledge in Banking. Financial, Insurance
• Done end to end Testing which includes analysis of the Business reequipment, Design doc, Impact Analysis and Retest after Fixing the Incidents.
• Communicate and Collaborate wif cross functional teams during all phases of the program, mentor, train, develop and serve as a knowledge 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 the project; knowledge transfers, allocating resources; working wif the 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 the areas of Test management & Co-ordination, Delivery, and Process Improvement and Followed the scrum model process using the 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 the Client.
• Good communication skills, interpersonal skills, self-motivated, quick learner.
• Well acquainted wif the 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, Confidential 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

Processes: IBM’s QMS and Agile methodologies.

PROFESSIONAL EXPERIENCE

Confidential - Boston MA

ETL TEST LEAD

Responsibilities:

• Responsible for Manage the team in by delivering defect free product to customer
• Responsible for TEMPeffective communication between the project team and the customer.
• Provide day to day direction to the project team and regular project status to the customer
• Establish Quality Procedure for the team and monitor team the meets quality goals
• Daily Interaction wif Team, Responsible for knowledge transfer and deliverables
• Assigning the Tasks to the Team members and Track the Testing Progress
• Review of Deliverable Test Scenarios, Test Cases and Preparation of Traceability Matrix, Test Execution, Defect Tracking and Test Closure Report.
• Prepare the Test case, Defect status matrix on regular base and update to Client.
• Used Application Lifecyle Management (HP ALM) for the 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 the application
• Responsible for successful completion of System testing of the application.
• Manage the end-to-end line test effort. The 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 the outcomes of the testing and analyzing the results
• Regularly communicates the testing progress and quality to the Project Manager
• Delivering the high quality, bug free software to our customers in the financial sector.
• Prepared the 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 the 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 the project.
• Establish Quality Procedure for the 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 the Test Plan and Test Strategy documents for GMDL & Deposits
• Provide the SIT and keep track the progress and make sure dat SIT is completed Wifin time schedule.
• Load the data into various hops like Pre Stage to Stg, Stg to ODS, ODS to OFSAA
• Coordinated and shared the Metrics to Leadership team on weekly base
• Prepared, reviewed the test cases and test scripts provided inputs to the team
• Attend all daily stand up calls and offshore daily calls to track the progress
• Lead the offshore Team by assign the tasks and track the 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 the Regression Testing by running all the test scripts in one time.
• Make sure Test deliverables are on time wif best possible quality and as per Project standards
• Keep update the User stories in Rally and task for each Sprint

Environment: Informatica, Oracle SQL Developer, Rally, Atomic

Confidential

ETL Test Lead

Responsibilities:

• Lead the offshore Team by assign the tasks and track the 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 the daily test status / defect call wif Client and provide the inputs
• Prepare test scripts as per updated Mapping Transformation logic
• Automated the 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 the 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 the offshore team and the customer.
• Provide day to day direction to the offshore team and track regular project status
• Assign the Tasks to the Team members and Track the Testing Progress
• Writing the 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 the Data Model and Mapping sheet documents.
• Compare the 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 the test scripts in Quality Center and Execute.
• Enter the 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 the 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 the offshore team and the customer.
• Provide day to day direction to the offshore team and regular project status to the customer
• Establish Quality Procedure for the team and monitor team the meets quality goals
• Responsible for knowledge transfer and offshore deliverables
• Communicating wif the offshore team and Client.
• Assigning the Tasks to the Team members and Track the Testing Progress
• Writing the Test Scenarios, Review, Execution and Defect Tracking
• Mapping the Requirements to the Test Cases and Preparation of Traceability Matrix
• Prepared the Test Environment and communicate wif team.
• Prepare the 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 the application and Regression
• Manage the end-to-end line test effort. The 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 the outcomes of the testing and analyzing the 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 the testing progress and quality to the Project Manager
• Delivering the high quality, bug free software to the Clients
• Prepared the Requirement Traceability Matrix to cover functional requirements wif Test cases
• Responsible for software testing of Change Requests
• Attend the 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 the 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 the Test cases, Review, Run the Test cases in Rational Manual Tester.
• Created the Test Design in Test Manager & Link to the Manual Tester.
• Track the Team Test Case Execution status and update daily Test status Report.
• Monitoring the Tivoli Job Alerts for the Confidential application involved in various LPAR, TWS, Build Stand up & Connectivity Testing.
• Tracking and Chasing Approvals of the defects using CPMA as per Test case schedule.

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

Confidential

ETL Test Engineer

Responsibilities:

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

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

Confidential

ETLTest Engineer

Responsibilities:

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

Environment: Ab-Initio, Teradata.ALM,UNIX

Confidential

Sr.Test Engineer

Responsibilities:

• Written the Test Cases according to the Updated Functional Specifications.
• Running Test Cases on the Test Servers.
• Prepared the Reverse Traceability matrix and make sure dat Test cases are meeting all the 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 the Test estimates for the current project.
• Assigning the Tasks to the Team members and Track the Progress.
• Preparing the Test Environment and the give the Test release.
• Preparing Daily/Weekly Status Reports send to the Client.

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