Summary
Overview
Work History
Education
Skills
Websites
Projects
Timeline
Generic
M Waqas Akbar

M Waqas Akbar

Data Analyst
Lahore,PB

Summary

Experienced Data Analyst with proven expertise in leveraging advanced analytical skills, SQL proficiency, and BI tools to derive actionable insights. Adept at problem-solving, with strong communication skills and a drive to master new technologies.

Overview

11
11
years of professional experience
4
4
years of post-secondary education

Work History

Data Analyst

Nishat Chunian Group
Lahore, PB
8 2022 - Current
  • Responsibilities include:

    - Conducting data analysis and leveraging insights to drive strategic decisions.
    - Developed dashboards for the entire group in alignment with 6 different departments.
    - Designing and managing databases, ensuring optimal data quality and integrity.
    - Visualizing data effectively using Power BI to enhance reporting capabilities.
    - Managing ETL processes for efficient data integration.
    - Performing data cleansing and mining to extract meaningful patterns and trends.
    - Engaging in all phases of the project lifecycle—from requirements gathering to application design and seamless module integration.
    - Utilizing data visualization tools to effectively communicate business insights.

Data Analyst and ERP Consultant

IGUID ENTERPRISE SOLUTIONS PRIVATE LIMITED
01.2021 - 06.2022
  • Provide wide variety of support services such as Oracle SaaS, PaaS and IaaS solutions.
  • Visualizing data using Power BI.
  • Implementation of ERP - Implementation of customized software solutions for clients - Manage Oracle EBS R12 and its related customer queries - Development of custom Database Packages, Procedures and other PL/SQL requirements.

Data Analyst

Nishat Chunian Group
01.2017 - 01.2021

As a Data Analyst, I successfully completed projects in:
- Data Visualization
- Data Cleaning
- Data Mining
- Data Modeling


My expertise includes Power BI and SQL.

Oracle Developer AND Functional Consultant

Nishat Chunian Group
02.2013 - 01.2017
  • PL/SQL Query writing and analyzing.
  • Packages procedures and views, Functions.
  • Developed or customized Oracle reports and forms to meet functional business requirements
  • Designed and implemented scalable applications for data extraction and analysis
  • Tested and deployed scalable and highly available software products

Education

University of the Punjab, Lahore
01.2008 - 04.2012

Skills

Analytical Skills

Projects

Power BI recent projects:


- Sales Dashboard
 - Developed a comprehensive sales dashboard using Power BI for performance analysis and decision-making.
 - Created complex queries for real-time insights from multiple data sources.

- Ageing Raw Material Analysis
 - Designed and implemented a dashboard to optimize inventory management by monitoring raw material ageing trends.
 - Utilized PL/SQL for data preprocessing and integration.

- Overdue Receivables Management
 - Developed a SQL-driven dashboard to streamline cash flow by tracking overdue receivables.

- Human Resources Turnover Analysis
 - Built a dashboard to analyze turnover patterns and enhance retention strategies.
 - Conducted statistical analysis using SQL queries, reducing attrition by 15%.

Timeline

Data Analyst and ERP Consultant

IGUID ENTERPRISE SOLUTIONS PRIVATE LIMITED
01.2021 - 06.2022

Data Analyst

Nishat Chunian Group
01.2017 - 01.2021

Oracle Developer AND Functional Consultant

Nishat Chunian Group
02.2013 - 01.2017

University of the Punjab, Lahore
01.2008 - 04.2012

Data Analyst

Nishat Chunian Group
8 2022 - Current
M Waqas AkbarData Analyst