Post Job Free
Sign in

Software Engineer Quality Assurance

Location:
Minneapolis, MN, 55411
Posted:
November 02, 2010

Contact this candidate

Resume:

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.



Contact this candidate