SUMMARY:

• With 28 years of experience in several roles in the IT field, I have successfully demonstrated my ability to contribute to full SDLC in IBM ISeries platforms, enabling the business to efficiently carry out service deliveries and to produce better solutions and outcomes. For 16 years, I have also worked in various consulting roles, serving businesses in retailing, distribution, manufacturing, entertainment, health care, mortgage banking, as well as in automotive sales and warranty.
• Over twenty eight years of programming on IBM AS400 ISeries with both interactive and batch programming in RPGLE/Free Form,CL,SDA/DDS,SQL/Imbedded SQL, Store procedure, DB2,client access, and all other AS400 utilities tools.
• Experienced in ERP conversions such as: BPICS distribution warehouse system consolidation and interfacing, JD AS400/Edwards One world conversion, AS400/Oracle conversion and implementation, Data warehouse conversion, SAP exposure and conversion, banking loan processing system processing, Island Pacific Retail application maintenance. Manufacture application Mapics XA, Infinium financial application support, EDI TrustedLink transition creation, and many in - house grown applications.
• Involved in some web front-end, Net, C#, AS and Java J2EE web developing interface with front-end web HTML/JavaScript, and back-end AS400 interfacing and processing. Developed AS400 Store Procedures and Trigger Program.
• Involved in Client/Server file transfer, AS400 iDB2 Data provider, MS IBM host integrator, ODBC connections, SQL server
• Experienced in wireless hand-held RF Autosoft warehouse application on IBM RS6000 AIX UNIX and Lunix Knowledge of UNIX operating system.
• Starting exposure, self study of Bigdata, Hadoop, AWS technology

TECHNICAL SKILLS:

System Analysis Skills: Complex problem solving, analysis and resolutions User and/or business requirement functional and technical design creation for business and enterprise level systems Software testing preparations, execution, reporting, and full cycle system testing. Analyzing applications. Researching and trouble - shooting user business problems, suggesting solutions, and resolving issues. End user development demonstration and

Development tools: VPN remote and on call support. AS400 Turnover, Implementer, Aldan, version control and Hawkeye Pathfinder utility. EDI TrustedLink Visual Studio, SQL reporting server various proprietary tools.

PROFESSIONAL EXPERIENCE:

Confidential

Home and mortgage Insurance Company, consultant

Responsibilities:

• Analyzing business rules, define, design and create permanent and work files. Programming, testing and communicating with users for variety reports and online programs. Come up with best solutions to creating the new reporting system, for current and future use.
• Use RPGLE, SQLs. Automated Upload and download files and generate IFS files in network system.
• Testing, post implementation user problem troubleshooting and supports. Suggested, design and created new maintenance programs for daily and year end. Suggested and documented for IT department future .

Confidential

Concrete servicing Company, consultant

Responsibilities:

• Developed new interface to third party ERP system via AS400 IFS,
• Worked on AS400 ISeries RPGLE programming
• Exposure and interface third party Java to AS400 for xls files. Communicate with division director and managers to demonstrate new projects.
• Support user equipment management, dispatch job payrolls, research and resolve issues. Provided some system, third party software evaluations, design and administration.

Confidential

Automotive warranty, consultant

Responsibilities:

• Analyze current BPICS in-house programs and data for warehouse distribution, modify or create for production systems.
• Programming in AS400 RPGLE, SQL.
• Worked on EDI ASN consolidation program. Heavy current system program analysis, design, create and implementation.

Confidential

Automotive warranty, consultant

Responsibilities:

• Supported business users through all analyses, meetings, daily user support throughout the entire life cycle of the project.
• Communicated with outside IT business vendor for web interface, troubleshooting and support.
• Supported .net C# team for front end interface and Siebel system reporting.

Confidential

Distribution, consultant

Responsibilities:

• Developed new AS400 RPG application to JDE one world interface.
• Worked in fast paced lifecycle of analysis, coding, testing, implementation and post implementation support.
• Involved in all user meetings, design, and heavy daily testing with JD Edwards one world.

Confidential

Mortgage Loan, consultant

Responsibilities:

