SCOTT K. COFFEY
704-968-8270
PROFESSIONAL
SUMMARY
Scott is an
experienced Information Technology professional in the Government, Insurance,
Banking, Health Care, and Hygiene Services industries. He has a broad-based
skill set that includes project management and software development. He has
managed large and small projects covering many services including custom
application development, network rollout, customer service help desk, technical
help desk, computer and network operations and billing. Scott has developed
custom e-Commerce websites and brochure-type websites.
He is a highly
effective technology professional who is innovative, profit-oriented, and
performance-driven. Scott has strong leadership, management, problem solving,
and customer-service traits. Scott is
also effective at new strategy development and continuous improvement of
current methods. He is an action person
with a proven record of results. He
adjusts to change easily and has outstanding communication and people skills.
SKILLS
SUMMARY, (#) = Years Experience, (E) = Exposure Only
Languages VB.NET (3), VBA(3), JavaScript
(3), VBScript (3), HTML (3), CSS (2), COBOL (2), JCL (2), ALC (2), CICS (1)
Design Tools MS
Visual Studio 2005(4), MS DTS (1), MS SQL Server Integration Services(3), MS
SQL Server Management Studio (3), MS SQL Server Reporting Services (3), Macromedia
Dreamweaver MX (2), PaintShop Pro (2), Photoshop (1), Macromedia Flash MX (E),
Crystal Reports (E)
Office Tools MS
Project (12), MS Word (12), Excel (12), PowerPoint (5), MS FrontPage (3)
Operating
Systems MS Windows (3.1, 95, 98, ME, 2000, XP, 2003)
(15)
Databases MS
SQL Server (4), MS Access (8), VSAM (2), MySQL (5)
Servers MS IIS (5), Active Server Pages (ASP) (5), ASP.NET (3)
ERP MS Dynamics GP v9.0 (3)
Professional Experience
Position
Title Sr. Database Developer
Tools
Utilized MS SQL Server 2005,
MS SQL Server Reporting Services 2005, MS SSIS, MS Access
Ø Application
Summary: The Metrics and Reporting team provides reports
and data analysis to various departments in the Distributed Systems group.
Ø Project
Summary: The
Metrics and Reporting team uses Microsoft technology to implement their
soutions.
Ø Responsibility
Summary: Converted the reporting database from SQL
Server 2000 to SQL Server 2005, including all tables, views, stored procedures,
functions, and jobs. Upgraded the DTS
packages to SSIS packages. Implemented
new schemas, roles, and synonyms to facilitate security in the development and
production databases. Monitor jobs to ensure successful completion and
troubleshoot and fix failed jobs when necessary. Work with Project Managers and team members
to turn reporting requirements into production reports. Use complex expressions to calculate, group, filter,
parameterize, and format the contents of reports. Develop stored procedures to extract and
aggregate data for SSRS reports. Create
new SSIS packages and jobs to extract and load data for new reports.
Position
Title Consultant
Tools
Utilized MS SQL Server 2005,
MS SQL Server Reporting Services 2005, MS SSIS, MS Access
Ø Application
Summary: Technekes provides data-driven marketing
programs, execute lead generation actions, qualify prospects, and implement
customer relationship programs to maximize profitability for their customers.
Ø Project
Summary: Technekes
uses Microsoft technology to implement their solutions.
Ø Responsibility
Summary: Work with Account Managers and Technical Leads
to turn reporting requirements into production reports. Use complex expressions to calculate, group, filter,
parameterize, and format the contents of reports. Develop stored procedures to extract and
aggregate data for SSRS reports.
Position
Title Director of Information
Systems
Tools Utilized MS Dynamics GP, Scribe, MS Dynamics Integration Manager,
SQL Server 2000/2005, SQL Server Management Studio, HTML, ASP.Net, VBScript, MS
Windows 2003, IIS 6, MS Project, MS Office
Ø Application
Summary: Swisher Hygiene provides hygiene services to
commercial facilities.
Ø Project
Summary: Swisher implemented the Microsoft Dynamics GP (
Ø Responsibility
Summary: Planned, coded, and
executed the conversion of customers, contracts, accounts receivables, and the
item master from the legacy system to the MS Dynamics GP system. The conversion was handled using extensive MS
SQL Stored Procedures, Scribe, and Integration Manager. Designed, developed, and implemented numerous
reports using stored procedures and MS SSRS.
Lead a team of developers, DBAs, and support desk professionals in the enhancement,
testing, implementation, and support of the MS Dynamics GP system.
Position
Title Consultant
Tools Utilized SQL Server 2000, ASP.NET, VB.NET, MS SQL Server DTS, MS
Access 2003, VBA, MS Windows 2003, IIS 6, MS Office
Ø Application
Summary: Swisher Hygiene provides hygiene services to
commercial facilities.
Ø Project
Summary: Swisher utilized a
custom windows application on a FoxPro database and a SQL Server based
reporting portal to manage their business.
Ø Responsibility
Summary: Responsible for maintaining a series of DTS packages
critical to the Swisher Reporting Portal.
Tuned the DTS packages that resulted in a decrease in execution time
from over 12 hours to 6 hours. Provided
ad-hoc and new reports using stored procedures, user defined functions, and MS
SSRS. Designed, developed, and implemented
a website used to track sales to the national accounts customers (large chains). This included a new SQL Server Database and
an ASP.NET website written in VB.NET.
Position
Title Owner/Developer
Tools Utilized HTML, CSS, ASP, VBScript, JavaScript, MySQL, MS Access,
MS Windows 2000, IIS 5/6, MS Project, PaintShop Pro, Photoshop, MS Office
Ø Application
Summary: ClickAMemory.com
provides a quick, easy, and cost-effective way for photographers and small
businesses to display and sell their products online.
Ø Project
Summary: ClickAMemory.com developed an online broker
service allowing its customers to display and sell their products online. A customer can setup and customize their
store within minutes. This service virtually eliminates the time and start-up
costs associated with setting up an online store. Click-A-Memory also provides
custom website development and hosting.
Ø Responsibility
Summary: Web-based project using a standard development
life cycle. Planned and executed the
entire life cycle of the project including developing the Project Plan in MS
Project; designed, coded, tested, and implemented the solution; and worked with
customers and vendors. Also developed database-driven
and brochure-type websites for clients and provided website hosting
services. Developed the custom websites
using ASP, HTML, CSS, JavaScript, and PaintShop Pro and Photoshop. Developed the database driven sites using
JScript, ASP, MS Access, and MySQL.
Position
Title Partner/Developer
Tools Utilized HTML, CSS, ASP, VBScript, JavaScript, MS Access, MS Windows 2000, IIS 5, MS
Project, PaintShop Pro, MS Office
Ø Application
Summary: NewAirFilters.com provides residential and commercial
customers with an easy way to order air filtration products online.
Ø Project
Summary: NewAirFilters.com recognized an opportunity to
provide customers with an easy, cost effective way to order air filtration
products online. Many of NewAirFilters.com’s
products are not available in home improvement stores.
Ø Responsibility
Summary: Web-based project using a standard development
life cycle. Planned and executed the
entire life cycle of the project including developing the Project Plan in MS
Project. Evaluated, recommended, enhanced, implemented, and maintained an
eCommerce package and company’s website.
Position
Title Management Consultant
Tools
Utilized MS Access, VBA, MS
Office
Ø Application
Summary: This application, Work-Wares, was an
eMarketplace for Wachovia’s mid-market customers.
Ø Project
Summary: This
project would allow customers to purchase goods and services from vendors in
the eMarketplace. The vendors provided
competitive pricing due to the large volume of purchases from the combined
customer base.
Ø Responsibility
Summary: Identified, documented, and tracked over 500
issues in a new eMarketplace product based on Microsoft Commerce Server.
Created and maintained an issue tracking database using MS Access and VBA. Performed administrator duties on Kana
Response, a comprehensive solution for
managing high volumes of inbound e-mail and Web-form inquiries.
Position
Title Management Consultant
Tools
Utilized MS Access, VBA, MS
Office
Ø Application
Summary: This application, Work-Wares, was an
eMarketplace for Wachovia’s mid-market customers.
Ø Project
Summary: This
project would allow customers to purchase goods and services from vendors in
the eMarketplace. The vendors provided
competitive pricing due to the large volume of purchases from the combined
customer base.
Ø Responsibility
Summary: Identified, documented, and tracked over 500
issues in a new eMarketplace product based on Microsoft Commerce Server.
Created and maintained an issue tracking database using MS Access and VBA. Performed administrator duties on Kana
Response, a comprehensive solution for
managing high volumes of inbound e-mail and Web-form inquiries.
Position Title Lead Architect/Project
Manger/eCommerce
Tools Utilized MS Project, MS Office, Visio
Ø Application
Summary: PBY-Direct was Pep Boys’ vision for ordering
all parts and accessories for any area within the company and for its retail,
commercial, and online customers. Pep
Boys sells over 200,000 parts and over 1,000,000 accessories.
Ø Project
Summary: Pep Boys had multiple ways to order parts and
accessories for their stores and distribution centers, and were evaluating
offering an online store. They wanted to
streamline their ordering process and provide a single source for parts for all
areas. Pep Boys also wanted to complete
a Proof of Concept project with one store, one supplier, and one product line.
Ø Responsibility
Summary: Mainframe and web project using Broadreach’s
standard life cycle. Responsible for the design of the PBY Direct project. Project manager for the Proof of Concept
project. Developed project plan in MS
Project. Managed the vendor responsible
for the web application. Assigned and managed tasks to the supplier and the
customer departments involved in the Proof of Concept. Provided status updates to the PBY Direct
team through regular meetings and Pep Boy’s and Broadreach management through
regular status reports.
Client/Industry Blue Cross/Blue
Position
Title Project Coordinator
Tools
Utilized MS Project, MS
Office, Lotus Notes
Ø Application
Summary: The project was a migration from a mainframe
claims processing system to an AS/400 based managed care system. It involved approximately 20 sub-projects
covering all areas of the company.
Ø Project
Summary: This
project updated Blue Cross/Blue Shield (BC/BS) to a state-of-the-art managed
care system. It included many
sub-projects across the whole company.
Ø Responsibility
Summary: Project coordinator for the infrastructure
group. Project involved approximately 20
sub-projects that migrated an insurance claims processing system from an IBM
Mainframe to an IBM AS/400 system. Many of the sub-projects included
client/server and web technology. Worked
with individual project managers to ensure consistency among all project
plans. Mentored those needing assistance
in project management. Provided single
point of contact for the Infrastructure group with the Project Team. Provided regular status updates to the
Project Team and to the Infrastructure Group through regular status
meetings. Provided status updates to
BC/BS and Broadreach management through regular status reports.
Client/Industry American Medical Response/Ambulance
and patient transport
Position
Title Project Manger
Tools
Utilized MS Project, MS Office
Ø Application
Summary: The AMR project installed mobile computers in
AMR ambulances for dispatching ambulances and providing patient information.
Ø Project
Summary: AMR needed to reduce their reliance on their
private radio network for dispatching ambulances. They implemented mobile computers in their
ambulance fleet to provide for dispatching of ambulances and to provide crew
and patient updates to the central dispatch system.
Ø Responsibility
Summary: The AMR project utilized mobile computers, the
RAM Mobile Data wireless network, NetTech middleware, and Paradigm4 developed
switching software to dispatch ambulances and collect patient information. Managed project from development through
implementation. Modified and updated the
Project Plan using MS Project. Managed
Paradigm4 and sub-contractor resources and assigned and managed tasks to AMR. Provided regular project status updates via
status reports and customer meetings.
Client/Industry
Position
Title Executive Program
Manger
Tools
Utilized MS Project, MS Office
Ø Application
Summary: The
Texas Data Link System (TDLS) is a network based Emissions Management
Information System used by the State to manage, monitor, and report emissions
data to the United States Environmental Protective Agency. Over 2,000 emissions stations contact an
MCI-housed Oracle database using a combination of 800, wide-area, and local
area networks.
Ø Project
Summary: MCI
provided the network, data system, network & computer operations, technical
help desk, customer service desk, and billing for the project. This system allowed the State to meet the
Federal Clean Air Act of 1990s requirements.
Ø Responsibility
Summary: The
TDLS was a client/server and web project using an Oracle 7 database, Sun
servers, custom software, and the network MCI backbone. Worked on all phases of the project including
sales calls, proposal development, contract negotiations, and led the design,
development, implementation, and operation.
Managed subcontractors and MCI resources in six different locations
around the
Industry State & Local
Government
Position
Title Systems Integration
Manger
Tools
Utilized MS Project, MS Office
Ø Application
Summary: One of
six people that grew a new Network and Systems Integration Unit to over $250
Million in contract revenue. Worked with the National Account Managers and
internal MCI resources to provide system and network integration services for
various customers.
Ø Project
Summary: Led the design, development, and implementation
of technical solutions in response to new business opportunities.
Ø Responsibility
Summary: Implementation manager for the CA Emissions
project, transitioning the project from the development phase to the operations
phase. Technical project manager for MCI
TimeClerk, a patented ANI-based Time and Attendance system for In-Home Health
Care workers in the New York State Medicaid program. The 800 calls are routed via neworkMCI to the
Phoenix-based platform where a Telephone Application Controller (switch) and
Telephone Application Processor (database) handle intelligent call information
and interfaces with the healthcare provider premise-based system, billing, and
customer functions. Project manager for
the Missouri Department of Revenue Audio Response Unit based Tax Filing system. This system allowed seasonal businesses to
file quarterly tax returns via MCI’s Enhanced Call Routing platform. Led overall effort for communication between
networkMCI and
Company EDS, IT Service
Provider, November 1987 – May
1995
Client/Industry City of
Position
Title Account Manager/Dallas
Parking
Tools
Utilized MS Project, MS
Office, MS Access
Ø Application
Summary: The
Parking Ticket Information Processing System (TIPS) provided the City of
Ø Project
Summary: The City of
Ø Responsibility
Summary: Politically sensitive project in EDS’
hometown. Took over this project in the
development phase to improve relations between EDS and the City. Addressed the City’s concerns by implementing
processes and procedures developed in cooperation with and approved by the
City. Developed the Project Plan in MS
Word for the proposal. Enhanced and
updated the project plan after taking over the project. Provided ad-hoc reporting for the city using
MS Access. Hired and managed
professional and clerical resources.
Assigned and monitored tasks to sub-contractors and internal EDS departments. Responsible for P & L and the 5-year,
$2.5M contract. Developed and managed
change management process. Provided
regular status updates to the City and EDS management through meetings and
status reports.
Client/Industry City of
Position
Title SE Supervisor/Chicago
Parking
Tools
Utilized MS Office, MS
Project, Timeline
Ø Application
Summary: The Parking Enforcement Management System
(PEMS) provided the City of
Ø Project
Summary: EDS integrated leading edge technology with an
IBM mainframe-based application to create the Parking Enforcement Management
System, an award winning system that helped
Ø Responsibility
Summary: Led a team of 6 - 10 systems and operations
professionals, including business analysts, computer operators, and
programmers. Responsible for performance
reviews and salary administration.
Supervised the implementation of several systems, including the
conversion of 22 million backlog tickets worth over $400M. Supervised the design, development, and implementation
of enhancements to the Chicago Parking Enforcement Management System. Developed several project plans for
sub-projects and proposals. Gave
presentations to City Personnel and EDS management on various topics and
project status. Head writer for the
Client/Industry
Position
Title Systems Engineer/Dallas
Support
Tools
Utilized COBOL, JCL, CICS,
VSAM
Ø Application
Summary: EDS
provided the hardware, software, programming, and operations to Blue Cross/Blue
Shield of Colorado for the State’s Medicaid claims processing system
Ø Project
Summary: EDS was a subcontractor to Blue Cross/Blue
Shield of Colorado for the State’s Medicaid Claims Processing system.
Ø Responsibility
Summary: Designed, developed, and maintained programs on
an IBM mainframe using COBOL, JCL, CICS, and VSAM. Provided on-call support for the batch cycle
7x24 for one week at a time every 2 months.
Client/Industry National Heritage Insurance Company
(NHIC)/Healthcare/Medicaid Claims Processing
Position
Title Systems Engineer
Tools
Utilized MS Word
Ø Application
Summary: NHIC
insured all Medicaid recipients in the State of
Ø Project
Summary: NHIC, an EDS subsidiary and an insurance
company, provided all claims processing for the State’s Medicaid program.
Ø Responsibility
Summary: Worked in a business analyst role gathering
requirements, documenting enhancement requests, working as a liaison with the
development staff, and performed system testing. Led two major projects: the annual profile
build, which sets professional service prices for the coming year, and an
interface with an electronic claims provider.
EDUCATION
TRAINING
Project
Management, EDS
Leading
People, EDS
Coaching
& Developing People, EDS
Presentation
Techniques, EDS
Basic
Leadership, EDS
Systems Engineering Development Program, EDS