Life Cycle Quality Assurance

RAJIV KUMAR RATTU

QE Engineer Lead/ QA

Contact: 620-***-****

Email: *******@*****.***

Visa Status: US Citizen

PROFESSIONAL SUMMARY

10+ years of I.T industry experience in Software Quality analysis in all phases of testing life cycle, including requirements gathering, risk analysis, project planning, scheduling, testing, defect tracking, management, and reporting.

Expertise in diverse domain technologies like Healthcare, Banking and Retail.

Experienced in every phase of Quality Assurance Life Cycle (QALC) and Software Development Life Cycle (SDLC).

Serve as a point of contact for the client’s stakeholders and provided customer support in addition to team building.

Experience in software engineering methodologies of SDLC like Agile and Waterfall.

Extensive experience in OOAD representation techniques with UML, which involves Requirement Management using Use Case modeling, dataflow process modeling, Analysis

Design with Interaction and Class diagrams.

Extensive domain knowledge in MMIS, EPIC, EDI X12, HL7, HIPAA, System, Medicare and Medicaid, CMS Compliances/Regulations.

Experience in Designed and implemented Payment Advice Transaction, 837 Health Care Claim Transaction. Populated ICD-9, NDC Disease code sets as per the standards. Experience with transaction sets 834, 835, 837, 270, 271, 276, 277 and 5010.

Strong experience in documenting existing processes, analyzing business requirements, working with requirements traceability matrix, re-engineering business processes and designing.

Expertise in executing different types of Testing Techniques: Smoke Testing, Functional Testing, Integration Testing, Regression Testing, User Acceptance Testing (UAT), Verification and Validation.

Experience in ETL testing with Informatica and Pentaho to ensure business logic in data transformation.

Experience in Webservices testing with SOAPUI.

Experienced in Workflow analysis, and collaborative management system.

Expertise in Problem solving and Defect Tracking Tools like Quality Center, Bugzilla, JIRA, Azure, Rallys and Clear Quest.

Experience in back-end testing to query and access Oracle database using SQL.

Experience in XSL, XSLT for formatting and displaying XML data on browser and familiar with XML Schemas.

Involved in backend testing by writing and executing SQL queries.

Tested the mobile version of the application on Android and iOS phones.

Extensive experience in developing business documents and mapping documentation.

Outstanding communication skills and ability to work effectively with technical teams in order to translate business requirements into an effective technical solution; and serve as an effective liaison between the key IT and business contacts.

Good working knowledge of Claims processing, HIPAA Regulations and 270, 271, 834, 820, 835, 837 and x12 EDI Transactions for health care industries.

EDI transactions (810, 832, 850, 855 and 856) and experience with EDI and EDI outputs, IDOCS, ANSI, partner profiles, master data.

EDI Analyst in Healthcare Industry with extensive knowledge of HIPAA standards, EDI (Electronic data interchange) transactions 820, 834, 835, 837 and x12 Implementation and Knowledge of HIPAA code sets, ICD-9, and ICD-10 coding.

Expertise in various subsystems of MMIS- Claims, Provider, Recipient, Procedure Drug and Diagnosis (PDD), Explanation of Benefits (EOB).

Monitored EDI transactions and troubleshoot any errors or discrepancies to ensure timely resolution and minimal disruption to business operations.

Excellent Reputation for dedicated teamwork and result-oriented approach.

Fluent in a broad range of technologies including business process tools such as Rational Requisite Pro, Microsoft Project, Microsoft Office suite, Microsoft Visio.

Exceptional Communication and interpersonal skills to build productive relationships with colleagues, clients, vendors and other stake holders, providing focused project management.

Ability to achieve targets and deliver results in a high-pressure environment.

Proactive and analytical problem solver with strong leadership and excellent interpersonal skills; also has good client interaction and team skills.

WORK EXPERIENCE

Client: TRINET - Dublin, CA

QE Lead- 02/19 – 03/24

