Objective

• A challenging, growth oriented technical lead or software developer position, on the AS400/IBM I - Series using RPG, COBOL, SQL, or a newer technology, where I can apply my technical, analytical and organizational skills.

PROFESSIONAL EXPERIENCE

Confidential

SR Programmer Analyst

Responsibilities:

• Order Entry Supersedes - In corporate auto recommendations for old items vs. new items based on inventory level of each
• Billtrust Invoices - Modify in-house invoice printing to in corporate COD customers, as well as include all invoices previously excluded in files sent to Billtrust for invoice generation. Interface with vendor to finalize requirements, and SOWs.
• Claims - Expand Claim Number in DB files, modify programs as needed
• Customer Deposits - Interface deposits to Billtrust
• Clarity (Blueridge) Forecast Loads
• Production Support on Mincron ERP and in-house software; Pricing, Order Entry, A/P, Claims, Invoices, Statements, Excel refreshables, Month End Processes, Physical Inventory, etc.

Confidential

RPG Consultant/Analyst

Responsibilities:

• Price Change Reason Code - PM, BA, Developer of project. Capture Reason Code in numerous applications for price change analysis. Impacted areas; Trends, Price Changes, Rebates, Discounts, Remedy System for origination of data
• Customer Matching - Performance Improvements
• Warehouse Cycle Counts, and Inventory Adjustments - Institute edits for amounts, and adjustments to inventory, and receiving detail
• Contracts and Pricing - System wide object impact analysis, QA, and Development
• Price Override - System wide field/object impact analysis
• Customer Licensing, Dispensed Data, and Questionnaire screen maintenance changes
• Developed pgm to interface from RPG to Java (non funded)
• Developed Automated FTP application (non funded)

Confidential

Senior Rpg Developer/Analyst

Responsibilities:

• Sales Comparison by Category - create .xls of sales comparisons for current and previous periods, and years
• Safety Management System - gather, and document requirements
• ACH Confirmation - integrate into payroll, and A/P an e-mail reminder for ACH confirmation
• Paystub GUI screen/create PDF - Created a GUI screen using Profound Logic which listed pay stub summaries. Modified payroll program to create an on-demand pdf paystub
• Cafeteria Plan Report & Maintenance screen
• Sub Category Maintenance Screen & Mass Update Program

Confidential

Senior Developer/Analyst

Responsibilities:

• Main Commissions programmer: Worked with users to develop comprehensive requirements documents, responsible for design, construction, testing, etc. of software solutions. Flat file processing as well for industry comm. formats. Savings per year due to automations for days
• Pershing Pricing Markups: Major system enhancement, 500 members looked at, 230 or so modified/new.
• DASD Utilization and Reorg Tool - 10% savings achieved
• Revenue Coding: Provide mechanism for Accounting, and Commissions to reconcile, code all receipts by various criteria. Various reports, exports provided for interfaces, analysis.
• SSN Masking: Mass System Analysis to identify programs/screens where SSN needed to be masked
• Websmart - preliminary tool analysis, modified SQL portions to interface with our DB in order to determine response time effect.

Confidential

RPG/COBOL Consultant/Contractor

Responsibilities:

• Peg Billing: Development, assist manager and tech lead with design, documentation, interface within the team, and other teams, users as needed
• Replace Query: Analysis/construction of programs to replace query. Primary focus to provide security, an audit trail, and ease of use for users with current Ryder database structure of sites/numerous I Series boxes
• Invoice Extract and Purge: Created new version (by replacing cursors) with run time improvements from 18 hours to 1.5 hours for 35000 invoices
• DASD & Reorg process: Analysis, and DASD Cleanup. Saving of 75 gig, identified various problems with reorg program.
• Short Term Warranty: Analysis/Rqmnts of Parts Disposition, etc.
• Electronic PM Follow Ups: analysis/requirements gathering of a previously on-hold project. Added functionality to process duplicate follow up task strings & federal/state PM edits throughout SMO & PM Follow Ups application. On hold.
• PM Yield Mgmt: design/construction of functionality to edit activation of PM tasks using a percentage of days/miles intervals. iWarranty: attended initial vendor/SOW/requirements meetings. Provided support/backup for project manager, initial analysis/estimate/requirements gathering for RCRC feed, parts price master feeds, obtaining warranty data on SPOs.

Confidential

Senior Developer/Analyst/Project Lead

Responsibilities:

