Post Job Free

Resume

Sign in

Data Analyst Assistant

Location:
Tucson, AZ
Posted:
November 23, 2020

Contact this candidate

Resume:

KAUMUDI KULKARNI

adh2yy@r.postjobfree.com 520-***-**** Tucson,AZ LinkedIn Website

SUMMARY

Result-oriented and collaborative, with proven Python, SQL, R, Tableau skills for data analysis from being a part of diverse and cross-functional team projects. Aspiring data analyst, passionate about synthesizing data into actionable insights and presenting them to technical and business stakeholders. EDUCATION

Master of Science, Management Information Systems - GPA: 3.8/4.00 Aug 2019 - Dec 2020 University of Arizona, Eller College of Management, Tucson, AZ Courses: Data Mining, Business Intelligence, Big Data Technologies, Eller Business Consulting, Statistics Bachelor of Engineering, Computer Engineering - GPA: 3.5/4.00 Aug 2015 - May 2019 University of Mumbai, India

Courses: Object-oriented programming, Data Structures and Algorithms, Database Management SKILLS

• Programming Languages: SQL, Python, R, C, HTML, CSS, JavaScript

• Data Analysis: Excel, Tableau, Oracle 11g, SQL Server, BigQuery, MySQL, PostgreSQL, RStudio, Jupyter Notebook

• Tools: IBM DataStage, GCP, PyCharm, VS Code, GitHub, PowerPoint, Visio

• Python Libraries: cx_Oracle, logging, numpy, pandas, matplotlib, pyspark PROFESSIONAL EXPERIENCE

Project Manager and Developer, Academic and Research Technologies Group: Link Jun 2020 – Aug 2020

• Designed project workflow and drove the project to successful completion by increasing team productivity by ~40%.

• Developed Python scripts to automate user management in Oracle RDBMS systems in a Linux-based environment.

• Applied ‘Don’t Repeat Yourself’ principles and performed unit testing to maximize code quality and maintainability. Graduate Research Assistant, University Analytics and Institutional Research (UAIR) Jul 2020 – present

• Working on the Delete Strategy (ETL) project to ensure consistency in records loaded into UAIR data warehouse.

• Developed >140 jobs using IBM DataStage and test queries in SQL to facilitate the truncate and load process. Technical Consultant, Tucson Electric Power (TEP), Course: Eller Business Consulting Jan 2020 – May 2020

• Analyzed TEP’s past financial data of 8 years to present business opportunities for a non-functional power system.

• Presented Net Present Value analysis, benefits and risks analysis through ~15 expert interviews and industry research.

• Acquired client engagement experience through weekly status meetings and reports. Cyber-Security Tech Fellow 2020, CodePath, University of Arizona Aug 2020 – present

• Facilitating a 12-week cyber-security certification course for 28 computer science students.

• Training students with hands-on experience in web-application vulnerability detection with Burp Suite, penetration testing, malware detection and developing defensive applications. ACADEMIC PROJECTS

Database Development for Bookman’s Entertainment Exchange

• Designed and implemented a relational database system using Oracle SQL to optimize in-store inventory management.

• Created ER diagram, SQL queries, triggers, stored procedures for in-store operations, and connected database to a web-interface to simplify data flow and management. NYC traffic collisions Analysis: Link

• Analyzed > 1 million records of NYC traffic collisions from 2013-19 using R, Tableau, Excel.

• Developed interactive Tableau dashboards to determine collision hotspots, collision factors, injuries, weather, etc.

• Forecasted number of collisions for 2020-21 using Tableau for future scope. Patient Readmission Prediction System

• Trained a hospital dataset of >70K health records to predict whether a patient will be readmitted for diabetes or not.

• Tested the data against machine learning algorithms like decision trees, Naïve Bayes, XG Boost.

• Implemented XG Boost and improved performance by reducing iterations by ~90%. Business Analysis of Disney+

• Defined potential business problems from past financial data and made recommendations to build customer base.

• Presented a holistic analysis of SWOT, stakeholders, finances to succeed in the market of online streaming services. LEADERSHIP AND COMMUNITY INVOLVEMENT

• Mentoring students from the incoming MIS cohort with resume, cover letter and portfolio preparation.

• Improved outreach and alumni engagement as Alumni Head in my undergraduate college.



Contact this candidate