GRADUATE CLASSES IN COMPUTER SCIENCE @ University of Kentucky
- I have completed the Discrete Mathematics course (CS 275) at UKY which was a prerequisite for conditional admission into the CS master’s Program.
BACHELOR OF SCIENCE IN COMPUTER SCIENCE @ Mansoura University
- Majors: Information Systems
CUSTOMER CHURN ANALYSIS
- Utilized Python to analyze 7000 data science job listings and gain insights on what it takes to land a job in analytics.
- Implemented Regex techniques to comb through the job descriptions and identified the key requirements.
- Aggregated and visualized the data by using pandas, matplotlib and wordcloud to compile a professional report.
EXECUTIVE KPI DASHBOARD FOR NORTHWIND TRADERS
- Created an interactive KPI dashboard for Northwind Traders using Power BI, focusing on sales trends, product performance, key customers, and shipping costs.
- Performed ETL (Extract, Transform, Load) operations using Power Query in Power BI to clean and transform data from the 7 Excel tables, ensuring data accuracy and consistency.
- Presented the dashboard to the executive team, offering actionable recommendations based on the analyzed data, thereby enabling data-driven decision-making for Northwind Traders.
SALES PERFORMANCE ANALYSIS
- Utilized SQL to extract data from 8 different related tables from customer sales databases using JOIN and VIEW.
- Transformed and filtered data by using aggregating and filtering function to improve reporting process.
- Loaded and visualized data with Python to identify key business intelligences that can improve sales performance.
Data Coordinator @ McKesson - Jacksonville, FL (Sep 2022 – June 2023)
- Managed the end-to-end photo request workflow, including receiving, reviewing, and coordinating photo requests from Alternative Sourcing Vendors (ASVs), ensuring timely delivery and adherence to quality standards.
- Utilized MS Access to extract photo request data, providing accurate and up-to-date information on open requests, enabling efficient tracking and monitoring of ASV performance.
- Leveraged MS Excel to organize and analyze data related to photo requests, generating insightful reports and summaries to support decision-making processes within the ASV team.
- Utilized Snowflake to extract and analyze data, gaining valuable insights into photo request patterns and trends, and presenting findings to support process optimization and operational efficiency improvements.
Sales Associate @ THE HOME DEPOT – Jacksonville, FL (July 2022 - Present)
- Assisted customers in-store and over the phone, demonstrating knowledge of supply chain processes and effectively communicating product availability and delivery timelines.
- Collaborated with team members to ensure accurate inventory management, including restocking shelves and coordinating with distribution centers for timely product replenishment.
- Collaborated with team members to maintain an organized sales floor, optimizing the overall customer experience.
DATA ANALYST @ Kentucky Transportation Center (KTC) – Lexington, KY (Sep 2019 – May 2020)
- Reviewed and updated account information in company computer system.
- Completed quality assurance reviews to assess accuracy of data and validate results.
- Formulated, defined and documented system specifications.
- Organized subsystems to execute proper collection of data.
- Compiled and modeled data using MS Excel and Access.
- SQL (SQL Server, MySQL, PostgreSQL)
- Python (Pandas, NumPy, Seaborn, Matplotlib)
- Microsoft Excel (VLOOKUP, XLOOKUP, Pivot Tables, Conditional Formatting, Pivot Charts, Power Pivot)
- Cloud Computing (Snowflake)
- BI Tools (Microsoft Power BI, Tableau, Power Query)
- Microsoft 365 (Access, PowerPoint, SharePoint, Outlook, Teams)