OBJECTIVE:

An information technology (IT) position with responsibility for analyzing, designing, developing, and maintenance of business application database software and related systems projects.

CAREER OVERVIEW:

IBM System 3x, AS/400, and iSeries RPG/CL professional since: 1989. Data Warehouse ETL systems development: 11 years. Double major Bachelor’s degree: Accounting and Computer Information Systems. MBA, Strategic Management. MS, Information Technology Management. XHTML website development with PHP, CSS, XML, XPath, XSLT, and WordPress objects. Complete end to end multi-platform system builds from scratch using SDLC and spiral methodologies. Virtual project team management.

PROFESSIONAL EXPERIENCE:

PHP Webmaster (Consulting). Kalamazoo, MI. 4/2013 – 3/2014.

Design and development of custom PHP/XML Real Estate Transaction Standard (RETS) EDI data feed for daily MLS listings refresh. Subsequent update of mymichiganforeclosures.com PHP/MYSQL website per XML RETS objects. Creation of RSS data feeds. Development of XPath/XSLT XML objects for integration of PHP driven XHTML website with WordPress blogging and content management software. Facebook social media integration. Implementation of Google and Bing Webmaster tools per Search Engine Optimization (SEO) procedures. XML RSS objects for EDI transmissions.

Sr. IT Specialist (iSeries/AS/400), Nationwide Insurance. Troy, MI. 10/2000 to 7/2011.

Data Warehouse unit specialist responsible for analysis, design, development, and maintenance of RPG, CL, and SQL based regulatory statistical data reporting systems for THI subsidiary. Design and implementation of extract-transform-load (ETL) processes required for standardizing every auto insurance transaction, per reporting requirements. Various projects including: maintenance, enhancement, and operation of period end statistical data procedures; financial system reconciliation and balancing of internal databases to reported statements per external regulatory requirements; external data reporting included NAII Stat Data Auto Calls, TX month-end state data calls, and various other regulatory data requests. Project technical development lead for rewrite of Victoria/Titan subsidiary group auto insurance policy rating engine. Design and expansion of regulatory statistical database. Legacy application projects including: marketing, general ledger, VIN#, various States reporting, and ad hoc creation of filings for external reporting entities. Consolidation of Statistical reporting process into menu driven system.

Sr. iSeries/AS/400 Consultant, www.idea.com/MODiS. Southfield, MI. 7/1999 – 9/2000.

Clients included TI Group Automotive and Lear (Ford). Responsible for design, development, and implementation of custom AS/400 solutions. Systems included RPG BPCS, MAPICS, and Future-3. Support of Bill of Materials, Post Ship Billing, and other modules for manufacturing customers. S/36 Y2K modifications with Century Solutions.

Client/Server Network Developer – AS/400 Contractor. Kalamazoo, MI. 3/1996 – 7/1999.

Retained by Kirby Inc., distributors, Refinance Centers/WWF, Preferred Financial Plus, DMB Mortgage Bankers, the Maxim Group. Design, development, and implementation of versions 1.0 and 2.0 of branch office telemarketing software package programmed in Visual dBase, SQL, and Crystal Reports. Creation of various software package modules including: automated dialing, lead tracking, mailers, and sales force automation to interface PRO-CD, Melita’s PhoneFrame dialer, and Goldmine 4.0 contact manager. Management of automated sales - marketing systems and training of telemarketing staff. Maintenance and development of custom and packaged AS/400 RPG/CL systems for various clients.

AS/400 Consultant, Sierra Consultants, Ltd. Grandville, MI. 3/1995 – 12/1995.

Development of AS/400 RPG/CL systems. Responsible for design, development, and implementation of $1MM inventory management system, requiring creation of custom RPG/CL database modules and other objects coded in PCIRL, ASC/COM, and TLAshford to interface scanners, wands, and bar-code printers. Mainframe to AS/400 database software conversions. Creation and enhancement of RPG/CL applications for TWC, MAPICS, BPCS, and various daily ad hoc client programming requests.

