Oracle Consultant Resume

SUMMARY:

Senior IT professional with extensive experience in the automotive and auto finance industry. Responsible for database administration, development, deployment and ETL projects with Oracle databases. Roles included Technical Leader, Subject Matter Expert, Systems Analyst and Developer. Performed both client facing role and as tech lead for offshore development team. Strong commitment to customer satisfaction with a career focused on providing outstanding customer support.

TECHNCIAL SKILLS SUMARY:

Oracle
MS SQL Server
DB2
Mainframe (DB2, IMS)
PL/SQL (SQL Developer, TOAD)
Unix Shell Scripting
ETL (Extract, Transform and Load)
FTP
SQL Plus
SQL Loader
MATLAB
Python
InfoSphere DataStage
JAVA
HTML
PL/1
Visual Basic
COBOL
JCL
C
Unix
Windows
Linux (Ubuntu) mainframe
SVN
StarTeam
PVCS
Visual Source Safe
Endeavor
Control M
Tidal
AutoSys
JAMS
Cron
Enterprise Data Warehouse (EDW)
Teradata
ERWIN
Oracle Data Modeler
Confidential Quality Center / Test Director
Caliber RM
Cognos
ITIL Foundations
VMWare
SDLC (Systems Development Life Cycle)

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Consultant

Responsibilities:

Responsible for the installation, configuration, and administration of Oracle 11i databases that support Confidential big data and machine learning analytics research initiatives.
Interact with North American production facilities to secure and accurately transfer data into the research database environment utilizing ELT and EDI processes.
Source research data from existing Confidential Teradata and Enterprise Data Warehouse (EDW) environments.
Extensive use of SQL and PL/SQL to identify data required for researchers and create tables for analysis tools including MATLAB, R and Mathematica.
Responsible for loading data to the Linux high performance computing (HPC) environment and setting up database connectivity.

Confidential

Oracle PL/SQL developer

Responsibilities:

Developed, Tested and Deployed extract and load processing for the Confidential Customer Service Transportation (FCTP) project.
Created daily, weekly and monthly UNIX scripts, FTP, PL/SQL procedures, Oracle 12c tables.
Created new procedures for loading VIN Decoder data to Oracle tables for Confidential AZ, D, and X plan data.

Confidential

Senior Oracle developer

Responsibilities:

Developed and deployed software solutions
Rewrites of New Car inspection feeds from AiM trading partners converting Visual Basic front end processing into Oracle PL/SQL procedures.
Designed, developed, implemented monthly purge processing of aged inspection data from multiple oracle tables.

Confidential

Technical Leader / Subject Matter Expert

Responsibilities:

Responsible for developing and deploying software solutions including: Information Warehouse (IW) automotive financing application.
Developed and deployed software solutions on multiple projects using Oracle, PL/SQL, UNIX and DataStage.
Worked with customer to develop business requirements for Dealer Marketing Analytics Project and Enterprise Data Warehouse project.
Tech lead for Information Analytics project to load Datamart with auto finance application and origination data optimized for Business Intelligence and Cognos reporting. Coordinated team members working in multiple countries and states. Loaded datamart from Oracle 10g warehouse using Datastage ETL. Took on additional responsibility as test defect coordinator.
Tech lead and Deployment SME for Dealer Marketing Replacement project to load Market Opportunity and Lease Loyalty data into IW Datamart using DataStage ETL and UNIX scripts. Designed, tested and deployed UNIX processing to load inbound ETL files. Responsible for successful project completion with in tight time constraint.
Tech lead for the Debt Manager Replacement project. Designed and developed ETL using DataStage to replace obsolete PL/SQL logic. Directed offshore team in the design, development and testing.
Created outbound ETL extracts to provide Anti - Money Laundering data per requirement from the federal government.
Lead developer on National Guard Marketing Campaign to load inbound ETL from 3rd party web site.

Confidential

Technical Leader / Subject Matter Expert / Systems Analyst / Developer

Responsibilities:

Responsible for the design, development and analysis of multiple Engineering Business systems for Confidential ’s Global Product Development group.
Developer and primary production support for Factory Scheduling Tool application using a JAVA web frontend with Oracle and PL/SQL backend processing.
Tech lead on project to retire eTool Connection system and migration of engineering drawing data.
Production support lead for the Product Description Information System mainframe PL1 application.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship