Shae Hinds

Midwest Integrated Systems Resources, Inc.

PO Box 1481

Portage, MI 49081

shinds1@chartermi.net

CONSULTANT PROFILE

 I have been working in the IT industry and the IBM Midrange product line for more than 25 years. I have been responsible for the full range of IT development cycle activities; systems analysis, project management and programming through implementation, documentation and training. My management responsibilities included staff management. My programming experience includes providing support for legacy applications and systems including software and hardware conversions, upgrades and enhancements to leverage an historical database.

Along with my technical and programming skills, I communicate well and strive to develop good rapport with both management and end users. I am dedicated to providing the end user with a product that meets their functional requirements. I have a strong work ethic and I strive to provide practical and professional results for my customers.

Career highlights and accomplishments:

1. My first major responsibility was to manage the conversion of all batch processing, OCL and RPGII programs from an IBM System 3/15D to a System/38 for the Stryker Corporation in Kalamazoo, MI. We completed the conversion 2 months ahead of schedule.

2. I became senior programmer/analyst and subsequently IT Operations manager for the Bill Knapps’ Company, a privately owned, Midwestern restaurant chain. I developed and maintained custom applications for Profit Sharing, Direct-Deposit Payroll, Inventory Control, Bill of Material, MRP, Purchasing, Point-of-Sales data analysis as well as supporting many other custom coded applications.

3. My IT Operations Manager responsibilities included managing a staff of 3 local staff members and providing 24/7 support for equipment and communications in remote commissary locations in 3 states. During this period I shared responsibility for the conversion from a System/38 D to the AS/400.

4. Since starting Midwest Integrated Systems Resources, Inc. (MISR) in January 1993 with my business partner, David Dunfield, we have had the opportunity to provide IT support and training to many companies in a variety of industries. One of our more challenging projects involved a 15-month Y2K conversion for an insurance claims processing company, Health Risk Management (HRM now CBCA). I developed a search and scan “de-compiler” system in RPG ILE to analyze source code (CL, RPGIII, RPGIV, RPGILE) to identify field usage, determine where-used and aliases.

5. Since January 2000, we have become involved with the LANSA product line as business partners and developers. I developed a LANSA application for the City of Portage, MI, which was awarded the “Innovative Park Resource Award” in 2004 by the Michigan Parks and Recreation Association.

Expert in: OS/400, I5/OS RPG, RPGIII & IV, RPG/ILE, SQL, CL,

LANSA, Visual LANSA. LANSA for the WEB,

T.L. Ashford Labeling Software, Hawkeye, DBU

Aldon Change Management, Implementer Change Management Manufacturing, Inventory, Insurance, Government, Purchasing, Accounting

PROJECT/CAREER HISTORY

Most Recent Client: 

EDCOR, Education Benefit Management (Contract) 2006

Selected to be a member of a 20-person team to enhance and upgrade a custom legacy application system to RPG ILE standards and tie it to a Web interface. Tasks included creating elaborate adjudication processes to validate both application and payment requests submitted via Web transactions. Developed programs using OPNQRY, RPG ILE, RPG SQL, procedures and service programs. Responsible for generating Technical Specifications documents to accompany all coding.

Cardinal Health

ISeries-AS/400  Consultant (Contract) 2005 – 2006 

Performed Sarbanes-Oxley compliance evaluation on Credit and Re Bill Chargeback system. Analyzed and created Business Rules documents based upon RPG and CL Programs.

PFIZER

ISeries-AS/400  Consultant (Contract) 2005 – 2005 

Collaborated on a team installing Pfizer MAPS (Manufacturing and Production System). Developed custom RPG ILE Interfaces between Laboratory applications and MAPS system. Developed custom RPGLE Product Label generation programs to interface with T.L. Ashford label software. Created product label formats using T.L. Ashford. Worked on software Compliance teams for FDA and SOX.

Famous Footwear/Brown Shoe Company

ISeries-AS/400 LANSA Consultant (Contract) 2004 – 2005

Developed LANSA cross-reference tool & Project Control Tool. Converted over 400 LANSA functions with over 100 file name changes and over 11000 field name changes.

Client: RPA Process Technologies

iSeries-AS/400 LANSA Consultant (Contract) 2004

Added functionality to a VL (Visual) LANSA application to record Project Stage Validation information. Created new files, with rules, triggers, etc. and new VL LANSA components that were integrated into an existing Quote generation system.

Client: City of Portage, Michigan

iSeries-AS/400 LANSA Consultant (Contract) 2001-2005

