OBJECTIVE:

A Challenging Position in Enterprise Resource Planning (ERP) Implementation and Support

SUMMARY:

• 18 years experiences in financial accounting/reporting, business process and consulting with Attorney and CPA licenses qualifications.
• 15 years experiences in Enterprise Resource Planning (ERP) systems implementation and support. 10+ years experiences in SAP S4 HANA and ECC 6.0 functional and technical implementation and support. 4 years experiences in Oracle EBS R12. X functional implementation and support.
• Excellent combination of in - depth business process knowledge, financial accounting background, legal expertise with strong ERP system technical and functional experiences and capabilities.
• Expertise in SAP Security architecture, ECC Security, FIORI Security, HANA DB Security, SAP GRC, Security Weaver, ERP Maestro etc. Expertise in audit and control process, remediations, and user access controls.
• Expertise in support and configurations of various SAP ECC and S4 Finance modules including GL, AR, AP, AA, Banking, Tax, Consolidation, TV, Treasury, CO, COPA, CO-PCA, IM etc. Expertise in support and configurations of various Oracle E-Business Suite R12 modules, including GL, FA, PA, AP, INV, PO, SLA, CM, AR etc.
• Expertise in Master Data Management, data structure design, data cleansing, data mapping and data conversion.
• In-depth hands-on expertise and knowledge in SAP Basis, HANA database and Fiori. In-depth knowledge of system integration, functional aspects, technical aspects and business processes. Highly fluent with SQL and in-depth knowledge of SAP and Oracle EBS tables and data structures
• Extremely self-motivated and strong trouble-shooting and problem-resolving capabilities. Substantial hands-on and management experiences for both functional and technical.

WORK EXPERIENCE:

IT Manager -- SAP Applications

Confidential, Houston, TX

Responsibilities:

