Shibasis Mishra

With over 3 years as a Tableau Developer, specialize in translating complex data into compelling visualizations and interactive dashboards. Proficient in Tableau Desktop, excel in data analysis, modeling, and optimization. Expertise includes connecting Tableau to various data sources and implementing advanced calculations. Collaborative and communicative, effectively engage with stakeholders to meet business requirements. Creative and detail-oriented, design visually appealing dashboards. Committed to staying current, continuously enhance skills to deliver high-quality solutions that empower informed decision-making

• DOB- 16th July 1996
• Permanent Address- Plot no-2218, Sabarsahilane, Kalpanasquare, bhubaneswar,Odisha-751006

• Resolved product issue through consumer testing.
• Awarded With Emerging Talent Award in Financial year 2022-23.
• Used Microsoft Excel to develop inventory tracking spreadsheets.

• Project Name- Finance Dashboard (Banking)
  Technology Used- Tableau Online, Tableau Desktop 2021.4 , Presto, SQL, Superset, MS-Word
  Deployed over 100+ analytics projects for all departments using Tableau 2021.4 and Tableau online.
  Strong hands on experience implementing dashboards, data visualization and Analytics using Tableau Desktop and
  server.
  Created Product Leval and Branch level Dashboards which increased revenue by 5% By a quarter.
  Conducted data analysis, performed business-analysis tasks (such as creating project plans), received data and records
  in multiple formats, and worked on performance-turning to help in comprehending joins and data distribution.
  Used advanced chart visualizations in Tableau—such as dual axis, box plots, bullet graphs, tree maps, bubble charts,
  and waterfall charts—to solve complex problems and to create interactive dashboards and visualizations.
  Developed and reviewed simultaneous SQL queries in Tableau Desktop to validate both static and dynamic data for
  data validation.
  Utilized Tableau Desktop to create multiple rich dashboards that appropriately told stories of business status and success,
  strengths and weaknesses, and potentials; also offered at a glance, visual representations of profitability, products, and
  Branches.
  Ability to handle multiple tasks concurrently and meet the deadlines.
• Project Name- Pharmaceutical Sales Dashboard (Omnichannel Dashboard)
  Technology Used- SSIS, Tableau, Snowflake
  Created ETL packages in SSIS and Checked the data counts in SQL Server. As per the requirements, the target will be
  Snowflake.
  Scheduled the package run and created full load in SSIS container.
  Connected Snowflake to Tableau using Snowflake ODBC connector.
  Supported the development and modification of Tableau views in Tableau Desktop 2021.4, while preparing
  documentation and training users from respective units
  Scheduled automatic refresh in Tableau Server and uploaded into that server with data source.
  Generated advanced Tableau dashboards with quick/context/global filters, parameters and calculated fields that.
• Project Name- Sales and Customer Insight Dashboard
  Technology Used- SSIS, Tableau, Snowflake, MS-Excel, MS-Word, SQL, Tableau Sever
  Supported Sales Target with Cohort Analysis,driving up - sell by +40%.
  Connected Snowflake to Tableau using Snowflake ODBC connector.
  Scheduled automatic refresh in Tableau Server and uploaded into tableau server with data source.
  Created six dashboards and given actions to the dashboards.
  Used Calculated fields for Rank ,date diff, datetrunc, if statements. Created a dashboard and used global filter.
  Created a dashboard to show total sales and profit, loss(using bullet chart) and created donut charts also to represent
  data.
• Project Name- Retail Dashboard
  Technology Used-Tableau, Tableau Online, SQL
  Worked closely with DevOps and management teams to create IT and data visualization solutions in a consumer
  products firm with $80M in annual revenue.
  Supported Sales targets with cohort analysis, driving up-sells +40%.
  Generated advanced Tableau dashboards that allowed us to track and improve customer units KPI by 12% within a
  month.
  Developed 3 Tableau dashboards, providing insights that allowed management to focus on loyal customers, raising
  revenue 15%.
  Experience in efficiently using standard Business Content, extending and enhancing according to the report
  requirements.
  Communicate Effectively with colleagues and Business users.
  allowed to track and improve customer units KPI by 12% within a month.

