SUMMARY

• 6+ years of IT experience and technical proficiency in data warehousing teamed with Business Requirement Gatherings, Analysis, Design, Data Modeling, Development, Testing and Implementation of Data warehouse for Banking, Insurance and Telecom industries.
• 1+ years of experience implementing Data warehouse/Business Intelligence using OBIEE.
• 1+ years of experience on Business Objects and Xcelsius.
• 6+ years of experience in Extraction, Transformation and Loading of data using Informatica 8.x/7.x/6.x, Oracle 8i/9i/10g, MS SQL Server 2005/2000/7.0/6.5, ERWIN 4.0/3.5/3.X, SQL, PL/SQL, SQL*Plus, SQL*Loader, UNIX, Unix Shell Scripting.
• Extensive knowledge on linking data from multiple sources, using functionalities like combined queries, drill down, and master detail using Business Objects.
• Extensive experience in Siebel Answers, Delivers, iBots, and Siebel Intelligent Dashboards with Siebel Analytics stand-alone/integrated implementation.
• Proficient in using the following tools: Oracle BI Administration, Oracle BI Answers, Oracle Delivers (iBots), Quest Toad, Oracle SQL Plus.
• Experienced in DAC to configure, monitor and schedule ETL routines.
• Expertise in debugging and optimizing the Business Objects/Oracle BI / Siebel Analytics Dashboards / Reports and Informatica Mappings / Workflows.
• Strong knowledge on OLAP, ROLAP, MOLAP, OLTP, Star Schema, SnowFlake Schema. Autosys.
• Excellent problem solving skills with good interpersonal skills, Quick learner and excellent team player.

EDUCATION

• Bachelor of Engineering in Computer Science.

TECHNICAL SKILLS

OBIEE 10.1.3.x, Siebel Analytics 7.9.x, Business Object XI/R2

ETL:

Informatica 8.1.1/7.x/6.x

Data Warehouse Administration Console:

DAC 10.1.3.x

Database:

Oracle 10g/9i/8i/8.0/7.0,MS SQL Server 2005/2000,SQL*Plus, MS Access 7.0

Languages:

C, C++, Java, HTML,XML, SQL,PL/SQL, Perl, Unix Shell scripting

Operating System:

Unix, Linux, Windows XP/NT/2000

PROFESSIONAL EXPERIENCE
Confidential,Charlotte Informatica/Business Object Developer Mar ‘08- Till Date
The data warehouse brings multiple sources together in a form that permits cross-function analysis. This data warehouse project contains two main components. First component is to create central customer database for organizations. The second component is analysis of Finance data and involved various financial data.
Responsibilities:

• Designed and exported universe for standard/ad hoc reporting requirements for end users. Linked Universes and modified the Budget Universe for the purpose of generating ad-hoc reports. Involved in Writing Detailed Level Documentation for reports and Universe design.
• Created and involved with creation of complex universes.
• Effective use of advanced reporting and formatting functions in Business Objects reporting.
• Developed Single and multiple dashboards and scorecards using business objects.
• Developed presentation layer and worked on navigation
• Created Master/Detail Reports, Cross-tabs, Charts and Applied slice-and-dice, implemented different level of hierarchies for drill techniques.
• Developed LDAP security model for security publications and involved in Development of OLAP data structures using Microsoft Analysis Services tools.
• The major data providers used are Universes, data files, Free Hand SQLs. Involved with the Enterprise Data Warehouse project and involved in part of Data analysis.
• Effective use of advanced reporting and formatting functions used in Business Objects reporting.
• Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source system.
• Extensively worked on the performance tuning of the Informatica PowerCenter Mappings as well as the tuning of the sessions.
• Extensively used SQL, PL/SQL, and UNIX shell scripts.

Environment: Business Objects XI R2, Xcelsius 2008, Oracle 10g, Informatica PowerCenter 8.1.1, Toad, UNIX.
Confidential,NJ Informatica/OBIEE Developer Aug ‘07- Mar ‘08
The primary goal of this project is to develop a 1.4Tb sized Data Warehouse of a credit card division to support the high availability of ad-hoc reporting and various reporting services. Involved in the Migration of data from PeopleSoft Financials using Informatica PowerCenter 8.1.1. Scheduled the data through Data Warehouse Administration Console (DAC) for metadata management and scheduling. The project involved creating business intelligence solutions for the various work streams, by comparing and contrasting data from various sources and then consolidating them at the report/dashboard level.
Responsibilities:

• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Participated in Adding Calculations to a Fact Table for various reporting requirements
• Installed LDAP server for security using Initialization block and created variables and enabled various group level security and set up LDAP authentication.
• Created Dimension Hierarchies and Level-Based Measures for Business requirements.
• Used Aggregate Tables and specified Aggregate Levels for each source.
• Mapped Dashboard field requirements to Siebel OLTP/OLAP Physical/Business Model.
• Designed Intelligence Dashboards and created Global Filters.
• Used Session Variables in report calculations and Security implementation.
• Designed & customized Siebel Answer Views & charts, Create & save Filters, Create Charts & Tables in Siebel/Oracle BI Answers.
• Used Metadata Design Principles to Design Repository based on business requirements and followed Best Practices.
• Set up Analytics Multi-User Development environment for developers.
• Set up Analytics Server Security to control access given to business users.
• Administered Scheduler Server & Tables to set up Delivers to configure iBots based on the threshold value to the user.
• Involved in creating Complex mappings using lookup, filter, Joiner, aggregate, Sequence generator and expression transformations; using Informatica Power Center

Environment: Oracle Business Intelligence 10.1.3.3, Siebel Financial Analytics 7.8.2, Informatica 8.1/7.1, DAC, oracle 10g, PL/SQL, XML, UNIX, PL/SQL Developer.
Confidential,NY Informatica Developer Nov ’06 – Aug ’07
Confidential,is the U.S.-based division of the ACE Group of Companies, which provides insurance and reinsurance for a diverse group of clients around the world. Scope of this project involved the design and development of a Claims data warehouse, by collecting the data from source systems namely confer claims in the form of flat files and in the form of spread sheets. Business Logic and transformations will be applied to this data so that only clean, necessary and reliable data loaded into the data warehouse.
Responsibilities:

• Developed end-to-end ETL process for Insurance Claims Analysis Warehouse.
• Extensively worked on Informatica to extract data from flat files and Oracle, and to load the data into the target database.
• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems
• Imported Source/Target Tables from the respective databases and created transformations using Joiner, Routers, Lookups, Filter, Expression, Aggregator
• Extensively worked on the performance tuning of the Informatica PowerCenter Mappings as well as the tuning of the sessions.
• Created Stored Procedures for data transformation purpose.
• Developed UNIX shell scripts for error log checking and making required changes to the parameter file
• Extensively used SQL, PL/SQL, and Unix shell scripts
• Experience in creating control files to define job dependencies and for scheduling using Autosys tool.
• Assisted in the installation of Informatica PowerCenter Client and Server, and configure database connectivity using ODBC to various sources and repositories
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.

Environment: Informatica Power Center 7.1, Erwin 4.0, PL/SQL, Oracle 8i, SQL Server 2000, SQL*Loader, Windows 2000, UNIX and Autosys
Confidential, Informatica Developer Sep ‘05- Nov ‘06
Over the years, the bank has enlarged its basket of products and services to industrial concerns, covering almost the entire spectrum of industrial activities, including manufacturing and services. The project is designed for maintenance of loans given to various firms and to generate reports.
Responsibilities:

• Extracted data from Oracle, Flat files, SQL Server using Informatica Power Center.
• Implemented business Data mart with OLAP functionality.
• Implemented Aggregate, Filter, Joiner, Expression, Sorter, Lookup and Update Strategy, Normalizer, Sequence generator transformations.
• Created Mapplets in Designer and used those Mapplets in the Mappings.
• Executed sessions, sequential and concurrent batches for proper execution of mappings and sent e-mail using server manager.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.

Environment: Informatica Power Center 6.2, SQL Server 2000/2005, Oracle 8i/7i.
Confidential,India Informatica Developer May ‘03- Aug ‘05
This Project was to Build Enterprise Data warehouse (EDW) which had SQL Server for the ETL, the Primary Objective of the Project was to replace the SQL server DTS with Informatica as the ETL tool, the secondary objective was calculating the productivity of the sales personnel and awarding the most productive sales person with Special incentives.
Responsibilities:

• Responsible for the full life cycle of the warehouse from analysis through implementation into a production Data warehouse
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Created mappings using the transformations like Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Rank, Sequence Generator, Update Strategy and Joiner transformations.
• Created reusable transformations and Mapplets and used them in mappings.
• Used Informatica Power Center Server manager to create sessions, batches to run with the logic embedded in the mappings.
• Fine tuned Transformations and mappings for better performance.

Environment: Informatica Power Center 6.2, PL/SQL, Oracle 8i/7i, SQL Server.