North Carolina Data Engineer
Resume:
Oxford, North Carolina, *****
******@**********.***
LinkedIn: www.linkedin.com/in/chriscombsgo
P R O F E S S IO N A L S U M M A RY
JOSEPH COMBS
S E N I O R DATA E N G I N E E R
Senior Data Engineer with over 20 years of expertise in information systems and data management. Proficient in developing complex data solutions, including ETL processes, data warehousing, and reporting across various platforms. Known for constructing enterprise data warehouses and managing large data integration projects, driving significant business improvements.
EM PLOYM E N T H ISTO RY
AUG 2022 - MAY 2024
Senior Database Developer, RegEd, Inc., Morrisville, NC
•Collaborated within an Agile team as a senior member of the Data Services group, managing data-centric activities for a SAAS regulatory compliance company.
•Developed and optimized stored procedures, triggers, and views, and designed database structures using T-SQL.
•Performed performance tuning and DevOps deployment, including SSIS ETL for loading new customers, and deployment coordination with C# business logic and JavaScript-based UI layers through DevOps pipelines.
•Conducted architectural reviews of databases and represented data services in Agile Scrum development teams.
•Provided developer consultation on database-related issues, ensuring alignment with the best Agile and DevOps practices.
•Received training in Power BI and Python but was not able to leverage in a project environment.
MAY 2016 - JUL 2022
Behavior Health Data Analyst, NC DHHS - Central Regional Hospital, Butner, NC
•Constructed a Patient Data Mart using ROCTO SQL Engine on RHEL 6 and SSIS ETL Packages in SQL Server.
•Created and delivered a comprehensive Patient Management dashboard using SSRS, facilitating data-driven decision-making across the entire hospital.
•Engaged in Data Quality and Iterative Process Improvement activities stemming from EHR data integration and reporting initiatives, ensuring high accuracy and reliability of data.
MAR 2013 - MAY 2016
Real Estate Broker, Keller Williams, Raleigh, NC
•Worked as a licensed broker as a buyer and seller agent in the North Carolina Real Estate market.
MAY 2012 - DEC 2014
Business Intelligence Consultant, Cisco Systems, Research Triangle Park, NC
•BI Program Manager for multiple projects for Cisco Services group to design & develop dashboards in Tableau using data from Teradata and Oracle data warehouses.
•Architected, built, and delivered Data Mart to deliver sales opportunity information to global sales force, using SSRS, location details of installed equipment to the appropriate teams to leverage 2 billion-dollar sales opportunity. Increased sales of $800 million sales increase were attributed to this promotional mechanism in the first 12 months of implementation.
JAN 2010 - DEC 2011
Consultant, Enterprise Network Services, Raleigh, NC
•Worked as contract resource for Alamance County LME, Watauga County LME and the Forsyth County LME over a 2-year period performing various duties to keep the organizations operational.
•Performed IT Audits for NC County Governments. Identified weaknesses in infrastructure and waste in procurement.
OCT 2002 - JAN 2010
Information Services Director, Pet Partners, Inc., Raleigh, NC
•Senior member of a start-up team in building $20 million revenue per year Property & Casualty MGA Insurance operation which had filed T&C and was licensed in all 50 states. Created, staffed, and provided leadership to the Information Systems / Information Technology department based on a rapidly changing business plan.
•Achievements included strategic planning, technical architecture design, product and vendor selection, project management, procurement, and installation of network, server, workstation hardware infrastructure. Architect & Operational Manager of in- house development of web-based software systems for supporting marketing, order entry, operations, finance, customer service call center, claims review and payment, premium collection, electronic payment processing, email marketing, document management, print operations, etc.
•Responsible for perimeter security, network security, and PCI DSS Security compliance for payment processing.
NOV 1997 - SEP 2002
Owner/Principal Consultant, Broad Reach Consulting Inc., Durham, NC
•Implemented an enterprise data warehouse for Croscill / Royal Home Fashions containing sales and marketing information for a 300+ million-dollar textile company in SQL Server.
•Constructed a data warehouse and dashboards to facilitate FAA reporting of fleet maintenance data for passenger planes using SQL Server for Midway Airlines, which was generating $280 million in revenue.
•Created a data warehouse for Glaxo Wellcome OTC group to manage the clinical trial budgets and associated activities for creating New Drug Applications to gain regulatory approval for moving patented drugs to OTC formulation. This data warehouse was implemented in Oracle for an operation generating $360+ million in revenue.
JUN 1988 - SEP 1996
Advanced Technology Consultant, GLAXO, INC., Research Triangle Park, NC
•Built portfolio tools to manage the pharmaceutical development pipeline and existing portfolio of a global pharmaceutical research company using Oracle. Built IRI/Express 4NF OLAP decision support database which provided forecasting and historical analysis of sales and promotional effects of nation-wide sales force on physician prescribing habits.
•Created Executive Information Systems platform to put implement a dashboard for senior executives distributing organizational performance metrics to their desktops using the Camshare EIS platform. Worked in Excel and wrote expense reporting app in VBA.
•Heavily involved in data-centric activities, including Data Warehousing, Data Quality, Master Data Management, Data Governance, Data Architecture, Database Design, E/R Modelling for IBM Mainframe DB/2 RDBMS.
•Wrote CICS/COBOL Pseudo Conversational code in TSO on MVS using VSMA and DB/2.
AUG 1982 - MAY 1988
Programmer Analyst, Burlington Industries, Clarksville, VA
•Worked as IBM Mainframe programmer writing batch Cobol and pseudo-conversational CICS programs in ROSCOE and TSO/ISPF. Created JCL to run batch programs. Used IDMS database and VSAM files as read-write containers. Wrote order-entry and inventory management programs, trained in MRP and JIT manufacturing models.
E D U C AT IO N
JAN 1979 - JUN 1982
BSBA in Decision Sciences, Appalachian State University, Boone, NC
S K IL L S
Azure Data Engineering
Data Management Reporting
Analytics SQL Server
Azure SQL T-SQL
PostgreSQL Agile Practices
SDLC Waterfall
Object Oriented Design Technical Management
SSRS SSIS
SSAS SSMS
Contact this candidate