Objective

• Software professional with 17 years of progressive experience in QA and project management.
• Extensive background in designing and implementing test strategies, operational procedures and test methodologies to support the development and release of business critical applications.
• Extensively involved in testing Data warehouse, Data Migration, Master Data Management, Client/Server and Web application projects having various complex ETL logics, transformations and reports.
• I have always delivered projects consistently ahead of deadlines, exceeding the defined quality and performance.

SUMMARY

• 17 years of experience in Data Warehouse (Data Stage, Informatica) and Database Migration Testing.
• Excellent Knowledge of Data Warehousing concepts including dimension modeling (Star and Snow flake schemas) and slowly changing dimensions.
• Led the planning and execution of initial QA release of full scale IBM Infosphere Master Data Management (MDM) project for a reputed bank in USA
• Managed and delivered the first ETL Agile testing project for a reputed bank in USA.
• Expertise in handling multiple projects simultaneously at Onshore and Offshore model.
• Extensively worked on backend SQL and PL/SQL scripts to test the Data warehouse ETL flow, Data Reconciliation, Initialization, and Change Data Capture, Delta Processing, Incremental process.
• Oversee data mapping and migration of data warehouse projects including source to target mapping rules, data validation rules, data quality rules, data cleansing rules, business transformation rules and metrics etc.
• Extensively worked on databases including in Oracle, SQL Server, Netezza, DB2 and Teradata.
• Experience in mentoring and executing ETL projects such as Informatica, Cognos, CA Autosys and SSIS.
• Report testing experience on Cognos ReportNet and OBIEE.
• Proficient in developing Test Strategy and Test Plan, Risk Mitigation strategies, Root Cause Analysis and Contingent plans and Project Completion Reports
• Experience in working on RFP’s and Effort estimations for the Data warehouse, MDM, Report, DB Migration testing projects
• Responsible for gathering business requirements, analyzing business needs and participate in the delivery of technical solutions to complex business and technical requirements.
• Extensive experience in preparing and executing of test cases for various phases of testing such as ST, SIT, UAT, OAT
• Expertise in generating test reports, defect reports from HP ALM with good experience in reporting Daily, Weekly, Monthly Status & Review reports to Senior Management and Client.
• Keen understanding of Bug life cycle and experienced in HP ALM/QC, JIRA and confluence.
• Around 8 years of onsite experience in client facing roles.
• Hold regular team meetings to determine progress and address any questions or challenges regarding projects requirements, blocking issues and progress.
• Extensive experience in large transformation program like Anti - Money Laundering, Mortgage Upgrade in banking and financial industry.

TECHNICAL SKILLS

Data Warehousing: COGNOS decision stream 7.1, Informatica, SQL Server 2005 Integration Services (SSIS), TOAD 7.2, CA Autosys, Unix, IBM MDM, OBIEE, SQL Assistance, Oracle SQL Developer, Putty, winSCP, JASON, XML spy, AXIOM SL

Databases: MS Access, MS SQL Server, Microsoft SQL Server 2005 Beta 2, NCR Teradata, Oracle, Oracle Exadata, Netezza, Snowflake, Aurora, IICS

Defect and Test Management and other Tools: HP Test Director 8.0, Bugzilla, PVCS Tracker, Mercury Quality Center, HP ALM, Perforce, JIRA, Rally, Jenkins, AWS S3, AWS EC2, Spark, DBeaver

Verticals: Banking & Finance, Insurance

PROFESSIONAL EXPERIENCE

Confidential, NC

Tools: HP ALM, Rally, DBeaver, IICS, Jenkins

Test Manager

Responsibilities:

• Practice agile principles and collaborate with an Agile/Scrum environmentwith QA Engineers, Product Owners, Scrum Masters, and Dev leads.
• Participate in regular agile ceremonies such as program increment planning, daily stand-ups, backlog grooming, iteration retrospectives, team demos
• Coordinate with the Business Analyst, Scrum and development teams on any clarifications, requirement changes for multiple concurrent projects within GDW.
• Prioritize the CR’s and develop the schedule for upcoming QA releases.
• Identifying and resolving execution hurdles, especially across teams and cross-functional work streams.
• Coordinate data cycles between multiple work streams in both INTEG and SIT environments.
• Triage and manage the defects/issues and prioritize as per the release calendar.
• Coordinate with Dev leads to deploy changes into SIT and UAT environments.
• Facilitate data loads into test environments via Autosys or IICS jobs on need basis.
• Co-ordinate and monitor the offshore deliverables for multiple concurrent projects
• Facilitate build migration to higher QA regions on need basis across various pipelines.

Confidential, RI

Tools: HP ALM, Rally

Test Consultant

Responsibilities:

