Government Operations Consultant /Employment Security Representative Resume

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 tool that aggregates frequently asked questions to simplify database troubleshooting and technical support
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.
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.

TECHNICAL SUMMARY:

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

Database Systems: SQL Server 2005, 2008, and 2012. Oracle, Microsoft Query AnalyzerProgramming C#, C++, Java, HTML, FoxPro, SQL.

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

PROFESSIONAL EXPERIENCE:

Confidential

Government Operations Consultant /Employment Security Representative

Responsibilities:

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.
Reviews federal and state law and consults with staff and partners as appropriate to develop or redesign state and federal reporting procedures, forms, systems and manuals.
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 EFM and regional, state and federal performance.
Provides recommendations to management relative to correcting problem areas.
Performs ad-hoc applications, designs, data queries and reports.
Utilizes T-SQL to build reports to import into an Excel format of the job seekers of the different federal programs.
Provides and technical assistance to AWI staff, regions and other partners with regard to performance and reporting systems.

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

Security Representative

Confidential

Responsibilities:

Processed initial unemployment compensation claims via telephone, mail and internet.
Determined issues, concerns and/or complaints, employers or other customers. Accessed and researched necessary records to either resolve those issues or refer to a specific or appropriate program specialist or supervisor.
Researched and explained the unemployment compensation program at the request of callers and direct them to the appropriate place to file a claim. Explained how to file via mail, fax or internet.

Confidential

Systems Project Analyst

Responsibilities:

Established and maintained databases used for testing and production.
Established and maintained database dictionaries.
Wrote queries using Microsoft Query Analyzer.
Performed database maintenance.
Developed security and control procedures for databases including recovery and back-up procedures.
Developed and documented standards for use, control, updating and maintenance of databases.
Worked in coordination with programmers, programmer/analysts and other data processing personnel on procedures related to new or existing data files.

Environment: SQL Server 2005, Microsoft Query Analyzer, T-SQL.