Andrey Sedletskiy

Experience

• 

  МЕТРО Кэш энд Керри

  Sept 2001 - Jul 2005

  System Support Specialist
• 

  IBS

  Aug 2005 - Jun 2006

  SAP BW Consultant
• 

  Orange Business Services Russia

  Jul 2006 - Sept 2009

  ORACLE E-Business Suite Specialist
• 

  OTP Bank (Russia)

  Oct 2009 - Jul 2011

  Data Warehouse Developer

  As a Lead DWH Developer at OTP Bank, I delivered technical solutions to solve business problems in a timely manner. Provided product roadmap, plan, development estimates, and weekly status reports. I consulted with colleagues, management, and business team members on requirements, problems, project status, and issues. I defined the data load strategy, monitoring and timeliness of the ETL process that supports the data warehouse.Following are the highlights of the value I brought to OTP Bank:☛ Improved the speed of ETL-procedures by two times and optimised SQL and PL/SQL code by using PL/SQL Developer and TOAD.☛ Created a lot of forms and reports in APEX using PL/SQL, SQL and JavaScript as well as developed datamarts and OLAP cubes using ORACLE OLAP option, SQL, and PL/SQL. Show less

• 

  FlexSoft, JSC (Flex Software Systems)

  Jul 2011 - Jul 2014

  Lead DWH developer

  As a Lead DWH Developer at FlexSoft, I interacted with both functional and technical groups to understand business needs, while providing oversight, identifying architectural options, evaluating options against the overall enterprise, managing information architecture, and making recommendations that return analytic business value. I implemented configuration changes, redesigns, new releases, and updates to the systems environment that aligns to the roadmap. Following are the highlights of the value I brought to FlexSoft: ☛ Orchestrated and implemented strategies for developing ETL-system with dynamic chain formation using ORACLE 12c features, SQL and PL/SQL, TOAD, and ORACLE SQL Developer.☛ Optimally utilised all the available resources for successfully creating a big part of DWH data model using ORACLE RDBMS, ERWin, and Table partitioning. Show less

• 

  KamaGames Studio

  Jul 2014 - Oct 2018

  Lead ORACLE Developer

  As a Lead Oracle Developer at KamaGames, I perform a wide range of development tasks and functions, including leading development projects, updating databases, consulting with clients, providing technical support, and preparing reports for management. I design custom workflows in OeBS using Application Workflow, PL/SQL, HTTP, and CSS. I monitor and resolve SQL performance issues for multiple applications, reporting systems, and dashboards. I increase performance, speed, and error handling of the process. I oversee the process for producing, installing, and modifying custom reports in OeBS using XML Publisher, SQL, and PL/SQL.Skills Enhancements: Software and Applications Development, Technical Support, Excellent Client Service, Management Reporting, Strategic Project Management, Application Workflow Process, Performance Improvements, Stakeholder Relationship Management, Clients’ Needs Assessments, Multi-tasking and Time ManagementFollowing are the highlights of the value I brought to KamaGames:☛ Spearheaded the creation of data gathering system from a number of servers into Apex-server using REST, text-files, JSON-files, XML-files, LDAP and OAuth 2.0 authentication, SQL, and PL/SQL.☛ Earned recognition from senior management for optimising code and eliminating errors in data transfer between systems as well as for creating bank statements loading and processing system. Show less

• 

  MSP Bank

  Oct 2018 - Sept 2021

  Lead Oracle Developer

  Leveraged broad scope of industry knowledge toward developing targeted procedures, functions, packages, reports, and / or forms for CRM system’s key users by utilizing SQL, PL / SQL, and TOAD.Performed diverse development tasks and functions, including updating databases, consulting with clients, providing technical support, and preparing reports. Promptly resolved SQL performance issues.☛ Created custom forms in CRM system using Oracle Forms.☛ Designed custom workflows in internally developed CRM system.☛ Increased performance, speed, and error handling of key processes.☛ Led process for producing custom reports using XML, SQL, and PL / SQL.☛ Developed a system of accounting for subsidizing loans and reporting on them.☛ Created and managed a system for transferring loans to special financial organizations.☛ Recognized by management for continually optimizing code and eliminating key errors. Show less

• 

  Exima

  Jul 2020 - Jan 2021

  Qlik Sense developer

  Perform a wide range of development tasks and functions, including installing Qlik Sense, leading development project, consulting with client, providing technical support, and preparing reports for management. Monitor and resolve performance issues. Error handling of the process.Remote work.

• 

  LANIT-Iv Com

  Aug 2020 - Feb 2021

  Lead ORACLE Developer

  Perform a wide range of development tasks and functions, including updating databases, consulting with clients, providing technical support, and preparing reports for management. Monitor and resolve SQL performance issues for multiple applications, reporting systems, and dashboards. Increase performance, speed, and error handling of the process. Oversee the process for producing and modifying custom reports. Using GIT for version control.Remote work.

• 

  OTP Bank (Russia)

  Sept 2021 - now

  Lead Data Governance Developer

  Capitalize on the opportunity to drive forward-thinking executive-level oversight of systems analysis and Data Warehouse refactoring. Update databases, consult with clients, and provide key systems analysis.☛ Modified ETL processes in DWH using Informatica.☛ Expertly refactored DWH from 3NF (Inmon) to Data Vault.☛ Effectively provided systems analysis to prepare for refactoring.