Technical Consultant Life Sciences

Chander Kalappan

OVERVIEW

●Sr Consultant with IQVIA in the Global Pricing and Contracting Practice within the Market Access Center of Excellence.

●20 years’ experience including 15 years of consulting experience and 6 years of HealthCare and Life Sciences industry.

●Specialization in technical roles in Model N Flex, Model N PxN, and Revenue Management.

●Excellent problem solving and analytical skills.

PROFICIENCIES

•Technical Consultant: Specialization in Integrations, database extracts, loading data into Model N PxN, Flex.

Converting legacy data into Model N.

Developing Interfaces, SQL Scripts and Reports.

•Industry Domain: Pharma/Life Sciences, Telcom, Public Sector and Oil & Gas

●Model N Interfaces worked: Customer, Legal Entity Hiearchy (LEH), Direct Sales, Alignment Relationship, GPO Relationship, Financial Adjustment, Chargebacks (EDI 844), BidAwards (EDI 845) and Contract Conversion

Applications / Solutions:

•Model N PxN, Flex

•Oracle, SQL Server, MS Access

•SQL, PL/SQL, Snowflake

•ETL Tools: Informatica DataStage, Azure Databricks

•Business Objects, Cognos, Tableau,Oracle BI

•Unix, Linux

•JIRA, ServiceNow, ALM, Qtest

•SAP, Sales Force, Workday

•Programming (.NET C#, VB, VBA, ASP.NET)

Education

●Master of Computer Application with specialisation in Computer Application, University of Madras

●Bachelor of Corporate Secretary ship with specialisation in Accountancy (BCA), University of Madras

●Diploma in RDBMS with specialisation in Databases, Software Solution Integration, Chennai, India

Certifications

●Cognos Impromptu Certified Product Professional

●Cognos Power Play Certified Product Professional

●Cognos Access Manager Certified Product Professional

●Cognos Decision Stream Certified Product Professional

●Cognos Report Net Certified Product Professional

●Informatica Certified Designer

●Informatica Certified Administrator

●Informatica Certified Consultant

PROFESSIONAL EXPERIENCE

Sr Consultant, IQVIA 2009 – Present

Technical Consultant, Amgen

oConversion program developed in Azure Databricks to generate output files.

oPrepared test scripts for Technical Interfaces.

oLoad Historical Master Data, Chargebacks, Direct Sales into Model N Powered by N.

oDeveloped Mapping, Design and Code promotion documents.

Technical Consultant, Viatris

oLoad Historical utilization files into Validata data Flex system for Eye care division integration

oLoad Historical Medicaid invoices to settled into Flex system for Eye care division integration.

oLoad Chargebacks into Flex system for Eye care division integration

oPrepared runbooks for Managed Care Rebates, Medicaid and Validata

Technical Consultant, Abbott Laboratories -ADD

oModel N Legacy system to Model N Powered by N upgrade project.

oUpgraded all interface to support cloud environment.

oDeveloped mapping, design and code promotion documnets

oE2E testing.

Technical Consultant, Takeda

oPrepared test scripts for Technical Interfaces.

oDocument the architecture, TDS documentation for interfaces in scope as part of deliverables.

oDocumented and executed test scripts in Qtest.

Technical Consultant, Sanofi

oAs Conversion Lead to load/convert all Sanofi Pasteur Master Data which includes Customer, Products, Pricing related data into Sanofi Model N Flex application.

oDeveloped Conversion routines using PL/SQL

oInvolved in the new interface design and development between Model N Flex system and SAP system which related to Customer, Product, Pricing data.

oProvided Validation and Reconciliation Reports of Pasteur data to Pasteur and Sanofi.

oInvolved in the new interfaces design and development for EDI 844 Chargebacks, 845 Bid Award and Reconciliation 849

oCreated Deployment plan along with tasks and defining the cutover activities for Production release.

oCreated SQL fixes and test scripts for production support fixes.

Technical Consultant, AstraZeneca.

oPerformed Dataflow Analysis current state vs future state for Model N Upgrade

oPerformed Integration and E2E testing

Technical Consultant, Novo Nordisk

oModel N RC(Cloud) upgrade and Informatica Interface development

oDataflow Analysis current state vs future state

oCreated POC’s for EDI 844, 845, 849

oCreated informatica mapping to populate data into fact and dimension tables.

oCreation of test Scripts in ALM

oInvolved in Integration and system testing End to End.

Technical Consultant, Abbott ADD

oThe purpose of this project is to implement Periodic Billing Contract integration with SAP and Amortize Service and Rental contract billing

oDesign and Developed interface

oDeveloped Architecture, TDS and testing documentation

oE2E testing

Technical Consultant, ICU Medical

oModeln upgrade and legacy transactional conversion (Direct Sales, Chargebacks, Rebates)

oExtract Legacy Hospira Transaction Data from Modeln N HIS production and load the data into

oTest Model N application E2E

oFunctionality and UI Testing

Technical Consultant, Abbott ADD

●The purpose of this project is to implement the Contract Lifecycle Management (CLM) implementation will integrate the Model N revenue management application into the Abbott ADD contract management environment

●Involved in multiple interface development like Master and Transactional data

●E2E testing

Technical Consultant, Abbvie

●The purpose of this project is to successfully implement the ModelN Abbott Revenue System (MARS) implementation into the Abbott PPD environment

●Master data interface development

●E2E testing

Technical Consultant, APP Pharmaceuticals

●The purpose of this project is to successfully implement the Pricing Strategy and Execution, Contract Management, Contract Compliance, Chargebacks, Institutional Rebates, Administrative Fees, Government Pricing, Medicaid Claims, Fee for Service, and Revenue Planning Intelligence modules of Model N

●Master data interface development

●E2E testing

Activities

●Defines Data Interface Mappings between source systems and Model N / Flex

●Designs and codes Medium and complex mappings and workflow using Informatica

●Defines all validation and exception rules for incoming data into the Model N system

●Develop initial extracts from legacy systems and transforms into Model N dataflow formats

●Reviews the requirements and design of extraction programs from systems of record for transactional data

●Executes unit testing of ETL interface mappings and workflows.

●Performs Integration Testing

●Model N Interfaces worked:

●Defines Validation and Exception rules for incoming data into the Model N system

●Develop initial extracts from legacy systems and transforms into Model N dataflow formats

●Designs and codes Medium and complex mappings and workflow using Informatica

●Executes unit testing of ETL interface mappings and workflows.

●Performs Integration Testing

●Defines Data Interface Mappings between Model N and external systems (Value Centric VC).

●Defines all validation and exception rules as per VC system

●Develop initial extracts from Model N systems and transforms into flat file formats for VC.

●Design and code complex stored procedures

●Performs Integration testing - Cognos8 Reports

Contact this candidate