OBJECTIVE:

Seeking challenging position as an ORACLE Architect/Senior Programmer/Technical Team Lead with emphasis on development in Oracle 10/11g/12 RDBMS that allows for professional growth and expansion of my skill - base

PROFILE:

• Senior level Information technology professional with over 19 years of experience in all aspects of the systems development life cycle, including top-tier physical/logical data modeling, PL/SQL development, systems troubleshooting and administration.
• Have excellent analytical, communication, leadership skills and am accustomed to demands of on-call support for large-scale systems.

BUSINESS SKILLS SUMMARY:

• Unix HP, AIX, Linux
• Sun-Solaris
• MS Windows 95/98/2000/NT 4.0/2012
• Oracle 7.X/8.X/9.X/10.X/11G/12c
• Amazon RDS for Oracle
• SQL Server 2012/2016
• MS Access
• PostGreSQL
• SQL *Plus, PL/SQL, DML, DDL, ETL, XMLTable, JAVA, HTML
• Unix Shell Scripting
• SQR
• Visual Basic 4.0/5.0/6.0
• VB.NET
• Erwin
• VISIO
• TOAD, SQL Navigator, PL/SQL Developer
• SQuirreL SQL Client
• SQL Loader For ORACLE
• ORACLE EXPORT/IMPORT/Datapump Utilities
• ORACLE Enterprise Manager
• EXCEED, Unix CDE, VNCviewer, WinSCP 5.9
• Microsoft Visual Studio 2012,2017
• Microsoft Visual SourceSafe 6.0, PVCS Version Control
• Crystal Reports 11
• Business Objects 6.X
• SSIS
• Assential Data Stage
• TALEND
• Atunity
• AWS Glue

PROFESSIONAL EXPERIENCE:

Confidential, Fort Washington, PA

SENIOR APPLICATION ENGINEER/DATABASE ARCHITECT/TEAM LEAD

Responsibilities:

• Conducted Proof of Concept effort to migrate local Oracle Databases to PostgreSQL on AWS using AWS Glue, Python/Spark scripts and utilizing AWS job scheduling
• Worked closely with business partners to provide advanced technical solutions which dramatically increased company profit
• Designed and developed “SmartWatch” application that uses dynamic Marketing criteria to monitor Ditech valued customer’s portfolios whose loans almost paid off to offer different opportunities to refinance, reduce loan payment, or to get cash out when customers login to their Ditech accounts.
• Designed and developed ETL processes to load Marketing data from on-premises DataMart to Oracle AWS to feed Cloud based “SmartWatch” Application.
• Designed and developed programs to balance customer call traffic between Ditech call centers.
• Developed PL/SQL “Dialer” process that direct calls and control call volume to Ditech “Sales” department.
• Designed and developed “MLS Triggers” PL/SQ process aimed to offer best mortgage rates to retain creditworthy customers who have a current Ditech loan and listed their properties for sale.
• Designed and developed “Credit Triggers“ PL/SQL process that aimed to retain valued Ditech customers who are shopping for a mortgage with another lender
• Developed Integration services for DAYFORCE and FIELDGLASS HR daily updates to the database that parsed raw XML data requests through API calls.
• Developed solution delivering Marketing data into PostGreSQL database on AWS to enable email campaigns using HubSpot.
• Identified critical areas of conversion, evaluated and transferred existing processes to support new system structure and requirements.
• Designed supporting Oracle database and developed PL/SQL, JAVA, XML based ETL processes to interface into the new system.
• Co-Designed and developed a Single Data Repository (SDR) - OLTP/Reporting/Data Warehouse hybrid that stores application, marketing, telecom, HR, and various vendor data and to support reporting.
• Led development team effort that efficiently delivers results
• Provided training and documentation for application support team
• Participated in Business Objects XI upgrade to version 4.1
• Free SQL report conversion
• Creating Universes
• System had over 200 tables and supported analysis of telecom and web site hit data to assess the effectiveness of marketing campaigns by tracking initial contact thru loan closure.
• Developed and supported performance tuned ETL processes using external tables, JAVA objects, UTL FILE, triggers, linked databases, pipelined transformation table functions using Oracle Job Scheduler to coordinate execution.
• Provided Email report and file extract delivery thru PL\SQL procedures using UTL SMTP.
• Designed and Developed the Business Object’s Universe and key reports.
• Designed and developed process to load vendor supplied loan related invoices for validation against CLFDM and to create formatted invoice detail files for direct load into the SmartStream AP module for payment.
• System was targeted to provide a common loan origination platform across all of Confidential RESCAP’s lending channels.
• Designed custom user access security approach for Business Object reports targeting to replace setting row-level security in Supervisor.
• Developed automated parameter driven approach for building complex reporting queries that reduced average development time from 4 days to 4 hours.

