SAP BW on HANA/BW4HANA Solution Designer, SAP BW on HANA Solution Designer, HANA Senior Consultant

Tech Mahindra, Bangalore India

Roles and Responsibilities:
* Built data flows using LSA++ data model architecture as per the build spec provided by the
lead.
* Developed complex Bex queries for multiple Invoices reports for FI-AP.
* Understanding business rules of the existing data flow and accordingly enhancing the flow as
per the build spec and functional specification.
* Enhanced standard data sources and created generic extractor as per the requirement.
* Implemented new BW and HANA concepts like AMDP transformations, ADSOs, Composite providers,
CDS Views, Table Functions, Stored procedures, Calculation Views and Purning Tables concepts
for improving the performence of data loads and reports.
* Involved in complex ABAP coding required for the KPI logic
* Handled incidents related to multiple live reports in FI.

ITC Infotech, Bangalore India

* Understanding the business rules for the existing flows.
* Created stored procedures in SAP HANA for daily deletion and reload of data as per the
Business rules.
* Monitoring of complex Process Chains. Taking care of Daily and Weekly Jobs as per client
requirements.
* Troubleshooting the process chains and keeping track of the issues that occur.
* Created dataflow for Open Hub destination.
* Helped BODS team in understanding SAP BW system and accessing Open Hub's in SAP BW.
* Sending daily status reports users on the availability of reports.
* Created Process Chains with the reference of existing flows.
* Checking data consistency, aggregates and hierarchies through RSRV.
* Performance tuning by maintaining Aggregates, Compression, Partition, indexing of info cubes .
* Analyzed the ABAP code in where it is taking more time while loading.
* Worked on Open hub destinations to send the data bw to Bods.
* Worked on OLAP cache, broadcast setting and 0TCT_CA1 cube for handling performance issues.

ITC Infotech, Bangalore India

* Extensively worked on data extraction from SAP R/3 using Generic extraction.
* Extensively worked on data extraction from Flat File.
* Created multiple data layers merging Flat file and SAP data as per business rules
* Installing Business content Info Cubes, DSO Objects, Info Objects.
* Implemented BW Formulas, Field routines as per the logic of functional spec.
* Monitoring Data load activities and recovered failures.
* Worked on Enhancements (Data source enhancements and reporting).
* Extensively worked on LO cockpit and Generic data extraction from SAP R/3.
* Created Attribute views, Analytical Views, Calculation views in HANA for POC.

IBM India Pvt Ltd

* Responsible for daily data loads process chains monitoring.
* Resolving process chain failures and updating user on daily basis.
* Maintained reconciliations to verify the data in SAP R/3 and SAP BW were same or not after the
data loads
* Analyzing the reasons for frequent failures of process and providing permanent solutions
* Supported the client by providing long-term solutions to the tickets by doing root cause
analysis
* Maintained work history for all the tickets.
* Updated data from the DSO to Info Cube using with Delta update.
* Uploaded master and transactional data from flat files. SAP BI and SAP R/3.
* Worked Extensively on Administrative workbench (RSA1).