OBJECTIVE

• Seeking a strategic role utilizing finance, accounting, auditing, and information technology to facilitate business needs while ensuring optimal solutions are achieved, feasible, and properly integrated with the business objectives.

TECHNICAL SKILLS

Computer Specialization: SAP BPC, SAP FICO, SAP BW/BI, SAP Business Objects XI R2 and R3, SAP Order - to-Cash, Microsoft SQL Server, SQL Server Analysis Service, and SQL Server Integration Services, Oracle Financials, Oracle PL/SQL, Oracle Data Warehouse (OBIEE), Oracle Discoverer, Oracle Database Administration, Oracle Backup and Recovery, Oracle Performance Tuning, Unix/Linux scripting (bash), Oracle Enterprise Manager

Oracle Technical Skills/Experience: user acceptance testing, process definition and data requirement, memory, storage, and cpu utilization, capacity planning, performance tuning, RMAN backup and recovery, SQL Loader, Export and Import Utility, database and data warehouse installation, design, configuration, and implementation, replication, materialized view, RAC, SQL Plus

Other Computer Experience: Access, PowerPoint, Advance Excel (vlookups, macros, pivot tables), Word, 10-Key

Bicultural and Bilingual: Cantonese Language

PROFESSIONAL EXPERIENCE

Confidential, Burbank, CA

Senior Business Analyst Consultant Contractor

Responsibilities:

• Performed functional and technical hands-on SAP BPC planning and consolidation design and configuration
• Worked extensively on report development, input schedules, script logics, allocation, and security
• Developed and maintained hierarchies, dimensions, properties, KPI, and EPM add-on for seamless drill-through
• Configured account transformation in Web Admin and intercompany matching and elimination through script logics
• Setup up default logics for currency translation, restatement, and any other business rules using custom built logics
• Extensive experience with Data Manager Packages, data integration, and BW process chain and modeling
• Implemented security using team access profile, member access profile, and work status on Web Admin
• Liaised between SAP BW team and the BPC team regarding infocubes and DSO development and data extract
• Streamlines the backup strategy and performance optimization with the system server admin and database admin
• Performed functional support of SAP FICO Order-to-Cash module to generate sales order, billing, and GL posting
• Coordinated process support of A/R daily transactions with customer setup, posting, and batch processing.
• Liaised between accounts receivable and MIS to document business requirement enhancement and bug fixes
• Lead testing requirement and UAT for the existing third party SAAS application for royalty revenue recognition
• Project manage team effort in ETL related tasks and validated invalid data, format, and transform development
• Created flow chart diagrams for existing process and identified opportunity for automation to reduce cycle time
• Provided SAP production support for closing and troubleshoot close critical issues for the territories assigned
• Coordinated the onboarding program of new licensees for process compliance, data collection, and quality control
• Designed and tested the royalty revenue accrual program for the global SAAS application affecting every licensees
• Validated pricing logics and GL product assignment are driven out correctly based on MDX script logics and business rules
• Participated in the automation and UAT of SAP sales order reversal using Tx-Shuttle scripts and excel input file

Confidential, Santa Barbara, CA

Data Analyst

Responsibilities:

• Engaged as the lead analyst for the Oracle Financial Service Analytics and the Fidelity Oracle information system
• Streamlined SAP Business Objects reports out of the analytic systems from the Fidelity Oracle database
• Engaged in development and design of data warehouse data model, ETL load, and performance consideration
• Developed documentation insupport of the reporting processes, business process maps, and report specifications
• Extensive hands-on exploration of data sets, SQL, dashboards, statistical analysis, and data visualizations.
• Evaluated data connected from multiple sources in support of KPI’s, business drivers and local reporting needs
• Optimized information and analytic usage to ensure quick and actionable intelligence
• Built dynamic and rich dashboards using out-of-box features, customizations, and visualizations
• Performed data analysis and developed statistical models for segmentation, classification, optimization, etc
• Explored and recommended emerging technologies and techniques to support/enhance BI landscape components.

Confidential, San Jose, CA

Financial Business Analyst

Responsibilities:

• Designated as the lead SAP BPC analyst for the development, implementation, and production support
• Maintained and updated SAP BPC dimensions, hierarchies, properties, MDX script logics, security, and work status
• Performed extensive application configuration, cube optimization, and drive reporting based out of SAP BPC
• Engaged in user acceptance of BPC input forms and reports for SEC reporting, tax, treasury, and weekly financials
• Supported management reporting and analysis on consolidated financials for close, forecast, and annual plan
• Managed reporting and forecasting improvements through systems enhancements and process improvement
• Partnered with worldwide FP&A and Corporate Accounting teams to define business requirement and rollout plans
• Ensured system development team properly translated business requirement for improved reporting and analytics
• Coordinated with IT on systems requirements to support forecasting and planning cycles for worldwide operations
• Created reports and implemented processes for in-depth analysis of company accounts and lines of business
• Provided ongoing support with worldwide FP&A and IT teams for the day-to-day system-related training and issues
• Documented business data flow and control process flow to monitor data quality check and workflow efficiency

Confidential, Rosemead, CA

Business Analyst 3 Contractor

Responsibilities:

• Responsible for daily accounting transactions in support of the receivables process, customer GL setup/posting
• Streamlined processing needs relating to daily lockbox and wire remittance deposits to the appropriate account
• Analyzed deductions and credits in customer accounts, identifying items to net, items to follow-up with customer, and items requiring potential write-off and reviewed weekly aging report to address accounts 45+ days past due
• Identified causes of nonpayment and communicated issues for corrective action to be taken
• Contacted customers to collect past due amounts and identified any reasons for non-payment.
• Continuously worked to improve A/R processes through SAP technology for quality improvements.
• Implemented SAP Business Objects to provide automated full extract for data warehousing needs.
• Developed cash flow projection relating to the amount collectible and uncollectible from customers

Confidential, Beverly Hills, CA

Business Systems Analyst

Responsibilities:

• Administered all aspects of BPC configuration, consolidation, planning, reporting, dimensions, and hierarchies
• Worked to improve data quality, collection processes, and report design to meet diverse and changing needs
• Conducted functional testing, acceptance testing, and end-user support for SAP Outlooksoft BPC
• Provided security implementation for Oracle/Outlooksoft users through roles/profiles and task/member access
• Formulated internal control risk management to help reduce business and technology risk
• Developed financial models on BPC to facilitate financial, statistical, operational, and cost/benefit analysis
• Participated as key member to the system development, conversion and implementation life cycle of BPC
• Worked closely with the development staff in interpretation and analysis of data and process requirements
• Updated and maintained security access, rollup structures, dimensions, and user setup