Mitali DharDutta

Lead and developed AI-powered assistants using Microsoft Copilot Studio, Azure OpenAI, and Power Platform to support business
users and developers. Built enterprise conversational solutions integrated with Power Apps, Power Automate, SharePoint, SQL
databases, APIs, and knowledge repositories. Developed RAG-based applications using LangChain, FAISS, and Azure OpenAI to
enable secure, contextual information retrieval and conversational analytics. Integrated Copilot Studio agents with business
workflows to automate approvals, notifications, and operational processes. Applied prompt engineering, Responsible AI practices,
governance controls, and DLP policies while exploring Agentic AI frameworks such as CrewAI and LangChain to deliver scalable
AI-driven business solutions. Collaborated with 15+ business stakeholders across functions to gather requirements and define
scalable automation solutions. Improved reporting adoption by 35%+ through enhanced dashboards and automated notifications

Led the development of an alert-based visualization solution to proactively identify potential high-risk sales transactions for
internal assessment and control. Utilized Power BI to build BI reports and dashboards, enabling comprehensive data
analysis. Engineered an approval process flow using Power Automate, streamlining workflow efficiency. Conducted
requirement gathering, data architecture design, data modeling in Snowflake and Power BI, ETL processes, and data
validation in Snowflake, ensuring data integrity. Designed queries in Snowflake DB for data validation and customization.
Integrated Power Automate with Power BI to establish a seamless approval process flow. Analyzed data and defined Key
Performance Indicators (KPIs) aligned with business requirements. Developed various KPIs tailored to business needs and
implemented row-level security measures at the data layer for enhanced data protection.

Caterpillar - Tool: Contributed to the development of an intelligent data assessment tool for
leading manufacturing company to enhance insight into demand & supply, and improve data quality. Led requirement
gathering and crafted an innovative data architecture using Python scripts, with a focus on data modeling, ETL processes,
and data validation using Pandas library. Designed data analysis expressions in Power BI and developed reports and
dashboards for enhanced visualization and analysis. Designed Python scripts using Pandas library for data validation and
customization of logic. Integrated Python with Power BI to build the data assessment tool, streamlining data management
processes. Analyzed data and defined Key Performance Indicators (KPIs) aligned with business objectives. Developed
various KPIs based on business requirements to drive performance improvement initiatives.

Vodafone UK
Contributed to the development of a comprehensive dashboard for Vantage Tower Company at Vodafone UK, Europes
largest tower company. Led requirement gathering, data analysis, transformation, and modeling. Designed data analysis
expressions and developed reports and dashboards on Qlik Sense for improved data visualization. Defined Key Performance
Indicators (KPIs) based on business objectives. Optimized data models and load scripts to enhance dashboard performance.
Simplified complex expressions in dashboards to improve frontend usability

OTIS BI-WD As a Power BI Developer and Project Lead, I led the OTIS BI-WD project for OTIS, a top manufacturer of
elevators and escalators. My role involved migrating a module from Business Objects (BO) to Power BI. Throughout the
project lifecycle, I managed requirements, conducted data analysis, and oversaw data transformation, modeling, and
report/dashboard development. Leveraging SQL expertise, I designed and executed queries for accurate data retrieval and
verification. I also crafted complex DAX expressions to ensure data accuracy and consistency in Power BI. To enhance
performance, I configured connections to an Azure Databricks cluster within Power BI Desktop. Rigorous unit testing and
data validation ensured alignment with existing reports and sources. Post-development, I deployed reports to Power BI
services, implementing advanced features like Power BI mobile view and data security measures. Additionally, I contributed
to Power BI embedding and developed paginated reports using Power BI Report Builder. Independently, I managed the OTIS
MGM Billing project, leading design, data modeling, and dashboard development efforts on the Power BI platform.

Skill survey BI reports: Led end-to-end responsibility for the SkillSurvey and CAP-Dev Integration Project, involving
requirement gathering, task estimation, data modeling, and Power BI report development. Designed and developed reports
in Power BI Desktop using Azure SQL and Azure Analysis Services, incorporating interactive visuals, KPIs, custom visuals,
and tabular data models. Utilized various charts and calculated columns to effectively present data. Implemented user
specific Row-Level Security (RLS) and deployed reports in Power BI Services, managing user access. Ensured data validation
with SQL Server and implemented data refresh schedules. Collaborated with the integration team to embed reports within
web portals for easy access. Worked with both Power BI Premium and Power BI Pro editions. Additionally, created tabular
reports using MS Report Builder and scheduled subscriptions for Excel reports. Developed paginated reports using Power BI
Report Builder with live data connections.

I provided strategic insights for election campaigns by analyzing beneficiaries and schemes. Developed end-to-end
dashboards for 5 projects, crafted concise infographics reports, and led requirement analysis processes. Utilized SSRS, Power
BI, and Tableau to create tailored reports, designed various chart types, and generated informative reports for stakeholder

Gained foundational experience in banking operations and financial auditing, managing deliverables, transaction monitoring,
and risk control to ensure process accuracy and compliance.

Maintained branch audit compliance and managed MIS reporting, ensuring accuracy and timely data consolidation for
management insights.

Maintained branch audit compliance and managed MIS reporting, ensuring accuracy and timely data consolidation for
management insights