SUMMARY:

• Twelve years of SAP Configuration experience in BPC NW/MS 10.0 (HANA) /7.5/5.1, ECC 6.0/5.0/4.6
• Implemented multiple BPC projects, this includes Planning solutions (Revenue, Sales, OPEX, CAPEX, HR planning) and Consolidation (US Elimination, Management Consolidations, Multicurrency)
• Participated in three full life cycle SAP ECC implementation and upgrade projects, new solution implementation, several maintenance and enhancement projects documentation, and User training
• Experienced in industry specific business process e.g. Revenue recognition, Service Management, Royalty Payment, Copyright Reporting, Multi currency environment, Intercompany Accounting
• Configuration experience with SAP BPC Consolidations & Planning (NW and MS) - Admin, Business Rules, Script logic, Transformation, Conversions and Reporting (EvDRE and EPM), SSIS Package
• Competent in Client relation management, Project Management, Resource allocation, Presentation,
• Hands on SAP ECC configuration experience -Financials (FICO), Profitability Analysis (COPA), Financial Supply Chain Management (FSCM), Special Ledgers, Project Systems (PS), Human Capital Management and Payroll
• Knowledge of SAP HANA, SAP BW/BI, BeX Analyzer, SQL Server

TECHNICAL SKILLS:

Consolidation: Legal/Managerial/Tax Consolidation, US Consolidations, Ownership Model, Rate model

Planning: Sales planning, Cost center planning (OPEX), Capital spending (CAPEX), HR planning

Configuration/Admin: Script Logic, Debugging (UJKT, ABAP), Work status maintenance, Business process flows (BPF), BADI implementation, Develop SSIS Packages

Business Rules: Currency Translations, CTA, Eliminations and Adjustments (E&A), Intercompany Booking, Balance carry forward

Data Loads: Maintenance of Transformations and Conversions files, Master Data and Transaction Data loads from BW and flat files, Package and Package Links

Reporting: EPM, EvDRE, Web Reporting

Performance improvements using: UJSTAT, MDXTEST and SLG1

Finance module: New General ledger, Accounts payables, Accounts receivables, Credit Management, Asset Accounting, Sales Tax & Use Tax, Special Ledger, Report Painter, Report Writer

Controlling module: Internal order, Cost center accounting, Profit center accounting, Basic Product costing

COPA: Account and Cost Based Profitability Analysis

FSCM module: Dispute Management, Collection Management, Credit Management, and Biller Direct

Project Management: Experience with Agile project management

PROFESSIONAL EXPERIENCE:

SAP BPC Sr. Developer

Confidential, Irvine, CA

• SAP BPC OPEX Planning Model
• Scope involved OPEX planning solution for Confidential, Inc, data load from SAP BW, HEADCOUNT model and push to other models - FINANCE, GROSS MARGIN
• Role - Requirement gathering, design, train and roll-out the solution to end users
• Dimensions in model - Standard planning dimensions plus WBS/project, Production orders
• Created alternate hierarchies for dimensions (many of them have 20,000+ members) and built security on these hierarchies.
• Created multiple BPC scripts based on dimension properties e.g. custom logic to copy data from Actuals to Forecast categories and them to allow easy planning input post amounts at account roll-up level. RUNALLOCATION scripts where applicable. PUSH logic to other models.
• Created EPM report - e.g. Category comparisons, Top 15 Projects, Drill-thru (To BEx) using EPM functions like - EPMDimensionOverrride, EPMAxisOverride. Trained users on how to use Expand/Collapse functions for EPM report
• Created complex EPM Input Templates using VB Script - e.g. lock cells for protection in Actual category
• Created Transformation and Conversions to load master/transactional data from - BW Info providers and Flat files
• Created complex package/package links - to create Hierarchies for WBS (which did not exists in BW source system), pass parameters from package to script logic
• Created multiple BPF, Instances for quarterly forecast cycles - Each step included reference guides, link to - packages/package link/report/input template/dimensions

SAP BPC Sr. Developer

Confidential, Houston, TX

• SAP BPC Consolidation Application Enhancement
• Scope involved Design and Build of Consolidation Application for Master Limited Partnership (MLP)- Segment and Tax Consolidations
• Designed the new Entities and Groups
• Created Consolidation Business Rules for Equity methods
• Maintained Automatic Adjustments rules for Equity pickup
• Modified Scrip logic for custom consolidation
• Created Tax and Segment consolidation EVDRE reports, published consolidated books
• Helped user to test and validate consolidation results
• SAP BPC Planning Application Enhancements
• Enhanced Sales planning application for territory planning
• Used script logic for top-down planning/distributions
• Created dynamic EVDRE reports territory planning
• SAP BPC 7.5 Service pack updates
• Applied service pack updates and participated in UAT

SAP BPC Consultant

Confidential, Calgary, AL

• SAP BPC Managerial Consolidation of Plan data
• Scope involved Design and build of -Planning Model for P&L planning, and Management consolidation Model of plan and forecast data
• Lead Business blueprint requirement sessions, provided solution options
• Designed Management consolidation model to consolidate plan and forecast data
• Designed interfaces from- Legal consolidation model and Planning Model
• Designed Management Entity, concatenated version of SAP ECC Company code and Profit center
• Created Entity Hierarchy to represent Ownership/Group structure
• Created Ownership structure for Management Entities
• Created Business rules- Carry forward, Account Calculations, Currency Translations and Consolidations
• Used UJ CUSTOM LOGIC enhancement spot to develop Allocation BADI.
• Created logic script logic by using Destination App, and BADI to transfer data between planning and consolidation Model.
• Created complex script logic for balance sheet logic calculations
• Lead integration testing with business users, Delivered solution and provided after Go-Live support

SAP BPC, FICO Lead

Confidential, Mission Viejo, CA

• SAP BPC SG&A Cost Center Planning, CAPEX, BS Planning (Version 10.0 NW, TM1 was legacy system)
• Developed Application for MG&A planning for North America
• Automated master data load (cost centers and GL accounts) and transaction data from SAP BW
• Developed web templates for cost center managers to input budgets
• Drill-down reporting (to BeX) to view cost center line items details
• Developed reports- variance and trend analysis
• Developed script logic for allocations
• Retracted BPC data to ECC using BADI
• Security maintenance (Teams/Access Member Profiles)
• SAP BPC Consolidations Implementation (Version 7.5 NW, TM1 was the legacy system)- Global Financial and Managerial consolidations
• Scope involved gathering data form multiple GL systems from global entities and consolidating
• Participated in business requirement with Financial consolidation team and local business users
• Scope included Financial consolidations and Managerial consolidation
• Designed Application, Dimensions, Dimension properties setup, business rules
• Script logic development for Default logic, consolidation logic, IC matching/booking, Re-class logic
• Maintained Business Rules - Account transformation, Automatic adjustments, and US Eliminations
• Developed packages to load Master Data and transactional data (GL Balances) from -SAP BW/SAP ECC and non-SAP systems.
• Created custom Start & End BADI for Trial balance validation, implemented RUNLOGIC BADI
• Developed EvDRE Reports - Consolidation reports (B/S, P&L, Disclosure accounts, Cash Flows)
• Created budget and forecast input templates
• Implemented mass user management tool, Developed Security matric, applied custom program to load Users/Teams/Access Profile/Task Profile from Excel files
• Trained End user to upload data in BPC, Debug mapping issues and use validation reports
• SAP ECC FICO
• Implemented cash discounts accruals using COPA
• Involved in extraction of COPA data to BW and TM1 (sales planning system)
• Implemented new M&A entities, Profit and Cost center Hierarchies
• Implemented Payment cards, Interfaces to Concur System
• Implemented BAI2 enhancement project- using Third-Party software, to increase cash application hit rate
• Supported FI - General Ledger, Accounts Payables, Account Receivables, Asset Management, Tax Reporting
• Supported CO- Costing based COPA, Created new Characteristics and Value fields

Business Analyst

Confidential, CA

• SAP BPC Sales planning implementation and cost center planning
• Developed SOP application, dimensions
• Developed complex Product and Region allocation logic
• Developed input schedules to enter detailed plans
• Uploaded SAP ECC COPA data (as ACTUAL) in BPC, and also retracted BPC planned values in COPA in different plan versions
• Created EvDRE reports- Trend analysis, Actual vs. Plan
• Improved reporting performance- by multiple EvDRE’s
• SAP FSCM Solution Implementation (Two-System Landscape)
• Implemented Dispute module for AR department
• Enhanced collection modules, developed new collection strategies
• SAP FI, CO Enhancement
• Enhanced costing COPA structures- added new value fields and characteristics relevant to AFS industry
• Created Costing based COPA planning templates
• Implemented integrated internal order planning

SAP FICO, HR Business Analyst

Confidential, Los Angeles, CA

• Project lead for ECC 6.0 upgrade project
• Successfully lead internal and system integrators team to upgrade from 4.7B to ECC 6.0 Unicode system
• Added new functionalities in FICO and HCM
• Supported FI modules - General Ledger, Accounts Payable, Accounts Receivables and Asset Management
• Enhanced Costing and Account Based COPA, modified reports to include new structure

Sr. Associate

Confidential, Los Angeles, CA

• Designed -inbound and outbound COPA interfaces to/from Hyperion system
• Designed outbound interface of GL and cost center hierarchies to Hyperion with custom rules
• Designed drill-down custom report which displays assessments from FI to Costing Based COPA

SAP Business Analyst

Confidential, Old Tappan, NJ

• Pearson Inc. Implementation (Full life cycle implementation)
• Implemented new corporate entities and migrated legacy balances
• ISBN 13 Enhancements
• As media industry standard moved from ISBN 9 to ISBN 13, identified impact on master data and integration with other systems
• Participate ECC 5.0 Upgrade project
• Brady Games Enhancement
• Implemented new entities acquired from M&A activities