• Weekly meeting with business analyst to gather business requirements and designed functional and technical requirements documentation
• Creation of Database schema.
• Creation of Aggregated tables for OLAP analysis. • Creation of ETL scripts using PentaHo DI.
• Loading data in Snowflake warehouse.
• Designing and Developing 15+ Dashboards using Tableau.
• Random simulated data generation in ETL scripts for testing the dashboards • Creation of various types of users, sites, groups and publishing of data sources and workbooks at Tableau Server.
• Testing of reports using Tabjolt and Scout testing tool as per requirement.
• Optimization of dashboards and performance improvement.
• Conversion of Tableau Reports in Power BI.
• Transfer of data from Snowflake to S3 buckets in parquet format.

• Interacting with business analyst to gather business requirements and designingfunctional and technical requirements documentation.
• Understanding the KPIs and Requirements Documents.
• Integration, transformation, and loadingthe data from various data sources into DW.
• Designing and Developing 10+ Dashboards using Tableau for student’s academic as well as financial information, faculty evaluation and university admission sales information.
• Testing and validating the generated reports in collaboration with the Users.
• Migration of reports from Tableau Desktop to Tableau Server.

• Interaction with the business analyst for creation of requirements and function document.
• Creation of tables in postgres for storing the company’s resources, employees, salary data.
• Creation of reports and dashboards in Grafana for quarterly rating and salary information of employees.
• Used user-defined plugins like Calendar, Pie Chart etc. for creating more interactive reports.
• Creation of users, roles, groups in Grafana for providing different access to the different level of users.
• Reports and dashboards creation in Tableau to analyze the budget, revenue and sales at management level.
• Migration of dashboards from Tableau Desktop to Tableau Server.
• Testing of the dashboards and to optimize their performance

• Understanding the KPIs and Requirements Documents.
• Involved in creating complex Dashboards on Tableau and performing advanced analytics to analyze data of employees, sales and forecasting for the decision-making perspective of the organization.
• Extensively used the concepts of Aggregation, Blending, Parameters, Hierarchies, Charts, Filters, Table Calculations, and Calculated fields.
• Transformed complex business logic into Database design and maintained it by using SQL objects like Stored Procedures, User Defined functions, Views and Triggers.
• Deployed Dashboards on Tableau Server and manage its delivery.
• Integration, cleansing and transformation of the data as per DW format.
• Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and Test Data
• Optimization of the dashboards after analyzing the test results

Databases: Oracle, SQL Server, Spreadsheets Tools: MS Excel, SQL Developer, SSMS, PentaHo DI (Kettle), Tableau Roles and Responsibilities Understanding the KPIs and Requirements Documents. Involved in creating complex Dashboards on Tableau and performed advanced analytics to analyze data of employees, sales and forecasting for decision making perspective of the organization. Extensively used the concepts of Aggregation, Blending, Parameters, Hierarchies, Charts, Filters, Table Calculations, and Calculated fields. Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined functions, Views and Triggers. Deployed Dashboards on Tableau Server and manage its delivery. Integration, cleansing and transformation of the data as per DW format. Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and Test Data Optimization of the dashboards after analyzing the test results.

Databases: Postgres Tools: SSMS, PG Admin, Grafana, Tableau Roles and Responsibilities Interaction with the business analyst for creation of requirements and function document. Creation of tables in postgres for storing the companys resources, employees, salary data. Creation of reports and dashboards in Grafana for quarterly rating and salary information of employees. Used user-defined plugins like Calendar, Pie Chart etc. for creating more interactive reports. Creation of users, roles, groups in Grafana for providing different access to the different level of users. Reports and dashboards creation in Tableau to analyze the budget, revenue and sales at management level. Migration of dashboards from Tableau Desktop to Tableau Server. Testing of the dashboards and to optimize their performance.

Databases: SQL Server, Postgres Tools: SSMS, PG Admin, PentaHo DI (Kettle) Roles and Responsibilities Collection of requirements from Business analyst and designing of requirements document. Creation of Database schema in Postgres using PG Admin from moving data from SQL Server. Creation of users and roles for accessing the database. Automation done by creating stored procedures. Creation of ETL scripts using PentaHo DI. Automation of SQL Scripts to test the result sets at the Postgres and SQL Server databases. Improvement in queries. To optimize the ETL scripts and development of all the reports in latest version.

Built dashboards for financial clients to track KPIs like revenue, profit, OTD, FPY that display ACT/FC/Budget values, reducing manual effort by 60%

Supported data analysis and decision-making at GNA University, improving academic and administrative processes and enhancing performance insights

Built dashboards for retail/warehouse KPIs like inventory, sales, and fulfillment, improving visibility and decision-making