Gabriel Mongefranco
Sr. BI and Analytics Developer
Innovative data architect and software developer with demonstrated knowledge of best practices in Healthcare IT. Led transformative projects that increased use of mobile technologies in research studies, decreased breached help desk tickets by 800% and increased adoption of data analytics across organizations. Co-authored a SLEEP journal article on automating the cleaning of Fitbit sleep data. Currently working as the University of Michigan's first data architect dedicated to mobile data and high-tech wearables in research.
______________________________________________________________________________________
• SQL / Oracle / Microsoft SQL Server
• Power BI / Power Query / Tableau
• Snowflake
• BI Publisher
• C# / Object-Oriented Programming
• Data Mapping and Modeling
• Dashboard and Report Development
• Power Automate / SharePoint
• Analytics and BI
• Bilingual,
Spanish and English
•
Research
& Analysis
• Technical Writing
University of Michigan Ann Arbor, Michigan
Currently designing and implementing the enterprise architecture for wearable and mobile data (Fitbit, Apple Watch, Garmin, CGMs, etc.) to help accelerate clinical and mental health research
Co-authored a paper on automating Fitbit sleep data cleaning that was published on the prestigious SLEEP journal (doi.org/10.1093/sleep/zsae290)
Led two project teams of 10 students to build research and business apps: TrackMaster, a membership tracking system and CRM for research centers (SharePoint, Tableau, Oracle, Power Automate); and MiNap, an Apple Watch sleep diary app for sleep and mental health research (Swift, AWS, DynamoDB, Python, Docker, iPaaS, Oracle)
Implemented a Knowledge Base system and GitHub organization for University of Michigan’s Depression Center to share technical articles and code for wearable devices and mobile tech
NSF Ann Arbor, Michigan
Designed 30+ Snowflake datasets and Power BI / Tableau dashboards for specific visualization tasks that gave leadership completely new insights into accruals, profit margins, auditor performance and IT metrics
Directed Agile Sprint process from requirements review to creating Sprint plans to overseeing an international BI development team
Integrated data from multiple systems into cohesive SQL views using Snowflake, APIs, SharePoint, Azure blobs and Power Automate
Documented enterprise data architecture, datasets, development processes, ER diagrams
Trained
Applications Support team in Power BI which
shifted
nearly 90% of support work to level 2
NSF / Vision IT Ann Arbor, Michigan
Earned 100% customer satisfaction ratings resolving complex issues in java, BI Publisher and Oracle PL/SQL
Improved second level Apps Support metrics by 250% in Latin America, increased customer satisfaction survey responses tenfold, and reduced breached tickets by 800% globally
Authored 100+ technical articles in both English and Spanish, ER Diagrams and a Data Dictionary that resulted in quicker, better service globally
Interviewed and acted as technical mentor for a global team of 4-8 developers, while coordinating their work to ensure SLAs were met and ITIL best practices were followed
Self-Employed Grand Rapids, Michigan
Leave
of Absence to provide full time care and case management for family
members with disabilities
Priority Health Grand Rapids, Michigan
Wrote a 5,000+ line SQL query to identify specific asthma patients that require interventions to reduce their dependence on medical care, contributing to better outcomes while reducing the cost of care by 25%
Pioneered
cutting-edge
dashboards
(Oracle,
Tableau, Business Objects), saving large hospitals over $5M in
federal fines for
hospital
readmissions
Self-Employed Grand Rapids, Michigan
Created a prototype appliance for Atos/John Deere to allow communication between headquarters (SOAP web services), Azure cloud, and thousands of on-site Dealer Management Systems with REST APIs
Modernized a century-old insurer through automated migration of 10 billion financial documents from outdated systems into IBM CMOD
Performed
payment-card industry audits (PCI DSS) and software compliance
audits for retail and legal offices, saving $100k in fines from BSA
and US DoT
Dominion Dealer Solutions Ann Arbor, Michigan
Led integrations projects and interviewed and mentored developers
Designed and developed middleware solutions to connect a Dynamics AX dealership management system to Honda and Toyota using BizTalk Server, WCF, AIF, XML, C#, T-SQL, and SSIS
Produced
a client authentication Windows Tray App, WPF desktop apps, web
APIs, and complex SQL Server functions
Infinimight LLC Kentwood, Michigan
Provided
software and integration development services (C#, ASP.NET, dotCMS,
JavaScript, SQL) and license compliance audits to clients
throughout Michigan
Spectrum Health System Grand Rapids, Michigan
Increased adoption of Enterprise Data Warehouse through development and technical documentation of Data Marts and SAP Business Objects universes for Finance, Service Desk, Project Management and Healthcare
Developed business applications and dashboards using VB.NET, T-SQL, Access, C#, ASP.NET, JasperServer, iReport, Business Objects, and Tableau
ITIL 4 Foundation Certificate in IT Service Management
CompTIA Network+ Certified Professional
CompTIA Security+ Certified Professional
Davenport
University, Grand
Rapids, MI
Bachelor
of Applied Science
Major
in Network Security
Grand
Rapids, Michigan
Grand
Rapids Community College, Grand
Rapids, MI
Associate
of Art
Major
in Computer Information Systems
Co-authored “Lessons learned on the road to improve sleep data extracted from a Fitbit device,” published in 2025 in SLEEP journal (doi.org/10.1093/sleep/zsae290)
Eliminated knowledge silos at NSF IT by compiling information from 10+ departments and documenting business processes, data definitions, database schemas and ER diagrams in an enterprise Data Dictionary. NSF, Ann Arbor, Michigan, 2020-2022
Led informatics initiatives as the Computer Systems Officer and Certified Boat Crew Member for the U.S. Coast Guard Auxiliary, Muskegon Flotilla (civilian volunteer), Muskegon, Michigan, 2010-2012
Presented "Dissecting a Computer Virus" and "Protecting Yourself from Identity Theft" to audiences of 40+ attendees at Spectrum Health and Davenport University, Grand Rapids, Michigan, 2009 and 2010
Won over 15 medals and trophies at national and state competitions in C++ Programming, Computer Security, VB.NET Programming, Database Design, HTML, Information Technology and Administrative Support Concepts at Business Professionals of America. Grand Rapids, MI; Clio, MI; Reno, Nevada. 2007 and 2008
Launched a volunteer-run computer repair “PC Clinic” while vice president of Computer Club at Grand Rapids Community College, resulting in over $5,000 in savings for the local student body. Grand Rapids, Michigan, 2004-2005