Rishi Agarwal

Rising Codementor

US$15.00

For every 15 mins

Sessions/Jobs

ABOUT ME

Software Engineer, Tech Lead & SQL Developer

I have 14 years of experience in developing software in which I have undertaken different roles - from being a database designer & SQL developer to maintaining middle layer in Java and front end in VueJS. I also lead software teams to ensure the timely release of the software. I believe that software should be designed that it is functional and usable by the end customer.

Hindi, English

New Delhi (+05:30)

Joined November 2018

EXPERTISE

MySQL

10 years experience

Been a strong user of MySQL and used it many projects. I know all the nuances of MySQL and designed MySQL database using the right type ...

Been a strong user of MySQL and used it many projects. I know all the nuances of MySQL and designed MySQL database using the right type of options. I ensure that right table option is selected, all the Primary keys, unique keys and indexes are set. Have optimized mysql queries effectively and also tweaked database server configuration according to the type of applicaiton. Enabled replication and backup too.

Software Development

14 years experience

I have worked on full stack of developing software and also led software teams. I understand client requirements very well and ensure tha...

I have worked on full stack of developing software and also led software teams. I understand client requirements very well and ensure that clean code is written that meet best coding practices.

Java

14 years experience

Have worked on enterprise software using JSP, Servlets & Apache Ofbiz that managed orders and accounting. Have been an avid user of open ...

Have worked on enterprise software using JSP, Servlets & Apache Ofbiz that managed orders and accounting. Have been an avid user of open source stack like Java since the start of my career.

SQL

10 years experience

Started career with Oracle/PL-SQL, then moved to MySQL and SQL Server where I designed complex databases for Web and Mobile software. I a...

Started career with Oracle/PL-SQL, then moved to MySQL and SQL Server where I designed complex databases for Web and Mobile software. I also enabled database backups and replication. I optimized queries and built database objects like stored procs and triggers relevant for the tech stack. I also built data warehouses and pipelines to collect data into them.

MongoDB

4 years experience

Have been using Mongo for many projects lately for the ease of storing data.

Vue.js

2 years experience

I have used VueJS with Vuex and other UI toolkits for Vue to build awesome looking UI. I find VueJS a really good framework for frontend.

Git

8 years experience

REVIEWS FROM CLIENTS

Rishi's profile has been carefully vetted and approved as a Codementor. Connect with Rishi now, and leave a review for them once you're done!

SOCIAL PRESENCE

Stack Overflow

1195 Reputation

Community Posts

Using Multiple Sequences in a Table

Recently, I wanted to use multiple sequences in a table. I wanted to generate a new sequence for every event for the id of its registrants. The table structure was something like this : CREATE TAB…

‘EXISTS’ is better than ‘IN’

While working on my last project, I was facing a query which was taking 30 second to execute. The number of tables involved were 10 and total records were around 20k. It was a search functionality…

Use ANSI Style for MySQL

I prefer to use ANSI style for writing MySQL queries. When I started working on SQL, I used the old style aka Theta style for all my queries. Example of a query in Theta style : SELECT e.title, …

EMPLOYMENTS

Founder

Arvan Technologies Pvt Ltd.

2010-11-01-Present

I have led teams to deliver projects for both startups & enterprise. I ensure that the correct requirements are understood by all stakeho...

I have led teams to deliver projects for both startups & enterprise. I ensure that the correct requirements are understood by all stakeholders of the project and deliverables are completed for every milestone. We have worked on web and mobile app projects and delivered solutions for cloud. We also help companies upgrade their legacy software to modern UI apps that work across phones, tablets and desktops. I worked on Java, Spring Boot, Sencha ExtJS, VueJS, Postgres, MySQL and built full stack applications using these technologies.

Java

MySQL

Microsoft SQL Server

Java

MySQL

Microsoft SQL Server

Ext JS

Co-Founder

Thinkingspace Technologies Pvt Ltd

2007-04-01-2010-10-01

In the Web 2.0 era, I was handling the database design & development in MySQL and Microsoft SQL Server. I have designed complex database ...

In the Web 2.0 era, I was handling the database design & development in MySQL and Microsoft SQL Server. I have designed complex database applications here, optimized SQL queries and enabled DB backups and replications. I also worked on Wordpress to launch websites and maintained web apps in Java/Java EE. We developed full-stack web applications for various clients in sectors like event management, F&B, media. We developed desktop software using SQLite for security agencies to analyze call records and built a SaaS data warehousing application in MySQL.

Java

MySQL

WordPress

Java

MySQL

WordPress

Java EE

Microsoft SQL Server

SQL Developer

Persistent Systems Ltd

2006-07-01-2007-03-01

I worked as a Junior Developer here on Oracle/PL-SQL for enterprise software to track insurance claims from hospitals. It was my first ex...

I worked as a Junior Developer here on Oracle/PL-SQL for enterprise software to track insurance claims from hospitals. It was my first experience on SQL and I loved the capabilities of what SQL can do. I built complex objects like stored procedures and triggers to query and process data spread over a complicated relational database.

SQL

Oracle

SQL

Oracle

PROJECTS

Insights DSS

Sapience

2010

This was a SaaS based web application that would enable executives of Small and medium sized enterprises to analyze their company perform...

This was a SaaS based web application that would enable executives of Small and medium sized enterprises to analyze their company performance. This was built using ASP.NET C# and a data warehouse built on MySQL. A pipeline was created to gather data from legacy databases and data was stored in the data warehouse. Then data analysis was done on the star schema.

MySQL

Data warehouse

MySQL

Data warehouse

Treadstone

2008

This was a desktop-based application used by law enforcement agencies to track and analyze call records. Data was imported from CSV into ...

This was a desktop-based application used by law enforcement agencies to track and analyze call records. Data was imported from CSV into an SQLite database and complicated queries were executed to pinpoint the crime event.

SQLite

Desktop Applications

SQLite

Desktop Applications