worked and created several dashboards on different datasources including oracle, sql server, excel, impala, sap hana.

Listing Down few Key projects:

1) Integration of SAP Hana with Tableau: For a Pharma based company named Mankind we implemented tableau with SAP Hana, where I used hana as the backend for the data and created sales and purchase reports. I worked as a techinical lead in this project

2) Intergration of Tableau with POS system: A medicine stores company a subsidary of Religare wellness, We implemented Tableau intergration with my sql and prepared market analysis for loyalty customers and other campaigns run by the individuals. I acted as a business analyst and managing all the reports building on tableau

3)Tableau And Impala, Implemented tableau in yes bank using hadoop impalad and migrated all the oracle reports to hadoop system. worked as a manager and handled all client communcation.

4)Tableau And SAp Business one- Used to build all the reports for all thre relevant modules like sales, Account receivables, account payables,balance book. worked as a core developer understanding the responsibilites and skills.

5)Qlikview server installationa and oracle connectivity: Implemented in yesbank qlikview for a finone team for oracle reports

• Created data models based on requirements.
• Created separate structures for different modules.
• Used multiple table joins, union.
• Implemented sales, purchase, footfall, bank statement modules.

• Created data models based on requirements.
• Optimization of queries using indexes.
• Used multiple table joins, union.
• Pre-calculating the required columns.
• Restricting the use of IF and count statements.

• P/L reports required all the chart of accounts.
• All the entries are made into JDT1 tables.
• Joins, Unions were used.
• Create variables.
• Data validation from client and create documentation.

• P/L reports required all the chart of accounts.
• All the entries are made into JDT1 tables.
• Joins, Unions were used.
• Create variables.

Data validation from client and create documentation

• Gathering and analyzing requirement specifications.
• Convert SQL queries into IMPALA (Non-SQL language).
• Create queries to run faster and optimize the report.
• Load the data from IMPALA into Tableau environment.
• Create parameter and calculated fields.
• Different chart objects like Bar Chart, Line Chart, Bubble Chart, Straight table and Maps.
• Responsible for dashboard design, layout, look and feel and development.

Publishing the report on the client-based server

• Created data structures based on requirements in power BI.
• Created separate structures for different modules.
• Used multiple table joins, unions, created several inventory reports.