Engineer Data

RESUME

KUMAR ILANKOVAN

Email : ********@*****.*** Mobile : +1-612-***-****

Experience Summary

Having total of 12+ years of pioneering experience and high performance in system analysis, design, development and implementation

Establish, maintain & improve continuous deployment processes and bring teams to an even higher level of performance

Co-ordinating and helping for the continuous improvement of the development team

Owning responsibility of end-to-end project defect free delivery

Coaching, supporting and maintain sprit within the team & helping to remove obstacles for teams,

Help to identify and mitigate any external dependency risks in development

Coordinate with other Scrum Masters, tools streams and their teams on deliverable

Gather data and provide agile metrics, Plan releases, evaluating test exit and sign off criteria

Reporting status to company and client on a regular basis,

Tracking performance and doing work assessment of subordinates

Excellent experience in designing, developing, documenting, testing of ETL/ELT jobs and mappings using Informatica /DataStage to populate tables in data warehouse and data marts.

Proficient in developing strategies for Extraction, Transformation and Loading (ETL) mechanism.

Technical expertise in Informatica, DataStage, UNIX, Control-M scheduler, shell Scripts, Teradata, HTML, ServiceNow and Jira

Experience interacting with Business Analysts and clients

Knowledge by experience on SDLC, STLC cycles and Quality process

Achievements:

Saved approximately €1.1 million annually by integrating expenses data from SAP to Nokia warehouse without Teradata-Apprimo dependency Warehouse for reporting

Automation of scoring for email and mobile campaign for Target customers

NT - Composite installation and utilisation for reporting earlier than expected timeline

Certifications:

Process:

Certified ScrumMaster(CSM) Scrum Master Accredited Certification

Technical:

Informatica Teradata

Industrial Practise:

Telecom Retail Health Care Legal Information Service

Educational Qualifications

Master of Engineering(2002 -2004, Medical Electronics), College of Engineering, Guindy, Anna University, Chennai, India

Bachelor of Engineering(1996 – 2000, Electronics & communication Engineering), Electronics & communication Engineering, Govt.College of Engineering, Bargur, University of Madras, India

Technology

Software/Products

Tools

ETL Tools : Informatica 9.5, Data Stage 8.5

Databases: Oracle, TeraData R12

Documentation: MS Office

Quality lifecycle : HP QC, Bugzilla

Version Management : CALIBER, Jira

Life Cycle Mgmt: ServiceNow

Scheduling: Control-M

Process Automation: Git, Query Surge

Career Graph

As Assistant Consultant in TATA Consultancy Services, Chennai, from August 2006 to Till Date

Software Engineer in TieNet Technologies, Chennai - 24, from June 2004 to August 2006

System Engineer in Roland Systems, Chennai - 29, from December 2000 to April 2002

Onsite Assignments

TARGET Corporation, USA from Mar 2015

Microsoft Mobile Oy (NOKIA), Finland from Oct 2013 to Feb 2015

TARGET Corporation, USA from Jun 2010 to Feb 2012

Northern Trust, Chicago from May 2009 to Jun 2009

Assignments

The details of the various assignments that I have handled are listed here, in chronological order.

Project

Merch UDC

Customer

Target Corporation Minneapolis, USA

Period

Mar 2015 to Till date

Description

Upstream Data Centre to maintain and reduce the off seasonal items. By reducing the ‘clearance’ items it will help to improve the business. Also off season items distributed across the stores will be controlled and maintained from single location.

Responsibilities

Co-ordinating and helping for the continuous improvement of the development team

Owning responsibility of end-to-end project defect free delivery

Coaching, supporting and maintain sprit within the team and helping to remove obstacles for teams,

Help to identify and mitigate any external dependency risks in development

Creating source-target mapping document, developing jobs using ETL/ELT strategies

Unit testing, executing UAT scenarios

Risk Planning, Evaluating test exit and sign off criteria

Reporting status to company and client on a regular basis

Tools/Software

DataStage8.5, Informatica PC9.1, cloud, Teradata, Git, Jira,Windows 7, Unix,,

Location

Target Corporation, MN, USA

Project

Flow Reporting

Customer

Nokia (Microsoft) Corporation Finland

Period

Apr 2012 to Mar 2015

Description

Planning for the financial year is one of the major activities in Nokia. Aprimo Flow tool used for this. The flow data is maintained in different versions as per the business need. The forecast is compared with actual details and necessary steps will be taken to improve business.

Role

Scrum Master/Tech Lead

Responsibilities

Understanding, Planning and estimating the projects

Managing and coordinating the various tool streams

Monitoring the progress of work

Creating source-target mapping document, developing jobs using ETL/ELT strategies

Unit testing, defect tracking and UAT execution

Risk Planning, Point of escalation for matters requiring attention

Evaluating test exit and sign off criteria

Reporting status to company and client on a regular basis

