Ask Question / Post resume

Post a reply to the thread: www.extreme-europe.com Extreme IT Europe Ltd Hyderabad : Informatica developer, HSMP

Your Message

Your Username:

Notes:-
1) You can copy and paste your full resume in the box below.
2) Or you can ask your question. We try to answer, as far as possible.

Title:

[QUOTE=Guest-IJT;134751][b]Name [/b]: vkirankumar
[b]Email [/b]: dwh.vkiran AT gmail.com
[b]Designation / Skillset[/b] : informatica Etl developer
3+ experince of informatica etl tool

[u][b]Resume[/b][/u] :
Kiran.V

CAREER OBJECTIVE
 Having 3+ years of experience in software development and Data warehousing technologies using Informatica tool as ETL-Developer.
PROFESSIONAL SUMMARY
- Experience in Development of mappings using needed Transformations using Informatica tool.
- Experience in the Data Warehousing using Data Extraction, Data Transformation and Data Loading.
- Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
- Preparing the mappings according to the Business Requirements.
- Knowledge on Data Warehousing concepts like Star Schema, Dimensions and Fact tables.
- Extensively used Informatica client tools – Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager
EDUCATION
- BSC from Sri Venkateswara University, Tirupati, 2004-2007.
WORK EXPERIENCE
- Presently working for Wipro, Bangalore from April-2010 to till date.
- Previously worked in Thomson Reuters, Bangalore from Jan-2008 to March-2010.
SOFTWARE PROFICIENCY
ETL Tool
Informatica Power Center 8.6/7.x
Database
 ORACLE 8i/9i,10g
Operating Systems Windows,Unix
1.) PROJECT NAME HE BI PROJECT
Client HYBRID ELECTRONICS, US
Period May-2010 To Till
Solution Environment Informatica 8.6, Oracle 10g, Windows 2000.
Role Team Member
Domain Manfacturing
[b]Description [/b]:
Hybrid Electronics is a value added, broad line electronic components distributor that provides material management solutions to a diverse group of customers worldwide. Hybrid stocks over 500,000 parts, and has access to over 50 million components. Hybrid Electronics is a company dedicated to supplying design
engineers and buyers with the newest products and leading-edge technologies combined with unsurpassed customer service and worldwide support. The main objective of the project is assisting the senior and middle level management of the organization to improve the sales and get the knowledge of the new business opportunities
[b]Responsibilities [/b]:
- Created ETL mappings using Informatica Power Center to move Data from multiple sources
Like Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts.
- Involved into source code review,the mappings created by my team members.
- Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent
Sessions and scheduling them to run at specified time.
- Developed different mappings by using different Transformations like Aggregator, Lookup, Expression,
- update Strategy, Joiner, Router etc to load the data into staging tables and then to target
- Involved in performance tuning by optimizing the sources, targets, mappings and sessions.
- Monitored transformation processes using Informatica Workflow monitor.
2.) PROJECT NAME EAGLE DW
Client EAGLE Boston
Period Jul-2009 to Feb-2010
Solution Environment Informatica 8.5, Oracle 9i, Windows 2000.
Role Team Member
Domain Trading
[b]Description [/b]:
Eagle to have an integrated view of the amount and the type of business with its trade customers worldwide identifying its partners that do significant business and analyzing the profitability on the basis of customer, product, region, etc. Eagle want to product, customer, location wise reporting.
[b]Responsibilities [/b]:
- Mainly involved in ETL developing.
- Analyzed the Sources, targets, transformed the data, and mapped the data and loading the data into Targets using Informatica.
- Transformations like Expression, Router, Joiner, Lookup, Update Strategy, and Sequence Generator are mainly used.
- Creating the mapping and transformations using Informatica
- Creating the reusable mapping using mapplet designer and that Mapplets are used in mapping
- Using ETL process to Extract, Transform and Load the data into stage area and data warehouse.
- Preparing the Documentation for the mappings according to the Business Requirements
3.) PROJECT NAME Data mart for Banking System
Client WELLSFARGO BANK, USA
Period Dec-2008 to June-2009
Solution Environment Informatica 7.1.1, Oracle 8i, Windows 2000
Role Team Member
Domain Banking
[b]Description [/b]:
 The project is for caters requirements of the banking environment has been to extract data from source applications and load into oracle data warehouse. The purpose of the implementation is to understand the trends, performance and customer analysis of the bank. Subject areas covered in the warehouse are accounts like savings bank account, current account, loan account and overdraft account. Loans like personal loan, educational loan, industrial loan and house loan etc. Deposits like fixed deposits, recurring deposit. The company requires different level of analysis about loan amount, type of customers, type of payment schedules, captures data from their Transactional Database maintained under Client/Server Architecture
[b]Responsibilities [/b]:
- Working on Informatica tools Source Analyzer, Warehouse Designer, Mapping Designer,
- Mapplet Designer and Transformation Developer
- Creating Informatica mappings, mapplets and reusable transformations.
- Analyzed the Sources, targets, transformed data mapping the data and loading the data into targets using Informatica.
- Creating session & scheduling of session for loading data.
- Created Informatica mappings to build business rules to load data. Most of the transformations
- used like the Source qualifier, Expression, Aggregator, Lookup, Filter & Sequence generator
4.) PROJECT NAME Sales and Marketing Data Mart for Retail Domain
Client Maplins Electronics, UK
Period Jan-2008 to Nov-2008
Solution Environment Windows 2K, Oracle 9i, Informatica Power Center 7.1.1
Role Team Member
Domain Sales And Marketing
[b]Description [/b]:
This is a data warehousing application made for the analysis and reporting purpose of the sales and marketing company. The dimensional modeling used in this project is star schema. Using this project we can generate various types of reports like best Employee Report, Best Customer Report, Best Product sold report, Best Promotion report, etc.
 Project involved extracting of data from disparate data sources and transforming data from these files before loading into the warehouse. The transformations included filters and aggregations for the star schema target tables. The data sources were Oracle database tables and the target tables were in Oracle database. The project involved creating a metadata repository for the data warehouse, analyzing the source data, and then deciding on the appropriate extraction, transformation and loading strategy. Subsequently, mapping for the data flow from the data source to the target tables was created along with the required transformations. Sessions were created to run the data loading. The frequency of the data load was based on data warehouse requirements.
[b]Responsibilities [/b]:
- Understand the source systems and involved target design reviews.
- The project involved extracting data from various sources, transforming the data from these sources before loading the data into target (warehouse) Oracle tables.
- Worked on Informatica Power Center Designer tool-Source Analyzer, Mapping and Mapplet Designer, Transformation Developer.
- Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, and Update Strategy..
- Implemented slowly changing strategy to manage the data in the dimension tables. 
-------------------------------------------------------
[b]More Information about this submission and submitter [/b]:-
___________________________________________________
[b]Submission ID  [/b]: 4352950
[b]Date & Time  [/b]: 10th Jul 2011 4:24 AM (UTC)
[b]IP Address  [/b]: 122.179.53.110
[b]Browser Info  [/b]: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.2)
Predicted Country ;: India[/QUOTE]

All times are GMT +5.5. The time now is 10:58 AM.