Data Analyst Digital Marketing

SIMRAN JAIN

Chicago, Illinois P: 312-***-**** *************@*****.*** linkedin.com/in/jsimran EXPERIENCE

Darwill Oak Brook, IL

Data Analyst July 2024 - Present

• Utilized Python libraries such as Pandas and Matplotlib to analyze marketing data, identifying trends in customer behavior and campaign performance that informed strategic decisions.

• Formulated and executed SQL queries that segmented patient populations based on specific criteria, ensuring tailored marketing efforts that increased engagement and response rates.

• Spearheaded the development and execution of integrated digital marketing campaigns, resulting in a 15% increase in brand visibility and a 20% boost in lead generation. A.J. ANTUNES Carol Stream, IL

Marketing Analyst Intern June 2023 – Dec 2023

• Innovated interactive dashboards in Google Data Studio, utilizing interactive charts, scorecards, tables, date range selectors, drill-down functionality, and conditional formatting to visualize insights and key performance metrics effectively.

• Leveraged advanced features of Google Analytics, such as user flow analysis, funnel exploration and behavior modeling reports to meticulously track and analyze visitors flow and interaction pattern across the entire company website.

• Implemented segmentation features in Marketo to segment customer data based on demographics, behavior, and purchase history, leading to personalized marketing campaigns and a 20% boost in click-through rates. HEM CHEM CORPORATION Mumbai, India

Senior Marketing Analyst Nov 2018 – June 2022

• Led a team of 4 for Salesforce Marketing Cloud to craft targeted email campaigns, personalized customer journeys, and execute multi- channel marketing initiatives, driving engagement and revenue growth resulting in 20% increase in customer engagement metrics.

• Planned, executed, and analyzed targeted advertising campaigns across Google Ads, Facebook Ads, and LinkedIn Ads platforms to optimize reach and engagement with specific audience segments, achieving 15% increases in click-through rates (CTR), conversion rates, and return on ad spend (ROAS) utilizing campaign management tools such as DoubleClick Campaign Manager.

• Employed complex Excel formulas and functions such as Pivot Table, VLOOKUP, HLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS, and nested IF statements to manipulate and analyze budget allocation, resulting in a 30% reduction in data processing time. Textronics Design System Mumbai, India

Marketing Analyst Intern May 2017 – Dec 2017

• Developed personalized email campaigns for brand awareness using HubSpot's email marketing tools, leading to a 25% improvement in email open rates and a 15% increase in click-through rates (CTR).

• Designed and implemented custom triggers and variables in GTM to capture specific user interactions and events, such as button clicks, form submissions, and page views.

• Defined project scope, strategy and methodology to improve customer experience and drive engagement on the website; Implemented and managed SEO content strategies utilizing WordPress, leveraging its user-friendly interface and extensive plugin ecosystem to optimize website content for search engine visibility and user engagement. Retail Association of India Mumbai, India

Marketing Research Intern Mar 2015 – May 2015

• Generated reports on Microsoft Excel for long-term and short-term financial data, KPI’s, technical support and business performances, plot graphs to support forecasting activities and compile data to consolidate reports.

• Involved in trade fairs to aid the gathering of new technologies, industry trends, market research and business development for rapidly changing business strategies.

EDUCATION

ILLINOIS INSTITUTE OF TECHNOLOGY Chicago, IL

Master of Science in Marketing Analytics December 2023 Relevant courses: Business Statistics, Analytics for Decision making, Marketing Strategy, Supply chain management, Database Management Systems, Marketing Research & Engineering, Digital Marketing, Power BI PEARL ACADEMY Mumbai, India

Post-Graduation in Fashion Business; Major in Marketing and Merchandising August 2018 BHARATHIAR UNIVERSITY Coimbatore, India

Bachelor’s in Business Administration January 2017 TECHNICAL SKILLS

Data Analysis: SQL, R, Tableau, @Risk, Excel, Advanced Excel, Python, SAS JMP Pro, Power BI, Sales Force, Looker Digital Marketing: HubSpot, Content creation, Content Ideation, Social Media Marketing, Organic social media, Keyword research, Familiarity with SEO, SEM, Google campaigns, Google Analytics Designing: In Shot, Adobe Photoshop, Illustrator, Canva, In Design Tools: Outlook, MS Word, MS PowerPoint, Google Suite ACADEMIC PROJECTS

Performance Analysis for Alaska Airlines (Tableau) Spring 2023

• Performed exploratory analysis of Alaska Airlines data to identify the key performing indicators.

• Analyzed flight frequencies over multiple locations, flight delays, routes, and performed competitor analysis.

• Built Dashboards and provided recommendations based on the analysis to improve Airlines overall performance. Database Design & SQL – Fox core Retail case study Spring 2023

• Identified entities and attributes from the case study and developed an entity-relationship diagram for the database.

• Normalized relations and removed data redundancy from 1000+ rows of data. Wrote (DDL) queries to create schema and tables.

Contact this candidate