SUMMARY

• 8+ Years of experience in Software Testing, Test Automation development and Testing ETL, Datawarehouse, Client/Server and Web applications.
• Experience in Functional, Manual, Automation, Regression, User Acceptance (UAT), System, Integration, Sanitary, End to End, Middle ware webservice and Black box testing.
• Extensively used HP ALM Quality Center, QTP.
• Experience in ETL Methodology for data extraction, Transformations and loading process in a corporate ETL solutions using INFORMATICA(Repository Manager, Designer, Workflow Manager and Workflow Monitor), IBM Infosphere information server Datastage(manager, designer, director and administrator) and SQL server Integration Services(SSIS).
• Exeperience in Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test result.
• Experience in writing complex SQL, Oracle queries inclusing calling stored procedures by passing parameters.
• Familiar with SQL Server, Toad Oracle, Stored Procedures, Functions and Triggeres.
• Experienced in dealing with clients to gather requirements, Understanding the business requirements and providing production support.
• Experience in Full software life Cycle(SDLC)(designing, Debugging, Testing, Documentaion, Maintenance and Enhancement).
• Experience in data analysis and problem solving with large amount of data.
• More experience on preparing Test Plan, Test Cases, Test data and Traceability matrix Documents.
• Worked on multiple client specific environments related to Financial, Banking, Insurance and Mortgages.
• Experience in Automation for functional and middle ware testing by using ATP and IBM RIT.
• Experience in designing and analyzing complex mappings from different transformation logics like Unconnected and Connected Lookups etc.
• Good understanding of Data warehouse concepts, Star & Snowflake Schema, Fact/Dimension tables, Normalization/Demoralization and slowly changing dimension (SCD) types.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Worked on different project methodologies like Agile, Critical Path, Waterfall and Migration.
• Vast experience in Data conditioning by using DMART/MDM and QA activities.
• Experience in using Data sources/targets such as Oracle 11g/10g/9i/8i, SQL Server 2008/2005, web based DB2, and Flat files
• Experienced in Middle ware testing by using SOAP UI and IBM RIT Tool.
• Excellent interpersonal and communication skills, technically competent and result - oriented with problem solving skills and ability to work effectively as a team member as well as independently.

PROFESSIONAL EXPERIENCE

Confidential, North America, Charlotte

Sr. Test Lead

Responsibilities:

• Analysis of Business Requirement Document (BRD) and High-Level Design (HLD) and Low-Level Design (LLD) technical design documents.
• Involved in Work Group Meetings, JAD sessions and Client status meetings
• Gathering the impact details of all CIS applications.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Prepared the Test Plan, test cases and Traceability Matrix documents.
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Data Conditioning for SIT Testing, Regression Testing and End-to-End Testing
• Conduct quality reviews of test plan and test script documents.
• Participated in regular project status meetings and QA status meetings.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Running the workflows by using work flow manager, Autosys and UNIX.
• Monitoring logs by using Work flow Monitor. And also monitor the scheduled work flows.
• Validate that data is transformed correctly according to various business requirements and rules.
• Validate that all projected data is loaded in to data warehouse without any data loss and truncation.
• Validate that ETL application appropriately rejects, replaces with default values and repots invalid data.
• Validate that data is loaded in data warehouse within prescribed and expected time frames to confirm improved performance and scalability.
• Involving in Middle ware testing by using XML and JSON REST requests.
• Web service, End to End, Sanitary, Performance,Regression and Security Testing is also carried out to make sure everything is smooth and reliable.
• Involving in running the automated test scripts by using QTP.
• Monitoring and tracking the project status.
• Involving in Defect Triage meeting to analyze the defects in inbound and outbound systems.
• Use IPMS for all project management related quality activities.
• Reporting status to the client on daily basis
• Defect Management, Reporting tracking using HP ALM Quality Center.
• Identifying priorities in consultation with the client and changing the schedule.
• Tracking and mitigating the risks.
• Periodic metrics and Traceability matrix prepared and provided to client and management.
• Root Cause Analysis.
• Taken care User Acceptance Testing (UAT) part.
• Created Share point sites for the team.

Environment: Informatica Power Center V9.5.1, SSH Tectia, Autosys Scheduler, SQL, Unix, DB2 and Quality Center- ALM v12.20, IBM RIT tool, QTP, SoapUI v5.1.3, Oracle v11.6, COBOL, CICS, JCL, CA7, DMART, Mainframe, Cobol and VSAM.

Confidential

Test Lead

Responsibilities:

• Involved in gathering and understating business requirements.
• Extensively worked on Informatica Power Center tools- Designer, Workflow Manager, Workflow Monitor.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica,
• Worked with Data modeler to restructure the data mart according to changes in the model worked on changes in the Informatica converting business needs to technical coding.
• Extracted data from different source systems like DB2, COBOL and XMLs.
• Worked on Joiner, Aggregator, Update Strategy, Router, Lookup, XML, Stored Procedure, Sequence Generator, Filter, Sorter, and Source Qualifier.
• Implemented slowly changing dimensions - Type I, II & in different mappings as per the requirements.
• Experience in scheduling tools like Autosys for automating and scheduling jobs run.
• Prepared Test Data and loaded it for Testing, Error handling and Analysis also prepared the test cases and tested the ETL components for end to end process.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for Unit Testing, Systems Testing, expected results.
• Worked on the production code fixes and data fixes.
• Responsible to Prepare UAT Test Plan and Test Scripts. And also Pre-UAT and Post UAT activities.
• Responsible to troubleshoot the problems by monitoring all the Sessions that are scheduled, completed, running and also used Debugger for complex problem troubleshooting.
• Worked with Application support team in the deployment of the code to UAT and Production environments.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the Mappings.
• Involved in Defect tracking by using HP QC ALM v12.20.
• Worked on onsite and offshore team coordination.

Environment: Informatica power center V 8.6, DB2, COBOL, MS SQL Server 2012, SSH Tectia, Autosys Scheduler, UNIX, Putty, DB2 and HP QC ALM v12.20, JIRA, Sharepoint.

Confidential

Test Analyst

Responsibilities:

• Analysis of Business Requirement Document (BRD) and High-Level Design (HLD) and Low-Level Design (LLD) technical design documents.
• Take a part in Work Group Meetings, JAD sessions and Client status meetings
• Gathering the impact details of all CIS applications.
• Creating Test Plan and Test Script documents.
• Data Conditioning for Testing
• Perform Functional, Regression and End-to-End Testing
• Defect Management and Reporting using HP Quality Center
• Assisting Development Team for Defect Triage.
• Preparing Traceability Matrix Document.
• Perform User Acceptance testing with huge amount of data.
• Involving in Project Management Activities.

Environment: IBM InfoSphere Information Server Datastage Designer, Director, QualityStage v8.5, SSH Tectia, Information Analyzer, Autosys Scheduler, Unix, Business Glossary, Metadata workbench, Fasttrack, DB2, Oracle and Quality Center

Confidential

ETL Test Analyst

Responsibilities:

• Analysis of Requirement and Design Documents.
• Involving Work Group and client Status Meetings.
• Analyzing and Estimating the Time of Business Requirements.
• Preparation of SIT Test Plan and Test Scripts.
• Data Conditioning for SIT Testing, Regression Testing and End-to-End Testing.
• Deploy the constructed code in Testing Environment.
• Perform SIT Testing, Regression Testing and End-to-End Testing.
• Defect Management and Reporting using Visual Studio (VSTF).
• Assisting Development Team for Defect Triage.
• Reporting status to the client.

Environment: SQL Server, Datastage, UNIX, VSTF, CHEF (SSIS Framework), SharePoint