AKHIL SHAH

ac35v1@r.postjobfree.com

(M) – 973-***-****

**** **** ****** ****,********, Ohio - 43026

PROFESSIONAL SUMMARY

* ***** ********** ** ******** Analysis,Design and Software Quality Assurance Testing (Automation and Manual) of Client Server and Web Applications.

Experience in Testing Data Warehouse and ETL Applications.

Experience with QA Methodology and QA Validations to ensure the Quality Assurance Control.

Expertise in HP ALM, QTP/UFT, Selenium, Win Runner, Test Director and Load Runner and Rational Tools for Quality Assurance.

Strong in Analyzing Business specifications and Use Cases and Developed Test Plans, Test Scripts and Test Cases and Executed them.

Extensive experience in Unit, Functional, SIT, UAT, Integration, Regression, User Acceptance, System, GUI, Load, Stress, Performance Testing.

Experience working in Production and Development support.

Implemented the software development lifecycle (SDLC) for the testing life cycle to follow the Standards process in the application.

Experience with industry standard methodologies like RUP, Agile and CMM.

Experienced in Database Testing using SQL queries on RDBMS databases like Oracle and SQL Server.

Expertise in Problem solving and Bug Reports using Bug Tracking Tools.

AREA OF EXPERTISE

Testing Tools: ALM 12.01, UFT 12.02,12.54, Test Director 6.0/7.0/8.0, Win Runner 5.0/6.0/7.0, Load Runner 10.0, Requisite Pro, SOAP UI and Clear Quest

Databases: MS SQL, Oracle 10g/9iAS/8i/8.0/7.3, Sybase ASE 12.5.1

Database Tools: TOAD, SQL*PLUS, SQL*LOADER, SQL Developer, Developer, Aqua Data Studio

Scripting Languages: VBScript, Java Script, UNIX Shell, EJBS, JDBC, PERL

Languages/Packages: SQL, PL/SQL, C, C++, JAVA, JSP, COBOL, HTML, DHTML

Data Warehousing: Informatica Power Center 8.1.1/7.1/6.0, Data Stage, Ab Initio.

Operating Systems: UNIX, Linux, Windows XP/2000/NT, MS-DOS

PROFESSIONAL EXPERIENCE:

QA Automation Engineer Jan 2017 – Till date

T.Rowe Price

Developed Automation frameworks from scratch in UFT and selenium by VBscript and Java ( with the help of JUNIT,TestNG, GitHub)

Extensively worked on Descriptive Programming in HP UFT and Selenium.

Used Loops and Conditional statements in UFT with the help of VB scripts as well as shell scripts and in selenium with JAVA.

In Selenium created automation scripts in JAVA using Inheritance concept to reuse functions.

Developed test scripts in UFT using VB Script for automation of Web Based Applications.During web based application automation worked on Webelement, Webedit, webtable,link,etc..

Worked on number of Automation framewoks (Data driven framework, Keyword driven frame work,Modular Framework, Hybrid framework)

Developed automation VB scripts using UFT to automate functional and regression testing.

Mentored and trained Team members for the effective use of automation framework and to develop UFT scripts and installing UFT, connecting to UFT through ALM and executing the UFT scripts from ALM.

Assisted with automation of finance department’s manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.

UFT In data driven frameworks for each Use Cases (functionality) written in Descriptive Programming.Executing the test scripts in UFT and ALM. Developed test scripts, Object Repositories and function libraries using VBScripts.

Extensively used Data table for test data and also saved Test data sheet in ALM.

Worked with the Developing Team to Develop web elements and to interact with the MYSQL Data base.

Walkthrough with Business Analysts and developers on the Test Plans that were designed.

Executed Test cases in the timely manner and Reported defects in HP Quality center ALM

Managed & scheduled all Automation scripts from HP Quality center ALM

Created test suites for functional and regression testing in HP UFT 12.54

DATAWAREHOUSE :

Along with automation I also worked on 1 ETL project in T.Rowe Price.

I compared source to Target data transformation to make sure data flowing from source to target model with correct transformation Logic.

