REGINALD HOUSE

Professional Summary

Ability to drive improvements into existing processes.

Wide range of skills across multiple technologies with the ability to integrate processes successfully.

Self starter with the ability to multitask in a fast paced environment.

Analytical ability to drive improvements into existing processes.

Earned Project Management Certificate from Stevens Institute of Technology.

Knowledge of and Participated in Agile work environments.

Technical Summary

Microsoft SQL Server 2008 R2, PL/SQL, HP-UX, Visual Basic 6, VB.NET, Oracle, UNIX Shell Scripting, PERL, Python, Active X scripting, Crystal Reports, SQL Navigator, Power BI, ColdFusion, PowerBuilder, DTS, SSIS, SSRS, ASP, HTML, Microsoft Visual Studio 2010, 2012, 2013, 2014, 2016, 2017, and 2019 SAS Programming Language Release 6.08, Database administration, Windows Server Administration, Microsoft Office Suite. MS Project, Tableau, Alteryx. Have used Excel for 15+ years.

Work History Summary

North American Risk Services, Altamonte Springs, FL 06/2022 – Present

Sr. Database Analyst/Reports Writer

Participating and hosting Teams meetings in an effort to help the work progress smoothly.

Created and enhanced the SSRS reports for both internal and external clients.

Wring SQL Queries to populate reports using Crystal Reports..

Using DBeaver package to write SQL queries against Oracle databases.

Using WEB Intelligence reporting package to create and edit reports.

Using SAP Business Objects as reporting repository.

Using SAP Universe Tool to edit data Universes.

Using Fresh Service ticketing system to respond to open tickets.

Agile work environment

Truist Bank, Orlando, FL 05/2021 – 10/2021

SQL Developer

Supported Truist’s CRM program ProMerit

Created and enhanced the SSRS reports that were internal to ProMerit

Wrote SQL Queries using SSMS 2016 that triggered the edit checks used by ProMerit to ensure data integrity

Attended and actively participated in the daily stand-up meetings as well as the sprint planning sessions

Down to Earth, Maitland, FL 12/2020 (2-week project)

Data Analyst

Pulling data from multiple sources.

Creating reports associated with the company’s 1095-C submissions to third party vendor

Organizing and finishing the data to submit to vendor.

Created Access database to streamline the reporting process.

Health Plan Services, Tampa, FL 01/2016 – 05/2020

SQL Developer (ETL-SSIS) / Data Analyst II (Manager/Lead)

Managed the day to day operations of the Data Analyst group.

Assigned work as needed to ensure that the resource assigned had the skill set for the project.

Interviewed potential candidates for open positions within the group.

Enhanced existing process through the use of automation bots by reviewing the process, gathering the resources and documenting the process whereby three shifts of employees were freed up to do more meaningful work.

The aforementioned process involved a process that required the shift workers to manually enter data into the system whereas the bot did the same work within 5 minutes, eliminating the need for the manual intervention by the shift workers.

Creating new and enhancing existing reports in SSRS using Visual Studio 2012, 2013, 2014, 2016, 2017, and 2019.

Creating and enhancing SSIS packages to facilitate the data load process using Visual Studio 2012.

Creating database objects, writing stored procedures and views in MS SQL Server 2012 used as input to the reports.

Creating dashboards and reports using Tableau

Creating workflows using Alteryx.

Writing adhoc queries and reports as requested.

Coordinating the file creation process in order to return data to the State and Federal exchanges that originated the data.

Performing analysis on data received from the state and federal exchanges in support of the healthcare initiative (Obamacare).

Assisting to document the file send and receipt process.

Automating existing processes that were previously done manually.

Writing queries as a part of my analysis against mySQL and DB2 databases using SQL Developer.

Utilizing Power BI to create reports and dashboards for management review to make adjustments to the process and personnel assignments.

Used Excel to render reports on an adhoc basis.

Performed analysis with Excel using the built in functions, VBA, Macros and Pivot table features.

Walt Disney World Resorts

Worldwide Safety and Auditing (Walt Disney World), Orlando, FL 09/2015 – 11/2015

