
Venu Birapuneni
- Senior Quality Analyst (Lead)
- Philadelphia, PA
- Member Since May 28, 2023
Venu Birapuneni
Core Expertise -Quality Analysis | Data Analysis| Business analysis | Agile Scrum |Project Delivery
Professional Experience Summary
· 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 in integration testing, system testing, user acceptance testing (UAT), functional testing, black box testing, regression testing, API testing, performance testing.
· 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
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.
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
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
· 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.
· 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.
· Involved in writing and testing test scripts using Selenium WebDriver and Java.
· 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
· 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
· 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
• 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.
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.
· Create new templates f the CMMI processes and supported the client level activities.
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.
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:
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:
· Coding, unit testing and system testing.
· Set up penny sweep, close and redemptions, change back to $500.00 set up.
Environment: COBOL, JCL, VSAM, CICS, MQ series, NetX360, SAS and MS Office.
Corporate Insurance Group, TCS, India