SUMMARY

• Over twenty years of experience developing business applications using the Confidential I platform, (AS/400, Power 9).
• This development experience involves the use of RPG (III,IV,ILE), and COBOL to maintain and develop legacy systems and software products like Infor XA.
• I have acquired this experience from different companies, including insurance, manufacturing, and distribution.
• In addition, I have also gained valuable business knowledge from these types of business environments.
• It is my goal to continue working as an IT professional to help reach the business objectives for the company I work for and to continue my in new technology tools and business applications to improve business processes.

TECHNICAL SKILLS

Languages: RPGIII, RPGIV, RPGILE, CL, SQL/400, STORED PROCEDURES, SQL TRIGGERS programs, COBOL

Software: TFS, Infor XA (Mapics XA), SN2000, MAC - PAC, EDI Premenos/Harbinger, Hawkeye, MKS Implementer, Aldon Change Management/Community Management, Microsoft Office suite, Visio, ALM Quality Center

Utilities: RDi, PDM, SEU, SDA, DDS, QRY, DFU, DBU, RLU, IFS, AS/400 security, FTP, Navigator, Client Access.

Hardware: Confidential System i(Power 9)

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

Sr. Programmer Analyst

Responsibilities:

• Under Agile structure (3 weeks sprints) perform my duties developing software solutions to improve business processes.
• Analyze business requirements to deliver the best software enhancements.
• Collaborate with Agile team members (QA, BA, Developers, others) to complete all committed PBI stories.
• Meet/maintain communication with Business Analysts and other business resources to clarify/obtain additional information to deliver proper solution.
• Maintain existing business applications (mortgage, insurance, and financials).
• Prepare unit testing documentation.
• Prepare release document containing detail of code to be deployed.
• Submit enhancements to QA team.
• Maintain communication with QA team to clarify test results.
• Use System i platform to develop or maintain code.
• Use of SQL stored procedures, SQL Triggers, CL, COBOL, Aldon change management tool.

Confidential, San Antonio, TX

Developer

Responsibilities:

• Provide application development support using the AS/400 platform to SWBC customers in the mortgage industry. Once ticket is assigned by IT manager process begins with analysis of issue reported by Business Analyst. If necessary contact Business analyst for additional information. Set up test environment to replicate defect reported by Business analyst to find the root cause. Perform code changes (COBOL) to correct defect. Execute unit testing. Validate enhancements and document results. Include documentation as part of ticket. Broad knowledge of the AS/400 platform, strong analytical and troubleshooting skills. Strong communication skills at all levels of the business.

Confidential

IT Consultant

Responsibilities:

• Responsible for the analysis, design, coding and maintenance of software application and processes for distribution and manufacturing operations for software packages and legacy systems on the iSeries (AS/400).
• Strong knowledge of business applications that includes accounts receivables, accounts payable, fixed assets, budgeting, cost accounting, and payroll.
• Responsible for the maintenance and creation of new applications using the RPGIII, RPGIV, RPGILE, CL, QUERY/400 and SQL400. This work also included work involving the system utilities SDA, PDM and RLU.
• Developed a benefit package copy utility application for a medical insurance provider to copy benefit packages from one environment to another environment. This allowed them to copy several benefit packages in just few minutes avoiding days entering data manually. This application was written using COBOL, CLP, and SQL scripts interacting with Power MHS database.
• Developed and implement vendor withholding tax to keep control of invoice amount subject to withholding for government purposes.
• Developed and implemented state and city sale tax withholding to keep control of the tax amount that needs to be paid to the government periodically by city.
• Provide support to implement unattended backup system procedure.
• Provide support to manage data stored in S/36 environment definition within the AS/400.
• Modify payroll legacy system to allow special payroll deductions to be discounted from the employee’s wages and keep correct YTD balance of the deduction.
• Participate as a project coordinator in the implementation of data feeds from SAP HR module to Infinium HR module software. My role included to meet with end users to gather all necessary information to prepare user test scripts. Explain to users how to execute scripts and how to record each step to be tested. Collect all results from scripts and meet with developers to discuss it and assign incident to correct steps that failed and prepare new set of scripts to re-test. Create test environments. Meet with developers every day to follow up on pending tasks and determine if additional resources and require to comply with due dates. Participate on weekly project status conference call meetings with Confidential PMO.

