Summary
Overview
Work History
Education
Skills
Timeline
Generic

Michael Shumilov

Monroe Township,NJ

Summary

Accomplished Senior Software Developer with extensive expertise at UL Solutions, specializing in T-SQL and SQL Server. Demonstrated success in designing robust ETL solutions and enhancing database performance. Skilled in collaborating with cross-functional teams, exhibiting strong leadership and problem-solving abilities to achieve successful project outcomes.

Overview

28
28
years of professional experience

Work History

Senior Software Developer

UL Solutions
Princeton
02.2016 - 05.2025
  • Participated in multiple major projects including Upgrade Reporting Solution, Upgrade User Group Management System, Platform Stabilization and Data Cleaning. Created multiple new and upgraded existing SSIS packages to import user feed and export data to customers in multiple formats. Monitored and maintained SSIS packages/SQL Agent jobs. Involved in numerous major semiannual Service Pack releases for ComplianceWire Electronic Learn Management System (ELMS). Developed The Right to Forget and General Data Protection Regulation (GDPR) to meet the FDA CFR and European Union requirements. Worked closely with Enterprise Architects and DBAs to achieve maximum horizontal database scalability including DB sharding and table partitioning. Participated in analyzing, mapping and merging data systems after UL had acquired Learnshare and EHS Sustainability. Complete multiple database performance tuning projects.
  • Developed and maintained data models for reporting and analysis.
  • Designed and developed ETL/BI solutions using BCP and SSIS.
  • Collaborated with cross-functional teams to gather requirements and ensure BI solutions meet business needs.
  • Designed and implemented the physical and logical structure of databases based on product requirements and application needs.
  • Created and managed database objects such as tables, views, indexes, stored procedures, sql agent jobs, etc.
  • Troubleshooting and resolving issues reported by QA.
  • Extensively worked on stored procedures performance tuning.
  • Performed T-SQL code reviews for other developers.
  • Designed and developed multiple reports using SSRS based on business requirements.
  • Created and maintained number of SSIS packages to import/export clients’ data.

Senior BIDS/SQL Developer

Birch Family Services, Inc.
New York, NY
01.2012 - 02.2016
  • Designed and developed multiple databases for internal applications and reporting system. Developed the SSIS package to provide XML data feed to Relias Learning. Using SSIS developed and deployed a transaction set parser to handle the EDI X12 835 file (Health Care Claim Payment and Remittance Advice) and EDI X12 837 file (Health Care Claim). Developed and deployed the SSIS solution to automatically create, encrypt with public key and upload the EDI X12 834 (Benefit Enrollment and Maintenance) file to medical insurance company (Guardian). Designed, developed and deployed the ETL package to create and upload Multiple Services Fixed File Format employment and salary verification to Equifax Workforce Solutions. Using SSRS developed, published and managed security of several data-driven reports from internal and external databases such as Kronos and Blackbaud.
  • Developed numerous SSIS solutions for integrating data from multiple disparate sources into a master database.
  • Planned and implemented Vertical and Horizontal database partitioning.
  • Developed SSIS packages for distributing data in multiple formats including file encryption.
  • Administered all SQL servers and database utilizing MS SQL servers 2008 / 2012.
  • Created, scheduled and managed a SQL Server Agent jobs in T-SQL and SSMS.
  • Analyzed and optimized SSIS and SSRS solutions’ performance and scalability.
  • Performed unit testing of all SSIS packages, SSRS Reports and T-SQL scripts.
  • Created a variety of ad-hoc and standard reports including parameterized, drill down, drill through, and sub reports using SSRS 2008 / 2012. Managed report security and subscriptions.
  • Communicated with the end users on requirements gathering.
  • Led project team members. Mentor and train junior team members.
  • Used reverse engineering to analyze business logic and performance issues of old applications.
  • Involved in weekly meetings to track the progress of work and to reach the milestones.

Senior BI/SQL Developer

United Nations
New York, NY
06.2010 - 12.2011
  • Developed multiple SSIS projects for Office of Program, Planning, Budget and Accounts (OPPBA). Designed and developed SSIS solution to extract, transform and load data from Sybase servers located at UN offices around the globe into a master database (MS SQL Server 2008). Developed a web-based tool to compare and identify structural differences between databases in different SQL Server environments. Redesigned structure of database objects to speedup report processing. Converted multiple databases from SQL Server 2000 to SQL Server 2005 and SQL Server 2008.
  • Created numerous reports utilizing SSRS 2005 and 2008 environment.
  • Converted numerous of existing DTS packages to new SSIS platform.
  • Implemented numerous system enhancements.
  • Optimized system for performance and scalability.
  • Implemented Increased Degree of Parallelism in SSIS packages.

