Data Sql Server

Scott Shacreaw

***** ****** **** *****

Blue Ridge Summit, PA 17214

(Cell) 717-***-****

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

Objective: To land a position that will allow me to use my skills and

experience to provide effective and efficient solutions for a

company that can provide a rewarding and challenging career

path.

Clearance: Active Secret

Education: Bachelor of Science

Information Technology w/ Business

Juniata College, Huntingdon, PA

Graduated - May 2003

Master's Certificate

Business Analysis with emphasis in IT Project Management

Villanova University - Online

August 2008 - January 2009

Experience:

Sr. Systems Analyst

General Dyanmics, Fort Detrick, MD

May 2011 - Present

. Created Oracle/MS Access based data dictionary for the JMAR

Application

. Performed data mapping of CUD web services between the XML

result set and the physical database schema

. Created data models for CUD web services using ERWin

o XML Physical schema to show the physical XML element

name and metadata

o XML Logical schema to show a more business-friendly

structure of the XML files

o Database physical schema to show all tables involved

in the creation of the XML result sets

. Interfaced with development staff to ensure accuracy of

maps and models

. Reviewed UDR (Universal Data Repository) ICDs

. Reviewed DMLSS Prime Vendor Gen IV documentation

. Reviewed JMAR Facility Management ICD

. Worked with Informatica B2B XML translation software

. Reviewed CUD system ICDs

Database Developer

Keya Consulting, Fort Detrick, MD

October 2009 - May 2011

. Develop databases to solve business requirements

. Map data flows to assist in project management

. Identify project timelines and critical paths across

multiple functional areas

. Manage existing database systems in SQL Server, MS Access

and Sybase

. Breakdown business processes and automate existing manual

tasks

. Write VB to assist in process automation

. Analyze data from numerous source systems and find

relationships

. Write data mining routines to provide reports to upper

management

. Administer web-based accounts

. Provide other technical support as needed

Functional Analyst 2

Akimeka LLC, Fort Detrick, MD

February 2009 - October 2009

. Managed projects from the requirement gathering point

through to production testing

. Wrote complex SQL to solve business queries

. Compiled data for JMAR project

. Functioned as a JMAR ETL developer for JMAR interfaces

. Reviewed JMAR application features versus specification

document

. Worked as the database expert with the netcentric proof of

concept team

. Wrote PL/SQL to develop stored procedures and packages

. Programmed in VB to allow flexibility of procedures and

data flow

. Used Access extensively to easily query amongst multiple

systems

. Worked as a data sourcing analyst on Government

deliverables

. Tracked armed services medicine across the world

. Held user group conference on current version of software

to track armed services medical supplies

. Worked on system sustainment

. Developed ad hoc reports for various users when canned

reports don't fill requirements

. Mapped new data feeds into existing data structures

. Ensured data integrity based on business rules

. Clearly translated business rules into requirement

documents

. Worked with developers to build Interface Control documents

Database Analyst 2

Manitowoc/Grove Crane Group, Shady Grove, PA

August 2007 - February 2009

. Performed upper level analysis for Director and VP level

clients

. Collected data from multiple interfaces to write analytical

reports

. Managed multiple IT projects for the Purchasing Department

. Worked as IS Customer Liaison to help schedule, prioritize

and manage IS Requests

. Developed databases to meet business requirements

. Wrote VB programs for more functionality within MS Access

. Analyzed current systems to ensure they follow business

rules

. Ensured data integrity throughout systems

. Coordinated data cleanup exercises in Oracle, Informix, and

MS Access

. Created process to handle all Supplier Quote Requests

. Began data scrubbing for migration to SAP

. Began data mapping between two separate CRM systems for

migration to SAP

. Worked as the Small Business Liaison Officer to ensure our

government contract program continues

. Attended small business matchmaking events to develop

relationships with suppliers

. Developed process for handling small businesses that will

pass government auditing

. Worked in multiple locations with different systems and

user groups

. Worked across a number of departments to help with data

reporting needs

. Worked as IS Liaison between IS and Purchasing to

facilitate the purchasing department requests

. Worked with the Purchasing functional area to understand

their technical needs and develop business processes

. Worked closely with IPD/NPI teams to develop reports and

programs to help track cost and margins

Programmer 2

Dietrich Industries, Blairsville, PA

August 2005 - August 2007

. Developed programs with Progress V9

. Designed and modify databases to meet the goals of business

processes

. Managed a number of large projects from planning to

delivery

. Worked with users from all levels of the organization to

develop tools beneficial to the company

. Ensured that all programming changes are recorded properly

for SOX compliance

. Built GUI's and reports from many databases

. Organized data from many databases to develop programs and

reports

. Worked both alone and in a team environment to meet goals

of assigned projects

. Developed company-wide product costing on over 3,500 items

to develop margin analysis

. Developed product specification documents using PDF Include

within Progress to be sent to customers when they receive

quote submittals

. Wrote numerous margin reports based on product costing to

help senior management make decisions on cost of our entire

product line

. Used Webspeed to develop web pages linked to our intranet

. Used appservers within Progress to access data across

multiple databases

Data Analyst

MxEnergy Inc., Annapolis Junction, MD

May 2003 - August 2005

Independent Consultant

August 2005 - January 2007

. Worked as a part of a small IS team to maintain data in a

data-intensive environment

. Worked as migration lead and as part of multiple data

migration teams

. Member of steering committee when choosing new CRM system

. Worked with Oracle 9i, SQL Server 2000 and MS Access to

develop reports and programs

. Wrote VBA to develop front ends for back ends to multiple

platforms

. Performed QA for CRM to ensure that specifications were met

and any bugs were reported

. Distributed tasks among 6 employees to ensure timely

turnaround

. Performed performance evaluations on 6 team members for

upper management

. Used my strong skills in SQL to ensure data integrity and

provide complex reports to corporate heads

. Developed and maintained multiple database systems

. Wrote VBA to develop functions or modules for database

manipulation

. Assured data integrity to help keep MXEnergy running on a

daily basis

. Saved company from $5,000 to $25,000 on a weekly basis by

developing auditing systems

. Trained end users on how to use newly developed databases

and features

PC Technician

Juniata College, Huntingdon, PA

August 2000 - May 2003

. Worked troubleshooting PC and Network issues within

school's infrastructure

. Implemented license management software to keep track of

all software on college owned computers

. Worked phone support as needed to walk users through

computer and network issues

. Utilized active directory to manage user groups,

permissions, and software installs

. Worked on major upgrade projects for the school during

summer internships

Skills: Hard skills -Oracle 9i, Oracle 10g, Pervsasive, SQL Server

2000, SQL Server 2005, VB, MySQL, Baan, Informix, Progress V9,

Webspeed, MS Access, MS Word, MS Excel, PowerPoint,

Dreamweaver, Java, C++, Discoverer, TOAD, XML, HTML, JavaScript,

Data Migration, Data Integrity, Hardware setup, Hardware

installation, Software installation, Network troubleshooting,

Mac OS X troubleshooting

Soft skills - Team Leadership, Presenting, Assigning tasks,

Communication (Oral and Written), Multitasking, Logical

thinking, Problem solving, Organization

Awards Smaltz Achievement Award - May 2003 - awarded to one senior for

overall career excellence

All-conference offensive lineman - November 2002 - awarded all

conference honors

Ray A Kroc Youth Achievement Award - June 1999 - awarded for

leadership

Contact this candidate