Talent's Information
-
Location
Pune, India
-
Rate
$11.0 per Hour
-
Experience
7 Year
-
Languages Known
English,Hindi
Available for
About RANJITH
Over 7 + years of experience in ETL – Informatica Power center involved in Analyzing, Designing,Developing, Testing, and Implementation of Database projects.
Having good knowledge in data warehousing and Business intelligence concepts with emphasis onExtraction, Transformation and Loading data.
Extensive experience in Source Analyzer and Target Designer with including of Workflow Managerand Workflow Monitor, Debug Mappings, and Reusable Components.
Involved in Performance tuning of mappings, sessions, Data Validation, Tech Debt and CodeRefactoring.
Experience in working with different data sources Like Flat Files, RDBMS and other Sources.
Having Good Understanding of Dimensional Modeling like Star Schema, Snowflake Schemas.
Experience in Oracle 19c/12c/11g/10g and MySQL,TABLEAU. Strong analytical skills, self-driven,keen to learn and adopt new technologies and processes.
Worked on various business requirements with lead to development Efforts for various clients.Responsible for the own scrum development team on Agile- iteration basis for Client business roadmap.
Tech Stack Expertise
-
AWS
AWS
9 Years -
Oracle
Oracle 11G
6 Years
Work Experience
ELT Developer
- January 2019 - February 2022 - 3 Year
- India
Projects
Data Conversion
- June 2014 - June 2020 - 73 Months
-
Codan Forsikring is the biggest insurance (building, asset, legal entity and liability) company in Europe. Mainly to convert data to adapt with codan insurance policy requirement details. Data gathered from sources are flat files, transferred data from these sources to target as oracle and then oracle data should be converted into XML code using xml generator.
Responsibilities:
Extraction, Transformation and Loading (ETL) of data by using Informatica Power center.
Extracting source data from flat files, loaded to an Oracle and converted to XML separate code for every policy details.
Developing the mappings in Informatica Power Center Designer to load data from flat files to the staging environment.
Creating the mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Sequence Generator, Lookup, Update Strategy and Normalizer Transformation
Centene
- October 2020 - October 2023 - 37 Months
-
Centene is the biggest insurance company in US.Mainly analysis the policy holder type of treatment and provide the billing amount to particular Hospitals(Providers).Prepare daily reports to clients and also maintain the policy Holder treatments history. Approve the payments and verify the payment as perthe Provider Contract approval policies by using Citricx,ABS tools.
Responsibilities:
Entering the claim with new inventory of data into system.
Processing the claims after proper investigation.
Daily working towards achieving the individual targets.
Updating the productivity and pending claims status into the database every day.
Understanding the medical history of the clients.
Followed adjudication policies and procedures to ensure proper payment of claims
Delivered timely service to the members, providers, billing departments on the subject of claims
Every week collate the updated documents and process flow.
Settlement of the claims in accordance with the norms of the Insurance policies.
Solving the queries of the customers in the Claim settlement issues.
Weekly report of the updated workflow and status of the workflow with client confirmations.
Creating slides with report of the individual KRA(key result area)
Soft Skills
Industry Expertise
Education
in BSC
Pune University- June 2012 - June 2014
