Senior SAP BW/BPC Developer/Analyst Resume Irvine, CA - Hire IT People

SUMMARY

PROFESSIONAL EXPERIENCE

Confidential

Senior SAP BW/BPC Developer/Analyst

Responsibilities:

Manage SAP BW(7.5) data warehouse running HANA DB back-end with SLT tables from FI and SD
Support all operations planning on BPC embedded to include all back-end planning cubes
Design and maintain all BPC planning templates in Analysis for Office as well as Bex Query Designer
Maintain existing calculation views and design new views to support data integration between SAP data and external systems
Highly experienced user of HANA studio with perspectives in BW modeling and HANA CV modeling

Confidential, Irvine, CA

Senior SAP BW/BPC Administrator

Responsibilities:

Manage SAP BW(7.5) data warehouse used in financial reporting and annual planning
Monitor and correct all data accuracy issues involving both master data and transaction data in SAP BW
Support one BPC embedded application(10.1) and one BPC Standard application(10.1).
Integration experience includes the automation of SSIS jobs to load plan data to SAP planning cubes
Develop and test new Fox planning functions as required by corporate planning group.
Develop and test new ABAP routines used in numerous ETL programs
Enhance and maintain data extractors and ETL processes from FI and PS modules into BW
Enhance and fix Bex queries consumed in either Bex Analyzer or Analysis for Office
Support and maintain SQL Server Analysis Services cubes for analyzing outstanding loans

Confidential

Senior Programmer and DBA

Responsibilities:

Supported the Logility planning application and all the related custom VB codes used in processing orders for the Grocery division.
Participated in a major project to adapt existing VB codes to work with new data structures used in new SAP ERP system
Acted as DBA for 3 production instances of Oracle used in running the Logility application
Supported the Financial Reporting and Budgeting group on Oracle Financial Analyzer
Supported the Marketing group on an Oracle Express OLAP application
Played a key role in the implementation of a new OFA data design using version 6.3 with data migrated from the old 6.2 environment
Wrote and modified numerous SPL programs in the custom code database to accommodate design changes required in implementing OFA 6.3
Worked with users to troubleshoot and make changes to system as necessary. Programmed a new Excel template using VBA with the Express API to provide users a tool to upload data to OFA from an Excel worksheet

Confidential

Senior Business Systems Analyst

Responsibilities:

Supported the Financial Planning and Reporting groups on SAP FICO module and work with the Information Systems group on configuration and systems reporting issues
Developed and maintain an SAP data warehouse containing general ledger and internal orders data in MS Access to facilitate monthly reporting for 12 financial analysts
Developed custom applications and user interfaces using standalone VB6 or VBA contained in Excel or Word to access SAP reports and data using remote function calls via OLE automation
Acted as system administrator for Hyperion Pillar budgeting software and support over 30 users in Finance with technical issues
Administered a Lotus Notes application used to assign engineers to development projects and use this data to generate product line contribution reports for all active product lines

Confidential

Senior Financial Analyst

Responsibilities:

Analyzed corporate profit & loss statements and financial performance for a $45 million direct-mail advertising company
Produced revenue goals and detailed expense budgets under the direction of the Chief Financial Officer
Conducted variance analysis reports and present results at monthly management meeting
Assisted Chief Operating Officer in developing pricing strategies for new as well as existing products

Confidential

Financial Analyst

Responsibilities:

Compiled sales revenue forecasts and product requirements for Canada, Middle East, Mexico
Acted as liaison for all business issues originating out of Europe
Provided technical support for database systems used to track sales orders from International subsidiaries
Maintained all Lotus macros and handled all breaks/fixes

Confidential, Culver City, CA

Staff Accountant/Analyst

Responsibilities:

Produced biweekly sales forecasts and pro-forma Profit & Loss reports for Western Region VP
Provided financial support to sales executives in the Western Region territory