Profileimage by marco sisfontes Implementation and Financial Transformation Lead (BPC Embedded/ Analytics Standard/HANA Architect), from whiteplains

marco sisfontes

available
Contact

Last update: 06.09.2022

Implementation and Financial Transformation Lead (BPC Embedded/ Analytics Standard/HANA Architect),

Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Full Professional) | Spanish (Full Professional)

Attachments

Marco Sisfontes RESUME BPC7-SAC.doc

Skills

SAP, Analytics, SAP Analytics Cloud, data visualization, Fiori Apps, HANA, visualization, cloud, SAP BW, BPC, MS Excel VBA programming, VBA programming, PS integration, SD Integration, Procurement, SAP Lumira, Reports, SAP AO, Interface, SAP HANA Analytics Cloud, data conversion, VBA, SOLMAN, MS versions, Test Scripts, Citrix, SAP BI, HANA 1709, BEx Queries, EPM/HANA Architect, SAP HANA, DTS, QDPs, Info Providers, ODS, Crystal Reports, Excel, BOBJ, SQL, Calculation Engine, SAP HANA Expression Editor, FI, x platform, SLQ Script, Data Management, mobile devices, SAP Business Suite, Data modeling, ETL, SAP EPM 10, script, UI, Hyperion, data extraction, EPM Reporting, user interface, Logic, database, Business Objects, DTS packages, SAP CRM, Single Sign On, subreports, Word, PowerPoint, Xcelsius, Query, Service, 7.0 Net, Visual Basic, Hierarchies, Attributes, Universe Designer, Web Intelligence Reports, requirement gathering, OLAP, Web Intelligence, Web, Excel interface, Power Point, Interfaces, Data Mining, SAP Business Intelligence 7.0, ABAP, Essbase, SAP Basis, data transfer, IBM, WADs, Business Explorer Queries, MS Excel, Style sheets, BSP, R/3, SAP FI, Web Application Server, Star Schema, BEX Query Designer, Web Reports, Metadata, Data Warehouse, System Design, Macros

Project history

01/2019 - 12/2019
Implementation and Financial Transformation Lead (BPC Embedded/ Analytics Standard/HANA Architect)
Biopharma
Biopharma
Biotech and Pharmaceutical Client, Global Deployment Europe, Asia, Americas
North East, USA
Implementation and Financial Transformation Lead (BPC Embedded/ Analytics Standard/HANA Architect)
Jan-2019- to Dec 2019
SAP BPC 10.1 on HANA 1809 with BW4 with SAP ECC S/4

* Financial Statements development using composite providers.
* AO Reporting and customization using extensive MS Excel VBA programming and SAP BPC VBA
programming.
* 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.
* SAP CPM configuration and integration with PS, SD, Procurement and Billing, Lumira, and
Project Baselines.
* GAP/FIT analysis to determine upgrade, reporting changes, data flow and implementation
strategy changes.
* Deployment using SAP MS Analysis for Office 2.7, SAP BPC 10.1
* Integration with new consolidation tool from SAP Group Reporting for plan data.
* Working with CDS Hana Views, and deploying using Fiori of BEx Queries and AO Reports.
* 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.
* Working with SOLMAN (Solution Manager), and QC Vera for Testing, and deployment.
* 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.

03/2017 - 01/2019
Implementation and Financial Transformation Lead (BPC Embedded/Standard/HANA Architect)
Konica Minolta
Konica Minolta
Manufacturing Client, global Deployment Europe, Americas, and Asia
North East, USA
Implementation 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 2019


* 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.
* GAP/FIT analysis report development, architectural changes, data flow, software upgrade, and
package configurations in alignment with SAP BPC 10.1/SAP BPC 11.
* 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
* SAP CPM project management, baseline, project reporting, Issue Resolution, working with business
requirements and SAP BPC and SAP CPM integration.
* 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.

03/2015 - 03/2017
Editor
Kao Group
Kao Group,
Manufacturing Client, global Deployment Europe, Americas, and Asia
USA, Midwest and Northeast
Implementation 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 2017


* 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.
* Migration of SAP BW Tax data to SAP HANA and included as part of the SAP
* 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.
* 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:
* Update of S/4 HANA Reporting using BOBJ, Crystal Reports, and Web Intelligence.
* Update of SAP HANA from SP06 to SP12 for Graphical Views.
* Working with SAP HANA security and Analytic Privileges
* Creating and enhancing Analytic, Attribute, and Calculation Views for BOBJ4 reporting using
Universes.
* Creating customized calculations using SQL, Calculation Engine and SAP HANA Expression
Editor.
* Creating Decision Tables for Sales Analysis and Discounts
* Replicating 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.
* Creating Input Parameters and calculated values on the fly.
* Transporting SAPHANA objects between systems.
* Integration with SAP BPC for master data on the fly replication from SAP ECC, and alignment
with the SAP EPM Embedded model.
* Migration of SAP EPM 10 to 10.1 on HANA objects.
* Replicating SAP ECC data into HANA and exporting into SAP BW for reporting.
* Data 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.
* Working with Analytical Views Join, Aggregation, Projection, and Union for SAP and Non-SAP
data.
* Extensive 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.

