Data Software Developer

SAYAK CHAKRABORTY

*****.***********.***@*****.*** 513-***-**** www.linkedin.com/in/sayakc027 github.com/sayakc027 EDUCATION

University of Cincinnati, Carl H. Lindner College of Business Cincinnati, OH Master of Science in Information Systems, Graduate Certification in Data Analytics, GPA: 3.87 / 4.00 Available: Immediately Visvesvaraya Technological University, Dayananda Sagar College of Engineering Bangalore, KA Bachelor of Engineering in Computer Science, GPA: 3.15 / 4.00 August 2017 TECHNICAL SKILLS

Programming R, Python, SQL, SAS, R Shiny, C, C++, C#, Java, HTML & CSS, JavaScript, MySQL, Oracle SQL, Microsoft SQL Server Tools RStudio, Tableau, Power BI, Microsoft Excel, Git, GitHub, Microsoft Office (Word, Excel, PowerPoint, Visio), Alteryx Methodology

Database Design, Database Modelling, Data Quality Assessment, Data Analysis, Pattern and Trend Identification, Visualization of Data Insights, Statistical Analysis, Regression Analysis, Data Mining Additional Skills Application Design & Development, AGILE Methodology PROFESSIONAL EXPERIENCE

University of Cincinnati Cincinnati, OH

Data Intern May 2020 – Present

• Planned out business requirements to build a database to store Alumni Information for the IS Program at the University

• Developed the conceptual (ER model) & logical design of the database using Microsoft Visio

• Performed normalization (3NF) for database structure to store information for up to 5K users

• Currently, working on developing and designing the User Interface for the Web Application Accenture Bangalore, KA

Application Developer Associate – Production Analyst October 2017 – June 2019 Operation of Ordering Application for a leading Telecommunication Client

• Analysed and resolved multiple critical triages using MySQL and Shell scripts and prevented business to be affected critically

• Designed dashboards using Power BI for analytical reports incorporating daily activities for the client and the management

• Quantitative analysis of frequently occurring problems, thus highlighting critical issues, & predicting its impact on the business

• Involved in requirements gathering, collaborating across multiple teams, & consolidating the technical specifications document Automation of Daily Activity Reports – reducing manual labour by 600%

• Developed database queries using MS SQL to fetch and transform the required data for the reporting

• Configured batch jobs using Shell-Script

• Designed an automated email to display real-time data using HTML and CSS Uranium Corporation of India Limited (Department of Atomic Energy) Jamshedpur, JH Software Developer Intern July 2016

• Developed a web application “Post-Retirement Medical Facility” for the Retired Company Employees

• Developed the physical design of the database using Oracle & front end of the application using Oracle Form Builder and Oracle Report Builder

TECHNICAL PROJECTS

Forecasting Google Stock Price incorporating COVID-19 GitHub RPubs April 2020

• Using the comparison of ARIMA, KNN and Neural Networks Algorithms in R, tried to forecast the future price of the google stock incorporating the impacts of COVID-19 on its price and built an interactive R Shiny App for the users Cluster Analysis on FIFA 20 GitHub RPubs April 2020

• Using K-Means and Hierarchical Clustering Algorithms, tried to find the most suitable replacements for a player based on his physical attributes and skills

Text Mining Tweets for Disaster Management GitHub April 2020

• Built a machine learning model (in Python) to differentiate between disastrous and non-disastrous tweets

• Using the GloVe technique for word embedding, and modelling the data using Logistic Regression, KNN, XG Boost, Decision Tree and Voting Classification method and obtained an F1 score of 0.784 using Boosting New York AirBnB Price Determination GitHub RPubs February 2020

• Built a model to determine the factors affecting the price of the Airbnb in New York using statistics using multiple linear regression, variable selection by best subset regression, stepwise regression (AIC/BIC), & Lasso Regression. It also includes exploratory data analysis, model selection, validation, & prediction USA States Ranking by Fiscal Conditions Tableau April 2020

• Made a dashboard in Tableau to visualize different trends for each state of USA based on their fiscal conditions and how they can meet their short-term & long-term goals

EXTRACURRICULAR ACTIVITIES

• KPMG, Data Analytics Consulting Virtual Internship Certificate April 2020 – June 2020

Identified Data Quality Issues and suggested mitigation measures of data from Sprocket Central Pty Ltd to ensure data accuracy, consistency, and completeness using Python NumPy and Pandas library

Analysed existing customer trends and behaviour via data exploration to identify key factors while targeting new customers in their marketing strategy to boost bike sales and designed a Tableau dashboard for the same

• Published a paper on Recognition of Handwritten Digits using Machine Learning Techniques in International Journal of Engineering Research & Technology (IJERT) ISSN: 2278-0181 Vol. 6 Issue 05, May-2017 Certificate Published Paper Publication

Contact this candidate