• Understanding the functional specifications.
• Perform the regression testing of multiple releases.
• Coordinate with the project and development teams on any clarifications, requirement changes.
• Develop SQL queries to retrieve data for validation purposes
• Issue/Defect resolution and Status Reporting.

Confidential, RI

Tools: IBM Infosphere MDM, ETL DataStage, JSON, OBIEE, Perfaware, JIRA, HP ALM

Test Manager

Responsibilities:

• Review business requirements, functional specifications, ETL data mapping and provide ROM, SMC testing estimates.
• Estimate and obtain management support for the effort, resources and budget required to perform the testing.
• Set knowledge transfer session with business user and authored MDM member locator portal user manual
• Collaboratively define the end-to-end test strategies for functional, integration, performance and User acceptance testing
• Develop detailed Test Plan which clearly documents testing scope and approach for SIT and UAT phase of testing including various types of testing performed in each test region and cycles.
• Conduct walkthrough on the Test plan, Test Readiness review documents to the MDM project and business team
• Assisting test engineers, analysts on Test data preparation which meets the test scenarios and review them.
• Mentor the team in preparing the test cases for checking the population of data correctly into fact and dimension tables as per the design and ETL mapping specifications.
• Monitor and Structure the daily test execution to meet the project timeline.
• Functionality testing of email notification in DataStage job failures, abort or data issue problems.
• Performed sample data quality analysis for the 4 future inbound feed. Further refine the scope of work for phase 2.
• Contributed in Test Case development session and authored MDM reporting module test cases.
• Worked as project coordinator facilitate between MDM technical implementation team and MDM operation support team, developed MDM data quality operation support user guide.
• Conducted knowledge transfer session with new data stewards hired.
• Coordinate with the project and development teams on any clarifications, requirement changes.
• Document, implement, monitor and enforce all client processes for testing as per standards defined by the organization
• Triaging the defects to make sure the defects has enough information for developers and has sensible “Severity” and “Priority” fields, Capture the Root cause and the defect Target Resolution date.
• Keep track of the new requirements / change in requirements of the Project.
• Escalate the issues about project requirements to Project Manager.
• Manage test cases, traceability to requirements and defects in HP ALM
• Provide knowledge transfer on the key components like Data standardization, suspect and collapse processing, DSUI and Error handling techniques to offshore test team
• Work closely with software development engineers to develop and implement manual and automated tests
• Collaborate with Business Teams to define UAT Test plan.
• Ensure all sign offs on deliverables are received to go to Production (overall test strategy, test plan, test cases, test completion reports.).
• Managed offshore QA resources for ensuring timely project deliverables and completion.
• Attend the daily scrum calls, product backlogs, brainstorming sessions and demo in CPR project.
• Discuss with offshore team on the daily deliverables and ensure they are tracked and closed as per the sprint cycles.
• Responsible for monitoring and prioritizing the defects and coordinating the build deployments for defect fixes responsible for overseeing the team including metrics, daily defect status reporting and close integration
• Performed Database, ETL, Alerts, JASON, Web services using soapUI and batch job validations on need basis and reporting.
• Prepare, review and seek approvals on the Test completion report

Confidential

Tools: DataStage ETL

QA Manager

Responsibilities:

• Led a high performing software testing team of 22 personnel for big Oracle data migration testing project.
• Involved in attending high level meetings for Non-TS applications
• Developed project plan, estimation of multiple CR in NON-TS space and task prioritization
• Created comprehensive system test plans that include resource requirements, schedule assumptions
• Discuss requirements and scheduling with project teams to ensure the timely, accurate, and effective completion of project deliverables
• Conduct formal test case review sessions with project team and in corporate feedback
• Identifying and tracking risks and follow-up on issues with all teams to a closure in Clarity and setting mutually agreeable time lines
• Responsible for producing evidence of completion for all line items on the requirements traceability matrix (RTM) requiring quality assurance review
• Develop SQL queries to retrieve data for validation purposes
• Plan and schedule all QA deliverables during project lifecycle

Confidential

Tools: CA Autosys, UNIX, SunGard’s GMI, JIRA, Confluence

Test Manager

Responsibilities:

• Review business requirements, functional specifications and gathering application knowledge from business analysts, designers and developers to identify and understand the project needs.
• Preparations of Effort Estimate and QA sizing.
• Preparation of Test Plan and Test Plan walkthrough to the Project Stake holders
• Analyzed market data feeds for Equity and Fixed Income related feeds from various systems like SunGard’s GMI application.
• Enrich the data with reference data management thereby applying the business logic
• Analysis of the test cases for feasibility to automate
• Automated the GET LOAD REPORT process with Perl script to execute the jobs in lower test regions.
• Entered the defects into JIRA and manages the resolution and documentation of these defects.
• Performed test data analysis including finding, modifying, and creating test data
• Monitored jobs in Autosys for QA during the peak testing phase
• Organized the meetings, reported the progress to client management and escalated issues.
• Drive defect Triage Meeting and conduct root cause analysis with developers and business team.
• Support Business users during UAT testing.
• Publish Rejected Defect Analysis, UAT defect Analysis, Lessons Learnt and Test Summary Report at the end of release.
• Testing the new change requests coming from Production system and other downstream applications.
• Test sign-off and process control.

