Rob Hartley Email & Phone Number

• Earned SnowPro Core Certification April 2023.• Earned Azure Data Fundamentals DP-900 Certification October 2023.

Santa Ana, Ca, Us

• Created data merge and database constraint management code for a new SSDT tool being constructed to assist with the Epic insurance data conversion and upload part of the overall onboarding process for new EHR insurance provider clients. SSDT project adds test data to a large test database that includes over 200 individual tables and no pre-existing documentation.• Developed automated TSQL code generation templates for the creation of merge code for the SSDT tool described above. • Production support. SSIS ETL debug and development with Visual Studio and a client specific custom conversion tool. Over 200 .dtsx packages in production client conversion environment. All of them are required to run a single client conversion. Mainly TSQL and C# development.• Onboarding and training of new production support engineers.• Performance tuning of SSIS based custom conversion tool. Keywords:TSQL, C#, SSMS, SSIS, Visual Studio, Git, AWS, SSDT

Chicago, Illinois, Us

• Acquired, adapted, and coded VB.NET, VBA, and PowerShell based tools from the web that allow for the movement of SSRS report .rdl’s between different servers without copying over the existing ReportServer installation on the destination server as part of a BI migration effort.• Debugged existing SSRS reports and created new ones based on translation from 10+ year old partial documentation, existing AS400 code, and requirements gathering where necessary.• Performance tuning of automated TSQL/SSIS based production data processes.• Debug security issues with SSRS subscription service.• Prepared and tuned multi-million record data feed for Call Center AI program.Keywords:TSQL, VB.NET, SSMS, SSRS, Visual Studio, Excel VBA, sp_whoisactive

• As part of a DevOps team, wrote TSQL code to enable data transfer, time zone conversion, data transfer logging, and the web API code for the web based data transfer control system for the SSIS based data transfer system that moves pharmacy prescription data between every Consolidated Mail Outpatient Pharmacy (VA CMOP) being run by the Department of Veteran’s Affairs in the United States.• Created C# code in SSIS to communicate with the TSQL based logging system by executing the required TSQL stored procedures with the correct parameters at the right time during the data transfer process between individual CMOPs and the national prescription database. • Worked with DevOps team software testers to develop testing plans, code samples, and illustrated documentation for all code produced.Keywords:TSQL, C#, SSMS, SSIS, Visual Studio, Microsoft Team Foundational Services, Distributed Transaction Coordinator

• Software development and debug for .NET/Access/SQL Server based systems.• Data processing, cleansing, and ETL. One time efforts and automated solutions were both offered. • DBA services for SQL Server based systems including backup, maintenance, and ongoing performance monitoring and tuning with the SQL Server Profiler, Database Engine Tuning Advisor, and SolarWinds Database Performance Analyzer.Keywords:TSQL, C#, VB.NET, SSMS, Visual Studio, SSIS, SQL Server Profiler, SolarWinds Database Performance Analyzer, SQL Server Database Engine Tuning Advisor, Microsoft Access and Excel VBA

Rocky Hill, Ct, Us

• Created multiple SQL Server 2008 R2 databases that collectively serve as the backend for a signficant part of the United Way’s business intelligence services, including their 211 call center data.• Used SQL Server BI tools to build ETL packages in SSIS for the automated, routine import of data from multiple different types of sources. This included TSQL, VB.NET, and VBA programming, as well as the modification of some existing C# code.• Established and maintained up to date software documentation detailing the different configurations of the newly developed .dtsx packages including basic installation, maintenance, import reversal and troubleshooting procedures.• SSRS and Excel based data reporting; both year end and ad hoc reporting to fill specific requests.• Performed various small scale debug and repair tasks involving existing Access applications.Keywords:TSQL, C#, VB.NET, SSMS, Visual Studio, SSIS, SSRS, SQL Server Profiler, Microsoft Access VBA

• Responsible for on-call DBA duties and further development of the end client’s line of business, custom built Access/SQL Server application.• Reviewed the entire software application for ongoing maintenance and administration needs, and then documented the procedures used to address those needs in an easy to read, user manual style format.• Added functionality to a pre-existing, undocumented Access/SQL Server hybrid database containing over 11.6 million records, including Excel based data import/export for the forms, user-specific sound based alarms when new jobs queue, and other control modifications according to user preference.• Stood up a second instance of the database on a new server as a performance improvement measure to separate the reporting activity load from the data entry load. Also created a custom SSIS data merge solution to keep the 2 servers’ data synchronized with an automated overnight transfer process.• Additional performance tuning and refactoring of the SQL database code was required. SQL Server Profiler and Solarwinds DPA solutions were set up and used for monitoring as part of this process.Keywords:TSQL, VB.NET, SSMS, Visual Studio, SSIS, SQL Server Profiler, SolarWinds Database Performance Analyzer, SQL Server Database Engine Tuning Advisor, Microsoft Access and Excel VBA

Cromwell, Ct, Us

• Developed an integrated, multi-department data model and ultimately a database software system using Microsoft Access and Excel in conjunction with VBA and SQL code for the company that supported decision making processes, satisfied its meaningful use EMR requirements under ARRA, and saved it over $150,000 annually in back office labor costs. This system became a model for other non profit human services organizations in Connecticut as an affordable means of meeting ARRA requirements and also fulfilling COA accreditation requirements where applicable.• Extracted and cleansed 14 years’ worth of legacy data from over one hundred separate Excel files (many different formats), then mapped the data to a single custom destination format usable by database software mentioned above prior to loading it into the new system.• Produced a quality assurance and performance improvement metrics program with VBA automated Excel dashboard support for each department within the organization at large in order to enable the company to meet its operational demands for quality control and to fulfill COA accreditation requirements.• Gathered business requirements and generated documentation for all software produced.Keywords:Microsoft Access and Excel VBA, MySQL, Navicat

Microsoft Certified Technology Specialist, Sql Server 2008, Database Development

Ms, Business, Organization And Management

Levels 1-3 Certificates (All), Microsoft Office (Access, Excel, Word)

Bs, Environmental Science, Environmental Health