Project: Carrier Vendor Feeds: MFT (Manage File Transfer) and People soft Benefit vendor feed EDI files. Includes benefit files Medical and dental EDI 834, Retirement 401K, Life Insurance, Payroll, workers compensation, Legal etc

Manage team that tests Benefits Carrier Feeds EDI files for all the vendors.

Worked on testing different benefit modules like medical, dental, retirement, 401K, life insurance etc.

Created and analyzed Business Requirements Specifications, System Requirements Specifications and User interface Specifications documents.

Work with the business to identify functional and performance expectations.

Worked closely with business users and IT to write business requirements, create user stories, test plans, and other project documentation.

Smoke testing of test and production environments.

Understand the reporting requirements and assists in trouble shooting issues.

Leverage Jira to create user stories and document project updates.

Confers with functional or technical experts to develop requirements or resolve issues.

Analyzed and documented information system requirements and the corresponding impact on processes.

Collaborate with business stakeholders to define UAT scenarios and test data, ensuring realistic and representative testing environments.

Used Rational Unified Process (RUP)/UML to make an Object-Oriented model for the application and used modeling tools like UML/Rational Rose for creating the Use Cases, Class diagrams, Sequence diagrams etc.

Validated 837 (Health Care Claims or Encounters), 835 (Health Care Claims payment/ Remittance),270/271 (Eligibility request/Response), 834 (Enrollment/Dis-enrollment to a health plan) Developed plan for data feeds and data mappings for integration between various systems, including XML, to follow ICD 10 Code set and ANSI X12 5010 formats.

Responsible for providing UAT Sign-offs for the new features and enhancement.

Worked closely on 834 transaction code for Benefit Enrolment and was involved in Validation of HIPAA for 837, 270/271, 276/277,835, 834 EDI transactions.

Participate in prototyping solutions to provide the business unit a preliminary evaluation and/or user interface experience.

Created and maintained applicable documentation for the entire EDI Process and Keeping abreast of all technical and procedural changes, various additions and enhancements to the data exchange products and associated communications infrastructure affecting EDI.

Involved in documenting end-to-end business workflows, including process steps, inputs, outputs, decision points, and stakeholders involved, facilitating clear communication and process optimization.

Prioritize, track, and escalate all issues to project leads and to resolution.

Worked on EDI transactions: X12, 835, and 837 P.I to identify key data set elements for designated record set. Interacted with Claims, Payments and Enrolment hence analyzing and documenting related business processes.

Define and document EDI business process requirements.

Identified and sequenced project activities, resources, equipment, and costs. Research, consult, analyze, identify, and break down all efforts needed to deliver project objectives and meet timelines.

Analyze complex issues surrounding Enrollment, HR payroll, payroll tax and accounting processes and systems.

Incorporated HIPAA standards, EDI (Electronic data interchange), and code sets, ICD-9 /CPT.

Monitoring and verifying whether EDI transactions are on time and resending file in case of any outbound interruption, requesting the Trading partner to resend the file if we haven’t received it on time.

CAFM Production support and bug fixes and enhancements to ensure consistent payroll practices are used throughout the application.

Well versed in analyzing CRM business processes that include campaign management, lead management, role hierarchy, account management, case management and multi-tier environment

Involved in test case preparation of test procedures, test scenarios,, test cases and test data, tested companies CRM application

Creating and testing salesforce CRM workflows, approval processes, validation rules.

Documented Test Estimation and Test Plan

Conducted UI testing and UAT signoffs

Working as a defect lead for UAT tracking defects raised in UAT and representing team for queries and concerns related to defects.

Worked on phases of SDLC and various methodologies.

Performed Functional testing of web application and functional design.

Facilitated discussions involving business rules and EDI 834 files

Developed data flow diagrams, illustrating the flow of data from the Legacy systems into the Application database Tables, along with checkpoints for testing / verification.

Analyzed user requirements, attended the Change Request meetings to document and notify the changes that are implemented/ or needed to be implemented.

Represented as a Lead for testing Weekly Builds and monthly releases.

Prepared JIRA status report and executed Test cases in JIRA

