SUMMARY

• 11+ years of professional experience in complete IT project life cycle like Requirement gathering, Application Development, User acceptance testing and post production support.
• 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 with IMS team to provide them the Unbundling data from GRASP - CPCC which helped me to understand bundling/unbundling strategies of products at Novartis.
• Understanding of Government Best Price calculation processing
• Good business knowledge 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 with 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 with Function point and use case based estimation techniques.

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 with 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 with 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 with Auxilium’s technical team and 3rd party vendor
• Design and build Payment Request and Confirmation interface with 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 Acknowledgement into Model N, exporting EDI849 Chargeback Reconciliations to Liaison & exporting Paid Chargeback data to legacy applications.
• Gained knowledge 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 with team to proceed with development.
• Building integration layer with PLSQL / UNIX for MemberMatch (Internal tool) with 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 with 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 with 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 with users.
• Registry changes

Confidential

Team Member

Responsibilities:

• Requirements Gathering
• Building the Functional Specifications and the detail design documents
• Coding the PL/SQL stored procedures and reviewing the technical deliverables from offshore
• Batch process designing
• Handling critical night job abends

Confidential

Team Member

Responsibilities:

• Gathering requirement from end user for IT request, doing resource estimates, negotiating it with client account manager and delegating work to team members
• Involve in critical module development with team members and managing overall support activities
• Responsible for Cognizant internal project audits, generating matrix and maintaining internal project tracking portals etracker, Prolite (for defects / issues) etc.
• Night Job Support

Confidential

Project Leader

Responsibilities:

• Involvement in planning and scoping of modules.
• Preparation of Functional Specification and Detailed Design and presenting them to Client for approval.
• Designing of Front end screens by discussing with Business user, creating reports in Cognos.
• Overall project management and adherence to processes of client for progress of the project life cycle.
• Responsible for various database activities like creation, table space management and performance tuning of the same

Confidential

Team Member

Responsibilities:

• Understanding the project requirement, preparing data model
• Involve in technical discussion with project leader and with client
• Capacity planning of Database, responsible for overall database activities which include DB setup for every code drop, managing user privileges etc.
• Creating OQ, IQ and PQ test specification for the project
• Involved in deployment of project

Confidential

Team Member

Responsibilities:

• Responsible for gathering requirement from onsite coordinator and client and present the same to development team.
• Involvement in planning and scoping of modules.
• Preparation of Functional Specification and Detailed Design and presenting them to Client for approval.
• Designing of Front end screens by discussing with Business use, creating repots in Cognos.
• Handling complex database development and space management involved in project and also creation of data model and design specification for the same.
• Also granting and monitoring the various database privileges like system level, Object level for the DB Developer as well as Java Developers.
• Worked with Materialized views, and oracle job scheduler. Also handled assignments which include email notification, extraction and loading process (ETL) using materialized views, Datastage, developing Complex SQL Queries, Triggers, Procedures and Packages.
• Responsible for looking after day-to-day activities and resource management of team.
• Involved in the database objects creation with strictly following the clients coding standards and testing the same.
• Maintaining the version of source code with the help of version control tool like Visual Source safe.
• Done UNIX shell scripting and used SQL Loader to load the data into database. Also done exception handling processes like email sending, logging the error message into log tables etc. in UNIX Shell script.
• Reporting to Project Manager for development status of Project.
• Creating Operational Qualification and UAT test specifications

Confidential

Team Member

Responsibilities:

• Involved in developing Procedure, packages, triggers and functions for the project
• Creating Unit test scripts and executing them
• Also creating system and integration test cases and explaining it to tester.