DENTON E. HINDS

NASHVILLE, TENNESSEE ***** 615-***-****

SQL DEVELOPER

Technically oriented SQL Developer/Senior Systems Analyst with an extensive and proven track record of success, most recently in the Healthcare industry as a Healthcare Data Engineer. Led ETL processing for all incoming and outgoing data to/from the Care Management EMR system at Navi Health.

SKILLS

•Expert with PL/SQL or Transact-SQL, SQL Stored Procs, Views, Functions, Triggers, Indexes and Constraints.

•Expertise–Data Conversion, Migration, ETL processes Microsoft SSIS.

•Developed and Supported EDI (X12 to GIG MTF) Interface and CorePoint.

•Databases: MSSQL-Server, Oracle, MySQL, PostgreSQL, Ingres, HP’s Image, MS Access.

•Languages: VB, C, Perl, Cobol, PHP, VB for Applications, Visual Basic Studio, Amazon S3 Cloud Service & API.

•OS: Microsoft, Unix, Linux, HP3000’s MPE.

•Version Control: GIT, CVS, SVN-Tortoise, TFS, and BitBucket SourceTree, SkyBot Scheduler.

•Atlassin Products: JIRA, BitBucket, SourceTree, Confluence.

•HealthCare Systems Exports: AllScriptsPro, NextGen, Greenway Intergy EHR, PrimeSuite, McKesson HPF (Horizon Patient Folder), GE Centricity–GERIS (Radiology Information System), GECPN (Centricity Perinatal).

•Auto-IT scripting to automate–Windows GUI simulation.

•Advanced features of Excel and Access.

•Work directly with End Users.

•Present technical topics clearly.

•Excellent Oral & Written Communication.

•Very Customer Service Oriented.

•User Training and Documentation.

•Excellent Root Cause Analysis & Solution Design.

EXPERIENCE

Navi Health (Optum/UHG), Brentwood, Tennessee November 2020–April 2023

Data Exchange Team-ETL

DATA EXCHANGE ENGINEER

•Led development of SQL Stored-Procedures and SSIS Packages, to support the ETL processes to and from clients, partners, and vendors.

•Most of our ETL processes used a Custom Configurable Workflow to Transform and Load data into ‘Raw’ Tables from any format that was supplied: flat-files, delimited-files, CSVs, Excel, XML, EDI. These tables are left as the partner supplied them but are then Transformed into Tables for our need to go into our Care Management system.

•These Incoming and Outgoing ETL files consist of the following data: Provider, Census, Eligibility, Beneficiary, Authorization Requests Acknowledgements and Appeals, Final DRG (Diagnostic info), Plan RX, Hospital Claims, Plan Claims, Master Reference Data, External Vendor Data, Case Management, Data Management, Vendor Facility, Patient Support, Clinical Documents, and miscellaneous files.

•Developed and Maintained SSIS packages to move Tables from our Production ETL environment to other production environments such Data Warehouse and our Care Management CRM platform. Also maintained the scheduling and automation of these processes.

•Used BitBucket-GIT & SourceTree (along with Tortoise) Version Controls for all the SQL objects. Maintained "Branch Integrity" between my Feature-Branches and the current Release-Branch as well as the Main/Trunk-Branch. Octopus software was used to deploy the Release-Branch of code to multiple environments at once.

•Primary developer in converting to a new vendor that supplies vital healthcare industry Master Data of all Providers in the US: Hospitals, Clinics, Facilities, Affiliates, Doctors, and Associations. The import files include data on Professional Specialties and Organization Affiliations, Accreditations, Licensing, Pharmacy and Prescription data, as well as Entity-Organization and Parent Company information.

•Maintained internal Audit Tables and their corresponding SQL-CDC Tables when changes are made to the source tables. The Audit Tables are copies of the CDC Table, allowing the archival of the data longer as the CDC Tables are flushed regularly.

•Set up internal jobs and Stored-Procedures to Audit and Purge certain tables using an age-variable specific to each table. This process required the scripting of the DROP of Key Constraints (using system tables, not hard coding these keys) and re-Creating them after the purge.

•Used Ecrion 3rd-party software to automate the generation of all insurance/medical/healthcare letters to the patients, populating the letters with real-time information from the database (stored-procedures/queries) and queuing them for the variable mailing processes.

•Created a new process, Tables and Stored-Procedures, to load SICC Assignments (Skilled Inpatient Care Coordinators) to Skilled Nursing Facilities in bulk, saving the users considerable time from their cumbersome input process to assign SICCs manually. This occurs with new contracts or large expansions of existing contracts into new states/facilities (multiple times each year)

•Maintained the Stored-Procedures to Down-Merge new contract data from Production to all other environments. These environments are other Production Servers as well as lower environments such as Stage, QA, UAT, DEV, HotFIX, Performance, and others.

TRINISYS, Brentwood, Tennessee November 2018–November 2020

Healthcare Document Archival/Storage and Retrieval

HEALTHCARE DATA ENGINEER

•My primary function is to migrate the client’s data and documents from the Health Care EMR system they are currently using to the Trinisys Clearview system which is focused on document archive, storage, and retrieval at a much cheaper cost to the client than their current EMR system. The process used batching and parallel processing across multiple nodes, utilizing a load-balancer.

•Familiar with the database structure of several EMR systems, querying directly to the database to extract data: McKesson HPF (Horizon Patient Folder) systems, NextGen HER/EMR systems, GE Centricity RIS (Radiology Information System), Greenway Intergy Prime suite.

•Used HTTP calls to interrogate and extract data and documents from Allscripts A4 system.

