Data Analyst

Ashwini Mahale

*******.********@*****.*** 815-***-****

www.linkedin.com/in/ashwini-mahale https://github.com/ashwiniM96 Virginia

PROFESSIONAL SUMMARY

Motivated and highly analytical Data Analyst with 2+ years of experience interpreting and analyzing data.

Proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency.

Demonstrated knowledge of database; hands-on experience with AWS technologies like S3, Glue; JIRA, Source to target data mapping; Regression analysis; Ad-hoc analysis; A/B Testing; Statistics; Data cleaning, Transformations, Data visualization etc.

Knowledge in the ETL (Extract, Transform and Load) of data into a Data Warehouse and Business Intelligence (BI) tools like Tableau.

Experience in efficient usage of Advanced Microsoft Excel in data analysis and reporting using Pivot Tables, VBA, VLOOKUP, Macros.

Approach challenging situations with entrepreneurial agility and open-mindedness, creative problem-solving, and critical thinking.

WORK EXPERIENCE

Data Analyst, IDEXCEL- Herndon, VA 12/2019 – 02/2020

Created multiple SQL queries in Postgres SQL to fetch data from various tables using join operations to extract data.

Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from a Data Warehouse, transformed, and sent to an external entity.

Data Analyst, ANDWILL, LLC- Wilmington DE 09/2019-12/2019

Built Data Pipeline, ETL workflow to transform and aggregate data in Agile Environment.

Involved in importing of data from various data sources, performed transformations using MapReduce and loaded data into S3 buckets and extracted the data from SQL Server using SSIS.

Performed analysis of functional and non-functional categorized data elements for Data Profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks.

Created dashboards of the results in Tableau for visualization.

Graduate data intern, SUNY-Poly - Utica, NY 07/2017 to 12/2018

Built framework which can determine a degree to which structure of customer survey on website characterizes no. of supportive decisions on every client.

The data was extracted from amazon.com using Web Scrapping in python using Beautiful Soup, and data operations were made using pandas, predictions with regression models were made on the dataset using NLTK and SCI-KIT libraries.

SQL Database Developer, REBI Pvt Ltd -Bangalore, India 08/2016 to 07/2017

Worked on relational database, wrote complex SQL queries, optimizing queries and performed Data Analysis of data.

Generated SQL queries using joins, database connections and transformation rules to fetch data from SQL Server database systems.

Involved in preparing procedures, functions, triggers in the project. Used query optimizer for performance tuning. Used lot of insert, update and delete statement in PL/SQL.

Created Pivot tables and Charts using worksheet data and external resources, modified pivot tables, sorted items and group data, also used Macros for automation management of Dashboards and Ad-hoc reports.

ACADEMIC PROJECTS

Analysis on YELP Dataset

Performed ETL on the database as a part of data analysis, also performed data visualization with geospatial data and sentiment analysis on the huge JSON dataset in python using NLTK, Pandas libraries and Sci-kit learn for regression analysis.

Also created a recommendation system using the review file from the dataset with collaborative filtering.

Prediction of Car Resale Value

The project aimed at producing an estimate of retail value of used cars by analyzing its attributes, reviews, and other significant features.

Data was collected and data cleaning operations were performed and then regression models were built on data and then verified.

Music Synthesizing from Video

Developed a machine learning model that recognized music notes being played on piano simulator and generate a wave audio file.

Designed a convolution neural network to train the dataset created as a set of music keynotes images to train the model.

TECHNICAL SKILLS

Programming Languages: SQL, Python, Java, DAX

Web Technologies: HTML 5, CSS 3, JavaScript, Bootstrap

Big-Data Ecosystems: Hadoop, PySpark, Spark Core, Spark MLib

IDE: Advanced Microsoft Excel, Tableau, SQL Server, SSRS, PgAdmin 4, PostgreSQL, T-SQL, Cloudera

AWS: S3, Glue, Athena, Redshift

Data analysis

Data Warehousing

ETL

Data Visualization

EDUCATION

BE, Computer Engineering, 2017

Mumbai University - Mumbai, India

MS, Computer Information Science, 2019

State University of New York-Polytechnic Institute - Utica, NY

CERTIFICATIONS

Microsoft Excel for Data Analysis and Reporting (UC-Y92WPYOV)

Microsoft Technology Associate - Security Fundamentals (ID: 13575462)

Oracle Certified Professional Java Programmer (OCPJP) - Java Standard Edition 6 (ID: OC1516541)

Contact this candidate