We provide IT Staff Augmentation Services!

Business Analyst/ As/400 Consultant Resume

2.00/5 (Submit Your Rating)

MinnesotA

CAREER GOALS:

My goals is to be a valued employed by always enhancing my skill level inside and outside of work. To become the go to resource on technical issues. I want to learn the system so I can assist in utilizing it to its full functionality. I want to understand each user roll so I can be able to write custom enhancements the increase their productivity. I want to produce issue free end products so when an enhancement is installed there are no issues. I want to be able to come up with custom solutions that increase the user’s productivity and save the company money. Outside of work I plan on working on acquiring a PMP.

PROFESSIONAL SUMMARY:

  • Information Technology professional with more than 20 years of experience.
  • Participated in full life cycle development projects which included analysis, administration and obtainment of user requirements and converting them into project specifications, design, development, system testing, implementation, maintenance and user training.
  • Excellent analytical, programming, organizational skills and diversified experience with various aspects of business systems (such as warehouse management, shipping, receiving, picking, purchasing, price lists, contracts, transportation, order entry and order processing accounts receivable, accounts payable, general ledger), conversions to packages (data mapping, data conversion, program customizations, program and file enhancements) and as well as experience with development of Data Warehouse.

TECHNICAL SKILLS:

Software: OS/400, AS/400 Administration, AS/400(CL), RPG - II, RPG/400(RPG-III), RPG-ILE(RPG-IV), RPG Free, 400(COBOL), 400(COBOL-ILE), CL, SDA, DFU, DBU, DSPDTA, SEU, Subfiles, Query/400, SQL/400, Client Server, Overlays, Embedded SQL, Sequel, Aldon, Abstract, NIKU, Fast Fax, APlus, Mplus, Hawkeye, Crystal Reports, TL Ashford, UNIX, Micro Focus COBOL, RM COBOL, JAM, MS Word/Excel, Microsoft Project, Quickbase FTP, MQ, EZFTP and exposure to Preminos EDI.

Package Software: ASW ver 3.2 and 4.92, ASI, People Soft, Legacy, Real World and MCBA.

Applications: Customer Order Processing, Distribution, ERP, Manufacturing, Inventory, Sales Analysis, Purchasing, Quotes, A/R,A/P, G/L, Budgeting, H/R, Insurance Claims, Trading and other.

Hardware: ISeries, AS/400, IBM RS series (RS6000), HP UNIX Series (HP9000), NCR Towers and Unisis.

Documentation Created: Requirements Specifications, Functional Specifications. Project Plans, Project timelines, Project Cost Analyst, Data Flowcharts, Project Benefit Specification. System Flowcharts Series

PROFESSIONAL EXPERIENCE:

Confidential, Minnesota

Business Analyst/ AS/400 Consultant

Responsibilities:

  • Analyzed parts existing ERP system so I could correctly proceed with request
  • Documented parts of the ERP system,
  • Reviewed work that was done on AS/400 using RPG/ILE, COBOL, Query, CL, SQL and other AS/400 tools.

Confidential, Dallas, Texas

AS/400 Consultant

Responsibilities:

  • Analyzed parts existing ERP system so I could correctly proceed with request
  • Maintained existing RPG programs in the ERP system,
  • Developed new requested reports that were assigned.
  • Work was done on AS/400 using RPG/ILE, COBOL, Query, CL, SQL and other AS/400 tools.

Confidential, Logansport, IN

Business Analyst

Responsibilities:

  • Ran several projects first doing feasibility studies, cost analysis, and requirements gathering.
  • I then would create a requirements document and project plan.
  • Utilized the information systems development life cycle (SDLC), information technology, project management tools and approaches to development and implementation.
  • Work with user to get full understanding project scope, project goals, product functionality, and desired features.
  • Ensure that change requests are written in such a way that requests are in clear format for the vendor and developers.
  • Analyzed existing reports on IFS system
  • Information Systems manager.
  • Wrote reports and outside applications that interactive IFS.
  • Assisted user in system and user errors.
  • Created documents, for project planning.
  • Supplied weekly status reports.
  • The work was done using Crystal Reports, Toad SQL and Access.