11/2010 - 03/2011
BI/BPC Planning and Consolidation Architect
Abeam Consulting; AFLAC Tokyo Insurance
* SAP BI architecture design, build, and deployment
* Dual Reporting in US GAAP, IFRS, and Common Accounts, Cash Flow, B/S, P&L, Cash Flow, for both
planning and actual data.
* Build of custom data sources, and reporting using BOBJ, BEX, Analyzer, and EPM Reporting.
* Development of hierarchies, master data attributes, and input reports and reports, evaluation
of gross margin by product lines.

03/2010 - 09/2010
SAP BPC Lead for Global Deployment
Down Chemical Chemical Global Conglomerate
* SAP 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: Shareholder's 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.

09/2009 - 03/2010
SAP BPC/ Business Objects Corporate Lead Architect
Murray Energy
Murray Energy
Mining, Exploration, and Energy Client
Ohio, USA, Coal and Natural Gas
SAP BPC/ Business Objects Corporate Lead Architect
Sept 2009- March 2010
Budget Planning and Consolidation SAP BPC 7.0 SP04


* Lead 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: Shareholder's 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.

03/2009 - 09/2009
Global Lead Architect
BHP Billiton
* Lead 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.1
* Corporate 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.

08/2008 - 02/2009
SAP BPC Consultant 7.0
Abeam Consulting
* Initial 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, Security
* Definition of application sets, Formulas, Dimension Logic, Data Manager (DM)
* BPC for Excel, Word, and PowerPoint
* End-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 liabilities
* OLAP 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. .

11/2007 - 06/2008
SAP BI Lead Consultant
Peavy Electronics
Experience with SAP BPC:

* Development of reports and consolidation system using SAP BPC to build a costing model that
required:
* Legal Consolidation, Ad hoc reporting, intercompany elimination, Application Sets,
Application functions, business rules, dimension and members, working with SAP BPC for
Web, Excel, and Word; defining security, status, roles, work status, Business Process
Flows.
* Budgeting system implementation.
* Consolidation using Legal Consolidation, Intercompany Elimination, data upload from
subsidiaries, currency translation, report building, formula calculations, Business
Process Flows and web reports.
* Security, Task and Profile Management.
* Formula calculation, Data Manager, Dimension Calculation, Data Loads
* Report building using BPC Excel interface, Word, and Power Point Interfaces
* Review of requirements and reports
* Extraction from SAP CRM using SAP BW of Trade Promotion Management and Sales Operational
Planning (SOP).
* Development of an advanced Data Mining application for payment of Sales Representatives in
order to dynamically calculate commissions based on constantly changing conditions. This
Costing Model involved more than 200 sales representatives all over the world using SAP
Business Intelligence 7.0.
* CO-PA, FI, SD, MM, and CO support
* BI Business Content including extractors, master data, and reports.
* Basic ABAP experience to support ABAPERS in the program development.
* Configuration and maintenance of GL postings.
* Development of custom extractors and BEx Reports replicating reports and cubes based on Hyperion/Essbase
migration to replicate those reports with information in SAP.
* Activation and development with Business Content
* Interaction with SAP Basis to fix data transfer problems, flat files problems with the
system, RFC connections, Web integration, and suggestion of system upgrades to match the
latest SAP requirements.
* This project was a "cleaning operation" after IBM Global Consulting Services left the
project, leaving multiple problems to the client.
* Billing Documents, Controlling Areas, Operating Concerns, cost center standard hierarchy,
activity types and statistical key figures.
* CO-PA Planning Layouts, Planning Versions, CO-PA Reporting (Forms and Report Line
Structures).
* Consolidation experience: definition of versions, hierarchies, ledgers,consolidation groups
and frequencies, assign hierarchies to chart of account, move balances forward,
consolidation monitor and task definition for inter-company elimination, manual posting,
data transfer definition, dimension definition, deletion of transactional data, definition
of FS Items, Currency Translation, Elimination of Profit/Loss on Sale of Fixed Asset to
Subsidiary.

09/2007 - 10/2007
Lead SAP BI Consultant
Capgemini
Project for Capgemini USA
Lead SAP BI Consultant

