SUMMARY

• He has extensive experience in development of Browser based ERP software connected to back - end SQL servers or DB2 based applications, which include Financials (GL, AP, AR, FA, CA, CM), Order to Cash ( OE, AR ), Procure to Pay ( PO, AP ), Inventory Management, Human Resources, Payroll, Time and Attendance (Kronos), Distribution, Property Management, Construction and Manufacturing .
• Development of in-house business application using HTML5, BootStrap, AJAX, JavaScript, jQuery, CSS, CGI and DB2.
• Conversion of JDE GL, AP, AR, and PO data from Infinium files with supporting command and control files
• Converted Employee Master, Benefits, Payroll and 401K -contribution information to JDE OneWorld XE
• Develop/Customize various JDE programs using JDE OneWorld XE files with supporting command and control files
• Converted JDE Construction Accounting data (percentage rent, CAM, etc) into Infinium Purchasing
• Customization of Order Entry to AR Cash Receipts (Order to Cash) process to Auto-Match based on historical data
• Modification of Purchasing to AP ( Procure to Pay ) for multi-currency cash distribution based on FASB accounting rules
• Enhancement of General Ledger by "related cost-center" aggregation for Business Intelligence ( BI ) Financial Reporting
• Enhancement of Warehouse Management system by integrating NT based workflow management software
• Customization of Shop Floor Management by integrating NT based workflow management software
• Enhanced Best Route Distribution Path processing using least used route index
• Automated Plant Equipment Management system with foreign Fixed Assets application

TECHNICAL SKILLS

• SDLC ( System Development Life Cycle ) Model, Prototyping s Rapid Application Development (RAD) and Component Assembly Model s Service Oriented Architecture ( SOA ), IBM Rational ClearQuest experienced Software
• HTML5, BootStrap, JavaScript, jQuery, CSS, AJAX, DB2, MS-SQL server, vb:ASP, .NET, XML, JSON
• MQ Series, JDE Financials, Solomon, Oracle Interface, WDSC(WebSphere), Visual Studio 2008, Prism, Kronos,
• Infinium Suite (Financials, Human Resources), E3 Trim, JDA, Robot, mPlus, SharePoint
• AWS (Automated Warehouse System), MacPac XE (Manufacturing, Distribution, Resource Planning, Cost/Job Mgmt)
• MS Project, Adobe Products (Photoshop, Flash, DreamWeaver), SecureCheck, AccPac, ADO
• Varsity, Brio, BPCS, MAPICS, ODS, HTE, EDI translators, Visual InterDev
• Implementer, Aldon, DBU, Hawkeye, TurnOver, Quadrant, QuestView, etc.
• HTML5, BootStrap, JavaScript, jQuery, CSS, AJAX, DB2, MS-SQL server, vb:ASP, .NET, XML, JSON s RPGle (free), SQL:RPGle, Clle, Store Procedures & Functions, Triggers, API, MI, Rexx, PL/I
• ASP, vb:A, vb.Net, Brio, C, db2:SQL, Flash, dHTML, CSS, vFoxPro, dBase(xx) s XML, XSLT, XBRL, ASP.net, HTML5, CGI, java:javaScript, jQuery, vb:Script, vb:Access Hardware
• IBM i5 eServer iSeries, AS/400 and System/38, Windows Platforms, ES9000, 370, 3090, 4300 series s DEC VAX/PDP, DataGeneral Eclips, Wang VS, HP 9000, PRIME Information System s Intel Pentium & 80x86, z80 CPM/MPM, Routers, Firewalls, MUXes, Patch Panels, HUBS

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Sr. Consultant - Project Manager

Responsibilities:

• Development of Management CRM Dashboard using HTML5, CGI, JavaScript, jQuery, AJAX to DB2 database
• Project management of Profound Logic's Application Modernization Suite on iSeries platform
• Maintenance of in-house developed Environmental Compliance CGI based software using Stored Procedures
• Confidential Positive Pay project
• PC Scale weigh tag application enhancement project
• Various external system data conversion projects

Confidential, Irvine, CA

Sr. Consultant - Project Lead

Responsibilities:

• Development using RPGfree ( procedures, modules, service programs and binders ) via PDM and Web Sphere
• Production support of MacPac XE ( Manufacturing, Distribution & Finance ) modules
• Enhance data interfaces to/from Materials Management MacPac module to Resource Planning
• Several projects to enhance the Automated Warehouse Systems ( AWS ) to interact with MacPac XE
• Troubleshoot Oracle Data Interface, Preferred Partnership Program and Customer Return System
• Worked with Implementer change management system and Microsoft Sharepoint application
• In-house developed Inventory Management and Just in Time supply Management applications

Confidential, Irvine, CA

Sr. Consultant - Project Lead

Responsibilities:

• Development Data Warehouse programs and procedures using SQLRPGfree
• Creation of Browser Based Dashboard application via CGI interface using DB2 SQL backend on i5 platform
• Designed and Implemented Key Performance Index application for Mobis America division
• Troubleshoot and maintain Warranty system applications

Confidential, Corona, CA

Sr. Consultant - Project Lead

Responsibilities:

• Supporting JD Edwards v7.3 Financials, Manufacturing, Distribution, Supply Chain and Process Engineering
• Development of AS/400 front-end web applications using CGI with JDE back-end database.
• Acom EDI/XML maintenance & integration to the JDE ERP package via SQL & XML
• Project lead for the Material Return Obligations project.

Confidential, Canoga Park, CA

Sr. Consultant

Responsibilities:

• Interfaced and Supported JDE OneWorld XE Financial and HR suite, E3 Trim, JDA and Infinium PL & Purchasing.
• E3 Trim, Supply Chain, Automotive Aftermarket industry Logistics & Distribution Experience on AS/400 .
• Using AS/400 WebSphere MQ, using RPGle, developed XML document interface for IMC customers.
• Developed using RPGle, AAIA standard XML interfaces for the AS/400 to accept Amazon Web orders.
• Converted EDI (8xx FIN docs) using RPGle to XML documents via AS2 server for gCommerce VAN provider.
• Analyzed, designed & developed IntraNet Web Application to serve various purchasing and sales activities.
• Analyzed, designed & developed ( RPGle ) RF based Merchandise Return System using hand-held scanners.
• Created an industry unique Cascading Price Group application for the automotive parts customers.
• Enhanced and maintained E3 Trim, Inventory Management System (price factoring, pick-ticketing).
• Augmented & maintained in-house created automotive parts warehousing & distribution software.
• Migrated from a legacy line printer check processing to the " SecureChecks " MICR laser system on AS/400 .