Oracle PL/SQL Developer Resume Dallas, TX - Hire IT People

SUMMARY:

Dependable and hard - working IT Professional with experience in design, programming and analysis. Self-starter with excellent analytical and problem-solving skills. Able to contribute to a project team in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines. Experience with the latest tools in Oracle, UNIX, Linux and Windows environments.

TECHNICAL SKILLS:

Operating Systems: Unix, Linux, Windows

Languages: SQL, PL/SQL, Fortran, Cobol

Databases: Oracle Database versions 8, 9i, 10g, 11g (SQL, PL/SQL , procedures, packages, functions, Triggers)

Tools: APEX, Oracle Developer, Oracle Forms, Oracle Reports, SQL*Loader, SQL*Plus, SQL Navigator/Toad, SAP Roambi, SQL Developer.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Oracle PL/SQL Developer

Participated in the upgrade of existing FDIC APEX apps from 4.2 to 5.1 that were supported by Confidential LLC.
Member of team that designed, developed and implemented two separate applications used to support the tracking and sale of assets from failed financial institutions. These applications involved development of APEX user interface, designing database table structure and developing packages, procedures, functions and triggers.
Responsible for development of changes to existing APEX apps where needed.

Confidential , Irving, TX

Oracle PL/SQL Developer

Analyzed insurance claim date received from newly acquired clients and mapped data into a standard Oracle conversion schema. Client data was received in varying formats (excel spreadsheets, SQL server databases, access databases, oracle tables and fixed length or comma delimited files).
Created tables and processes to transform data from customer’s format into Oracle tables.
Wrote PL/SQL scripts using previously mapped data into interface tables which in turn were loaded into production Oracle database.

Confidential, Fort Worth, TX

Oracle PL/SQL Developer

Redesigned interface to third party Shoppertrak application. Modified PL/SQL procedures shell scripts previously run weekly to run daily. By restructuring the queries and optimizing the SQL, was able to cut the run time by 80%.
Created tables and process to produce customer contact lists based on customer activity and outstanding transactions to be used by the stores during promotions and sales events at each store.
Wrote procedures to identify customers with open items such as loans or layaways and load into tables to be used by queries to produce contact lists as stores relocated or closed.
Implemented SAP Roambi Mobile Reporting tool. Developed queries and shell scripts to produce files containing store metrics and transfer them to the cloud for field management teams allowing them to view daily performance data on their mobile devices.
Responsible for development and support of licensing module.
Conversion of reports to run in either Spanish or English with a selectable language parameter for stores in Mexico.

Confidential, Irving,TX

Programmer Analyst

Designed, developed and maintained data repositories using Oracle 11g database to store data from ERCOT for use in forecasting, planning and verification by the retail, generation and transmission units.
Led development team in implementation of a complex billing system interfacing an Oracle based Lodestar meter data management system with a Oracle based Banner billing system.
Developed custom reporting from Banner Billing System data using SQL*Plus, Oracle Reports.
Developed and modified custom transaction analysis and correction tool using Oracle Forms.
Provided assistance, guidance and coaching/mentoring to less experienced development team members.
Wrote Oracle PL/SQL procedures to extract energy consumption data from the production Banner billing system and compare with energy consumption data supplied by ERCOT (Energy Reliability Council of Texas). Created records for submission to other market participants to correct data variances.
Developed and modified custom transaction analysis and correction tool using Oracle Forms.
Developed and modified PL/SQL procedures to process transactions associated with data repair and correction.

Confidential, Dallas, TX

Programmer Analyst

Developed reports from trouble reporting Remedy and billing databases using PL/SQL and SQL Navigator. Created views, stored procedures and functions.

Confidential, Dallas, TX

Programmer/Analyst IV

Developed custom reports using Oracle Reports and SQL*Plus for AR, GL, PA, AP, PO, FA, INV and OE modules in Oracle Financials.
Developed and implemented custom applications using Oracle Reports, Oracle Forms, SQL*Plus, PL/ SQL and Oracle databases.
Developed and implemented interfaces between custom applications and Oracle Financials (AR, INV, GL) using Oracle Reports, Oracle Forms, SQL*Plus, PLSQL and Oracle databases.
Troubleshoot and correct complex bugs or issues (including performance issues) reported by the user community. Was a resource to optimize long running SQL queries.

We provide IT Staff Augmentation Services!

Oracle Pl/sql Developer Resume

Dallas, TX

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship