Resume

Skills

• Business – Information Technology procurement, software license compliance tracking, technical writing

• Databases – Business Objects universe development; JasperServer, MS SQL, Access; database design, report and dashboard development in Crystal Reports, iReport, Excel and Web Intelligence

• Networking – LAN setup and troubleshooting, network traffic analysis, Windows Server 2003/2008 administration, ZENworks Asset Management (ZAM) administration, Linux administration

• Office – Advanced knowledge on Microsoft Access, Excel, InfoPath, Publisher, PowerPoint, Visio, Word, and Visual Basic for Applications. Working knowledge of OpenOffice, LibreOffice, KOffice, and GIMP

• Programming – Procedural and object-oriented (OOP) programming using C++, JavaScript, GAMBAS, Pascal, PBASIC (embedded), Tcl/Tk, T-SQL, VBA, VB.NET, XML, X++, and several other languages

• Security – Foot printing, safe programming, WEP/WPA2 configuration, server hardening

• Web Development – ASP.NET, CSS, DotCMS, Elgg, IIS, JavaScript, Velocity, Web Services, WCF, WordPress, XHTML

Education

• Graduate coursework in Computer Architecture and Database Design. Grand Valley State University (Grand Rapids, MI). Completed 09/2009

• Bachelor of Science – Network Security. Davenport University (Grand Rapids, MI). Graduated 05/2009

• Associate in Arts – Computer Information Systems, Network Administration. Grand Rapids Community College (Grand Rapids, MI). Graduated 05/2007

Professional Certifications and Security Credentials

• Merchant Marine Credential, Ordinary Seaman/Steward, Unlimited Tonnage Ratings (Domestic), Deck Cadet. United States Coast Guard, 01/2011

• Transportation Worker Identification Credential (TWIC). Transportation Security Administration (TSA), 11/2010

• Network+ Certified Professional. CompTIA, 08/2008

• Security+ Certified Professional. CompTIA, 08/2007

Professional Experience

Web Technician — Calvin College/Calvin Institute of Christian Worship 10/2011 – Present

• Support and maintain the Calvin Institute of Christian Worship website

• Web development for DotCMS using Velocity, HTML, CSS, JavaScript, JQuery, Lucene and SQL

• Project Highlights:

  • Developed the search functionality for several content structures, including advanced filters for authors, related content, and tags, leveraging Lucene fuzzy and proximity searches

Application Developer – Two Men and a Truck International, Inc. 01/2011 – 06/2011

• Microsoft Dynamics AX development in X++ and VB.NET/C# through .NET Business Connector

• Application and web development in .NET, including WCF and REST-based web services

• Report design and ETL programming using SQL Server 2008 reporting and integration services (SSRS, SSIS)

• Project Highlights:

  • Created an interactive, easy-to-use financial reports package for U.S. franchises using SSRS

  • Installed and customized Corendal Directory to allow the Service Desk team to manage Active Directory using a web-based interface. Created extensive documentation and training materials

  • 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 a web service and a prototype Android application for accessing Dynamics AX via HTTPS/SSL

IT Consultant – Infinimight LLC 04/2010 – Present

• Manage and market Infinimight LLC, my own IT consulting firm. Find contracts and sales leads

• Provide consulting services including database design, data migration, software development, Windows server support, and software license compliance tracking and auditing

• Project Highlights:

  • Provide on-going 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 Velocity/JavaScript widgets

  • Integrate purchasing systems (Lawson and home-grown .NET systems) with license compliance systems (CA APM/SWCM) for Spectrum Health using MS SQL and batch scripts, providing an automated data flow of purchasing data and automatic reconciliation to license compliance data, for a time savings of 20 minutes of data entry per license record.

  • Perform 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 Hospitals 06/2009 – 05/2010

• Business Objects universe development, data validation, and security administration

• Application, web and database development in ASP.NET, VB.NET, Access/VBA, Microsoft SQL Server (Transact-SQL), and batch scripting

• Application Support, server upgrades and customer support for SPSS PASW Data Collection, ABA National TRACS Burn Registry and Stratacap Financial Planning

• Project Highlights:

  • Documented Data Warehouse environment. Created alerts and probes to monitor and track the performance of Windows, Web and Business Objects servers

  • Created a web-based Data Dictionary to provide end users with easy access to business definitions of Data Warehouse objects. Developed a VBA application to synchronize Business Objects universe objects with this Data Dictionary automatically

  • Implemented a PASW Data Collection server and SQL database back-end for enterprise creation, publishing and analysis of web-based and telephone-based surveys

  • Created a web service to read Excel and user-supplied data from Xcelsius dashboards

  • Created a web application and web service to shorten long internal URLs

Analyst – Spectrum Health System 12/2007 – 05/2009

