ETL Developer, Information Technology Team Lead

Nazreen Liyakath

Email: *********@*****.*** Mobile: +316********

Address: Groot Hertoginnelaan 176, 2517 EV, Den Haag, Netherlands

Visa: Work Permit – MVV(5 years), Netherlands

PROFESSIONAL SUMMARY

•2.6+ years of expertise as ETL Team Lead and Developer in Business Intelligence

Projects.

•Demonstrated proficiency in mentoring individuals to maximize levels of productivity, while

forming cohesive team environment.

•Solid understanding and familiarity with insurance and capital markets domain. Exposure in

Data Warehousing and Database concepts.

•Dutch language course – A1 (Completed).

•Excellent team player with good interpersonal skills.

•Performed fulfilling roles as Team Lead & Developer with large team sizes. A strong

believer in high quality work with superior results.

•Experience in ETL design, development and unit testing applications for Data Warehousing

projects using Informatica 8.6.1 and SAS DI Studio 4.2.

•Experience in writing SQL query (TOAD, Teradata SQL Assistant), Test Director 7.6 SP3,

creating and tracking changes of defects.

•Familiar with Oracle, Teradata, Unix, SQL, PL/SQL, Base SAS 9.2, Business Objects,

WinSCP, Putty, Test Director & HP Server Automation 7.5

•Knowledge of client server applications and exposure to UNIX systems.

•Good knowledge of all stages including analysis, design, development, testing of SDLC.

•Ensure sufficiency and efficiency of testing through reviews and best practice

implementation.

•Quick at learning new concepts, working well under pressure and communicating ideas

clearly and effectively. Friendly with an upbeat attitude.

QUALIFICATIONS

•B.Tech in Information Technology from Kerala University, India

CERTIFICATIONS

•Informatica Certification in PowerCenter 8 Mapping Design

•Oracle 11g Certification SQL

•Certification in Java Programming from CDAC (Scientific Society of the ministry of communications

and Information Technology, Govt. Of India)

•Certification in Web Development Using LAMP (Linux, Apache, MySQL, PHP) from CDAC (Scientific

Society of the ministry of communications and Information Technology, Govt. Of India)

AWARDS, PUBLICATIONS, COMMUNITY

•Awarded for the contributions towards the Chennai centre cultural initiatives by the Capgemini centre

head, Chennai.

•Awarded twice for the best dance performance by Capgemini centre head, Chennai.

•Runners up in the Capgemini cricket league.

PROJECTS UNDERTAKEN

Claim System Replacement July 2011 – October 2012

Role Team Lead The Royal Bank of Scotland, UK

The project is regarding building a Dataware house for the Insurance Business of RBS. Here in CSR

initially some Datamarts were built to take reports. But this was not flexible enough to cater to the new

Requirements. So we went for smaller building blocks called Components. These are nothing but

Dimension tables which are derived from one or more source tables. A map table is used to relate these

source tables and this map table will provide SKs. We did POC for this and in first release we delivered

21 components. Based on the requirements we will build components with or without temporalness (SCD

2/SCD1). Here we handled error handling, logging and other standard procedures.

Roles and responsibilities

:

•Work with Business Analysts in gathering the Requirements, Use Metadata required for test case

development and execution.

•Ensuring the team are working in line with the client’s vision and objectives, to building trust and

open communication within the team; managing, training, helping and resolving issues.

•Coordinated meetings, reviews and presentations, and gathered project data and analysis for

reporting.

•Provided status updates and informed the PM of any project accomplishments or delays.

•Divided the tasks among the team members and tried to maintain a positive and productive working

team.

•Involved in Design and Development of ETL.

•Involved in Understanding Source Data mapping sheets.

•Extraction, Transformation and loading of data from Source systems (PDS & GWCC) into different

components as per the requirements (Business Verification and transformation rules). Various

transformation rules are applied.

•Created Informatica mappings, and re usable Code using different transformations.

•Creating Worklets, workflows and run for scheduling jobs and implemented error handling.

•Involved in Complete Unit Test case design

•review of the ETL

•Review current test plans, test cases, and test procedures

•Identifying setting up test data and execution.

•Involved in Test Results documents preparation.

•Query the database using SQL to check the data for various test cases.

•Interacting with Development team and Product Manager for any issues/clarification

•Involved in Performance tuning of the mappings/sessions.

•Reports the work completed to the reporting manager effectively and provides complete visibility to

all stakeholders

•Understands the project, related domain and able to review of the work done by the team members

Tools/Technologies:

Informatica Power Center 8.6.1, Toad for oracle 9.0.1, Unix, Oracle 10G, CA7 Scheduler

Solvency II Release 1.2 October 2010 –July 2011

Role ETL Developer The Royal Bank of Scotland, UK

Solvency II is a European Union Directive which defines capital adequacy requirements for

insurance companies. The aim of the Solvency II is to ensure the financial soundness of insurance

undertakings, and in particular, to ensure that they can survive difficult periods. The project is regarding

building a Dataware house for the Insurance Business of RBS and smaller datamarts are built from this to

generate reports. Solvency II Release 1 is to extract data from different source systems such as Liabilities

systems (UIS) and Business Systems (XOLAR, ROAR). The purpose of Solvency II Release 1 Project is

to transform and load the files/datasets for the Liabilities system (UIS files, ROAR datasets) from the File

Landing Area (FLA) to Relational Landing Area (RLA). SAS DI jobs are developed to load and process

files/SAS datasets on FLA and upload data to the RLA onto the respective tables. Before loading the

files/SAS datasets to RLA, the components developed will be used for checking the existence and non

corruption of the files/SAS datasets.

Roles and responsibilities

:

•Understanding Source Data mapping sheets.

•Extraction, Transformation and Loading of data from SDW relevant to Reserving Data Mart as per

the requirements (Business Verification and transformation rules).

•Created SAS DI Jobs using different transformations.

•Analysis of certain existing Jobs and modifying them based on new sprint changes.

•Developed Jobs and implemented error handling.

•Involved in Complete unit testing and test Data preparation.

•Involved in Test Results document preparation.

•Involved in Performance tuning of Jobs.

•Involved in Performance tuning of Teradata queries.

•Assisted in resolving the problems identified by the team members.

•Understands the project related domain and able to review the work done by the team members.

•Promotes and recommend improvements to the quality assurance standards.

Tools/Technologies:

SAS DI Studio 4.2, Base SAS 9.2, Teradata SQL Assistant, Unix, LSF Scheduler inbuilt in SAS, Test

Director 7.6 SP3

Other Interests

Singing is my passion and has sung in local language music albums. Likes to play guitar, biking

around the hague during weekends, trying new recipies in cooking and spend time with some

interesting books.

PERSONAL DETAILS

•Gender : Female

•Date of Birth : 09 10 1985

•Marital Status : Married

•Passport Number : K7831246

•Nationality : Indian

Contact this candidate