IT Business Application Manager and ERP Architect with 10+ years in Oracle ERP - E-Business Suites and related business applications
Long Time oracle ERP Consultant, Leader and Architect
oCumulated 10+ years of solid hands-on experiences in oracle ERP E-Business Suites and Business Applications as a consultant, architect or manager.
oCompleted type of projects including but not limited implementation, upgrade, gap filling extension, full functional customization development, platform switching.
oServed as SME in EBS, modules from Order to Cash, Procure to Pay, Manufacturing, Supply Chain/Planning, Financials, PLM, Reporting/BI, Enterprise System Architectures/Platform Landscape and Data Processing Automation Solutions.
oBrought the solutions to business customers through business requirements analysis, architectural design, presentation and collaboration, functional design and spec writing, technical design and development, functional testing and UAT as well as DBA tasks.
oProvided full scale of consulting services to business customers with effective collaboration with executive managers and steak lders to provide solutions for their business system needs and data process needs, no matter they are unique or common, small or big, all to their satisfaction.
oDefined and executed projects as well established and mentored project teams for projects.
?Service Project Management custom module: As a consultant, lead a consulting development team, developed a solution for customer to fill the gap between the oracle ERP modules to manage their service business sectors which was a significant portion of their business. The system acted as a collaboration center starting from taking the service orders from OM then went through planning, milestone management, resource reservation, then reaching the full Service GL. Based on full analysis of the business requirements and fully mapped ERP functionalities, this custom module assured a complete success for the ERP implementation project. I lead analysis and did design, even put hands-on development work on few critical objects. The custom module seamlessly integrated with OM, AR, AP, BOM, INV, PO, GL and GL.
?EBS based Analytics and BI system: As a consultant, designed and developed an Analytics/BI system for customer reporting requirement. The system covered full oracle ERP system with all the modules implemented – Net-Booking, Billing, Backlog, Inventory, OM, AR, AP, GL, PO, WIP, BOM, Cost, Reserve etc. It served reporting needs for executive dashboard, statutory reporting, FP&A, performance KPI monitoring, operational management and transactional reporting in every business segment and function. Visualized with Hyperion Reporting Tool or OBIEE.
?Customer Delinquency Management system: As a consultant, designed and developed a Delinquency Management solution to fill the gap of ERP functionalities. It was a fully integrated custom module with oracle ERP system for handling multi-million customers’ delinquency condition and generating daily delinquency status report along with cash flow status and revenue forecast report. It was the most important KPI that the management was looking after.
?Implementation/Upgrade Projects: Participated in multiple oracle ERP implementation projects as a SME for modules and tracks to setup and configure the modules such as OM, INV, AR, AP, GL, MRP, ASCP, Pricing, Tax, QA, etc. As well as a solution provider to provide solutions to fill the gap such as Passport Sales Marketing project, On-line Credit Check, On-line Payment Transaction, Clear To Build in MRP, etc. Implementation was not just a typical default configuration and setup, rather to set oracle ERP to fit customer’s business requirement and special needs. Examples like Supply Chain Hub operating unit, Bar-Code with License Plate and UPC code witut WM, EDI with third party data broker, etc.
?Platform Switching Project: As a consultant, provided analysis and solution plan to customer management team in the process of determination on either further upgrade IBM system or change the system to UNIX based oracle system. The oracle new technology was adopted and the customer claimed a full success on this platform switching project after a most high visible and critical system was successfully re-designed and developed on oracle platform. I was the one that designed the solution and lead a team of developers mixed half consultants and half employees to implement the solution and changed customer’s data processing platform from IBM mainframe to oracle database centered platform once for all.
MS, Physics, Western Illinois University, Macomb, IL, US