Confidential

Tools: AXIOM

Test Manager

Responsibilities:

• Identifying the roles and responsibilities of multiple teams involved in the project.
• Managed both the client and the vendor partners in UK and Netherlands.
• Played the Test Consultation role and streamlining the test process.
• Axiom SL application for regulatory reporting
• Preparing the system integration test plan
• Preparing the operational acceptance test plan.
• Managing all the test phases from SIT, ST, UAT support, NFT and OAT.
• Managing the test team located at Netherlands and Edinburgh.
• Interacting with the client technology services and the business team
• Identifying the risks, issues, and tracking them with timely escalations.
• Knowledge management of all the test process like Oracle data-pump from one environment to another.
• Reviewing the Test deliverables.
• Interacting with the AXIOM vendor during implementation in resolving the issues
• Maintained Axiom Components including Portfolio, Aggregation and Workflow.
• Coordinating with Global Infrastructure Services (GIS) team during OAT.
• Conducting weekly meetings with all the stakeholders.
• Tracking the status with weekly status reports and Minutes of Meetings (MOM)
• Chasing the defects and issues to resolution.
• Preparing the test completion report.
• Understanding of the scope of the R3
• Preparing the Programme level OAT test strategy
• Providing inputs to the change control board/ project control committee

Confidential, St,Paul, MN

Tools: Wipro Gallagher Solutions, Informatica

Test Lead

Responsibilities:

• Analyzing the business requirement.
• Preparing the Test cases
• Reviewing the Test documents.
• Test Execution
• Defect logging and defect tracking using Mercury Quality Center.
• Interacting with the client
• KT on the project to the new clients
• Updating the status of the deliverables to the Client Project Managers on daily basis.

Confidential, Seattle, WA

Tools: Informatica, Cognos Decision Stream, Cognos ReportNet, CRN- Seibel, TOAD

Module Lead

Responsibilities:

• Requirement analysis and understanding of the CORT application.
• Analyzing the Change Requests (CR) and/or Production Support Ticket (PST).
• Analyzing the addition of new column in the CRN-SIEBEL application
• Analyzed the Functional requirements using Scenarios & DDD (Detailed Design Document)
• Written Test Cases for ETL data flows to compare Source, staging and Target database systems.
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Validating the Archive process to purge the data that meet the defined business rules.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Union in Oracle.
• Check the naming standards, data integrity and referential integrity.
• Tested the Slowly changing dimension columns
• Testing of records with logical delete using flags
• Identify the primary key (logical / physical ) and put update or insert logic
• Executing and monitoring Informatica jobs and validate the successor and predecessor jobs.
• Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
• Accessed to Informatica session log files to find the root causes for logical bugs
• Generated the detailed reports of the Bugs, go no go reports and comparison charts.
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
• Defects tracking, review, analyze and compare results using Quality Center.
• Worked with development team to ensure testing issues are resolved based on using defect reports
• Prepares and submit the summarized audit reports and taking corrective actions
• Upgrading the Cognos Decision Stream 7.1 with the new catalog thereby checking the ETL connections from Source table-Mappings-Target table for the affected build/ Job stream.
• Entering the test data in the front-end application i.e. in SIEBEL 6.0.
• Data validation in source (Siebel), staging and target (DWH) tables using TOAD 7.2.
• Checking the Reports (in COGNOS Report Studio).
• Tested ad hoc and canned reports for Business objects.
• Tested reports for various portfolios using universe as the main data provider.
• Tested both the regular and Ad-hoc reports using COGNOS Report Studio functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, DrillDown etc.
• Validated the ETL Scripts in the Target Database (Oracle) for creating the cube before migrating it to SQL Server.
• Validated the OLAP cubes generated in Oracle Environment.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.

Confidential

Tools: Imaging software, TestComplete 3.0, Bugzilla

Product Test Engineer

Responsibilities:

• Understanding Functional specification document of iMagic.
• Involved in preparing Test Cases based on Functional Specifications
• Involved in Functional and Regression Testing.
• Executed the scripts manually and automated using Test Complete 3.0
• Defect Tracking and Reporting using Bugzilla.

Confidential

Tools: .Net

Test Engineer

Responsibilities:

• Understanding Functional specification document
• Preparing high level test scenarios
• Preparing Test Cases using Black box testing techniques.
• Executing test cases manually.
• Bug reporting using bug template
• Daily Status reporting.