Project Sql Server

Katina S. Hughley

**** ***** **. * Dearborn Heights, MI 48127 * 313-***-**** *

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

Summary:

Detailed-oriented Project/Program Manager, with several years of

experience in program analysis. Experience and knowledgeable with analyzing

and managing multiple complex projects in fast paced environments.

Excellent communication and presentation skills. Knowledgeable in project

management principles, gathering requirements, documentation and training,

problem solving and end-user support.

Technical Skills:

. MS Access . Project Management Principles . Cascading Style

Sheets (CSS)

. MS Word . Data Analysis & Reporting . HTML

. MS Excel . ERP/Database Systems . Adobe Photoshop

. MS Project . Electronic Data Interchange .PageMaker

. MS PowerPoint (EDI) . SharePoint Designer

. MS Publisher . SQL Scripting . SharePoint (MOSS &

. MS Visio . Application/Web Development WSS 3.0)

. MS InfoPath . FileMaker . Quickbooks

. MS Outlook . Windows 95/XP/2000/Vista

. SQL Server '00 & '05

Training & Certifications:

MCTS: Microsoft Office SharePoint Server 2007

MCTS: Windows SharePoint Server 3.0

Bright Horizon Certificate in PageMaker 7.0

Bright Horizon Certificate in Photoshop 7.0

HIPAA certification

Experience:

RCM Technologies/NuSoft Solutions - Troy, August 2007 - May 2009

Michigan

Technical Business Analyst/Consultant

. Assisted in project management principles and activities by

creating detailed project plans, task allocation, and budgeting and

issues resolutions in MS Project.

. Accountable for scheduling, cancelling, and rescheduling all client

visits and consultants out to client locations; responsible for all

travel arrangements (hotels, rental cars, airfare, etc.).

. Provided support to internal sales department by creating client

contracts, business agreements, and request for proposals.

. Performed Business Analysis activities by working with clients to

gather and document technical requirements.

. Drafted business requirements, analyzed and translated the

documents to communicate the functional requirements and

specifications to the development team.

. Collaborated with top managers and high-level consultants to create

the internal organizational project/program processes and framework

system to ensure structured, organized, and budgeted projects.

. Installed and implemented Microsoft Office SharePoint Server 2007

with SQL Server 2000 or 2005 backend.

. Analyzed and resolved issues with custom Microsoft Office

SharePoint Server 2007 application.

. Developed custom master pages, page layouts, content types, and

features for Microsoft Office SharePoint Server 2007.

. Developed custom training documents on custom content management

system applications.

. Presented and delivered custom knowledge transfer sessions on the

usage and maintenance of developed Microsoft applications.

Technical Environments: Microsoft Office SharePoint Server 2007, Windows

SharePoint Server 3.0, SQL Server 2000/2005, Microsoft Content Management

System, HTML, CSS, MS InfoPath, MS Project, MS PowerPoint.

Covisint- Compuware Corporation - Detroit, September 2005 - August 2007

Michigan

Customer Technical Support Analyst

. Performed Electronic Data Interchange (EDI) analysis from raw data

(Edifact, X12 and XML) for multiple automotive suppliers and

healthcare providers via the phone, internally ticket system, and

by email.

. Resolved automotive suppliers and healthcare providers EDI issues

quickly and accurately by analyzing and interpreting the data

syntax and providing precise solutions.

. Monitored failed EDI transmissions on internal system and resolved

error EDI transmissions.

. Monitored raw data files on automotive internal system to ensure

suppliers translated data was accurate.

. Recommended and selected to join an elite team to provide data

analysis and project support for an automotive supplier.

. Collaborated with the internal mapping group to obtain knowledge on

internal mapping and translating process.

. Responsible for maintaining detailed documentation for each

customer's case that had been supported.

. Reported bugs and followed the designated procedure for escalating

problems or issues to provide end user support.

. Supported newly hired employees by creating internal training

materials on several applications.

. Provided hands-on training sessions on several internal

applications, systems, departmental policies and procedures to

employees.

Technical Environments: General Motors internal data system, Covisint

Connect internal system, EDI 824, 830, 864, 835 and 837, MS Office, and MS

Outlook

Engineered Plastic Products, Inc. - July 2004 - September 2005

Ypsilanti, Michigan

Project Coordinator/Help Desk Specialist

. Translated and mapped Electronic Data Interchange (EDI) raw data

into the internal ERP system for three automotive plants.

. Modified EDI raw data syntax to ensure parts and quantities were

accurately inputted into internal ERP system.

. Created and analyzed reports using Powershop, Crystal Reports and

MS Excel that disaggregated automotive work in process (WIP), raw

materials, and finished manufactured good parts.

. Used complex SQL queries and basic SQL statements to create

reports, graphs and diagrams within Crystal Reports and MS Excel to

display cost analysis data in a useful way for both technical and

non-technical users.

. Provided project support by creating and implementing project plans

for automotive parts.

. Provided project leadership by assuring accurate costing for all

manufactured parts.

. Assessed project cost by analyzing automotive parts Bill of

Materials, Work in Process and required labor; provided detailed

budget analysis.

. Responsible for maintaining detailed documentation for each

automotive part's project plan and internal ERP system.

. Conducted regular staff development training to plant managers,

plant purchasing agents and plant administrator's on all aspects of

the internal ERP system, company policies and procedures.

. Collaborated with upper management on ways to ensure accurate EDI

data entry of manufacturing parts in the ERP system for the three

automotive plants.

Technical Environments: Powershop ERP system, Crystal Reports, MS Access,

MS Excel, SQL, Covisint Connect, EDI 824, 830, and 864, MS Office, and MS

Outlook

The Community House - Birmingham, Michigan September 2002 - July 2004

Office Services Assistant

. Worked closely with several external and internal programs

directors to provide project support.

. Worked with several clients, internally and externally to provide

monthly budget analysis.

. Created monthly billing statements from internal databases and

generated reports in MS Excel.

. Responsible for converting internal software database into MS

Access to ensure easy accessibility and retraction.

. Created several reports for multiply clients and provided data

analysis on several MS Access databases.

. Worked with several program directors to create custom and creative

marketing and advertising promotional designs.

. Created monthly newsletters, post card mailers, program

directories, and promotional flyers.

. Promoted to maintain departmental website.

. Created detailed and custom training materials for internal

employees on Microsoft applications.

. Provided training sessions to internal employees on Microsoft

applications.

Technical Environments: MS Access, MS Excel, MS Office, MS Outlook,

Photoshop, PageMaker, HTML, and Dreamweaver

Education:

Texas A&M-Commerce - Commerce, Texas

December 2009

Master of Business Administration

Wayne State University - Detroit, Michigan

December 2002

Bachelor of Arts

Concentration: Computer Science

Involvements:

Project Management Institute, 2008-present

NBMBAA, 2009 - present

SHRM, 2009 - present

Contact this candidate