My Resume

WORK
EXPERIENCE

AIA Global Resources PVT LTD |  02/2024 – Present

  • Collected and consolidated data from multiple sources daily.
  • Analyzed and reported on Daily & monthly sales performance for employees and departments.
  • Tracked order profitability and assessed financial outcomes.
  • Analyzed refund orders to identify root causes and developed solutions to prevent future issues
  • Identified top-rated products and analyzed specific regions for targeted promotions to boost sales.
  • Reviewed listing data to ensure all uploaded listings met quality and accuracy standards.
  • Developed interactive Power BI dashboards to monitor department, group, and individual performance.
  • Performed Monthly & quarterly sales analysis and presented findings to the CEO.

Millennium Medical Billing, INC |  01/2023 – 01/2024

  • Oversee data updates in all departments to ensure accuracy and timeliness.
  • Diligently review and validate weekly, monthly, and yearly reports from all departments.
  • Collect data from various billing departments, such as claim posting, payment posting, and appeals etc.
  • Conduct thorough data preprocessing, encompassing cleansing, validation, and standardization.
  • Leverage advanced Excel techniques to perform in-depth data analysis related to medical billing, reimbursement rates, and claims processing.
  • Utilize statistical methodologies to uncover trends and insights.
  • Conduct comprehensive exploratory data analysis (EDA) to identify patterns and anomalies.
  • Develop interactive dashboards and concise reports to convey critical financial and billing metrics.
  • Customize visualizations to align with specific client and department reporting requirements.
  • Generate comprehensive reports summarizing data analysis outcomes for each client.
  • Communicate insights and recommendations clearly to our manager.
  • Document data analysis processes, methodologies, and assumptions for future reference and auditing.

SoftMining – Peshawar | 08/2021 – 12/2022

  • Getting the data and understanding what is required through metadata.
  • Asking some important questions related to SMART technique.
  • Cleaning the data from errors, null values, inconsistency, duplicated values and outliers to be valid for analysis.
  • Analyzing the data using Excel.
  • Designing an interactive dashboard based on design thinking.

VIRTUAL INTERNSHIP
CERTIFICATES

Accenture| May 2023                     

TATA | May 2023            

pwc | August 2023            

ACADEMIC
BACKGROUND

13 – Sep – 2021

Islamia College Peshawar | CGPA 3.70/4.00

PROFESSIONAL
CERTIFICATES

NAVTTC | Dec 2021                    

Coursera | May 2023        

Coursera | Nov 2023        

365 Data Science | Nov 2023

365 Data Science | Nov 2023  

COURSES

Solo learn                 

Solo learn             

Solo learn           

Solo learn

IBM

Great Learning Academy

Great Learning Academy

Data Camp

Phone:

+923025547429

Email:

msmkhan.afridi1239@gmail.com

Connect With Me: