Tilak Chandrasekaran

• Created Semantic Data models for Banking and Healthcare insurance business dimensions in FAW.
• Created data pipelines for dimensions and facts in the data warehouse/marts without data staging or operational data source layers by extracting directly from the source.
• Successfully delivered Proof of concept for REVENUE ANALYZER, which identifies and provides insights into various business factors that affect the revenue of the bank.
• OCI Identity domains, Compartments, Autonomous Database, and ADB Configuration.
• FTP data transfer from source to target using ODI.

Gathered and successfully delivered data requests to the credit card team.

Tuned ODI packages that are consuming a substantial amount of execution time in the daily ETL load.

Deployed type II dimensions for SA-level data and cross-dimension to combine customer and accounts-level data in the warehouse.

Successfully delivered ODI proof of concept to extract data from flat files and populate the same data into Warehouse.

Carried out installations and configurations of Oracle Database (12c, 18c, 19c), Oracle Goldengate, and Weblogic. ODI and OBIEE.

Constructed Data Warehouse and installed schemas with predefined objects, object definitions, and datasets in the backend.

Configured and installed ODI topology, data models, mappings, and packages.

Prepared and released newer versions/patchsets to address.

Customer requirements and bug fixes in the product.

Created OBIEE dashboards for insurance departments, like Finance. Operations, Underwriting, Actuary, Reinsurance, and Coinsurance with all the required parameters and measures.

Developed data warehouse Fact and dimension tables to populate policy-level, endorsement-level data both separately and combined.

Developed data warehouse Fact and dimension tables to populate various levels of an insurance claim life cycle: Intimation, Outstanding, Paid, Rejected, and Closed.

Developed various PL/SQL procedures to reconcile the premium level and claim level data between source (OLTP) and target (OLAP) systems.

Identified the error patterns and provided permanent fixes at both the technical and business levels for the discrepancies in insurance premiums and claim amounts stored in various systems like eBao, Oracle Financials, and DWBI.

Worked with almost all types of IRDA data requirements.

Delivered reports based on the business done by the company in sales channel-wise and branch-wise.

Delivered reports based on the business done by the brokers and their incentives.

Worked with requirements of all the major insurance lines of business, like Aviation. Engineering, Fire, Health, Motor (both own damage & third party), Marine, Personal, Accident, and Workmen's compensation.

Configured and implemented the GST fee types (CGST, SGST, and IGST) at both the warehouse level and report level.

Adapt at all stages of the project lifecycle, from business requirements and technical definitions to development. Testing, user acceptance testing (UAT), production support, and completion.

· Experience in Dimensional Data Model designing, analyzing and implementing the data model and Data integration

Involved and fixed live issues in client side.