SUMMARY

• Information Technology Senior Programmer/Analyst for the AS400 - with proven experience in designing, developing, testing, deploying and maintaining applications.
• Excellent understanding of the entire project life cycle. Expert in analytical problem solving. Strong in RPG development.
• The desire to learn new technologies as needed. Would like to branch out to an Object Oriented technology.

TECHNICAL SKILLS

• RPGIV
• CLP
• DDS
• RDA
• MS-OFFICE
• ILE/FREE
• MKS IMPLEMENTER
• SHOWCASE
• REMEDY
• HAWKEYE
• QUERY
• SQL EMBEDDED
• SUBFILES i2 TM400
• XML
• FTP
• DB VISUALIZER
• SQL
• WEBSPHERE-
• ECLIPSE
• CLIENT ACCESS
• RUMBA
• INFINIUM /ERP
• CITRIX
• CODE 400
• SYNON
• I2/TM400
• SHARE POINT
• CLIENT ACCESS
• FREE FORM
• TURNOVER
• ABSTRACT PROBE
• DB2 400 ViSiO
• HP Quality Center(Mercury)
• TL Ashford
• MQ Team Tracker
• Maximo

PROFESSIONAL EXPERIENCE

Confidential - Palatine IL

Programmer Analyst

Responsibilities:

• Weber is the iconic BBQ Grill company located in the Chicago Suburb.
• My job consists of both Adhoc requests and Projects using the AS400 Platform.
• Programming is done on the AS400 7.2 using RPGILE, CL, DDS etc…
• Create Bar Code Labels with the TL Ashford product.
• Help administer the MKS Implementer product for work Management.
• Follow the standard SDLC job cycle to Analyze, Design, Code, Test, QA and implement.

Confidential - Dallas TX

Programmer Analyst

Responsibilities:

• Confidential is a TV/Internet/Phone Company. They service the rural areas of the country.
• Was brought in to help with several phases- Modernization of legacy code and Break fixes.
• The language being used is the current RPG release 7.2. Completely Free Form.
• Most of the time I work from home remotely. Once a month, I live in Dallas TX for a week.
• Proactive in daily meetings, and educational sessions to be on the same page as other staff. We follow an agile SDLC.
• The programming is state of the art RPGILE using procedures and Embedded SQL.

Confidential, IL

Programmer Analyst

Responsibilities:

• This Retail Giant merged with Office Depot. I worked in the Logistics Department to support Confidential until the merger was complete. I worked with the AS400 team. The code was written in RPGII, RPGIII. RPG4. FREE FORM, ILE, CLP, DDS etc….
• Handled Remedy support tickets throughout the day finding the correct remediation.
• Created new Programs in order to fix an existing problem or a new enhancement.
• Followed a SDLC that consisted of Design/Unit Testing/QM Testing/ and a Change Request workflow signoff.
• This company has 87 factories across North America. I worked in the Finance Division with the AS400 team. The code was written in RPGII, RPGIII. RPG4. FREE FORM, CLP, DDS etc….
• Performed a file/field data conversion. This involved modifying many files and programs, as well as converting the data to match the conversion. We modified over 6000 programs.
• Test scripts were given to us to perform our unit testing before turning the objects over to Quality Control to Test.
• Performed maintenance and and new development on the legacy system on the AS400 platform.

Confidential, Chicago IL

Programmer Analyst

Responsibilities:

• This environment is a law firm specializing in Real Estate Foreclosure cases.
• I work in the IT Department as an IBM AS400 Developer. Using the RPG language to create reporting for the 60 lawyers as well as the clerical management at the law firm.
• Extract DB2 data to excel user friendly file formats, and create Ad Hoc requests.
• My job is to answer the users request entered in the Help Desk ticket system.
• Create and modify an in house desktop management system that interacts with the ISERIES objects.
• Create reports to help make strategic decisions in managing the law firm.
• Interfaced heavily with the Business Analyst to put the correct specifications together.

Confidential, Naperville IL

Programmer Analyst

Responsibilities:

• Work was done on the AS400/ISERIES. The language was RPGIII/RPGIV/RPGILE/FREEFORM.
• I performed the standard SDLC requirements to complete each task.
• The conversion for my department was finished. The postmortem needed support work to patch and repair loose ends from the AS400 to SAP conversion.
• Used tools such as Remedy, Share point, Rumba, Clarity, Turnover, MQ etc…. to do my job.
• Worked closely with the users and business analyst to assure accurate results.
• Development was done on the AS400/ISERIES. The language was RPGIII/RPGIV/RPGILE. Publicly held company. Strong methodologies were in place.
• I performed the standard SDLC requirements.
• A Project performed: The Company was in the process of migrating and interfacing the AS400 data to the SAP System. I made modifications to the existing RPG applications to interface the SAP system. The result was data became more accessible to all platforms.

Confidential, Deerfield IL

