PRIYA JOHN M Current Visa Status : H* EAD

**** **** ******* ******,

PACOIMA,CA 91331

Mobile: 949-***-****

E-mail : adbyq7@r.postjobfree.com

PROFESSIONAL SUMMARY

Over 9 years of professional experience in QA software testing with full system development lifecycle experience, including designing, developing and implementing test plans, test cases, test Scenarios and test processes in Web oriented, middleware and client server applications. Experience in testing of ETL testing, data warehouse testing, Point of Sale testing, 4690 Operating System Testing, Web Testing, and Embedded System Testing.

SUMMARY

Over 9 years’ experience in ETL testing, Data warehouse testing, Point of Sale applications, 4690 Operating system, UFT (Unified Functional Testing),Web Applications, C#, and Embedded Systems testing.

Attended mongo DB training and good knowledge.

Hands on experience on Accounting.

Hands on experience on mobile testing.

Hands on experience on Microstrategy, Tableau.

Hands on experience on API testing and E2E testing.

Hands on experience on JIRA, database querying using JQL, Confluence and sococo.

Hands on experience on SOA, j2EE platforms, mainframes, MQs, xml, web services

Strong Technical skills & experience building integration scripts, sql, pl/sql, stored procedures, triggers.

Hands on experience on iOS and Android app or game testing

Hands on experience with QA Project Management in VR, console, or PC video games

Hands on experience on mobile applications on iOS and Android devices

Knowledge on TFS, Rally, SharePoint.

Hands on experience on Coding and testing skills on UI, API and backend testing

Strong knowledge on membership data load and claims processing.

Strong knowledge on Siebel, Oracle.

Has received quarterly award for innovation in 2015 and 2017 also.

Professional Scrum Master Certified

Scrum Master Accredited Certified.

Attended training on QNXT.

Hands on experience in facets.

Did M.S (Masters) in Applied Electronics and Bachelors in Electrical and Electronics Engineering.

Worked as Business analyst and scrum Master also.

Provided support to anthem audit

Strong knowledge on grievance and appeals and good understanding about medicare and medical projects.

Currently working as a Test Manager for HCA Medicare project for Anthem.

Actively involved in LOE preparation and project management.

Efficiently leading and managing testing team both onsite and offshore and handling teams with team sizes of 10+ people.

Very Strong Experience and through understanding of software quality activities throughout the software development life cycle (SDLC) and Scrum

Hands on experience on money transfer system.

Expertise in analyzing Business requirements, Functional and Technical Specifications and strong working experience in developing Test Strategies, Test Plans, Test Cases, creating Test data, defect management including reporting, analysis and defect metrics.

Experienced in building testing teams right from scratch including devising the selection process and actively participating in interview panels and training programs

Hands on experience in Tracking and Reporting of defects using Defect Tracking Tools such as Clear Quest, HPALM, Rally, HP/Mercury Quality Center.

Extensive experience in ETL testing and strong knowledge on data warehouse testing.

Excellent knowledge on Teradata and SQL

Solid Back End Testing experience by writing and executing SQL Queries.

Expert in Rational Quality Manager RQM and RTM.

Expert in testing 4690 operating system, UNIX, XML Command line.

Professional experience in Black Box Testing, White Box Testing, Functionality Testing, Performance Testing, Integration Testing, System Testing, Backend Testing, Load Testing, Regression Testing and User Acceptance testing.

Experience in integration of various data sources with Multiple Relational Databases like SQL Server, MS Excel, MS Access.

Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)

Strong knowledge on JIRA

Experienced and detailed understanding of Agile/Scrum, Waterfall and SDLC methodologies.

Extensive working knowledge in Health Care and Retail Domain Testing, Embedded System Testing.

Good experience in Process Flow Charting, Root Cause Analysis in UAT.

Good experience in Bug Tracking tools like Clear Quest, HPALM and Test director

Hands on experience on testing of network, software or an integrated environment.

Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.

Strong analytical, design skills and problem solving abilities with quick turnaround.

Result oriented, self-starter and able to work with minimum or no guidance.

Proven ability to understand business problems and apply technology to formulate feasible solutions.

SKILLS SUMMARY

Testing Tools

ETL testing,UFT,SQL Server, HP Quality Center, HPALM, Clear Quest, Rational Quality Manager, Requirement Traceability Matrix, POS Testing, Toshiba 4690 operating system Testing, Rational Performance tool

Bug Reporting Tools

Clear Quest, HPALM 11.0, HP Quality Center 9.2 / 10.0/11.0,Rally, Test Director

Programming Skills

C/C++, XML, HTML,JAVA,Ruby

Data warehouse

