SUMMARY:

• Having 5 years of IT experience in Data warehousing /Database / ETL / Report Testing
• Experienced in onshore(USA) - offshore(India) model
• Experienced in communication with upstream and downstream project teams for integration testing
• Experienced in performing integration testing and resolving issues from onshore
• Expertise in Datawarehouse testing by writing complex sql’s and ETL Testing by using Abnitio
• Good Experience in Teradata Warehouse and Teradata SQL
• Good Exposure in Teradata Utilities such as Multiload, Fast Export, etc.,
• Good Knowledge in running teradata table load using shell scripting from Unix
• Expertise in using BI Reporting Tools - Microstrategy and Cognos
• Good Exposure in running Mainframe Jobs for preparing VSAM files to ETL load and VSAM file preparation for ETL load
• Trained in Date warehousing / Reports / ETL Tools from Cognizant Technology Solutions, India
• Good Knowledge about different types of transformations and mappings process in Abinitio ETL tool
• Have undergone end to end life cycle of Data warehouse testing and also having clear Understanding of DWH concepts
• Proficient in QA Methodologies and able to conduct end to end testing for any application
• Experience in various type of testing like Integration Testing, User Acceptance Testing, Functional Testing, Regression testing, Performance testing.
• Experienced in Technical & Managerial aspects like preparation of Project Related documents like Test plan, Business Assurance Strategy(BAS) document, Test Approach Document, Test Exit Report, Dash Board, DSR (Daily Status Report), DTER (Daily Test Execution Report) status Reports
• Ability to provide Test Estimation for any project with clear break-up of tasks
• Creation and execution of detailed test cases to verify software functionality and adherence to Business requirements
• Excellent interpersonal, project management, communication and documentation skills
• As a QA Analyst, proven analytical and problem-solving skills to validate IT/Business processes through careful test data creation, Test cases and test plan
• Good exposure of automated testing tool-Quick Test Professional(QTP) and Quality tool - Quality Center

TECHNICAL SKILLS:

ETL Tools: Abinitio using UNIX

Business Intelligence Tools: Microstrategy, Cognos

Database: Teradata, Oracle

Test Management Tool: Mercury Quality Center

Bug Tracking Tool: Mercury Quality Center

Testing Tools: Quick Test Professional

Database Interface Tools: Teradata SQL Assistant, SQL Developer, Mainframe

Database languages: SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Hartford, Connecticut

Offshore Lead

Responsibilities:

• Responsible to maintain Quality Center up to date and provide correct status to customer
• Responsible to prepare test timelines, milestones and tracking the same on daily basis
• Responsible to review deliverables received from offshore and getting those reviewed with customer
• Responsible to communicate and support integration testing teams(upstream and downstream project team) over integration testing/ meetings
• Provide technical support to offshore team in System/Regression testing
• Schedule reviews with customer/project team and seek their approval for System/Regression test deliverables like BAS(Business Assurance Strategy),Test Cases and Test Results
• Responsible to perform pre-requisite checks for any System/Integration/Regression testing
• Responsible to involve in Integration test execution from onshore using UNIX, DB2, TERADATA and communicate the updates/issues to integration teams.
• Responsible to create the Test Strategy document for each story in the Rally
• Responsible to validate input table/files, lookup files, Target files.
• Responsible to raise and to track the defects in Quality Center tool
• Responsible to attend Daily standup, Rally Update

Confidential

Offshore Lead

Responsibilities:

• Responsible to prepare end to end test strategy and test plan starting from upstream Input to Data warehouse, Datamarts, Analytics and Reporting
• Responsible to monitor offshore team tasks and to coordinate/guide offshore team members on both technically and project management perspective
• Responsible to attend requirement walkthrough calls and to define test scope and test strategy from offshore
• Responsible to give walkthrough on test approach, test conditions, test cases to customers from offshore
• Responsible to prepare daily status report, weekly status report, risk and mitigation plans and share the same to onshore coordinator
• Responsible to conduct knowledge sharing session on UNIX/DWH/SQL/BI and to continuously motivate the offshore team members
• Responsible to mock up the data(entering test data) according to theS2T(Source to Target) mapping
• document
• Responsible to validate the data load in Teradata tables as per the mapping specification document
• Responsible to review test cases and to map requirement/defects to test cases in Mercury QC
• Responsible to create SQL queries based on the S2T document
• Responsible to validate the various SCD(Slowly Changing Dimensions)type scenarios data between
• Source Clean files(in Unix) and the target database(Teradata) as per the requirements

Confidential

Technical Lead

Responsibilities:

• Responsible to analyze and review the DWH/BI Project requirements documents(BRD,FSD,TDD).
• Responsible to create the Test Strategy document and Technical testing approach
• Responsible to create Complex SQL queries based on the requirement document(BRD), mapping specification document (FSD)
• Responsible to do balance reports testing between datawarehousing, datamarts and reports
• Responsible to validate COGNOS Reports according to the requirements.
• Involved in Triage and Client Meetings.
• Involved in reviewing test cases and writing test cases as per business customer testing
• Responsible to raise and to track the defects in Quality Center

Confidential

QA Analyst

Responsibilities:

• Testing the application as per the mapping specification document
• Writing complex SQL Queries as per mapping document
• Testing Business reports using Cognos and Microstrategy
• Providing status report to offshore lead
• Reporting Defects in Quality center and maintaining RTM in Quality Center