SUMMARY OF QUALIFICATIONS:

• An insider of Oracle ERP (E-Business Suites) and its tools, Great Plains and Banking Software (from installation, business concept design/functional implementation, customization for reports and batch processes to patch application, database maintenance and function supports for all modules)
• Solid experiences in logical and physical designing, developing, maintaining and tuning databases and Data Warehouses for Oracle (7.3/8.0/8i/9i/10g), MS SQL (7.0, 2000,2005), and DB2 (Common Server and UDB 5.0/6.0/7.0), Oracle ERP (Oracle Financial Applications 11.5.5-11.5.10.2) under Unix/Linux/Windows/AIX
• Strong experiences in ERWIN, PL/SQL, ETL, ASM, Oracle Application Server Configurations, Adadmin, Adctrl and Adpatch, Web Development(ASP and JSP), XML,PERL/K-shell scripts, C and Java
• Solid knowledge and skills in banking and accounting application:
• Financial statement analysis and modeling
• Performance measurement
• Risk management (Interest Rate risk, Credit Risk and Market Risk)
• Assets / Liabilities Management
• Portfolio evaluation
• Hedge Fund
• Stock, futures and options pricing
• Excellent abilities to analyze, evaluate and solve business problems with optimized solutions

EXPERIENCES:

09/2000-Present Lead Senior ERP Architect/DBA
Morningstar, Chicago

• Customizes and develop forms, extensions, and interfaces as needed to support business requirements
• Convert Great Plains, JD Edward and People Soft of purchased companies in US, Europe and Australia into Oracle EBS
• Leads the development and maintenance of integrated business process & application roadmaps with focus on the ERP strategy in and around the enterprise. Advises on the effective use of information management methodologies/technologies and supports any needed changes in order to leverage information products, services, methods, and technologies
• Supports front-end users (accountants and financial analysts) to do user daily and month-end close operation and technical function trouble shootings
• Proposes, plans and initiates IT projects and solutions, in conjunction with various business units. Maintains existing application portfolio for scalability, reliability, performance and maintainability
• Implement, maintain and support Oracle Financial Applications(GL, AR, AP, FA, CE and Service Contracts) and Human Resource Systems (11i.5.6 and 11.5.10.2) under multiple organizations and multiple currencies
• Maintain and support ADP Payroll systems and Gupta Database (Computer Associate Database Engine)
• Evaluate user business requests, gather business requirements, analyze, design and develop application solutions to meet the business and front-end users requirements
• Maintain an support Great Plains (Microsoft ERP) and its databases (MS SQL 2000, 2005)
• Modify the setups and configuration of existing oracle ESB modules to enhance the functional and technical solutions and implement new oracle ESB modules
• Install Oracle 8i, 9i and 10g database software; Install and configure11i Oracle Financial Applications (General Ledger, Cash Management, Fixed Assets, Receivables, Payables, and Service Contracts modules) (11.5.5) base, upgrade Oracle Financial Applications to 11.5.6 and to 11.5.7 by applying patches using Oracle Apps DBA tools—adpatch, adadmin and adpatch
• Logical and physical design and develop Customer Relationship Management (CRM) for internet payment, fulfillment and data mining under Oracle 9i; Develop packages and stored procedures to process online subscriptions, online payment, auto-batch renew customers’ subscriptions, auto-batch payment, book sale, book cancel refund, recognize revenues on transaction, product and GL levels
• Clone Oracle 8i, 9i/10g databases for oracle 11i.5.10.2 ERP and HR test and development environments
• Develop scripts to backup, recover and clone Oracle (8i and 9i) Databases and Oracle Financial Applications
• Design and implement Oracle 10g RAC Databases and Data MART for Hedge Fund Research
• Install, develop and maintain customized Oracle 10g RAC databases for large investment firms
• Create Standby oracle 9i and 10g RAC databases for 11.5.10.2 ERP for DR
• Upgrade Oracle Financials and HR from 11.5.6 to 11.5.10.2
• Design and develop databases (MS SQL Server 2000, 2005 and oracle 9i) and data warehouses (Oracle 9i) for large institute clients’ mutual fund and equity portfolio simulation and optimization
• Design and develop data warehouses (oracle 8i, 9i and MS SQL 2000, 2005 ) for Mutual Funds, Equity and Separate Account Research
• Maintain and support Equity-Edge (E-trade stock options system) and Database (Oracle 8i)
• Model, design and develop a large scale web based Morningstar Mutual Funds (Open End, Close End, Variable Annuities, ETF, and Separate Accounts) and Stocks Distributed Web databases for users to query and research on mutual funds and stocks, and to do portfolio research and asset management
• Develop scripts and stored procedures to auto-load and backup OLTP and OLAP under MS SQL 7.0, 2000,2005 databases

