Sql Server Engineer

Michael Fomin

DBA and Data Engineer/Developer

Seminole, FL 33776 (Tampa / St. Petersburg / Clearwater) 727-***-****

**********@*******.*** Linked-In: http://www.linkedin.com/in/fominmichael/

Master’s Degree in Computers Science US Citizen

Professional Profile

Seasoned all around professional with solid experience in Microsoft SQL Server administration (4.21A – 2016), 24x7 support, Backup / Restore, SQL Server Maintenance, Database Maintenance, High Availability and Disaster Data Recovery planning, Troubleshooting and Performance Tuning. Besides that has profound practice in design, implementation of high performance scalable and robust data centric solutions using full stack of Microsoft SQL Server technologies: OLTP, Data Integration/SSIS, MDM, and Microsoft BI Stack: SSIS, SSAS, Power BI, SSRS using On-Premises, Azure and SQL Azure platforms. In addition has practice working with Oracle, MySQL, Big Data/Large datasets, NoSQL, Hadoop, and Apache Hive. An expert in Relational and Multidimensional databases design and implementation. Moreover has a very good experience using .NET/C# especially for Backend development, data integration and interexchange.

Education: Moscow Power Engineering Institute (Technical University), Moscow, Russian Federation

Master’s Degree in Computers Science

http://www.mpei.ru/StartPage.asp?Lang=eng

Certifications / Additional Education:

Profisee Group. Inc.

A training for Microsoft Master Data Management (MDM) services and Profisee Master Data Maestro.

Microsoft authorized education and certification center “Stars & S”, Moscow, Russia

Microsoft Windows 2000 administration, Certificates of achievements.

Industry Background: Financial services, Banking; Commerce, e-Commerce; Marketng; Media services; Law, legal information, government; Insurance services (Health, Auto, Workers Compensation, Property and Casualty); Telecommunications; Trading; Construction; Car manufacturing; Healthcare Data; Medical Device Manufacturing; Manufacturing light industry; Enterprise Networking.

Experience

November 2017 – January 2018

DBA / Senior BI engineer – AMERILIFE GROUP, LLC, Clearwater, FL

Scope: Providing a service to AmeriLife Group, LLC as senior BI engineer / DBA - Consultant, and a member of Business Intelligence team. The reason for leaving – all projects successfully implemented, contract ended.

Platform & Skills: MS SQL Server 2016, 2014, 2012, 2008R2/2008, SSIS 2014, Visual Studio 2015, SSDT, PowerPivot for MS Excel, TFS. AGILE, SCRUM

Role:

-Reconfigured and rebuilt Visual Studio project environments and SQL Server Database, Integration Services Catalogues and Analysis Services development environments for next initiatives.

-Performed SQL Server performance troubleshooting using system stored procedures and Dynamic Management Views (DMV).

-Engineered and implemented a minor project to filter out unwanted data inside SSIS pipeline as an easy to support scalable solution.

April 2016 – November 2017

DBA / Senior Data engineer / Architect – ATLAS GENERAL INSURANCE SERVICES, San Diego, CA

Scope: Providing a service to Atlas General Insurance Services (Insurance Broker, WC and Commercial P&C) as a Full Time employee - telecommute, a member of Data Analytics Department in Agile/Scrum environment. Built and administrated SQL Servers and was responsible for design and implement data processing and transformation services to make information available for business for simple and in-deep analysis. The reason for leaving – lay off.

Platform & Skills: MS SQL Server 2016, 2014, 2012, 2008R2 / 2008, SSIS 2016, 2014, Visual Studio 2015, SSDT, MySQL, GitKraken. OLTP, Data Integration, Operational Data Store (ODS), Data Warehouse (OLAP, SSAS), Microsoft Azure and Power BI.

Role:

-MS SQL Server installation (2014-2016) and migration from earlier versions, configuration and administration for Data Analytical department including Production, Test (QA) and Development environments.

-SQL Server advanced coding standards and SSIS templates design, instituting and putting into practice.

-Data and servers landscaping analysis and planning for enhancements.

-Project implementation ownership at all development stages from requirement gathering and analysis to final reporting, Post-production project ownership and support;

-Leadership in Data Architecture (Databases and Processes) design and implementation for owned projects and for other teams.

August 2015 – February 2016

SQL Server DBA / Sr. Database Engineer- Verizon Data Services, Tampa, FL

Scope: Served as Sr. Database Engineer / SQL Server Database Administrator - Consultant for Verizon Data Services, Credit and Collections department. The reason for leaving – all projects successfully implemented, contract ended.

