SUMMARY:

• Confidential has more than 15 years experience in leadership roles in operations, design, manufacturing, Six Sigma and Information Technology. He has experience with consultant related positions and middle management, working with Division Managers, General Managers, Middle Management and development of process improvements, formulating strategies and implementing change. He is the author of the book “CPM and Balanced Scorecard with SAP” by SAP PRESS, AG published January 2007 in Europe and sold in 100 countries, and also author for a second publication on “Profitability Analysis (CO - PA) with SAP” released January 2008 by SAP PRESS, AG. He has six years experience with SEM 6.0 (BPS and CPM). He has Business Information Warehouse BW 3.5/BI 7.0 experience. He has a year experience in FI/CO, Profitability Analysis and Cost Center Accounting. He possesses good functional knowledge of SD, FI/CO and general business process of SAP R/3. He has two years in PeopleSoft (J.D. Edwards) consultant experience in inventory, distribution, materials management, and manufacturing.
• Confidential has experience in configuring and implementing SEM in the area of BPS and CPM.
• He is skilled in BSC, Management Cockpit and Measure Builder. He is proficient in designing Business Planning architecture with area, level, and package. He has experience in the modeling of planning structure, manual planning, balance sheet planning and profit planning. He has experience in cost center planning, extraction, retraction, profit planning, and investment planning. He is skilled in transactional (real time) cubes. His Business Planning and Consolidation (SAP BPC) experience maintains Dimension Members, Building Balance Sheet and Look at Cash Flow, allocations, adjustments and eliminations, creation of Business Process Flows. He is skilled in Application Sets development, Entity Dimensions and Hierarchies. He was involved in the development of AD-Hoc Reports, Live Reporting using BPC, working with BPC for Excel, for PowerPoint, for MS Word, and Insight. He completed the Reporting and Drilldown, and development of Member Access Profiles (security). He is adept in Business Planning Functions (EVPs) such as EVDPS, SELF, EVDEP, EVBSS, EVBAS, EVALS, and EVMEMBERS. He is working with MDX and SQL syntax. He worked with the Data Manager and Administration, along with the configuration of layouts.
• Confidential was involved in the design and implementation of BW project by Building BW objects and analysis for strategic decision-making. He has experience with BW Administrator Workbench and Business Information Warehouse (BI). He is familiar with InfoCubes, ODS Objects, InfoObject, InfoSources, update rules and transfer rules, Process Chains, ABC Analysis, Association, and Regression Data Mining Workbench. He was involved with Delta Loads, InfoSources, and the migration of DataSources from 3.x to BI 7.0. He is skilled in the maximization of Query Optimization Options. He has experience in building multi cubes and InfoSets as per the query needs. He has experience in loading transaction data into the BW system from different source systems. He is skilled in conducting sessions for users.
• He has experience with BEX queries and workbooks, and Crystal Reports. He was involved in Integrated Planning (IP), planning functions, planning sequences, filters, real-time InfoCubes, aggregations, trace function, planning cockpit, and Fox formulas. His FI/CO experience includes Cost Center Accounting: organizational structures, cost element accounting, cost center groups, categories, assessment and distribution, activity types, and actual postings. His Profitability Analysis (CO-PA) experience includes 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. His G/L Accounts skills include chart of accounts, retained earnings, enable fiscal year default, tolerance groups, G/L Account for Automatic clearing, Balance Sheet and Profit Loss accounts. He is knowledgeable for Report Painter and R/3 Reporting, along with Order-to-Cash Process, Credit Control Areas, and Purchase-to-Pay (P2P). He is skilled in Invoice Verification, Outgoing Payment Processing, and integration between MM and GL. He is proficient in Vendor and Customer Master, Billing Documents, and Invoice Processing. He configured House Banks.
• Confidential received a Doctor in Industrial Technology, along with a Masters in Manufacturing Systems. He holds a Bachelors of Science in Industrial Engineering, Quality Engineering and Simulation. He has excellent communication and leadership skills. He has the ability to convert complicated information into more understandable terms.

TECHNICAL SKILLS:

Skills: SAP HANA (SAP America) Hedge Funds - London Business School (LBS), UK Private Equity -London Business School (LBS), UK Global Investment Risk Management Programme - Oxford Said Business School, UK Peracs Due Diligence Analytics Software, at London Business School (LBS), UK Six Sigma Design and Manufacturing Optimization Cost Accounting Productivity Manufacturing and Design Simulation Project Management. Crystal Reports Business Objects, Dashboards, Web Intelligence, SAP Lumira, SAP HANA, BOBJ 4.0-4.1, SAP BW 7.3/SAP BW 7.4, SAP EPM10 DB2 MS Access Microsoft Project

