Quality Assurance Project
Resume:
Wayne Coffman
Overland Park, KS 66213
913-***-**** / *********.**@*****.***
SUMMARY
Extensive experience as a business systems analyst in health-care, customer and product
management, accounting, finance, billing, and data warehousing. Also experienced in SQL
reporting, training, quality assurance, supervision, and project management.
PROFESSIONAL EXPERIENCE
Blue Cross and Blue Shield of Kansas City
Business Systems Analyst January 2010 - present
Serving as lead analyst for the Integrated Health Management Technology Services Group.
Responsibilities include modeling business processes, defining business, functional, data, and
system requirements, leading JAD sessions, project management, test planning, quality assurance,
and end-user training for in-house and vendor systems, which are integrated with the corporate web,
reporting, and data warehouse applications. Technologies utilized by in-house systems include
Crystal/InfoView reports, Data Stage ETL, and DB2 databases. Primary vendor systems include
Facets and Alineo.
Embarq – Overland Park, Kansas
Supervisor / Sr. Business Analyst December 2005 – January 2010
Hands-on leadership of team responsible for system enhancements, maintenance, and report
development for customer and revenue data warehouse, which supported 11 million customers and
$6 billion in annual revenue. Served as the liaison between IT and the user community, identified
business and system requirements, led JAD sessions, developed reports and data extracts, and
managed projects, off-shore developers, and staff. Technologies used in this role include Oracle and
Teradata data warehouses, Informatica ETL, complex SQL queries, and Crystal/InfoView reports.
Sprint – Overland Park, Kansas
Project Leader / Sr. Business Analyst September 2003 – December 2005
Led large development projects to enhance the customer billing systems, which included a major
invoice format upgrade, introduction of new products, and improved accounting controls.
Responsibilities included defining business and system requirements, project management, test
planning and execution, and end-user training.
Led joint application design sessions for multiple source systems during creation of enterprise-wide
data warehouse. Responsibilities included defining requirements for customer and revenue
reporting, designing system interfaces, test planning and execution, and project management.
Mid-Missouri Telephone – Pilot Grove, Missouri
Controller May 2003 – September 2003
Overall responsibility for accounting, billing, and regulatory reporting activities for the phone company,
an Internet subsidiary, and parent holding company. Direct responsibility for financial and operational
analysis, budget to actual comparisons, forecasting, and staff supervision.
Sprint – Overland Park, Kansas
Senior Supervisor December 2000 – May 2003
Managed a 12 person team responsible for billing intra-carrier services. Activities included
monthly billing operations, definition of business and system requirements driven by regulatory
changes and process improvements, reporting, variance analysis, and stakeholder management.
1
Wayne Coffman
12822 Barton Street
Overland Park, KS 66213
913-***-**** / *********.**@*****.***
PROFESSIONAL EXPERIENCE
(Continued)
Sprint – Overland Park, Kansas September 1999 – December 2000
Program Manager / Sr. Business Analyst
Led system development projects to improve the corporate real estate data warehouse and
associated applications by providing enhanced business reporting, reducing cycle times, and
improving controls. Activities included identifying business and system requirements, project
planning, system design, training, mentoring team members, and vendor management.
21st Century Solutions, Inc. – Liberty, Missouri
Project Leader / Business Analyst June 1997 – September 1999
Led development and implementation of technology solutions to meet corporate client needs,
including process automation, reporting, and web-site design. Activities included project
management, business and system requirements definition, system design, testing, training, and
client relationship management.
Sprint – Overland Park, Kansas
Sr. Business Analyst / Project Leader February 1991 – June 1997
Directed teams responsible for billing carrier services, designing and implementing new billing
systems, and automating processes. Also evaluated company performance against contractual and
regulatory requirements and led stakeholders in implementing corrective action. Responsibilities
included project planning, defining business and system requirements, system design, software
development, testing, process re-engineering, training, and resource management.
United Telephone – Bristol, Tennessee
Accountant June 1988 – February 1991
Rotated among several departments in progressively more responsible positions within message
processing, settlements, end-user billing, and carrier billing. Responsibilities included financial
analysis, regulatory audits, implementing tariff changes, and general ledger activities.
EDUCATION
Bachelor of Science – Accounting, May 1988
Virginia Polytechnic Institute and State University – Blacksburg, Virginia
CERTIFICATIONS
Certified Public Accountant
2
Wayne Coffman
12822 Barton Street
Overland Park, KS 66213
913-***-**** / *********.**@*****.***
APPLIED EXPERIENCE
• Databases: Teradata, Oracle, DB2, SQL Server, MS Access
• Reporting: SQL, Crystal, InfoView, OBIEE
• Other: Visio, Word, Excel, PowerPoint, Project, TSO, SharePoint
• System Development Life Cycle: business, functional, data, and system requirements definition, joint
application design, data modeling, data mapping, test planning & execution, documentation, training,
implementation
• Project Management: business case development, project planning, managing scope, cost,
resources & schedule, status reporting, sponsor relationship management, post implementation
reviews, managing vendor and off-shore resources
REFERENCES
Dan Willard 913-***-**** 112 N. Chambery
Olathe, KS 66061
Susan Doyle 816-***-**** 403 Glen Arbor Rd
Kansas City, MO 64114
Elaine Mills 816-***-**** 305 W. 114th Street
Kansas City, MO 64114
3
Contact this candidate