Data Oracle

IRINA STASIW

** **** *****,

Richboro, PA *****

( 267-***-**** (cell)

Email: *********@*******.***

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

Roles/Positions

Senior PL/SQL Developer, Senior Oracle Database Developer, Senior Database Architect, Technical Team Leader, Senior Application Developer

Responsibilities

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.

Industries

Mortgage Lending, Financial services, Mortgage servicing, Utility Line Clearance and Infrastructure Services, Publishing

OPERATING SYSTEMS

Unix HP, AIX, Linux

Sun-Solaris

MS Windows 95/98/2000/NT 4.0/2012

DATABASES

Oracle 7.X/8.X/9.X/10.X/11G

Amazon RDS for Oracle

SQL Server 2012

MS Access

PostGreSQL

DEVELOPMENT LANGUAGES

SQL *Plus, PL/SQL, DML, DDL, ETL, XMLTable, JAVA, HTML

Unix Shell Scripting

SQR

Visual Basic 4.0/5.0/6.0

VB.NET

DATA MODELING TOOLS

Erwin

VISIO

DEVELOPMENT 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

REPORTING TOOLS

Crystal Reports 11

Business Objects 6.X

ETL TOOLS

Assential Data Stage

TALEND

Atunity

AWS Glue

PROFESSIONAL EXPERIENCE

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

Creating Universes

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

SENIOR PROGRAMMER/ANALYST

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

1999-February 2004

ORACLE ARCHITECT

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

c.Cursor expressions

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

Contact this candidate