SUMMARY

Over 7+ years of experience in Information Technology, BI reports and Dashboards development and Testing, Quality Assurance Testing, Analysis, Validation and Documentation of Web Based, GUI, ETL and BI applications. Expertise in the domains of Pharmaceutical, Insurance, Banking, Retail and Financial systems.Automation testing using tools such as Load Runner and QualityCenter. Writing and executing test plans and test cases in highly structured and loosely structured development environments and performing all types of testing (Functional, Performance , ETL Testing, BI Testing).

• Worked for Fortune 500 companies like Liberty Mutual, Bank of America, Exxon Mobil, Brinks etc.
• Expertise in the development of Test Plans and Test Scripts for ETL Testing.
• Good working experience in the Development and Testing of Reports and Dashboards using Micro Strategy.
• Vast experience in the deployment of Public and Schema objects across the environments (Dev, Test and QA) in Micro Strategy .
• Vast experience in the analysis of Performance Test Results. Consolidating the performance test results and sharing with stake holders( Business Users, Senior Management, Dev and QA teams)
• Good experience in testing the ETL applications developed using Informatica.
• Good experience in understanding the EDW applications.
• Has good working experience with Performance tools like Load Runner.

• Good working experience in SQL and PLSQL.
• Developed sql test scripts to validate EDW applications (ETL Testing).
• Experience in Agile development model.
• Attending Project Planning, Design Review, JAD Sessions, Test Planning and Status review calls and providing the Metrics reports to the Project manager on Project Status.
• Extensively worked with Business teams/Dev teams in defect resolution and for any queries.
• Experienced in validated production deployments.
• Good team player, strived to improve customer satisfaction and have ability to work independently.
• Proven ability to manage and prioritize multiple, diverse projects simultaneously.
• Possess excellent oral and written communication skills and pleasing interpersonal skills
• Self-motivated and have ensured execution of tasks across multiple customers and priorities

TECHNICAL SKILLS

MS-DOS, 2000/NT, XP, Vista, Windows 7, 2003 server, HP-UX, UNIX and Linux

Languages

Java, J2EE, XML, HTML, DHTML, T-SQL, SQL and PL/SQL

RDBMS

Oracle8i/9i,Oracle10g, DB2,MSAccess, MS-SQLServer2005 and Teradata

ETL Tools

Informatica

Scripting Languages

VB Script, JavaScript

Testing Tools

Load Runner

Defect Tracking Tools

QC 9.0/9.1, PVCS Tracker7.0 andBugzilla

SCM

VSS, CVS

BI Tools

Micro Strategy

Education: MCA (Masters in Computer Applications)

CCD:
Confidential,
USA Oct - 2010 To Till Date
CCD project is one of the highly visible projects at Liberty Mutual and it is all about implementing a MDM - Customer Data Integration (CDI) for Liberty Mutual’s personal market. Under this project a central hub will be created that will house the customer data from various sources to give a 360 degree view to sales, marketing product, customer service, underwriting and claims divisions. This would ensure that the organization does not use multiple (potentially inconsistent) versions of the same master data in different parts of its operations. Liberty Mutual acquired Safeco, another insurance giant in the US. The master data from this company is also reconciled and the dependencies that existing applications have on the master databases are sorted out during the data merging process.

Responsibilities:

• Understanding the Business Requirements and converting them into test cases.
• Single point of contact to senior management . Assignment and monitoring the tasks of onsite and offshore teams.
• Development and Review of Test Plans and Test Scripts for ETL Testing for EDW Mart Tables.
• Development and Testing of Reports and Dashboards as per the needs of Business users.
• Preparation of SQL queries to validate data in the report against fact and dimension tables.
• Perform Functional testing of Micro strategy Objects designed for the application under test.
• Perform Performance and Load testing for Microstrategy Reports and Dashboards.
• Sharing Performance Test Results with stake holders.
• Provide technical/domain guidance to Trianz offshore team that develops the major part of test scripts. Acts as a liaison between offshore team and onsite coordinator.
• Provide testing effort for the BI Reports.
• Review the test scripts/ test cases designed for BI Reports.
• Perform UI Testing, Functional Testing and Performance Testing for the Micro strategy reports.
• Sending daily status to senior management (Onsite team and Offshore Test Manager)
• Tracking the offshore team tasks and reviewing time sheets.
• Contribute in the design of Test Plan/Test Strategy Design
• Prepare and execute performance test scripts using load runner components.
• Prepare summary sheet based on the results generated by Analysis section.

This Project uses Informatica, Micro Strategy, Oracle, Teradata and ‘Load Runner’ software.

OASIS
Confidential,
USA May - 2010 To Oct -10

Project Description: LibertyMutual’s new Personal Market Enterprise Data Warehouse (EDW) is called OASIS. OASIS is an acronym for Online Analytical System for Informed Strategies. We will refer to the new EDW as OASIS throughout this guide.
OASIS will be the single, central repository of all Liberty Mutual Personal Market business data. It is designed to provide “one version of the truth” for reporting and analysis. The OASIS environment will empower its users and others within Personal Market to make more informed business decisions by furnishing timely and accurate information.
This application was developed using Informatica, Oracle and Teradata software.

Responsibilities:

• Understanding the Business Requirements and converting them into test cases.
• Single point of contact to senior management . Assignment and monitoring the tasks of onsite and offshore teams.
• Responsible for migrating the MSTR objects from Dev environment to QA environment.
• Development and Review of Test Plans and Test Scripts for ETL Testing for EDW Mart Tables.
• Development and Testing of Reports and Dashboards as per the needs of Business users.
• Preparation of SQL queries to validate data in the report against fact and dimension tables.
• Perform Functional testing of Micro strategy Objects designed for the application under test.
• Sharing Performance Test Results with stake holders.
• Provide technical/domain guidance to Trianz offshore team that develops the major part of test scripts. Acts as a liaison between offshore team and onsite coordinator.
• Provide testing effort for the BI Reports.
• Review the test scripts/ test cases designed for BI Reports.
• Perform UI Testing, Functional Testing and Performance Testing for the Micro strategy reports.
• Sending daily status to senior management (Onsite team and Offshore Test Manager)
• Tracking the offshore team tasks and reviewing time sheets.
• Contribute in the design of Test Plan/Test Strategy Design
• Prepare and execute performance test scripts using load runner components.
• Prepare summary sheet based on the results generated by Analysis section.

This Project uses Informatica, Micro Strategy, Oracle, Teradata and ‘Load Runner’ software.

Confidential,
Sep 2007 To April 2010.
Sun Chemical, the world\'s largest producer of printing inks and pigments, is a leading provider of materials to packaging, publication, coatings, plastics, cosmetics, and other industrial markets.
Sun Chemicals automated system integrates with many other client systems ,collects and process the information about its R&D, Marketing, Distribution and Advertisements etc. Sun Chemicals planned to develop a Data Ware house system to generate the reports for analysis. This entire process involves ETL and Reporting.

Mainly the project deals with ETL process which involves the migration of related data from Oracle, DB2 database, File systems to Enterprise Data Ware House systems and writing complex SQL queries to validate and analyze this data.

Validation of data generated in the reports and dashboards with respect to source tables. Validation of UI and security of data and reports.

Responsibilities:

• Creating new test cases for validating different fact and dimensional tables in EDW.
• Supporting to team for technical issues while creating the test cases.
• Validating the data among the different stages in enterprise data warehouse database.
• Validating all the subject areas in EDW.
• Ensures that the ETL process functions well with other upstream and downstream processes
• Ensures that the ETL application correctly rejects, substitutes default values
• Creating standard format of new test cases for data mart validations like oid minus and full minus.
• Execution of test cases .
• Provide Effort estimation for the BI Reports.
• Perform UI Testing, Functional Testing, Regression Testing, Security Testing and Performance Testing on the BI Reports.
• Test Plan preparation.
• Prepare and execute performance test scripts.
• Prepare summary sheet based on the results generated by Analysis section.

This Project was developed using Informatica, Cognos, Teradata and Load Runner.

Confidential,
USA Jun 2005 To Aug 2007.
Brink’s Cash Sync is a money processing system that supports the Cash Logistics Operations in the United States. This is an enterprise web application with 3-tier architecture, which is used by the employees of Brinks across the US. This project deals with Cash Management Process at Brinks for its customers. To reduce the cost of maintenance of existing system and to scale the system to integrate with other internal, external systems, a new system was proposed called iCASH. This project consists of various modules depicting the business process of Brinks operations –

1. Cash Admin.
2. Cash Processing.
3. I Info (Reports)
4. ODS & Extracts
5. BizTalk Projects (Bank of America, Wells Fargo, Exxon Mobile etc)

Responsibilities:

• Understanding Business Requirements, Technical Specification and design.
• Guiding the team in writing SQL queries and Database related issues.
• Indentifying the testing scope, defining the test strategy and effort estimation.
• Test Plans were written by incorporating User Profiles, Configurations, Environments, Risks, Schedules and Analysis.
• Interactions with Business users, Support groups and Development team for clarifications
• Task Allocation, monitoring and tracking.
• Preparation of Traceability Matrix
• Performed Integration and ODS Testing.
• Test Case design and functional testing of iInfo Reports developed using Cognos.
• Verification of fixes in multiple environments like QA and Pre-production
• Attended sprint meetings and scrum calls
• Provided all required test reports and metrics for team and management
• Responsible for the delivery of test artifacts to clients.
• Responsible for maintaining the application source data, build files in version control tools
• Peform data validation for the reports generated from ODS data.

This Project was developed using Net3.5,Biztalk Server, Oracle10g