• Used AS400/RPGLE, free form RPG procedure and service program, store procedures, SQL, Turnover.
• Performed performance analysis, and used multi-threading and proper file indexes.
• Interfaced with .net C# front end application.
• Provide application system analysis and documentation.
• Worked with Analyst, QA, LOB, MQ through full project life cycle process, including Maximo incident approval process.

Confidential

Industry Parts, Consultant

Responsibilities:

• Involved in full SDLC development both online and batch programming including free form, procedure calls, embedded SQL, and commitment control.
• Developed functional and technical specifications, test scripts and implementation documentation. Involved in user meetings, discussion, testing, and after implementation support. SAP implementation exposure and interface.

Confidential

Mortgage Loan, Consultant

Responsibilities:

• Used AS400/RPGLE, procedure, service program, SQL, and multithreading job process. Developed store procedures calls and Java J2EE interface.
• Provided application system analysis and documentation.
• Coordinated with various teams and provided offshore support. Used Turnover source control.

Confidential

Dealership Sales Marketing, Consultant

Responsibilities:

• Programmed using Free form, imbedded SQL, Procedure Prototype binding with interactive programs and batch application.
• Participated in all phases of the project, including business analysis and project application design up to user testing.
• Worked on .Net C# interface to online Dealer Sales application, AS400 data provider, Store procedure calls. Used Visual Studio Involved in Webservice. Developed Store procedures to interface to DB2 AS400.

Confidential

Mortgage Loan, Consultant

Responsibilities:

• Program on AS400 RPGLE, store procedures interfacing with Dot.Net front-end. RPGLE free forms. Main person developing for the AS400 back end process for the team. Involved in all user design discussions, developing, unit and integration testing
• Worked on some existing Dot .Net C# maintenance projects in MS VS2005 and VS2003. Developed Dot net. Screen, add, and change backend AS400, update and repost back to front-end.

Confidential

Dealership Sales Marketing, Consultant

Responsibilities:

• Programmed using Free form, imbedded SQL, Procedure Prototype binding, Service program with interactive programs and batch application.
• Interfaced to a variety of Web online application, distributing the reports from AS400 to Web. Create XML for Vendor application.
• Involved in some .NET C# project to interface and support third party web Sales Marketing application.

Confidential

Health care, accounting, Consultant

Responsibilities:

• Programmed using Free formed RPGLE to interface with Valutech Mainframe application with huge transactions. Including full development life cycle with analysis, user discussions.
• Provided documentation, coding, testing, implementation and post-production support for a big project. Communicated with users and other technical teams to get the best outcome.
• Interfaced with the bank and Provider/Client Claims printing services.
• Performed Visio representation of business and technical process workflow to the user and other technical teams.
• Provided analysis and process Company Provider 1099 for year 2004.
• Worked on HTML. Folder file to display AS400 reports on intranet.
• Worked on FTPs, Procedure calls, batch, reports, online programming. Using SQL, MKS implementer, and Robot Scheduling analyze and improve operating efficiency by coding multiple processes at the same time for jobs
• Troubleshoot and fix the user testing and post implementation problems.

Confidential

Distribution and Manufacturing, Consultant

Responsibilities:

• Programmed using Free formed RPGLE for a RMA function Oracle interface using embedded SQL
• Work includes full development life cycle with current system analysis, technical user discussions. Documentation, coding. Heavy unit and integrated testing, and post-production support for the big project.
• Performs program specification, flow charts, test plans, unit and system test.
• Worked on various modules such as MACPAC credit Memo, invoice, purchase order, pricing, Inventory programs analysis and programming interface with WebMethods, Broad Vision, Siebel interface, Oracle PL/SQL, forms and reports/Discovery, and MS SQL Server and VB application.

Confidential

Retail and distribution, Consultant

Responsibilities:

• Programmed using RPGLE to interface with VMI system and EDI PO transmission, to automate PO processing. Embedded SQL with both batch and online programs.
• Created AS400 receiving worksheet report on web intranet through IFS file system.
• Extracted business data from AS 400 and interfaced with Unix based RETEK warehouse management system.
• Worked online and batch program for allocation and inventory balancing between two systems.
• Analyzed current system for an optimum programming plan to implement pre-package functionality; documented and evaluated the current system program, and submitted an in-depth project proposal for the million dollar major system modification.

