Resume

Gabriel Mongefranco

Software Development, Data Analytics & Technical Writing

SUMMARY

Software Developer and Data Analytics Specialist with in-depth experience in C#, PL/SQL, T-SQL, dashbaords, APIs and technical writing.

Skills and Certifications

Skills and Certifications

SKILLS

Agile | APIs | Business Intelligence | WCF/REST/SOAP | C# | Analytics | JavaScript | Linux | SQL | Oracle | Technical Writing | Mentoring Developers | Application Support | Customer Support | Spanish

EDUCATION

Bachelor of Applied Science, Network Security. Davenport University, MI

Associate of Arts, Computer Information Systems, Network Administration. Grand Rapids Community College, MI

PROFESSIONAL EXPERIENCE

Application Support Developer, VisionIT / NSF International

Ann Arbor, MI — 09/2019 – 03/2021

Customer’s main point of contact for Level 2 tickets. Resolved complex 2nd-level application support issues and coordinated with IT teams and Business Analysts as needed for bug fixes.

  • Provided application support for enterprise java web apps, BI Publisher reports and Oracle PL/SQL stored procedures.
  • Improved second-level support metrics for Latin America by over 200%, and implemented an enhancement for global IT customer satisfaction surveys that increased response rates by over 30%.
  • Wrote or co-authored 75+ Spanish/English bilingual knowledge base articles in Confluence that resulted in quicker, better service globally.
  • Increased efficiency of Service Desk by automating repetitive tasks in Jira using JavaScript and Power Automate.

High Tech Aide, Leave of Absence

Ann Arbor, MI — 09/2016 – 09/2019

Took a leave of absence to provide full time care and case management for family members with disabilities

  • Advocated for family members by clarifying communications with health care providers, compiling health history to prevent medicine interactions and incorrect medical diagnoses, ensuring compliance with HIPAA, and navigating the complex health and insurance systems.
  • Assisted with medical equipment, including wheelchairs, AFOs and assistive technology.

Data Analytics Analyst, Priority Health

Grand Rapids, MI — 09/2015 – 09/2016

Develop health care metrics dashboards, data mining and advanced data analytics queries for Michigan’s largest health plan.

  • Developed a 5,000+ line PL/SQL query for an asthma population health extract for the National Green and Healthy Homes Initiative (GHHI).
  • Developed and automated hospital readmission dashboards using Oracle, Tableau and Business Objects.

Software Developer, Self-employed

Grand Rapids, MI — 10/2013 – 12/2015

Provided software development, data analytics, and integration services, with a focus on .NET/C#, T-SQL, web services (REST, SOAP, WCF) and APIs.

  • Developed a WCF middleware appliance prototype for Atos/John Deere to integrate Deere’s XML-based web services, through Azure, to any on-premise Dealership Management Systems (DMS) over SOAP and REST web services/APIs.
  • Developed a DMS simulator for John Deere in WPF capable of processing STAR BODs (XML messages), as well as running OS-level diagnostics (CPU utilization, memory, event logs, etc.).
  • Developed C# and MS-DOS batch programs for ASG-ECM to assist in migration of billions of financial documents into IBM CMOD.

Advanced Information Systems Auditor, Meijer Inc.

Walker, MI — 06/2014 – 09/2014

Audited Meijer’s information systems to ensure data confidentiality, integrity and availability, as well as compliance with Payment Card Industry (PCI) data security standards and DOT/MDOT regulations

  • Audited outbound logistics to ensure compliance with DOT standards, saving the organization over $25,000 in potential fines, and potentially saving lives in the event of hazmat incidents
  • Audited Meijer’s information security controls to ensure compliance with PCI DSS 3 Data Security Standards

Software Developer, Dominion Dealer Solutions (Dominion Enterprises)

Ann Arbor, MI — 02/2012 – 10/2013

