SUMMARY

• 11+ years of professional experience in complete IT project life cycle like Requirement gathering, Application Development, User acceptance testing and post production support.
• Currently performing role of Senior Consultant SME come Technical Architect at Confidential at Boston and Chicago for their data migration and Medicaid Flex Upgrade.
• 6 years of Techno - Functional experience on Managed Market applications like SAP Contract Pricing and Chargeback Component - CPCC, Electronic Claims Processor - ECP, Market Basket Management - MBM, Government Pricing Rebates and Sales Allocation system - GRASP.
• Completed ECP-Model N changes project at Novartis to modify Ideal ECP tool according to Model N suite needs.
• Thorough understanding of Managed Market terminologies and processes right from Contract Authoring, Pricing strategies, Rebate Tier setup, Customer maintenance, Utilization file processing, Sales upload, Managed Care Rebate and Chargeback adjudication and Reconciliation & Mail Retail Ratio calculations.
• Recently worked wif IMS team to provide them the Unbundling data from GRASP-CPCC which halped me to understand bundling/unbundling strategies of products at Novartis.
• Understanding of Government Best Price calculation processing
• Good business noledge of Market basket Management application of Novartis, national and customer market share calculation processes, FDB and IMS national data import process.
• Was technical architect during major enhancements carried out on Ideal ECP tool for Deduping rules, rebate allocation process, NDPDP standard utilization file load which has saved 900 business user’s hours per year for Novartis
• Strong exposure to Managed Market Commercial revenue management tools like SAP CPCC, Model N Life Science Revenue Management Suite and Ideal ECP.
• Considered as Domain Expert personnel for Managed Market area in Novartis
• Responsible for Preparing Project plan, Project Cost estimates, Functional Specification and Detailed Design for Enhancement Modules and presenting them to Client for approvals.
• Worked wif DBMS SCHEDULER in Model N changes for ECP project.
• Trained on Model N Life Sciences Revenue Management Suite 4.3 both on Functional and technical front which involves creation of Price List, Contract Authoring, Approval route setting, Application switches, Customer Commitments etc.

TECHNICAL SKILLS

Operating Systems: Windows XP, UNIX

Languages: Forms 6i, Reports 6i, SQL, Oracle - PL/SQLUNIX Shell Scripting, Microfocus - COBOL.

File Systems and Other Database: Oracle 9i,10g and 11i

Tools: and Utilities: UltraEdit32, Toad, PL/SQL Developer, VSS and True-change. Perforce, Hands-on experience wif Function point and use case based estimation techniques.

Others: Proven experience on Managed Market applications like Model N, CPCC, Ideal ECP, MemberMATCH, CARS Imany etc.

PROFESSIONAL EXPERIENCE

Confidential

Senior Architect

Responsibilities:

• Analyzing their current Medicaid DW interfaces and propose cost estimates
• Design and Develop for FLEX DW interfaces by replacing underlying code/queries/views to keep their structure same
• Present data comparison workbooks between old and new environment
• Develop UAT test scripts and support its execution

Confidential

Technical Solutions Architect

Responsibilities:

• Designing entire data migration interfaces for 6 data streams
• Executing Load routines and Scrub and Feed jobs in GP to populate TARGETS
• Running Price Types in GP and matching it wif Accounting Workbooks
• Test Scripts and UAT execution

Confidential

Technical Solutions Architect

Responsibilities:

• Analyzing AZ’s Contract Management and GP architecture
• Design data requirements for Direct/Indirect Sales, MCO & Tricare Rebates & Fees, GPO Admin Fees, Launch Discounts, Price Points, Medicaid etc and discuss it wif BMS Business and Technical team
• Setup contracts in AZ for these diabetes products according to BMS’s contract data
• Design & Build database schema, Shell Script, Staging Area and Data Migration procedures
• Run GP calculations and verify inclusions of BMS’s product in it

Confidential

Technical Architect

Responsibilities:

• Responsible for implementing full Revenue Management Advantage suite which involved Government Pricing, Medicaid, Managed Care, FSS Compliance etc in client environment
• Gather client’s contract strategy from Business users and provide design documents to implement same in RMA
• Discuss all the oracle PLSQL interfaces like Customers, Products, Category, Direct/Indirect/Custom Sales, Rebates Payments etc wif Auxilium’s technical team and 3rd party vendor
• Design and build Payment Request and Confirmation interface wif SAP

Confidential

Technical Architect

Responsibilities:

• Responsible for leading implementations using Model N’s contract management application suite to assist Merck to maximize revenue
• Analyzed client business processes to recommend more efficient process solutions
• Collected and analyzed detailed customer, product and pricing data to effectively enforce government compliance
• Developed oracle PLSQL dataflow to import legacy data like Product, Customer, Membership, Pricing into Model N and to export data like Paid Chargeback, Contract Pricing, Membership, EDI849 Chargeback Reconciliation, Credit Memo Request to SAP etc.
• Working as Module lead for Chargeback area and responsible to implement end to end chargeback life cycle processing like Establishing GPO & Wholesaler memberships, loading EDI844, Validations Chargeback Submissions & Claims, Sending Credit Memo Requests to SAP, loading Credit Memo Acnoledgement into Model N, exporting EDI849 Chargeback Reconciliations to Liaison & exporting Paid Chargeback data to legacy applications.
• Gained noledge of Model N areas like configuring Validation task & messages, setting up switches, modifying properties, enabling debugging of any particular class or job, scheduling jobs etc.
• Lately involved in Master Data integration where Products, Customers, Price Lists are being loaded into Model N
• Got involved in deploying Model N Baseline Service Patches and Custom jar in Client’s environment

Confidential

Technical Architect

Responsibilities:

• Understand Business requirement for the Membership analysts and discuss the same wif team to proceed wif development.
• Building integration layer wif PLSQL / UNIX for MemberMatch (Internal tool) wif CARS to upload Membership details
• Creating process manual for business users to have them use new methodology that we developed.

Confidential

Project Leader

Responsibilities:

• Requirement gathering and PLSQL Interface designing
• Providing Technical and Functional details of Current interfaces systems like Ideal ECP, MBM, GP, Infoone to Model N team
• Finalizing Scope documents for interface systems
• Oracle Packages Coding and Version Control

Confidential

Project Leader

Responsibilities:

• Involvement in planning and scoping of ECP modules.
• Preparation of Functional Specification and Detailed Design and presenting them to Client for approval.
• Designing of data upload methods to and from Model N using DBMS SCHEDULER and shell scripts.
• Co-coordinating wif Model N business users about ECP extract files testing
• Cognos Report changes
• Preparing UAT test scripts
• Carrying out end to end testing from Loading ECP utilization data - Uploading it to Model N - Rebate payments (done by users) - loading Payment details back in ECP - Reconciliation and Ratio generation

Confidential

Project Leader

Responsibilities:

• Changing ECP system files like .cmd, .inf file, .ora files to accept new values
• Repacking the VB components
• UNIX box setup co-ordination wif IBM and directory, permission, file system configuration for project
• Carrying out End to End testing in Development as well as QA box before starting UAT wif users.
• Registry changes