SUMMARY

• ETL, Business Intelligence (BI) and Data warehouse QA Test Lead and Technical Data Analyst/Modeler having around 9+ years of experience in all phases of Software life cycle (SDLC) including Requirement Analysis, Test Planning, Test Design, Test Environment setup, Test Data setup, Test Execution, Defect Triaging, RCA, Data analysis and Test Closure.
• Have expertise in Black box, White Box, System Integration testing, UAT, Interface testing, Data Migration testing, Risk based Regression testing and Data Warehouse testing.
• Strong experience in different Databases like Oracle, SQL Server and Teradata.
• Experienced working in Agile & Waterfall methodology projects.
• Astute understanding and experience in Mutual Funds (Investment setup, Pricing, Trading, Position Reconciliation, Dividends and Accounting).
• Have good working experience in Treasury application such as Wall Street Suit (WSS), Investment Setup platform APERIO Suite - SRM (Delta Data), Trade processing, Revenue Sharing, Position Reconciliation application Fundlinx (Delta Data).
• Have domain expertise in Treasury, Capital markets.
• Sound knowledge in ETL tool like Informatica 9.5.1
• Proficient in BI tools like Cognos and OBIEE.
• Good hands on experience in Unix Shell Commands.
• Good Knowledge in IBM Tivoli Workload Scheduler (Maestro).
• Very good understanding of Data Warehousing concepts, Data Analysis and Data Warehouse Architecture.
• Strong Understanding of Star Schema, Snowflake Schema, Metadata, Facts and Dimensions.
• Experienced working in Automation tool to compare huge data base to reduce the manual efforts.
• End-to-End Defect Management - Detecting defects, co-coordinating with the Business and development to triage and tracking them to closure using Test Management tools like HP Quality Centre/ALM.
• Acquired sound skills in testing methodology - Preparation of test ware like Effort Estimation, Test Plan, Test Scope document, Test Scenarios, Test Scripts, Test cases, Run plan, Day-Zero checklist, Test Execution involving End to End Defect Management and Test Summary.
• Extensively involved in various User Acceptance Testing and System Integration Testing in Data Warehouse platform by understanding the Business Requirement Documents & Functional Specification Documents, decomposing them into testable functions & executing them.
• Proficient preparing Test Strategy, Test Plan, Test Approach, Test Summary Report and Process Flow documents.
• High-powered, innovative, and technically inclined professional with extensive and progressive background in IT functions with Good analytical, presentation and strong communication skills.

TECHNICAL SKILLS

Operating Systems: Windows, Basic Linux and UNIX

Languages: C, C++ and SQL

Databases and Tools: Oracle 10g/11g, Teradata, Microsoft SQL server, MS Access, SQL Developer

Reporting Tools: Cognos and OBIEE

ETL Tools: Informatica 8.5 and Informatica 9.5.1

Scheduler & Utilities: IBM Tivoli workload Scheduler (Maestro), Informatica Workflow manager

Defect Tracking Tools: HP Quality Center (HPQC) / HP ALM

Domain Knowledge: Mutual Funds, Investment Cycle, Trading, Pricing, Insurance, Treasury, Capital Markets and Credit Cards

Office Tools: MS Office Suite, MS Project 2010

PROFESSIONAL EXPERIENCE

Confidential, Enfield, CT

Tools: ETL, Informatica 9.5.1, OBIEE, Teradata, IBM Tivoli (Maestro)

QA Lead

Responsibilities:

• Role includes continuous interaction with Business to understand Business Requirements & Functional Specification documents, team co-ordination and task distribution.
• Performing Detail testing on data getting staged and transformed from multiple application via ETL (Informatica), making sure all the data movements and logics are incorporated across the board till reporting.
• Working with Senior Business Stake holders to understand business requirements and interpreting the same to the IT functional team through Requirement elicitation, Business requirement analysis and Management reporting.
• Performing detailed impact analysis on business processes/system flows, synthesized findings and made recommendations based on data or functional requirements change.
• Collaborated with cross-functional teams (business users, IT Managers, technical architects and developers) to ensure maximum process quality including process documentation.
• Performing Requirement Analysis, effort estimates, schedule plan, design, Testing and documentation.
• Coordinate with Client, Development, Support and the offshore teams during both planning and execution phase.
• Performing root cause analysis, identifying and resolving data quality issues for remediation.
• Performing data quality audits on project data for business rule violations and incorrect data.
• Smoke testing the environment once the QA code migration is completed.
• Preparing Traceability matrix to map Functional Requirements to Test Requirements and Test cases.
• Preparing Effort Estimation based on the Testing Scope.
• End-to-End QA Test management.
• Preparation and Tracking QA Run plan.
• Preparation of Test Strategy and Test Plan.
• Reviewing Testware like Test Requirements, Test Scenario’s and Test Cases.
• Defect Management and defect triaging with Business, Dev and Vendor.
• Finalizing the test environment and required Test data set.
• Tracking the each business requirement till the closure
• Day Zero checks and Smoke Testing before the start of QA Test Execution.
• Running End to End Batch cycles and troubleshooting any issues that comes up.
• Validate the business data once the built is completed at end of each sprint
• Identifying business data issues and escalating the same to business team after each sprint
• Publishing QA Test Summary and Progress on a frequent Interval to Project Managers to highlight any risk/issue that was foreseen.

Confidential, Stamford, CT

Tools: ETL, Informatica, Cognos, Oracle 10g/11g

Onshore Test Lead

Responsibilities:

• Working as a QA onshore Lead for onsite/offshore model and leading a team of 8 members
• Understanding the Business requirement from product owners
• Implementing QA task in all SDLC stages of the project in each sprint
• Reviewing technical design documents for the task created for each requirements
• Analyzing & reviewing the QA Testware for the task created by QA team
• Completing the Testware execution for all tasks within the estimated timelines
• Tracking the each business requirement till the closure of the sprint
• Skilled in preparing Testware environment to execute the Testware scripts
• Potential knowledge in running batch loads using Informatica tool
• Completing the execution of Testware within the estimated timelines
• Responsible for end to end Defect, project tracking
• Extensively worked in Rally tool to update the daily activities of QA team during each sprint
• Identifying the business defects and escalating to project team
• Skilled in tracking the Effort estimation for all the QA team members worked in the project
• Converge data from 22 varied source systems, consolidate and extract reports in the treasury operations
• Validate Data ware house system along with various critical business logics ensuring data movement across various stages via ETL.
• Preparing traceability matrix linking Business Requirements to Functional Requirements to Test Requirements and Test Cases.
• End-to-End QA Test management.
• Preparation and Tracking QA Run book and SIT cycle plan.
• Preparation of Detail Test Plan.
• Reviewing Testware like Test Requirements, Test Scenario’s and Test Cases.
• Defect Management and defect triaging with Business, Dev and Vendor.
• Finalizing the test environment and required Test data set.
• Day Zero checks and Smoke Testing before the start of QA Test Execution.

Confidential

Tools: ETL, Informatica, Cognos, Oracle 10g/11g

Test Engineer

Responsibilities:

• Role includes analyzing BR/FS and performing Gap analysis to identify the Gap’s between BR and FS.
• Have delivered 75+ releases (New ETL Data warehouse components (ETL), Data Migration, Enhancements, New functions, Bug fixes) on success note
• Have tested 90+ Cognos reporting solutions
• Have written 5000+ test cases during my offshore tenure
• Understanding BR/FS decomposing them in Testable functions like Test Scenarios, Test Cases and Test Steps.
• Involved in Test Scope, Run Plan Preparation and performing regression testing in existing functionalities and defect prone areas.
• Preparing SQL Queries required for the execution of test cases.
• Performing Test Execution in HPQC by running the Test Scripts and Cases.
• Provided training for new members of the team in Project execution.
• Involved in the enrichment of Test Scripts based on the release changes.
• Prepared Defect logs, Closure logs and Defect Tracking using HPQC.

Confidential

Tools: CRM DAC, SAP

Process Executive

Responsibilities:

• Analyzing the Purchase Orders.
• Processing of the purchase orders by entering them into SAP Front end application
• Order Confirmation from the purchaser
• Processing the order and sending confirmation and receipt for the processed PO’s.

Confidential

Tools: SQL Developer, JIRA

Test Analyst

Responsibilities:

• Preparing Test Scenarios and Test cases and other Testware.
• Worked with a small team of developers to brainstorm and contribute ideas to build web portals, customize application to be more user friendly.
• Collaborated with the business owner to create a strategy to test and implement the model in creating thin-client GUI for the newly developed systems.
• Prepared Test Requirements, Test Cases and Tractability Matrix.
• Have delivered multiple releases on success note.
• Have implemented 15+ successfully E-leaning, E-commerce and web portal applications.
• Have supported UAT testing and implementation to business.