Summary

• Over 10 years of Experience in Data warehousing Analyst, Quality Assurance and 6 years of ETL/BI testing experience with extensive backend testing Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Experienced QA Analyst / Data Reporting Analyst with strong background in design, development, and support of online databases and information products as well as data analysis / reporting / processing.
• Extensively strong on databases including Terada, Oracle 10g/9i/8i, MS SQL Server 2000/7.0 and DB2
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
• Experience in Performance Tuning of sources, targets, mappings and sessions.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame
• Extensive experience in Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing, and White Black Box testing manually and also using automated tools WinRunner, Load and Stress testing using Load Runner and QTP for testing Client / Server and Web based applications.
• Expertise in Defect Tracking, Defect management and Bug Reporting Tools like HP Quality Center, Rational Clear Quest, HP INA andd version control tools like Rational Clear Case. Participated in and Bug Reporting using Quality Center for business software and Web applications.
• Excellent programming and problem solving skills having worked on C, C , VB, SQL, PL/SQL
• Extensive knowledge in regression testing and design documentation.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Excellent communication, analytical and interpersonal skills
• Experience with programming technologies like C, C , Visual Basic, Java, HTML and SQL
• Good analytical skills, presentation skills with strong communication skills.
• Excellent understanding of all phases of Systems Development Life Cycle SDLC and Software Testing Life Cycle STLC , including requirements analysis/design, development and testing.
• Experience in working in Agile with good knowledge on Scrums and sprints.
• Experience in writing System test plans, defining test cases, developing and maintaining test scripts according to the business specification given.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping Knowledge in Dimensional Data Modeling using Star and Snow Flake Schema and preparing prototype models for data analysis.
• Tested the ETL Informatica mappings and other ETL Processes Data Warehouse Testing
• Experience with Excel functions, pivots, graphs and used Excel for quality check data analysis.
• Written several complex SQL queries for validating data in data warehouse
• 5 years of experience as QA software Test Lead in projects for leading Healthcare, Banking financial, Retail and Telecom clients.
• Working in different time zones to manage Onshore and Offshore software testing team.
• Received certificate of Appreciation 4 times for outstanding contribution in project work.

Technical Skillset

Project Details

Confidential

ETL Test Lead / Sr. ETL Test analyst

Project Summary: - Projects and enhancements for various subject area for the enhancement of EDWard Upgrade release. Includes the data to support each of these efforts currently comes from various sources. Information Management IM team have joined forces to create EDWard Enterprise Data Warehouse and Research Depot , an industry leading data warehouse that provides a single source of consolidated information. EDWard will deliver actionable information through a consistent view of the business and will help WellPoint deliver on its business strategies across the company.

Responsibilities:

• Analyzed business requirements and interfaced with clients for development and enhancement of a system to support multiple business areas including Claims, Memberships, Clinical and Products.
• Developed Test cases, Test plans, and Test procedures using RQM, MS Word and MS Excel.
• Performed ETL testing and extensively used SQL functionalities. Used Teradata SQL Assistant to Teradata Database.
• Testing the source and target databases for conformance to specifications.
• Conducted regression testing on the system under test and Debugging the SQL-Statements and stored procedures.
• Created reports that included a general overview, open bugs, new bugs and enhancement requests. Entered new bugs and maintained the current status of those bugs.
• Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica and Teradata.
• Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing, Parallel Testing, Performance Testing and Regression Testing and Post Production Validation.
• Conditional testing of constraints based on the business rules.
• Involved in Positive and Negative Testing for many scenarios and applications.
• Responsible for creating Test Strategy for the Data Warehouse.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Written several complex SQL queries for validating data warehouse.
• Performed the tests in both the SIT, QA and contingency/backup environments.

Environment: MS Excel, Clear Quest, Rational Quality Manager, WINSCP, Teradata, Unix,MS-Office.

Confidential

ETL Test Lead / Sr. Test analyst

Confidential is a consumer credit reporting agency in the United States, considered one of the three largest American credit agencies along with Experian and Transunion. A global leader in information solutions empowers businesses and consumers with information they can trust. With a strong heritage of innovation and leadership, leverage unique data, advanced analytics and proprietary technology to enrich the performance of businesses and the lives of consumers.

Project: GIS Personal Solutions PSOL Advanced Analytics Platform

