Awais Khalid

Q

Senior Data Analyst

QMCC

Nov 2024 - Current (1 year 5 months)

As a Senior Data Analyst, I was responsible for analyzing complex datasets to derive actionable insights that informed business strategies. I collaborated with cross-functional teams to identify key performance indicators and developed comprehensive reports that highlighted trends and opportunities for growth. Additionally, I utilized AWS Redshift as our data warehouse to extract data efficiently using PostgreSQL, which enabled me to build detailed reports on Metabase. These reports covered critical metrics such as inventory status, sales figures, profit margins, revenue, and top-performing products, ultimately supporting data-driven decision-making across the organization.

Data Analyst II

Motive

Sep 2023 - Aug 2024 (1 year)

As a Data Analyst II, I was responsible for analyzing complex datasets to derive actionable insights that informed business decisions. I collaborated with cross-functional teams to develop data-driven strategies and improve operational efficiency. Additionally, I utilized AWS for maintaining, extracting, and modeling data from Redshift, which enhanced our data management capabilities. I also built comprehensive marketing reports on Metabase and created post-sales dashboards on Tableau, providing stakeholders with clear visualizations of key performance metrics.

Executive Data Management & Data Science

Zong CMPak Ltd

Apr 2022 - Sep 2023 (1 year 6 months)

Data Engineer II

Afiniti

Jan 2022 - Apr 2022 (4 months)

As a Data Engineer II at Afiniti, I was responsible for the development, maintenance, and automation of ETL pipelines tailored for our clients, ensuring efficient data flow and processing. My role involved preparing data for AI models, which included creating and maintaining Slowly Changing Dimensions (SCDs) and performing feature engineering on raw data to derive actionable insights. Additionally, I worked extensively in a cloud-based environment, leveraging cloud computing technologies to enhance our data architecture. My responsibilities also encompassed conducting in-depth analyses of the data warehouse to identify actionable points and gather critical KPIs, further supporting our data-driven decision-making processes.

R

Creative lead and manager

Rebel Club

Jun 2020 - Current (5 years 10 months)

Lead the team of designers and artists to successfully carry out content creation processes and music recording

Associate Data Engineer

Afiniti

Aug 2019 - Jan 2022 (2 years 6 months)

Development and Management of all ETL/BI processes, including Data Flow Design and Optimization. Development, testing, and monitoring of ETL/BI domain. Development and maintenance of complete Data Flow through Data-warehousing techniques. Development of Data Integrity checks making a robust data flow. Optimization of the whole ETL/BI processes through SQL query tuning. Data analysis and warehousing catering to BI and AI modeling needs. Introducing processes to use CRM data for better customer understanding and behavior prediction. Designing and implementation of 3rd Party Data Projects (used to enhance knowledge base and train AI models). Documentation of all data-related requirements. Custom PowerBI Dashboards for trends and reporting. Add

U

Data Analyst

USEN PAKISTAN

Jan 2019 - Jul 2019 (7 months)

As a part of the BI data analyst team, I am responsible for understanding business clients' requirements and delivering data according to the shared analysis definitions. I identify, optimize, and automate ad-hoc requests using Bash scripting and SQL, ensuring timely delivery of quality data while meeting strict timelines. My expertise in MySQL query scripting and optimization allows me to efficiently manage data requests. Additionally, I create PowerPoint presentations based on the data gathered to present the overall company growth to management. Furthermore, I have experience in refining, cleaning, and transforming clients' raw data into a normalized form using SQL platforms like Greenplum and DBeaver. This includes creating Slowly Chang

U

Business Intelligence Intern

USEN PAKISTAN

Sep 2018 - Dec 2018 (4 months)

As a Business Intelligence Intern, I conducted comprehensive market research in relation to business intelligence initiatives. I collaborated with our USEN partner, SOLINK Corp, to develop customized solutions tailored to client needs. My responsibilities included studying various ERP systems and their customization, as well as customizing Customer Relationship Management (CRM) systems. Additionally, I utilized SQL and PostgreSQL to manage clients' raw data, loading it into databases and modeling it into clean, normalized tables. This structured data was then used to build insightful reports on Metabase, focusing on key metrics such as sales, expenses, and customer retention.

A

Local Committee Vice President Finance & Legal

AIESEC in Islamabad

Feb 2017 - Feb 2018 (1 year 1 month)

Awais Khalid

About

Detail

Timeline

Résumé