PROFESSIONAL SUMMARY:

• Senior SAP BPC Consultant with 12+ years of experience in BPC and adept at designing, implementing, customizing, supporting, upgrading, and migrating reports, input schedules and environments.
• Well versed in Planning, Budgeting, Forecasting, and Consolidation (both Legal and Management Reporting) for SAP BPC 10.1 Standard and Embedded models.
• Experienced SAP consultant with the ability to lead a team of BPC consultants.
• Technical expertise of SAP: BPC, HANA, BW, and Security.SAP BPC:
• Experience with BPC 10.1, BW 7.4 and HANA connectivity including definition and Configuration of Dimensions, Dimension Members, Properties, and Models.
• Working knowledge of Logic Script development, Member Formulas, Local members, Data Manager Packages, Package Links, as well as transformation and conversion files for data loads.
• Hands on experience in developing functional models like CAPEX, Head Count planning, Sales planning, and Forecast Planning.
• Automation of Master data and transactional data uploads from BW/ECC to BPC using standard DM packages.
• Expert experience in developing Reports, Input Schedules, custom logic scripts, Excel VBA/Macros, correct usage of BPC EPM functions.
• Supporting month, quarter, and year end process automation by using Business Process Flows to facilitate users' closing and reporting activities.
• Configured work status for locking/unlocking of transaction data after business has approved the plan/forecast version.
• Script logic programming for currency conversions, inter - company eliminations, security set up (task profile, data access profiles, users, and teams), work status settings, Business Process Flows (BPFs).
• Executing the optimization tool including light and full optimization on a given model.
• Creation of dynamic & static reports, nested reports to optimize the reporting capabilities, input schedules for entering data and reports. Experience in user authorizations.SAP HANA:
• Working knowledge on SAP HANA project implementations with both Native HANA and SAP BW on HANA landscapes.
• Worked on Data Modeling, Data Provisioning, Reporting, Security, and Authorization aspects of SAP HANA 1.0.
• Experience on HANA Modeling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, and Analytical Privileges.
• Experience in migrating the Standard DSO and Info Cube to HANA Optimized DSO and Info Cubes.
• Experience in Importing BW models (Info Cube, DSO) in HANA as Analytical views.
• Experience in Data-Provisioning techniques using SLT (SAP Landscape).
• Transformation to perform real-time data replication into SAP HANA and real-time data loading into HANA using SAP BODS.
• Experience in Configuring and Consuming SAP HANA models in BI clients such as Predictive Analysis, Business Objects Explorer, and MS Excel.SAP BW:
• Experienced in designing and maintaining data targets such as; Info Objects, DSO, Info cubes, Virtual Provider, Hybrid Providers, and Multi Providers.
• Strong experience in BW 3.x and BI 7.x versions upgrades (technical and functional).
• Strong experiences in installing the Standard Business Content objects and enhance them into custom objects based on the business requirements.
• Worked on BW support project activities (data loading & monitoring and troubleshooting their failures).
• Experience in system maintenance tasks (Delta queue cleaning, Setup table deletion & validation).
• BW loads automation through process chains.
• Worked extensively in SD, MM, PP, and FICO Modules.
• Strong in performance tuning (Data loading and BEX reports) and job failure reduction activities.
• BW Modeling - Requirement gathering, translating the requirements into BW specific mapping, analyzing existing business processes, and specifying design.
• Strong experience in Info Cube (Real-Time Cubes, Basic cubes, Multi-cubes) design, InfoSources, InfoObject maintenance.
• Experience in creation of master data and transaction data sources by using views/tables & SAP Queries, Data source Enhancements, variable exits for BEx reports & routines in update rules and transfer rules as per client requirement.
• Reporting authorizations, authorization objects & roles. Skills to write routines as per design & debug the ABAP routines.
• Customizing using of variables, various planning functions. Process chain maintenance for day today schedules.SAP Security:
• SAP BPC creation of Task Profiles, Member Access Profiles, and assigning write/ read access to Users and Teams.
• Working knowledge of SAP BPC Work Status settings and Business Process Flow templates creation.
• SAP HANA experience in providing security restrictions on models using Analytic Privileges and assigning to Authorization roles for different types of users.
• Maintenance and set up of Security roles and objects, as well as, the creation of transports and collection of objects from BW to BPC.

