Igor K Resume

IKT Limited, December 2017 – now

·         Analysing the Segmentation feeds provided by AppNexus

·         Recover MS SQL Database data after data corruption incident

·         Optimising the database infrastructure on Microsoft SQL Server, including always on topology

Lead SQL Developer, Intermediate Capital Group Plc, July 2017 – October 2017

·         Take ownership of BI solution that brings in data from different lines of business into DW

·         Manage three SQL Developers.

·         Automated deployment process using Octopus and Team city, migrate solutions to Git source control

·         Review the MDS solution, provide roadmap for redesign of data pipeline taking into account all the different sources.

Database optimisation, Eurostop Limited China, June 2017

·         Review database design, suggest possible changes and demo tools that could be used to meet business requirements

·         Optimisation of database objects, troubleshoot deadlocks, provide maintenance plans, etc.

·         Optimisation of SSAS cubes

·         Train staff to do further maintenance of databases and troubleshooting.

Data Lake and DW projects, The Exchange Lab, June 2016 – May 2017

General

·         Technical lead of the project, managing of 2 resources and external consultancy.

·         Built full end to end testing/demo environment that included source systems, DW, Data Lake, Tableau

Data Lake

·         Data lake was implemented using AWS EMR cluster and S3 buckets, with the ETL implemented in Spark and Java, CSV and JSON sources, parquet partitioned outputs.  I was technical lead and helped to translate existing SSIS functionality into SPARK ETLs, reviewed and approved architecture for the DL to meet business requirements, managed all work for the initial project to complete on time.

·         Provided training to the team how to operate data lake, SDLC model, use of Git repository for java projects, basic tasks in Java to enhance the application, trained spark and scala, integrated with Bamboo

·         Extended Scala/Spark ETLs with new data sources and data publishes

·         History backload including dealing with schema changes

·         Rewrote SPARK ETL to stage conformed data in HDFS hot cache to speed up downstream publishes, merged outputs to speedup S3 copy process, adjusted memory settings to make more efficient Spark execution

·         Automate deployment via Bamboo, setup QA environment, defined operational processes and EMR cluster build, DR plan for 2 EMR clusters, python scripts to do housekeeping of logs, integration with Grafana dashboard for performance monitoring.

·         Implemented publish into different S3 locations for separate consumers, so different S3 security policies can be used

DW

·         Rewrote ETLs to process 4 billion messages a day, running feeds in parallel, utilising AWS EC2 infrastructure with a factory of SSIS Servers.

·         Implemented best practises in Kimbal design and etl templates like junk dimensions, early arriving facts, etc.

·         Implemented inmemory caching to improve performance of SSIS

·         Defined team structure, release process, development process, collaboration, use of Git repository and checkin/checkout process

·         Provided training to the dba on how to maintain the solution

·         Automated Tableau data sources deployment, extended Tableau data model

·         Redesign ETL to have individual packages for each stage of load, i.e. Extract/Transform/Load/PostLoad allowing for better team development and use of staging as extract only rather ODS.

·         Implemented multi-threading of package executions

·         Implemented time zone reporting (with 10 time zones, extensible) in Tableau to allow different regions to analyse data in their time zone rather UTC.

·         Implemented security model for Tableau

·         Migrated all DW infrastructure to SQL 2016 EC2 instances, with plans to move to AWS RDS.

Traveling, December 2015 – April 2016    

Investec Bank Plc

December 2014 – December 2015                  BI Architect/Development manager

I was hired to take the team through the transformation process and introduce best practises and processes.  When I joined the team consisted of 6 developers, 3 business analysts and 2 support engineers but due to corporate culture each was working in silo.  While I was there, I’ve introduced agile process, migrated development to VS2013, Git/Stash and Jira, build a team spirit, improved on code sharing and cross skilling.  I’ve prepared the environments to be upgraded to SQL 2014 from 2008R2 version.  As part of data lake initiative, I’ve designed the Corporate Data Warehouse model and started migrating silo reporting solutions to this schema.

Major projects worked on:

·         Migration of Capital Calculation engine to Moody’s

·         Data warehouse to report on revenue for traders based of Fidessa and RIMS systems

