Vikin Rani

Morganville, NJ

Email: arvind@itbmsglobal.com

Contact: 732-655-8900 Extn 1032

Key Professional Skills:

ü Over 5+ years of experience in large and mid-level companies as Quality Analyst in Health Care, Banking and Telecom Domain.

ü Extensive experience in QA analysis, assisting in designing Test Plans, designing and executing Test Cases

ü Ability to switch testing Priorities, Manipulating Data and understanding the underlying process details, documenting program bugs and ensuring software meets Business requirements

ü Excellent knowledge in various phases of SDLC and STLC

ü Actively involved in Smoke Testing, Functional Testing, Integration Testing, Regression Testing, Black Box Testing, UAT testing and various testing methods

ü Strong interpersonal and communication skills, ability to understand functionality and approach high-level and unclear requirements with common sense to ensure software reflect accurate intended functionality

ü Experienced to review programs, System Requirement Specifications [SRS], Functional Requirement Specifications [FRS], diagrams, test procedures and flowcharts, and Defect tracking reports

ü Experienced in using Quality Center/ALM, QTP, Test Complete, MS Office, Google Spread Sheet etc.

ü Good experience and knowledge in RDBMS SQL.

ü Experienced working in the health care project like claims, membership and benefits

ü Broad knowledge of Medicare, Medicaid, PPO, HMO, POS, diagnostic codes, and claims process, EDMS (electronic data management system).

ü Good experience working with Claim processing PPO, FEP and ITS blue card, Subscriber/member enrolment, Billing and Provider application in FACETS & Diamond.

ü Hands on experience in HIPPA standards, Medical Claims in Process Documentation, Analysis and Implementation in X12 Standards and 835/837/834/270/271/277/ processes of Medical Claims Industry from the Provider/Payer side.

ü Worked closely with project managers, developers, business analysts and other team members to ensure status and schedules are communicated and met

ü Quick learner, self-motivated, excellent analytical skills, adopt at learning new skills

Technical Skills:

· Platforms: Windows 10/8/7/Vista/XP, Mainframe

· Programming: HTML, CSS, XML, JavaScript, VB Script

· Database: MySQL, SQL, MS Access, Oracle

· Testing Tools: HP ALM/QC, Test Complete, QTP, JIRA

· Browsers: MS Internet Explorer, Mozilla Firefox, Chrome, Safari

· Test Strategies: Integration, System, Regression, User-Acceptance, Black Box, Performance

· Methodologies: Agile, Waterfall, V Model

Education:

MBA from MDU, Rohtak with Specialisation in Human Resource Management 2008 to 2010

Bachelor of Arts from Delhi University 2004 to 2007.

One-year Diploma in Computers.

Work Experience

Client: Florida Blue BCBS, Jacksonville, Florida

Duration: Feb 2015- Till now

Position: Sr. QA Analyst

Florida Blue Corporation focused on serving people who receive healthcare benefits through publicly sponsored programs, including Medicaid, Medicare, State Children’s Health Insurance Program (SCHIP), Family Care and Special Needs Plans (SNP). There were multiple ongoing projects at Florida Blue where multitasking was a key to success

Responsibilities:

• Review and understanding the user stories from SRS and related documents.
• Coordinating with BA and Software Development team for the clarifications of issues in different Requirements

· Used Microsoft excels to write test case and exported to HP ALM.

· Involved in GUI and functional testing of the application.

• Writing SQL queries to compare results with data generated in reports
• Created Regression Test Scripts and performed extensive Regression tests on all fixed defects
• Responsible for logging defects and involving in Defect meetings to prioritize.
• Worked on AGILE methodology /Agile-Waterfall Hybrid environment for software development Testing.
• Tested EDI transactions 270/271, 837, 835, 834(X12) according to the test scenarios.
• Involved in creating Traceability Matrix report in HP ALM/QC.
• Tested informational messages, general messages and medical records for ITS (Inter-plan Teleprocessing Services) and FEP (Federal Employee Plans) Claims.
• Involved in the processing of the ITS claims then uploading the test results in the Quality Center according to test acceptance criteria
• Testing the Professional, Institutional and dental claim processing.
• Creating daily and weekly reports in HP ALM/QC.
• Assisted in User acceptance testing (UAT) testing.
• Involved in testing the functionalities of the application and validated against the requirement.
• Involved in Smoke, Functional, Regression and Integration testing.

· Participated in Sprint Planning, Daily Standup Meeting, Sprint Review Meeting and Retrospective Meeting.

Environment: HIPAA, EDI, QTP, SQL, GUI, Oracle, HTML, XML, Java, WINDOWS XP, Oracle, UNIX.

Client: Tenet Healthcare Corporation, Atlanta, GA

Duration: Jan 2014 to Jan 2015

Position: QA Analyst

Tenet Healthcare Corporation is a healthcare services company whose subsidies and affiliates own and operate acute care hospitals and related ancillary healthcare businesses. Tenet’s hospitals aim at providing the best possible care to every patient who comes through their doors with a clear focus on quality and service. As a QA Tester, I was involved in various kinds of testing of the HIPAA application modules like Membership and Claims.

Responsibilities:

· Involved in writing Test Plan and making sure that the development of test plan is according to the requirements.

· Involved in Back End Testing by creating and running SQL queries.