• Application, web and database programming in support of IT and business functions (VB.NET, C#, ASP.NET, PHP, C++, T-SQL, MySQL, JasperServer, Jasper Reports, IIS server, MS SQL server, Access, Excel, Crystal Reports, Business Objects)

• License Compliance Tracking and monitoring for thousands of software titles.

• Procurement of client and server technology (software, hardware and services)

• Project Highlights:

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

  • Setup a JasperServer environment with Active Directory authentication. Designed several reports in iReport for procurement, license tracking and budget reporting

  • 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

  • Created several ASP.NET and SharePoint sites, including interactive department pages, auction sites, voting applets, Jasper Reports dashboards and event sign-up pages

Information Integrity Technician – Spectrum Health System 08/2007 – 12/2007

• ZENworks Asset Management implementation, data migration, administration, and troubleshooting

• Software license compliance

  • Research and document legal right to use for thousands of applications

  • Process and approve internal requests for new applications and upgrades

  • Proactively monitor compliance through ZENworks Asset Management, home-grown Access and SQL databases, eDirectory tools, NWAdmin, Active Directory, spreadsheets, VBA and Crystal Reports

  • Coordinate work with vendors, customers, and analysts to quickly resolve any compliance issues

• Procurement of all client and server technology. Place and reconcile credit card orders

• Project Highlights:

  • Managed application footprint creation process to increase software recognition

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

  • Created a C# application to update an LED sign through a secure web interface

  • Created an illegal software tracking database that processed heterogeneous data from Access, Active Directory (AD), CSV files, eDirectory, Lawson, Microsoft SQL Server and ZAM

Asset Management Intern – Spectrum Health System 04/2006 – 08/2007

• Software license compliance

  • Research and document legal right to use

  • Develop compliance reports through SQL queries, Excel/VBA and Crystal Reports

  • Programming of database applications in PHP, T-SQL, VB.NET, Access, VBA, and Tcl/Tk

  • Write and revise business processes and policies

• Procurementof all client and server technology. Place and reconcile credit card orders

• License reconciliationof over 2,000 applications, saving $200,000 in licensing costs

Computer Tutor – Grand Rapids Community College 09/2005 – 05/2006

• Tutor students in programming (C++, QBasic, Visual Basic, Bash), Unix Administration, Telecommunications, LAN/WAN, Web Design, and Microsoft Office

• Provide assistanceto students with technology use, mathematics, and Spanish

• Provide first-level supportat the Student Technology Help Desk as needed

Languages

• English

• Spanish (native speaker)

Training, Awards and Leadership Experience

• Microsoft Courses 80011, 80012, 80013, 80014: Development in Microsoft Dynamics AX, NetCom, Las Vegas, NV, March 2011

• Volunteer Crew Member, United States Coast Guard Auxiliary, Grand Rapids, MI and Muskegon, MI, 01/2011 to present

• Presenter, “Dissecting a Computer Virus,”Spectrum Health and Davenport University, 02/2009

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

  • Designed and built three explorer robots with Basic STAMP micro controllers

  • Added wireless communication via serial XBee modems

  • Designed a security protocol for encrypted communication and intrusion detection

• Business Professionals of America (BPA) National Leadership Conference, Reno, NV 2008

  • Administrative Support Concepts – 2nd place

  • Computer Security – 3rd place

  • C++ Programming – finalist

  • VB.NET Programming – finalist

• Microsoft Course 2559B: Introduction to Visual Basic .NET Programming with Microsoft .NET, Computer Products and Resources (CPR), Grand Rapids, MI, March 2008

• Business Professionals of America (BPA) Michigan Leadership Conference, Davenport University, 2008. National Leadership Conference qualifier

  • C++ Programming – 1st place

  • Information Technology – 2nd place

  • Computer Security – 3rd place

  • VB.NET Programming – 3rd place

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

• Business Professionals of America (BPA) Michigan Leadership Conference, Northwood University, 2007. National Leadership Conference qualifier

  • Computer Security – 1st place

  • C++ Programming – 1st place

  • Fundamentals of XHTML – 2nd place

  • Database Design – 4th place

• Novell ZENworks Asset Management Advanced Training, Spectrum Health, 12/2006

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

• Project Management 101, Spectrum Health, 2006

• Vice President of Computer Club at Grand Rapids Community College, 2004-2005

  • Organizer of an extremely popular computer repair clinic, “PC Clinic,” Grand Rapids Community College, Grand Rapids, MI 2004-2005

  • Club representative at Student Congress and at the 2005 GVSU Leadership Conference at Grand Valley State University, Allendale, MI 2005

• Presenter, “Google Hacking 101”, Grand Rapids Community College, 11/2004

Contact Information

Contact me via e-mail at gabriel_resume@mongefranco.com or online via this contact form.  For contract opportunities, please visit my company web site at:  http://www.infinimight.com.

Electronic Versions

• Gabriel Mongefranco’s Resume – PDF Version
• Gabriel Mongefranco’s Resume – Open Document Version
• Gabriel Mongefranco’s Resume – Word Version