Sign in

Developer Web

Northbrook, IL
March 11, 2020

Contact this candidate


Olga Rutsky

Phone: 847-***-**** E-mail: Northbrook, IL 60062


Extensive programming experience in Oracle APEX, Oracle ADF and PL/SQL Development of Business Applications. Also proficient in Web Development and Ruby on Rails technology. Developed Complex database objects including PL/SQL Packages, Stored Procedures, Functions. Developed Datamart Load programs to load data from OLTP database to Datamart database. Loaded Data into Oracle Tables using SQL Loader.

Experience with all phases of Software Development Lifecycle, Oracle, SQL, Ruby, Java, and PostgreSQL databases and building complex reports,

Excellent troubleshooting, analytic, problem solving, strong business analysis, communication and leadership skills. Flexibility to adjust to business needs, and handle multiple priorities and deadlines. TECHNICAL SKILLS

Languages: PL/SQL, SQL, XML, HTML, UNIX Shell Scripting, Ruby on Rails, Java, JavaScript Software: Oracle APEX, Oracle ADF, Jdeveloper, SQL Developer, PL/SQL Developer, Jira, pgAdmin PostgreSQL, Eclipse, MS Office tools


Wells Fargo., Rosemont, IL Feb 2019 – Nov 2019

Oracle PL/SQL and Web Developer

Development of Business Application using Oracle ADF, Jdeveloper with a team in Agile environment. Created Oracle database objects, stored procedures, documentations. JPMorgan Chase & Co., Chicago, IL May 2018 – Nov 2018 Oracle PL/SQL and APEX Developer

Conversion Business Application to Oracle 12C and APEX 5.1. Created Oracle database objects, stored procedures and data load scripts. Worked with a team in Agile environment.

Kantar Media SRDS, Rosemont, IL 2000 – Aug 2017

Systems Developer 2006 – Aug 2017

Responsible for Application Development using Oracle 10g, PL/SQL, SQL*PLUS and SQL Loader that supported business needs for print and on-line products.

Created Oracle and Postgres database tables.

Created Unix shell scripts for invoking SQL scripts and scheduled them in crontab. Worked on Web Development using Ruby on Rails, MongoDb, PostgreSQL, JavaScripts, HTML and css for company website and online data entry application. Updated and supported PL/SQL application that generated XML / HTML for on-line products Partnered with members of the Product Marketing Teams to develop and maintain company website. Created ad-hoc reports for Marketing and Data Operation departments. Wrote JAVA client and internal custom files per Marketing requirements. Developed programs using Ruby on Rails and Java Script for the creation of the new company website Responsible for 24/7 support (including weekends) to ensure Oracle database exports and data loads performed correctly, resolved production issues.

Database Administrator 2002 – 2005

Developed PL/SQL programs for new SAP Billing Processing System. Converted COBOL extraction application to PL/SQL, including the creation, implementation and monitoring of Oracle databases, and database maintenance. Developed Oracle forms application for a data dictionary. Database Analyst 2000 – 2002

Converted DMS(Data management system) from C++ and COBOL to PL/SQL Led print product extraction conversion

Managed Data Load process for print and on-line products Catalpa Systems Inc, Chicago, IL 1996 – 2000

Oracle Developer 1996 – 2000

Designed software for food and restaurant industries using Oracle Form and Reports. Converted COBOL programs to PL/SQL.


B.S. in Engineering, Belarusian National Technical University, Minsk, Belarus PROFESSIONAL TRAINING AND CERTIFICATIONS

Pentaho Data Integration Fundamentals, 2016

Ruby on Rails, 2011

Oracle Database 10g, Java 2 Course, 2006

XML Fundamentals, 2004

Oracle University course: Develop PL/SQL Program Units and Advanced PL/SQL, 2001 Introduction to the UNIX Operating System, UNIX Shell Scripting, 1996 Oracle University course: Introduction to Oracle - SQL and PL/SQL, 1996 COBOL Application Development, 1996

Contact this candidate