Mina Elkholy

Egypt

@Mina_Elkholy

Freelance Data Scientist & Desktop Application Developer

Personal Information

Mina.Elkholy@hotmail.com
+20-01151188305
Egypt

Badges

CPP
Python
Sql

Certifications

Work Experience

  • Freelance Data Scientist

    Upwork•  March 2022 - Present•  Cairo, Egypt

    As a freelance data scientist on platforms like Upwork, Khamstat, Mostqel, Freelancer, and Fiverr, I have gained extensive experience in extracting KPIs and insights from data, developing and optimizing databases, designing data warehouses, and building various data models. I have also taken on roles in database administration and security, problem-solving with multiple programming languages, and creating dashboards and reports. My work includes designing storytelling presentations, developing desktop applications, creating professional documents, building websites, and utilizing AI tools for generating and editing content. Additionally, my proficiency in copywriting with a high typing speed and accuracy has been an asset in my freelance projects. - Extracted KPIs and insights from data, and built regression, classification, and clustering models. - Developed databases with SQL, PL/SQL, T-SQL, and PostgreSQL, including optimizing queries and designing databases from scratch with EERD, ERD, and different schema types. - Generating Database Reports including Skills of SSAS, SSIS, SSRS, Oracle Reports, and Forms, also Generating Crystal Reports for the Analysis Tasks. - Building Mobile Applications and Web Applications with Oracle APEX. - Administered and secured databases in Oracle, MySQL, and MS SQL Server, and designed Dataware houses, applying ETL and ELT processes. - Built recommendation systems and chatbots, and solved problems using C++, Python, and C#. - Created dashboards and reports using Power BI, spreadsheets, and Excel, and designed storytelling presentations for stakeholders to enhance business outcomes. - Developed desktop applications with .NET Framework and Guna 2 UI Tools, and created professional documentation, presentations, cover letters, and resumes. - Built websites with Canva and Wix, and utilized AI tools for generating images, videos, and editing techniques. - Excelled in copywriting with a speed of 111 WPM and an accuracy of 100%.

  • Foundation in Specialization Intern

    ALX Africa•  April 2023 - September 2024•  Cairo, Egypt

    During my 11-month internship with the ALX Africa Foundation in the Data Science specialization, I gained invaluable practical experience and developed a comprehensive skill set that has prepared me for the industry. The program focused on enhancing our technical expertise in data science, building a standout portfolio, and mastering essential soft skills. We worked on various projects, learned advanced data analysis and cleaning techniques, and integrated AI into our workflows. Additionally, we were trained in professional communication, time management, and stress management, ensuring we could perform under pressure. The internship also emphasized personal growth with daily habits like meditation, morning pages, and exercise, which boosted our productivity and well-being. Furthermore, we honed our ability to create professional documents and optimize our online presence for job applications, making us well-rounded and competitive candidates in the job market. - Analysing and cleaning data. - Utilizing AI for data processing. - Completing data-driven projects. - Building a robust data science portfolio. - Creating an impressive portfolio using Notion, Canva, and Wix. - Writing professional emails. - Crafting winning cover letters. - Optimizing LinkedIn profiles and ATS resumes. - Learning interview tips and tricks. - Practicing excelling in interviews. - Time management, communication, presentation, and negotiation skills. - Working effectively under pressure and handling multitasking. - Daily habits: meditation, morning pages, and exercise. - Managing sleep hygiene and stress.

  • Data Science Intern

    Explore AI Academy•  July 2023 - August 2024•  Cairo, Egypt

    During my 11-month internship at Explore AI Academy in the Data Science field, I worked on practical projects and exams addressing real-world problems faced by the United Nations. I gained extensive skills in data analysis, machine learning, and advanced data visualization using tools like Google Spreadsheets, Power BI, SQL, and Python. My experience included building recommendation systems, regression and classification models, and implementing clustering algorithms such as K-Means and KNN. Additionally, I learned to create dashboards and reports, perform statistical analysis, and leverage AWS for cloud services. The internship also provided hands-on experience with Natural Language Processing, neural networks, and chatbots. Working collaboratively on these projects honed my teamwork skills, particularly using Power BI Server, and taught me effective data cleaning techniques and storytelling to meet business needs. - Analysed data, created visualizations, and built dashboards and reports using Google Spreadsheets, Power BI, SQL, and Python. - Built regression models, classification models, and recommendation systems while learning machine learning algorithms and techniques. - Implemented clustering algorithms like K-Means and KNN and performed statistical analysis. - Developed Natural Language Processing algorithms, LLMs, Prompt Engineering, performed text analysis, and constructed neural networks for data prediction. - Worked on United Nations projects, including water limitations issues, and built chatbots and custom ChatGPT solutions. - Created Excel sheets with visualizations and KPI analysis from scratch, applied data cleaning techniques in industry settings, and customized dashboards with Power BI Server. - Optimized SQL queries, utilized AWS for cloud services, and explored XGBoost and LightGBM algorithms through Jupyter Notebooks and Jupyter Labs in Anaconda environments. - Enhanced teamwork and collaboration skills, and applied storytelling and business need analysis through data interpretation. - Mastering Python Packages like: NumPy, Scikit-Learn, Pandas, Seaborn, and Matplot.

  • AI Career Essentials (AICE) Intern

    ALX Africa•  May 2024 - July 2024•  Cario, Egypt

    During my eight-week internship at AICE (AI Career Essentials) from ALX, Africa on the Savana Platform, I immersed myself in the world of AI, mastering prompt engineering and leveraging AI tools to enhance my capabilities as a data analyst and data scientist. This experience allowed me to generate and apply AI knowledge to various exams and milestones, significantly enriching my professional skill set. AI and Prompt Engineering: - Mastered prompt engineering for chatbots like Copilot, ChatGPT, and Gemini. - Utilized these skills to streamline data analysis and scientific workflows. AI Tools for Multimedia Creation: - Generated images and videos using tools such as CupCut, Bing Image Creator, Leonardo AI, MidJourney, and Pika Art. - Produced audio content with Stable Audio and Pika Art. Professional Optimization and Presentation: - Enhanced LinkedIn profiles by using Snapper Photo Analyzer and Resume Worded to select the right format and images. - Generated optimized cover letters and ATS-compliant resumes using AI tools. - Practiced interview skills on platforms like Pramp and Interview Warmup. Design and Publishing: - Designed logos and websites using WIX and Canva. - Published personal presentation websites tailored for companies. Image and Video Editing: - Edited images and videos using AI Ease. Time Management and Business Enhancement: - Managed time effectively with the Para AI Tool. - Leveraged ChatGPT to enhance business strategies and ideation processes.

  • Founder Academy Intern

    Mastercard Foundation•  March 2024 - July 2024•  Cairo, Egypt

    During my three-month internship at ALX Africa's Founder Academy Powered by Mastercard Foundation, I had the opportunity to immerse myself in various aspects of business development and entrepreneurship. This comprehensive program taught us how to transform innovative ideas into tangible realities, starting with conceptualizing new technology ideas and calculating the necessary budget for our projects. We explored strategies for securing sponsorships and gaining the confidence of potential investors to bring our visions to life. Additionally, the curriculum covered practical applications of AI in business, focusing on enhancing operations and decision-making processes. - Think of a new technology idea and make it real. - Calculate the budget of the project. - Get sponsorships and founders to believe in our idea. - Apply AI in business to improve operations. - Brand myself and my ideas using landing pages, Canva, and other platforms. - Optimize a company page on LinkedIn to attract customers. - Identify the best business environment for our company. - Build a lean canvas model to highlight our product’s unique value. - Create a pitch deck to effectively present our product. This internship was a pivotal experience, equipping me with the skills and knowledge to confidently embark on my entrepreneurial journey.

  • ALX Foundation Intern

    ALX Africa•  March 2023 - July 2023•  Cairo, Egypt

    During my three-month internship with ALX Foundation, I underwent intensive soft skills training designed to develop resilience, embrace challenges, and foster continuous learning for the future of technology. The program emphasized time management techniques like the Pomodoro Technique, stress management through meditation, and the importance of action over mere planning. We used platforms like Canva and Wix to develop our portfolios, and Canva and PowerPoint for presentations. The training also covered storytelling, Google software proficiency, resume writing, ATS optimization, job hunting strategies, active listening, communication skills, Agile and waterfall models, wireframe and mock-up development, and creating compelling cover letters and pitch materials and apply all skills in milestones and real projects. - Mastered time management techniques (Pomodoro Technique) and stress management (meditation). - Emphasized action-oriented focus rather than planning without execution. - Developed portfolios and presentations using Canva, Wix, and PowerPoint. - Crafted compelling stories and problem-solving narratives. - Gained proficiency in Google software (Drive, Docs, Gmail, Google Meet). - Optimized resumes, GitHub, and LinkedIn profiles for ATS. - Learned job hunting techniques and how to approach managers. - Enhanced active listening, feedback, communication, and negotiation skills. - Understood Agile and waterfall project management models. - Created wireframes and mock-ups for applications. - Developed effective cover letters and pitch materials (writing and videos). - Improved decision-making and prioritization skills. - Practiced morning routines and recognized their benefits. This internship was instrumental in equipping me with the soft skills necessary to navigate the evolving landscape of technology and business.

  • Data Analysis and Visualization Intern

    Information Technology Institution (ITI)•  November 2021 - March 2022•  Cairo, Egypt

    During my three-month intensive training in Data Analysis and Visualization at the Information Technology Institute (ITI), I gained comprehensive skills in various tools and techniques essential for data analysis. This internship provided in-depth knowledge of Excel, Power BI, Python, machine learning, database design and development, SQL, and PL/SQL. Additionally, I learned about data warehousing, Oracle databases, and Toad software. The program also covered freelancing techniques and how to start a career as a freelancer, certifications from Mahara Tech Website, and essential soft skills like presentation, communication, and negotiation skills. I also learned how to write ATS resumes and optimize LinkedIn profiles. Key Learning Areas: - Mastered Excel and Power BI for data analysis and visualization. - Learned Python and its libraries (Pandas, Matplotlib, scikit-learn, Seaborn, NumPy) for scripting tasks and data analysis. - Understood machine learning principles and applied regression and classification models. - Developed skills in database design and development, including SQL, PL/SQL, and building packages and triggers. - Gained knowledge in data warehousing and enhancing business operations. - Worked with Oracle databases and Toad software. - Learned freelancing techniques and how to start a freelance career. - Obtained certifications through Mahara Tech courses. - Enhanced statistical analysis and analytical SQL skills, including PostgreSQL and SQLite. - Developed soft skills in presentation, communication, and negotiation. - Learned to write ATS-friendly resumes and optimize LinkedIn profiles. Applied Projects: - Executed multiple Python scripting tasks and data analysis. - Scraped JSON files and websites for data collection. - Applied regression and classification models for predictive analysis. - Designed a data warehouse for airborne data. - Analysed IBM employees' turnover rate. - Analysed a new website for songs similar to Spotify. - Built a comprehensive dashboard for Tokyo Olympics data using Power BI. - Analysed S&P stock data from CSV files, including data cleaning and creating a full dashboard.

  • Entrepreneur Intern

    Injaz•  July 2019 - August 2020•  Cairo, Egypt

    During my one-year internship at Injaz Company, I gained invaluable insights into becoming an entrepreneur and founder, with a particular focus on building small businesses in the technology sector. The program provided a comprehensive understanding of technology and the political landscapes of different countries we aimed to develop products for. - Enhanced business operations and strategies. - Developed creative and critical thinking skills to generate new ideas. - Transformed ideas into mock-ups and wireframes to achieve business goals. - Learned to think like a businessman and effectively brand-new ideas. This experience has been instrumental in shaping my entrepreneurial mindset and equipping me with the skills necessary to thrive in the business world.

  • Business Analysis and Software Testing Intern

    Positive Edge•  June 2019 - July 2019•  Cairo, Egypt

    During our one-month internship at Positive Edge, we delved deeply into the realms of business analysis and software testing. This intensive program was a perfect blend of theory and practical experience, providing us with a solid foundation in both areas. We explored the essentials of business analysis, learning how to effectively gather and document requirements, analyze business processes, and communicate findings. Simultaneously, we were introduced to the world of software testing, where we gained hands-on experience in designing test cases, executing test plans, and reporting bugs. The mentorship and collaborative environment at Positive Edge ensured that we not only learned the fundamentals but also understood how to apply them in real-world scenarios, making this internship an invaluable stepping stone in our professional journey.

