Shijin Mohanan Sheela

• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool, and backward. • Created Delta and full load pipelines to fetch data from file systems and load into Azure Data Lake Store and some into Azure SQLDB Type1, Type2 tables. • Developed Spark notebooks using Spark for data extraction, transformation, and aggregations.

I• Creating ADF pipelines, implementing code accordingly as per mapping document business logics • Created pipelines with extensive usage of activities like Copy, Metadata, For Each, If, Filter, Stored Proc, Mapping Data Flow etc and Transformations like Lookup, Derived column, Select, Aggregate, Union all, Join, Alter row, Conditional Split etc. • Created dynamic parameterization pipelines and datasets as re-usable component.

Specialist in supporting Actimize Watch list filtering(WLF) solution implementations in global sanctions screening project, which includes but not limited to - Gathering the initial data sets and performing the Extract Transform load(ETL) and validation of the client's data  Executing the test run, analysing alert quality and the identification of potential improvements Automating job and process as per the project requirement Analysis the application on the effectiveness and efficiency via SWIFT