AHAD ALI KHAN
***********@*****.*** +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)