* Demo and review of the new SEM (SAP Business Planning and Consolidation) version 4. Basic
information regarding SAP Business Planning and Consolidation (Outlooksoft) architecture and
infrastructure, reporting, application set creation, consolidation and planning.
* Migration from BW 3.5 to BI 7.0, and general system installation review and roles update.
* BI Business Content including extractors, master data, and reports.
* BW Security and Roles development
* Material Management, Point of Sales Data, Shipping Points, Billing Documents, Inventory
Movements, Goods Issue status, Sales Orders, Material Status and Back Orders Reports.
* Business Reporting using WADs and Business Explorer Queries, workbooks, formula calculation,
calculated key figures.
* Development of customized extractors, reusing SAP Delivered Business Content
* Data Mining Development and forecasting models for materials management and financial
analysis.
* Integrated Planning (IP), planning functions, planning sequences, filters, real-time
InfoCubes, aggregations, trace function, planning cockpit, Fox formulas.
* Support and configuration of payment program configuration including Company Code Data,
Paying Company, Vendor Master, and payment methods.
* Accounts Receivable: configuration of reason codes, account determination, customer master
records, and customer groups.
* Review and update of consolidation hierarchies, hierarchies, ledgers, chart of account, move
balances forward, redefinition of tasks and scheduling for updates, configuration and
definition of FS Items, inter-company elimination, AP/AR Intecompany elimination, Loan
Elimination of intercompany, intercompany movements elimination.

01/2006 - 09/2007
SAP BI/BPC/SEM/FI/Strategic Consultant
New York Power Authority
New York

* Review of SAP BPC, and creation of structures and MS Excel reports for the client to evaluate
the possibility of a migration to this technology. Both structures and reports were created
using SEM and BPC, and training to users to deploy the application.
* SAP CPM Implementation: Balanced Scorecard and CPM Cockpit
* BEX Reports and Excel Style sheets.
* User Authorizations and Roles.
* BI 7.0/ BW 3.5
* Measure and Value Driver Tree.
* BSP Configuration of financial reports and BEX reports.
* Formatted and configured the Planning layouts and Fox Formulae.
* Extraction and modification of layouts.
* Planning Layouts, Planning Folders, Planning Functions, Planning Sequences, Packages,
Variables, Authorizations, and working with functions such as Copy, Distribute, Delete,
Repost, Forecast, and others.
* Complete deployment of the application around NY State electrical facilities. End-User,
Technical, and Managerial training.
* CO-PA reporting and data extraction in R/3 to BW, Data Sources, and Data Maintenance.
* BEx and MRP Reporting, including extraction and master data using Business Content.
* BW statistics, selective deletion, aggregations, hierarchies, checking indexing, query
properties, compression and partitioning.
* Integrated Planning (IP), planning functions, planning sequences, filters, real-time
InfoCubes, aggregations, trace function, planning cockpit, Fox formulas.
* Consolidation experience: definition of versions, hierarchies, ledgers, consolidation groups
and frequencies, assign hierarchies to chart of account, move balances forward, consolidation
monitor and task definition for inter-company elimination, manual posting, data transfer
definition, dimension definition, deletion of transactional data, definition of FS Items,
Currency Translation, Elimination of Profit/Loss on Sale of Fixed Asset to Subsidiary.

07/2005 - 01/2006
SAP FI CO PA Consultant
JP Morgan
* Planning Layouts and Profiles, FOX code
* Worked with Planning Functions
* BEx and InfoCubes Design
* BPS implementation with Planning Layouts, Planning Folders, Planning Functions, Planning
Sequences, Packages, Variables, Authorizations for budget planning and cost center accounting.
* Profitability Analysis and CO-PA reporting
* Extraction and integration of Cost Center Accounting info with SAP BW-BPS.
* Web Templates and Web Application Server
* Configuration of GL Accounts, creation and assignment of Cost Centers, Profit Centers and
Hierarchies.
* Investment Management and Profit Center Accounting.

12/2005 - 01/2006
SAP BW/ SAP CPM Consultant
PG&E Utility Client
* SAP CPM Implementation: Balanced Scorecard and CPM Cockpit
* Measure Builder
* BEx Reports
* Measure and Value Driver Tree.
* SEM SAP and BPS
* Involved in modeling of transactional info cubes for aggregation of Plan data.
* Formatted and configured the Planning layouts.
* Integrated Planning (IP), planning functions, planning sequences, filters, real-time
InfoCubes, aggregations, and Fox formulas.
* Worked with Chart of Accounts, Company code configuration, house banks and bank account
determination.

