Ranjit Kumar Rout
Bengaluru
Summary
Dynamic Senior Project Engineer with extensive experience at Wipro Technologies, specializing in Microsoft SQL Server and Agile methodologies. Proven track record in optimizing database performance and enhancing project outcomes through effective collaboration and leadership. Adept at incident management, ensuring seamless operations while driving continuous improvement initiatives.
Overview
10
10
years of professional experience
Work History
Senior Project Engineer:Windows Platform & PL-SQL
Wipro technologies: Greater Toronto Airports Authority
Bengaluru
11.2022 - Current
- Developed PLSQL stored procedures, functions, and packages to meet application development needs.
- Conducted performance tuning through indexing and table partitioning for optimized database operations.
- Managed virtual machines and applications for system maintenance and upgrades.
- Regularly patched Windows servers to ensure seamless application functionality.
- Implemented disaster recovery activities and automated processes to enhance application performance.
- Collaborated cross-functionally to improve task efficiency and project outcomes.
- Identified system improvement opportunities, recommending effective optimization strategies.
- Facilitated Scrum ceremonies to drive effective project planning and execution.
SQL Server Database Administrator
Wipro technologies: L'Oreal USA
Bhubaneswar
07.2020 - 10.2022
- Conducted root cause analysis to diagnose issues with database systems.
- Established security controls to protect client systems effectively.
- Performed database performance tuning to enhance overall efficiency.
- Managed backup and recovery procedures to safeguard critical information.
- Collaborated with IT team to integrate databases with various applications.
- Created tables, views, functions, stored procedures and other database objects.
Project Engineer: Incident Manager
Wipro technologies: Shell
Bengaluru
11.2016 - 06.2020
- Established hosting for each website and completed go-live process by uploading sites to host accounts.
- Monitored system performance and generated reports to track operational efficiency.
- Translated client requirements into actionable tasks and product stories for development teams.
- Troubleshot, tested, and resolved issues prior to software deployment.
- Reviewed project specifications and devised scalable solutions for multiple websites.
- Implemented enhancements to optimize site performance across all platforms.
- Conducted backups of web files to local directories to ensure data preservation.
- Managed database security, backup, and recovery procedures to safeguard information.
- Provided guidance on response strategies for critical incidents.
- Identified potential risks and created plans to mitigate them.
- Prioritized each incident based upon its impact on business and escalated issues considered major threats.
- Documented all major incidents, including details such as timeline, key players involved, root cause analysis.
- Collaborated with cross-functional teams to identify root cause of Major Incidents, develop solutions and prevent future occurrences.
- Met with stakeholders to collaborate and resolve problems.
ASP.NET Developer
Wipro technologies: Lloyds bank
Bengaluru
11.2015 - 11.2016
- Translated client requirements into product stories and actionable tasks for development.
- Configured web services to facilitate data integration between two systems.
- Validated code for structural integrity, security measures, and cross-browser compatibility.
- Managed source control repositories using GIT and SVN for effective version control.
Education
Master of Science - Computer And Information Science
Vellore Institute of Technology
Chennai06-2020
Bachelor of Science - Computer Science
Ravenshaw University
Cuttack06-2015
Skills
- Microsoft SQL Server and database management
- PL/SQL development
- Data integration and performance tuning
- Query optimization
- Backup and recovery
- Root cause analysis
- Incident management and ITIL framework
- Azure devops
- Agile methodologies
- Software licensing and patch management
- Web services integration
- Project management
Timeline
Senior Project Engineer:Windows Platform & PL-SQL
Wipro technologies: Greater Toronto Airports Authority
11.2022 - Current
SQL Server Database Administrator
Wipro technologies: L'Oreal USA
07.2020 - 10.2022
Project Engineer: Incident Manager
Wipro technologies: Shell
11.2016 - 06.2020
ASP.NET Developer
Wipro technologies: Lloyds bank
11.2015 - 11.2016
Master of Science - Computer And Information Science
Vellore Institute of Technology
Bachelor of Science - Computer Science
Ravenshaw University
Similar Profiles
Praveen Kumar VakkanthulaPraveen Kumar Vakkanthula
IT Operations Head & Digital Transformation Lead at Toronto Pearson Airport | Greater Toronto Airports AuthorityIT Operations Head & Digital Transformation Lead at Toronto Pearson Airport | Greater Toronto Airports Authority
SAKINA KHANSAKINA KHAN
Screening Officer at Canadian Air Transport Security Authority, CATSA, GARDA World, Greater Toronto Airports AuthorityScreening Officer at Canadian Air Transport Security Authority, CATSA, GARDA World, Greater Toronto Airports Authority
Zefra PileggiZefra Pileggi
Pass Office Coordinator at GREATER TORONTO AIRPORTS AUTHORITYPass Office Coordinator at GREATER TORONTO AIRPORTS AUTHORITY
Rakshith Yogamurthy MakkinniRakshith Yogamurthy Makkinni
Construction Manager at YGR CorpConstruction Manager at YGR Corp
PARTHIV RAJAGOPALPARTHIV RAJAGOPAL
Associate System Engineer at THOMSON REUTERSAssociate System Engineer at THOMSON REUTERS