Quality Assurance Lead

Professional Summary:

Overall **+ years of IT experience across various domains like Utilities, Automobile, Supply Chain Management and Securities

5+ years of experience as a Quality Assurance Test Analyst / Quality Assurance Engineer and Test Lead performing manual testing of applications in the client server, internet/intranet environments using HP Quality Center/ ALM and JIRA

6 years of experience with expertise as Oracle PL/SQL Developer in areas of Application software development and maintenance in Oracle environment

Expertise in project management skills by handling all meetings, data analysis, documentation and business reports

Experience in analyzing business specification documents, developing test plans, defining test cases, developing test scripts

Experience in executing test cases, identifying and logging defects

Expertise in Defect Tracking and Bug Reporting Tools like HP Quality Center/ALM and JIRA

Experience in Acceptance, Compatibility, Functional, Unit, Integration, Regression, Performance, GUI, Back-end, Smoke Testing

Experience in the entire Software Development Lifecycle (SDLC) life cycle from requirements gathering to releasing to production

Experience in all phases of Software Testing Lifecycle with expertise in the Integration and Functional, User Interface, Regression testing, System Testing and Smoke Testing

Experience analyzing test results and communicating via Bug tracking systems.

Excellent oral and written communication skills with strong problem solving skills and a result oriented attitude

Experience as QA Analyst, Business Tester and onsite/offshore coordination

Strong working knowledge on Relational Database Management Systems(RDBMS)

Oracle certified Database SQL Expert (1Z0-047)

Proficient in using Microsoft Office tools and Well versed with SQL, PL/SQL queries to run the data integrity tests

Excellent communication and interpersonal skills

Technical Skills:

Databases : Oracle 10g, SQL Server, MS Access

Languages : PL/SQL, SQL, UNIX Shell scripting

Tools and Utilities : HP ALM, JIRA, JCS Redwood Chronacle, Jenkins, SQL*Plus, Toad,

SQL*Loader, Putty, Subversion, Clearcase

Operating Systems : UNIX, Windows XP/Windows 7/8, Windows vista, Linux

Office Tools : MS Office

Professional Experience:

Volkswagen of America, Inc., Auburn Hills, MI, USA

Senior Data QA Analyst Feb 2017 – Till Date

Description: Volkswagen Group of America, Inc. is the North American operational headquarters, and subsidiary of the Volkswagen Group of automobile companies of Germany.

The Volkswagen TDI Bravo Hypercare Program provides a legally binding solution for customers and vehicles impacted by the TDI emissions defect. Volkswagen Group of America must implement the primary core components of this settlement so processing of buy backs and modifications can begin to take place.

Responsibilities:

Reviewed, analyzed, and ensured the quality of data loaded into the database system by utilizing SQL and Excel

Reviewed all data fields for accuracy before release of data to customer-facing programs

Accurately and articulately detailed data issues and conveyed problems/technical issues to programmers

Created and modified SQL queries for data mining to validate/support business decisions

Monitored data integrity by performing quality assurance checks on client data

Collaborated with different teams to improve product quality by emphasizing defect prevention, data quality audits, and strong user acceptance testing

Worked with other teams to find innovative solutions to improve overall operations and client satisfaction; once implemented will reduce ticket volumes and times by more than 25%

Environment: Oracle 10g- SQL, SQL* Plus, Toad, Windows XP, UNIX, JIRA

Cardinal Health, Dublin, OH, USA

QA Test Lead July 2016 – Jan 2017

Description: Cardinal Health, Inc. is a Fortune 500 health care services company based in Dublin, Ohio. The firm specializes in distribution of pharmaceuticals and medical products, serving more than 60,000 locations. The firm also manufactures medical and surgical products, including gloves, surgical apparel and fluid management products. In addition, it operates the nation’s largest network of radio pharmacies. With more than 36,000 employees worldwide, it helps pharmacies, hospitals and ambulatory surgery centers, clinical Laboratories and Physician offices focus on patient care while reducing costs, enhancing efficiency, and improving quality

Responsibilities:

Analyzed the Business Requirements Document and system specifications and identified the test requirements

Created Test Requirements Specification documents, Test plan and Test Result documentation

Involved in SDLC, Business Process Design and Implementation

Prepared the manual test cases from Use Case and CRP flow diagrams for the team to execute during String and E2E testing

Reviewed Manual test cases developed for the new functionalities added/existing functionality enhanced by the offshore team

Co-ordinate with different teams at onshore to collect/prepare data required for test execution

Performed Backend testing using SQL Plus, PL/SQL and Toad

Performed Functional, Integration, regression, positive, negative and UAT testing

Logged the errors, reported defects, determined repair priorities and tracked the defects until resolution using HP ALM and JIRA

Monitoring test progress throughout the project release cycle, providing test results and detailed status reports.

Performed Interface Testing and data validations using SQL

Involved in BPT Testing using HP ALM

Provided training for other team members

Coordinating offshore and onsite teams

Conducting project reviews to improve project implementations

Environment: Oracle 10g, SQL* Plus, SQL* Loader, Toad, Windows XP, UNIX, Shell Scripts, HP ALM, SVN, JIRA

UBS, Zurich, Switzerland

Test Lead and Test Coordinator – UBS GEAR MC Nov 2011- Jan 2016

