Andrei Chirkov Email & Phone Number

Moscow, Russian Federation

• Developed an insurance premium calculator for a new B2B platform which was awarded the "Time of Innovation 2021" award as the "Service Solution of the Year".• Implemented Git integration and automation of the release cycle with code formatting and quality control. Time spent on all stages of the release cycle has been drastically reduced as well as the number of potential errors during this cycle.• Developed Health Insurance subsystem and SOAP methods used by the mobile application… Show more • Developed an insurance premium calculator for a new B2B platform which was awarded the "Time of Innovation 2021" award as the "Service Solution of the Year".• Implemented Git integration and automation of the release cycle with code formatting and quality control. Time spent on all stages of the release cycle has been drastically reduced as well as the number of potential errors during this cycle.• Developed Health Insurance subsystem and SOAP methods used by the mobile application backend.• Performance tuning and query optimization.• Implemented additional automation and business functions.• Participated in DWH design and implementation of ETL processes using T-SQL.• Code-review and mentoring.Oracle Database, SQL, PL/SQL, REST, SOAP, ORDS, Oracle APEX, utPLSQL, ElasticSearch, Java Git, Jira, Confluence Show less

Москва, Россия

• Participated in the migration of the application from IBM DB2 to Oracle Database• Database architecture refactoring to simplify future developments.• SQL and PL/SQL performance tuning and profiling.• Database architecture design and application development.• Reports development.• Unit testing.Oracle Database, SQL, PL/SQL, XML, utPLSQL Git, Bash, SQLDeveloper, Toad

Москва, Россия

• Successfully migrated application from Oracle Database 10g to Oracle Database 12c: performance issues resolved.• Developed procedures and applications for downloading and verifying transactions and contracts from various markets and exchanges. This helped to reduce costs and avoid new license orders during the economic crisis.• Software troubleshooting: SQL tuning and PL/SQL performance optimization.Oracle Database, SQL, PL/SQL, XML, XMLDB, XSLT, Java, Python, Softwell… Show more • Successfully migrated application from Oracle Database 10g to Oracle Database 12c: performance issues resolved.• Developed procedures and applications for downloading and verifying transactions and contracts from various markets and exchanges. This helped to reduce costs and avoid new license orders during the economic crisis.• Software troubleshooting: SQL tuning and PL/SQL performance optimization.Oracle Database, SQL, PL/SQL, XML, XMLDB, XSLT, Java, Python, Softwell Resource Navigator Show less

Москва, Россия

• Administration and support of the Treasury and Capital markets platform.• Modification of the existing code: bug fixes and new features implementation.Oracle Database, SQL, PL/SQL, Softwell Resource Navigator

Москва, Россия

The main developer of the IVF subsystem which was used by the two largest Russian IVF clinics.• Research, development and implementation of the application in close cooperation with customers and in accordance with local legislation.• Database replication and migration.• Demonstration of the solution.T-SQL (Microsoft SQL Server 2005/2008)

Specialist, Applied Computer Science, 4,8 Of 5

Honours Degree

Education record