Design and implement end-to-end applications for Supply Chain Management.

• Implement business logic and process through stored procedures, packages, and triggers in the Oracle 10g database with SQL and PL/SQL.• Create and customize Oracle Forms and Reports for the Oracle E-Business Suite(11i) system, under Order Management, Purchasing, Inventory, Pricing, Receivables, Payables, General Ledger, and others modules.• Set up and maintain EDI VAN/AS2/FTP communications(850/855/856/810/832/846/867) with external systems such as Amazon Vendor Central and Commerce Hub, using IBM Gentran Integration Suite 4, Oracle e-Commerce Gateway, and custom PL/SQL packages.• Develop and maintain ViewSonic online store by customizing iStore JSP pages and create custom credit card fraud detection and automatic order hold process with customized Workflows. • Create PL/SQL and Java API wrappers for Oracle Shipping to interact with carrier systems such as FedEx Ship Manager Server, FedEx Web Service, and UPS WorldShip.• Enable data integration between Oracle EBS and Salesforce.com using SOAP and REST API.• Integrate Magento eCommerce platform with Oracle Order Management, Inventory, iPayment, and Vertex.• Enable Oracle Shipping/Receiving integration with Motorola MC-series barcode scanners by creating an ncurses-like UI using Python, urwid, and cx_Oracle on a CentOS terminal server.• Develop BI Publisher and Optio reports to facilitate barcode printing, dynamic signatures, and setup Bursting for targeted e-mail distribution.• Create custom Java POI and streaming based program to extend concurrent request output distribution functionalities that allow for very large datasets and multiple worksheets.• Create data upload and conversion programs using Web ADI, SQL*Loader, and Unix shell scripts.• Develop REST Services to expose Oracle EBS functionalities using Jersey and Tomcat.• Upgrade Vertex Sales Tax Q-series integration with Oracle Receivables from version 2 to 3.4.

• Implemented business logic and process through stored procedures, packages, and triggers in Oracle 8i/9i database with SQL and PL/SQL.• Created and customized Oracle Forms and Reports for the Oracle E-Business Suite(11i) system, under Order Management, Purchasing, Inventory, Advanced Pricing, Receivables, Payables, and others modules• Participated in all phases from implementation to testing of EBS upgrade from 11.5.7 to 11.5.10.2.• Extended ERP functionalities by building custom applications with Oracle public APIs, Form Personalization, and CUSTOM.PLL; as well as facilitating data export/import with SQL Loader, interface tables, and Unix shell scripting.• Set up and maintained EDI communications such as 830/856/810 through Oracle E-Commerce Gateway and Sterling Commerce Gentran Server 4, as well as developing solutions for outsourced EDI vendor GCommerce using flat-file FTP. • Participated in the design, implementation, and maintenance of the customized Oracle iSupplier and iReceivables portals under Oracle Application Framework with jDeveloper 9i.• Built and administered Oracle Discoverer 4i End User Layer, Business Areas, and Workbooks.• Created label printing programs to print out pallet and shipping labels using Zebra barcode printers.• Developed different concurrent request output distribution methods through print, e-mail, and fax by using XML Publisher, Bursting, Create!form, Create!stream fax, RightFax, and custom Java programs. • Created and maintained company intranet using ASP/JSP, IIS/Tomcat, and MySQL database.• Debugged and optimized existing programs using TKPROF and SQL trace to isolate and identify bugs and improve execution performance.• Helped maintain and troubleshoot desktop PCs, Windows 2000 server, and HP-UX Unix server.• Participated in the company ISO 9001:2000 certification processes as the Assistant Management Representative, Internal Auditor, and ISO Document Administrator.