Description: Global Environment for Accounting and Reporting (GEAR) - A fat ledger system that keeps balances on the most granular level and that provides the "Single Source of Truth" for all reports in Accounting & Controlling. Related to Wealth Management and has multiple modules like SSRD, CAL, VAL, GL and Reporting.

The Reporting module is the DWH of the accounting and controlling system consisting of sourcing facility, data marts (Start Schema), reporting tool – BO and an outbound framework. Facts are built of balances (Ledgers) and Dimensions of Static and Reference Data (SSRD)

Responsibilities:

Liaison between Testing team and Development teams for Defect resolution

Offshore-onshore test coordination

Coordinated the test plan with project managers and business analysts

Single point of contact for integration and system test operations

Review business requirements and coordinate with Business Analysts for test case preparation

Preparing and maintaining Test scenario /Test Cases

Operate INT and ST GEAR environments in CH, DE and EU regions using Redwood Cronacle

Create defects for any technical/functional issues and track it till closure

Prepare and maintain the test plan for ST environments

Maintain requirement traceability in HP Quality Center

Write shell scripts for process improvement and automation of manual tasks

Facilitate Knowledge transition to offshore

Trained junior testers on Test Fundamentals and Test Design Techniques

Involved in building packages using Jenkins and deploying and testing in Unit Testing Environment

Promoting the UT packages to higher environment for integration and system testing

Environment: Oracle 10g/11g, SQL*Loader, SQL* Plus, MS Excel, TOAD, XP, Linux, HP ALM, SVN, Jenkins

Gas South, Atlanta, Georgia, USA

Oracle Senior Developer – BI Team Sept 2008- Oct 2011

Description: Gas South is a Georgia based natural gas company serving over 200,000 residential, business, and governmental customers. It is a wholly-owned subsidiary of Cobb Electric Membership Corporation (Cobb EMC), an electric cooperative serving approximately 190,000 residential and business customers. Cobb EMC is one of the largest of Georgia's 42 EMCs and is among the largest of the nation's approximately 900 EMCs.

Business Intelligence team of Gas South analyses and supports critical IT operations for CIS (Customer Information System) - CC&B (Customer care and Billing). The job includes providing supporting data to Business Analysts for reviewing existing business policies and ways to improve performance.

Responsibilities:

Analysis of critical IT operations like Customer information, Location Information, Billing and account history, Sales & Marketing, Payments, Credit & Collections

Reporting functionality of different business processes and suggesting required enhancements of the existing reports and automation of the reports

Developing new reports which explain current status of different business policy and ways to improve policy performances

Deliver reports explaining success and failure of the functional processes and suggest business process improvements

Perform peer reviews for code, deliverables and process documents

Process documentation for the reports

Performance tuning of the reports

Developed and modified packages, functions and PL/SQL stored procedures to process the raw data into business understandable facts

Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling

Created DB links for connecting to remote databases accessing

Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries

Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization

Environment: Oracle Database 10g, PL/SQL Developer, SQL*Plus, TOAD, UNIX, Shell Scripts, SVN

Reliant Energy, Houston, Texas, USA

Oracle SQL Developer - CCS MMAS Analysis & Reconciliation Oct 2006- Aug 2008

Description: Reliant Energy, Inc. based in Houston, Texas, United States, is a retail and wholesale electricity provider which services nearly 1.8 million retail electricity customers including residential, small business, commercial, industrial, governmental and institutional customers. It also serves commercial, industrial, governmental and institutional customers in the Pennsylvania, New Jersey and Maryland (PJM) market and is one of the largest independent power producers in the United States with approximately 14,000 megawatts of power generation.

CCS MMAS Analysis and Reconciliation project required an in-depth analysis of the existing process and coming up with a low level “AS – IS design” document before proceeding with the automation. There was a lot of manual efforts being put in by the business users to do the reconciliation between the CCS and MMAS database daily. The aim was to come up with an automated solution to do the same job to avoid manual error and more quality output.

Responsibilities:

In Depth analysis of the existing process and preparing the AS-IS document

Client walk through of the analysis done with all the stakeholders needing to sign off the document

Provide with an automated solution using a POC

Design and development of several PL/SQL packages, procedures and functions that were used in automation

Worked with SQL*LOADER for data loading

Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning

Preparing the unit test cases, Operational Manual and Deployment Documents

Environment: PL/SQL, SQL*Plus, Oracle 10g, SQL*Loader, TOAD, UNIX Shell scripts

UBS, Zurich, Switzerland

Socrates DB – Oracle Developer Nov 2005- Sept 2006

Description: UBS is a diversified global financial services company, with its main headquarters in Basel and Zurich, Switzerland. It is the world's second largest manager of private wealth assets.

UBS Socrates team was responsible for creating mapping, workflows and scheduling jobs to perform profit and loss calculations using scenario dependent business logic.

Responsibilities:

Developing packages, procedures, functions, and triggers for the application using oracle

Creating simple mappings using Informatica

Using UNIX environment for performing the testing

Performing the tests on the newly coded procedures and documenting the same

Writing technical documents using the functional specifications

Writing PL/SQL code using the technical and functional specifications

Optimized the queries to improve the performance due to huge data volume

Environment: Oracle 10G, Pl/SQL, UNIX shell scripting, Informatica

Contact this candidate