Dynamic and results-oriented professional with extensive experience in SAP BW/4 HANA, ABAP in BI/HANA, HANA Studio, SAP Analytics Cloud and Azure Databricks, honed at prestigious firms including TCS, CTS, IBM India Pvt. Ltd, UST and IGATE. Excelled in leveraging programming and process focus skills to drive significant improvements in data management and reporting efficiency. Proven track record of developing innovative solutions to complex business challenges, enhancing data load performance by over 30%.
I have a short-term onsite experience in Paris for Renault, Sweden for Ericsson AB and US for Applied Materials.
• Preparing gap sheet, Technical specification and functional design document
• Working on HANA Studio to implement BI objects in BI 7.5 on HANA
• Worked on BPC data retraction to SAP BI using AMDP
• Implemented Bex Boolean function in reports
• Implemented CDS view
• Implemented stories/models in SAC
• Worked on Analysis office for Microsoft
• Worked on AMDP’s to improve the data load performance
• Implemented AMDP start, end and expert routines and processed millions of records in complex logic
• Developed customer exit variables using BADI
• Enhance the existing data sources, DSO’s and ADSO’s
• Developing functional module based extractors
• Working on ABAP OOP’s to implement in End routine/Start routine/Expert routines
• Developing ADSO’s and composite providers
• Created various views/tables in sources systems
• Developing Bex queries and BW reports on Analysis for Microsoft excel
• Perform cutover activities.
• Gathering functional requirement from business and converting into BW reporting and Tableau reporting on top of Databricks tables/views
• Preparing gap sheet, Technical specification and functional design document
• Working on finance data sources.
• Working on HANA Studio to implement BI objects in BI 7.5 on HANA
• Worked on BPC data retraction to SAP BI using AMDP
• Implemented Bex Boolean function in reports
• Worked on Analysis office for Microsoft
• Worked on AMDP’s to improve the data load performance
• Implemented AMDP start, end and expert routines and processed millions of records in complex logic
• Worked of SQL Script at Hadoop with Pyspark framework
• Working on Azure Databricks using SQL, Spark SQL and PySpark
• Working on Hadoop Hive and Impala for Analysis
• Developed customer exit variables using BADI
• Enhance the existing data sources, DSO’s and ADSO’s
• Developed time dependent hierarchies on G/L
• Developing functional module based extractors
• Working on ABAP OOP’s to implement in End routine/Start routine/Expert routines
• Developing ADSO’s and composite providers
• Created various views/tables in sources systems
• Developing Bex queries and BW reports on Analysis for Microsoft excel
• Perform cutover activities.
• Gathering functional requirement from business and converting into BW reporting and Tableau reporting on top of Hadoop
• Preparing gap sheet, Technical specification and functional design document
• Working on finance data sources.
• Working on HANA Studio to implement BI objects in BI 7.5 on HANA
• Worked on BPC data retraction to SAP BI using AMDP
• Implemented Bex Boolean function in reports
• Worked on Analysis office for Microsoft
• Worked on AMDP’s to improve the data load performance
• Implemented AMDP start, end and expert routines and processed millions of records in complex logic
• Worked of SQL Script at Hadoop with Pyspark framework
• Working on Azure Databricks using SQL, Spark SQL and PySpark
• Working on Hadoop Hive and Impala for Analysis
• Developed Tableau reports on top Hadoop tables
• Developed customer exit variables using BADI
• Enhance the existing data sources, DSO’s and ADSO’s
• Developed time dependent hierarchies on G/L
• Developing functional module based extractors
• Working on ABAP OOP’s to implement in End routine/Start routine/Expert routines
• Developing ADSO’s and composite providers
• Created various views/tables in sources systems
• Developing Bex queries and BW reports on Analysis for Microsoft excel
• Perform cutover activities.
• Gathering functional requirement from business and converting into BW reporting and Tableau reporting on top of Hadoop
• Preparing gap sheet, Technical specification and functional design document
• Working on finance data sources.
• Working on HANA Studio to implement BI objects in BI 7.5 on HANA
• Worked on BPC data retraction to SAP BI using AMDP
• Implemented Bex Boolean function in reports
• Worked on Analysis office for Microsoft
• Worked on AMDP’s to improve the data load performance
• Implemented AMDP start, end and expert routines and processed millions of records in complex logic
• Worked of SQL Script at Hadoop with Pyspark framework
• Working on Azure Databricks using SQL, Spark SQL and PySpark
• Working on Hadoop Hive and Impala for Analysis
• Developed Tableau reports on top Hadoop tables
• Developed customer exit variables using BADI
• Enhance the existing data sources, DSO’s and ADSO’s
• Developed time dependent hierarchies on G/L
• Developing functional module based extractors
• Working on ABAP OOP’s to implement in End routine/Start routine/Expert routines
• Developing ADSO’s and composite providers
• Created various views/tables in sources systems
• Developing Bex queries and BW reports on Analysis for Microsoft excel
• Perform cutover activities.
• Gathering functional requirement from business and converting into BW reporting
• Preparing gap sheet, Technical specification and functional design document
• Perform cutover activities.
• Developed units conversion at Bex query level
• Implemented Bex Boolean function in reports
• Developed virtual key figure using BADI
• Developed customer exit variables
• Enhance the existing data sources, DSO’s
• Developing functional module based extractors
• Working on Include programs to implement in End routine/Start routine.
• Developing DSO’s, cubes and multi providers
• Developing process chains
• Created secondary index on active tables of DSO’s
• Working on Data source enhancement
• Worked on start routine, end routine and info Object routine in Bi 7.3
• Debug the routines in BI 7.0
• Created various views/tables in sources systems
• Working on LO extractors
• Worked on test plan preparation and unit testing
• Handling sales, purchase and shipment extractors
• Major involvement in Extraction, Data modeling, Creating Cubes, ODS Objects,
• Developing Bex queries and BW reports
• Test cases preparation, execution and document the test cases.
Perform cutover activities.
• Implementation of LSA++ guidelines in SAP BI data model
• Working in build team for new developments
• Attended HANA 300 SAP standard training
• Handling HCM area. Working on head count, personal Administration, Actions etc..
• Implementing function modules, class and methods in start routine and end routines..
• Worked on time dependent master data such as employee, HR position, Orgunit, action type etc..
• Worked on start routine, end routine and infoObject routine in Bi 7.4
• Debug the routines in BI 7.4
• Created various views/tables in sources systems
• Worked on test plan preparation and unit testing
• Worked on Creating custom tables and views
• Worked on open hub destinations
• Developed reports using Variables, Filters, Calculated key figures, restricted key figures, Conditions, Exceptions, Free characteristics and analyzed in BEX analyzer.
• Formatting workbooks and crystal reports
• Major involvement in Extraction, Data modeling, Creating Cubes, ODS Objects,
• Creation & Maintenance of Customized Info Cubes, ODS Objects, Multi providers.
Test cases preparation, execution and document the test cases.
• Worked with business in Sweden to discuss the customer painful area on business Visa
• Worked on Sourcing area with Payment Hit Rate, Invoice Statistics, Region Sourcing Targets etc..
• Worked on Sev1,Sev2,Sev3 and Sev4 Tickets to fix within stipulated SLA.
• Worked on start routine, end routine and infoObject routine in Bi 7.0 o manipulate data.
• Debug the routines in BI 7.0
• Copying queries from one infoprovider to another infoprovider
• Filling and deletion of set up tables
• Worked on BW enhancements
• Adding of additional fields as per new requirement
• Created and added calculated key figures with formula variable
• Worked customer exits
Worked on performance improvement activities
• Worked with business in France to discuss the customer painful area on business Visa
• Worked on open hub destinations
• Requirement gathering from the End user and core Team.
• Worked on test plan preparation and unit testing
• Designing cube, ODS, Multiprovider and infoset
• Worked on Bex Queries, workbooks, RRI and OLAP Cache
• Worked on performance tuning
• Design the SAP – BI Data Modeling, Implement accordingly.
• Created variables with different processing types
Worked on logical partitioning to improve the report performance
• Worked on Business Object Crystal reporting
• Worked on data transfer process and transformations
• Worked on process chain monitoring and fixing issues
• Extensively involved in setting up of procedures for extracting data from SAP R/3 by using Generic Extraction.
• Developed reports using Variables, Filters, Calculated key figures, restricted key figures, Conditions, Exceptions, Free characteristics and analyzed in BEX analyzer.
• Developing the process chains to automate the whole daily delta loads in the development server after initial loads were completed in financials.
Generated and maintained aggregates and rollup activities on info Cubes as part of the info Cube management.
SAP BW/4 HANA, SAP ABAP/4, AMDP and Python, LSA method and LSA++ in SAP BI, Analysis for Microsoft Excel, Bex reporting, Hadoop Hive and Impala, Tableau reports, HANA, DB6, HP OVSC, SAP IT direct, HANA 300
SAP BW/4 HANA and SAP ABAP & AMDP in BI, HANA SQL Scripting, Hadoop Hive and Impala and Azure Databricks using SQL, Spark SQL and PySpark, Technical Lead