Jamal Nelson Email & Phone Number

New York, Ny, Us

• Provide data transparency across all departments, KPI alignment with business goals, and insight on audience behavior trends across 7 national brands and over 50 local radio brands • Manage all analytics projects for the business functions to provide high level insights on the effectiveness of daily operations and R.O.I for any major marketing initiatives• Utilize SQL queries to perform ETL processes of data from the data warehouse needed to conduct MoM performance comparison reports for Executive leadership team• Perform Tableau cross database joins to analyze user data across multiple brand marketing experiences (Social, Website, Video, etc.) using knowledge of SQL relational databases• Create Tableau Visualizations to highlight daily/monthly/yearly performance trends across multiple channel groupings• Assist Executive leadership with brand content strategy by performing distribution analysis of KPI’s to determine the niche topics influencing majority of audience visits to website • Enhance data reporting and understanding across all departments to prioritize effective tagging for accurate measurement of all marketing campaigns (internal and external) • Lead Email Retainment Strategy to grow, develop, and analyze audience behavior via web-based event tracking and source segmentation • Leverage Google Analytics alerts to monitor any website traffic issues or tracking anomalies across all national brands in real time• Performed Content Topic Analyses using NLP, to provide insight on the R.O.I on editorial production output for topics that drove high volume traffic to the website and those that stimulated deeper engagement because of consuming the article

New York, New York, Us

• Transformed the daily/monthly reporting for the overall business to provide transparency into the impact of company’s production against KPI’s, Revenue, and Product Engagement • Enhanced integrity of the data via proper implementation of GTM third-party marketing tags and advanced custom JavaScript tags on key pages for effective strategy and retargeting• Spearheaded implementation of data analytics tools to help provide clarity into user engagement on our site via key user event interactions, cohort analysis, and segmentation• Created user interactive dashboards, for all business departments, to provide insights on ROI for marketing campaigns via actionable KPI’s across all marketing channels• Developed a wholistic analysis on the user journey touchpoints from offline marketing campaigns, to landing page engagement and messaging, and lastly via online conversions and user retention

New York, New York, Us

• Delivered the daily/monthly reporting on KPI’s across each marketing channel to assess the growth or decline as a result of the company’s production• Ensured integrity of the data by monitoring proper implementation of JavaScript tags on our websites, along key touchpoints, for deeper engagement• Spearheaded data projects that helped provide clarity into the effect of our marketing efforts on the audience, which impacted decision making on optimizing the user journey• Transformed Sponsored Program Reporting from providing static spreadsheets to clients into interactive dashboards with key visualizations that provide insights on audience engagement• Modified Client Lead Generation reporting to increase efficiency and provided dynamic real time dashboards highlighting overall campaign performance (ROI)• Leveraged Google Search Console to inform website performance and optimization around Marketing efforts

New York, Ny, Us

• Developed a Web Analytics Measurement Framework to align key performance metrics with significant business goals for efficient and effective analysis via communication with stakeholders• Created a weekly assessment for content published on MorganStanley.com as a narrative on the user journey via conversion points on the website, which provided insights into user engagement• Built actionable dashboards using Tableau Visualization Software, that highlighted any notable trends and any possible outliers within the data for key performance indicators• Leveraged my knowledge of Adobe Analytics metrics, to inform businesses firm-wide of current website performance and distribute Ad-Hoc reports used in deriving valuable insights to support any recommendations on optimizing performance• Used Simply Measured to evaluate the ROI for marketing campaigns launched via social platforms, by performing calculations and analyzing key metrics (Impressions, Engagement rate)

- Performed queries using SQL to retrieve relevant data from the Data Warehouse pertaining to each E-commerce brand- Developed a testing template in Excel in order to perform side by side analysis of Key Performance Indicators and document any descrepancies for developers debugging- Analyzed and Queried Big data sets for Testing of KPI's (Key Performance Indicators) calculations- Generated a daily report compiled of the KPI"s used for measuring brand performance within business intervals (WTD,MTD,YTD)- Experience using ETL framework to establish efficient data flow from Data sources - Provided reports of customer activity using Google Analytics for clients E-commerce sites- Observed positive and negative measurements for brand performance within business intervals (WTD,MTD,YTD) for weekly reportingSkills Used- Knowledge of ETL process data model- SQL (MySQL, PostgreSQL, MSSQL) querying from database - Excel (If statements, Tables, Spreadsheet analysis, VLookup)- Knowledge of API and E-commerce Sites (Shopify)- Google Analytics - Calculation and Analysis of KPI's (Key Performance Indicators) for measuring performance- Knowledge of Tableau Visualization Reports for analysis

Houston, Texas, Us

- Business Process Modeling, Process Improvement, Requirements Gathering, User Acceptance Testing for more effective Business Analysis- Experience in conducting GAP analysis, As Is - To Be- Familiar with database testing using SQL- Experience working in System development Life Cycle using various methodologies Agile-Scrum, Waterfall approach- Interaction with subject matter experts, stakeholders, and end-users to understand, analyze, and communicate and validate requirements using JAD sessions- Experience in UAT (user acceptance testing) and SWOT analysis- Experience conducting flow charts using MS Visio

Chicago, Il, Us

- Manage Excel spreadsheets to prepare monthly updating of brand advertisement billing for the current quarter and fiscal year for various clients- Research information for various networks via our local database to cross reference current data and update any new terms- Create Ad Hoc analysis reports with Excel using Vlookup and Nested If formulas for client information

• Built formulas in Excel spreadsheets that would make the data easier to organize and analyze for remediation purposes• Research final fixed income securities in the Edgar Database • Examine documents in search of vital terms to be updated into the system for editing and comparison purposes using the VLookUp function• Entrusted with the task of training temporary employees to assist with the research and entry of the final data• Analyze private/public company securities for calculation of payments until full maturity

New York, Ny, Us

• Assembled and Analyzed budget spreadsheets within the departments for quarterly costs comparisons (Budgets vs. Actuals)• Collected weekly invoices to be entered in to database and verified for approval• Created copies of financial documents that were used for filing purposes