Michael Marcaccio

· Delivered technical presentation to Agile Release Train on SQL Agent Jobs and SSIS packages, enhancing cross-team knowledge sharing.

· Authored and maintained comprehensive GitHub documentation to standardize key processes across 5+ development teams.

· Spread Knowledge to engineers on Redgate SQL Data Compare tool, improving database version control across the Release Train.

· Designed and developed a full-stack personal growth project featuring a normalized ERD, a MySQL database using Entity Framework, a .NET 6.0 API, and an Angular frontend.

· Collaborated with a neighboring Agile Release Train to architect a SQL Agent Job during a cross-team design session.

· Improved exception handling logic in an internal API, significantly increasing test coverage and codebase stability.

· Implemented in-memory caching for a high-traffic payment API, reducing database load and improving UI response times for end users.

· Developed a modular calendar service package to enable reusable, decoupled scheduling capabilities across multiple teams’ APIs.

· Migrated internal APIs from Amazon ECS to EKS, increasing scalability and aligning infrastructure with modern cloud standards.

· Led architecture design, sprint planning, and engineering coordination to modernize the payoff API from .NET Framework 4.8 to .NET 8 and deploy on Amazon EKS.

· Designed and implemented Kafka topic integration for the payment API to support event-driven messaging for client payments.

· Diagnosed and resolved NuGet package dependency issues that were disrupting the payment automation pipeline.

· Investigated and fixed a critical bug impacting approximately 30,000 client payments, improving system reliability and financial accuracy.

· Spearheaded the migration of AWS Lambda deployment processes from custom scripts to Terraform, becoming the first engineer in the Agile Release Train to enable .NET 8 compatibility and pass quality gate standards.

· Led backend development of secure APIs using .NET Core, enabling approximately 15% faster processing of customer payoff requests.

· Migrated 10+ services and deployment pipelines to Auth0

· Facilitated bi-weekly training sessions for teams of 6–10 developers, increasing adoption of best practices across the org.

· Mentored junior engineers, helping them onboard quickly and handle on-call rotations independently.

· Created a PDF-merging proof of concept using stream processing, later integrated into a production tool used by multiple teams.

· Contributed to bi-weekly sprint deliveries by shipping an average of 3–5 code modules per sprint, with 95% passing rate in CI.

• Designed a database schema and ETL pipeline for a new lead-generation feature, resulting in about 5% lift in captured client opportunities.
• Led updates to SSIS packages and MySQL cloud databases, improving performance and enabling KMS encryption for security compliance.
• Automated payoff process with AWS Lambdas and RDS, reducing manual processing time by an estimated 40%.
• Developed an AWS Lambda that was leveraged by 5+ dev teams across Agile Release Train
• Migrated AWS Lambdas and internal APIs to Auth0 for authentication and authorization
• Built a POC for PDF merging using a vendor’s documentation on a library and implementation
• Developed Angular front-end components for internal tools for internal team members, streamlining customer service workflows.
• Used Adobe Launch to create UI banners for 5+ client-facing promotional campaigns
• Provided daily support when on-call for team’s UI front end and the backend rest APIs
• Resolved 100+ incidents while on-call, maintaining average response time under 10 minutes.

· Developed 50+ automated integration and regression tests using Python, increasing test coverage by about 35%.

· Participated in design reviews for 10+ features, embedding QA best practices early in the dev cycle.

· Awarded “Automate All the Things” and twice nominated for the Master Your Craft Award based on peer recognition and contribution quality.

· Contributed Angular unit test components and UI testing, improving front-end test coverage by an estimated 20%.

· Played a key role in the Agile Release Train’s first successful migration to AWS by assisting in the development of a new MySQL-based cloud database.

· Contributed to the adoption of GitHub source control for database objects, enhancing collaboration and version tracking across development teams.

· Optimized SQL queries and database performance through regular tuning, indexing strategies, and storage management, resulting in faster data retrieval and improved system stability.

· Developed automation scripts for tasks such as backups, indexing, and query optimization, reducing manual work by over 40%.

· Created and maintained complex database objects, including stored procedures, triggers, functions, views, indexes, and constraints, supporting high-volume transactional applications.

· Acted as a go-to technical resource, providing training and support on Redgate tools and SQL Server features to team members and stakeholders.

· Assisted development teams in troubleshooting and optimizing complex SQL queries and stored procedures in production environments, improving performance and scalability.

· Built and maintained 10+ ETL pipelines using SSIS to handle data transfers across systems

· Deployed and maintained SQL Server and MySQL database objects, supporting applications with 1,000+ daily users.

· Optimized memory settings and introduced KMS encryption on cloud-hosted MySQL databases, contributing to performance and compliance improvements.

· Nominated for the 2018 Rock Honors Award – Breakthrough Performance, recognizing excellence and innovation in engineering contributions.

· Led cross-functional teams to generate client letters

· Managed relationship with external print vendor

· Trained 15+ interns and new hires in learning team functions and workflows

· Partnered with IT team members to define system requirements for servicing documents

· Improved client facing communication in response to feedback by readjusting and reformatting notifications

· Collaborated with marketing team to design document templates

· Performed data mapping for information required on mortgage notifications

· Designed and conducted audits of servicing communications

· Awarded a Quicken Loans E2A Award for Client Experience