MSP Bank

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.

KamaGames Studio

Strategically steered optimization and development of ETL procedures for connecting OeBS, Oracle BI, and additional systems using PL / SQL and Oracle SQL Developer. Led dynamic development projects. Designed custom workflows in OeBS using Application Workflow, PL / SQL, HTTP, and CSS. Monitored and resolved SQL performance issues for multiple applications, reporting systems, and dashboards. Increased performance, speed, and error handling of processes. Coordinated the process for producing, installing, and modifying custom reports in OeBS using XML Publisher, SQL, and PL / SQL. Developed a data gathering system from a number of servers into an Apex-server utilizing REST, text-files, JSON-files, XML-files, LDAP and OAuth 2.0 authentication, SQL and PL / SQL. Earned recognition from management for optimizing code and eliminating data transfer errors between systems, as well as creating bank statements loading and processing system. Efficiently created ETL-procedures to retrieve data from HADOOP for loading it into Oracle OLAP using PL / SQL, SQL, external tables, and database links.

FlexSoft

Led key decision-making concerning data architecture, business intelligence, and data warehousing platform and tool selections. Liaised among functional and technical groups to ascertain business needs. Identified architectural options, evaluated options against the overall enterprise, managed information architecture, and made recommendations that returned analytic business value. Orchestrated strategies for developing ETL-system with dynamic chain formation using Oracle 12c features, SQL and PL / SQL, TOAD, and Oracle SQL Developer. Successfully implemented configuration changes, redesigns, new releases, and updates to the systems environment that aligned with the roadmap. Optimized the use of key resources for creating a big part of a DWH data model using Oracle RDBMS, ERWin, and Table partitioning.