Post Job Free

Resume

Sign in

Data Software Engineer

Location:
Boston, MA
Posted:
February 25, 2018

Contact this candidate

Resume:

AKSHUL AGARWAL

Boston, MA https://www.linkedin.com/in/akshulagarwal 617-***-**** ac4lxf@r.postjobfree.com EDUCATION:

Northeastern University, College of Engineering, Boston, MA Sep 2016 - May 2018 Master of Science in Engineering Management with certification in Data Analytics GPA: 3.6/4.0 Relevant Coursework: Data Warehousing and Business Intelligence, Computational Statistics, Data mining and Machine Learning, Probability and Statistics, Database Design and Management, Collecting Storing and Retrieving Data, Project Management University of Mumbai, Mumbai, India Aug 2011 - Jun 2015 Bachelor of Engineering in Computer Science GPA: 3.5/4.0 TECHNICAL SKILLS:

Languages: R, SQL, Python, Java. PL/SQL, T-SQL, C, C++, Matlab Database: SQL Server, MySQL, Oracle, PostgreSQL, MongoDB, Hadoop Data Integration Tools: Microsoft SSIS, Talend Studio Visualization Tools: Tableau, PowerBI, QlikSense, PowerPivot Software Tools: Microsoft Excel, SAS, SPSS, SQL Developer, Jupyter Notebook, Microsoft SSMS, MySQL Workbench, PGAdmin4, TOAD Data Modeler, Microsoft Visio, Jira, Confluence PROFESSIONAL EXPERIENCE:

Northeastern University, Boston, Research Assistant Oct 2017 – Jan 2018

Implemented a coding scheme for examining political ads

Adopted proposed coding scheme to annotate one of largest collection of political ads available to public till date

Evaluated, assessed and analyzed accuracy of quantitative research methods in extracting information from ads

Built dashboards in Tableau to present analysis results to lead PI and other researchers Analytics Advisory Group LLC, Austin, Data Science Intern May 2017 – Aug 2017

Executed a project to undergo a complete model development life cycle using CRISP-DM methodology for a healthcare client

Developed a prediction model in R using ARIMA to forecast heart related cases from inpatient discharge data

Selected ARIMA models with varied p,d,q values and validated it using AME, RMSE, MAPE parameters Itiviti AB, Mumbai, Associate Software Engineer Jul 2015 – Jun 2016

Managed complete software development life cycle starting right from requirement gathering and analysis to maintenance

Generated scripts, successfully tested and executed them to automate client order placing process

Migrated entire application on client’s machine and conducted UAT testing in production environment

Created dashboards in Tableau, QlikSense to depict trends in stock acceptance rates for various European stock markets ACADEMIC PROJECTS:

The Kaggle Project – Prudential Life Insurance Assessment Sep 2017 – Dec 2017

Interpreted dataset containing 127 predictors, narrowed them down to 38 using RFE and Variable Importance

Programmed a predictive model for risk classification using XGBoost, SVM, Decision Tree, Linear Regression algorithms

Compared different modeling techniques using RMSE values and selected best performing model Data Integration/Data Warehousing Sep 2017 - Dec 2017

Designed a Hybrid dimensional normalized target database consisting Fact and Dimension tables

Accomplished DI using Talend, SSIS involving source to target mapping, data-conversion, SCDs and error handling

Combined data from database tables using Tableau, PowerBI to depict trends, performance and profit margin Sentiment Analysis and Visualization of government policies using Twitter API Jan 2017 – Apr 2017

Mined data (16,00 tweets) related to government policies using Twitter API calls

Performed data wrangling in R and stored data in MongoDB

Devised an algorithm to perform sentiment analysis on data whose result was visualized using Tableau and ggplot Built a Health Insurance Company Database Jan 2017 - Apr 2017

Gathered and identified all key entities and relations and then designed database using Toad Modeler

Integrated Procedures, Triggers, Indexes & Functions to provide modularity to database

Created a front-end web application using R Shiny to access database and implement CRUD operations Speech Recognition and Authentication Aug 2014 – Apr 2015

Developed a MATLAB based application that would validate a user by speech recognition using feed forward neural network, achieving 82% speech recognition accuracy



Contact this candidate