Designed, developed, deployed and trained staff to use a comprehensive set of Visual LANSA applications that integrated with and enhanced the functionality of the HTE (governmental applications packaged software) Work Order system for the City of Portage, Michigan. This project included a wireless laptop interface for the Streets Department and a PDA interface for the Parks & Recreation departments. The City of Portage Parks and Recreation department won the Innovative Parks Resource Award from the Michigan Recreation and Parks Association for the PDA project in 2004.

Features include a wireless interface for “standalone-and-synch” data exchange using LANSA Integrator for both PDA and laptop PC devices. The new functionality provides staff the ability to record work order data while in the field and transmit it to the iSeries when in communications range.

Additional functions included providing Windows interfaces for packaged green-screen maintenance, specialized analysis and reporting features. This application required an intimate knowledge of the functioning of the packaged software, importing over 150 HTE files into LANSA, as well as the creation and interfacing of over 20 LANSA files, with appropriated logicals, predetermined join fields, access routes, virtual fields, rules and triggers, etc. Over 80 VL components, many reusable parts, LANSA Processes and Functions were needed to support file synchronization and application function. The following development tools were used:

1. LANSA
2. Visual LANSA
3. LANSA Integrator
4. Embedded Visual Basic – used for the PDA application.

Client: Cooperative Elevator 

LANSA Consultant (Contract)  2003

Worked on 2 person team designing and creating Visual LANSA application to replace an existing Delphi application. Created fields, files with appropriate rules, triggers, access routes, predetermined join fields, etc. needed to support the Visual LANSA application.

Client: City of Portage, Michigan

iSeries-AS/400 Consultant (Contract) 2001-2003

Analyzed documented, re-wrote and expanded functionality of a legacy custom Special Assessments system using RPGLE, OPNQRYF, SQL. The project included correcting system flaws and inconsistencies in the existing interfaces to the Cash receipts and General Ledger modules of the HTE governmental software product. The system was expanded to integrate with the Building Permit and Land management modules of HTE as well as interfacing with a stand-alone PC product used by the Assessors.

This project required working with managers and staff in the Assessors Office, Finance and Community Development departments.

Client: Ameriwood Industries, Inc.

ISeries-AS/400 Consultant (Contract) 2000

Designed, developed and implemented an RPG/ILE Repair Parts and Return Authorization application to allow service staff (US and foreign-based) of this furniture manufacturer to process customer calls and web orders. The application required the ability to fill Orders and distribute parts from warehouses identified to be closest to the customer’s location. Acknowledgements were automatically sent to customers who provided email addresses. The system also provided tracking customer requests to alert staff of possible abuse situations.

Client: Western Michigan University

ISeries-AS/400 Consultant (Contract) 1999

Part of 2 person team that designed and created Web site for Vehicle Parking Registration and Parking Ticket processing system using LANSA for the Web. This project required interfacing with a legacy AS/400 application created in Synon. Over 100 files were imported into LANSA and the appropriate rules, triggers, access routes, etc. were defined. Student Parking Sticker pickup processing and receipt printing were developed using LANSA.

Planned, managed and executed Y2K conversion of S/36 Parking System application. This required conversion of some code from S/36, RPG II as well as Synon generated files and code. This system is responsible for generating over $8 million dollars annual revenue for WMU.

Client: HRM, Health Risk Management

ISeries-AS/400 Consultant (Contract) 1994-2000

Designed, planned, managed and executed Y2K conversion of Insurance Claims Processing System. This project included expansion of critical non-date fields (company, department numbers, etc.) to enable applications to support growing customer base. Over 3000 fields in 6000 files and 3000 RPG programs were changed, many using our custom Visual Age RPG and RPGLE Code generator. Field and file usage analysis was accomplished via our custom CL, RPG and RPGLE code de-compiler software.

Rewrite of custom COBRA benefit product.

Designed and created data conversion tools to streamline the absorption of historical claims data from mainframe MVS systems as well as and many other projects.

Client: City of Albion

ISeries – AS/400 Consultant (Contract) 1994- 1998

Functioned as operations support for this small Municipal government that had no IT staff. Upgraded OS/400 from V2R3 to V3R1, applied PTF’s, supported Text Management application etc.. Performed programming maintenance for Tax and Payroll systems and other Governmental applications.

Employer: Bill Knapp’s Restaurants

Operations Manager 1988-1994

Responsible for 24/7 functioning of S/38 and AS/400 hardware and software over 3 state network of commissary food manufacturing and distribution sites.

Responsible for Operations staff and functions: backup & recovery, reports and distribution, installation and maintenance of hardware, etc.

Instrumental in installation and migration from S/38 to AS/400 platforms, operating system support, etc.

AS/400 Senior Systems Analyst 1984-1988