Confidential

Sr. Systems Analyst

Responsibilities:

• Confidential, Confidential is a company plant dedicated to manufacture concentrate liquids for their worldwide products like Pepsi, Diet Pepsi, MT Dew, and Sierra Mist among others. This plant also manufactures salts for their Gatorade line of products. This concentrate plant was considered the benchmark for all other PepsiCo plants in the world.
• Responsible for the maintenance and creation of new applications using the RPGII, RPGIII, RPGIV, RPGILE, CL, QUERY/400 and SQL400. This work also included work involving the system utilities SDA, PDM and RLU.
• Responsibilities included all functions of Mapics XA, including user definition, Cross Application functions, assign user security, assign user menu options, PTF apply, data collection, and day to day issues with end users.
• Responsible to perform major upgrade from Mapics XA R5 (Infor XA R5) to Mapics XA R7 (Infor XA R7). Include all aspects of a project this big and important for the business. From creating project plan, meeting with business users, creating Mapics XA environments to apply latest PTF’s to perform unit testing, user testing, communicate results to management, and getting signoff from the business to perform all steps to go live.
• Responsible to perform major upgrade from Mapics DB software to Mapics XA R5 (Infor XA R5). Include all aspects of a project this big and important for the business. From creating project plan, meeting with business users, creating Mapics XA environments to apply latest PTF’s to perform unit testing, user testing, communicate results to management, and getting signoff from the business to perform all steps to go live.
• Developed a custom application to load distribution requirements into the system and create customer orders within the Mapics XA COM module automatically. These orders were then loaded into our MRP system to be considered for material purchase.
• Developed a custom application to automated material picking from warehouse locations using RF hand held devices (Intermec, LXE). This application gave the material picker to opportunity to deliver materials from the warehouse directly to a production room using all manufacturing orders for that particular production date. All transaction created using the RF hand held devices were recorded into Mapics XA to have full visibility where the inventory is and to which order was used.
• Created interfaces to maintain material planning application (cAvail) with real Mapics XA data. Connectivity to the AS/400 and to the server running the cAvail applications was using scheduled FTP scripts. Also on demand option was available for the user.
• Implement data feeds from Mapics XA accounting management to Oracle financials, Hyperion financials and Cognos. Automated process using FTP scripts.
• Implement the Automated Export Systems which reports all our shipments going to the US in an electronic filing method host to host similar to EDI. This application was developed to collect data from our shipments system to send data using a proprietary data format from US Customs and Border Patrol which consists of a header record, detail lines, and trailer record. This process was similar to an ASN EDI transaction.
• Implement the use of a tool called Spool Flex to convert AS400 spool file reports to electronic format like PDF and excel.
• Sarbanes Oxley process owner for change management and SDLC. Maintain control of SOX guidelines in terms of documentation required for any software/process change. Run quarterly test scripts and submit to local and corporate management.
• Responsible to provide all necessary data feeds to transfer line of products to a new producing location as part of a global business initiative called GCS. This includes BOM data, customer orders, planning and forecast data.

Confidential

Contract programmer analyst

Responsibilities:

• Provide IT support for a manufacturing plant.
• Maintain legacy business applications (A/R, A/P, G/L, P/R, H/R, Inventory, logistics) running on a system 36 and an AS400. Coded using RPGII, RPGIII, and RPG/400 based on business needs.
• Role included system design, system analysis, and application development.
• Participate in business meetings to replace legacy system with MAC-PAC ERP software.
• EDI data mapping using Premenos/Harbinger application. Used to send/receive 850, 810, 855, and 856.
• Develop business applications to allow the user to enter data with validation to eliminate entry errors.
• Automate manually processes to improve business performance.
• Prepare unit testing documentation.
• Prepare UAT documentation.
• User .
• User documentation.
• Application documentation (process flow, table definitions, deployment, rollback steps).