SUMMARY

• Over 9 years of experience in testing D Warehouse, Database (ETL & BI) for Banking, Insurance, Financial, Retail and Health Care Industries.
• Having Onsite experience of Working at client location in Confidential.
• Extensive experience in ETL/D warehouse backend testing and BI Intelligence reports testing.
• Create and build D Quality Rules and review the metrics results. Worked on Informatica IDQ tool for extensive D profiling.
• Well - versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC). Professional experience in unit testing, Functional testing, system testing, regression testing and User Acceptance Testing (UAT).
• Extensive testing ETL experience using Informatica 9.5 (Designer, Workflow Manager, Workflow Monitor and Server Manager).Validated ETL Informatica mappings.
• Extensive DW Project Experience in various databases and tools like Informatica 9.5, Autosys, Oracle, Terad and Business objects.
• Sound Knowledge and experience in Metad and Star schema/Snowflake schema. Analysed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Expert in Data Analysis, Data Validation, Data Verification and identifying d mismatch from Source and Target.
• Expertise in Business Intelligence Testing by validating report functionality developed, using Business Objects by writing complex SQLs at the backend.
• Expert knowledge in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Created ETL Test Data and coordinated with DBA’s for production d copy to meet the d requirement for all ETL mapping rules as per the business and technical requirements.
• Experience in Defect management Cycle using HP Quality Centre for Bug Tracking and Defect Reporting.
• Experience in preparing Test reports from Quality Centre and prepared Daily Execution status summary report to communicate the test status with the team and Stakeholders.
• Actively involved in User Acceptance Testing (UAT),
• Clear understanding of business procedures and ability to work as an individual and as a part of a team.
• Experience in working with Software Development team in resolving/troubleshooting Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies
• Have Knowledge in Agile, Scrum based implementations.
• Exceptionally organized with great ability to work on multiple projects simultaneously and ability to create synergies within the organization and with clients. Client-Focused, deadline-driven
• Excellent in Quality process and its Methodology. Quality assurance check on all the offshore deliverables.
• Involved in Analysis, Estimation, Preparations, Review and Execution of Test cases, Defect tracking, Delivery activities, Team Coordination and Team Leading activities.
• Conduct Defect triage meeting's supporting business team in UAT and warranty period.
• Preparation of root cause analysis and test summary report.

TECHNICAL SKILLS

• ETL tools: Informatica 9.5, Informatica IDQ, D Stage 8.5,
• BI tools: Business Objects XI, Cognos 10.2,
• DBase: Microsoft Sql Server, DB2, Oracle 10g, Terad 12,
• OS: Windows XP/2000/NT 4.0/Vista, UNIX,
• Testing Tools : Hp Quality Center (QC), Hp Application Lifecycle Management (ALM),Defect Reporting Tools: Clear Quest,

Roles and Responsibilities Details:

Confidential

Responsibilities:

• Analyzing the user specification/Client requirement documentation
• Providing High Level (L0) and Low Level (L1) Estimates based on Test Case Points and planning the resource loading for the project tenure.
• Responsible for preparing and reporting the project status to Client.
• Prepare, Review, and Walk through of Test Strategy, Test Plan.
• Prepare Test Plan by analyzing the Functional and Business Requirements.
• Develop Test scenarios for complex functionalities and give Walkthrough to Business.
• Peer reviewing of the test cases, test scenarios prepared by the team.
• Created ETL test d for all ETL mapping rules.
• Wrote complex queries in Oracle SQL to check the d from Source and Target.
• Conduct Defect Triage meeting
• Conducting design walkthrough to the customers.
• Involved in Change Request Estimation, gathering requirements and estimating it.
• Worked with Business Analysts to define testing requirements to satisfy the business objectives
• Involved in Analysis, Estimation, Preparations, Review and Execution of Test cases, Defect tracking, Delivery activities, Team Coordination and Team Leading activities.
• Preparation of root cause analysis and test summary report
• Performed Source system analysis (SSA) to identify the source d that needs to be moved into the target tables.
• Performed D Analysis and D validation by writing SQL queries.
• Managed the off-shore test teams by delegating tasks to the team and tracked the same.
• Regularly followed up with the development team to discuss the defects identified during testing
• Expertise in validation of report functionality developed, using Business Objects by writing complex SQLs at the backend.
• Co-ordinate with the UAT folks and ensure that there is smooth hand shake between the QA and the UAT teams.
• Participate in the meeting with the front end team to make sure that the d warehouse testing team get the d in time and reduce the lag time without impacting the project timelines.
• Playing the role of QA SME for LOB's and closely working with business to identify the impacted systems and impacts

