data analyst

YASHASWINI KRISHNA NAIK •860-***-**** • **********.************@*****.*** • LinkedIn

4+ years of experience in providing business solutions through data analytics, statistical analysis, dashboards and reporting for fortune 500 companies belonging to ERP-SAP, Retail, CPG, Supply Chain and Marketing domains

Excellent hands-on experience in SQL, Tableau, R and Advanced Excel

EDUCATION

MS in Business Analytics and Project Management, University of Connecticut, Hartford, CT July 2017

Bachelor of Engineering in Information Science, VTU, Bangalore, India 2008-2012

TECHNICAL SKILLS

Tools: R Studio, Tableau, Oracle SQL, MySQL, Advanced MS Excel(VLookup, Pivot Table), SAS JMP Pro, SAS Enterprise Miner, MS Office Suite, MS Visio, Access, IBM SPSS Modeler, Hadoop, Business Objects, BEx analyzer, ERP SAP R/3

Statistical and Technical Skills: Hypothesis Testing, Data Cleaning, Data Management, Time Series Forecasting, Linear/Logistic Regression, Principle Component Analysis, Spreadsheet Modeling, Monte Carlo Simulation, Clustering, Decision Tree Analysis, Text Analytics, Market Basket Analysis, Market Segmentation, Association Rules, A/B Testing, Digital Marketing Analytics, Visual Analytics, Data Mining, Business Intelligence

Programming languages: R, SQL, SAS Base, Python, VBA, C, C++

Certification: Data Visualization with Tableau, Google Analytics, Data Warehousing for BI (Coursera)

PROFESSIONAL EXPERIENCE

Data Analyst - Basement Systems, Seymour, CT, USA March 2017 – June 2017

Marketing & Sales Analytics R, Tableau, Advanced Excel- Analyzed client’s historical data to identify leads with higher propensity to convert. Identified appropriate marketing channels to invest in order to improve sales

Procured and analyzed external data to identify demographic & geographic factors influencing sales

Business Analyst - Cognizant Technology Solutions, India August 2012 – July 2016

Provided analytical support involving data cleaning, data manipulation, exploratory analysis to generate actionable insights

Extensive experience in ETL and writing SQL queries for data extraction, analysis and validation

Acted as liaison between functional team and client. Presented business process walkthroughs, functional specifications documentation and status updates to stakeholders to ensure sound knowledge of client objectives and customer insights

Ad-hoc Reporting Retail and CPG- Trained and mentored peers in creating KPIs driven Tableau Dashboards and insightful reports by analyzing large datasets to effectively communicate analytical results and support decision making

Text Analytics Marketing- Enhanced ability of client to create ad messages that resonate with target segments based on personality traits of customers to achieve high levels of marketing effectiveness

Customer Segmentation Retail- Clustered (K-Means) Walmart’s customer base into actionable groups based on historical buying patterns in apparels. Resultant clusters were profiled across customer demographics, forming customer personas and formulated targeting strategies for each of the clusters accordingly

Process Optimization Supply Chain- Automated 70% of manual supply chain process reports, saving company the cost of 1.5 resources in turn reducing cost and overall turnaround time by 40%

DATA ANALYTICS PROJECTS

Business Process Modeling Customer Service SQL, MS Visio: Performed gap analysis and designed AS-IS and TO-BE data models. Implemented database and designed business use cases through SQL queries to optimize business process

Yelp Customer Review Analysis Big Data Analytics SPSS, Tableau, R : Performed Text Analytics and built a predictive model that predicts star ratings of restaurants leveraging most recent semantic content of customer reviews

Inventory Management Sales Analytics R Studio, R Shiny : Performed ABC analysis for Selective Inventory Control, built predictive model using Random Forest Technique and created Shiny UI application for Inventory Management

Real Estate Sales Clustering SAS Enterprise Miner, Tableau : Built Time Series Forecasting Model for real estate sales price across regions clustered into counties in the state of CT using ARMA, ARIMA and Seasonal techniques

Contact this candidate