Ravikant Patel
Senior Software Engineer
Kolkata
Summary
Proven Database Developer and RPA Developer at Wipro Technologies, adept in SQL development and enhancing team productivity. Expertise in optimizing database performance and leading innovative automation solutions. Demonstrated success in improving system stability and project outcomes through advanced SQL queries and effective collaboration.
Overview
6
6
years of professional experience
Work History
Database Developer (SQL)
Wipro Technologies
07.2021 - Current
- Ran specified, registered stored procedure, optionally including one or more arguments for the specified stored procedure.
- Designed SQL queries based on the scenarios and applied them in the project work.
- Enhanced database performance by optimizing SQL queries and indexing strategies.
- Designed and developed customized extract, transform, and load (ETL) applications per client specifications.
- Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Maintained high-quality code standards through rigorous testing and peer code reviews, minimizing potential bugs and security vulnerabilities.
ServiceNow Administrator
Wipro Technologies
07.2021 - Current
- Implemented advanced scripting techniques to automate routine tasks, saving time and resources for the IT department.
- Spearheaded initiatives aimed at improving ITIL compliance within the organization using the features offered by the ServiceNow platform.
- Conducted regular audits of system architecture to identify opportunities for optimization or enhancement.
- Assisted in successful system upgrades by conducting thorough testing and addressing potential compatibility issues in a timely manner.
RPA Developer
Wipro Technologies
05.2018 - Current
- Worked as an RPA verification engineer.
- Did validation of bots signoff on a daily basis.
- I was involved in audits as well.
- Worked on unassigned bots (assigning unassigned bots to existing bots or creating a new bot).
- Worked on SQL Server Management Studio.
- Worked on daily reconciliation, creating and sending reports to client.
- Did modification on bots and their properties, such as changing schedule, auto-signoff schedule, assignee, etc.
- I also have knowledge of the control room and checking bot progress in the control room.
- Established strong working relationships with clients to ensure clear communication of expectations and requirements throughout the project lifecycle.
- Identified potential risks early in the process, allowing proactive mitigation measures to prevent delays or setbacks.
- Enhanced team productivity with regular progress meetings, thorough task allocation, and prioritization of tasks based on urgency and importance.
- Led development of innovative solutions that addressed complex technical challenges, contributing to successful project outcomes.
Education
Master of Technology - Software Engineering
Birla Institute of Technology & Science
Pilani, India 04.2001 -
Bachelor of Computer Applications - Computer Science And Programming
Aryabhatta Knowledge University
Patna, India 04.2001 -
Skills
SQL development
SQL analytics
Advanced SQL Queries
Stored Procedures
Robotic Process Automation
Automation Anywhere
SQL Database Management
API Development
SLA Configuration
ServiceNow Development
Service Catalog Management
Problem Management
Languages
English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
Cricket
Apart from my professional work, I like to play cricket and also like to watch cricket matches. I was also captain of my village cricket team when I was teen. Whenever I get some time off from my work I love to enjoy cricket.
Timeline
Database Developer (SQL)
Wipro Technologies
07.2021 - Current
ServiceNow Administrator
Wipro Technologies
07.2021 - Current
RPA Developer
Wipro Technologies
05.2018 - Current
Master of Technology - Software Engineering
Birla Institute of Technology & Science
04.2001 -
Bachelor of Computer Applications - Computer Science And Programming
Aryabhatta Knowledge University
04.2001 -