Social Media Data

ABHISHEK G KARKAMKAR

201-***-**** *** Wilson ave, Kearny,New Jersey, USA 07032 **********@*****.***

Profile

3+ years of professional work experience in Marketing and Media analysis, Data analysis, Data cleansing, Data integration, Data mapping

Experience interacting with business clients to translate the business requirements into technical specifications

Experience analysing trends and forecasting sales to develop long-term strategies, key objectives, and operations execution plans based on best practices as well as maximum growth and profitability

Experience in Marketing and Media Attribution and Channel Analysis

Technical Skills

Program Management: MS Project, JIRA, Agile Scrum, Lean and Six Sigma, SDLC, DFM, PDLC, WebEx

Data Management and Visualization: MySQL, R, MS Excel, MS Visio, MS Office, Google Analytics, Google adwords, Tableau, Omniture

Work Experience

Sr. Media Investment Analyst at Elsy Media INC. Nov 2018 - Present

Responsible to help ensure client and company success, measuring digital campaign performance, developing deep insights to drive performance, and designing sophisticated testing plans.

Query and analyze large data set from social media, e-commerce platforms and raw data provided by the clients using MySQL and Tableau

Develop new metrics, analytical categories and scoring systems to evaluate brand digital health and marketing performance

Design reporting structure and illustrate data into visualized stories using Excel and business intelligence tools (Tableau)

Extract actionable insights to make strategic recommendations on digital content optimization and local marketing strategy (increase client brand followers by 40% and campaign engagement by 300%)

Work cross-functionally with the off-shore teams in different countries to conduct analysis for the client data and submit the deliverables to exceed the client expectations

Develop business plans, media campaign plans, project management plans, and retail and web analytics reports and presentations

Market Data Analyst at Integra Technologies LLC. (DE) Feb 2018 – Oct 2018

Responsible to Conduct Consumer insights and Market data analysis for a client according to their requirements

Employ qualitative marketing research techniques to help client understand their customers more fully and make well-informed business decisions

Operate closely with cross-functional stakeholders to create Work Breakdown Structure, establish Quality Assurance

procedures, control Project risks and costs, and manage Project Scope

Perform data reconciliation using Excel and SQL and use this data for predicting and forecasting future sales

Identify, analyze, and interpret market trends or patterns in complex data sets according to the functional and requirements of the client

Recommend various pricing, branding and distribution strategies by analyzing the end user preference

Create Financial Models using Excel to help analyze the finances for potential clients

Conduct, measure, and implement the results of A/B tests for ad copy and targeting

Business Operations Manager at Hudsonedge LLC. (NJ) Feb 2017- Feb 2018

Responsible to work with the CEO to manage the documents and other activities in the whole day.

Accountable for building high level and detailed project plans, driving project schedules, organizing

review meetings, communicating effectively with all stakeholders

Developed marketing strategies to increase the number of clients

Determined extent of project, construction process, financing and budgeting, as well as construction processes and schedules using Excel

Energy Marketing Analyst at Arkados Inc. ( NJ ) Feb 2016 – Dec 2016

Responsible for collecting market data and evaluating information from diverse market sources. Analysing qualitative & quantitative information to support and review new and existing marketing and sales strategies and maintaining the database of secondary information.

Created Reports of the Market Research and Submitted it to the Higher Authorities

Performed extensive data analysis to identify data anomalies and gaps using complex SQL queries.

Detected, monitored, and forecast trend forces utilizing data sets from multiple sources (both traditional and digital specific) in Tableau and Excel

Performed traffic analysis in Google Analytics related to paid digital traffic and other sources / mediums.

Marketing Analyst at Green Labs LLC. (NJ) Nov 2015 – Feb 2016

Conducted the market research from the various sources and analyze it which would help the company to stay ahead in the competitive market

Developed and executed marketing programs as per company's objectives

Developed Google Analytics Reporting and Analysis for Social Media Sites, Keyword research and expansions (Google Insights, Google Ad Words, Word Tracker)

Monitored SEO trends and stayed up to date with latest SEO technologies

Education

New Jersey Institute of Technology: Master’s in Industrial/Engineering Management (3.75/4) Aug 2015 - Dec 2016

Key Courses: Management Accounting Data mining for Managers Global Marketing Management Cost estimation Project Control Project Management Information Systems and Principles.

Certification

PMP – Project Management Professional

Contact this candidate