Confidential, Dallas, Texas

AS/400 Consultant

Responsibilities:

  • Analyzed parts existing ERP system so I could correctly proceed with request
  • Analyzed system bugs and wrote reports that showed the records effected,
  • Developed new requested reports that were assigned.
  • Work was done on AS/400 using RPG/ILE, Query, COBOL, CL, SQL and other AS/400 tools.

Confidential, Springfield, IL

Business Analyst Senior Consultant

Responsibilities:

  • Analyzed existing reports on legacy system
  • Wrote conversion specifications for the SAP consultants for ERP system migration to SAP..
  • Also did data mapping and tracking down the business rules involved in calculating fields.
  • Created documents used to map and implement business rules.
  • Supplied customer status reports.
  • The work was done using AS/400 Sequel, RPG/ILE, RPG Free, COBOL/ILE and CL.

Confidential, Houston, TX

Senior Programmer Analyst

Responsibilities:

  • Handle the day to day affairs of the IT department.
  • Track down and fix existing bugs in the system.
  • Handle user and customer request for modifications to the system or new reporting capabilities.
  • Gathered requirement and documented changes.
  • The work was done using AS/400 RPG/ILE, RPG Free, COBOL/ILE and CL.
  • Administered and customize ASW ERP caned packaged.

Confidential, Algonquin, IL

President

Responsibilities:

  • Started the company by purchasing a 12 unit residential building in Elgin. In the past four years, went on to purchasing another 42 rental units.
  • Spent the last two years, purchasing and rehabbing properties, some were sold as flips and the others rented.
  • Present inventories consist of a 15 unit, 12 unit, 8 unit, 6 unit 4 duplexes and 5 houses. The company has over $500,000 in revenue.
  • Project manage skills came in to play by setting company systems and successfully running rehabbing projects, that have come in on time and on budget.

Confidential, Waconda, IL

Project Manager

Responsibilities:

  • Designed and managed all aspects of projects.
  • Created full project documentation, assigning task to developers, meeting with Clients and the user community.
  • Ran several successful projects from bringing on new clients to customizing and enhancing existing system.
  • Ran conversion project, converted Purchasing and Customer service for Legacy system to ASW 4.92. Participated in staffing administrating and scheduling IT personal, The work was done using AS/400 RPG/ILE, RPG Free, COBOL/ILE and CL.
  • The engagement used Aldon for their change management system. Quickbase and MS Project for Project management.
  • Worked on migration project from ERP system to ASW.
  • Administered and customize ASW ERP caned packaged.

Confidential, Chicago, IL

Consultant

Responsibilities:

  • Role was a developer.
  • Coded custom modification to real time applications.
  • Performance coding techniques to multithreaded applications were used.
  • Played a key role in developing an employee trading system.
  • Binding/Procedures, Activation Groups, User-Q’s and Service programs utilized. The work was done using AS/400 COBOL-ILE, RPG-ILE and CL.
  • The engagement used Aldon for their change management system. NIKU along with Remedy used for keeping track of billable time.

Confidential, Crystal Lake, IL

Senior Programmer/Analyst - Project Lead

Responsibilities:

  • Created several conversion programs.
  • Customized the Confidential Order Entry and Distribution systems.
  • Created several new programs for picking ticket selection. Provided a partial project plan, user instructions, system documentation. Programs were written using COBOL-ILE, RPG-ILE, RPG Free, Subfiles, SQL, Query, Fast Fax, Preminos EDI, MQ, and CL.
  • Converted the existing distribution to create picking tickets and packing slips. Overlays where used on the packing slip to display company logo and formatting lines. Altered ship verification process to handle customized freight system.
  • Created Order Acknowledgments in 400(COBOL-ILE) and CL that would automatically be sent to the customer via fast fax.
  • Customized Invoices that utilized AS/400 Overlays saving the expanse of pre-printed forms. The invoicing system was written in 400(COBOL).
  • Customized Alter Standard system to create Magnification Orders and routings. Programs were written using RPG-ILE, RPG Free and CL.
  • Implemented and upgraded fast fax. User documentation was created. Work was done in COBOL-ILE, RPG-ILE Subfiles and CL.
  • Did several migration projects to the AS/400 ASW system.
  • In charge of maintaining and user support of the Customer order Processing system, Accounts Receiving System, Purchasing system, Distribution System, Inventory System, and Fast Fax system.
  • Wrote Interface between Confidential purchasing system and Sandvik Sister Companies. Communications used MQ and Funnel. Work was written in RPG-ILE, RPG Free and CL.
  • The EDI Administrator for 1.5 years.
  • Did some administration work such as system upgrades, security and adding users.

