Project Manager Customer Service

William H. Bourner

**** ****** ***** **** . ***** Louis Missouri, 63129

314-***-**** Home . 314-***-****) Cell

ablosk@r.postjobfree.com

QUALIFICATIONS SUMMARY

Information technology professional with significant experience in Software

Development Life Cycle, client interaction and requirements analysis. Self

starter with the ability to work with minimal supervision. Experience

includes over 20 years in Analysis and Systems Engineering. Additionally

skilled in Data Analysis, Team Leadership and Problem Resolution. Degreed

professional with excellent communication skills, both verbal and written.

SKILL PROFILE

Languages: VB.Net, Visual Basic 6.0, ASP.Net, SQL, PL/SQL, ADO, RDO, DAO,

ASP, HTML, XML, MS-DOS, MVS, COBOL, JCL

Software: Oracle SQL Developer, Rational Requisite Pro, Rational Test

Manager, MS Visual Studio, MS SQL Server Management Studio,

MS SourceSafe, MS Project, MS Visio, MS Excel, MS Word, MS

Outlook, MS FrontPage, Crystal Reports, Supply Tech EDI,

TSO, VSAM, ISPF, Predict, Pan Valet

Databases: Oracle 10g, MS SQL Server 7.0, 2000, 2005, MS Access

Operating Systems: Windows 95, 98, NT, XP Professional, Windows Server

2003

Hardware: IBM PCs, HP-UX, IBM Mainframe

Other Skills: Software Development Life Cycle, Data Flow diagramming,

Process Flow diagramming, Entity Relationship diagramming,

Cross-functional diagramming

Military Service: United States Navy, Advanced Electronics, Secret

Clearance

BUSINESS EXPERIENCE

Continuing Education June 2010 - Present

Currently pursuing additional skills in business analysis at the Center for

the Application of Information Technology (CAIT) at Washington University

Received PL/SQL training from University Missouri Saint Louis

Bradford & Galt - St. Louis, MO August 2006 - May

2010

Consultant

Assignment - Express Scripts (August 2007 - May 2010)

Provided support for Pharmacy Technology multi-million dollar automated

fulfillment systems

. Applied numerous software enhancements in support of mission

critical applications

. Worked with developers, systems analyst, project manager in

identifying requirements

. Identified test scenarios, scripted test cases and performed system

testing of applications

. Used extensive knowledge of Oracle SQL in analyzing data to resolve

production issues

. Teamed with vendor, FedEx, in gathering requirements for application

interface. Mapped data from shipping application to multiple FedEx

transaction sets.

. Conducted code reviews with off shore team ensuring applications met

coding standards

. Mentored staff on application development standards

. Created and updated process flows for existing applications

. Provided weekly status reports to management

. Maintained Oracle database by adding and updating table definitions.

Assignment - A.G. Edwards (August 2006 - July 2007)

Responsible for remediation and testing of AIM applications during

migration from IBM mainframe to HP-Unix environment

. Self trained on Rational TestManager, Rational ClearCase and

Rational Requisite Pro

. Teamed with project mangers, business analysts and developers in

identifying requirements used to create architectural and detail

design specifications

. Identified test scenarios, scripted test cases and conducted

assembly testing

Analysts International - St. Louis, MO April 2006 -

August 2006

Consultant

Assignment - Magellan Health Services

Responsible for development of medical claims reports for internal and

external clients

. Gathered requirements from subject matter experts, analysts and

developers

. Developed numerous complex Oracle SQL queries used in the reporting

process

. Improved process of importing medical data. Documented process and

trained users in new procedures. New process reduced manual effort of

importing data by 60%.

Lindstrom & McKenny - St. Louis, MO February 2005 -

March 2006

Analyst/Developer

Responsible for evaluation and upgrading of companies automated systems

. Elicited requirements from business owners covering Inventory, Memos

and Invoicing

. Created business, functional and data requirements documents

. Conceived, designed an implemented application interface between sales

and accounts receivable systems. Application reduced time required to

balance accounts receivable by 70%.

Self Employed - St. Louis, MO June 2001 -

February 2005

Analyst/Developer

Responsible for analysis, design and development of web based

applications

