Analyst Intern Program

Kshitij Kamat

*******.*****@***.*** 717-***-**** www.linkedin.com/in/kshitijdkamat

EDUCATION

New York University May 2024

Master of Science in Management of Technology GPA 3.56/4.0 Specialization: Data Analysis

Relevant courses – Data Visualization for Business Intelligence, Statistics for Data Analysts, Operations Management, Business Analytics, Data Management, Tableau, Power BI, Project Management

MIT World Peace University June 2021

Bachelor of Technology in Electronics & Communications Engineering GPA: 3.43/4.0 Specialization: Artificial Intelligence

Relevant Coursework: Data Structures, Algorithms, Object-Oriented Programming, Computer Networks, Data Science, Computer Vision, Natural Language Processing, Big Data Computing, Mathematics for AI. SKILLS

Languages: Python, Scala, SQL. Big Data technologies: Hadoop, Apache Spark, Sqoop, Apache Hive Databases: MySQL, Oracle DB MS Office: MS Word, MS PowerPoint, Microsoft Excel Version Control: Git, GitHub Actions Data visualization tools: Power BI, Tableau Other: Analytical Thinking, Problem Solving, Communication, Time Management, Collaboration, Decision Making, Adaptability, Flexibility WORK EXPERIENCE

Cognizant Tech Solutions Pune, India

Program Analyst July 2021 – June 2022

• Managed the client's business by maintaining accurate asset liquidity to prevent bankruptcy by manipulating code fixes of scala files according to the client's requirements.

• Implemented client requirements through a series of primary meetings to establish consistent communication amongst multiple teams mainly based in Poland and the United States of America.

• Streamlined code efficiency and visibility by meticulously traversing Scala files and directories to eliminate obsolete code, and optimized data import processing time by 65% to capture results faster from Oracle database onto Hadoop.

• Proficiently executed complex SQL queries on the Hadoop platform, to perform rigorous data analysis and validation of precise fund calculations for clients' businesses.

• Incorporated the use of GitHub for version control to create new branches from existing ones and merge/update new code with the existing ones.

• Collaborated with the Scrum Master to streamline task allocation and boost team productivity by utilizing Agile JIRA software to create and link tickets, thereby enabling effective tracking of task progress and enhancing organizational efficiency.

• Developed comprehensive information documents to enhance team knowledge and boost morale by disseminating information on new technologies used in the project.

Program Analyst Intern Feb 2021 - June 2021

• Learnt the use of various Big Data related applications to perform Cognizant projects and help improve clients' business.

• Designed an emulated banking system using multiple big data storage and processing tools like SQL to execute queries, Sqoop for data migration, Hadoop for data storage, Hive, and Spark to process and store data.

• Received certification for successfully cracking every assessment held by the Cognizant HR department focused on communication and public speaking exercises to communicate clearly and efficiently across multiple teams. PROJECTS

Fashion Analytics Using Tableau

• Extrapolated consumer and sales information from the chosen retail store dataset to gather insights on consumer behavior.

• Derived customer and consumer Key Performance Indicators (KPIs) like gross income, net sales, and profit to understand which profiles mark the company's biggest sales.

• Created visualizations with the help of Tableau to display meaningful charts of the derived KPIs to judge and predict the selected fashion retail store's performance and determine which areas to target that need improvement. Stock Data Analysis Using Linear Regression

• Conducted regression analysis using statistical software packages of Python, to compare ABT stock’s data with market risk-free rates.

• Evaluated the significance of the regression model and conducted a residual analysis to identify outliers and improve model performance.

• Used the linear regression model to judge key stock parameters, predict stock prices, analyze market trends, and make investment decisions.

• Evaluated the predictive power of linear regression models by measuring their accuracy and error rates using metrics such as R- squared, mean squared error, or root mean squared error.

• Presented analysis and insights to the professor and fellow peers, utilizing models to support investment recommendations. PUBLICATIONS

Machine Learning Based Essay Grading, IJRASET

International Journal for Research in Applied Science and Engineering Technology, Paper ID: IJRASET36180 CERTIFICATIONS

Business Analytics and Management Decisions NPTEL

Contact this candidate