·         Capital and Provisioning ODS for Leasing business that interfaced with Equifax, LeaseSoft, risk calculation engine(similar to matlab) over ESB and captured application and behaviour parameters.  Data warehouse design for Leasing business as well.

·         Enterprise data warehouse model within data lake for consolidated balancesheet reporting and detailed lines of business reporting, started with migration of LeaseSoft data warehouse

·         IFRS9 (that included application and behaviour scoring using in-house developed model execution engine, capturing and transforming data from every line of business that has exposure, etc.)

·         Migration of Trading Data Warehouse to new architecture (Calypso, Chi as back end)

·         FSCS reporting

·         Reporting on external brokerage business that served SED desks (BoNY and Opal).

·         Fatca reporting

·         Client data MDM solution across all business lines (PB and CIB, SA and UK)

·         Credit Ratings data service providing S&P, Fitch and Moody’s ratings to all lines of business.

City Index, Financial reporting and business intelligence

City Index is one of the world leaders in spread betting and CFD trading.  We provide consistently competitive spreads and access to thousands of markets worldwide including indices, shares, currencies, commodities, bonds, interest rates and more. We transact in excess of 2 million trades every month for individuals in over 50 countries worldwide.

March 2013 – December 2014                        BI Architect/senior developer

I took over the responsibility of leading the technical implementation of the BI platform.  I am responsible for making sure the teams implementations fit into the design of the platform, the platform adapts and evolves to the new requirements and ever changing business requirements.  The team consists of 5 developers, 2 QAs. The development process is based on Agile development methodology, runs in 2 weeks sprints, peer reviews and continuous deployment.  The reporting platform sources data from number of different trading platforms based in the UK and US, third party systems and manually managed MDM files, loads using ETL framework (supports type 0,1,2 slowly changing dimensions and additive/semi-additive facts) built on top of SSIS framework.  The data is presented to the end users via standard Star schema data-marts, SSRS reports and SSAS cube with number of out of the box and complex MDX members to allow “from/to” period analysis, current period, year-to-date, KPIs, etc. 

Achievements

Reverse engineered, brought in client activity on trading platforms data.

Consolidated client acquisition data scattered across number of front end platforms, core trading platforms, marketing management systems, mapped, cleansed and brought into central repository, that subsequently feeds into different KPIs, giving information on P&L and trades numbers by platforms, P&L generated by new clients acquired through different campaigns, etc.

Designed data model to reflect client, sales person, introducing broker, broker participants and legal parties’ relation.

Brought in measures to cover GL, instructions, rebates, trades, client activity including trading platforms

Regulatory reporting - FATCA, PRR and CRR, trades reporting as per CRD IV/EMIR.

Performance optimisation of SSAS- consolidated mini dimensions into larger junk dimensions, partitioned cube, implemented cache warming, aggregations and optimised members for fast dimensional browsing, implemented time intelligence (YTD, MTD, etc.).

Designed real-time feeds into data-warehouse. Designed framework for external reporting of the Datawarehouse, including security model, with SSRS and SSAS as end tools.  Designed data model to support report translations

Designed reference data framework (MDM)..

Implemented automated deployment into any environment (dev,qa,ppe,live) including db changes, SSIS, SSRS, SSAS (CI) and driving test automation.

Continuously coach business users on how to use the BI platform including cube and data warehouse, how to build pivot tables and queries to minimise delays and help them to come up with new ideas and requirements.

Towers Watson, Risk Consulting and Software Line of Business

Towers Watson is one of the leading global professional services company that helps organizations improve performance through effective people, risk and financial management. With 14,000 associates around the world, we offer solutions in the areas of employee benefits, talent management, rewards, and risk and capital management.

June 2012 – March 2013                                  Data Architect/Database Developer

With Towers Watson I was responsible for looking after the database part of any development, promoting database solutions, implementing best practices, proposing/reviewing client database server infrastructure, taking on the database responsibilities for the Risk Capital modelling application and life Risk Modelling application for the EMEA region.  I lead number of R&D work streams across other departments within the Risk Consulting, including Investment and PC.

All the development follows the Agile end of the RUP methodology and distributed between Atlanta USA, Sidney Australia, Cambridge, Oxford, London and number of other development centres.  Data modelling is done using Sparx Enterprise Architect.  All software products/ database products have been designed to comply with Solvency II.

Major achievements:

Modelled the data for the new risk modelling software.  Evaluated the reusability of the statistics engine and reporting solutions from the investment branch and came up with the proposal for combined solution shared by all deparments.

Implemented Reporting POC that was basis for the reporting module of the new risk modelling application (www.towerswatson.com/en-GB/Press/2014/02/towers-watson-announces-next-generation-modelling-software-for-life-insurers).  SQL, Excel PowerPivot, OData feed publisher, generators of VaR, Percentiles, Black-Scholes, etc.

POC of a full Enterprise Data Warehouse solution for the enterprise version of the risk modelling application.  Consists of SSAS Tabular and MultiDimensional, SSRS, PowerView, autogenerated SSIS packages, and import management framework, SharePoint 2013 as platform for reporting, OData feeds, integrations with third-party dashboards, additional data imports, exports, etc. with data-warehouse under the bonnet.  Solution would allow integration with any other part of the business, on-site and cloud solutions, third parties, deployable to any of the may TW clients.  Solution supported auditing requirements of data as well as code for the investment solutions.  For example, it would allow to reproduce any results as per Solvency II.

Modelled the data and then designed and developed the physical implementation for the POC for the usage based insurance solution.  High transaction VLDB solution, high frequency, small record sets would be retrieved to evaluate scoring and report back to consumers.  Modelled the data, estimated the data sizes and possible speed of data retrieval.

Designed and developed with a team of actuaries a Policy Management tool for one of the new insurers based in Hong Kong, China.

Redesigned the code base for Risk Agility software to simplify build process.

  The Office of Gas and Electricity Market, London UK

The independent government body responsible for monitoring and licensing of Gas and Electricity industry insure safety of the UK energy supply.

November 2010 – June 2012                           Data Architect/Senior Database Developer

At the time of leaving Ofgem I was combining Data architect and Database team lead.  As an Data Architect I was responsible for working on projects from their conception/feasibility stage to the end, engage with BAs and business owners to create and write requirements, model the data, create database ER designs and verify their implementation by the development team, running number of R&D projects and pitching them to the Business steering comities as well as looking after the project budgets.  All the data modelling would be done using IBM Rational Architect package.  RUP methodology was used to run large projects and Agile for small ones.

As a database lead I was responsible for change management/approvals, release management and db builds, overseeing QA and UAT processes, management of 10+ permanent and contract resources, work planning, recruitment, estimation, processes enhancement.  The role was also quite hands-on.   I worked on number of OLTP and OLAP data warehouse databases, large SSIS package frameworks, SSAS cubes and SSRS reporting solutions.

Major achievements:

Markets data-warehouse database

        Designed and implemented number of new data marts, SSIS packages and SSAS cubes to the existing solution following the existing framework (TIBCO messages), managed team of 4 developers and a full development cycle from including test, uat and release

        Managed team of 4 developers

        Implemented partitioning and aggregations to improve performance

Licensing application

        Modelled data, implemented database architecture and database development.  I was involved on all stages of the project from inception to go live, including all QA and UAT cycles.