SQL/Web Developer

ProcureStaff, Ltd.
New York, NY
01.2002 - 04.2010
  • Participated in development, enhancement and re-design of existing human resource procurement and time keeping web applications for Eli Lilly and Company, Medtronic, AT&T and MassMutual Financial Group to improve performance, scalability and introduce new features.
  • Created SSIS packages to automate the Import and Export of data to and from SQL Server 2005.
  • Developed integration components to exchange data between external and internal systems.
  • Performed query optimization for efficient execution.
  • Created and scheduled jobs to run the SSIS packages.
  • Created numerous SSRS reports.

Programmer/Analyst

LIQUID2REALITY, Inc.
New York, NY
01.2000 - 12.2001
  • Developed the e-commerce website www.jemznjewels.com. Created mail client for www.westburypartners.com using DHTML and ASP as programming languages. Developed a web-based Bulletin Board System (BBS) for “FIRST NEW YORK SECURITIES” which allows employees to post new and browse the archived messages. Created and implemented ActiveX DLL (VB 6.0) to enable check spelling of internal company’s words and expressions.
  • Extensively used VB 6.0 in multiple windows applications and VB and Java scripts in web-based applications.
  • Extensively used T-SQL to create variety of SQL Server objects such as stored procedures, tables, triggers, indexes, user-defined functions, etc.
  • Utilized several API functions to meet application needs

Programmer/Analyst

BIS Geek International
Brooklyn, NY
01.1999 - 12.1999
  • Designed, developed and implemented a General Ordering and Inventory System application for Newport Textile Company, Inc. Participated in the design and development of web portal for SPEEDUS.COM. Participated in the design and development of a security and personalization system that allows programmatically modify user access to the site.
  • Developed stored procedures, tables, views, triggers and indexes.
  • Performed data analysis and database normalization.
  • Developed reports using Crystal Reports

Programmer/Analyst

EPL Software Corp.
New York, NY
11.1997 - 01.1999
  • Designed and developed a patient tracking application and web site for “Illiria Medical Center”.
  • Created database, web page and reports.

Programmer/Analyst

Visual Realities Consulting Group
Brooklyn, NY
01.1997 - 11.1997
  • Created a CD-ROM based “Sea Ports Directory” for people who want to go sailing. The program contains searchable information about Seaports of the United States. Program allows searching destinations by name, keywords or regions.
  • Provided VB coding and testing.

Education

Advanced Courses - Computer Programming

American Training Center, Inc.
Forest Hills, NY
01.1997

Bachelor's degree - Mechanics and Mathematics, Minor Computer Sciences

Tashkent State University
Tashkent, Uzbekistan
03.1989

Skills

  • T-SQL and SQL Server
  • C# and VBNet
  • HTML, CSS, and JavaScript
  • XML and API integration
  • PostgreSQL database management
  • Business intelligence tools
  • SSRS and SSIS reporting
  • Data transformation services
  • ADO and ODBC connectivity
  • Version control with GitHub
  • Agile methodologies including Scrum
  • NET Framework development
  • PowerShell scripting
  • Crystal Reports generation

Timeline

Senior Software Developer

UL Solutions
02.2016 - 05.2025

Senior BIDS/SQL Developer

Birch Family Services, Inc.
01.2012 - 02.2016

Senior BI/SQL Developer

United Nations
06.2010 - 12.2011

SQL/Web Developer

ProcureStaff, Ltd.
01.2002 - 04.2010

Programmer/Analyst

LIQUID2REALITY, Inc.
01.2000 - 12.2001

Programmer/Analyst

BIS Geek International
01.1999 - 12.1999

Programmer/Analyst

EPL Software Corp.
11.1997 - 01.1999

Programmer/Analyst

Visual Realities Consulting Group
01.1997 - 11.1997

Advanced Courses - Computer Programming

American Training Center, Inc.

Bachelor's degree - Mechanics and Mathematics, Minor Computer Sciences

Tashkent State University

Similar Profiles

CREATE PROFILE