We provide IT Staff Augmentation Services!

Oracle Data Warehouse Programmer Resume Profile

4.00/5 (Submit Your Rating)

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.

We'd love your feedback!