Michael Cuccia Email & Phone Number

Needham, MA, US

Senior Manager, Data Engineering responsible for managing projects to deliver data through ingestion pipelines for Direct to Consumer data for our Analytics team to consume for reporting.

Denver, CO, US

• Utilized Microsoft Fabric and Azure Data Factory to create data pipelines using the Medallion architecture to build data pipelines for moving data from on-premises databases to the Bronze lakehouse, pySpark notebooks.
• Leveraged Power BI reports and data models to meet the reporting needs of our supply chain, product, sales shipments, inventory, and logistics users.
• Developed AWS Data Migration Service process for copying on-premises SQL Server, Dickies BI, to Redshift using real time Change Data Capture and daily full load processing. This effort included the use of Git.
• Reengineered data load stored procedures to improve reliability and consistency of data delivery to the Dickies BI SQL data warehouse for Dickies brand data.
• Managed scheduled jobs in the Dickies BI data warehouse using SQL Agent to schedule SQL Agent jobs to load data from the ERP system both daily and multiple times per day.
• Developed enhancements for customer requests to add to or change data model in Dickies BI SQL database for Data Analytics to satisfy the data needs of the Dickies brand for Power BI reporting.

Hanover, MD, US

• Composed SQL scripts and stored procedures using Transact SQL, and Agile Software methodology to manage the Dickies BI data warehouse, storage for Dickies brand data.
• Performance tuned SQL scripts and stored procedures to maximize the efficiency of the SQL code used to query, update, insert, and delete data in the Dickies BI data warehouse.
• Relieved contention on the Dickies BI data warehouse with the implementation of merge logic for the nightly scheduled data loads.
• Created scheduled notification emails to identify blocking, failed jobs, and daily record counts in the Dickies BI data warehouse.
• Trained peer SQL developers in the nuances of how to handle customer support for overnight data load processing.

Hanover, MD, US

• Composed SQL scripts and stored procedures using Transact SQL, and Agile Software methodology to manage the DPAS application.
• Performance tuned SQL scripts and stored procedures to maximize the efficiency of the SQL code used to query, update, insert, and delete data in DPAS.
• Identified and removed all data for FF-GEIT with a mass update to delete flags utilizing the batch SQL update approach. Improved performance from 30 minutes down to 30 seconds for the entire process updating hundreds.
• Created report for FF-GEIT using Transact SQL to identify all manufacturer part number records in the DPAS database which could not be soft deleted (several hundred thousand rows) with detailed data for each to explain.
• Managed table deprecation project through extensive research and creating DevOps work items required to complete transitioning from one schema to another within the DPAS SQL database.
• Trained web developers in SQL techniques along with performance tuning for SQL processes related to their application development.

Tampa, Florida, US

• Performed development and production support duties using SSIS (ETL), SSRS (Report Builder), Transact SQL, and Agile Software methodology to manage the Evoke360 application, including gathering business requirements.
• Designed proof of concept reporting suite for reporting team using Power BI for replacing SSRS reports for the Datalink Software web application.
• Migrated and transformed data from either import files or database to database using SQL Server Integration Services (SSIS).
• Improved performance of reporting module by performance tuning SQL used by SSRS reports
• Fostered maximum teamwork using Agile practices such as scrum, sprints, daily stand ups, planning, refinement, and retrospective meetings on a 2-week cycle.
• Compose Transact SQL to design, build, and implement complex stored procedures, complex SQL select/insert/update/delete scripts, tables, scalar functions, table valued functions, and indexes.

Port Washington, New York, US

• Provided user community with high visibility to our data in both the Liaison (Advantage) and MaxOps (vMOX) applications by deploying a Power BI reporting solution for the company to include data sources from which our.
• Provided world class performance by radically improving speed of all web applications (Liaison, MaxOps, Command Center, and OnePortal) which use SQL Server databases as their transactional databases by tuning the.
• Increased our presence in the international space by implementing a product inventory import to allow end users for our Swiss partner to utilize our Command Center application using Transact SQL importing files of data.
• Fully supported day to day operations of the business providing one day or less resolutions for any and all SQL related and Power BI issues.
• Trained our Development staff of 20+ developers, CTO, and Manager of Software Development in the finer points of SQL performance tuning
• Improved overall performance of all SQL production and development environments by managing project to upgrade SQL Server from 2012 to SQL Server 2019 to take advantage of the enhance performance features included in.

El Segundo, CA, US

