Current Industry :- not working

previous Industry: Vyomlabs baner, pune, India(7 month exp)

Acumen Analytics pune, india (3 month exp).

Functional Area: data warehousing (ETL and BI).

Years of Experience: 1 year (over all)

• Over1 years of experience in Information Technology including Data warehousing, RDBMS, and Client Server applications.
• 1 years of data warehousing experience using Infomatica 7.1.1 and 8.1.1,Siebel analytics Data warehousing(informatica and DAC(Data warehouse application consol),Oracle warehouse builder 10gr2).

Informatica Power Center 7.x/8.x and ETL Concepts.

• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like flat files, Excel, Oracle, SQL Server.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, and Mapping Designer.
• Hands on experience with complex mappings from varied transformation logics like Unconnected and Connected lookups, Router, Aggregator, Joiner, Update Strategy and re-usable transformations.
• Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.
• Working experience in using Oracle 9i/8i/7i, SQL Plus, ERWIN,Windows XP/2000/98/95,
• A basic understanding and experience with OBIEE,BO,cognos.
• Excellent communication, interpersonal, analytical skills and strong ability to perform in a team.
• Understanding, flexible, and adept at working in high paced environments, adapting quickly to different business organizations needs

Technical Skills

ETL Tools : Informatica Power Center 7.x/8.x,OWB,DAC,
OLAP : Business Objects 5.1/5.0,OBIEE,BO,Cognos
Data Modeling : Erwin 4.0
RDBMS : Oracle10gr2, 9i/8i/7.x, sqlserver2005 Access,MSAccess
Languages : C, C++, VB6.0.

Project Details

Confidential
I configure and handle this project

Role: ETL Developer

Project Description:
Confidential is a CRM system which provides the company database structure. The data warehouse maintains the company information like salary analysis, skill analysis, product analysis customer analysis, employee analysis, like such details about organization.

Responsibilities:

• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Connected & unconnected lookups, Filter, Router, Sequence Generator, Sorter, Joiner, and Update Strategy.
• Used Workflow manager for Workflow andSession Management, database connection management and Scheduling of jobs to be run in the batch process.
• Developed shell scripts, PL/SQL procedures for creating/dropping of table and indexes of performance for pre and post session management.
• Imported data from various Sources transformed and loaded into Data Warehouse Targets using Informatica.
• Developing Informaticamappings & tuning them when necessary.
• Optimizing Query Performance, Session Performance.
• Configure informatica repository to DAC(data warehouse application consol )

Environment: Informatica Power Center 6.0 (ETL),SQL server 2005,

Confidential,

Role: Informatica Developer

Project Description:
This Data Warehouse is constructed to stage the Sales & Distribution and Inventory related data for AVM Pharmaceuticals (Pharmaceuticals and Hospital related products). Informatica is used to Extracting data from source system to target systems. There are numerous sources of data coming into the warehouse including flat files and Excel spreadsheets.

Responsibilities:

• Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• There were two kinds of data loading processes (Daily and Weekly) depending on the frequency of source data.
• Imported data from various sources transformed and loaded into Data Warehouse Targets using Informatica.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Extensively used Transformations like Router, Aggregator, Source Qualifier, Joiner, Expression, Aggregator and Sequence generator.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.
• Worked with different sources such as Oracle, SQL and flat files.
• Knowledge of slowly changing dimension tables and fact tables.
• Optimizing the mappings by changing the logic to reduce run time.

Environment: Informatica Power Center 7.1.1 (ETL),Oracle 9i/8i, ERWIN 4.0, SQL, Windows NT/2000/95.

Education Details:

B.E.Computer
H.S.S

B.E.Project Details:-

Project Title: Online forum (online communication)
Description: online forum is nothing but online communication. it is web site On which user create account and give topic for discussion for all member. Other member replay of question. user can see all replay of answer.

Desired Job Details

Employment Status: Full Time

Languages Known

English: (Read, Write, Speak)

Hindi: (Read, Write, Speak)

Marathi: (Read, Write, Speak)