Robert McHenry
Columbia,TN
Summary
Experienced SQL Developer with expertise in database administration, programming, project management, and customer relations. Proficient in optimizing database performance, designing complex reports, and implementing disaster recovery solutions. Skilled at leveraging technical expertise to drive efficient and reliable data management systems.
Overview
19
19
years of professional experience
1
1
Certification
Work History
Senior Consultant/Developer
RSI
08.2021 - 01.2024
- Streamlined the development process for SQL Server reports and procedures
- Enhanced data processing capabilities by integrating Azure services for real-time operations
- Managed the creation and maintenance of detailed reports through SSRS and Power B
- Generated in-depth reports by extracting and analyzing data from various databases with sizes between 10G and 20G.
SQL Developer
HCA
01.2021 - 04.2021
- Achieved optimization in query execution and created visually appealing reports by leveraging SSRS and Power BI.
- Conducted comprehensive analysis and fine-tuned databases for optimal performance
- Executed migration and enhancement of database structures for optimal performance.
SQL Developer
Cigna Health Springs
02.2019 - 12.2020
- Enhanced efficiency through analysis and optimization of SQL queries and database structures
- Collaborated on XML integration assignments, simultaneously verifying SSO
- Achieved efficient data migration by implementing the development and testing of SSIS packages for databases containing millions of rows and multiple columns. This led to a substantial increase in database sizes from 10G to 20G.
SQL Developer
CHS
09.2018 - 12.2018
- Managed successful migration of 20,000 databases to SQL Server 2016
- Ensured data integrity and optimized stored procedures.
SQL Developer
AO Smith
03.2018 - 07.2018
- Ensured accuracy of reporting through thorough validation of data migration.
- Expertly oversaw disaster recovery operations on various platforms.
SQL Developer
Vertec Solutions
12.2017 - 02.2018
- Executed efficient data loading and processing operations for SQL Server databases
- Employed SSIS to streamline the process of converting and integrating data.
SQL Developer/DBA
Frost-Arnett
09.2017 - 11.2017
- Increased database performance while ensuring security measures were implemented.
- Designed and implemented ETL functions to facilitate data migration.
SQL Developer/DBA
My Nexuscare
02.2017 - 07.2017
- Safeguarded databases by effectively managing data backup and implementing stringent security measures.
- Optimized reporting and ETL functions by employing PL/SQL and T-SQL.
SQL Developer/DBA
DCI Inc.
03.2015 - 01.2017
- Demonstrated expertise in managing database performance and implementing successful Lawson upgrades.
- Restructured applications and procedures for enhanced financial reporting.
Program Development
LTOnline
08.2004 - 11.2014
- Successfully executed the conversion process for SQL Server to Oracle applications.
- Streamlined operations by optimizing the performance and strengthening the security measures for a comprehensive set of 87 databases, comprising of 83 SQL Server and 4 Oracle databases
- Implemented the use of ColdFusion, JavaScript, and .NET in the development of dynamic web applications.
Education
Bachelor of Science -
Northern Arizona University
Flagstaff, AZComputer Science -
Eastern Arizona College
Thatcher, AZSkills
- Databases: SQL Server (2016), Oracle (11G)
- Programming: T-SQL, PL/SQL, SSRS, SSIS, Power BI, IBM DB2, HTML, Oracle SQL, JavaScript
- Tools: Tableau, Informatica ETL, Visual Studio, SSMS
- Operating Systems: DOS, UNIX, VM, OS/2, Novell, MVS, Excel
- Other: ETL, High Availability, Disaster Recovery, Azure Stream Analytics, Azure App Service
Certification
- AI Essentials, 07/2024
- Oracle PL/SQL Trained, New York, New York
Timeline
Senior Consultant/Developer
RSI
08.2021 - 01.2024
SQL Developer
HCA
01.2021 - 04.2021
SQL Developer
Cigna Health Springs
02.2019 - 12.2020
SQL Developer
CHS
09.2018 - 12.2018
SQL Developer
AO Smith
03.2018 - 07.2018
SQL Developer
Vertec Solutions
12.2017 - 02.2018
SQL Developer/DBA
Frost-Arnett
09.2017 - 11.2017
SQL Developer/DBA
My Nexuscare
02.2017 - 07.2017
SQL Developer/DBA
DCI Inc.
03.2015 - 01.2017
Program Development
LTOnline
08.2004 - 11.2014
Bachelor of Science -
Northern Arizona University
Computer Science -
Eastern Arizona College
Similar Profiles
Tishana NashTishana Nash
Direct Support Professional at RSIDirect Support Professional at RSI
Adam RowlandAdam Rowland
Learning Technology Professional at RSILearning Technology Professional at RSI
George KonstantinidisGeorge Konstantinidis
Senior Product Manager at RSISenior Product Manager at RSI