Reports Developer

Creating new and enhancing existing reports in SSRS using Visual Studio 2012.

Creating documentation of reports as well as data dictionary of the underlying databases.

Writing queries with joins and sub queries to extract the precise data needed to populate the reports.

Serving as team member in developing and documenting the reporting process.

Coordinating the moving of all reports to the development, QA and production environments.

Coordinated the identification and installation of the necessary reporting software.

Participated in daily standup meetings (SCRUMS) in an Agile work environment.

Charles Schwab, Orlando, FL 04/2015 – 09/2015

Data Analyst

Performing analysis of network data to determine ownership.

Launching waves of data attestation to engage leadership of business units in an effort to encourage subordinates to disposition data associated with the applications that fall within their scope.

Creating databases to enable the ability to query data as a part of the attestation effort.

Writing queries with joins that brings the data together in a cohesive way so as to be able to report on and analyze the data.

Contacting the individuals who have been determined to be the responsible parties based on the analysis.

Creating reports in Tableau and Data Insight. Created dashboards using Tableau.

Creating and documenting methodology to create an ongoing maintenance process to ensure that files on the network are properly handled and maintained as well as retained from a legal perspective.

Automating daily work functions to drive efficiency into the project.

Florida Association of Realtors, Orlando, FL 11/2014 – 03/2015

Application Developer

Creating and enhancing reports using Crystal Reports.

Optimizing and documenting existing processes while reviewing these processes and automating them as needed.

Creating database objects, writing stored procedures and views in MS SQL Server 2005 used as input to the reports.

Created SQL Server Agent jobs to enable the scheduling of processes.

Created SSIS packages as a part of the automation efforts.

Identifying, troubleshooting and resolving process and database object issues.

Modifying reporting process to improve the processing and accuracy of the data.

Handling follow-up and resolution of trouble tickets related to iMIS application.

Serving as support lead for Member Services applications and processes.

Creation of List automation to improve/automate communications for all boards in the state of Florida.

Leading project to integrate SSRS into the environment to transition away from Crystal Reports.

Total Marketing Concepts(TMC), Sanford, FL 7/2014 – 10/2014

SQL Server DBA/ Developer

Created and modified SSRS reports and Power BI.

Managing the reporting processes of the Verizon and Comcast segment of the business.

Documenting reporting process.

Creating database objects, writing stored procedures and views in MS SQL Server 2008 R2 used as input to the reports.

Created SQL Server Agent jobs to enable the scheduling of processes.

Monitor replication that occurs every 5 minutes to ensure that data is replicated successfully.

Created packages to send email regarding any failures of jobs that need to be addressed.

Utilizing performance tools to optimize database performance.

Identifying, troubleshooting and resolving database issues.

Modifying reporting process to improve the process and accuracy of the data.

Created dashboards and reports using Tableau.

Loading leads to the dialer for operational continuity.

Handling follow-up and resolution of trouble tickets for operations.

“Scrubbing” data to ensure that representatives have fresh leads to speak with.

Monitor dialer activity to ensure that there are no issues to impede the daily operation.

Hilton Grand Vacation Club, Orlando, FL 3/2014 – 7/2014

SQL Server DBA

Created and modified Crystal Reports using Crystal Reports XI.

Creating database objects, writing stored procedures and views in MS SQL Server 2008 R2.

Utilizing performance tools to optimize database performance.

Documenting reporting process.

Managing the reports process and repository, administering access as well as the versioning tool used.

Orlando Health, Orlando, FL 1/2014 – 3/2014

SQL Server DBA

Creating database objects, writing stored procedures and views in MS SQL Server 2008 R2.

Performing database maintenance and tuning.

Monitoring database backups in a clustered environment.

Utilizing performance tools to optimize database performance.

Handling security access for users to databases, views, stored procedures, and tables including read, write and execute permissions.

Installing SQL Server databases and other components of MS SQL Server Management Studio.

Performing Backup and restore operations as requested.

Serving as the DBA related to Disaster recovery project for Allscripts Enterprise.

