Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Gennadii Garshin

Sr. Oracle Developer

Summary

An experienced Software Engineer with a wide range of technical skills and knowledge. Obsessed with Oracle Database technologies and strive to develop deep expertise. Skilled in data integration, data manipulation and processing. I have a positive attitude to new technologies, so I'm not afraid to gain knowledge quickly. My experience gives me a systematic and broad vision of solving technical problems. It allows me to predict and prevent all possible problems at an early stage.

Overview

9
9
years of professional experience
5
5
years of post-secondary education
7
7
Certifications

Work History

Software Development Engineer

Weigandt Consulting GmbH
Aachen
03.2021 - Current
  • Working on huge projects based on Oracle Retail software products.
  • Performing data migration and data integration between different systems.
  • New data interfaces software development.
  • New core functionality development and refactoring of the existing solution.
  • Database optimization and performance tuning.


DWH/BI Developer

Splat
St.Petersburg
02.2018 - 03.2021
  • Full cycle developing of the Data Warehouse on Oracle DB.
  • ETL development to populate DWH from different sources.
  • Data quality, monitoring and alerting control procedures developing.
  • Wrote and optimized SQL statements to assist business intelligence practices.
  • Performing optimization tuning on each step of data warehouse development.
  • Compiled, maintained and developed database systems for tracking tailored content reports.

PL/SQL Developer

Splat
St.Petersburg
10.2015 - 02.2018
  • Support of the existing Data Warehouse system based on Oracle DB.
  • PL/SQL code refactoring, optimization tuning.
  • Cooperation with different departments such as Fraud, Payments, Finance, Marketing in data preparation for KPI analysis.
  • Developing online reports, self-service reporting, olap cubes, custom asp.net reporting application, operational ad-hoc reporting
  • Data marts, ETL developing.
  • Created optimal technical solutions to user needs with in-depth system analysis.
  • Implemented system enhancements to design and develop solutions to address problem reports.
  • Analyzed existing SQL queries to identify opportunities for improvements.

Support Engineer

Gortis Softlab
St.Petersburg
07.2014 - 10.2015
  • Working on huge GIS projects for Russian energy companies as a Technical support engineer.
  • Incident solving.
  • Software troubleshooting.
  • Communication with business users and developers.
  • Operational data reporting.
  • Technical documentation handling.

Education

Master of Science - Management Information Systems And Services

Volga State University of Telecommunications And I
Samara, Russia
09.2009 - 06.2014

Skills

    Data extraction and integrattion

Certification

Coursera. Data Science Professional Certificate

Timeline

Oracle 12C Release 2 Backup and Recovery Using RMAN

02-2022

Oracle Cloud Infrastructure Foundations 2021 Associate

12-2021

Software Development Engineer

Weigandt Consulting GmbH
03.2021 - Current

Coursera. Data Science Professional Certificate

05-2020

Oracle Database PL/SQL Developer Certified Professional

11-2019

Performance diagnostics based on AWR and ASH reports

10-2018

DWH/BI Developer

Splat
02.2018 - 03.2021

Oracle Database SQL Certified Associate

06-2017

PostgreSQL Administration 9.4. Basic Course

02-2017

PL/SQL Developer

Splat
10.2015 - 02.2018

Support Engineer

Gortis Softlab
07.2014 - 10.2015

Master of Science - Management Information Systems And Services

Volga State University of Telecommunications And I
09.2009 - 06.2014
Gennadii GarshinSr. Oracle Developer