Objective: A challenging position that effectively utilizes 29 years of data modeling, software design, programming, DBA, project management and PLSQL / ORACLE / UNIX / C expertise

Technical Skills:

Hardware: HP, SUN, PRIME, PC
Operating Systems: UNIX, HPUX, SOLARIS, PRIMOS, LINUX,
WINDOWS XP/2000/NT
Languages: PL/SQL, SQL, C, PRO*C, PERL, TRANSACT SQL,
JAVASCRIPT, HTML, FORTRAN, COBOL
Databases/Tools: ORACLE 10G, ORACLE 8i, ORACLE 7.x, SQL SERVER 2005,
PL/SQL DEVELOPER, SQL NAVIGATOR, TOAD, SQL
LOADER, ORACLE ENTERPRISE MANAGER, BRIO,
INFORMATICA

Experience:

August 2003 Confidential Bridgewater, NJ
to Present Software Design/Development/Data Warehouse Specialist

• Data Warehouse Specialist/Consultant involved in the enhancement and development of a data warehouse application for an international insurance company. The project includes a historic conversion which involves moving 25+ years of data from multiple sources to a Data Warehouse developed using Oracle 10g/8i and PL/SQL stored procedures in a UNIX environment.
• Currently involved in migrating Asia-PAC claim and policy data from a SqlServer environment to an Oracle Data Warehouse. The data is being moved between the two environments using Informatica. PL/SQL stored procedures are written on the Oracle 10g/UNIX environment.
• Tasks include conducting requirement analysis, writing technical design documents, document data source definitions, source to target mapping and coding of ETL procedures (PL/SQL)
• Coded and maintained a reserve allocation application for the extraction of data to be used by the actuarial team. This application is written in PL/SQL.
• Coded and maintained a web-based risk history application for the extraction of data to be used by the actuarial team. This application is written in PL/SQL.
• Analysis of data summations to identify and adjust pockets of transformed data to provide more granularity to the actuarial application
• Developed enhancements to online actuarial applications using Oracle 10g/PL/SQL (.NET front end). Added functionality providing users with the ability to upload parameter files. Modified complex applications to incorporate parameter lists using dynamic SQL.
• Involved with tuning PL/SQL stored procedures to decrease the time needed to complete the Data Warehouse conversion and extraction of data. Oracle tools such as Explain Plan, DBMS_PROFILER, DBMS_TRACE and PL/SQL Developer were used. Also modification of packages to use advanced bulk collection methods were implemented.

January 1991 Confidential, NJ 
to June 2003 Software Design/Development/Project Management

• Develop/Design/Maintain applications utilizing PL/SQL, Pro*C, C , PERL and HTML in a UNIX environment using SQL Navigator
• Extensive development and maintenance in the loading and extraction of data into the order processing systems using Pro*C, PL/SQL and Perl
• Extensive SQL Query development
• Developed the internal fulfillment/inventory control system
• Developed the shopping cart web based ordering system using Oracle Application Server 9iAS on Sun Solaris platform
• Developed sample drug tracking system for the pharmaceutical industry
• Developed order processing/inventory control/activations/shipping processes for the cellular phone industry (AT&T, Cingular, Sprint)
• Developed on line credit card processing
• Developed bar code print routines
• Developed software to manipulate large client mailing lists
• Developed system utilities using UNIX Shell and PERL scripting
• Experience in LINUX
• Responsible for technical and end-user documentation

• Responsible for the administration of HP UNIX systems and

ORACLE database administration

• Maintain the physical and logical structure of the Oracle databases
• Currently supporting ORACLE 8.1.7.4 on HPUX 11.0, ORACLE 8.1.6 running on Sun Solaris 5.8
• Currently supporting HP9000 systems running HPUX 11.00
• Planned and performed ORACLE7 to ORACLE8 migrations
• Responsible for Oracle product installations and upgrades
• Responsible for the enrollment of users and security issues,backup and recovery procedures and system performance analysis

• Utilized Oracle Enterprise Manager to monitor database activityand client/server applications

• Maintain Postalsoft applications for address correction and presort modules

January 1985 Confidential, NJ
to November 1990 Senior Marketing Support Analyst 

• Responsible for the installation and configuration of all ORACLE products on PRIME Unix platforms and PRIME proprietary systems

• Member of the UNIX Product Introduction Team for Prime Computer
• Pre-sales technical support for the implementation of PRIME 50 series and UNIX systems to potential and existing customers

• Assist customers in system analysis and programming using C and Fortran

January 1981 Confidential Jersey City, NJ
to October 1984 Senior Programmer/Analyst

• Designed and developed in-house programming using Fortran

and Cobol for warehouse and fulfillment systems

• Worked on Prime 50 series utilizing the PRIMOS operating system
• Worked on various IBM mainframes
• Installed PC based inventory systems at warehouse locations nationwide

Education:

BS Computer Science

Additional Information:

Prime Computer Analyst of the Year North America Mid-Atlantic Region (1986)
Attended numerous ORACLE and UNIX classes and seminars
Attended one semester of graduate work at Stevens Institute of Technology