Venu Birapuneni

  • Senior Quality Analyst (Lead)
  • Philadelphia, PA
  • Member Since May 28, 2023

Candidates About

 

Venu Birapuneni

Core Expertise -Quality Analysis | Data Analysis| Business analysis | Agile Scrum |Project Delivery

Professional Experience Summary

  • A  Senior Lead Systems Quality Analyst with ten plus  years of IT experience in Software Development Life Cycle, Analysis, Design, Development, Testing and Integration of client/server, web and legacy applications in the Healthcare, Finance and Banking domains.
  • Extensive testing experience in Banking, Financial and Health Care Industry as a Manual and Automated Tester specialized in QTP, Selenium tools package.
  • Extensive experience carried out as QA Consultant in creating test strategy, test plans, test scenarios and executing Test cases for both web based and client-server applications from business and end user perspective.

·         Experience in complete software development life cycle (SDLC) methodologies- Agile/Scrum, Waterfall and V-model.

·         Worked extensively on legacy modernization, data integration, data migration, data design, data profiling, data modeling, data quality and data management.

  • Experience as  a Business Systems Analyst  in Requirements Elicitation, Requirements Analysis, GAP Analysis, data Analysis, Systems Analysis, business process reengineering and Root Cause Analysis (RCA).

·         Experience in integration testing, system testing, user acceptance testing (UAT), functional testing, black box testing, regression testing, API testing, performance testing.

  • Experience in gathering reporting requirements from the business users for business intelligence, data warehouse application.
  • Extensive experience in data analysis, ETL techniques for loading high volumes of data and smooth structural flow of the data.

·         Experience in various aspects of project/program management/PMO, coordination among the offshore/onsite/client teams.

·         Experience in development of the user stories, closely worked with product owner, scrum master and other stakeholders in the agile scrum model.

·         Experience in the development of tasks according to Capability Maturity Model Integrated (CMMI) Maturity Level 3.

·         Proficient in the application of EDI ANSI X12, EDIFACT, EDIFECS, Facets, QNXT, HL7 ,NASCOand HIPAA Standards.

·         Good understanding of the US healthcare market and knowledge in the healthcare operations, business processes etc.

·         Experience in Health Edge products such as Health Rules Manager and HealthRulesDesigner.

·         Experience in Facets modules –utilization management, claims and enrollments

 

Technical Skills

Languages

COBOL, SQL, PL/SQL, VB, C++, C#, Java, JavaScript, HTML, XML

Databases

MS Access, Oracle 8i/9i, DB2, MS SQL Server, Teradata, Mongo DB

Operating Systems

Windows, MVS/ESA,UNIX, Linux, Z/OS and AIX

OOAD and DESIGN

RSA (Rational Software Architect), Rational Rose, UML with Class, Sequence and Use case diagrams, Rational Requisite Pro, Visio and Enterprise Architect

Packages

Rational Rose, Requisite Pro, Clear Quest, I log J-Rules

EDI Tools

BizTalk server, Tibco , IBM-WTX, IBM Sterling Gentran Integration Suite 3.1/4.1/4.2/4.3,ANSIX12,Gentran Server

Office tools

MS Office 2003/2007 (Word, Excel, Power Point, Outlook), MS Visio, Lotus Notes, Microsoft Share Point, and MS Project.

Testing Tools

QTP 8.0, Rational Functional Tester, HP ALM(Quality Center), Load Runner, Clear Quest, SOAPUI,REST, JIRA, Test Rail, Test Director, TFS ,Selenium IDE, Selenium Web Driver,Test NG Framework, Cucumber.  and Bugzilla

Data warehousing(DWH)

Informatica Power Center, Informatica Power exchange, IDQ, Erwin, Evoke, Business Objects, Crystal Reports ,Cognos, MSBI,BTEQ and Teradata Data Warehouse

Version Control:

PVCS, SVN, CVS, Clear Case

 

Education

  Bachelor of Engineering (B.E) passed with First class

 

Certification

  PMP from Project management Institute (PMI)

 

Professional Experience

 

IBC - AmeriHealth Administrators (AHA), Philadelphia, PA,                                                         Apr’16- till date

Leap Projects –Senior Quality Analyst (Lead)

