ABHISHEK G KARKAMKAR
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
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
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
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.
PMP – Project Management Professional