Skills
Project Management
Microsoft Project Server
System/Test Analysis
Requirements Planning
Database Design
Design Documentation
Software Creation/Revisions
User Training Documentation
Message-Oriented Middleware
Business Application Programming
Platforms
Hardware:
AS/400 / iSeries
SYSTEM/38
SYSTEM/36
IBM PC
Hewlett-Packard 3000
Operating Systems:
OS/400
SSP
Windows
DOS
MPE iX
Competencies
Programming Languages:
RPG
COBOL
CL/400
OCL
COGNOS
Java
XML
SQL
PHP
Communications:
Message-Oriented Middleware
Electronic Data Interchange (EDI)
Productivity Tools:
MS-Office
MS-Project Professional
MS-Project Server / EPM
Websphere Development Studio Client (WDSC) / RDi
Extract Transform Load (ETL)
MKS Implementer
Aldon CMS
Database:
DB2/400
Turbo Image 3000
Education:
Project Management Institute (PMI)
George Washington University Project Management
University of Minnesota
General College BAS
Management Information Systems
National Education Center - Brown College - Computer Programming and Operations
Profile
A professional of Information Technology (I/T) who contributes to the success of
business organizations through experience, dependability, diligent pursuit of
business knowledge and understanding of client needs. Demonstrates a broad range
of technical and managerial ability from Application Development and Systems
Analysis to Project Management and I/T Department Manager. Proven ability to
take the steps necessary to ensure the needs of the business and management are
understood and delivered. Formally trained in Project Management methodology
through the Project Management Institute and George Washington University;
well-versed in team building and leadership principles that result in successful
delivery of I/T projects on time and under budget. This combination of technical
and managerial experience provides the skill set necessary to act as effective
liaison between stakeholders and technical staff. The customer benefits from
processes and systems that are useful, understandable and meet the needs of the
business. Well-versed in the Software Development Life Cycle (SDLC) including
development of business and functional requirements as well as use cases, code
development, and specifications for code development.
PROFESSIONAL EXPERIENCE
Computer Directions Corporation
2000-Present
FOUNDER AND SOLE PROPRIETOR, INDEPENDENT CONTRACTOR SERVING MINNESOTAS TOP
COMPANIES Incorporated 1987
Rural Community Insurance Services (RCIS)
2009
Programmer Analyst
Application upgrade and maintenance for program defects and enhancement
Analysis, evaluation, detection of functional issues with existing programs
Recommendation for solution of program issues and enhancement
Program application enhancement, test and restore to production
RPG IV, RPG/ILE, PHP, stored SQL procedures, HTML, WDSC/RDi
Wells Fargo Wealth Management Group
2008-2009
Programmer Analyst
Design, write and test programs to parse XML documents and load to Asset
Classification database.
Assist in development of workflow process and documentation
Interpret and convert Asset Classification data for client use
RPG/ILE, XML, iSeries Access for Web, WDSC/RDi
EMC Paradigm Publishing
2008
Programmer Analyst
Assist migration of in-house application to new application
Establish program migration priorities to meet go-live date
Rewrite or modify existing programs to use files from new BookMaster
application
RPG IV, RPG/ILE, PHP, stored SQL procedures, HTML, WDSC/RDi, Java
Jostens, Incorporated
2007-2008
Programmer Analyst
Migration from AS400 Model 170 using OS V4R2 to AS400/iSeries V5R4. Compile and
test all applications, test new hardware connections and verify communications
links to remote sites.
Organize and execute project plan for migration and testing
Make recommendations for upgrade of communications from APPC/SNA to
Message-Oriented Middleware
AS400/iSeries, OS400, COBOL, DB2/400, WDSC/RDi
McKesson Corporation
2007
Programmer Analyst
Business applications support for AS400 platform.
Organize and execute projects for application support and enhancement for JD
Edwards
Database integrity and support
AS400/iSeries, OS400, RPG/ILE, DB2/400, WDSC/RDi, SQL
Regis Corporation
2004-2006
Programmer Analyst / Systems Analyst
Application conversion from OPM to ILE code. This project required the detailed
analysis of business needs merged with the latest technology to produce a more
efficient method of data delivery from the Point-of-Sales (POS) to Corporate
Headquarters.
The new Sales Interface application was designed and written as a flexible,
rules-driven system to process data as it arrives via a message queue system
installed as part of this project.
Many reusable tools and techniques were developed during the life of this
project specifically for the purpose of migrating Third-Generation, procedural
programs (OPM) to Object-Oriented/ILE on the AS400/iSeries platform.
Installed Message-Oriented Middleware product to process data via Event-Driven
Data Exchange
Used XML to allow flexibility for dynamic change of data requirements
Provide for expanding volume of data and company growth
Eliminate data dependencies between related applications to ensure timely
processing for sales of services and inventory saving $60,000 per month
Presentation of data to JD Edwards, Infinium payroll and data warehouse
Migration of OPM code to Object-Oriented/ILE code
Create training program for conversion of OPM to ILE code
AS400/iSeries, RPG/ILE, DB2/400, RS6000, AIX, XML, WDSC, SQL, Java
Lifetouch National School Studio
2003
Programmer / Business Analyst
Statistical analysis and reporting for sales and scheduling of services. Used
COGNOS 4GL to extract information from multiple database formats for sales
forecasting.
Created management reports by geographic location
Provide information to sales staff to renew business with past client
Generate new sales based on recent census data
DEC/VAX, COGNOS
Minnesota Mining & Manufacturing (3M)
2001-2002
Programmer Analyst
Applications and system support for HP3000/MPE iX platforms enterprise wide.
Assist support team for HP3000 platform for all installations throughout 3M
Database integrity support
Support for existing applications MM3000, Mac-Pac, custom in-house
Help desk support for end-user community
HP3000, COGNOS, COBOL, Image3000, Robelle, Adager, ETL
UCare Minnesota (HMO)
2000-2001
Programmer Analyst
Defined and executed various projects in liaison with client personnel including
needs analysis, definition and execution. Used Extract, Transform and Load (ETL)
tools for data preparation and EDI transmission to various Government agencies
for HIPAA, HCFA and state DHS reporting.
Successfully defined and implemented a solution for reconciliation of funds
disbursement for Centers for Medicare & Medicaid Services (CMS) resulting in a
savings of more than $300,000 annually conserving cash flow
Defined and implemented Batch Enrollment Process for new client companies
saving time and money by reducing transcription errors
Conducted needs analysis, research and implementation for Extract, Transform
and Load (ETL) software for migration of data from government agencies and
clients
Completed various assignments for information requests from end-user clients
Participated in HIPAA training for compliance with new government standards
and practices
HP3000, COGNOS, COBOL, Image3000, Robelle, Adager, AMISYS, ETL
International Business Machines (IBM)
1997-2000
Information Technology Specialist
Systems Analyst / Programmer Analyst. Programming and testing on several
projects for Year 2000 compliance in a high-profile environment. Specific duties
varied from Y2K compliance to Risk Management, Change Management, application
testing and data migration. Team leadership strongly emphasized.
Business Application upgrade for Year 2000 compliance
Use Project Planning and Productivity tools to define and track level of
effort
Lead for IBM midrange applications using RPG, DB2/400, LANSA, Synon, EDI
Project clients included:
Banc One Columbus, OH
Nash-Finch Co. Edina, MN
Regis Corporation Edina, MN
Minnesota Mining & Manufacturing (3M)
1996-1997
Programmer / Systems Analyst
Defined the parameters for data warehouse enhancement. This project used an
existing Global Sales Reporting (GSR) system as a basis of design. The plan
expanded GSR to include more detail plus create a method to capture international
currency values for a specific time and place.
Led the effort for definition and implementation planning of Global Enterprise
Data Warehouse (GEDW) project
Effort required close liaison with management and technical staff
Solve key technical problems of data acquisition for international currency
and data extract from existing Global Sales Reporting application
Year 2000 compliance for existing Global Sales Reporting System, BPICS, JD
Edwards and MAPICS applications
AS400/iSeries, OS400, RPG/ILE, DB2/400
Computer Directions Corporation
1991-1996
Provided data processing solutions and support for several companies in the
Minneapolis/St. Paul area.
Custom and Off The Shelf solutions such as Great Plains/Real World, MAPICS
Network support
Programming and computer operations
Consulting for hardware and software acquisition and installation
Database migration for merger and acquisition
AS400, RPG, HP3000, COBOL, COGNOS, Novell PC network
Project clients included:
CENEX Harvest States
Target Corporation
Hartzell Mfg. Corporation
Pannekoeken Family Restaurants
Minnetonka Corporation
Northland Insurance
Michael Foods
St. Jude Medical, Inc.
1991
Team Lead and Systems Analyst
Team Lead for development of custom in-house application in support of business
requirements using Fourth-Generation (4GL) reporting tools.
Product tracking and Value-Added Tax for European Sales Corp.
Create Surgeon Profiles database to track heart valve implants
HP3000, COGNOS, COBOL, Image3000, Robelle, Adager
Waldorf Corporation / RockTenn
1990
Programmer / Systems Analyst
Application maintenance for several in-house custom systems in support of
business requirements.
Carton packaging production and inventory
Recycled paper inventory and processing
JD Edwards and MAPICS modification and application support
Migration of LANSA generated applications to RPG code
AS400, RPG
Portec, Inc.
1986-1989
Programmer / Systems Analyst
Several projects required business analysis and close liaison with stakeholders
at all levels including clients, management, end-users and technical staff for
project definition and implementation. Assumption of Department Manager duties
during facilities consolidation which freed staff personnel to address issues of
physical transition to another state.
Defined and executed project plan to implement a Sales Quotation/Order Entry
system for manufacturer of custom conveyor systems
Submitted project plan for scope, schedule and resources required; worked
closely with all stakeholders to ensure business needs were properly addressed
Benefit was a reliable system to track quotations allowing better
communications between client and vendor; additional benefit of creating shop
floor orders from customer sales order reducing transcription errors saving time
and paperwork
Defined, executed and implemented custom system for tracking movement of raw
materials between intra-company facilities
Trained end-users and managers to use reports and on-line facilities to
identify location and status of raw materials
Result was more efficient timing in manufacturing process and scheduling for
delivery to the customer
Various maintenance and support programming for MM3000 application
Assumed Department Manager duties during intra-company plant consolidation
freeing staff personnel to conduct transition
HP3000, COGNOS, COBOL, Fortran, Image3000, Robelle, Adager, Vesoft
|
