Ravi Ranjan Shandilya

• Company Overview: A leading financial corporation based in the U.S.

CMS: - Control Management System (2018-Present)

• Designed various RSA Archer-based solutions.
• Enhanced compliance-focused business application.
• Crafted robust DDE business logic.
• Created data feed code and linked it with Autosys for smooth operation and upfront failure notification.
• Stabilized network pathways for improved communication.
• Refined query development and increased speed.
• Revamped system design to enhance app performance.

TrBIS: - Treasury and Banking Information System (2016-2019)

• Administered Vostro accounts operations efficiently.
• Managed complex data storage for S.W.I.F.T payment systems.
• Report development and generation.
• Implemented regulatory protocols to ensure proper removal of outdated information.
• Coordinated the process for releasing and handling code requests.

Project Life cycle reports (2011-2016)

• Designing the data flow model for the migration.
• Tuning of the process.
• Created the technical design document for the migration from Access 2007 to Oracle 10g.
• Involved in OLAP database modeling.
• Design and writing of procedures and functions for SSRS reports.
• Developed reports using SSRS, using Oracle 10G and SQL Server 2012 as databases.
• Tuning of the stored procedure and SSRS report.
• Monitoring and participating in the coding, and making sure to resolve all technical issues/problems.
• Engaged in creating and structuring OLAP databases.
• Ensured quality and functionality through meticulous package and report tests.
• Earned a credential from IIT-K in developing Blockchain Architecture and Use Cases.
• Awarded Gold and Silver Awards by stakeholders for excellence.
• Database:-Oracle 10g,Sql Server 2008,OBIEE,SSIS,SSRS Tools Excel, Toad.

• I worked in the insurance domain with a financial company, Royal Bank of Canada.
• Database migration from SQL Server 2000 to SQL Server 2005.
• Financial report development for mass marketing for client RBC.
• Database: SQL Server 2000, SQL Server 2005.
• O.S :- Windows 2003
• Client: Royal Bank of Canada.
• Responsibilities:-
• Worked on various SQL report developments, and technical design documents.
• Coding and creating new objects (stored procedure, function) as required.
• Test case design and testing it.

• worked on PL/SQL object development in material management and the mining domain.
• Having experience in database migration from 9i to 10g.
• Involved in debugging and troubleshooting PL/SQL programming units.
• Involved in distributed database programming, which takes care of synchronizing the data between two databases.
• Worked on tuning and improving the performance of PL/SQL objects code.
• Involved in the customization and enhancements of the crystal reports(BI Reports), and Excel reports based on requirements.
• I drafted the technical design and unit test cases.
• Client: Singerani Coal Mines.