Database: SQL Server 2008, Oracle 11g with tools DB Artisan, Toad and SQL Developer
Workers Compensation Automation and Integrated Systems .
Database used was SQL Server 2008 R2, created queries, stored procedures, functions, triggers etc.
Worked on SQL Server Integration Services(SSIS)andSQL Server Reporting Services (SSRS)
Programs, offers and source codes building for Acquisition, Balance transfer, Convenience check and Promotional Rewards offers.
Application software coding was done using C# and Vb.Net.
Database used was Oracle 11g, created queries, stored procedures, functions, triggers etc.
Developed shell scripts for batch processing with Tivoli Workstation for interface with down streams.
Development of Windows services, web application. Multi-threading was implemented for parallel processing of loan applications. WCF was used to address standardization of the loan applications.
Risk Queuing Management System Software is web based software: coding was done using C# in Visual Studio 2010. Also web services and windows services were used as real time loan applications were coming to the system from loan originating system. Database used was SQL Server 2008 and Oracle 11g.
Application software coding was done using C# but for interface used Java.
Developed database objects such as stored procedures, UDFs, views and triggers etc.
Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS.
Supported team in resolving SSRS and T-SQL related issues and created different types of reports.
Opics System enhancement using Vb.Net, C#, SQLServer and Oracle was the database.
Developed Database objects such as Stored procedures, UDFs and triggers etc.
Worked for the development and testing of interface system from front office to Opics system, using Meridian tools where Java was used for mapping and MQ-series used for messaging purpose.
Interfaced system captures different types of deals from KondorPlus and Bloomberg using MQ series and Meridian Tool using Java language.
OpicsRisk performs the Portfolio valuation, cash flow Analysis and VAR calculation. The VAR calculation can be done with delta normal, Historical simulation or Monte Carlo simulation.
Different modules of Opics in developed in VB/C#.net.
In developing GUI used Win Forms & Infragistics and Business Objects in C#.net. Involved in establishing Data Access Layer in ADO.Net and created database objects stored procedures, triggers.
Involved in coding for the development and maintenance of OpicsRisk using MS-VC++ with SQL-Server.
RiskIQ System: Merges information from diverse legacy sources, databases and trading & accounting application and gives the consistent and comprehensive view of risk. RiskIQ analyzes the impact of adverse market moves on individual portfolios as well as firm’s regional and global positions.
Portfolio Analysis and Value at Risk (VAR).
Database objects (Tables, Indexes, Stored Procedures, Triggers etc.) for RiskIQ created. Developed the GUI and Business logic using VB.Net and C#.Net.
Default Filter System: A front and middle-office software tool for default risk measurement.
Default Filter systematically quantifies the likelihood of default of corporate and commercial borrowers in these markets. It makes the best possible use of public and private credit information, thus helping to guide decisions on portfolio, credit management and individual loan analysis.
Designed the database and created database objects such as tables, indexes, stored procedures, triggers etc. in Oracle and SQL-Server.
Designed the database and created database objects in Oracle and SQL-Server.