Test Consultant

Jagadish Dharamanna

Contact No: 503-***-****

Email: acwaz2@r.postjobfree.com

Solution Delivery Analyst

Seeking a Senior Analyst position with a reputed organization that will strategically utilize my Data Warehouse (DWH) testing skills and also provide me a platform to accomplish my professional goals

Professional Summary

Good Experience in Testing as Technical Test Lead, Test Consultant, SR. Test Analyst, Data Analyst and involved in Test Deliverables like Test Plan, Test Strategy, Test cases and Test Completion report.

Overall 10+ Years of Experience in Data warehouse/ETL/BI testing and implementation on various domains and technologies

Test Lead, providing End-to-End QA solutions for Large volume data intensive projects

Strong understanding of Agile Scrum and waterfall SDLC methodologies

Expertise in BI Testing with various tools like BO, Cognos etc.

Data Integration Testing of various source systems

Experience in Functional, Regression and System Testing.

Good Experience in managing the complete SDLC for a Medium/Large development/Maintainenece project right from working on RFP’s, estimate etc.

Experience in writing, reviewing and executing test cases as per the client process

Preparation of test documents, Test execution & Defect Reporting.

Preparation of Test strategy/ Test plan documents.

Good experience in data bases like Oracle,DB2,Terradata and MS access

Good experience in HP quality center

Good experience in Retail, Insurance and Banking domains

Coordinated the Onsite and Offshore teams to resolve issues

Very good Knowledge on Data warehousing Concepts, Design, Implementation and Maintenance.

Good knowledge of SDLC & Defect Tracking Life Cycle

Good Team player with excellent communication, interpersonal, demonstrating skills, problem Solving and Leadership Qualities

Experience in Requirement gathering

Experience in Defining and implementing the role testing plays within the organizational structure.

Experience in Defining the scope of testing within the context of each release / delivery.

Experience in Deploying and managing the appropriate testing framework to meet the testing mandate.

Experience in Planning, deploying, and managing the testing effort for any given engagement / release Education/Certifications

Bachelor of Engineering from Vishweshwaraih Technological University

Basic Program Management

Test Consultant

Areas Of expertise

Project Management

Delivery Management

New Initiatives

Process Management

Technical Expertise

Technology Skills

Databases Oracle 10g/9.2 /8.1.7, Teradata, DB2,MS Access Operating system Windows NT/XP/2000, UNIX, Linux

Languages C, SQL, PL/SQL

Tools

SQL Developer, Toad, Mercury Quality Center, Informatica PowerCenter, Datastage, Autosys, SAS – Merchandise Intelligence, cognos, HP ALM, JIRA Domain Retail, Insurance, Banking, Health care

Employment History

Company Name Designation Duration

Wipro technologies

Test Consultant /Test

lead /Project lead

Dec 2010 - Current Date

STC ThirdEye Technology Private Ltd.

Chennai

Test Lead Sept 2010 - Dec 2010

Infyte Infotech Pvt Ltd, Bangalore

Senior Software

Engineer

Apr 2007 - Feb 2009

Open solutions, Bangalore Software Engineer June 2005 - Apr2007 Chronology of Experience:

Project : Nike SAS Markdown Optimization

Duration : October 2012 to current date

Tools used : SQL Developer, Informatica, UNIX, SAS, HP ALM Description of the Project

SAS Markdown Optimization (MDO) is a complete solution that enables you to determine which products to mark down, how much to mark down, when to mark down and at which locations. Markdown optimization also monitors the performance of past and ongoing activities against financial and operational goals. MDO provides markdown pricing schedules for EMEA products at the end of their life cycles as they are cleared off of their inventory.

Responsibilities

Requirement gathering.

Preparation of test strategy, Test plan and test estimates

Track and prepare the report of testing activities like test testing results, test case coverage, required resource, defects discovered and their status, performance baselines etc.

Test Consultant

Organize the status meeting and send the consolidated status report across location daily to the client.

Co-ordinate with development team in fixing of QA defects

Assign task to Testing Team members and ensure to keep a track on the same.

Escalate the issues about project requirements if any( Software, Hardware, Resource ) to Project Manager/ SR. Test Manager

Ensure the timely delivery of different testing milestones.

Preparation of test data, test cases, test scenarios and test execution

Tracking of defects using Quality Center and Jira

Review software design, change specifications, and plans against contractual and/or process requirements.

Defining the scope of testing within the context of each release / delivery.

Deploying and managing the appropriate testing framework to meet the testing mandate. Project : CELL ID PHASE III

Client : Optus Technology

Role : Test Lead

Duration : 8 Months

Domain : Telecom

Tools used : Teradata, Abinitio, UNIX, Cognos, HP ALM Description of the Project

The Testing for Cell ID phase 3:

Release was broken down into below streams:

Application and Integration testing - conducted at SRDM to CRDS, CRDS to LELU/HUD, GSMIS to Peach, XACCT to IDW, GSMIS to IDW, SRDM to IDW, CRDS to Insight Plus, CRDS to ACE and TAS, SRDM to XACCT and DCS, XACCT to ARBOR, SRDM to Arbor,

IDW –Extract generated from SRDM, GSMIS, XACCT and DCS Responsibilities

Preparation of Test plan.

Preparation of Estimate for the time, resources and budget required to perform the testing.

Organize the testing kick-off meeting

Track and prepare the report of testing activities like test testing results, test case coverage, required resource, defects discovered and their status, performance baselines etc.

Organise the status meeting and send the consolidated status report across location daily to the client.

Keep track of the new requirements / change in requirements of the Project.

Co-ordinate with development team in fixing of QA defects

Assign task to Testing Team members and ensure to keep a track on the same.

Ensure the timely delivery of different testing milestones.

Preparation of test data, test cases, test scenarios.

Execution of the same for integration, system and sanity testing.

Tracking of defects using Quality Center

Involved in Meetings with developers, clients and onsite co-ordinators

Involved in status call, discussing defects found with Offshore and Onsite Team.

Attend the regular client call and discuss the weekly status with the client. Test Consultant

Project : LBG-GOLD-FLEX-MASTER

Client : Lloyd’s Bank Plc

Role : TEST LEAD

Domain : Banking

Tools used : Teradata, Datastage, UNIX, QC

Description of the Project

The GOLD program is a 3 year initiative approved by the Group Strategic Review that will deliver tangible business benefits and will drive incremental value year on year. GOLD Release 1 requirements consist of 6 initiatives/work stream.

Introduce a new feed into GRID of Motor Insurance data and then make this data available in ACUMEN. Report for GDW to implement a solution for loading monthly balances and accruals data for retail customer in to GRID. Create a process to classify the ongoing (current) and historical (one-off) HBOS Credit Card transactions and integrated with the existing TCS process and data. In addition to that, this will also provide adjustments to new manual amendment of classifications.

Responsibilities

Preparation of Test strategy/ Test plan documents.

Preparation of factory document.

Preparation of effort estimation.

Track and prepare the report of testing activities like test testing results, test case coverage, required resource, defects discovered and their status, performance baselines etc.

Organise the status meeting and send the consolidated status report across location daily to the client.

Co-ordinate with development team in fixing of QA defects

Assign task to Testing Team members and ensure to keep a track on the same.

Escalate the issues about project requirements if any( Software, Hardware, Resource ) to Project Manager/ SR. Test Manager

Ensure the timely delivery of different testing milestones.

Preparation of test data, test cases, test scenarios.

Execution of the same for integration, system and sanity testing.

Tracking of defects using Quality Center

Involved in Meetings with developers, clients and onsite co-ordinators

Involved in status call, discussing defects found with Offshore and Onsite Team.

Attend the regular client call and discuss the weekly status with the client. Project : GHM GTB ETL Upgrade & WFM Upgrade

Client : Duns and Bradstreet

Role : Senior Test Engineer

Domain : Healthcare and Services

Description of the Project

D&B has built a Global Hygiene and Match system (GHM) for IBM. IBM transmits data in daily, weekly and monthly batches to D&B. This data is loaded to Customer Copy Database (CCDB) and match keys built for each of these records are stored in the Custom Match Repository (CMR). Data is cleansed, standardized and matched against D&B’s corporate repository. Currently D&B uses Informatica for ETL and it has decided to upgrade Informatica from version 7.1 to 8.6.

Workflow Manager (WFM) within the Global Hygiene Match (GHM) System was built on a See Beyond platform and D&B’s license for this software expires in December 2011. It has decided to Migrate WFM from See beyond to Oracle BPEL

Test Consultant

Responsibilities

Involved in Preparation of Test strategy/ Test plan documents.

Preparation of test data, test cases, test scenarios.

Execution of the same for integration, system and sanity testing.

Tracking of defects using Quality Center

Involved in Meetings with developers, clients and onsite coordinators

Monitor Batches through the internal GUI Portal.

Report Job Errors to the concerned teams and track the issue.

Prepare Reports on Pre and Post Informatica up gradation based on different batches.

Involved in status call, discussing defects found with Offshore and Onsite Team.

Involved in preparing performance Matrix during Performance testing.

Query through SQL with respect to Issue codes for different batches.

Backup jobs through UNIX for all the batches for checking the performance testing.

Performed manual Testing (Functionality, GUI Testing). Projects

From June 2005 till Dec 2010 worked on multiple projects on data warehousing testing, manual and automation

Contact this candidate