Philip Varghese Email and Phone Number

Supporting, maintaining, and facilitating upgrades to Revenue Management applications, data management processes and data integration platformBusiness Units - Commercial, Managed Care, Medicaid, Government Pricing, Market AccessVendor ManagementEnterprise System ArchitectureStrategic Road Map planningBPO SupportRFP,RFISOX Audits

• Lead the upgrade of Model N/Revitas Flex 7.10 to implement MRB, GP, RM, Validata, BI modules• Lead and act as a liaison in managing the System Integrator, Product Vendor and ensure implementation of project as per project plan• Works with end-users and IT project teams to gather business requirements for Model N/Revitas Flex 7.10 system upgrade. Demonstrated a clear understanding of the project objectives, IT/business processes and business functions.• Established project plans including resource and timeline requirements. Effectively communicated project status throughout the life of the project.• Lead SDLC phases of projects and delivered on milestones based on agreed upon project deadlines and schedules.• Prepared solution design specifications employing use case documents, diagrams, and screen mockups as applicable.• Assist the business in the development of test plans and test cases, and support them in their execution of user acceptance testing activities.• Assists in the development of test scripts, test cases execution, gather and analyze test results for the remediation and re-testing process.• Assists with the development and execution of change management/training during the implementation or rollout of a new module• Manage change requests from multiple sources and prioritize appropriately.• Configure and deploy change requests while adhering to established change control procedures and documentation requirements.• Solve application incidents, analyze issues and identify their source. Perform root cause analysis to determine and drive potential solutions.• Collaborate with cross functional teams and vendor partners to deliver operational changes.• Participate in internal and external audits and own the remediation to deliver it on timely to comply with SOX/GXP standards. • Works with software vendors, internal teams and 3rd party vendors to troubleshoot complex system related issues

• Assume a technical advisory and Solution Architect role in the development and management of project scope, issues for Pharma client implementing Contract Life Cycle Management, Revenue Management and Analytics Solutions.• Responsible for the development of technical and delivery requirements for the new contract management eco-system. • Work with business stake holders in Contract Management, GTN, Rebates, Contract Strategy; Analytics to design and implement Contract Management systems to meet business needs.• Work with project leadership to define project scope and develop approach to design technical requirements and solution delivery requirements• Lead technical requirements gathering and design sessions and writing technical requirements documents• Summarize findings; develop recommendations and present/communicate results to clients and internal teams• Presentation of deliverable status and results to customer

• Assume a leadership role in the development and management of project scope, issues and escalations while continually setting client expectations.• Provide input to project planning, management, and status reporting internally.• Conduct analysis of client requirements.• Work with client to create functional design of system, to configure systems and coordinate training.• Manage data conversion process, data validation, and system testing. • Gather Business Requirements.• Work closely with process owners and end users to map required business processes and translate them into system data specifications and configurations for system implementation and usage.• Devise new business processes and project plans for system enhancements.• Provide timely and accurate status updates to all levels of management.• Assist in enforcement of project deadlines and schedules.• Prioritize multiple tasks effectively.• Assist the user community with validation and troubleshooting system issues.• Define test conditions. Develop accurate and complete test plans.• Provide support to the Contract Management team for different business areas – Contract Management, Pricing, Gross-to-Net, Rebates, and Chargebacks.• Work with Revitas & SAP to ensure the Managed Care data is accurately captured in the Analytics application• Manage the various interfaces from Revitas – Customer, Product, Pricing, Direct Sales, Chargebacks, Coverage Gap and Tricare.• Support the finance team with Gross-To-Net analytics for different line items. • Manage technical projects and/or software support teams in a matrixed (cross-functional) environment• Interface directly with the business users, management level IT clients, software vendors and other service providers

• Lead the Model N Software implementation and upgrade projects for several clients in the role of a Technical Lead, Data Management Lead, Integration Lead and Techno-Functional Consultant. • Supported the Model N software implementation(v5.3 - 5.7) and upgrade of Medicaid, GP & Commercial modules for several pharmaceutical clients including - AbbVie, Fresenius-Kabi, Ranbaxy, LEO, ConMed• Lead the integration efforts for multiple interfaces – Customer, Product, Pricing, Rebates, Chargebacks, Direct Sales, Indirect Sales, Rx ScriptValidate, Coverage Gap, Tricare• Performed the data conversion and mapping activities from iContracts to Model N • Assisted in the data interface build and testing with external Wholesalers• Assisted with testing activities. Ensure all requirements are met Reviewed all technical design specification documents produced• Validated the ETL process and the enhancement to add additional fields for the SAP – ETL/Model N interface• Engaged in testing and validating changes to the interface and ensuring data quality• Tested Model N functionality for the Commercial & GP modules and authored SOP’s to support the business

Supported the Model N managed care implementation for several pharmaceutical clients such as Corning Life Sciences, Actavis, Novo Nordisk Excellent work experience in Government Pricing, Commercial and Medicaid modules in the Model N application Lead the effort for loading the Legacy Converted Contracts into Model N for Corning Life Sciences Lead the team in a Data Audit and Cleansing project for Actavis Pharmaceuticals. Provided technical and functional guidance to the team to perform data audit on several Master Data areas such as Customer, Product, and Pricing. Was engaged in leading the Performance Testing at Actavis and authored the Test Scenario documents and developed a matrix to track performance issues with the applicationProvided technical insight into database related issues by analyzing jobs, queries, and other metrics Worked closely with the Product Development team at Model N in enhancing queries, running performance tests and there by meeting customer defined SLA’s Oracle database performance analysis including hands-on experience with Oracle AWR reports or Oracle trace files; Java code debugging using IDE (e.g. Eclipse) or any other methods in order to narrow down specific code issues; Troubleshooting application server out of memory issues; Writing SQL/PL-SQL to analyze data or to give direct SQL fixes to customers, including reading/writing complex SQL statements and/or stored procedures; Work with the engagement manager to determine the overall implementation approach Assemble and mobilize technical team in preparation and prepare key activities for the technical work stream Support functional team through requirements sessions and analysis Driving escalations to resolutions, including providing concise problem and next steps summary to both customer and company upper management;

