Ekta Ratanpara

**** * *** **, *** Jose, CA 408-***-**** ac270u@r.postjobfree.com

EDUCATION

Master of Science in Information Systems (MSIS) - GPA: 3.62/4.00 Expected Graduation June 2018 Santa Clara University, Leavey School of Business Santa Clara, CA Coursework: Data Science with Python, Dashboards, Scorecards, and Visualization, Business Intelligence and Data Warehousing, Database Management Systems, Information Systems Analysis and Design, Object-Oriented Analysis and Programming Projects:

• Twitter Sentiment Analysis – Data Science Analysis with Python: Retrieved tweets using Twitter API for a trending topic and performed sentiment analysis of tweets to classify it into strong/weak positive, strong/weak negative and neutral categories. Used NLP toolkits/packages like NLTK and SciKit Learn in Python.

• Effect of Weather on Flight Delay and Stock Price – Business Intelligence and Data Warehousing: Created ER and Dimensional model databases in MYSQL. Preprocessed 2+million entries using Excel. Used Alteryx to perform ETL from multiple different sources for climate data and flight data. Performed analytics on relationship between weather conditions and flight delay by creating Tableau dashboards.

• Living Abroad: Choose the country best for you: Collected relevant data from multiple data source. Used python pandas for data cleaning, transformation and normalization. Using customizable charts, created a story in Tableau showing relative standing of the countries and show the best country that fits your need by controlling factors like income, health, safety etc. Tableau public link: https://public.tableau.com/profile/publish/DataViz_Ekta/Story Bachelor of Engineering in Electronics & Communication Engineering - GPA: 3.67/4.00 July 2007 – June 2011 Gujarat University Ahmedabad, India

TECHNICAL SKILLS

Programming Languages: Python (numpy, pandas, seaborn, scikit-learn), SQL, PL/SQL, Java Database: Oracle 10g, 11g and 12c, MySQL, SQL Server Tools & Platforms: Tableau, Alteryx, Toad, PL SQL Developer, MS Excel, Google Analytics, Oracle BI, Lithium, SVN, Tidal, Data Flux Functional Skills: Data Visualization, Data Modelling & Warehousing, Project Management, Requirement Gathering and Analysis EXPERIENCE

Data Analyst Intern, Juniper Networks June 2017 – Sep 2017

• As a part of online customer support team, created dashboards using Tableau to track and monitor the ongoing activities and provided data driven insights to improve the current processes.

• Gathered and blended data from multiple source systems, transform the data using SQL and Excel pivot tables to provide relevant metrics, reporting and analysis based on historic data.

• Worked on support analytics to provide insights in various business areas like case volumes, article popularity, user activities on forum, articles workflow, case deflection and money saving. Assistant Database Analyst, Institutional Research, Santa Clara University Mar 2017 – June 2017

• Created dashboards in Tableau to enable visual and analytical insights that support the institution's strategic, operational planning and decision-making.

• Complied, cleansed and reconciled data conflicts to showcase institutional trends and patterns. Business Analyst, Tata Consultancy Services – Client: Pfizer Inc. Jan 2015 – July 2016

• Performed data migration parity testing. Developed and executed test scripts in SQL to verify if the migration is done correctly.

• Collaborated with stakeholders and program managers to define & manage scope and project timeline. PL/SQL Developer, Tata Consultancy Service – Client: Cisco Systems, Inc. Jan 2012 – Dec 2015

• Designed and developed an application using PL/SQL and Unix shell scripts that generate variety of reports based on real- time array filters. The application was used by many cross functional teams and saved 30% human efforts to generate reports.

• Implemented Complex User Access Management to provide access to user at different geo hierarchies. The tabs seen by the user in the UI and data/column visibility in the reports would vary based on the user access level.

• Demonstrated proficiency in all aspects of data analysis and database programming in SQL and procedural SQL related technologies that encapsulate SQL, including Cursors, Ref-cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Table Indexing