SUMMARY:

• Confidential has been in the IT Industry for around 8 years 4 months in the areas of Requirement analysis, Design, and testing the applications .
• The activities that he has been performing related to testing data warehouses range from Design, Development and Execution of Test Strategies and managing the above activities.
• He has extensive experience in functional testing methodologies that include Systems Integration Testing, User Acceptance Testing Support, Release Testing and Post Production Validation.
• He has extensive knowledge and experience in implementing Automated Test Execution tools for various Data Warehousing Testing Projects.
• He has a strong knowledge in databases like Teradata, Oracle and is efficient in Data warehousing programming languages like SQL, PL/SQL, UNIX shell scripts, SAS which are required as a part of ETL testing activities and implemented data quality frame work for Data submissions and DW assets.
• Confidential possesses strong leadership qualities, project management skills coupled with a good technical background and, he has performed various test lead activities viz., prepare functional test plan, contribution to test strategy, master test plan, review of SQL queries, test cases & results, defect management, daily & weekly status presentation to offshore / onsite leads, co - ordination with upstream & downstream applications.
• He has received appreciation mails from the client and managers in all the projects he is involved in.
• He is a Confidential Certified Professional in Data Warehousing and Health Care Concepts and certified through IBM on IBM WebSphere DataStage v.8.0 in 2012

STRENGTHS:

• Skilled in Data Warehouse testing strategies.
• Worked on an end to end lifecycle of the product.
• Worked on projects with SDLC model and Agile model.
• Hands-on experience in writing complex SQL queries for testing.
• Excellent knowledge in Data warehousing Concepts and testing at various levels.
• Excellent domain knowledge in the Health Care Industry of U.S.A.
• Expert SQL skills in Teradata, Oracle and MySQL.
• Expert SAS skills to build a regression suite.
• Excellent knowledge in using Defect Management tools viz. HP Quality Center and Clear Quest.
• Led a team successfully all through Requirements Study, Test preparation, Test Execution and Test closure with excellent Communication and Management skills.
• Ability to handle multiple tasks and work independently as well as in a team.
• Building QA automation frame work using SAS, Attacamma and UNIX shell scripts to improve the data quality in data warehousing.
• Proficient in excel macros

TECHNICAL SKILLS:

Operating Systems: Windows 2000/XP/Vista/7, UNIX, CentOS

Databases: SQL Server, Oracle, PLSQL, Teradata, MySQL, Microsoft Access

Data Mining Tools: Attacamma DQC, DQA, XML Spyware, Platinum

Test Management Tools: Rational Clear Quest, HP Quality Center

ETL & BI Tools: DataStage, Informatica, Cognos Reports, SAS EG, BO WEBI, Jasper IReports

Packages: MS Office, Open Office, Visual basic 6.0,Adobe Flex Builder, Adobe Flash Media Server

Programming Languages: C, C++, UNIX Shell Scripting, XML

Scheduling Tools: Autosys

Data Modelling tools: ERWIN

EMPLOYMENT HISTORY:

Confidential

Database: Teradata

Tools: Wherescape Red, Excel VBA, Attacamma DQC, Unix, CA7 Scheduler

Responsibilities:

• He has been involved in preparing and reviewing estimations, creating implementation plans and resource management.
• He has been involving in interactions with the client through various meetings.
• From a QA perspective, he managed all the tickets raised for the issues in the new warehouse.
• He is responsible for the testing activities and its signoff for such tickets in this phase of stabilizing the data.
• He coordinates with the offshore team through regular status meetings and discussions.
• His professional experience and advanced knowledge of the DW System has been an asset to the client. As a QA resource, he was managing the tickets raised for all the data issues identified in the project.
• He has acquired specialized knowledge on the data warehouse technology required for the design, development and implementation of DQ frame work in Attacamma (Data Profiling ).
• He worked on the newly built framework built for validating the data of inbound loads and the existing frameworks for outbound data.
• His expertise on automation frameworks enabled him to work on those validation frameworks with ease.

Confidential

Database: Teradata

Tools: Wherescape Red, Excel VBA, Attacamma DQC, Unix, CA7 Scheduler

Responsibilities:

• He, with his team, worked on MEDICAL CLAIMS, HEALTH MANAGEMENT and PHARMACY CLAIMS domains.
• He was also involved in the test data preparation and its environment management tasks from offshore.
• He has created macros and made use of the in-house applications to automate de-identification of test data that is loaded into lower environments.
• He has been involving in preparing and reviewing the Test strategy, Test plan, Object promotions, Data profiling & coverage analysis, Automations, Test cases, Test scripts, Test results and Test summary.

Confidential

Database: Teradata

Tools: Wherescape Red, Ataccama DQC, MS Excel VBA, Rational CQ

Responsibilities:

• Confidential as an offshore test analyst managed a team of testers at offshore. He has been involving in preparing and reviewing the Test strategy, Test plan, Object promotions, Data profiling & coverage analysis, Automations, Test cases, Test scripts, Test results and Test summary .
• He has been involving reviewing complex SQL queries and shell scripting.
• He used Rational Clear Quest as defect management tool.
• He also reported status to onsite / offshore leads regular basis using dashboards, daily status meetings, and weekly status reports and also involved in tracking the progress, issues and risks in the project.
• His professional experience and advanced knowledge of the DW System has been an asset to the client.

Confidential

Database: Teradata

Tools: Attacamma, Teradata, Unix, and CA7 Scheduler

Programming Languages: SQL and Shell scripting

Responsibilities:

• Confidential as a BI test lead managed a team of testers at offshore. He has been involving in preparing and reviewing the Test strategy, Test plan, Object promotions, Data profiling & coverage analysis, Automations, Test cases, Test scripts, Test results, Test summary and Post Production Support.
• He has acquired specialized knowledge on the data warehouse technology required for the design, development and implementation of DQ frame work in Attacamma.
• He involved in regular discussions with the various Onsite Experts for different healthcare subject areas Membership and Claims to derive the data quality rules using his specialized knowledge on data warehousing.
• Specifically, Confidential involved in analyzing the test data and preparing the DQ plans, DQ work flows, shell script to run the DQ workflows and CA7 job request to run the DQ workflows automatically based on the scheduled/adhoc request.
• Confidential involved in preparing the Production readiness document to migrate the frame to production / live environment.
• He also reported the status to Onsite /offshore leads regular basis using dashboards, weekly status reports, daily status meetings and also involved in tracking the progress, issues and risks in the project.

Confidential

Database: Teradata

Tools: Teradata, Unix and CA7 Scheduler

Programming Languages: SQL and Shell scripting

Responsibilities:

• He has acquired specialized knowledge on the data warehouse technology required for the design, development and implementation of DQ frame work in Teradata / UNIX.
• He involved in regular discussions with the various Onsite Experts for different healthcare subject areas Membership, Claims, Products and Providers to derive the data quality rules using his specialized knowledge on data warehousing. Specifically, Confidential was involved in analyzing the test data and preparing the macro to generate the SQL script for business rules identified and CA7 job request to run the DQ workflows automatically based on the schedule.
• Confidential involved in preparing the Production readiness document to migrate the frame to production / live environment.
• He also reported the status to Onsite /offshore leads regular basis using dashboards, weekly status reports, daily status meetings and also involved in tracking the progress, issues and risks in the project.
• Confidential has monitored performance for automation build in production environment and validated the results which are generated.
• He handles any new changes requested within the current application, which involves design correction or modifications.
• He implemented Excel Marco to prepare the supporting scripts to reduce the implementation cycle time.

Confidential

Tools: Teradata, Business Objects Web Intelligence, HP QC

Programming Languages: SQL, SAS

Responsibilities:

• Confidential as a tester has been involving in preparing Test cases, Test scripts, Test results and Test summary.
• He was reporting the defects using HP Quality Center. The reports were developed using Business Objects Web Intelligence and they were tested for any data issues and format issues.
• His expertise in the tool helped in providing the results in a timely manner and which was bug free.