• 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.

Designing Business Dashboards as per KPIs shared by client like sales, purchase, expense analysis.

Using POS system to create multiple sales report.

Used Microsoft Nav as ERP and Tableau to create the reports like purchase, sales, inventory.

Used SAP B1 as ERP and Tableau to create majorly P/L reports by zonal sales manager and company financials.

Dynamically designed dashboards and converting reports from Pentaho to Tableau.

Converting crystal reports of SAP B1 to Microsoft Power BI.

Auditing of QlikView Reports/Submitting a detailed audit report.

SIPL is a mall management project, which uses SAP B1 as ERP. Backend was SQL Server. We needed to create module wise dashboards for Sales, Purchase, Account Receivables, Account Payable, Inventory. Created data models based on requirements. Created separate structures for different modules. Used multiple table joins, union. Implemented sales, purchase, footfall, bank statement modules.

Fortis health world has retail medicinal store all over India. Backend was MYSQL. They have POS systems assigned all over the stores. They need many different KPI regarding sales. Loyalty rewards. Member analysis of different customer walk-in. 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.

They use Microsoft NAV as ERP and had requirement of creating multiple sales, purchase, inventory reports for different manufacturing plants. Backend was SQL Server. They had a specific requirement of creating sales, purchase report. Tagging of data was suggested by us. Created index on the tables. 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.

Emami Frank Ross Pharmacy which uses ECOGREEN as ERP. Auditing QlikView server parameters, 3- tier architecture. Usage of unnecessary functions. Replacement of joins with Apply Map. Checking the data models based on requirements. Created separate QlikView files for different modules. Checking use of multiple table joins, unions. Simplifying data structures, creating only QVD which are necessary.

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