• Managed, designed, and built suite of reports using Power BI from concept to full implementation utilizing visualizations including matrix, table, map, combo bar line chart, stacked bar chart, heat map, Top N, and line.
• Create workspaces using Power BI designed to house reports with email notifications utilizing scheduled refreshes. These reports contained data for Daily Operations, Sales, Labor Productivity, and Accounting.
• Built data warehouse using Microsoft SQL Server 2016/2017 to design, build, and implement fully functional dimensional model using Ralph Kimball methodology to develop dimension and fact tables including measures and.
• Designed and built data integration packages using SSIS to refresh data from 3 different database platforms including SQL Server, Progress, and Postgresql into centralized data warehouse housed in a SQL Server database.
• Performance tuned multiple SQL Server databases and associated queries utilizing Index Tuning Advisor, SQL Profiler, creating/modifying indexes where needed, removing cursors to replace with while loops, and.
• Developed Labor Data Load SSIS Package to populate daily labor data from Ultimate software via a reports as a service console application to import the data file and load the data with SSIS utilizing several types of.

El Segundo, CA, US

• Managed, designed, and built suite of reports using Power BI from concept to full implementation utilizing visualizations including matrix, table, map, combo bar line chart, stacked bar chart, heat map, Top N, and line.
• Developed a data warehouse using SQL Server Integration Services and Transact SQL for manufacturing operational and sales data integrating data from multiple platforms including SQL Server and ProFlow databases into a.
• Built reporting suite using Power BI including table, chart, and maps visuals. Use Power BI to merge datasets from multiple platforms into a single report. Reporting suite used to make financial decisions based on.
• Automated daily labor data load from third party vendor using SSIS and SQL Server Agent Scheduler to give executives decision making data based on labor hours and wages. These decisions allow them to run the company.

Bellaire, Texas, US

• Built Operational Data Store database using SQL Server Integration Services and Transact SQL for newspaper subscriber data for our 400 plus newspaper clients across the country.
• Built out Database Server and SQL Server database from scratch for the Subscribers Data Integration project
• Creating reports for an Executive Summary Dashboard using Power BI and Transact SQL to give newspapers and admins a clearer view of Subscriber data.
• Creating reports for an Executive Summary Dashboard using SQL Server Reporting Services and Transact SQL to give newspapers and admins a clearer view of Subscriber data.
• Creating data integration packages using SQL Server Integration Services to perform data loads for the newspaper subscribers from Lee Enterprises, McClatchy Publishing, and the Philadelphia Inquirer.
• Created, modified, and performance-tuned stored procedures, triggers, functions, and ad hoc queries to provide exported data files for Dynamic Pricing Landing Pages specific to each subscriber.

Menlo Park, CA, US

• Performed development and production support duties using SSRS, SSIS, Transact SQL, and Agile Software methodology to manage payment collections for hospitals, including gathering business requirements from end users.
• Performing development and analytics duties using Transact SQL to maintain back end of Collect system to run day to day operations.
• Creating reports using SQL Server Reporting Services to give users and admins a clearer view of the data.
• Maintain and develop Collect system using C#.net, ASP.net, javascript, and MVC to manage day to day operations and gather payments.
• Creating data integration packages using SQL Server Integration Services to perform data loads for the Guarantor Linkage project.
• Creating complex queries and update scripts to perform data cleanup for Guarantor data.

Houston, Texas, US

• Performed development and analytics duties using Transact SQL to maintain back end of Materials Management System to run day to day operations.
• Created CRM web application using Powerbuilder, HTML5, CSS3, and javascript to handle customer requests and issue reporting.
• Enhanced web application using Powerbuilder, HTML5, CSS3, and javascript to maintain front end of Materials Management System to run day to day operations.
• Created, modified, and performance-tuned stored procedures, triggers, and ad hoc queries to provide production support for day-to-day business operations.

• Performed development and production support duties using SSRS, Transact SQL, and Agile Software Lifecycle to manage reporting for assisted living communities, including gathering business requirements from end users.
• Developed and modified new reporting services reports to deliver data from the SenSys database.
• Performance-tuned stored procedures, triggers, and ad hoc queries to provide production support for SSRS reports.
• Worked directly with end users and peers to design mockup reports and gather requirements to deliver SSRS reports.
• Designed reporting architecture for reporting services security including server, reporting database, and report management to set up user and group level security.
• Communicate with peers and end users to manage changes and issues through TFS.

White Plains, NY, US

