Data Analyst Assistant

URVASHI RAWAT

*******@********.*** *** East White Street, Champaign, IL 61820 217-***-****

http://linkedin.com/in/urvashi-rawat

EDUCATION

University of Illinois at Urbana Champaign, Illinois Expected Graduation date: Master of Science Information Management May 2021

GPA : 3.78/4.0

Rajasthan Technical University, India August 2012 – June 2016 Bachelor of Technology in Computer Science GPA : 3.8/4.0 SKILLS

Analytics and Visualization: Python, R,SQL, Tableau 10,Power BI, EDDIE, Microsoft Excel Development Tools: Anaconda, PyCharm, RStudio, Jupyter Notebook, Oracle Data Modeler, Talend Open Studio (ETL development)

RELEVANT PROJECTS

• Hurricane Analysis - Using ‘pyGeodesy’ package to perform various computations about storm like direction of storm, landfills,distance travelled and maximum speed using Latlon and Intersection classes to make analyses on the different categories of storms

• High Tech Sculptures – Carving a marble block to find the best shape that fits inside the marble block when Analyzed among the various possibilities generated by rotating block across 3D axes. Using ‘numpy’ and ‘pandas’ library to compute mean density, centre of mass and stability of shape across specific access

• Happiness Rank – Generating reports using power BI tool to visualize and determine the dependency of happiness rank on various factors like gender, age, loneliness and city

• Corporate Pool System – Designing data mart using Lucid chart for a carpool system across several regions of USA EXPERIENCE

School of Information Sciences, UIUC, Champaign, Illinois September 2019 – Present Graduate Research Assistant

• Visualizing data for convenient care department using Python’s Matplot and Seaborn library to understand current trends in data

• Using statistical techniques for hypothesis testing to validate health care data of patients who had cardiac arrests for emergency departments

• Analyzing patient appointments, diagnosis and weekly visits data using Tableau Illinois Business Consulting Group, UIUC, Champaign, Illinois September 2019 – Present Business Consultant

• Designed a business model on excel sheet which computes revenue loss based on various factors affecting sale of products

• Creating Power BI reports on statistics of crop yield decline, bee population decline and equipment purchase decline

• Recommended business strategies and decisions which reduced revenue loss by 33% Infosys Limited, Pune, India November 2016-May 2019 Data Analyst

• Accomplished major strategic goal and client commitment through development and implementation of a new python module with added functionalities like digital signature, ID verification and appropriate approvals, which increased application efficiency by 29%

• Proposed an idea senior practioners for a strategical support portal with high priority ticketing system to improve ticket handling by 40%

• Delivered an interactive dashboard displaying information about customers and number of monthly appointments in tableau for client presentations

• Conducted data modeling practices to analyze data from previous informational findings and provide suggestions for strategic and operational improvement

• Communicated data-driven insights and recommendations to clients by understanding current trends

Contact this candidate