MOHAMED NIFRAS

About

B.Tech graduate in Artificial Intelligence & Data Science with hands-on experience in Python, SQL, Power BI, and AWS. Builds end-to-end analytics solutions including ETL pipelines, predictive models, and interactive dashboards.

Experience

• Data Analyst Intern
  BDreamz Global Solutions Pvt Ltd
  Jan 2026 – Jun 2026

Education

• Bachelor of Technology in Artificial Intelligence and Data Science
  Syed Ammal Engineering College
  Artificial Intelligence and Data Science · 2021 – 2025

Skills

• SQL
• Git
• GitHub
• Python
• Jupyter Notebook
• Power BI
• Tableau
• MongoDB
• Matplotlib
• NumPy
• Pandas
• Streamlit
• scikit-learn
• OpenCV
• PostgreSQL
• PyTorch
• TensorFlow
• Seaborn
• Docker
• LangChain
• PySpark
• Databricks
• Snowflake
• ETL
• Excel
• PL/SQL
• RAG
• AWS Glue
• AWS S3
• Ollama
• Athena
• Lambda

Projects

• AI-Powered Retail Analytics RAG Chatbot
  LangChain, PostgreSQL, Streamlit, Python

  Developed a Retrieval-Augmented Generation (RAG) chatbot enabling non-technical users to query sales and inventory data in natural language. Integrated LangChain with PostgreSQL using vector embeddings for context retrieval; achieved sub-2-second average query response time on a 100,000+ record dataset. Deployed on Streamlit Cloud with user authentication; reduced ad hoc reporting requests to the analytics team by an estimated 40% in internal testing.

• Customer Behavior Analysis Dashboard
  Python, SQL, Power BI, Pandas

  Analyzed 50,000+ transactions using SQL and Python to identify purchasing patterns and customer lifetime value across product categories. Performed RFM segmentation creating 5 customer segments; built interactive Power BI dashboards for retention and churn analysis. Delivered insights that improved customer retention strategy and marketing ROI through targeted segment identification.

• Cloud-Based Retail Data Pipeline
  AWS S3, PySpark, Snowflake, Power BI

  Built an end-to-end data pipeline using AWS S3, PySpark, and Snowflake for retail sales analytics. Developed ETL workflows to transform and load large-scale datasets from a data lake into a Snowflake data warehouse. Created interactive Power BI dashboards, enabling data-driven decision-making through centralized reporting and analytics.

Courses & certifications

• Data Analytics Program · Besant Technologies, Chennai · 2025

🗣️ Languages

• English · Professional
• Tamil · Native