SNEHAL AGRAWAL

*** ******* *****, **********, **, 45220

adjlzk@r.postjobfree.com • https://www.linkedin.com/in/snehal-agrawal • 513-***-****

EDUCATION

University of Cincinnati, Carl H. Lindner College of Business (GPA: 3.92/4.0) Cincinnati, USA

Master of Science in Information Systems with Data Analytics certification Expected: Apr 2021

Bundelkhand Institute of Engineering and Technology Jhansi, India

Bachelor of Technology in Computer Science Aug 2012 - June 2016

SKILLS, CERTIFICATES, AND BADGES

Programming Language: R, Python, Julia, SAS, C/C++, JavaScript, Java

Database: PL/SQL, SQL Developer, Oracle, MS Access

Analytical Tools: Tableau, Power BI, MS Excel (PivotTables, VLOOKUP, charts), Jupyter Notebooks

Web Technologies: HTML, CSS, Bootstrap, JSON, XML, ASP.net using C#

Others: Data Analysis, JIRA, ServiceNow, ETL, Visual Studio, GitHub, Algorithms, Data Structures, Agile, AWS, Data Evaluation, Data Mining, Data Modeling, Google Analytics, Statistics, Verbal Communication skills, Math

Badges: Silver Badge in SQL in Hackerrank, Gold Badge in Problem Solving and Python, Tableau Analyst

Certificates: Intro to SQL for Data Science and Joining Data in SQL in Datacamp

PROFESSIONAL EXPERIENCE

Divisions Maintenance Group Newport, KY

Financial Analyst Intern Nov 2020 – Present

Built dashboards to communicate key findings to various stakeholders to facilitate data driven decision-making

Migrated Sales report from Excel to Power BI with additional user interface features and designs to make data visually appealing and easy to navigate and read across organization

Worked closely with multiple teams (Finance, Marketing, IT, and senior executives) to identify key metrics and business tool to analyze equipment data using Excel, DAX, and Power BI to increase profitability and better judgment

IQVIA Bangalore, India

Data Analyst June 2016 - May 2019

Analyzed CRM data sets using SQL and advanced Excel (PivotTable) to produce a new customer system; system led to resolution of 700+ customer issues and reduced customer calls by 30%

Collected and cleaned raw data provided by clients into quantitative data in R and analyzed to identify problems and proposed solutions

Synthesized current business intelligence data to produce reports, dashboards and polished presentations in Tableau and PowerPoint, highlighting findings and recommending changes to clients

Led a 5-member cross-functional (project managers, leads, and engineer) teams to analyze customer support data using data mining techniques and draw meaningful conclusions that lead to 90% issue reduction

Automated daily/weekly/monthly reporting systems with SQL queries to assure all issues are rightly captured and decreased risk of mission area to less than 1%

Trained employees on SQL, advanced Excel, R, and Tableau to influence improved data management, monitoring effectiveness, quality analyses, and suggesting large-scale improvements

Performed trend analysis, identified root cause, and planned strategies for reduction of issue-capturing mechanism, leading to increased efficiency of mechanism by 90% single-handedly

ACADEMIC PROJECTS

Process Mining using bupaR package for healthcare process in R

Developed Process Model using event log data for hidden information retrieval to improve on healthcare processes

Hotel Demand Analysis and Data Wrangling in R

Consumed large data sets to understand, clean, visualize, and forecast hotel demand trend analysis and future prediction

Telecom Churn Prediction analysis in R

Built models to predict telecom churn using data understanding and exploration, data cleaning and data manipulation, visualizations, outliers, logistic regression, model adequacy and validation, variable selection, and neural network

LEADERSHIP

Founded and Headed Event Organizing Committee for a team of 40 June 2017-April 2019

Sports Captain for Table Tennis and Chess August 2014-June 2016

Contact this candidate