Informatica Developer
Resume:
PALASH BARAL
Silver Oak Apartments,
Virupakshpur,
Kodigehalli
Bangalore--560097
E Mail : **********@*****.***
Tel: +919********* (M)
OBJECTIVE
To Obtain a Challenging position in Data Warehousing which offers opportunity for professional growth with the growth of the Organization, in a corporate Environment that will utilize my technical expertise and personal skills.
PROFESSIONAL SUMMARY
• 5 years and 4 months of experience in Software life cycle in Data warehouse and Client Server applications and developing Strategies for Extraction, Transformation and Loading mechanisms using Informatica on Oracle database.
• Demonstrated abilities in handling projects involving planning, requirement analysis, ETL design and scheduling.
• Adept in ETL design and implementation and handling of projects efficiently for delivering the required applications in a very systematic way.
• Possess sound knowledge in data warehouse concepts and have expertise in ETL tool, Informatica Power Center 6.2/7.1/8.6.
• Identifying the project requirements, analyzing business risk and project risk and evaluating the same with the team in team meetings.
• Good interpersonal skills, commitment, result oriented, self-motivated, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.
EXPERIENCE
Organization Duration
Actiance India Pvt Ltd March 2011 – till date
Cleartrip Travel Service Pvt. Ltd March 2009 – Feb 2011
Amiti Software Technologies Pvt Ltd June 2006 – Oct 2009
TECHNICAL SKILLS
Operating Systems Windows XP
Tools Informatica PowerCenter 6.2/7.1/8.6.
Database Oracle 9i (SQL, PL/SQL Basics), SQL Server.
Skills ETL designing, Performance Tuning
FUNCTIONAL SKILLS
ETL Development
• Strong knowledge on Data Warehousing concepts, ETL concepts, Data Modeling, Dimensional Modeling.
• Capable of the Designing and Development of process required for Extracting, Transformation and Data Loading.
• Approach through different logic to apply for design of simple & complex mappings by using Error Log Table and Control Table (CDC) Strategy in different way using Informatica to load Dimension & Fact tables using SCD logic.
• Optimizing the ETL process using performance-tuning methods.
• Performing the logical test for object, preparing & executing the Unit Test Cases.
• Code review and preparing Production Release sheet.
• Extensive experience on integration of data from databases like Oracle and SQL server.
RELEASE TASK /PROJECTS HANDLED
1. Project Name: BLUE SHIELD OF CALIFORNIA
Role ETL Developer
Client BSC-ODS/DI
Environment Unix, Windows XP, Informatica 8.6, Oracle
Duration 7 Months
Work Location Actiance India Pvt. Ltd, Bangalore
Team Size 4
- The Client, Blue Shield of California, is one of health insurer of USA wants to integrate its existing legacy system with their new Facets system so that data from these two different system can be integrated and used for reporting purpose. Apart from this they also wanted to introduce various source systems and use them as an Operational Data Storage system.
The prime objective of this module is to help the Managers of BSC to analyze the business in different portfolio and the risk associated with them.
Understanding existing business model and customer requirements.
Proper understanding & analysis of the requirement.
Leading the team to achieve the target and meeting the deadline.
Understanding the requirement and designing the HLD in Visio.
Understanding the Data model.
Preparing the Design document.
Preparing PK,FK and Missing Code map scripts for the ODS system
Prepared UTC for the developed mappings & tested mappings as per ETL specification.
Helped in DIT.
2. Project Name: EXPEDIA
Role ETL Developer
Client Expedia
Environment Unix, Windows XP, Informatica 8.6, Oracle
Duration 14 Months
Work Location Cleartrip Travel Service Pvt Ltd, Bangalore
Team Size 4
Expedia, Inc. is the world’s leading online travel company, empowering business and leisure travelers with the tools and information they need to easily research, plan, book and experience travel. Expedia wanted to implement and optimize database applications, performing data analysis which will help in their business decision making and identifying the key sectors, airlines, nature and time of leisure or business travels.
Understanding existing business model and customer requirements
Translated business requirements into data mart design.
Deliver technical Designs and Unit Test plans
Sourced large volumes of data from multiple data sources (Relational and Flat File) such as Relational Table, and Flat File into staging area using Informatica PowerCenter.
Designed the ETL processes using Informatica tool to load data from Oracle and Flat file into the target Oracle 9i database.
Implemented Extract, Transformation, and Loading (ETL) functionality for Data mart using Informatica Power canter.
Used Informatica Workflow Manager & Monitor to Create, Schedule, and Monitor and Send the Messages in case of process failures.
Tested mappings to assure that data was loaded as per ETL Specification.
3. Project Name: RISK DATABASE MANAGEMENT
Role ETL Developer
Client NCC
Environment Unix, Windows XP, Informatica 7.1.2, Oracle.
Duration 8 Months
Work Location Amiti Software Technologies Pvt Ltd, Bangalore
Team Size 5
Amiti Software Technologies Pvt Ltd is an Offshore IT Services Company specializing in providing offshore software solutions to Corporations all over the globe.
- The Client, National City Corporation (NCC), is one of the largest Bank of USA wants to update its existing system with two additional modules to enhance its performance. I will be working on the Loan & Mortgage module. The development & design of this module will be in line along its existing business requirement so that the extracted data can be loaded to the CORE through staging area and Clearing House using ETVML concept.
The prime objective of this module is to help the Managers of NCC to analyze the risk associated in the different portfolio and the risk associated with them.
Understanding existing business model and customer requirements.
Proper understanding & analysis of the requirement.
Understanding the requirement and designing the HLD in Visio.
Understanding the ER model.
Preparing the Design document.
Developed complex mappings.
Prepared UTC for the developed mappings & tested mappings as per ETL specification.
Optimizing the mapping to load the data and reduce run time.
Working on various defects as a maintenance works.
Worked on sanity checks on production support.
Data validation for production support.
4. Project Name: Chrysler Financial (CFC)
Role ETL Developer
Client CFC
Environment Unix, Windows XP, Informatica 7.1.2, Oracle
Duration 6 Months
Work Location Amiti Software Technologies Pvt Ltd, Bangalore
Team Size 3
CFC has selected ATC to build, deploy and manage a private-label system for the Canadian Market, building upon the Web E.L.V.I.S. site in the US. The company also wanted to build a warehouse of cooked data with respect to their sold vehicles that are grounded at their dealership in order to redefine their marketing strategies.
Understanding existing business model and customer requirements.
Proper understanding & analysis of the requirement.
Understanding the ER model.
Preparing the Design document.
Prepared UTC for the developed mappings & tested mappings as per ETL specification.
Optimizing the mapping to load the data and reduce run time.
Working on various defects as a maintenance works.
Worked on sanity checks on production support.
Data validation for production support.
EDUCATION
Graduation - Bachelor of Engineering (Medical Electronics), 2004, 61.3%
Visveswariaha Technological University Karnataka
Class 12th – St.Michael’s School, Durgapur, 1998, 53 %
Indian School Certificate
Class 10th – St.Michael’s School, 1996, 75.16 %
Indian Certificate of Secondary Education
PERSONAL DETAILS
Date of Birth: 09th March 1980
Gender: Male
Martial Status: Unmarried
Nationality: Indian
<a href=http://descargar-ares.name >ares</a>, <a href=http://www.btjunkie.name/ >btjunkie</a>, <a href=http://www.freedownloadgames.name/ >games</a>
<a href=http://avkaspersky.com/ >kaspersky</a>, <a href=http://www.btjunkie.name/ >btjunkie</a>, <a href=http://www.freedownloadgames.name/ >games</a>
<a href=http://xvideosx.name/ >xvideos</a>, <a href=http://www.btjunkie.name/ >btjunkie</a>, <a href=http://www.freedownloadgames.name/ >games</a>
<a href=http://www.emule.name/ >emule</a>, <a href=http://www.btjunkie.name/ >btjunkie</a>, <a href=http://www.freedownloadgames.name/ >games</a>
<a href=http://www.youtubemp3.net/ >youtube downloader mp3</a>, <a href=http://www.btjunkie.name/ >btjunkie</a>, <a href=http://www.freedownloadgames.name/ >games</a>
<a href=http://xnxxvideos.name/ >xnxx</a>, <a href=http://www.btjunkie.name/ >btjunkie</a>, <a href=http://www.freedownloadgames.name/ >games</a>
<a href=http://armor-games.name/ >armor games</a>, <a href=http://www.btjunkie.name/ >btjunkie</a>, <a href=http://www.freedownloadgames.name/ >games</a>
<a href=http://gamescar.name/ >car games</a>, <a href=http://www.btjunkie.name/ >btjunkie</a>, <a href=http://www.freedownloadgames.name/ >games</a>
<a href=http://armor-games.name/ >armor games</a>, <a href=http://www.btjunkie.name/ >btjunkie</a>, <a href=http://www.freedownloadgames.name/ >games</a>
<a href=http://pornhubvideos.name/ >pornhub</a>, <a href=http://www.btjunkie.name/ >btjunkie</a>, <a href=http://www.freedownloadgames.name/ >games</a>
<a href=http://pornhubvideos.name/ >pornhub</a>, <a href=http://www.btjunkie.name/ >btjunkie</a>, <a href=http://www.freedownloadgames.name/ >games</a>
<a href=http://youtubemp3.net/ >youtube to mp3</a>, <a href=http://www.btjunkie.name/ >btjunkie</a>, <a href=http://www.freedownloadgames.name/ >games</a>
<a href=http://www.steamagent.net >steam</a>, <a href=http://www.btjunkie.name/ >btjunkie</a>, <a href=http://www.freedownloadgames.name/ >games</a>
Contact this candidate