Logistic Data Analyst

SHRUTIKA SINGODIA

857-***-**** Open to Relocate Portfolio Github *****************@*****.*** LinkedIn SUMMARY

Meticulous and logical data and Business professional with proven ability to communicate with both technical professionals and end users to identify and translate into business systems requirements for product delivery. Offering 3+ years of experience driving Business impact through data driven insights. Enhancing business effectiveness through making recommendations based on data findings.

PROFESSIONAL EXPERIENCE

Graduate Research Assistant Boston, MA

Boston University May 2020 – Jan 2021

Researched and worked on project to model and predict the outcome of breast cancer treatment among patients by analyzing reports of around 7000+ rows of dataset in collaboration with Massachusetts General Hospital

Designed and created web page that shows medical info of patients while, predicts chances of having BC in patients Graduate Teaching Assistant Boston, MA

Boston University Nov 2019 – Dec 2020

Appointed as Teaching Assistant for course Database Design Implementation for Business (SQL) at Boston University. Graded SQL assignments, generated class reports based on solved SQL queries to evaluate accuracy

Implemented an online review system for 97 students to analyze their performance based on difficulty of the questions and provided them with an insightful report on class performance and statistics for every question Data Analyst Indore, India

WebCraft IT June 2016 - May 2019

● Achieved ownership of a project after creating and optimizing Jupyter reports with Python & SQL queries to reduce the execution time by 60%. Created database schema with final dataset of more than 43 tables using SQL.

● Interacted with stakeholders, elicited requirements, analyzed data, reported results and provided 79% accuracy

● Built and executed backup recovery procedures for metrics reports resulting in 56% of accuracies

● Gathered and transformed various records coming from multiple sources and developed SQL queries to store desired parameters in the database Analyzed data operations using SQL, Microsoft Excel

● Key participant in all phases of the SDLC right from requirements gathering to translate strategy in operational plan

● Created tables and relationship between them, implemented CRUD operations using Gii framework for specified data model. Performed A/B testing for code change requests thereby reducing the defect rate by 40% Business Analyst Intern Indore, India

WebCraft IT April 2014 – May 2016

Communicated with the stakeholders, conducted users’ interviews to and create an empathy map and personas

Analyzed data and prepared reports proactively for meetings and increased an efficiency of the workflow by 25%

Executed SCRUM (agile) master responsibilities utilizing JIRA for grooming user stories, backlog management

Redesigned fulfillment processes and protocols, saving company a minimum of $1.5 million, implemented a CRM process using MS Dynamics that reduced refunds by 32% ; resulting in a 10% decrease in the bounce rate

Developed crucial Functional Design Documents, detailed use case specifications, presentations and User Stories using JIRA, Confluence, Trello. While, created mockup design and wireframes by using balsamic software

Built metrics and business cases to improve customer experience by creating 10+ prototypes models EDUCATION

Boston University, Boston, MA Jan 2021

Master of Science Computer Information Systems, GPA: 3.70 Rajiv Gandhi Proudyogiki Vishwavidyalaya, India July 2016 Bachelor of Engineering Computer Science Engineering, GPA: 3.80 TECHNICAL SKILLS

Databases: MySQL, Microsoft SQL Server, Oracle, PostgreSQL Programming Languages: Python (Numpy, Pandas, Matplotlib, Sklearn, Seaborn), R, SQL, HTML, CSS Data Integration/BI/ETL: Talend, SQL Server Integration Services (SSIS), Alteryx, ER/Studio Data Visualization: Tableau, Microsoft Power BI, Microsoft Excel (Pivot Tables, Pivot Charts, V lookups), SAS Machine Learning: Regression, Classification, Decision Trees, Random Forest, KNN, K-means clustering, PCA Big Data/Cloud: Amazon Web Services (IAM, S3, Lambda, DynamoDB, RedShift), Spark, Hive Other: GIT, JIRA, Jupyter Reports, SDLC, AWS, Agile (SCRUM), Word, Power Point, Scrapy, Microsoft Project, Kanban CERTIFICATIONS