. Designed and developed Auction Solutions web site. Web site presents

information on online auctions. Gathered and documented requirements,

designed, coded and tested application

. Designed and developed web site for Missouri Bait Works. Key features

include integration of third party payment processor PayPal and

integration of web services feed from Amazon.Com

Daugherty Systems - St. Louis, MO July 1999 - June 2001

Consultant

Assignment - Monsanto (October 1999 - June 2001)

Team lead during design, development and deployment of web based sales

tracking system

. Gathered business and functional requirements from stakeholders

. Created timeline, cost and resource estimates

. System implemented on time and under budget, under aggressive timeline

Lead analyst on AG Commerce database marketing web project

. Responsible for gathering and analyzing data from multiple sources

. Cleansed and normalized production data

. Developed Oracle SQL queries to update production database

. Enhancements resulted in a 51% decrease in time required to load

production data

Lead analyst during Envision project

. Conceived, designed and implemented enhancements to existing sales

forecasting system

. Enhancements resulted in a 12% reduction in processing times

Assignment - Anheuser-Busch (June 1999 - September 1999)

Business analyst responsible for testing and remediation of MSG

applications during migration from Windows 95/Office 95 to Windows

2000/Office 2000 desktop environment

. Created test plans, test cases and test scripts for MSG applications

. Assisted users with acceptance testing

Partec - St. Louis, MO March 1999 - June 1999

Consultant

Assignment - Computer Sales International

. Gathered requirements from users for major upgrade to the asset

tracking system. System was used to track leased assets and customer

lease provisions.

. Developed prototype based on requirements and presented to the user

community.

Systems Service Enterprises - St. Louis, MO March 1997 - March

1999

Consultant

. Responsible for developing timelines and cost estimates in support of

ongoing projects

. Team member on project to upgrade Ameren corporate web site. Worked

with stakeholder in identifying requirements.

Assignment - Microsoft

. Teamed with Microsoft in design and development of object-oriented

application. Application assists beverage distributors in optimizing

product placement on store shelves.

Maritz - St. Louis, MO March 1988 - March 1997

Business Analyst/Senior Systems Analyst

Provided ongoing support for multiple corporate systems

. Responsible for leading and coordinating efforts of eleven analysts

and programmers. Project eliminated duplicate systems and merged

company data assuring successful merger of two company divisions.

Developed project plan, assigned tasks and held regular staff

meetings. Project completed ahead of schedule.

. Responsible for automation of manual processes between distribution

center and order processing departments. Automated distribution center

with third party software and hardware, which reduced manual effort by

60%. Designed and implemented hardware, software and procedures

integrating distribution center PC with corporate mainframe.

Enhancements reduced billing cycle by 50%.

. Project lead during selection and deployment of company's first EDI

application. Evaluated and selected third party software, hardware and

value added network (VAN). Mapped data from order processing

application to EDI 850 purchase order transaction.

. Lead analyst during conversion to Oracle financials general ledger.

Mapped data from accounts receivable and billing systems to new

general ledger. Identified and resolved data issues with missing and

invalid data. Modified systems to create data feeds to the general

ledger.

. Supported large user communities in the areas of Order Processing,

Fulfillment, Inventory, Billing, Accounts Receivable, General Ledger,

Loyalty Marketing and Customer Service.

EDUCATION AND TRAINING COURSES

Bachelor of Science, Business Administration

University of Missouri, Saint Louis, Missouri

Additional Education / Training

Client/Server Systems Relational Database Design

Building a Successful Client/Server System XML

Best Practices for Web Based Architectures Extensible Markup

Language (XML)

Microsoft Project Extensible Style Sheet

Language (XSL)

MS Project Server MS Visual InterDev 6.0

Rational Unified Process (RUP) UML

Intermediate Applications of SQL Visual Basic 6.0

Advanced Applications of SQL Crystal Reports

PL/SQL

Military Service

Advanced Electronics Technician, United States Navy

. Six years of active duty service

. Received advanced electronics theory training

. Responsible for troubleshooting and maintenance of over 100 high power

transmitters used for communications with United States Navy ships and

aircraft

. Obtained secret clearance

Certifications

Registered Pharmacy Technician in the state of Missouri

Contact this candidate