Teradata

ETL tool

Informatica Power Center 8/7

Database

MS SQL 2008/2008R2/2012, MySQL, MS Access, DB2,IMS, Oracle

Operating Systems

MS DOS, Windows, WINDOWS XP, WINDOWS VISTA, UNIX, IBM 4690

Web Technologies

HTML, XML, SOAP, VB Script, Java Script

Web Browsers

Firefox, Internet Explorer, Chrome, Opera

Project Methodologies

SDLC, Agile Scrum, Waterfall

Microsoft Office

Word, Excel, Visio, SharePoint

Other Tools

MATLAB,LABVIEW,MS Word, MS Excel, MS Office, MS Project, MS Power Point, FTP,TFS

EXPERIENCE HIGHLIGHTS

UST Global, Los Angeles, CA, USA

(MAY 2015 – MAY 2018)-ONSITE

Designation: Test Manager

Projects

(1) HCA Medicare Revenue Datamart

There is no dedicated DataMart for Medicare specific data that makes the analytics & reporting part difficult which in turn hampers business and services improvement schemes. Purpose of building Medicare Revenue DataMart (CMS_RDS) is to establish a data foundation (DataMart) specific to Medicare Phase 1 and this effort deals with loading of Medicare and Clinical Data into Raw Medicare Revenue DataMart. This will enhance analytics capabilities that drive clinical interventions to support the Medicare population and improve reporting capabilities for Medicare Revenue business areas including risk adjustment and STARS. The transformation of these files is part of phase 2 effort.

Responsibilities:

Worked as a Test Manager for HCA Medicare project for Anthem

Hands on development experience on ETL and Teradata.

Hands on experience on JIRA

Efficiently leading and managing testing team both onsite and offshore and handling teams with team sizes of 10+ people.

Test artifacts creation – Test strategy, test plan, test cases, test evaluation summary

Hands on experience on Tableau.

Hands on experience Trizetto facets.

Hands on development experience on ETL and Teradata

Deep knowledge of Health care life cycle from start to end (Member Enrolment – Provider Maintenance – Payer Claims– Prior Authorization – EDI Transactions – Claims Payment)

Provided a new design to RAPS transformation in Anthem Medicare revenue DataMart and received lot of appreciation from Anthem stakeholders and management.

Worked on complex projects like related complex project like HCC risk score, HCCGAP, Accumen,RAPS transformation, Acumen, MAO004, MAO001, MAO002, MPWR, PDE, HCCMODD, HCCMOFD, PTDMODD, PTDMOFD, HCCMOFD, Chase list, Intervention, EDPS.

Strong Technical skills & experience building integration scripts, sql, pl/sql, stored procedures, triggers.

Review the Requirement analysis document, Test Cases,Test Plan, Test execution Results and Test evaluation summary document .

Hands on experience on API testing and E2E testing.

Defect Management in Clear quest– Log and track defects to closure, defect triage, defect reporting

Extensively involved in Database Testing.

Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.

Hands on experience on Teradata and strong knowledge on SQL queries.

Experience in integration of various data sources with Multiple Relational Databases like SQL Server, MS Excel, MS Access.

Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)

Strong knowledge on Healthcare domain.

Found lot of seveority1 defects and which in turn made as Change requests.

Actively involved in LOE preparation and resource planning.

Suggested lot of business enhancement ideas and received lot of customer appreciation mails.

Interacted with the Developers to discuss about the Defects raised and follow-up, and involved in the Defect Triage meetings.

Involved in all phases of SDLC (Software development Life cycle) and followed Agile methodology.

Hands on experience on bigdata and python.

Hands on experience on talend ETL.

Worked in migration project from Teradata to bigdata.

Train the new joiners in the team on application and business concepts.

Given requirement walkthroughs and test case walkthrough to client.

Task allocation, status reporting, execution and coordination between onsite and offshore team.

Proficient in solution identification, Effort estimations, project scheduling, implementation processes, project tracking, team management metrics collection & analysis to facilitate process/product improvements

Effective in communicating project status, test deliverables and issue escalations to key stakeholders on product quality

Environment: TERADATA, SQL server, Informatica,Bigdata,Python,Clear Quest and ETL testing,JIRA,SOCOCO,CONFLUENCE.

UST Global, Bentonville, AR, USA

(June 2014 – May2015)-ONSITE

Designation: Test Lead/scrum Master

Projects

(2)Walmart (SNE update and regression test Store systems, POS, QA)

