capital assessment model

Project 1 Project Title : CAM Client : CRS Role : ETL Developer Duration : March 2016 to Till Date Team Size : 6 Tools Used : Database - Oracle 11g and Microsoft SQL Server 2008 R2 Tools - Informatica 9.x , ServiceNow,Bugzilla. Description: CAM is capital computation software that facilitates estimation of regulatory capital for credit risk, market risk and operational risk in accordance with the Basel II Accord across standardized as well as advanced approaches. Key Features • Library of predefined reports with capability to customize based on institution's requirements • Ability to conduct stress testing and scenario analysis • Retail pooling and segmentation across geographies, product type, collaterals and other attributes • Calculation of specific and general risk for interest rate risk, including securities and derivatives, as per the duration approach, equity and equity derivatives. • Netting module to allow netting of derivative positions (such as swaps, forward rate agreements and futures) as per RBI guidelines. This helps reduce capital requirements as no disallowance is applied to the positions. Roles and Responsibilities: • Developed ETL mapings, Transformations and Loading using Informatica. • Extensively used ETL to load data from Flat files, cobal files and also from the database. • Involved in evaluation of data, which we are loading everyday is fine or not. • Activities including Design & development on Informatica. • Involved in daily reconciliation of data between source and DWH. • Worked with different data sources like Flat Files and Databases. • Involved in Both Development and support of the Project. • Involved in Enhancements of the existing coding and implemented new reconciliation process according to the client and User requirements. • As an ETL Team member, was responsible for Design and Development of job on the from Source to Target mapping process. • Responsible for overseeing the Quality procedures related to the project. Project 2 Project Title : AKB Client : KPN, Netherland Role : Software Engineer / Data Warehouse Contingent Duration : January 2014 to February 2016 Team Size : 6 Tools Used : Database - Oracle 11g and Microsoft SQL Server 2008 R2 Tools - Informatica 9.x & 8.x, Sql Develo, Bugzilla Description: KPN Telecom is the leading Mobile Network Operator in Netherlands. This Company engaged in rendering postpaid mobile services and Broad band Confection Services and Digital Services. This Project Specially Deals with Business Analysis. This Project is to extract to Various Source Systems into a Consolidated Entitlement Repository (CER) which we built in EDW (Enterprise Data Warehouse). Data from all the Source systems will be extracted into CER Staging. All the business logics and validations will be done from CER Staging using Informatica Power Center and Load the data into CER Staging to AKB Data Warehouse. Roles and Responsibilities: • Extensively used ETL to load data from oracle and Flat files to Data Warehouse • Extensively worked in data Extraction, Transformation and Loading from source to target system using power center of Informatica. • Extensively involved in development of mappings using various transformations of Informatica according to business logic. • Created and Scheduled Sessions and Batches using Server Manager • Created and Monitor the sessions using workflow manager and workflow monitor. • Conducting unit testing. • Used debugger to validate the mappings and gain troubleshooting information about data and error conditions. • Involved in Preparation of Low level Design documents.