Mahathi Dhulipala

Data Analyst || Project Specialist

"Driving transformation through smart systems, sharp insights, and strategic collaboration."

About Me

Discover the person behind the professional

I'm a passionate technology professional with a unique blend of technical expertise and business acumen. With experience spanning multiple industries, I bring a holistic approach to solving complex problems through data-driven insights and innovative solutions.

Mahathi Dhulipala
"Technology is best when it brings people together and solves real problems."
"Technology is best when it brings people together and solves real problems."

Professional Profile

Innovation Driven

Continuously exploring emerging technologies to drive digital transformation

Data-Centric

Transforming raw data into strategic assets for informed decision-making

Collaborative

Building strong relationships across technical and business teams

My Approach

I believe in combining technical excellence with business strategy to create solutions that are not only functional but also deliver measurable value. My approach focuses on understanding core business challenges, leveraging appropriate technologies, and implementing solutions that drive efficiency and growth.

Core Competencies

Areas where I excel and deliver exceptional value

Data Analysis & Visualization

Expert in transforming complex datasets into clear, actionable insights using Tableau, Power BI, and Python. Recognized with Missouri DNR Energy Star Award (2025) for leading data‑system modernization and interactive dashboard automation across state agencies. Iron Viz 2025 Participant Representing MO DNR.

Tableau / Power BI KPI dashboards Predictive modeling Data validation

Project & Product Management

Certified Agile practitioner with full SDLC coordination. Skilled in requirements gathering (BRD/FRD), sprint planning using Jira, and managing cross‑functional teams. Drove IT system migrations, compliance workflows, and stakeholder alignment for Missouri state programs.

Agile/Scrum BRD / FRD Jira / Confluence Risk management

Azure Data Engineering

Proficient in designing end‑to‑end data pipelines, ETL/ELT processes, and cloud architecture. Hands‑on with Azure Data Factory, Synapse Analytics, AWS Glue, Spark, and Redshift. Built automated federal reporting pipelines and centralized ledger platforms for state divisions.

Azure Data Factory Synapse/Redshift Spark / Glue ETL pipelines

Process Optimization & Automation

Specialized in identifying inefficiencies and automating manual workflows. Reduced reporting turnaround from weeks to days through analytics‑backed visualizations. Introduced data‑driven prioritization models and automated compliance workflows using Power Automate and SharePoint.

Workflow automation Lean methodologies Power Automate Data governance

Full‑Stack Development & QA