Responsible for designing, developing and implementing a custom inventory control, bill of material, MRP and purchasing applications.

Developed and created Profit Sharing, Direct Deposit, Stock and Sales analysis and tracking systems for privately held company.

Employer: Stryker Corporation

RPG programmer/analyst 1981-1984

Involved in a variety of projects, particularly creating custom sales analysis reports.

Major responsibility was the planning, installation and execution of all aspects of an 18-month project to convert all batch systems from the IBM System/3-15D to System/38. This included creating a relational database and converting historical data for all financial, manufacturing, bill of materials, material requirements planning, inventory control, sales analysis and customer service systems.

EDUCATION

Kalamazoo Valley Community College

Courses included general business, accounting, and data processing.

Western Michigan University

Degree - Bachelor of Arts and Teaching certificate

Michigan State University

Psychology and Social Sciences

Kalamazoo College

Psychology and Social Sciences

PROFESSIONAL DEVELOPMENT

Technical classes and seminars attended include RPG ILE, RPG SQL, SQL, OPNQRYF and database design, RPG III, COBOL, MAPICS, system design, and security planning. Also attended numerous IBM Technical and COMMON Conferences.

IBM Classes include Application Programming and Implementation I&II, AS/400 for the experienced System/38 Implementer, and many local IBM seminars.

LANSA Classes Include LANSA Fundamentals, LANSA for the Web, Visual LANSA, Advanced Visual LANSA, Surround Technologies VL Frameworks.

Attended the Rochester Summit at IBM Rochester, and attended four other sessions at IBM Rochester on Client/Server, Websphere and Year 2000 conversion planning.

PERSONAL DATA

Co-authored Text Search Services for News/400, December 1993.

Created DSPMONMSG, AS/400 programmer utility software.

Member of local AS/400-iSeries user group. Presentations included Y2K Project Planning & Management, SQL/400 features and functions.

Past member of local (DPMA) Data Processing Manager’s Association.

SYSTEM EXPERIENCE

Computer	Languages	Software Applications
IBM AS400 / iSeries	RPG III, IV, ILE, CL, SQL, DDS, SDA, DB2 and AS400 Utilities including Code/400, DBU, SEQUEL, etc. LANSA, Visual LANSA, LANSA for the Web	MAPICS, HTE package software. Aldon & Implementer change management software. I have designed, programmed, installed, documented and trained users on many custom Manufacturing, Financial, Accounting, and Distribution applications. I have also converted different systems and data bases and applications to the AS400, upgraded older AS400 code to RPG400 and ILE. I performed Y2K conversions for different companies.
IBM SYS 3, 36, 38	RPG, RPG II, RPG III, OCL, SDA DDS, DB2	MAPICS and Custom Applications
PC experience, nguages and Tools	Microsoft Office products including ACCESS, EXCEL, MS Project, Outlook, etc. I've worked with most Windows operating systems including 3x -95-98, XP, and 2000.	I have worked with most PC tools but I primarily use the PC as an interface to the iSeries data base, for programming and reporting functions.

INDUSTRY EXPERIENCE

Industry	Application	Summary
Manufacturing	Custom Software, MAPICS	Much of my IT experience has been with manufacturing applications. I created a custom inventory control system, MRP and bill of material for a private restaurant chain. I created a custom Purchasing system and a Sales analysis and tracking system based upon their Point of Sales data. Designed, developed and implemented an RPG/ILE Repair Parts and Return Authorization application for a furniture manufacturer, to allow service staff (US and foreign-based) to process customer calls and web orders.
Insurance	Custom Software, Mainframe Database conversions, Custom COBRA benefit application. Custom Y2K conversion with database enhancements	Worked with a major Claims processing organization on a variety of projects. Performed many custom data base conversions from Mainframe systems. Developed a custom COBRA benefit processing application. Was part of a 2 person team that performed Y2K conversion on 3000 fields in 6000 files and 3000 programs. We accomplished this while 8 corporate programmers continued to develop and modify the applications.
Financial	General Accounting and GL and Finance.	I have created and maintained Stock and Profit Sharing applications for a privately owned company. I created a Sales analysis system for their Point of Sales system. I enhanced and interfaced a custom Special Assessment system with the Cash Management and General Ledger modules for the City of Portage.
Other	Change Control Project Management Application Design Data Base (DB2 DDS	I have worked and managed many large and small projects. I am an experienced application designer and programmer and I have extensive data base design and administration experience. Many of my projects have included conversions and enhancements to legacy systems both packaged and custom code. Much of my IT experience has been in positions where I was responsible for the complete project cycle from interviewing the end user and designing the system to stringing cable and installing hardware.