Nayan Kumar

Jersey City, NJ ***** adb75d@r.postjobfree.com 201-***-**** www.linkedin.com/in/nayank

EDUCATION

Pace University, Seidenberg School of Computer Science and Information Systems New York, NY

Master of Science in Information Systems GPA: 3.66 May 2020

Rajiv Gandhi Technical University, Sanghvi Innovative Academy Indore, India

Bachelor of Engineering in Mechanical Engineering December 2015

RELEVANT COURSEWORK

Big Data & Information Systems Data Warehousing and Data Mining Database management system Analytics Information System Project & Change Management Information System Design and Development Business Analytics for Decision Making

Business Telecommunications Database Programming Geographical information system Web Design and Development

TECHNICAL SKILLS

Programming Languages: Python, Hadoop, My SQL, NoSQL database, Java (Intermediate), HTML, CSS 3, PHP.

BI Tools: PowerBI, Tableau, SharePoint.

Operating Systems: Windows, Mac, Linux

Database: Microsoft SQL Server, Azure, AWS, OLTP.

Microsoft ETL Tools: SSRS, SSIS, SSAS.

Software: Microsoft SQL Server Management Studio, CRM, Microsoft office and Viso.

Skills: Agile software development, Project management, Scrum, EDI, SDLC.

ACADEMIC PROJECTS

Project Title- Comparing the obese people who are 20 years and above in different areas (GIS) December 2019

Worked individual created layout map of Jersey City counties by using ArcMap software

The base map consists of residential area and roads

By using ArcMap software and Microsoft Excel filtered the data by using attributes of Jersey City counties.

Identified the counties with high or low health department or obese people who are 20 year above.

Project Title- Home Space furniture in Data base management system December 2018

Worked in a group of four to create a database for a furniture store using MS Access

Wrote supplemental queries in SQL and manage the database.

The store had many problems, in terms of, recording and managing their products. Now they can easily maintain the records of current stock, remaining stock, as well as, out of stock items

EXPERIENCE

Playbook Jersey City

Operational and Data Analyst intern September 2019 – December 2019

Worked alongside with CEO and COO across functional projects

Generated, Maintained, Designed and Developed Data reports by using Tableau for visualization creating dashboard, Excel for data preparation and analysis and Jira

Using power BI generated reports for visualization and data modeling

With the help of ETL load designed and developed SSRS reports

Working with project management and spreadsheet tools

Abhyudaya Multimedia Madhya Pradesh, India

Data Analyst July 2016 - June 2017

Performed data manipulation, sorting, filtering, vitalization of data and analyzed the data using pivot tables using SQL queries and no squeal.

Developing the primary interactive shell of the project by using IPython

Analyzed Data by using Pandas Library and pandas’ group to facility, summarize, dice, slice of the Data file.

Vitalization the static of data by using matplotib

Interpreted data using Hadoop and analyzed results using statistical techniques and assisted associates by performing data compiling and mining to sort data.

Contact this candidate