Summary
• Dedicated IT professional with 6+ years of progressive expertise in design, configuration, development, testing and implementation of OBIEE/Siebel Analytics and Data warehousing solutions using ETL Tools.
• Understanding of Information Technology Software Development Life Cycle (SDLC) methodology and project management principles, which include Requirements Analysis, Design, Development and Testing.
• Around 2 Years experience as Siebel Configuration and Siebel Actuate Reports.
• 3 Years of experience in data warehousing development using ETL tools such as Informatica Power Center 8.6/7.1.

1 years experience in Oracle Database 10g & RDBMS and Programming concepts such as in SQL, PL/SQL.

• Strong experience in developing OBIEE/Siebel Analytics Repository (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer).

Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables and Physical and Logical data modeling.
• Experience in installation and configuration of OBIEE on Windows.
• Hands on experience on setting upLDAPfor OBIEE.
• Knowledge on OM from Oracle ERP and Datawarehouse Application Console(DAC).
• Extensive experience in configuring Interactive Dashboards with navigational and drill-down capabilities using global and local Filters, Contextual Navigation, Guided Analytics, Alerts, Security Setup (groups, access privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Have clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development Using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.Proficient in the development of ETL (Extract, Transform, Load) processes with a good understanding of source to target data mapping, ability to define, Capture Meta data and Business.Team player with Strong leadership, Interpersonal and communication skills.

Technical Skills

BI tools : OBIEE 10.1.3.4.1,
Reporting/Data warehouse tool : Cognos 8.4 , Informatica 8.6/7.x,DAC
OS : Windows XP/2000/2003/98/95,UNIX & MS-DOS
Databases : Oracle 8i/9i/10g, SQL Server 7.0 MS Access 97/2000
Languages : HTML, PL/SQL, C, C++, Java, Shell Scripting
Web servers : IIS, Web logic, Tomcat, OC4J
Database Tools : TOAD, SQL Developer, SQL*Loader, Export , Import
RMAN, TKPROF
Modelling Tool : Erwin 7.1, Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential,CA September’2009-April’2010 OBIEE Consultant
Consulting for Confidential, which is an online textbook rental company. Students rent textbooks typically by ordering online, and return books after the semester. Involved in design the repository metadata (.rpd file).Developing Reports and Dashboards in OBIEE, Review and testing the reports.
Responsibilities:
• Identify the Facts and Dimensions based on the design specification.
• Involved in Data Modelling, Design Documents and Data warehouse.
• Designed and developed subject areas in RPD.
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer (Design of hierarchies, dimensions, and aggregates).
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Define appropriate joins, calculation, dimensions and measures in the repository
• Involved while creating repository Users/Groups and assigned permission to the user Groups to define security in the repository.
• Created and customized various Reports and Dashboards for various user groups.
• Designed various reports as per the requirements for user interface design like Drill Down, Pivort, Break down Reports, Narrative and Nested reports in Answers.
• Created reports with different Views (Compound, Chart, Table, Pivort, Ticker and
Narrative).
• Developed and schedule iBots for delivering personalized reports to users on time.
• Involved in Documentation and user manuals.
Environment: OBIEE 10.1.3.4.1, Oracle 10g, Informatica 8.6, Windows 2003 Server

Confidential,Seattle, WA August’2008-September’2009
BI Developer
Consultant for Confidential,Worked on Design, development of mapping using Informatica 8.6 Designed the reports and dashboards in OBIEE. Involved in installation and upgrading the .rpd. Created useful analytical and decision support reports like Sale Analysis by regions and sales by category and period were produced from the system.
Responsibilities:
• Participated in the requirement gathering of he various work streams by meeting with the
Business user and base lining the details.
• Developed mapping using Informatica Power Center for Dimensions and Fact tables.
• Worked extensively with Physical Layer, BMM and Presentation Layer.
• Installing and Configuring Siebel Analytics Server on Windows.
• Maintained the .RPD ( repository file) to added new subject areas and functionality
to preexisting structures supplied by Oracle Analytics.
• Involved in creating Data sources for connecting to the back end database.
• Designed Star schema for fact and Dimensional tables and created alias for the dimensional
Tables when necessary.
• Build Business model and established relationships & Foreign Keys (Physical & Logical)
Between tables.
• Create proactive agents iBots and interactive Dashboard to alert the marketing team about
Business changes.
• Used Filters( Global and Local) and provided customized prompts to avoid excessive data
showing up in the reports.
• Developed new measures as well as modifying the existing measures at RPD level.
• Worked extensively in creating dimensional hierarchies to support Drill Downs.
• Involved in security by creating Users, groups and External Tables.
Environment: OBIEE 10.1.3.4, SQL*Loader, Oracle 10g, Window 2003, TOAD,Informatica
Power Center 8.6.

Confidential,September’2006-May20’07
Informatica Developer
Consultant for T-mobile ,It gets data from SQL Server and Flat Files. The primary aim of this project is to integrate the data sources from existing system and to provide analysis to make business related decisions. Worked on design, development and review of mapping in Informatica Power Center 8.1.
Responsibilities:
• Performed data analysis based on the source systems and existing OLTP database systems.
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer,
Mapping Designer, Mapplet Designer and Transformations Developer.
• Created various transformations such as Update Strategy, Look Up, Joiner, Filter and
Router Transformation.
• Extracted the data from Oracle, Flat files and load into Data warehouse.
• Used Informatica Designer to create complex mappings using different transformations
like filter, Router, lookups, stored procedure, joiner, update strategy, expressions
and aggregator transformations to pipeline data to Data Warehouse/Data Marts
• Involved in obtaining change data capture (CDC).
• Involved in creating target database for the Data marts.
• Involved in the creation of oracle Tables, Table Partitions, and Indexes.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Worked with physical and logical data models of Erwin.
• Debugging invalid mappings using break points.
Environment: Informatica Power Center 8.6, Oracle10g,,SQL*Loader, UNIX Windows 2000

Confidential, Feburary’2005-August’2006 Confidential,INDIA

ETL Developer
Pioneer Distiller Limited is a Alcohol manufacturing. The company has exponential growth from the time of is establishment. The project has 2 data mart, one is Financial and other is Sales. The process loads client and standard data into a warehouse database. The data is thoroughly checked for validity during processing. This data is used in developing reports and the warehouse is built on Oracle.
Responsibilities:
• Worked Extensively on Informatica tools–Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Designed and developed various mappings and mapplets in Mapping designer and sessions and workflows in Workflow manager to extract data from SQL Server and load to Oracle database.
• Extensively used transformations such as Sequence Generator, Expression, Filter, Router, Sorter, Rank, Aggregator, Look up (Target as well as Source), Update Strategy, Source Qualifier, Stored Procedure and Joiner.
• Responsible for using the capabilities of Power Center namely list files, Connected and Unconnected look up, Persistence lookup, Dynamic & Static lookup.
• Created and ran Pre-existing and debug sessions in the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager.
• Developed Informatica Mappings, Re-usable Transformations, re-usable mappings and Mapplets for data load to data warehouse and database (oracle).
• Set up Batches and sessions to schedule the loads at required frequency using Power Center Workflow manager.
• Extensively used SQL and PL/SQL scripts with TOAD environment to create Target tables.
• Perform review of Session log files to trace causes of bottlenecks.
Environment: Informatica Power center 7.1.2, UNIX, Oracle 9i (SQL Plus, PL/SQL), Win NT.

Confidential,Bangalore May’2004-December’2004
SQL Developer
ISS is a real time Application for users to select various tourist spots in INDIA and plan a trip depending on the budget, distance, climatic conditions time and occasion. Involved in developing
the profile of the user and occasion of the tour will be entered into the database. Then the details of the location will be suggested to the user.
Responsibilities:
• Plan, design, and implement application database code stored procedures and views.
• Created user accounts, role, and profile and granting access to Database.
• Moving the database objects from one database to another database by export and
Import utility.
• Performed Oracle DBA tasks: creation of database objects, tablespaces, tables, established security via users and role.
• Working knowledge in using EXPLAIN PLAN, TKPROF.
• Involve in taking hotback up and cold backup.
• Involved in manual testing and automation testing.
Environment: Oracle 9i,10g, OS: Red hat Linux

EDUCATION:
Bachelors of Engineering Electronics and Communication Engineering.