Sql Server Data
Resume:
Title:Information Systems Analyst
abpqoa@r.postjobfree.com
Document
Source below
NAME: SCOTT GREEN
ADDRESS:
CITY: Edgewood
STATE/PROVINCE: WA
ZIP/POSTAL CODE: 98372
COUNTRY: USA
EMAIL: abpqoa@r.postjobfree.com
PHONE: 253-***-****
CANDIDATE ID: N/A
CITIZENSHIP: US
Citizen
EDUCATION: Not Entered
EXPERIENCE: Not Entered
WILL RELOCATE: Not Entered
RELOCATION INFO: Not Entered
JOB WANTED: Not Entered
HOMEPAGE:
HOTSKILLS:
ESUME
SCOTT GREEN
11113 46th St., E.
Edgewood, WA 98372
SUMMARY OF ASSETS
I am an Information Systems Professional with fourteen years overall
industry
experience. I am a Sr. Level Visual Basic developer, Jr. SQL Server
DBA, a
data architect and have excellent process/data modeling skills. I also
have educational experience and limited working experience with
Oracle.
EXPERIENCE
Computer Skills:
Hardware: IBM PCs and Compatibles
Software: Visual Basic 3.0, 4.0, 5.0; SQL Server; Oracle 7.3; Crystal
Reports 5.0; ODBC; Access; EasyCASE; Paradox; Knowledgeware ADW 2.7;
S-Designer Appl. Modeler 5.1; S-Designer Data Architect, Windows 3.1,
Windows 95 and Windows NT 4.0.
Methodologies:
DMR P+
EXPERIENCE HIGHLIGHTS
As a Consultant for BEST Consulting, assigned to the following
projects; For The Boeing Company responsibilities were as follows: o
Developed Visual Basic 5.0 applications and ActiveX DLLs from
functional specifications in support of the BCAG Pricing group using
Oracle and Access databases. Developed reports in Microsoft Excel
using OLE Automation through Visual Basic. These applications were
used to help determine the price of airplanes. o Developed functional
specifications to be used by developers for creating application
modules. o Performed the duties of Data Architect by maintaining and
enhancing Conceptual, Functional and Physical data models. Worked with
the Oracle DBA's implementing the changes to the database. Employment
dates October 1997 to present For Cinnabon, responsibilities were as
follows: o Made enhancements, corrected program defects and improved
performance of the programs that are used by the bakeries to track
sales and employee's time that was developed in Visual Basic 3.0. o
Developed the new employee module for the Bakery Automation System. o
Designed and developed SQL Server stored procedures to import employee
information into SQL Server and then export the information to the
company's payroll provider. o Designed and developed their new backup
program using DynaZip. o Designed and developed the new program to
poll and import data from Panasonic cash registers into the Bakery
Automation System. o Provided assistance to users that had questions
and problems with SQL Server and Access. Employment dates
July 1997 to
October 1997
For Simpson Timber, responsibilities were as follows: o Managed the
company's SQL Server databases by writing stored procedures,
monitoring performance of the servers, implementing changes for the
application development team and maintaining the security of the
severs. o Created data models and validated changes to the data models
by the application development team. o Converted one of the SQL
Servers to integrated security. Developed a DBA User Guide that
documented the SQL Server servers and their databases. Employment
dates
February 1997 to June 1997
For King County Metro VanPool, responsibilities were as follows: o
Automated the company's manual Van Pool tracking system. Performed
Project Management tasks, developed the data and process models and
helped with the re-engineering of business processes. Developed the
application in Visual Basic 4.0 and Crystal Reports 5.0, using the
Access engine and ODBC. Performed testing and implementation of the
application. o Helped with Business Process Re-engineering of
Rideshare Operations. Then used the re-engineered processes to develop
the process model and validate the data model. o Developed the data
and process models needed to complete Phase One of the application. o
Created and maintained the Access database for the application. o
Developed and managed the project plan, using Function Point Analysis,
that involved the tasks that needed to be performed to complete the
application. o Developed a Configuration Management plan and Issue
Resolution procedure for the project. o Developed all the standards
and procedures used on the project. o Developed an Employer
application to track the employers who have employees riding in van
pools. o Chose the project development tools that would be used on the
project. Employment dates
December 1996 to February 1997
As an Information Systems Analyst
for King County Metro VanPool,
performed the same support as listed above for another contracting
firm on a
temporary
basis from October 1995 to December 1996.
As a Database Engineer
for Health Systems Technologies,
responsibilities included: o Developed processes and procedures to
implement customer data into Managed Care System application. o
Developed import and data collection tools using Visual Basic, Access
and ODBC. o Provided user training and support to customer DBAs in the
operation of SQL Server database. Employment dates
August 1995 to
October 1995
As a Visual Basic Instructor
for The Boeing Company. responsibilities
included: o Taught off-hour courses to employees on how to use Visual
Basic and provided them with working examples to expand their skills.
Helped with the improvement of the course material and the development
of an advanced course. Employment dates
January 1994 to June 1995
As a Business System Programmer/Analyst
for The Boeing Company
responsibilities included: o Developed Visual Basic applications using
the Jet Engine for Printing Operations. Managed projects, gathered
requirements, designed applications and databases, coded and tested
applications. o Implemented a Microfilm Label Printing system for
airplane manuals, which included a Users Guide, interface to the
mainframe for downloading files and an interface to Visio using OLE.
The application will save the company $114,000 a year. o Used the DMR
P+ methodology for producing the deliverables for the system. o Member
of Software Engineering Process Improvement team. Employment dates
November 1994
to July 1994
As a Contract
Programmer for By Contractors, For Contractors
responsibilities included: o Converted Jobcost/General Ledger
application from Clipper into Visual Basic. o Developed a complete
Jobcost/General Ledger application using the Visual Basic 3.0 and
Crystal Reports. o Developed a Setup program for the application. o
Developed On-line help for the application. o The application is
currently being marketed in the Pacific Northwest. Employment dates
November 1993
to April 1995
As a Computing Data and Process Architect for The Boeing Company.
responsibilities were as follows: o Assigned as the Data Architect for
the Group Insurance organization. Assisted projects with data and
process modeling and maintaining entity and attribute definitions.
Worked with the DBA to design physical databases. o Produced the
conceptual and functional data and process models for the company's
Insurance Benefit System using the DMR P+ Methodology. o Produced
conceptual and functional data and process models using the
KnowledgeWare ADW CASE tool. o Worked with the DB2 DBA to translate
the functional data model to a physical data model and created DCLgens
for COBOL applications. o Developed processes and standards for the
use and sharing of data within the development group and with other
organizations. o Developed procedures on the use of the KnowledgeWARE
ADW CASE tool to do impact analysis and how to use the tool to produce
the DMR P+ deliverables. o Developed procedures on the use of the
Brownstone repository in the application development and maintenance
support. o Member of the team mapping IDEFlx to the DMR P+
Methodology. o Knowledgeable in the IDEFlx modeling technique.
Proficient with the MODELPRO PC modeling tool and the LEVERAGE
mainframe modeling tool. Employment dates
October 1991
to October 1994
As a System Analyst
The Boeing Company. responsibilities included: o
Developed PC applications for the Payroll department, Network and
e-mail administrator. Provided PC support for users. o Used the DMR P+
Methodology and the Knowledgeware ADW CASE tool to aid in the design
of computer applications for the Payroll department. o Created
software documentation standard for the PC Application Group. o
Created and maintained the Data Dictionary for the PC Application
Group. o Designed and installed an Ethernet network using UngermanBass
software, that included cc:mail and mainframe communication using
IrmaLan software. o Developed users manual for the network. o Member
of Standards Group. o Coordinated the move of the computing equipment
for the Payroll department to a new location. o Member of the testing
team for LAN Manager and SQL Server software. o Member of the testing
team for Paradox and SQL Link accessing SQL Server. o Member of team
for installation of Windows 3.0 environment. Employment dates November
1988
to September 1991
As a
D.P. Manager/Programmer/Analyst
for Pacific Erectors, Inc.,
responsibilities included: o Managed computer operations and system
development, Network administrator. Provided PC support for users. o
Designed, constructed and maintained multi-user Job Cost, Payroll and
Accounting applications in Clipper and dBase III+. o Created and
maintained company computer policies and standards. o Designed,
installed and administered a Novell network. o Maintained data
communication link between home office and remote offices. o Developed
and managed computer budget for the company. o Evaluated and purchased
computer hardware and software for the company. o Trained employees in
the use of computer software. Employment dates
July 1985 to July 1989
As a Programmer/Analyst for Professional Application Programmers,
Inc., responsibilities included: o Developed PC applications. Member
of software development team. o Developed computer application that
showed the shear and stress of various beams graphically. o Developed
amortization program and demonstrated the program at real estate
seminar for client. Employment dates
April 1984 to May 1985
EDUCATION/ACCREDITATIONS
A.S
. Computer Science Steven Henager's College of Business
abpqoa@r.postjobfree.com
Contact this candidate