Andrey Sedletskiy

Andrey Sedletskiy

System Support Specialist

Followers of Andrey Sedletskiy213 followers
location of Andrey SedletskiyPoland

Connect with Andrey Sedletskiy to Send Message

Connect

Connect with Andrey Sedletskiy to Send Message

Connect
  • Timeline

  • About me

    Senior ORACLE Developer with 15+ years’ experience in ORACLE Technologies and IT Project Management

  • Education

    • Московский Государственный Университет им. М.В. Ломоносова (МГУ)

      1994 - 2001
      Masters of Science Physics
  • 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.

  • Licenses & Certifications

    • Oracle Advanced PL/SQL Developer Certified Professional

      Oracle
      Dec 2013
    • Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist

      Oracle
      Sept 2013
    • Oracle PL/SQL Developer Certified Associate

      Oracle
      Nov 2011
    • Cisco CCNA, Cisco Certified Network Associate

      Cisco