Developed integration solutions and enterprise software in an Agile/SCRUM environment to connect automobile manufacturers with a Dynamics AX-based Dealership Management System, using SQL, BizTalk, WCF, AIF and XML.

  • Interviewed job candidates for technical positions and mentored new developers, helping them learn BizTalk, SSIS and T-SQL.
  • Developed SSIS packages for ETL processing of VIN decoding and OEM parts data, and exposed the data through C# WCF services and BizTalk Server
  • Automated the build and deployment process for Dynamics AX 2012, SQL Server 2012 databases, and BizTalk 2010 assets using TFS Build Server, SSDT and batch scripts.
  • Created a WPF-based test management application (“Tesla”) to allow business analysts and QA testers to login to specific Dynamics AX instances using test account credentials.
  • Developed a Windows Tray app and API with encryption features to allow client applications to authenticate against and securely query a Dealership Management System over the Internet. Also built all BizTalk, WCF and AIF services on the cloud side.
  • Developed a SQL 2012/WCF “Global Directory” application to provide the backend glue between Dynamics AX, SharePoint, web and CRM applications in a multi-tenant cloud environment, facilitating dynamic connections to a user’s organization instances and databases based on assigned security roles.
  • Built BizTalk orchestrations (middleware web services) to sync data between a CRM, in-house Finance & Insurance web app, and Dynamics AX.

Web Technician, Calvin Institute of Christian Worship (Calvin College)

Grand Rapids, MI — 08/2011 – 02/2012

Developed new website features using DotCMS, HTML, JavaScript, and Velocity.

  • Developed the Search and Related Posts functionality for worship.calvin.edu using Apache Lucene, fuzzy and proximity queries, DotCMS, JavaScript and JQuery.
  • Taught web development and content management essentials to interns and support staff.

Application Developer, Two Men and a Truck Intl., Inc.

Lansing, MI — 01/2011 – 07/2011

Developed enhancements to Dynamics AX modules and reports; research and implement solutions for IT management and security

Accomplishments
  • Created a REST web service and Android client application to view contracts in Dynamics AX, using X++, .NET Business Connector, and SSL
  • Created an interactive, easy-to-use financial reports package for U.S. franchises using SSRS with drill-downs to linked reports
  • Enhanced several Dynamics AX modules, including Project Management (activity selections for Project Wizard), General Ledger (custom reports), A/P (custom check printing) and A/R (search suggestions)
  • Created SSIS packages to load text and XML log files into SQL Server

Business Owner / IT Consultant, Infinimight LLC

Grand Rapids, MI — 04/2010 – 12/2012

Ran own business, providing IT Consulting services that included: database design, data migration, software development, Windows server support, and software license compliance auditing.

  • Provided support and development for Calvin College and Calvin Institute for Christian Worship websites, including dotCMS content management system, Velocity macros, and JavaScript code.
  • Integrated Spectrum Health’s purchasing systems (Lawson and in-house .NET systems) with license compliance tracking systems (CA APM/SWCM) using T-SQL and batch scripts, providing an automated import of purchasing data and reconciliation to license compliance data.
  • Performed software license compliance audits for clients of Shinners & Cook, P.C., making recommendations for remediation of BSA complaints and compliance program improvements.

Programmer/Analyst, Spectrum Health System

Grand Rapids, MI — 04/2006 – 05/2010

