Hey there!

Shahid Malik.

Data Analyst

More About Me
About

Let me introduce myself.

Profile Picture

Data Analyst with more than 2 years of hands-on experience in Sales and Accounts Management.
Leveraged Excel, SQL, Power BI, and Python to extract actionable insights, identifying sales trends and opportunities that elevated revenue up to 89 million Rupees and leading profit growth up to 11%.

Profile

  • Fullname: Shahid Malik.
  • Current Role: Data Analyst
  • Email: shahidawan145@gmail.com

Skills

  • Tools: Power BI, Excel, BigQuery, AWS(EC2, S3)
  • Languages: Python, SQL, JavaScript, HTML, CSS
  • Libraries: Pandas, NumPy, Matplotlib, Seaborn
  • RDBMS: MySQL, SQL Server, PostgreSQL
  • Frameworks: Django, Flask, FastAPI
  • Other: Web Scraping, ETL, Git, Unix/Linux
Resume

More of my credentials.

Work Experience

Data Analyst

December 2021 - Present

Lasani Publisher's

Harnessing advanced SQL and Excel, conduct exhaustive CRM data analysis to unveil pivotal sales trends and capitalize on revenue-generating opportunities.
Develop and maintain ad-hoc query requests from multiple stakeholders.
Enhanced invaluable insights that evaluated revenue to an impressive 89 million Rupees within a span of two years.
Spearheaded a sales process revolution, driving an impressive 11% profit growth.
Utilizing Python, automate daily repetitive tasks, ensuring time-saving efficiencies for smoother operations.
Craft KPI dashboards, reports in Excel, distilling complex data into actionable insights tailored for stakeholders.
Conduct regular data audits and analysis for data accuracy, enhancing the reliability of sales forecasts and improving overall business projections.

Education

Bachelor's Degree in Software Engineering

Virtual University of Pakistan

Majors: Database Management and SQL Fundamentals,
Programming with C, C++, Python,
Web Development using HTML, CSS, JavScript and

Portfolio

Check Out Some of My Works.

I have done some projects leveraging Excel, SQL, Power BI, and Python to extract actionable insights, and drive data-informed decisions.