Paul T. Rykiel

*** **** ******* ******, **** #*S

Chicago, Illinois 60613

773-***-****

dubzpj@r.postjobfree.com

Results- driven, self-motivated, IT leader with a proven track record in the areas of project management, design, development, training, support, and implementation of various business systems. Excellent communicator able to quickly identify key stakeholder critical business requirements and drive important project milestones. Strong technical skills and troubleshooting techniques. Ability to adapt to a changing business climate and embrace new technology.

Expertise:

IBM AS/400 I-Series: (CL, RPG, RPGLE, SQL, DBU, DFU, OS/400, DB2, Query), IBM Data Propagator,

Cognos BI Tools (Impromptu, Series 7, Cognos 8, CRN 1.1, Framework Manager), Java, XML, HTML, JSP, FTP Microsoft Suite: (SQL Server, Excel, Access, Outlook, Office) Eclipse, Merant, Softlanding (Turnover), Hawkeye, BPCS, AS/SET, Infinium, CS Stars, and JD Edwards.

Professional Experience:

Standard Parking Corporation, Chicago Illinois – Senior Systems Analyst

June 1999 – March 2010

Designed, developed, and implemented various computer business systems. Provided application support to internal and external users and clients. Worked with upper management to gather project and product requirements and set milestones. Trained end users on various computer business systems and techniques. Designed the Change Management process and workflow. Performed analysis and wrote specifications for programmers. Architected the Cognos Reporting environment. Adapted the company’s project methodology and chartering process. Fostered working relationships with internal and external departments. Administrative duties for Company’s Intranet and Internet sites. Managed several internal projects on a project team.

 Chargeback System: Designed and developed a system to charge clients for services and fees associated with managing portfolio accounts. Using the IBM AS/400 I-series, built a system that is flexible and scalable to the changing needs of the company. The administrative function is simple and user friendly, the execution and reporting function is plug-and-play. This system is fully integrated with Property Management System (PMS), the General Ledger, as well as the Statement processing system.

 Management Services Reporting System: provided application support and system maintenance to the business owners of this system. The system’s function is to track the wholesale costs versus retail costs of goods and services to clients and realize the net profit. Responsible for adding and tracking new services and building new reports for this system, using the IBM AS/400 I-series. This system integrates with the chargeback system, property management system (PMS), and the General Ledger.

 Insurance Budget Forecasting Tool: built a spreadsheet to forecast insurance costs and premiums for the coming budget year for the entire company. Using data stored on the IBM AS/400 I-Series raw data is downloaded into a tab on the spreadsheet and calculations are entered to create the main tabs and the summary on the spreadsheet. The original process took 2 weeks to build and troubleshoot. Using a MS DST SQL package redeveloped this process and reduced time to build from 2 weeks to 1 hour. The SQL package took the raw data from the IBM AS/400 I-series and transformed the data onto a tab on a predefined MS Excel spreadsheet. When the spreadsheet is opened, it recalculates populating all tabs.

 Canadian EFT System: Automated this process from a manual process. Using the IBM AS/400 I-series, retrieved Client’s monthly customer parker data to charge monthly fees for parking services to the Canadian bank. This system creates the raw EFT data file on AS/400 I-series and uses FTP to send the Canadian Bank (CIBC). The raw data is retrieved from the Revenue Management System (RMS) and contains name, address, bank account, monthly charge, parking location, etc.

 Cognos Reporting Environment: Managed this project from the beginning into the first roll out. Gathered requirements from each functional business unit and architected Cognos Catalogs. Authored training for all users. Using IBM Data Propagator built the reporting partition used by users of Cognos. The Data Propagator uses journaling to update the report partition in a real-time manner.

 Client View 1.0: As part of a project team, developed reports using Cognos Impromptu to create client monthly statements to be viewed on the Internet. This project was driven by the Western division of the company to specifically meet the needs of one portfolio account.

 Client View 2.0: Administrator of this Java based system. Base system was written using Cognos Imprompu and re-written in Java. Administrative duties include: setting up users using LDAP and XML, and HTML, performing troubleshooting and monitored system usage. Also, performed analysis and wrote specifications for Java programmers.

 Controlled Self Assessment System (CSA): Provided analytical activities into the development and maintenance of this system. The CSA system extracts questions from the Internal Audit system to allow the garage managers the opportunity to assess and score their performance prior to the actual audit. The system is Java based and uses JSP to integrate data from the IBM AS/400 I-series. Used Eclipse and Merant to understand flow and inner workings of system, for trouble shooting and maintenance. Wrote Specification for Java programmers.

 Change Management System: Managed this project from conceptual design to Implementation. Assisted in authoring the workflow feature which is a series of reports that tracks the progress of a project. The software used in the Change Management process is Softlanding’s Turnover. Turnover allows the user to check out or build the objects to their development environment, make changes and promote them to a test environment. After the users have completed their testing, the objects are promoted to the production. Turnover archives 5 copies of objects for programmers to restore. All documentation is stored in a folder on the server for auditors review.

 STARS implementation: CS Stars is a proprietary insurance system that is hosted by Marsh, Inc. Worked on the project team to build the interfaces for the CS Stars to populate the database that Marsh hosted for the company. Also, developed programs using IBM AS/400 I-series to retrieve deductible claims information to be applied to client’s monthly statements.

 Project Methodology and Chartering process: The Company adopted a methodology for project management authored by Ernst and Young. Wrote a scaled down version of the chartering process for the company. The scaled down version included: Introduction, Project Objective, Project Scope, Functional Design, Technical Design, project team, work breakdown structure, budget, In-scope items, out-of scope items, constraints, communications design, testing, and final signoff.

Whitehall Jewelers, Chicago Illinois – Senior Programmer/Analysts and Project Leader

August 1997 – June 1999

As part of a project team of programmers and business analysts, rotated between project leader and programmer. Designed, developed and implemented various systems using JD Edwards and Dreamwriter.

 Breakup System: Using IBM AS/400 I-series designed and developed and implemented this tracking system, which empowered the user to track heirloom jewelry pieces and inventory them with proper value. Built for insurance purposes and loss prevention

 Y2K Project Team: worked on a project team to analyze and reformat all date driven processes and reports.

Whitman-Hart, Chicago Illinois – Senior Consultant

March 1995 – August 1997

Provided consulting services to clients of Whitman-Hart. Services include analysis, database design, programming, implementation, training, support, documentation, and troubleshooting.

 Candle Corp, Des Plaines Illinois, worked with H/R division in development of H/R reports for EEOC

 General Binding Corporation – Northbrook Illinois, Using AS/SET Program generator, wrote reports for upper management

 Select Beverages – Darien Illinois, on a project team wrote specification and programs for a new inventory system, where the user used cell phone technology to transmit inventory data back to the AS/400 system

 Road Master – Olney Illinois, senior developer of a payroll incentive system, where bonuses were awarded based on a quota system. This system uses BPCS as the base MRP system.

Education:

BA in Computer Information Systems, DeVry University Chicago, 1987

Loyola University, course in Java and Data Structures, Chicago 2000

Master of Project Management, Keller Graduate School of Management, 2002

PMP Certification, Project Management Institute, 2009

DePaul University, Master of Computer Science, Chicago (expected in 2013)

Excellent References available upon request

Contact this candidate