Responsibilities:

  • Analyze Requirements and develop Business Testing Requirement Definition (BTRD).
  • Create Test Cases and Test Plan from the business requirement document.
  • Create and request test data for the test execution.
  • Complete Test Execution and Report Defect Findings.
  • Participate in scrum calls, Defect triage and product release meetings.
  • Create test data for the new membership subscription records, changes and cancellations.
  • Create enrollment data for EDI 834 validations such as add new member, term, reinstatements.
  • Run the User acceptance test cycles for the client migration.
  • Validate and review the EDI 834 feed to Health Rules Manager.
  • Validate the various services of the member portal using SOAP UI.
  • Create claims, searching for and editing claims in Health Rules Manager
  • Test the EDI 837 claims for the customer migration project.
  • Lead the onsite and coordinate with offshore team.
  • Proactively provides the defect resolution and actively participates in the technical discussions.

Environment: BizTalk server, HealthRules Manager, HealthRulesDesigner, C#, WCF, XSLT,J2EE, .NET Framework 4.5, ASP.Net, DB2, Use cases, Facets, SQL Server 2014,SSIS, Business Objects, Agile, REST ,JSON, SOAPUI, JIRA,HP Application Lifecycle Management 12.6 and MS Office.

 

Health Plan Services (HPS), Tampa, FL,                                                                                                 May’15- Apr’16

Aetna On boarding (Go-to-exchange) –Quality Analyst Lead/System Test Analyst

HealthPlan Services (HPS) is the nation’s largest independent provider of sales, benefits administration to the insurance and managed care industries. Its Go-To-Exchange platform used for enrollment, reconciliation, eligibility, subsidy and premium billing, member services and renewals for over 5.0 million members

Responsibilities:

  • Perform business requirements analysis, design documents for completeness and testability.
  • Develop system integration test plans, test scenarios, test cases, test data and test scripts from the Business requirement document.
  • Run the 834 enrollment cycle end to end and validate the data as per carrier standards.
  • Perform the execution of UAT test cases, test scripts; captures test results, test metrics and reports.
  • Co-ordination with multiple/cross functional platform teams of Service Link and Exchange Link
  • Involved in writing and testing test scripts using Selenium WebDriver and Java.
  • Conduct integration testing of the functionality WTX EDI developed components.
  • End to end system testing for connectivity with Carrier and retest SIT defects
  • Smoke test Environment for the readiness in UAT region.
  • Validate the data using the DB2 SQL for the various enrollment scenarios across SIT, QUA and UAT regions.
  • Validate and test the claims feed from sample Enrollment database.
  • Used JIRA for the defect tracking and resolution tracking.
  • Lead the test team at onsite and work with client carrier teams.

Environment: IBM WebSphere, IBM WebSphere Transaction Extender, PHP,  CMS,  JAVA,  XML, ETL frameworks, EDI 834,  IBM DB2, SOAPUI, WSDL, Selenium IDE, Selenium Web Driver, Test NG Framework, Medicaid, Medicare, EDIFECS,CMS, REST, HP Quality Center ,SQL/PL SQL, Scrum, User stories ,JIRA, CMMI, Share point and MS Office

 

AmeriHealth Administrators (AHA), Fort Washington, PA,                                           Sep’14- Apr’15

Leap Migrations Senior Systems Test Analyst Lead

Responsibilities:

  • Analyze Requirements and develop Business Testing Requirement Definition (BTRD).
  • Create Test plan and test cases from the BRD.
  • Create the test data, run the test scripts and Report Defect Findings.
  • Participate in Defect Meetings with Development team.

·         Create claims, searching for and editing claims in HealthRules Manager

·         Work with claims batches, adjusting claims financials.

·         Validate and review the EDI 837 feed to HealthRules Manager.

·         Create and execute SQL queries to fetch enrollment, claims data and compare expected results with those actually obtained.

·         Used JIRA for the defect tracking and resolution tracking.

·         Worked on the provider reports testing.

·         Worked on Health Rules Payor 5.3 regression testing.

·         Lead and guided the QA team from offshore as subject matter of expert.

Environment: BizTalk server, Health Rules Manager, HealthRulesDesigner, C#, WCF, XSLT,J2EE, .NET Framework 4.5, ASP.Net, DB2, Facets, Scrum, User stories, SQL Server 2012,Business Objects, Crystal Reports, SOAPUI, HP ALM 11.00 and MS Office.

 

Experian, Costa mesa, CA                                                                                                            Jun’11-Jul’14

NextGen NL and AU Customization-Senior Quality Analyst -Lead

Responsibilities:

·         Worked closely with the business leads, project managers and product manager to baseline the business requirements and identify the test requirements early in the project lifecycle and helped to identify the requirement gaps.