• Lead and manage the IT team for SAP applications implementation project, including HANA Database, ECC 6.0 EHP7 with Simple Finance, SAP Gateway, SAP PI/PO, SAP BW, SAP BOBJ, SAP Data Services, BSI Tax Factory, Web Dispatcher, Solution Manger etc. Guide, design and build applications landscape technical requirements for infrastructure. Direct and oversee technical installations and implementations of the databases and applications.
• Analyze business process and requirement of implementation projects. Develop and lead business process designs primarily for SAP finance (simple finance, GL, AP, AR, FA, Banking, Treasury etc.) and Material Management (MM). Plan, manage, oversee and perform the functional configurations for all FI/CO modules, Travel expenses and Simple Finance.
• Manage, lead and perform master data conversion and governance for the implementation projects with a team of only 3 inexperienced members. Within a period of 3 months, successfully cleaned up, mapped and converted 3.7 million materials across 108 manufacture plants, 8.3 million material master changes, 4.5 million storage locations, 2,000 global employees in 22 countries and all related info types, 150,000 fix assets in 22 countries, 9,000 vendors, 6,000 customers and 500,000 Equipment Master for 3 full cycles in DEV, QA and Production systems. Was invited multiple times as guest speaker for ASUG conferences and presented as keynote speaker for Winshuttle 2017 annual conference.
• Perform technical analysis for SAP systems in production and non-production environments across a variety of platforms. Evaluate and identify the implementation gaps. Expediate design, build, test and deliver ECC securities with over 2000 single, derived and composite roles, across all ECC modules with full organization levels securities to completely meet business needs in 2 months with a team of only one additional resource. Develop profiles/roles with complex design restrictions. Coordinate comprehensive testing of authorizations to ensure accuracy. Lead and execute company-wide role maintenance and user administration.
• Design and Build the security roles for HR renewal and FIORI gateway which fully integrate with ECC security. Design, build and deliver complex FIORI and HR renewal roles with controls of menus, catalogs, tiles etc. Design and Build the integrated security and roles for HANA DB for BI solutions, including SAP BOBJ, Microsoft Power BI, Tableau Reporting and Lumira. Identify the security objects in HANA DB. Design, build, test and deliver the BI roles for HANA database involving various schemas, calculation views etc.
• Lead and perform all Finance configuration activities including Company code, Business area, Document control, Fiscal year maintenance, Field status Group, Finalization of Chart of Accounts, foreign currency, Tolerance groups for GL, GL Master, Park document, Hold document Recurring entries. Vendor master data configuration, Tolerance group, Automatic Payment Program, Invoice, Credit memo, Check management, Down payment, Integration with MM module, Customer master data configuration, Terms of payment, Open item management, Dunning, Invoice, Credit memo, down payment, Interest calculation, Integration with SD module, Asset master data, Organization structure, Chart of Depreciation, Depreciation area and key, linking with GL Valuation Methods, Depreciation key, Depreciation Run, asset acquisition, write-off, Cost element group, assignment of cost elements to group, Actual postings, Information System, Cost center hierarchy, Actual Postings, Periodic Reposting, Distribution, Assessment, and Information System, Order types, Creation, Expense booking, Status management, Settlement, Planning, Actual Postings, Year-end closing, Information System, Creation of Profit Center, Maintain automatic account assignment of revenue element, Choose additional B/S & P&L A/C Account groups. etc.
• Design SAP Service desk ticketing system using Service Now, define SLAs; manage the SAP service desk technicians; perform tickets and issues triage for go-live support; monitor, analyze and supervise the performances of the technicians.
• Identify and analyze the gaps. Plan, design and manage SAP upgrade project, including ECC upgrade to EHP8 with SF1605, HANA DB technical upgrade to 2.0 SP03, FIORI architecture re-design by merging front-end system with back-end system, 20+ more FIORI apps installation and implementation, PI/PO upgrades, ADS and Web Dispatcher Upgrades etc.
• Lead and manage the Basis team to rebuild the entire SAP development and quality landscapes for all SAP applications. Execute HANA DB upgrade to 2.0 SP03, upgrade ECC to EHP8 with SF1605. All other SAP applications upgrade to latest versions available. Manage development team for upgrade related tasks, provide guidance and oversea the performances.
• Install and configure 20+ FIORI apps with architecture changes by merging front-end server with back-end servers. Design, build, test and successful deliver related security roles for 20+ newly implemented apps, including menu, catalogs and tiles etc. Integrate the FIORI roles with other ECC security roles to achieve access control and process control requirements.
• Plan and manage the project timeline. Draft the functional and business testing plan with all business scenarios. Manage upgrade testing tasks for both functional team and business users. Organize and lead the testing meetings. Control change management process for break-fix.
• Lead FICO functional and business team for validation and testing. Perform trouble shooting and perform break fixes and re-testing. Provide guidance, to business users.
• Execute, manage and lead the overall go-live cutover process. Manage, lead and execute cutover activities for technical team. Manage functional team and post go-live support. Draft and plan various business and user communications.
• Manage and lead post go-liven hyper care and system stabilization.
• Research and evaluate S4 HANA implementation and conversion options. Study and understand S4 HANA implementation pre-requisites. Install SAP notes and execute S4 HANA readiness check for ECC Production System. Draft S4 HANA implementation plan.
• Manage the upgrade Solution Manager to 7.2. Install and implement SAP Solution Manager focus-build and focus-insight adds-on as preparation for S4 HANA implementation.
• Install S4 HANA Application as Green Field implementation proof of concept. Execute and complete base-line configurations for Simple Finance and Simple logistic, including General Ledger, Accounts Payable, Accounts Receivable, Asset Accounting, Electronic Bank Statement (EBS), Cost Center Accounting, Profit Center Accounting, & Internal Orders etc. Successfully Implement additional SAP Finance FIORI Apps.
• Perform system copy of ECC Production system and execute S4 HANA Brownfield Implementation (upgrade) as proof of concept. Lead and manage the technical team including basis, development and infrastructure. Successfully complete technical upgrade to S4 HANA.
• Re-design the material master structure, lead master data management team, clean and re-convert the master data according to the new design.
• Manage, lead, guide and supervise SAP technical team, including basis, security, ABAP development, FIORI deployment and development, interfaces including SAP PI/PO and master data management. Perform regular and periodical systems updates/upgrades, apply SAP support packs.
• Plan, design, manage, execute and implement SAP GRC, process control and access control. Lead and manage the server build and technical installations. Perform initial production system evaluations after installation and base-line setup for GRC.
• Review business needs and evaluate options for SOD software and tools. Perform technical installations for ERP Maestro, setup security roles for RFC calls, execute reports on ERP Maestro cloud and review the results. Perform technical installations for Security Weaver, setup corresponding security roles, execute reports using Security Weaver and review the results.
• Comply and deliver audit documentation and effectively completed security redesign for corporate compliance. Execute analysis, adjust user access assignment and re-design roles to remediate audit. Manage and lead the team to complete annual SAP license audit. Submit self-declaration and audit reports to SAP.
• Plan, design, manage, execute and implement SAP support projects, such as Epuise data synchronization; yearly HRSP application and testing; JP Morgan inbound and outbound bank interfaces with PI/PO configuration and end to end testing; SAP landscape (HANA, ECC and S4) migration to Amazon Web Services, SAP applications disaster recovery build etc.

