Sql Server Microsoft Office

Antwan McCoy

**** ******** ***** *****, *********, Florida 33578 Cell# 813-***-****

********@*****.***

OBJECTIVE

To obtain a senior level position in the technology arena that will allow me to you utilize my expertise to their fullest along with my strong interpersonal communication skills.

CERTIFICATIONS

A+ Certified COMPTIA 12/11

IC3 Certified Administrator CERTIPORT 04/12

Microsoft Office Specialist Master MICROSOFT 11/14

SUMMARY OF QUALIFICATIONS

Over ten plus years working with SQL Server 2008 - 2011, Oracle, business rules development, report analysis, SLDC, user views and Access

Ten plus years providing IT training in the Microsoft Office Suite 2003 -2010

Programmer analyst, data analyst, business analyst, requirements gathering, and liaison for various organization

Ten plus years of experience in relational database administration, modeling, design, development, and implementation using Oracle Designer, PL/SQL and other Oracle tools and utilities

Over ten plus years of experience performing analytical database and website analysis,

Over ten plus years working with various teams in the full life cycle development, methodology and standards

Ten plus years of experience communicating with multi-functional teams, programmers, and non-technical staff personnel at all levels

Ten plus years creating stored procedures, triggers, rollback, declare, and union queries within SQL Server 2003 - 2011

Ten plus years of experience creating reports utilizing Crystal Enterprise VI – XI

PROFESSIONAL WORK EXPERIENCE

Computer Mentors Inc. 06/11 - Current

IT Programs and Site Manager

Manage 26 personnel on a daily basis

Direct and Manage a 3.5 Million dollar Department of Labor Grant

Utilize DDL to create, alter, add constraints, and drop tables etc…

Supervise, train, coach, recognize, evaluate and discipline staff accordance with established policies

Conduct daily, weekly, monthly and quarterly maintenance of accurate management reporting of MIS data within SQL Server 2008

Manage network permissions and user rights as well as setting up VPN for employees

Created Ad Hoc queries for data analysis and audits

Implemented Crystal Reports 9 for reporting purposes to Senior staff and DOL

Created an Access 2010 DB for tracking client and exports into Excel for reporting trends with VB backend for modules

Schedules, performs, monitors and maintains system upgrades to operating systems in a production environment

Ensure integrity of workstation and server data by evaluating, implementing and managing appropriate solutions to hardware and software

Certified 38 participants on Certiport Online IC3 program and 28 on Microsoft Office Specialist

Senior IT Certified Trainer in Microsoft Word, Excel, Access and PowerPoint

FLDOC, Education Department 12/06 - 03/11

Sr. Programmer / Analyst / Instructor

Developed an Access 2003 Database Tracking System to track 3300 personnel

Developed and taught various self-help curriculums life skills, financial management, and small business concepts to over two thousand students in FLDOC over three year period

CHS America, 06/06 – 09/06

Sr. DBA Programmer / Analyst

Importing delimited flat files into DTS Designer package for uploading into SQL Server 2000

Wrote sp_procedures and queries for various reporting functionalities

Test and validated scripts in SQL for data accuracy and integrity

Creating ADHOC reports and exporting into Excel for reporting purposes

Creating Monthly, Quarterly, and Annual reports

KFORCE (Bright House Networks) Contractor 02/06 – 05/06

DBA Programmer Analyst

Migrating Sybase to Business Objects XI through Data Integrator

Setup SQL Server in order to test scripts in the Sybase IQ_ACP DTWHSE

Utilize DTS as a migration tool connecting to Sybase and Oracle 11i to SQL Server

Wrote and created various reports in Crystal XI

Defense Intelligence Agency (DIA) Contractor 11/03 – 12/05

Sr. Programmer Analyst

Provided systems analysis and support for the Joint Intelligence Virtual Architecture Program

Create reports include formatting options such as Charting, Mapping, Grouping, and Sorting Alerting, Field highlighting, Drill-down, Parameter prompts

Provided testing and technical writing support for COTS/GOTS products

American Federation of Teachers Contractor 11/02 – 10/03

Senior Data Analyst

Created parameterized Crystal Reports in Business Objects using Charts, Cross-Tab reports, and sub-reports, Running Totals pulling from SQL Server

Created stored procedures and developed reports in Crystal Reports 8

Evaluated SQL Server 2000 tables for field and data accuracy

Provided analysis results on findings and recommended solutions

TSA (TSA 9/11 project) Contractor 04/02 – 11/02

Senior Data Analyst, Command Center Operations

Managed technical resources selected and assigned to the project team, from internal sources and/or from external solution providers

Resolved onsite operational issues during a major conversion project

The conversion project affected the countrywide airport hiring systems of baggers and screeners for 9/11

Developed Oracle Forms and Reports for the user interface; a data load using PL/SQL and SQL*Loader; and cron jobs calling Unix scripts to download and manipulate files

US Army (Veteran) Germany Airborne, Division G2 09/85 – 11/96

Military Intelligence (Sr. Data Analyst)

EDUCATION

BS, Computer Information System Strayer University, Washington, DC 2000

Contact this candidate