Project 1:

Project : MASS
(Marketing Agency Sales Summery)
Client : State Farm.
Operation systems : Windows, Linux.
Environment : DB2, Informatica 10.1s, Python.
Duration : Feb’2018 to till date.

Description:

State Farm is one of the largest insurance companies in US. This firm specialized in auto insurance for farmers, and later expanded its services into other types of insurance, such as homeowners and life insurance, and to banking, financial services and mutual funds.
Responsibilities with the team of 6:

• To go through the documentation provided by System Operation team for system analysis.
• To identify the tables and columns for the required to generate desired output, as per the source system along with the team.
• Design and develop Informatica ETL Mappings/Transformations for extracting data, transformation, data cleansing, integration and loading into the target/staging area
• Creating batch files to transfer data files from Informatica windows server to Active data warehouse UNIX server through WIN-SCP utility.
• Creating load scripts to load data from data files on UNIX server onto tables in the database.
• Creation, configuring, scheduling and running of Sessions, Work lets and Workflows.
• Reviewing the work done.

Project 2:

Project : Enterprise Data Warehouse (EDW).
Client : Philips.
Operation systems : Windows, Linux.
Environment : Oracle10g, Informatica 9.6.
Duration : March’2016 to Jan’2018.

Description:
PHILIPS is a multinational conglomerate corporation headquartered in Amsterdam, one of the largest electronics companies in the world, currently focused in the area of healthcare and lighting. It was founded in 1891. It was once one of the largest electronic conglomerates in the world and currently employees around 74,000 people across 100 countries.
Responsibilities with the team of 5:
• To go through the documentation provided by System Operation team for system analysis.
• To identify the tables and columns for the required to generate desired output, as per the source system along with the team.
• Design and develop Informatica ETL Mappings/Transformations for extracting data, transformation, data cleansing, integration and loading into the target/staging area
• Creating batch files to transfer data files from Informatica windows server to Active data warehouse UNIX server through WIN-SCP utility.
• Creating load scripts to load data from data files on UNIX server onto tables in the database.
• Creation, configuring, scheduling and running of Sessions, Work lets and Workflows.
• Creating procedures, functions, packages and triggers based on requirement and updating the existing procedures, triggers and packages.
• Creating indexes to improve the performance in query retrieving process.
• Design and development of mapping and Database management.
• Preparing the unit test cases and performs Unit testing and peer reviews at the end of each phase.
• Reviewing the work done.

Project 3:

Project : LIFE ASIA.
Client : ICICI PRUDENTIAL.
Operation systems : Windows, UNIX.
Environment : Oracle10g, Informatica 9.5.
Duration : JUNE’2015 to Feb’2016.

Description:

ICICI is one of the largest insurance companies of India. ICICI aims to retain and develop our market position through our behavior, by striking a good balance between price and risk, and by offering dynamic, compassionate and innovative service to our customers, in claims situations. Our insurances include workers' compensation, motor, building, contents, transport, house, personal accident and health care. It uses the product named LIFE ASIA for its IT implementation.
Responsibilities with the team of 7:

• To go through the documentation provided by System Operation team for system analysis.
• To identify the tables and columns for the required to generate desired output, as per the source system along with the team.
• Design and develop Informatica ETL Mappings/Transformations for extracting data, transformation, data cleansing, integration and loading into the target/staging area
• Creating batch files to transfer data files from Informatica windows server to Active data warehouse UNIX server through WIN-SCP utility.
• Creating load scripts to load data from data files on UNIX server onto tables in the database.
• Creation, configuring, scheduling and running of Sessions, Work lets and Workflows.
• Creating procedures, functions, packages and triggers based on requirement and updating the existing procedures, triggers and packages.
• Creating indexes to improve the performance in query retrieving process.
• Design and development of mapping and Database management.
• Preparing the unit test cases and performs Unit testing and peer reviews at the end of each phase.
• Reviewing the work done.