Sign in

Developer Sql

Northbrook, Illinois, 60062, United States
April 18, 2018

Contact this candidate


Olga Rutsky

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


Extensive programming experience in Oracle 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. Ability to plan, organize, learn complex business functions and work well in a team environment. 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: PL/SQL Developer, pgAdmin PostgreSQL, Eclipse, MS Office tools PROFESSIONAL EXPERIENCE

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 Improved the processes and quality of our team's work by implementing test-driven development. 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.

Responsible for resolving production issues.

Provided technical and user documentation to support multiple applications. 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. Produced reports and custom files to meet the business needs of various departments 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