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.
Hi - We have ETL developers in our team and we are ready to sale their services.
Please provide us below details :
1. Work location :
1. if it is outside india who will take care of VISA and travel expenses.
2. Duration of role
3. Type of job (permanent/temporary) .
4. How many resources you need.
NOTE: We are not consulting or job agency.
We have Agile certified team of developers. you will have services of corporate team at the cost of a freelancer.
Please contact me by clicking on chat button for more details.
Thanks
Sachin Sirohi
Dear Sir/Madam,
Hope you are doing well.
As a database administrator have knowledge and experience in Oracle as well as SQL server. Could you please have a chat discussion and proceed with the work?
Thanks,
PRatik