Prajakta Sonawane

Prajakta Sonawane

Prajakta Sonawane

Highly analytical and strategical mindset with in-depth knowledge of databases, data cleaning, manipulation and visualization to furnish insights and analytics to help advance corporate growth.

@psonawane-hawk-iit-edu

Joined Aug 2020

About

Pursuing MS in Information Technology and Management focusing in Data Management.
Execute analytical experiments to help solve various problems, making a true impact across multiple domains.
Identify relevant data sources and sets to mine for client business needs and collect large structured/unstructured datasets and variables.
Devise and utilize algorithms and models to mine big data stores, perform data and error analysis to improve models, and clean and validate data for uniformity and accuracy. Algorithms include linear regression, multiple regression, classification algorithms such as KNN, Naïve Bayes algorithm., decision trees, SVM, etc.
 Analyze data for trends and patterns and interpret data with a clear objective in mind using Python and R.
Proficient with reporting and visualizations using Tableau and PowerBI.
Have a good hand over working with the ELK Stack.
Developed ETL procedures to migrate data with the help of Pentaho and SSIS.
Can work and query effectively and efficiently with databases such as MySQL and MongoDB.
Create websites and user interfaces, using standard HTML/CSS, JavaScript practices, while incorporating data from back-end databases and services.
Intermediate experience with programming languages such as Java and C.

Experiences

Data Analyst Intern

Sep 2017 - May 2018

8mos

Sep 2017 - May 2018

8mos

See more

Project Title: “Proactive monitoring of Server logs to prevent instant shutdown of the server using Elasticsearch” • Monitored different servers such as IIS, Apache, Tomcat, etc. and collected data from the log files. • Parsed the log files in JSON format, loaded them to the ElasticSearch clusters which are pipelined via Logstash and alerted the administrator about the shutdown using SMTP approach using ElastAlert queries. • Technologies Used: Python, Elasticsearch, Logstash, Kibana, ElastAlert
Python

Python

Elasticsearch

Elasticsearch

Tech Stack

Databases
Microsoft SQL Server

Microsoft SQL Server

Beginner

MySQL

MySQL

Beginner

PostgreSQL

PostgreSQL

Beginner

MSSQL

MSSQL

Beginner

Languages
Python

Python

Beginner

Java

Java

Beginner

JavaScript

JavaScript

Beginner

Query Languages
Oracle PL/SQL

Oracle PL/SQL

Beginner

Javascript UI
React

React

Beginner

Copyright © 2024 Prajakta Sonawane

Built with Showwcase