SUMMARY

• A challenging, growth oriented technical lead or software developer position, on the AS400/IBM iSeries/IBM Power System using RPG, COBOL, SQL, SYNON 2/E, COOL 2/E or a newer technology, where I can apply my technical, analytical and organizational skills.
• Wholesale A/C, HVAC, and Pharmaceutical Distribution, Aviation, FINRA Brokerage, Trucking, Retail (office, furniture), Tours (cruise, and land tours), Telephony, Computer Operations
• Wholesale Distribution, Order Entry, Pricing/Contracts, Discounts/Vendor Rebates,
• Invoicing, Statements, Supply Chain, Purchasing, Warehouse (counts, picking, inventory, receiving), Retail (office, furniture), Sales/Bonus/Commissions, Payroll/Benefits, Vehicle Maintenance, Warranty, Billing, Address Validation, Customer Maintenance/Match, Viking J2EE/Java (Address Pools, Phone Scripts, Sales History), Reservations (Cruise/Tours/Air/Ground), Finance (Accounting (A/P), Accounts Receivable (A/R), Forecasting, Standard Cost, Revenue Recognition, Deposits), Equal Access, System Utilities (DASD, Scans, Query, File Rebuilds)

TECHNICAL SKILLS

PLATFORM - AS400/iSeries: /IBM Power System

SOFTWARE/LANGUAGES: RPG Free, RPG TR7, RPG ILE, RPGLE, RPG IV, RPG III, RPG II, SQL COBOL DB2 SYNON 2/E, COOL 2/E DDL CLP

AS400/iSeries: UTILITIES - Rational (RDI), SEU, SDA, DSPFs, DDS, QUERY, QRY/400, QMQRY, OPS Navigator, Client Access, DDMF, FAX/400

CODING METHODOLOGY: FTP, IFS, service programs/sub procedures/modules, online/batch programs, embedded/interactive SQL, stored procs, DTAQs, DDMFs, QCMDEXC, flat files, RJE, Agile, Waterfall

OTHER: Hawkeye, Robot Scheduler, Aldon CMI, Aldon LMI, Turnover, Crystal Reports, Lawson A/P, Lawson G/L, Microsoft Office, Excel, Word, Group1

SOFT SKILLS: use of system development life cycle (SDLC) - gather requirements, business analysis, documentation, coding, testing (unit, and user), implementation. User and vendor liaison, team player

LIMITED EXPERIENCE: Profound Logic, SQL Server & C#/ADO.NET, JWalk, J2EE Web Development using Websphere Application Development Studio (WSAD), Java, JSP, Servlets, SQL, HTML, Struts, JavaScript, XML

Hardware: Tandem VLX, HP3000

PROFESSIONAL EXPERIENCE

Senior Programmer Analyst

Confidential, BEAch, FLorida

Responsibilities:

• Order Entry Supersedes - Incorporate auto recommendations for old items vs. new items based on inventory level of each
• Billtrust Invoice Generation - Modify in-house invoice printing to include COD customers, and invoices previously excluded. Interface with vendor to finalize requirements for COD invoices, and SOWs.
• Claims - Expand Claim Number in DB files, modify programs as needed
• Customer Deposits - gather data/develop interface 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.

CONSULTANT

Confidential, WESTOn, FLorida

Responsibilities:

• Price Change Reason Code - Project manager (PM), Business Analyst (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 object impact analysis, QA, and Development
• Price Override - System wide field/object impact analysis
• Customer Licensing, Dispensed Data, and Questionnaire screen maintenance
• Developed program to interface from RPG to Java (un-funded)
• Developed Automated FTP application (un-funded)

Senior programmer analyst 01

Confidential, fort lauderdale, FLORIDA

Responsibilities:

• Sales Comparison by Category - created spreadsheet of sales comparisons for current and previous periods, and years
• Safety Management System - gathered, and documented requirements
• ACH Confirmation - integrated an ACH reminder in payroll, and A/P
• 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

Senior programmer analyst

Confidential, PALM Beach Gardens, FLORIDA

Responsibilities:

• Main Commissions programmer, used SDLC 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 2013 – 176 days
• Pershing Pricing Markups: Major system enhancement, determine impact to 500 members,230 were modified or new.
• Revenue Coding: Provided method for Accounting, and Commissions to reconcile, and code all receipts by various criteria, included screens, reports, data exports.
• DASD Utilization and Reorg Tool – 10% savings achieved
• SSN Masking: Mass system analysis/code changes
• Websmart: Preliminary tool analysis, modified SQL code to determine response time effect with date concatenation changes.

CONSULTANT

Confidential, Miami, FLORIDA

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 in-house programs to create a solution which mimicked IBM/400 Query, but allowed use of Ryder database structure of sites/numerous iSeries boxes. Added security, an audit trail, and ease of use.
• Invoice Extract and Purge: Replaced dynamic SQL cursors which reduced run time from 18 hours to 1.5 hours for 35000 invoices.
• DASD & Reorg process: Improved process. Saved 75 gig.
• Short Term Warranty: Analysis/Requirements of Parts Disposition, etc.
• Electronic Preventative Mnt (PM) Follow Ups: Added duplicate task functionality & federal/state PM edits throughout SMO & PM Follow Ups application. (on-hold)
• PM Yield Mgmt: Designed/constructed functionality to edit activation of PM tasks using a percentage of days/miles intervals.
• iWarranty: Provided support/backup/analysis for project manager for the SOW; RCRC feed, parts price master feeds, obtaining warranty data on SPOs.

Confidential, DelRay Beach, FlORIDA

J2EE Web Development

Responsibilities:

• Viking Address Verification Pool in JMillenia, used by CSRs: Developed application which displayed records, navigated to other pages, allowed addresses/order(s) to be approved/rejected, and notified of address/phone changes at approval time. Interacted with the 400 via stored procs, DB2/SQL, or DTAQ.
• Viking Outbound Pool in JMILLENNIA: Added phone scripting functionality, Scripting data was retrieved from the AS/400 via embedded DB2/SQL in Java.
• Developed the Sales History Screen.

AS400 / iSeries Development

Confidential (CCDW)

Responsibilities:

• Responsible for Address Validation modules using Group 1, integration into existing systems, made common modules, maintenance, and upgrades. Implemented Canada, participated in vendor selection process for new Web Service based Address Validation software.
• Developed/maintained various Customer applications/projects (Viking Integration, initial Contract Mgmt/Pricing implementation, Customer Setup, MBS Billing from the AS/400 to the mainframe, numerous Downloads/Uploads, etc.)

Intermediate Systems Analyst

Confidential, Boca Raton, FLORIDA

Responsibilities:

• Clearance Prices: Technical lead. Project determined the next recommended price for skus based on length of time since price change, available quantity, rate of sale, etc. Users could override, accept, or remove the recommendation, which was subsequently 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.
• Warehouse and Inventory: Involved in team analysis and re-design to use a real-time system and RF scanners Created numerous screens using SYNON/COOL 2/E related to the following applications (note: project was un-funded).
• Receiving, Change of Inventory Location, Pick & Receiving Lists, Warehouse Pick Activity, Customer on Order Fulfillment, Pick Efficiencies
• Migration from General Electric (GE) Finance to Household Finance Corporation (HFC): Designed, and wrote programs which created flat files for GE. 1st time use of RJE, which sent Settlement data to HFC, and received their response.
• Numerous improvements; Central repository of raw data, duplicate record detection, data capture, and screens for users to maintain the data.
• 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

Project Lead

Confidential, Fort Lauderdale, FLORIDA

Responsibilities:

• 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
• Interface/Collection of Reservations data: Developed systems to automate/allow a direct reconciliation from Reservations to Accounting.
• Standard Costing: Developed table driven modules to calculate yield, and capture itemized revenues and expenses from the 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
• Fax/400: Implemented for Reservations invoices. Included overlays, status reports, status updates to bookings, and retry logic.
• Reservations Front End re-design: Assimilated Database (DB), and defined relationships in SYNON 2/E Data Model.
• 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.