Data Analyst Social Media

Phoenix, Arizona ****************@*****.*** +1-602-***-**** LinkedIn GitHub

SUMMARY

Data Analyst with 5 years of relevant experience solving business problems. Worked on projects for 18 Fortune 500 companies, mentored 14 analysts, generated revenue of $800k and earned 5 awards. Eager to leverage my business intelligence skills and consulting acumen to enrich your business through inquisitive analytics, and by solving complex problems EDUCATION

• Master of Science Data Science Aug 2018–May 2020 Indiana University, USA

Officer at DS Club- Maximized the employment opportunities for 400 students by hosting networking sessions with industry stalwarts

• Bachelor of Technology Electronics Engineering Jul 2009–Jun 2013 Bharati Vidyapeeth University, India

Received Best All Rounder of the Batch award and served as Joint Secretary for 2,800 students TECHNICAL SKILLS

• Prog & Querying Languages – Python, R, SQL

• Databases – MySQL, SQL Server, Oracle. Extraction Transformation Loading (ETL), Data Warehousing

• Visualization & Reporting – Advanced Excel (Macros and using VBA lookups), Tableau, Matplotlib, Seaborn, Plotly, ggplot2

• Machine Learning – EDA, A/B Testing, Linear Regression, Logistics Regression, Support Vector Machine (SVM), Random Forest, Gradient Boosting, PCA, K-Means Clustering, Collaborative Filtering, KNN, Neural Networks

• Libraries & Tools – NumPy, Pandas, SciKit-Learn, NLTK, CRM tool(Salesforce), Microsoft Office WORK EXPERIENCE

Data Scientist – MoreMD (Heathcare Company), USA Sep 2019–Dec 2019

• Curtailed the operating costs by $150K by exploring the root cause of low payment-to-charges ratio across the insurances, CPT codes, providers and locations using raw data of 3 years and interactive excel dashboard: revenue was outpaced by 2% Data Analyst Intern – Unislink (Medical Billing Company), USA Jun 2019–Aug 2019

• Investigated the reasons why lucrative medical claims of top 3 clients, who contributed 42% share, got rejected by insurance companies

• Tracked the top procedural codes, providers, insurance plans responsible for it, using excel dashboard: revenue was augmented by 5% Decision Scientist & Regional Leader – Mu Sigma (Data Analytics Company), India Sep 2013–Oct 2017

• Solved 3 business problems, delivered insights & recommendations for marketing campaign analysis, supply chain compliance and sales funnel web analytics, etc. by using SQL, R, Tableau, VBA, excel dashboards. Cultivated a team of 6 analysts & raised a revenue of $300K

• Expanded account strength by scoping of new projects, converting 2 prototype projects into billed engagements by translating business requirements from 15 C-level executives to data teams and collaborating with analytics teams, and produced revenue of $500k

• Achieved cross functional and industry exposure through my management consulting and sales operations with a global footprint across my clientele across retail, entertainment, technology, telecom & domain functions like pricing, marketing, supply chain etc.

• Earned 4 awards for impeccable deliverables on tight deadlines, thought leadership & accountability for content creation

• Key Problems Solved:-

– Campaign Analysis: Optimized digital campaign by joining products, demographics & sales data, measuring the customers’ response towards previous campaigns on website & social media using automated VBA dashboard, which saved 8% funds & time by 11 hours

– Supply Chain Compliance: Grew sales by merging salesforce & transactional data, analyzing sales funnel, spotting stages where large orders took unjustified processing time & officials responsible for it using SQL, R and amplifying the supply chain compliance by 25%

– Reduced Attrition: Minimized the churn of business buyers who contributed 7% items, by crafting an attrition model, using their buying & selling patterns across countries, product categories, transaction amount & frequency, which saved revenue leak by 15% ACADEMIC PROJECTS Aug 2018–Present

• Recommendation System: Devised an automated food recommendation system, which provides food recipes of various cuisines based on ingredients available, nutrients wanted & user allergies, by using knowledge graph & cypher in neo4j, which benefited food industry

• Optimize Cash Flow: Forecasted if a new customer will pay the bill on time, when exactly will pay & what amount will pay by first joining transaction, account & contract data, then using random forest, decision tree & linear regression models, predicted accurate cash flow

• Election Polls: Identified the drivers of the support that a Gubernatorial candidate gets from his voters, by using survey data & statistical modeling: which empowers the candidate to resolve issues, & channelize his efforts towards positive drivers, to boost up his vote bank Surya Prateek Soni

Contact this candidate