Social Media Data Analyst

Rounak Rajendra Burad

469-***-**** ********@*****.***

www.linkedin.com/in/rounakburad

A highly organized and detail-oriented analyst with 2+ years of experience as a Business/Data Analyst skilled at collecting, interpreting and presenting data in a fast-paced environment. I am an accurate, assertive and adaptable professional who can effectively multi-task in challenging situations and meet critical deadlines.

Work Experience:

Data Analyst Dec 2019 - Present

CodersData LLC, Cheyenne, Wyoming

Built dashboards using Tableau to allow stakeholders to easily access data and monitor KPIs.

Built, reviewed and modified data reports using conditional formatting, Pivot tables etc. in MS Excel.

Extracted and combined data from disparate data sources using SQL queries (JOINs, Order By, Windows functions).

Supported Data Analysis operations using Python (pandas, NumPy, matplotlib, sklearn, seaborn).

Effectively coordinated with other departments to proactively identify and resolve problems.

Analytics Intern Aug 2019 – Dec 2019

Boto3 Inc., Atlanta, Georgia

Combined data from multiple tables using SQL queries (JOINs, stored procedures) and updated successful queries on GitHub platform.

Cleaned data in Excel and used functionalities like conditional formatting, pivot tables etc. and presented the data using graphs

Using Excel as data source created dashboards and stories in Tableau.

Created UML diagrams and BRDs to gather and explain the business requirements. Used JIRA for agile project management activities.

Business Analyst Sept 2018 – April 2019

Unibees Inc., Dallas, Texas

Analyzed customer data for Unibees Inc. using SQL and MS-Excel and provided useful insights from it.

Created visualizations using Tableau to present responses from customers using charts, graphs, and stories.

Planned and executed all digital marketing, SEO/SEM, email marketing, social media and display advertising campaigns leading to increase in the number of users by 30%. Maintained the social media presence of the company.

Measured and Reported KPIs for the organization. Identified new marketing trends and provided actionable insights.

Tracked the progress made on the leads generated and the progress made with each lead and actions to undertake regarding those individual leads using Salesforce. Project and Task progress was tracked using Asana.

Supported the testing activities and provided feedback as well as new ideas leading to big changes in the app.

Skills:

Languages: SQL, HTML, Python (NumPy, Pandas, Matplotlib, sklearn, seaborn)

Analysis and Presentation Tools: MS-Excel (VLOOKUP, Pivot tables, Conditional Formatting), MS-PowerPoint, MS-Word, Google Analytics and AdWords, Facebook Ads manager, Tableau, SAS Enterprise Miner, Salesforce, Talend

Project Management Tools: MS Project, Microsoft Visio, Asana, Slack, Jira

Academic Projects:

Transportation delay in commercial airline industry.

Analyzed flight delay data acquired from an online source using SAS Enterprise Miner to determine the co-relation between various factors like arrival time, departure time, duration, day, week, etc. and flight delay and provide report on reasons for flight delays.

Online advertisement campaign for Mitul Gada and Associates.

Ran an advertisement campaign for Mitul Gada and Associates using Google AdWords and Facebook Ads manager to promote the institute using creative keywords, attractive ads and various ad extensions.

The Google and Facebook ads campaign together had around 190k impressions over a period of 4 weeks leading to 1400+ clicks. On the Google ads campaign, we achieved a CTR of 2.6%.

Used Google Analytics to keep track of the website performance and analyzed various things like demographics of the visitors, bounce rate, source of the visitor i.e., organic, email etc. to improve the performance.

Airline delay and its connection to tweets.

Analyzed flight delay dataset using Excel and Tableau to visualize the patterns in the flight delays and to determine using Tableau the reasons behind tweets by customer of various airline carriers and see if they were due to the delay.

Data was analyzed based on Day of week, day of month, month of year, airline company, origin state, destination state, flight distance etc. to understand the delay pattern and correlate it with customer tweets to see if delay was the reason for their tweets.

E-Scribe: Healthcare record management system.

Simulated an EHR project from initiation to delivery. Used SDLC steps for the project such as creating project charter, requirements gathering, creating UML diagrams, testing etc.

Education:

The University of Texas at Dallas May 2019

M.S. in Information Technology Management GPA : 3.60

University of Pune May 2016

B.E. in Computer Engineering GPA: 3.24

Contact this candidate