SUMMARY

• Software Engineer with Expertise in IBM AS/400 RPG Programming Language
• Expertise at developing interactive user interfaces and batch applications.
• Collaborate well on teams and independently with minimal supervision.
• Focused and results driven, with excellent strategic, analytical, communication and problem - solving abilities.
• Problem-solver, providing data-driven recommendations to complex issues.
• Application Developer | Systems Analyst | Software Engineer
• Expertise in developing Interactive User Interfaces and Batch applications.
• Engineer/Re-Engineer Software applications in an IBM AS/400 environment.
• Develop Software in ILE RPG, Free RPG, DB2/SQL, Embedded SQL, RDP.
• Deploy ILE programs and service programs as web services based on the SOAP(XML) protocol using integrated web server for IBM i. Deploy ILE programs and service programs as RESTful(JSON) web services.
• Extensive experience as an Application Developer, Senior Systems Analyst, Software Engineer
• Skilled in analysis, design, development, testing, implementation, and support of various applications
• AWS and Azure in-house training at Royal Caribbean Cruises.Utilize tool available in new Cloud technology.
• Developed ILE modules, Service Programs with embedded SQL and send/receive data from external servers for various Booking Engines here at RCCL, using WebSphere MQ queues utilizing Pointers in RPG, Prototyping, Service programs, Activation Groups.

TECHNICAL SKILLS

• Free ILE RPG
• DB2 SQL
• Embedded SQL
• RDP
• Pointers
• Prototyping
• Service programs
• Identity and Access Management (IAM);
• Okta
• OIM / OID
• LDAP SSO (SAML
• Oauth) and Active Directory
• ServiceNow
• Tableau
• Salesforce
• Jira and Confluence

PROFESSIONAL EXPERIENCE

Confidential, Miramar, Florida

Software Engineer

Responsibilities:

• Most recently, I have been working on Engineering/Re-Engineering various Backend applications on AS/400 that capture data from various Frontend WEB applications. Most business rules are on Backend AS/400 and several Web applications feed data to Backend AS/400 via WebSphere and other methods. We parse that data and put it in relational database tables in DB2/400 and Microsoft SQL servers.
• Wrote applications using ILE RPG with Embedded SQL for back-end Air and Cruise reservation. RCCL uses Confidential and Sabre for Air reservations.
• Recent training in AWS and Azure. Many tools in use now
• Business logic for web applications is on AS/400 which communicates with Front End applications via WebSphere MQs. These applications are written in Java on an AIX platform. I work on Backend AS/400 in RPG. We do all business logic processing for Air and Cruise reservation requests coming from all Web applications and send back the data.
• Wrote, maintained International/Domestic Guest Document system (gathers data from multiple databases and prints all travel documents (Air, Sea and Shore excursions) for passengers in a travel booklet in PDF from Microsoft SQL servers; wrote some stored procedures on SQL Server.
• Several other Web applications are developed in different Operating/Programming environments to sell Cruise, Air and other products. I developed software on AS/400 to process Web data and send back the response to those web applications.
• There are several interfaces to send data to Accounting applications, such as, JD Edwards and others. Develop interfaces to Accounting in ILE.
• Developed, maintained and provided support for multiple applications in AS/400 ILE RPG, RPG Free and SQL
• Data resides in DB2, Microsoft SQL servers, Oracle database, Cassandra and Siebel and requires looking into data using POSTMAN APIs, IBM IWS Web Services, Oracle SQL and MS SQL. Provide support for Guest Account using all these Tools.
• Lead a task force to convert RPG to ILE RPG. Utilized many ILE functions and most DB2/SQL functions to reduce actual size of code.

Confidential, Northbrook, Illinois

Application Programmer Analyst

Responsibilities:

• Programmer Analyst in an AS/400, Windows/NT and AIX 7.0 environment for Travel Agency back office systems. Developed/maintained applications on AS/400 and client/server environment, was involved in parsing Air passengers PNR (Passenger Name Record) data for Confidential and Sabre Global Distribution Systems.
• Developed external interfaces to/from AS/400. Developed applications on both AS/400 and PCs. Data from AS/400 fed to SQL server 7.0 running business intelligence reports application and web serving.
• Developed reports using report writer SEQUEL for a custom automatic Report Saver Scheduler system. Re-engineered entire report scheduler on AS/400 to run and distribute reports.
• Re-engineered Passenger Travel Booklet (PTB) system for our client Confidential Lines that printed over 10,000 booklets per day and provided support for it. They used both RPG and COBOL. So I coded in both.
• Developed programs to extract data from AS/400 and wrote FTP batch processor to send the extracted data to remote FTP server over the Internet for travel agency back office system to be fed to MS SQL server 7.0 and to be used in ASP web pages.
• Provided On-Site technical support to a client ( Confidential in Northbrook, Illinois for one full year. It was a SABRE shop that bought Global MAX that ran on Confidential . Trained users, operations, programmers to use AS/400 as well as MAX application. Provided all kinds of support to user and technical staff as they migrate from other systems (Unix Hardware and software of HP3000) to MAX and AS/400.
• At Confidential, installed CA/400 with ODBC driver on several PCs for users so they could access AS/400 data using ODBC compliant applications. Developed custom ILE RPG/400 programs for Credit Card reconciliation, Account/Receivable and Account/Payable and maintaining database and operation. Worked with other programmers to develop a Report Writer on AS/400 in ILE RPG/400, wrote special purpose programs to print pre-paid tickets and charge forms.
• Worked on the financial applications module of the Global MAX project and globalized domestic systems. Globalized to use multiple currencies and languages. All Air data coming from Confidential and Sabre reservations