Data Analyst

PRATEEK KUMAR KANOJE

Worcester, MA ***** Email: *******@***.*** LinkedIn: https://www.linkedin.com/in/prateekkanoje/ Cell: 917-***-**** EDUCATION

Worcester Polytechnic Institute (WPI), Worcester, MA, GPA 3.70/4.0. Expected Graduation: May 2019 Master of Science in Information Technology.

Relevant Coursework: Business Intelligence, Project Management, Introduction to Data Science, Data Mining for Business Applications, Database Application Development, System Design & Development, Innovation with Information Systems. IBS, International Business School, Americas, Sao Paulo, Brazil Dec’18-Feb’18 Certificate Program in Executive Management.

Prestige Institute of Engineering Management & Research, India, GPA 3.89/4.0 May 2016 Bachelor of Engineering in Electronics & Communications. SKILLS & CERTIFICATIONS

Technical Skills: Java, C, C++, Microsoft Suite (Word, Excel, PowerPoint, Access, Project, Visio), SQL, HTML, Tableau, R, JavaScript, Python (NumPy, Pandas, Scikit), SAS 9.4 Base Programmer. Tools: Google Analytics, Tableau, PowerBI, Android Studio, Mendix, IBM Watson Studio, Jupyter Notebooks. Functional Skills: Requirement gathering, Decision making, Change management, Co-creating, Business strategy, Systems thinking.

PROFESSIONAL EXPERIENCE

Graduate Assistant at Worcester Polytechnic Institute. Sep’17- May’18

● Assisted Director of International House with managing student's data and designed English curriculum for international students.

● Handle reports and documents, as a record log of students that enrolled for the Conversation Sessions at WPI.

● Supervised various conversation sessions and mock interviews with international students to practice their English-speaking skills.

● Worked with international students to suggest classes based on their areas of interest and closely monitored and updated their progress. Junior Data Analyst, WebCraft IT, Indore, India Jun’16 – May’17

● Performed Data Management, Data Manipulation, Recovery and Cleansing for complex Client’s data using a variety of python libraries (NumPy, Scikit, Pandas) MS Excel and R.

● Retrieved, Stored and Manipulated the user data with the help of advanced SQL queries.

● Built Visual Analytics using Tableau to derive graphs and actionable intelligence from product clustering results.

● Collaborated with cross-functional teams to modify the client’s requirements and worked directly with the Project Manager to deliver the product on time.

ACADEMIC PROJECTS

Weather Analysis for East Coast SAS, SQLite, MS-Excel: Jan’18 –May’18

● Explored, prepared and analyzed the weather data for East Coast using SAS statistic modelling and MS-excel and performed various operation on data through accessing data using SQL in SAS.

● Validated and categorized storms by combined effects of wind speed and climatic conditions through sub setting rows and computing new columns.

System Analysis, Design and Testing project for Conversation Partners Mendix: Jan’18 – May’18

● Reduced the time of the client and his conversation partners in filling and verifying the feedback forms manually and bring more transparency in the overall system by incorporating a feature of feedback from the TA.

● Elicited requirements from client and developed user stories, project plan and use cases. Developed a web application using Mendix as a development platform for implementation of the project with rapid application development methodology. Performed unit, system and integration testing for the developed application. Prepared user documents such as user manual and reference guide for using the application. Business Intelligence solution for Guitar Centre Tableau, MySQL, Python Aug’17 – Dec’17

● Analyzed the data and formatted it using MS Excel and tableau. Designed sample snowflake schema for the data warehouse. Developed real time operational dashboards for monitoring the sales by the executives and manage store performance by the store managers using Tableau.

● Performed customer segmentation and profiling by location, profit margins, and sales. Used Tableau to design interactive performance dashboards (tactical and strategic) to visualize the key performance indicators for specific users.

● Performed data analysis on the available data of its customers to recommend better products and conjoint analysis and linear regression to advice musical instruments for customers.

Database Management Application for SASA (South Asian Students Association). Aug’17 – Dec’17

● Developed an in-time academical network platform for the WPI’s professors and graduate community, to improve academic and research interests of graduate students.

● Programmed the database using SQLite, Android Studio, and performed functional and implemented the application on various OS versions. CERTIFICATIONS

● Business Statistics and Analysis Specialization, Rice University.

● SAS 9.4 Base Programmer, SAS.

● IBM Data Science Professional Certificate, IBM.

● Advanced Google Analytics, Google.

Contact this candidate