Glen Hinckley
Software/EDI/Data Architect
Contact
Address
Keller, TX, 76248
Phone
(407) 590-3821
E-mail
ghinckley@glenhinckley.com
Skills

    EDI/X12
Excellent

HL7
Excellent

Query Writting
Excellent

SQL
Excellent

Backend design
Excellent

Software design
Excellent

ETL development
Very Good

Machine learning
Good

Data visualizations
Excellent

Debugging
Very Good

System Software/EDI/Data Architect and Engineer with 25+ years’ experience in secure software design and troubleshooting. Proven ability to write mission critical software and systems. Architect from back-end database through UI layer. Expertise in designing, writing, and maintaining highly complex software systems in either vertical or distributed architectures.

Skills
  • Cloud Technologies: AZURE , AWS
  • X12 EDIFACT / EDI 204, 210, 211, 214, 270, 271, 276, 277, 278, 820, 835, 837, 834, 940, 945, 943, 944, 990, 997, 999, HL7
  • Reporting / Data Anliticys: Power BI, Tableau, SSRS, Crystal Reoports, Oracle Reports
  • Logic Aps, UI Path, Biztalk, RPA
  • Software / Languages: Net 1 – 6 MVC, MVVC, WCF, WPF .NET Core, .NET Standard, Microsoft Visual Studio.NET ASP.NET .NET Framework, COM, DCOM, MTS, Microsoft Visual Basic 3, 4, 5, 6, VB.NET, Microsoft C# 2.0 – 5.0, XML, JavaScript, Java, JSP, Java Spring forms, CLI and GUI apps, C/C++ MFC, GCC 2.x 3.x, OWL, SharePoint, RPG CL JCL
  • Databases: Microsoft SQL Server 6x, 7, 2000, & 2008 2012, 2014, Oracle 7.3, 8, 8i, 9i, 10g, 11g, & 19c Oracle Forms & Oracle Reports, InterBase, db2 AS400 iseries
  • Operating Systems: Unix (Solaris, HPUX), Linux, AS400 SR3.x - SR5.x 6.x
  • Testing / Tracking: Test Complete, Metaspoilt, kali Linux, HP Service Test, HP Quality Center, LoadRunner, Microsoft Test tools in Visual Studio, JIRA, bugzilla and other bug and defect agile tracking
  • Sybase Power Designer, Embarcadero ER Studio, Embarcadero DB Artesian
Work History
2007-03 - 2007-03
2022-03 - 2022-08
Borrego Health: Medical Clinics | California EDI Contractor
  • Performed analysis of walgreens 340b program
  • Wrote ETL CLI app in C# to import 21M records in  8000+ files.
  • Indentified failure mode's of current solution
  • Wrote a new solution fixxing issuesn this was done as a C# winform app.
  • Resubmited two years worth of data recovering over 65k unpaid prescriptions, this was done using a c# CLI app to write out a flat file in walgreens format.
  • On going support and maintance
2007-03 - 2007-03
2022-03 - 2022-11
Lanter Delivery Systems inc, EDI Contractor
  • Forensic analyses/reverse engineering/documenting
  • DB, Functions, SP and apps
  • Logic Apps
  • Biztalk reverse engineering
  • FTP Scripts with Power shell
  • Wrote several C# azure functions that can make flat files that connet to bot cloud and on primise dbs.
2007-03 - 2007-03
2020-10 - 2021-01
MANDGS Contractor
  • Wrote eBay CRM app that uses eBay, FedEx, UPS, USPS, and PayPal APIs to track sells, inventory, purchasing and shipping
  • Uses Angular, MVC and rest API for its front end
  • Has an android app that they use in shipping, packaging and receiving?
2007-03 - 2007-03
2013-07 - 2020-02
DCS Global Systems Plano Tx Senior Programmer/ Data Architect / EDI Architect
  • Designed and wrote EDI 270,271,276,277,278,835,837 parsing engines
  • The EDI parsing engine was built from the ground up in code with no external components
  • It is delivered as a .Net dll that can be added to the toolbox in Visual Studio or just invoked with a using method
  • It can parse all 5010 and older formats and has support for 6010, 6020 once it is finalized
  • Designed and wrote EDI 270,271,276,277,278,835,837 Viewers, this takes the parsed data from the db and makes a human readable HTML display
  • Designed and wrote EDI communications modules that can send and receive EDI with TPAs
  • Designed and wrote HL7 data stream receiver/server using raw TCP/IP stack
  • Setup TPAs with all 50 states, CMS, TRICare, Anthem, Availilty, Centene, Dorado, Emdeon, HighMark, Ivans and others
  • Provided documentation on how to use stack and training as required
2007-03 - 2007-03
2016-01 - 2018-01
Security Architect / Engineer
  • Implemented firewalls between groups6, replaced the cisco PIX firewalls with SonicWall’s
  • In 2017, started work on getting us ready for the first HITRUST audit
  • First part was ruining pen testing on the software stack, and network hardening and running attacks on it and then patching and fixing as necessary
  • Implemented Metasploit to do penetration testing
  • Used kali linux to test network vulnerabilities.
2007-03 - 2007-03
2013-01 - 2015-01
Infrastructure Architect / Engineer
  • Transformed the environment from one of bare metal boxes into a Hyper-V environment
  • In 2015 I replaced all the layer 2 switches with layer 3 procurves and configured vlans to segment the company into different network groups.
2007-03 - 2007-03
2011-10 - 2013-01
Walt Disney World Orlando Fl Contractor
  • Db2 to Oracle Data scrubbing and integrity project conversion
  • Converted an app called the zulfi solution to a.NET front end and jboss server app
  • The app was a collection of 92 queries and 92 fallout queries that ran as a db2 stored procedure
  • The queries in the app checked for thing such as missing foreign and primary keys, missing business logic, made sure that related tables had been populated and keys where correct
  • The avg query had 10 to 30 joins on an avg of 5 to 15 tables
  • Quires would return number of errors found and other criteria that was inserted into a table
  • The SP then took that table and ran another set of queries based on the original that went out and populated the result tables with the suspect records
  • This app would take on avg 30+ hours to run; it ran against the entire WDW data set looking thru some 300M records
  • Ongoing support and maintenance
2007-03 - 2007-03
2011-02 - 2011-06
World Wide Interactive Services Orlando Fl Contractor
  • ASP.NET Conversion
  • Coordinated with web designer to redo front end for Credit Union Software
  • Simple redesign but old web site was hodgepodge of technology
  • Mostly odd use of the table control to make a lot of tags
  • Fixed all the table controls to render standard HTML table
  • Replaced obsolete java script with jquery
  • Fixed and repaired the primary DB2 server
  • Advised and coordinated with staff to design a cloud based service to deploy there product.
2007-03 - 2007-03
2008-03 - 2009-08
Florida Wildlife Commission Contractor
  • Foxpro to C# Conversion
  • Rewrote the existing Foxpro app as a web based C#
  • This app tracks and maintains all hunting and fishing licenses in the state of Fl
  • This app had to collect data from a db2 system in Kentucky parse the data print the cards and track interest and current value of the license
  • The Foxpro app was an ongoing effort from several previous programs over the last decade and had no documentation or any programmers that experience with it
  • All the business rules were put in separate DLLs so they could be reused in the future for this or other projects that the same type of data
  • The new app could pull and parse the data in about 2 mins as opposed to over an hour for the old system.
Education
University of Central Florida - Orlando, FL
Valencia Community College