•Used Auto-IT scripting to simulate user printing of medical records from the GE CPN (Centricity PeriNatal) systems where direct access to the database is prohibited (old Windows platform). The automation being driven from a file of patient IDs, simulating a person Selecting Patients and Printer various reports.

•Used Amazon S3 API for cloud storage of documents where applicable in the scripts.

SQL DEVELOPER, April 2018–November 2018

•Using the Trinisys Convergence platform and SQL I migrate the client’s data and documents from their current Health Care EMR system to the Trinisys Clearview system for document/data storage and retrieval.

•Leveraged my SQL experience to improve the queries used to extract data from the EMR databases, using MS-SQL, MySQL, and Oracle SQL.

•Quickly transitioned into the Healthcare Data Engineer position as Trinisys does not really require a full time SQL Developer.

FRANKLIN AMERICAN MORTGAGE COMPANY, Franklin, Tennessee February 2011–April 2018

SENIOR EDI ANALYST

•My primary function has been using SQL to create ETL processes for both export and import of data to/from our many databases. Perl is the primary tool used to send or receive the data in the various formats required by the partners. Typically, we SFTP the data but email is also used frequently for data delivery.

•Developed and support ETL processes to create ULDD (Uniform Loan Delivery Dataset) XML files to the MISMO (Mortgage Industry Standards Maintenance Organization) standards, primarily used to sell loans on the secondary market to FannieMae, FreddieMac, GinnieMae, and other investors.

•One of my primary responsibilities is the monitoring and support of automated Wire Transfers that are SFTP’ed to our partner banks 4 times a day.

•Developed and supported EDI, ETL processes with our Loan Subservice for both import and export of files in various formats including XML, spreadsheets, delimited flat files, and very large monthly Bulk Reconciliation files.

•Developed and supported our import /export interface with MERS (Mortgage Electronic Registration Systems) to register loans, record transfers (beneficial rights and servicing), and keep investor and funder information up to date.

•Develop and support the export of Government Compliance data for HMDA (Home Mortgage Disclosure Act) to the CFPB (Consumer Financial Protection Board)

•Supported a DropBox process where users sent email with spreadsheet attachments to a designated email address, where a script would automatically pass the enclosure and execute the corresponding Perl script (keyed off the email subject). Primarily used to automate their data entry tasks to databases.

•Monitor and review Nagios Warnings of identified and potential error conditions of various processes in the SQL Database. Creating new Nagios procedures and warning processes when defined and required.

•Completed Microsoft training 20767–Implementing a SQL Data Warehouse, which includes SSIS.

COMMUNICATIONS TEST DESIGN INC, CTDI, Nashville, Tennessee September 1999–June 2010

(CTDI Acquired NRDC from Nortel & bridged my service)

SENIOR SYSTEMS ANALYST

•Primary support and development for the Nashville Branch of separate and customized Oracle applications for each major customer: ATT, Avaya, Nortel, Sprint/Embarq/CenturyLink, and NXO/BlackBox.

•Converted and Migrated the SQL Server database data to Oracle 10g as I replaced the old Nortel applications with CTDI’s Unix Oracle systems for our primary customers.

•Developed separate Order Management System with Visual Basic using SQL Server database and Transact-SQL for several smaller volume customers.

•Local EDI support and maintained the interface between EDI and the Order Management system.

Both inbound and outbound transactions, including 850, 855, 856, 861, and 810, as well as the 997 functional acknowledgements.

•Developed customized applications with Access and Excel, using VB for applications (VBA) for specific groups such as Customer Service and Receiving to aid them in recurring, time consuming manual tasks.

•Supported data interfaces back to the customers from the Order Management system.

•Interfaced each Oracle application to FedEx & UPS Shipping stations to look up order and address information and then pass back tracking and return tracking numbers. Automatically updating the order management system with the carrier's tracking numbers and ship method using Oracle Triggers.

•Applications were developed on Unix servers in C, using PL/SQL and TOAD software from Quest. Most systems used the 10g version of Oracle. Used CVS version control library for the source code.

•Used web-based LogiXML Reporting package to develop Views and ad-hock user reports from Oracle.

•Utilized Perl to create several much needed tools from multiple data sources such as the following:

A comprehensive Planning tool for Production giving their suggested build, run rate, minimum keep levels, all inventories, order/shipping requirements, and F/G replenishment requirements.

Notifying customers weekly and monthly of defective units they have not yet returned against advanced shipments we’ve sent them to help them avoid charges for Did-Not-Return Units.

Alerts to our Regional Stocking Locations, RSLs, of our replenishment shipments they should expect to receive soon.

Data extracts in Excel format (capable of multiple tabs) for various management reporting, automatically emailed to them.

Perl is also used to feed the above-mentioned FedEx & UPS shipping stations as well as the feed to the Billing application below.

•In depth Billing application including Invoices using Access 2000, feeding it data from the Oracle Order Management Systems. It evaluated the expected defective returns from the customer (or lack) and calculate additional charges, accordingly, taking into account the 30-day return window provided to them.

•Supported an MQSeries (IBM product) EDI interface to an Ingres database Order Management system.

•Completed training on Microsoft .NET Framework, Visual Studio 2005 software but didn’t get a chance to use it much.

ADDITIONAL RELEVANT EXPERIENCE

NORTEL, Nashville, Tennessee

SENIOR SYSTEMS ANALYST

VANDERBILT UNIVERSITY, Nashville, Tennessee

PROGRAMMER ANALYST

EDUCATION

Nashville State Technical Institute

Associates Degree in BUSINESS DATA PROCESSING

Contact this candidate