SNE is Store Number Expansion Project .Walmart and SAM’s club currently uses a four digit number system to identify stores, clubs, distribution centers and home office departments. Store number variable definitions currently have a size limitation that typically limits them to support 4 digit store numbers up to 9,999. This limitation will be expanded out to a small integer (32,767) during this phase. Store Number Expansion Project is to update all systems, applications and processes that have a store number size limitation to accommodate 5 digit store number to support Wal-Mart’s continued growth. 4690 operating system is used for POS registers. 4690 is widely used by IBM's retail customers to drive retail systems running their own applications as well as IBM's Application Client Server Environment (ACE), Supermarket Application (SA), General Sales Application (GSA), and Chain Drug Sales Application (CDSA). 4690 supports applications written in IBM 4680 BASIC (a variant of CBASIC), Metaware High-C, and Java 2.

Responsibilities:

Handled scrum master role.

Hands on experience on Accounting.

Hands on experience on Agile TFS test management

Hands on experience in an agile/DevOps release environment

Train the new joiners in agile and scrum framework.

Hands on experience on Mercury Quality Center 9.0

Hands on experience on iOS and Android app or game testing

Knowledge on HTML, JavaScript, AJAX, CSS, jQuery, XML, XSL, JSON, SOAP

Hands on experience on testing web service using SOAPUI

Hands on experience on HP load runner.

Hands on experience on Selenium.

Experience on REST, API testing.

Hands on experience on testing of MacOS, iOS, and Windows platforms

Strong knowledge of the iTunes Store and available content types.

Hands on experience on mobile testing.

Hands on experience on SQUISH Mobile App.

Experience on Money transfer system

Experience with HPALAM-- Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting to Developers, Tracking Defects

Interacted with the Developers to discuss about the Defects raised and follow-up, and involved in the Defect Triage meetings.

Perform 4690 operating system testing

Hands on experience on mobile applications on iOS and Android devices

Extensively involved in Database Testing.

Involved in all phases of SDLC (Software development Life cycle) and followed Agile methodology.

Check the files sent in SMART/POSHOST during running the SNE Specific application and do back end system testing. Find the store number in the files sent.

Review the Requirement analysis document, Test Case and Test execution Results.

Hands on experience on selenium

Strong knowledge on WorkdayHCMS

Analyze the unit test plan and put the queries in clarification tracker and then to share point.

Train the new joiners in the team on application and business concepts.

Created WIKI pages for SNE Remediated Applications

Coordinating requirement walkthroughs within team to ensure the team is up to date with application changes.

Regression testing

Run different types of transactions like Layaways transactions

Train the new joiners in the team on application and business concepts.

Environment: HPALM 11.0,4690 operating system, XML, Share Point, Window NT/XP, HTML, Excel, UNIX,SMART,POSHOST,FTP

UST Global, Kerala, India

(June 2013– June 2014)

Designation: Senior Tester

Projects

(3) WellPoint Senior Online Stores (Testing Centre of Excellence -TCOE)

The Senior Online Store is the fully integrated Electronic Enrollment platform for Consumer Senior Business. Senior Online Store is a web based portal which provides an option for the US citizen who is above 65 years of age and any individual with an ESRD(End Stage Renal Disease) or with certain disabilities to view, choose and enroll into a suitable Medicare plan online i.e. Enterprise Shop/Quote/Enroll portal for Medicare products. Online stores provide multi-channel experience for Consumer Shoppers, External Brokers, and Telesales Agents and Strategic partners.

Responsibilities:

Experience with HPALAM-- Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting to Developers, Tracking Defects

Hands on experience on UFT

Hands on experience on Coding and testing skills on UI, API and backend testing

Worked as a business analyst

Executing the Test cases against the business requirements in test environment and publishing the status to stakeholders.

Experience with RQM-Requirement Mapping, Test case Execution, Test Suite Execution, report generation

Review the Requirement analysis document, Test Case and Test execution Results.

Leading the peer review Group and guiding the team to complete planned reviews on time.

Validation and execution of the batch job streams

Managing all RQM related Activities like template creation, mapping and Execution.

Interact with onsite and business stakeholders for requirement clarifications.

Train the new joiners in the team on application and business concepts.

Defect Identification, reporting and co-ordinate issue resolution.

Documentation of the learnings and best practices.

Coordinating requirement walkthroughs within team to ensure the team is up to date with application changes.

Tracking, monitoring and Effort tracking.

Coordinate Requirement walkthroughs by SA.

Worked closely with Automation team and executed the test cases in QTP.

Involved in Functional, Regression, Performance and Sanity testing.

Developed and executed SQL Queries to perform database/backend testing.

Took sessions to the Automation team regarding the application and executed test suites using Selenium.

Interacted with developers for resolving the defects and setting the priorities