Confidential, Willow Grove, PA

SENIOR PROGRAMMER/ANALYST

Responsibilities:

• Prior to upgrade, gathered and documented existing custom processes and reports
• Gathered and documented modifications required to synchronize custom processes and reports
• Researched whether current customizations would come as standard after upgrade to Enterprise v3
• Researched impact on the end users
• Researched alternate software to replace ADP services and CSS HRizon all together
• Testing patches in development environment
• Resolved CalcPay Cobol process problem
• Applied patches starting 8.00G.09. Brought system up to “ready-to-upgrade” state
• Created ELECTRONIC PAYROLL DATA MODEL using ERWIN 4.0
• Created weekly electronic payroll data load and validation processes
• Created Load error and Statistic reports
• Implemented Automation of FTP process; created shell script that FTPs report file(s) from one location to another.
• Implemented PL/SQL generated email functionality to notify user and payroll department about status of the load
• Automated ELECTRONIC PAYROLL using DBMS JOB, ORACLE Build-In package that executes job at specific time set by user.
• Gathered and documented Overhead System functional requirements
• Implemented Overhead data migration from Sybase to Oracle data base; loaded data to ORACLE using ORACLE EXTERNAL tables, SQL*LOADER, and UTL FILE technologies
• Created validation packages to insure data consistency
• Created OVERHEAD search using PL/SQL table function technology
• Converted mainframe cost calculation process into PL/SQL. Compared results against mainframe calculations and explain variances
• Created Overhead Interface using VB.NET Interface validates user entered data against ORACLE data base, and allows user to search, add, delete, and update OVERHEAD data

Confidential, Horsham, PA

ORACLE ARCHITECT

Responsibilities:

• Gathered and documented core data FUNCTIONAL REQUIREMENTS for THOMAS REGISTER on the Internet.
• Installed ORACLE 9i software and set up development environment for Thomas Register on the Internet. Created ORACLE database, table spaces, and users. Loaded test data into database using SQL LOADER. Maintained data base changes.
• Data IMPORT, EXPORT.
• Designed, developed, and maintained a logical and physical DATA MODEL using ERWIN 4.0 and VISIO.
• Designed and developed sophisticated SEARCH ENGINE using ORACLE text (interMedia) CTXCAT indexes, custom thesaurus, ORACLE 9.2 table functions. After go LIVE, maintained changes of existing production version of PL/SQL packages.
• Designed and developed WEEKLY BUILD process for displaying and searching data. Created UNIX shell scripts to run TROI WEEKLY BUILD. After going LIVE, maintained changes of existing production version of PL/SQL packages.
• Created documentation and Trained production team on how to run the WEEKLY BUILD process.
• Provided technical support to production team.
• Created number of PL/SQL packages, stand-alone functions and procedures to support major functionalities for Thomas Register USER REGISTRATION online.
• Designed and developed efficient algorithm to provide fast data transferring to DATA WAREHOUSE based on extensive usage of MATERIALIZED views.
• Optimized existing warehouse PL/SQL code, tuned SQL queries using SQL NAV query plan analyzer that significantly increased system performance (any number? 50%)
• Developed SQL*Loader scripts and PL/SQL packages for converting data and moving it from Mainframe ADABAS system to Oracle 8 Database for Martindale-Hubbell® Nationwide Publishing Company.
• Extensive experience utilizing advanced ORACLE 8i PL/SQL features such as Dynamic SQL, UTL FILE, DBMS LOB, Cursor Variables, and ORACLE built-in packages to develop batch process for Martindale-Hubbell®.
• Created reusable procedures/functions/packages for common purposes.
• Supported main extract engine (EXMAST) and maintained system until turnover to Martindale-Hubbell® was completed.
• Coding a very complex process that built an attorney's biographical sketch as well as a customized uppercase routine for Martindale-Hubbell®.
• Coding back-end Billing and Sizing process and Auto verification processes for Martindale-Hubbell®.
• Created number of shell scripts, to run PL/SQL packages from UNIX.
• Resolved number of problems using following features of ORACLE 8.X