Sql Server Management

Rachel A. Stuve

***** ******* ***** (***) ***-

*766

Macomb, MI, 48044

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

SUMMARY

Advanced analyst specializing in system development lifecycle, relational

databases, data quality, reporting and Portal/Collaborative web

applications with experience in automotive, government and manufacturing

technologies and services; education includes Bachelor of Science in

Information Systems, Master of Science in Administration (2011), Sun

Certified Professional for Java Technology and ITIL V3 Service Management

Certification.

COMPUTER SKILLS

Adobe PhotoShop CS3 JDeveloper (Oracle 10g) MS Project 2007 SUSE Linux 9.0

BackOffice Data Java/Javascript MS SharePoint SWiSHmax

Migration 2007

Benthic Golden/PLEdit Jython MS SQL Server TOAD (Oracle)

2008

Cognos Lotus Notes R5 MS Visio Vignette Content

PowerPlay/Impromptu Management

Crystal Reports Macromedia Dreamweaver Offendertrak Vignette Collaboration

9.0/10.0 MX 7.2

HTML/SHTML Macromedia Fireworks MX Oracle 9i/10g Vignette Portal 7.4

Hummingbird BI Suite Macromedia Flash MX SQL/PLSQL VMware Server

8.0

PROFESSIONAL EXPERIENCE

General Electric (Energy Division), Van Buren Township, Michigan

Advanced Application Specialist, Information Management

02/10-present

> Subject Matter Expert on BackOffice suite of tools and methodologies

for data migration and data quality tools

> Coordinate with national/international teams to install, configure and

optimize data migration applications

> Conduct software demonstrations, assist with timeline creation,

approve technical deliverables, manage customer expectations, lead

user training sessions and report status to senior management for all

BackOffice initiatives

> Collaborate with project managers to recommend proper solutions for

data migration and quality

> Manage technical and personnel resources to ensure proper support for

ERP data conversion projects

Champion Enterprises, Troy, Michigan

Lead Portal Developer/Analyst, Information Systems

07/07-02/10

> Gathered requirements, designed, built and documented corporate

intranet Portal using Vignette suite: full SDLC

> Installed, designed and built intranet Portal/BI site (beta) using

SharePoint 2007/IIS & SQL Server 2008

> Project planning, software evaluation, designed architecture and

recommended solutions for Portal/BI solutions

> Upgraded and patched Collaboration and Portal applications

(application server: VMware & Linux)

> Developed templates, workflows, role-based security

> Developed and maintained system and design standards

> Documented system requirements, configuration, design and disaster

recovery procedures

> Regular status reporting and presentations to C-level executives

> Reported directly to CIO regarding project status, new development,

issues, and long-term application strategy

> Created all training materials and conducted user and administrator

training for 800+ remote and local employees

Macomb County, Mount Clemens, Michigan

Programmer/Analyst, Information Technology

4/03-7/07

Offendertrak-Facility management system (COTS) implemented throughout

Macomb County Jail and dependent agencies

> Lead developer for reporting team: Analyzed and gathered requirements,

created new reports, code reviews

> Created 100+ user-interactive reports through queries, stored

procedures, packages and functions

> Configuration of user interface and database: acted as technical

liaison between users and vendor

> Completed data synchronization/conversion between legacy system and

new system using MS/Oracle databases

> Assisted with the development, documentation and implementation of

database naming and coding standards

Expedited Booking System-Oracle/.NET two-way interface with Offendertrak

that streamlines data entry processes

> Created procedures/functions called by interface to validate and

return/insert data from/into database tables

> Created, implemented, and executed test plans. Coordinated with users

to document results/enhancement requests

> Conducted system needs analysis, requirements review, business process

examination, and documentation

> Created training manuals and provided support and training to end-

users

Bond Application-Oracle/JDeveloper two-way interface with Offendertrak that

streamlines the bond processing process

> Gathered requirements, created data flow design and developed initial

system prototype

> Developed application through Oracle 10g and JDeveloper

> Conducted system needs analysis, requirements review, business process

examination and documentation

Computer Aided Dispatch Decision Support System (CADDSS)-COTS to track

incidents received by the dispatch center

> Used MS SQL Server 2000 tools (stored procedures, functions, queries,

DTS) to verify accuracy of data

> Utilized Hummingbird BI Suite to create a reporting interface.

Provided user training and technical support

DaimlerChrysler, Auburn Hills, Michigan

Systems/Programmer Analyst (Contract), Corporate Services Systems and

Support 5/02 - 03/03

> Analyzed, developed, tested and implemented groupware intranet and

database applications using Lotus Notes

> Utilized Vignette V6 to manage expansion and enhancement for external

recruiting website

> Acted as technical liaison regarding requirements, configuration

changes, and site enhancement

> Created training manuals, testing scripts, and provided support and

training to content providers

> Utilized Cognos PowerPlay and Impromptu to process data and discover

trends in supplier non-compliance

> Recommended new rating system for suppliers/carriers. This initiated a

new carrier evaluation method.

Electronic Data Systems, Troy, Michigan

Customer Support Representative, Techline Customer Support Center

6/00 - 7/02

> Subject Matter Expert: resolved escalated issues for group of 30,

managed questions, lead software research teams

> Updated Intranet page via Microsoft FrontPage with current product

updates and troubleshooting tips

> Created email templates and department standards for client

communication

> Researched and planned disaster recovery and information protection

procedures

CERTIFICATIONS

General Electric Co.

Six Sigma Process Quality: Green Belt Certification

Date: June 2010

Information Systems Examinations Board (ISEB)

ITIL V3 Service Management Foundation Certification

Date: October 2009

Sun Microsystems

Sun Certified Java Associate (SCJA)

Date: April 2009

Oracle University, Troy, Michigan

Oracle Database 10g: Advanced Programming with PL/SQL Certificate

Date: May 2005

EDUCATION

Central Michigan University, Mount Pleasant, Michigan

Master of Science Degree

Concentration: Business Administration Leadership

Graduation: 2011 (Projected)

GPA: 4.0/4.0

Oakland University, Rochester, Michigan

Bachelor of Science Degree in Business Administration

Major: Management Information Systems

GPA: 3.76/4.0 (Magna Cum Laude)

Contact this candidate