I'm Mohammad Shiha
DATA ANALYST
Hi there and welcome to my website! I'm Mohammad--a data analyst with a passion for turning complex datasets into actionable insights. With a major in Management Information Systems from the University of Arizona, I have honed my skills in tools like Excel, SQL, Tableau, and Python. My professional experience spans roles where I’ve contributed to improving user engagement, optimizing systems, and providing data-driven solutions.
Beyond my career, I enjoy exploring the outdoors through hiking, playing video games, and watching movies and TV shows. Whether I'm tackling a challenging dataset or exploring a scenic trail, I bring curiosity and dedication to everything I do.
PORTFOLIO
Salesforce and Whatfix Data Analysis
Handshake
Data Analysis
Company Scorecard Data Analysis
Salesforce & Marketing Cloud URLs Data Analysis
Salesforce ERD
Design
Amazon Regression Data Analysis
Whatfix vs. Non-Whatfix Users Data Analysis
Pharmacy Database Design
College
Data Cleaning
IT Support
Data Analysis
MyDukaan
Data Analysis
Skills
EXCEL
SQL
TABLEAU
90%
80%
Logical Functions (IF, IFS, AND, OR); Text Functions (CONCAT, TEXT, TRIM); Conditional Functions (COUNTIF, SUMIF, AVERAGEIF); Lookup Functions (XLOOKUP, VLOOKUP, INDEX, MATCH); Conditional Formatting; Data Validation; Pivot Tables, Slicers; Visualizations; Power Query; Power Pivot; Data Analysis Toolpak (Regression)
CREATE, INSERT, UPDATE, DELETE, DROP, SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, SELF JOIN, UNION, SUBQUERIES, CASE WHEN, WINDOW FUNCTIONS, CTE, TEMP TABLES, STORED PROCEDURES, TRIGGERS, EVENTS, INDEXES
Connecting to Data Sources, Data Joining, Charts (Bar, Line, Scatter, Heatmap, Treemap, Gantt), Calculated Fields (IF, CASE), Parameters, Actions (Filter, Highlight), Creating Dashboards/Stories
75%
Connecting to Data Sources, Joins & Relationships, Charts (Bar, Line, Scatter, Heatmap, Treemap, Gantt), Calculated Fields (IF, CASE), Parameters, Actions (Filter, Highlight), Creating Dashboards & Stories
PYTHON
Data Types (Strings, Lists, Tuples, Dictionaries), For Loop, While Loop, If-Else, Functions, Libraries (Pandas, Matplotlib), Try-Except, Pandas (Reading, Filtering, Grouping, Sorting), Matplotlib (Bar Graphs, Line Graphs)
70%
Experience
Sep 2023-Nov 2024
University of Arizona, UITS
IT Data Analyst
Utilized Excel, SQL, Tableau, and Python to analyze user engagement, corporate relations, and IT support data, driving insights that improved tool adoption, resource allocation, and user satisfaction. Key contributions include optimizing Salesforce and Whatfix usage, identifying trends in events, career fairs, and corporate partnerships at the University of Arizona, and streamlining Salesforce data architecture with ERDs. Delivered actionable recommendations that enhanced engagement and support efficiency.
May 2022-Aug 2024
University of Arizona, Eller
MIS 111/112 Student Assistant
Graded 10-50 student projects weekly, providing constructive feedback and further ensuring grading accuracy for 100+ projects per week. Developed and applied Excel skills, including Pivot Tables, VLOOKUP, and Conditional Formatting, to enhance grading efficiency and precision.
Dec 2023-Apr 2024
Group 22
Data Analyst/Entry Intern
Extracted 125 non-profit companies weekly from the IRS website, including emails and officer names. Standardized the data in Google Sheets for consistent formatting, size, alignment, and spelling and analyzed the data for insights.
Jan 2023-May 2023
University of Arizona, Eller
Economics 200 Preceptor
Managed and edited 3 surveys, improving clarity of the questions. Analyzed 450+ rows of qualitative survey data in Excel to identify common themes and examined 700+ student assignment data to pinpoint frequently missed questions for targeted lecture clarification.