Sanjay Mohan Email & Phone Number

Liverpool, GB

Liverpool, England, United Kingdom

• Conducted detailed data analysis utilising SQL queries on user engagement and purchasing behaviour, resulting in a 25% improvement in customer retention and a 20% increase in average order value.
• Implemented Tableau to design and manage a comprehensive financial dashboard, facilitating tracking sales trends and profitability analysis for different food categories. This initiative led to strategic pricing.
• Utilised SQL and Excel to create and manage predictive analytics models, enabling accurate demand forecasting and reducing excess inventory by 15%, minimising food wastage.
• Applied Python extensively for data extraction and analysis to spearhead the implementation of a personalised recommendation system. The system, integrated with the platform, increased upsell and cross-sell.
• Successfully configured high-performing business models and mapping layers, logical tables/dimensions, columns, logical joins/keys, and set levels to support drill-down, aggregation/sum over columns to make business.
• Built SQL source queries equivalent to the BI reports for validation and troubleshooting.

Liverpool, England, United Kingdom

• Implemented an innovative location-based and preference-driven food ordering platform, resulting in a 20% increase in average order value and a 25% growth in monthly active users.
• Fostered partnerships with the University of Liverpool and SciTech Daresbury's Digital Innovation Team, leading R&D initiatives for future advancements, such as developing automated kitchen technologies and exploring.

London, England, United Kingdom

• Collaborated with Stakeholders to create and map the new request and response messages of older IATA standards of Emirates, Singapore Airlines and Condor airlines using Graphql and SoapUI during the development of a.
• Worked on implementing NDC content APIs and the adapter framework, which can translate and manage messages exchange between the NDC standard chosen by each airline and a content subscription model for configurable.

Bangalore, India

• Automated end-to-end test cases for Encova insurance company based on guidewire, which is hosted on both desktop and mobile devices, and developed internal testing Infrastructure tools to improve the efficiency of the.
• Partnered with Client developers to script and document test cases for consumer line and personal line insurances, including personal auto insurance and Inland Marine insurance.
• Automated 75% of the manual test cases by designing test scenarios in ReadyAPI, JUnit and Cucumber along with Jenkins for continuous integration to schedule and run the automated test cases in the pipeline.
• Responsible for writing, redesigning, and maintaining Selenium WebDriver scripts for regression and functional testing using TestNG and a data-driven framework with Apache POI API. Identified test scenarios, estimated.
• Implemented automated test suites using Selenium WebDriver and Microsoft Azure DevOps for a cloud-based insurance application, ensuring robust test coverage across different environments.
• Conducted non-functional testing, including performance testing using tools like Apache JMeter, to assess the scalability and reliability of Encova's insurance platform under various load conditions.

Kochi, Kerala, India

• Developed UX features for a menu management platform, increasing the speed of order placing and improving the turnaround for delivery. Developed a presentation layer (web forms) using asp. Net, HTML and C

Bengaluru Area, India

Worked in field of Marketing and Direct sales including both Business to Business and Business to Customer sales.Was part of the team who conducted direct and online surveys for the purpose of marketing and Lead generation.

Master Of Science - Ms, Business Analytics, Distinction

Bachelor’S Degree, Computer Software Engineering