Developer Project

SANIL KUMAR P.S

Contact: +91-805*******; E- Mail: *****.***@*****.*** ________________________________________

Dear Sir/Madam

I am submitting herewith my resume for your perusal and favourable consideration for the post of ETL DEVELOPER in your organization.

Review of my credentials will indicate that I am a qualified IT Professional with sound knowledge and exposure across software development as ETL Developer for the past 3.5 years. A high performing individual with excellent professional and technical skills achieved via rich cross-functional exposure across the industry. Dynamic Professional with the calibre to utilize, extract, transform and load (ETL) tools to maintain, design, develop, test, implement and document data warehouse solutions. Currently designated as ETL Developer with ELIVEN TECHNOLOGIES PVT .LTD, Bangalore.

I am an innovative thinker, able to apply analysis and creativity to problem solving. I am a highly personable, self-motivated and diligent individual with flexibility to adapt to new situations.

Driven by high energy levels and technical competence I am confident of making visible contribution to company’s growth and profitability objectives.

A tour through my enclosed resume shall take you through the details and I am confident, in my credentials you would find a perfect fit for the said job. Thanks for sparing your time.

I would appreciate the chance to meet with you in person to discuss as to how I could be a vital part of your organization.

Thanking you in anticipation.

Yours sincerely

sanil kumar P.S

SANIL KUMAR P.S

Contact: +91-805*******; E- Mail: *****.***@*****.*** ________________________________________

ETL DEVELOPER - IT PROFESSIONAL

Seeking challenging assignments across the IT industry

________________________________________

PROFILE

• Competent and dynamic Software Professional, offering a progressive career of 3.6 years across software development as ETL Developer.

• Ability to utilize, extract, transform and load (ETL) tools to maintain, design, develop, test, implement and document data warehouse solutions. Currently designated as ETL Developer with ELIVEN TECHNOLOGIES PVT .LTD, Bangalore.

• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.

• Hands on exposure in designing ETL process and Data Integration techniques developing and supporting various ETL processes using Informatica and is holding a strong understanding on the architectural concepts of Data warehousing; good understanding of Oracle database and manageable hands on skills in technologies like SQL.

• Experienced in all phases of the project life cycle starting from user interaction, specification development, back end development, coding, testing, implementation and production support.

• Acquire working knowledge of basic commands and scripting in UNIX and also about Data Warehousing concepts.

________________________________________

TECHNICAL SKILLS

Languages SQL,PL/SQL

Database Oracle 9i/10g

ETL Tools Informatica 7.1.2, Informatica 8.6,Erwin

Reporting Tools Business Objects XI

Operating System Windows Xp,Linux

Productivity tools Microsoft Word, Microsoft Excel

________________________________________

PROFESSIONAL TRAININGS UNDERGONE

• Completed a 5 months training on Informatica, Business Objects XI, Data Warehousing concepts and SQL from Orator Neuro Science Research Organization Pvt Ltd, Bangalore

PROFESSIONAL EXPERIENCE

________________________________________

ELIVEN TECHNOLOGIES PVT LTD, Bangalore since June 2009

ETL Developer

• Gather & define business requirements while managing the risks to improve business processes, thereby contributing to enterprise architecture development from a business needs point of view through business analysis & map processes. Conduct code walkthroughs and review peer code and documentation.

• Demonstrated expertise utilizing ETL tools, including SQL, and Informatica and ETL package design, and RDBM systems like SQL Servers, Oracle.

• Look after the gamut of responsibilities pertaining to the data extraction from various sources like Oracle and flat files and loading of the data into the designed schema (into target warehouse (Oracle).

• Expertise in restructuring and development of business application.

• Directly responsible for Extraction, Cleansing, Transformation, integration and Loading of data from multiple feeds and sources into Data Warehouse by using Informatica.

• Technically abreast with the usage of Informatica Designer for the creation of Informatica.

• Extensively used Informatica Designer and transformations like Aggregator, Transformer, Lookup, Joiner, Filter, and Sorter.

• Skilled in the usage of Informatica for scheduling, running and monitoring Informatica tasks.

• Extensively Used Informatica client tools- Source Analyzer, Warehouse designer, Mapping designer, Mapplet designer, Informatica workflow manager, Informatica workflow monitor.

PROJECT EXPERTISE

Project #1

Title “Finance Data Warehouse (FDWH)”

Client ALASKA Finance Inc – Alaska, USA

Environment

Duration Informatica 8.6.1, Windows 2003server, Oracle 9i.

Oct 2010 – Till date

Description The Alaska Finance Inc is one of the leading banking, finance, insurance organizations in USA. It deals with different financial, banking, insurance services to different customers through different subsidiaries. The main aim of the project is to find out season wise financial analysis, target customer group, profit/loss making schemes, branch wise sales analysis and etc. At the same time information has to be updated on time for facilitating the managers and customer care people to run the business smoothly and resolve the issues from clients’ side. Accurate and reliable information is required for executives and analysts so that total business growth and profitable areas can be identified easily.

Roles and Responsibilities

• Analyzing the user requirements and high level design documents, and develop various ETL jobs to load desired data from OLTP to OLAP system.

• Extensively used Informatica client tools – Informatica workflow designer, repository manager, workflow monitor, and debugger.

• Good in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Export/Import, Informatica.

• Modification of existing ETL – Informatica jobs as per the requirement.

• Involved in Data Extraction from Oracle, Flat files using Informatica.

• Performed data cleansing on all raw data.

• Designed and developed update strategy, aggregate, joiner, lookup transformation that are used in mappings.

• Implemented Various Transformations using Slowly Changing Dimensions.

• Performed debugging of mappings.

Project #2

Project Pure Safety

Duration July 2009 – Aug 2010

Environment Informatica 8.6.1, Oracle10g.

Role ETL Developer

Description The objective of this project was to replace the Existing Load Process by Informatica as an ETL tool in order to gain performance improvement and to make the load process consistent across all the applications

Roles and Responsibilities

• Understanding the existing data warehouse and ETL process.

• Loading data from Staging area to Dimension.

• Developing mapping to extract data from various sources and load it to the staging area using various transformations.

• Develop different transformations to load the data into target.

Project #3

Project iDart

Duration July 2008 – April 2009

Environment Informatica 8.6.1

Role ETL Developer

Description The objective of this project was to Extract the data from a handheld

(PDA) Transform the data and load to database.

Roles and Responsibilities:

• Understanding existing OLTP system.

• Interacting with client and team about progress and development of the project.

• Develop ETL jobs for cleansing and transformation.

• Perform unit testing cases.

________________________________________

EDUCATIONAL & PROFESSIONAL CREDENTIALS

BBA (Business Administration) 2007 Rai Business School 63%

12th 2004 Kendriya Vidhyalaya, cochin, CBSE 57.8%

10th 2002 Kendriya Vidhyalaya, cochin, CBSE 43 %

________________________________________

EXTRA CURRICULAR ACCOLADES

• Participated in regional Level Swimming Competition for Kendriya Vidhyalaya in under 19.

• Played cricket in National Level for KendriyaVidhyalaya, Chennai in under-19 age group.

• Played cricket in regional for KV, Arakkonam in under-16 and under-14 age group.

• Obtained Merit certificate for securing third position in quiz competition held as a part of “Vigilance Awareness Week” held by “Oil India Limited”.

________________________________________

Date of Birth: 30th November 1985; Languages Known: English, Hindi, Malayalam and Tamil; References: Available on request

PASSPORT NO: Applied; ALTERNATE EMAIL: ************@*****.**.**;

Contact this candidate