Education

  • Ain Shams University

    Computer Science, BS•  September 2016 - August 2020•  Percentage: 75.98

    As a graduate of Ain Shams University with a B.Sc. in Computer Science and Information, I have developed a solid foundation in software development, data science, and machine learning. My academic journey included hands-on projects and active community involvement, all of which have prepared me for a career in data science. Relevant Coursework: Object Oriented Programming, Data Structures, Algorithms, System and Database Design with Oracle, Microsoft SQL Server, PostgreSQL, SQLite. Programming in C++, C#, Python, Computer Architecture, Logic Design, Testing and Validation, Assembly, VHDL. AI Algorithms, Machine Learning, Deep Learning, Image Processing, Computer Vision, Probability and Statistics, R, Matlab. Information Systems and Simulation Design, Web Development (HTML, CSS, JavaScript), Software Testing, Xamarin for Mobile Applications. Key Projects: Developed a Bank System using C++ and OOP concepts, created Traffic Sign Detection and Recognition using YOLO V5. Implemented sorting and searching algorithms in C++ and C#, built simulation systems and hardware simulations using VHDL. Analysed baseball teams and weather data using Jupyter Notebooks and Python, developed deep learning models for animal image classification. Created a comprehensive statistical analysis package in R. Community Involvement: Member of ACM ASCIS, engaging in competitive programming and problem-solving on Code Forces. Participant in OSC, learning Linux commands and exploring open-source applications.

