Address: Roselle, IL *****

Phone: 1-630-***-****

e-Mail: adyai2@r.postjobfree.com

Web site: www.linkedin.com/in/igormikhalyev

Igor Mikhalyev

OBJECTIVE: Data Warehouse / Data Integration / ETL / Reporting

QUALIFICATIONS:

More than 20 years of experience in wide areas of data integration

Database & data architecture, integration, conversion, design and development

Data analysis, modeling, data warehousing

Experience with full life cycle of software development for complex enterprise projects

Agile and Waterfall experience

Strong problem solving skills

Excellent communication and interpersonal skills

Well-organized, self-motivated, detail-oriented

Highly competent in requirements, architecture, design, coding, code review, testing, documentation

Experience with object oriented analysis and design practices

Effective team leader

SKILLS:

SQL, T-SQL, PL/SQL,

SSIS, SSRS, SSAS, ETL, Talend

Performance Tuning

Database Administration

Tableau

Azure, AWS, Web Services

JIRA, Confluence, Bitbucket, SourceTree, Slack, Git, TFS

C#, ASP.Net, NUnit, Linq, WinForm, WebForm

Salesforce, APEX

Python

DATABASES: Azure, MS SQL Server 2005-2019, Oracle, Sybase, Access, MySQL, PostgreSQL

EDUCATION:

M.S. degree at MOSCOW INSTITUTE OF PHYSICS & TECHNOLOGY, Moscow, Russia

EXPERIENCE:

October 2019 - Present

Nitel

Senior BI Developer

Project: Data migration from legacy systems to Salesforce, Data Warehouse and Reporting

Description: Development of databases and ETL process to migrate data from legacy systems to Salesforce. Data integration into Data Warehouse and Reporting system.

Responsibilities: Designing and implementing database tables, stored procedures, SSIS packages, SSRS and Tableau reports.

Skills: SQL/T-SQL, Stored Procedures, Functions, SSIS, SSRS, Tableau, C#, Salesforce, APEX, JIRA, Python

Database: Asure, MS SQL Server 2016, PostgreSQL

November 2018 – October 2019

Tribune Media / Nexstar Media Group

BI Engineer – Data Warehouse/ETL

Project: Enterprise Data Warehouse + SSAS Cubes

Description: Development of data warehouse and SSAS Cubes using WorkDay data feed.

Responsibilities: Designing and implementing database tables, views, stored procedures and SSIS packages. Databases performance tuning. SSAS cube rebuild tuning. Tableau development and administration.

Skills: SQL/T-SQL, Stored Procedures, Functions, Triggers, SSAS, SSIS, C#, Tableau, PowerShell, Python

Database: MS SQL Server 2014-2016

Project: Digital Universe web site's back-end (http://digitaluniverse.tribunemedia.com)

Description: ETL/Database and web site to store and display Google Analytic data about radio and TV web sites usage.

Responsibilities: Databases performance tuning. Fixing dead-locks. Fixing stored procedures calls from Azure services. Azure runbooks. Designing and implementing database tables, views, stored procedures.

Skills: Azure SQL, Stored Procedures, Functions, Azure services, runbooks and alerts, C#, PowerShell scripts

Database: Azure

March 2018 – November 2018

LGIMA

PMO Developer

Project: LGIMA Datamart

Description: Architecture, design and development of LGIMA datamart. Tableau dashboard desing and development.

Responsibilities: Data requirements analysis. Designing and implementing database tables, views, stored procedures and SSIS packages. Databases performance tuning.

Skills: SQL/T-SQL, Stored Procedures, Functions, Triggers, SSIS, C#, ETL, UC-4, Tableau, Python

Database: MS SQL Server 2012

Project: DOL 5500 Form Search utility

Description: Downloading DOL 5500 forms in different formats. Developing utility to search data using user friendly interface.

Responsibilities: Data requirements analysis. Designing and implementing database tables, views, stored procedures and SSIS packages. WinForm application development.

Skills: SQL/T-SQL, Stored Procedures, Functions, Triggers, SSIS, C#, ETL, UC-4

Database: MS SQL Server 2012

December 2016 – March 2018

Nuveen Investments

Sr. Application Developer

Project: Compliance Data Feed System

Description: Developing, testing and supporting the ETL system for compliance department. Loading, transforming and extracting data for several data feeds. Integration with existing systems.

Responsibilities: Data requirements analysis. Designing and implementing database tables, views, stored procedures and SSIS packages. Databases performance tuning.

Skills: SQL/T-SQL, Stored Procedures, Functions, Triggers, SSIS, SSRS, SharePoint, C#, ASP.Net, ETL, TWS, MOVEit

Database: MS SQL Server 2014

March 2015 – December 2016

SPX

Database Developer

Project: GFI Network Manager / Data System

Description: Developing and supporting the back-end for transportation agencies data system. Data transfer and processing from fare boxes to central database, to web site in the cloud and back.

