Sql Server Human Resources

Donia L. Miles

404-***-**** email: *******@*******.***

SKILLS: MS SQL Server, MS Office Suite, MS ACCESS, MS Office Project, MS

VISIO, Crystal Reports XI, SQL, SSIS, SSRS, Microsoft Office SharePoint

(MOSS), Monarch (ETL), Visual InterDev, Visual Basic 6, Advanced Excel,

Macromedia Dreamweaver MX, MS FrontPage, HTML, JavaScript, ASP, PL/SQL,

Oracle, XML

Familiar with: Windows 2000/XP, VB.Net applications, Server administration

functions

EXPERIENCE:

May 2008 - Present. Consultant. John Deere.

. Improved MOSS workflows process by creating useable custom

modules for company-wide use.

. Revamped data migration process to be 60% more efficient by

creating VBA macros to automate Excel reports.

. Redesigned the import/export of data process to automate data

entry through ETL tools which increased productivity by 80%.

. Designed reports into SSRS from Crystal Reports for company-wide

intranet use.

. Wrote and maintained technical documentation (ER diagrams) and

interactive podcasts for client instructional use.

March 2007 - March 2008. Production Manager/Analyst. GoodCents, Inc.

. Provide day-to-day leadership, task delegation, status

reporting, and facilitating meetings.

. Manage projects and related tasks using MS Office Project to

monitor timeliness of project deliverables.

. Formulated and re-wrote stored procedures and views in SQL

Server databases to increase efficiency of report query times.

. Redesigned legacy programs for new client specifications using

stored procedures results and Crystal Reports.

. Automated by 90% the import and transfer data from

tables/files/spreadsheets to production table fields (DTS).

. Performed SQL DBA functions, backup and restore of databases.

January 2005 - January 2007. Data Analyst. GODR. Atlanta, GA

. Worked as a liaison between internal management and vendors.

. Wrote queries and stored procedures to gather data from SQL

Server to produce Annual Report statistics.

. Managed preparation and distribution of internal and external

reporting.

. Created and maintained web pages using Dreamweaver and

FrontPage.

. Solved coding issues written in VB.Net and ASP.Net to eliminate

various bugs

. Performed data migration from legacy system.

May 2001 - August 2004. Analyst II Emory School of Medicine. Decatur,

GA

. Built new modules for an educational entry system using VB and

MS ACCESS.

. Optimized queries and reports using MS Access databases and

Excel spreadsheets.

. Created new forms/modifications/enhancements.

. Automated many data entry screens by incorporated VB Script into

programs.

. Installed user software on end client machines and trouble shoot

various problems.

. Gathered client technical specifications and helped with

software implementation.

Donia L. Miles

Page 2

1 EXPERIENCE, continued

April 1997 - May 2001. Programmer/Analyst Tascor, Inc. Marietta, GA

. Spearheaded the development of a new tracking system that

incorporated OCR technology, barcode technology and SQL Server

back end to track employment of thousands of clients.

. Designed application that generates reports and summaries using

Crystal Reports.

. Created a Help Desk application using ASP, HTML and JavaScript

in Visual Interdev.

. Created application for use by Human Resources to track site

workers for time off requests using VB and Crystal Reports.

. Processed large files using bulk copy to transfer files from

text format to SQL Server tables.

EDUCATION:

Master's Degree in Business Administration. Keller Graduate School of

Management.

Bachelor's Degree in Computer Science. Southern College of Technology.

Major: Software Engineering

Contact this candidate