GURJOT SINGH

MBA Graduate and versatile professional with 2 years of work experience as an MIS analyst, Business development executive, and operations associate. Expertise lies in collecting, processing, and analyzing large datasets using tools like MS Excel, Power-BI, and SQL, for practical data interpretation. Skilled in Creating detailed reports and visualization Dashboards, enhancing strategic decision-making. Collaborated with clients, conducted requirement analysis, and maintained daily sales operations, ensuring productivity goals. Managed student data, encompassing document verification, and create insightful dashboards for data-driven decision-making. Expertise in overseeing inbound deliveries, ensuring accuracy, and cultivating positive client relationships. MBA in Logistics Supply Chain and Marketing and B.Tech in Mechanical Engineering. Certified in Data Analytics Essentials (Cisco) and Data Analysis with Python (IBM). Applied skills in real-world projects, including building relational databases in SQL and developing a pricing model for a smartwatch company. Seeking an analyst role to contribute analytical expertise and drive organizational success.

• Car Sales Dashboard (Tool Used : Power-BI, DAX)
• Objective - Design and development of a comprehensive Car Sales Dashboard for a car dealership company. The project aimed to provide real-time insights on key sales KPIs, including YTD and MTD sales, average prices, and cars sold metrics. Implemented visualizations like weekly sales trends, body style/color distribution, regional sales mapping, and detailed sales information grids. Demonstrated expertise in data analytics and visualization for informed decision-making and business growth

• Data Analysis with Python, IBM (Tool Used : Python , Python Libraries)
• URL - https://coursera.org/verify/KGPUYNJV4PH4,
• Objective - Apply data analysis and modeling techniques to predict house prices based on various features like square footage, bedrooms, and floors. Utilize statistical and machine learning methods for precise predictions in real estate. Employ diverse attributes to enhance accuracy and contribute to informed decision making.

• Building Relational database in SQL, Coursera (Tool Used : SQL)
• URL - https://coursera.org/verify/FNEMA24KDPQU,
• Objective - Gain an elementary understanding of SQL Server Management Studio. Build a simple query and deploy it in SSMS. Create and run SQL Queries to create tables and columns and get valuable insights from data.

• Pricing Model for Smartwatch Company, Bluetick.AI (Tool Used : Excel, Power-BI)
• Objective - Build a spreadsheet model to calculate a suitable selling price for smartwatches, so the company can make a profit margin of at least 2% and sell not less than 1800 smartwatches a day, to gain a 5% market share.

Data Analytical Essentials : Cisco Network Academy.

Data Analysis With Python : IBM.