Environment: D Stage 8.5,Oracle 11g,Autosys,HP ALM, Actimize AML tool

Test Lead,

Confidential, NY State

Responsibilities:

• Create Project plan and set the dependencies of various tasks related to the project.
• Get the project plan reviewed with the stake holders and then pass it on to the team members for the better understanding of the time lines and the target goals.
• Analyze and review the business specifications document.
• Prepare an execution plan for both the development and testing activities of the project and drive them to closure.
• Prepare the release management plan and get that reviewed by the deployment team.
• Involve the requirement discussions and providing resource planning along with the estimates for the Design, and execution of the testing requirements.
• Understand the Business requirements and convert them into technical specifications relative to the project.
• Once reviewed, convert the technical specification document as Test Approach and get an approval on the same.
• Create testing milestones and tracking them to closure.
• Consistently monitor the development activities and answer any blocking issues that hamper the development and may subsequently impact the testing timelines.
• Review the application testing team’s test plan and ensure that there is a smooth hand shake between the DW team and the front end testing team.
• Co-ordinate with the business\d analyst team and ensure that all the business requirements are met and are converted to test cases.
• Create Requirement Traceability Matrix.
• Schedule and Drive the status calls for the better co-ordination between offshore and onshore teams.
• Schedule calls with the development team and bring everyone onto one page of understanding
• Participate in meetings with the end client to provide the project status and provide inputs to address any concerns.
• Creating defect triage spreadsheets, project testing metrics and sharing the same with the client.
• Conducting lessons learnt sessions at the end of the project and document the key takeaways and make sure that these are followed\implemented for the next release.
• Co-ordinate with the UAT folks and ensure that there is smooth hand shake between the QA and the UAT teams.
• Participate in the meeting with the front end team to make sure that the d warehouse testing team get the d in time and reduce the lag time without impacting the project timelines.

Environment: Informatica 9.5,Oracle 10g,Autosys,HP ALM, Unix, Cognos .

Test Lead,

Confidential,

Responsibilities:

• Create Project plan and test strategies for all the ETL testing and Report testing projects.
• Involve the requirement discussions and providing resource planning along with the estimates for the Design, and execution of the testing requirements.
• Schedule and Drive the status calls for the better co-ordination between offshore and onshore teams.
• Schedule calls with the development team and bring everyone onto one page of understanding
• Participate in meetings with the end client to provide the project status and provide inputs to address any concerns.
• Creating defect triage spreadsheets, project testing metrics and sharing the same with the client.
• Conducting lessons learnt sessions at the end of the project and document the key takeaways and make sure that these are followed\implemented for the next release.
• Co-ordinate with the UAT folks and ensure that there is smooth hand shake between the QA and the UAT teams.
• Participate in the meeting with the front end team to make sure that the d warehouse testing team get the d in time and reduce the lag time without impacting the project timelines.
• Develop Test scenarios for complex functionalities and give Walkthrough to Business.
• Peer reviewing of the test cases, test scenarios prepared by the team.
• Created ETL test d for all ETL mapping rules.
• Wrote complex queries in Oracle SQL to check the d from Source and Target.
• Involved in Change Request Estimation, gathering requirements and estimating it.
• Worked with Business Analysts to define testing requirements to satisfy the business objectives
• Involved in Analysis, Estimation, Preparations, Review and Execution of Test cases, Defect tracking, Delivery activities, Team Coordination and Team Leading activities.
• Preparation of root cause analysis and test summary report
• Performed Source system analysis (SSA) to identify the source d that needs to be moved into the target tables.
• Performed D Analysis and Data validation by writing SQL queries.
• Managed the off-shore test teams by delegating tasks to the team and tracked the same.
• Regularly followed up with the development team to discuss the defects identified during testing
• Expertise in validation of report functionality developed, using Business Objects by writing

Environment: Informatica 9.5, Terad, Business Objects, Autosys, Unix

Confidential .

Responsibilities:

