Ajinkya Nikam

Detail-oriented and results-driven Data Analyst with a strong analytical mindset and hands-on experience in transforming complex datasets into actionable insights. Proven ability to interpret and analyze large volumes of data, identify trends, and present findings to support informed business decisions. Proficient in data visualization, statistical analysis, and utilizing tools such as Python, SQL, Tableau, and Excel. Adept at collaborating with cross-functional teams to drive process improvements and optimize data quality. Seeking to leverage a solid foundation in data analysis to contribute to the success of a dynamic organization.

Business Case Study: Target US Retailer Operations in Brazil (2016-2018)   [Using MySQL, Big query, Tableau, Excel]

• Conducted comprehensive sales trend analysis for a US retailer operating in Brazil from 2016 to 2018 using MySQL, BigQuery, Tableau, and Excel.
• Explored year-on-year and month-on-month sales trends through extensive exploratory data analysis.
• Studied the evolution of E-Commerce and its impact on the Brazilian economy, providing insights into customer distribution, average freight value, and potential government revenue through taxes/GST.
• Analyzed freight costs, average delivery time, and payment methods to understand customer purchasing parity.
• Shared strategic data points and recommendations with business stakeholders for improved sales and profits, and enhanced customer targeting.
• Achieved a 20% reduction in query execution time through query optimization.
• Boosted sales by approximately 30% and profit margins by 16% as a result of data-driven insights and optimizations.
• Utilized various SQL techniques, including joins, CTEs, window functions, date & time functions, and query optimizations to complete the project successfully.

• Conducted a thorough case study on Netflix utilizing Python libraries such as Pandas, NumPy, and Matplotlib for data analysis and visualization.
• Analyzed business strategies, content trends, and the competitive landscape to derive actionable insights.
• Contributed to strategic decision-making in the entertainment industry by providing data-driven recommendations based on findings.

• Utilized Python libraries such as Pandas for data manipulation and analysis.
• Applied Matplotlib and Seaborn for data visualization to create charts and graphs.
• Leveraged NumPy for numerical computations and statistical analysis.
• Utilized SciPy for advanced statistical analysis when computing probabilities.

• Computational Fluid Dynamics (CFD) Analysis for Cycling Efficiency: Developed a Python program to simulate airflow over a bicycle, calculating drag forces to optimize cyclist performance and enhance aerodynamics.
• 2R Robotic Arm Kinematics Simulator: Created a Python-based simulator for 2R robotic arms, implementing forward kinematics to model movement and positioning accurately.
• Air Standard Cycle Analysis for Thermal Efficiency: Engineered a Python program to generate the P-V diagram for an Air Standard Otto cycle, enabling calculation of thermal efficiency across varying compression ratios.
• Dynamic Systems Simulation: Designed a Python program to simulate pendulum motion, solving second-order ordinary differential equations and analyzing dynamic system behaviors.
• Optimization and Constraint Minimization: Conducted hands-on constraint minimization exercises, including pen-and-paper calculations and implementing Python scripts to find optimal solutions.
• Newton-Raphson Method for Pressure Optimization: Implemented a Python script employing the Newton-Raphson method to determine the minimum pressure required for breaking ice using an air cushion vehicle.
• Curve Fitting and Parameter Optimization: Applied curve fitting techniques using Python to optimize parameters of defined functions, accurately aligning observations and models.
• IC Engine Data Parsing and Analysis: Conducted comprehensive data parsing and analysis for IC engine simulations, leveraging Python for data extraction, manipulation, and interpretation.

• Company: Krushiraj Agrotech
• Project Objective: Analyzed city gardens' needs to recommend tailored product combinations.
• Client: Sriram Enterprises
• Importance: Critical for securing government orders, strengthening market presence.
• Contribution: Utilized Excel, MySQL, and Tableau for precise analysis and tailored solutions.
• Achievement: Commended for strategic approach, delivering targeted solutions for client satisfaction and effective market positioning.

• Company: Krushiraj Agrotech
• Project Objective: Utilized Tableau to build trust among modern farmers by showcasing product efficacy.
• Client: Well-respected Farmers
• Importance: Demonstrating product effectiveness crucial for gaining trust in modern farming.
• Contribution: Leveraged Tableau for visual representation, highlighting product efficacy for farmer trust.
• Achievement: Acknowledged for innovative use of visualization, aligning with evolving farmer preferences and strengthening relationships with Well-respected Farmers while positioning products as reliable and results-driven in modern farming.

• Formula Bharat (Formula Student India) 2017. 2nd in Acceleration, 4th in Skid-pad, 5th in Autocross, 8th in endurance, 8th in fuel efficiency, 10th overall.
• Supra SAEINDIA 2017.
• Formula Student JAPAN 2016
• Letter of appreciation(Sinhgad Academy Of Engineering).