Deepak Kumar Sharma Email & Phone Number

Pune, Maharashtra, India

Pune Area, India

Pune Area, India

-Worked on several data centric projects including Tableau dashboards, Social Mediaand Web Analysis.- Developing and Maintaining highly interactive Tableau dashboards for visualizingvarious Risk Metrics (Market Risk, Credit Risk, Business Risk) reports for a globalbank- Created and maintained SQL scripts to perform data aggregation to support Tableauvisualisations.- Implementing workarounds in Tableau like Dynamic axis start point for Charts,Commentary for charts, Dynamic order of the axis items, Distinguish nature of thecharts or visualisations etc.- Published and shared dashboards using Tableau Server, allowing business users toplay with the data visualisations on the fly and use them in the final reporting.- Data collection, transformation and manipulation with Python libraries(Pandas,Numpy, Scipy, BeautifulSoup, Sklearn, Statsmodel)- Responsible for collecting and analysing large volume social media data, providingactionable social listening insights for shaping the overall digital marketing plan forclient’s products and portfolio- Reporting of Key Insights including Share of voice against competitors, conversationdrivers, trending topics and hashtags, conversation clusters, key Influencers- Automated text classification task using NLP and Machine Learning techniques inPython and saving more than 70% manual effort in reporting- Measuring and reporting website performance against KPIs with tools Omniture SiteCatalyst- Campaign performance analysis on Website through Omniture Site Catalyst

Bangalore

Key Duties:• Creating high quality reports and driving insights on gathered data from Social Media tools.• Keyword Optimization to track the most relevant data.• Sentiments Tuning by categorizing the Social Media Conversations.• Campaign performance and Hashtag Analysis.• Recommendation of strategies and improvements to win on Social Media.• Identifying the areas of concerns out of Negative Social Media Conversations. • End to end interactions with client to know the expectations more deeply.• Data Analysis to analyse the results achieved out of strategies & prepare preventive & follow up action Plan.• Analysis of the customers Social Media Profiles and helping digital marketing team to design campaigns based on analysis outcomes.• Finding key influencers out of the dataset.• Optimization of Social Media Data.Key Achievements:• Developed an Excel dashboard to explain the overview matrices pertaining to Social Media Data coming directly from the Monitoring tool.• Penned a white paper to explain how police can use social media effectively during crises.• Devised a Safety Index Matrix for Mobile Cabs Industry that reflects the public opinion for safety in various cab providers.• Devised Brand Affinity Matrix that shows how a Brand shares a Social Media Mention with its competitors and vice versa. ‘• Helped Clients to design Campaigns by Analysing the Social Media Profiles of its customers.

Bangalore

Key Duties:• Creating high quality reports and driving insights on gathered data from Social Media tools.• Developing custom Social Media tools to meet client requirements using Facebook and Twitter API.• Creating high customer engagement strategies and Twitter campaigns.• Evaluation of new social media tools.• Monitoring and studying trends in Social Media tools and applications.• Sentiments Tuning by categorizing the Social Media Conversations.• End to end interactions with client to know the expectations more deeply.• Data Analysis to analyse the results achieved out of strategies & prepare preventive & follow up action Plan.• Keeping an eye on terms and conditions applying on Social Media data usage.• Finding key influencers out of the dataset

Punjab

Bengaluru

Responsible for development of Windows Form Applications in C#.NET and reporting to concerned manager for accomplishment of a module and removing the issues obtained as a result of testing.