Peter H. Kelly
Senior Business Systems Analyst
Minneapolis, Minnesota, 55411
Home: 612-***-**** Cell: 612-***-****
abicuo@r.postjobfree.com
Professional Summary
As a Senior Business Systems Analyst Peter Kelly offers a wealth of
knowledge based on twenty four years experience. This experience includes
defining manual processes and their complementary data processing systems
for such institutions as
. Blue Cross Blue Shield of Minnesota,
. General Electric,
. Wells Fargo,
. Cargill,
. The Carlson Companies,
. Guidant Cardiac Pacemakers,
. C.H. Robinson,
. Bremer Bank,
. Minneapolis City Hall.
Experience
Wells Fargo
Minneapolis
Corporate Division -
Enterprise Risk Management Technologies-
Anti Money Laundering and Terrorism
Senior Business Systems Analyst (7/2010 - 12/15/2010)
Wells Fargo and Wachovia Banks have grown dramatically over the last
decade through mergers and acquisitions. This has made the analysis of
transactions for Money Laundering and Terrorism difficult. The
unification of these two institutions in 2009 has made this challenge
even greater. My project is to design a new system that will allow the
complete and unified transactions of both banks to come under one
system for scrutiny. It requires analyzing the different business
models and data processing models of the various institutions to
develop a single view of all transactions to uncover Money Laundering
and Terrorist activities.
Ingenix (Employee)
Eden Prairie
Corporate Division
Senior Business Systems Analyst (10/2009 - 7/2010)
Ingenix is a subsidiary of the United Health Group. Ingenix produces
literature that support medical procedural coding. In the last few
years they have grown through acquisition to include 23 companies.
All the acquisitions have complemented the company's core competency.
Primary responsibility has been managing requirements for outward and
inward facing Website development. This work has spanned the Websites
for companies owned buy Ingenix and Websites for other United Health
Group companies. This has included
. Developing Statements of Work
. Use Cases & Business Rules
. Wireframes.
Carlson Companies (Contractor)
Plymouth Minnesota
Corporate Division
Senior Business Systems Analyst (8/2009-10/2009)
The Carlson Companies is a highly diversified organization that
includes travel, restaurant chains, hotel chains and corporate
incentive programs.
Carlson is replacing an existing software package that helps manage
and track changes or incidents relating to computer technologies. It
helps support the IT help desk. Originally they were going to produce
3 different sets of documents to support three types of activities -
requirements, user acceptance testing and end user training. I
presented a new type of documentation that would support all three
activities. This shortened the project timeline by two months. The new
documents were fully embraced and are currently in use.
Blue Cross Blue Shield of Minnesota (Employee)
Eagan Minnesota
Enterprise Management Division
Senior Business Systems Analyst (7/2005-8/2009)
Blue Cross Blue Shield (BCBSMN) is medical insurance company with
regional and national accounts such as the Federal Government of the
United States, 3M, Target and many others. Two out of three
Minnesotans have BCBSMN as their primary or secondary insurance.
Techniques and Tools used:
. RUP "Lite" as the primary SDLC model,
. "Water Fall" model on occasion,
. Use Cases - Cockburn model, the Rational model and everything
in between,
. Business Rules,
. Business Requirements Documents ("The System shall. . . "),
. Requirements Traceability Matrix,
. Supplemental Requirements Documents,
. Page Specifications,
. Report Specifications,
. UML - Context Diagrams, Activity Diagrams, Sequence Diagrams,
. Traditional Flow Charts
. Reviewed white and black box test plans.
Leadership:
. Processing Electronic Adjustments - Claims processing is the
single most complex process for an insurance company. In
determining how to process adjustments to claims
electronically, instead of have 10 to 12 Subject Matter
Experts (SMEs), I had 42 SMEs. In this corporate culture a
simple majority is inadequate, complete consensus is required
for all requirement products. I led 42 SMEs to consensus on a
major modification to the company's most complex process in 6
months. The 6 month dead line was imposed due to a new state
statue. We were completed with full consensus in 5 months.
. Electronic Claims validation and pre-processing - As stated
above claims processing is the single most complex process
for insurance companies. When I arrived the requirements
documentation for the validation of electronic claims was
unusable by the Business SMEs and the technologists. In
addition there was no design documentation on the IT side. I
lead 14 SMEs and technologists through a documentation effort
that resulted in 28 Use Cases and over 170 Business Rules. In
this instance I had to gain the consensus of both the SMEs
and the technologists before the new requirements documents
were approved. This was accomplished in 3 months.
. Developing a process for creating multi-tiered Provider
Networks. - Three Business Analysts had failed on this
project when it was assigned to me. Blue Cross had not
constructed a new Provider network in 15 years. There were
35 SMEs involved from 7 departments. I invited all of them
to an initial meeting. They all showed up and there was
nothing but anger and frustration in the room. Over a 4
month period I rebuilt these professional relationship and
trust while developing 24 Business Use Cases. At the end of
four months I invited the 35 SMEs for a final sign off
meeting. There was laughter and teasing and best of all we
had consensus that the newly defined process was workable.
. Quality Assurance - When I arrived at Blue Cross the BAs only
involved Business SMEs. I start a new trend that became a
department standard of inviting representatives from both
Quality Assurance (QA) and from Technology to my requirements
meetings. Often these individuals knew about extreme or
unusual conditions that needed to be addressed that the
Business SMEs had forgotten about. I routinely ask for and
got criticism from my QA representative on the "testability"
of my work. More than once this resulted in additional
investigation of issues that were ambiguous. In return I
reviewed and advised on both the developer's white box test
plans and the black box test plans developed by QA.
Mentoring:
. Health Care Claim Payment/Advice and Health Care
Eligibility/Benefit Inquiry and Information Response - In
this project I was given an assistant who was straight out of
school. I was asked to mentor the new BA into the company's
standards. I lead and teach by example. I would run a
requirements gathering meeting with his help. We would do a
postmortem together and agree on the appropriate work
products to develop. After I developed the work products I
would review them with him, make changes and plan for the
next meeting. Then we would reverse roles! I believe that
this approach is very respectful of the other BA while at the
same time giving them an opportunity to learn new standards
in a real life setting.
Standards:
. When I arrived at Blue Cross the Cockburn model was used for
Use Cases. I help lead a gradual transition to the Rational
model. This allowed us to eventually use RequisitePro which
relies heavily on a Rational model for Use Cases.
. I was asked twice to write Use Cases that served as the
departmental standard and act as an example for the standard
Use Case model at Blue Cross.
Technologies addressed as a Senior Business Systems Analyst
. Java and XML,
. VSAM and COBOL,
. Oracle RDMS and PLSQL
. MQSeries Messaging to link the Mainframe and distributed data
processing environments.
Carlson Marketing Group (Contracting)
Merchandise Awards Division, IT - Plymouth, Minnesota
Senior Business Systems Analyst (1/2005-7/2005)
Carlson Companies is a pioneer in incentive and loyalty awards
programs.
. Mentored Carlson Staff in Use Case development and Activity
Diagrams.
. Worked with Quality Assurance to develop appropriate black box
test lpans.
. Performing requirements work for changes and enhancements to
internal durable asset systems such as
. Point redemption,
. Inventory control,
. Warehouse management,
. Client Billing and accounting
. Order Entry,
. Order Fulfillment,
. Stored Value Cards (Visa & MasterCard gift cards),
. Online Merchandise Catalogs.
Bremer Bank (Contracting)
Application Development and Data Warehousing - Lake Elmo, Minnesota
Senior Business Systems Analyst (9/2004 - 1/2005)
Bremer Bank is non-profit regional Bank established in 1943.
Performed requirement and design work for internal Banking systems
such as
. Anti-Money Laundering,
. BAI file exports (Bank Administration Institute),
. Integration of an "off the shelf" Loan Underwriting System (Allied-
TAM) with an "in house" Contact Management System. .
FirstLogic, Commercial Mail Division (Employee)
La Crosse, Wisconsin & Minneapolis, Minnesota
Senior Business Systems Analyst/Team Lead (2/2001 - 3/2004)
FirstLogic is a provider of software for preparing commercial mail.
. Performed requirement and design work for the Entry Planner
product.
. Stabilized an "unusable" commercial software product in 10 weeks.
. Developed both white box and black box test strategies.
. Assisted in the execution of these white box and black box test
plans.
. Reduced defects per week from one every 3 days to 1 every 4 to 5
weeks over a 15 week period.
. Revitalized the product by creating a new multi-tiered prototype
product using ASP.NET, VB.NET, Microsoft Transaction Server, SQL
Server with T-SQL and Visual FoxPro COM objects. It contained 3
major new features and reused 85% of the existing code base.
General Electric, Global Exchange Services, Express Systems (Employee)
Bloomington, Minnesota
Senior Business Systems Analyst/Software Engineer (8/1999 - 1/2001)
General Electric, Global Exchange Services (GXS), Global Software
Development, Express Systems. In the year 2000, Global Exchange
Services was the world's largest Business to Business (B to B)
provider with over 100,000 trading partners, producing over one
trillion dollars in transactions. The Global Software Development
division provided custom and shrink-wrap software systems to support
the B to B network. Express Systems supplied shrink wrap, EDI based
ASN (Advanced Shipping Notice), and compliance labeling solutions for
small to medium sized suppliers. The solutions were targeted at the
retail market. The products supported transactions with trading
partners like The GAP, WalMart, Sears, Federated Stores, JC Penny,
Dayton Hudson, and many more.
. Performed requirement and design work for the Desktop EDI product.
. Developed both white box and black box test strategies.
. Assisted in the execution of these white box and black box test
plans.
. Used Java 2 and XML to create prototypes of next generation web-
enabled products.
. Assisted in recruiting six team members for the GE India Technology
Center (GEITC) in Bangalore, India.
. Traveled to Bangalore, India. Provided basic training and support
at the GEITC (in Bangalore) for the new team members.
. Produced the first UML based designs.
. Mentored the software engineers on UML
. Introduced Code and Design review for both Introduced Code and
Design review for both UML based designs and designs based on
traditional Structured Design and Analysis. Led Code and Design
reviews. Coached the other software engineers on Code and Design
reviews.
. Led Code and Design reviews. Coached the other software engineers
on Code and Design reviews.
C. H. Robinson - Preferred Systems (Employee)
Minnetonka, Minnesota
Senior Business Systems Analyst/Team Lead (10/1998 - 8/1999),
Preferred Systems, a Subsidiary of C.H.Robinson Worldwide Inc, is a
broker of "Less than Truckload" (LTL) shipping for clients like
Toyota, America OnLine and Frito-Lay. PTS provides rating,
scheduling, tracing and tracking for LTL shipments.
. Performed requirement and design work for multi-modal
transportation logistics optimization systems
. Developed both white box and black box test strategies.
. Assisted in the execution of these white box and black box test
plans.
. Developed three tiered architectures using SQL Server, Microsoft's
Transaction Server, and ISS to increase website performance.
. Developed web pages using Cold Fusion and Active Serve Pages to
demonstrate the scaling of the three-tier model.
. Used COM objects and the Microsoft Transaction Server to provide
complex business logic to the company's websites.
. Created COM objects to reclaim existing business logic (from DOS
based applications) for use for company websites.
. Designed databases using SQL Server 6 and 7 to support customer
websites.
. Installed and configured SQL Server, Microsoft's IIS, and the
Microsoft Transaction Server for use with customer websites.
Gagnon and Associates (Employee)
Minneapolis, Minnesota
Senior Business Systems Analyst/Software Engineer (1997- 10/1998),
Gagnon and Associates is an Industrial Engineering firm of 45
employees specializing in the food distribution vertical market. They
market two software packages, a labor management tool (CALM), and a
warehouse management system (GWMS).
. Performed requirement and design work for the Gagnon warehouse
management system
. Management:
. Directed product reorganization to facilitate version control
process
. Used team review and consensus to develop a Software Development
Process for the GWMS product
. Initiated the first version controlled releases of the GWMS
product
. Directed distribution of work to achieve the first regular
release cycles for the product.
. Introduced the use of release notes to regulate the software
upgrade process and better manage client expectations
. Negotiated and prioritized product issues with Gagnon management
and GWMS clients
. Initiated first requirements based reliability testing and first
system integration testing
. Nurtured a new team culture based on ownership, trust, and
consensus, despite an initial 50% staff turnover and an ultimate
30% reduction in team size.
. Development:
. Performed all major design and requirements activities.
. Created an incident tracking system tailored to the needs of the
GWMS team
. Personally upgraded/installed GWMS product at 3 out of 12 sites
. Rewrote 20% of the core library functions
. Performed 15% of all requirements based reliability testing and
system integration testing.
. Mentoring:
. Taught and delegated requirements and design actives within
team.
. Introduced new approach to software development base on "Rapid
Evolutionary Development" (Lowell Jay Arthur, ISBN 0-471-53633-
4)
. Provided coaching on unit testing within the team.
. Initiated a change in management perspective through the use of
books like "ZAP! The Power of Enlightenment", "Peopleware" and
"The Decline and Fall of the American Programmer"
. Lead internal technical "book club". Selected and reviewed
"Debugging the Development Process", "UML Toolkit" and "UML
Distilled" with technical staff.
Guidant Cardiac Pacemakers (Contracting)
Shoreview Minnesota
Systems Analyst/Software Engineer (9/1996 -4/1997)
Clinicals Department - Product Allocation System
Systems development with Visual Foxpro 5.0 and Oracle
Guidant Cardiac Pacemakers developed leading edge pacemakers,
defibrillators, combination pacemakers and defibrillators, and the
"leads" that connect the devices to the human heart.
Redevelopment of the Product Allocation System to span SAP and a
commercial clinical data collection product.
1. Developed new user interfaces in Visual Foxpro 5.0.
2. Developed both white box and black box test strategies.
3. Assisted in the execution of these white box and black
box test plans.
4. Implemented new tables in an existing Oracle database
for the Product Allocation System.
5. Migrated data from existing FoxPro 2.6 tables to new
Oracle tables.
6. Integrated data from SAP and an Oracle based commercial
clinical data collection product into the Product
Allocation System.
Redevelopment of a document tracking system (Forms Received Log
).
7. Developed new user interfaces in Visual Foxpro 5.0.
8. Implemented new tables in an existing Oracle database
for the Forms Received Log.
9. Migrated data from existing FoxPro 2.6 tables to new
Oracle tables.
10. Integrated data from an Oracle based commercial clinical
data collection product into the Forms Received Log.
11. Developed both white box and black box test strategies.
12. Assisted in the execution of these white box and black
box test plans.
Asset Marketing Services (Contracting)
MIS Department - Bloomington, Minnesota
Systems Analyst/Software Engineer (4/1996 -8/1997)
System Development with Visual Fox 3.0 and Informix
Asset Marketing sold collectable items. These items ranged from
signed baseballs to silver and gold coins. Their marketing was almost
exclusively by telephone to a very select list of customers. New
customers were usually gained by referral by an existing customer.
Key Accomplishments:
13. Created a "foundation" application for all Visual Fox
development. The Foundation provides centralized multi-
user, security, auditing, and software release functions.
The Foundation is object oriented and data driven.
14. Established model for Visual Fox to Informix
interconnectivity using Intersolve's ODBC driver. The Model
allows seamless access to FoxPro tables and Informix
tables. It also supports the execution of Informix based
stored procedures for rapid data processing in the UNIX
environment.
15. Introduced, taught and established Yourdon/Demarco
structured design techniques as standard post-
implementation technical documentation for the Visual Fox
development group.
16. Managed the distribution of projects to a team of four
Visual Fox Programmers. Organized and lead Code and
Requirement reviews.
17. Developed several reporting/process management applications
in Visual Fox. These applications utilize the Foundation
application mentioned above:
1. Unconverted Buyer System - Identified Customers with
no "upsell" activity, allowed distribution of
customer data to telemarketing group and tracked
results of telemarketing efforts.
2. Inventory Reserves - Supported the planning,
execution and evaluation of Inventory liquidation
projects.
18. Developed both white box and black box test strategies.
19. Assisted in the execution of these white box and black box
test plans.
SkyLine Graphics (Contracting)
MIS Department - Burnsville Minnesota
Systems Analyst/Software Engineer (11/1995 - 03/1996)
Systems development with FoxPro 2.6 for Windows & SBT
SkyLine Graphics created state of the art displays for trade shows. An
entire booth with a 20 foot picture could be engineered to collapse
into two small suite cases. Their engineers use Sun work stations to
develop these displays for customers.
Key Accomplishments:
Developed a custom Sales Reporting system for SkyLine Graphics
based on SBT PRO 3.0 tables using FoxPro 2.6 for Windows.
Reports include three year sales comparisons, several sales
rankings, full statements and one page account balances for
SkyLine Distributors. This reporting system:
20. provides on-line reports for SkyLine staff,
21. emails custom reports to all SkyLine Distributors nightly
using Microsoft Mail.
Developed both white box and black box test strategies.
Assisted in the execution of these white box and black box test plans.
DYTEC (Contracting)
Bar Code Scanning Software - St. Paul, Minnesota
Systems Analyst/Software Engineer (4/1995-11/1995)
DYTEC offered data collection solutions using bar code technology.
Key Accomplishments:
Time and Expense (Visual FoxPro): Designed and implemented a
Visual FoxPro application for tracking corporate software
development costs. System tracks both actual and estimated time
and expense. It attributes time and expense to Software
Development Requests, Software Change Orders, Bug Reports,
Employees, Clients, Projects, Products, Modules and Module
Components. It allows for several classifications of time (i.e.
requirements, design, implementation, testing ). The Time
and Expense system has its own custom reporting system that
produces "roll-up" summary reports that export to Excel
spreadsheets. The number and order of totals and sub-totals is
defined by the end user at run time. Time and Expense is a
"stand alone" product that will run in single user desktop mode
or in a multi-user networked configuration. Conducted white box
testing on all code.
Labor and Attendance (FoxPro 2.6): Developing the client
portion of a client server system that monitors labor and
attendance for industrial manufacturing. The server side
collects data on the current status of work in a diversified
manufacturing concern. The client provides transaction
auditing, editing, reprocessing and export of data to legacy
host systems. The client export process allows the user to
reformat data, filter data, transpose/translate data and define
the final table structure. These definitions are stored as
templates that can be retrieved, edited and rerun. A "Save As"
feature allows existing templates to serve foundations for new
templates. Conducted white box testing on all code.
Guidant Cardiac Pacemakers (Contracting)
Shoreview Minnesota
Systems Analyst/Software Engineer (2/1994 -4/1995)
Clinicals Department - Product Allocation System
Systems development with FoxPro 2.5 for Windows
Guidant Cardiac Pacemakers developed leading edge pacemakers,
defibrillators, combination pacemakers and defibrillators, and the
"leads" that connect the devices to the human heart.
Key Accomplishments:
24. Moved pre-existing Allocation System from FoxPro DOS 2.0
to FoxPro Windows 2.5.
25. Restored control of data to users by expanding
add/edit/query capabilities and adding new turnkey
reports
26. Increased ease of use by converting the primary
add/edit/query screens from modal to modeless operation.
Users can move quickly from one screen to another with a
"mouse click" without waiting for files to open or
screens to refresh.
27. Increased system speed by reconfiguring FoxPro 2.5 and
Windows for WorkGroups 3.11 environments. Eliminated
redundant code execution in screen refreshes.
Introduced Rushmore optimization strategy into code to
increase data file access and refresh speed.
28. Created Network/Stand-Alone/Take-Home option for the
Allocation System. System now runs whether the network
is up or down, and users can take home a copy on a
laptop. The System automatically tracks operating mode
transitions. In a stand-alone to network transition,
the Allocation system updates network files and
identifies update conflicts. The system allows end
users to resolve these data conflicts.
29. Used formal structured methods for gathering end user
requirements. Utilized "Functional Decomposition
Diagrams" to document both the manual and automated
functions of the Allocation System. These diagrams are
end user oriented and provide the foundation for design,
requirements testing and ISO900 compliance.
30. Conducted white box testing on all code.
CARGILL Assignment (Contracting)
Corporate Information Technology Department - Minnetonka Office
Systems Analyst/Software Engineer (12/01/93 - 02/01/94)
Cargill is a world wide commodities management company based in
Minnetonka Minnesota.
CTM Project:
Created a custom query system in FoxPro DOS 2.0 for Cargill.
This query system allowed Cargill's Accounting Department to
analyze and take action on incoming mainframe accounting files.
Monthly files were submitted electronically from offices world-
wide. File source, file types, and product types were cross-
categorized to create complex multi-layered relationships.
Conducted white box testing on all code.
Bitterman and Associates (Employee)
MIS Department - Plymouth, Minnesota
Systems Analyst/Software Engineer (1990-1993)
Bitterman and Associates Sales Incentives and Marketing, a private
company of 35 employees that markets and implements Sales Incentive
Programs to the Food and Investment Industries. Each Incentive
program required its own data processing package to track
participants' productivity, issue merchandise awards, and produce
custom client reports. These independent systems integrated with an
enterprise-wide data processing system that supported the company's
basic business functions: Order Entry, Purchase Orders, Inventory,
Accounts Receivable, Accounts Payable, General Ledger, Program
Administration, Vehicle of Exchange Engine, Program Parameters. All of
this software was written "in-house" using FoxPro.
Major responsibilities included:
31. Created new design specifications for custom client software and
the enterprise-wide system for the Marketing, Sales, Operation, and
Finance staff.
32. Estimated cost for software projects using actual in-house cost
development data from past projects.
33. Provided custom client software, enhancements, and additions to the
enterprise-wide system based on design specifications.
Key Accomplishments:
34. Wrote the Inventory, Program Parameter and System
Control modules for the enterprise-wide data processing
system in FoxPro 1.2.
35. Created standard procedure library for record locking,
record recycling, module path management and multi-user
software interlocks in FoxPro 1.2.
36. Enhanced and upgraded the Order Entry, Purchase Order,
Accounts Receivable and Vehicle of Exchange modules in
FoxPro 1.2.
37. Converted index system to "Rushmore" technology for the
enterprise-wide data processing system with FoxPro 2.0.
This conversion provided fifty percent performance
enhancement due to faster file opening and faster record
access.
38. Developed a new on-line Banking System in FoxPro 2.0 to
replace the old batch system. The old model required
250 hours to implement as a custom client software
system. The new model required 90 hours to implement.
The new model also provided backward compatibility so
that pre-existing systems could be upgraded to the new
model at very little expense.
39. Wrote the in-house programming standards document for
custom client software.
40. Conducted white box testing on all code.
Minneapolis City Hall (Employee)
Energy Office
Minnetonka, Minnesota
Systems Analyst/Software Engineer (1985-1990),
Minneapolis Energy Office was an independent, nonprofit organization
that develops and administers energy-saving programs for commercial
property owners and the general public, working closely with the
Public Utility Commission and other governmental agencies.
Key Accomplishments:
41. Managed transition from Lotus-based tracking systems to
dBase III+ systems. The change reduced staff computer
time by one-third, and provided the first system-wide
management reports.
42. Devised a time-sheet tracking and analysis system to
provide research project cost analysis for a variety of
projects with rapidly shifting priorities using dBase
III+.
43. Created a dBase III+ loan tracking system and created
more efficient loan processing procedures, reducing file
load from 600 to 300 active files and application to
closing time from 36 weeks to six weeks within one year.
44. Conducted white box testing on all code
Technologies
Use Cases Business Rules Activity Diagrams
Context Diagrams Requisite Pro ClearQuest
UML RSA Modeler Formal Inspections
ISO9000 EDI X12 Data Standards
ASP.Net VB.Net XML
Oracle PLSQL Informix
Microsoft SQL Server Transact SQL Microsoft Transaction
Server
Visual Source Safe Visio Microsoft Office
Active Server Pages Cold Fusion Visual FoxPro
Education
Oberlin College, Oberlin, OH. (1976-1980),
Major: Music Performance.
Minor: Mathematics.
References
References are available upon request.
Examples of Work
Examples of work are available upon request.