Atanu Dhar Email & Phone Number

Kolkata, WB, IN

California, United States

Boca Raton, Florida, United States

• Data Ingestion and Modeling on Artist, Venue, Event, Radio, and Demography Data to recommend artists to venues.
• Event, artist, and venue data are read using Azure Data Factory (ADF) dataflow as JSON data via REST API calls from SeatGeek, Ticketmaster, Spotify, etc., and stored in Azure Data Lake Storage (ADLS Gen2). Data is.
• Helped achieve more accurate Artist Recommendations. 16% increase in Venue Ticket Sales.

Boca Raton, Florida, United States

Boca Raton, Florida, United States

• Transaction Data Modelling and Analytics.
• The client offers payment services on physical and online platforms. From all the sources, the transactional information is collected in an Apache Kafka queue and is appended as JSON files every second with sizes.
• Prepared data to train the Fraudulent Transaction Analysis model.

Kolkata, West Bengal, India

• Training undergrad/ newly graduated individuals to achieve their desired career path.
• Database training: Basic to Advanced SQL, types of DBMS: SQL vs NoSQL, OLTP vs OLAP.
• Data Normalisation, Star/Snowflake schema modeling, Facts, Dimensions, ETL, object-oriented concepts using Python; Analytics tools like Power BI, Tableau, etc.
• Cloud Data Engineer: Outline on Azure tools like Azure Data Factory, and Data Lake and AWS tools like Glue, and EC2.
• DevOps: GitHub Actions, Azure DevOps, CI/CD Pipeline, etc.
• Project Guidance: Created demo projects with real-world scenarios to bridge the gap between theoretical knowledge and practical experience.

Kolkata, West Bengal, India

• Analytics on MRI (Medical) data using Azure IoT Hub, MQTT, Azure Stream Analytics, and Power BI. Developed over 80 Reports on Power BI, on different aspects of the machine’s performance.
• Challenges resolved: o Cost optimization: Aggregated data over 10 seconds to reduce data transfers to the cloud. This reduced cloud data costs to 1/100. o Lag optimization: Intermittent lag in data is reduced by.
• Fleet management system for a logistics company also using Azure IoT Hub and Azure Stream analytics. Stored GPS and other fleet data in Azure Cosmos DB to monitor vehicle location, speed, and fuel consumption. Reported.

Jakarta, Indonesia

• ETL design using SSIS for a Toy Distribution Business.
• Data from SQL Server (on-premise) and flat file sources like Excel and CSV are read and transformed within SSIS and loaded into another SQL Server database in the same DBMS. Power BI reports are used for analytics on.
• 30+ differently structured sources are parsed, cleaned, modeled, and harmonized to a unified table structure. Automated file scanning to trigger automated pipeline runs reduced human intervention.

Kolkata, West Bengal, India

• Data Analytics on Live Customer Transactions Data
• PostgreSQL tabular data from the transactional sources were filtered and aggregated in the DB, under a different “analytics” schema, and were directly used in a LiveCharts report (WPF,.NET Framework). Reports showed.
• Management was able to replace all manual or semi-automatic analytical processes with 100% automatic analysis and forecasting. Forecast demands were found to be around 85% accurate which is good enough for the business.

Bengaluru, Karnataka, India

• Player Mechanics Design using C# in Unity Engine
• Designed a player walking, running, and jumping using Game Physics and Spatial Interpolation. Designed player, enemy, and background assets using Adobe Photoshop and Adobe Illustrator. Generating varying enemy spot.
• Reusable algorithms and assets reduced the build rate of other games to 1.25x faster.