07/08/2024 updated
TC
60 % partially available
Senior Associate- Projects, Applications Developer II, Software Engineer
Chennai, India
Only remote
Data AnalysisOracle WebLogic ServerBug ManagementSoftware as a ServiceCloud ComputingData TransmissionsData IntegrationExtract Transform Load (ETL)Data WarehousingOracle Business Intelligence Enterprise EditionOracle Data Service IntegratorOnline Transaction ProcessingOracle DatabasesOracle ApplicationsPL-SQL
backend, Cloud, Control M, Analytics, Data integration, data transfer, Data Warehousing and Business Intelligence, Data Warehouse, DWBI, Dimensional Data, ETL, FTP, functional dependencies, Computer science, OLTP, Oracle, Oracle Financial, Oracle Business Intelligence Enterprise Edition, OBIEE, Oracle Data Integrator, Oracle 11G, 12c, Oracle Database, Oracle Financials, Oracle Analytics, PL/SQL, Physical Data Models, Real Time Data, Scripting, snowflake, bug fixes, SaaS
Experience
Professional experience5 - 10 years
Freelancer since2024
Languages
EnglishGood
Project history
Business client: Pacific Gas and Electric
February'2021-August'2021
* Gathered and successfully delivered data requests to credit card team.
* Tuned ODI packages that are consuming substantial amount of execution
time in daily ETL load.
* Deployed type II dimensions for SA level data and cross dimension to
combine customer and accounts level data in the warehouse.
February'2021-August'2021
* Gathered and successfully delivered data requests to credit card team.
* Tuned ODI packages that are consuming substantial amount of execution
time in daily ETL load.
* Deployed type II dimensions for SA level data and cross dimension to
combine customer and accounts level data in the warehouse.
Customers Handled: State Street, HCSC. Euroclear. Kaiser Permanente
Product Development/Deployment Activities:
* 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.Weblogic. ODI and OBIEE.
* Constructed Data Warehouse and installed schemas with pre- defined
objects, object definitions and datasets in the backend.
* Configured and Installed ODI topology, datamodels, mappings and
packages.
* Prepared and released newer versions/patchsets to address
* customer requirements and bug fixes in the Product.
Product Development/Deployment Activities:
* 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.Weblogic. ODI and OBIEE.
* Constructed Data Warehouse and installed schemas with pre- defined
objects, object definitions and datasets in the backend.
* Configured and Installed ODI topology, datamodels, mappings and
packages.
* Prepared and released newer versions/patchsets to address
* customer requirements and bug fixes in the Product.
Customers Handled: SBI General Insurance, National Insurance Corporation.
* Created front-end OBIEE dashboards for insurance departments like
Finance. Operations, Underwriting, Actuary, Re-insurance 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
level 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 in both
technical and business levels for the discrepancies of insurance Premium
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 Line of Business like
Aviation. Engineering, Fire, Health, Motor (both own damage & third party),
Marine, Personal, Accident and Workmen compensation.
* Configured and implemented the GST fee types (CGST, SGST & IGST) in both
warehouse level and report-level.
* Adapt at all stages of 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.
* Created front-end OBIEE dashboards for insurance departments like
Finance. Operations, Underwriting, Actuary, Re-insurance 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
level 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 in both
technical and business levels for the discrepancies of insurance Premium
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 Line of Business like
Aviation. Engineering, Fire, Health, Motor (both own damage & third party),
Marine, Personal, Accident and Workmen compensation.
* Configured and implemented the GST fee types (CGST, SGST & IGST) in both
warehouse level and report-level.
* Adapt at all stages of 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.