AS/400 Programmer/Analyst, Interkal Corp. Kalamazoo, MI. 8/1994 – 3/1995.

Development and enhancement of mission critical AS/400 RPG/CL database systems including: Bill of Materials, Order Entry, Costing, and MAPICS. S/36 RPG II application upgrades.

PROFESSIONAL EXPERIENCE:

AS/400 Programmer/Analyst, Checker Motors (GM supplier). Kalamazoo, MI. 4/1993 – 8/1994.

AS/400 RPG/CL programming. Responsible for coding and maintenance of General Ledger, Payroll, Bar-Coding, Engineering, Inventory, and Costing systems. Responsible for repair and enhancement of the Month-end reporting process. Daily systems trouble-shooting, business software repair, and problem solving. S/36 application rewrites. Implementation, upgrade, and maintenance of various software packages including: MAPICS, Future-3, and INTEGRAL. AS/400 System upgrades.

S/38 Contractor. Lansing, MI. 9/1992 – 1/1993.

Retained by Michigan Hospital Association. Migration and conversion of a UNIX database to S/38 RPG/CL. Enhancement of the Hospital Worker’s Compensation Claims management system. Modification of various other S/38 RPG/CL applications.

AS/400 Operator/Programmer/Analyst, EPI. Battle Creek, MI. 1/1991 – 8/1991.

Coding of RPG Sales Call Reporting system for the AS/400. Printing of rebate checks, and company reports. Complete responsibility for computer operator functions.

S/38 Operator/Programmer, JP Systems, Inc. Kalamazoo, MI. 9/1989 – 8/1990.

Operation and maintenance of multi-site dial-in network for the Southwest Michigan Library cooperative. Design, development, and implementation of custom RPG II & RPG III screens and reports for the S/38 environment.

EDUCATION:

Walsh College. Troy, MI. Post Graduate Certificate, Project Management. Data Warehousing/Business Intelligence, website development courses with HTML, JavaScript, and CSS. Awarded: Summer, 2009. www.walshcollege.edu.

Oakland University, Rochester, MI, Masters of Science. Major: Information Technology Management. Development of Diagrammed Instruction Set Computing. UML, Project Mgt., VB (for Excel), Object Oriented Analysis and Programming with Java, Spiral Project Management, and Java swing development. Awarded: August, 2007. www.oakland.edu.

Oakland University. Rochester, MI. Post Graduate Certificate, Accounting Information Systems & Management Information Systems w/Oracle 11i & CoolGen, and Systems Modeling, awarded: August, 2003. www.oakland.edu.

Davenport University-Dearborn Campus. Dearborn, MI. MBA, SAS statistical programming. Strategic Management concentration, awarded: June, 2001. www.davenport.edu.

Davenport University-Kalamazoo Campus. Kalamazoo, MI. BBA, Accounting & CIS, including advanced database design and development. Awarded: June, 1995. www.davenport.edu.

Kalamazoo Valley Community College. Oshtemo, MI. Undergraduate coursework, August, 1984 – January, 1986. DEC VAX BASIC programming and financial accounting. www.kvcc.edu.

Central High School. Kalamazoo, MI. High School diploma, awarded: June, 1984. Apple IIe BASIC programming, Lotus 1-2-3, classical literature, and mathematics.

OTHER TRAINING:

System I Developer RPG & DB2 Summit, 3/2011. Orlando, FL. Five day iSeries Workshop. www.systemideveloper.com.

New Horizons. 9/2005. Troy, MI. Project Management. www.nhmichigan.com.

www.pci.org, 3/2004. Des Plaines, IL. Insurance industry regulatory statistical data reporting standards and procedures.

Walsh College, 5/2002. Troy, MI. Management Leadership coursework. www.walsh.edu.

Scoop, 6/2001; 6/2000. Troy, MI. On-site RPG IV and RPG ILE training courses.

IBM AS/400 Technical Conference, 4/1994. Cleveland, OH. RPG IV/ILE workshops.

Contact this candidate