Shruti Sanjay Kasar

Boston, MA-***** +1-857-***-**** adhxjx@r.postjobfree.com www.linkedin.com/in/shruti-kasar14 TECHNICAL SKILLS

Programing Languages: SQL, Python, PL/SQL, MATLAB, R, Java Web Languages: HTML5, CSS3, Java Script, WordPress Database: Microsoft SQL Server, Oracle, Snowflake, MySQL Analytics & BI Tools: Power BI, Tableau, SSIS, Talend, Toad Data Modeler, Looker, ERStudio, Altryx, Qlik Tools and Utilities: Jupyter Notebook, Visual Studio, Git, MS Excel, JIRA, Salesforce, Bitbucket, MS Power Point EDUCATION

Master of Science in Information Systems Expected August 2021 Northeastern University, Boston, MA

Relevant Courses: Application Engineering and Development, Database Modeling and Database Designing, Data Science Engineering Methods & Tools, Designing Advanced Data Architectures for Business Intelligence Bachelor of Engineering in Information Technology July 2013-May 2017 Mahatma Gandhi Mission’s College of Engineering and Technology, India (University of Mumbai) Relevant Courses: Database Management Systems, Data Structure and Algorithms, Data Mining and Business Intelligence. CERTIFICATES

Tableau Analyst, Tableau May 2020

MATLAB Onramp and MATLAB for Data Processing & Visualization, MathWorks Training Services June-July 2020 EXPERIENCE

M/S. Samsherian, Panvel, India July 2017-March 2019 Jr. Business Intelligence Analyst

• Designed and executed client building strategies by performing brand research and competitor analysis

• Performed analysis on the data collected by the marketing channels to get meaningful insights using BI tools

• Developed the Key Performance Indicators and measured the brand progress with the help of BI techniques

• Worked closely with the marketing team to design the campaigns for targeting the right audience to build the brand profiles

• Evaluated the marketing campaign’s effectiveness by tracking the customer habits and market trends ACADEMIC PROJECTS

Good Reads Recommendation System: Python, PyCharm, Flask, AWS (S3, EC2), Tableau Present

• Develop a Flask Application for Good Books Reads Data using PyCharm to recommend books to the user using Collaborative and Content based filtering

• Build a pipeline by extracting data from AWS S3, perform cleaning, create validation & recommend functions

• Incorporate Flask mail web service to send the recommendation to users & deploy the application on EC2 Instance

• Perform sales analysis of the books at the various levels in Tableau & generate dashboards on target customer Data Warehouse & Business Intelligence: Talend, SSIS, Tableau, MS Power BI, ER Studio January-April 2020

• Profiled and integrated the Wide World Importers data set with 17M+ records from multiple sources using Talend

• Designed ETL workflows using Talend and SSIS to integrate data into facts and dimensions tables

• Performed error handling and implemented the reject codes of bad data for the performance tuning in future

• Optimized ETL jobs to ensure one click load to entire data warehouse

• Utilized Amazon Web Services (AWS) Redshift to store and AWS Athena to query the data warehouse

• Built 15+ dashboards using MS Power BI and Tableau representing the KPI Loan Data Prediction & Analysis: Python, Jupyter Notebook January-April 2020

• Performed exploratory analysis on Lending Club dataset using python libraries: NumPy, Scikit-Learn, Matplotlib & Seaborn

• Implemented Data Cleaning by removing data with inconsistencies, duplicates and null values using Python code

• Applied supervised Machine Learning Algorithms like Gradient Boosting, Logistic Regression and Linear Regression to train the model for predictive analysis in Jupyter Notebook

• Predicted the loan waive-off accuracy, interest rate and potential investment using the machine learning algorithms Dental Office DB: SQL Server, SSIS, Toad Data Modeler, Tableau September -November 2019

• Developed a normalized MS SQL Server Database for Dental Office & implemented its functionality using web application

• Employed Toad Data Modeler tool to design the Data Schema & to understand the cardinalities between the attributes

• Generated a DDL script using Toad Data Modeler and performed forward engineering to design physical data model

• Designed 5+ SQL Functions, Stored Procedures and Triggers to store and maintain the data in the database

• Performed data profiling using SSIS to analyze the data in the database and generated reports using MS Power BI