·         Created test plan and test strategy for the customization.

  • Created Input/output mapping, business rule, and data load/ validation documents.
  • Develop user stories for the consumer credit report test cycles/
  • Co-ordination with multiple/cross functional platform teams.

·         Involved in writing and testing test scripts using Selenium WebDriver and Java.

  • Participate in defect triages with project manager, product manager, and development teams.

·         Defect management - Raising defects In Clearquest, assigning to the concerned developer.

·         Documenting the testing process and actual results in Quality tracker.

·         Closely worked with scrum masters, product owners in identifying the user stories, EPICS and helped weekly product demo to the client.

·         Track the defects assigned to developers and keep up on their status using JIRA

Environment: JAVA, ECLIPSE, DB2, CEARQUEST, Toad, Informatica, Pentaho, Kettle, Selenium IDE, Selenium Web Driver, Test NG Framework, SQL, MS Visio, User Stories, JIRA and Version One

 

Coventry Healthcare, Downers Grove, IL/Chennai, India                                                               Oct’10- Mar’11

LA Medicaid/5010 HIPAA 834–Senior Quality Analyst (IT)-Data Migrations

Responsibilities:

·          Worked on the LA Medicaid and 5010 HIPAA 834 compliance project.

·          Main responsibility is to test software functionality, compatibility, and system integration as per CMS mandates.

·          Participated in user requirement gathering, product design, and testability of products.

·          Created as-is, to-be process flows, RTM and Test Plans.

·          Documented and supported development of test plan, test scenarios, test cases and the executed test cycles.

·          Tested the enrollment and premium billing modules in Facets integration.

·          Created work in progress and status reporting on the testing progress for management.

·          Developed, maintained and executed manual and automated tests (system, integration, and regression).

·          Performed the extensive UAT testing on the 834 enrollment files for validity and business rules.

Environment: IDX,.NET,FACETS ,SQL Server, Teradata, Informatica, Teradata SQL Assistant ,See Beyond, CMS,Medicaid,ICD10, HIPAA,EDIFECS,MS office, MS Project, MS Visio , JIRA and Rational RequisitePro

 

Well Point Healthcare-Anthem, North Haven, CT                                                            Jun‘10–Aug ‘10

CIS Phase II–EDI Business Systems Analyst/Quality Analyst

Responsibilities:

·         Created requirements document and data mapping for phase II for sources systems  WMDS,ECC.TRIMED,CP

·         Research and analyze the data gaps among source systems and provide resolution.

·         Created and executed test plans, scenarios and peer reviews to test Mainframe and ETL Applications.

·         Tested 837 claims adjudication process and validated the results against source system applications WMDS, ECC.TRIMED and CP.

·         Created and executed SQL queries to fetch data and compare expected results with those actually obtained.

·         Tracked, reviewed, analyzed, and compared defects using Quality center.

·         Tested the Utilization  and CASE Management modules  of FACETS

·         Created GAP ANALYSIS document for BI Reports migration

·         Conducted internal knowledge sharing session in areas of domain

Environment: ACES, FACETS, Informatica Power Center Version 8.6.1, Teradata SQL Assistant ,SAS,UNIX, Business Objects  XI R3,EDI,ANSIX12,MS office, MS Project, MS Visio and Rational Requisite Pro

 

Viant Health Care Payment Systems, Naperville, IL                                                          Apr ‘09 – Mar ‘10

Viant-Lake Forest EDI migration- EDI QA Lead

Responsibilities:

•      Requirements analysis, converted business process needs into testing requirement document.

·         Created GAP ANALYSIS document for EXTOL (old system) to GIS (new system) migration.

·         Created test strategy document for phase1 migration.

·         Developed process flow diagrams for as is and to be systems.

·         Prepared test plan and test scenarios for the migration.

·         Performed functional and Integration Testing of the applications.

·         Validated the HL7 interface for the migration project.

·         Tested the 837claims-professional/institutional. File level comparisons, claim level comparison.

·         Tested the business logics on Claims Processing /repricing in  Medicaid, NASCO and Medicare.

Environment: Gentran Integration Suite 4.3, IBM I Series for AS/400, HIPAA, ANSIX12, EXTOL integrator, NASCO, Medicare, ICD 10,HSA, FSA,FACETS,HL7,EDIFECS,UNIX, JAVA, Informatica, MS office, MS Project, MS Visio and ORACLE.

 

Bright point, Plainfield, IN                                                                                                            Jun ‘08 – Feb ‘09

EDI Support–EDI QA Lead

