Project # 3
Project Name : Loblaws
Domain : Retail Domain
Role : Tableau Developer
Environment : Tableau Desktop , SQL Server, Excel
Duration : Dec 2023 – Sep 2024
Description :
A Canadian grocery company called Loblaws operates under the Loblaws City Market brand in the provinces of British Columbia, Alberta and Ontario. Primarily a subsidiary of Loblaw Companies Limited, the largest food wholesaler in Canada. Loblaws has its headquarters situated in Brampton, Ontario.
Roles and Responsibilities
- Analyzing and understanding the user stories and acceptance criteria.
- Developed various views, dashboards and customization of dashboards.
- Created filters, table calculations and calculated measures.
- Handling user filter, filter actions, data blending, joins etc.
- Created action filters, parameters and sets for preparing dashboards and worksheets., Publishing sheets and dashboards on server using Tableau desktop.
- Published workbooks by creating user filters to restrict access to only the relevant teams.
- Created aggregations, calculated fields, table calculations, totals, percentages using Key Performance Indicators (KPI) and measures.
- Creating views for YTD, QTD, MTD, YOY, QOQ, MOM views for corporate actions.
- Consistently participating in client conversations to discuss project status and new requirements.
- Expertise in Aggregations, Forecasting, Trend lines, Formatting in Tableau.
- Used Tableau desktop extensively to build Heat maps, Tree views, Bar charts, Gantt charts, Geographical maps, dashboards using Stack Bars.
- Designed and deployed reports with Drill up and Drop down menu option, Parameterized and Linked reports using Tableau.
Project #2
Project Name : Albertsons
Domain : Retail Domain
Role : Tableau Developer
Environment : Tableau Desktop, SQL Server, Excel
Duration : May 2023 – Dec 2023
Description :
Founded in Boise, Idaho, Albertsons Companies, Inc. is an American grocery chain. The firm is the second-largest grocery chain in North America, after Kroger, with 2,253 locations as of the third quarter of fiscal year 2020 and 270,000 employees as of fiscal year 2019.
Roles and Responsibilities :
- Used Measure Names and Measure Values field to create visualizations with multiple measures and dimensions.
- Creating dashboards in Tableau using calculations and parameters.
- Utilized filters, sets, parameters, quick filters and calculated fields in Tableau reports.
- Used Trend lines, Aggregate Functions, table calculations and Filters., Analyzing and obtaining insights from massive data sets with Tableau desktop.
- Developed Interactive Dashboards using various tableau objects like Actions, Parameters and Filters in various levels.
- Seek for ways to maintain the accuracy of the primary information being conveyed while also adding visual appeal to graphs and tables.
- Involved in design and development of various reports utilizing Tableau Visualizations such as bar charts, line charts, pie charts, area charts, heat maps, tree maps and some additional sophisticated visualizations.
- Created Actions, Parameters, Filters and Calculation sets for preparing dashboards and worksheets.
- Developed reports with consistent drill-down functionality including Drilldown report and Summary report.
- Optimize Tableau workbooks and dashboards for performance and speed, ensuring efficient data loading and visualization.
Project #1
Project Name : HPE ProCurve
Domain : Ecommerce
Role : Tableau Developer
Environment : Tableau Desktop, Oracle, Excel
Duration : Dec 2015 – Sep 2022
Description :
The Hewlett Packard Enterprise firm (HPE) is a business-focused, global American information technology firm with headquarters in Spring, Texas. Its products include servers, storage, networking, containerization software, consulting and support.
Roles and Responsibilities :
- Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development and production rollover of reporting and analysis projects within Tableau Desktop.
- Developed reports and dashboards using Tableau desktop in close collaboration with corporate power users.
- Developed a heat map that breaks down the regions of our current service customers by color so that business users can identify where we have the most and least users.
- Created prompts, customized calculations, conditions and filter (local, global) for various analytical reports and dashboards.
- Reviewed basic SQL queries and edited inner, left and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
- Scheduled weekly and monthly Tableau Server data refreshes in response to business changes to ensure the views and dashboards were appropriately displaying the updated data.
- Merged different tables and data sources via data blending.
- Connecting and updating massive datasets via filtering, grouping and aggregations.
- Used Tableau desktop to analyze and obtain insight into large datasets.