PROFESSIONAL EXPERIENCE:

Confidential

Implementation and Financial Transformation Lead (EPM/HANA Architect)

Responsibilities:

• Migration of financial reporting from Legacy into SAP BPC NW 7.5/BPC NW 10/BPC NW 10.1 on HANA.
• SAP BPC Optimized for S4 HANA environment:
• Working in Embedded and Standard models.
• Creation of Aggregation Levels, Multicubes, and Real-time InfoCubes.
• Working with SAP Fiori and different HANA Views: Query Views, Private Views and Reusable views.
• Working with the SAP PAK/BPC Planning Manager.
• Working with WEBI Reports.
• Focused on Financial Reporting, Consolidation and Financial Planning using EPM Addin and Analysis for Office (AO).
• Deployment of Analysis for Office and EPM Add-In for Embedded Model of BPC.
• HANA CDS:
• Creation of SQL Views
• Creation of Association between Views and Entities.
• Creation of User-defined structures.
• Data Import with HANA CDS import using data provisioning, and creating customized messages.
• Creation of CDS Documents, extension artifacts, Metadata, creation of CDS roles.
• Creation of views using XS Advanced for syntax and associations.
• Creating HANA Schemas
• Working with HANA OData Service,
• 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 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.

Confidential

SAP BPC NW 7.5/SAP BPC 10.1 Lead/with HANA integration

Responsibilities:

• SAP 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,, 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 10
• 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.
• 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.

Confidential

SAP BPC NW Lead and Migration from SAP BPC 5.1 to SAP BPC NW 7.5

Responsibilities:

• Migration 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 in corporate 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 NW
• Hierarchies, 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 adjustments
• Currency translation and adjustments
• Consolidation, Budgeting, Forecasting, and Planning.
• Integration with third party systems and migration design to SAP ECC and SAP BI
• Capital 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.

Confidential, North Carolina

SAP BPC Lead for Global Deployment

Responsibilities:

• 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,, 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 Confidential 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.

Confidential, Ohio

SAP BPC/ Business Objects Corporate Lead Architect

Responsibilities:

• Lead Architect, Blueprinting, Assessment,, 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.

Confidential

SAP BI/BPC 7.0 SP03 Global Lead Architect

Responsibilities:

• Lead architect, Blueprinting, Assessment, 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 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,, 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.

Confidential

SAP BPC Consultant 7.0

Responsibilities:

• 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, 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. .

Confidential

SAP BI Lead Consultant

Responsibilities:

• 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.

Confidential, Tampa, FL

Lead SAP BI Consultant

Responsibilities:

• 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.

Confidential, New York

SAP BI/BPC/SEM/FI/Strategic Consultant

Responsibilities:

• 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 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 .
• 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.

Confidential, San Francisco, CA

SAP BW/ SAP CPM Consultant

Responsibilities:

• 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.

Confidential, NJ

SAP FI CO PA Consultant

Responsibilities:

• 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.

Confidential, Chicago, IL

SAP SEM/BW Consultant

Responsibilities:

• 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

Confidential, Florida

SAP BW Consultant

Responsibilities:

• Responsible for System Design, analysis, development and the implementation of Business Warehouse using SAP BW 2.0B and SAP 4.6C
• 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
• 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.

Confidential, IL

SAP SEM Consultant

Responsibilities:

• 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.

Automotive Manufacturer, Moline

SAP SEM Consultant

• 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.

Confidential, NJ

SAP FI CO PA GL Consultant

Responsibilities:

• 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.

Confidential, Houston, TX

SEM Team Lead Consultant

Responsibilities:

• 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 them for Business Information Collection.
• FOX for formulae creation.

Confidential, Iowa

SAP Consultant

Responsibilities:

• Product and design optimization with ANSYS and other 3D design tools.
• Trained and supported implementation of SAP Data warehouse, R/3 Reporting, Financial Accounting, Profitability Analysis and Strategic Enterprise Management Modules.
• Different Six Sigma projects and received Black Belt .
• Development of a Doctoral Project with Structural Equations Modeling and Genetic Algorithms to improve Material Flow and Cost Reduction in Assembly Lines.