Data Project

Abdul Khader CK

Email: ********@*****.***, Phone: +91-741*******

Career Objective

To obtain a challenging position in the industry where I can apply my extensive analytical and inter-personal skills and my excellent communication skills in rendering a significant contribution to quality of application, ultimately leading to the value addition to the organizational goals.

Current Role Description

Working as ETL Team lead in Accenture India Pvt Ltd and contributing for the MDM-Salesforce data integration project. My technological forte is Data Warehousing, data Integration and data migration under which I am very proficient in Informatica Power Center, Informatica Power Exchange, SQL, Oracle PLSQL, UNIX shell scripting, Informatica cloud service and various data warehousing methods and concepts. Also contributing as part of Accenture Informatica Solution architect team where I am providing design and solution by using informatica for complex IT requirements.

Experience Summary

Over Five years of IT experience in Design, Analysis, Development, Maintenance and Support of software applications and implementation of Data warehousing using ETL Tool Informatica Power Center with Oracle, SQL server databases on windows and UNIX platforms.

Good experience in Banking and Life science domain and worked in multiple data warehousing, data integration and data migration projects.

Involved in Technical and Business meetings with client and high level management

Experience working with the customers and business to understand requirements and translate into IT solutions that meet the business needs.

Demonstrated capabilities in developing and refining project plans, estimations, resource loading and utilization, and scheduling of project deliverables in the analyze, develop, deploy and debrief phases of various projects.

Good hands on experience in Informatica Power Center Client Tools – Designer, Workflow Manager, Repository manager and Workflow Monitor

Good experience in Informatica Power exchange tool and created different types of datamaps to extract data from mainframe sources.

Basic knowledge on Informatica administrator console and various admin activities

Good hands on experience on staging data from different types of sources like mainframe files, flat files, Oracle, XML,SAS server, SQL server etc and loading in data ware house tables as per the business logic.

Worked as member in performance improvement team and achieve the goal by using different techniques like PDO, Session level partitioning, Exchange partition, Parallel processing etc

Informatica/Oracle tuning Expert. Hands-on experience with PL/SQL programming, triggers, cursors, stored procedures, functions and packages. Strong understanding of the Oracle Architecture and the design and implementation of slowly changing dimensions, Star Schema, and Snowflake Schema

Experience in writing UNIX Shell Scripts to automate day-to-day operations

Basic knowledge on mainframe jobs and the scheduling documents like DOC05, DOC40, DOC35

Good experience in scheduling ETLs by using Autosys and UC4 jobs

Hands on experience in the tools like Harvest, ALM, Win SCP, Toad for Oracle

Certified administrator of Salesforce CRM and have good hands on experience on salesforce admin, config and customization.

Proficient in data integration of different sources with Salesforce CRM. Designed and developed multiple integration projects and integrated Seibel CRM, MDM and Salesforce CRM applications.

Good knowledge cloud integration tools like Informatica cloud service.

Excellent Skills in Application performance tuning, Application testing, Code Reviews & walkthroughs.

Proactive with good technical, analytical and communication skills

Contributions/Achievements

Got Accenture-Shire shining star award 2015 for the successful design and implementation of Salesforce-MDM Integration.

Got the Super Debut Award for contribution to the value creation with in TCS-PNC relationship

Got start of the month award multiple times for quality of work, dedication and commitment.

Appreciated by the client and higher management for the great contribution to the Data ware house split process, an initiative to define process for each file from the source and load data in multiple cycles as per the file availability instead of waiting for all the files from the same source system to be received.

Got compliments and appreciation from higher management for the contribution to the design and development of enhanced control validation for different types of data which is used to create the dashboard for reconciliation purposes

Successfully completed the FTC domain certification in US Banking and Risk Management, Salesforce admin certification and many internal certifications in various process and technologies.

Attended Salesforce 401 and 201 trainings and got certified as Salesforce 201 administrator.

Certifications

FTC - Risk Management E1

Successfully Completed

FTC - US Banking E1

Successfully Completed

Ascent – Informatica E2

Successfully Completed

Brainbench – PL/SQL E2

Successfully Completed

Salesforce admin-ADM 201

Successfully Completed

Technical Skills

Platforms

Windows,Unix

Languages

Oracle PLSQL, SQL, C, JAVA,J2EE,HTML

Database

My SQL, Oracle 10g

ETL Tools

Informatica PowerCenter 8.x, Informatica Power Exchange 8.x, Informatica PowerCenter 9.x

CRM

Salesforce, Veeva

BI tools

QlikView

Data base tools

Toad, SQL*Plus

Scheduling tools

Autosys, UC4

Others

MS Office, Harvest, HP ALM,WS FTP, Visio, Win SCP, Shell Scripting

Cloud Tools

Informatica cloud service