• Project Name- Finance Dashboard (Banking)
  Technology Used- Tableau Online, Tableau Desktop 2021.4 , Presto, SQL, Superset, MS-Word
  Deployed over 100+ analytics projects for all departments using Tableau 2021.4 and Tableau online.
  Developed a series of interactive dashboards that automated the financial reporting process, reducing the time taken to generate reports by 10%, resulting in improved efficiency and quicker decision-making.
  Created predictive models within Tableau that utilized historical financial data to generate accurate revenue and expense forecasts, contributing to more accurate budget planning and resource allocation.
  Designed and implemented executive-level dashboards that provided real-time insights into key financial metrics such as revenue, expenses, profitability, and cash flow, enabling executives to make informed decisions on-the-fly.
  Developed visualizations to identify and analyze potential financial risks, such as market volatility or regulatory changes, helping the organization proactively adapt its strategies to minimize exposure.
  Built cost analysis dashboards that allowed the finance team to identify cost-saving opportunities by visualizing expenditure trends across departments and recommending areas for optimization.
  Utilized Tableau's calculated fields and custom functions to handle complex financial calculations, such as ROI, NPV, IRR, and CAGR, directly within dashboards for easy analysis. Played a key role in improving data quality by identifying and rectifying inconsistencies and errors in financial data sources, leading to more reliable and trustworthy dashboards.
  Created compliance-oriented dashboards that visualized the organization's adherence to financial regulations and standards, enabling stakeholders to quickly assess and address any compliance gaps. Established visualization best practices within the organization, ensuring that financial dashboards followed industry standards for clarity, accuracy, and effective communication of insights.
• Project Name- Pharmaceutical Sales Dashboard (Omnichannel Dashboard)
  Technology Used- SSIS, Tableau, Snowflake
  Developed an interactive dashboard that provided pharmaceutical sales representatives with insights into their territory's sales performance, prescription trends, and physician interactions, leading to more targeted sales strategies and increased revenue.
  Created a visualization that showcased prescribing patterns of physicians, identifying top prescribers, therapeutic areas, and potential growth opportunities, enabling the sales team to tailor their engagement strategies effectively.
  Built a dashboard that compared the market share of different products within specific regions, helping sales teams understand competitive dynamics and make data-driven decisions to gain market advantage.
  Developed a dashboard to track the distribution of product samples to healthcare professionals, ensuring compliance with regulations while optimizing sample allocation to maximize impact on prescription rates.
  Created a dashboard that segmented physicians based on prescription behavior, enabling targeted marketing efforts and personalized engagement approaches based on each segment's preferences and needs.
  Developed a real-time dashboard that tracked adverse event reports associated with products, helping the pharmacovigilance team identify and respond promptly to potential safety concerns.Designed a dashboard that compared sales forecasts to actual sales data, facilitating better demand planning and inventory management, and reducing the risk of stockouts or overstock situations.
• Project Name- Sales and Customer Insight Dashboard
  Technology Used- SSIS, Tableau, Snowflake, MS-Excel, MS-Word, SQL, Tableau Sever
  Supported Sales Target with Cohort Analysis,driving up - sell by +40%.
  Connected Snowflake to Tableau using Snowflake ODBC connector.
  Scheduled automatic refresh in Tableau Server and uploaded into tableau server with data source.
  Created six dashboards and given actions to the dashboards.
  Used Calculated fields for Rank ,date diff, datetrunc, if statements. Created a dashboard and used global filter.
  Created a dashboard to show total sales and profit, loss(using bullet chart) and created donut charts also to represent
  data.
• Project Name- Retail Dashboard
  Technology Used-Tableau, Tableau Online, SQL
  Designed an interactive dashboard that visualizes daily sales data across different departments and store locations, enabling managers to quickly identify trends, top-performing items, and areas needing improvement.
  Created a supplier performance dashboard that displayed key metrics such as delivery times, product quality, and pricing trends, assisting procurement teams in negotiating better terms and building stronger relationships with suppliers.
  Built a customer segmentation dashboard using demographic and purchase history data, enabling marketing teams to target specific customer segments with personalized promotions, resulting in improved customer engagement.
  Created a dashboard that analyzed competitor pricing data and customer response to price changes, helping pricing teams adjust Walmart's pricing strategy for improved competitiveness and profitability.
  Created a dashboard for HR and management teams to monitor employee performance metrics such as attendance, productivity, and customer interactions, assisting in performance reviews and workforce management.
  Built a dashboard that calculated the return on investment (ROI) for store upgrades and renovations, helping store managers prioritize investments that lead to the highest revenue growth
  allowed to track and improve customer units KPI by 12% within a month.

