AMAN RAJESH SONKAR

*** ****** ******, ********, *** Jersey 07029. ac2tbc@r.postjobfree.com, 409-***-**** CAREER OBJECTIVE:

Motivated and self-driven student from Stevens Institute of Technology. I have a strong inclination towards Business Analysis, Data Visualization, Data Analytics and Business Strategy teams working to develop optimal tactics to support the strategic objectives of the organization and to improve the business process. Seeking a career path where I can utilize my skills which would help the organization to grow and further enhance my growth profile

EDUCATION:

Stevens Institute of Technology, Hoboken, New Jersey May 2017 Master of Science in Information Systems / Business Intelligence & Analytics GPA: 3.67 Course Work: Analysis and Development of Information systems, Financial Decision-making, Project Management Fundamentals, Data Knowledge and warehousing, IT strategy, Organizational behavior and design, Process innovation and management, Integrating IS technologies, Data warehousing and Business Intelligence, Knowledge Discovery Databases. University of Mumbai, Mumbai, India May 2015

Bachelor of Engineering in Instrumentation Engineering SKILLS:

Operating Systems: Windows, Linux

Programming Languages: C, C++, R, Python, SQL, Assembly level language Applications: Microsoft Excel, Microsoft PowerPoint, Microsoft word, MATLAB, Visual Basic, Tableau, Visio, Adobe Photoshop Database Systems: MS Access, MySQL Server

EXPERIENCE:

Berko and Associates, New York, New York September 2017 – Present Data Analyst Intern

• Assembled data on Excel for the canvassing project. Standardized the data to remove redundancy and managed the data to ease bulk upload on Alto – A salesforce CRM for Real Estate. Analyzed the managed data on Tableau to create data visualization for possible real estate listing and analyzed the data to provide forecasting and projections for bonds rates.

• Performed diagnostics on Salesforce and generated client specific reports to fit their requirement. Created customized reports on possible listing to increase productivity and expand business. Stevens Institute of Technology, Hoboken, New Jersey Graduate Student Assistant, Samuel C. Williams Library August 2016 – May 2017

• Automated records of students using Excel and VBA. Created graphs to visualize records of students accessing the library facilities

• Maintained the World-Share book database for the library and managed the OLCC database for books and interlibrary loan

• Complying a variety of statistics concerning library usage and book circulation and maintain library records using Microsoft Excel Graduate Student Assistant, Campus Card Office January 2016 - July 2016

• Created and managed data sets of student’s records of their student ID card and all the financial activities related to it using pivot tables and vlook up in Microsoft Excel. Using the data created financial report to evaluate the most active expenditure area and used the data to increase productivity

ACADEMIC PROJECTS:

Stevens Institute of Technology, Hoboken, New Jersey Library Management Database System, Information Systems January 2017 – May 2017

• Created Datasets in MySQL server by recording different data like the number of books, different types of books, students and faculty information, different technologies offered to be issued, penalty details, number of students accessing the library

• Normalized and data to improve integrity and reduce redundancy in SQL. Analyzed the data in Tableau in terms of checking out books, reserve study rooms and the number of students by increasing the staff during peak hour to improve efficiency Hospital Database Management System, Information Systems January 2017 – May 2017

• Built and managed the data of an application for medical office consisting of many doctors. Patients can schedule an appointment and the reports, prescription, medical insurance and billing data will be recorded and managed

• Recorded and managed the data in Microsoft Access of patients regarding their respective doctor, the patients’ medical history, current prescription, their health insurance information and personal and billing information efficiently Data Analysis on “Hot-Spot”, Information Systems August 2016 – January 2017

• Implemented a device using R language and integrated sensors like temperature, gas, humidity, water, motion detector, presence detector, reed switches, sound sensor to collect data continuously which is available for access via the internet

• Implemented another device using Raspberry PI to create a data server which would collect all the sensor reading real time and analyze these data to determine the spots on campus which would be busiest during a time of the day

• Analyzing this data by virtualizing in Tableau and cross referenced this data with the number of sign into the WIFI hot spots in the spot to determine why that place is busy during the time of the day and places which are busy during a period University of Mumbai, Mumbai, India

Home Automation Using Raspberry PI August 2014 – May 2015

• Created a home automation system using R language and integrated with sensors like gas, humidity, light, temperature which gives real time readings. Innovated a design to connect various electrical equipment’s to the device which can be controlled wirelessly through smartphone or any device

• Modeled a home security system using MySQL Server where sensors like presences detector, motion, smoke and gas sensors give real time readings and generated an alarm via speaker and personal text to the user if any sensors are breached Visa Status – F1

Contact this candidate