Platform & Skills: MS SQL Server 2012, MS Windows Server 2005, active-active cluster, MS SQL Server Management Studio, SQL Profiler, T-SQL, MS Visual Studio 2013 and 2012. SSIS 2005, 2008R2, 2014. AGILE, SCRUM.

Role:

- Analyzed code for safe PROD, QA and DEV environments migration from SQL Server 2005 to SQL Server 2012.

- Successfully performed MS SQL Server environment (Production, UAT and Development) migrations from 2005 to 2012 platform.

- Owned performance improvement project, re-architected and reengineered existing solution to improve the overall performance of Data acquisition and processing jobs in four times to meet the goal.

- Assisted application developers via database activity tracing.

- Helped other database developers with choosing right approach to solve problems, design data architecture for them.

- Shared my knowledge and expertise in SQL Server technologies, SQL Server internals and best practices with a team.

October 2011 – June 2015

Systems Architect - PCM, Inc. (Commerce, ecommerce), El Segundo, CA

Scope: Worked full time for PCM, Inc. (formerly PC Mall, one of the top IT hardware and services retailers in US) as Systems Analysts / Architect and Team Lead. Led the company in Enterprise Database (ED), Enterprise Data Warehouse (EDW), Enterprise Service Bus (ESB, Data Hub), Data as a Service (DaaS) and Software as a Service (SaaS) initiatives, including formal leadership, systems analysis, design and team and hands on implementation. Focusing on end-to-end data processing (full information/data life cycle), an integration of internal and external systems, data cleansing (DQS), master data management (MDM), data interexchange and replication and Analysis/Reporting systems (Data Warehouse: Inmon / Kimball). The reason for leaving – lay off (the position was shipped overseas). Built and provided full DBA support for email marketing system.

Platform & Skills: Hub-and-Spoke architecture, Enterprise Service Bus (ESB) concept. MS SQL Server 2012, MS SQL Server 2008 R2, T-SQL, MS Visual Studio 2012/2010/2008, TFS, MS Visio, SQL Server Profiler, Database and Data Warehouse Design, Implementation and reporting, Tracing, Debugging and Performance Tuning, DDL, DML, DCL, TCL, SSIS, SSAS, SSRS. WCF, C#, SOAP and REST Web Services, UML, HTTPS, XML. SDLC, Agile, Scrum, Waterfall.

October 2010 – June 2011

Lead Data Engineer / Architect – CareFusion, San Diego, CA