• Create Project plan and test strategies for all the ETL testing and Report testing projects.
• Involve the requirement discussions and providing resource planning along with the estimates for the Design, and execution of the testing requirements.
• Schedule and Drive the status calls for the better co-ordination between offshore and onshore teams.
• Schedule calls with the development team and bring everyone onto one page of understanding
• Participate in meetings with the end client to provide the project status and provide inputs to address any concerns.
• Creating defect triage spreadsheets, project testing metrics and sharing the same with the client.
• Participate in the meeting with the front end team to make sure that the d warehouse testing team get the d in time and reduce the lag time without impacting the project timelines.
• Execute the intended work flows from Informatica and monitor and troubleshoot the error through Informatica or Autosys logs
• Validated DB Links shared by SMEs that exist between 9i instances & warehouse are created between 11g & warehouse are working fine.
• Ensured D consistency check by writing queries and comparing with source dbase instance
• Validated Informatica connection changes, Synonyms and Stored Procedure check to make sure warehouse job run is successful.
• Validated 100 + BO reports against the BRIO Reports for format, Lay Out, Report Prompts/Filters its behavior and correctness of D by writing excel macros (Excel comparator)

Environment: Informatica 9.5, Oracle 9i, Business Objects 3.1, Brio 8.0.Client: Confidential Duration.

Confidential,

Responsibilities:

• Working Closely with Business, DW BA’s in finalizing the DW prioritization List for the D warehouse related ETL and Reporting PPM’s for the Monthly/Quarterly Releases based on available QA Effort
• Providing Estimates based on PPMs in hand and planning the resource allocations
• Responsible for preparing and reporting the project status to Client for each planned releases.
• Working with business and BA’s to give walkthrough on end results
• Conduct Defect Triage meeting
• Peer reviewing of the test cases, test scenarios prepared by the team.
• Involved in Analysis, Estimation, Preparations, Review and Execution of Test cases, Defect tracking, Delivery activities, Team Coordination and Team Leading activities.
• Playing the role of QA SME for LOB's and closely working with business to identify the impacted systems and impacts
• Coming up with real time and business scenario to make sure the all the requirements are achieved.
• Translate Functional Specifications and D Mapping specifications into effective Test cases
• Building the complex Sql Server Sql queries to implement the transformation rules and business rules specified in the functional requirements.
• Involved in Client Interaction and Knowledge Transfer sessions.

Confidential

Responsibilities:

• Analyzing the user specification/Client requirement documentation,
• Compilation, Validation, Execution and monitoring the jobs through D Stage.
• Prepared detailed test scenarios and test cases covering all the mappings.
• Peer reviewing of the test cases prepared by the team.
• Test d preparation.
• Execution of test cases and defect tracking,
• Logging Defects in Quality Control.
• Preparation and Execution of Regression Test Cases.
• Writing SQL Queries for Dbase validation.
• Collaborate closely with the Business Analyst Team to come up with strategies for generating reports using the Probe tool (Client specific tool).
• Analyze the Users queries and generate the corresponding reports using Probe tool.
• Make a summarized analysis report on the generated Reports and send them across to business in all the Data marts Applications.
• Validate Cubes in both Stage and production environments.
• Use Probe tool and generate the monthly, quarterly and annual reports on various client subject areas like Personal Lines Auto (PLA), Property Experience Mart (PEM), Home Owners Frequency and Severity (HFS) and Auto Frequency and Severity (AFS).
• Perform the Reconciliation between the d marts and the probe tool in all the subject areas like PLA, PEM, HFS and AFS.
• Feed the Stake holders with the trend analysis reports quarterly using the Probe tool in various client subject areas.

Environment: Teradata, PCOM, Unix

Quality Assurance Analyst

Confidential

Responsibilities:

• Understanding the overall functional and business requirements and knowing the details of the work requests in each release.
• Preparing test plan and test cases.
• Translate Functional Specifications and D Mapping specifications into effective Test cases.
• Building the complex Teradata SQL queries to implement the transformation rules and business rules specified in the functional requirements.
• Perform Testing as per Quality Standards.
• Writing SQL Queries for Dbase validation.
• Following defect life cycle (starting from creation of defect to closure with resolutions).
• Using BI Work Request DB tool to keep track of the requirement changes and report timesheets to the client.
• Involved in Client Interaction and Knowledge Transfer sessions.
• Perform Testing as per Quality Standards.
• Validating cubes.
• Writing SQL Queries for Database validation.
• Following defect life cycle (starting from creation of defect to closure with resolutions).
• Use Rational Team Consort (RTC) to update the status daily.
• Use Hp Application Life Cycle Management (ALM) tool to keep track of all the QA artifacts, test results and the Sql queries.
• Send an official sign off notification to the stake holders once the changes are successfully tested in the Production.

Environment: D Stage, Cognos, Oracle PL/SQL, UNIX Shell Scripts, SQL Server