IT Manager- Global SAP Finance Master Data Management

Confidential, Houston, TX

Responsibilities:

• Analyze business process and requirement of SAP ECC 6.0 ERP implementation project. Perform system requirement gathering and gap analysis. Design and develop FICO configurations and designs, Finance Master Data structures, conventions, policies, rules and procedures related to finance, supply chain, human resources, sales and distributions, manufacturing, data exacting, consolidation and financial reporting etc.
• Govern, manage and maintain global financial data. Centralize SAP global master data maintenance including chart of accounts, profit centers, cost centers, banks, intercompany processes, fixed assets, projects, vendors and customers, materials, treasury, financial and credit management, HR master etc. for implantation and roll-outs. Manage the finance MDM team to maintain production master data on daily basis for global over 50 countries and 35,000 employees. Accomplish significant cost-saving by reducing the 3rd party consulting hours and internal head-count.
• Design and establish financial master data structures and details for new functionalities implementation and new locations roll-out. Guide the implementation process to ensure the accuracy and correctness of financial master data. Lead and execute finance master data review, cleaning, mapping, validation, conversion and loading activities.
• Build, configure, implement and customize SAP FICO designs including GL, AR, AP, AA, Banking, Tax, Consolidation, TV (Travel Expenses), Treasury, CO, COPA, CO-PCA, CO-CCA, RA(Result Analysis), Project system etc. Test the configurations and functionality.
• Lead and execute the conversion, mapping, cleansing, loading, validation of all Finance master data for SAP implementations including chart of accounts, profit centers, cost centers, banks, intercompany processes, fixed assets, projects, vendors and customers, materials, treasury, financial and credit management, HR master, internal orders etc.
• Lead the team to review, optimize and clean financial master data. Perform financial data profiling and analysis. Identify issues and lead special project to improve business efficiency and accuracy of financial data. Team-work closely with corporate finance, financial SEC reporting and global closing co-ordination, IT sustain, IT project integration, IT transformation teams.
• Facilitate and provide in-depth user s concerning SAP Finance data structure, SAP Finance functionalities and financial reporting. Draft the publish Corporate Finance Master Data Policies, Guidance and materials. Perform intensive trouble-shooting, research and provide resolutions for all FI/CO functionalities.
• Design and monitor SAP Master Data Request approval and workflows, optimize the processes and procedure and manage SLAs for the team.

Senior SAP FICO Analyst

Confidential, Houston, TX

Responsibilities:

• Analyze business process and requirement of SAP ECC 6.0 ERP implementation project. Perform system requirement gathering and gap analysis. Develop business process design and model and define systems strategies as well as solutions in Blueprint Phase for various business cycles including Order to Cash, Procure-to-Pay, Asset and Equipment Management, Monitor and Report Financials as well as Human Capital Management.
• Perform and lead the realization phase for all FI/CO functionalities. Take the full responsibilities and key role as the ONLY resource to configure and customize GL, AR, AP, AA, Banking, Tax, Consolidation, TV (Travel Expenses), Treasury, CO, COPA, CO-PCA, CO-CCA, RA(Result Analysis) etc. Review and validate customizations for baseline and final configurations. Accomplish significant cost-saving by reducing the 3rd party functional consulting hours from 200 hours/week to 20 hours/week within 2 months.
• Take the full responsibilities and key role as the ONLY resource to design and create FI/CO master data structures as well as manage and set up all FI/CO master data.
• Draft, revise and finalize over 100 functional and technical specifications for enhancements of FI/CO functionalities. Communicate with development team, validate and test enhancements.
• Perform intensive trouble-shooting, research and provide resolutions for all FI/CO functionalities. Review, validate, test and apply solutions, such as SAP notes etc. Create and monitor Service Request with SAP Support as needed.
• Lead financial data conversion for multiple project roll-outs. Take the full responsibilities and key role as the ONLY resource to build LSMW and load data files for GL COA and account balances, AA Asset master and balances, AR balances, AP balances, MM inventory balances and vendor master, SD customer master, TV travel expense vendor master etc.
• Develop, validate and optimize complex queries, reports and data files using Report Painter, Writer and SQL to facilitate various businesses need.
• Design and perform regression testing including unit testing, integration testing (INT) and user acceptance testing (UAT) during the implementation process. Lead and support user s for all FI/CO functionalities for project roll-outs.
• Provide over 12 months of on-site and hands-on support to users for FI/CO modules. Trouble shooting and resolve encountered issues. Design, implement and manage the SLA standards and procedures for post go-live user support. Conduct continuously remote user support, s and communications as level 1, 2 and 3 support. Manage, lead and delegate off-shore support team for FI/CO user requests and tickets.
• Provide in-depth insight for ECC integrations from FI/CO perspective. Perform account determination customization for other modules such as SD, MM, HCM, PS, PM etc. Work with Security team to build, validate and test FI/CO and other related security roles. Administrate and monitor ECC workflows.

Oracle EBS Implementation Project Transition Lead

Confidential, Houston, TX

Responsibilities:

• Implement Oracle application functional solutions for EBS R12 installations and rollouts. Lead and perform configurations and set up of Oracle EBS R12 all core modules, including Oracle General Ledger and Sub-ledger Accounting (GL and SLA), Order Management (OM), Purchasing (PO), Inventory (INV), Accounts Receivable (AR), Accounts Payable (AP), Process Manufacturing (OPM), Cost Management (CST) etc.
• Design and perform regression testing including unit testing, integration testing (INT) and user acceptance testing (UAT) during the implementation process.
• Perform intensive trouble-shooting, research as well as provide resolutions for all modules (GL, SLA, OM, INV, PO, AR, AP, CST, etc.). Review, validate, test and apply solutions, such as patches, data fixes etc. Create and monitor Service Request with Oracle Support (Met-Link) as needed. Utilize Oracle Diagnostics, trace and other tools to gather necessary information. Monitor applications and transactions as precautious on daily basis.
• Design, implement and manage the SLA standards and procedures for post go-live user support. Conduct continuously user support, s and communications.
• Develop, validate and optimize complex queries, reports and data files using PL/SQL to facilitate various business need.

Senior Oracle Applications Functional Analyst

Confidential, Houston, TX

Responsibilities:

• Analyze business process and requirement Oracle R12. ERP implementation projects. Perform system requirement gathering and gap analysis. Develop business process design and model. Define systems strategies, including reports, interfaces, conversions and extensions, for various business cycles such as, Acquire to Dispose, Account-to-Close (Record to Report), Procure-to-Pay, Project-to-Close, Lead-to-Contract (Order to Cash) etc.
• Implement Oracle application functional solutions for EBS R12 installations and rollout. Configure and set up Oracle EBS R12 all core modules, including Oracle General Ledger and Sub-ledger Accounting (GL and SLA), Accounts Payable (AP), Fixed Assets (FA), Project Accounting (PA), Inventory (INV), Purchasing (PO), Cost Management (CST), Cash Management (CM), Accounts Receivable (AR), I-Expense, I-Procurement etc.
• Significant hands on experience with PA Costing and Billing. Lead Project Accounting (Costing and Billing) implementation team. Configure key areas in Project Costing, Project Billing, auto Accounting, business flow setups. Define Project related setup options, Project calendar, Project Period. Setup Project types, Project Templates, Tasks, workflows and profiles. Set up Project rate Schedule for Labor and Non-Labor ps to facilitate the resources to enter their cost against the Project and Task number. Customize project accounting suite for reporting activities. Configure accounting Rules for Auto accounting and creating Lookup sets. Configure Project Capitalization process and interfere to Fixed Asset module.
• Design and perform regression testing including unit testing, integration testing (INT) and user acceptance testing (UAT) during the implementation process.
• Lead and perform over 400 hours of in-depth class-room user sessions at various sites across US. Provide over 10 months of on-site and hands-on support to users for all core modules. Trouble shooting and resolve encountered issues.

