PROFESSIONAL SUMMARY:

An accomplished SAP BW/HANA professional with over a 13 + years of experience across various challenging roles like SAP BW, HANA, BI/BOBJ Techno - Functional Consultant, Senior Developer, Development Lead and Business Analyst. This experience includes numerous end-to-end implementations, upgrades, migration and support projects.Adept at handling technical discussions on design, liaising with business to gather requirements and effectively lead teams across the globe.

TECHNICAL SKILLS:

Data Modelling: SAP BW, SAP HANA, SAP BOBJ IDT

Data Provisioning: SAP BW, BOBJ DataServices, HANA

Programming Languages: ABAP/4, AMDP, HANA Native SQL and Python

Reporting Tools: SAP Business Explorer (BEx), SAP BOBJ/BI, Power BI, Tableau

SAP ERP: Finance, Sales modules, Shopping cart, Travel & Expenses, Master data, Dealer Business Management and Supply Chain Forecasting(APO).

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Extensively worked with different phases of project life cycle such as Blueprinting, Planning, Scoping, Requirement Gathering, Architecture, Analysis, Design, Development, Testing, Documentation, Deployment, User Training, Post Production Support and Change Management during the implementation of global Business Reporting Data Warehouse Solutions using the products SAP BW, HANA, SAP BI/BOBJ and other reporting tools like Tableau and Power BI.
• Good exposure to the various Project management methodologies like ASAP, Waterfall and Agile.
• Heavy Knowledge and experience with SAP Business Suite functional applications including Sales and Distribution (SD), Purchasing (MM), Inventory Management (MM), Production Planning (PP), Quality Management (QM), Plant Maintenance (PM), General Ledger (FI-GL), Accounts Payable (FI-AP), Accounts Receivable (FI-AR), Controlling (CO) and Profitability Analysis (CO-PA).
• Strong experience in building Data Warehouses using SAP BW, SAP BI/BOBJ, Native HANA SQL, ABAP and AMDP for Enterprise and Ad-Hoc and Self-Service Reporting requirements.

Confidential

Responsibilities:

• Create HANA Native Modelling Objects including Attribute Views, Analytic Views and Calculation Views (Graphical & SQL Scripting).
• Technical Expertise in upgrade and Migrate Projects from BW7.3/DB to BW7.4/HANA.
• Perform Pre and POST DMO activities during upgrade and migrate of BW/HANA.
• Migrate Standard Infocubes to HANA Optimized infocubes.
• Design and develop dataflows in BW7.3/7.4 with new infoproviders like Open ODS View, Advanced DSO, Composite Provider, Transient Provider.
• Design Analytic/Calculation views in HANA Studio by importing BW Info Cube schema.
• Extraction of data from Legacy data base and SAP ECC to HANA Data Base via System Landscape Transformation (SLT).
• Extract data from SAP ECC Extractors to HANA Data Base using Embedded BW in ECC system via Direct Extractor Connection (DXC).
• Strong Knowledge in Creating and executing Data Service Jobs and leveraging various Platform/Data Quality Transforms in SAP Business Objects Data Services (BODS).
• Hands-On experience in creating BOBJ Analytical reports using HANA Information Models.
• Extensively worked on integrating data within HANA from heterogeneous systems for the purpose of building Cross functional and Cross Business reporting models.

Confidential

Responsibilities:

• Design/create/configure and maintain Data modeling objects including Infoobjects, DSO’s, Info Cubes, SPO, Transformations, DTPs, Info Sets, MultiProviders, Process Chains, Open Hub.
• Install SAP BI Content data flow for functional applications including SD, MM, PP, QM and FI-CO.
• Create source system connections including SAP, BW, File, DB Connect and UD Connect.
• Extract Logistics data (LO Cockpit), Finance data and Controlling data from SAP ECC.
• Extract ECC data by creating Custom Extractors based on Table/View and Function Modules.
• Extensively used ABAP Programming within Start/End/Expert routines in Transformations, BW Customer Exits for Global Reporting Variables and Datasource enhancement, BADIs, BW Data Mining logic implementation within APD, BW Custom Logic BADI for Decision making in process chains and automatic rotation of SPO partitions leveraging BADI.
• Performance optimization including Compression, Aggregates, Indexes, DB Statistics, Partitioning, BW Accelerator and housekeeping activities.
• Created efficient Business Explorer reports using Bex Analyzer, Query Designer, WAD leveraging various features including Calculated Key Figures, Restricted Key Figures, Formulas, Selections, Structures, Conditions and Exceptions.
• Setting up standard role-based authorizations and defining analysis authorizations.

Confidential

Responsibilities:

• Design, develop, deploy complex Universes in Universe Design Tool & Information Design Tool.
• Design Relational and OLAP universe using IDT leveraging Multiple Data sources.
• Create Universes with measures, dimensions, join conditions, Filters, LOV, Cardinality, Aliases, Contexts, Index awareness, Derived tables and Aggregate Awareness using UDT and IDT.
• Involved in query performance tuning of SAP NetWeaver BW Universes.
• Design Develop and Maintain Web Intelligence reports using BICS Connectivity to BEX reports.
• Develop Complex Web Intelligence reports using multiple Queries, merging dimensions/prompts from different universes, drill down, Breaks/Sections and Input Controls to impact all queries within WebI report based on selection criteria.
• Create complex Crystal reports including sub-reports, parameter-based reports, graphical reports, cross-tab reports, drill-down reports and analysis reports.
• Worked extensively on various Business Objects functionalities like Queries, Slice and Dice, Cross Tab, Master Detail, Breaks, Alerts, Filters, Sorts, Ranking, Prompts, and Calculations
• Extensively worked on Advanced analysis for Office/OLAP to create analytical reports by consuming BW info providers, BEx Queries and HANA information models.
• Leverage InfoView/BI Launch Pad to view published reports
• Created visual analytics using SAP Lumira and Design Studio on top of HANA and BOBJ Information Models.