Rishabh Awatani Email & Phone Number

Toronto, On, Ca

Toronto, Ontario, Canada

Toronto, Ontario, Canada

Spearheaded integration with Open AI utilizing LangChain and CrewAI to implement a multi-agent system allowing text-based interaction with the services offered by the product.Developed agent-based LLM systems consisting of 3 specialized agents capable of interaction and task coordination to interact with the product APIs by performing RAG over the existing OpenAPI documentation enabling seamless integration of existing user journeys and workflow.Designed SQL/TSQL analytics queries for the in-house analytics portal that spanned across a wide range of relations querying data for over a million rows in a complex database.Implemented the knowledge graph to store and process semantic data about the organization’s physical and logical structures in a Neo4J graph database which was consequently used in downstream recommendation systems.Created meeting room panel application supporting near real-time communication over 10,000 rooms simultaneously showcasing proficiency in Socket and Streaming services with high data throughput.Improved backend response time from 4 seconds to 6 milliseconds by migrating complex analytics calculations and aggregations to efficient SQL/T-SQL queries.Enhanced container deployment by reducing build size by 70%, resulting in a 10x improvement in deployment speed.

Gathering product insights and usage metrics using Segment Twilio, Mixpanel and Google Analytics.Using JavaScript to inject scripts into front-end and back-end for user behaviour trackingCreating dashboards in Mixpanel to visualize key conversion, engagement and activity metrics such as DAU, MAU, Session Length, Feature Success etc.Served as a liaison between stakeholders and the engineering team to gather and document analytics requirements and effectively implement them with the engineering team.

Dubai, United Arab Emirates

Collaborated in the development of a React Charts dashboard by writing complex SQL/T-SQL queries using JOIN, GROUP BY, ORDER BY, Window Functions and Sub QueriesImproved backend response time from 4 seconds to 6 milliseconds by migrating complex calculations to efficient SQL/T-SQL queries.Successfully conducted regular database migrations for both Postgres and MSSQL ensuring seamless integration of new changes.Utilized Tableau to create dynamic O365 dashboards, reducing average waiting time for room booking by 60%.Utilized ADF to seamlessly transfer data from an on-premises MSSQL server to Azure Synape, facilitating data visualization in Power BI and leading to a 25% improvement in room utilization, ultimately saving clients over 300 hours of resource allocation.Proficiently deployed applications on Azure Kubernetes Service and GCP Cloud Run ensuring scalability, reliability, and optimal performance.

Dubai, United Arab Emirates

Collaborated with several cross-functional teams to streamline communication and solutions delivery,effectively completing a major project 2 months ahead of the deadline.Contributed towards development, testing and maintenance of the Java-based integration platform introducing 3 major integrations with Jira, Whatsapp and Amazon Alexa.Fielded and educated 4 enterprise clients about the offered ITSM software and in-house integrationplatform, successfully acquiring them which resulted in a revenue of about 3.2 million USD

Postgraduate Degree, Business Insights And Analytics

Acquired a deep understanding of data ETL/ELT lifecycle including sourcing, cleaning, munging and data management concepts like governance.

Bachelor Of Computer Application, Computer Science, 8.1

Learned and practised several Object Oriented and Functional programming languages like C, Java, JavaScript, C++, and Python. Implemented.