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
Objective

To obtain a Senior EDI Architect position in the Healthcare industry, where my extensive experience in EDI integration, expertise in healthcare systems, and knowledge of the Azure platform can be utilized to provide efficient and effective solutions to the organization. Additionally, my proficiency as a Senior DB Architect with experience in DB2 iSeries, Oracle, and MSSQL, and expertise in ERWIN and ER/Studio, can add value to the organization.

Summary:

Highly skilled Senior EDI Architect with over 20 years of experience in designing, implementing, and managing EDI solutions for healthcare organizations. Expertise in various EDI standards, including X12, HL7, NCPDP, and DICOM. Proficient in healthcare systems, including EHRs, EMRs, and practice management systems. Knowledgeable in the Azure platform, including Azure Logic Apps, Azure Functions, and Azure API Management. In addition, extensive Senior DB Architect experience with proficiency in DB2 iSeries, Oracle, and MSSQL, and expertise in ERWIN and ER/Studio. Excellent leadership and project management skills, with a proven track record of successful project completion and delivery.

Skills
  • Expertise in EDI integration and various EDI standards, including X12, HL7, NCPDP, and DICOM.
  • 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
  • Knowledge of HIPAA and other regulatory requirements related to healthcare data.
  • Proficiency in healthcare systems, including EHRs, EMRs, and practice management systems.
  • 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
  • Expertise in ERWIN and ER/Studio for data modeling, data architecture, and database design.
  • Excellent leadership and project management skills, with a proven track record of successful project completion and delivery.
  • Strong communication and collaboration skills to work with internal teams and external partners.
  • Knowledge of HIPAA and other regulatory requirements related to healthcare data.
  • Ability to troubleshoot technical issues and provide guidance and support to DBAs, data analysts, and developers.
  • Experience in developing policies, procedures, and training materials related to data governance and compliance.
Work History
2007-03 - 2007-03
2023-01 - 2022-01
Borrego Health: Medical Clinics | California EDI/Database Contractor
  • Conducted an in-depth analysis of Walgreens 340b program, identifying multiple failure modes within the current solution.
  • Developed and wrote a new solution that addressed these issues and provided a more effective way to manage and maintain the program.
  • Successfully resubmitted two years' worth of data, resulting in the recovery of over 65,000 unpaid prescriptions.
  • Provided ongoing support and maintenance for the new solution to ensure continued efficiency and compliance with regulatory requirements.
  • As part of my work, I utilized my expertise in database design and development, EDI solutions, and project management. I also collaborated with other stakeholders, including Walgreens' IT team, program managers, and healthcare providers, to ensure successful implementation and operation of the new solution.
  • Utilized ER Studio to reverse engineer a ProgressDB for an EMR vendor who had no ER diagrams or knowledge of any PK/FK pairs.
  • Designed and implemented a process to move all data from the EMR database to SQL Server on a nightly basis..
  • Wrote stored procedures to generate PK/FK pairs for the EMR vendor's clustered keys in lieu of primary PK/FK pairs..
  • Designed and developed a data warehouse to enable stakeholders to access analytics through Tableau.
  • Providing ongoing support and maintenance to ensure the smooth functioning of the system.
2007-03 - 2007-03
2022-03 - 2022-11
Lanter Delivery Systems inc, EDI/Database Contractor
  • Forensic analysis, reverse engineering, and documentation of databases, functions, stored procedures, and applications related to the shipping industry.
  • Designed and implemented Logic Apps to automate data integration processes between various systems.
  • Designed and developed Logic Apps for EDI 204, 210, 211, and 214 mapping, utilizing Azure Integration Services.
  • Conducted reverse engineering of BizTalk solutions to identify and document system architecture, message flows, and data mappings.
  • Developed FTP scripts using PowerShell and WinSCP to securely transfer files between systems and partners.
  • Wrote Azure Functions to create flat files from data extracted from both on-premises and Azure databases, providing a scalable solution for file creation and transfer.
  • Provided consultation on EDI-related projects and technologies to clients in the shipping industry.
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 implemented a comprehensive database solution for storing large volumes of data, which catered to multiple data consumers such as a web front-end and analytics via PowerBuilder and Tableau. Custom C# CLI apps were used for ETL operations.
  • Developed a highly efficient EDI 271 parsing stored procedure, comprising 13,000 lines of code, which enabled easy CRUD operations in a single stored procedure.
  • Designed and developed EDI 270,271,276,277,278,835,837 parsing engines, which were built from the ground up in code, without the use of external components. The EDI parsing engines are delivered as .Net DLLs that can be invoked with a simple using method, and support all 5010 and older formats, with support for 6010 and 6020 planned for once it is finalized.
  • Developed EDI 270,271,276,277,278,835,837 viewers, which parsed data from the database and presented it in human-readable HTML display.
  • Created EDI communication modules for sending and receiving EDI with TPAs, streamlining the process and making it more efficient.
  • Designed and developed a HL7 data stream receiver/server using a raw TCP/IP stack, which facilitated efficient transfer of data.
  • Successfully established TPAs with 50 states, CMS, TRICare, Anthem, Availilty, Centene, Dorado, Emdeon, HighMark, Ivans and other relevant entities, thereby facilitating efficient data exchange.
  • Provided extensive documentation on how to use the stack and delivered training as required, empowering users to utilize the system to its full potential.
  • Mentored and trained new employees, facilitating their successful integration into the organization and promoting a positive and productive team culture.
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 Senior Database Architect
  • As a Senior Database Architect, I have extensive experience in managing complex data scrubbing and integrity projects, with a focus on Db2 and Oracle systems. One such project involved converting the Zulfi solution, which ran across 21 Db2 servers on 4 continents, to a .NET front end and JBoss server app.
  • Using my expertise in ERwin, I was able to reverse engineer the Zulfi solution and identify areas for improvement in data integrity. The Zulfi solution itself was a collection of 92 queries and 92 fallout queries that ran as a Db2 stored procedure. These queries checked for various issues such as missing foreign and primary keys, missing business logic, and incorrect keys in related tables.
  • On average, each query involved 10 to 30 joins on 5 to 15 tables and would return the number of errors found and other relevant criteria, which was then inserted into a table. The stored procedure would then take this table and run another set of queries based on the original, which would populate result tables with suspect records. This entire process could take over 30 hours to run and involved analyzing a dataset of over 300 million records.
  • Additionally, I provided ongoing support and maintenance for the Zulfi solution to ensure its continued effectiveness and efficiency. My expertise in database architecture and data integrity allowed me to successfully complete this project and provide valuable insights for future improvements.
2007-03 - 2007-03
2011-02 - 2011-06
World Wide Interactive Services Orlando Fl Contractor
    ASP.NET Conversion and Database Maintenance
  • Collaborated with a web designer to revamp the front end of Credit Union Software to improve user experience
  • Streamlined and standardized the web site's HTML table rendering, replacing an outdated table control method
  • Upgraded the web site's java script with JQuery to ensure compatibility with modern web browsers
  • Provided maintenance and repair to the primary DB2 server to ensure seamless data management
  • Offered guidance and worked with staff to design a cloud-based service to deploy the product to customers
  • Trained and mentored staff on best practices for web development and database maintenance techniques to enhance their skills and productivity
  • Achieved seamless deployment of the product and provided ongoing support and maintenance to ensure its smooth operation.
2007-03 - 2007-03
Database
2008-03 - 2009-08
Florida Wildlife Commission Database Contractor
  • Foxpro to C# Conversion
  • Redisigned the Foxpro db and convert it to SQLServer 2005.
  • I used ER studio to resvereng the foxpro db and then generated a new SQL 2005 model from it.
  • 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