SUMMARY

• Experience in quick, precise software development using Oracle PL/SQL in a UNIX environment. Also involved in the creation and support of a Data Warehouse for a large insurance firm along with Oracle DBA work.
• Involved with the writing of analysis documents, technical design documents, unit and system testing and documentation.

TECHNICAL SKILLS

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

PROFESSIONAL Experience

2003 to 2012 Confidential, Bridgewater, NJ
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 11g/10g/8i and PL/SQL stored procedures (bulk collection methods, arrays, varrays, etc) in a UNIX environment.
• Currently involved in migrating Latin America claim and policy data from a SqlServer environment to an Oracle Data Warehouse (Oracle 11g/UNIX). The data is being moved between the two environments using Informatica and PL/SQL stored procedures (bulk collection methods, arrays, varrays, etc).
• Just completed 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 using various Oracle analytic functions.
• 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.

1991 to 2003 Confidential, W. Caldwell/Dover, NJ
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 activity

and client/server applications

• Maintain Postalsoft applications for address correction and presort modules

1985 to 1990 Confidential, Parsippany, NJ
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

Education:

BS Computer Science