Resume

Gabriel Mongefranco

Database Development | Integrations | Web Services

SUMMARY

I am a creative and resourceful software developer currently seeking to re-enter the workforce in the Grand Rapids, Michigan or Ann Arbor, Michigan areas. My areas of expertise are database development, service-oriented architecture (SOA) development, web services, and enterprise integration. My past experience includes running an IT consulting business, mentoring developers, leading technical design and architecture, public presentations, managing software license compliance, and developing cutting-edge, enterprise-level software.

Skills and Certifications

Skills and Certifications

CAREER OBJECTIVE

To re-enter the workforce and train as an Enterprise Architect.

SKILLS

Databases and Integration: T-SQL, SQL Server, SSIS, BizTalk, Access, Excel

Development: C#, VB.NET, WCF, SOAP, REST, XML, DotCMS, Visual Studio, TFS Build Server, Agile

EDUCATION

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

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

PROFESSIONAL EXPERIENCE

Data Analytics Analyst, Priority Health

Grand Rapids, MI — 09/2015 – 09/2016 (Part-Time)

Develop advanced analytics in healthcare quality improvement and cost savings for one of Michigan’s largest health plans

Accomplishments
  • Developed a complex population health extract with PL/SQL 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

Rockford, MI — 10/2013 – 12/2015 (Part-Time)

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

Accomplishments
  • Developed a WCF-based middleware appliance prototype for Atos/John Deere that would allow integration between Deere’s XML-based web services, through Azure, to on-premise Dealership Management Systems (DMS) over SOAP and REST
  • Developed a DMS emulator 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 (Full-Time)

Audit 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

Accomplishments
  • 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 Enterprises

Ann Arbor, MI — 02/2012 – 10/2013 (Full-Time)

Develop enterprise integration and database 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

Accomplishments
  • 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 orchestrations
  • 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
  • Created 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
  • Designed and 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
  • Designed and developed a series of BizTalk orchestrations (middleware web services) to perform scheduled data syncs between different modules of a CRM application, a web-based Finance and Insurance application, and Dynamics AX

Web Technician/Developer, Calvin College

Grand Rapids, MI — 2011-2012 (Part-Time)

Maintain and enhance the Calvin Institute of Christian Worship’s website using DotCMS, HTML, JavaScript, and Velocity

Accomplishments
  • Developed the search functionality for CICW’s website, including advanced filters, related content widgets, and tags, leveraging Lucene fuzzy and proximity search queries
  • Taught web development and content management essentials to a group of interns and support staff

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

Lansing, MI — 01/2011 – 07/2011 (Full-Time)

Develop 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

Kentwood, MI — 04/2010 – 12/2012 (Full-Time)

Manage and market Infinimight LLC. Provide professional services including database design, data migration, software development, Windows server support, and software license compliance auditing

Accomplishments
  • Kept accurate accounting and expense records, and prepared all legal documents and tax returns
  • 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 (Full-Time)

Develop business intelligence solutions, ASP.NET and WinForms applications, Access and SQL Server databases, and web services; purchase hardware and software; keep accurate software license records

Accomplishments
  • Created an illegal software tracking database in Access/SQL Server that imported data from multiple sources to track compliance status, provide automated notifications to management, and force uninstalls remotely
  • Created an ASP.NET web application and a web service, “Shorty,” to shorten long URLs
  • Created a web service to read Excel files from a file share, protected through AD security group membership (roles), so they could be used for dashboard data sources in SAP Xcelsius and Tableau
  • Created an ASP.NET/T-SQL web app, “Data Dictionary”, to provide end users with easy access to business definitions of Data Warehouse objects in a search engine-like fashion. Developed a VBA application to synchronize Business Objects universe objects with the web app’s SQL Server backend
  • Created a VB.NET/T-SQL application for HR to easily navigate through Spectrum Health’s employee 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, integration with Excel to import vendor price sheets, a 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 integrated it with Active Directory authentication. Designed iReport reports for procurement, license tracking and budget reporting
  • Created a Business Objects universe and webi reports for Spectrum Health’s Help Desk, using data from CA ServiceDesk

Computer Tutor, Grand Rapids Community College

Grand Rapids, MI — 2005-2006 (Part-Time)

Tutor students in programming (C++, VB.NET, Bash), Systems Administration (Linux, Windows Server), 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.