| Candidate Information | | Title | Supply Chain Business Process | | Target Location | US-NY-White Plains |
| | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateSenior SAP Consultant in SAP BPC, IBP, BW, SAP S/4 HANA, Group ReportingExperience includes Senior Consultant to Lead Architect/ Architect roles with over 15 years professional experience, including approximately 15+ full life-cycle implementations including multiple projects at various stages. Highly skilled Project Lead directing business process re-engineering, configuration, and training. Focused on providing leadership and direction to SAP finance and Supply Chain implementations teams and resolving technical and business process issues. Industry experience includes Manufacturing, Pharmaceutical, Mining and Utilities, Retail, Consumer Goods, Biopharma, and more. Strong management and leadership skills, with ability to motivate professionals and maximize business benefits, excellent communicator, with emphasis on building strong client and internal relationships.Education:Doctoral Degree in Engineering/Finance University of IowaInvestment Banking Specialization London Business School UKPrivate Equity Specialization University of Oxford UKSAP Press Author for CO-PA, CPM, SAP S/4 HANA, Cloud.SAP Financials Expert Magazine Author.Master Degree in Finance and Engineering, Costa Rica Institute of TechnologyBachelor Degree, Finance Costa Rica Institute of TechnologyProfessional ExperienceRetail Americas, Europe,Jan 2023- PresentSAP IBP Consultant (Demand, Inventory, S&OP, Demand Sensing)Inventory Optimization, and model building to manage safety stock levels per warehouse, and distribution centers per product.Product Life cycle planning, and forecast optimization.Template development using both SAP IBP Analytic Stories and MS Excel environment.Advanced Forecasting models development, currently my models manage and forecast 2 billion usd per year in sales revenue using machine learning algorithms, implementation of probabilistic supply chain, model optimization by category and product types, and forecasting optimization by channels, product types, product groups, and model accuracy improvement over 200% for seasonal and non-seasonal products.Scenario development for Demand planning.Creation of Key Figures, Master Data Attributes, and Model Building, and Master Data Types, Planning Operators, Planning Areas.Creation of Forecast Models and validation, ABC/XYZ Segmentation, and Planning, Lag-Based Snapshots, Revenue Planning and Cost Planning.Key Figures calculations, and revision. OSS resolution with SAP, model adjustments, Promotion Sales Uplift Configuration.Creation of Reports and Views, and master data maintenance with the MS Excel environment of IBP.Retail and Manufacturing, Americas, Europe, Asia and Latin AmericaJan 2021- Jan 2023SAP IBP Consultant (Demand, Inventory, S&OP, Demand Sensing)Configuration of User Management and Authorizations.Job configuration and scheduling, and performance and utilization improvement.Data validation and build of CPI-DS interface for both master data and transaction data from APO/BW/SAP ECC for Sales Order Quantity, Sales Order Revenue, and Master data for Location, Customer, and Products.Creation of Key Figures, Master Data Attributes, and Model Building, and Master Data Types, Planning Operators, Planning Areas.Creation of Forecast Models and validation, ABC/XYZ Segmentation, and Planning, Lag-Based Snapshots, Revenue Planning and Cost Planning.Key Figures calculations, and revision. OSS resolution with SAP, model adjustments, Promotion Sales Uplift Configuration.Creation of Reports and Views, and master data maintenance with the MS Excel environment of IBP.Management of Inventory Optimization, capacity constraints at the plant, location, and distribution center level.Revenue snapshots management and calculations, and variance analysis reports for COGS, Customer Revenue, Customer Group.SAP MM Consumption-Based Planning (MM-CBP), PurchasingInventory Management, Material and Customer Master.Sales and Distribution (SD)Management of Statistical Models at the finished product and component level.Utility Northeast, USAJan 2020- Dec2021SAP IBP Architect and Financial Transformation Lead (Demand, Inventory, S&OP, SAC, and Group Reporting)Development of composite providers.AO Reporting and customization using extensive MS Excel VBA programming and SAP BPC VBA programming.SAP BPC Embedded, building ADSOs, Info Cubes, working with the new IBP/BPC Interface using ADSos for flat file upload.Performing IBP data validation, Inventory and Demand Planning, Aggregation and Top down planning, and Scenario Modeling.Working with Demand Review for Sales Forecast, Marketing Forecast, Annual Operating Plan, and Create Demand Plan as part of the Demand Planning Module, Working with Safey Stock levels, and Dashboarding of Time Series, Setting up Inventory Plans, and Review Capacity limitations.Working with Embedded Fox Code and calculations.Configuration and migration of Integrated Planning (IBP) in 10.1 BPC, and Demand Sensing, Driver-Based Planning, Inventory Planning and Optimization, and statistical Forecasting, Constrained and Unconstrained Supply Planning for Supplier and Inventory Management, Supply Time Series Heuristics. Working with Demand Planning and Demand Sensing to 8 weeks demand planning by Sales Order level.Top down and Bottom-UP Forecasting using IBP functionality, and integrated into Analysis for Office (AO) creation of Planning Sequences, Aggregation Levels, Planning Functions, Info Providers, and BEx Queries.Reporting and consolidation un ACDOCA, ACDOCP, ACDOCU.Working with Data Monitor and Consolidation Monitor, Manual Postings, Interunit Consolidation.SAP MM Logistics Invoice Verification GR/IR Account Maintenance, Pricing Conditions, Material Price Change,Sales and Distribution, Credit Risk Management, Material Sorting, Pricing Conditions, Transportation, Reports and Analyses, Output Determination.Migration from BPC Consolidation standard to Group ReportingData Validation, creation of Rule-Based Reports, Local Reports and Group Reports.Building SAP BPC Models in ACDOCP in alignment with Group Reporting Versions.Currency Translation using BPC Embedded and Standard, Sales Planning, Operations, Finance, HR Headcount, Salary, Wages, Labor Calculations, Overhead distributions, seasonality design for material demand adjustments, Financial planning by SBU and Material Review, Cost of Goods Sold, Cost of Sales, P&L, B/S reporting, Cash Flow by Transaction Type.BiopharmaBiotech and Pharmaceutical Client, Global Deployment Europe, Asia, AmericasNorth East, USASAP BPC/IBP Consultant with HANA Architect)Jan-2019- to Dec 2019SAP BPC 10.1 on HANA 1809 with BW4 with SAP ECC S/4Financial Statements development using composite providers.AO Reporting and customization using extensive MS Excel VBA programming and SAP BPC VBA programming.Response and Supply with Supply Review Optimizer and simulation mode, and Supply Plan DashboardGathering and Cleansing historical data, running statistical forecasting, and reviewing forecast quality.Analyzing Mid-Term Forecasting, Local Demand Plan Based on Market Insights, Checking alerts for Global Demand Planner, Creating Global Demand PlanAnalyzing Forecast for Segment.Focused on Financial Reporting, Consolidation and Financial Planning.SAP BPC Embedded, building ADSOs, Info Cubes, working with the new IBP/BPC Interface using ADSos for flat file upload.Deployment using SAP MS Analysis for Office 2.7, SAP BPC 10.1Integration with new consolidation tool from SAP Group Reporting for plan data.Performing IBP Scenario Modeling, creating Dashboards, Calculation of Sales and Demand Forecasts and Inventory Management, Developing and implementing Materials Planning by SKUs and Product Family.Working with Inventory and Demand Planning to calculate capacity limitations, Forecasting time Series, and Dashboarding in SAP SAC.SAP IBP configuration and update of planning levels, Attributes, Master Data, hierarchy, in SAP BI/SAP IBP.Create Embedded S/4 Calculated KPIs and Key Figures and reported using HANA Views and AO Reports for Planning and Consolidation.Working with Cost Center Planning, Workforce Planning, Financial Planning Balance Sheet, P&L, Intercompany; Capital Projects, data conversion to third party reporting using BPC VBA.Work Status, and Business Process Flows using HANA Embedded functionality.Aggregation Levels, Composite Providers, ADSOs, SAP BW Tools for HANA 1709, BEx Queries for BPC Planning, Workbooks, VBA code for BPC, Planning Functions.Top down and Bottom-UP Forecasting using IBP functionality, and integrated into Analysis for Office (AO) creation of Planning Sequences, Aggregation Levels, Planning Functions, Info Providers ADSOs, and BEx Queries.Working with SOLMAN (Solution Manager), and QC Vera for Testing, and deployment, Supply Chain heuristics Unconstrained and Constrained Supply Planning, and Demand Planning, Configuration of Demand Sensing.Working with Embedded Fox Code and calculations.Fiori Tile deployment of AO Workbooks, and end-user testing and training.Currency Translation using BPC Embedded and Standard, Sales Planning, Operations, Finance, HR Headcount, Salary, Wages, Labor Calculations, Overhead distributions, seasonality design for material demand adjustments, Financial planning by SBU and Material Review, Cost of Goods Sold, Cost of Sales, P&L, B/S reporting, Cash Flow by Transaction Type.Semiconductor (Konica Minolta)Manufacturing Client, global Deployment Europe, Americas, and AsiaNorth East, USAImplementation and Financial Transformation Lead (BPC Embedded/Standard/HANA Architect)SAP BPC 10.1/11 on HANA 1709 with BW4 with SAP ECC S/4, and current migration to SAP BPC 11.March 2017-Jan 2019IBP for Inventory Planning with Scenarios, safety stock calculations, Running Operators, and Demand/Supply balancing.Focused on Financial Reporting, Consolidation and Financial Planning.SAP BPC Embedded, HANA optimized, and Standard BPC Versions in NW, and also previous experience working with SAP BPC MS versions.Global Deployments in different Continents in both Planning and consolidation.Deployment of Analysis for Office and EPM Add-In for Embedded Model of BPC,and migration to SAP HANA Optimized in progress.Deployment using SAP MS Analysis for Office 2.7, SAP BPC 10.1 and SAP BPC 11.SAP BPC Security on SAP BW, Test Scripts, Training, Citrix Deployment using BOBJ Data Repository.Working with FOX Code formulas and SAP BPC Embedded, building ADSOs, Info Cubes, working with the new IBP/BPC Interface using ADSos for flat file upload.Transformation, Conversion and Loading files, and G/L Account conversion and migration using Flat Files and reading SAP BI Info Cubes.VBA and BPC customizations for dropdowns, save, prompts, complex calculations for labor and capital, multiple selections, queries with multiple selection of merge variables, complex workbooks, with multiple aggregation levels, copy functions.IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports.Aggregation Levels, Composite Providers, ADSOs, SAP BW Tools for HANA 1709, BEx Queries for BPC Planning, Workbooks, VBA code for BPC, Planning Functions.Currency Translation using BPC Embedded and Standard, Sales Planning, Operations, Finance, HR Headcount, Salary, Wages, Labor Calculations, Overhead distributions, seasonality design for material demand adjustments, Financial planning by SBU and Material Review, Cost of Goods Sold, Cost of Sales, P&L, B/S reporting, and architecture design and integration with Japanese Operations.SAP BW DTPs, Data Transformations, Mappings, conversions.Kao Group,Manufacturing Client, global Deployment Europe, Americas, and AsiaUSA, Midwest and NortheastImplementation and Financial Transformation Lead (EPM/HANA Architect)SAP EPM 10.0/SAP BPC 10.1 on HANA with BW4 with SAP ECC S/4.March 2015-March 2017Focused on Financial Reporting, Consolidation and Financial Planning.SAP BPC Embedded, HANA optimized, and Standard BPC Versions in NW, and also previous experience working with SAP BPC MS versions.Global Deployments in different Continents in both Planning and consolidation.Deployment of Analysis for Office and EPM Add-In for Embedded Model of BPC.Migration of SAP BW Tax data to SAP HANA and included as part of the SAPTransformation, Conversion and Loading files, and G/L Account conversion and migration using Flat Files and reading SAP BI Info Cubes.IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports.Reporting, Consolidation and Planning.Revenue Planning, Operational Expenses, Capital Projects, Treasury, Legal and Managerial Consolidation, Investments: short-term and long-term debt, Balance Sheet Planning, Income Statement, and others.Planning and Consolidation project, with global training in different locations onsite in Europe and USA.Development of BEx queries, workbooks, key figures and variables, DTS, QDPs, Info Providers, ODS, Composite Providers, Info Cubes, Multicubes.Reports using Crystal Reports, Dashboards, WEBI, Analysis for Office, and direct connection of MS Excel to HANA platform.HANA migration and enhancement of reporting:oUpdate of S/4 HANA Reporting using BOBJ, Crystal Reports, and Web Intelligence.oUpdate of SAP HANA from SP06 to SP12 for Graphical Views.oWorking with SAP HANA security and Analytic PrivilegesoCreating and enhancing Analytic, Attribute, and Calculation Views for BOBJ4 reporting using Universes.oCreating customized calculations using SQL, Calculation Engine and SAP HANA Expression Editor.oCreating Decision Tables for Sales Analysis and DiscountsoReplicating SAP ECC tables into HANA, and enhancing and combining SAP BW cubes (migrated to SAP HANA) and Third-Party sources into the same Calculation views.oCreating Input Parameters and calculated values on the fly.oTransporting SAPHANA objects between systems.oIntegration with SAP BPC for master data on the fly replication from SAP ECC, and alignment with the SAP EPM Embedded model.oMigration of SAP EPM 10 to 10.1 on HANA objects.oReplicating SAP ECC data into HANA and exporting into SAP BW for reporting.oData provisioning replicating SAP ECC data into HANA using SLT, and working with BW on HANA to enhance BW cube information and combine it with HANA Calculation Views.oWorking with Analytical Views Join, Aggregation, Projection, and Union for SAP and Non-SAP data.oExtensive reporting using the Universal Journal and ACDOCA to combine analysis of CO-PA, Assets, FI, CO, and Statistical Journals in order to provide real time financial reporting.Xcel Energy, AccentureEnergy and Utility, Midwest, Minneapolis AccentureImplementation and Financial TransformationSAP BPC NW 10.1 Lead/with HANA integrationJan 2015- March 2015Focused on Financial Reporting, Consolidation and Financial Planning.SAP BPC Embedded, HANA optimized, and Standard BPC Versions in NWSAP BPC Blueprinting process and Financial Specs.BW architecture and data flow designCreation of Models, initial reports, and cash flow process design.Transformation, Conversion and Loading files, and G/L Account conversion and migration using Flat Files and reading SAP BI Info Cubes.IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports.Reporting, Consolidation and Planning.Revenue Planning, Operational Expenses, Capital Projects, Treasury, Legal and Managerial Consolidation, Investments: short-term and long-term debt, Balance Sheet Planning, Income Statement, and others.National GridEnergy and Utility, Deployment to USA and International OperationsUSA, NortheastImplementation and Financial TransformationSAP BPC NW 7.5/SAP BPC 10.1 Lead/with HANA integrationApril 2011-Jan 2015SAP HANA design and migration from previous SAP BPC 7.x platform to SAP BPC 10.1, to migration and conversion to SAP HANA.Development of SAP BW cubes for Tax data, and migration into SAP HANA.Conversion and redesign of SAP extractors based on SAP Simple Finance, and the requirements changes for S/4 HANA.Development of Analytical Views, tables, Attribute Views, Calculated Views.Working with SLQ Script and Projections in data merging of views for Actual and PBF data.BPF: definition of process templates, activities, activity performers and activity reviewers, working and configuring process instances and tasks. Deploy Hyper Links for Planning and Consolidation scenarios, and as part of month-end closing. Working with Actions after expirations and deadlines, and linking BPFs with Work Status updates, and deployment and trouble shooting. Setting up Reviewers and Owners logic following BPC security. Attaching Data Management Packages, Reports, Input Templates, to improve and control and monitor the planning and consolidation process for year end.Modeling of HANA Live Views and reporting based on customized HANA models in SAP BO Web Intelligence and SAP Lumira and analyzing in IPad (mobile devices).Working with SAP Business Suite on HANA with predefined HANA Live views and creating real time operational report based on HANA views.Integration with SAP BPC EPM10 and SAP S/4 HANA with Simply Finance Implementation.Working and developing Private Views, Reuse Views, and Query Views.Reporting using SAP Lumira, Universe Designer, Bex queries, and Crystal Reports.Data modeling and ETL design integration with BW, SAP EPM 10 and HANA using SAP and non-SAP data sources.SAP BPC NW 10 and 10.1 upgrade preparation activities due to improvements in functionality, and improved stability in the system performance.Blueprinting and requirements gathering. Interaction with Planning, Consolidation, Forecasting, and Consolidation.Security Roles, Task profiles, and User Security.Migration of legacy systems into SAP BPC NW 7.5 Planning, Budgeting, Forecasting, and Consolidation, preparation to migration for SAP BPC NW 10.Allocations, custom script logic, Dynamic Parameters, and lead role of BADI development for burdening, allocation, and distributions.Finance model design for Cost Center/WBS/and Orders.Lead Architect, Blueprinting, Assessment, training, and deployment to include Consolidation and Management Reporting environment.Integration of SAP BI/ SAP ECC, Inbound and Outbound legacy systems such as UI Planner, Hyperion, Reval, Power Plant.Focused on Financial Reporting, Consolidation and Financial Planning.Migration of financial reporting from Legacy into SAP BPC NW 7.5/BPC NW 10Transformation, Conversion and Loading files, and G/L Account conversion and migration using Flat Files and reading SAP BI Info Cubes.IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports.Revenue Planning, Operational Expenses, Capital Projects, Treasury, Legal and Managerial Consolidation, Regulatory Reporting (FERC), Investments: short-term and long-term debt, Balance Sheet Planning, Cash Flow, Income Statement, and others.Dual Reporting in US GAAP, IFRS, and Common Accounts.Development of SAP BI Cubes, Transformation, Loading, Financial and Operational transactional data extraction.MerckGlobal Pharmaceutical ConglomerateNortheastSAP BPC NW Lead and Migration from SAP BPC 5.1 to SAP BPC NW 7.5Oct-2010 until March 2011Migration of financial reporting from Legacy and SAP BPC 5.1 to SAP BPC NW 7.5.Transformation, Conversion and Loading files, and G/L Account conversion and migration using Flat Files and reading SAP BI Info Cubes.BPF: working with Instances, Tasks, and process definition and interaction with Work Status flow. Modification of user interface to incorporate BPFs as a simple and direct solution to simplify both the planning and consolidation process.Script Logic development of custom programs.IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports.Assessment, Blueprinting, and migration path from SAP BPC 5.1 to SAP BPC NWHierarchies, G/L account groups, SQL updates to SAP BPC 5.1 database commands, and SAP BPC NW 7.5 upload, transformation, and loading.Reports, EVDRE, report migration from SAP BPC 5.1 to SAP BPC NW 7.5.Journal Entries, and top side adjustmentsCurrency translation and adjustmentsConsolidation, Budgeting, Forecasting, and Planning.Integration with third party systems and migration design to SAP ECC and SAP BICapital Expenditures (CAPEX), Operational Expenditures (OPEX), Production Planning (PROD), Overhead and Cost Center Planning, Rolling Forecast.IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports.Income Statement, Balance Sheet, Cash Flow design for SAP ECC and EVDREs.Down ChemicalChemical Global ConglomerateNorth CarolinaSAP BPC Lead for Global DeploymentMarch 2010-Sept 2010SAP BPC NW 7.5 upgrade due to improvements in functionality, and improved stability in the system performance from SAP BPC NW 7.0.Lead Architect, Blueprinting, Assessment, training, and deployment for 40 business units in 30 countries, to include Consolidation and Management Reporting environment.Focused on Financial Reporting, Consolidation and Financial Planning.Complete migration of financial reporting using Business Objects and SAP BPC from legacy environment with reports such as: Shareholders Equity, Cash Flows, Income Statements, Balance Sheet, Intercompany, Budgets, Statement of Operations with monthly, variance, and YTD values, Management Reporting, Profit and Cost Centers, using Period and Calendar Reporting and others.Transformation, Conversion and Loading files, and G/L Account conversion and migration using Flat Files and reading SAP BI Info Cubes.Development of input schedules, templates, DTS packages, upload and download programs, scripts, EVDRE Reports and Dynamic templates, Application Sets, property and member maintenance.IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports.Capital Expenditures (CAPEX), Operational Expenditures (OPEX), Production Planning (PROD), Overhead and Cost Center Planning, Rolling Forecast.Transition from a multiGAAP to a IFRS as secondary reporting applying adjustments to the base data automatically to allow the dual reporting and changes stored in the same application set.Development of SAP BI Cubes, Transformation, Loading, Financial and Operational transactional data extraction.Currency Translation Adjustments (CTA) and interaction with Ernst & Young, and Deloitte as internal and external auditors to match their recommendation on financial reporting, due to the current limitations of their different Legacy Systems on financial visibility, accuracy, and transparency.Murray EnergyMining, Exploration, and Energy ClientOhio, USA, Coal and Natural GasSAP BPC/ Business Objects Corporate Lead ArchitectSept 2009- March 2010Budget Planning and Consolidation SAP BPC 7.0 SP04Lead Architect, Blueprinting, Assessment, training, and deployment for 60 business units in the mining, exploration, and coal extraction.Focused on Financial Reporting, Consolidation and Financial Planning.Sales and Operational Planning (SOP) and using SAP CRM extractors using trade promotion management (TPM), Bdocs, and SAP BW Adapter.Complete migration of financial reporting using Business Objects and SAP BPC from legacy environment with reports such as: Shareholders Equity, Cash Flows, Income Statements, Balance Sheet, Intercompany, Budgets, Statistical Key Figure reporting, Statement of Operations with monthly, variance, and YTD values, Sales and Cost Planning by G/L Account, Profit and Cost Centers, and others.Transformation, Conversion and Loading files, and G/L Account conversion and migration.Financial and Operational Planning, which includes CAPEX, OPEX, Revenue Planning, and Cost Center Planning.Development of input schedules, templates, DTS packages, upload and download programs, scripts, EVDRE Reports and Dynamic templates, Application Sets, property and member maintenance.IFRS/US GAAP dual reporting formats and migration of chart of accounts, and reports. Working on US GAAP Joint Venture reporting and IFRS modifications for revenue recognition, capitalization of intangible assets, inventory valuation, and service contracts based on percentage of completion basis.Transition from a multiGAAP to a IFRS as secondary reporting applying adjustments to the base data automatically to allow the dual reporting and changes stored in the same application set.Development of SAP BI Cubes, Transformation, Loading, Financial and Operational transactional data extraction.Development of Business Objects Universes, Xcelsius Dashboards, and Web Intelligence Reports. Queries and architecture design from SAP BI Cubes and BEx reports, Slice and Dice, Cross-Tab and Tabular Views, Tree Control, Data Provider Viewer, Hierarchies, Attributes, Universe Designer, Web Intelligence Reports with Time Dependencies, Single Sign On, reports and subreports in Crystal.Security, teams, roles, user ids, SAP BPC Web, BPC Excel, Word and PowerPoint interfaces.Design and Accessing BOBJ Universes from BI, Xcelsius, Query as a Web Service, Crystal Reports, Web Intelligence.BHP BillitonSAP BI/BPC 7.0 SP03 Global Lead ArchitectSingapore, Southeast Asia, Global Energy Resources and Oil ClientMar, 2009-Sep, 2009Lead architect, Blueprinting, Assessment, Training Manuals, and Business Units evaluation of planning methodologies.Financial Planning and Consolidation Activities.Development and implementation of SAP BPC 7.0 Net Weaver Platform with SAP BI 7.1Corporate Analysis of current phasing out technologies and planning strategy with more than 800 000 USD in cost savings in the first 2 weeks of work.Global planning of SAP BPC Global Architecture for Marketing, Mining, Refining, and Extraction Operations of Stainless Steel, Diamonds, Titanium, Aluminum, Oil, Iron Ore, Gold, Silver, and Uranium in South Africa, USA, Europe, Australia, and South East Asia.CAPEX,OPEX, Planning and Forecasting models, depreciation and tax planning.Design of Security Architecture, Process Mappings, training, Dimension Logic, Web Reporting, EVDRE Reports, Formulas, Application Sets and Application Development, Blueprinting, and Scripts.Sales and Operational Planning (SOP) and using SAP CRM extractors using trade promotion management (TPM), Bdocs, and SAP BW Adapter.Cube Extraction, Validations, Transformations, Conversions, and Installation Review.IFRS/USGAAP Under IAS 16 adjusting differences in asset componentization guidance to track and account for property, plant and equipment at more disaggregated levels.Integration of M&A Transactions to easily be part of the dual reporting process.Separation of the load processes using IFRS loads and USGAAP in two separate Charts of Accounts in order to allow the dual reporting, and the adjustments of the G/L accounts.Input Schedules, EV Functions, Budgeting and Forecasting, Visual Basic Buttons, Currency Translations, Balanced Sheet, Income Statement, Cash Flow, Excel and Advanced Logic, Process Chain Data Manager Packages, EBooks, Journal Entries, Working with the new SAP BPC NW 7.0 Planning and Rate ApptSets, Master Data Extraction from BI into SAP BPC using both custom procedures and standard functionality.Development of Business Objects Universes, Xcelsius Dashboards, and Web Intelligence Reports. Queries and architecture design from SAP BI Cubes and Bex reports, Slice and Dice, Cross-Tab and Tabular Views, Tree Control, Data Provider Viewer, Hierarchies, Attributes, Universe Designer, Web Intelligence Reports with Time Dependencies, Single Sign On.Abeam ConsultingTaipei, Taiwan, August, 2008-Feb, 2009SAP BPC Consultant 7.0Initial Product Evaluation and Assessment: includes blueprinting, architecture design, requirements gathering, and communication of ASAP and SAP BPC implementation methodology to users, managers, and developers.Blueprinting, requirement gathering, product specification, security design and roles definition, integration with SAP BI.Reporting and Legal Consolidation that includes Currency Translation, Live Reporting, Web Reporting, SecurityDefinition of application sets, Formulas, Dimension Logic, Data Manager (DM)BPC for Excel, Word, and PowerPointEnd-user training, development of EVRE reports, and scripts, dimension and worksheet logic.IFRS 8 reporting using Segment Reporting for different vertically integrated operations, applied to debt or equity, applying multidimensional views of financial statements.Consolidation of non-Balance Sheet Entities, and modification of Income Statement, Cash Flow, and Balance Sheet. Business Rules to recognize deferred tax assets and liabilitiesOLAP Business Universes, and working with Reports running Slice and Dice processes in Cross-Tab and Tabular View formats. Working with Web Intelligence and Xcelsius to migrate components previously running in BEx, SEM-BPS and SEM-CPM. .Allianz InsuranceLondon, England July-08SAP BPC 7.0Training for Financial Services CompanyTraining users and consultants on the Fundamentals of BPC reporting, expansion, filtering, suppression, and indentation in reporting, Ad hoc reporting analysis, EvDRE functionality. Definition of the suggested SAP BPC Implementation Methodology and its comparison with ASAP Methodology. Interaction and integration with SAP BW.Peavy ElectronicsElectronics Manufacturer, Jackson, MS Nov. 07 June 08SAP BI Lead ConsultantExperience with SAP BPC:Development of reports and consolidation system using SAP BPC to build a costing model that required:oLegal Consolidation, Ad hoc reporting, intercompany |