09/96 – 09/2000 Chief Financial Application Architect
Confidential

• Work with bank CFOs and Controllers to do overall business analysis, solution design, and functional architecture activities to plan banking ERP implementations
• Oversees and guides implementation of proposed solutions for banks; communicate and coordinate between clients and functional / technical teams; Reviews all applications development and configuration project requests, coordinates schedules and related departmental activities
• Defines system integration and acceptance testing process and ensures adequate resources; Works with business units, marketing and sales teams in decision making process to ensure effective cross-functional decisions and implementation plans
• Design and develop bank marketing data warehouses for banks’ data mining
• Design and develop market risk, interest rate risk and credit risk management systems for banks to model and hedge its risks using tools such as interest rate swaps and credit derivatives (Total Return Swaps)
• Manage and maintain more than 200 databases and data warehouses under Oracle 7.3, Oracle 8, MS SQL 6.5, MS SQL 7.0, DB2 2.1 and DB2 5.0
• Model more than 110 banks’ data to develop Assets/Liabilities Management implementation and customization guidelines using ERWIN
• Design and implement logically and physically more than 110 large scale databases for banks and financial institutions, including hardware configuration, RAID disk space management, capacity planning, partitioning tables and indexes
• Develop stored procedures to auto batch data transfer
• Redesign activity based cost allocation to simplify implementation procedures and improve the performance
• Design account, product and customer level profitability reports requested by Canadian and British banks
• Analyze and diagnose internal and external databases’ performance issues and running errors
• Redesign transfer pricing methods and tune SQL statements to improve the performance
• Perform business and competitive analysis
• Design assets/liabilities management, risk management, performance measurement business concepts and prototype models
• Redesign cost allocation and add new features for banks to allocate cost based on budget and abilities to trace the allocated amount for each step
• Model customers’ data, design and create databases, and implement user interface and integration with customers’ other products
• Develop product definitions and functional specifications for banking software
• Design and prepare banking performance measurement demonstration data for testing and sales

9/94- 8/96 Financial Analyst and Database Administrator
Confidential, Chicago, IL

• Review financial statements to analyze companies\' operating performance and efficiency, liquidity and capital resources, to assess credit history and investment risk, and to evaluate stock prices based on assets, dividends, free cash flow and earnings (including residual income) models
• Develop futures & options pricing models and trade volume allocation programs
• Develop application programs to review and forecast VaR and risk management performances
• Develop 30 year bond futures, ten year notes futures, S & P 500 index futures and options, Eurodollar futures, and OEX futures financial models
• Design and implement a database under DB2 to store trading data and customer information to allow remote customers to query their trading information
• Monitor and analyze Oracle and DB2 activities, diagnose performance problems and tune Oracle and DB2 databases memory, IO and SQL
• Develop scripts to backup Oracle and DB2 databases and to automate databases startup and shutdown; Monitor databases’ alert files, log files, tablespaces, rollback segments, database availability, manage oracle redo logs, data files, control files and archived log files

10/91-8/94 Research Assistant
Confidential, Chicago, IL

• Develop mathematical model of pressure effect on isotope fractionation to simulate oxygen isotope fractionation between various phases under mantle and ultra-high experimental condition utilizing C++ under UNIX
• Design and implement databases for processing experimental data under Oracle/UNIX
• Develop programs for theoretical quantum physics computation and numerical analysis using C++ and FORTRAN under UNIX, PC and MAC

EDUCATION:
MS in Accounting
MS in Physical Sciences
MS in Applied Mathematics,
BS in Computer Sciences