Skills

Data Analysis
Data Visualization
Data Science
Data Cleaning
Data Imputation
Data Automation
Automation
Statistics Concepts
Statistical Analysis
Descriptive Statistics
Inferential Statistics
Dashboards Designing
Reprots Designing
KPIs & Insights Extraction
Data Storytelling
Business Intelligence
Database Design
ERD Design
EERD Design
Conceptual Schema Design
Draw.IO
Data Modelling
Data Warehouse Design
Star Schema Design
Database Development
Database Optimization
SQL
T-SQL
PL SQL
Analytical SQL
Analytical PL SQL
SQL Tuning
SQLite
PostgreSQL
MySQL Server
Microsoft SQL Server
SSRS
SSAS
SSIS
Oracle Databases
Oracle Forms Builder
Oracle Reports Builder
Oracle APEX
NoSQL
MongoDB
Microsoft Excel
Excel VBA
Google Sheets
Google Sheets Code
Power BI
Anaconda Tools
Jupyter Notebooks
Jupyter Lab
AWS (Amazon Web Services)
C++
C#
Desktop Applications Development
ADO.NET
ODP.NET
R Language
Matlab
Python(Advanced)
Python Pandas
Python Numpy
Python Sckit-Learn
Python Open-CV
Data Structure
Algorithm
Object-Oriented Programming
Machine Learning
Deep Learning
Image Processing
Computer Vision
Regression Analysis
Classification Models
Clustring Models
Natural Language Processing Models
LLMs Designing
Prompt Engineering
AI Tools
ChatGPT
Gemini
Copilot
Problem-Solving
Team Leadership
Adaptability
Communication Skills
Negotiation Skills
Presentation Skills
Public Speaking Skills
Audiance Understanding
UI Design
Wordpress Development
Figma Design
Canva Design
Microsoft Power Point
Microsoft Word
Bing Image Creator
Midjourney
WIX Designing
Documents Design
Presentations Design
Resume Design
Cover Letter Design
Logos Design
Wallpapers Design
Video Editting
Video Creation
Wireframes Design
Mockups Design
Prototypes Design
Websites Design
Motion Graphic
Whiteboard Design
Animations Design
Web Scrapping
Regular Expressions Handling
Text Analysis
Azure SQL
Shiny for Python
Python Selenium
Python Streamlit
Generating Crystal Reports
DAX
Power Query