Performed all phases of testing which includes Black box testing, Functionality testing, Regression Testing, GUI testing, negative testing, and system testing of the application

Managed the offshore team by creating the tasks and assigning work to the team, interacted with the Leads and managers

Took online Sessions to offshore team members regarding the business requirements and functionality.

Regularly scheduled Knowledge transfer meetings to offshore team regarding the Application functionality

Generated Documents for teams and Uploaded in Share point

Handled multiple offshore teams by interacting with the Leads and managers

Involved in the Daily Status calls and follow up’s with offshore teams.

Coordinated between Offshore and Onsite managers to share the business logic with them.

Given Presentations to the Product owners about nice to have features in the application.

Uploaded Daily Status in SharePoint for tracking

Environment: HPALM 11.0,Quality Center, Clear Quest,SOA testing,Batch job Running, Database testing, SQL, XML, Share Point, Window NT/XP, HTML, Excel, SOAP UI

Optical Zonu, 15028 Delano St, Van Nuys, CA 91411, USA

(October 2009–December 2012)

Designation: Software Engineer

Optical Zonu Corporation is a privately owned high technology company located in the San Fernando Valley of the City of Los Angeles, specializing in the design and manufacturing of Fiber Optic Components for Analog Transmission, Digital Transmission, Business Class Services and Coarse Wavelength Division Multiplexing. OZC is the leading supplier of Full Duplex, Single Fiber, Single Wavelength Transceivers and RF over Fiber Optic Links. OZC maintains important strategic and global relationships in the Industry and cooperates with major vendors and suppliers of optical, communication and electronic devices, to enable rapid production of cutting-edge solutions.

Projects

1) OZ100/OZ 450 - Compact, Modular, low cost series of individual Transmitter (TX) and Receiver (Rx)

2) OZ810 optimum long reaches RF over Fiber Transceiver

3) OZ 9000 CHASSY

4) GPS over Fiber Optics System

GPS over Fiber Optics System allows signals to be carried from an antenna to a GPS receiver with minimal signal degradation over a non-conducting dielectric glass media. This system provides a completely transparent cross-site connection between an antenna and receiver.

Roles & Responsibilities:

Worked as a business analyst also.

Reviewed the business requirements in detail once test request is initiated.

Worked with IT team for test environment setup and test data if not provided.

Walk through of the test plan, Test cases with the development team and ensured that they are in sync with the Business Requirement/RTM created by IT.

Created System Test Plan and Test cases and ensured that they are in sync with the Business Requirement/RTM.

Experience in HPALM - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting to Developers, Tracking Defects.

Performed Defect Identification, reporting and issue resolution.

Followed appropriate defect life cycle management plan for retest and closure of the defect.

Mapped Requirements to Test Cases for Requirements Traceability Matrix

Co-ordinated weekly team meetings and onsite-offshore calls.

Quality controller for the production environment and status reporting to Senior Management.

Involved in developing detailed test cases and test scripts using Rally for Functional and Regression Testing

Performed regression testing and validated fixes to the system using QTP.

Work with developers, business and Release managers to discuss ways to fix the Defects.

Supported the production line in the form of testing, trouble shooting and various modular assemblies for both RF over Fiber line and also digital SFC line.

Executed the test procedure for each individual module and ensuring that it meets Quality standards of noise figure, intermodulation distortion measurements like IP3, OIP3.

Additional responsibilities include Quality control, generating corrective action report, administrative functions and other supports for management.

Environment: QTP, HP Quality Center 10.0, Query Analyzer, XML, Window NT/XP, HTML, Unix, Web Services, SOAP UI, Windows server 2008.

Indian Space Research Organization, Kerala.

(July 2007- August 2008)

Role: Project Engineer(Radio Frequency Department)

In this project, an analog transmitter is implemented in the digital way. I have used Direct Digital Synthesizer technique for frequency generation. The DDS used here is AD9910.The work focuses on design, development and implementation of Phase Modulated transmitter using Direct Digital Synthesizer AD9910.For serial programming PIC 18F8722 Microcontroller is used. Phase modulation is performed here and 70 MHz phase modulated output is obtained. This transmitter is used in Launch Vehicles.

Roles& Responsibilities:

Designed the hardware through ORCAD software.

Programming was done using PIC18F8722 Microcontroller.

Major responsibilities were designing the hardware, designing the code, and verifying the output.

Presented a seminar on this project at ISRO.

Helped the ISRO official staff to prepare the official documentation.

EDUCATION, TRAINING & CERTIFICATIONS

Passed M-Tech in Applied Electronics Engineering from M.G University.

Passed Btech In Electrical and Electronics from M.G University.

Contact this candidate