Responsibilities:

  • Identifying all the stakeholders and their requirement needs.
  • Worked with technical team for solution design documentation and s/w development.
  • Created the test plan, test cases for the EDI partners on boarding.
  • Tested the  inbound and out bound mapping transactions(EDI ANSI X12 850,855,856,857,810)
  • Performed SIT, UAT and Regression test cycles.
  • Responsible for the successful production implementation and client sign offs.

Environment: Gentran Integration Suite 4.1, Gentran Server 5.2 for UNIX, ETL, JAVA, SQL Server, Oracle 10 g, Shell Scripting, SQL, TOAD and MS Office.

 

Ameriprise Financial Services, Minneapolis, MN                                                                              Jan ’07 – Jan’08

Get Profile- Senior QA/BSA Lead

Responsibilities:

  • Understand the requirement (PRD), develop the project test plan and guide the QA team throughout the test life cycle.
  • Developed Requirements Traceability Matrix (RTM) to track requirements.
  • Project review and status meeting with deployment teams and proactively look for risk signs.
  • Executed d SIT, UAT and Regression test cycles.
  • Manage Knowledge Transfer Process and induction plans.

·         Create new templates f the CMMI processes and supported the client level activities.

  • Offshore-onsite coordination.

Environment: JAVA, SOAP, JavaScript, Information security Access Management (ISAM), SSO (Single Sign On), WAS 5.1, IBM DB2, EPIC, Data warehouse, Informatica,   Lotus Notes, Quality Center, CMMI OPF  and Microsoft Project.

 

Cigna Healthcare, TCS Offshore, Chennai, India                                                                 Jan ‘06 – Dec ‘06

Claims Adjudication - EDI Analyst/Tester

The Claims Adjudication offshore supports the major business area for Cigna both in terms of technology and functionality coverage around the clock 24 hours .It also includes EDI support.

Responsibilities:

·         Requirements analysis – Converting business process needs into EDI requirements.

·         Created cross-reference documents to aid in mapping phase.

·         Configuring the EDI documents such as 270,271,274,276,277,834,835 and 837.

·         Developed test plans, Unit testing, assisted in system and user acceptance testing.

·         Tested the EDI transactions as per the implementation plan.

·         24x7 Production Support and onsite coordination.

Environment: Gentran Integration Suite 3.1/4.1, HIPAA, EDI ANSIX12, UNIX , Oracle, 8i, SQL ,MS Visio ,Use cases, Mainframe,cobol,db2 and MS Project

 

Medibank (Healthcare), Chennai/Melbourne, Australia                                                                Jan ‘05 –Nov ‘05

CDR / Lead Quality Analyst                         

Responsibilities:

·         Developed test cases after analyzing the specifications document

·         Prepared test scripts using SQL queries.

·         Understood requirements and job flows from the development team

·         Created and executed SQL queries to fetch data and compare expected results with those actually obtained

·         Tracked, reviewed, analyzed, and compared defects using Quality center.

  • Offshore coordination with the client / users and offshore team.

Environment:  IBM 3090, VS-COBOLII, JCL, VSAM, DB2,  Informatica Power center, UML, Informatica Power exchange, Quality Center 7.0, Data Warehouse, SAP,PEOPLESOFT, ERWIN and MS Project.

 

Bank of America, Jacksonville, FL                                                                                              Feb ‘03 – Dec ‘04

APECS-AGEN-VECTOR4 / Project lead/Business Systems Analyst             

Responsibilities:

  • Worked on compliance project –APECS-Regulatory reporting to States.
  • Also worked on Account Generation (AGEN) project which provides new accounts to entire bank customers.
  • Project/work requests estimations and preparation of SOW.
  • Performed Modification / Enhancement of COBOL programs and JCL’s.
  • Production support and business  continuity testing(Disaster Recovery testing)
  • Participated in Process Improvement sessions.

 

Environment: APECS, JCL, COBOL, SAS, VSAM, ENDEVOR, BTEQ, Teradata, CMMI and MS office.

 

Pershing Technology/ BNY Mellon, NJ                                                                                  Apr ‘00 – Dec ‘02

Automated Cash Management Conversions/ Programmer Analyst         

Responsibilities:

  • Analysis of the specifications provided by the client. Preparation of Detailed Design Documents.

·         Coding, unit testing and system testing.

·         Set up penny sweep, close and redemptions, change back to $500.00 set up.

  • Managed the Defects from initiation through closure of the defects and Production support.

Environment: COBOL, JCL, VSAM, CICS, MQ series, NetX360, SAS and MS Office.

 

Corporate Insurance Group, TCS, India