Data Project
Resume:
JINSAL ULAHANNAN
Cell : +91-974*******
Email: ****************@*****.***
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