Skilled in full‑stack development (Java, Python, C#, JavaScript) and test automation (Selenium, JMeter). Built CI/CD pipelines, automated UI/functional testing for payment gateways, and performed load/security testing. Experience with REST APIs, EDI, and system integration.

Java / Python / C# Selenium / JMeter CI/CD pipelines API testing

IT Governance & Compliance

Experience establishing IT policies, data governance frameworks, and audit‑ready documentation. Implemented Tableau security, user access control, and metadata standards. Certified in Tableau Server Administration, ITIL Foundation, Citi Research Ethics; ensured regulatory compliance for state/federal programs.

Data governance Compliance (CITI) Tableau Admin Risk assessment

Professional Capabilities

Comprehensive skills

BA
Requirement Gathering
GAP & SWOT Analysis
Impact & Feasibility
BRD/FRD Development
Data Flow Diagrams
Business Process Modeling
People Management
CRM Systems
VIZ
Microsoft Visio
Lucid Chart
UML
Power BI
Tableau
Microsoft Suite
XML
Data Analytics & Mining
DEV
Java
Python
C#
JavaScript
HTML/CSS
Mongoose
Kanban
REST APIs
TOOLS
Prism / Dev Track
IS Support
Drupal 7/8 CMS
Selenium / JMeter
Jira / SharePoint
ServiceNow / Product Hub
VS Code / Eclipse
Test Complete / Power Automate
DB
Oracle 11g
MySQL
SQL / T-SQL
ETL Processes
Data Modeling
DE
ETL/ELT
Spark
AWS Glue
Azure Data Factory
Redshift / Synapse
Cloud (Azure/AWS)
Big Data Analytics
LD
Subject-Matter Expert (MOWAP, MO-SEP, Tableau)
Knowledge Transfer & Mentorship
Stakeholder Management
Cross-Department Liaison
Team Coordination
Capacity Building
Training & Workshop Delivery

Professional Experience

My career journey

State of Missouri (Department of Elementary and Secondary Education)

Assistant Director - Data Analyst

Feb 2026 - Present
  • Designed, developed, and maintained interactive Tableau dashboards and executive-level visualizations to track KPIs, program outcomes, and performance trends across multiple regions.
  • Partnered with executive leadership and cross-functional program teams to translate business requirements into actionable metrics, ensuring alignment with strategic objectives.
  • Conducted comprehensive data validation and quality assurance processes, improving reporting accuracy and ensuring consistency across datasets.
  • Developed standardized reporting frameworks including summary tables, charts, trend analyses, and explanatory narratives to support data-driven decision-making.
  • Automated recurring reports, reducing manual reporting effort and improving turnaround time for leadership requests.
  • Implemented best practices in Tableau security, user access control, and data governance to ensure compliance and protect sensitive information.

State of Missouri (Department of Natural Resources)

Project Specialist / Research Data Analyst

Feb 2024 - Jan 2026
  • Administered and orchestrated the Division's enterprise reporting ecosystem, building 12+ interactive product dashboards delivering real-time insights to executive leadership and regulatory partners.
  • Led digital transformation of financial record-keeping, replacing manual spreadsheets with automated dynamic reporting modules to streamline product lifecycle.
  • Developed complex analytical models for forecasting financial demand, budget requirements, and resource allocation to ensure long-term product viability.
  • Engineered automated federal reporting pipelines ensuring accurate data reconciliation and sustained federal funding for large-scale financial programs.
  • Directed requirements gathering and authored BRDs/FRDs to align core IT systems with complex fiscal, operational, and regulatory reporting needs.
  • Consolidated enterprise data sources and implemented metadata standards to improve audit readiness and integrity of financial reporting.

Mikha IT Solutions

Azure Data Engineer

Feb 2024 - Sept 2024
  • Engineered and maintained end-to-end data pipelines using Azure Data Factory, Azure Synapse Analytics, and SQL
  • Transformed raw data into interactive dashboards and visual reports using Power BI
  • Developed semantic data models and DAX measures in Power BI to support self-service analytics
  • Integrated Azure Data Lake Storage, Azure SQL Database, and external APIs to centralize data
  • Created data catalogs and documentation using Azure Purview and Power BI Dataflows
  • Implemented role-based access control (RBAC) and row-level security in Power BI

AECI (Associated Electrical Cooperative Inc)

Programming Intern

May 2023 - Dec 2023
  • Migrated legacy transaction forms to modern frameworks, enabling automated product dashboards and accelerating regulatory compliance workflows.
  • Built ServiceNow-integrated analytics with real-time dashboards to track product delivery, budget burn rates, and state-mandated financial milestones.
  • Automated Tableau and Power BI reporting by integrating HCM and enterprise ledger data, utilizing SQL/T-SQL for deep-dive KPI and churn analytics.
  • Enhanced data quality and platform interoperability for financial systems using MS-SQL, XML, JavaScript, and Web Services to ensure seamless API integration.
  • Implemented secure EDI data exchange standards to ensure accurate, encrypted communication and settlement with partner financial institutions.
  • Optimized customer-portal data flows, improving accuracy of user-submitted financial data and reducing loan/application service turnaround time.

Missouri University of Science and Technology

Student Well-being Intern

Sep 2022 - May 2023
  • Delivered workshops on stress, anxiety, time management, and productivity to improve student well-being.
  • Led wellness initiatives promoting mental health awareness and inclusive support on campus.
  • Organized large wellness and safety events to enhance preparedness for international students.
  • Executed well-being programs including aromatherapy, motivation coaching, and substance-awareness campaigns.
  • Presented mental-health education sessions to increase coping skills and campus engagement.

American Arbitration and Association

Software Test Engineer

June 2019 - Dec 2021
  • Automated UI and functional testing for payment gateways using Selenium, boosting product QA efficiency and accelerating resolution of transaction-level defects.
  • Directed System, Integration, Regression, and UAT cycles using JIRA to reduce production defects in high-stakes lending and wallet applications.
  • Verified and monitored data flows across Salesforce CRM, SAP, and Tableau to ensure strict audit compliance and regulatory accuracy for financial reporting.
  • Created and maintained BRD, FSD, and ETL mapping documentation, establishing full traceability from product requirement to final financial delivery.
  • Championed Agile transformation by optimizing sprint delivery timelines and refining acceptance criteria for loan products.
  • Built reporting dashboards and data analytics modules using Salesforce and SAP, enabling real-time insights for compliance, risk management, and operations.

DRDL (Defense Research and Development Laboratory)

Non-Destructive Testing Analysis Intern

July 2015 - Dec 2015
  • Managed customer and operational data using SAP Master Data Governance (MDG) to improve data accuracy, traceability, and defense workflow efficiency.
  • Analyzed cross-functional workflows and delivered data-driven insights to enhance decision-making in defense operations.
  • Developed cost-benefit models and technical business cases to prioritize system upgrades and reduce operational overhead.
  • Utilized supply chain, inventory, and accounting systems to strengthen resource control and compliance with defense standards.
  • Introduced process automation and error-reduction improvements to support data governance and system readiness for DRDO programs.

Education

My academic background

Master of Science in Information Science and Technology

Missouri University of Science and Technology, Rolla, MO, US

Jan 2022 - Dec 2023

GPA: 3.6/4.0

Bachelor of Technology in Electronics and Communication Engineering

JNTUH, Hyderabad

Aug 2016 - Jul 2019

GPA: 3.6/4.0

Diploma in Electronics and Communication Engineering

SBTET, Hyderabad

Mar 2013 - Apr 2016

GPA: 8.7/10.00

Certifications

My professional certifications

Tableau Desktop Foundations

Salesforce Certified

Feb 2025

Tableau Desktop Analyst

Salesforce Certified

Jul 2025

Tableau Server Administrator

Salesforce Certified

Aug 2025

Agile Scrum Master

Expertise in Agile methodologies

2023

ITIL Certification

IT service management best practices

2023

Introduction to Six Sigma

Process improvement methodologies

2023

Microsoft Enterprise Mobility Suite

Management and Security

2023

CITI Certification

Research ethics and compliance training

2023

Customer Service Leadership

Leadership in customer service

2023

Mental Well-being Ambassador

Promoting mental well-being

2023

Complete Confidence

LinkedIn Learning - Self-confidence skills

Apr 2025

Operational Excellence Foundations

LinkedIn Learning - Operational Excellence

Feb 2025

VLSI Design using FinFET

Keshav Memorial Institute of Technology

Mar 2017

IOT (SONET) Participation

Keshav Memorial Institute of Technology

Date not specified

IETE Electronic Project Competition

Keshav Memorial Institute of Technology

2017

Suicide Prevention Training

Ask Listen Refer program

Oct 2022

Six Sigma: Green Belt

LinkedIn Learning

Jun 2025

Show Me Excellence White Belt

The Missouri Way Training

Jun 2025

Show Me Excellence Yellow Belt

The Missouri Way

Jun 2025

Leadership

Beyond professional experience

Student Well-Being Chair

International Student Club, Missouri S&T

Organized wellness initiatives and mentored international students on campus resources

President

India Association, Missouri S&T

Led cultural programming and community-building activities for 200+ members

Conference Attendee

IEEE & IETE Events

Presented technical projects on VLSI design and IoT applications to academic audiences

"Every role I've taken on—from mental wellness campaigns to Earth Day outreach—has been a step toward creating informed, empowered communities."

Leadership Beyond Work

My campus and community engagements reflect a commitment to service that complements my professional work. Whether dressing up to boost team morale or teaching students about energy conservation, I've learned that small moments often create the biggest impact.

Honors

Recognition and involvement

Certificate of Excellence

Peer Wellness Educator and member of Joe's Peers through the Student Well-Being program at Missouri S&T

Most Innovative Intern Award

For high-impact visual solutions at AECI

Certificate of Appreciation

From Zensar for outstanding dedication and performance

Energy Star Award Recognition

Recognized by Missouri Department of Natural Resources for outstanding contributions to energy efficiency and sustainability initiatives

India Association Leadership

As President & VP: Organized cultural events, OPT/CPT workshops, and raised $5,000+ through fundraising

Cultural Events Student Workshops Fundraising

Mental Well-being Initiatives

Facilitated awareness weeks, student retreats, and health campaigns reaching 150+ students

Peer Education Workshops Health Promotion

Sustainability Leadership

Earth Day events promoting energy literacy to 2,000+ attendees through interactive exhibits

STEM Education Community Outreach Youth Engagement

100% Amazing Internship

Achieved Certificate of 100% Amazing Internship at Student Well-Being, Missouri S&T

Policy & Advocacy

JED Campus Committee advisor and speaker at Law Awareness conferences on student protection

Mental Health Policy Student Advocacy Public Speaking

Articles

My insights on technology, data, and digital transformation

AI Agents Revolution
Published on Medium

The Silent Revolution: How AI Agents Are Quietly Becoming Your New Coworkers

Exploring how AI agents are transforming workplace dynamics and becoming indispensable collaborators in modern business environments.

Read on Medium
SharePoint Premium
Published on Medium

SharePoint Premium: When Your Content Started Thinking Back

Delving into how SharePoint Premium is revolutionizing content management with AI-powered insights and automated workflows.

Read on Medium
Data Tools Reality Check
Published in Analyst's Corner on Medium

The Great Data Tool Reality Check: Why Excel vs Tableau Isn't Really About The Tools

Examining the real factors that determine data tool success beyond the surface-level features and capabilities.

Read on Medium
Power Platform
Published in Bootcamp on Medium

The Lazy Revolution: Why Power Platform Is Making Me Question Everything I Know About Building Apps

Challenging traditional development paradigms with Microsoft's Power Platform and its impact on application development.

Read on Medium
M365 Constellation
Published in Bootcamp on Medium

The M365 Constellation: How Microsoft Accidentally Rewrote The Physics Of Digital Work

Analyzing how Microsoft 365's integrated ecosystem is transforming how organizations approach digital collaboration.

Read on Medium
Data Silos
Published on Medium

When Data Silos Became Our Biggest Enemy: How Three Companies Broke Free

Case studies of organizations that successfully overcame data silo challenges and transformed their data ecosystems.

Read on Medium
Environmental Tech
Published in Analyst's Corner on Medium

How I Stumbled Into Understanding Environmental Tech

A personal journey discovering the intersection of technology and environmental sustainability in modern organizations.

Read on Medium
Tableau
Published on Medium

Why Tableau Feels Like A Breath Of Fresh Air In A World Of Data Silos

Exploring how Tableau's approach to data visualization breaks down barriers and creates more accessible insights.

Read on Medium
SharePoint Paradox
Published in Bootcamp on Medium

The SharePoint Paradox: How Three Simple Concepts Accidentally Built The Future Of Work

Unpacking the foundational principles that made SharePoint a cornerstone of modern digital workplace strategies.

Read on Medium

Want to read more of my thoughts on technology and digital transformation?

Visit My Medium Profile

Technical Projects

Practical implementations solving real-world challenges

Smart Parking System

Implemented at KMIT campus parking lots using ultrasonic sensors (HC-SR04) and Arduino Mega. The system detects vehicle presence and displays available spots on LED panels at entrances.

Arduino C HC-SR04 RFID MFRC522 16x2 LCD
Reduced average search time from 8 to 2 minutes Cut lighting costs by 30% with motion activation

RFID Library System

Developed for JNTUH Central Library using RFID-RC522 readers. Books were tagged with passive RFID stickers, enabling self-checkout with student ID cards containing embedded RFID chips.

RFID-RC522 MySQL PHP Bootstrap
Checkout time reduced from 15 mins to 30 seconds Annual book losses decreased from 120 to 8 volumes

Dual-Axis Solar Tracker

Capstone project at KMIT using 4 LDR sensors, SG90 servos, and ESP32. Achieved 28% greater efficiency than fixed panels during testing (May-July 2023).

ESP32 Azure IoT LDR Sensors Servo Control
28% more energy than fixed panels Remote monitoring via mobile app

Smart Waste Management

Pilot project for Rolla city using ultrasonic sensors and LoRaWAN. Monitored fill levels in 15 public bins, optimizing collection routes for sanitation department.

Arduino LoRaWAN Ultrasonic Route Optimization
Reduced collections by 40% Saved $15,000 annually in fuel costs

Smart Street Lighting

Implemented on KMIT campus pathways using LDR sensors and relay modules. Lights automatically adjust based on ambient light and motion detection.

LDR Sensors Relay Modules PIR Motion Energy Monitoring
60% energy reduction Zero manual intervention needed

Digital Notice Board

Deployed in 3 campus buildings using SIM800L GSM modules and LED matrices. Administrators can update displays via SMS from authorized numbers.

SIM800L LED Matrix Keil Software AT Commands
Eliminated paper notices Instant campus-wide updates

Precision Height Measurement

Developed for industrial applications using CCD cameras and image processing algorithms. Achieved sub-millimeter accuracy in quality control processes.

CCD Imaging OpenCV Python Calibration
99.9% measurement accuracy 50% faster than manual methods

Procurement Analytics

Analyzed 3 years of financial data (15,000+ records) using Tableau connected to DB2 via ODBC. Identified bottlenecks in approval workflows and vendor performance.

Tableau DB2 ODBC Excel Macros
Approval times reduced by 35% Saved $48,000 annually

IT Service Dashboard

Created for Mikha IT using Power BI connected to ServiceNow API. Visualized ticket metrics with row-level security for department heads.

Power BI ServiceNow API DAX Azure AD
Resolution time down from 32 to 19 hrs Balanced technician workloads

Water Quality Visualization

Visualized 5 years of environmental data (8,000+ tests) with JavaScript integrations for custom filtering. Deployed on Tableau Server.

Tableau JavaScript SQL Server Geospatial
Report generation from 3 days to 2 hours Identified priority remediation sites

Document System Migration

Migrated 12,000+ files from network drives to SharePoint Online. Implemented metadata columns and trained 85 users on new system.

SharePoint PowerShell Metadata User Training
File retrieval from 8 mins to 90 seconds Version conflicts reduced by 75%

Digital Approval System

Built using SharePoint lists, Power Automate, and Power Apps. Digitized a paper-based process with 22 approval steps across departments.

SharePoint Power Automate Power Apps MS Forms
Approval cycle from 42 to 17 days Eliminated 15,000 paper forms annually

Customer Retention Model

Developed for AECI using Python and Scikit-learn. Analyzed 2 years of customer data to predict churn risk with 85% accuracy.

Python Scikit-learn XGBoost Feature Engineering
85% prediction accuracy Saved $250K in retained revenue

Feedback Analysis Tool

Built for KMIT Student Wellbeing using NLP to analyze 5,000+ survey responses. Classified sentiment with 92% accuracy using BERT.

Python NLTK BERT Text Classification
92% classification accuracy Processed 10K+ feedback items

Online Store Platform

Full-stack e-commerce solution for local retailer with React frontend, Node.js backend, and MongoDB. Integrated payment processing and inventory management.

React Node.js MongoDB Stripe API
30% conversion rate 500ms page load time

University Blog System

Content management system for KMIT student organizations using Drupal 8. Supported 50+ student groups with customized templates.

Drupal 8 PHP MySQL Custom Themes
5K monthly visitors 100+ articles published

Data Integration Pipeline

Built for Mikha IT using Azure Data Factory and Synapse Analytics. Consolidated data from 8 sources into unified data warehouse.

Azure Data Factory Synapse SQL DB Data Lake
60% faster processing 40% cost reduction

Agile Project Dashboard

Azure DevOps integrated dashboard for sprint planning with 95% estimation accuracy. Used by 12 development teams.

Azure DevOps Power BI Agile Metrics Scrum
95% sprint accuracy 10% less scope creep

Defect Detection System

CNN-based image classification for manufacturing quality control. Trained on 15,000 product images with 94% accuracy.

Python TensorFlow CNN Computer Vision
94% defect detection 200ms per inspection

Campus Wellness App

Cross-platform application for KMIT students with mood tracking and mental health resources. 10,000+ downloads.

React Native Firebase Health API UX Design
10K+ downloads 4.8/5 app rating

Inventory Optimization

Predictive analytics for AECI supply chain using Python and Prophet. Reduced overstock while maintaining 99% fulfillment rate.

Python Prophet Time Series Inventory Mgmt
30% less overstock 25% faster replenishment

Get In Touch

Let's work together

Email

mahathidhulipala22@gmail.com

Location

Missouri, USA

LinkedIn

linkedin.com/in/mahathidhulipala/