TECHNICAL SKILLS:

ERP Packages: SAP Net Weaver 2004s, SAP R/3 4.6,4.7, ECC 6.0

SAP Modules: SAP BI 7.0, BW 3.X, SAP BPC NW, BI related ABAP SAP Business Objects XI R 3.1 & 4.0, SAP HANA Studio

Reporting Tools: BPC EPM ADD-in, FIORI, BEx Query Designer, BEx Analyzer, Workbooks, Web Application Designer, Crystal Reports, XCelsius, WEBI

Functional Module: Logistics (SD, MM), FI (AP, AR, GL)

Programming Languages/Scripts: ABAP, Script Logic, FOX Code, VBA, PL/SQL, C++, Java, .NET, HTML

Databases: SAP HANA DB, HANA STUDIO, HANA LIVE, FIORI, SAP BI/BW Workbench, SQL Server, MS Analysis Services, SSIS, SSRS, Oracle, TERADATA, SYBASE, ESSBASE, TM1

PROFESSIONAL EXPERIENCE:

Confidential - Brooklyn, NY

Sr. SAP BPC Consultant

Responsibilities:

• Business Requirement gathering, and Blueprint preparation and presentation.
• Model development for the financial planning process.
• Input Schedule and Report design with the use of EPM Functions.
• Design of application model and development.
• Data extractions/loading and processing from/to SAP ECC system.
• Build EPM Reports as per user requirements (building complex reports with Macros to perform EPM functions, Copy range Functions).
• Formatting of the Reports using the standard BPC formatting.
• Enhancement to the current system (Reports, Input templates, Distribution of reports) Maintaining Dimensions.
• Reconciliation of the Headcount Data with BO reports and BPC reports.
• Script Logic writing, member formula, dimension aggregation customization for calculations at Model level for reporting requirements.
• Business Process Flow and Business Process Instance Management.
• Task Profile creating and Instance management for Access and Process Initiations.
• Technology of business warehouse (SAP BW), data extraction/retraction from SAP-system and non-SAP system, process chains, data model development, integration.
• Reporting system with SAP BEx Analyzer, BO Web Intelligence.
• Building web application (SAP BEx Web Application Designer).
• Programming skills ABAP, SQL, VBA.
• Creating OLAP Universe (*.UNV, *.UNX). Development of analytical reporting BO WEB.
• Experience in Planning and Budgeting, Management Consolidation, Legal Consolidation System Development, and Implementation.
• Model Design with respect to blue print and requirement analysis.
• Input Schedule and Report design with use of EPM Functions.
• Customizing the Reports, Input Schedules, Logic to meet the specific needs of the client using supported functions with BPC.
• Transformation File, Conversation File and Data Manager Package management and scheduling.
• Data extractions and Processing from BI system.
• Data Loading and Process Testing for Data from BI to BPC.
• Loading transactional data from Info Provider in BW to the BPC Environment using the Data Manager in BPC for Validating and Previewing Data.
• Configuration of Business Rules, Script Logic, and Member Formulas for calculations.

Confidential - King of Prussia, PA

Sr. SAP BPC Developer

Responsibilities:

• Conducted brainstorming sessions to align Planning and consolidation implementation with future S4 Finance system.
• Designed HANA views of ACDOCA & ACDOCC structures and integrate data layer from ECC.
• Built real time info providers and aggregation levels for Exchange rates, Ownership rates and Consolidation data.
• Built Composite providers to consume Historic & ACDOCA data for consolidation.
• Constructed multiple composite providers to ease business user reporting requirements.
• Built reconciliation reports for Currency rates & Master data maintained in ECC tables through virtual providers.
• Designed data flow architecture from source systems JDE/EDW/Work day.
• Structural mapping and conversions of master to BPC.
• Designed scripts to handle Currency conversion without business rules.
• Achieved elaborated reporting capabilities on total number of product units sold based by different packet size through conversion of Product units to Single units.
• Designed script logic - Copy tax account data from No channel to Distributor Entities.
• Automate adjustments for OCNIS (Other Costs not in standard) to the departmental expenses on Quality Assurance/Check.
• Provided EPM Add-in Input schedules/Forms for data collection related to Adjustments/Tax/Depreciations.
• Enhanced User experience on EPM reports for P&L, BS and standard comparative reports through VBA based APIs.
• Supported Financial closure cycles. Maintained integration points. Scheduling planning areas to automate closure activities.
• Prepared Functional and technical specification documents for BCF, Currency translations, IC Eliminations & Consolidation of Investments, Work status, Security & BPF.
• Built business rules and task sequences for Carry forward, Currency translations, Eliminations.
• Achieved retained earnings calculation through account transformation rules.
• Designed logics for computing P&L to RE via Journal Entries by planning functions - FOX scripts.
• 30%-time reduction in closure cycle through simpler, faster, automated controls and validations to check and enforce data consistency at entity level.
• Designed Journal templates, allowing Group Accountants and Controllers to enter adjustments at entity/group level through journals at site.
• Delivered seamless integration of business teams and processes through Business process flows and work status, providing data locks after each financial process.
• Designed input queries in BEX and skull templates for reporting financial statements - Balance sheet, Income statements, Statement of Equity, Cash flows with drill down at PC.
• Built calculated key figures for management reporting.
• Captured consolidation team structure and implemented analysis authorization to restrict users based on their role in reporting system.
• Designed data access profiles and teams to provide User community with right data set and execution authorization level.
• Conducted workshops to demonstrate the reporting features and flexibility for Excel based add-in Analysis for Office.
• Consumed functions, calculations, cell-based formatting, variable passing, filters, conditional formatting to enhance User experience with AO reports and input forms.
• Support work status and reporting issues.

Confidential - Dallas, TX

SAP BPC Consultant

Responsibilities:

• Deployed as SAP BPC Consultant for the Confidential S4 HANA BPC 10.1 Consolidation project.
• Responsible for creating, documenting, and implementing a scalable solution design and implementation plan.
• Provided technical expertise and hands on implementation work during critical project milestones.
• Assisted and/or lead pre-sales activities as needed to develop solution offerings and presentations, and to demonstrate, present and explain services offerings to prospective clients.
• Led the onshore and offshore team to build a consolidated reporting model in BPC 10.1. Configured and implemented Inter-company Eliminations for Revenue, Receivables Payables, Investments, and Capital Accounts.
• Performed hands-on configuration of top-sided adjustments to provide reclassifications and reconciliations across all levels including summary as a separate ledger or category.
• Prepare Consolidated Financial Statements in USGAAP and IFRS.
• Perform SAP BPC 10.0 Planning, Budgeting, and Forecasting with Logic Scripts.
• Perform Intercompany Matching, Booking and Eliminations.
• Create SAP Business Objects Dashboards for clients.
• Monitor and Report Project information.
• Prepare Earned Value Analysis Reports.
• Calculate Cost Variance and Schedule Variances of Projects.
• Preparing materials and videos.
• Create Analytic, Calculation and Attribute views and Decision tables in SAP HANA and use the views to create interactive SAP Business Objects Dashboards and in SAP Lumira.
• Gather and Review Business Requirements.
• Understand Business Needs and Pain Points with the existing systems.
• Perform GAP Analysis and ensure Business needs are covered.
• Create functional and technical specification documents.
• Propose several alternate Design Solutions.
• Troubleshoot existing configurations.
• Streamline Business Processes with SAP BPC BPFs.
• Design the BI systems while ensuring optimal integration between the enterprise systems like ECC, BW, HANA, BPC & BOBJ.
• Co-ordinate Design & Build Workshops.
• Create Dimensions and Models for Budget, Planning, Forecasting & Consolidation functionality.
• Create and Maintain BPC Master Data & Hierarchies.
• Create Reports and Input Schedule Templates.
• Provide application security and maintenance of user profiles and privileges.
• Provide system documentation and end-user s.
• Manage Project & ensure deliverables are met as per plan.
• Set up project review meetings with Business and IT teams.
• Recommend SAP Financial and BI solutions as per client future requirements.
• Ensure SAP Best practices are followed.
• Define SAP HANA Tables and loading data into the tables.
• Create BEX Queries with Formulas, Restricted Key Figure, Calculated Key Figure, Exceptions, Replacement path variables, OLAP Variables and Conditions.
• Create Info cubes and Data store objects after extracting ECC Data -into SAP BW.
• Designed and implemented currency conversion business rule to use appropriate rates for Actuals and to plan all reporting allows for home and local currency.

