Data Analyst &
Project Manager

Detail-oriented professional with 3+ years' experience in data analysis, project coordination, and institutional business support. Proficient in SQL, Python, Power BI, and automation tools.

Mahnoor Malik - Professional Data Analyst

Top Rated

Upwork Verified

0

Projects Delivered

0

Client Projects

0

Years Experience

About Me

Professional Summary

I am a passionate Data Analyst and Project Manager with a Computer Science background, specializing in transforming raw data into actionable business intelligence. My expertise bridges the gap between technical teams and business stakeholders, ensuring data initiatives drive measurable impact.

With proficiency in Python, SQL, Power BI, and advanced data visualization tools, I create solutions that not only answer business questions but also anticipate future needs. My project management skills ensure timely delivery and exceed client expectations consistently.

Rawalpindi, Pakistan
Available for Projects, Job

Education & Languages

BS in Computer Science

International Islamic University Islamabad (IIUI)

2018 – 2022

Specialized in Data Science, Machine Learning, and Database Management

Languages

Urdu

Native Proficiency

English

Professional Proficiency (B2)

Certifications & Training

IBM Data Science Professional Certificate Python for Data Science and AI Data Analysis with Python Databases and SQL for Data Science Excel for Data Analytics Graphic Design - Digiskills ChatGPT & AI Hacks with MS Office Tools for Data Science Python Project for Data Science

Key Competencies

Stakeholder Communication

Excellent communication skills for technical and non-technical audiences, ensuring clear understanding of data insights.

Cross-functional Collaboration

Proven ability to work effectively across different teams and departments to achieve project goals.

Project Coordination

Skilled in timeline management, resource allocation, and quality assurance for complex data projects.

Work Experience

Project Manager | Data Analyst

AI Data House (SMC-PVT) LTD

Remote - Rawalpindi, Pakistan

05/2023 – Current

Led and mentored a data team to execute projects aligned with organizational goals

Utilized SQL and Python for data cleaning and exploratory analysis

Automated workflows using Apps Script and Excel macros to enhance reporting efficiency

Created dashboards using Power BI and Looker Studio for business insights

Collaborated with institutional clients, assisted with documentation, and monitored project timelines

Skills Applied:

Team Leadership SQL Python Power BI Looker Studio Apps Script Project Management

Top-Rated Data Analyst & Project Manager

Upwork (Freelance Platform)

Remote - Global Client Base

2022 – Current

95%+ Job Success Score with 21+ completed projects and $1K+ total earnings on Upwork platform

Top-Rated Plus freelancer with verified identity and 100% client satisfaction rate

Specialized in Data Analytics, Ecommerce Website Development, and Full Project Management

Successfully delivered 21 client projects with 5-star reviews across various industries

Available more than 30 hrs/week with less than 24 hrs response time for urgent projects

Fluent English communication for international clients with verified language proficiency

95%+ Job Success

Upwork Top-Rated Status

21+ Projects

Successfully Delivered

Skills Applied:

Freelance Project Management Client Communication Data Analytics Ecommerce Development Remote Collaboration Time Management International Clients

Assistant Project Manager

Technodigg LTD

Remote - United Arab Emirates

02/2023 – 11/2024

Oversaw team operations and client project delivery in a cross-functional environment

Interpreted client requirements and ensured alignment with execution

Conducted QA of deliverables and facilitated timely communication across teams

Assisted in planning and coordination with stakeholders on technical deliverables

Skills Applied:

Project Coordination Client Management Quality Assurance Team Operations Stakeholder Coordination

Technical Skills

Data Analysis & Programming

Python 90%
SQL 95%
Django 85%

Visualization Tools

Power BI 90%
Looker Studio 88%
Google Analytics 85%

Automation & Office Tools

Excel VBA 95%
Google Apps Script 95%
Microsoft Office 98%

Additional Skills

Data Visualization Machine Learning NLP Database Design Workflow Automation Statistical Analysis Institutional Business Strategy Government Partnerships

Projects

A showcase of my technical expertise through real-world data analysis and automation projects.

Gemini Multimodal Creative Studio
React 19 Google Gemini AI Studio

Gemini Multimodal Creative Studio

High-end creative suite leveraging Google Gemini models for real-time voice, image generation, and grounded search.

Real-time voice conversations with Gemini 2.5 Flash
Text-to-image generation using Gemini models
Web-grounded search with Google Search integration
Live Demo
Business Sentiment Analysis Project
AI/ML Django

Business Sentiment Analysis

AI-powered sentiment analysis using Twitter and YouTube comments with Django and NLP techniques.

Developed AI-based sentiment analysis model
Processed unstructured social media data
Designed SQL database architecture
Climate Change Impact on Global Crop Yield Analysis
Python Power BI Data Analysis

Climate Change Impact on Global Crop Yield

Python/Power BI analysis of climate impact on global food security.

Integrated FAO & World Bank climate data
Interactive dashboard for climate insights
Automated data preprocessing pipeline
Database SQL

Hospital Management System

SQL-based system for managing doctors, patients, and appointment bookings.

Designed comprehensive SQL database system
Managed doctors, patients, and appointments
Optimized healthcare operations
Budget Planner
Automation Excel

Interactive Budget Spreadsheet

Automated budgeting tool with Excel and Google Sheets automation.

Created automated budgeting tools
Used Excel macros and Google Apps Script
Helped clients increase savings by 30%
Revenue Dashboard
Dashboard Power BI

Sales Performance Dashboard

Real-time business insights dashboard for sales performance tracking, with dynamic.

Built interactive dashboards with Power BI
Enabled 3x faster trend identification
Real-time data updates
Faculty Performance Tracking System
Excel VBA Pivot Tables Dashboard Automation

Faculty Performance Automation

VBA-powered Excel system for automated faculty performance tracking, with dynamic calculations.

Automated employees record generation.
Dynamic category-based task allocation
Dual dashboard system with interactive slicers
10-Year Ownership Transition Model
Financial Modeling Excel S-Corp

Ownership Transition Financial Model

Complex 10-year shareholder transition model with phased buy/sell scheduling and financial tracking.

10-year shareholder transition modeling
Phased transaction scheduling with weighted averages
Notes payable/receivable with interest tracking
Leads Management Dashboard
Looker Studio Data Visualization Dashboard

Leads Management Dashboard

Comprehensive Looker Studio dashboard for tracking lead conversion, revenue, and team performance.

Revenue and lead conversion tracking
Team performance analysis with visualizations
Dynamic date filters and lead source breakdowns
Healthcare Form & PDF Generator
Google Apps Script PDF Generation Automation Financial Calculations HIPAA

Healthcare Form & PDF Generator

Dynamic Google Form with dependent dropdowns and automated PDF invoice generation for healthcare procedures.

Dynamic forms with dependent dropdowns from Google Sheets
Automated PDF generation with calculations
Procedure pricing, tax calculations, and insurance tracking

Data Analytics Blog

Practical insights, tutorials, and real-world solutions in data analytics, SQL, Python, and business intelligence.

Get In Touch

Ready to transform your data into actionable insights? Let's discuss how I can help your business.

Email

contact.mahnoormalik@gmail.com

Send Email

Phone

(+92) 308 5277249

Call Now

LinkedIn

Connect professionally

Visit Profile

Upwork

Top Rated

View Profile

Hobbies & Interests

Data Visualization Documentaries & Series Institutional Business Government Partnerships AI & Machine Learning Graphic Design