Chanchal Arya

Experience

• 

  Infosys

  Sept 2012 - May 2016

  Senior System Engineer

  • Created PL/SQL functions, procedures, views, and other database objects to implement rules of BASEL in OFSAA• SQL Exception handling and SQL query optimization• Implemented Credit Risk Management and rules for calculating Risk Weighted Assets (RWA) in OTC and SFT• Responsible for SFT and OTC portfolio and the Credit Risk Management implementation in OFSAA• Created analytical reports using OBIEE as per BASEL requirements• Development and maintenance of ETL components like Business Measures, Business Processes, T2Ts, Rules, Processes, Runs, and other components in OFSAA. Show less

• 

  Amdocs

  May 2016 - Sept 2021

  Database Administrator

  • Created multiple databases in Linux, and Windows and maintained around 100 databases• Optimizing large, complicated SQL statements and performance tuning• Upgraded Oracle database to higher versions. Worked on Oracle 10g, Oracle 11g, Oracle 12c, Oracle 19c.• Database maintenance tasks like tablespace maintenance, backup of database, export/import• Developed and updated databases to handle customer data.• Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.• Analyzed existing SQL queries to identify opportunities for improvements.• Developed, implemented, and optimized stored procedures and functions using PL/SQL.• Developed in-house applications designed for company needs.• Maintained complex PL/SQL queries, views, and other database objects in a multi-database environment with little supervision. Show less

• 

  Centric Consulting

  Sept 2021 - Apr 2023

  Senior Consultant

  • Experienced in end-to-end development from Requirement Analysis to System Study, Documentation, and Testing• Regular interactions with Solution Strategists and Clients for project requirements and design.• Designed and implemented TSQL queries for reporting and complex solution development.• Produced high-standard database solutions to meet stability, reliability, and performance metrics.• Developed, implemented, and optimized stored procedures and functions using T-SQL.• Resolved complex business issues, proposing long-term solutions to avoid repeat problems.• Performed code refactoring of existing SQL queries and solutions and optimization to improve performance.• Provided production support of applications by troubleshooting issues, proposing solutions, developing and testing fixes, and migrating solutions in Azure DataFactory (ADF). Show less

• 

  Mastek

  Dec 2023 - now

  Team Lead 1 - Development

  • Led development team in analyzing requirements and implementing user stories for 2052a products.• Utilized SQL queries to successfully build the Derivatives module of 2052a financial reports.• Created framework for NSFR/LCR calculator implementation in 2052a report.