SUMMARYWith over 7 years of experience in the financial services industry, I have worked with the vast majority of the largest U.S. custodian banks and brokerage firms. In my tenure, I have integrated new data into Client's data warehouse, coordinated the development of SQL Server Integration Services (SSIS) and Powershell packages, compiled normalization requirements, and updated existing & created new stored procedures.RESPONSIBILITIES Integrated new data feeds into the client’s data warehouse. Coordinated the development of SQL Server Integration Services (SSIS) package and power-shell with the development team. Providing Full documentation about new development and change in an existing package via BRD to the various department including dev team, ultimate user and Operations team. Compiled normalization requirements and updated existing normalization, also created new stored procedures. To evaluate and analyze Daily Fund Scorecard to check Profit and Loss Performance of financial instruments, classified on a portfolio basis and product basis. Create ETL rules further load of data in the structured format in the Database. Partner with Stakeholders to identify the reporting needs and oversee the entire lifecycle of report development. Develop data integrity reports, catching and addressing anomalous activity before it negatively affects the end-users.  Make procedures in SQL server, to track any exceptions as well as to analyze the process ad-hoc requirements. Use of Bloomberg Terminal, Markit WSO as a tool to extract information from vendors to make accounting system normalization. Investigate data discrepancies and position reconciliation breaks.RECOGNITION Recognized by Client in Reducing the time spent on Dashboard Monitoring. Recognized by Client in Building Data Warehousing infrastructure that includes Generic Import, Normalization, Data Integrity report Via SQL Server Procedure and end-user reports.

1. To Independently value OTC derivatives such as Credit Derivatives and Interest Rate Derivatives.2. To Analyze risk on financial Instruments, especially Derivatives & preparing its report via Proc SQL SAS.3. To evaluate vendor supplied derivative valuations and market data relative to Investment Manager / Counterparty prices.4. Have a good understanding about process flow of parties invloved in trade processing.5. Worked on waterfall modelling of CDO, CMBS and CLN products.6. Investigate root cause of breaks and strive to prevent its recurrence through various initiatives.7. Participating and representing bank on various market calls like ISDA, TIW & Pay Rec as a tool to resolve breaks.8. Track queries via smartstream / TLM for both external nostro and internal control accounts and resolve all breaks with high attention to detail.9. Laise with key stakeholders like Middle Office, Sales support, IT Support to ensure all issues resolved in timely manner.10. Support cross training to reduce any key dependencies and enhance product and process knowledge in and outside of team.11. Have a good knowledge of Credit and Interset Derivative products like IRS, Currency Swap, ND Swaps, ND MTM Swaps, Caps & Floors, Inflation swap, CDS, CDO, TRS, Index Tranches, ABS, RMBS, CMBS.12. Subject Matter expert in Credit, Interst Rate Derivatives and Fx Derivatives.