Reg reporting

Risk applications (CVA & Liquidity risk).

• Managed team of 3 developers.
• Worked extensively in SQL server 2008 / Ssis / Ssrs.
• Successfully migrated Sybase 12.5 to 15.7 , kdb to pyspark, Informatica 7 to 8.
• Successfully designed db2 db for liquidity risk applications.
• System Design and develop the system using Stored procedure with and without cursor, trigger, view, also use the all types Join query statement Etc.
• Involve in application development and Unit, Integration and System Testing. Debugging and troubleshooting of the application.
• Performance tuning of the application, reduction in the number of loops and code optimization.
• Involve in project documentation for each module of the application.
• Smooth implementation and testing of the application and extend post go-live & application maintenance support to the client.

Managed Finance ODS in Sybase Iq and Sybase ASE and SSIS, calculating Profitability.

Truncating and Loading staging tables on daily basis (like Loans / Deposits / loan details/ fees etc.) and calculating profitability. Reading data from ALM and Corebanking to calculate profitability.

Migration of some processes from Sybase ASE to Sybase IQ for faster processing.

• Joined as Sybase IQ /ase Developer
• Worked extensively in Ssis / Ssrs.
• System Design and develop the system using Stored procedure with and without cursor, trigger, view, also use the all types Join query statement Etc.
• Involve in application development and Unit, Integration and System Testing. Debugging and troubleshooting of the application.
• Performance tuning of the application, reduction in the number of loops and code optimization.
• Involve in project documentation for each module of the application.
• Smooth implementation and testing of the application and extend post go-live & application maintenance support to the client.

Database modeling and Data migration from Ms-Access to Sybase Server for Moodys.com (Sep 2009 – Jan 2011)

• Enhanced nRDE application for Moodys.com
• Sybase Developer / Project Lead
• Migration of MSPG from MS-Access to Sybase server
• Database modeling and Data migration from Ms-Access to Sybase Server
• Design and development of the workflow program and handle various phases of application development.
• System Design and develop the system using Stored procedure with and without cursor, trigger, view, also use the all types Join query statement Etc.
• Involve in application development and Unit, Integration and System Testing. Debugging and troubleshooting of the application.
• Performance tuning of the application, reduction in the number of loops and code optimization.
• Involve in project documentation for each module of the application.
• Smooth implementation and testing of the application and extend post go-live & application maintenance support to the client.