Shalvi Rana

Working in consulting in the IFMS module for the Rajasthan government.

• Increased Vendor service success rates by quickly resolving issues.
• 
  

• Working for BMW NBFC for their Loan Management System.
• Migrated 100% Data from their old system to OmniFin system.
• Wrote Procedures, triggers, packages for Booking, Restructuring, Receipt Upload of Loan.
• Wrote complex SQL queries to help fetch Loan Data for customer in application.
• Wrote Email/SMS procedure to send updates of Loan to respective customers.
• Tuned existing stored procedures for Performance.

• ●Built complex queries using SQL and wrote procedures, functions, triggers, and packages based on change using PL/SQL.
• ● Performance Tuning and enhancement of Stored Process.
• ● Moving t data from flat files to tables using SQL loader using Shell script on Putty.
• ● Development for standard Release Cycles(3-Month) According to requirements given by customer, following.
• ● Worked on Achieving ALWAYS ON Architecture for Database.
• ● Performed DR (Disaster Recovery) Activities for Database.
• ● Risk Assessment and Management for Deployment.
• ● Maintained Database Health and Stability along with debugging issues and resolving them quickly to avoid user escalation.
• ● Involved in Transformational Activities like Golden Gate Implementation, Always On , Dual DB Links via Load Balancer , XFB Failure Maintenance.
• ● Grooming Junior team members about project and transferred knowledge of same.

• Developing Unix shell scripts to call stored DB objects and spool data in files.
• XFB Files to third system and Schedule jobs via Cron.
• Achieved Dual Database Link Via Load Balancer incase of Disaster to keep application up and running.
• Achieved Dual XFB system via DNS implementation and Switch during disaster.
• Automated tasks to reduce labor costs and increase productivity.
• Worked as Designer for team for short span of time and understood problem and created solution for same.
• Performed root cause analysis to provide resolutions for production issues.
• Collaborated with clients to determine need and devise appropriate solutions.