• Viking Address Verification Pool within JMILLENNIA (application used by CSRs):Developed application which consisted of displaying appropriate records, navigation to other pages, allowed addresses/order(s) to be approved/rejected, and notification of address/phone changes at approval time. Interacted with the 400 via stored procs, DB2/SQL, or entries placed into a DTAQ.
• Viking Outbound Pool within JMILLENNIA: Added phone scripting functionality, retrieved the scripting data from the AS/400 via DB2/SQL embedded in Java, developed the Sales History Screen.
• Customer Centric Data Warehouse (CCDW)
• Sub Project 3: Led this phase which involved integrating the Address Validation web service into the existing applications, and Front End modifications to support CCDW. 1st and 2nd phases implemented (file changes, modifications to integrate the address service into our existing AS400 applications). Note: Use of web service was switched as IBM service was not fully operational.
• Sub Project 2: Worked with IBM, vendor, and in-house staff to provide/map the address validation rules, and the new message format to be used by the Address Validation service.
• Sub Project 1: Project lead for BSD Acxiom/Duns phase 1 re-design
• Responsible for AddressValidation modules using Group 1, integration into existing systems, made common modules, maintenance, and upgrades, Canada implementation, participated in vendor selection process for new Web Service based Address Validation software.
• Developed/maintained different Customer applications/projects (Viking Integration, initial Contract Mgmt/Pricing implementation, Customer Setup, MBS Billing from the 400 to the mainframe, numerous Downloads/Uploads, etc.)

Confidential

Systems Analyst

Responsibilities:

• Clearance Prices: Technical lead. On the Corporate system, the project determined the next recommended price for skus based on length of time since price changes, available quantities, rate of sale, etc. Users could override, accept, or remove the recommendation, which was applied to the stores’ systems.
• Customer Owned Inventory & Radio Frequency (RF) Scanning Design: Involved in initial analysis/design for implementing RF functionality for merchandise picking.
• Migration from Confidential ( Confidential ) Finance to Confidential Corporation (HFC): Responsible for analysis, design, and rewrite of previous programs which created flat files for Confidential . Implemented first time use of RJE. RJE was used for sending Settlement data to HFC, and receiving their response.
• Numerous improvements; Central repository of raw data, duplicate record detection, data capture, and screens for users to maintain the data.
• Warehouse and Inventory: Involved in team analysis and re-design to a real-time system from a batch system, and to use RF scanners. (note: project was unfunded). Created numerous screens related to the following applications;
• Receiving, Change of Inventory Location, Pick & Receiving Lists, Warehouse Pick Activity, Customer on Order Fulfillment, Pick Efficiencies
• Furniture Assurance Plan (FAP) Sales: Responsible for analysis, design and construction of the following portions of the FAP project:
• Collection/Transfer of data to the insurance provider, FAP Credits, Historical database, Close Ratio Reports
• Forecasting application; developed new maintenance system, upload/download capability, parallel yield analysis
• Developed new policies for new bookings for various applications, while allowing existing bookings to use the old policies; Air Gateways Availability, Commissions.
• 1099s: Developed data accumulation/capture in Reservations, transfer to Lawson

Confidential

Project Lead

Responsibilities:

• Interface/Collection of Reservations data: Corrected data inconsistency problems in Reservations, and developed systems to automate/allow a direct reconciliation from Reservations to Accounting.
• Standard Costing: Developed table driven modules used to calculate yield, and capture itemized revenues and expenses from the individual components sold to passengers.
• Financial Applications: Integrated Standard Cost module into all applications; Daily Reporting, Revenue Recognition, Voyage Close.
• G/L: Table driven revenue, expense, and liability groupings, as well as account summaries for Voyage Close/Revenue Recognition. Data collection by grouping interfaced into Lawson.
• Air Ticket Costs: Implementation of interface from Sabre CRS to ADS.
• Lawson Software: Installed releases, created/maintained testing, training environments

Confidential

Programmer Analyst

Responsibilities:

• Fax/400: Implemented on the Reservations System for invoices. This included overlays, status reports, status updates to bookings, and retry logic.
• New Tours: Reservations changes to handle new business; pricing, air inventory, guaranteed inventory.
• Reservations' Agents Bonus Program: Allowed teams to be formed, progress measured, and incentives to be determined.

Confidential

System Engineer

Responsibilities:

• Automation of Equal Access, and San Antonio conversion. First time remote record update/retrieval used via DDMF.

Confidential

Senior Computer Operator

Responsibilities:

• Trained new operators, created training and procedures manual, did job scheduling, job monitoring, restarts, etc. (Hardware: Tandem VLX, HP3000)
• Responsible for job scheduling, monitoring, restarts, backups, etc.