Sagar Kumar Dalai
Data Analyst · Automation Engineer
Sagar Kumar Dalai
Data Analyst · Automation Engineer · Advanced AI Video Creator
Turning raw business data into live, decision-ready systems — with a side of Gen AI, Power BI dashboards, and AI-generated UGC.
I build data systems
that don't lag,
dashboards that don't
miss, & AI workflows
that actually ship.
Who Am I?
Hi, I'm Sagar Kumar Dalai — Data Analyst, Automation Engineer, and Advanced AI Video Creator with hands-on experience across HR, Supply Chain, Operations, Export, Purchase, and Sales domains.
Skilled in building real-time Power BI dashboards, automating workflows through Python and web scraping, and transforming ERP data into live, decision-ready systems. Experienced in developing Gen AI and RAG-based solutions, and producing AI-generated video content and high-quality UGC ads.
Currently pursuing PGDM in Big Data Analytics and passionate about combining analytical thinking with creative tools like VR, Gravity Sketch, and Metahuman design to deliver measurable business impact.
Microsoft 365
Power BI
SQL
Python Data Handling
Here are some of my expertise
Power BI
I specialize in Power BI, creating insightful visual reports with strong data storytelling. Skilled in using DAX functions and building effective data models through table relationships.
SQL
Proficient in SQL for writing complex queries to extract, filter, and transform data efficiently. Experienced in working with joins, subqueries, and optimizing database performance for analysis.
Python
Skilled in Python for data analysis using libraries like Pandas, NumPy, and Matplotlib. Capable of cleaning, manipulating, and visualizing large datasets to derive actionable insights.
visualization
Experienced in creating eye-catching, interactive data visualizations that deliver clear insights. Also worked in Unreal Engine, including creating realistic MetaHuman characters and immersive scenes.
Microsoft Excel
Proficient in Excel for data analysis, using advanced formulas, pivot tables, and charts to uncover insights. Skilled in automating tasks, cleaning data, and building interactive dashboards for business reporting.
Cloud Computing(AWS)
Skilled in cloud computing with the ability to deploy and manage servers on platforms like AWS. Experienced in setting up scalable cloud infrastructure for data processing and application hosting.
Automation
Expert in automating workflows using Zapier to connect apps and services. Streamlining repetitive tasks to save time and increase efficiency across business processes.
Mobile App Designing
Designing user-friendly and visually appealing mobile application interfaces. Focusing on intuitive UX/UI to enhance user engagement and satisfaction.
Webpage Design
Creating responsive and modern webpage designs that adapt to all devices. Implementing clean code and aesthetic visuals for a professional online presence.
My Skills
Real-time analytics.
3D bar chart · scatter cloud · network graph · grid floor. Move your cursor to orbit the scene.
SQL
Python
DAX
Power BI
Microsoft Excel
Data Modelling
Gen AI / RAG
AI Video & UGC Content
Web Scraping
Unreal Engine / Metahuman / Gravity Sketch
Photoshop
ERP Systems / Automation
Experience
- Designed and deployed real-time KPI dashboards by integrating ERP data streams, converting static reports into live management monitoring systems.
- Built an end-to-end automated attendance scraping pipeline that extracts, processes, and loads daily records into live Power BI dashboards — eliminating manual HR data entry.
- Developed an interactive application featuring a 3D space viewer, enabling customers to explore products and environments in an immersive, real-time visual interface.
- Built an automated lead generation system using external APIs and Google Apps Script, capturing, enriching, and routing qualified leads directly into the sales pipeline.
- Streamlined cross-functional workflows across HR, Supply Chain, Operations, Export, Purchase, and Sales departments, reducing manual effort and errors.
- Conceptualised and executed a VR-based machinery showcase for customers using Gravity Sketch, independently managing ideation, design, and delivery.
- Produced AI-generated video content and high-quality UGC advertisements for product demonstrations and customer engagement initiatives.
- Delivered end-to-end analysis of real estate projects covering HR data, customer churn, sentiment, sales funnel, and campaign performance using Power BI and Excel.
- Built automated DAX-driven Power BI dashboards to monitor monthly employee progress and project milestones.
Education
Adani Institute of Digital Technology Management, Ahmedabad, Gujarat.
Building expertise in Excel, Power BI, SQL, Python, Hadoop, web scraping, cloud computing, and cybersecurity.
Pt. Ravishankar Shukla University, Raipur
Income Tax, Company Law, Accounting, GST; Computer applications: HTML, Excel, DBMS, Visual Basic.
Certifications
Data Visualization with Python IBM · 2024
AWS Academy Cloud Foundation AWS Academy · 2024
Python for Data Science IBM · 2024
SQL and Relational Databases IBM · 2024
Statistical Analysis Fundamentals Using Excel Coursera · 2024
Create Charts & Dashboards Using Microsoft Excel Coursera · 2024
Simulations & Achievements
Tata Consultancy Services — Data Visualization Job Simulation Forage · Jul 2025
Deloitte Australia — Data Analytics Job Simulation Forage · Jul 2025
2nd Position — Word Wiz Competition Competition
Academic Projects
- Designed a Retrieval-Augmented Generation (RAG) chatbot enabling employees to query internal SOPs, HR policies, and company documents in natural language.
- Built a document ingestion pipeline supporting PDF and DOCX formats with FAISS vector embeddings for context-aware responses; deployed locally for internal testing.
- Analysed global COVID-19 datasets with advanced DAX measures to build interactive, trend-revealing reports with optimised user interactivity.
- Tracked sign-up trends by demographics, activity, and geography to optimise campaign targeting and improve conversion rates.
- Scraped wealth data, processed with Pandas, and visualised key insights and patterns through Matplotlib charts.
- Merged multi-source datasets to examine district-wise literacy and state-level population figures, surfacing demographic correlations.
- Architected a normalised relational database covering Profiles, Tenancy, Housing, Referral, and Employment Status with optimised query performance.