• Project Name- Finance Dashboard (Banking)
  Technology Used- Tableau Online, Tableau Desktop 2021.4 , Presto, SQL, Superset, MS-Word
  Deployed over 100+ analytics projects for all departments using Tableau 2021.4 and Tableau online.
  Analyzed potential financial risks, such as market volatility or regulatory changes, helping the organization proactively adapt its strategies to minimize exposure.
  Utilized Tableau's calculated fields and custom functions to handle complex financial calculations, such as ROI, NPV, IRR, and CAGR, directly within dashboards for easy analysis. Played a key role in improving data quality by identifying and rectifying inconsistencies and errors in financial data sources, leading to more reliable and trustworthy dashboards. Granted and Restricted Permission for all the users and Groups.
• Project Name- Pharmaceutical Sales Dashboard (Omnichannel Dashboard)
  Technology Used- SSIS, Tableau, Snowflake
  Developed a real-time dashboard that tracked adverse event reports associated with products, helping the pharmacovigilance team identify and respond promptly to potential safety concerns.Designed a dashboard that compared sales forecasts to actual sales data, facilitating better demand planning and inventory management, and reducing the risk of stockouts or overstock situations.
• Project Name- Sales and Customer Insight Dashboard
  Technology Used- SSIS, Tableau, Snowflake, MS-Excel, MS-Word, SQL, Tableau Sever
  Supported Sales Target with Cohort Analysis,driving up - sell by +40%.
  Connected Snowflake to Tableau using Snowflake ODBC connector.
  Scheduled automatic refresh in Tableau Server and uploaded into tableau server with data source. And Provided Churn Analysis.
• Project Name- Retail Dashboard
  Technology Used-Tableau, Tableau Online, SQL
  Designed an interactive dashboard that visualizes daily sales data across different departments and store locations, enabling managers to quickly identify trends, top-performing items, and areas needing improvement.
  Built a dashboard that calculated the return on investment (ROI) for store upgrades and renovations, helping store managers prioritize investments that lead to the highest revenue growth allowed to track and improve customer units KPI by 12% within a month.

Project Name- Banking Domain (Finance and Customer Dashboard)

Tools Used:  Tableau Desktop (2023.1), Tableau Server, Tableau Online, SQL, MySQL, Presto, Superset,Excel

Summary:-

• Developed and maintained Tableau dashboards that provided real-time insights into the MNC Bank's financial performance. Visualizations included key metrics such as revenue, profitability, and asset distribution, enabling executives to make informed decisions promptly.
• Played a key role in developing Tableau reports that supported regulatory compliance, ensuring accurate and timely submission of financial reports to regulatory authorities. These dashboards streamlined the reporting process and minimized the risk of compliance-related issues.
• Conducted data integration from multiple sources and optimized Tableau queries, resulting in a 25% improvement in dashboard loading times.

Project Name - Pharmaceutical Domain (Omnichannel Dashboard)

Tools Used:  Tableau Desktop (2022.3), Tableau Server, Tableau Online, SQL, Excel

• Develop Tableau dashboards that integrate and analyze data from various marketing channels such as digital advertising, social media, email campaigns, and sales force interactions. This enables stakeholders to gain insights into the effectiveness of multichannel marketing strategies.
• Create visualizations within Tableau that showcase sales performance across different channels, regions, and products. These dashboards can help identify high-performing channels and optimize sales strategies for pharmaceutical products.

Project Name - Retail Domain (Sales and Customer Dashboard)

Tools Used:  Tableau Desktop (2021.1), Tableau Server, MySQL,SSIS, Snowflake

• Develop Tableau dashboards that enable retail businesses to segment and profile customers based on demographics, purchasing behavior, and preferences. These visualizations empower marketing teams to create targeted campaigns and personalized promotions.
• Implement Tableau dashboards that visualize customer purchase history and provide personalized product recommendations. This enhances upselling and cross-selling opportunities, improving overall customer satisfaction and increasing average transaction values.
• Developed and maintained Tableau dashboards for real-time monitoring of key performance indicators, resulting in a 20% improvement in data accessibility.