Hardik Bapna

SAP BI Analyst

TCS•  October 2017 - Present

⬧ Worked on HANA Data Modelling based on Design Specific requirements. ⬧ Prepared Design Specification Document for GSSV(Global Sales Services Bookings and Forecast) implementations. ⬧ Created Calculated columns, restricted columns to perform business specific calculation. ⬧ Created variables, input parameters, filters, rank function to meet necessary business logic. ⬧ Created HANA Tables to cache data for better performance. ⬧ Developed Full and Delta procedures to load data into cache tables. ⬧ Developed table function and analytical privilege to implement authorization checks. ⬧ Working on troubleshooting issues related to WEBI and Explorer reports and authorization issues. ⬧ Worked in IT Direct ticketing tool to resolve issues within SLA.