Computer Skills
Languages

• 3 years AS/400 RPGIII, 8 yrs AS/400 RPGIV with ILE modular construction
• 11 years AS/400 CL , Query/400
• 4 years creating Crystal Reports also one year using SSRS and .Net
• PC Programming, Visual Basic 2005, 2008, C++, SQL Server

Software

• Database, DB2, Microsoft SQL Server 2000, Microsoft SQL Server 2005.
• Data Warehouse, fact and dimension tables.
• Query, Query 400, Microsoft Transact-SQL with stored procedures, views and functions.
• Reporting, Crystal Reports 9, 10, XI and 2008, SQL Server Reporting Services
• SQL Server Management Studio
• Visual Studio 2005, 2008.
• Visual Source Safe.
• Microsoft Office, Word, Excel, Access, Visio.
• SharePoint
• VPN, Cisco Systems.
• Platforms, OS/400, Microsoft Windows 2000, Microsoft Windows XP, Vista and Windows 7.

Hardware

• Assembled many PC computers from scratch. I have ordered the hardware, assembled the computers, and installed the OS and software. I have worked with imaging. Repair computers for friends and family. Maintain and support my sister’s laptop computers for her Whole Child Learning Company. I am very good at troubleshooting hardware and software problems.
• Latest Build - Media PC

LIAN LI PC-A05NB Black Aluminum ATX Mini Tower Computer Case
ASUS P7P55D-E LGA 1156 Intel P55 ATX Intel Motherboard
Intel Core i5-750 Lynnfield 2.66GHz Quad-Core Processor
CORSAIR XMS3 4GB DDR3 1600 Desktop Memory
HITACHI Deskstar 1TB 7200 RPM Internal Hard Drive
POWERCOLOR Radeon HD 5770 1GB Video Card
CORSAIR 650HX 650W 80 PLUS BRONZE Certified Modular Power Supply
LITE-ON Blu-ray Disc Reader
Noctua NH-U12P SE2 120mm CPU Cooler
Microsoft Windows 7 Home Premium 64-bit

Experience
Programmer Analyst 2008 – 2009
Confidential,Appleton WI

• West provides business-to-business sales management solutions to almost 100 clients. I worked for West client American Express, developing and supporting custom reports used to monitor their credit card direct phone sales. These reports are created with Transact-SQL stored procedures and functions, Crystal Reports XI and SSRS. The client can access reports from web portals or the reports can be emailed directly to the client through automation
• I also provided technical/on call support for American Express Database and Reporting. I am familiar with help desk software, on call conferencing, creating service desk tickets, resolving service desk problems in a timely manner and client follow-up.

Programmer Analyst 1999 – 2007
Confidential,Neenah, WI

• Lead programmer for a rating system for Commercial Jewelers Block Insurance line.

This application calculated policy premiums and could be run live, in batch or during the night cycle. This application used IBM’s Integrated Language Environment (ILE) to compile the live and batch CLs, the main rating engine, the 45 modules or steps of rating and calculation sub-procedures into one application. I developed the Management CLs, the main rating engine and the more sophisticated rating modules. I also was in charge of creating the binding directories used for compilation.

• Lead programmer for a rating system for Commercial Jewelers Standard line. This was scaled down version Business Owners Property offered to small business owners. This system followed the same format as the previous.
• Designed and developed our Forms System. Jewelers Mutual Insurance is a very specialized insurance company, for this reason, Jewelers wanted to create an in-house system to manage all the paper leaving the building. The design needed integrate a data queue for both interactive and batch formsets, a main engine that managed the formset generation, and print queues for printing and imaging formsets. The design also needed a program that handled all static forms and programs for each variable from. I programmed the data queue program for live and batch, and the main engine. The main engine generated each form, managed the formset, copied the spool files to print queues for printing or imaging and also managed the printers in a dataarea rotation. If a form was not generated the formset was not printed and an error report was given to the underwriter of the policy. All of the above is still used by Jewelers Mutual Canada.
• Jewelers Mutual has now purchased a server based system to handle all transactions for commercial and personal lines. This purchase was made to improve productivity and technology.

During the development of this system, I was assigned to the Reports Team. I created mainly financial and claims reports, using Microsoft Transact-SQL stored procedures and Crystal Reports. These reports were produced from the transactional database or from the financial data warehouse.

• Enhancement to Business Owners Property line v1.01, v1.02 and a major revision 2.00.
• Enhancement to Jewelers Block Insurance line v1.01.
• Enhancement to Jewelers Standard line v1.01 and v1.02.
• Creation Policy inquiry program using sub-files.
• Creation and maintenance of forms using stored procedures and Crystal Reports.
• Monitored overnight cycle through VPN.
• Worked on Help Desk calls to resolve customer problems.

Consultant 1996 - 1999
Confidential,Milwaukee, WI

• Engagement Jewelers Mutual Insurance, Length 9 months

I was brought in to Jewelers Mutual to create their first application to be developed in ILE RPG. This application rated premium for Jeweler’s Business Owners Property line of insurance. The application was the first policy rating application to be fully automated and integrated to their PCA Policy Entry System which was written in COBOL.

• Engagement Miller Brewing Co, Length 1 year

My assignment at Miller gave me a chance to be part of team of New Resources consultants. The team managed information services for Miller Brewing’s newly acquired import beer company. I was there to write an EFT (Automatic Fund Transfer) system, which would electronically transfer payments from beverage company banks, around the United States, to the import company bank. This application was written in RPGIII.
From this application I went on to help expand the import company to two import companies to better represent Miller’s ownership.
I also developed an FTP application to transfer data from the import company to Miller’s data warehouse on the mainframe.

• Engagement Oshkosh Truck, Length 3 months

At Oshkosh Truck I worked on J. D. Edwards software user enhancements. I worked on improved screen navigation and added more user fields to screens.
I also developed an enhancement to copy older inactive parts back into production. This saved users from reassembling the parts from scratch.

Consultant 1996 - 1996

• Confidential,Engagement Copps, Length 6 months

At Copps, I joined a Capgemini team that was developing a warehouse management system in a 4th generation language called SIGNON. Here I developed handheld screens and the logic behind them.

Education

• 3 yrs Radio-TV-Film
• Associate Degree CIS Programmer Analyst
• Associate Certificate PC Programming