Oracle Applications Support

Confidential

Responsibilities:

• Take the full responsibilities and key role as the ONLY functional analyst for entire Oracle applications with over 750 users, 12 core modules and 5 instances. Accomplish significant cost-saving by reducing the 3rd party functional support hours from 240 hours/week to zero within 2 months.
• Perform intensive trouble-shooting, research as well as provide resolutions for all modules (GL, SLA, FA, PA, AP, INV, PO, CST, CM, AR, I-Expense etc.). Review, validate, test and apply solutions, such as patches, data fixes etc. Create and monitor Service Request with Oracle Support (Met-Link) as needed. Utilize Oracle Diagnostics, trace and other tools to gather necessary information. Monitor applications and transactions as precautious on daily basis.
• Lead and manage special projects related to Oracle applications. Design, collaborate, and document EBS functional and technical specifications for various special projects such as acquisitions, new operating unit configurations for all modules, Chapter 11 filing, bankruptcy emergence, bank conversions and automatic banking transactions implementation etc. Design, create, test and implement numerous SQL scripts as well as configurations related to all core modules such as AP, CM, GL, FA, INV, PO, PA etc. to achieve special goals.
• Develop, validate and optimize over 500 complex queries, reports and data files using PL/SQL and Toad to facilitate various business need. Publish the queries and reports through Oracle Discoverer and EBS customized schema. Develop and modify various RTF files for XML report templates.
• Conduct continuously user support, s and communications. Create and perform over 100 hours of substantial follow-up s at various sites all over US.
• Manage upgrades projects. Perform patch and functional analysis for multiple upgrades (12.0.4, 12.0.6 and 12.1.3). Lead the upgrade testing cycles. Conduct trouble shooting and provide solutions during the upgrading/testing process. Teamwork with developers to complete development objects and manage 3rd party development resources.
• Enhance, improve and optimize EBS effectiveness and efficiency continuously by changing configurations, processes automations etc. Maintain and modify EBS system securities and controls for SOX compliance. Create and modify customized responsibilities, menus, functions request sets etc. Administrate Oracle application workflows.

Senior Accountant

Confidential, Dallas, TX

Responsibilities:

• Performed general ledger month-end close. Prepared, evaluated, reviewed and corrected monthly, quarterly and annual financial statements as well as supplement and footnote information. Analyzed the financial statements and presented to management. Brought management's attentions to various issues that affected cash flows, internal controls, financial results etc.
• Oversaw various sub-ledgers, including AP, AR, payroll etc. Reviewed, analyzed and reconciled accounts and transactions. Maintained and examined financial schedules and records to ensure transactions were properly recorded. Made timely corrections on identified issues. Assisted financial and tax audits.
• Managed fixed assets procedure, policy and process. Preformed bank reconciliations for all bank accounts including deposit accounts, disbursement accounts, payroll accounts etc. Managed and compiled inventory financial data and information. Conducted periodically physical inventory verifications. Maintained Sarbanes-Oxley compliance.
• Team-worked with non-financial managers to prepare, evaluate, review and modify annual financial budgets. Generated financial forecast and financial projections. Compiled managerial accounting information, including scorecards, benchmark etc.

Staff Accountant

Confidential, Arlington, TX

Responsibilities:

• Prepared standard journal entries and allocations.
• Performed accounts reconciliations and corrections which involved intense analysis and investigation on un-reconciled items.
• Recorded AP and AR transactions in general ledger.
• Maintained accounting schedules.
• Worked closely with customers and vendors to research the reconciliation items and resolve the disputes.
• Presented monthly financial results to management.
• Prepared the variances analysis.
• Explained the financial information to non-financial managers.
• Identified opportunities to improve business processes and reported the findings to management.