· Reviewed test assignments, developed test plans and scripts, and conducted test as assigned.

· Used Microsoft excels to write test case and exported to HP ALM.

· Validate EDI Claim Process according to HIPAA compliance.

· Involved in testing HIPAA Database, which incorporates all the HIPAA (Health Insurance Portability and Accountability Act) transaction sets.

· Tested data to check HIPAA- eligible & participation check for individual coverage.

· Involved in creating test scripts and test data files for the HIPAA transaction based on the ANSI X12N HIPAA standards.

· Performed Automation Functional testing using QTP.

· Inserted various check point using QTP, to measure the performance.

· Conducted result analysis and interacted with developers to resolve bugs.

· Assisted in UAT (User acceptance testing) testing.

· Performed regression, system testing and end-to-end testing of the application.

· Involved in GUI and functional testing of the application.

· Created Complex SQL Scripts and embedded them into Unix Shell Scripts to perform the back end testing.

· Tested and validated the database tables using SQL queries and Stored Procedures and performed Data Validation and Data Integration.

· Track and managed bug using HP ALM.

· Participated in Status Review Meetings.

Environment: HIPAA, EDI, SOA, QTP, SQL, GUI, Oracle, HTML, XML, Java, WINDOWS XP, Oracle, UNIX.

Client: Huntington National Bank, Columbus, OH

Duration: November 2012 – August 2013

Positon: QA Tester

The Huntington National Bank is the principal subsidiary of Huntington Bancshares Incorporated a regional bank holding company headquartered in Columbus, Ohio.

I worked as a QA Analyst on three modules: e-Apply; where the customer can apply for various banking accounts like checking, savings or for loans and insurance policies; e-Access, which supports online banking; Online banking application, using which customers can check their balance, pay bills, view transaction from certain period etc. I worked on the Bank’s Cash Management that facilitates the wire transfers and international payments and tested the real time messaging, which confirms the customers initiated wire and status of their wire activity.

Responsibilities:

· Studied and Analyzed the Business Requirements Specification Documents and System Requirements Specifications Documents and identified the test requirements. 

· Interacted with business users to analyze the business requirements and system functional specifications and prepared Requirements Traceability Matrix (RTM) documents to map the business requirements with the functional and technical requirements and test scenarios. 

· Participated in design review meetings to understand technical and functional systems overview. 

· Analyzed user and business requirements and prepared Test Plan and Test cases. 

· Involved extensively in doing back end testing of the data quality by writing complex SQL. 

· Developing and executing SQL queries to perform Data Integrity testing to validate and test data using SQL Server 2008. 

· Conducted the Functional, System, Integration and Regression testing for Functionality of the web application. 

· Used Test Complete to perform Regression Testing/Automation Testing.

· Generated the detailed reports of the Bugs, Pass-Fail report and Assigned defects using HP ALM/QC. 

· Migrated Requirements from Excel to HP ALM/QC. 

· Maintained and updated the test cases and issues log to track the pending defects and statuses from prior releases in HP ALM/QC. 

· Created Status Report, Test Result Report and Weekly Status Report to my Manager. 

· Mapped the Requirements to the Manual scripts and preparing the Requirement Traceability Matrix in HP ALM/QC. 

· Tested compatibility of application with Internet Explorer, Mozilla Firefox and Google Chrome. 

· Worked closely with the developers and BA to get the immediate resolution to the defects. 

Environment: Microsoft .Net Application (C#.Net, ASP.Net), Oracle, HP ALM/QC, Test Complete, Windows XP, UNIX, HTML, Java Script.

Employer : Parwan Telecom Technologies, Noida, India

Duration: March 2010 – August 2012

Position: Jr. QA Tester

PEC is dedicated exclusively to the telecom software field. The entire organization is geared to quality software products that meet the telecom requirements of today, at cost effective prices. I worked on various projects based on end user website testing.

Responsibilities:

• Analyze Business, System requirements and Test Requirements Document (TRD) that are being loaded in HP Quality Center.

• Wrote and executed test cases in HP Quality Center for System Testing and User Accepting Testing (UAT).

• Managed defects using Defect module of HP Quality Center.

• Create defect reports using Dashboard module of HP Quality Center as required.

• Managed manual test cases in HP Quality Center.

• Exported test cases from excel into HP Quality Center using the MS Excel Add in.

• Coordinated in execution of automated testing where used Test Complete tool.

• Executed manual and automated regression test cases after the bug fixes following test scenarios.

• Performed regression tests to verify bug fixes for each release.

• Performed Black box, User Interface (UI), functional, Usability testing of web application and validated business rules.

• Performed Positive and Negative Testing to ensure appropriate user authentication.

• Worked in Agile environment, in which User Stories with its tasks were assigned to me as per the iteration.

• Attended Standup meeting in every morning to get and provide updates to the team.

• Ensured that tasks assigned as per the sprint get accomplished successfully within the timeline.

• Used SQL queries to perform the backend testing of the Oracle database.

• Generating weekly status reports to the team manager, attend weekly status meeting with team members, business analysts and technical team.

• Provide support to the team with any testing, research, and documentation as required.

Environment: Windows, Java, SQL, SQL Server Management Studio, HP Quality Center, MS Internet Explorer, Mozilla Firefox, Chrome, Safari