GIS/PSOL is Equifax's only direct-to-consumer business unit. The key products in GIS include credit reports, scores, monitoring, identity protection and debt management tools, distributed via web, mobile, call center, APIs and offline/partner channels. PSOL also integrates with Siebel HTIM application to deliver required Consumer, Order Management, Call Center, Products, Pricing, and Partner Management capabilities. PSOL Advanced Analytics platform is built for consolidating for data from multiple sources such as online request, batch request, offline requests, etc. PSOL AAP provides the ability to business to quickly assess and decision on data, quick root cause analysis, identify upsell targets and appropriate product match, and Enable PSOL to combine 3rd party and 1st party Equifax data.

Responsibilities:

• Analyzed current business processes and created and developed new functionality to meet business objectives.
• Involved in preparing the strategy document that defines the test environment, phases of testing, time lines of different phases of testing, entrance and exit criteria into different phases of testing and resources required to conduct the effort.
• Provided Test metrics on the results of system testing activities coordinated and collaborated with others in analyzing collected requirements to ensure system development and implementation plans meet customer needs and expectations.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping. Conducted various management activities by analyzing and verifying test results, providing status reports
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Tested reports and ETL mappings from Source to Target
• Performed Data Driven Testing of the Application for different users/data sets
• Developed Test cases for the Data Warehouse in Oracle System
• Conducted data validation testing and extracted certain column of data from a number to files in UNIX environment.
• Used SQL for Querying the Oracle database in UNIX environment.
• Conducted Functional testing to ensure that the application meets the requirements and to ensure usability readiness.
• Involved in creation of defect analysis report for system Test and UAT.

Environment: Oracle, Informatica, MS Office Suite, ALM Quality Center,Snag It, HP INAV.

Confidential

Test Lead / Sr. Test analyst

One of the America's leading Vehicle remarketing company sell used cars through physical and online auctions.

Project:

The web application provides simple and efficient way for the dealer to purchase the vehicle through bidding or can perform a direct purchase. This is an integrated application for live physical auction as well as online sale. The application provides the provision to the admin to perform all administrative actions like creating online sales, adding vehicles to the sale events, pricing for the vehicles available in online sale, etc. It has rich functionalities for the dealers for their day to day business activities.

Confidential

The web application provides a simple and efficient way for Nissan / Infiniti customers from United States to return ground the leased vehicles. The Nissan / Infiniti dealers can buy the grounded vehicles or it can go for internal and live auction based on the vehicle's return status. The vehicles would get associated to the online sales if they satisfy certain business rules of Nissan business. A Nissan/Infiniti US dealer can bid or buy the vehicles from the online sales created for Nissan/ Infiniti US dealers. The system will send outbid, winner and other mails to the users and other configured mail ids. User and dealer can view different types of reports regarding their activities. The Testing scope involved: Integration Testing, System/Functional Testing, Performance Testing and Regression Testing

Confidential

The web application provides a simple and efficient way for the Nissan / Infiniti customers from Canada to return ground the leased vehicles. The Nissan / Infiniti Canada dealers can buy the grounded vehicles or it can go for internal and live auction based on the vehicle's return status. The vehicles would get associated to the online sales if they satisfy certain business rules of Nissan Canada business. A Nissan/Infiniti Canadian dealer can bid or buy the vehicles from the online sales created for Nissan/ Infiniti Canada dealers. The system will send outbid, winner and other mails to the users and other configured mail ids. User and dealer can view different types of reports regarding their activities. The Testing scope involved: Integration Testing, System/Functional Testing, Performance Testing and Regression Testing

Confidential

The web application provides a simple and efficient way for the Hyundai / Kia customers to return ground the leased vehicles. The Hyundai / Kia dealers can buy the grounded vehicles or it can go for internal and live auction based on the vehicle's return status. The vehicles would get associated to the online sales if they satisfy certain business rules of Nissan Canada business. A Hyundai / Kia dealer can bid or buy the vehicle from the online sales created for Hyundai / Kia dealers. The system will send outbid, winner and other mails to the users and other configured mail ids. User and dealer can view different types of reports regarding their activities. The Testing scope involved: Integration Testing, System/Functional Testing, Performance Testing and Regression Testing

Confidential

