概要

An experienced Microsoft Excel & Google Sheet expert with 5 years in automate reporting, deep dive data analysis, dynamic dashboards and data visualization. I have created several Excel and Google Sheets projects, customized applications, automate templates, complex & dynamic formulas, dynamic ranges, send & receive API requests. Excel data to any JSON format and parse JSON to excel including web scraping.

My goals are quite simple to surpass your expectations, while providing the best value and quality execution on each and every project, excellent time management skills enabled me to work independently without distraction.

One of my goals is creating simple solutions to complex problems. My documents are always easy and intuitive to operate and understand. Moreover, I constantly search for new and improved ways of doing things.

I believe i possess the specialized skills that would make a valuable addition to your Work.

项目

Excel KPI dashboard for Staffing and Recruiting Agency.

工作经历

公司标识
Data Analyst
Medical Billing
Oct 2019 - 代表 | Lahore, Pakistan

Currently focused on using VBA to introduce quality of life improvement to staffs in the company and automate various tasks in each work areas.Developing VBA codes, macros, UDF functions & formulas in Microsoft Excel and Google Sheets.Excellent in analytical thinking for translating data into informative visuals and reports.Developing dashboards and visualizations for effective performance monitoring. This gives us a clear idea of how model is performing with results generated on real-time feeds.Preparing weekly, monthly performance reports and dashboards for Providers (Doctors) and Facilities (Hospitals).Supporting various departments, including Accounts, HR and Billing in reaching their goals through analysis and automation.

公司标识
Retail Coordinator / Data Analyst
Uniworth Shirt & Tie Shop
Jul 2016 - Oct 2019 | Lahore, Pakistan

Preparing monthly retail targets for each ASM, shop and territory.
Preparing weekly, monthly performance reports and dashboards.
Calculating incentive and bonuses, calculations are based on monthly performance against targets.
Keep up to date management with ASM/Store sales percentages.
Application of various formulae to get desired results from gathered data.
Keep detailed records, generate reports, and develop presentations to help management understand the logistics perspective.
Ensuring stores have enough stock.
Measuring stock quantity levels to ensure 100% availability of products at outlets through monitoring minimum, maximum and re-order levels of inventory.
Resolving Franchisee problems related to inventory, payments and taking follow-up for timely delivery of stock from warehouse.
Extensive practice of taking responsibility of Area Manager in their absence.
Handling advertising bills, negotiation with vendors and coordination with different channels management for advertising related issues.
Assisting to Marketing HOD, as well as Operation Manager and accomplishing the assigned work given by both of them in an efficient manner.
Carry out additional responsibilities and tasks as assigned by management.

公司标识
Customer Service Representative
The Resource Group TRG
Jun 2013 - Jul 2016 | Lahore, Pakistan

• Act as contact point for complaints coming for all channels. • Maintain a complete hard/soft record of complaints. • Ensure timely reporting of complaints. • Escalation of the issues on a timely manner in order to resolve complaints within the assigned Turnaround Time • Live chat handling, quick response on Email for customer complaints and queries. • Conducts follow up phone calls to survey respondents who have concerns or questions. • Performs other related duties as assigned by management. • Consistently helped my team in achieving record-high customer satisfaction rankings, improvements to the bottom line and turnaround of under-performing operations • Expert in customer care/communications, problem solving, relationship building and employee training and support. • Take ownership and ensure timely resolution in terms of customer complaints • Maintaining good professional relationship with client/customer • Provide feedback to supervisors on important issues/problems to ensure customer retention

学历

University of the Punjab
学士, 贸易学士, B.Com‎
Accounting, Economics, Mathematical Statistics
所占比重 50%
2015
Govt. College of Science
中级/A级, 计算机科学学生, I.C.S‎
Computer Science, Mathematics, Statistics
所占比重 52%
2012
Govt. Islamia High School
大学入学/0级, 科学, Matric in Computer Science‎
Biology, Chemistry, Physics
所占比重 67%
2010

技能

熟练 Excel VBA
熟练 Google Sheet Management
熟练 Microsoft Excel
熟练 Power BI
熟练 Reporting and Analysis

语言

熟练 英语