Tanmoy Saha

Work History

Sr Business Intelligence Analyst

Ivanti Technology India Pvt. Ltd.

Kolkata (Remote)

08.2021 - Current

Designed customized data collection models for specific visualization tasks
Developed intelligence-sharing dashboards, providing company-wide access to collected data
Monitored and optimized SQL server performance query and Data model
Gather requirements from users across various departments and developer report according to their requirement
Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs and enhancements
Develop new reports based on user requirement and maintain existing report, fix bugs, ETL pipeline, DAX Functions and add new metrics or KPI into existing report
Migrate Existing Excel and crystal report to Power BI to support user automation demand and trained user how to navigate
Implement incremental refresh to support large dataset and performance
Implement row- level Security among regional directors and manager in Power BI service
Build Data model, transform, shape, cardinality, and cleanse to support user requirement in various developing process
Work closely with DWH team to integrate business intelligence assets into future development lifecycles
E.g., Calculated logics, Area Groupings and Product Groupings
Create and configure workspace to share report, access to user and the entire organization by using Power BI App.

Asst. Manager Business Intelligence

GUS India Education LLP

Hyderabad

10.2020 - 08.2021

Migrate existing ad-hoc reports to power BI to support part of the automation process and to give user the flexibility of access those report from their phones
Maintained Existing ad hoc report across users in excel and provide advice to move them to automated process in Power BI
Experience in working with Power BI service configuration workspace configuration, assign permission and deployments
Schedule meet to gather requirements from user and deliver actionable dashboards, communicate with business users to validate their metrics and KPI through UAT process
Validation dataset side by side against existing transactional system for accuracy
Prepared, analyzed, and Ad hoc report to identify performance across various categories, Build executive report month-to-date Dashboard on BI system (Power BI)
Implement role-Level Security to among directors and executives to support critical restriction and privacy
Provides design support for development of business intelligence solutions
Configured dataset and scheduled incremental refresh to support large dataset for performance improvement
Schedule Domo Dataflow refreshing from multiple source transformation for reporting purpose
Build and manage reports across various departments to ensure accuracy and data consistency
Gathering data from multiple sources and develop ETL process using Domo or power BI
Build marketing model to track Year-to-date (YTD) variance and performance
Organize report, size, and share them with team member before deploying to production
Building data models, Star schema, snowflake, one to many relationships and date table
Extract data from multiple source transform, clean, shape and identify pattern using Power BI
Collaborate with internal and external stakeholders to discuss requirements, Metric and KPI
Discuss with various departments leaders to ensure On-Time delivery of their weekly report
Experience working with Margin Minders, Actuals and analyzed various product categories and sales
Work with the Data Engineering team to discuss data granularity, attribute, changes, and patterns
Collaborate with Data warehouse team ensure data integrity and consistency across various departments
Performed monthly incentive performance analysis to lead marketing incentive offer adjustment
Intermediate experience using DAX, MDX and writing complex DAX functions across data models
Build variance reports across departments and relate findings and their causes of changes
Validate data side by side comparing during migration of existing legacy system to ensure accuracy
Schedule Domo Dataflow refreshing from multiple source transformation for reporting purpose
Develop and configure Role level security across multiple regional report and dashboard
Implement incremental refresh on our large data set to enable faster refresh time

Sr. Data Analyst

Deloitte Support Services India Pvt. Ltd.

Hyderabad

11.2018 - 05.2020

Understanding client's requirement clearly and agreeing to realistic timelines and communicate the same to stakeholders.
Bringing and combining data (Append, Merge, join etc.) from various places.
Reshaping data (Transposing, Grouping and Pivoting).
Implementing latest data visualization techniques through Power BI.
Using DAX and Power query to solve critical business problem.
Taking care for HR operational data, managing data platforms with data driven objectives.
Pull out the data from SAP system and prepare interactive reports and dashboard for client.
Responsible for analyzing the data and creating reports as per member firm requirements using Power BI.
Created rich controls Report on Power BI service using DAX measures implementing complex business reporting scenarios.
Design SQL queries using aggregation, set operations and join to verify data flow between source systems to target.
Assist with creation and distribution of monthly process decks for senior management.
Responsible for ad hoc requests and delivering within the timeline is a regular job.
Preparing ad hoc report for external and internal stakeholders as well as working with cross function teams.

Data Analyst

GAP IT Services India Pvt. Ltd.

Hyderabad

03.2018 - 10.2018

Produced monthly reports using advanced Excel spreadsheet functions.
Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
Documented effective and replicable methods for extracting data and organizing data sources.
Designed and implemented tools to support strategic value chain optimization initiatives.

MIS Analyst

Vivo Communication Device Pvt. Ltd.

Kolkata

10.2015 - 10.2017

Planned and designed system improvements to meet changing demands.
Installed improvements and adjusted parameters to optimize functionality.
Trained users and supported variety of problems with hardware and software.
Analyzed existing systems and databases and recommended enhancements to solve business needs

Summary

Overview

Work History

Sr Business Intelligence Analyst

Asst. Manager Business Intelligence

Sr. Data Analyst

Data Analyst

MIS Analyst

Education

MBA - Business Analytics And Data Science (Pursuing)

Bachelor of Commerce - Accounting And Finance

Skills

Certification

Timeline

Similar Profiles

YOGESH DEWANGANYOGESH DEWANGAN

YERRAM BHAVANI SHANKERYERRAM BHAVANI SHANKER

Siva Ganesh JaggumantrySiva Ganesh Jaggumantry