Worked on Project ALIGN to integrate the Legacy and Master Data applications of Merck & Schering Plough Worked on the Phase 1 – Medicaid for project ALIGN with focus on Medicaid Programs, Payments, Claims& Rebates and Pricing subject areas Participated in all aspects of requirements gathering, analysis, design, development, installation, testing, implementation and post-implementation reviews. Developed Functional Requirements, Interface Functional specification and Interface Data mapping documents Worked closely with the Application and Data Integration team on development activities. Participated in data modeling activities and worked closely with the Data Architects in database design Performed UAT, SIT and Production data validations. Investigated data integrity issues in the MMW database using SQL queries and validated against the data in the Model N XML. Proactively communicated and collaborated with the different work streams to analyze information needs and functional requirements and deliver the following artifacts as needed: (Functional requirements, Interface designs, Interface mapping) Validated the Initial load and incremental data for Medicaid Phase and reported data issues to management Extensive front-end working knowledge of the Model N v 5.5/5.6 versions in creating Medicaid Programs, loading/validating price lists, running data flows and investigating functional issues with the application Supported the Model N Medicaid Go Live activities and production support during hyper care Worked in conjunction with the Model N technical team to review unit of work documents

Responsible for executing the day-to-day Service desk incidents, problem tickets, call-support and break fixes. Provided regular updates to the AKT (Application Knowledgebase) documents with troubleshooting common issues of the applications that are being supported. Coordinated and performed all database changes for the R&D Department at Unilever, this includes modifying PL/SQL Packages, Procedures, Trigger and Ad-hoc SQL queries when requested by business users. Debugged the Forms and PL/SQL procedures, functions to fix Oracle database errors RADMIS. Worked on interfacing SAP Master Data files for Sales and Finance with Landing Zone for validation and reporting. Modified the SAP Master Data interface files to include data specific to the business requirements Provided database support for the Landing Zone application (Oracle 10g) for processing the SAP inbound files and outbound extract files. Ensure high levels of application availability, appropriate response, data protection, and other industry standard actions for all supported applications Managing, monitoring & reporting on daily Incidents, Call Support and Problem tickets in a timely manner. Escalated unresolved issues as documented in processes and procedures; maintained ownership of issues through resolution and provide updates to management on critical issues Ensured that the Incident tickets were resolved within the documented Service Level Agreements(SLA’s) Communicated and coordinated project activities with business, technical and IT service organizations Involved in developing Functional and Technical specification documents for enhancements to the SAP interface.

Worked extensively on the PL/SQL based application CTP (Central Transaction Processor) for EDI (814’s, 867’s) development and Accubyl Billing Application and other small initiatives and projects as needed Involved in developing and business tabling inbound/outbound 814 EDI transactions using Oracle PL/SQL objects in CTP for clients in the Texas Utility Market. (Eg: Customer Cancel Switch, Customer Move In/Move Out, CSA, Change Request/Response). Client Files were developed for the new Clients using Shell scripts and PL/SQL  Worked on automating Enrollments and Responses for a Texas client by developing a new EDI transaction (ECR) in CTP using Oracle PL/SQL Procedures, Functions, Packages in a UNIX environment Implemented the 867 EDI transactions (HIU) using PL/SQL packages to process the Inbound Historical Usage Developed and implemented internal Test Plans and co-coordinated testing of outbound and inbound EDI files in Oracle database and verified that the files were mapped correctly in the Oracle PL/SQL packages. Responsible for manual processing of inbound and outbound 814 files in Oracle database that are not automated in CTP using UltraEdit-32. Data manipulation and analysis were done for X12 EDI file formats using PL/SQL, SQL Responsible for assisting Clients and Trading Partner’s with their inquiries in a timely manner. Responsible for inquiries/tickets in the incident Tracking Database (Tracker). On an average 10 – 15 Oracle database related Tickets were handled per day for the Accubyl and CTP applications. Worked on Standard Data Repairs using SQL, PL/SQL on a daily basis using Data Repair Tracker Monitored daily UNIX Batch jobs in Maestro and assisted with job abends that may occur during the run. Monitored the daily bill print files in the FTP server and transferred the files for business review

Worked on billing applications CSB (Residential) and KCS (Commercial) which holds data of 20 million customers. Extensively used Oracle SQL, PL/SQL and Unix Shell Scripting Successfully created and debugged Oracle PL/SQL procedures, functions and Packages for enhancing the billing application. Analyzed requirements for clients, and designed weekly/monthly reports using Oracle Report 6i based on the criteria. Involved in the project of Selling of Accounts, which involved in analyzing client requirement and creating reports for selling Written Off accounts in the system to various collection agencies. Handled large volume of data up to 100 million records using Oracle SQL&PL/SQL

PL/SQL Development - Packages, TriggersSQL TuningSQL Loader uploadsShell Scipts for AutomationWorked with PL/SQL and SQL to developMaintenance of Client Contract Module