Oracle Data Warehouse Programmer Resume Profile
FL
TECHNICAL SKILLS
- Recent Development: Developing, maintaining, and performance tuning Oracle PL/SQL Packages, Procedures, Functions, SQL Loader, UNIX Shell Scripts, Awk, Java, Microsoft Reporting Services, Access.
- Database Systems: Oracle 11gR2 , Oracle 10g, Oracle 9i, SQL Server, MS Access, Unisys DMS II
- Business and Application Roles: Senior Analyst, Systems Analyst, Programmer, Computer Operations
- Business and Application Experience: Direct Marketing - Distribution, Order Entry
- Insurance - Data Warehousing, Professional Liability, Auto, Homeowners, Health
- Government - Human Resources, Public Utilities, Professional Licensing
- Operating Systems: Solaris UNIX, Linux Suse , Windows 2000, HP UNIX 10.20, Unisys A-Series MCP
- Legacy Systems: XGEN 4GL, Unisys A-Series WFL
PROFESSIONAL EXPERIENCE
Confidential
Data Specialist
Functional DBA/System Specialist supporting IronData Versa Licensing Management system for the State of Florida. Oracle database is hosted on Solaris Unix. Application layers hosted on Windows.
Confidential
Programmer Analyst Contractor
Short term contract to review and standardize existing federal reporting process. Existing process is a combination of SAS and AccessDB manual processes.
Confidential
Oracle PL/SQL Contractor
Develop Oracle PL/SQL Packages and Procedures in Datawarehouse Group. Set up data extracts from MarineProcurement system that handle orderings, shipping, delivery to ships and distribution during cruises.
Confidential
Oracle PL/SQL Contractor
Develop Oracle PL/SQL Packages and Procedures for OLTP system. Oracle team implements back end processes of mobile phone application. Front end development by dot net group. Oracle environment is 11gR2. Confidential
is owned by American Express.
Confidential
Senior Oracle Database Programmer Analyst
- Developed Oracle PL/SQL Packages, Procedures, Functions, Unix Scripts, Awk, and Java.
- Automated file exports/imports combining PL/SQL, Unix/Oracle scripts w/utilities such as vi, Awk, Sed, and SQL Loader, UTL FILE package, and batch processing scripts.
- Implemented Oracle PL/SQL Packages integrated w/Microsoft Front End using REF CURSORS and XML.
- Evaluated opportunities for performance tuning as needed.
- Supported back end for eCommerce, marketing research, vehicle pricing, and inventory management.
- Limited exposure to SQL Server, T-SQL, and Microsoft Report Services.
Confidential
- Oracle PL/SQL Programmer Consulting for Robert Half Technology
- Developed Oracle PL/SQL system implementing interface to new Prescription Benefit Management Provider.
- Oracle 10g on Solaris Unix system, Unix Korn shell scripting.
Confidential
Oracle Data Warehouse Programmer I
- Developed Oracle PL/SQL Packages, Procedures, Functions, and Triggers. Also used Korn Shell Scripts, Awk, Oracle Warehouse Builder, Java, Oracle SQL Loader, and UTL FILE package.
- Data load procedures included editing, transformation, auditing, status messaging, and event logging.
- Data sources include comma and tab delimited, fixed length records, Oracle Exports, and Oracle DBLinks.
- Responsible for design, implementation, and support of automated Data Warehouse processes.
- Insurance lines supported - personal lines, extended product warranties, and Credit Card debt protection..
- Loads processes used push and pull methods acquiring data in the USA, Canada, and South America.
Confidential
Senior Programmer
- Programming/Support of Order Entry system for B2B supplier of plumbing, electrical, and hardware items.
- Dual platforms: XGEN COBOL generator, UNIX/Informix DBMS and Unisys Mainframe/DMSII DBMS.
Confidential
Information Systems Analyst
UNISYS A-Series mainframe to Oracle 11i HRMS conversion to Oracle Time Management.
Confidential
Senior Software Consultant
Y2K programming, end user support Sheriff Office's XGEN legacy time management system.
Confidential
Senior System Analyst
Migrated programs, WFL, and data from Unisys Mainframe to Oracle Unix environment.
Confidential
Programmer/Analyst
Underwriting system development using XGEN 4GL COBOL generator on Unisys A-Series Mainframe.
Confidential
Analyst/Programmer
Medical professional liability system on XGEN COBOL / Unisys Mainframe/DMSII DBMS platform.