SUMMARY:

• Skilled IT professional seeking challenging and exciting opportunity which would utilize heavy consulting experience, hard work and ability to learn new technologies.

TECHNICAL SKILLS:

Front End/Web: SAP PowerBuilder, Microsoft Visual Basic, Oracle J2EE, Borland JBuilder

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

Database Tools: Quest Toad, ERWIN, Allround PL/SQL Developer

Reporting Tools: Microstrategy, Crystal Reports, Cognos, SAP Business Objects

ETL Tools: IBM DataStage, Informatica.

Applications: Model N(former Revitas) CARS/IS, CARS/Medicaid, CARS/GP; Oracle Financials, SAP

Operating Systems: Windows, UNIX, Linux

PROFESSIONAL EXPERIENCE:

Confidential - Hagerstown MD

Senior Application Developer

Responsibilities:

• Work on various applications used to process credit card payments. These applications utilize Oracle 12 database as well as Java. Wrote various programs using Oracle PL/SQL, SQL as well as Java. Created modifications and enhancements to existing applications and batch processes. Using in-depth knowledge of Oracle database worked on performance tuning for various database units to accommodate heavy data volumes. Created various reports using Oracle Application Express.

Confidential - Franklin TN

Senior Consultant

Responsibilities:

• Eisai: Created various modifications to BI reporting application which utilizes Microstrategy 9 and Oracle 12 as a back-end, made changes to ETL. Created various customizations to CARS/IS, CARS/Medicaid and GP applications using SAP PowerBuilder 12 and Oracle 12 (SQL, PL/SQL). Provided ongoing user support.
• Forest Labs: Lead a team of 16 developers and BA’s to build reporting system which utilized SAP Business Objects as BI tool and Oracle 11 as back-end. Designed and developed Data Warehouse (dw), ETL process, provided assistance on building reports.
• Alcon: Responsible for building Datamart using MS SQL Server, building various customizations to CARS/IS application using PowerBuilder and Oracle 12 (SQL, PL/SQL), created various modifications to Business Intelligence application using Microstrategy 9.
• Pfizer. Participated in implementing Revitas Flex suite which utilizes Java and Oracle.
• Designed and developed various processes for bringing data into Revitas Flex applications from other systems using Oracle (PL/SQL) and PowerBuilder.

Confidential - North Wales PA

Senior Consultant

Responsibilities:

• Participate in implementation of various interfaces between iMany CARS/IS, CARS/Medicaid, iMany GP application as well as Oracle Financials. Designed and developed a number of Oracle database objects, created and modified PowerBuilder 12.5 objects. Provide ongoing user support for iMany CARS/IS application.
• Participate in implementation of iMany GP (Government Pricing) System at Talecris Biotherapeutics. This web-based application utilizes Java 1.5 technology and used 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 iMany CARS/IS and iMany CARS/Medicaid systems. Both of these applications use PowerBuilder 9 as the front-end tool and Oracle as the back-end.

Confidential . - Plainsboro NJ

Senior Consultant

Responsibilities:

• Decisively participated as a contributing team member in data gathering, designing, developing and testing various modifications to iMany CARS/IS as well as in-house developed Medicaid system. Responsible for designing, developing and testing PowerBuilder 9 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. Provided Microstrategy administration.
• Cultivate key relationships with internal staff, peers and business partners to ensure customer satisfaction.
• Personally responsible for implementation of CARS/IS system as well as its integration with JDE as well as reporting systems.
• Wrote, modified and tested SQL, PL/SQL (procedures, functions, triggers, etc) and PowerBuilder code, provided database administration.

Confidential - Washington DC

Senior Consultant

Responsibilities:

• 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.

• 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.
• Procter and Gamble: 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 as Microstrategy objects as well as reports design and development
• Wyeth Pharmaceuticals: 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