Project Experience

Project #1

Company

Accenture

Client

Project Name

Role

Shire Pharmaceuticals, USA

SFDC-MDM data Integration

Senior Integration Developer/Team Lead

Duration

Team Size

May 2015 till now

20

Environment

Informatica Power center 9.5, Oracle 10g, Salesforce CRM,

Veeva CRM,Informatica cloud service, Unix, Win SCP, Toad, UC4

Description

Shire Pharmaceuticals is one of the leading Pharma Company in US. It deals with products related to rare deceases mainly with ADHD and GI. This project is an integration between shire intelligent patient services application built in salesforce service cloud with MDM. This interface will take care of insert/update of Physician and site of care, affiliations and merging of the records dynamically based on various complex requirements and merge rules.

Also as part of this project we need to integrate the Salesforce CRM and Veeva CRM for the territory alignment and de-identified patient.

Roles and Responsibilities

• Involved in various phases of the software development life cycle right from Requirements gathering, Analysis, Design and Development.

• Analyzing the requirements by communicating with related stakeholders and framed the business logic for the ETL process.

• Involved in the ETL technical design discussions and prepared ETL high level technical design document

• Extracted high volume of data sets from data files, Oracle, SalesForce.com(SFDC) using Informatica ETL mappings/SQL PLSQL scripts and loaded to Data Store Area

• Extensively used the Informatica cloud jobs like Power center jobs, data synchronization jobs, data replication jobs and task flows for achieving the requirements.,

• Contributed to the development of complex ETL mappings including joiner, sorter,Normalizer, Sequence generator, SQL transformation,router, aggregator, union, lookup and filter transformations etc.

• Created complex ETLS for Account merge and address merge based on the merge rules by using Informatica salesforce merge transformation.

• Created re-usable transformations/mapplets and used across various mappings

• Wrote complex PLSQL scripts /functions/procedures/packages

• Extensively used mapping parameters, mapping variables to provide the flexibility and parameterized the workflows for different system loads.

• Optimized the performance of the mappings by various tests on sources, targets and transformations and improved the performance of the mappings by using Pipeline partitioning in Informatica.

• Created UC4 jobs for scheduling the informatica power center jobs for the inbound and outbound flow of this interface

Project #2

Company

Accenture

Client

Project Name

Role

Shire Pharmaceuticals, USA

Shire Patient Service data migration

Senior Integration Developer/Team Lead

Duration

Team Size

Nov 2014 to Apr 2015

20

Environment

Informatica Power center 9.5, Oracle 10g, Salesforce CRM,

Informatica cloud service, Unix, Win SCP, Toad, UC4

Description

Shire Pharmaceuticals is one of the leading Pharma Company in US. It deals with products related to rare deceases mainly with ADHD and GI. In 2014 Shire acquired few Pharmaceuticals companies like Viropharma and NPS. This project is to migrate the data from these companies to the Shire patient service CRM applications built on Salesforce and Veeva.

Roles and Responsibilities

Interacted with business analysts, Source data architects and Source application developer to understand the source data flow and created the functional and technical design document

Extensively used Informatica Power Center 8.5.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.

Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.

Implemented partitioning and bulk loads for loading large volume of data.

Involved in loading the data from Source Tables to ODS (Operational Data Store) Tables using Transformation and Cleansing Logic using Informatica.

Project #3

Company

Accenture

Client

Project Name

Role

AstraZeneca, USA

AZ US VEEVA Data Integration

Integration Developer

Duration

Team Size

Jan 2014 to Nov 2014

16

Environment

Informatica Power center 9.5, Oracle 10g, Veeva CRM,

Informatica cloud, Unix, Win SCP, Toad, Autoys

Description

AstraZeneca is one of the leading Pharma Company in US. This project is to do the data integration between legacy Seibel CRM solutions with Veeva CRM and to migrate the call centre related data from the legacy CRM to Veeva CRM.

Roles and Responsibilities

Responsible for gathering the business requirements for the Initial PoCs

Contributed to the development of ETL complex mappings including joiner, sorter, router, aggregator, union, lookup and filter transformations etc. using informatica power center

Developed few Stored procedures for the data integration call data

Involved in code Reviews as per ETL/Informatica standards and best practices

Wrote Unit Test cases and executed unit test scripts successfully

Supported during QA/UAT/PROD deployments and bug fixes

Project #4

Company

Tata Consultancy Services

Client

Project Name

Role

PNC Financial Services Group, USA

PNC EIP Basel-II

ETL Developer

Duration

Team Size

March 2011 to December 2013

30

Environment

Informatica Power center 8.6.1 and 9.5, Informatica Power Exchange 8.6.1 and 9.5, Oracle 10g, Unix,HP ALM,

