Technologies used: SQL Server 2008, Oracle SQL Developer
● Worked in the ingestion of the probabilty of default scores and Quantitative credit indicators of the various companies, in a proper defined schema of tables in the sql server database with the help of sql procedures and triggers for S&P Capital IQ product.
● These scores were provided by the credit analytics team either in the form of excel files or views on tables in their database.
● These scores are then used by the various products such as credit health platform on Global credit portal and S&P Capital IQ.
● Have even worked with the optimization of the stored procedures and thereby improving the performance while working with 700 million rows of data in the tables.
● Dealt with partitioning and tuning of the database on different disks with the help of various files/filegroup creation, thereby having a clear understanding of the relational databases.
● Worked with the replication, maintenance and backup/restore of database on different servers.
● Have created SSIS Packages for migration of data from Oracle to SQL Server for ingestion purpose.