TECHNICAL SKILLS:

BW4/HANA, BW 7.x & BW - IP, HANA, S/4HANA, BPC 11/10.x, BusinessObjects 4.1 (WebiAnalysis Office, Design Studio, Data Services), Fiori, SLT, SDA, ABAP, FOX, Logic script, SQLSQLScript, EPM, VBA, ECC (FICO, MM, PM), BW/BI/HANA Performance, ETL, Winshuttle.Specializing in BW & HANA modeling, development & integration. BPC (Embedded/Standard)BW-IP, BW technical & functional. SAP BI report/dashboard/Scorecard, Fiori. Data conversion.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. BPC/BW/HANA Consultant

Responsibilities:

• Worked with Team to implement S/4HANA Finance On - Premise Edition, BPC Standard/Embedded and BW Embedded.
• Responsible for all data conversion, BPC/BW configuration & development and config Fiori apps.
• Configured BPC, BW and S/4HANA post-installation. Activated BPC, BW and BusinessObjects BI Content bundle.
• Set up BW/BPC transport landscape and BPC/BW security. S/4HANA monitoring and performance.
• Performed master data and historical data extraction/transformation/load from legacy system to S/4HANA Finance and BPC/BW.
• Developed custom BW queries, Analysis Office input forms and reports with VBA.
• Performed testing all delivered BPC aggregation levels, planning functions, BW queries, Analysis Office reports, BPC Admin console.
• Developed custom planning functions with FOX/ABAP/SQLScripts.
• Created BW custom infoobjects, aDSOs, CompositeProviders, Open DSO views, BW queries, ABAP user-exitconverted classic cubes/DSOs to HANA-optimized cubes & aDSOs., etc.
• Installed BW Modeling Tools.
• Built HANA data models: schema, attribute/analytic/calculation views, hierarchies, variables/input parameters, decision tables, analytical privileges, stored procedures, SQL/SQLScripts, CDS views. Optimizing HANA views and SQL scripts forbest performance. Good knowledge of universal tables ACDOCA/P/C and inter-relationships.
• Worked with Basis to upgrade BW 7.x to BW 7.5 on HANA and BW4/HANA. Installed HANA Studio.

Confidential

Sr. BW/BPC/HANA Consultant

Responsibilities:

• Verified, enhanced and tested all current BW structures, ETL processes, ABAP, BEx queries and WebFocus reports to implement SAP ECC & BW for Candiac plant.

Confidential

Sr. BPC/BW/HANA Consultant

Responsibilities:

• Worked with Team to convert BPC 7.5 MicroSoft Server to BPC 10.1 Embedded on BW 7.5/HANA using Amazon AWS.
• Responsible for BPC/BW configuration, development & data conversion, production cutover plan, technical support and problem solving.
• Performed BPC, BW and HANA post - installation configuration. Set up BW/BPC transport landscape and BPC/BW security.
• Installed HANA Studio & BW Modeling Tools. HANA monitoring and performance.
• Created BW infoobjects, HANA-optimized standard and real-time planning cubes, CompositeProviders, aDSOs for comments & data consolidation, BW queries, EPM input forms with VBA, BEx variables, ABAP user-exit.
• Built BPC Embedded planning aggregation levels, filters, planning sequences, standard & custom planning functions with FOX/ABAP/SQLScript to calculate salary & benefits for employee and position planning. BPC Admin Console. Characteristic relationships and data slices. Converted BPC 7.5 reports to EPM reports.
• Performed master/transactional data and historical data extraction/transformation/load from MicroSoft Server into BW. Built CDS views.

Confidential

Sr. BW/BPC/HANA Consultant

Responsibilities:

