Professional Summary

• Seven plus years of total IT experience across Data warehouse development providing business intelligence solutions using OBIEE (Siebel Analytics) reporting tools.
• Experience with Data Integration and Analysis for Decision Support Systems in Banking, Pharmaceutical, Telecommunication, Health Care industry domains.
• Effective experience in Complete Software development Life cycle (SDLC)(Iterative, Waterfall methodology, Agile, RUP) which includes Business Requirements Gathering, System Analysis & Design, Data Modeling, Development, Testing and Implementation of Data warehouse and Business Intelligence Applications.
• Extensive experience on OBIEE/Siebel Analytics features (i.e. Clustering, Security, cache, usage tracking, dimensional hierarchy, aggregate navigation, MUD, Disconnected, Integration Variables/Initialization Blocks configuration etc.)
• Solid understanding of Oracle Business Intelligence Enterprise Edition (OBIEE 10.1.3.x), its architecture, components (OBI Server, Oracle BI Presentation Services, Web cat file, config files and other tools and utilities), Siebel Analytics 7.x, and Informatica 8.x/7.x/6.x.
• Hands-on experience in building the OBIEE (Siebel Analytics) Repository (.rpd) file, Interactive Dashboards/Answers, Security Setup and scheduling iBots using Oracle BI delivers.
• Extensively worked on BI Answers, BI Dashboards, BI Deliver, BI Server and BI Publisher.
• Excellent experience in creating pixel-perfect BI reports using Oracle BI Publisher.
• Configured and installed BI Publisher and integrated with OBIEE server and created Smart View Report Templates.
• Ability to enhance performance by understanding when & how to leverage aggregate tables, materialized views, table partitions, indexes, and managing cache etc.
• Strong understanding of ETL, OLAP, Star Schema, Business Process Analysis, Dimensional Data Modeling, Physical & Logical Data Modeling.
• Hands-on experience with prebuiltOracle BI Appsfor HR and Financial modules.
• Highly proficient in Design, Development, Implementation, Administration and Support of ETL processes for Data Marts and large scale Data Warehouses using Informatica Power Center 8.x, 7.x, 6.x1, Power mart and Metadata Reporter.
• Experience in extracting data from Oracle EBS, PeopleSoft, Siebel CRM, OLTP, and integration and loading data to OLAP systems.
• Practical, hands-on experience working with Informatica Data Integration Tools – Repository Manager, Designer, Workflow/Server Manager, and Workflow Monitor.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle 10g/9i/8i, SQL Server 2005/2003, and DB2 and worked on integrating data from various types of flat files, COBOL files and XML files.
• Expertise in writing, testing and implementation of Stored Procedures, Triggers, Functions, Packages and design of star schema at database level using SQL, PL/SQL.
• Experience in using Data Warehouse Administration Console (DAC) to schedule the Informatica jobs and metadata management.
• Sound Knowledge of Relational and Dimensional Modeling techniques.
• Extensive experience in Data Modeling using ERWIN.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers. Proficient in Toad.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure.

Technical Skills

BI Tools:

OBIEE 11/10.1.3.4/10.1.3.3/10.1.3.2, Siebel Analytics 7.8.5, BI Publisher

BI Applications:

Oracle BI Apps -7.9.6/7.9.5/7.9.4

Languages:

SQL, PL/SQL, C, C++, HTML, XML, Java Scripts, AOL.

ETL Tools:

Informatica PowerCenter 8.6/8.5.1/8.1.1/7.0

Data Modeling:

Dimensional Data Modeling -Star, Snowflake Modeling.

RDBMS:

Oracle 11g/10g/9i, Oracle EBS, SQL Server 2005/2000

Environment:

Windows, Linux, Unix, Solaris

Technical tools : Toad, SQL Developer, Erwin Data Modeler 4.x/7.3.x, SSRS

Educational Qualification

Bachelors in Computer Science Engineering

Professional Experience

Confidential,Boston, MA May’10 - Till Date
Sr.OBIEE Developer / BI Publisher

Description: The project involved implementation of HR operating and analytical reports. HR Data Mart was built from the base tables to enable optimal reporting environment based on the client requirements. The project is focused on developing various detail and summary reports that will prove helpful for the Business Users.
Responsibilities:

