Alexey Makhnev

Career Profile

Senior / Lead Java developer with 15+ years of hands-on development, maintenance and support experience in multiple large-scale multi-country projects, determined to build robust solutions solving challenging problems within Databases, Integration, Data Engineering areas in most elegant, lean and effective way.

Professional Expertise

Integration

It is not an easy task to create really effective team from strong performing individuals. And here I am not speaking about the people but software applications. For me integration is one of major areas of interest with many years of experience working with all kinds of enterprise grade integration tools – from creating complex integration scenarios with SAP Process Integration or Microsoft Biztalk to high performing ETL processing using PL/SQL or SSIS.

Custom development

I love developing and very often custom code could become the most elegant way to solve complex problems. I have extensive experience in designing and implementing system critical components on application or database levels using mostly Java and PL/SQL, occasionally putting my hands on variety of tools and languages – maintaining front-end using HTML/CSS and Javascript, fixing webservice implemented in C#, creating complex Excel macros with VBA and batch scripts with Python or bash or Powershell.

Solution ownership

I never had word “owner” in my official work title. However for me ownership never was about the title but how you do your job – it is about personal responsibility for the solution, sticking to commitments, communicating on all levels to transform ideas from business users to programmers or management, making real difference. Helping people by solving complex problems and addressing challenging requirements really makes my everyday work enjoyable and brings satisfaction.

Programming Languages and Technologies

Java SQL PLSQL Javascript ASP.Net/C#/VBA Oracle DB MSSQL DB SAP PI/PO ETL

Work experience

Experian

London, UK
Oracle Development Lead
11/2018 – now

Hands-on leadership of 10 developers to deliver backend component of the strategic anti-money laundering application for one of the world’s largest banks. Architecture and design of new features, implementation of critical modules, overlooking all regular developments and bugfixes, doing code review and mentoring more junior developers. Setting up effective development processes as team structure has been changed from flat to hierarchical due to growth and development model is gradually moving from Waterfall to Agile. As part of project leadership team, defining technology aspects of product roadmap to expedite new features delivery – breaking down monolith application into loosely coupled modules, migrating complex static ETL processes to independent microservice-style architecture. Application owner in enterprise landscape, collaborating with external teams to ensure smooth solution functioning, providing L3/L4 support to end users.

Integrace Ltd (contract)

Woking, UK
SCP Integration Lead, project for AB-InBev/Asahi
12/2017 – 11/2018

Implementation of SCP and Manufacturing integration solution separation as part of AB In-Bev Europe business divestment. Managing transition of services to offshore development/support team. Design and development of data integration front-end application within SCP and Distribution area providing UI & REST / SOAP API (Java / Spring MVC). Establishing wider integration governance framework, ensuring integration component of new projects is following enterprise design patterns and best practices.

SABMiller Plc

Woking, UK
Integration Solution Owner
05/2012 – 04/2017

All-in-one architect / functional designer / developer / product owner of a custom-built system for high throughput data integration between SAP and SCP Infor landscapes within GT solution, built on Oracle technologies (350+ tables, 250+ PL/SQL / Java ETL/ELT procedures with 50K lines of code in total).

  • Build and enhancement of solution core components and interfaces such as:
    • High-performance interface for SAP movements and sales documents resulted in near-real-time operational data visibility.
    • Multiregional feature allowing solution to work 24×7 mode providing businesses within different time zones (Europe, Australia, LatAm) with the same level of service.
    • Performance improvements – full MD regeneration time reduced from 2.5 hours to 30 minutes, processing of large transactional datasets – from 6-8 hours to 20-30 minutes.
  • Support and change management of the solution in multiple simultaneous projects and environments.
    • Deployed solution in multiple regions, including Australia, Czech/Slovakia, Netherlands, Poland, Romania, Latin America countries.
    • Designed version control process for Oracle database objects and moving changes across complex enterprise landscape (two tracks with several dev/test environments in each). With up to 100 active changes, no issues were connected with misalignment of objects.

SABMiller Plc

Woking, UK
Service Manager
04/2016 – 04/2017

GT Non-SAP Service Delivery Manager was a secondment role. Managed operations of GT Non-SAP systems with more than 100 application servers and databases in production landscape. Key responsibilities include:

  • Change management, coordination of emergency/regular maintenance and patching processes.
  • Driving activities executed by multiple geographically distributed support teams (business users, onsite and offshore support, vendors)
  • Hand-on works on systems supported internally, root cause analysis, implementation of changes.

Japan Tobacco International

London, UK
Integration Developer
09/2011 – 12/2011

Designed several custom SAP PI interfaces between SAP ECC and storage system using Java//Database/ccBPM. Implemented advanced alert mechanism allowing users to restart certain BPM activities from email. Reviewed all JTI SAP PI interfaces, completed migration assessment from PI 7.0 to PI 7.3.

Service Birmingham

Birmingham, UK
Integration Developer / Solution owner
02/2009 – 09/2011

Customer First project is a SAP implementation in UK’s largest council (one million residents) aimed to automate all aspects of daily council tasks. As part of project team implemented several integration interfaces using custom Java development within SAP PI ESB. At a later stage moved into SAP PI integration landscape owner role in support organization with responsibilities to maintain smooth operation of more than 250 integration interfaces in production.

GESeaCo

London, UK
Senior Consultant
03/2008 – 01/2009

Technical team lead completing integration component of solution for reliable collection and processing of EDI messages in global container leasing company. Trained small off-shore development and later the support team, designed support processes. Overall positive feedback on solution was received during first week after go-live with number of errors in integration layer reduced from 10% of all traffic to 0.

IBS Group

Moscow, Russia
Senior Consultant / Developer
12/2004 – 02/2008

Successfully completed several projects for large customers by developing and supporting solutions based on Java/.Net, enterprise grade databases, SAP / Microsoft integration technologies, with most notable example being development and ongoing support of custom-built system managing masterdata for 180M customers of one of biggest Russian bank

SoftAriA

Novosibirsk, Russia
Java Developer
01/2002 – 12/2004

Completed development of several mid-to-large scale websites based on J2EE/Oracle technologies.

Education history

August 2017, Google Cloud Certified
Google Certified Professional – Data Engineer
Verify

2007, SAP Certification
Development Consultant SAP NetWeaver ’04 – Exchange Infrastructure & Integration Technology.

1996-2001, Novosibirsk State University, Novosibirsk, Russia
Mathematician/System Programmer in Applied Mathematics and Computing Systems.
Specialist Degree (with distinction), equivalent to BS (Hons) or higher.