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