Michael Cuccia Email & Phone Number

Harrisburg, Pa, Us

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 to move the data from the Bronze lakehouse to the Silver lakehouse, and stored procedures in the Gold data warehouse to move the data from the Silver lakehouse to the Gold data warehouse into a star schema dimensional model.• 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, Terraform scripts for configuring resources, Jenkins for secrets, DMS tasks, and chron scheduling.• 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.• Managed and co-developed sunset project for replacing an antiquated ETL solution to save VF over a million dollars in licensing fees annually. The new solution included both SQL and AWS Lambda functions in Python along with Terraform scripts for configuring AWS resources.• Supported our retail business resolving issues involving SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and stored procedures for data loads to the Dickies BI data warehouse.• Proactively cross-trained developers to support SQL data load processes.

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 of thousands of rows of data.• 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 why to the customer in language the customer understands. Performance tuned process from several minutes down to only a few seconds.• 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 from end users and translating requirements into business intelligence and reporting solutions.• 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.• Ensure product excellence by performing code reviews and responding to code reviews made by developer peers.

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 users could rapidly create their own reports.• 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 performance of dozens of poorly performing SQL queries. This effort includes analyzing execution plans and adding indexing for tables and columns and rewriting queries to direct the SQL engine to properly traverse the query tree.• 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 for contracts, orders, and products.• 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 the newest version.• Supported and modified scheduled database jobs using SSIS and SQL Agent through Microsoft SQL Server.• Increased data visibility by conceptualizing a data warehouse and building reporting views to be used as fact tables This includes moving dimension data through ETL with SSIS implementing a dimensional modeling strategy.• Rapidly developed solutions with Agile methodology using Jira to create epics and stories, manage daily development, and participating in daily standups.

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 chart including daily / weekly / monthly date bins for drill down capabilities to help executives and site managers to make daily financial, labor, and manufacturing decisions.• 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 Reconciliation which reconciled our manufacturing dollars to the accounting system with a .1 % margin of accuracy.• 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 KPI's. This model included both SSIS and SQL scripts to update slowly changing and rapidly changing dimensions.• 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 cluster. SSIS packages also included data integration using source data from files such as text files or Excel files.• 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 implementing table-valued functions to cross apply with queries.• 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 data transformations such as multicast, merge, derive, conditional split, sort, lookups, and union all.

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 chart including daily / weekly / monthly date bins for drill down capabilities to help executives and site managers to make daily financial, labor, and manufacturing decisions.• 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 SQL Server database using SSIS.• 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 trending data for operations and sales.• 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 with greater efficiency saving labor dollars and making more sales dollars.

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 and translating requirements into IT reporting solutions.• 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.• Created, modified, and performance-tuned stored procedures, triggers, and ad hoc queries to provide production support for day-to-day business operations.

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 and translating requirements into IT reporting solutions.• 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 requirements from end users and translating requirements into IT solutions.• 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 solutions into production.• 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 and foreign key constraints.• Modified web applications including Network Reporting Tool, ACOQR, and Pegasus• Team Foundation Server for code source control and problem tracking.• Iterative development using the sprint and scrum concepts of Agile to adapt quickly to changing requirements and concurrent bug fixing during new development.

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 into IT solutions.• 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 translating requirements into IT solutions.• 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 requirements into IT solutions.• 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.• Developed and modified Usage Uploader console application for uploading Power usage data into our Retail Transaction System to open Excel, create worksheets, and perform calculations before loading into RTS.

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 translating requirements into IT solutions.• 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 requirements into IT solutions.• 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 users and translating requirements into IT solutions.• 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 solutions.• Developed and modified Omega-Rx application to support hospital pharmacy management operations.