• Performed development and production support duties using SSIS, SSRS, Transact SQL, C#.net, Visual Studio 2010, and Agile Software Lifecycle to manage medicare advantage health plans including gathering business.
• Developed and modified the Member Premium Load to extract data from source database, transform the data, and insert transformed data into NRT (Network Reporting Tool) destination tables, deployed SSIS packages and.
• Created reports such as the Paid Claims and Membership report to support day to day business operations for the finance and analytics departments to make financial decisions based on NRT reports.
• Created, modified, and performance tuned stored procedures, triggers, and ad hoc queries to provide production support for day to day business operations.
• Performed DBA role to create and restore databases in all development environments, update statistics, and make changes to the data model such as creating tables, triggers, adding/removing columns, and creating primary.
• Modified web applications including Network Reporting Tool, ACOQR, and Pegasus

The Woodlands, Texas, US

• Performed development and production support duties using SSRS, Transact SQL, and Powerbuilder to manage railroad logistics operations.
• Maintained eBill application to create Bills of Lading to support rail line logistics
• Created, modified, and performance tuned stored procedures and triggers used to insert, update, and delete data in the eBill application
• Created reports for eBill reports allowing end users to make business decisions based on the data in eBill

Houston, TX, US

• Performed development and production support duties using SSIS, SSRS, and Transact SQL to manage power trading and LNG operations including gathering business requirements from end users and translating requirements.
• Created, modified, and performance tuned stored procedures, triggers, and queries for Mid Office Operational Data Store to provide support for the Power Trading group.
• Developed and modified ODS Data Load from Zainet to Mid Office ODS to move one million rows of power data daily.
• Performed Lead Analyst role for 3 contractors to oversee Endur implementation.
• Performed DBA role to create proof of concept SQL Server database to maintain security for handling ship scheduling for LNG Operations.

Houston, TX, US

• Performed development and production support duties using SSIS, SSRS, Transact SQL, and Powerbuilder to manage budget projections of field projects including gathering business requirements from end users and.
• Developed and modified PowerPlant to Mantra Interface to refresh development environments from production environment.
• Created Project Executive Summary Report to track the budgets of projects used by upper management.
• Created, modified, and performance tuned stored procedures, triggers, and views to support Mantra forecasting system to analyze budget projections for field projects.
• Performed DBA role to create databases, backup and restore databases, update statistics, performance tuning, and data model changes in development environments.
• Provided production support and new development for Mantra forecasting system.

Houston, TX, US

• Performed development and production support duties using SSIS, SSRS, SSAS, Transact SQL, and Powerbuilder to manage gas and power trading including gathering business requirements from end users and translating.
• Performed as Team Lead for 3 contractors to provide production support for Transenergy and Oxy Reports applications.
• Developed and modified ETL packages for Operational Data Store and Transenergy supporting power and gas trading.
• Created and modified fact tables and dimensions to produce cubes out of the Data Warehouse Power trading datamarts.
• Created and modified reports to identify users by application role, application roles, and user-role exception reports.
• Created, modified, and performance tuned stored procedures, triggers, and views in Transenergy application to support natural gas scheduling and trading.

US

• Performed development and production support duties using DTS (now SSIS), SSRS, Transact SQL, and Powerbuilder to manage gas and power trading and scheduling including gathering business requirements from end users and.
• Performed as Team Lead for 8 developers to provide production support for Unify Gazelle and Database Migration Effort.
• Created, modified, and performance tuned stored procedures, triggers, and queries in Unify application to support natural gas and power operations including Settlements, Logistics, and Volume Management.
• Created data integration packages to move data from Unify to downstream accounting systems.

Houston, Texas, US

• Performed development and production support duties using DTS (now SSIS), SSRS, Transact SQL, and Powerbuilder to manage pipeline infrastructure including gathering business requirements from end users and translating.
• Created, modified, and performance tuned stored procedures, trigger and queries to provide support for the Pipeline Infrastructure module.
• Created Powerbuilder Search utility to search application source code for text strings.
• Developed and modified the DartPlus application to manage Pipeline Infrastructure, Contracts, and Revenue functions.

• Performed development and production support duties using Transact SQL and Powerbuilder to provide technical consulting for energy, healthcare, and death care clients including gathering business requirements from end.
• Developed and modified Horizon application to provide death-care management for cemeteries and funeral homes.
• Developed and maintained GeNESis application to support gas trading operations

Australiia, AU

• Performed development and production support duties using Transact SQL and Powerbuilder to manage car dealerships including gathering business requirements from end users and translating requirements into IT solutions.
• Developed and modified CARMan97 application to support Payroll, Financing, Guest Management, and Sales modules.

• Performed development and production support duties using Transact SQL and Powerbuilder to manage hospital pharmacies including gathering business requirements from end users and translating requirements into IT.
• Developed and modified Omega-Rx application to support hospital pharmacy management operations.