Club Assist, Altamonte Springs, FL 8/2013 – 12/2013

Reports Analyst / SQL Developer / Business Intelligence Developer

Writing Reports after creating the stored procedures that are to be used as input to the reports.

Rendered the reporting and dashboards using Tableau.

Maintaining and producing existing reports.

Creating reports using Excel’s advanced functionality.

Enhancing existing reports as requested often optimizing them for efficiency.

Creating database objects, writing stored procedures and views in MS SQL Server 2008 R2.

Creating BI Solutions for reporting.

Systems 2000, Altamonte Springs, FL 4/2013 – 8/2013

Reports Analyst / .Net Programmer

Writing Reports after creating the stored procedures that are to be used as input to the reports.

Enhancing existing reports as requested often optimizing them for efficiency.

Creating Reports build using Visual Studio 2010.

Creating database objects, writing stored procedures and views in MS SQL Server 2008 R2.

Creating and altering Forms using VB.Net code.

Scheduling and Releasing all new report build, determining what is to be included and specifying test scenarios.

Medwatch LLC, Lake Mary, FL 8/2012 – 4/2013

Reports Analyst / Technical Support Analyst

Writing Crystal Reports after creating the stored procedures that are to be used as input to the reports.

Enhancing existing reports as requested often optimizing them for efficiency.

Creating SSIS packages using Visual Studio 2008.

Creating database objects, writing stored procedures and views in MS SQL Server 2008.

Perform all manner of technical support utilizing tools such as Active Directory for password resets and account creation.

Monitoring database backups.

Creating SQL server Agent jobs to automate processes and report scheduling.

Assist RX, Orlando, FL 8/2011 – 4/2012

SQL Database Administrator

Performed ETL transformations of data for analysis, massaging the data to conform to database specifications.

Performed troubleshooting of the data and connectivity to ensure the accuracy of the transformation.

Monitoring file transfers both incoming and outgoing.

Creating the interfaces inbound and outbound that securely connects to the file transfer site.

Creating database objects, writing stored procedures and views in MS SQL Server 2008.

Performing database maintenance and tuning.

Creating replication, backup and Disaster recovery plans including set up of the plans.

Utilize performance tools to optimize database performance.

Maintain companywide data warehouse as resource owner.

Automation of processes using VB.Net, SQL Server jobs, stored procedures, and T-SQL

Develop and maintain process documentation including database schemas and the data dictionary.

Creating and maintaining SSIS packages using Visual Studio 2008.

Planning connectivity setup projects, monitoring milestones as the projects progress.

Creating dashboards using Power BI to assist management in its decision-making using the true data.

Siemens Global Shared Services, Orlando, FL 6/2010 - 4/2011

SQL DBA/Operations Analyst - 10-month Contract

Performed ETL transformations of data for analysis, massaging the data to conform to database specifications.

Performed troubleshooting of the data and connectivity to ensure the accuracy of the transformation.

Monitoring file transfers both incoming and outgoing.

Creating the interfaces inbound and outbound that securely connects to the file transfer site.

Encrypting and decrypting files transferred to and from the file server.

Writing/Developing Perl scripts to perform file transfers on a scheduled basis.

Handling file retrieval and archiving from PeopleSoft, EZSuite, EZ-X, and SICOM

Creating Windows Forms application for Personnel/HR data.

Utilizing Ms-SQL Server 2008 to create database, stored procedures and views to interact with the Windows Forms application. The application makes use of MS SQL Server’s ETL capabilities.

Used Visual Studio 8 to create SSIS packages for transformation of data to SQL databases.

Perform FTP and OpenFT file transfers manually on an adhoc basis and creating batch jobs to perform the transfer.

Educational Summary

University of Phoenix, Maitland, FL Present

IT Major (9 credit hours remaining)

Stevens Institute of Technology 2000

Project Management Certification

AT&T School of Business, Somerset, NJ 1996 - 1998

UNIX System Administration, UNIX Shell Programming

Delaware State College, Dover, DE 1980 - 1981

Computer Science

Contact this candidate