Ran the complex SQL queries using sql developer and Postgres

Environment: JIRA, Confluence, Urban code, Jenkins, Hippa 834, AWS, Selenium, ANSI5010, HIPPA, API, ERP, SQL developer, Postgres, Azure, Putty, PeopleSoft, Wrike, WinSCP, 5010, CloudBees, SAP HCM etc.

Client: BANK OF AMERICA - San Francisco, CA

Mobile QA Lead: 05/18 - 02/19

Project: Mobile Downloadable Application (MDA): Worked on project Olive (3% discount) on credit card purchase for customer and Small business cards, also assigned modules like Erica (chat bot), Deeplinks, Transfers, Regression 7.8 .

Manage team that tests Bank of America app features across all Mobile browsers (Android & iOS)

Created Test Plans for major releases in Bank of America and reviewed Test Cases that

covers all aspects of mobile platforms & devices ( iOS and Android)

Collaborate with technical teams for any required integrations with third-party applications.

Establish communication schedule to set expectations and identify responsibilities for each project team member. Update stakeholders on the progress of the project.

Help monitor project progress, identify risks, and implement mitigation strategies to meet project deadlines and goals.

Promote and verify quality in all releases.

Responsible for providing QA Sign-offs for the new features and enhancement in Mobile downloadable app.

Verified and updated card holder data information, account information and authorization of transaction in green screen of mainframe application

Actively involved in Requirements analysis with Product and development team

Documented Test Estimation and Test Plan

Represented as a Lead for testing weekly Builds and quarterly releases.

Prepared Weekly status report.

Executed Test cases in QC ALM

Logged defects in ALM and Rallys

Responsible for the execution of Functional Test suite and Regression tests on weekly Builds.

Used splunk for data conditioning

Used MyCTO for checking the logs

Reviewed wireframes created by architecture team

Performed mobile testing using emulator and simulator for Android and IOS devices using Perfecto.

Environment: QC ALM, Perfecto, Splunk, MyCTO, Rallys, Jira, IOS, Android, Iphone, Ipad, Wrike etc.

Client: WELLSFARGO BANK - San Francisco, CA

BSA Lead: - 08/17 - 02/18

Project: Whole Sale Common Authentication (WCA): Wholesale Common Authentication is a lightweight authentication channel that supports authentication and standardized user identity management for external facing application and Wells Fargo Private label offerings.

Actively involved in Requirements/Usecase analysis with team and the Product owners in Elaboration phase.

Developed Use Cases for the regulatory reporting tool. Verified that the Use Cases matched the application’s every single requirement.

Develop business solutions using information technology methods, keeping the different perspectives of major stakeholders across several departments in consideration.

Documented the Business Requirement Specifications and developed the requirement Traceability Matrix

Performed Functional testing of web application and functional design

Created Test scenarios from Requirement documents and authored testcases.

Prepared Traceability matrix for the Usecases from Requirement documents to the testcases.

Worked on phases of SDLC and various methodologies.

Performed the testing in different data centers in the production Environment.

Performed the condition testing by conditioning the users in Putty

Performed the scope and prioritizing the regression testing.

Tested Web Services (REST) API’s using SOAPUI

Manual and Automation testing of UI.

Automation framework in Java using Selenium.

Experienced in identifying object locators and creating Page Factory.

Performed Designing and execution the automation scripts using Selenium-WebDriver

Continuous Integration and Automation Framework

Performed backend testing using SQL developer environment.

Environment: QC ALM, SQL developer, SOAPUI, TestNg, Selenium, Json, Windows, Putty

Client: WESTERN UNION MONEY TRANSFER - San Francisco, CA

QA/BSA Lead: - 09/16 - 07/17

Project 1: WUPOS Retail: The purpose of the project is to provide Western Union with a gateway or API that would allow any country where Western Union has a licensed entity to easily and quickly implement the ability for WU agents to take debit card payment through WUPOS. Also gateway or API integrates with any processor required to support debit card transactions.

