Mukundan Sankar

adhbe4@r.postjobfree.com, 209-***-****, https://www.linkedin.com/in/mukundansankar/, https://medium.com/@mukundan.sankar14, San Jose, CA

OBJECTIVE

An experienced analyst with strong experience working cross-functionally building analytical solutions with expertise in

Data analysis, modeling, and data visualization, seeking an exciting Senior Data Analyst opportunity to help advance the business.

EDUCATION

Master of Science in Analytics

Harrisburg University of Science and Technology, Harrisburg, PA / July 2019 - Present

Courses: Statistical & Analytical Methods, Principles of Analytics, Machine Learning, Data Visualization with Tableau

Master of Science in Information Systems (MSIS)

Santa Clara University, Leavey School of Business, Santa Clara, CA / September 2014 - June 2016

Bachelor of Engineering in Electronics and Telecommunication

University of Mumbai, Mumbai, India / September 2009 - May 2013

PROFESSIONAL EXPERIENCE

Data Analyst

Apple Inc, San Jose, CA (Remote Contract)/ Sep 2020 – Oct 2020

Developed Python script to extract incoming utterances data from Splunk and merge with existing GitHub repo data.

Designed Tableau dashboard to help fix intents for chatbot for the Business Chat team.

Data Analyst/Scientist

StratApps Inc, Fremont, CA / May 2018 – Feb 2020

Retrieved most profitable customers, products using ad-hoc and scheduled dashboards in Tableau to help increase marketing efforts to see a 10% rise in number of customers in US North-East region.

Developed a SQL Data warehouse to get data from multiple sources using ETL by Postgres SQL and Python package.

Gathered requirements from all internal and external stakeholders including Finance, Marketing and Product team to align with their views on how the end SQL data warehouse solution should be.

Designed technical documentation (data pipelines, data flows, mapping and data dictionary, mock-UIs) for technical team.

Tracked email marketing metrics using HubSpot data in SQL DW like CTR, email forwarding rate, email frequency, conversion rate and bounce rate using Tableau and communicated insights to marketing team which helped reduce bounce rate by 15% .

Queried SQL data warehouse for pet symptoms which helped reduce customer manual form entry time by 10s per customer.

Data Analyst

PeoplePlus Software Inc, Ann Arbor, MI / August 2017 - May 2018

Tracked and analyzed inventory management KPI performance using SQL and Tableau and built an inventory forecasting model which helped improve sales by 10% month/month

Used HiveQL to query large dataset of about 5 million records containing Supply Chain and e-commerce data to help manage the inventory, labor, equipment and generate ad-hoc reports to solve customer issues.

Used Tableau and HiveQL to generate reports for business users to help examine their net profit margins, sales among other KPIs.

Data Analyst

Abilities United, Palo Alto, CA / October 2016- July 2017

Analyzed marketing & advertising metrics for digital content (website, social media, email) using Google Analytics, and Twitter Analytics with Python and recommended insights to increase customer engagement with website by 8% Qtr./Qtr.

Developed ad-hoc and automated dashboards for offline marketing channels on Excel data with Tableau.

Used A/B Testing to evaluate email marketing content and help improve engagement with email by 10%.

ACADEMIC/PERSONAL PROJECTS:

Chatbot (April 2020- May 2020): Built an NLP Chatbot using Python using Python Dash, NLTK/NLP that gives a company’s stock info, to assist in stock purchase, performs sentiment analysis for text from a document/text/HTML URL with 91% precision. Check here

Credit Defaulter Prediction (June 2020-July 2020): Used neural network with PyTorch on a Finance data to predict if someone would default on their credit loans using past payment history, demographics, and credit balance. check here

TECHNICAL SKILLS

Python(NumPy, Pandas, Sci-kit learn, SciPy, NLTK, statsmodels), SQL, Excel (Pivot Tables, advanced formulas), Tableau, Looker, Google Analytics, Airflow, MS Visio, AWS Redshift, GCP BigQuery, HiveQL, Digital Marketing, SAS, Postgres, PowerBI

Contact this candidate