Quality Assurance Analyst

Kunal Zope

EMAIL: *********@*****.*** CELL: (***) – 474 - 1371

AMHERST, MA

Summary

Twelve years of Global IT experience in Software Development Life Cycle.

Ten years of Quality Analyst experience and two years of an Oracle Developer experience at the Asia’s largest software exporter – Tata Consultancy Services Ltd.

Specialize in the validation of Data Management involving Oracle software solutions and expertize in requirement analysis, system analysis, and Test & Defect lifecycle management using HP QC / Pega PMF/JIRA.

Hands-on involvement in 4-point analysis of Business requirements, Test Strategy & estimations, User training and post-production support.

Vast Exposure to tools like SOAP UI, Business Objects Data Integrator, Informatica, OBIEE reports, Siebel Analytics reports.

Developed Test plans, test scripts and aided in automation of repetitive test scripts using HP QTP, Selenium.

Valuable experience in Oracle PL/SQL as a developer and validation expert.

Deft at getting inside the application functionality as well as code (PL/SQL) that enables to identify missed out scenarios by the developer. (White box testing)

As a developer, designed and developed an entire module for a large project in a stringent timeline.

Worked for more than two years as a QA cum developer for PEGA PRPC projects in Government organization.

Exposure in tuning SQL statements to improve execution performance that resulted in reduction of Test execution time.

Excellent communication skills, adept at client interaction and understanding business applications.

EDUCATION

Degree

Specialization

School

University

Year

Bachelor of Engineering

Electronics

Vivevkananda Education Society’s Institute of Technology, Chembur

Mumbai

2006

Core Competencies

Skills

Test Management, ETL-Database & UI validation, Shell Scripting

Certifications

ISTQB, ITIL v3

Software Products

Oracle 10g, 9i, HP Quality Center, SOAP UI, JIRA

Languages

SQL, PL/SQL, ISIS Papyrus, C++

Tools & Utilities

PL/SQL Developer, Toad v10.6 v11.0, Informatica, BODI, Papyrus Designer v6.2, HP Quality Center 8.2, 9.2, 10.0, 11.0, Mercury Test Director, Infor

Version Control Tools

Visual Sourcesafe, Serena Changeman version Manager, Kintana, Quality Centre

Microsoft SharePoint

Operating System

Windows XP/2003/Server 2000/7, Mac OSX Yosemite

Professional Experience

Client: State of Maine, Augusta, ME Duration: May 2018 – till date

Role: Manual Tester - III

Project: HR Modernization System

Description:

State of Maine has legacy standalone systems in different technologies and platforms for managing Employee timesheets, leave accruals, Payroll, Hiring/promoting/demoting, benefits, deductions et al operations. Infor is the product that shall replace each of these legacy systems and bring entire services under one portal and on cloud. I am owner of two modules in test effort for this modernization project.

Responsibilities:

Requirement Analysis.

Test Life Cycle Planning & Management.

Test Case walkthrough with Business Users.

Solution Environment

Infor

Software

Infor, Internet Explorer, Google Chrome

Tools

MS Office 2016, JIRA - TM4J

Client: State of Maine, Augusta, ME Duration: Dec 2015 – till date

Role: QA Analyst / PEGA Tester

Project: Agile Center of Excellence

Description:

The applications ‘PayMaine’ and ‘MainePays’ are developed for the online payments management for State of Maine (inbound and outbound). The applications are developed in PEGA 7.1.9 & 7.2.1 respectively. Major responsibilities involved validation of web application, integration with other State departments and underlying data tables. The considerable part of project was to develop web services for other applications of State and involved exhaustive SOAP & REST API testing. Validate data updates in Oracle database firing SQL queries. Worked on Licensing framework of Pega Systems extensively for large applications of Board of Pesticide Control & Department of Marine Resources.

Responsibilities:

Requirement Analysis.

Test Life Cycle Planning & Management.

Test Case walkthrough with Business Users.

Validation of workflow implementations in PEGA.

Perform minor development tasks and defect fixes.

Accessibility testing using JAWS.

Daily Stand-Up Meeting with Product Owner and stakeholders.

UAT Queries, clarifications and support.

Extensive QA documentation so that project may clear any kind of audit.

Solution Environment

PEGA PMF, PEGA 7.1.9, 7.2.x, 7.3 Designer Studio

Software

MS Office, SOAP UI, PL/SQL Developer

Tools

MS Office 2003, MS Office 2016

Role: QA Analyst / PEGA Tester May 23, 2018 – till date

Project: SOMER

Description:

State of Maine Employee Resources HRMS modernization project caters to all employees activities such as Workforce Management, Payroll, Tax, Benefits et al. The module in which I was majorly involved included Payroll and Workforce management. We used JIRA for managing and executing test scripts.

Responsibilities:

Requirement Analysis.

Test Life Cycle Planning & Management.

Extensive QA documentation so that project may clear any kind of audit.

Solution Environment

Infor Ming.le, JIRA

Software

MS Office, PL/SQL Developer

Tools

MS Office 2010

Client: Pfizer Inc., New York, NY. Duration: Sep 2013 – Feb 2015

Role: Lead Analyst

Project: Validation Center of Excellence

Description:

The Site Health application formerly Healthy Monitoring Application is designed to maintain Plans and Reports of myriad studies pertaining to various medical studies in numerous geographies. Data Validation of this implementation in Pega (UI) and Oracle Database (Back End) was the key task performed using Oracle queries. Also similar validation activities were performed for Pharmaco Vigilance eXchange (PVX) application. The QQI Reporting project which was an add on project involved validating the workflows developed for reporting Quality Improvement reports using IDS of Informatica.

Responsibilities:

Requirement Analysis.

Validation Plan Preparation.

Test Life Cycle Planning & Management.

Test Case walkthrough with Business Users.

Validation of workflow implementations in Informatica IDS.

Source Target Mapping (STM) validations in Database using complex SQL queries.

Daily Status Report / Meeting with stakeholders.

UAT Queries, clarifications and support.

Lead the team by example: Suggested use of Requirements module in QC for Traceability, which was earlier done using spreadsheets.

Solution Environment

HP Quality Center

Software

MS Office, Oracle

Tools

Quality Center v10, v11; Toad 11.0; Office 2003

Client: Cricket Communications Inc., San Diego, CA. Duration: Sep 2010 to Aug 2013

Role: Test Analyst – ETL Team Lead (Offshore / Onshore)

Project: Test Center of Excellence

Description:

The Convergys Billing system implementation involved phasing out of existing billing process and code. Cricket Data Store (CDS) system was phased out and new Convergys billing system was implemented with new set of BODI jobs. Post Billing project, there were few other projects wherein Cricket implemented LTE, National Retail tie-ups, Tax modifications for better customer experience. My team handled verification of data Mappings for new projects and validation of correct data in Enterprise Data Warehouse (EDW) used as source for OBIEE reports.

Responsibilities:

4-point Requirement Analysis from Testability Perspective.

Test Lifecycle management of Releases.

UAT user trainings and support.

Quality Center Admin to manage User access, Reports.

OBIEE reports validation assistance.

EDW data validation using simple to very complex SQL queries.

Data Migration validation performed by BODI & Informatica batch jobs on day-to-day basis.

Solution Environment

Quality Center

Software

MS Office, BODI, Informatica, Oracle

Tools

QC v10.0, Toad v10.6, My SQL developer, Notepad+, Editplus, DOORS, XML files

Client: CISCO Systems Inc., San Jose, CA Duration: Feb 2008 to Aug 2010

Role: Project Lead

Project: Quality Assurance Competency Center

Description:

Quality Assurance Competency Centre (QACC) is an organization within CISCO responsible for monitoring and implementing QA processes glibly across projects. In this we had small as well as big assignments wherein we would take control of QA processes/activities and bring them to the expected level of fluency in case they were not up to the mark. Projects worked included Data Validation and Web page (UI) testing for Partner Self Service (PSS), Partner Access Online (PAL) and Partner Access Admin (PAE) tools of Cisco.

Responsibilities:

Constant interaction with Client for various enhancements/requirements/releases.

End-to-End verification of Front End (Web) and Back End (Oracle RDBMS) implementations.

Share knowledge with cross-functional teams (Automation / Development).

Develop Manual Test scripts that can be readily assimilated into Automation Test scripts.

Test Lifecycle Management.

Post Go-live support.

Evaluation of Team members, budgeting resources.

Solution Environment

Quality Center

Software

MS Office

Tools

QC v9.2, Toad, MySQL developer, UI of applications, XMLs

Role: Tester

Project: Portfolio Management Tool

Description:

The Portfolio Management Tool is an internal tool used by CISCO Managers. This tool is budgeting tool wherein the managers may plan the future costs for planned projects; they may get the forecast reports of their spending as well. Managers may even have minute details of the Resources and their percentage allocations in various projects. The reports are accessible in two ways viz. through Application and through Siebel Analytics.

Responsibilities:

Constant interaction with Client Program Manager for monthly releases.

Requirement walkthrough with stakeholders.

Planning of Test Lifecycle.

End-to-End QA support for Front End and Back End implementations using Oracle DB queries and Test cases.

Report defects and track to closure.

Daily Status reporting to client.

Solution Environment

Quality Center

Software

MS Office

Tools

QC v8.2, Toad, Siebel Analytics

Role: Module owner - Developer

Project: Quickwins

Description:

The Quick Win Team was responsible for providing solutions to the existing issues in the system as well as the long-term solutions. This project was a mini development project wherein the cycle repeats every month for different applications being serviced. The deliveries of the solutions are to be made within 30 days hence the name ‘Quickwin’.

Responsibilities:

Quickwin (Issue) Analysis and Design to merge the solution.

Effort estimation.

Development & Implementation in Oracle Procedures & Packages using PL/SQL.

Unit Testing in Dev, Test environments.

Deployment of solution to Production environment and verification of solution in Live application.

Solution Environment

Oracle

Software

MS Office, Oracle 10g

Tools

Toad, PL/SQL Developer, Serena ChangeMan version manager, Kintana

Client: Hibernian Life & Pensions Ltd., Dublin, Ireland Duration: Sep 2006 to Feb 2008

Role: Team Member - Developer

Project: Hibernian eGroup Pensions

Description:

The project was centred at creating a web application for Hibernian which earlier used the legacy system i.e. Mainframes. The module, in which I was involved, was aimed at creating and checking the “Quotations” that the end user may realise by setting certain parameters. The user may alter the parameters online and seek the change to suit their needs best. The output for my module was through ISIS Papyrus - Document Management System.

Responsibilities:

Prepare high-level and low-level design for module based on system requirement specification (SRS).

Application development in ISIS Papyrus Designer for generation of PDFs for Client quotes.

Created various PL/SQL procedures/packages according to the Client requirements.

Effort estimation, Unit testing, Shell Scripting and deployment to AIX server.

Visual Sourcesafe Admin for repository maintenance and Back Up project code.

Arrange team-building events, fun filled Fridays for team rejuvenation.

Environment

Oracle, ISIS Papyrus

Software

MS Office, Oracle 9i, 10g

Tools

SQL* Plus, PL/SQL developer, Toad, Shell Scripting, ISIS Papyrus Designer v6.2, Shell scripting, Serena Changeman Version Manager, Microsoft VSS.

Contact this candidate