SUMMARY:

• Experience in the area of Information Technology as a Architect, Developer, Designer, Analyst, and Leader.
• Involved in all phases of project life cycle from Systems Analysis, Design & Development through Testing and Implementation.
• Extensive experience in RPGILE, RPG II - IV, CLP, DSPF, CLLE, Modules, Stored Procedures, Service programs, DB2 SQL & Embedded SQL, Free Form RPGILE,
• Software Architect/Developer on the i5/OS using RPG IV ILE. Methodologies include specializing in the relational data base design and full program life cycle development for various business models. Modular design approach includes using ILE service programs and Binding by .
• Develop and deploy DB2 SQL back-end procedures and functions on the iSeries. Create vb.NET and T-SQL procedures to work as a front-end applicant for the Series using OLE and .net iSeries providers.
• Worked independently as a system data base administrator using the change management tool TurnOver. Responsibility include providing solution for the program development department with DB2/400 related issues pertaining to Journaling, COMMIT, ROLLBACK, audit trail, DDM, Trigger, Data Dictionary, LF/PF, Normalization and join files.
• In addition to IBM i5/OS software development I have extensive experience working as a web developer and e-commerce strategist for small business in the Houston demographic area. The web programming involves using open source tools such as PHP5, MySQL and Apache.

SKILL:

Language/skills implemented: RPG IV ILE, embedded-SQL, CL, Query 400, ILE Service/Module, T-SQL, VB6, JDBC, Java, PHP, XML

Data Base Management / Tools: DB2 SQL, MySql, SQL Server, Access

Program and Change Management Tools and EDI: WDSC, RDi, Data Studio, Access Client Solutions (ACS) Client Access, Hawkeye, eSend, ROBOT, DBU, NetBeans 7.1, Eclipse, Turnover and Aldon, BMC Remedy, Agile, Sharepoint, NDM, ZMODFTP

ERP: Accounting Plus, PRISM, MAPICS/Infor XA

PROFESSIONAL EXPERIENCE:

Confidential, Addison, Texas

Software Developer

Responsibilities:

• Software support escrow department related to impound account statements for Insurance & Tax using service and module programs stored procedures and functions developed as both RPGILE and SQL based applications for .net web services for Countrywide mortgage & loans.

Confidential, Plano, Texas

IBMi RPG IV ILE Software Developer

Responsibilities:

• Software Architect supporting backend service applications using services programs stored procedures and functions developed as both RPGILE and SQL based applications for .net web services for Countrywide mortgage & loans.
• EDI and FTP feed applications for various business partners.
• DB2/400 Data mapping
• Develop programs using RPG Free, Embedded SQL and CLLE

Confidential

IBMi RPG IV ILE Software Developer

Responsibilities:

• Participate in business requirements meetings and analyze the requirements and gain good knowledge f the application from both technical and business perspectives.
• Prepare technical specifications documents and mapping documents to help development Participate in test planning meetings and arrive at test strategy to create test cases and scenarios from requirements.
• Involve in the development of the detailed test plan and test cases for system testing,Integration testing and regression testing.
• Co-ordinate with users to create test cases for UAT.
• Executed test cases/scenarios, documented results and generated reports.
• Analyze and troubleshoot the defects to isolate the likely cause of the problem
• Develop programs using RPG Free, Embedded SQL and CLLE Develop reports using WRKQRY or write SQL queries to verify the data

Confidential, Houston, Texas

IBMi RPG IV ILE Software Developer

Responsibilities:

• Research sFTP, FTP, ODBC and mapping on each VISTA asset.
• Feed Analysis for the Interlock asset feed/data requirements
• Implement sFTP and FTP scripts with modifications to RPGLE & CLLE source as required to support separation.
• Interlocking Asset
• Research Interlocking assets split strategy
• Identify and deploy source modification as required for each Interlocking asset
• Base Utilities and assets used
• Robot IBM - based job scheduler.
• HP WebTools SFTP Webtools utility used to research data feeds on HP Service Bus (HPSB)
• Turnover IBM-based Program Management Tool
• HP ALM (Application Life Cycle Management)

Confidential, Houston, Texas

Software Developer

Responsibilities:

• Responsible for custom RPGILE development for ERP manufacturing package Infor XA (MAPICS).
• Design and Developed the following packages to integrate to Infor XA using RPGILE, CLLE and embedded SQL
• Design and Developed Cloud based applications based on the RESTful architecture using PHP, HTML5 and Java.
• The process involved developing PHP applications to handle GET, PUT and POST request using cURL resources.
• The applications provide update process between COUPA purchase order / invoice system and MAPICS residing on IBM i, AS400. PHP, XML and JDBC was used to complete the update request on the AS400 database.
• Develop procedures to communicate between SQL Server and iSeries DB2 tables.
• This process involved posting and reporting manufacturing orders generated from MAPICS and transferred to the SQL Server for logging. Currently working on web base inquiry for order status residing on the SQL Server.