Completed a Commercial Data warehousing project and delivered to the sales team in US. Was responsible for understanding the requirement to increase Incedos technical capabilities for Pharma commercial domain. Integration of the SQL database to Tableau and dashboard building to show the business insights by defining the Key point indicators. Also have designed the same sets of KPIs and charts on Power BI for demo purpose.

A/B testing project focusing on its existing plans and products performance wrt the market. Have set up a proper cloud based Tableau and AWS Kinesis integrated solution where the real time data are monitored.

Developed the Tableau Sourcing Dashboard and Automated Reports. Launch Analytics using Tableau, Market Basket & product launch readiness Patients Claims, Prescriber & Non Retail sales, Targeting, Alignment, share & split Responsibilities Interaction with the client on daily basis to understand their existing application and extensively worked to confirm and clarify requirements and business logic. Worked with client to identify the KPIs and matrices to measure the business performance. Creating the Dashboard and Report level prompts for CIO in the designated Organization. Customized Reports look and Feel using Column Formatting, Conditional formatting. Creating dimensional hierarchies as per business requirements. Creating the requests in answers and see the results in various views like table view, view selector, chart, pivot table, ticker and legend. Created the Business Users Reports, saved filters and prompts to improve the performance. Tested and validated the reports. Involved in Performance Tuning Created reports using BI publisher as per user requirements

Project Name : Tresor Sales Analysis Dashboards

Role

Tableau Developer/Administrator

Database

Tableau 9.x, Ms SQL Database

Platform

Tableau

Team Size

2

Duration

2 months

Description

Developed and Deployed the Tableau Dashboard for Retail Analysis.

A Tableau dashboard for Sales & Commercial Analytics is a solution that enables the business users to view the status of their business with respect to various Activities, Trainings, Sales and Compensation. It also provides self-service BI capabilities to business user for their reporting and data requirements.

Responsibilities

• Migrate Excel Report to Tableau Environment
• Connect deferent views according to requirement
• Created new views using different charts.
• Created Dash board using views.
• Prepare the calculated field to achieve the requirement.
• Created quick filters
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel.
• Created Users, Groups and Projects on Tableau Server.
• Created customized and interactive dashboards using multiple data sources

Project Name : PNB Housings Finance LTD

Role

Tableau Developer

Database

Ms SQL Database & Excel Files

Platform

Tableau

Team Size

2

Duration

2 months

Description

Developed the Tableau Sourcing Dashboard and Automated Reports.

Tableau Sourcing Dashboard and Automated Reports is a solution that enables the business users to view the Daily disbursal calendar, total disbursement, Login to disb. TAT, Branch level analysis, disbursement trend, Login to disbursement TAT, and Avg. cibil score. It also provides self-service BI capabilities to business user for their reporting and data requirements.

Responsibilities

• Interaction with the client on daily basis to understand their existing application and extensively worked to confirm and clarify requirements and business logic.
• Worked with client to identify the KPIs and matrices to measure the business performance.
• Creating the Dashboard and Report level prompts for CIO in the designated Organization.
• Dashboard for Daily disbursal calendar, total disbursement, Login to disb. TAT, Branch level analysis, disbursement trend, Login to disbursement TAT, Avg. cibil score for approved applications.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Creating dimensional hierarchies as per business requirements.
• Creating the requests in answers and see the results in various views like table view, view selector, chart, pivot table, ticker and legend.
• Created the Business Users Reports, saved filters and prompts to improve the performance.
• Dashboards mainly for the Login and Disbursal reports.
• Tested and validated the reports.
• Involved in Performance Tuning
• Created reports using BI publisher as per user requirements

Developed the Tableau loan Analysis Dashboards and Reporting system. Loan analysis and Reports is a solution that the business users can visit daily to know the status of their disbursals, instead of quarterly static reporting provide Self-Service reports for Though Leader liaisons and Field operation team with role based access. It also provides self-service BI capabilities to business users for report for their reporting and data requirements. This Solution consolidates data from multiple data sources to provide a 360 degrees mash up view. Responsibilities Gathering data from different sources like SQL Server, Oracle and creating Tableau data model to be used for Dashboard Stabilized the connection for various Data Sources. Customized the expressions and the scripts and done the necessary data transformation, created simple and complex expressions (using Set Analysis). Understand Requirement, Analyzing Systems and Source Databases. Designed, developed and implemented Tableau Business Intelligence reports. Create basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements and quicktable calculations. Representing data using the visualizations using Charts. Development of back-end (Oracle) to fulfill the UI requirement. Use Trend Lines, Reference Lines and statistical techniques to describe the data. Use Measure name and Measure Value fields to create visualizations with multiple measures and dimensions. Responsible for dashboard design, look and feel and development. Use parameters and input controls to give users control over certain values. Combine data sources by joining multiple tables and using data blending Involved in daily stand up with business analysts and data architect to resolve the business issues and Data challenges. Worked independently and capable of multitasking & prioritizing in a fast paced and agile work environment.