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.

KNOWLEDGE AND SKILLS

• Computer Specialization: SAS, SAP BPC, SAP FICO, SAP BW/BI, SAP Business Objects XI R2 and R3, SAP ECC, Microsoft SQL Server, SQL Server Analysis Service, and SQL Server Integration Services, Oracle Financials, Oracle E-Business, 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: Microsoft Business Analytics, Peoplesoft General Ledger, Peoplesoft HRMS/Payroll, Peoplesoft Financials, Access, Relational Database Management System, PowerPoint, Advance Excel with vlookups, macros, and pivot tables, Word, 10-Key

WORK EXPERIENCE

Confidential

Business Data Analyst

• Engaged as the lead analyst for the Oracle Financial Service Analytics and the Fidelity Oracle information system
• Streamlined SAP BO/BPC reports out of the analytic systems from the Fidelity Oracle database and DW
• Engaged in development and design of data warehouse data model, ETL load, and performance consideration
• Developed documentation in support 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
• Worked on SAS to optimize information and analytic usage to ensure quick and actionable intelligence
• Used SAS to build 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

Financial Business Analyst

• 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
• Worked with report development by writing SQL and PL/SQL scripts against the underlying tables and schemas
• 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
• Performed extensive application configuration and drive reporting based out of SAP BPC and Business Objects
• Engaged in user acceptance of input forms and reports for SEC reporting, tax, treasury, and weekly flash financials
• Documented business data flow and control process flow to monitor data quality check and workflow efficiency
• Participated in review of database architecture/design, data modeling, and ETL specifications for datawarehousing

Confidential

Business Analyst 3

• Provided functional support for closing, budgeting, and forecasting for the Operations Support Business Unit
• Created universes, classes, and objects specifically for Corporate Real Estate and Transportation Service
• Translated business requirement and implement reporting solution with SAP BOXI R2 and SAP BPC
• Provided best practice on BPC configuration, dimension, hierarchy and property setup, and security consideration
• Managed the data validation process and security role mapping in SAP FICO and applying SOX control policies
• Provided data analysis of AP, PO, Receipt, and Invoicing and run data quality check on the underlying records
• Performed account reconciliation, variance analysis, and trend analysis of the p l and balance sheet accounts
• Maintained GL account analysis, cost centers allocations, key business drivers, work orders, and internal orders
• Participated in ad hoc request dealing with complex data analysis and formulated project management strategies
• Performed SOX compliance on application and systems controls and ensure proper standard operating controls

Confidential

Business Systems Analyst

• 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
• Performed troubleshooting tasks relating to BPC and Oracle performance, connections, and installation

Confidential

Finance Accountant

• Performed month end closing, journal entries, reconciliation, financial statements, budgeting, and variance analysis
• Managed the cost center allocation process and analyzed payroll benefits, overhead expenses, and SGA
• Partnered with the finance team to lead the requirements gathering efforts for all finance-related applications
• Automated vacation and sick pay accrual and ensured timely contributions to the benefits trust plan
• Updated bank recon and ensure customer collection are accurate, timely, and matched to cash deposit listing
• Maintained for proper transfer of cash inflow and outflow to corporate headquarter through daily bank wire analysis
• Implemented new sql scripts to update key business metrics, ad hoc analysis, and forecasting/projection
• Served as the lead analyst on the Order-to-Cash cycle that includes procurement, PO receipt, and invoicing
• Extensive experience with Peoplesoft e-business solution including HRMS, payroll, AR, AP, fixed assets, and GL

Confidential

Financial Analyst

• Served as an outlet business consultant for regional planning and consolidation of actuals, forecast, and budgeting
• Performed account analysis, variance analysis, and GL account reconciliation of the p l and balance sheet
• Distributed individual business unit monthly reports of the operating expenses, gross margin and operating margin
• Provided weekly sales volume and trade spending report to determine actual vs. goal, including promotional details
• Benchmarked SGA against budget and prepared reports for DSMs as areas to watch for austerity
• Performed in depth trend analysis of sales, cost of goods sold, inventories, purchases, and inter-unit transfers
• Acted as a liaison between information services and the business units to address efficiency and functional issues
• Extensive experience with Oracle Financials, including GL, AP, AR, purchasing, customer order, and invoicing.