Data Analytics Fundamentals (Amazon Web Services) July 2020 Introduction to R and Python for Data Science (Data Camp) June 2020 SQL for Data Science (Coursera) Nov 2020

Google Analytics (Google Analytics Academy) May 2020 Microsoft Excel (Udemy) Dec 2020

PROJECTS Github

Business Intelligence & Retail Data Warehousing (ETL) (Tableau, MySQL, SSIS, Talend, ER/Studio) BU’ Spring 2020

Designed a data warehouse in ER/Studio, pipelined and integrated huge dataset of 60 million records from diverse sources (CSV, Oracle, MS SQL Server, PostgreSQL, MySQL) using ETL techniques on Talend Open Studio, and SSIS

Implemented slowly changing dimensions (SCD), currency conversions, error handling, debugging and performance tuning (20 minutes – best in the class of 70) and visualized the outcome by building dashboards on Tableau Patient No Show-up Classifier (Weka, R, JMP, JIRA) BU’ Spring 2020

Ran 5 feature-selection algorithms & deployed 5 classifiers Random Forest, Simple Logistic, J48, Naïve Bayes

Performed Data Cleaning, Data Exploration, Feature Engineering, and Exploratory Data Analysis to develop statistical models (Logistic Regression, Decision Trees, Random Forest) on 100,000+ rows of a Weka dataset AIRBNB Booking and Rental Database (MySQL Workbench, Microsoft SQL Server, Power BI) BU’ Fall 2019

Modeled Entity Relationship for hotel booking which is a hospitality website that enables people to rent houses Modeled Entity Relationship while preparing dashboards on Power BI for data visualization

Normalized database to 3NF and implemented views, Stored Procedures, Functions, Triggers, Common Table Expressions, Sub Queries, Joins, Windows functions, and encryption of critical data using MD5 Stock Market Analysis (Python, Sklearn, NumPy, Pandas, Matplotlib, Pylab) BU’ Fall 2019

Program Implemented various regression models and clustering techniques for buying and selling of stocks on stock market data using pandas, to generate report to identify the best strategy of Machine Learning Algorithms

(logistic regression, linear regression, KNN, Random forest, K-means, Naïve Bayesian, SVM and decision tree) Blackjack Game (Python Developer) BU’ Fall 2020

Developed a text-based Blackjack game in Python language which included encapsulation, inheritance, polymorphism with exception handling functionalities, Object-Oriented Python concepts and python libraries LEADERSHIP EXPERIENCE & AWARDS

Best Student: Engineering Excellence Award, Undergrad College, India (2016). Awarded with certificate in recognition of dedication & achievement in campus placement.

University Computer Science Team Technical Head (2012 - 2016): Organized technical events, competitions, workshops for university students; Team size: 45+ members

Awarded and Appreciated for Volunteer work, Lions Club International district 3233 by council chairperson’s

Team Lead Manager: In Almighty welfare society an NGO where Rewarded with Volunteer Appreciation.

Active speaker in Toastmaster International and Awarded as a Best Guest speaker by Toastmaster International

College Fest Event Organizer Head (2016): Planned, coordinated and executed yearly college technical fest

Event Coordinator at Lions Club International: Organized various social events for community welfare

First position in National Entrepreneurship Network tech and business idea held at University

Second Position in Quiz (2016) : Inter-university competition at IIM with approx. 60 participants RESEARCH PUBLICATION

Published a Research Paper in International Journal, IJESRT (2015): Manuscript published in IJESRT

(International Journal of Engineering Sciences & Research Technology), IJESRT 4(11), Manuscript title: “A Survey on Web Crawler: A Search Engine”, Main author.

LEADERSHIP SKILLS

Team Work & Management, Time Management, Logical Thinker, Public Speaking HOBBIES

Dancing, Social work, Cooking, Sketching, Reading

Contact this candidate