SQL, Tableau, Microsoft Office

ROGER DEFOUR

**** ********** **** *** ***

Jacksonville, FL 32256

Cell: 850-***-****

Email: ***********@*****.***

Professional Summary

Performance Monitoring – Plays an active role in monitoring the overall performance and tuning the various database performance bottlenecks.

Database Administration - Performs detailed database administration across millions of records, including reporting and technical support of 24 regions across the state of Florida

Process Improvement - Authored a 50-page database dictionary to serve as a reference tool that to search for column names of each table in our database and what the definition and description of each column in detail and it’s data type.

Performance Reporting – Develop daily, weekly, monthly, quarterly and annual reports supporting measurement, management and service improvements aimed at helping Floridians find jobs through services and resources provided by Florida’s workforce system.

Completed MOC 201461- Querying Microsoft SQL Server course on August 30, 2017 where I learned to program with T-SQL, use subqueries, use table expressions, use built-in functions, use set operators and use window ranking, offset and aggregate functions.

Completed the MOC20464-Developing Microsoft SQL Server 2014 Databases Course on September 22, 2017 where I learned Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and investigate cascading FOREIGN KEY constraints. Determine appropriate single column and composite indexes strategies. Create tables as heaps and tables with clustered indexes, also consider the design of a table and suggest an appropriate structure. Read and interpret details of common elements from execution plans. Design effective non-clustered indexes. Design and implement views Design and implement stored procedures.

Professional Experience

Department of Economic Opportunity (2008 to 2018)

Government Operations Consultant II

Government Operations Consultant (2008 to Present)

Develops and maintained SQL Server 2005/2008/2012 databases.

Creates and executes stored procedures to update tables of the federal programs and then create a backup of the tables.

Develops periodic federal, state, crystal and local reports for the agency and partners.

Creates complex Ad hoc and recurring standard reports, as related to performance, reporting, and analysis, according to state and federal program policy for department’s workforce programs.

Validates on-line reports and searches for all One-Stop and Program support program systems.

Works with programming staff to implement programming changes as required by federal or state mandates.

Identifies reporting issues and addresses problems related to timely production of federal and state reports.

Investigates, reviewed, and conducted analysis of data collection problems in conjunction with EF and regional, state and federal performance.

Gathers and organizes information on problems and procedures, plans and conducts studies related to these items, documents findings of these studies, and prepares recommendations for implementation of new system procedures

Validates data to ensure that performance outcome reports, within the department, to USDOL, other agencies, CareerSource Florida and the Local Workforce Development Boards are correct.

Utilizes T-SQL to build reports to import into an Excel format of the job seekers of the different federal programs.

Verifies Ad Hoc reports to ensure that program policy is followed.

Environment: SQL Server 2005/2008/2012, T-SQL, Production, Development, Backup/Recovery, Microsoft Excel, FoxPro, Tableau.

Technical Summary

Operating Systems: UNIX, Window XP, Vista, Windows 7, Windows 8

Database Systems: SQL Server 2005, 2008, and 2012. Oracle, Microsoft Query Analyzer,

Programming: C#, C++, Java, HTML, FoxPro, SQL.

Software: Microsoft Office Suite, Core FTP, Adobe Photoshop, Lotus Notes, Notepad, Notepad++, DBF Commander, Dreamweaver.

Education

Florida State University, Tallahassee, FL

Master of Science, Information Studies, 2007

Bachelor of Science, Information Studies, 2004

Contact this candidate