Alex Kataev Email & Phone Number

Sydney, New South Wales, Australia

Sydney Area, Australia

C# developer in the Smartgroup project team where my focus is primarily on migration of the client's projects to Azure. The project team has achieved:● Successfully migrated the one of the intranet applications (which plays critical role in client's infrastructure) + public web portal from on premises environment to Azure, including full application revamp to avoid typical Azure migration issues such as dealing with MSDTC, splitting application on services to isolate code parts which can't be migrated to the Azure webapp service, introducing asynchronous execution tasks using Azure web jobs ● Performance improvement and introducing monitoring solution (Dinatrace) to the migrated applicationsWas as a backend/fullstack developer in the one of the Adviser Intelligence project development team. As a member of the team I ● Actively participated in the knowledge transfer process from the previous project development team● Was a part of the team which established the new technology stack using Microsoft Azure, Service Fabric, Nginx● Developing Insurance Tool/CAP modules including database schema design, implementation of data access layer, developing client UI components using AngularJS/ReactJS/Typescript● Performing code review, refactoring and unit testing of all levels of the application

Sydney Area, Australia

● Designed and implemented database and object cache storage layer using MS SQL, .NET, Entity Framework● Populated server’s functionality through WCF SOAP and REST services ● Created C++ CLI wrappers for accessing native C++ libraries from .NET● Developed libraries for math calculations, using C++ Boost/STL libraries● Developed Excel Add-in functions using ExcelDNA library and Excel Automation API ● Developed management client application using Winforms and WCF● Participated in web portal development process using MVC/Javascript/Bootstrap stack● Integrated Python script engine to the server and developed C# to Python wrappers, for providing the intercommunication between user python scripts and server core libraries● Performed code review, refactoring and unit testing of all levels of the application

Perm, Russia

Designed and coded database layer used in all database oriented company projects. The list of functionality includes data warehousing, master data management, ETL procedures, OLAP engine, auditing, batch job scheduling, calculations, security, etc. Designed and developed PL/SQL API to work with slowly changing dimensions in data warehouse.Introduced version control system (Microsoft Team Foundation Version Control) in all aspects of database developmentActively participating in the system design and architectureRedesigned existing software modules like OLAP subsystem and ETL in such a way that overall performance increased significantly. Developed complex code units using the latest features to optimize performance (bind variables, bulk binds and fetches, query rewrite and materialized views, partitioning, global temporary tables, index-organized tables, pipelined functions, function result cache, native compilation, etc.)Has a lot of experience in SQL queries tuning (SQL TRACE, CBO, 10046 and 10053 events, TKPROF, EXPLAIN PLAN, wait events, external manipulation of statistics using DBMS_STATS, optimizer hints, bitmap and functional indexes) on large database environments (up to 2 terabytes) Extensively worked with Oracle utilities: Import / Export (including Data Pump), SQL*Loader, SQL*Plus Has solid knowledge and hands-on experience in other Oracle technologies: Oracle Data Cartridges (Extensible Indexing, Extensible Optimizer); Oracle Advanced Security (Fine-Grained Access Control); Heterogeneous Connectivity and Transparent GatewaysMetadata API (DBMS_METADATA) Hands on solid DBA experience (upgrade, patching, tuning, recovery, etc.)

Developed OLTP accounting system (Oracle 8i, PL/SQL packages, Java, Swing and EJB) , wrote PL/SQL packages used to calculate and publish accounting reports, server-side part of java application using EJB2 and JBoss, client side of java application using SWING, java report engines (JReport, JasperReport)