IGOR FLEYSHMAN

**** ********* ****** ***, ************, PA 19115 • Phone: 215-***-**** • Email: adjohe@r.postjobfree.com

SUMMARY

Senior Programmer-Analyst with extensive and diverse experience in Database Development of business applications using databases (Oracle, MS Server, Hadoop) 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.

TECHNICAL SKILLS

Hardware: PC compatibles.

Databases: Oracle, Microsoft SQL Server, PostgreSQL, Hadoop, MongoDB

Languages: SQL, PL/SQL, T-SQL, Java, Perl, Python, XML, SAS, Hive, Pig

Development Tools: TOAD, SQL Developer, Visual Studio, UC4, Autosys, Jira, Powershell, Eclipse, Oracle HRS, ERWin, Powerdesigner, SVN, Sharepoint, AWR

Operating Systems: Linux Ubuntu, Sun Solaris Unix, AIX Unix, Windows 10.

Management Tools: Microsoft Office, PVCS, CVS, Microsoft Project, Visio, VNC.

PROFESSIONAL EXPERIENCE

Office of City Councilman-At-Large, Philadelphia, PA July, 2020 - Present

Programmer-Analyst

•Interacted with end-users and functional analysts to identify and develop Business Specification Documents (BSD) and transform it into technical requirements.

•Created a logical and physical database design using ERWin.

•Wrote scripts for extracting, loading, transforming data from various source systems to RDBMS.

•Worked on Task Automation using UNIX and Python shell scripts and Autosys for job monitoring and scheduling.

•Created scripts for validating and fixing bad data and generating reports.

•Provided mentoring, technical assistance, troubleshooting and alternative development solutions

.

Bank of America, Pennington, NJ November, 2017 - December, 2019

Contractor, Application Developer V

•Created and developed upper-stream loads using external tables, Oracle packages, PL/SQL, Korn Shell and Python 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. Gathered statistics by using the DBMS_STATS package. Rebuild indexes and tables.

•Developed database workframes for generating data extracts for inside business partners using PL/SQL and Oracle built-in packages. Analyzed data by creating reports using database analytical functions.

•Designed and created test environment and automated jobs for loading, transforming and verifying data during migration applications to Oracle Cloud.

•Provided secure data access to the RDR system for internal users by auditing access requests, designing and creating views and data usage and security violation reports.

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, PL/SQL 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.

•Designed and developed collections and documents in the MongoDB database.

•Created reports for the Risk Management department, utilizing Oracle stored procedures, PL/SQL, and Korn shell scripts.

ACI, Princeton, NJ March 2010 - July, 2016

System Engineer

•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, T-SQL, PL/SQL, Unix Sun Solaris, Perl and AppWorx/UC4 scheduling application used for different services such as epayment, funding, remittance and disbursement.

•Performed database programs’ tuning and analysis on existing inefficiencies utilizing Explain Plan and built-in packages and system views; created indexes and materialized views; gathered table statistics. .

•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.

•Created database triggers using Oracle PL/SQL for auditing and enforcing data integrity of tables used for configuring ETL jobs.

JP MORGAN CHASE, Iselin, NJ May 2000 - January, 2010

Sr. Programmer-Analyst

•Conducted technical activities; analyzed Windows, Linux and web applications, installed and tested applications during migration applications to the OneDesk platform. This ten-million dollar project allowed reduce money spending on applications' deployments, updates and support.

•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.

•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.

EDUCATION

STEFAN’S TECHNICAL COLLEGE, Lviv, Ukraine

M.S. in Computer Programming

LVIV’S POLYTECHNIC COLLEGE, Lviv, Ukraine

B.S. in Mechanical Engineering

SPECIAL TRAINING

In-house training in Amazon Web Services 2019

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

WORK STATUS

US citizen, authorized to work for any employer.

Contact this candidate