Steven N. Brafford, MBA
5611 Wyndemere Circle
Mineral, VA 23117
[Send email to request phone number] 54-4207 (h)
[Send email to request phone number] 40-0904 (c)
I am a senior Information Systems professional with an MBA offering more than 30
years of experience as a Senior Business Analyst, Senior Systems Analyst, Quality
Assurance, Project Manager, and Manager. I have strong documentation skills, am
able to develop and maintain effective working relationships, and skilled in SDLC
- System Development Live Cycle. I have often worked with business
representatives at all levels in diverse companies - Vice Presidents, Directors,
Managers - to develop business requirements and then work to fulfill those
requirements. I have developed use cases, test cases, entity relationship
diagrams, and data flow diagrams. I have had to ensure that standards and
procedures are followed - down to the level of reviewing program code - and been
involved in developing standards and policies. I have worked with data management
for over ten years of my career - database design, GAP analysis, data flows, data
mapping, data definition, and data movement.
Industries:
BCBS Insurance, Medicaid Insurance, Credit Card, Power Generation,
Transportation, Consulting, Grocery Retail, Grocery Wholesale, Manufacturing,
State Government, Local Government, Software Development
Functional Areas:
Business Analyst, Systems Analyst, Quality Assurance, Project Leader, Team
Leader, Manager of Application Development, Test Lead, Technical Designer,
Developer
Methodologies:
General SDM/SDLC to include Business Requirements, System Requirements, High
Level Design, Detail Design, Construction, Unit Test Cases, Integrated Test
Cases, and System Test Cases; PMI methodology, IIBA methodology
SKILLS PROFILE
Application Package:
Enterprise Reporting, Claims Reporting, Case Management, Utilization Management,
Disease Management, Inventory Management, Perishable Inventory Management,
General Ledger, Payroll, Accounts Payable, Accounts Receivable, Labor Management,
Order Processing
Databases / DB Tools:
DB2, Oracle, SQL Server, Teradata, SPUFI, Toad, VSAM, IMS
Desktop Tools:
Mercury Quality Center, Microsoft Office Suite, Microsoft Project, Microsoft
Access, VISIO, Primavera's P3e
Hardware:
IBM Mainframe, Unisys, PCs
Operating Systems:
MVS/ESA, DOS/VSE, WINDOWS 3.1/95/98/XP/2000, Unisys, Pick
Programming Languages:
COBOL II, CICS, Assembler, Pick, RPG II, QUIKJOB, EASYTRIEVE
Testing Tools:
Mercury Quality Center, Toad, File-Aid, SPUFI, QMF, Xpediter
Utilities / Command Languages:
Sort, IDCAMS, BMS, Control-M, Librarian, ISPF, SDSF
PROFESSIONAL EXPERIENCE
KEANE, INC. 01/05-CURRENT
CAREFIRST BCBS
MEDICAL INSURANCE 06/08 - CURRENT
SR BUSINESS ANALYST
PROJECT DESCRIPTION SUMMARY
Installation of a corporate wide data warehouse and centralized web-based
reporting tool which combined data from three operational systems for reporting
and analysis of claims, enrollment, and revenue.
* Worked closely with several functional areas - small group pricing, large
group pricing, marketing, strategic planning, and audit - in the development of
several business requirements documents sent to the vendor of a centralized
reporting tool which uses the "cube" and "dimension" structure. These documents
specified how the data would be summarized, calculated, and presented.
* Recommended process, procedure, and reporting changes.
* Utilized Visio and PowerPoint in presentations.
* Worked with the above mentioned groups to provide requirements for extracts
and reports for both the vendor of the software and to internal development
staff.
* As Sr. BA, planned and coordinated work of three other BAs and two data
analysts.
* Led requirement elicitation meetings often using web meeting tools.
* Kept client management informed of requirements' status, risks and issues.
* Worked to resolve issues.
* Performed data mapping of existing databases to new reporting tool.
* Used Mercury Quality Center for test management.
* Wrote test cases for the above mentioned requirements.
* Performed user acceptance testing with the various functional areas.
AMERIGROUP
MEDICAID INSURANCE 02/07 - 06/08
SR. BUSINESS ANALYST, END TO END TEST MANAGER
PROJECT DESCRIPTION SUMMARY
Installation of a web-based "case" management - utilization, disease, and case -
software package to process all subscribers. Testing of enhancements necessary to
support the HIPAA National Provider Identification (NPI) imitative.
* Developed business requirements and system requirements in conjunction with
several functional areas for use in the configuration and customization of the
package, development of six data feeds from legacy systems, data conversion from
legacy system, and design of 80 custom reports.
* Developed and executed test cases keeping business area informed of status.
* Worked extensively with business and software vendor in the configuration,
customization and testing.
* Developed E2E Test Plan and worked with 10 functional areas in the testing of
the HIPAA NPI (National Provider ID) requirement across 17 application systems.
* Utilized Mercury Quality Center 9.0 Testing Tool.
NASCO 08/06 - 01/07
BCBS MEDICAL INSURANCE SOFTWARE
LEAD SYSTEMS ANALYST
PROJECT DESCRIPTION SUMMARY
Upgrade to new release of the NASCO software - member enrollment, billing, and
claims processing - at one of their clients.
* Led team of three systems analysts in developing software upgrade plan.
* Working with NASCO's client to perform detailed impact analysis of their
system.
* Created project plan for software upgrade.
INTERNAL STAFFING ASSIGNMENT 04/06 - 08/06
VENDOR MANAGEMENT LIAISON
PROJECT DESCRIPTION SUMMARY
Liaison between a large client's (15-50 new requirements per week) vendor
management system and Keane's various staffing groups and select
sub-contractors.
* Forwarded new requirements to appropriate staffing group, submitted
candidates to client, coordinated interviews, and coordinated on-boarding
activities.
* Provided Keane management with weekly metrics
AMERIGROUP 02/06 - 03/06
MEDICAID INSURANCE
BUSINESS ANALYST
PROJECT DESCRIPTION SUMMARY
Formulate Amerigroup's response to a readiness review from the state of Georgia
consisting of over 425 items in preparation to Amerigroup performing Medicaid
services in that state in June 2006.
* Worked with business representatives to articulate the answers. This involved
interviewing, composing responses in a consistent manner and reviews with VP
responsible for the project.
* Produced a Power Point presentation comprised of over 600 slides that was
reviewed by multiple groups in a one week presentation to representatives from
Georgia.
DOMINION POWER 08/05 - 01/06
ELECTRIC POWER GENERATION
BUSINESS ANALYST
PROJECT DESCRIPTION SUMMARY
Configuration, customization, testing and installation of work scheduling
software into a recently purchased nuclear power plant.
* Met with business representative to determine the requirements for
interfacing their work management system into Primavera's P3e scheduling package
and from P3e into their other systems.
* Performed data mapping and GAP analysis to replace their scheduling package
with Primavera's P3e package.
* Worked closely with their technical staff to develop technical specifications
for development of interfaces from their work management system into P3e.
* Developed system test cases and assisted in system testing.
* Developed implementation plan.
* General support of software at three other nuclear plants.
* Conducted training for Business Systems Analysts
* Developed system requirements and technical specifications for four Key
Performance Indicator (KPI) reports that will be used by all four nuclear plants
to satisfy certain nuclear industry reporting requirements. Performed unit and
system testing of these reports.
Environment: Oracle, MVS, COBOL II, MS Office, Visio, P3e
NEWPORT NEWS / SPIEGEL 05/05 - 08/05
WOMEN'S APPAREL
BUSINESS ANALYST / LEAD DEVELOPER
PROJECT DESCRIPTION SUMMARY
Replace physical paper gift certificates with plastic gift cards similar to
those common in the retail industry and revamp their web-sites to support the
purchasing of gift cards. The project was intended to increase business 10 to 15
percent.
* Developed business requirements by working with local and corporate
management.
* Analyzed existing systems and developed change specifications for three
external vendors and for internal systems.
* Develop SDM documentation for System Design, Detail Design, Unit Testing, and
System Testing.
* Assisted project management with the development and maintenance of project
plan.
* Assisted project management with change control.
Environment: MVS, COBOL II, File-Aid, CICS, MS Office, DB2, VSAM
CAPITAL ONE
FINANCIAL
01/05 - 05/05
Technical Designer
Project Description Summary
Multiple enhancements to one of their Account Management Systems.
* Received business requirements from client and developed SDM documentation -
system design, detail design, test plan, unit test cases, and system test cases.
* Reviewed unit and system test results.
Environment:
MVS, COBOL II, File-Aid, MS Office, VISIO
IPC TECHNOLOGIES
DOMINION POWER
ELECTRIC POWER GENERATION
04/04 - 01/05
Systems Analyst
Project Description Summary
Configuration, customization, testing and installation of a standardized work
scheduling software into their three nuclear power plants.
* Worked with corporate management and business representative from three
nuclear power plants to develop the requirements for the interfaces from three
work management systems into the new enterprise scheduling package - Primavera
P3e. Worked with the same group to develop the requirements for feeds from P3e
out to various other systems at the plants.
* Worked with corporate management and plant representatives to configure P3e
in a standard manner across the e |