Data Analyst

Nilambari Sonawane

602-***-**** **************@*****.*** Phoenix, AZ

SUMMARY

Recent graduate with 2+ years success in data-driven and analytical approach to opportunities and challenges for business via SQL, Tableau, Python and Excel. Driven by team collaboration and blend of strategic strong problem solving. EDUCATION

Master of Science – Information Systems Management Aug 2019 – July 2020 Arizona State University, Tempe, AZ, USA

Bachelor of Engineering – Electronics and Telecommunications Aug 2013 – May 2017 Savitribai Phule Pune University, India

WORK EXPERIENCE

Data Analyst, Accenture Oct 2017 – July 2019

• Performed query optimization and tuning using SQL Profiler and Index Tuning Wizard for classical, interactive and ALV reports of SAP ABAP to increase efficiency by 25%.

• Created adaptive dashboards by developing and reviewing SQL queries in Tableau desktop.

• Identified, measured and recommended improvements strategies for KPIs.

• Collected, cleaned and analyzed the survey data of 1500 healthcare facilities using NumPy, Pandas, Matplotlib Python libraries.

• Automated extraction of geo-spatial coordinates and created visualization based on 30 pre-selected features to measure the performance of hospitals.

• Automated 45% highly repetitive jobs of technologies like SAP, Mainframe, Siebel, and MOVEit using the Robotic Process Automation, which reduced daily manual efforts of 120 hours.

• Technologies Used: SQL, Python, Tableau, RPA Automation, SAP ABAP, Pandas, NumPy, Plotly, Matplotlib Business Intelligence Engineer Intern, Qualden Technologies Jun 2017 – Oct 2017

• Designed solutions for the company's strategy and automation team by creating interactive stories, dashboards, and visualizations leveraging Tableau to enable effective reporting and analytics.

• Functioned as a liaison between analytics team and business process owners for analyzing issues and providing solutions to meet business goals.

• Built a system utilizing Python and image processing for enhancing home security to 97%.

• Created a mobile application wireframe prototype using Adobe XD for the same.

• Technologies Used: SQL, Python, Tableau, Image Processing, IoT, Adobe XD TECHNICAL SKILLS

Programming Languages: SQL, Python, SAP ABAP

Databases: MySQL, SAP ECC, SAP HANA, MS SQL, Oracle, PL/SQL, PostgreSQL Visualization: Tableau, Power BI, Matplotlib

Tools & Technologies: ETL, AWS (EC2, S3, Redshift, Lambda), Excel, Data pipeline, Azure, RPA Automation, VDI tool Relevant Coursework: Data Mining, Visualization, AI, Business Intelligence, Machine Learning, Data Structures and Algorithms, Data Modeling, Statistics, InfoSec, Agile, Data Management Academic Workshops: SQL, Tableau, Python (Pandas, NumPy, Scikit-Learn, TensorFlow, Keras), AWS PROJECTS

A Comic Buff Got Happier [MySQL, Pandas, Matplotlib, Seaborn]

• Scrapped Reddit data and extracted 100k comments using Python and stored it in MySQL.

• Filtered & analyzed data with Python libraries like Pandas, Matplotlib, and Seaborn to perform LDA analysis for topic modeling.

• Performed sentiment analysis after aggregating data for gathering the reasons to enhance comic to cinematic adaption. Airbnb Yield Prediction for Hosts [AWS, NumPy, Scikit-Learn]

• Extracted and analyzed the customer data to obtain data points that are responsible for high listing prices in New York region.

• Trained and evaluated the random forest and linear regression models and deployed them on AWS to predict the gross annual revenue of the host.

Movie Recommender System [Matrix factorization, NLTK, TF/IDF]

• Implemented content-based recommender using TF & IDF, collaborative filtering using Matrix factorization, and hybrid model recommender system on TMDB movie dataset.

Credit Card Fraud Detection [R, Logistic Regression]

• Explored the data for credit card transactions and performed data manipulation and data modeling.

• Built a classifier to detect credit card fraudulent transactions up to 95% by fitting it to a logistic regression model.

Contact this candidate