Extraction – SLT, SDA/SDI, OData Services, BW LO Cockpit, Generic Extractions, and Master and Transactional data Extraction, Activating Data Sources and CDS Views,
Expertise on loading data into BW using delta and full upload methods using ODP using multiple sources.
Maintained Info Objects, Data Sources, Info Sources, Info Objects, Info Cubes, ODS/DSO, ADSO objects, Composite Provider, Open hubs, Transformations, DTP, Business content, Info packages, Process Chains
Validated process chains to load the data into the targets and monitoring the same for daily, weekly and monthly schedules
Expertise in Programming of SQL, ABAP and AMDP.
Knowledge on Native HANA Objects like Calculation Views, Table Functions, Stored Procedures, Triggers, Sequences, OData Services and XSJS.
Knowledge on ABAP to Implement Start/End/Field and Expert Routines on BI Transformations. Performed Performance tuning of the code to reduce the Data Load time.
Load Scheduling & Monitoring, Load Error Correction, Process Chain & Load optimization and Root Cause Analysis.
Exposure in the unit and integration testing of the development work and documented the results and Interact with functional team to test the data
Preparation of testing results document and should have knowledge on qtest
Expertise in Agile methodology and experience on using tool like JIRA, ADO etc.
