octobre 2010 - août 2011
PROJECT PROFILE 1: Wellpoint Facets Central
Domain Healthcare
Location Cognizant Technology Solutions, Chennai
Operating Systems Windows 2000, Unix
Software Sybase, Unix Shell Scripting
Project Abstract
WellPoint, a Health care company provides a range of services. WellPoint is one of the leading health benefits company serving the needs of approximately 34 million medical members nationwide. WellPoint is included in the S&P 500 index.
This project aims at upgrading the WTX maps into 5010 version and to translate all claims data received electronically from the ANSI 837v4010/ v5010 file format to Facets XC format Roles and Responsibilities in the project
My responsibilities are:
• Performed the entire analysis pertaining to interface IC19 and worked directly with a client SME in sharing mode
• Created Sybase stored procedures and UNIX scripts for processing claims file in 5010 format. Modified Sybase stored procedures and UNIX scripts for processing claims file in 4010 format.
• Upgraded the 4010 WTX 837 maps into 5010 Errata version 837 maps.
• Performed unit level testing and job level testing
• Involved in End to End testing of Claims processes.
• Involved in ST support and created X12 test files.
• Performed system integration testing for some of the interfaces in various modules.
• Prepared Unit Test Plan, Technical design document, Migration document, ST hand off document etc.
• Mentored a couple of Entry Level Trainees in the team and has played an important role in bringing them up to speed on all processes involved in the Claims module.
Tool IBM Websphere Transformation Extender 8.2,Facets Data Model, Clearcase, SQR Reports, Letters
mars 2009 - septembre 2010
PROJECT PROFILE 2: Facets Upgrade from 4.41 to 4.71 for UHCRV,UNISON and GLHP
Domain Healthcare
Duration
Location Cognizant Technology Solutions, Chennai.
Operating Systems Windows 2000, Unix
Software MS SQL server 2005 stored procedures, DTS Packages, Unix Scrips
Tools Used Gentran, IBM Websphere Transformation Extender 8.1
Project Abstract
UnitedHealth Group (UHG) is an innovative leader in the health and well-being industry, serving more than 50 million Americans. The company combines outstanding clinical insight with consumer-friendly services and advanced technology to help people achieve optimal health
This project aims at identifying all impacted stored procedures and other components due to version change of Facets system and remediating those impacted components to the new upgraded Facets system.
Roles and Responsibilities in the project
My responsibilities include:
During Development:
• Involved in the identification of data type change and version change in the huge number SQL stored procedures due to Facets System upgrade from 4.41 to 4.71.
• Analyzed the SQL stored procedures for Data type change, Data length change, Deleted columns, new columns added, Values added and values deleted details in approximately 8000 custom stored procedures for Great Lake Health Plan.
• Prepared a detailed excel document with the analysis results and explained it to onsite.
• Analyzed the mainframe(JCL) components and Created MS Visio flow diagrams for the mainframe jobs.
• Tested the EC maps in HIPAA gateway.
• Remediated the impacted components in development environment.
• Involved in the preparation of Technical design document, source code and unit test case document and test evidence.
• Provided Technical and Functional guidance to the team of trainees.
• Reviewed the Technical design document, source code and unit test case document and test evidence prepared by the team of trainees.
During System testing:
• Lead a team of 3 members to test all the processes related to Claims
• Review of system test case document and test evidences of the team.
• Managing the KT with developers, offshore, onsite review of design documents of SIT and testing of the processes, raising defects and tracking the status of the defects till its closure and verification of the code fix for the defects.
mars 2008 - mars 2009
PROJECT PROFILE 3: Accelerated EDI Consolidation(AEC)
Domain Healthcare
Duration
Location Cognizant Technology Solutions, Chennai.
Operating Systems Windows 2000, Unix
Software Oracle
Tools Used IBM Webshpere Transformation Extender 8.1
Project Abstract
WellPoint, a Health care company provides a range of services. WellPoint is one of the leading health benefits company serving the needs of approximately 34 million medical members nationwide. WellPoint is included in the S&P 500 index.
AEC project aims at consolidating the Legacy EDI Gateways in California, Georgia, Virginia, and New York. This will result in a single Enterprise EDI Gateway to exist for all states/brands and provide an enterprise-wide trading partner solution
Roles and Responsibilities in the project
My responsibilities include:
• Involved in the analysis of business requirements, design document preparation, coding and testing.
• Modified the 835 WTX maps and made the corresponding changes in oracle tables, stored procedures.
• Made the trade partner entries in the test environment.
• Performing Unit testing and System testing.
• Prepared detailed program specification technical design document for the given requirement.
• Prepared the Unit Test case and System test case documents.
• Modified the Unix scripts for various applications.
• Performed integration testing.