• Responsible for BPC/BW/HANA models, technical issues and performance/tuning. Resolved defects related to input forms/reports, master and transactional data ETL. Using BODS for data extraction and data cleansing.
• Built/enhanced BPC planning objects: aggregation levels, filters, planning functions (Copy, Delete, Forecast, Revaluation, Distribution, FOX and custom functions ABAP, currency translation), planning sequences, characteristic relationships (standard & user - exit ABAP), data slices, actual and planning cubes, multiproviders, input-enabled BEx queries with variables for YTD, hierarchy, text, etc.
• Enhanced BEX queries and EPM input forms/reports with EPM functions & API, Excel functions and VBA for OPEX, CAPEX, Sales Margin, headcount expense & costs, rolling forecast, etc.
• Hybrid modeling withnative HANA and BW on HANA. Developed BW data models using CompositeProvider, advanced DSO, Open DSO View, transient & virtual providers. Generated HANA views for BW objects and publishingHANA models in BW. Converted Multiproviders & cubes to CompositeProviders & aDSOs.
• Using ODP/ODQ to extract master/transaction data from ECC FICO. Using Smart Data Access for virtually accessing external databases (Hadoop, Oracle) from HANA/BW. Real-time data replication from SAP and non-SAP sources to HANA/BW using SLT. Verified BW transformations and BEX queries to push down to HANA.
• Built HANA data models: schema, attribute/analytic/calculation views, hierarchies, variables/input parameters, decision tables, analytical privileges, stored procedures, SQL/SQLScripts. Optimizing HANA views and SQL scripts forbest performance. Developed BPC planning functions to call Hana stored procedures.
• Monitored & analyzed BW/BI/HANA performance via HANA Administration, SolMan, DBA Cockpit.

Confidential

Sr. BW/BI/BPC/HANA Consultant

Responsibilities:

• Worked with Team to migrate BW to BW 7.4 on HANA.
• Implemented Plant Maintenance and Engineering Costs data from ECC to BW/HANA.
• Developed HANA and BW data models. Using BODS for data extraction and data cleansing from non - SAP sources.
• Built data models in HANA Studio: schema, tables, Attribute views, Analytic views, Calculation views (graphical/SQL Script), hierarchies, variables/input parameters, decision tables and stored procedures .
• Developed complex SQLScripts with SQL and CE functions. And generated HANA views for BW cubes, DSOs.
• Using SLT for real-time replicating specific MM, PM core tables to HANA & BW.
• Using Smart Data Access for virtually accessing external databases (Oracle, DB2) from HANA/BW. Using ODP/ODQ for extracting master and transaction data from ECC to BW.
• Analyzing SQL Plan, SQL trace, expensive statements. Created table partitions (hash, range, round robin).
• Applied HANA best practices.
• Optimizing HANA views and SQL scripts forbest performance.
• Developed Webi reports based on HANA & BW data with complex query filters, adding tables, charts, using breaks, calculations, conditions, calculating data with formulas, functions, variables, using multiple data sources. Built BO dashboards apps and link to Webi reports.
• Monitored & analyzed BW/HANA performance via HANA Administration, SolMan, DBA Cockpit.
• Responsible for BW/BPC Standard 10.0 backend & ABAP to implement new Engineering Costs planning and forecasting: Rail Cost per Mile, CAPEX, headcount expense & costs, rolling forecast, etc. Extracted/loaded master data and transactional planning data.
• Defined transformation files, mapping and conversions files, process chains.
• Set up Data Manager packages.
• Loaded the master and transaction data from BW master into BPC. Automated execution of DM packages.
• Developed input schedules & reports using EPM functions & Excel VBA.
• Developed logic script.
• Built custom BAdI for: rounding, inconsistent data posting, depreciation, revaluation, forecast, transformation & conversion start/end routines.

BW/BI Architect

Confidential

Responsibilities:

• Responsible for enhancing TIS Track Inspection System: BW backend, BEX queries, portal BW reports. ABAP.
• Enhanced ECC Plant Maintenance extractors: 2LIS 17 Notification, Item, Task, Activity, Cause. And enhanced data extractors to extract ECC PM master/transaction data and data classification.
• Created/modified BW backend: infoobjects, DSO, infocubes, infoproviders, datasources, infosources, infopakages, DTPs, transformations, process chains, BWA, Data Hub. Developed ABAP Badi to extract transaction and master data, hierarchies & texts from ECC.
• Developed Start/End/Expert routines transformation and custom routines. APD processes. Created/enhanced BEx queries & BW portal reports (BW 3.5/7.1 WAD).
• Built TIS Performance Scorecard using BO Web Intelligence 4.1.
• Created universes for data sources from ECC and non - SAP tables.
• Set up BICS connections based on BEX queries.
• Developed Webi reports.

Confidential

Sr. BW/BPC Consultant

Responsibilities:

