Sap Epm (financial Planning) Resume
Huston, TX
SUMMARY:
- Having 14 years of IT experience in SAP EPM, SAP FSCM, SAP BW, SAP S4 HANA, SAP Simple finance, SAP FI, CO and SAP BI/BO with excellent Project Management, Business Analysis and strong Communication Skills.
- Having cutting edge experience in SAP EPM Financial Solution with Four Full Life Cycle Implementation, One Support, One Upgrade and Role out projects with focus on Planning, Budgeting & Consolidations
- Worked on Reports, Dynamic templates, SAP BPC, FICO security design, Data manager, BPF, Applications, Dimensions, Members, Properties, Work status, Security, EV functions in SAP BPC
- Describe and configure functionality and features of SAP Profitability and Cost Management and Design the Industry KPI’s.
- Involved in all the phases of project using ASAP Methodology which includes AS - IS, TO-BE, BBP, Configuration, Testing and Go-Live activities
- Experienced in developing Reports & Input Schedules, SAP BPC Scripting and Excel VB.
- Extensive experience in configuration and testing of FI/CO modules -GL, AR, AP, Fixed Assets, Treasury, Cost Center Accounting (CO-CCA), Internal Orders and Profitability Analysis (CO-PA). Product costing (CO-PC) and Special purpose Ledger
- Integration of FI with MM and SD with Procure to Pay and Order to cash Cycles Reporting tools like Report Painter, Report Writer
- System landscape experience on design, Sizing, Install BPC 10 MS, Extensive Test Custom logic, Architecture design /develop the Report and Input Schedules.
- Expertise in Defining and Configuring Dimensions, Dimension Members and their properties, AppSet and Applications, Logic development, Data transformation and Conversions during the loads.
- Proficient in External Reporting and preparation of Financial Statements with good understanding of GAAP.
- Adept in various financial processes including Auditing, Assurance, Accounting processes, Financial statements, Fund Flow Management, Reporting, Consolidation and analysis, Budgeting and Forecasting
- Experienced in preparing a demo system for client which could successfully convert the lead into the business for the organization
- Experience in SAP BW Designing and maintenance of Info Cubes, MultiProviders, Remote Cubes, Infosets, DSO objects with consistent star schema and efficient multi-dimensional data modelling techniques. Customization of data sources in various SAP modules with focus in FI, CO, SD, MM, PP,PS, QM and HR Data
- Experience in SAP BPC BADI’s, BI Routines, BI-EXTRACTORS .
- Worked Across the Asia,Dubai,Qatar,UK,US.
PROFESSIONAL EXPERIENCE:
Confidential, Huston,TX
SAP EPM (Financial Planning)
Responsibilities:- High Level requirement Study and data Assessment for SAP EPM & BI,BO,R/3
- Lead the Team Size of 14 with SAP ABAP, SAP BW,SAP BPC,SAP BO,SAP HANA.
- System Design for SAP BPC(EPM) Planning and management consolidation.
- Preparation of master data for dimensions and required properties for planning scenarios
- Design Data upload structure with transformation & conversion logic for appropriate master data loads and transaction data loads through flat file approach.
- Stress tested the production data for the performance check of the data model.
- Reviewed solution architecture and provided technical guidance on as-needed basis.
- SAP CRM/ ECC Master Data Creation & Maintenance- Business Partner/ Customer Master Data, Marketing Attributes, Product Master Data, Pricing Conditions, Organizational Master and Territory Management.
- Working with OPEX, Sale, Revenue, Cash flow Planning Templates
- Developed custom Process chains to support master data and transaction data loads from BI to BPC.
- Script Logic Programming (Dimension & Worksheet) for Currency Conversions, Inter Company Eliminations, Account Reclassification, Allocations and other customized script logics.
- Good Experience to setup input schedules / interfaces for external data / reports / and custom planning and forecasting functions
- Worked on setting up Security and Audit settings to ensure user entitlements and access rights.
- Worked exclusively on Work Status and integrating the Work States with Business Process Flows.
- Configured drill-through functionality in Reports to see the underlying data from external databases.
Confidential, Indianapolis, IN
SAP BPC10.1 (Financial Planning) Architecture & SAP Simple Finance
Responsibilities:- Responsible for EPM ( BPC/FICO/BW) back-end development: designing, developing, and implementing budgeting and planning models
- Interpret business requirements into system solutions to satisfy the business needs and improve the user experience
- Working on Planning & Budgeting Business processes - Annual Planning ( Sales Planning, Cost Center Planning, CAPEX Planning, Planned Financial Statements/ Reports P&L, Balance Sheet, Cash Flow ).
- Liaise with other CoE team members to communicate change impact, and co-ordinate and optimize cross-module requirements
- Responsible for BPC back-end development: designing, developing, and implementing budgeting and planning models
- Load the BPC model from back end systems and generate the reports SAP BI Analysis Office and EPM Add-In.
- Working with Profit and Cost management based on Region and Product dimensions .
- Design and Develop the KPI’s with Product and Industry Cross function segmentations.
Confidential, Houston, Tx
SAP BPC 10.0 Consolidation Lead Consultant
Responsibilities:- Financial Reporting and Analysis (Region/Internal Management)
- Managing the Financial Close IFRS (Audit)
- SOX Compliance Activities (GAAP)
- Working with External Auditors
- Creating and Maintaining Forecast Reports.
- Creating Discoverer Reports.
- High Level requirement Study and data Assessment for both Legal and Management Consolidation
- System Design for both Legal and management consolidation
- Input schedules to capture Supplementary data and additional financial data.
- Statutory/Legal reporting for the Group based on consolidating and posting elimination entries between all SM Groups of Companies.
- Designed the SAP BPC Input templates end to end security and meeting BCF/Intercompany eliminations.
- The Complex consolidation hierarchy with time depended complex ownership.
- Developed SAP BO PC consolidation reports to validate the data transferred from SAP BO PCM TO SAP BO BPC and show the detail transaction data via SAP BPC Drill-Through
- Consolidation at subgroup level hence at group level with cash flow.
- Consolidation of Investment, Net earning derivation, Inter-company matching and elimination.
- Worked with Financial SAP BPC reporting authorization design and development .
- Elimination process for Capital stock, Investment in shares and minority Calculations.
- Worked with Profit and cost management function within SCM segmentation.
Confidential,San Diego,CA
Senior SAP Functional Lead
Responsibilities:- Owner for Application development technical processes. Provide process training to development team.
- Application development technical processes SAP-BPC Net weaver with end to end Software Lifecycle implementations (SDLC) with focus on Budgeting and Planning solutions using SAP-BPC
- Provide detailed estimates for projects for design and development. Validate estimates from consultants.
- Understand the Business Process and built insights to functional and technical aspects of SAP software components and provide solution & architectural recommendations on potential SAP changes.
- Involved requirement gathering and business blueprint with BW-IP, BPC 10.1 /FICO.
- Created a New Applications and applied associated dimensions, defined its properties and managed dimension members.
- Developed Sales Planning and Revenue planning and Cost center and HR Planning .
- Designed and developed multiple Hierarchies in Account Dimension for Chart of accounts and financial statement versions.
- Loaded Actual and Budget data into Finance Application and helped the user’s gain good understanding of Variance analysis capabilities in BPC.
- Working on Planning & Budgeting Business processes - Annual Planning (Sales Planning, Cost Planning, CAPEX Planning, Planned Financial Statements/ Reports P&L, BALANCE Sheet, Cash Flow).
- Worked extensively with BPC Office and utilized the powerful and flexible formulas and functions within BPC reports and input schedules to retrieve, display, and submit data for a real-time view of the financial position of the organization.
- Managed transports between Development, Quality and Production Environments.
Environment: ECC 6.0, BI 7.3 with IP and BPC 10.1 and FICO
Confidential, San Jose, CA
SAP EPM /BPC10.0 With FICO& BW/BO Architecture (SME)
Responsibilities:
- Owner for Application development technical architecture processes. Provide process training to development team.
- Provide detailed estimates for projects for design and development. Validate estimates from consultants.
- Provide expertise with SAP data architecture integration with SAP and Non SAP technologies and enforce interface standards.
- Worked with Cross function application and provide the security with in Management group.
- Implementation of activity-based cost accounting models and profitability analyses using approaches such as activity-based costing and time driven and activity-based costing
- Working with HCM and Sale, Revenue, Cash flow Planning Templates
- Understand business process and scheduled the meeting with stakeholders determines cost of operations by establishing standard costs models; collecting operational data.
- Prepares, reviews, and develop the BPC actual, forecasted, and budgeted financial results utilized by regional and global business management in decision-making processes for the business areas.
- Support SAP BPC end to end security and meeting Data security requirements.
- Worked with different planning inputs templates B&S, P&L, Sales, Cost center, HR .
- Improves financial status by analysing results; monitoring variances; identifying trends; recommending actions to management working on through BPC Dashboards.
- Design and development the business requirements with technical concept and provide the power users.
- Designed interfaces to extract actual data from ECC/BW cube to BPC model which is required for various reporting and developed security profiles, roles and teams.
- Worked with Finance users and provided training and support in creating EPM 10.0 reports and input schedules, Maintenance of master data, loading actual, coping data from one category to another, setting environments etc.
Environment: ECC 6.0, BI 7.0, 7.3 and BPC 7.5 and 10.0 NW,HANA
Confidential
Senior SAP BOFC& BPC Consolidation Lead
Responsibilities:
- Keep abreast of developments in the SAP-EPM space, including BOFC & BPC & BOBJ, and develop roadmap to further benefit from the new features and capabilities.
- Provide thought leadership in guiding the business and technology teams on the emerging trends in SAP-BPC and in reporting.
- Work collaboratively with the Architectural services team in designing a scalable, sustainable and adaptable solution using SAP-BPC &FI/ BI With SAP BO.
- Design, develop and support solutions built on SAP-BPC and BW platforms
- Convert & map business requirements to BPC actionable build items
- Work closely with the business in understanding and translate requirements to actionable build items for SAP-BOFC.
- Collaborate with other teams as necessary including; PMO, Architectural Services, Compliance and Testing.
- Educate the business and IT teams on how best to leverage SAP-BOFC
- Conducting workshops for gathering planning and reporting requirement for Sales planning, HCM planning, Finance.
- Designed and implemented 18 month rolling forecasting process, assuring consistent communication and utilization of planning assumptions among all regions. Designed and implemented quarterly and yearly Strategic Planning process. Designed and implemented P&L, Balance sheet and Cash flow input schedules.
- Design and developing SAP FC security tasks profile and data access profile .
- Designed and developed security profiles, roles and teams
- Designed and developed multiple Hierarchies in Account Dimension for Chart of accounts and financial statement versions.
- Loaded Actual and Budget data into Finance Application and helped the user’s gain good understanding of Variance analysis capabilities in BPC.
- Developed Sales and Manufacturing, Finance and Profit Data modelling, Application set and Application at SAP BPC.
- SAP BPC Consolidation Process Monitoring, Rate and Scope Definition .
- Design and configuration experience for intercompany booking, allocations, reporting.
Environment: ECC 6.0, BI 7.0, FICO,MM, PP,SD,CRM,SCM and BPC NW 10.0
Confidential
Senior SAP BPC Consolidation Lead
Responsibilities:
- Worked Strategy of Master Data, Data Governance/Standardization, Master Data Process Design, High Level SAP BPC Architecture and the Implementation Roadmap defined by the business case.
- Created a New Application Set and applied associated dimensions, defined its properties and managed dimension members.
- Quality proposal preparation and presentation with minimum turnaround time.
- Assist in developing Marketing collateral, case studies, brochures etc.
- Extensively Provided the SAP BPC NW Conceptual, Logical and Physical Data Model and Relational and Master Data Model.
- Created SAP BPC NW Data Models, Application Set Dimensions, Properties and Application
- Responsible for gathering the requirements, preparing the Business process procedures, Configuration and creating the test scripts for Data Migration.
- Created Custom Process Chain to handle appends records for BPC cube.
Environment: ECC 6.0, FICO, MM, SD, QM, BI 7.0 and BPC NW
Confidential
Senior SAP BPC MS 7.5 Consultant
Responsibilities:
- Involved in creating application set, dimensions and applications.
- Prepared technical specifications using functional requirements for BI and ABAP.
- Created data extractions programs from Info cube and custom table’s.
- Created Custom tables and upload program’s to load the data to custom tables.
- Developed Input Schedules and Reports and SSIS packages.
- Involved in Currency Translations.
- Created Process chains for automation.
- Security settings - Member Access profiles, Task Profiles.
- Data Manager Functionality and loading data using data manager packages.
Environment: ECC 6.0, FICO, PS, MM, PP BI 7.0 and BPC 7.5 MS