Amritakshya Dey

Senior BI Developer

 

 

 

 

 

Skills

Tableau  SQL, Hive QL

Databases - MSSQL, SAP HANA

Cloud Data Services - Azure SQL , Azure Datalake, Google BigQuery

Alteryx Snowflake TabPy

Agile Methodology Ticketing Tools - HPSM, ServiceNow.

 

Education

B.TECH - INFORMATION TECHNOLOGY

Calcutta Institute of Engineering & Management

2011-2015

 

 

Certifications

Tableau for Data Analysis Azure Fundamentals Python for Data Analysis

 

Summary

BI Developer with 6 years of experience in Data Visualization & Analytics using Tableau. Worked directly with stakeholders on various industry  domain  projects from end to end development, requirement gathering/analysis, design, testing & documentation with a solution oriented approach. Proficient with SQL in data preparation & transformation using ETL concepts & logics for different KPIs/Metrics as per business requirement.

Professional Experience

SENIOR BI DEVELOPER

 May, 2021–present

Migrated Legacy Excel reports to graphic rich Tableau dashboards from scratch using Parameters and Filters for customizing and interactive user experience, thereby increasing efficiency and focus on tracking of KPIs by 30%.

Developed and deployed 30+ dashboards for high level stakeholders, working directly with them, to provide a summary/overview of different business processes.

Analyzed historic data using SQL and visualized Sales data on a YTD,QTD & MTD sections based on different conditions for business users, to plan and strategize on growth.

Created stored procedures in Google BigQuery to clean, transform and prepare raw data post analysis for reporting and visualizations for other teams and business users as well.

Worked closely with scheduling teams to schedule refreshes for DataMart and published data sources for updated reports availability with minimum downtime scenarios.

 

TABLEAU DEVELOPER

Cognizant Technology Solutions | April, 2016– April, 2021

Developed detailed Tableau report for E-commerce domain based client to showcase the SKU records based on warehouse and sales, refreshed on a daily basis to provide the overview of different product records in one place henceforth, reducing manual efforts by 20% on a daily basis.

Analyzed and created datasets using SQL for Insurance domain client and present the customer data using Tableau based on different criteria like  location, age groups etc. to point out sales figures and patterns & also forecast for the next Quarters/Years, estimating growth to achieve by 15% in relevant timeline.

Performed sentimental analysis using TabPy over customer reviews to gain insights on different products/services using advanced analytics to understand behavior patterns.

Worked on ETL tools like Alteryx to cleanse, transform and load raw data from multiple sources (on premise & cloud) to data warehouse to be used by various teams.

Supported & maintained Tableau dashboards, performed enhancements as specified by business team and provided documentation & training to the end- users.