Richboro, PA *****
( 267-***-**** (cell)
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
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
Senior PL/SQL Developer, Senior Oracle Database Developer, Senior Database Architect, Technical Team Leader, Senior Application Developer
Provide large-scale business solutions in integrating/transforming functional silos of data\models into a unified knowledgebase while defining business rules and transformation logic for the data load (ETL), conversion, database development\administration\technical support and team skills development.
Mortgage Lending, Financial services, Mortgage servicing, Utility Line Clearance and Infrastructure Services, Publishing
Unix HP, AIX, Linux
MS Windows 95/98/2000/NT 4.0/2012
Amazon RDS for Oracle
SQL Server 2012
SQL *Plus, PL/SQL, DML, DDL, ETL, XMLTable, JAVA, HTML
Unix Shell Scripting
Visual Basic 4.0/5.0/6.0
DATA MODELING TOOLS
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
Microsoft Visual SourceSafe 6.0, PVCS Version Control
Crystal Reports 11
Business Objects 6.X
Assential Data Stage
Ditech Financial LLC (former GMAC Mortgage), 1100 Virginia Drive Fort Washington, PA 19090
August 2005 - Present
SENIOR APPLICATION ENGINEER/DATABASE ARCHITECT/TEAM LEAD
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.
Mortgage Originating System Conversion from old Eclipse (IBM) to new Encompass (Elli Mae)
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
Co-Designed and developed a Consumer Lending Financial Data Mart (CLFDM)
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.
Participated in Design, Development and Implementation of the LendScape system
System was targeted to provide a common loan origination platform across all of GMAC 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.
Asplundh Tree Expert Co, 708 Blair Mill Road Willow Grove, PA 19090
March 2004 – August 2005
Participated in Upgrading CSS HRizon V8 to Enterprise Version 3.00 project
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
Participated in ELECTRONIC PAYROLL project
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.
Participated In Overhead Project
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
Created Ad-hock to report excess state taxes paid after Asplundh acquisitioned two companies – VCI and Trees Inc. enabling Asplundh to reclaim over $600,000.
Thomas Technology Solutions, One Progress Drive Horsham PA
Gathered and documented core data FUNCTIONAL REQUIREMENTS for THOMAS REGISTER on the Internet.
Researched following features of ORACLE 9i for redesigning Thomas Register on the Internet —
a.Table and Pipelined Functions
b.Transportable table spaces
d.New CASE statements and expressions in PL/SQL
e.Native XML Type, DBMS_XMLQuery, DBMS_XMLGen
f.ORACLE text (interMedia).
g.ETL (Extraction Transformation Load) support for data warehouse - External Tables (enhancement of SQL* Loader Functionality), Materialized Views, Pivoting INSERTs, “Upserts” (insert with MERGE Statement).
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 —
CLOB data type, ORACLE Build in packages, Objects based data types, advanced features of dynamic SQL, Native Dynamic SQL, Bulk Binds, FOR ALL Clause, RETURN Clause,
Java stored procedures.
EDUCATION AND TRAINING
Certified ScrumMaster Course DailyAgile (Kiran Thakkar)
Talend Data Integration Basics & Advanced Talend, 2016
Business Object Platform 4.1 SAP, 2015
Attunity Replicate Attunity, 2015
ScrumMaster Course 2015
Crystal Reports XI Vision Harvest Inc, 2012
DataStage Essentials for Enterprise Edition IBM, 2006
Training in Database Administration CSC Institute, Inc., Southampton PA 01/2001-06/2001
Corporate training in Visual Basic 6.0 CSC Institute, Inc., Southampton PA 1998-1999
Diploma in Computer Programming in Oracle
RDBMS and Developer2000/Forms 4.5 CSC Institute, Inc., Southampton PA 1997-1998
Bachelor of Art in Economics Moscow State University, Moscow, Russia 1986-1992