The web application provides a simple and efficient way for the TOYOTA customers to return ground the leased vehicles. The Toyota / Lexus dealers can buy the grounded vehicles or it can go for internal and live auction based on the vehicle's return status. The vehicles would get associated to the online sales if they satisfy certain business rules of Nissan Canada business. A Toyota / Lexus dealer can bid or buy the vehicle from the online sales created for Toyota / Lexus dealers. The system will send outbid, winner and other mails to the users and other configured mail ids. User and dealer can view different types of reports regarding their activities. The Testing scope involved: Integration Testing, System/Functional Testing, Performance Testing and Regression Testing.

Responsibilities:

• As a QA lead I involved in the following activities:
• QA team is responsible for Functional testing, load testing, regression testing, UAT support, and Production certification testing.
• Manage the 8 members QA testing team for platform and presentation track. Coordination and manage onshore and offshore QA team.
• Direct interaction with client business analysts for business and requirement needs.
• Working in Agile team having iterative and incremental development, where requirements and solutions evolve through collaboration between self-organizing, cross-functional teams.
• Closely work with development team and business analyst team to meet deliverables on time.
• Created and executed software test plans, cases and scripts to uncover, identify and document software problems and their causes.
• Certified different applications using automated testing tools and programs addressing areas including database impacts, software scenarios, regression testing, negative testing, error/defect retests and usability.
• Created and executed software test plan, test cases and scripts for the data migration project using Informatica 8.6
• Documented software defects using defect tracking system and reported defects involving program functionality, output, online screen and content to software developers.
• Delivered thorough QA testing reports that determined product quality and release readiness.
• Prepare the Software Test Plan and Check / Review the Test Cases document.
• Analyze requirements during the requirements analysis phase of projects.
• Keep track of the new requirements from the Project.
• Forecast / Estimate the Project future requirements.
• Escalate the issues about project requirements Software, Hardware, Resources to Project Manager / Test Manager.
• Assign task to all Testing Team members and ensure that all of them have sufficient work in the project.
• Organize meeting and prepare the Agenda for the meeting.
• Attend the regular client call and discuss the weekly status with the client.
• Send the Status Report Daily, Weekly etc. to the Client.
• Communication by means of Chat / emails etc. with the Client.
• Act as the single point of contact between Development and Testers for iterations, testing and deployment activities.
• Track and report upon testing activities, including testing results, test case coverage, required resources, defects discovered and their status, performance baselines, etc.
• Ensure content and structure of all Testing documents / artifacts is documented and maintained.
• Document, implement, monitor, and enforce all processes and procedures for testing is established as per standards defined by the organization.
• Log and monitor project related issues in the defect tracking tool identified for the project.
• Check for timely delivery of different milestones.
• Motivate team members and Organize / Conduct internal trainings on various products.

Confidential

• Toyota Data migration project is a data migration project implemented using Informatica 8.6. The source and target databases are Oracle 11g and Teradata respectively.
• Involved in gathering requirements and analysis of data mapping documents.
• Developed Test Plans, Test Cases, Test Scripts for UAT tests
• Used Informatica as an ETL Tool for Developing the Data Warehouse.
• Prepared complex SQL queries for comparing the data in Source and target tables
• Verification of data in dimensional tables
• Verification of the mappings and workflows
• Verification of data loaded into the target tables using SQL queries
• Developed Tractability Matrix and Test Coverage reports.
• Managed and conducted System testing, Integration testing, Functional testing, UAT and Regression testing.
• Used the Informatica Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Responsibilities include acceptance testing, functional testing, Integration testing, System testing
• Execute batch processing and verify the jobs status and data in database tables
• Tracked the defects using Clear Quest and generated defect summary reports
• Modified Configuration file according to space constraints
• Prepared status summary reports with details of executed, passed and failed test cases
• Interacted with developers, Business Management Teams and End Users
• Participated in regular project status meetings related to testing

Confidential

Test Lead / Test analyst

Project Enterprise Provider Database Solution

