Data Analyst

Suraksha Jadhav

**************@*****.*** 857-***-**** https://www.linkedin.com/in/suraksha-jadhav/ https://github.com/SurakshaSJadhav

TECHNICAL SKILLS

Programming Languages: MS SQL, T-SQL, Python, Oracle, C Analytics Tools: Tableau, Power BI

Big Data Solutions: Apache Hadoop

NoSQL Platforms: Couchbase, MongoDB

Tools and Skills: ETL Operations, Advanced Microsoft Excel, VBA Macros, Data Analytics, Data Mining, SDLC, Git, SSIS, JIRA, Analytical problem solving, Agile Methodologies EDUCATION

Master of Science in Information Systems Northeastern University Boston, MA May 2020 Bachelor of Engineering in Computer Science Atria Institute of Technology Bangalore, India Jun 2015 EXPERIENCE

Data Analyst Intern Velero Technology Boston, MA Jul 2020 – Present

• Built the company database data in Neo4j and visualized the same in Tableau that helped the clients to make better data- informed decisions

• Utilized JIRA for project management, issue tracking and workflow of DB tasks for issues at any given time Data Engineer/Analyst Granite Telecommunications Quincy, MA Aug 2019 – Dec 2019

• Built the Data pipeline for classification model using pandas library which saved 25% of processing time and clients could make better data-informed decisions

• Implemented Extracting, Transforming and Loading ETL data from Excel, Oracle to MS SQL Server by using SSIS services

• Integrated SQL and Tableau to develop interactive dashboards, and utilized Microsoft Excel to categorize sales reports into a detailed pivot table to develop an improved strategy, which helped finance team to increase sales by 10% in OHIO

• Migrated data from SQL Server & Oracle to Hadoop increasing execution speed by 35%

• Implemented SCRUM for agile development and participated in team-led solutions, reviewing peer’s code for quality Senior SQL Developer/Analyst IBM Bangalore, India Oct 2015 – Jul 2018

• Worked as Oracle backend SQL Developer for largest telecommunication tool “Order Status Manager IBM AT&T Business Direct”; facilitated in providing real-time status on all service orders in one central location in Agile methodology

• Initiated in accomplishing real-time processing, due to terabytes amount of data, took up lead in tuning performance. Sole contributor in reducing response time from 3 minutes to 50 seconds (85% efficiency) using query optimization

• Created and conducted training courses for the team about scrum methodology and agile best practices, understanding and improving team dynamics and team performance

ACADEMIC PROJECTS

Exploratory Data Analysis of Airbnb in Seattle (NumPy, Pandas, Matplotlib, Seaborn) Oct 2018 – Dec 2018

• Analyzed the Airbnb data of roughly 8000 listings to describe activity of homestays in Seattle and to understand real estate and short-term rental market by using data science libraries in python (pandas, SciPy, NumPy, Scikit, matplotlib)

• Executed algorithms such as Regression, Decision trees, Random Forest to find out what type of Airbnb is preferred Diabetes Patient Readmission – Hyperparameter Database (H2O, Python, Regression Analysis) Feb 2019 – Apr 2019

• Performed EDA on the Diabetes patient readmission dataset representing 10 years of clinical care at US hospitals, ran H2O AutoML on deciding target variable, fetched models from leaderboard and its corresponding hyperparameters

• Generated algorithms such as XGBoost, Gradient Boosting, Bayesian Models and statistics for different runtimes and extracted range of important hyper-parameters values to boost the predictive performance of models Data Warehousing and Business Intelligence for Retail (Talend, Relational DB, Tableau, Power BI) May 2019 – Aug 2019

• Designed and developed a data warehouse, pipelining retail data from diverse sources using Talend

• Implemented Source to Target Mappings, ETL flows, and Performance Tuning on data sourced from SORs (MySQL, SQL Server, Postgres, Oracle and Excel)

• Built interactive dashboards to convey stories of retail sales using Tableau and Power BI Boston Crime Data Analysis using Python and Power BI (MongoDB, Power BI, JSON) Sept 2019 – Dec 2019

• Performed EDA on the dataset and loaded the dataset into MongoDB in JSON format, and connected it to PowerBI

• Analyzed the data and dashboards were to visualize how has crime changed over the years, which part of Boston has the highest crime rate and what kind of crimes have been occurring frequently.

Contact this candidate