TECHNICAL SKILLS:

Experience: BW4/HANA, BW 7.x & BW - IP, HANA & S/4HANA, VDM CDS, BPC 11/10.x, BOBJ 4.1 (WebiAnalysis Office, Design Studio, Lumira), Fiori, Data Services, SDA, SDI/SDQ, SLT, ETL, ABAPFOX, SQL, SQLScript, Logic script, EPM, VBA, ECC (FICO,MM,PM), BW/HANA Performance.Specializing in BW & HANA modeling, S/4HANA Embedded Analytics with VDM CDS, HANA Native development, BW on HANA/Any db, BW-IP, BPC Embedded/Standard, BI dashboard

PROFESSIONAL EXPERIENCE:

Confidential

Sr. BW/BPC/HANA Consultant and HANA Native Architect/Developer

Responsibilities:

• Worked with Teams 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 testing all delivered BPC aggregation levels, planning functions, BW queries, Analysis Office reports, BPC Admin console. Developed custom planning functions with FOX/SQL Scripts/ABAP AMDP. Setting UMO & currency conversion, characteristic relationships & work status/data slice. Configured embedded Consolidation.
• Created BW custom infoobjects, aDSOs, CompositeProviders, Open DSO views, BW queries, BW variables user-exit with ABAP/Badi, converted cubes/DSOs to HANA-optimized cubes & aDSOs, etc. Installed BWMT.
• Using ODP & BODS/SLT/SDI-SDQ for ETL data provisioning from SAP and non-SAP sources into HANA & BW. Performed loading master/transaction data into S/4HANA and BPC/BW. Developed custom BW queries, Analysis Office input forms and reports with VBA.
• 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 & SQLScripts. Good knowledge of universal tables ACDOCA/P/C inter-relationships.
• Worked with Basis to upgrade BW 7.x to BW 7.5 on HANA and BW4/HANA. Installed HANA Studio. Setting and configuring
• Predictive Analytics & HANA PAL Predictive Analysis with flowgraph & SQLScript for forecasting. HANA Native development. Developed S/4HANA Embedded Analytics with VDM CDS views & adding custom tiles to Fiori launchpad.
• Worked with teams installing CPM 2.0, testing the interface to BPC/IP and AO, comparing Plan to Actuals in real time for project costs, WIP.

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. BW/BPC/HANA Consultant and HANA Native Architect/Developer

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.
• 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 & SQLScripts. HANA Native development.
• Using ODP & BODS/SLT/SDI-SDQ for ETL data provisioning from SAP and non-SAP sources into HANA & BW.

Confidential

Sr. BW/BPC/HANA Consultant and HANA Native Architect/Developer

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 with native 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, queries, BW variables user-exit with ABAP/Badi. 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 for best 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 for best 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 Confidential 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.

Confidential

BW/BI Architect

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, infosourcesinfopakages, 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 Confidential 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 ABAP BAdI 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. Confidential objects.
• Developed custom ABAP BAdI for: rounding, inconsistent data posting, depreciation, revaluation, forecasttransformation & conversion start/end routines. BW/BPC security enhancement.
• Created OLAP universes (for data sources from ECC & BW) and BICS BEX queries. Developed ad - hoc financial reports using Webi. Set up SolMan-Early-Watch Alert to monitor all production BW systems.

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. Built Webi reports for Financials and Sales.
• Performed master/transactional data ETL from ECC & flat files to BW.
• Setting BW/IP security with Basis.