Eric Cox
Data Engineer } SQL | ETL/ELT | C# | HealthCare EDI X12 | Mentor | Funny, Kind, Patient
- Role
- Lead Database Developer at TransUnion
- Location
- Austin, TX, US
- LinkedIn followers
- 500 followers
About Eric Cox
I am a data engineer and senior developer with deep experience building, optimizing, and…
Experience
Lead Database Developer
Sep 2009 — Present · Austin, TX, US
Implement data solutions using Microsoft technologies (C# and SQL) as part of an Agile development team utilizing both Scrum (sprint iterations for projects) and Kanban. Design, create, populate and test normal, dimensional and fact tables. Extract, transform and load (ETL) production data between a number of data sources and SQL 2016 databases using SSIS, SQL and C#. Monitor and correct data quality problems, validate, match and de-duplicate data. Troubleshoot problems and tune T-SQL queries. Develop and maintain a set of tools which generates X12 formatted files from data in a Microsoft SQL 2016 database, transfers the files to/from other entities and loads the returning X12 data back into SQL (16,789 tables with 4 to 28.4 billion records each).Accomplishments- Invented and implemented a new client testing framework which enables quick and parallel development of multiple client projects- Created numerous SQL templates and scripts to automate redundant tasks- Invented and created C# code to search through data files and pull out specific blocks based on numerous settings. This enabled a search through thousands of files for a data pattern and the output of results in various ways (file name, full path, data block, data with surrounding x lines)- Solved a data file location problem by creating a C# application to find misplaced files and remap them in the database.
Education
The University of Texas at San Antonio
Masters of Science, Management of Technology
1998 — 2000
Wright State University
MS (Not completed), Computer Science
2008 — 2008
The University of New Mexico
Bachelor of Science, Electrical Engineering
1988 — 1992
Skills
- Oracle
- Ssis
- Database Development
- T-Sql
- Databases
- Data Warehousing
- Sql Server
- Sql
- Database Design
- Etl
- Software Development
- C#
- .net
- Agile Methodologies
- Microsoft Sql Server
- Visual Studio
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.