Gabriel Mongefranco
Sr. BI and Analytics Developer
Dynamic Business Intelligence leader with demonstrated knowledge of IT best practices in Healthcare and Audit Services. Led innovative projects that decreased breached tickets by 800% and increased adoption of data analytics across departments. Led international teams of 6-10 developers, wrote over 100 knowledge articles, and became functional service lead for dashboards.
______________________________________________________________________________________
• SQL / Oracle / Microsoft SQL Server
• Power BI
• Snowflake
• BI Publisher
• C# / Object-Oriented Programming
• Data Mapping and Modeling
• Dashboard and Report Development
• Power Automate
• TCP/IP Networking
• ADA and Accessibility
• Analytics and BI
• Billingual, Spanish and English
• Customer Relations
• Leadership & Mentorship
• Research & Analysis
• Technical Writing
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
U.S. Coast Guard Merchant Marine Credential
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