• Worked with functional and technical project leads, finance, and other business groups to identify, analyze, and document Business requirements.
• Developed proof of concept to check the functional feasibility of the OBIEE implementation.
• Involved in Installation, configuration and administration of OBIEE server and repository.
• Effectively managed ODBC connections and imported the Physical tables, keys and physical joins from the databases.
• Designed Star-Schema using Facts, Dimensions, Physical, Logical, Alias and Extension tables and established relationships & Foreign Keys (Physical & Logical) between tables.
• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer, Created session & repository variables using OBI Administration Tool.
• Created Org Dimensional Hierarchy with drill-down capabilities using global and local filters, Logical tables & columns, Aggregate columns, Time-Series and Level based Measures & Aggregate navigation and customized Star and Snowflake schemas by linking Fact and Dimension tables in the BMM layer.
• Managed security privileges for users & groups using LDAP & SSO authentication, OS external database authentication/login as well as Dashboard/Report-level security.
• Configured Analytics Metadata objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard, Pages, Folders, and Reports).
• Developed and debugged many Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector).
• Utilized Oracle BI Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to interactive dashboards for subscribed users.
• Optimized performance using Indexes, Aggregate tables and materialized views.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters and custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboards as per requirements.
• Performed end-user training to develop ad-hoc reports using BI Answers.
• Used Data Stage for ETL purpose, for Data Extraction from source tables, Data Mapping and Data Conversion (Transformation) and Data loading into the HR Data Mart.
• Installation and configuration of BI Publisher. Experience in BI Publisher with reference to calling templates from one template to another and in calling stored procedures in BI Publisher reports.
• Developed BI Publisher reports for upper management to view their associate profiles for decision making purpose, and bursting reports using it.
• SourcedAP and ARtables form BI Publisher and created reports. Performed Unit, Integration, and Regression testing to validate report and mapping functionality.
• Created highly formatted reports using BI Publisher based not only on conventional data sources (such as Oracle Database) but also on various other data sources (such as Web Services, RSS feeds, and so on).
• Participated in the complete SDLC starting from Analysis including design, development, testing, implementation and maintenance of the HR Hub reporting application.

Environment: OBIEE 10.1.3.4, BI Publisher, SQL Server 2005, IBM InfoSphere DataStage 8.0, Microsoft SQL Server Management Studio Express 9.0, SQL*Plus, SQL*Loader, Windows NT Server/XP, UNIX.

Confidential,Memphis, TN Dec\'08 –Apr\'10 OBIEE Developer

Description: The purpose of this project is to access, integrate, and trust the data so they can increase operational efficiency, better manage regulatory compliance, and grow revenues. In this project we pull data together from disparate sources to determine the most cost-effective, revenue-enhancing combinations of services. We generate timely, accurate reports that meet regulatory requirements.

Responsibilities:

• Interacted with business representatives for requirement analysis and to define business and functional specifications. Interacted with the business leads and Client to gather reporting requirements to provide reports focusing on AR and AP Modules.
• Designed and developed the OBIEE/Metadata Repository (.rpd) using Siebel Analytics Server Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies) & Logical & Facts/ Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• IntegratedMapViewerin OBIEE Dashboards to show the shipment orders from the customers from different states.
• Used Analytics Scheduler to configure Delivers and iBots to notify the corporate managers and region managers immediately about the messages. Generated iBot alerts for reports to be delivered by email.
• Developed Time Series objects for comparing the usage variations between the current and previous years and months.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the Sql execution path by making use of hints etc.
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Deployed Informatica workflows to Data warehouse Application Console (DAC) for parallel execution of various tasks with in an execution plan with their respective priority. Automized full and refresh mode optimization rules. Performed load balance across multiple Informatica servers.
• Configured the OBIEE Analytics Web, Generated Reports and Dashboards using OBIEE Answers.
• Used Oracle BI Web Services to embed the results of Oracle BI Presentation Services into External Applications.
• Developed Mappings and Workflows using various Transformations (Update Strategy, Router, Expression, and Aggregator) for extracting the billings data from Oracle Applications.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems.

Environment:OBIEE 10.1.3.3, Oracle BI Applications 7.9.5/7.9.6 (Financial analytics), Informatica 8.1.1, DAC, Oracle 11g, Oracle EBS, SQL Developer, SQL*Plus, Windows-XP