I used different complex SQL queries like (Minus, Joins and many more) to compare source against target as per the transformation logic.

Environments: HP UFT 12.54, HP ALM, SQL, XML, JIRA, Agile, UNIX, Jenkins, GIT Stash, Source Tree, Windows 7, MS Office.

QA Automation Engineer Aug 2015 – Dec 2016

Wells Fargo, Winston Salem, NC

Developed detailed Test Plan, Test Scenarios and Test Conditions using HP ALM.

Designed Functional Libraries, Functions, Common functions, Regular Expressions and Environmental variables using UFT in VB script.

Extensively used Shared Object Repository in QTP. In some cases use Shell script along with VB script.

Execute the Automation scripts on daily basis, quarterly and also on request bases.

Followed Agile Methodology and attended Scrum meetings.

Performed Database testing to test data migration from different test environments.

Automation scripts execution through ALM, updating test results and uploading relevant files/screen shots back to ALM.

Created Macros for calculation of equity, interest and foreign exchange as per requirements.

Automation of Database (Backend) testing, preferably for Oracle and Teradata databases

Created Traceability matrix between requirements & test cases in HP ALM.

Created Automation frameworks (Data driven framework, Keyword driven frame work as well as Hybrid framework) in VB Script and JAVA using QTP/UFT and selenium Tools respectively.

Created complex SQL queries in MYSQL / Oracle server against source and target database to pull out specific data report.

As a project lead coordinated with business and technical teams for day-to-day information, issues, project status as well as future goals and deadlines.

Tracked and managed defects using HP ALM. Generated and Maintained Defect reports using HP ALM.

Sr.ETL System Analyst/ QA Engineer Nov 2014 – AUG 2015

Wisconsin Physician Service, Madison, WI

Developed Test Plans, Test Cases, Test Scripts and Traceability Matrix using HP Quality Center / ALM.

Created Data driven framework, Keyword driven framework as well as Hybrid framework using QTP/UFT.

Worked with SQL queries to validate the data in database.

I also worked on Source (it was textfile or dB or mainframe) to Target data validation to make sure transformation logic.

I used different complex SQL queries like (Minus, Joins and many more) to compare source against target as per the transformation logic.

Maintained the traceability matrix between requirements and test cases. Worked with TriZetto Facets: Group/Class/Plan/Product, Member/Subscriber, Claims Processing, Customer Service, Provider, Subscriber/Member enrollment.

Tested User Interface inconsistency and application functionality.

Responsible to check whether the interfaces and the extensions properly integrate with the Facets application.

Agile Process was followed and testing was done simultaneously.

Participated in Requirement Analysis, Business Analysis and Design Analysis.

Attended daily Scrum Calls and guided QA and Developer regarding the defects, Technical Specification Documents and Mapping Documents.

Worked on Scrum Master for coordinating meetings and defined testing goals.

Tested and validated ANSI X12 5010 Transactions such as 834, 837, 835, 270, 271, 276 and 277.

Involved in validating Keyword files.

Involved in testing ANSI X12 5010 EDI Transactions.

Tested the loading of claims data into Facets 4.71/5.01.

Tested the Adjudication of Claims and Migration Process.

Validated the integration of applications with Facets, which manages the customer service, claims, membership, care facilitation and appeals.

Participated in testing various interfaces of Facets 4.71/5.01.

Developed Test Strategy, Test Cases and Test Scripts for enrollment, billing, Membership, Claims, Payment, Authorization and Eligibility of claims in Claims Processing System.

Tested Member level benefits and billing in MemebrsEdge

Worked with CSR request, validated the data and Tested routing of claims correctly.

Created and Tested 834 Files.

Systematically created outbound Monthly Reconciliation discrepancy reports.

Reports should be placed in the error folder, Facets Mapping.

Used XML and develop XML (Canonical) files.

Compare the Facets production data with load table, Load derived table with data from the Recon Monthly file, Identified records that do not match

Performed Functional, Integration, System, Smoke, Backend and Regression Testing.

