We provide IT Staff Augmentation Services!

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.

Hire Now