Responsibilities: Data requirements analysis. Designing and implementing database tables, views and stored procedures. Databases maintenance, support, administration, troubleshooting and performance tuning. Mentoring developers to use best practice in database development and data access. Unit testing.

Skills: SQL/T-SQL, Stored Procedures, Functions, Triggers, SSIS, ETL, Talend, JIRA, Confluence, Slack

Database: MS SQL Server 2005-2012, Sybase, Oracle, MySQL

November 2009 – February 2015

303 Capital Partners, LLC

Senior Software Engineer

Project: 303 Reports

Description: Report utility for risk management, compliance and accounting. It collects data from different sources (banks, clearing firms, trading platforms, etc.), processes and transforms the data into unified structures, provides more than 100 reports and data feeds for customers. The logic of the utility is mostly data driven - to add, change or delete a report only the database data needed to be changed..

Responsibilities: Data requirements analysis and discussions with users and developers. Designing and implementing database tables, views and stored procedure to support applications development. Databases maintenance, support, administration, troubleshooting and performance tuning. Mentoring developers to use best practice in database development and data access. Unit testing.

Skills: SQL/T-SQL, Stored Procedures, Functions, Triggers, SSIS, SSAS, ETL, WikiMedia, C#, Linq

Database: MS SQL Server 2005-2008

June 2009 – November 2009

AMLI Residential

Consultant

Projects: Green Dashboard web site.

Description: Databases for web application to report quantitative data about properties green performance.

Responsibilities: Designing and implementing database to support applications development. Databases maintenance, support, troubleshooting and performance tuning.

Skills: SQL/T-SQL, PL/SQL, Stored Procedures, Functions, Packages, Triggers, SSIS, SSAS

Database: MS SQL Server 2005-2008, Oracle 9.x

February 2008 – December 2008

Arroweye Solutions, Inc.

Sr. Software Engineer

Projects: Gift card activation system.

Description: Database for gift card activation system.

Responsibilities: Designing and implementing database to support applications development. Databases troubleshooting and performance tuning. B2B data exchange. Redesigning the database access methods and procedures. Teaching developers to use the best database access standards.

Skills: SQL/T-SQL, Stored Procedures, Replication, SSIS, ETL, C#, Wiki

Database: MS SQL Server 2005

March 1998 – February 2008

Distributed Software Development, Inc.

Software Engineer

Project: Voter Registration System

Description: Database for Voter Registration System.

Responsibilities: Team leader. Data requirements analysis and discussions with customers and developers. Designing and implementing database tables, views and stored procedure to support applications development. Databases maintenance, support, troubleshooting and performance tuning.

Skills: SQL/T-SQL, Stored procedures, Triggers, DTS, ETL, UML, Delphi

Database: MS SQL Server 2000

Project: Zaks Invest web site (www.zaksinvest.com)

Description: Database for web site.

Responsibilities: Data requirements analysis. Designing and implementing database tables to support applications development. Databases troubleshooting and performance tuning.

Skills: SQL, ETL, UML, PHP

Database: MySQL

Project: 311 Reports (www.311Reports.com)

Description: Database for 311 report web site.

Responsibilities: Data requirements analysis. Designing and implementing database tables and views.

Skills: SQL, UML

Database: Access

Project: Policy Copy Utility

Description: Databases for Policy Copy Utility

Responsibilities: Team leader. Data requirements analysis. Designing and implementing database tables and views. Teaching developers to use the best database access standards. Using reverse engineering to get initial data requirements.

Skills: SQL, JSP

Database: DB2 OS/390, Access

Project: Web Based Field Reporting System

Description: Database for Web Based Field Reporting System

Responsibilities: Documentation, architecture, design, development, testing, performance tuning and installation. Code review.

Skills: SQL/T-SQL, Stored procedures, DTS, ASP

Database: MS SQL Server 7.0/2000

Project: Message Switch Interface

Description: Message Switch Interface is used by Computer Aided Dispatch (CAD) and the interface to National Crime Information Center (NCIC) products to communicate with various vendor’s message switches. It also provides the ability for Mobile Data Terminals to communicate with CAD and to interface with the Records Management System (RMS) or CAD databases.

Responsibilities: Documentation, architecture, design, development, testing, performance tuning, installation and production support.

Skills: SQL/T-SQL, Stored procedures, Triggers, Delphi

Database: MS SQL Server 7.0

Project: Database for billing and customer care system for paging companies

Responsibilities: Documentation, architecture, design, development, testing, performance tuning.

Skills: SQL, PL/SQL, Stored procedures, Triggers, Packages, VB, C++

Database: Oracle

May 1992 - March 1998

Odessa Science & Research Communication Institute, Odessa, Ukraine

Software Engineer

Projects: Database for information and search system for communication devices; Warehouse inventory.

Responsibilities: Team leader. Documentation, architecture, design, development, testing, performance tuning, installation and production support.

Skills: SQL

Databases: Interbase, DBF

REFERENCES: Available on request

Contact this candidate