TECHNICAL PROFICIENCIES

Front-End/Web Tools/Languages:

Sybase PowerBuilder (all), Microsoft Visual Basic 4/5/6, Sun Java, Borland JBuilder (all), NetBeans (all), Eclipse, HTML, XML

Databases:

Oracle (SQL, PL/SQL, Database administration), MS SQL Server (SQL, T/SQL), MCR TeradataV2Rx

Database Tools:

Quest Toad (all), ERWIN (all), Allround PL/SQL Developer (all)

Reporting Tools:

Microstrategy 6/7/8, Crystal Reports 7/8

Applications:

I-Many CARS/IS, CARS/Medicaid, CARS/GP; Oracle Financials, JDE and SAP

Operating Systems:

Windows (all), UNIX (all), Linux (all)

PROFESSIONAL EXPERIENCE

Confidential, North Wales PA Senior Consultant June 2006-Present

• Participate in implementation of various interfaces between I-Many CARS/IS, CARS/Medicaid, I-Many GP application as well as Oracle Financials. Designed and developed a number of Oracle database objects, created and modified PowerBuilder objects. Provide ongoing user support for I-Many CARS/IS and CARS/Medicaid applications.

Environment: Windows XP, Oracle 9i/10G, PowerBuilder 9/10/10.5

Confidential,Florham Park NJ Senior Consultant Feb 2006-June 2006

• Participate in implementation of I-Many GP (Government Pricing) System at Talecris Biotherapeutics. This web-based application utilizes SUN Java 1.3 technology and uses Oracle 9i as a back-end. Responsible for gathering user requirements, creating technical specifications, data modeling as well as designing ETL processes between various systems.
• Responsible for implementation of I-Many CARS/IS and I-Many CARS/Medicaid systems. Both of these applications use Sybase PowerBuilder as the front-end tool and Oracle as the back-end.

Environment: Windows NT/2000/XP, Oracle 9i, Java 1.3, Apache Tomcat, PowerBuilder 9.

Confidential,Plainsboro NJ Senior Consultant Aug 2004-Feb 2006

• Decisively participated as a contributing team member in data gathering, designing, developing and testing various modifications to I-Many CARS/IS as well as in-house developed Medicaid system. Responsible for designing, developing and testing PowerBuilder objects, Oracle SQL scripts as well as Oracle PL/SQL units in UNIX environment.
• Point of contact for multiple interfaces between the CARS/IS, SAP and various reporting systems. Responsible for numerous database modifications, data extracts using SQL, PL/SQL, as well as front-end modifications using PowerBuilder 8/9 and ongoing user technical support.
• Responsible for a number of customizations/modifications to in-house built deductions systems using Visual Basic 6.
• Participate in design and development of reporting system. Responsible for gathering user requirements, data modeling, creation of Microstrategy 7.5 dimensions, metrics, filters, reports and other objects. ProvidedMicrostrategy administration.
• Cultivate key relationships with internal staff, peers and business partners to ensure customer satisfaction.

Environment: Windows 2000/XP, HP UNIX, Oracle 9, PowerBuilder 8/9, Visual Basic 6, Microstrategy 7.5.

Confidential, Roseland NJ Senior Consultant May 2004-Aug 2004

• Personally responsible for implementation of CARS/IS system as well as its integration with JDE as well as reporting systems.
• Demonstrated excellent project management skills in gathering and distilling user requirements, writing specifications, and developing interfaces between JDE and CARS/IS systems.
• Wrote, modified and tested SQL, PL/SQL (procedures, functions, triggers, etc) and PowerBuilder code, provided database administration.

Environment: Windows 2000, Oracle 9i, PowerBuilder 8, SQL, PL/SQL.

Confidential,Washington DC Senior Consultant Feb 2004-May 2004

• As a senior developer/technical lead participated in design and development of large data warehouse. Responsible for design and development of Microstrategy objects, reports as well as database modeling, data manipulation and performance tuning.

Environment: Windows XP, Oracle 9i, Teradata V2R5, Microstrategy 7.2.

Confidential,Edison NJ Consultant Nov1998-Feb 2004
Accountable for acting as an I-Many consultant/technical lead serving a large number of clients and I-Many corporate initiatives by designing and developing multiple client applications and managing all aspects of client projects.
Project highlights include (partial list only):

• Apotex: Participated in design, development, implementation and support of custom reporting application using Microstrategy 7 and Oracle 8. Personally responsible for gathering user requirements, logical and physical database design and development, creating ETL (extract, transformation and load) process, design and development of Microstrategy objects as well as post-production application support. In this application ETL process validates, transforms and loads data coming from CARS/IS and SAP systems using DataStage 5, Perl 5 script, Oracle SQL*Loader, SQL and PL/SQL scripts. Provided Oracle database administration when needed.

Environment: Windows NT/2000/XP, Oracle 8/9i, Microstrategy 7, Datastage 5, PowerBuilder 8.

• Confidential,Created a reporting system using Microstrategy 7 and Oracle 8 as the back end. Participated in gathering user requirements, database and ETL design and development, as well asMicrostrategy objects as well as reports design and development.

Environment: Windows 2000, Oracle 8, Microstrategy 7, DataStage 4, PowerBuilder 7.

• Confidential, Wrote PL/SQL scripts for extracting data from CARS/IS system and transferring to the Government Pricing system using MQ Series tools. Performed data validation/cleansing and was involved in front end PowerBuilder 7 modifications.

Environment: Windows 2000, HP UNIX, Oracle 8, PowerBuilder 7.

• Confidential, Participated in design and development of data warehousing application using Crystal Reports 7/8 and Oracle 8 as a back-end. Primarily responsible for designing and developing ETLprocess using Oracle PL/SQL and SQL scripts as well as reports design, development and deployment.

Environment: Windows 2000, Oracle, PowerBuilder 7, Crystal Reports 7/8.

• Confidential, Responsible for design and development of General Ledger module for CARS/Medicaid system. Designed and developed Oracle and PowerBuilder objects.

Environment: Windows 2000, Oracle 8, PowerBuilder 7, PVCS.

• Confidential,Responsible for design and development of dynamic reports for web-based eDMS (Deductions Management System) application. Crystal Reports 8 and Visual Basic 6 were used.

Environment: Windows 2000, SQL Server 7/2000, Visual Basic 6 and Crystal Reports 7.

• Confidential,Designed and developed custom reporting system using Microstrategy 6/7 and Oracle 7.

Environment: Windows NT/2000, Oracle 7/8, Microstrategy 6/7, PowerBuilder 5/6/7

• Confidential,Participated in implementation of CARS/IS system. Responsible for design and development of database objects, wrote PowerBuilder code.

Environment: Windows 95/NT, HP UNIX, Oracle 7, PowerBuilder 5/6.

EDUCATION AND TRAINING

Bachelor of Arts

Ardent Datastage Essentials, Ardent (Informix), Denver CO, Diploma 2000
Oracle Database Administration, Oracle Foundation, Edison NJ, Diploma 2000
Gold Certificate in Microstrategy Tools and Data Warehousing, Microstrategy, Tampa FL, Diploma 1999
Client/Server Programming, CSC Institute, Southampton PA, Diploma 1997