Accounts Payable, General Ledger,
PeopleTools, SQL, SQR, Cobol,
Application Engine, Database Agents, Query, Crystal
Technical
Lead – Programmer Analyst April, 2000 to Present
Frankenmuth
Mutual Ins. Co. Frankenmuth, MI
Platform: PeopleTools
8.47x/ 7.5x/6.0x, PeopleSoft 8.9X/7.5x/6.0x, Microsoft
SQL Server 7.0/6.5, Windows Server 2000/2003.
Tools: ISQL, Query
Analyzer, SQR,
Objective: Maintain and
enhance PeopleSoft version 8.x.
·
Upgraded
PeopleSoft Tools 7.59
to 7.60 to 7.61. – 8..2x to 8.47
·
Upgrade
PeopleSoft Financials Financials/SCM 7.5x– 8.4x– 8.9x
·
Technical
lead over PeopleSoft implementation of G/L and A/P modules.
·
Develop
AP check interfaces from legacy/mainframe systems.
·
Develop
GL journal interfaces from legacy/mainframe systems.
·
Develop
AP payment interface to “record” check information produced from a unique check
printing solution.
·
Utilized
Database Agent/Message Agent to update AP payment/voucher/vendor tables as part
of a nightly automated load process.
·
Implemented
multiple EFT formats and Positive pay solution.
·
Implemented
Open Item Accounting. Utilize Open Item
Accounts populating entries with AP, and GL data.
·
Continuing
support and maintenance of PeopleSoft
·
Provide
Business Analyst support in development and testing of new initiatives in the
PeopleSoft environment.
Senior
Programmer March 1996 to December, 2000
Frankenmuth Mutual Ins. Co.
Platform: IBM mainframe
Tools: TSO, ISPF,
COBOL, EASYTRIEVE, DB2
Objective: Utilize financial/statistical
information management software to fulfill the company’s needs in this
functional area.
·
Support
the financial/statistical processing and reporting of the company.
·
Develop
procedures, job flow and scheduling of process for the overall system.
Programmer June, 1994 – March, 1996
Nationwide Insurance Company,
Platform: Oracle 7.x, OS2, Unix, IBM mainframe
Tools: Cobol, TSO, ISPF, COBOL, PL/SQL
·
Batch
programming and DBA work on a 401k management system, using Oracle, pl-sql, and Microfocus Cobol on a
Unix platform.
·
Batch
and Online support and DBA on an Adhoc reporting and
quoting system, using Oracle on an OS/2 platform.
·
Batch
and Online mainframe programming for a Pensions Payout system.
PeopleSoft technical training:
Courses
8.x Peopletools I and II
Course 8.x PeopleSoft Security
Course 8.x PeopleCode
Courses
7.5: PeopleTools I and II
Other Technical training
DB2 Concepts and Programming
Introduction to Unix
Advanced Unix
SQL I
PL/SQL I
PL/SQL II
Tune SQL Statements
C programming
Case Tools I
Advanced Modeling Techniques
Information Engineering 1
CSCC ,
Degree:
Associates Degree
Concentration: Computer Information Systems
1998 - PRESENT DBWORLD.NET
http://www.dbworld.net
·
1998 - 1999 Private
venture using Redhat linux
, Apache http web server, smtp server, samba
server to provide internet virtual hosting
and Email, 7 days a week / 24 hours a day, to small and medium size companies.
·
1999 - 2003 Web site hosted off site and maintained as a personal
"hobby" site and retention of Email addresses
·
2003 – present - Semi Professional Photographer. Weddings, Portraiture, Art