Skills

OS/*** RDMS, DDS, DDL, RPGII, RPGIII, RPGIV, ILE, RPG Free Format and SQL, Embedment SQL, Interactive SQL, IBM X-Analysis, INavigator, FTP, DDM, EDI, RPG Web services, Parsing XML and Json with SQL functions, UDF, DBU, Triggers, Hawkeye, Access Client Solutions, DB2, CLLE, SDA, RDI, Subfiles, others too many to mention.

User Define Functions in SQL.

Binding Directories, Service Programs, Triggers, Procedures, etc.

Rational Development Tools.

SAP Integration

ALDON, Turnover, MDCMS and Implementer for AS/400 change management systems.

Agile and Scrum Methodology; Waterfall Methodology.

Others too many to mention.

Professional Experience

Medtronic. Hospital Equipment Manufacturers

Mansfield, MA

Sr Programmer/Analyst IBM iSeries RPG-SQL

September 04, 2018 to Present.

Analyzed a proprietary Group Purchasing Organization system (GPO). This system paid commissions using a complex set of rules. Modified and documented the process to create and maintain audit tables for disputed orders. This allowed the Company to follow claims from customers and reason for claim more efficiently.

Modified the code to improve the performance of the process described above. Did the implementation to production.

Work in other project to reengineering the actual modules in the iSeries to transfer the information to SAP system.

Create sql DDL tables, joins, triggers, stores procedures, service programs, procedures and modernize the old RPG code to free format RPG with embedded sql, etc.

Create RPG Web services to extract customers commissions.

Parsing Json tables using SQL functions.

John Deere.

Milan, Illinois

Sr Programmer/Analyst IBM iSeries RPG-SQL

July 10, 2017 to August 29, 2018.

Developed new applications such as account payables bank interfaces like HSBC bank of Canada

Modified the Hazardous materials application and create Excel reports for the shipping department.

Created DDL tables for different applications.

Developed a service program for UPS Web Services to obtain rates by zone, weight, size and parcel price.

Do the service program and function’s (prototypes) to processing special price discounts for parts.

Parsing XML tables.

Frontier Communications.

Richardson, TX

Sr Programmer/Analyst IBM iSeries RPG-SQL

Mar 2015 to June 30, 2017.

Developed application to interface and migrate ATT’s and Verizon’s data to Frontier’s databases.

Using Google location web services, developed an application to pinpoint customers’ addresses with exact coordinates. This application saved the company over $700,000 a year by failed service calls caused by incorrect location address.

Conversion of DDS to DDL, including creation of constraints, long field names and views, joins, etc.

Eliminated in the RPG programs the traditional RPG I/O’s to using sequel and create services programs to retrieve the table’s information.

Southern Wine & Spirits.

Miramar, FL.

Sr Programmer/Analyst IBM iSeries RPG-SQL

Mar 2004 to August 2010; May 2012 to February 2015.

Introduced new programming techniques such as IBM Rational Development for I (RDI) in conjunction with Turnover as well as the new free format RPG.

Development the National Pricing system and interface to the SQL server front end.

Interaction with business users for requirements clarification and resolution of incidents reported.

Trained less experienced programmers in the new Free Format RPG coding for iSeries.

Worked in On-Call Rotation Team and 2nd level Escalation for Critical issues.

Development interfaces from the inventory and warehouse package to Manhattan WMI and implementation

Parlux Fragrances Inc.

Fort Lauderdale, FL

Sr Programmer/Analyst IBM iSeries RPG-SQL

February 2012 to April 2012.

• Development sales, item and customer interfaces from JDE World package to Manhattan WMS in RPG Free Format.

• Development services programs to facilitate the common business functions like dates conversion and others repetitive operation to facilitate actual and future development.

• Direct Interaction with the users and handles the daily issues or functionality with the warehouse and understanding the user requirement and assist them to solution the issues.

VAI.

NY.

Sr Programmer/Analyst IBM iSeries RPG-SQL

February 2011 to January 30, 2012.

Maintenance and modification Distribution and inventory custom package to different company clients this package include all the accounting modules, routing, inventory, POS in general is a custom ERP package.

Modify and create new modules accord to the client specifications.

Convergys.

Tamarac, FL

Sr Programmer/Analyst IBM iSeries RPG-SQL

September 2010 to January 2011.

• Major modifications of telephony, high volume data processing and cable software systems for the newest version.

• Change the package logic from house/resident to the client/account this will create unique way to trace the client across the system and not lose the information when they move from one place to other.

Management Dynamics Inc.

Secaucus, NJ

Sr Programmer/Analyst IBM iSeries RPG-SQL

Feb 2001 – Mar 2004

(Tariff and Contract management solutions for the ocean transportation industry)

Developed web-based solution that automates service contracts to eliminate invoice errors, improve productivity, build business intelligence and provide information services for carriers, NVOCCs and shippers.

Involved in the design, impact analysis for design change, development, implementation/delivery and maintenance and support of the automating of price rates and contract management solutions.

Wrote and roll out of the functionality to calculate accurate bottom-line charges prior to quoting or booking,

My worked helped improve operations and reduce costs for importers, exporters, transportation intermediaries, and carriers.

Interval International.

Miami, Fl.

Sr Programmer/Analyst IBM iSeries RPG-SQL

Dec 99 – Dec 2000

(Quality Vacation Exchange Network Timeshare travel exchange and membership services)

Developing new B2B ERP web front end AS/400 platform-oriented application software geared to 3rd party reservation system for resort developers.

Wrote Modules that included Sales and Marketing, Purchasing, Operational and Reservation and Worldwide Transfer exchange.

Ryder Integrated Logistics (JIT). Miami, Fl.

Sr Programmer/Analyst IBM iSeries RPG-SQL

Sept 98 – Dec 99

(Third party integrated logistics Software for Distribution, Warehousing and Transportation)

Developing (coded), deployed and supporting distribution, warehousing and transportation management systems solutions software.

Mercury/Rene Perez & Associates Air group.

Miami, Fl.

Sr Programmer/Analyst IBM iSeries RPG-SQL

Sept 93 – Sept 98

(Airline Automation Services, Rene Perez & Associates)

Designing, developing, deployment and supporting of logistical software and ERP for Airline Automation Services, a third party airline maintenance systems application software house.

Universal American Mortgage Corp. Miami, Fl.

Sr Programmer/Analyst IBM iSeries RPG-SQL

1992 – 1993

(Consumer Banking and Mortgage Loans Servicing)

Worked in the development, implementation and roll out of the integration of its consumer banking and mortgage loans servicing modules to the accounting systems, collection systems and mortgage insurance fulfillment.

Wrote and deployed data transfer mechanisms automating electronic data transmissions.

Evaluated, wrote and deployed application modules interfacing LSAMS 3rd party package

Budweiser Distribución. Miami, Fl.

IT Director/Sr Programmer Analyst iSeries RPG-SQL 1990 – 1992

(Conglomerate owner of Beverage Distributor and Automobile Dealerships: Miami Honda, Central Hyundai, and Sunshine Ford)

Maintaining and enhancing beverage distribution software package. Implemented ACS Automobile software for dealerships configured to communicate with two remote offices. I implemented, maintained and modified P.O.S. system for dealerships.

Decorama Desley. Miami, Fl.

IT Department Manager and Sr Programmer Analyst iSeries RPG-SQL 1987 – 1990

(Made-to-measure draperies and window treatments for the home furnishings industry Distributor and Manufacturer)

I worked on managing and developing its PRMS v8r4 package for manufacturing, distribution and financials/administration. Management included materials and finished product inventories, factory production control, sales, accounting information requirements. Management included the supervision of 5 programmers. I implemented EDI (Sterling software) to interface with JC Penny, Montgomery Ward and, Sears, and Bar-coding for Shipping Department.

Pioneer Metals, Inc. Miami, Fl.

MIS Department Manager 1985 – 1987

(Air Conditioning Wholesaler)

I managed the data entry department, and the data reporting operations of accounting, sales, distribution and inventory movement among the company's 14 warehouses.

Amfesco Duramil Industries Inc. Miami, Fl.

Programmer/Analyst - DP Manager 1983 – 1985

(Shoe Manufacturer)

I maintained and implemented new programs on the system IBM /34 for factory production control, supervised data processing department. I maintained its accounting software.

Florida Data Center. Miami, Fl.

Programmer/Analyst 1980 – 1982 (Medical Billing)

(Medical Billing)

COBOL Programmer/Analyst for Medicare and Medicaid claims processing, insurance claims processing, A/R, and account delinquency. MVS (mainframe).

Education

Bachelor’s degrees in Computer Science, Havana, Cuba, University of Havana.

EDI training, GE, Orlando, FL.

EDI Seminar, Sears Roebuck, Chicago, IL.

IBM AS/400 Technical Conferences, Orlando, FL.

IBM AS/400 Technical Conferences, Marco Island, FL.

IBM AS/400 - S/38 Technical Conference, Atlanta, GA.

System Administration of NetWare, CAD, Orlando, FL

IBM AS/400 Technical Conferences, Orlando, FL.

Asna Visual RPG, San Antonio, TX, 1998.

Java, University of Miami, Miami, FL., January 2000.

VB.Net, University of Miami, Miami, FL., March 2005.

ASP.Net, University of Miami, Miami, FL., July 2005.

Junior ABAP Programming.

Technical Skill set:

Mainframes: Honeywell Systems DPS6 & DPS7,

Midranges: IBM Sys/34, 36, 38, AS/400 and iSeries

Database:

DB2/400

Business References: Provided upon request.

Immigration Status..: US Citizen

Others…: Bilingual English/Spanish

Contact this candidate