Professional Summery
• 10+ years of professional experience engaging with the business stake holders in understanding business needs and provide solutions of SAP Business Warehouse experience encompassing a wide range of skill set, roles and industry verticals on SAP BW4HANA, BW on HANA, HANA, BODS, Embedded BPC, Azure Data Lake, Azure Data Factory and SQL Data Warehouse.
• Worked on Datavard tool to perform data loads from SAP to Azure Data Lake.
• Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer.
• Created multiple Stored Procedures, Pipelines and Power BI Reports as per the Client requirement.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing, experience in Monitoring and Tuning SQL procedures.
• Implemented multiple SAP BW on HANA projects with both Native HANA and SAP BW on HANA Landscapes in Agile Scrum Methodology.
• Worked on SAP Embedded BPC support project, cleared the issues reported by users/functional.
• Developed multiple complex queries on Invoice data for FI Module and fair knowledge FI-AP, AR, AA, GL modules for Procurement to Pay (P2P) and Source to PAY (S2P).
• Experience working on HANA Enterprise Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, Table Fucntions and CDS Views.
• Excellent knowledge on: ADSOs, Composite Providers, AMDP tranformations, HANA Optimized InfoCubes, HANA Optimized DSO's, Transient, Composite, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA.
• Extensivily worked on Standard data sources Enhancement, Genric and ODP data sources creation.
• Handled multiple SAP BW HANA Projects on Scrum model as Solution Designer.
• Experince in extracting data from Non SAP sources into SAP HANA using SDI.