Scope: Worked for CareFusion as Lead Data and BI engineer/Architect – Consultant. Played Solution Architect role in “Med” globalization project. Designed an architecture and led the implementation of the project for all parts: the database, the data warehouse and ETL. Implemented changes to database and data warehouse schemas, code, SSIS packages, and SSRS based (including C# and VB.NET script components) and SSRS and ASP.NET/C# based reports. The reason for leaving – a project successfully implemented, contract ended.

Platform & Skills: MS SQL Server 2008, T-SQL, MS Visual Studio 2010 and 2008, TFS, ER Studio, SQL Server Profiler, Database and Data Warehouse Design, Implementation and reporting, Tracing, Debugging and Performance Tuning, DDL, DML, DCL, TCL, SSIS, SSAS, SSRS. SDLC, Agile, Scrum.

June 2009 – August 2010

DBA / Lead MS SQL Server Database and Data Warehouse engineer – ICW Group, San Diego, CA

Scope: Served as full time employee for ICW Group as Senior MS SQL Server Database / Data Warehouse engineer / analysts / DBA. Supported Enterprise Information Services (EIS) department as SQL Server technology lead. Led or participated in number of projects. Created, optimized or reengineered solution based on modern technologies and best practices. The reason for leaving – lay off.

Platform & Skills: MS SQL Server 2008/2005/2000, T-SQL, MS Visual Studio 2008/2005, SVN, ER Studio, SQL Server Profiler, Database and Data Marts Design, Implementation and reporting, Tracing, Debugging and Performance Tuning, DDL, DML, DCL, TCL; XML Message queuing and processing. Production, Staging, QA, INT and Development environments. SDLC, Waterfall, Agile, Scrum, Matrix.

February 2007 – April 2009

Senior Database Engineer / Lead / Architect / DBA – JPMorgan Chase & Co., Tampa, FL

Scope: Participated as a consultant in number of successful projects combined into a new generation of Chase Education Finance (CEF) enterprise loan application processing system. Functional and technical design based on requirements, reverse and forward engineering, T-SQL DDL and DML code implementation, SSIS packages design and implementation for data migration and data integration, operational reports design and implementation using SSRS; Mainframe to SQL Server integration via BizTalk, SQL Server development environment administration (DBA), tracing and performance tuning; Resource Planning. The reason for leaving – all projects successfully implemented, contract ended.

Platform & Skills: MS SQL Server 2005 (32 and 64 Bits) / 2000, T-SQL, DDL, DML, DCL, TCL, SSIS, DTS, DTEXAC, DTEXACUI, SQLCMD, SSRS, Notification Services, SQL Server Profiler, Database Tracing, Debugging and Performance Tuning, DML, DDL, Data Warehouse, RedGate SQL Toolbelt, BizTalk Server, .NET Framework 2.0, C#, ADO.NET 2.0, SOAP, MS Visio 2003, MS Visual Studio 2005, MS Visual SourceSafe, PVCS, IMB Mainframe COBOL, HP Quality Center, N-UNIT. SDLC, Waterfall, Agile, Scrum, Matrix.

May 2003 – January 2007

Consultant – Global Consulting Group, Ltd., Boston, MA and vary client sites

Worked full time as a Senior Software and Data Engineer / Architect / DBA for a number of the clients of employer: Agile Communication Group (Startup), Tampa, FL; Nielsen Media Research, Oldsmar, FL; NexTrade Holdings, Inc., Clearwater, FL; eMASON, Inc., Clearwater, FL; Verizon, Tampa, FL; JPMorgan Chase & Co., Columbus, OH; Verizon, Irving, TX; General Motors (GM) / IBM, Warren, MI.

Skills Summary

Methodology: Entity, Logical and Physical Relational Modelling and Dimensional Data Modeling; Object-relational mapping (ORM); Reverse and Forward Engineering; System Integration, Data Lineage, Data Integration, Data Transformation, Kimball and Inmon Data Warehouse architecture, Monolithic / Federation / Hub-and-spoke EDW, Bus matrix, Conformed dimension; WEB applications, Services Oriented Architecture (SOA), Enterprise Service Bus (ESB), Client-Server, n-Tier architecture, Microsoft Solution Framework (MSF), UML, Design Patterns, Coding standards.

Databases, Data Warehouses, ETL and BI:

MS SQL Server 2016/2014/2012/2008R2/2008/2005/2000/7.0/6.5/6.0/4.21A;

24x7 support; Backup / Restore; SQL Server Maintenance; Database Maintenance; High Availability and Disaster Data Recovery; Dynamic Management Views (DMV) and system stored procedures.

Transact-SQL (T-SQL), DDL, DML, DCL (Data Control Language), TCL (Transaction Control Language), OSQL, SQLCMD; SQL Server Agent, SQL Job; Database Backup, Restoration, Log Shipping, Snapshot; Disaster Recovery Planning; Troubleshooting; Performance Tuning; SQL Server Profiler, Performance Monitor.

SQL Server on premises, SQL Azure.

Analysis Services (SSAS) for MS SQL Server 2005-2016, MS OLAP, BI, MDX, DSO; Power BI, Reporting Services (SSRS, RDL); PowerPivot for MS Excel; Crystal Reports; Tableau.

Data Acquisition, Data Integration via MS SQL Server Integration Services (SSIS, DTEXEC, DTEXECUI) and Master Data Management (MDM: MDS, DQS).

Notification Services (SSNS, SSB, SQL Service Broker);

Oracle, MySQL, MS Access, IBM DB2. RedGate SQL Toolbelt, TOAD for Oracle Suite.

Data Modelling Tools: ER Studio, CA Erwin, MS Visio.

.NET Technologies: .NET Framework 1.0 – 4.5; ASP.NET, ADO.NET, SOAP/WSDL and REST/WADL Web Services, WCF, Multilingual User Interface.

Additional Programming Languages: C#, C++, Visual C++ / VC++ (Windows API, MFC, OLE DB, ODBC, DB Library), VBA, PL/SQL, SQL, XML.

Development Tools: MS Visual Studio 6.0 - 2015, MS SQL Server Management Studio, Business Intelligence Development Studio;

P.M. and Collaboration Tools: Team Foundation Server (TFS), MS Project, MS Outlook, MS Exchange, Lotus Notes.

Version control systems: TFS, GitKraken, MS Visual Source Safe, Vault SourceGear version control system, PVCS, SVN.

Contact this candidate