Kratik Mehta Email & Phone Number

Pune, Mh, In

Bengaluru, Karnataka, India

• Developed and maintained an Analytical DataMart for an educational domain client, enhancing data accessibility and analysis.• Automated ETL workflows using N8N and Python to schedule daily tasks, such as retrieving contact and company data from HubSpot, reducing manual effort and increasing productivity.• Created and deployed Lambda functions to streamline data automation processes.• Engineered a web scraper with Python and Selenium to automate the retrieval of School Accountability Report Cards across various California school districts, significantly reducing manual effort and improving data collection efficiency.• Designed and implemented an automated document scraper for extracting curriculum information from HTML and PDF School Accountability Report Cards, integrating the data into a Postgres database to streamline the data entry process.• Constructed interactive dashboards using Looker Studio to analyze Google Analytics data, including website traffic, page views, conversions, and form submissions, providing valuable insights for informed decision-making and optimization strategies.

Bengaluru, Karnataka, India

Project: EV Market Segmentation in India• Analyzed the Indian EV market and identified two potential target segments: Younger, less well-off professionals who are looking for affordable cars, and middle-aged, well-off professionals who are looking for expensive cars.• Developed a marketing mix for the ideal target segment: The EV should be affordable, efficient, and stylish. It should also have a range that is suitable for Indian driving conditions.• Used data science and machine learning to identify the target segments: The data was collected from a variety of sources, including government data, market research data, etc.Project: AI Product/Service Prototyping for Small Businesses• Developed an abstract prototype for an AI-powered inventory optimization solution for small and medium businesses, leveraging machine learning and predictive analytics techniques.• Conducted comprehensive market research and needs assessment to identify inventory management challenges and design a solution aligned with business requirements.• Implemented and validated the solution using Python, incorporating demand forecasting algorithms, optimization strategies, and actionable insights for improved inventory performance and decision-making.

Pune, Maharashtra, India

• Created, maintained the Test reporting using SQL and MS Excel and improved documentation for quality tests and activities.• Application testing (manual), Source vs target data testing using SQL scripts.• Generate data difference report.• Reduced product defects and the number of rejected items by working with the production team on long-term solutions, resulting in a 20% increase in product quality.• Collected and analyzed routine samples to evaluate the quality of daily production.• Created, maintained, and improved documentation for quality tests and activities, with an average of 30 new pages each month.

Pune, Maharashtra, India

• Planned and scheduled training seminars for novice and expert users of CAD software to increase their productivity.• Collaborated with CAD software experts to gather product information for learning solutions' design and development, resulting in improved knowledge transfer metrics.• Maintained Computer-Aided Design expertise through personal research and Continued Professional Development (CPD), which resulted in the training of staff on new software, and the design and printing of new products for the company.

Post Graduate Program, Data Science And Business Analytics, 4.03 Gpa

Texas McCombs School of Business

Bachelor Of Engineering - Be, Mechanical Engineering, 75%

High School Diploma, Science, 83%