Confidential

Home loan, consultant

Responsibilities:

• Worked on development of a new loan servicing system and interfaces for UK mortgage banks.
• Programmed Free Form RPGLE/RPGLE/RPGIV batch and online, journaling, trigger and commitment controls. Programmed embedded SQL for reports.
• Used Turnover version control.
• Participated in all team projects including project development, testing and production support life cycle.
• Involved in MQ/MQSI XML messaging data transmission.
• Exposure and interface to Java J2EE development, JSP, JDBC, IBM Java WebSphere and interface with GOS loan origination.
• Experienced using internal data conversion tools.

Confidential

Part time Consultant

Responsibilities:

• Programmed using Free formed RPGLE/RPGLE. Provided Mapics XA application support
• Used AS400/InternetWeb auto entry data to create AS400 interface to trigger and update Mapics application.
• Automated Web order to auto pick/pack, ship and auto invoice.
• Created Auto inventory backflash/bill of material order input.
• Used VB, Visual Studio.NET, and ASP applications to interface with AS400.
• Used CRM software interfacing.
• Provided proof of concepts with Java, AS400 and JSP.

Confidential

Retail, Distribution, Consultant

Responsibilities:

• Programmed RPGLE on AS400 on online, batch, and RPGLE procedure programs.
• Supported Mozart Internet Web order and Catalog mail order programs.
• Supported Island Pacific retail applications.
• Programmed POS data transfers.
• Developed AS400, Prestige Payroll, and STR POS time hours interfacing programs.
• Used DB400 ODBC to Access database.

Confidential

Online Startup, Off hour/Part Time Consultant

Responsibilities:

• Programmed RPGLE on AS400 to support IP applications with retail clients. Interfaced and posted Journals IP to JD Edwards.
• Started Java programming, AS400 interface and API development using Eclipse.

Confidential

Consultant, Developer

Responsibilities:

• Develop loan Origination front end, and service backend Loan servicing package. From user information screen validation, updates and important loan amount calculations.
• Programmed RPG400/RPGLE, embedded SQL interactive subfiles/batch on AS400.
• Provided hands on programming and created Internet application in HTML/Java, CGI on AS400.
• Supported front end/backend Loan servicing package and dealership warranty system.
• Used IBM Client Access, Lotus Notes/Dominos Client Server software.
• Involved or exposure in SAP ERP implementation, ABAP programming.
• Develop proto-typing of Java demonstration.

Confidential

Retail, Distribution, Sales, Senior Programmer Analyst

Responsibilities:

• Supported Island Pacific Retail package.
• Programmed RPG400/RPGLE interactive subfile/batch and performed SQL programming.
• Supported multi-country retailing/distribution application.
• Sent by company twice to Disney UK, England twice for programming support.
• Worked on AS400/RS6000 PCS warehouse application interface projects.
• Used Rumba Client Server software.
• Exposure to SAP/ABAP4 initiative testing implementation.

Confidential

International Retail and distribution, Senior Programmer Analyst

Responsibilities:

• Programmed RPGLE on IBM AS400 in retail environment on RPG400/RPGLE.
• Supported GL/AP/AR for accounting for end user using Software 2000 GL, Computer Associate AP.
• Worked on POS data transfers.
• Support for AS400 evening problem on-call/dial-in
• Programmed on SQL.
• Converted and supported RS6000 AIX Unix wireless handheld RF Autosoft/Noran warehouse distribution system.
• Involved in Monarch/Intermix bar code AS400 interfacing.
• Used Netsoft Client/Server for AS400/PC interfacing.
• Supported nationwide remote location users.

Confidential

Manufacture, Programmer Analyst

Responsibilities:

• Programmed on IBM AS400, RPGIII/400.
• Supported PC users.
• Performed AS400 conversation.
• Wrote AS400-PC ADP payroll transmission interface program.
• Provided in-transit warehouse distribution package interfacing.

Confidential

Trading, Sale Manager

Responsibilities:

• Worked as manager for l trading Co
• Worked in import and export business.
• Product management, QA, shipping and sales.

Confidential

System Coordinator

Responsibilities:

• Performed IBM VM system maintenance and VM user support on IBM 3080/3090s.
• Configured system.