JINSAL ULAHANNAN

Cell : +91-974*******

Email: acu7o1@r.postjobfree.com

Professional Summary

•5 years of Experience in ETL Development using Informatica.

•Having the motivation to take independent responsibility as well as ability to contribute and a productive team member.

•Good in SQL,PL/SQL.

•Good in Data ware Housing Concepts.

•Excellent in ETL tool Informatica and SSIS.

•Good in SQL Server, Oracle Databases.

•Self-motivated and ability to master new technologies.

•Good logical, programming skills.

Technical Skills

ETL Tools : Informatica 8.6, 9.1,SSIS

Databases : SQL Server,Oracle, Teradata, Netezza,Greenplum.

Scheduling Tool : Control-M, Autosys

Query Languages : SQL, MySQL, PL/SQL

Reporting Tool : Qlik view, SSRS

Programming Languages : .net

Certification

Power Center Data Integration 9.x : Developer Specialist

Areas of Data warehousing Expertise

•Experience in various SDLC phases including ETL Design, Development, Testing, Production Support and Data Analysis.

•Migration of Objects from Development to Quality and to Production

•Experience in Querying SQL,Oracle,PL/SQL,Netzza.

•Experience in developing and implementing the coding of many Informatica Multi Source - Single Target mappings and vice versa for the different stages of ETL.

•Proficient in designing and developing various transformation logics.

•Experience in developing complex mappings and SCD Type-I, Type-II mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregator, Update Strategy, Sequence Generator, Joiner, Filter, Router and SQL transformations.

•Experience in debugging the sessions by utilizing the logs of the sessions.

Educational Qualification

•B_Tech - MG University - 71%

•PLUS TWO - FJMHSS, Puthuppady - 83%

•SSLC - NHSS, Muvattupuzha - 87%

Experience Summary

•Highly motivated professional with 5 Years of experience in Data Warehousing.

•Worked as Programmer Analyst in Systalent Software Pvt Ltd from SEPTEMBER 2011 to NOVEMBER 2013.

•Worked as Programmer Analyst in Cognizant Technologies Solutions from November 2013 to October 2015

•Currently working at Tata Consultancy Services from October 2015 to till date

Project Summary

Project 1 : Spend Analytics –SA

CLIENT NAME : AMD

Duration : 8 Months

Environment : Windows, Informatica, MS SQL server

Team Size : 3

Role : ETL Developer

RESPONSIBILITIES

•Extracting data from SAP sources and Flat files and Loading data into the staging tables and then performed transformations before loading into the target.

•Formulating the ETL mappings to implement the business logic.

•Populated slowly changing dimensions tables using type-1 as well as type 2-dimension changing and maintaining the full history of the data.

•Creation and scheduling of the workflows.

•Involved in Unit testing and created Test case document.

Project 2 : WWP SALES – SALES_WWP_PRJ

CLIENT NAME : DELL

Duration : 6 Months

Environment : UNIX, Informatica, Teradata, Oracle

Team Size : 3

Role : ETL Developer

RESPONSIBILITIES

•Extracting data from RDBMS sources (ORACLE) and Flat files and Loading data into the staging tables (TERADATA) and performed transformations before loading into the target (TERADATA).

•Data loading from Flat file to Teradata using Fast Load, T Pump and Data loading from Teradata to Teradata using Pushdown optimization (Informatica).

•Created and executed Macros, Collecting and refreshing Statistics on Teradata tables.

•Formulating the ETL mappings to implement the business logic. Used transformations like lookup, update strategy, expression, filter, router, aggregate, sequence generator.

•Created workflows and session.

•Created Stored procedures and Triggers.

•Created UNIX shell scripts for file handling and archiving.

•Involved in Unit testing and created Test case document.

Project 3 : SUPPLY CHAIN MANAGEMENT

CLIENT NAME : AMD

Duration : 8 months

Environment : Informatica

Team Size : 5

Role : ETL Developer

•Formulating the ETL mappings to implement the business logic. Used transformations like lookup, update strategy, expression, filter, router, aggregate, sequence generator.

•Populated slowly changing dimensions tables using type-1 as well as type 2-dimension changing and maintaining the full history of the data.