• Enterprise Provider Database Solution is a migration of several existing applications that maintain the Providers information for one our leading health provider client. The objective is to build a foundation to enable the entry of Provider Data once into a central repository, streamlining and standardizing business processes. The EPDS centers on the heart of client business model of creating, tracking, marketing, and managing flexible, quality provider networks to support all lines of business, products and services. The intent of the project is to not only support existing business, but to also provide a flexible, configurable solution to enable future business initiatives and growth.
• The high level scope of the project is to replace the Back-end Hierarchical Databases IMS DB to Relational DB2 databases to support the high-volume back-end activities and the Front-end IMS DC screens to Web Interface which will be in Java/J2EE technologies using Web Sphere server and DB2 database. The Front-end provides Data entry Admin features and the Back-end provides extracts or query access to external systems.

Responsibilities:

• As a Senior QA Engineer,
• Analyzing the client business requirements
• Prepare the test cases based on Requirement and take part in peer review of the test cases.
• Creation of Test data and Test Execution.
• Reporting defects and Tracking the defects to closure.
• Performed functionality testing, Regression testing, Automation Testing, Ad hoc Testing Smoke Testing.
• Identify various scenarios for functional and integration testing
• Closely work with development team to meet deliverables on time.
• Created and executed software test plans, cases and scripts to uncover, identify and document software problems and their causes.
• Certified different products using automated testing tools and programs addressing areas including database impacts, software scenarios, regression testing, negative testing, error/defect retests and usability.
• Documented software defects using defect tracking system and reported defects involving program functionality, output, online screen and content to software developers.
• Constant Interaction with Clients for requirements clarifications.
• Ensured that quality Standards are met.
• User Acceptance Test support.

Confidential

sr. tester

Project: Product Control Center PCC

• PCC is the worlds most advanced and comprehensive product lifecycle management solution, purpose built for communications service providers. PCC is the communication industry's first purpose-built and standards-based system focused on enabling service providers to construct, manage, and deploy a layered product catalog that includes the full technical and commercial definition of products.
• As a senior QA, I was involved in
• Analyzing the client business requirements
• Prepare the test cases based on Requirement and take part in peer review of the test cases.
• Creation of Test data and Test Execution.
• Reporting defects and Tracking the defects to closure through Test Director.
• Performed functionality testing and Regression testing.
• Identify various scenarios for functional and integration testing
• Closely work with development team to meet deliverables on time.
• Documented software defects using defect tracking system and reported defects involving program functionality, output, online screen and content to software developers.
• Constant Interaction with Clients for requirements clarifications.
• Ensured that quality Standards are met.
• Data Migration testing from Prostgres SQL to Oracle.

Confidential

Tester

Project: Geneva BreCon Billing

• Geneva BReCon is a billing system. Retail Geneva is an automated billing platform supporting approximately 65 different components, interfaces, and products and billing thousands of Retail customers. The Project carries out the end-to-of telecom billing. The main process under billing include Collects call details records from customer on daily basis, Apply customer specific rates taxes to CDR's, Apply adjustments like credit and debit, Calculate discounts and service charges, and Bills the customers as per usage
• As a team member I was involved in
• Analyzing the client business requirements
• Prepare the test cases based on Requirement and take part in peer review of the test cases.
• Creation of Test data and Test Execution.
• Reporting defects and Tracking the defects to closure through Test Director.
• Performed functionality testing and Regression testing.
• Identify various scenarios for functional and integration testing
• Closely work with development team to meet deliverables on time.
• Documented software defects using defect tracking system and reported defects involving program functionality, output, online screen and content to software developers.
• Constant Interaction with Clients for requirements clarifications.
• Ensured that quality Standards are met.

Confidential

Tester

Project: Automated Expense System

• Automated Expense System AES is designed to automate its current paper process for expense invoice approval, vendor maintenance requests, transaction maintenance requests, as well as replace the current system for setting up and tracking ECR preparers and approvers, using its Metastorm Business Process Management BPM infrastructure to model and generate the application functionality.
• As a team member I was involved in
• Analyzing the client business requirements
• Prepare the test cases based on Requirement and take part in peer review of the test cases.
• Creation of Test data and Test Execution.
• Reporting defects and Tracking the defects to closure through Test Director.
• Performed functionality testing and Regression testing.
• Identify various scenarios for functional and integration testing
• Closely work with development team to meet deliverables on time.
• Documented software defects using defect tracking system and reported defects involving program functionality, output, online screen and content to software developers.
• Written Java code for the unit testing
• Constant Interaction with Clients for requirements clarifications.
• Ensured that quality Standards are met.