Data Analyst

Shriyash Sudhir Mahajan

201-***-**** – ******@****.*** – LinkedIn

Program Analyst/Software Engineer

Software Engineering – Data Analytics – Business Analysis

CAREER ACCOMPLISHMENTS

Automated system improved recruiter efficiency and saved approximately 60 mins for each recruiter (Taj Technologies Inc.).

Conceived URL Actions to navigate from one dashboard visual to another dashboard for a smooth eye-catching presentation, paired with using Tableau Data Extracts for better performance on rendering the visualizations (Haystack AI)

Constructed dashboards in Tableau for bugs tracked vs resolved time, resulting in increasing the product efficiency by 24 hours. (iLink Software Pvt. Ltd.)

PROFESSIONAL EXPERIENCE

Taj Technologies Inc. August 2020-Present

Program Analyst

Developed web scrapper to scrape data from job portal sites using Python

Maps and stores data at internal server and constructs pipeline for server

Developed dashboard with power BI in order to draft monthly reports, employee performance, engagements, client reports, and quarterly revenue reports

Haystack AI June 2019-December 2019

Software Engineer

Involved in sprint planning and UAT testing. Defined best practices for Tableau Report development by adhering to style guidelines and making visual pop-out. Collaborated with ETL team to extract data into Tableau using custom SQL to filter data source. Blended data from multiple databases into one report by selecting primary keys from each database for data

validation. Supported all phases of the project development, testing, pre-implementation runs, and production support. Delivered the activities on time, bug free, and with high quality and excellent customer service.

Created paywalls for application subscriptions. Devised tableau dashboards to monitor and predict sales, user reviews and application performance

Conceptualized metrics dashboard indicating errors, incidents, status and other details

Drafted and modified Business Intelligence analytical reports using Tableau

Resolved any performance issues of the reports

Converted Legacy Reports to Tableau dashboards connecting to SQL server

Built Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts etc.

Drew backup of the Tableau server on regular basis by using Tabcmd and Tabadmin commands. Constructed

restoration procedures to restore the server during system failures

iLink Software Pvt. Ldt. June 2016-March 2018

Software Engineer

Partnered with business unit managers to understand project scope, suggest possible alternatives, and document each step of the design. Participated in sprint planning meetings, daily SCRUM stand-ups, sprint reviews and retrospectives, user stories, and task prioritization.

Implemented a medication reminder application to track activities and patients' daily medical schedule

Forged REST Api to maintain backend, added features like push notifications and email notifications with Python and Flask

Conducted end to end QA testing using Agile methodology that included gathering test requirements, laying out test plans, setting up test environment, writing and executing test cases, and reporting and following up on defects

PROJECTS

Sentiment Analysis on Twitter data (R, python) Data Visualization web mining August 2019-December 2019

Performed sentiment analysis on demonetization tweets collected from tweeter. Implemented SVM model to train and test data with accuracy of 71%. Used same trained model to perform sentiment analysis, which classifies tweets into negative, positive and neutral

Model gave sentiment score to each tweet according to number of positive and negative words in a sentence. Each tweet is then classified into one of the three sentiments

Established visualization using R libraries like WordCloud which gives information like most frequent positive and negative words, most tagged people in tweets, overall positive or negative tweets

Data Mining for Microsoft Employee Data ( Python Data analysis) January 2019-May 2019

Implemented data mining algorithms like logical regression, Decision Tree and Naïve Byes on Microsoft Employee Data using Rapid Miner. Resulted in interesting outcomes like reasons for attrition, when employees are more likely to leave the company etc.

Analyzed the data with Confusion Matrix and calculated important parameters like recall, precision, accuracy

Data Visualization for road accidents (Tableau, python) January 2019-May 2019

Designed tableau dashboard to analyze UK accident records over ten years of time period

Deployed multiple tableau functions to create interactive dashboard which gives information like average accidents in year, car makes and models with highest number of causalities, road and atmospheric conditions at the time of accidents

Predictive Data Mining for Walmart Store Sales Forecasting January 2019-May 2019

Completed data mining to predict Walmart store sales based on geographical locations and special events using Weka for clustering and classification

Estimated monthly sales with 95% accuracy by developing a predictive data model based on the KPI’s

TECHNICAL PROFICIENCIES

Programming Languages:

Python, R, MSSQL, HTML5, CSS, JS, jQuery

Tools/ Framework:

Tableau, PowerBI, OLAP, MS-Visio, MS: Excel, PowePoint, Rapid Miner, Agile, SDLC, Project Management, Knowledge Management, Network Scheduling, UAT Testing, Scrum, UML, JIRA, AWS, Git

Databases:

MS-SQL, MySQL

EDUCATION AND CERTIFICATIONS

NEW JERSEY INSTITUTE OF TECHNOLOGY

Master of Science, Information Systems and Computer and Information Sciences

Graduated May 2020

GPA: 3.95/4.0

UNIVERSITY OF PUNE, India

B.E. Electronics and Telecommunications

Graduated June 2016

Contact this candidate