Confidential

SAP BPC Consultant

Responsibilities:

• Reviewed the different Planning and Forecasting scenarios - Inventory, Manpower, CapEx, OpEx & Revenue planning.
• Analyzed the logic scripts, BADIs, input templates and reports used in rolling forecasts and what-if simulations.
• Observed the data flow within the models, master data maintenance and flat file load of transaction data.
• Maintained dynamic formatting in reports and input templates along with the use of Macros to trigger data manager packages.
• Lead the design, development and support of the enterprise-wide ERP BI/BPC solution as well as providing technical leadership to the SAP BI/BPC development team.
• Shepard intake items that come into the intake process; providing guidance and input to individuals as they move their items through the process.
• Implemented enterprise architecture artifacts, such as target and current state architecture, referential patterns, roadmaps, and technology standards.
• Provide practical knowledge of technical design and solution architecture alternatives and the implications of each approach.
• Provided overall leadership for the technology solution architecture, design, and delivery of the BI/BPC environment including both onshore and offshore.
• Involved in business requirement gathering for Legal and Management consolidation and defining chart of accounts.
• Involved in integration and conversion from Hyperion Planning to SAP BPC.
• Configured the dimension properties sourced from various modules like PS, SD, CRM, HR, and FICO.
• Configured applications for Planning and Budgeting like Projects, Opportunities, Risk Reserves, and Summary.
• Designed templates for G&A planning for employee and cost center based for salaried and non- salaried.
• Used BADI to summarize data from Cost center to Profit center from various applications to summary application.
• Worked with Hyperion Planning templates to perform reconciliation activities with SAP BPC.
• Involved in setting up the process for both Transactional and Master data from ECC to BI to BPC.
• Developed Custom Input Schedules for spreading Cost and Revenue based on Project and calculate Earnings.

Confidential

SAP BPC/BW Consultant

Responsibilities:

• Gathered the requirement for blueprint, build, the consolidation, planning, budgeting, and forecasting functionalities. Maintain connectivity between R/3, BI & BPC systems, extract data from data sources, replicate the Meta data in BI as well as create transformations and data transfer processes to the BI targets and finally load data to data targets.
• Prepared the documentation on the input template and data extraction of consolidation and planning requirement.
• Designed and Developed Dimensions, Applications, Script Logic, and Business Rules required for Budgeting and forecasting solution.
• Created and modified Applications by adding new members and updated dimension properties in applications.
• Optimized various data storage types to compress database improving system responsiveness and performance.
• Worked extensively on Worksheet Logic, Script Logic, Dimension Formulae, and Dynamic scripting.
• Designed and developed Reports using EVDRE and other EV functions.
• Designed and developed Input Schedules using EVDRE and other EV Functions.
• Data management and loading of transaction data to BPC using the data transformation, conversion logic, Master Data loaded to a BPC Dimensions. Validation of data loaded.
• Designed and developed Transformation Files, Conversion Files and Packages required for loading data from Flat files, External systems, and BW system.
• Worked on BPC application architecture, performance enhancement using Light and full optimizations.
• Process chain development to support master data loads from BW to BPC.
• Develop the planning and consolidation reports using the BPC reporting services and EVDRE.
• Developed Macros using VB script in reports & input schedules to trigger BPC functions using MNU commands.
• Developed reports using functionalities like page key range, col key range, Expand range table in EVDRE function.
• Participated in the daily meetings with the on-site coordinator to discuss the deliverables. Involved in workshops for requirement gathering and prepared the design document.
• Prepared the business user manual.

Environment: SAP BW7.3, SAP BPC 7.5 Net Weaver, ECC 6.0, ABAP Development workbench, BEX analyzer/Browser.

Confidential

SAP BW Consultant

Responsibilities:

