Daniel J. McGuire
Senior Financial Software Engineer & Data Analyst. Don’t skim a page — step into each chapter and look around.
Lead the design and execution of data mapping frameworks and target data architecture to ensure seamless data integration across enterprise finance applications.
Partner closely with Product Managers, Data Engineers, and Data Architects to validate complex datasets, enforce data governance, and optimize data pipeline performance.
Develop and implement scalable, real-world financial use cases and data models to enhance platform capability, data consistency, and reporting solutions.
Collaborate on Proof of Concept (PoC) initiatives, onboard key client enterprise workflows, and ensure high quality and health across client production environments.
Support modern AI and development workflows using Cursor AI and Python to automate data analysis tasks.
Write and push production-level code (Java, JavaScript) to resolve software bugs, optimize reporting queries, and deliver targeted feature enhancements.
Utilize modern AI-assisted development tools (Cursor AI) and Git version control to accelerate software debugging, refactor backend scripts, and maintain pipeline health.
I worked on the SSGA and Nuveen Alpha Conversions both at State Street. In January 2023, a section of State Street employees were transitioned to Deloitte, but we still worked on the same projects. The SSGA project was focused on implementing a new performance product. The Nuveen project was converting Nuveen onto the State Street transaction processing platform.
Led cross-functional onboarding and implementation lifecycles, translating business requirements into technical functional specifications and system architecture solutions.
Conducted comprehensive gap analysis between legacy databases (SQL Server) and cloud environments (Snowflake) to ensure complete data integrity, standard compliance, and data quality.
Designed and configured data interfaces and data share specifications for clients, ensuring secure and seamless data access for financial decision-making.
Oversaw project implementation timelines, cost structures, and risk mitigation strategies while keeping key executive stakeholders aligned.
Served as Subject Matter Expert in Snowflake database administration, querying, data sharing, and architecture configuration.
Collaborated with Product Management and engineering teams to define functional requirements, technical specifications, and system enhancements for enterprise accounting platforms.
Communicated project progress, deliverables, and timelines across global stakeholders and led weekly coordination across offshore development teams.
Managed, maintained, and automated 1,000+ daily regression test cases utilizing Jenkins, JavaScript, and SQL to ensure software reliability.
Reviewed and approved junior developer code (SQL, Java) on GitHub and edited database tables/schema to accommodate core functional enhancements.
Conducted client-facing platform demonstrations and delivered training sessions across internal teams for major software updates.
Partnered with QA teams to author functional documentation, user guides, and test plans for software releases and system integrations.
Enhanced core platform engines (STAR) to process intraday, capital, and income NAV allocations across diverse asset classes.
Reviewed C++ code for system integrations (NASDAQ module) and utilized Unix and Win Merge to deploy code fixes across dev, QA, and production environments.
Managed daily accounting operations, risk escalations, and client deliverables using STAR accounting platforms.
Processed complex derivatives and trades including IRS/CDS swaps, futures, options, and fixed income instruments.
Supervised fund accounting staff, auditing daily valuation pricing and developing automated Visual Basic macros to boost workflow efficiency.