Ranjit Raphael Email & Phone Number

Bangalore

Regulatory Reporting for RWA, Leverage Ratio, BCBS239, IFRS9 (only Provision)

Kuala Lumpur, Malaysia

• Implement BCBS 239 Program for the Bank as part of Regulatory Compliance. Roles and Responsibilities:
• Prepare Data Dictionary of Transaction processing and core banking systems.
• Prepare Business Glossary of Banking Systems
• Identify Golden source of Data
• For Risk Data Aggregation, support for Enterprise Data warehouse Implementation
• Data profiling using IBM Information Analyzer and SQL Developer

Bangalore Area, India

1 Build Solution Accelerators and Frameworks in Financial Risk and Regulatory Space2 Domain Consulting and Risk SME Support in Client Engagements3 Involvement in RFP/RFI Responses4 Prepare TCS Internal Assets for BCBS 238\295(LCR) and Regulatory Reports for MAS,FSA,FED5 Research on Risk regulatory reports for various jurisdictions and create assets such.

Bangalore

• Sourcing Project to build PD\LGD\EAD Engine.Basel II individual portfolios flow from Golden sources after converting cycle-cut information to Month end data, to Basel ODS for GL Reconciliation, then to IDN for.
• Conducted high\low level requirements analysis and estimation.
• Collaborated with developers, local and remote business users to elicit research and document.
• Prepare Data inventory document.
• Involved in requirement analysis and BRD preparation.

London, United Kingdom

• Market Data Management is a strategic service that provides single (golden) source of market data for different clearing systems within LCH such as EquityClear, SwapClear, ForexClear, and RepoClear. Enterprise Service.
• Involved in documenting BRD and FSD.
• Involved in User Acceptance Testing of clearing platforms for NASDAQ, SWAP-CLEAR, Banking Replacement, Turquoise MTF, FEX and FOREX-CLEAR.
• Worked on Various Message formats XML, SWIFT, Pipe-de-Limited, Tab-de-Limited and CSV.
• Worked on Various XML formats such as XML, FIXML, CLEARML, MDMXML (Reference Data Messages) including FIX 5.2 standards.
• Involved in Capturing and Snapping of trades and prices from (Bloomberg and Reuters) through External FIX Gateway.

Greater New York City Area

1.Implemented MIS reporting tool, MARS for Asset Management2.Implemented CRS, Compliance Review System, for Duetsche Bank. CRS is Asset Management application and used to provide workflow approval for Retail market documents.

Charlotte, North Carolina Area

Implemented Bank's Credit Card Application: CARD. CARD is used for issuing new cards, Transaction authorization, payment and charges, Collection, Delinquency, Behavior Score cards and Limit Adjustments.