Project 2: Western Union Speedpay: The purpose of the project is to Integrate Speedpay with the Western Union Apollo gateway to connect to Credit Card Networks. Apollo will Integrate with required Networks 'Payment-tech, FDMS North, TSYS and VANTIV' in order to process Credit Card payments on behalf of the Speedpay biller client base.

Developed Use Cases for the regulatory reporting tool. Verified that the Use Cases matched the application’s every single requirement.

Documented the Business Requirement Specifications and developed the traceability Matrix.

Managed onshore and offshore QA and BA resources

Submitted test Status and Test Evaluation Reports.

Developed Test data for Test Scenarios for Pre-Authorization, Initiation, Authorization and Capture and Settlement of Payments

Verified and updated card holder data information, account information and authorization of transaction in green screen of mainframe application

Involved in rigorous meetings with testing team, development and BA team to plan and implement testing efforts.

Executed the test cases in Quality Center and HP ALM

Performed module testing of API using SOAPUI

Certification testing of Apollo with First data, TSYS, Payment-tech.

Identified and resolved system bottlenecks in Performance Testing

Performed payments Batch testing

Tested the mobile version of the application on Android and iOS phones to ensure that it functioned similar to the desktop version.

Worked Exclusively on Apple Pay Payment

Managed Test Scripts and ran transactions using the Card Debit/Credit on Speedpay and WuPOS Simulators

Very good exposure of testing applications on wide range of Mobile handset of different vendors which includes Nokia, Samsung, Google G1, Sony Erricson, Motorola, Windows Mobile, HTC, LG, Iphone and many more.

Performed functional, UAT testing GUI testing with Mobile/ Smart (iOS and Android) devices to verify overall system behavior.

Performed Mobile Automation with SeeTest

Automated the test cases using selenium-web driver.

Conducted End to End Testing of Front end gateway, channel services and payment processor.

Responsible for Certification Testing with Payment processor

Used verifone VX805 and VX820 for placing Retail Transactions.

Validated all kinds of payment methods cash credit cards, debit cards etc.

Validated swipe, contactless, EMV, credit cards debit card and cash transactions

Tested different type of payment cards Visa, Mastercard, American Express, diner card

Conducted API performance testing with ALM Performance center

Tested 50 TPS for 48 hours.

Used JIRA for logging defects and user story tracking.

Attended Scrum calls with the offshore teams

Environment: HP ALM, SQL developer, SOAPUI, Performance testing, Selenium, Jira, SpeedPay Simulator, WuPOS Simulator Performance Center, Dynatrace, Android, iOS, SeeTest.

Client: ROCHE MOLECULAR SYSTEM INC - Pleasanton, CA

QA Engineer - 06/16 - 09/16

Project: RAFT- Run Diagnosis Analytical and Forensic Tool. Worked on various modules like Admin Login User Login, Privileges, assigned investigations, Unassigned Investigation, Cells, Runs, Search, Escalation, Diagnosis, Run Reports etc.

Actively involved in Requirements/Usecase analysis with team and the Product owners in Elaboration phase.

Participated in Sprint Planning sessions. Created QA sub-tasks with right estimates for the user stories.

Created Test scenarios from Requirement documents and authored testcases. Prepared Traceability matrix for the Usecases from Requirement documents to the testcases. This helped good test coverage, thus reduced bug leakage into production.

Performed Functional testing for the User stories. Reported bugs using Jira bug tracking tool and tracked them to closure. Also involved in exploratory testing.

Reviewed the Server logs for errors and exceptions and found non UI issues.

Involved in defining the regression scope and prioritizing the regression testing. Helped reducing regression effort from 3,00 testcases to 65 testcases for this release.

Tested Web Services (REST) API’s using SOAPUI

Developed TestNg framework in Java.

Manual and Automation testing of UI

Automation framework in Java using Selenium

Wrote Test cases in ALM

Logged defects in JIRA

Continuous Integration and Automation Framework

Performed Database testing on GoldenGate environment.

Involved in Documentation and Release notes review