Tools/Software

Informatica PC, Informatica Cloud, Teradata, Salesforce.com, Model-N, OBIEE

Location

Nokia Corporation, Finland

Project

EAM BI

Customer

TARGET Corporation USA

Period

Jun 2010 to Mar 2012

Description

TARGET is one of the major retail companies in USA. Enterprise application management is backbone of the Target. It helps to day to day business and reporting. EAM have SBE (Small Business Enhancements) and production support services.

Role

Technical Lead

Responsibilities

Managing and coordinating the various tool streams

Monitoring the progress of work

Point of escalation for matters requiring attention

Evaluating test exit and sign off criteria

Understanding the Business requirements

Analysing the challenges for SBE/enhancements and Risk Planning

Designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML, Transformer, Pivot etc, based of requirement, by utilizing an DataStage Designer, Administrator, and Director

Designing jobs using various types of stages like Sequential file, ODBC, Hashed file, Aggregator, Transformer, Sort, etc

Integrating of various data sources (DB2-UDB, SQL Server, PL/SQL, Oracle, Terada, XML and MS-Access) into data staging area.

Expert in working with Co-ordinating between offshore and onsite

Interaction and status reporting to client

Tools/ Software

DataStage8.5, Unix, Oracle9i, DB2, TeraData

Location

TARGET Corporation USA / TCS, Chennai

Project

NT -NMR

Customer

Northern Trust Bank, USA

Period

April 2009 to May 2010

Description

Composite Information Server (CIS) is a virtual data management system for Enterprise Information Integration (EII). It provides a secure and re-usable unified view solution that requires no change to existing applications or underlying information infrastructure. NT has data in Oracle, Sybase and DB2. For business purpose these databases are combined as a composite virtual database. The Composite database is used as data source in informatica

Role

Project Leader

Responsibilities

Understanding the Business requirements, Translating the business rules and preparing mapping design document

Creating Mappings between source systems and warehouse components

Analysing and identifying the strategy to implement extraction transform and load solution

Unit testing

Responsible to tune and maintain ETL procedures

Interaction and status reporting to client

Facilitating UAT

Tools/ Software

Composite Information Server 4.6, Informatica 8.5, Linux, Oracle, DB2

Location

NT, Chicago / TCS, Chennai

Customer

QWEST Communications, USA

Period

January 2007 to March 2008

Description

Qwest is one of the major telecommunication providers in USA. It helps the customer to order the products or services through online, voice calls and using the sales representatives. Orders can be created based on the customer’s configuration. GBUS, CARE, OPUS, SOES are some of the applications, which are used to create residential, internet and commercial communication services.

Role

Senior developer

Responsibilities

Understanding the Business requirements

Creating mapping design document

Translating the business rules by identifying suitable strategy to do ETL mapping

Creating Mappings between source systems and warehouse components

Unit testing

Preparation of support and release document

Transition to support teams

Interaction and status reporting to client

Tools/ Software

Informatica, Business Objects, HP Quality Centre 9.2, Borland Caliber

Location

TCS, Chennai, India

Project

CT Corporation

Customer

CT Corporation, Wolters Kluwer Company, MN,USA

Period

September 2006 – December 2006

Description

CT provides web-based workflow solutions for legal professionals to work. It provides intelligent software and service solutions that empower Banking and legal professionals to more effectively manage dynamic information, speed up workflows, and make critical decisions. It helps to get compliance in jurisdictions around the country and around the world with unparalleled confidence, flexibility and efficiency. This web application is used for maintaining an entity’s status with a state. Business Entity Filing application is a part of CT Advantage, which shares mainly the customer and order information.

Role

Senior developer

Responsibilities

Understanding the Business requirements and functional specification documents

Preparing of Scenarios and Test Scripts, Test Execution and defect tracking

Preparing support document and release document

System testing, Regression Testing and UAT

Interaction with client

Tools/ Software

Informatica, UNIX, Oracle 9i, Quality Centre,

Location

TCS, Chennai, India

Project

A-1 Cargo

Client

Bhima Consultants

Period

August 2005 – August 2006

Description

The system consists of numerous databases. There are from heterogeneous sources, hundreds of feeds. Data mostly come in the form of flat files in different formats also in Access and Oracle. The enterprise information is structured, analyzed and designed for fast retrieval of data. All the data sources are populated and shaped to make it wise.

Role

Software Engineer

Responsibilities

Understanding the Business requirements

Creating mapping design document

Translating the business rules by identifying suitable strategy to do ETL mapping

Creating Mappings between source systems and warehouse components

Unit testing

Preparation of support and release document

Transition to support teams

Interaction and status reporting to client

Tools/ Software

Informatica, Business Objects6.5, VSS, My SQL Server 2000 and Win XP

Location

TieNet Technologies, Chennai. India

Contact this candidate