• Analyze the GPO rate modules and creating the documentation to explain how this process works and once finished, start the project to modify the process creating an audit table with the GPO rates that will not be paid and the reason, The purpose of this is the company can easily find the cases in which they are not paid in case of a claim by the customer without the need for an audit.
• Created a module in sqlrpgle and a service program with the procedures to extract the records with GPO rates that will not be paid and the reason these are recorded in the mentioned table.
• Determine in the actual process and where to incorporate the procedures created; trace it and test the process.
• Analysis and modification of the code to improve the performance of the process described above. Did the implementation to production.

• 7.3
• Development new programs like interface an account payables interface to the HSBC bank of Canada, modify Hazardous materials application, create and excel report for the shipping department reporting these materials, create a DDL tables for different applications, debug and fix warehouse, inventory and distribution modules, development parts price discount module. Work with the ERP package COMERGE, did the directories and extract form and to iSeries NetClient file system (QNTC), work with IFS, Support application’s development in Strategi software package, work with the Agile & Scrum methodology environment, expertise in services programs, prototypes, binding directories, support and prioritize production tickets. Training less experience programmer in tools like eclipse RDI (IBM Rational Developer for i), IBM iAccess, DDL, SQL, data base development, Iseries Navigator and MDCMS, Rally, CA Agile Central (Rally).
• Production support activities for all types of priority tickets.
• Did a setup of the iSeries security project to be with the audit compliance.
• Do the applications to warehouse upload and download bin location using excels reports with STRATEGI web package and email it to the users.
• Do the service program and function’s (prototypes) to processing special price discounts for parts.
• Do a service program to call the UPS web services and received the XML response for rates by zone, weight, size and parcel price.
• Create User Define Functions in SQL
• Mapping using embedded SQL and UDF the EDI segments 850 Purchase Order & 855 Purchase Order Acknowledgment, send those to the John Deere network via QNTC

• Programming using IBM Rational Development for I (RDI) in conjunction with Turnover as well the new free format RPG using the SQL IBM new approach no I/O specs and DDL tables.
• Use IBM X-Analysis for cross-references, documentation, data model extraction and impact analysis for RPG, interactive structure chart diagrams and data flow, objects where used, applications area diagrams, interactive source code browse, documentation, extract business rules and relational data models, automated conversion of DDS to DDL, including creation of constraints, long field names and views.
• Re-engineering the line cards and services order system converting the DDS tables to DDL and eliminated in the RPG programs the traditional RPG I/O’s to using sequel and create services programs to retrieve the table’s information.
• Did a conversion of Verizon data system and integration to Frontier DPI ERP system in the iSeries.
• Did a conversion of ATT data system and integration to Frontier DPI ERP system in the iSeries.
• Understanding the business requirements and prepare the technical specs.
• Developing of Batch, Interactive, Service programs, Modules, procedures, prototypes for various Applications.
• Prioritize and solution production issues and tickets for the system users.
• Production support activities for all types of priority tickets.
• Interaction with business users for requirement clarification and resolution of incidents reported.
• Providing Status reports as needed.
• Create SQL Store Procedures to transfer information to other systems.

• Test the programs to ensure that they function according to the program specifications.
• Debugging interactive and batch processing of modules and programs.
• Assist developers with less experience in the process of creating code to use the SQL techniques.
• Assist less experience programmer in the new Free Format RPG coding for iSeries.
• Assist less experience programmer to use the Rational Development for iSeries.
• Resolve production tickets assigned by Remedy software.
• Research and do the interface to the Google API web service to get the latitude and longitude base in the customer address and parse the returned xml, I use the HTTP server in the iSeries, this save to the company $700,000.00 at year.
• I create SQL procedures to get and return information to the programs applications also do some store procedures to call RPG programs who return some information necessary to the system applications like get terminals address for the equipment’s offices for telecom.
• Use the iSeries Navigator to create and debug store procedures and functions, create tables, schemas, scrips and verify the performance, using the explain to access the index advisor for create necessaries indexes, etc.

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

• Understanding the business requirements and prepare the technical specs.
• Developing of Batch, Interactive, Service programs, Modules, procedures, prototypes for various Applications.
• Prioritize and solution production issues and tickets for the system users.
• Production support activities for all types of priority tickets.
• Interaction with business users for requirement clarification and resolution of incidents reported.
• Providing Status reports as needed.
• Development the National Pricing system and interface to the SQL server front end.
• Development Conversion engine to handle conversion programs.
• Development programs to mapping data to unify two ERP's packages in one unique system.
• Developing of Batch, Interactive, Service programs, Modules, procedures for various Applications A/R, AP, GL, Inventory, Receiving, Pricing, etc.
• Development invoices and pickups interface from the ERP core package to the handheld system called Velocitor.
• Development interfaces from the inventory and warehouse package to Manhattan WMI and implementation.

• Test the programs to ensure that they function according to the program specifications.

• Debugging interactive and batch processing of modules and programs.
• Advise developers with less experience in the process of creating code to use the best techniques.
• Assist less experience programmer in the new Free Format RPG coding for iSeries V7R2.
• Assist less experience programmer to use the Rational Development for iSeries.
• Use the SLDC (Life Cycle Development) researching, designing, developing, testing (unit and system, benched market, regression, stress and load); deployed, documented, trained and supported implementation of relational database (RDBMS) architecture.
• Work in On-Call Rotation Team and 2nd level Escalation for Critical issues.

• * Program Documentation * Create and maintain technical documentation necessary for program maintenance defined by Project Manager.

• * Management Analysis * Perform management analysis through routine monitoring and actual system operation. Perform additional tasks as assigned by the Project Manager.