Saabir Khan
$20/hr
I'm an SQL and ETL Developer
- Reply rate:
- -
- Availability:
- Full-time (40 hrs/wk)
- Age:
- 40 years old
- Location:
- Pune, Maharashtra, India
- Experience:
- 9 years
1. Project:OWAZ(IDDN Report Module)
Company:Globetek Software Systems
Client :Russian Insurance company
Technology: Informatica PowerCenter, Toad 9.x, Oracle 10g, SQL, PL/SQL.
Role : Developer.
Description:OWAZ is the first overseas Client of Bajaj Allianz; this Project involves automating all the processes of insurance for e.g. Policy issuance, Claim registration, Reporting etc. The scenario at the Client side was that there were different types of systems which created a difficult scenario during closure of accounts and the generation of regular reports where there was lot of trouble in integrating reports from various systems and in reconciling data from different systems. Further one of the major problems faced was the modification of the premium figures pertaining to any previous period which affects the entire reporting pertaining to the previous period & the same comes to knowledge much later. Hence a unified IT system was expected which allows all types of customized reports from a single system.
Contribution:
Created mappings to migrate data based on the conditions given in the specifications.
Created and optimized source-to-target mappings by using aggregator, filter, joiner, expression, look-up transformations.
Was involved in the IDDN Report module.
Responsible to create and maintain ETL processes, mentor other team members.
Developed Procedures responsible to load the summary tables.
The IDDN Report contains all the details for a given policy.
Automated the manual process of loading RI (Reinsurance) Details by creating Oracle SQL scripts, PL/SQL cursors, packages, procedures, functions, tables, indexes, views, and constraints.