Confidential, Rolling Meadows, IL

Senior Consultant

Responsibilities:

  • Role was analyzing all AS/400 applications for changes needed that would make the systems 2000 compliant.
  • Hawkeye, FNDSTRPDM and Query were used in determining what files and programs need to be changed.
  • Responsible for changes needed in the Y2K project. Part of this was putting him in charge of all changes to COBOL programs.
  • Converted all COBOL programs into COBOL/LE, to utilize was the new date functions.
  • Converting RPG-ILE programs. All work was performed in AS/400 Query, RPG-ILE, COBOL-LE and CL.
  • Role was as a Programmer/Analyst responsible for writing a file maintenance program using sub-files, EDI invoice program, and several work in progress programs.
  • Did maintenance of several other programs for A/R, A/P and manufacturing applications.
  • All work was performed in AS/400 Query, RPG-ILE, COBOL-ILE, Sub-files and CL.
  • Role was as a Programmer/Analyst responsible for writing conversion programs that convert files from an AS/400 to an IBM Mainframe.
  • Assisted in mapping fields from file to file, analyzing results and using Query for exception reports.
  • All work was performed in AS/400 Query, RPG-ILE and CL.
  • Some modification of COBOL-ILE programs was done.
  • Assisted in migration project to AS/400.
  • Role was as a Programmer/Analyst responsible for writing and interface between Accounts Payable and EDI.
  • The interface would receive EDI 850 Inbound Invoice transactions and automatically check to see if the goods have been received and then make payment.
  • This saved the company over $800,000 the first year. They were able to reduce the Account Payable staff and receive early payment discounts.

Confidential, Chicago, IL

Senior Programmer Analyst

Responsibilities:

  • Customized and developed Fund Based Accounting System in Micro Focus COBOL, C, IQ Report Writer and JAM on UNIX platforms.
  • Did phone support, Training and Sales. The client’s base consists of Airports, U.S. Territories, Cities, Villages, Park Districts, Churches and Countries.
  • System consist of A/R, A/P, G/L, Inventory, Work Orders, Lease Management, Properties, Cash Receipts, Central Name and Address, Animal License, Vehicle License, Business License, Call Tracking, Alarm Billing, Ticketing, and Utility Billing.

Confidential, Libertyville, IL

Programmer Analyst

Responsibilities:

  • Customized and developed Fund Based Accounting Systems in RM COBOL on DOS, UNIX and AS400 platforms.
  • The client base consists of Small Cities, Towns and Villages.
  • Systems consist of A/R, A/P, G/L, Cash Receipts, Vehicle License, Business License, and Building Permits.

Confidential, Arlington Heights, IL

Programmer Analyst

Responsibilities:

  • Customized RealWorld Accounting Systems in RM and Micro Focus COBOL on UNIX and DOS platforms.
  • System Consist of A/R, A/P. G/L, Order Entry, Cash Receipts, and Inventory.

Confidential, Northbrook, IL

Programmer Analyst

Responsibilities:

  • Designed and programmed, Merchandize Incentive Systems in Wang COBOL.
  • Ran two major accounts with an income of over 1.9 million.
  • Recognized for outstanding service and increasing account income.
  • Developed and maintained various in house administration systems, including MCBA accounting package. Also used Wang RPG, Wang Assembler and Wang Utilities.

We'd love your feedback!