Abhishek Nilajagi

adk2cr@r.postjobfree.com 617-***-**** LinkedIn Dashboards

TECHNICAL SKILLS

Languages : SQL, Python, R, DAX, Libraries (Pandas, NumPy, Matplotlib, Scikit-learn, TensorFlow) Data Tools : MySQL, Microsoft SQL Server, Tableau, Power BI, MS Access, SAS Software’s : MS Excel, Jupyter Notebooks, Microsoft Office Suite, Viso, Microsoft Azure, CRM, VBA Certification : Six Sigma White Belt, Tableau Badges Machine Learning: Regression Analysis, Random Forests, Gradient Boosting, Decision Tree, KNN EDUCATION

Master of Science in Information Systems, Northeastern University, Boston, USA September 2018 - May 2020 Courses: Communicate/Visual Data Analysis, Data Warehousing and SQL, Data Mining Application, Analytics Systems Technology, Predictive Analytics, Probability Theory and Statistics, Decision Support and Business Intelligence Bachelor of Engineering in Computer Engineering, Mumbai University, Mumbai, India August 2013 - May 2018 Courses: Data Structures, Database Management Systems, Data Warehouse and Mining, Artificial Intelligence WORK EXPERIENCE

Business Analyst Intern, Adwaita Solutions Inc July 2020 - Present

• Configuring specification, business analysis requirements with Agile software development methodology

• Aiding the BI team in visual stories, A/B testing and designing use cases using Microsoft Azure DevOps

• Drawing insights using SQL and Power BI to generate business strategies for the product marketing analytics Business Analyst, Ledgerops April 2019 - July 2019

• Lead a team of 4 to deliver solutions and digital marketing strategies to upsurge the online presence for Ledgerops

• Gathered web data using python API integration with Google and Twitter APIs along with SEMrush SEO data

• Performed EDA and Data Cleansing to build an interactive dashboard in Tableau to identify the potential influencers Data Analyst, Flow Tech Engineers Ltd July 2017 - December 2017

• Implemented a material requirement information system by using enhanced data collection using Excel

• Proposed solutions based on orders data analysis to improve manufacturing timelines 15% and ROI analysis

• Decreased delivery time by 20% and improved on expenditures on raw material and provided automated solutions Financial Analyst, Shivam Chemicals Pvt Ltd January 2017 - June 2017

• Evaluated large financial and clients CRM datasets expenditure assets and performed Ad hoc analysis

• Examined KPIs and built interactive data dashboards on Tableau for sales analysis and sales forecasting

• Improved 12% on trading and transaction durations by ranking analysis of traders and financial expenditures ACADEMIC PROJECTS

Malware Classification Using Machine Learning May 2018

• Built ETL to import live classified malware data and used data visualization for malware image classification

• Designed ANN and K-Nearest Neighbor machine learning algorithms for malware classification into 9 groups

• Achieved an accuracy of 86% by optimizing hyperparameter of Artificial Neural Network, reducing overfitting

• Published research paper in the International Journal of Computational Intelligence Research (IJCIR)Vol.14 Adult Income Dataset Prediction December 2019

• Motivated a team to comprehend income data and test multiple prediction algorithms using Python

• Explored census dataset and outlined the necessary factors required to predict people having earnings above 50k

• Trained and tested various Machine Learning models in python language and was able to achieve 80% accuracy for prediction for Decision tree Classifier which was 20% more accurate than Random Forest Classifier Pharmacy Insurance Management System. February 2020

• Built database for an Insurance company to store their customers claims and prescription details

• Developed a Normalized E-R model for the database system using MySQL workbench and used stored procedures

• Expended data extraction queries and used operations like triggers, joins, views on the dataset using MySQL Boston Bike Sharing March 2020

• Collected data of around 10ks Blue Bikes riders and proposed BI solutions to increase their customer’s and services

• Created action filters, parameters and geographic heat maps to find busiest stations and made dashboard in Tableau

• Identified KPIs like bike station traffic, type of customers and developed interactive Tableau visual reports