خلاصہ

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
اکتوبر ۲۰۱۹ - موجودہ | 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
جولائی ۲۰۱٦ - اکتوبر ۲۰۱۹ | 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
جون ۲۰۱۳ - جولائی ۲۰۱٦ | 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
انٹرمیڈیٹ / اے لیول, انٹرمیڈیٹ ان کمپیوٹر سائنس, I.C.S‎
Computer Science, Mathematics, Statistics
فی صد 52%
2012
Govt. Islamia High School
میٹرک / او لیول, سائنس, Matric in Computer Science‎
Biology, Chemistry, Physics
فی صد 67%
2010

پیشہ ورانہ مہارتیں

ماہر Excel VBA
ماہر Google Sheet Management
ماہر Microsoft Excel
ماہر Power BI
ماہر Reporting and Analysis

زبانیں

ماہر انگریزی