Michael Ferguson Email & Phone Number

Dallas, Tx, Us

Gb

* Designed and implemented Azure cloud solutions for large tax applications, optimizing infrastructure for scalability, reliability, and cost-efficiency.* Spearheaded the migration of datacenter-hosted applications to Azure, resulting in ~40% reduction of cost. (Tech: Azure Cloud, infrastructure migration, ARM, Bicep, PowerShell).* Leveraged ARM and Bicep to manage infrastructure in Azure Cloud with Azure DevOps pipelines for automated deployment and change management. (Tech: ARM, Azure Bicep, Azure DevOps)* Transitioned legacy applications into Docker Containers running on Azure Functions and Kubernetes, reducing application deployment time, improving scalability, and saving cost. (Tech: Docker, K8s)* Developed comprehensive monitoring strategies to ensure high-availability and fast response to application alerts and system outages.* Lead an internal DevOps team, assigning and managing tasks, and running daily scrum.* Facilitated Azure security best practices, implementing NIS and Azure Security Center recommendations to safeguard cloud environments.* Designed disaster recovery and high-availability strategies on Azure, ensuring business continuity and minimal downtime. (Tech: SRE / Site Reliability)* Managed Azure Kubernetes Service (AKS) clusters to orchestrate containerized applications, improving deployment cycles and system resilience. (Tech: Kubernetes, container orchestration)* Designed and implemented ETL processes using Azure Data Factory to aggregate key data from a large tax application for management reporting purposes. (Tech: Azure Data Factory, Azure Databricks)

San Francisco, Ca, Us

* Lead developers on various projects including a Data Warehouse, Angular web front-end, and OData RESTful web services. (Tech: Angular, Dimensional Modeling, SSAS, SQL Server, ETL)* Modeled and architected a data warehouse, including a data lake, using a medallion model and serving as the back-end for management reporting & master data (Tech: Data Architecture, Data Lake)* Implemented continuous integration and continuous delivery using Visual Studio Team Services and Git, enabling weekly automated releases of all database and front-end code.* Partnered with the Portfolio Accounting team to implement Trintech Adra, a cash reconciliation platform similar to ReconNet, automating reconciliation of ~ 500 cash accounts. (Tech: SQL Server, JAMS, Geneva)* Defined development patterns for SQL, ETL, and Angular to ensure consistency of code and best-practices across all projects. (Tech: SQL Server, .NET, Angular)* Created SQL and web services for Advent Geneva (Tech: SQL, XML, Web API, Geneva SOAP loader)* Lead daily scrum stand-up meetings, clearing any technical or business roadblocks.* Coded a security master interface as part of the Eze Castle (Order Management System) implementation, loading new securities created in the OMS into Advent Geneva and reporting them to the fund administrator.* Implemented the JAMS job scheduling system for centralized enterprise management of scheduled jobs, data feeds, and ETL processes.

New York, New York, Us

* Collaborated with finance and accounting to create a journal entry data mart, automating month-end posting from Advent Geneva to Great Plains GL and saving a day and 50+ man hours on the monthly close for a $6bn fund structure.* Joined forces with the NYC IT team as technical lead in the firm’s data warehouse project, modeling facts and dimensions in a star schema, creating data loading processes, optimizing queries, and creating best practices.* Worked with finance and accounting operations team to manage implementation of the Electra OpenSTaARS reconciliation platform for cash and position reconciliation between Advent Geneva and custodian / trustee data sources.* Assisted the IT team as project manager in the Cash Journal Entry project, liaising with operations to ensure the project met all requirements and had a solid test and migration plan.

New York, Ny, Us

* Created ORIX’s enterprise data warehouse from scratch in SQL 2012 with data sourced from Princeton Financial Systems PAM for Securities XG8 / PFI, MarkIt WSO, LeasePak, Bloomberg, and Epicor.* Lead the JAMS implementation to consolidate job scheduling and job management across the firm.* Loaded and transformed data using SQL Server Integration Services 2012 in a clustered Microsoft SQL Server 2012 environment.* Helped mentor colleagues on data warehousing ETL design and best practices, including various lunch-and-learn sessions on technical database-specific topics.* Revamped ORIX’s back-office reporting from PAM / PFI using InfoStream ODBC to improve reliability of reports and accuracy of data.* Managed all code in Team Foundation Server using SQL Server Data Tools projects* Assisted Accounting with a number of data pulls for P&L, valuations, returns, etc.

M.S., Accounting And Information Management

B.S., Software Engineering And Computer Science