SUMMARY

• Around 15+ years of experience in system analysis, development and testing of Database Applications based on Oracle 9i, 10g, 11g, 12c, MS Access and Intranet applications (J2EE, EJB, JSF, JSP, JQuery, JPA, Eclipselink, Hibernate, Servlets, XML, Web Logic, JDBC, HTML, Java Script)
• Possess strong functional, analytical, technical and hands - on experience in Pharmaceutical Contract Administration, including Managed Markets and Government Contracting; Health Care Services industries’ business processes and Child care management domain
• Strong expertise in Oracle 9i, 10g, 11g, 12c (SQL, PL/SQL, Stored procedures), MS Access (versions 2003, 2007, 2010)
• Strong technical skills in developing enterprise web-application using J2EE technology
• Hands on experience in tuning queries and database procedures
• Expertise in Rational Rose (UML), OOAD
• Good experience in functional testing, performance and stress testing, unit testing
• Hands on experience in maintaining Quality documents for audit purposes
• Good communication and inter-personal skills, accustomed to work in a team environment and cross train sub-ordinates in other Functional areas

PROFICIENCIES

Programming Languages: Java, SQL, PL/SQL, Visual Basic

Operating Systems: Windows, UNIX and Linux

Databases: Oracle 8i, 9i, 10g, 11g MS Access (versions 2003, 2007,2010)

Technologies: J2EE (JSF, JSP, Servlets, EJB, RMI, JMS, JPA, Eclipselink, Hibernate, JDBC), JDK, Swing

Tools: PL/SQL Developer, MFT, Toad, Eclipse, NetBeans, Crystal Reports (versions 10 and 8), VBA (Visual Basic for Applications), Rational Rose Enterprise Edition, Developer 2000 Forms, Developer 2000 Reports, MS Visual Interdev, Front Page, JUnit

Application Servers: JBoss, IIS

Applications: Confidential Flex (formerly Revitas Flex), I-many CARS, I-many CARS NG, I-many Medicaid, I-many Government Pricing, Confidential PREP, Mindlance-Government Pricing, Mindlance-Archive Utility, Mindlance-Data Audit Tool

EXPERIENCE

Confidential | Edison, NJ

Solution Architect

Responsibilities:

• Responsible for co-ordination, implementation and managing technical activities of Cumberland’s Fast track Revitas implementation for its BPO clients.
• Designed and developed several custom tools and applications to automate data cleansing, data loading, reporting and file transfer activities collectively for several clients.
• Involved in design sessions of Client Portal development for Payment Processing that interfaces with several other payment and reporting systems.

Confidential, San Francisco, CA

Solution Architect

Responsibilities:

• Co-ordinated, Designed and Developed a web application for consolidating and validating rosters from external sources like GPO & ONA entities and interface it with Revitas Flex application.
• Responsible for Oracle database and interfaces design that caters to Application needs.

Confidential, San Francisco, CA

Technical Lead

Responsibilities:

• Performed complete data analysis of Business unit configuration to identify duplicates, potential incorrect assignments of Business unit identifiers from external sources in Revitas legacy CARS application, compare and report all inconsistently active Business units in CARS application and other external sources that feed information into CARS
• Provided recommendation to rectify the inconsistencies before Revitas classic CARS to Flex CARS upgrade

Confidential

Technical Lead

Responsibilities:

• Involved in auditing classic CARS data to identify any possible inconsistent data that may exist. This was performed to facilitate and help clean up of data before migrating to Confidential System from Revitas Classic CARS System
• Created a configureable oracle tool CARS- Confidential Data Migration Tool based on Oracle 10g, to read, validate and transform domain data like Business units into XMLs to feed into Model System using its Data Flow utility
• In another initiative of CSL to clean up the Class of Trade information of its Customers, an extensive study of Class of trades and NPI database was performed to identify accurate COT information and recommend changes to CSL

Confidential | Morgantown, WV

Technical Lead

• Analyze, enhance and configure Mindlance Archiving tool for archiving Domain data in Revitas CARS

Confidential | Spring Grove, IL

Senior Technical Consultant

Responsibilities:

• Confidential - MS Access application with Baxter’s latest Pricing methodologies for Monthly AMP, ASP, Quarterly and Annual NFAMP and BP calculations
• Design and implement customs in Mindlance GP tool specific to Baxter
• Compare and validate above mentioned calculation results from Revitas GP application with Mindlance GP tool results and provide evidence for the validity of implementing the new methodology in Revitas GP application by Mindlance

Confidential | Eatontown, NJ

Senior Technical Consultant

• Confidential - MS Access application with West Ward’s latest pricing methodologies for Monthly & Quarterly AMP and ASP calculations
• Execute price type calculations and provide detailed reports to West Ward and enable the client to validate iContracts application’s calculation methodology

Confidential | Princeton, NJ

Senior Technical Consultant

• Design and Create a configurable Migration tool in Oracle 10g/11i that can convert Revitas CARS data (Oracle based) into XML files recognized by Confidential application

Confidential | Walnut Creek, CA

Senior Technical Consultant

• Design and development of custom Oracle procedures (Oracle 10g) for extracting Revitas CARS Rebate data and Balances application into Revitas’s Reporting Data Store (RDS)
• Design and development of custom analytical reports using Crystal Reports 8 to report data from customized RDS application

Confidential | North Wales, PA

Senior Technical Consultant

• Design and development of Oracle SQL (Oracle 10g) queries for data extraction model of Teva’s Revitas Electronic Claim processing application into Teva’s centralized Data warehouse

Confidential | North Wales, PA

Senior Technical Consultant

• Involved in functional analysis, testing and Implementation of Mindlance Archiving Utility for CARS
• Performance tuning of Remote and Local Installation of the Utility

Confidential

Senior Technical Consultant

• Involved in coding, Unit testing and implementation of CARS NG front end customs on Contracts module

Confidential

Senior Technical Consultant

• Performed domain data analysis in Revitas classic CARS, provided solutions for data cleanup
• Involved in developing custom oracle procedures for Rebate processing and reporting using Extdat module of CAR

Confidential | St. Louis, MI

Senior Technical Consultant

• Involved in Performance Tuning of Chargebacks load, Direct sales load, Customer load in GP from CARS interfaces

Confidential

Programmer Analyst

Responsibilities:

• Team leader for GDS ( Confidential Documentation System) Java and Oracle based application module of Merrill Lynch for 2 years.
• Developer in MA-STEPS Java and oracle project for 6 months.
• Developer and Team Leader in CCMS - Child Care management System - Oracle and Developer 2000 based application for 3 years.