Data Analyst Social Media

Adhish Tripathi

San Francisco, CA

******.********@*****.*** GITHUB +1-628-***-**** LINKEDIN

PROFESSIONAL SUMMARY

Passionate Data Analyst with proficiency in cross functional collaboration, data optimization, and data visualization

Experience in business strategy, project management and working with stakeholders, executing projects within timelines

Deploy dashboards and generate insights to improve operations efficiency by modelling data using statistical techniques

Executed projects using Agile methodology, participated in sprint planning, daily scrums and sprint reviews

Proven communicator and team player, with excellent analytical and problem-solving skills

Work Authorization: OPT EAD INITIAL (till May 11,2020), Sponsorship required currently (STEM OPT) in the future (H1B)

Total experience till date: 3+ years

EDUCATION

Master’s in Business Analytics, Hult International Business School, San Francisco 2018- 2019

Master’s in International Business, Hult International Business School, San Francisco 2017- 2018

Bachelor of Engineering, Rajiv Gandhi Technical University, Bhopal, India 2012 - 2016

Skills: Python, Alteryx, R, Tableau, SQL Server, Apache HIVE, Hadoop, MS-Excel, Google Analytics, Agile, Project Management

Certifications: Data Analyst with Python & MS-SQL, Alteryx Designer Core

Strengths: ETL, Data Analysis, EDA, Machine Learning (Decision trees, Clustering), Statistical Analysis, Visualization

PROFESSIONAL EXPERIENCE

Data Analyst – Hoffman La Roche, Pleasanton Sept 2019 – Current

Technology stack: Tableau, Alteryx, SQL, SAP Hana, Python, Microsoft Excel

Serve as a business partner supporting various functions, such as Finance, with RMS portfolio analysis as well as curate and administer business database repositories.

Work cross-functionally with the Global Finance team and Functions, including Project Management, to improve the quality and standards of reported data throughout automated data sources.

Analyze portfolio of products across business units through Tableau dashboards and other internal tools.

Pull data from MS SQL server into Alteryx to create predictive workflows thereby improving sales predictions by 5%.

Perform portfolio analysis, create portfolio dashboards, reports, and presentations (e.g., budget dashboards, capacity analysis, and project/portfolio reports) for technical and non-technical stakeholders.

Data Analyst – UpChoose PBC Ltd., San Francisco Apr 2019 – Sept 2019

Technology stack: Python, SQL, Microsoft Excel, Tableau

Create and modify Tableau dashboards, SQL queries and stored procedures to support the marketing department.

Analyze the impact of change in KPI’s on marketing data using Power Query, Advanced Excel and SQL.

Create analytical frameworks and partner with cross-functional teams to define success metrics and KPIs.

Carried out in-depth research to develop market penetration strategies and increased market penetration in 8 states.

Formulate data validation techniques and reduced customer lifetime value estimation error by 4%.

Analyzed a consumer panel of 5,000 subscribers, defined by A/B testing, and identified KPIs for customer acquisition, retention and loyalty.

Data Research Analyst - Startup Policy Lab, San Francisco Nov 2018 – Apr 2019

Technology stack: Python, SQL, Google BigQuery, Microsoft Excel, KNIME, Tableau

Examined the scope of deliberate attacks on the federal public comment process operations.

Act as a liaison between stakeholders and team members to convey meaningful business insights from analysis.

Collect, organize, store, and analyze public comment data of 6 years from different Web API’s (over 1 terabyte of data) using Kmeans & HDBSCAN clustering algorithms in Python.

Create anomaly detection algorithms in Python to identify potential fake comments and visualization using Tableau

Business Analysis Intern - UpChoose PBC Ltd., San Francisco May 2018 - Oct 2018

Technology stack: SQL, Python, Tableau, Advanced Excel, Microsoft office suite

Optimize SQL queries and create Tableau dashboards for data extraction to improve business efficiency by 13%.

Assist with customer outreach by using a combination of Python, MS-Excel, and social media portals such as Instagram, and created 632 new target customers that helped increase revenue by 10%.

Data Analyst - Technosatcomm Pvt. Ltd., New Delhi, India May 2016 – May 2017

Technology stack: SQL, Ms-Excel, Advanced Excel, Microsoft office suite

Facilitate project coordination efforts to provide strategic direction and operational supervision for implementation of a wi-fi zone; developed tactical plans to direct completion of projects at different sites across 6 metro stations.

Implement database management through SQL.

Supervise teams; planned and coordinated product delivery deadlines; improve feedback quality by over 30%.

Enhance communication between the engineering department and stakeholders through scenario planning sessions.

Contact this candidate