• Responsible for BW/BPC Standard backend & ABAP to implement BPC Budgeting and Cost planning.
• Developed BW backend to support BPC: multiproviders, infoproviders, infoobjects, DTP, datasources, etc.
• Extracting, cleansing, loading master & transactional data from ECC into BW/BPC.
• Defined transformation files, mapping and conversions files. Set up Data Manager packages. Loaded the master and transaction data to BW and BPC.
• Automated execution of DM packages. Created custom process chains. Developed dimension formulas, script logic.
• Developed custom BAdI/ABAP for: rounding, inconsistent data posting, depreciation, revaluation, forecast, transformation & conversion start/end routines, BW/BPC security.

Confidential

Sr. Consultant - BW/BPS/BPC

Responsibilities:

• Designed & implemented the new Global Upstream Budgeting & Factor Analysis BPC NW project and maintained & supported the old Global Upstream BW/BPS 3.5 application.
• Responsible for extracting, cleansing, loading master & transactional data from ECC into BW/BPC. Defined transformation files, conversions files, mapping to upload the master and transaction data from infocubes to BPC dimensions. Set up Data Manager packages. Created process chains. Set up Work status.
• Developed dimension formulas, script logic. Configured business rules (carry forward, eliminations, consolidation, etc.), process management and locking. Transported BPC objects.
• Developed custom BAdI/ABAP for: rounding, inconsistent data posting, depreciation, revaluation, forecasttransformation & conversion start/end routines. BW/BPC security enhancement.
• Designed and developed BPC input schedules & reports using EV functions and Excel VBA.

Confidential

Sr. BW/BI Consultant

Responsibilities:

• Designed BW Procurement application.
• Built BW infoobjects, DSO, infofocubes, infoproviders, datasources, infosources, infopakages, DTP, transformations, process chains, aggregations, Data Hub, DataMart, Myself DataMart & Infoset.
• Developed ABAP user - exits for extracting transaction and master data, hierarchies & texts from ECC.
• Developed Start/End routines, custom transformation routines & Expert routines and APD processes.
• Converted legacy system reports to Webi & Crystal reports for Supplier Chain Mgmt, Operations, etc.
• Created universes (for data sources from ECC, BW & non-SAP) for Webi and Crystal reports. Developed Webi documents with complex query filters, adding tables, charts, using breaks, calculations, alerters to highlight information, formatting, calculating data with formulas & variables, using multiple data sources, etc.

Confidential

Sr. BW/IP Architect & Tech. Lead

Responsibilities:

• Worked with Basis to install BW 7.0. Developed BW/IP application to plan & forecast: Financials, Fix Assets, CapEx, OPEX, HR Headcount expense/costs, Payroll calculation, Sales, Rolling forecast, etc.
• Built BW/IP backend: aggregation levels, filters, planning functions (Copy, Delete, Revaluation, Distribution, Forecast, FOX & custom ABAP), planning sequences, characteristic relationships (standard & ABAP Exit), data slices (standard & ABAP Exit), standard and real - time planning cubes, multiproviders, input planning layouts using BEx Analyzer, queries with variables for YTD, hierarchy, text, etc.
• Performed master/transactional data extraction/transformation/load from ECC & flat files to BW. Setting BW & IP security with Basis.
• Converted legacy system reports to Webi reports for Financials, Operations and Sales.

Confidential

Sr. BW/IP Architect

Responsibilities:

• Designed a blueprint to support the BW Retail application - purchase requisitions, purchase orders, warehouse inventory, material movements, GI/GR, on-hand quantity counts, stock replenishment, distribution centers, seasons, articles, sales planning and forecasting, etc.
• Built BW backend, APD processes, BEx queries & Web reports to analyze the performance of seasonal articles of past & current seasons and to plan pre-seasons articles based on key figures: carry-over & on-hand quantities, units sold, costs & retail values, per store, per article, per season, per merchandise category, etc.
• Built complex Point-of-Sales stores reports using Crystal reports/Xcelsius dashboards.

Confidential

Sr. BW & SEM-BPS/BCS Consultant

Responsibilities:

• Provided production support for BW & SEM - BPS/BCS apps: Profit & Loss, Balance sheet, Cash flow, Personnel planning, APO Production planning, Product costs, Sales, Costs allocation, and Confidential Consolidation period-end & year-end closing.
• Enhanced BW/BPS apps for Fixed Assets, Inventory, AP/AR: planning areas, planning levels, planning packages, planning functions (copy, reposting, forecast, delete, distribution, FOX), ABAP user-exit function modules (variable user-exit, characteristic relationship/data slice user-exit), layouts, etc.