Developed business intelligence solutions, ASP.NET and WinForms applications, Access and SQL Server databases, and web services; purchased hardware and software; kept accurate software license records.

  • Created an illegal software tracking database in Access/SQL Server that mined and extracted network and system data to track compliance status, automate management notifications, and enforce remote software uninstalls.
  • Created C# ASP.NET web apps and WCF web services with AD role-based security to shorten URLs, to push Excel files to Xcelcius/SAP/Tableau dashboards, and to update a serial-interface electronic marquee display.
  • Created an search engine and ASP.NET/T-SQL web app, “Data Dictionary”, for data governence of business terms and definitions used in theData Warehouse. Developed a VBA application to synchronize Business Objects universe objects with the web app’s SQL Server backend.
  • Created a VB.NET/T-SQL desktop app for HR organizational hierarchy.
  • Implemented and maintained ZENworks Asset Management (software and hardware tracking & inventory).
  • Enhanced a VB.NET/SQL Server IT procurement app with Dymo label printing, Excel vendor price sheets import, pop-up product catalog, license data export to ZENworks Asset Management, and synchronization with Lawson ERP, saving 20+ weekly hours of data entry.
  • Installed JasperServer (BI server) and configured it for Active Directory authentication. Designed iReport reports for procurement, license tracking and budget reporting.
  • Created a Help Desk Business Objects universe and webi reports with data from CA ServiceDesk.

Computer Tutor, Grand Rapids Community College

Grand Rapids, MI — 08/2005 – 04/2006

Tutored students in programming (C++, VB.NET, Bash), Systems Administration (Linux, Windows Server), LAN/WAN Networking and Telecommunications.

LEADERSHIP AND VOLUNTEER EXPERIENCE

  • Business Owner – IT, Real Estate
    • 2010-2012 – IT Consulting/Software Development (Infinimight LLC)
    • 2013-2015 – Software Development Consultant (Sole Proprietorship)
    • 2012-Present – Rental Property Ownership/Management
  • Skilled Nursing Assistant (Hi-Tech Aide) Trainer, Ann Arbor, MI and Rockford, MI, 2013 to present
    • Provide attendant care services to a family member with a severe spinal cord injury that includes wheelchair transfers, straight catheterization, activities of daily living (ADLs), mobility, and general safety
    • Train hi-tech aides in all care modalities and clinical procedures
  • USCG-Aux Flotilla Staff Officer – Computer Services, and Volunteer Boat Crew Member, United States Coast Guard Auxiliary. Grand Rapids, MI and Muskegon, MI, 2011-2012
    • Trained in CPR, first aid, and boating safety
  • Presenter, “Dissecting a Computer Virus. Spectrum Health and Davenport University, MI, 2009
  • Presenter, “How Do Hackers Do It? Spectrum Health, MI, 2008
  • Presenter, “Protecting Yourself from ID Theft on the Internet. Spectrum Health, MI, 2006
  • Organizer, “PC Clinic.” Computer Club, Grand Rapids Community College, MI 2005-2007.
    • Organized a popular free, volunteer-run computer repair clinic for college students and staff.

CERTIFICATIONS

Heartsaver CPR, AED, First Aid. 07/2015

Basic Life Support for Healthcare Providers (BLS). 04/2015

CompTIA Network+. 12/2008

CompTIA Security+. 08/2007

AWARDS

Business Professionals of America (BPA) National Winner 2008, Reno, NV, 2008:

  • Administrative Support Concepts
  • Computer Security
  • C++ Programming
  • VB.NET Programming

BPA Michigan Winner 2008:

  • C++ Programming
  • Information Technology
  • Computer Security
  • VB.NET Programming

BPA Michigan Winner 2007:

  • Computer Security
  • C++ Programming
  • Fundamentals of XHTML
  • Database Design

SPECIALIZED TRAINING

Querying Microsoft SQL Server 2012. Exam passed 07/2013

Development in Microsoft Dynamics AX (Microsoft Courses 80011, 80012, 80013, 80014). NetCom, Las Vegas, NV, 2011

Introduction to Visual Basic .NET Programming with Microsoft .NET. Ada, MI, 2008

Novell ZENworks Asset Management Advanced Training. Grand Rapids, MI, 2006

Contact Information

Contact me online at https://gabriel.mongefranco.com/contact.

About the Author

Gabriel Mongefranco is your software developer for all things data: extraction, integration, analytics and security. He is also a blogger, a poet, a proud father and a faithful Christian. He is always eager to contract with faith-based nonprofits! Learn more.