Data Analyst

DRASHTI MEHTA

Chicago, IL +1-980-***-**** E: ******************@*****.*** LinkedIn

SUMMARY

Detail-oriented Data Analyst with experience in data validation, reconciliation, workflow automation, reporting, and process improvement within a regulated, deadline-driven environment. Skilled in Excel, SQL, Python, Power BI, and Tableau to transform complex data into actionable insights. Experienced in building dashboards, identifying performance trends, and improving data accuracy across the healthcare, finance, and business sectors to support strategic decision-making SKILLS

Data Analysis and Visualization : Excel, Power BI, Tableau, Google Charts Programming and Querying : SQL, Python, R, Bash

Tools and Platforms : Microsoft Fabric, GitHub, Jupyter, Conda, HPC Linux WORK EXPERIENCE

Data Analyst Action Heights, West Chicago, IL Aug 2024 - Present

● Analyzed monthly financial and operational performance of multi-region rental properties by tracking income, expenses, cash flow, and KPIs to evaluate portfolio health

● Identified underperforming assets by analyzing maintenance cost trends, occupancy, and rent collection data, recommending efficiency improvements that reduced operational risk by 20%

● Forecasted 12-36 month cash flow projections and annual operating budgets using Fabric, allowing for strategic planning of capital improvements and refinancing scenarios

● Developed automated Power BI financial dashboards to visualize occupancy trends, maintenance costs, and delinquent accounts, enabling rapid identification of negative financial trends Data Research Technician Loyola University Chicago, Maywood, IL Oct 2023 – Jun 2024

● Performed comparative analysis on cardiac contraction patterns across multiple groups, identifying key orientation trends and outliers in mutant and wild-type samples

● Automated large-scale preprocessing of time-series datasets using Bash scripts and Conda, reducing manual workload by 30%

● Streamlined reproducible workflows using GitHub, ensuring data integrity and traceable documentation for collaborative research

● Investigated data discrepancies by automating recurring reconciliation tasks to validate accuracy and completeness for analysis

● Visualized complex metrics through structured dashboards, transforming raw data into strategic findings for decision-making within cross-functional teams

● Facilitated sessions on how to reduce redundancy, enforce constraints for data integrity, and create indexes for faster retrieval Data Analyst The Think Tank Agency, Mumbai, India Jun 2020 – Aug 2021

● Implemented data collection from various sources - databases, spreadsheets, and external data providers, improving accuracy

● Cleaned and preprocessed data to ensure quality and reliability, addressing inconsistencies, errors, and missing values

● Segmented customer database for targeted marketing based on behavior, demographics, and purchase history, resulting in more effective marketing strategies and increased customer engagement

● Designed interactive Tableau dashboards for data-driven insights, serving clients like Fortis Healthcare, Nikon, and BMW, which facilitated informed decision-making and strategic planning

● Worked with internal teams and external clients, demonstrating customer service and relationship management

● Led technical troubleshooting sessions to enhance analytical skills, achieving 95% satisfaction rate for strong communication CERTIFICATIONS

● Microsoft Certified: Power BI Data Analyst Associate - PL-300 Mar 2026

● Microsoft Azure Data Fundamentals - DP-900 Jun 2025

● Microsoft Azure AI Fundamentals - AI-900 Jun 2025 EDUCATION

Master of Science in Bioinformatics, University of North Carolina, Charlotte, NC, USA Aug 2021 – May 2023

Contact this candidate