Resume

SUMMARY

I am a creative and resourceful senior software developer currently seeking a part-time role in the Rockford, Michigan area. 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, presenting technical materials to non-technical audiences, managing software license compliance, and developing cutting-edge, enterprise-level software.

Skills and Certifications

Skills and Certifications

SKILLS

Databases and Integration: SQL Server, BizTalk 2010, SSIS, SSRS, Business Objects, JasperServer, Excel, Access

Development: C#, VB.NET, T-SQL, WCF, SOAP, REST, XML, ASP.NET, DotCMS, HTML, Visual Studio, TFS Build Server

EDUCATION

Pursuing EMT-Basic Certification. Expected graduation date: 02/2016

Pursuing Home Health Aide Certification. Expected graduation date: 08/2015

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

Software Developer, Self-Employed

Rockford, MI — 10/2013 – Present

Provide software development, migration, and integration services, with a focus on .NET, WCF web services, and T-SQL

Accomplishments
  • Developed a WCF-based prototype middleware appliance 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 batch programs for ASG-ECM to assist in migration of billions of financial documents into IBM CMOD

Data Analytics Analyst, Priority Health

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

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

Advanced Information Systems Auditor, Meijer Inc.

Walker, MI — 06/2014 – 09/2014

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

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

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 International, Inc.

Lansing, MI — 2011

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 certificates

  • 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 several SSIS packages to load and combine log files in different applications and formats into a master database

Business Owner/ IT Consultant, Infinimight LLC

Kentwood, MI — 2010-2012

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 long-term support and development for Calvin College and Calvin Institute for Christian Worship websites, including administration and customization of dotCMS content management system, Velocity macros, and JavaScript code

  • Integrated Spectrum Health’s purchasing systems (Lawson and custom-made .NET systems) with license compliance tracking systems (CA APM/SWCM) using T-SQL and batch scripts, providing an automated data flow of purchasing data and automatic reconciliation to license compliance data

  • Performed software license compliance audits for clients of Shinners & Cook, P.C., while providing recommendations for remediation of BSA complaints and better compliance programs

Programmer/Analyst, Spectrum Health System

Grand Rapids, MI — 2006-2010

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 processed heterogeneous data from SQL Server databases, Active Directory (AD), CSV files, eDirectory, Lawson, and ZENworks, and provided automated notifications to management as well as forced removals when needed

  • Created an ASP.NET web application and web service to shorten long URLs, for use within SharePoint, e-mail and web parts

  • Created a web service to read Excel files from a file share, protected through AD security group membership (roles)

  • Created an ASP.NET web app, “Data Dictionary”, to provide end users with easy access to business definitions of Data Warehouse objects in a Google-like fashion. Developed a VBA application to synchronize Business Objects universe objects with the web app’s SQL backend

  • Created a VB.NET/SQL application to easily navigate through Spectrum Health’s organizational hierarchy using HR data

  • Implemented, maintained and enhanced ZENworks Asset Management (software and hardware tracking & inventory)

  • Enhanced a VB.NET/SQL application with label printing, automatic importing of vendor price sheets, pop-up product catalog, license data exporting into ZENworks Asset Management, and synchronization with Lawson software, saving over 20 hours per week in manual data entry

  • Setup JasperServer (BI server) with Active Directory authentication. Designed several reports in iReport for procurement, license tracking and budget reporting

  • Created a Business Objects universe and Web Intelligence reports for IT quality metrics and incident management reporting from CA ServiceDesk

Computer Tutor, Grand Rapids Community College

Grand Rapids, MI — 2005-2006

Tutor students in programming (C++, VB.NET, Bash), Systems Administration (Linux, Windows Server), and Telecommunications

LEADERSHIP AND VOLUNTEER EXPERIENCE

  • Skilled Nursing Assistant (Hi-Tech Aide), Rockford, MI, 2013 to present

    • Provide attendant care services to a family member with a severe spinal cord injury. Care provided includes wheelchair transfers, straight catheterization, activities of daily living (ADLs), mobility, and general safety
  • 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

  • Senior Capstone Project: A Secure Network of Robots. Davenport University, MI, 12/2008

    • Designed and built three small robots with Basic STAMP microcontrollers and wireless networking

    • Designed a security protocol for encrypted communication and intrusion detection

  • Presenter, “How Do Hackers Do It?” Spectrum Health, MI, 2008

  • Presenter, “Protecting Yourself from ID Theft on the Internet.” Spectrum Health, MI, 2006

  • Vice President, Computer Club. Grand Rapids Community College, MI, 2004-2005

    • Organized a free computer repair clinic, “PC Clinic”

  • Presenter, “Google Hacking 101.” Grand Rapids Community College, MI, 2004

CERTIFICATIONS

Heartsaver CPR, AED, First Aid. Valid through 07/2017

Basic Life Support for Healthcare Providers. Valid through 04/2017

CompTIA Network+. 12/2008

CompTIA Security+. 08/2007

ACCOLADES

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

  • Administrative Support Concepts

  • Computer Security

  • C++ Programming

  • VB.NET Programming

BPA Michigan Leadership Conference Winner, MI, 2008:

  • C++ Programming

  • Information Technology

  • Computer Security

  • VB.NET Programming

BPA Michigan Leadership Conference Winner, MI, 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. MI, 2008

Novell ZENworks Asset Management Advanced Training. MI, 2006

 

Contact Information

Contact me online at http://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 daddy and a faithful Christian. He is always eager to contract with faith-based nonprofits! Learn more.