SAFAR MANDAL

Project- Maintenance and Support

Key responsibilities:

• Extract relevant data from Google Analytics using its API.
• Store the extracted data in a PostgreSQL database to facilitate easier querying and integration with Tableau.
• Design visually appealing and insightful dashboards to present the Google Analytics data effectively.
• Perform in-depth analysis of the data to derive meaningful insights, such as user behavior, traffic sources, conversion rates, etc.
• Implement interactive features to allow users to explore the data dynamically, such as filters, drill-down capabilities, and tooltips.
• Set up and configure Tableau Server to host the developed dashboard securely.
• Define user roles and permissions to control access to the dashboard and its data.
• Explore and implement new features available in the latest versions of Tableau, such as predictive analytics, machine learning integrations, and natural language processing capabilities.
• Develop custom extensions or plugins to enhance the dashboard's functionality and provide additional insights.
• Connects to a database to fetch data. Processes the data using Python.
• Publishes the processed data to Tableau Server.
• Creates a description of the project in Tableau.

Technology & Tools Use: Tableau Desktop, Tableau Server, SQL, PostgreSQL, Google Analytics, Python, Excel and JIRA

Project- Product and Supply Chain

Key responsibilities:

• Present Project management for Google Analytics projects, analysing various company websites to extract customer insights regarding potential store locations, products trends, value-add trends, and more.
• Established analytics goals and used some advance Google Analytics features to extract customer information and also reviewed social media to determine, identify, and translate customer behaviour; performed in-depth research and analysis on all available information.
• Prepared and created analytic reports on customer insights such as user geographic location, age groups, and gender using Microsoft Excel (advanced), Word, and PowerPoint
• Presented findings to senior leadership to help inform critical decisions about products and increase brand recognition and customer base
• Made suggestions on which products to use as add-ons with others, based on customer data regarding which products customers would often buy together

• Technology & Tools Use: Tableau Desktop, Tableau Server, SQL, SQL Server, JIRA, Advance Excel, Google sheet and Power Point

Project:- National Gypsum- US

Key Responsibilities:

• Participated in daily stand-ups with clients on daily design and development effort.
• Building prototypes for demonstration and illustration purposes for per groups, Business partners, or senior leaders.
• Preparing charts and visualization as per the requirement. Extensively used data blending, filters, Hierarchies, Transformations, Calculated Fields, customize Calculations, Conditions, Sets, Groups, Parameters, Graphs, Forecast functions.
• Preparing interactive dashboards for data analysis, data mining, Performance KPIs.

Technology & Tools Use: Tableau Desktop, Tableau Server, Tableau Prep, Oracle and JIRA

Project:- Supply Chain Management

Key Responsibilities:

• Participated in daily stand-ups with clients on daily design and development effort.
• Engage with existing or new potential client
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements. Understanding the requirements and functionality of the application from specifications.
• Interacted closely with business users ETL developers, Project Managers & members of the quality assurance teams to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
• Provide solution to client in terms of customized Analytics services.
• Preparing charts and visualization as per the requirement. Extensively used data blending, filters, Hierarchies, Transformations, Calculated Fields, customize Calculations, Conditions, Sets, Groups, Parameters, Graphs, Forecast functions.
• Preparing interactive dashboards for data analysis, data mining, Performance KPIs.

Technology & Tools Use: Tableau Desktop, Tableau Server, Tableau Prep, SQL Server and JIRA