• Being the technical and functional lead on supporting Oracle EBS (12.2.5 ) Accounts Payables, Accounts receivables, Project Billing and Project Costing, General Ledger, EBTax , HR and Timecard modules for 100+ ledgers via extensive Functional Knowledges of those modules and PL/SQL Packages, Procedures, Functions, Oracle Form (10g) and Report (10g) and BI Publisher.• Participating the below projects:New ledger Setup: Setup 10+ New Business Unit, General Ledger, AP/AR/Project/EBTax SetupAPTRECK: Interface with outsourced AP Invoices system via Outbound and Inbound interfacesIntercompany: Added fifth segment to accounting structure to handle the intercompany transactions.Jasper Report Creation: Created 20+ Jasper Reports from the scratch and integrated with E-Business via Java Concurrent programs.ARCITIXML: Based on Citi bank xml file to automate receipt creation.• Coordinating and Mentoring new Off-Shore team.

• Being the technical lead on collecting user requirements, designing, developing and maintaining Cash in Transit application, a full custom extension in Oracle EBS (11.5.10.2, 12.2), which fully integrated with Oracle Financials and interfaces with Eight ancillary systems via PL/SQL Packages, Procedures, Functions, Oracle Form (6i, 10g) and Report (6i, 10g). The below are few example projects: Stabilizing PDA; ATM Control System; Four week route scheduling; Ortech route optimization; R12 upgrade• Working on 4 TB Oracle database and very complex packages (7,000 or 8,000 lines code in one package is common), bulk collect, reference cursor, dynamic sql are often used, performance tuning is almost like the daily task.• Leading the project to build the CIT data warehouse in SQL Server via PL/SQL packages, Microsoft SSIS to extract, transform data from Oracle and load to SQL Server 2012.• Being the functional and technical lead to build all reports from the scratch for 3rd party enterprise application Track and Trace, mainly responsible for writing views and procedures for business logics in SQL Server 2012. • Being the secondary support for Oracle Financials on AR/AP/GL/Service Contract/Advanced Price and month end procedures.

On site Loomis, see above

• reviewing functional design, creating the technical specifications, developing code, unit and integration testing, and user acceptance testing in eBusiness 11.5.10.2(Accounts Receivable, Order Management, Inventory, Shipping, Advanced Price, System Administrator, Accounts Payable, General Ledger, Service Contract and HRMS)• Designing and implementing BI Publisher documents in eBusiness: Pick Slip, Pack Slip, Quote and Consolidated Billing Invoice. • Designing and Implementing Interfaces for external applications in eBusiness, e.g. customer, item validation and Order Import API etc.• Implemented and Maintained Khamelon Financial System Mainly supported Accounts Payable, Project Accounting, Order Entry, Accounts Receivable Modules.(Oracle 8i and developer 2000)• In charge of Performance Tuning of Khamelon Financial System for two months.• Designed and implemented Expense and Contract System interfaced with Khameleon AP module. used Oracle Form 6i, Oracle Report6i and Oracle 8i database.• Redesigned and implemented ProPlan Budget system Interfaced with Oracle HRMS, used Oracle Form 6i, Oracle Report6i and Oracle 8i database.• Designed and Implemented checking Retest Violators for CPAt ProgramUsing C, ProC on Unix, triggers and stored procedures in Oracle8I and Oracle Form 6i. • Maintained PlanEOS, RPS Web application Using Java, Oracle 8i

• In charge of web timecard/project administration application rolling out• Administrating and programming SQL Server 7.0 for 13 accounting and human resources databases• Maintaining Solomon Accounting and FLX: Visual HR Human Resource Packages Supporting General Ledger, Accounts Payable, Accounts Receivable, Project Controller• Developing Reports with Crystal Reports 7, 6, 5 and FRx: Financial Reporting Extenders

• Was a project manager of 12 projects of auditing and asset appraising in manufacturing and real estate industry• Participated more than 20 auditing and asset appraising projects