Oracle PL/SQL Developer

• Jan 2023 - Present

Senior Data Engineer at Sovcombank (TOP-10 Bank in Russia, Finance, Banking)

• Jan 2021 - Dec 2022

• Developed software for high scale Big-data banking system. Worked primarily on the online credit card processing functionality using Oracle SQL, PL/SQL and Java. Implemented performance tuning and code optimization. Ensured high scalability and availability. • Performed tuning and optimizing SQL & PL/SQL code performance using performance monitoring tools (HPROF & Oracle Enterprise Manager) • Provided technical mentorship to junior team members, performed code and design reviews to a group of 15+ developers. Improved coding standards and best practices by reviewing pull-requests. • Supported banks M&A deal providing Oracle DB data migration (3M+ clients, 1M+ of loans and deposits). This was achieved by using Oracle ETL tools and PL/SQL. My contribution has been rewarded with a personal merit. • Implemented backend logic of B2C Credit Cards cashback and subscription algorithms using PL/SQL and ETL tools. This has increased customer satisfaction score by 25%. Show less

Oracle Developer at Gazpromneft-Digital Solutions (TOP-40 High-Tech company in Russia)

• Mar 2019 - Jan 2021

• Developed software for storage, processing and reporting telemetry data in the process of oil and gas production using SQL, PL/SQL and Java code. • Performed ongoing support for 7 to 10 production applications and databases. • Optimized data merging process by creating the parallelized data pipeline procedures that resulted in a 10x improvement of application performance. • Developed software for storage, processing and reporting telemetry data in the process of oil and gas production using SQL, PL/SQL and Java code. • Performed ongoing support for 7 to 10 production applications and databases. • Optimized data merging process by creating the parallelized data pipeline procedures that resulted in a 10x improvement of application performance.

Senior Systems Developer at 1C ERP (High-Tech company)

• Jan 2012 - Feb 2019

• Developed 1C ERP + Microsoft SQL Server Systems for multiple retail, developer and production companies • Created, refactored and optimized internal code of 1C ERP Systems • Maintained and serviced databases using Microsoft SQL Server • Implemented several systems providing automation in business processes including production, bookkeeping, sales, supply, analytics which have been used for the past 10 years by more than 3000 people • Developed in collaboration with other team members of the database dev group an equipment accounting system (1 million+ items) for a large production company which led to greatly improved financial planning • Led a team of developers in process of development 1C ERP Systems from scratch for the retail chain of 60 stores and data migration from DB2 to Microsoft SQL Server Show less