Data Analyst
Resume:
ASTHA KATHIL
www.linkedin.com/in/astha-kathil
ac97iz@r.postjobfree.com
www.github.com/asthakathil
public.tableau.com/profile/astha.kathil
A passionate learner and data-driven problem solver looking to unlock business and policy insights. Competitive critical thinker with experience in Marketing, Operations, Human Resources, and Data Analytics who can offer sophisticated data science solutions.
EDUCATION
Stuart School of Business - Illinois Institute of Technology, Chicago, IL
May 2019
Master of Science in Marketing Analytics
Coursework: Quantitative Models for Marketing, Predictive Analytics, Social Media Marketing Analytics, Marketing Research & Engineering, Business Analytics, Analytics for Decision Making, Fundamentals of Database Management Systems
Level Education - Northeastern University, Boston, MA
August 2018
Data Analytics Bootcamp
Coursework: R, Databases & SQL, Machine Learning, Statistics and Probability, Data Visualization, Tableau, Excel
College of Science and Engineering, India
June 2011
Master of Business Administration, Major: Human Resource Minor: Finance
Bundelkhand University, India
June 2009
Bachelor of Business Administration, General
SKILLS & COMPETENCIES
Data Science: Data Analysis, Linear Regression, Logistic (Conditional and Mixed) Regression, Random Forest, Data Mining, Text Analytics, Data Visualization, Statistical Analysis, Social Media Analytics, Clustering (K-Means), Neural Network, A/B Testing, Decision Trees (Bagging and Boosting), Recommender Systems, Time Series Analysis.
Programming Language & Tools: R, RStudio, SAS, SQL, Tableau, SPSS, Microsoft Office (Excel, PowerPoint, Word)
PROJECTS
Customer satisfaction sentiment analysis December 2018
Conducted contextual mining to analyze customer satisfaction levels for CHASE and BOA.
Utilized SPSS and Lexalytics for text mining and performing of sentiment analysis.
Employee satisfaction analysis December 2018
Conducted sentiment analysis and developed decision tree to show the probability of employee retention.
Utilized SPSS and TABLEAU toolsets for analysis.
Proposed solutions to reduce the attrition rate and saved direct and indirect costs in hiring new candidates.
Term deposit subscription prediction December 2018
Used k-means, Neural network and decision tree to forecast who are the most potential customers to subscribe to the term deposit for the bank.
Used SPSS, R, and TABLEAU for data mining and keep track of the data.
Factors influence the demand of vodka October 2018
Applied regression analysis to study the relationship between vodka price and modes of advertising.
Investigated the relationship between vodka prices and independent variable modes of advertising.
Pinpointed and recommended ideas for the vodka brand, which was less preferred by the customers.
Factors Influence in Choosing the Dannon Yogurt October 2018
Operated SAS software in order to scrutinize data and substantiate what factors influence customers to buy different flavors of Dannon yogurt.
Managed statistical techniques for hypothesis testing and Logit models to study the choice decisions of consumers.
Advised the company regarding solutions to increase brand image and sales of non-selling Dannon product.
Identified How to Close the Skill Gap of New York August 2018
Utilized SQL and TABLEAU software to follow and explore the data.
Constructed dashboards by applying metrics and presented data and conclusions to the team in order to enhance strategies.
Proposed solutions to fulfill the skill gap for a different occupation.
PROFESSIONAL EXPERIENCE
CoLab Software, Boston, MA June 2018 - August 2018
PROJECT – Customer Usage Metrics Dashboard Development
Demonstrated expertise in the utilization of SQL and R to track, analyze, and interpret data.
Originated, developed, and implemented a dashboard, employing Tableau software, which was user friendly and provided the company with real-time analytics regarding customer usage.
Through dashboard establishment, the company was able to make enhanced technical, sales, and marketing decisions by providing access and visualization to a critical set of user information.
Axis Securities LTD, India April 2014 - March 2015
OPERATION EXECUTIVE
Conceptualized, designed, and actualized innovative pivot tables, utilizing advanced Microsoft Excel tools, including VLOOKUP and HLOOKUP functions.
Conducted people analytics by manipulating datasets to assist stakeholders, such as Human Resources, business heads, and others, to acquire insights regarding performance evaluations, hiring and promotion, employee compensation, and recruiting.
Applied Microsoft Excel to create, prepare, and distribute MIS on operations activities on a periodical basis
Formulated and generated various business reports, targeting goals, and overall achievements for the region.
Initiated incentive plans for employees, which generated sales data, and disseminated the data to business heads and payroll departments.
Hired, trained, and mentored a winning staff which developed high profile campaigns and relationships, exceeding all corporate quotas.
Ing Vysya Bank, India June 2011 - January 2012
BUSINESS DEVELOPMENT EXECUTIVE
Garnered deep knowledge and understanding of the corporate segment as well as available bank products within the geographic territory.
Researched, identified, and initiated contact with key clients to promote and sell the entire range of products.
Designed and launched a client visitation plan to maximize face-to-face client sales time and boost client retention, renewal, and account extension.
Directed and oversaw corporate banking accounts as well as account openings for new and existing customers, including processing all required documentation.
Monitored and maintained all pertinent records, handled customer rejections, and scheduled appointments with clients and partners.
Conducted client presentations and finalized client contracts with all costs and margins.
Cultivated customer relationships to accomplish repeat and referral contracts.
VOLUNTEERISM
5th Annual Remarkable Women’s Conference, Chicago, IL September 2017
Assisted with general administration activities, signing in guests, distributing event brochures, and selling cookies.
ADDITIONAL INFORMATION
Language: English, Hindi
Contact this candidate