CSM Harvest, Win SCP, WS FTP, Visio, Toad, Autoys

Description

PNC Financial Services Group is one of the largest bank in USA. PNC has engaged Tata Consultancy Services (TCS) to make PNC Basel-II compliant. The aim of the project is to make an Enterprise Data Warehouse for PNC that can use by the downstream users for various business analysis and decision making. This will give PNC a strong emphasis on risk management and improvements in bank's risk assessment capabilities.

Roles and Responsibilities

Involved in SDLC from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets.

Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor.

Worked with various transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Rank Trans formation, Router Transformation, Sorter Transformation, SQL transformation and Update Strategy Transformation

Worked with staging data from different types of sources like mainframe files, flat files, Oracle, XML,SAS server, SQL server etc

Created Workflows and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager

Created Connected and Unconnected lookup transformation for better performance of the mappings and sessions

Performed extensive testing on the mappings and wrote queries in SQL to check if the data was loading to the tables properly.

Preparing the Design documents based on the Functional/requirements specifications.

Involved in creation, modification and testing of various PL/SQL stored procedures and UNIX shell scripts for pre and post session commands

Optimized the performance of the mappings by various tests on sources, targets and transformations

Worked on Slowly Changing Dimensions (SCD's) and its implementation (Type1, Type 2, and Type 3) to keep track of historical data.

Done caching optimization techniques in Aggregator, Lookup, and Joiner transformation.

Developed Informatica Variables and parameter files to filter the source data.

Experience in using Informatica Debugger to test the data flow and fix the mappings

Implemented CDC in Oracle databases to capture latest updates from source to destination.

Created different types of datamaps in Informatica power exchange to extract data from mainframe files

Experience in testing the mainframe files data by using database row test functionality in power exchange

Experience in using Automation tools like Autosys

Scheduled the ETL jobs daily, monthly and quarterly based on the business requirement

Responsible for migrating the mappings, sessions, workflows and various ETL and Non ETL components from development to QA/Production environment through the version control tool Harvest

Documented the entire process. The documents included the mapping document, unit testing document and system testing document

Used Target Load order Plan for scheduling the data loading into different Target Tables by using the same mapping

Responsible for code review check list for each release that will help to deliver good quality of code without any defects

Creating database objects like tables, views etc

Creating the DMLs and Metadata that will use as parameters during the ETL

Coordinating with BA’s, DA’s for requirement gathering and clarifications

Responsible of creating for estimation of man hours per ETL and preparing the code migration and production implementation plan

Project #5

Company

iSrishti Technologies

Client

Project

Role

VKC Group of Companies

Human Resource Management Solution

Developer

Duration

Team Size

Sep2010- Mar2011

5

Environment

J2EE,My SQL,HTML, Java Script

Description

Human Resource Management Solution is a flexible answer to all the HR worries faced by small and medium sized businesses developed by iSrishti Technologies. It provides the features such as employee information management, leave management, time-sheet management and attendance reports, salary and payroll reports companies helping organizations manage their most important asset – people. This application ensures you, the perfect platform to line-up your HR processes in accordance with your company objectives.

Roles and Responsibilities

Designed, developed, tested and deployed various Modules

Preparing and executing unit test cases for the project

Bug fixing and maintenance of the product

Training end users and documenting the processes

Qualification

Degree and Date

Institute

Specialization

Master of Computer Application

Nov 2010

MES College of Engineering, Kuttippuram, Kerala

Computer Application(72%)

Bachelor of Science

June 2007

PTM GOVT College,Perinthalmanna, Kerala

Mathematics, Computer Science & Statistics(89%)

Higher Secondary Certificate (12th)

March 2004

D U H S S Thootha

Physics, Chemistry, Maths, Biology(69.83%)

Secondary School Certificate (10th)

March 2002

D U H S S Thootha

Physics, Chemistry, Maths, Biology (78.83%)

Career Profile

Dates

Organization

Role

Sep 2010 – Mar 2011

iSrishti Technologies

Java developer

Mar 2011 – Dec 2013

TATA Consultancy Services

ETL developer

Jan 2014 till now

Accenture India Pvt Ltd

Senior Integration Developer

Personal Details

Date of Birth

17-Dec-1986

Marital Status

Married

Nationality

Indian

Present Address

JS Usha Appartments,4th cross,Venkateswara College Main Road,Brindavan Nagar,Thavarekere,

Bangalore-29,Karnataka

Permanent Address

Chemmemkuzhi House, Valamkulam P.O, Anamangad Via, Malappuram Dist, Kerala-679357

Passport Details

Name as on passport

Passport Number

Date of Issue

Expiry Date

Place of Issue

Chemmemkuzhi Abdul Khader

G4858190

07-sep-2007

06-sep-2017

Malappuram, INDIA

Contact this candidate