Olga Penkova

Database, ETL, Data Warehouse Developer

OBJECTIVE: To work as a Databases Developer, SQL Developer,

Data Warehouse, Data Marts, ETL Developer.

SUMMARY OF QUALIFICATIONS:

10+ years of experience in Database systems design and development

Highly skilled in Relational Database Management Systems (RDBMS), SQL development and tuning of SQL queries.

Extensive experience in the banking, education and manufacturing sectors.

Experience working with Data Warehouses, Data Marts, business intelligence tools, ETL tools such as Informatica PowerCenter.

Successful development and delivery of several highly complex projects

Demonstrated ability for problem solving, troubleshooting, performance tuning. Analytical mentality, result oriented and team player.

TECHNICAL SKILLS:

Languages

SQL, PL/SQL, C++, Java

Data Modeling

Oracle Designer, Microsoft SQL Enterprise Manager

ETL, Metadata Management

QlikView, Informatica PowerCenter, Pentaho

Technologies and techniques

Relational (ER) Data Modeling, OLTP, OLAP, Dimensional Data Modeling, Data Warehouses, Data Marts, Multidimensional Cubes.

Databases

MS SQL Server, MS Access, Oracle,

DB tools and utilities

SQL Enterprise Manager, Oracle Enterprise Manager, Pentaho, Informatica Developer, Netbeans IDE

Operating Systems

Windows

Productivity

Word, Excel, Access, Visio, Outlook, PowerPoint

PROFESSIONAL EXPERIENCE:

The Pantry of Broward, Fort Lauderdale, USA 4/2016 - current

Database developer, Reports developer

Project

Support and modification current database.

Technical Functions

Modification current database, creation new modules and new reports.

Environment

MS Access

ECO BANK, Bishkek, Kyrgyzstan 10/2010 - 10/2015

Senior Information Management Systems Specialist

Project

Design and Development of ETL processes of Revenue Analysis and Forecasting Data Mart

Role

SQL Query Developer, Database Developer, Data Warehouse Designer, ETL Developer

Technical Functions

Designed and Developed load processes from different data sources to one database using Informatica ETL tool, DM and various file extracts for downstream systems

Worked as data quality analyst, looking for ways to mitigate issues with data.

The project outcome resulted in optimizing the data model and allowed for more efficient data load as well as optimum reports performance.

Found and corrected inefficiencies in the ETL process. This improvement resulted in reduced load time for daily processes.

Performed performance tuning of Informatica mappings to speed the data load.

Environment

SQL Enterprise Manager, Netbeans IDE, C++, Informatica PowerCenter 7.1

ECO BANK, Bishkek, Kyrgyzstan 05/2008 - 10/2010

Software Developer

Project

Development and support of banking software and reporting system.

Role

SQL Query Developer; Database Developer and data analyst; Software, report developer.

Technical Functions

Found ways to optimize data model and implemented approved changes. Conducted data model reviews for other developers.

Designed and developed custom modules for installed banking software.

Provided feedback to data analyst on data quality issues and suggested ways to mitigate them.

Developed reports using Netbeans IDE.

Developed web-applications that supported branch offices

Consulted branch office employees on ways to resolve issues with updated software and various data issues

Environment

SQL Enterprise Manager, MS SQL Server, Java, Netbeans IDE, C++

Freelancing Consulting Services - Bishkek, Kyrgyzstan 01/2005 – 05/2008

Software Development Consultant

Project

Development and support of Accounting, Sales and Supply Chain Management software.

Role

Database, report developer, data analyst.

Technical Functions

Designed and developed database system for manufacturing management software.

Developed database, application and reports for Accounting and Sales Management under strict deadlines.

Analyzed data discrepancies, debugged reports, reconciled with General Ledger reports

Developed software for Payroll Processing.

Environment

MS Access, C++

TECOS-ASIA, Bishkek, Kyrgyzstan 07/2000 – 01/2005

Software Developer

Project

Creating custom software to enable manufacturer to manage inventory of manufactured goods.

Role

Software, network engineer.

Technical Functions

Designed and developed database system for Inventory Management

Developed database, application and reports for Accounting and Sales Management.

Reduced complexity of various software modules

Improved financial results of Inventory management area and reduced the waste and loss of goods.

Built and maintained company’s LAN

Provide PC support.

Environment

MS Windows, MS Access, SQL Enterprise Manager.

Kyrgyz Russian Slavic University, Bishkek, Kyrgyzstan 07/1996 – 07/2000

Software Developer

Project

Entry Test Management System

Role

Software developer

Technical Functions

Developed the automated system of processing and delivery of information containing results of entry tests in the college.

Developed and supported the HR system.

Designed and developed system that supported research of physical processes happening during mining explosions.

Environment

MS Access, Pascal

EDUCATION

Broward Community School. Fort Lauderdale, FL, USA 01/2016 – current

English as second language

Master in Computer Science & Information Systems

Kyrgyz Technical University, Bishkek, Kyrgyzstan 09/1990 – 06/1995

Attended Math Academy 09/1987 – 05/1990

TRAINING

Data Warehouse Concepts, Design, and Data Integration

Database Management Essentials

Design and development of ETL processes of DW and DM component

Oracle SQL, PL/SQL, Oracle Enterprise Manager

Informatica Power Center 7.1

QlikView.

VOLUNTEER

Barney&Nobles Books Shop, Farmington, CT

Welcome Table

The Pantry of Broward

Modifying database application, Call center, welcome table for customers

The Bennett Elementary School

Take participation in child activities and open classes.

Gymnasium 26, Bishkek, Kyrgyzstan

Helper to teacher in field trip and other outclasses works with kids.

HOBBIES

Dance (Bachata, Salsa)

Fitness, yoga

Books

Traveling

Contact this candidate