SOFTWARE: Xcode 4, iOS5, PHP, Oracle 10g, PL/SQL, Java, Linux, Microsoft SQL Server, MySQL

BUSINESS EXPERIENCE:

February 2012 - Published Application in Confidential
September 2010 to Present: Showtime, New York, NY
Programmer - Developed Oracle Packages to migrate Interstitials data from a legacy broadcast
systems to PILAT’s Integrated Broadcast Management System (IBMS). Used a data dictionary and mapping documents to perform the translations. Created an Oracle package to migrate Showtime’s
Ratings, Advisories and Tech Cards to IBMS. Developed a reconciliation package to report the record counts in the old and new systems.
Industry: Television
Software: Oracle 10g, SQL Developer

February 2010 to August 2010: Confidential, New York, NY
Programmer – Created Oracle Packages and Triggers to support the Shared Listing Database Project.
Used SQL Loader to load flat files into the database staging area. Wrote packages to process the
staging area tables into the listing database.
Industry: Real Estate / Software Development
Software: Oracle 10g, PL/SQL, Toad, SQL Developer

August 2008 to December 2008: Confidential, Mount Laurel, NJ
Programmer – Investigate and document Microsoft Access databases written by the Franchise, Finance
and Settlement Services Departments. Converted Access reports to SQL Server Reporting Services.
Used Java and Apache POI to create Excel spreadsheets from SQL Server views.
Industry: Real Estate / Title Insurance
Software: Microsoft Access, SQL Server 2005, Java, Excel

October 2007 to February 2008: Confidential, New York, NY
PL/SQL Programmer – Oracle Programming Support for Mercury IT Governance Demand
Management.

• Created Oracle Packages to support the IT Governance Demand Management.
• Created Views to support the monthly reports
• Modified existing packages to run faster.

Industry: Banking
Software: Oracle 10g, PL/SQL

January 2007 to July 2007: Confidential, Jersey City, NJ
Contract Programmer: Report enhancements to support the Calypso Project.

• Created Oracle Views to capture the Calypso data from a Peoplesoft EPM Warehouse.
• Modified Oracle Stored Procedures and Packages to use the Calypso data.
• Modified Powerbuilder data window to capture the Calypso data.

Industry: Banking
Software: Oracle 10g, PL/SQL, Powerbuilder 8.5

October 2005 to January 2007: Confidential, New York City, NY
Contract Programmer – This was a data conversion project using Java, Microsoft SQL Server, Oracle 10g, XML and UNIX. The Java program converted the Insurance Premium Transactions (SQL Server) into XML Messages to feed into the new system. The Java program also needed to access an Oracle 10g database for some of the queries. Completed a policy migration program utilizing the Spring Framework. Used Spring / JMS to write insurance transactions to Websphere MQ. The development environment was Windows XP and the execution environment was UNIX.

• Created PL/SQL stored procedures and functions for the conversion. The PL/SQL functions
• were called from Java (JDBC) and from the stored procedures
• The stored procedures were used to maintain lookup tables from the external systems

Industry: Insurance
Software: Oracle 10g, Java, JDBC, Spring, JMS, JDOM, XML, UNIX, Microsoft SQL Server, DTS, Ant

May 2004 to September 2005: Confidential, Jersey City, NJ
Contract Programmer – This was a Peoplesoft EPM Data Warehouse conversion from an in house Sybase financial reporting system. Converted 35 to 40 Sybase stored procedures to Oracle 9i.
Converted a Sybase legacy reporting application to Oracle 9i using Business Objects / WebIntelligence 6.5 and Crystal Reports 9. The conversion required working with the Business Analyst to insure that all the Sybase data elements were mapped into the Oracle Peoplesoft database. Created a Business Objects Universe to define the data elements. Converted the old reports into WebIntelligence (WebI) reports using the Universe.
Industry: Banking
Software: Oracle 10g, Business Objects 6.5, WebIntelligence, Crystal Reports, Powerbuilder 8.0, Sybase

October 2002 to May 2004: Confidential, Valley Forge, PA
Contract Programmer – Maintenance and enhancements to the Case Management Healthcare System using Powerbuilder 8.0 and Oracle 9i. Maternity case processing was added to the application.
Database extract and load programming using Java, Oracle, UNIX (Solaris) and Microsoft SQL Server. Migrated member coverage data using Java, SQL*Loader and PL/SQL. Coded Java programs to perform nightly extracts to capture HIPAA data for third party processing. Used DTS 2000 to extract Pharmacy claims from SQL Server.
Industry: Healthcare
Software: Java, Oracle 9i, Microsoft SQL Server, DTS, Powerbuilder 8.0, Ant, UNIX

March 2000 to September 2002: Confidential, Philadelphia, PA
Contract Programmer – Healthcare application development for the Centralized Maintenance Utility using Powerbuilder 7.0 and Oracle 8.0. This application maintains customer information for other
Intracorp / CIGNA healthcare applications. Created database triggers, packages, functions and stored procedures using PL/SQL. The packages were used in encapsulate the business logic. The stored
procedures and functions were wrappers for the packages and were called from Powerbuilder.
Industry: Healthcare
Software: Oracle 8, Powerbuilder 7.0, PFC

November 1998 to December 1999: Confidential, Mount Laurel, NJ.
Contract Programmer - Developed an application to fax mortgage interest rate reports. The application creates the reports from an Oracle 8 database and stores the reports back in Oracle as Adobe PDF objects. The application interfaces with RightFax Enterprise Servers to fax the reports and retrieve fax status information. This application archives the mortgage rates sheets to disk and creates a HTML document for indexing. Developed reports for a mortgage inventory system using Sybase System 11. Created reports for the STARS appraisal system using Oracle 8. These applications were developed using Powerbuilder Version 6.5 and the PFC.
Industry: Real Estate / Mortgage
Software: Oracle 8, RightFax, Powerbuilder, PFC

EDUCATION: BS Computer Science,