ALAN SARIEDDINE

alsariedd@gmail.com | +1 (469) 969-8382 | https://www.linkedin.com/in/asariedd/ 

Dallas, Texas

Education

Southern Methodist University (SMU), Dallas TX, Aug 2019 - May 2023

• Bachelors of Science in Data Science

• Bachelors of Arts in Advertising

Current cumulative GPA – 3.4/ 4.0

Skills & Abilities

PowerBI, SQL, Microsoft Office (Excel, Powerpoint, Word), Descriptive Analytics, Time Series Analysis, Data Modeling, Data Transformation, Research, Social Media Marketing, Storytelling

Certifications

• Microsoft Certified: PowerBI Data Analyst Associate

• Google Analytics Certification

Experience

BrandMuscle – https://www.brandmuscle.com/

Data Analyst Intern                                        May 2023 – August 2023

•  Data Analysis: Developed comprehensive Excel Dashboards highlighting key insights, leading to increased visibility and actionable recommendations for campaign optimization by calculating essential metrics such as click through rate and view rate, enabling a better understanding of campaign effectiveness and audience engagement.

•  Reporting: Delivered bi-weekly client reports to clients, providing accurate details of purchased items and associated costs utilizing SQL to extract and compile data, leveraging PowerBI to develop and distribute timely reporting.

•  Data Cleansing: Implemented data organization and cleaning processes using Python and SQL developing accurate and actionable insights for the clients marketing strategies facilitating targeted analysis and enabling more effective allocation of advertising resources.

RAAP – www.rapp.com

Marketing Science Summer Intern            June 2021 – August 2021

• Automation: Developed Macros-code to automate the the process categorization of customer experience trends that resulted in more accuracy and productivity of 40 hours per week eliminating manual data entry processes. Created the documentation to ensured that this process if repeatable for other future projects.

• Visualization: Performed the data analytics cycle from data acquisition, cleansing to analysis in order to finally create meaningful insights through multiple sets of visualization and improved decision making.

• Research: Performed social media market research and proposed multiple methods to enhance brand awareness in the MENA region and presented to the executive leader.

PROJECTS

Project Management Executive Dashboard

• Developed streamlined data model using data cleansing and transformation procedures in PowerBI PowerQuery with a combination or Query Editor and DAX formula language.

• Enabled automated refresh of the dashboard by connecting to Sharepoint hosted excel file reducing the manual effort required.

• Compiled key performance indicators by interviewing executives to define pain points and methods to alleviate them through data driven decision making.

• Displayed project trends using line graphs utilizing historical data to predict performance over time.

• Presented dashboard to panel for feedback and potential enhancements while articulating technical aspects of the dashboard to non-technical users.

TEA – Graduation Rate Analysis Report                                   

• Performed data cleansing, table creation and data aggregation using SQL to manipulate dataset into a usable format.

• Discovered strong relationships between columns by applying a correlation matrix to the dataset to remove excess columns and data points.

• Analyzed data by applying clustering, time series analysis, and description analytic techniques to enhance the readers understanding of the underlying data.

• Determined conclusively multiple methods to increase the graduation rate of the cities while identifying the root cause to the lower graduation rates within counties.

Dating App Market Research Project

• Provided research and strategic consulting to inform dating app marketing efforts to the college student target as part of SMU advertising account planning class collaboration. Synthesized and presented category and competitive research, and pitched concepts and plans for feature enhancements to the marketing team and COO.