Gabriel Mongefranco
Sr. Data Architect
Data Architect and Business Intelligence leader with demonstrated knowledge of IT best practices in Healthcare and Audit Services. Led innovative projects that increasd use of mobile technologies in research studies, decreased breached tickets by 800% and increased adoption of data analytics across departments. Led international teams of 6-10 developers, and facilitated a University of Michigan mobile data experts group with 50+ multi-disciplinary members. Wrote over 250 knowledge articles, and became functional service lead for dashboards. Currently working as the University of Michigan's first data architect dedicated to mobile data and high-tech wearables.
______________________________________________________________________________________
• SQL / Oracle / Microsoft SQL Server
• Power BI
• Snowflake
• BI Publisher
• C# / Object-Oriented Programming
• Database Architecture and Design
• Data Mapping and Data Modeling
• Power Automate
• TCP/IP Networking
• ADA and Accessibility
• Analytics, BI, Dashboard Development
• Billingual, Spanish and English
• Customer Relations
• Leadership & Mentorship
• Clinical Research and Mobile Data Analysis
• Technical Writing
University of Michigan. Ann Arbor, Michigan
Currently designing and implementing the enterprise architecture, data flows, and infrastructure for bringing wearable and mobile data (Fitbit, Apple Watch, and Garmin), into a secure Oracle database environment within Michigan Medicine to help accelerate clinical and mental health research.
Led two project teams of 10 students to build two badly needed applications: TrackMaster, a membership tracking system and CRM for 30+ centers and institutes (using SharePoint, Tableau, Oracle, Power Automate); and MiNap, an Apple Watch sleep diary app for sleep and mental health research (using Swift, AWS, DynamoDB, Python, Docker and Oracle).
Implemented a Knowledge Base system and GitHub organization for the Depression Center and the Mobile Technologies Core to share technical knowledge around wearables and mobile tech, thus increasing collaboration among researchers of many universities.
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, and to champion disability rights at
school districts, State legislature and Federal
government
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, JasverServer, Business Objects, and Tableau
ITIL 4 Foundation Certificate in IT Service Management
CompTIA Network+ Certified Professional
CompTIA Security+ Certified Professional
Davenport
University
Bachelor
of Applied Science
Major
in Network Security
Grand
Rapids, Michigan
Grand
Rapids Community College
Associate
of Art
Major
in Computer Information Systems
Grand
Rapids, Michigan
Influenced members of the Michigan House of Representatives, Washtenaw County Board of Commissioners and the Governor’s Office to act to protect the rights and medical care of 18,000 catastrophic auto accident survivors, to pass resolutions in support of overturning a harmful law, and to introduce bills to repeal such law. Ann Arbor, Detroit and Lansing, Michigan, 2021-2022
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
Grew the membership of the Michigan Interfaith Coalition by over 30,000 new members in a single month by developing a compelling Wordpress website. Ann Arbor, Michigan, 2021-2022
Engaged with the US Department of Education, Office of Special Education through a parent focus group to help evaluate Michigan’s performance in implementing IDEA and ADA protections for students with disabilities. Ann Arbor, Michigan, and Washington, D.C., 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