Senior Programmer-Analyst with extensive and diverse experience in Database Development of business applications using Oracle and MS SQL Server on Unix and Windows NT platforms. Robust hands-on project experience in developing Financial, HR and Manufacturing client-server and intranet applications. Knowledgeable in all aspects of system development methodology with practical experience gained while working on main development projects.
Hardware: PC compatibles.
Databases: Oracle 10g/11g/12c, Microsoft SQL Server, MongoDB, MS Access
Languages: SQL, PL/SQL, T-SQL, C#, C, Java, Perl, XML, SAS.
Development Tools: TOAD, SQL Developer, Visual Studio, UC4, Autosys, Java Eclipse, ERwin, Oracle HRS, Powerbuilder.
Operating Systems: Linux Ubuntu, Sun Solaris Unix, AIX Unix, Windows 10.
Management Tools: Microsoft Office, PVCS, CVS, Microsoft Project, Visio, VNC.
Bank of America, Pennington, NJ November, 2017- July, 2019
Contractor, Application Developer V
•Created and developed upper-stream loads using external tables, Oracle packages, PL/SQL, Korn Shell scripts and Autosys for loading data into the Referential Data Repository (RDR) system used by the Bank of America.
•Involved in gathering and reviewing business requirements; writing the specifications; logical and physical database design using Brownstone data services and Oracle Toad tool.
•Resolved database performance bottlenecks creating table partitions and indexes and rewriting database objects (procedures, functions) and SQL queries.
•Developed a database framework for generating data extracts for inside business partners.
•Created test environment, loaded and verified data used for migration applications to Oracle Cloud.
Ally Bank, Ft. Washington, PA September 2016-August, 2017
Contractor, Database Developer
•Created interfaces for loading data into the ETL Business Data Recovery system used by the Ally bank
utilizing Oracle 12c and Korn shell scripts on a Linux platform.
•Participated in creation and supporting the DTC mortgage system utilizing Oracle and SQL/XML on a Unix platform.
•Created, tested and maintained database objects used as data sources for Business Objects reports.
•Analyzed, validated and cleaned data for running Monthly Mortgage back-end jobs.
•Created reports for the Risk Management department, utilizing Oracle stored procedures, PL/SQL, and Korn shell scripts.
ACI, Princeton, NJ March 2010- July, 2016
•Created interfaces between ORCC and outside clients (JP Morgan Chase, Capital One, LabCorp etc.) used for wholesale banking, e-paybill and e-collect systems utilizing Oracle, SQL*Loader, PL/SQL and Unix programming.
•Designed and developed various jobs for automating different processes and reports using Oracle, MS SQL Server, Unix Sun Solaris, Perl and AppWorx/UC4 scheduling application used for different services such as epayment, funding, remittance and disbursement.
•Performed Oracle programs’ tuning and analysis on existing inefficiencies utilizing Explain Plan and Oracle built-in packages.
•Created new batch programs and reports, supported and modified existed ones. Such programs included but not limited to: Electronic Funds Transfers reconciliation reports for comparing delivered transaction reports and our own data to identify discrepancies and suspect transactions.
•Designed and developed notification reports for biller clients to keep they informed of payments’ progress and consumers to enable them to be more involved in use of the Bill Payments system.
•Setup of clients’ customer account data in Mini Account Master (MAM) files by utilizing various transmissions types (ftp, sftp, curl), UC4 jobs, SQL*Loader, PL/SQL, Perl and shell scripts.
JP MORGAN CHASE, Iselin, NJ May 2000- January, 2010
•Responsible for the PCFast application, a managerial accounting system, which enables Financial Management staff systematically analyze predicted and actual balance sheet and income statement results, generates management reports and increases revenue. Created and developed Allocations, Load, Upload, Account and Report modules utilizing Oracle PL/SQL and Powerbuilder on a Unix Solaris platform.
•Created the Unclaimed Funds application with capabilities to load, track and process overpaid mortgages according to FDIC regulations and Federal law. The application is utilizing Oracle 11g, ASP.NET, C#, and Korn Shell.
•Developed the Account Executive Value Creation tool for the lending deal modeling and approval process to increase number of mortgage lenders using MS SQL Server, C#, Crystal Reports and T-SQL.
•Managed the Control Log application that utilizes J2EE, Actuate, PL/SQL, SQL*Loader and Korn Shell; developed as an Intranet system that allows top management reconcile, monitor and audit critical balance sheet GL accounts and fix data if required and generate monthly financial reports.
•Designed Control Logs logical and physical database schema, generated and modified DDL using ERwin.
•Implemented complex logic involving dynamic SQL, and Oracle Web Toolkit for creating Intranet Actuate financial and ad-hoc reports.
•Created and modified back-end scheduled jobs using Oracle packages, SQL*Loader, Korn Shell, and awk for loading data into data warehouse and importing data from remote systems (HP3000, SAP, Peoplesoft), setting security, and creating Unix jobs’ reports.
•Participated in the CoPS (Commission Payment System) project definition, analysis of business requirements, database design and application creation utilizing Oracle, ERwin, J2EE and XML on the Sun Solaris Unix platform. Created back-end jobs for loading and purging CoPS data. The CoPS application saved money by avoiding overpayment.
STEFAN’S TECHNICAL COLLEGE, Lviv, Ukraine
M.S. in Computer Programming
LVIV’S POLYTECHNICAL COLLEGE, Lviv, Ukraine
B.S. in Mechanical Engineering
Courses in MongoDB provided by MongoDB University 2018
Courses in SAS programming provided by CSC, Philadelphia, PA 2014
In-house training in Business Analysis provided by Total System Education, LTD 2008
Courses in C# and ASP.NET and Visual Studio provided by HOTT, Inc. 2007
US citizen, authorized to work for any employer.