06/2005 - 07/2005
SAP SEM/BW Consultant
Electronic Manufacturer
* InfoObjects, InfoSources, InfoCubes, Aggregate, Star Schema Multi-cubes, ODS Objects, ETL,
Generic data extractor, application specific extractor: such as CO-PA.
* BEx Analyzer, BEX Query Designer, BW Report Agent, Web Reports, Web Application Designer.
* Administrator Workbench, Metadata Repository, PSA (Persistent Staging Area).
* Aggregates and Multi-Cubes.
* Data Warehouse Modeling,
* Cost Center Accounting: organizational structures, cost element accounting, cost center
groups, categories, assessment and distribution, activity types, actual postings.
* Profitability Analysis: operating concerns, costing based- and account-based reporting,
maintain characteristics, value fields, assigning operating concern to controlling areas,
flows of actual values, variable and forms in R/3 reporting, and transports

01/2005 - 06/2005
SAP BW Consultant
Real Estate
* Responsible for System Design, analysis, development and the implementation of Business
Warehouse using SAP BW 2.0B and SAP 4.6C

Data Modeling and Extraction:
* The product architecture involved custom info sources, InfoCubes and ODS, as well as
enhancement of SAP standard Business Content in MM, SD and PM modules.
* Responsible for program specifications for development, maintenance and enhancements.
* Diagnosed and resolved basic to moderately complex program problems within the Business
Warehouse application.
* Used BEx Analyzer for normal Query Definition and InfoSet query for reporting.
* Profitability Analysis: operating concerns, costing based and account-based reporting,
maintain characteristics, value fields, assigning operating concern to controlling areas,
flows of actual values, variable and forms in R/3 reporting, and transports
Reporting:
* Used BEx Analyzer for normal query definition and variance.
* Used the functionality for defining variables, conditions, filters and exceptions for BEx
queries.
* Used calculated key figures and restricted key figures.

06/2004 - 12/2004
SAP SEM Consultant
Heavy Equipment Manufacturer
* Web reporting of SEM-BPS and BW.
* Interface with SEM-BPS layouts and co-models of Powersim constructor.
* Formatted and configured the Planning layouts.
* Business Planning Structure is developed in the SEM-BPS environment.
* SEM Stakeholder Relationship Management (SRM): Exposed to the tools for Stakeholder
Management, Contact Management Building Web Surveys and publishing them for Business
Information Collection.
* Configuration of Vendor Master Data, creation of Vendor Groups, payment terms and interest
calculation, and configuration of customer master records.

01/2004 - 12/2004
SAP SEM Consultant
Automotive Manufacturer
* Interfaced SEM-BPS and BW: Built Transactional cubes in BW for Planning and Basic cubes for
actual data.
* Created some custom info Objects, calculated key figures, custom transfer and update rules.
* Built Query / Structure with BEx Analyzer with Calculated key figures using various filters &
restrictions for SEM use.
* Development of Planning Hierarchy in SEM-BPS, Hierarchy Attributes in BW, Characteristic
Relationships in SEM-BPS, Worked on realignment of Characteristics across Hierarchies.
* Development of Planning functions, Parameter Groups: (formula, Copy, Repost, Revaluate,
Currency Translation, Distribution, Allocation etc). Used the Fox converter to build formulae.
* Development of Planning Sequences and Macros for Excel Layouts, variables in planning
functions
* Development of Planning areas, Multi-planning areas for Actual and various planning versions,
Planning Levels, Planning Packages, Planning Folders.
* Worked using SAP technologies and Team Lead for Project Management activities related to
design optimization, application of Six Sigma, and use of Powersim Construct to create a
Manufacturing Dynamic Simulation Model.

06/2003 - 12/2003
SAP FI CO PA GL Consultant
Pharmaceutical
* Development of cause-effect chain, KPIs, risk catalogs, perspectives, management cockpit,
InfoCubes, planning and multi-planning areas.
* Implemented profit planning and balance sheet planning.
* Budget Planning is formulated with Top Down and Bottom up planning.
* Involved in SEM Business content objects activation.
* CO-PA and Cost Center Accounting.
* G/L Accounts: chart of accounts, retained earnings, enable fiscal year default, tolerance
groups, G/L Account for Automatic clearing, Balance Sheet and Profit Loss accounts.

01/2003 - 06/2003
SEM Team Lead Consultant
Electronic Manufacturer
* Worked as a functional consultant in SAP-CPM and Project Management.
* Implementation of SAP-BW and SAP-BPS in Budget Planning and Profit analysis.
* Balanced Scorecard, Management Cockpit, Measure Builder, and KPIs.
* Involved in modeling of transactional info cubes for aggregation of Plan data.
* Formatted and configured the planning layouts.
* Multi-planning area and multi-providers were designed to analysis the plan and actual data.
* Business Planning Structure is developed in the SEM-BPS environment.
* SEM Stakeholder Relationship Management (SRM): Exposed to the tools for Stakeholder
Management, Contact Management Building Web Surveys and publishing

Time and spatial flexibility

anywhere in the world providing ALL EXPENSES COVERED, like ALL EXPENSES COVERED, net 30 payments MAX

Contact form

Contact details