• Involved in gathering user requirements, design, and development and testing of data models for Logistics.
• Worked on administrator workbench, and customized Info Objects, Info Sources and created Info Cubes by loading data based on Transformations.
• Involved in performance tuning while reporting and data loading.
• Involved in modeling the dimensions of cubes.
• Involved in Business Content installation of Data Sources and Info Cubes and all related objects.
• Involved in query performance tuning using tools such as RSRT (Query Performance Monitor), RSRTRACE etc. and other transactions such as ST03.
• Developed Multi providers to enhance reporting performance and flexibility.
• Performed Enhancements to SAP delivered data sources using SMOD transaction.
• Extracted user defined Database tables, Views on Sales, Delivery, and Customer tables from R/3 system using Generic Extraction.
• Involved in Logistics Extraction and COPA Extraction for profitability analysis.
• Implemented Generic Extraction for user defined tables.
• Loading data from the flat files on daily basis.
• Populated DSO Objects Info Cubes and Info Objects with Master and Transactional data from SAP R/3 via Data Staging area (PSA).
• Increased performance tuning by maintaining aggregates and Info cube partitioning.
• Developed process chains to automate the data loading process.
• Developed Logistics reports for Sales, Open orders, Order Fulfilment, Incoming orders etc.

Environment: SAP BI 7.0 Net Weaver, ECC 6.0, ABAP, BEX analyzer/Browser, SD & MM.

Confidential

SAP BW Consultant

Responsibilities:

• Designed and Created estimation model for BW implementation based on the scope of the requirements and prepared technical specification documents.
• Performed requirement gathering, data modeling, plan/scheduling data input from source systems, interface with users for standard reports, gap analysis, and associated solutions.
• Worked with Business Users and Functional teams during JAD sessions and assessing the work based on SAP best practices.
• Lead the process and developed flows in the areas of OTC for service metrics, open orders, and overall sales view reports.
• Was involved in upgrade from BW 3.5 to 7.0 and solving the issues that arise during upgrade.
• Designed and Developed Inventory Management report by integrating data from MM, SD, P2P and APO.
• Designed and developed the Global spend application to manage category of spend using Purchasing and accounts payable (AP).
• Designed and developed Freight payment application as business need to track freight invoice detail information for analytics using Accounts Payable (AP) and Transportation.
• Designed the flow for calculating the average selling price based on the sales view of customer/material and consensus demand, Forecast Accuracy, Dollarized Forecast, VMI Performance, etc. from APO.
• Creating business blueprint for the financial planning and forecasting for the different brands.
• Assistance in the installation of SEM 3.2B on an existing BW 3.1C system.
• Design, configure and develop expense, sales, inventory, and P&L planning cubes (transactional cubes).
• Develop Planning areas using the SEM cubes for Plan and BW basic cubes for Actuals.
• BCS to consolidate financial data for statutory and management reports.
• Responsible for support and enhancing BCS module.
• Create multi-planning area to integrate expense, sales, and P&L planning areas.
• Create multiple planning levels and packages in both single and multi planning areas to suit the Business requirements.
• Provided and user acceptance sessions as well as documentation.
• Created Custom Universe objects using Business Objects (BO) based on reporting requirements.
• Created Live Office Document based on WebI document and importing to Xcelsius.
• Created dashboards using Xcelsius for PNL report to provide overall sales by division.
• Developed complex queries and formatted them in Crystal Report and published then in CMC.
• Involved mainly in design phase of the project for implementing SAP BW FI module & BPS.
• Responsible for SEM BPS development for custom developed Planning Areas for Sales Merchandize. Used FOX and ABAP for complex planning functions involved.
• Proficiency in the areas of data modeling, extractions gathering requirements from the users, creating reports with BEx, Web Reporting, Performance issues, data loads, process chains, support, and user .
• Used standard and created generic data sources for building Cubes/ODS for GL, Cost Center Accounting (CCA), Special Purpose Ledger and Profit Center Accounting (PCA).
• Created complex BEx queries based on the user requirements showing the Balance sheet and Income Statement by using advanced features of the query development.
• Build complex Crystal Reports based on the multiple dynamic hierarchies to provide the dynamic functionality to the users.

Environment: SAP R/3, SCM, SD, WM, MM, P2P, FI-AP, APO, BW 3.1/3.5/7.0 & BO, FI/CO, and SEM BPS