Environment: QC ALM, SQL developer, SOAPUI, TestNg, Selenium, Jira, Json, AirFlow Windows, AWS S3, Google Chrome.

STATE COMPENSATION INSURANCE FUND, Vacaville/Pleasanton, CA

QA Performance Engineer - 09/12 - 04/16

Project 1: CARE and ECF, Claims applications. Worked on various modules, Payments includes Comp Payments, C&R, Stip Medical, Manage A Claim Establish A Claim, Subrogation, Letter Generation, Profile, Estimate, Balance, Calculator, Claim Life Cycle Management, Inbox, AML Red Flags PDRS, UR Referral, Document Repair, Subpoena Request, Miscellaneous money transactions etc.

Project 2: Oracle Upgrade: Performance Testing of Database Upgrade of Oracle 10g to Oracle 11g

Reviewed Business Requirement and Functional Specification docs for writing test cases.

Experienced in defining, creating and implementing testing process and methodology.

Prepared Test Plan and Test Cases based on business, technical and functional docs.

Submitted Status and Test Evaluation Reports.

Developed Test data for Test Scenarios as per the functionality of the application.

Involved in rigorous meetings with testing team, development and BA team to plan and implement testing efforts.

Review Test case written based on the Change Request Document.

Executed the test cases in Quality Center and HP ALM

Attend meetings to discuss all the outstanding Issues.

Validating the data at the backend.

Testing techniques performed include Smoke testing, Functional, System, Regression, Integration on HCM, CRM, Business Objects, Quest and Crystal Reports for Raptor Application

Perform Analysis/Support on BI, HCM - Time and Labour Modules after go-live

Extracting the data from the database using SQL DEVELOPER.

Extracting the data by running the SQL queries on the database.

Logging the defects in to QC.

Tested the mobile version of the application on Android and iOS phones to ensure that it functioned similar to the desktop version

Expertise of testing the application developed using various mobile technologies including J2ME, Blackberry, Android, Symbian, .Net Technology

Developed Load Runner scripts

Executed several performance test scenarios using LoadRunner and analyzed results

Tested in web services testing using LoadRunner

Used LoadRunner to create Vuser Scripts using VuGen, used Controller to generate and executed LoadRunner scenarios. Perform root cause analysis to detect memory leaks and bottlenecks in servers and enterprise applications, and proposed resolution for performance tuning.

Involved in establishing a new performance test baseline to develop a new performance benchmark and execution of the new benchmark.

Responsible for troubleshooting of problems related to LoadRunner and license issues with close cooperation with HP Interactive support team.

Monitored the Load test using Solar Winds and Sitescope.

Environment: QC ALM, SQL developer, Toad, Load Runner, Windows XP, VMware, IE8, IE9, Mozilla Firefox, Dynatrace, Solar winds

UNITED HEALTH GROUP, Eden Prairie, MN

QA Analyst lead - 04/12 - 06/12

Project 1: Web services Project, Master Patient Index (MPI) administration application enables MPI administrator to search and modify records in MPI and to configure the operations of the application.

Project 2: ETL Project, Data intake and architecture was one of the four pillars of OCS (OptumCare Suite) was a Data ware housing Project, in which data is loaded from internal sources (OCS) and external sources ICD9 and CPT and HCPCS.

Analyzed business requirements and segregated them into high level and low-level Use Cases,

Sequence diagrams using Rational Rose according to UML methodology thus defining the data Process Models.

Finalized Use Cases with the team members to develop Functional and Detail Design

Specification of the application.

Collaborated with stakeholders, including IT teams and business units, to gather and document detailed requirements for the EDI system.

Interacted with the Developers and Project Managers to provide Test plans and Test cases for the major infrastructure and enhancements projects in Scrum model.

Developed data mapping documentation to detail the transformation logic and field mappings between source systems and EDI files.

Generated testing status reports including precise replication steps for the Dev/Project Management Department as a part of the daily scrum meetings.

Reviewed Business Requirement and Functional Specification docs for writing test cases.

Conducted Web services testing using SOAP UI

