Data Analytics

Karan Haresh Nawani

adysuk@r.postjobfree.com Phone No: +1-862-***-**** LinkedIn - Karan Nawani

A motivated and teamwork-oriented analyst with the ability to generate actionable and meaningful insights by analyzing organizational data and making data-driven decisions to ensure profitability and process optimization for an organization. Education

MS in Management and Business Analytics NJIT, New Jersey, USA Sept 2021 – May 2023 Relevant Coursework: - Data Mining and Analysis, Corporate Finance, Project Management, Decision Analysis, Digital Marketing Strategies, Management Information Systems, Global Marketing Management Bachelor of Engineering in Information Technology TSEC, Mumbai, India Aug 2016 – Sept 2020 Relevant Coursework: - Data Mining and Business Intelligence, Software Engineering Project Management, Database Management Systems, Operating Systems, Data Structures and Analysis, Cloud Computing, Big Data Analytics Skills

Business Intelligence :-

Tableau, Power BI, SAP (S4 HANA, SAP Analytics Cloud), MS Excel, SSAS Programming & Analytical :-

R (GG plot, Plotly), SQL (MySQL, MSSQL, NoSQL), Python (Jupyter, VS Code), RESTAPIs Work Experience

Pricing Data Analyst Intern at Mohawk Industries Calhoun, Georgia, USA May 2022 – June 2023

● Analyzed sales, operations, and product pricing data from SAP of 2 million + records to provide actionable insights by creating various visualization dashboards in Power BI and SAP Analytics Cloud

● Collaborated with cross-functional teams to create a Price-Volume-Mix dashboard on SAP Analytics Cloud / Power BI to validate price increases, leading to an increase in price capture efficiency by 7%

● Analyzed and optimized the freight pricing architecture of the organization by 13% by creating freight pricing dashboards using Power BI, SQL, and SSAS

● Analyzed complex data and examined industry standards to help the FP&A team to determine and set competitive prices Analyst at Saffron Stays Mumbai, Maharashtra, India Oct 2020 - March 2021

● Conducted client-company negotiations and demonstrated leadership, analytical skills, and sound business acumen while onboarding homes for the Saffron Stays network.

● Developed a comprehensive Tableau dashboard integrated with MySQL, providing the home acquisition executives with seamless access to actionable insights and facilitating data-driven decision-making.

● Created a home acquisition tracker in Microsoft Excel which was referred to by the management executives of the company to keep track of the progress of that specific home which increased the tracking efficiency by 35% Analytics Intern at Saffron Stays Mumbai, Maharashtra, India June 2020 - Oct 2020

● Created a performance analysis dashboard in Tableau that tracks financial KPIs based on MoM revenue for all gold and silver category homes

● Created a lead generation model for the potential homeowner network using the current homeowner database using Excel

-+which scaled up our leads by 30%

Projects

Real-Estate Analysis using Tableau Oct 2022 - Nov 2022

● Utilized REST API to access real-time market data, including home prices, location, and other key performing metrics to design a MySQL database schema to efficiently store and manage real estate data.

● Created comprehensive and insightful visual representations in Tableau, including geographical analyses, bar graphs, and time-series charts in to summarize key findings and recommend actions for stakeholders. Automobile Sales Projection Using R Programming Sept 2019 - Oct 2019

● Estimated automobile sales using attributes such as make, model, year, engine, and other properties.

● Performed cleansing and exploratory data analysis to gain maximum insights from the data and its underlying structure, and patterns.

● Employed a regression analysis statistical tool to develop a relationship model between two dataset attributes.

Contact this candidate