Dmitriy Butakov Email & Phone Number

Moscow, Russian Federation

• Interaction with clients, participation in meetings and presentations, advocating and negotiation of decisions;• Requirements analysis and translation into technical and architectural approaches;• Participation in resources management and project planning, assessment of costs and timelines;• Creation of technical documentation and presentations;• Data modeling, database design, integration and ETL/ELT architecture, scalability and performance design;• Full cycle support of solution development, consulting and supervising team members;• Team members interview and hiring, coaching, knowledge sharing, motivation and performance review meetings.Projects:• Basel II and Risk Weighted Asset approach implementation (Teradata, SAS Data integration Studio, SAS Credit Scoring for Banking);• IFRS9 and Expected Credit Loss approach implementation (Teradata, SAS ECL Solution);• Data preparation and ETL development for tax and regulatory reporting migration to Diasoft Flextera BI;• Data Marts development for Anti Fraud and Anti Money Laundering activities (Teradata, Impala);• Analytical infrastructure using Python, R, Spark (Zeppelin, RStudio, Anaconda, Cloudera Data Science Workbench, Docker);• Offloading immutable/mutable DWH`s "cold" data into Hadoop (Cloudera Distribution for Hadoop, Impala, Sqoop).

Moscow, Russian Federation

• Analyzing of business requirements, evaluating of works, implementation planning, assigning of tasks in a team (3-6 pers); • Participating in meetings, discussing of tasks with customers, documentation development, negotiating of results with customers; • Designing of data marts and ETL processes, ETL development, testing and production. Projects: • Data mart development and evolvement to provide Analytical CRM functionality in the bank industry (Teradata, SAS Data Integration Studio, SQL).

Moscow, Russian Federation

• Migrating of EDWH from Oracle to Teradata;• Data model refactoring for OpenWay Way4 source. Implementing of ETL processes for new data model, testing, negotiating with customers;• Bug, bottleneck analyzing and fixing. ETL processes performance tuning using Teradata Process Monitor.Projects: • Data warehouse migration and integration project in the bank industry (Teradata, SAS Data Integration Studio, SQL, SAS Base/Macro, SVN, Erwin Data Modeler, Teradata SQL Assistant).

• Designing and developing of terabyte Data Warehouse to collect and process about 10 million records daily using SQL, PL/SQL;• Designing and developing of ETL processes to provide bulk loading and processing data from text files using PL/SQL, Oracle Java, SQLJ, Apache Commons Net API, Batch/Shell scripting;• Bug fixing, defects analyzing, database and application performance tuning using PL/SQL profiler, explain plan, TKPROF, OEM, AWR, ADDM;• Oracle 9i, 10g Administration on Linux OS. Oracle 9i to 10g migration;

• Designing and developing of web forms and PL/SQL program units for company`s internal services using C#, SQL, PL/SQL;• Designing and developing of a web application for automatic generation of documents for company's clients using Crystal Reports .NET;• Environments: Oracle 9i, PL/SQL Developer, ASP.NET, Microsoft Visual Studio, Crystal Reports .NET framework, Microsoft Internet Information Server.

• Developing of a device for remote temperature monitoring of an exchange system using Assembler, GUI and RS232 C++ programming;• Environments: MS Windows 2003 server, Atmel microcontroller, DS1820 sensors, Borland C++.