Rabia Mehdi
Atlanta, GA 470-***-**** **************@*****.***
LinkedIn: www.linkedin.com/in/rabia-mehdi
Professional Summary
Detail-oriented and results-driven Data Analyst and IT Support Specialist with over 3 years of experience across technical support, data analysis, and business intelligence. Proven track record in delivering actionable insights using Power BI, SQL, and Azure, while ensuring robust system support leveraging Windows, Active Directory, and Microsoft 365. Skilled in SSIS, Salesforce, and network troubleshooting. Passionate about solving business problems through data-driven strategies and cross-functional collaboration.
Certifications
Microsoft Certified: Azure Fundamentals (AZ-900)
Microsoft Certified: Azure Data Fundamentals (DP-900)
Microsoft Certified: Power BI Data Analyst Associate
Microsoft Certified: Modern Desktop Administrator Associate
CompTIA A+
Technical Skills
Data & BI Tools: Power BI Desktop & Service, Excel, SSMS, Azure Data Studio, DAX, T-SQL, GitHub, SSIS
IT Tools: Active Directory, Microsoft 365 (Exchange, Teams, SharePoint), SCCM, ServiceNow, Remote Desktop
Systems & Networks: Windows 11/10, TCP/IP, DNS, DHCP, MFA, user account management
Soft Skills: Data storytelling, communication, user training, cross-team collaboration, process automation
Professional Experience
Data Analyst
Cognitive Bits, Jan 2024 – Present
Designed and maintained Power BI dashboards for KPIs across departments, boosting strategic insights.
Wrote and optimized SQL queries to extract and transform data from large relational databases.
Partnered with stakeholders to define business rules and metrics for reporting solutions.
Automated reporting workflows, reducing manual efforts by 30%.
Data Analyst Intern
Cognitive Bits, June 2023 – Dec 2023
Automated IoT data collection and performed performance analysis.
Built Excel and Power BI dashboards to monitor system uptime and health.
Delivered insights and improvement recommendations to reduce inefficiencies.
IT Support Specialist
C & C Market Research, Atlanta, GA, June 2023 – Present
Supported 200+ users in hardware/software/network issues with a 95% first-call resolution rate.
Administered Active Directory & Microsoft 365, including provisioning, deprovisioning, and MFA.
Deployed and configured Windows 11 workstations and mobile devices with enterprise tools.
Logged and resolved issues in ServiceNow; created internal technical documentation and user guides.
Projects
Sales Performance Dashboard
Built interactive dashboard in Power BI to monitor sales by region and product.
Integrated SQL Server for live data refresh and KPI tracking.
HR Attrition Analysis
Used SQL and Power BI to analyze attrition trends; recommended data-backed retention strategies.
Event Management Database
Designed SQL Server database schema and used T-SQL for data manipulation and reporting.
Insurance MSBI & Power BI Project
Migrated data from OLAP to SSIS staging before DWH integration; built Power BI reports on top.
Additional Projects:
Covid-19 Forecasting: Built supervised ML models for future case predictions.
Zigbee Communication System: Led embedded systems project with GSM tech.
Email Spam Detection: Developed spam classifier using ML algorithms.
Education
Associate of Science in Computer Science
Gwinnett Technical College — Graduated May 2023
Volunteer Experience
Salesforce Manager – Lillah Services Charity
Oversaw the administration and customization of Salesforce CRM to support organizational goals.
Professional Development
Ongoing training in Azure Data Services, Power BI advanced analytics, and SQL performance tuning via Microsoft Learn and Udemy.