Olga Lomina

Cell: +1-425-***-**** E-mail: ac7zj6@r.postjobfree.com Skype: olga.lomina

SUMMARY:

•Professional experience in application analysis, design, development, testing, implementation, support and maintenance (10+ years)

•Strong experience in developing front-end GUI based applications using PowerBuilder with emphasis on object-oriented programming (10+ years)

•Experience with RDBMS Oracle, PL/SQL, SQL (10+ years)

•Experience of Database Design and Development (10+ years)

•Experience of tuning SQL queries (10+ years)

•Experience in C#

TECHNICAL SKILLS

Languages: SQL, PL/SQL, PowerScript, C#

Databases: Oracle - PL/SQL,

Software & Tools: PL/SQL Developer, SQL Navigator, PowerBuilder, Oracle Designer, Erwin, Microsoft Visual Studio, Microsoft SQL Server Management Studio

PROFESSIONAL EXPERIENCE

Jul 2012 Sep 2015 Software Developer, JSC IRM Development, Moscow, Russia

Developed the "Analytical information system for automation of trading in the wholesale electricity market" based on Oracle database and developer’s tools. Participated the system design business analysis, and table definition of the comprehensive and complicated a corporate information system software consisting of more than 1500 modules and 400 tables.

Performed configuration of the system - administration.

Designed and implemented a database structure to store of data of trading in the wholesale electricity market.

Developed a process to load data from suppliers and consumers to the data warehouse using the corporate information system.

Have developed and modified more than 300 forms, reports, procedures/functions using PowerBuilder and PL/SQL. Coded and tuned large PL/SQL stored procedures more than 20 thousand lines of codes for Analytical information system and enhanced the performance through the fine-tune of queries and creation of appropriate indexes.

Strong PL/SQL coding experience using packages and stored procedures, functions, packages, triggers.

SQL statements tuning.

Environment: Oracle 10g, PL/SQL Developer, SQL, PL/SQL, Erwin, PowerBuilder

Mar 1995 Jun 2012 Sr. Software Developer, JSC Tulachermet, Tula, Russia

Development of a Corporate Integrated Information System based on Oracle database and developer tools for the maintenance activities of the entire organization using client/server technology. This system helps to organize, plan and monitor maintenance activities and to increase efficiency production. Identified and analyzed the new requirements to increase the business effectiveness, managing the overall application infrastructure. Developed and implemented next tasks: HR Department, Wages, Staff Schedule, Chemical Analysis for the Factory Laboratory, Accounting and Control System for Document Execution, Cost Estimates.

Designed and implemented a database structure to store of data.

System configuration.

Designed and developed many forms and reports required by customers using PowerBuilder.

Developed a GUI using PowerBuilder.

Wrote SQL and PL/SQL scripts to create stored procedures, functions, packages and triggers.

SQL statements tuning.

Tested, implemented and supported software of new software products and the existing ones.

Environment: Oracle 9i/10g, Oracle Designer, SQL Navigator, PowerBuilder, SQL, PL/SQL

EDUCATION

1994 Engineer, Automation and control in engineering systems, Tula State University, Russia

2018 Developer C#, SQL server, .NET Framework, Algorithms and Data Structures, Kal Academy, WA

https://github.com/OlgaLomina

Contact this candidate