profile-pic

Aditi Ghosh

Vetted Talent

Aditi Ghosh

Vetted Talent

At Dell Technologies, we transform complex data into actionable insights, driving operational growth and marketplace efficiency. A Master of Science in Instrumentation Science from Jadavpur University equips me with a robust analytical foundation, maximizing the potential of BI tools like Tableau to enhance business reporting processes.

Our team prioritizes strategic decision-making, ensuring each insight delivers tangible business value. With a skillset that includes Power BI and shareholder communications, my goal is to continuously innovate and contribute to Dell's data-driven success.

  • Role

    Senior Bi Analyst

  • Years of Experience

    7.5 years

Skillsets

  • Power BI
  • Business analytics
  • Mssql queries
  • Good problem solving skills
  • Teradata sql
  • Mentoring
  • Business Intelligence
  • Data Visualization
  • Analytical Skills
  • Data Validation
  • Client handling
  • Knowledge Of Data Modeling And Data Warehouse - 3 Years
  • Hadoop
  • SQL
  • Tableau
  • Data Analysis
  • Training
  • Writing Dax Expressions - 3 Years
  • Troubleshooting Performance Issues In Reports - 3 Years
  • Power Bi Reports Development - 3 Years
  • Knowledge Of Query Performance Tuning - 2 Years

Vetted For

12Skills
  • Roles & Skills
  • Results
  • Details
  • icon-skill_image
    Power BI - Team LeadAI Screening
  • 50%
    icon-arrow-down
  • Skills assessed :Oracle, Performance Tuning, Queries, stored procedures, Data warehouse, Database structure, dax, Indexing, Power BI, Data Modelling, PostgreSQL, SQL
  • Score: 45/90

Professional Summary

7.5Years
  • Senior Bi Analyst

    Dell
  • Visualization Practitioner

    Brillio Technologies
  • Technical Analyst

    Infosys
  • Presales Consultant

    Comtech IT solutions Pvt. Ltd.
  • Pre-sales Consultant

    Goldstone Technologies

Applications & Tools Known

  • icon-tool

    Tableau

  • icon-tool

    Power BI

  • icon-tool

    MSSQL

  • icon-tool

    Hadoop

  • icon-tool

    Ubuntu

  • icon-tool

    Hive

  • icon-tool

    AWS Quicksight

  • icon-tool

    Domo

Work History

7.5Years

Senior Bi Analyst

Dell
    Generated reports from multiple databases using SQL Server Reporting Services. Developed and maintained data models for BI projects. Designed dashboards with interactive visuals in Tableau and Power BI for better decision making. Performed data analysis using Excel, Tableau, Power BI., to provide insights into customer trends. Created SQL queries and views to support reporting needs. Collaborated with IT teams on developing strategies for managing large datasets efficiently. Identified opportunities for improvement in existing database structures and querying techniques. Implemented best practices for data collection, storage, retrieval and analysis across multiple platforms. Worked collaboratively with developers and other stakeholders to ensure successful delivery of BI solutions.

Visualization Practitioner

Brillio Technologies
    Worked on debugging and rebuilding existing Tableau reports. Participated in the Data Governance activities for data cleaning on the tools and databases. Provided layout designs for new and existing reports. Explored new BI tools like AWS Quicksight, Domo etc.

Technical Analyst

Infosys
    Developed and maintained Tableau dashboards with interactive visualizations. Created custom views, charts, graphs, filters, parameters, and data sources to meet specific user requirements. Developed complex calculations using Tableau functions such as LOD expressions and table calculations. Implemented best practices for optimizing the performance of Tableau reports and dashboards. Assisted in designing and developing ETL processes to extract data from multiple sources into a single repository for analysis in Tableau. Analyzed large datasets to identify trends, patterns and correlations utilizing advanced analytics techniques in Tableau. Deployed Tableau Server security settings including authentication methods, permissions, row-level security settings. Optimized SQL query execution times by making use of indexes and partitioning techniques in order to improve report performance. Developed interactive drill down features across multiple levels of detail within dashboards.

Pre-sales Consultant

Goldstone Technologies
    Provided technical expertise on Tableau Products throught POC or demo. Deployed into Tableau development work in client location. Closely worked with the Business Development team to identify and generate geniue customers or prospect looking for Tableau product or services.

Presales Consultant

Comtech IT solutions Pvt. Ltd.
    Market research and analysis on Big Data Ecosystem to be used for any upcoming Big Data project needs. Provide solution architect using IOT and, Big Data tools as per the client requirement. Closely with the BD team for RFP, RFQ and, other sales activities for the US market.

Major Projects

4Projects

Customer Feedback Reports

    I worked for one of the client of Infosys which is a well known Cosmetic company in USA. The database used was MSSQL. We had to fetch the view from the DB and, build customer feedback reports on Tableau. We were a team of three members and, my role was to build the tableau reports, showcase the same to clients for their feedback and, implement the changes required. Also, publish the same reports to Tableau Server.

YTD and MTD COO sales report

    I worked as a Tableau Developer for one of the clients of Goldstone Technologies in the client location. As a Tableau Developer I have to prepare the YTD and MTD reports for the COO by using SAP BW as the primary database. With prior discussion with the client I had to include all the sales KPI that can help them know the current sale and their target starting from the fiscal year till date. Had to write complex date calculations on Tableau as well as troubleshoot the issues faced while uploading the dashboard on to the client server.

Consumer Offers

    The dashboard was build on Tableau and the audience for these reports was Customers from Telecom and Retailers as well as the associated Business heads. It comprised of summary charts in tabular form, Trend charts showing the peaks variations of sales over weeks and years. Used LOD and Parameters to switch between Rolling 13 weeks and Yearly comparison over the same dashboard. Worked on Row-Level Security and dashboard optimization. Build parameter driven Tableau charts and also calender charts to show the highest scorer of the day on a calendar. Use of Teradata as the main source of data. Also, engaged a team of 4 data engineer to work on a specific need to generate filter based pdf of the published report using python script.

Migration of Tableau to Power BI

    Currently working on the conversion of Tableau reports to Power BI report. Created Data Model on Power BI for the report needs. Conversion of LOD calculations to DAX queries. Compare the data between Power BI chart and Tableau to generate the same data maintaining the same granularity in the modified charts. Maintain UI standards by using Json Themes in Power BI.

Education

  • MS/M.Sc(Science)

    Jadavpur University
  • B.Sc

    D H S K Science and Arts College

Certifications

  • Hadoop training from petabytes, mumbai, maharastra