Worked on HIPAA 5010 Project, included Medicaid and Commercial entities including claims and enrollment testing as well as NPI and medical coding, ICD-9 and ICD-10 EDI testing

Developed detailed Test Plans and Test Cases using Quality Center/ALM and executed them.

Tests are managed using Quality Center/ALM, Created Claims for Medical / Hospital and Dental Claims Processing.

Tested the Eligibility applications (Eligibility Request and Eligibility Response).

Sr. QA Analyst/ ETL System Analyst June 2013 – Nov 2014

Wells Fargo, Winston Salem, NC

Actively discussed and gathered the complete project information from Business Analyst and Technical Team by BRD and FSD created by BA and Tech team, respectively.

Created Test Plans to fulfill all Business Requirements for the particular project.

After getting the Approval of Test Plans from QA Manager I developed and uploaded Test Cases for all Business Requirements in HP ALM.

Created Automation frameworks by QTP

Maintained HP ALM by uploading Requirements, Test plan and Test cases & also maintained Traceability Matrix in HP ALM by connecting all Test cases to Requirements.

Executed test cases and if any code was not working as expected I opened up Tickets in particular manner to track easily.

Wrote SQL queries for both MS SQL server and Oracle server to validate transformation logic.

I have used SOAP UI tool to validate XML file process for Web Service.

Validated Data Models of source (database/ flat file/ UNIX) and target database with the expected Data Models.

Efficiently handled multiple projects in Different environments like SIT, UAT and Prod.

Performed Functional Testing, Regression Testing, Load testing, Performance testing and many more for Different applications.

Worked in source to target, transformation environment ( ETL) .

Computer system Validation QA (Watson LIMS and Nautilus LIMS) March 2012 – April 2013

Thermo Fischer Scientific, Cambridge, MA

Responsibilities: Watson LIMS

Executed validation scripts and OQ scripts with Watson 7.4.1

Worked under the direction of the Validation Team Leader to provide test scripting, hands on execution/coordination and issue management.

Wrote SQL statements to extract data from the Tables against Oracle and MS SQL database.

Used TOAD tool to perform backend validation.

Wrote up defects and updated traceability matrices.

Mainted CAPA report which is a mechanism for correcting and recording defects and nonconformances.

Worked all task under strick cGXP environment.

After execution of the tests managed and coordinated resolution of defects found

Experience with the Review of Executed test scripts according to SOP and 21CFR Part 11 guidelines.

Responsibilities: Nautilus LIMS

Managed and Validated Nautilus 9.0.

Evolved in workflow creation using appropriate workflow nodes in laboratory-based environment according to user requirements with Nautilus LIMS 9.0.

Established priorities and schedule activities to ensure timelines and milestones are met.

Reported progress and issues to team lead in an effective manner.

Followed Quintiles System Life-Cycle (SLC) and Computer System Validation (CSV) procedures, as appropriate.

Worked efficiently in a team environment and followed the other team members.

Involved in documenting and maintaining quality process.

Computer System Validation QA Aug 2009 – Jan 2012

Amgen Pharmaceuticals, Thousand Oaks, CA

Responsibilities:

Dev eloped Test Plans, Test Cases, Validation Plans, Validation Procedures, Test Data, Traceability Matrix and Test

Summary Reports.

Involved in requirements gathering, business analysis and requirement analysis.

Involved in technical writing and documentation of user manuals.

Performed Database testing to verify the data using SQL to ensure integrity and consistency of data.

Extensively used TOAD to verify source data and target data after the successful workflow runs using SQL.

Developed IQ, OQ and validated the applications based on 21 CFR Part 11 guidelines in cGMP environment.

Conducted functional, regression, IQ, OQ and UAT tests

Developed tests and tested the upgrade from Argus safety 4.1 to 4.2

Tested the workflows for Argus Safety system (Argus4.1 / 4.2).

Worked with JCL extensively to schedule and execute the jobs in Mainframes

Analyzed the data using QMF.

Responsible for making modifications and enhancements to the existing JCL.

Created and modified test data using File-Aid.

EDUCATION

Bachelors in Pharmacy, India

Contact this candidate