William McKown
*** **********'s Way, Durango, Co 81303
Home: 970-***-****, Cell: 813-***-****
*******@*****.***
WORK EXPERIENCE
*/**** ** **/**** Verizon Data Services, Tampa, FL
Lead Systems Consultant
. Train and Lead cross-functional local and global
Requirements team on all system projects for
Assignment, Activation and Inventory System (AAIS
Core), ERC, Local Number Portability Gateway (LNPGW),
NTAS and SPIRIT.
. Create and manage detailed technical documentation
using System Architect and in-house repository system.
. Determine and gather system requirements and
specifications for complex application development
projects in Oracle, SAP, IBM systems within budget and
timeline.
. Coordinate and communicate system requirements and
cost with business owners, multifunctional teams,
programmers, program managers and testers.
. Completed Database consolidations projects for 12
datacenters on Verizon footprint.
. Facilitate Requirements, Testing and Design (RTD)
sections during teleconferencing and Requirements
Gathering Sessions (RGSs).
. Document Business Requirements and define System Design.
. Follow defined methodology practices and standards
throughout the System Development Life Cycle.
. Interface with Business, Testing and Developers at all
levels to gather system requirements and resolve
system issues.
. Design and maintain business systems through
requirements definitions, analysis, design,
construction, integration, and implementation,
ensuring the delivery of quality systems and service
for all products.
. Manage internal requirements websites.
10/2001 to 2/2005 Public Defender's Office, 13th Judicial Circuit,
Tampa, FL
Programmer Analyst
. Provided programming design, software enhancements &
modifications for all eleven in-house applications
using VB, ASP, VB.NET, ASP.NET, MS SQL, DCOM, Crystal
Reports, Oracle, Info Maker, Install Shield, Visio, MS
Project.
. Controlled access, performance monitoring and tuning
of all in-house databases with MS SQL Server, Oracle
or MS Access.
. Designed and developed in-house databases to meet
new user needs and responded to/anticipated
technological innovations.
. Designed MS SQL Server jobs, triggers, and stored
procedures on in-house databases.
. Reviewed existing programs made refinements, reduce
operating time, and improve techniques.
. Planned and created Install Shield for applications in
VB 6 to .NET.
. Created Install Shield for new in house installs and
automatic upgrades.
. Developed, wrote and maintained complete
program documentation.
. All testing of applications developed or modified,
including development of testing procedures and
scripts.
. Determined and analyzed budget for vendor purchased
products.
. Coordinated with CIP (vendor) and users on
identification of software problems, modifications
or enhancements on contracted applications.
. Held user group meetings with support staff on new in-
house developed software applications to gather input
on systems or required enhancements.
. Created data flow diagrams, ERDs and business rules
for programs and databases using Visio.
. Provided technical assistance and knowledge to all
computer staff and users.
9/2000 to 3/2001 USF School of Architecture & The Florida Center for
Design & Research, Tampa, FL
Programmer Analyst
. Designed and implemented Visual Basic using ADO for MS
SQL 2000 and MS Access database projects.
. Built intranet website for staff using ASP, HTML and
SQL 2000 database.
. Created data flow & ERD diagrams of business processes
and databases using Visio.
. Evaluated, planned and performed PC repair and
upgrades as necessary.
. Configured local & network installations and supported
various software packages, including NT, 2000, NT/2000
Server, AutoCAD, Arcview, ACT.
. Assured that all network resources were protected with
industry accepted backup and recovery procedures.
1/1999 to 10/2001 Carson International Inc., Ketchum, ID
Systems Analyst
. Managed & trained 20 employees on setting up and
maintaining 30 computers for Purina's Incredible Dog
Challenge Video Game Competition.
. Designed Visual Basic applications for the
scoreboard, which displayed graphics, scores, and
advertisements for the Purina's Incredible Dog
Challenge USA Network television show.
. Analyzed and communicated with software vendor on
modifications & fixes for Purina's Incredible Dog
Challenge video game.
. Computerized event scoring, final scoring and
management reports for Purina, Carson International
and Diamond P productions.
. Worked contracted events in New York, San Francisco,
Seattle, St. Louis, Chicago, San Antonio, Park City,
and Sydney, Australia.
EDUCATION & CERTIFICATIONS
8/1998 - 8/2001 University of South Florida; Tampa, FL
B.S., Business Admin, Management Information Systems,
Major GPA: 3.62
Overall GPA: 3.15; Graduated: August 2001
08/2007 - 4/2009 University of South Florida; Tampa, FL
Executive MBA Program
GPA: 3.75; Graduated: May 2, 2009
Expected 03/2013 Project Management Professional (PMP), Certification
through Project Management Institute (PMI)
TECHNICAL HIGHLIGHTS
Verizon Systems:
AAIS Core, ESAP, NTAS, LNPGW, SPIRIT - 7 yrs, IPM and IPM
Requirements - 4 yrs, FORTE - 4 yrs, Remedy - 4 yrs
Languages:
SQL - 8 yrs, Stored Procedures - 8 yrs, MS SQL Triggers - 5 yrs,
SQL*Plus - 5 yrs, XML - 8 yrs, C - 6 yrs, C++ - 6 yrs, JAVA - 5 yrs,
HTML - 12 yrs, PHP - 5 yrs, MySQL - 5 yrs, JavaScript - 5 yrs,
ColdFusion - 5 yrs
Applications:
Visio - 8 yrs, MS Project - 7 yrs, System Architect - 4 yrs, SQL
Server - 6 yrs, Visual Studio - 8 yrs, MS .NET 2003 - 2 yrs, Crystal
Reports- 5 yrs, Oracle - 5 yrs, Macromedia Dreamweaver - 3 yrs, Info
Maker 7 - 3 yrs, Install Shield - 2 yrs, FrontPage 2003 - 4 yrs,
Lotus Notes - 4 yrs, Corel Suite - 4 yrs, Office Suite - 12 yrs,
GroupWise 5.5 - 3 yrs
Environments:
Windows, Windows Server, Mac OS, Linux, Unix, IIS, Novell Server,
Oracle
ACTIVITES & HONORS
. Graduate of Verizon ISOP Leadership Program
. Management Information Systems Society, USF
. Business College Council, USF
. Sierra Club, Tampa Bay Group, Past Webmaster
. Developers Forum, Tampa Bay
. Tau Kappa Epsilon, Lambda Alpha Colony, USF, Chapter
Founder & Past Webmaster
. The Distinctive Achievement in Academic Excellence, USF
. Honored in Principles of Accounting Banquet, USF