SARAVANAKUMAR E

Proactive and versatile professional with a dedication to quickly adapting to new challenges. Strong problem-solving abilities and a proven track record of fostering strong relationships with clients and team members. Focused on supporting team success and achieving positive results.

SANOFI 1CRM INTEGRATION

Involved as primary ETL developer during the analysis, planning, design, development, and implementation stages of projects Created new mappings and updated old mappings according to changes in Business logic.

Worked on Agile methodology, waterfall  mode ,sprint planning etc..

Experience in optimizing/tuning ETL objects, indexing, and partitioning for better performance and efficiency.

Involved in the migrating project from Dev to UAT and UAT to Production. Help develop test cases and plans to complete the unit testing and user acceptance testing., Handling the monthly release activities., Monitoring activities for all the Production related jobs., Informatica Cloud, MySQL, Salesforce.

• Sanofi - Data Replication(DDZ)

 Replicate data from Salesforce DB to MySQL DB, Using Replication Task, synchronization Task, Developed Replication and Synchronization tasks in Informatica cloud to Synchronize Salesforce DB with MySQL database.

Created Indexes,Views and partitions on contry code and  various entities of the databases to increase the query performance.

Developed Replica read-only MySQL databases using views that are used as Reporting and Analysis data stores. 

• Sanofi -Data Integration(Back office)

 Integrate the extracted and transformed data into Salesforce DB. Creating all Mapping, Mapping Task, Parellel taskflow, Linear Taskflow and Mass Ingestion, Analyzed the source data coming from AWS S3 which is coming in the form of Flatfiles(.csv) 

Developed code to extract data and load it into the Postgres staging database. 

Worked with various transformations like a router, filter, union, expression, lookup, joiner, and aggregator., AWS S3, Informatica Cloud, PostgreSQL, Salesforce.

Using SCD Type1,SCD Type2 for history loads also multiple views has been involved

• Sanofi - IDAHE

Project which based on French government project and involves lot of POC and extracting data from salesforce to Nass path(network path) as zip file.

Using multiple data transformation and mass ingestion which used to move the folder from  aws S3 from nass using lambda,shell script.

Dta load's from salesforce CRM to multiple GIP layers

Creating parallel flow using multiple data task,parameters,command task which geneates the physical file

• Tamil
• English

• Udemy - Snowflake for developer
• Azure-fundamentals (900,204)

• Father's Name: Eswaramoorthy k
• Date of Birth: 05/28/00