SUMMARY

• 8.4 years of Software Experience in ETL Testing (Ab initio, Informatica), Web, Mainframe, Unix Technology and Automation in Testing.
• Worked on ETL testing using Solid experience in Informatica Power Center including Designer, Workflow Manager, Workflow Monitor, Repository Manager.
• Experience in Development of mappings using needed Transformations using Informatica tool.
• Experience in the Data Warehousing using Data Extraction, Data Transformation and Data Loading. Preparing the Documentation for the Mappings According to the Business Requirements.
• Experience in SQL scripting.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica & Ab - Initio graphs.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Tested the ETL Informatica & Ab-Initio mappings and other ETL Processes (Data Warehouse Testing).
• Participated in all phases of SDLC Waterfall /Agile and being responsible for inducing best practices for Quality Assurance of all end products.
• Responsible for creation of all QA supporting documentation such as estimates, test strategies, test plans, test coverage, risk assessment, defect management, issue resolution, status reporting and approach documents.
• Running the daily stand up meetings/Test Execution and daily status reporting and pulling the metrics from Quality Center/ALM/Rally.
• UAT Test Co-ordination with all applications and follow ups.
• Responsible for creation of Frame Works for Automation.
• Tested Ab initio, Informatica based applications.
• Tested mainframe & web applications both manually and also utilized automated regression testing tool (SOAP UI, DB2 Client, selenium, QTP tools).
• Strong Domain knowledge in Banking & finance domain.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS

Languages: VB Scripting, Selenium Scripting (JUnit), COBOL,JCL

Testing Tools: ETL Testing (Ab initio, Informatica) HP Quality Center (QC), Rally, SOAP UI, QTP & Selenium.

Testing Methodology: Waterfall and Agile.

Databases: SQL Server, DB2, IMS DB

Office Tools: MS Project Plan, MS SharePoint, Lotus Notes, OutlookExcel, PPT, Word

Data Transfer Appln.: FTP, SFT

PROFESSIONAL EXPERIENCE

Test Lead/Test Manager

Confidential, Phoenix

Environment: ETL test tool (Informatica), Mainframe, IBM DB2, Data Studio, Rally, Unix, SFT.

Responsibilities:

• Creation of ETL test data for all ETL mapping rules to test the functionality.
• Execution of ETL works flows and monitoring the logs.
• Loading the data into staging tables, data warehouse tables and data mart tables.
• Staging and data warehouse tables will be loaded into netezza database and validate the data using Agnity tool by writing the queries.
• Data mart data will be loaded into DB2 database and validate the data using IBM DB2 data studio.
• Validating the data in all tables by writing the SQL quires and Excel Macro sheets.
• Writing test cases using business requirements and Defect management in Rally.
• Writing the SQL queries to support the mappings rules and execution and validations.
• Managing end to end testing activities in new product launch and performing the Lead quality assurance analyst for various applications across portfolio.
• Provided inputs during project planning (resource requirements, test estimates, etc.) and throughout the development life cycle to ensure business objectives are met.
• Responsible for conducting the daily stand up calls and daily status reporting.
• Participating on Sprint grooming sessions, User stories writing and project Plan preparation.
• Responsible for pulling the daily/weekly and monthly metrics from Rally and QC/ALM
• Responsible for coordinating with UAT team
• Daily Status reporting with current project status, % of completion, open defects, follow-ups are furnished.
• Post Implementation support (if pre-engaged) and document the production issue.
• Document Projects Learning and share with the E2E Team.
• All testing engagements completed within project timelines and consistency met live-date project deadlines.

Test Lead/Test Manager

Confidential, Phoenix

Environment: ETL test tool (Ab initiao), Mainframe, IBM DB2, Data Studio, Rally Quality Center, Unix, SFT and QTP for regression testing.

Responsibilities:

• Creation of ETL test data for all ETL mapping rules to test the functionality.
• Execution of ETL work flows and monitoring the logs.
• Writing test cases using business requirements and Defect management in Rally.
• Writing the SQL queries to support the mappings rules and execution and validations.
• Created Frame work for Automation using QTP and Excel macro.
• Recording the QTP scripts.
• Modifying the recorded code inorder to support for other conditions.
• Managing end to end testing activities in new product launch and performing the Lead quality assurance analyst for various applications across portfolio.
• Provided inputs during project planning (resource requirements, development estimates, etc.) and throughout the development life cycle to ensure business objectives are met.
• Responsible for delivering all the SDLC documentation like Test Strategy, test Plan, RRA and required documentation for Entry & Exit criteria for all phases in SDLC.
• Responsible for conducting the daily stand up calls and daily status reporting.
• Responsible for pulling the daily/weekly and monthly metrics from QC/ALM
• Responsible for coordinating with UAT team
• Daily Status reporting with current project status, % of completion, open defects, follow-ups are furnished.
• Post Implementation support (if pre-engaged) and document the production issue in QC.
• Document Projects Learning and share with the E2E Team.
• All testing engagements completed within project timelines and consistency met live-date project deadlines.
• Received excellent Client satisfaction feedback by meeting or exceeding defined quality objectives.

Test Lead

Confidential, Phoenix

Responsibilities:

• SOAP UI we will be using when we do the manual testing for DB2 Stored Procedures.
• MI application will be using Data Power to connect DB2 Stored procedure.
• We register all DP wsdl in SOAP UI and do the request and response testing.
• Tested Webservices, XML, WSDL using SOAP UI tool .
• Modified End point when worked on different versions of web services.
• Tested webservices, providing required input data to request XML and validated response XML.
• Managing end to end testing activities in new product launch and performing the Lead quality assurance analyst for various applications across portfolio.
• Provided inputs during project planning (resource requirements, development estimates, etc.) and throughout the development life cycle to ensure business objectives are met.
• Responsible for delivering all the SDLC documentation like Test Strategy, test Plan, RRA and required documentation for Entry & Exit criteria for all phases in SDLC.
• Responsible for conducting the daily stand up calls and daily status reporting.
• Responsible for pulling the daily/weekly and monthly metrics from QC/ALM
• Responsible for coordinating with UAT team
• Daily Status reporting with current project status, % of completion, open defects, follow-ups are furnished.
• Post Implementation support (if pre-engaged) and document the production issue in QC.
• Document Projects Learning and share with the E2E Team.
• All testing engagements completed within project timelines and consistency met live-date project deadlines.
• Received excellent Client satisfaction feedback by meeting or exceeding defined quality objectives.