Skip to content
View shahidmalik4's full-sized avatar

Block or report shahidmalik4

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this userโ€™s behavior. Learn more about reporting abuse.

Report abuse
shahidmalik4/README.md

๐Ÿ‘‹ Hi, I'm Shahid Malik

  • I'm passionate about data engineering, analytics, and web development, and I enjoy leveraging my skills to derive insights and build data-driven solutions.

๐Ÿ™‹โ€โ™‚๏ธ About Me

  • ๐Ÿ“Š Currently, I work as a Data Analyst at Lasani Publishers.
  • ๐ŸŽ“ I hold a Bachelor's Degree in Software Engineering.

๐Ÿ›  Skills & Technologies

๐Ÿ”น Programming Languages

  • SQL: MySQL, SQL Server, PostgreSQL
  • Python: Pandas, NumPy, Matplotlib, Django, Flask
  • JavaScript
  • HTML & CSS

๐Ÿ”น Data Visualization & Analysis

  • Power BI
  • Excel
  • Databricks
  • Airflow
  • Docker

๐Ÿ”น Cloud Platforms

  • AWS: EC2, S3, Redshift, Glue, Athena, RDS, EMR
  • Snowflake
  • BigQuery

๐Ÿ”น Libraries

  • Pandas: Data manipulation and analysis
  • Matplotlib: Data visualization
  • PySpark: Distributed data processing with Spark

๐Ÿ”น Databases & RDBMS

  • MySQL
  • SQL Server
  • PostgreSQL

๐Ÿ”น Frameworks

  • Django: Full-stack web development and REST APIs
  • Flask: Lightweight web applications and APIs

๐Ÿ”น Data Engineering & Orchestration

  • ETL Pipelines: Data extraction, transformation, and loading
  • Data Warehousing: Scalable and efficient data storage
  • Workflow Automation: Automating data tasks and orchestration

๐Ÿ”น Other Skills

  • Git: Version control for collaboration and project management
  • Unix/Linux: Command-line proficiency and scripting
  • Automation: Efficient workflows and repetitive task management
  • Web Scraping: Data collection for insights and research

๐Ÿ“š Projects

Explore some of my work:

  • ๐ŸŒ Portfolio Projects: View data analysis and engineering projects on my website.
  • ๐Ÿ’ป Coding Projects: See my latest code on GitHub.

๐Ÿ“ซ Connect with Me

Letโ€™s connect and collaborate! Feel free to reach out through:


Thanks for visiting my profile! Dive into my repositories, and letโ€™s work together on data, engineering, and innovative solutions. ๐Ÿš€

Pinned Loading

  1. 120-years-of-olympics-analysis-using-powerbi 120-years-of-olympics-analysis-using-powerbi Public

    The "120 Years of Olympic Games: A Comprehensive Review" project aimed to analyze historical Olympic Games data spanning more than a century. Utilizing data sourced from Kaggle, the project focusedโ€ฆ

    2

  2. crm-analytics-using-powerbi crm-analytics-using-powerbi Public

    The "Boosting Profitability: Optimizing Sales via CRM and Analytics" project involved the extraction, manipulation, and analysis of sales data sourced from SQL Server. Utilizing MySQL for data tranโ€ฆ

    1

  3. pandas_marketing_campaign_analysis pandas_marketing_campaign_analysis Public

    Imagine that Freedom ran a recent marketing campaign to promote the value proposition of how the debt relief program helps people achieve financial freedom. Suppose the cost of this campaign was $6โ€ฆ

    Jupyter Notebook

  4. harnessing-sql-for-sales-insights-and-improvement harnessing-sql-for-sales-insights-and-improvement Public

    The "Harnessing SQL for Sales Insights and Improvement" project involved comprehensive analysis of sales data extracted from SQL Server, imported into MySQL for data preparation, cleaning, normalizโ€ฆ

  5. investigating-patterns-in-120-years-of-olympic-data investigating-patterns-in-120-years-of-olympic-data Public

    The project involved the extraction, cleaning, and manipulation of Olympic Games dataset sourced from Kaggle. Using Excel for initial cleaning and MySQL for data preparation, normalization, and anaโ€ฆ

  6. pyspark-airflow-postgres-etl pyspark-airflow-postgres-etl Public

    This project sets up an ETL pipeline using PySpark and Apache Airflow to extract data from a PostgreSQL database, transform it, and load it into a Railway PostgreSQL cloud database. The PySpark scrโ€ฆ

    Python