AHAD ALI KHAN

ad32zg@r.postjobfree.com +1-423-***-**** 2198 Tournament Dr, Chattanooga, TN, 37421

PROFESSIONAL SUMMARY

To pursue my professional career in a dynamic and professional environment where I can broaden my horizon. I want to be associated. with an organization where hard work and dedication is awarded with career opportunities for growth. MY DIVERSE AREAS OF EXPERTISE

o Proficient in advance MS Excel, ETL with Power Query, o Power BI, SQL (Intermediate)

o Automation of sheets with advance formulas (Vlookup, Xlookup) etc CAREER HIGHLIGHTS

Joblogic, Lahore, Pakistan (www.joblogic.com)

Technical Support Specialist Oct 2021 – Feb 2024

Major Responsibilities are:

o Write, Test SQL Reports and Data Source to extract data from the Azure DB o Data collection and cleaning into Excel Templates for bulk data imports o JIRA Tickets handling and Bugs investigation to manage custom technical requirements and customer esclations o Test software in UAT environment for new updates and suggest ideas o Import through Zapier for bulk data

o Handle queries of the customer over the video call to understand the working of the system and guide them about Joblogic interface.

Joblogic, Lahore, Pakistan (www.joblogic.com)

Data Analyst June 2020 – Oct 2021

Major Responsibilities are:

o Automate google sheets reports for findings/results for management with help of advance excel formula and techniques

o Maintain and update Power BI dashboard for multiple departments o Demonstrated new techniques for efficient reporting e.g coding, VBA, SQL function (Query,Select) o Created dashboard and data entry form on JavaScript for HR Recruitment data entry sheet EDUCATION

o BSc Hons in Economics 2010 (Government College University, Lahore) o Intermediate (FA) 2006 (Government College University, Lahore) o Matriculation (Science) 2004 (Lahore Model School, Lahore)