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