Analytics & Data Science Lead in BI & QA

www.linkedIn.com/in/moaizahmad *****.***@*****.*** Deer Park, NY

Moaiz Ahmad

Dedicated Analytics and Data Science professional with a proven track record of 7 years specializing in data manipulation, visualization, and modeling. Expertise in PowerBI, Tableau, RStudio, and Excel, proficient in SQL and T-SQL. Microsoft Certified in Data Science and experienced in leading analytics initiatives and actionable insights/optimizations. Seeking a dynamic role to contribute analytical insights, leverage data-driven decision-making, and drive team excellence in a growth-oriented environment.

ABOUT ME

Microsoft Excel

Microsoft Office Suite

Microsoft SQL Server

Search and Social platforms

Google Analytics

Tableau

PowerBI

SnowFlake

Python

RStudio

SOFTWARE SKILLS

PROFESSIONAL EXPERIENCE

Senior Analyst on the Data Governance team for the Novartis account. Lead the monthly reporting process, ensuring accurate data extracts and quality assurance (QA) across search, social, and display teams.

Developed and executed SQL queries in Snowflake for data QA and validation. Designed and maintained automated reports and dashboards to monitor key performance indicators (KPIs). Managed the data ticketing system, resolving discrepancies between Excel reports and dashboards. Utilize ETL processes to acquire, transform, and load data from diverse sources, including Azure Blob Storage, enhancing data integration and workflow efficiency. Ensure data accuracy on dashboards by cross-checking with Snowflake, our primary database. Extract data from Snowflake using SQL, then verify against various platforms (GA, DCM, META, TikTok, LinkedIn) using pivot tables and advanced Excel formulas.

Lead data analytics discussions and addressed questions in cross-functional team meetings. Collaborate with cross-functional teams to understand data needs and provide actionable insights. Provide training and support on data extraction, QA procedures, and reporting tools. Senior Business Intelligence Analyst

Publicis Health Media, New York, NY February 2024 – Present Senior Analyst

Lead Analyst for the Microsoft account.

Collected and compiled data from multiple platforms (Google Analytics, TikTok, Twitter, Reddit), ensuring accuracy and consistency.

Created and maintained reports and models using RStudio for in-depth analysis. Created and maintained dynamic and interactive dashboards in PowerBi Employed ETL processes to acquire, transform, and load data from various sources, including Azure Blob Storage. Utilized SQL and Excel for data extraction, cleaning, validation, and transformation, preparing datasets for analysis. Developed and created compelling data visualizations with Tableau and Power BI. Automated reporting and dashboard creation to monitor and analyze key performance indicators (KPIs). Carat, New York, NY March 2022 – February 2024

Data Analyst

Dataflow Development: Improved weekly data processing efficiency by managing and optimizing scalable data pipelines. Ingested, transformed, and distributed data streams from 20+ sources across multiple marketing channels (programmatic, digital, and social)

Dashboard Visualization: Boosted campaign performance through designing interactive dashboards and reports (Datorama, Tableau, Power BI, and Excel) to illustrate spending patterns and KPI performance. Reporting: Coordinated weekly pacing meetings and presented campaign optimizations to internal and external stakeholders

Ensure data accuracy on dashboards by cross-checking with Snowflake, our primary database. Extract data from Snowflake using SQL, then verify against various platforms (GA, DCM, META, TikTok, LinkedIn) using pivot tables and advanced Excel formulas..

Analyzes and reports out on the performance of the media programs, including variance analysis and proposed course corrections to the marketing leadership team

GroupM, New York, NY July 2020 – February 2022

Microsoft Certified in Data Science (Orientation)

EDUCATION

Microsoft Certified in Analyzing and Visualizing Data with Power BI Microsoft Certified in Querying with Transact-SQL

Moaiz Ahmad

Data Analyst

Analyst on the TIAA and BODY ARMOR accounts

Responsible for data collection, cleansing and subsequent reporting/dissemination to the respective cross- functional team as well as client stakeholders

Developed reporting templates for weekly, monthly wrap reports to meet evolving needs and expectations of both day-to-day client-side management as well as senior leadership Create dashboards and deliver data using Tableau for monthly and wrap reports. Clean, format and manipulate data using pivot tables and formulas in Excel for day to day data delivery to team members and senior leadership

Universal McCann, New York, NY January 2018 – May 2020 Data Analytics Analyst

Member of Data & Reporting team.

Used SQL and reporting tools, including PowerBI, for operational and visual reports. Collaborated with Retail and Web Sales teams on data profiling. Assisted in maintaining Reporting Database on Oracle. Developed and maintained ETL scripts.

Nike, New York, NY September 2016 – December 2018

Data Science Intern

Developed T-SQL code for reporting purposes for internal departments Key member of QA team to ensure the quality of data & reports via integrity tests Created KPI reports for different departments to enhance student’s overall approach to learning Took active part in Tableau POC

Accenture, New York, NY May 2015 – June 2016

CUNY - Queens College

B.S, Computer Science

Contact this candidate