RHI project (http://www.ofgem.gov.uk/E-SERVE/RHI/Pages/RHI.aspx)

        Modelled data, database architecture, lead database team development from start to finish (with 5-10 resources) for two phases, managed number of QAs and UATs with total of about 15 resources, database was designed with a vision of SOA in mind.

Networks project, RO/FIT change project

        Data modelling, design of data store, technical team lead, QA/UAT, release management, management of 5 resources.

Datawarehouse POCs

Build and presented number of datawarehouse solutions to the business in order to raise their awareness and buy-in into the big project.

Eurostop Limited, London UK

One of the largest retail software providers in the United Kingdome and overseas (EU, China, Singapore)

May 2007 – October 2010                 Senior Applications Developer

Database Developer and Administrator

My duties included providing third line support of our client databases (about 30% of the time) and third party integrations and application/database development (about 70% of the time).  The third party integrations included client-facing project managing and work with third parties, advising on the business processes, ensuring the project is completed within defined timescale and to the best satisfaction.  My responsibilities include architect and enhance our existing systems, implement best practices; provide third line support, investigate performance issues, implement backup&recovery policy etc.  Having big experience in the database design I am responsible for database design/architecture, writing stored procedures, triggers, functions, writing CLRs, Web Services and clients, maintain existing DTS/SSIS packages, maintain and develop SSAS Cubes, advice on backup&recovery and security, writing Excel spreadsheet loaders using VB, applications in NET.C#.  Mentor other team members, work with third party providers, internal and external training is also part of my job.  The company is Microsoft oriented using, MS SQL Database, MS SQL Visual Studio and Visual Source Safe to develop and control versions of the product.

Major achievements:

·         Numerous ETL integrations to other products like wholesale applications (SAP, STYLEman, ILevel), financial systems (SAP, SAGE), concession stores (Selfridges, Harrods, House of Fraser, Boundary Mills, etc.) and e-commerce solutions, using file exchange, sql link databases, web services, CLR, XML, C#, Excel spread sheet loadrs and dumps using VB.

·         Designed and implemented new real time data exchange architecture based on WCF/WebServices/XML/XQuery/CLR/C#.

·         Server consolidation projects, Amazon virtual servers technology, some other virtuanlisation technologies

·         Upgrade of large clients to current server/application version inclusive of interface and infrastrunctre upgrade

·         Optimisation of existing code; consulting over performance issues; responsible for maintenance and production release of some in-house applications 

·         Implemented version of real time data exchange using SQL Server Service Broker/Replication solution.

  OTP Bank (Ukraine branch of the OTP Bank Hungary), Kiev 

One of the largest banks in Ukraine (in the top 10 list)  and the largest foreign bank.  It was sold to the OTP group by Raiffeisen Group (Austria) in 2006.

February2003 – April 2007              Starting from Junior Engineer to

                                                                Deputy Head of the Payment Application Maintenance Department,

                                                                Head of the Database Servers Maintenance Sector

I had a very dynamic career grows in the bank.  The responsibilities included administer SQL servers, support of in-house financial systems and MIDAS core financial system, administer OS/400, supporting production & development environments, maintanance plans, backup and recovery. After been promoted to the department deputy manager I became responsible for the department management, 7 people.

Major achievements:

·         Developed and deployed the Replication Solution based on the Transaction Replication into the production environment that allowed to off-load reports from the main server.

·         Developed performance analysis system and critical alerts messaging system over Email and SMS

·         Supervised upgrade to SQL Server version 2005, other SPs rollup, implemented AWE

·         Supervised development of Security Standard for SQL servers documentation by external auditors

·         Participated in building SQL server cluster solution based on SAN technology.

·         Deployed log shipping solution and support scripts into main production SQL server environment

The International Institute of Social Development, Kiev

September 2002 - May 2004            System/Network Administrator + Sites Developer (work combined with education)

1 year experience in Data lake projects on EMR using Scala, Spark, Bash scripts and Java, parquet files, Zeppelin

1 year experience with Tableau

13+ years experience in Microsoft SQL Server 2000/2005/2008/R2/2012/2014/2016 production database

        architecture/development/administering 

Mission critical 24/7, heavy load databases 100Gb+, 4000 user connections, carried out upgrade process, setup logshipping, replication, security, performance troubleshooting, backup&recovery, maintanance plans, possess extensive knowledge of T-SQL, heterogeneous distributed systems, CLR, XML/XQuery, Service Broker, SOAP; DTS/SSIS, SSAS multidimensional and tabular;  SSRS, PowerPivot, PowerView, MDX/DAX

2+ years experience in data modelling as per the SOA concepts, web services, Enterprise Architecture, Entity Framework

5+ years experience of team management, project management, recruitment, estimation  

2+ years experience in .Net development, C#, OOD, WCF, Pascal, VB, C++

5+ years experience of maintaining network, servers FreeBSD, Linux, webservices Apache, firewall ipfw, ipf, NAT,

        SAMBA, routing, bash, perl, php, MySQL, InnoDB, AD, IIS, hardware and software for NAS/SAN, HTML, RSS

3+ years experience OS/400 and DB2/400 systems administering, CL/400, IBM WebSphere MQ and MIDAS international financial system

English, Ukrainian (Native), Russian (Native)

MSc in Computer Science, University of Oxford, In progress, May 2018.

MSc in Computer Science, February 2004

BA in Computer Science, July 2003

National technical university of Ukraine "KPI", Kiev