Systems Analyst-ISERIES Retail Industry

Responsibilities:

• The IT department needed someone to work as a Systems Analyst a long side the existing contractors (TCS). Gathered information from the company users to put together the Business, Functional and Technical requirements.
• The development was done using the RPG (SYNON) case tool. I learned the database design and Action Diagrams to perform my job.
• Worked as a team with the offshore team in India via phone conferences to assist in the development.
• Performed the entire SDLC and Unit testing for projects that were recently modified.
• I checked out and promoted the applications through the MKS Implementer work management system.
• Projects performed were as follows: Changing an item-delete function. The delete function delayed 60 days before the item is actually removed from the system. This saved the company from making costly mistakes of removing items prematurely.
• Produced a multi-file feed to an external vendor. In return - server received cost recommendations. This freed up valuable labor within the corporate office which was put to a better cause.

Confidential - North Chicago

Programmer Analyst-ISERIES Pharmaceutical Industry

Responsibilities:

• The company needed help with their International IT projects. I helped determine the remediation after the company changed to a new Fiscal year for reporting. I programmed and completed the backlog. %10 Labor Savings.
• The work was done using RPGIII, RPGIV/ILE language.
• The different systems needed to be documented through a formal Documentation system and SharePoint. Performed the documentation for programs I modified.
• Performed Unit testing for projects that were recently modified, and ready for QA.
• I checked out and promoted the applications through the TURNOVER (similar to MKS) work management system.
• The company had back logs in development. Using RPGIV/ILE, I programmed and completed the backlog. I saved the company 20K, in labor cost.
• From a Showcase product, users created their own queries that did not show correct information. Transformed the problem bound Showcase queries into structured RPG programs. This produced accurate forecasting and prevented 25% of wasted material.
• There was too much guess work for forecasting inventory. I modified the DB2 database to reflect correct inventory figures. Invoices went out faster accruing 30% more revenue.
• MKS was the tool to check out and implement the program modifications.
• Development was done through the Infinium ERP menu.

Systems Analyst

Confidential - Deerfield IL

Responsibilities:

• While reviewing the RPGIII, IV programs, determined the remediation for changing the distribution frequency of the Advertisement-Weekly-Flyer to match actual sales data. Provided actual sales reporting.
• Documented existing system, which allowed easy understanding of system flow, saving analyst’s time. Used Synon case tool to gather this information. Saved 85% of time and labor.
• The Work management system was MKS. Promotions were done through an Admin.
• Helped lead an offshore team.
• Acted as a SME to gather knowledge from AS400 system. Guided offshore developers, to understand the USA IT operations from overseas. The learning curve was shortened by 50%.
• Developed RPGIII, IV and CL programming changes when necessary to help keep the overseas developers on schedule. Allowed the offshore IT group to take control of the USA IT operations.
• Worked with a team to allow agents to gather insurance quotes Via the Web. This interface to the AS400 database increased sales by 40%. I checked out and promoted the applications through the ALDON (similar to MKS) work management system.
• Created an Excel VBA internal tool that generated and displayed the capital gained for each year of service with the company. Convinced the senior executive the wealth to be gained by staying onboard. This helped maintain customer relationships adding 40% more projects and revenue.
• (Playboy) Created FTP transmission of data between client and sister companies, as well as made strategic modifications to the warehouse pick/pack system. The goods went out the door in far less hours.
• (Ace Hardware) Customized the i2 TM400 transportation package to work for the company logistics dept.
• (E-Trade) Put together a database to allow a welcome customer package to be mailed out.
• (Shell Vacation) Modified the timeshare system to sell new timeshare business.

Confidential

Sr. Programmer/Analyst

Responsibilities:

• Reengineered the I2TM400 package to interface with the client databases, allowing the company to bring on new customers with little effort, and generated revenue 80% faster.
• Worked with the Web team to provide real time AS400 carrier and customer information send to and from the Web. Customers did not have to rely on customer service for questions on shipments. The result was 35% more truckloads created.
• Created an interface with AP and AR records within the Infinium Accounting software database. Auditing was able to show accuracy to management, and save on research costs.
• Answered and entered support tickets. Performed upgrades to the multiple AS400’s I2 software. Problems were rectified in a timely manner.
• At month end, interfaced with the Infinium GL files to balance the books.
• Created a Royalty Payment System to calculate the percentage of royalty from the sales figures, and automated a check to be mailed to the designer. Saved the Licensing department 95% of labor cost
• Developed a cost system to show the breakdown for the cost of an item. Negotiation for item cost was handled accurately and in a timely manner. The negotiation was handled 75% faster.
• Managed the MKS Implementer. All developers were able to shorten the time taken to complete the project life cycle.
• Made interface accounting files stay in sync with the JDE interface package, by reviewing JDE code and building a bridge CLP program.
• Made new functionality and modifications to the existing warehouse system. This made the warehouse run more efficiently.