Data Analyst

Summary

Data-driven, & highly analytical business analyst able to influence growth strategies

through fact-based, data-driven insights, with adept problem-solving and technical skills.

Work Experience and Internships

Since Sep’19 Business Intelligence Analyst

Cresen Solutions LLC, Berwyn, PA

Developed an ETL job for data integration, cleansing,transformation

& incremental loads in the data warehouse using Pentaho DI. Maintained & identified the SCD dimensions during the designing of the data warehouse.

Created databases and schema objects including tables, views, trig- gers, functions & applied constraints using PSQL.

Developed a MS Sharepoint site to publish multiple PowerBI reports, also managed the access of reports for individual users using MS Sharepoint groups.

Developed adhoc reports & dashboards using Power BI, based on the end-user requirements.

Developed complex PSQL queries & DAX to support Power BI visuals, identified and rectified data discrepancies.

Extensively involved in business requirements gathering, writing ETL specifications & prepared business requirement documents. Jan-Jun’17 Data Analyst Intern

MdC Concepts, Pune, India

Performed data cleaning using MS Excel and loaded cleaned data into SQL server.

Created visually impactful Tableau dashboards for data reporting. Performed data validation on developed dashboards using MYSQL. Research and Projects

Mar-Dec’19 Sentiment Analysis of Yelp Reviews using Multi-Label Classification Build a multi-label classifier model to categorize the user reviews on the restaurant business.

Adopted an intuitive approach to decompose multi-label into multiple independent binary classification problem.

Applied performance tuning on the final model using Python to im- prove the model’s overall performance.

Feb’19 Transactional Banking System.

Designed an OLTP system in a Docker Container around Postgres which performed CRUD functionalities on realistic mock data. Used Python-ODBC to establish a connection with Docker container to create a database in Postgres server.

Apr’18 Design and Implementation of Data Mart.

Modified ERD to dimensional modeling by recommending a star schema for a fictional data mart.

Collaborated in designing ETL process using Pentaho DI. Pro- grammed SQL queries for implementing views & summaries with roll- up and drill-down.

Nov’18 Research Interest Database

Collaborated in developing a digital library academic users to retrieve their profile & research work. Used HTML/CSS, Javascript & inte- grated it with JavaFX to create a desktop application & used MySQL

(JDBC) to store the database.

Prajakta

Deshpande

B *******@*.***.***

T +1-510-***-****

m linkedin.com/in/prajakta-

deshpande

Education

MS Information Sciences

Technologies Rochester Institute of

Technology Dec’19 GPA:3.34

BE Computer Engineering University

of Pune Jun’16 Class: First with

distinction

Skills

Programming Languages: Java,

Python & R for data analysis, SQL,

DAX.

Web: HTML/CSS, JS, JQuery,

Bootstrap, Ajax.

Technologies: Docker, Azure.

BI Reporting tools: Power BI, Tableau.

Databases: MySQL, PGSQL, MS SQL

Server, MongoDB.

Tools: Pentaho DI, MS Sharepoint,

Jira, Confluence, R-Studio, PgAdmin

4, Weka

Extra-Curricular

Computer Laboratory Assistant,

Rochester Institute of Technology

- Managed inventory of all the

computing devices.

- Assisted students in troubleshooting

system issues.

Student Manager, Rochester Institute

of Technology

- Overlooked daily shift lists and

scheduling for student employees

- Maintained student organization by

carefully training, as well as assisting

student employees.

Contact this candidate