Conducted data validation using SOA client.

Performed security testing, Webservices testing, UI testing, Data validation.

Used VMware to test applications on different operating system.

Wrote test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center.

Developed Requirement Traceability Matrix, which maps requirements with test cases.

Used Citrix to for cross browser testing

Created Test input requirements and prepared the test data for data driven testing. Used back-end database SQL queries.

Designs, creates, modifies and validates ETL mappings incorporating business rules.

Validated all the ETL code according to the business rules and relational user stories.

Used Rally to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.

Performed testing of ETL process, data migration and database performance after the target load.

Executed different DDL test scripts for data validations.

Experience to write SQL queries by using DDL and DML language and can write join queries

Created SQL database, including stored procedures and triggers.

Executed SQL queries to validate the data in target database.

Executed jobs in Pentaho

Participated in defect review meetings with the team members.

Environment: Quality Center, Rally, SQL developer, Pentaho Toad, SOAPUI, Java, Windows XP, Shell scripts VMware, IE8, IE9, Mozilla Firefox, HIPPA 5010

Client: BLUE SHIELD OF CALIFORNIA, San Francisco, CA

QA Analyst - 01/11 - 02/12

Project 1: SgMART: Project is called SgMart (Small Group Maintenance Automated Retrieval Tool. SgMART is Web application developed for Member Enrollment for subscriber and group maintenance and tool serves as a tracking means for installation and Membership.

Project 2: FACETS upgrade: The project was facets upgrade; Blue shield was upgrading facets 4.61 to 4.81 due to change in Datamodel as per business new need. There are different modules like Claims, Provider, Billing, Accounting, Plan, Member for that data is migrated from facets 4.61 to 4.81.

Designed and executed the test plans, test scripts, to check the data validity for various applications, tracking software and specification defects and resolution using Quality Center, documenting all phases of QA life cycle, analyze functional requirements, mapping documents.

Analyzed Business Requirements, use cases AGILE (SCRUM), high level designing and detail technical design of .net application.

Conducted testing and validation of EDI transactions and data mappings, identifying and resolving discrepancies to ensure data integrity.

Worked on EDI transactions: X12, 835, and 837 P.I to identify key data set elements for designated record set. Interacted with Claims, Payments and Enrolment hence analyzing and documenting related business processes

Maintained and updated EDI transaction maps and configurations to accommodate changes in business requirements or trading partner specifications.

Created business process test plans and test cases using Quality Center

Performed functional, Integration, regression of the application.

Wrote and executed automated Data Driven Test Scripts in QTP for different test scenarios, inserted various checkpoints to check web pages, table contents, databases, bitmaps and text.

Responsible for all types of tests like Business Functionality, Load Testing, Documentation testing, User Acceptance Testing (UAT), browser compatibility testing, Integration testing and maintain technical design documentation in Oracle and Windows environments.

Attended Daily Defect/Issue Discussion Meetings during End-to-end testing

Used Merrant Tracker as a defect tracking tool.

Reviewed computer logs and reports to identify application processing errors and possible improvements.

Interacted with the team members and participated in review meeting with developers and Business Analyst's for understanding the requirements.

Written source validation query using inline view, joins in SQL.

Performed Verification, Validation, and Transformations on the Input data before loading into target database.

Develop and maintain EDI documentation, including process flows, user guides, and standard operating procedures.

Validated source and target data by writing SQL query using different string functions, group functions in SQL

Used TOAD tools to connect to Oracle Database to validate data that was populated by ETL applications.

Involved in backend testing for different environments like System Testing and User Acceptance Testing.

Categorized and grouped test cases and managed them in Mingle.

Environment: Oracle, SDLC, Quality Center, .NET, MS Office 2007, MS office 2010 Access, EXCEL, SQL, TOAD, Window XP, HIPPA.

EDUCATION:

Pittsburg State University, Pittsburg, KS

MS (Engineering Technology)

Punjab Technical University, Punjab

B. Tech (Electrical Engineering)

Contact this candidate