Confidential,Atlanta, GA Jan\'07-Nov\'08
Siebel Analytics / Informatica Consultant

Description: This Project is to Design and Construct Enterprise Database for integrated Customer Information System (CIS) and the Billing System to establish a robust and cost effective Customer Management Process. Distributed data residing in heterogeneous data sources is consolidated into the target Oracle 9i enterprise Data Warehouse database.

Responsibilities:

• Customized and developed RPD, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Configured measures in the BML and mapped to multiple logical source tables.
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities.
• Mapped the configurations to accommodate for the territorial hierarchy that were accommodated via chart drilldowns.
• Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives provided optimized Analytics request using column selector.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Administered security and created alerts.
• Created templates for presenting results and Analytics and modified the Siebel Dashboard using cascading style sheets.
• Developed many Mappings & Mapplets using various Transformations (Update Strategy, Router, Expression, Stored Procedure, Lookup, and Aggregator) and Workflows with Sessions / Tasks. Executed the workflows through shell scripts using pmcmd.

Environment:
Siebel Analytics 7.8.5, Informatica PowerCenter 8.1.1, Oracle 10g, HP-Unix.

Confidential,Hyderabad, India Apr’05-Nov‘06
Siebel Analytics Application Developer

Description: Dr. Reddy’s is a global, vertically integrated pharmaceutical company with a presence across the value chain, producing and delivering safe, innovative, and high quality finished dosage forms, active pharmaceutical ingredients and biological products.
R&D uses Siebel eClinical application for Clinical Trial tracking of the studies conducted by the company. The project aimed to develop a user-friendly, web-based clinical trial system, which will allow maintenance of a centralized database for the clinical trials across the globe.

Responsibilities:

• Configured analytics repository with logical dimensional modeling using Star Schema (Facts and Dimensions). Extensively used Siebel Analytics Administration Tool for customizing and modifying the physical, business and presentation layers of metadata repository.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Created connection pools to retrieve data from Siebel OLAP layer, Siebel OLTP data and data from Oracle Database.
• Modified the customer and product hierarchies by assigning custom attributes to various levels in the hierarchy tree structure
• Specified aggregate levels for each source and created dimension sources for each level of aggregates.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Created Analytics Reports including Charts and Pivot table’s Compound layout using Siebel Answers.
• Created ibots and Delivers to send Alert messages to subscribed users.
• Worked extensively on Unit testing, Integration testing and fixed bugs during the UAT phase.
• Worked on various Informatica mappings as per business requirement.
• Performed end-user training to develop ad-hoc reports using Siebel Answers.

Environment: Siebel Analytics 7.8.2, Siebel eclinical, Informatica 8.0, Oracle 9i, Windows 2000.

Confidential,Hyderabad, India June\'04-Mar\'05
ETL Informatica Developer

Description: The Sales and Marketing department of the bank categorizes customers based on significant set of portfolio services that includes checking accounts, savings accounts, personal loans, credit cards etc. A data warehouse was developed in line with the business strategy to perform advanced analysis of the customer data to help offer better service and recommend new product offerings based on their needs. Data about the customers were collected from different systems and aggregated within the data warehouse.

Responsibilities:

• Designed the mappings between sources to operational staging targets.
• Used Informatica Power Mart / PowerCenter as an ETL tool for building the data warehouse
• Employed the Aggregator, Sequencer and Joiner transformations in the population of the data
• Responsible for modeling the physical database design using ERWin.
• Used Business Objects designer in coming up with standard report templates.
• Data transformed from SQL Server databases and loaded into an Oracle database.
• Responsible for creating the repository in Oracle database using Business Objects Supervisor.
• Created different types of reports like Master Detail, Cross Tab and Charts.
• Dealt with Trade Fund where we keep track of how much money business will have in trade promotion checkbook, if business hit volume goal to reveal a better estimate of available trade funds. So that proper decisions can be taken before overspend or under spend, for this preformatted and customizable reports and graphs, plans, payments, deductions are been made, both promoted and non-promoted volume and budget is been updated with actual spending when executed.

Environment:
Informatica Power Mart / Power Center 7.0, Business Objects 5.1, ERWin 3.5, SQL Server 7.0, Oracle 10g.