•Creation and scheduling of the workflows.

•Involved in Unit testing and created Test case document.

Project 4 : EBU Enhanmcements

CLIENT NAME : Cummins

Duration : 5 months

Environment : Informatica

Team Size : 6

Role : ETL Developer

•Modifying/Creating the ETL mappings to implement the business logic. Used transformations like lookup, update strategy, expression, filter, router, aggregate, sequence generator.

•Populated slowly changing dimensions tables using type-1 as well as type 2-dimension changing and maintaining the full history of the data.

•Creation and scheduling of the workflows.

•Involved in Unit testing and created Test case document.

Project 4 : Historical Data Migration

CLIENT NAME : Appvion

Duration : 3 months

Environment : Informatica

Team Size : 4

Role : ETL Developer

•Created data model using dimension modelling and involved in creation of mapping documents for Data transfer.

•Modifying/Creating the ETL mappings to load data from oracle database to SQL DW by implement the business logics. Used transformations like lookup, update strategy, expression, filter, router, aggregate, sequence generator.

•Populated slowly changing dimensions tables using type-1 as well as type 2-dimension changing and maintaining the full history of the data.

•Creation and scheduling of the workflows.

•Involved in Unit testing and created Test case document.

Project 5 : MILES PER GALLON

CLIENT NAME : Hyundai

Duration : 3 months

Environment : SSIS

Team Size : 4

Role : ETL Developer

Project Objective

The main aim of this project was to enhance the old MPG reports with new KPI and migrate the reports from AS400 to SQL server 2008

Project Description

Miles per Gallon (MPG) is a MicroStrategy reporting application needs to be enhanced with new and modified KPIs which will support business users to monitor and track the MPG Settlement Program. The old reports were pulling the data from AS400 table. This data needs to be brought into SQL Server and proper dimensional modeling needs to be created with the change data capture (CDC).

Role and Responsibilities

Converted AS400 code to SQL stored procedures

Created SSIS packages and used the stored procedures to load data to our SQL server database.

Creation and scheduling of the packages.

Involved in Unit testing and created Test case document.

Project 5 : Mercury_GW_Claims_Reporting

CLIENT NAME : Mercury

Duration : 6 months

Environment : Informatica

Team Size : 10

Role : ETL Developer

Project Objective

Guidewire Claims Reporting project deals with the implementation of reporting solution for Guidewire Claims that will cater to current claims reporting requirements and future scalability on operational and analytical reporting for Claims.

Project Description

This involves the development of a comprehensive data model for claims in alignment with industry best practices which can accommodate existing and will be scalable for known new reports. Design and development of ETL mappings to load data from Staging to Claims Warehouse.

Responsibilities

Extracting data from SQL server sources and Flat files and Loading data into the staging tables and then performed transformations before loading into the target.

Formulating the ETL mappings to implement the business logic.

Populated slowly changing dimensions tables using type-1 as well as type 2-dimension changing and maintaining the full history of the data.

Creation and scheduling of the workflows.

Involved in Unit testing and created Test case document.

Project 6 : IB Management Reporting

CLIENT NAME : Barclays

Duration : 3 months

Environment : Informatica, Oracle

Team Size : 3

Role : ETL Developer

Project Objective

IB management Reporting project deals with the implementation of reporting solution for Barclays Investment Banking section.

Project Description

This involves the development of comprehensive data model IB compliance in alignment with industry best practices which can accommodate existing and will be scalable for known new reports. Design and development of ETL mappings to load data from Staging to RDR.

Responsibilities

Extracting data from Oracle and Flat files and Loading data into the staging tables and then performed transformations before loading into the target.

Formulating the ETL mappings to implement the business logic.

Populated slowly changing dimensions tables using type-1 as well as type 2-dimension changing and maintaining the full history of the data.

Creation and scheduling of the workflows.

Involved in Unit testing and created Test case document.

Personal Details

Name : Jinsal Ulahannan

Age and Date of Birth : 26, 24-10-1989

Marital Status : Single

Languages Known : English, Malayalam and Hindi

Declaration

I do hereby declare that all the above mentioned details are true and to the best of my knowledge.

Jinsal Ulahannan

Contact this candidate