Dmitry Shatskiy - Резюме PL/SQL Developer

August 2014 — present time Senior developer of the "Competence Center for Centralized Banking Systems and Applications Integration" of the Information Technology Department AO UniCredit Bank. Moscow, Russia 2014-2016 PL/SQL Developer on the project of data migration from ABS MIDAS to ABS FlexCube 12 (Oracle Financial Services Software). Corporate accounts, loans and deposits were migrated to new banking system. Implementation on PL/SQL: • data extraction from source, source validation; • data transformation, enrichment; • target validation; • reconciliation reports; 2017-2022 PL/SQL developer on tasks of ABS FlexСube12, FlexСube6.3 customization, integration with other bank systems. Interfaces to external system: • FlexСube12 users management interface for IAM system; • Interface for processing blocks on individuals accounts from tax office; • FlexCube6.3 movements generation interface for adapter on bus; • Notifications from FlexСube12 loan module to Commissions amortization module; • Provide paid interest information for tax office; • Support loan holidays solution seamless for customers; FlexCube12 customization: • Creation new forms and dictionaries using FlexCube Rapid Application Development tool; • End of day batch form development; • Automatic interest payment though the form during EOD process; • Subsystem, calculating foreign currencies accounts fee; CI/CD processes creation and support, using stack: Bitbucket, Jenkins, Artifactory, Ansible, SonarQube; November 2012 —August 2014 Chief specialist of the Department of payment systems and processing development JSCB MOSOBLBANK JSC. Moscow, Russia • Development and support of processing system reporting (OpenWay Way4 Cards); Selection data from DB, present report in required format (Excel, Text, Word, HTML и т.д.), delivery to customer using Perl-scripts, Way4 DB Manager, Oracle Reports tools. Including generation of quarterly reports for the Central Bank (250, 260 forms); • Automation of data exchange between Processing System and external Information Systems. Receiving, validating, converting files from external systems using Perl scripts; • Way4 Cards system functionality extension using custom PL/SQL procedures; • Taking part in Way4 Cards system administration (Housekeeping, system version upgrade); Achievements: • Newly created and reviewed Processing system Reporting; • Processes automated: new cards creation based on Excel applications, uploading account balances from Banking system, personalization of non-personalized cards etc. • An encrypted file exchange system with the partners and Branches was implemented. Automated encryption/description, sending/receiving by email using Perl and VB-scripts; August 2012 — November 2012 ETL Developer RD Consulting LLC (RDTEX). Moscow, Russia • Developer on project «Corporate DWH creation for OJSC Bank VTB»: - Extract from sources, transform and load to DWH processes implementation using Oracle Warehouse Builder 10; Achievements: • Several full tructs created to upload new entities to DWH; Existed mappings were modified during incidents solutions and planned development activities; February 2007 — August 2012 Operational Reporting Expert of the Business Intelligence Department OJSC VimpelCom. Moscow, Russia • Report system development and support: - Customer requirement analysis; - Source data (DWH, Billing system etc.) structure analysis; - Development, optimization, testing procedures, collecting data for report (mostly Oracle PL/SQL, but also SQL Server Transact-SQL); - Integration new logic to Reporting system; - Support existing reports: incidents, consultations, modifications; • Ad hoc reports; • Development of reporting, based on Business Intelligence tools; Achievements: • Created and supported more than 50 reports, including complex reports: - using several source systems, - analyzing large data amounts; • Optimized existed reports which performance did not meet customer requirements; • Developed several BI dashboards using MicroStrategy, BusinessObjects Xcelsius tools;

1998-2004 Moscow Institute of Radio Engineering, Electronics and Automation (MIREA) Major: «Automated Information Processing and Control Systems» Engineer Courses: • "Oracle9i SQL Programming" (Lanit Academy, 2004); • "Oracle9i PL/SQL Programming" (Lanit Academy, 2005); • English courses (Denis’ School, 2004-2005); • "BusinessObjects XI Report & Universe Design course" (Tern, 2010); • "Informatica PowerCenter Developer Level 1" (Beeline university, 2011); • "Oracle Warehouse Builder 10g: Implementation Part 1" (Rdtex training stand, 2012); • "Oracle FlexCube Extensibility Framework" (Oracle Financial Services Software trainers, 2015); • "Oracle. Java programming in DB" (Interface, 2018); • "PostgreSQL: Level 2. Advanced capabilities" (Training center Specialist, 2022);

Relational DB theory knowledge; Understanding of Oracle DBMS operation principles; Wide experience of SQL, PL/SQL using. Including analytic functions, pipeline functions; Experience of SQL-optimization, processing large amounts of data; Communications with IT system customers, business requirements formalization and clarification. Search for best ways to implement requirements; Development of CI/CD processes skills: Git + Jenkins pipelines + Shell scripts + SonarQube + Artifactory + Ansible; Basic programming skills: Python, Perl, VBA, PHP, HTML; Usage experience with GIT + Bitbucket, Jira and Confluence; Pet project: Robot, trading on the stock exchange, written on Python, working through broker API;

Английский

English level
B1-B2