Professional Summary:

• Over 7 years of progressive experience in all phases of the Full Life Cycle Development of diverse web-based and Business intelligence applications. Possess strong understanding of cutting edge technologies, quick learning and problem solving skills. Have excellent communication and presentation skills.
• Experienced in Business Model development with Dimensions, Hierarchies, Measures, Aggregation, Time Series, Caching, authentication and authorization data and objects .
• Extensive experience in configuring Interactive Dashboards with drill-down capabilities, Security Setup, Metadata Objects and Web Catalog Objects.
• Experience in Complete life cycle of Business Intelligence with Star and Snow flake Schema Methodologies.
• Extensive experience in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets Tasks and scheduling using Workflow Manager.
• Expertise in developing OBIEE repository with Physical, Logical and Presentation layers build reports/dashboards from the repository using OBIEE Siebel Answers and troubleshoot various technical issues and bugs.
• Involved in Performance tuning at the ETL level, OBIEE-RPD, Dashboard Server Level.
• Good knowledge on various activities like import and export of Datastage projects.
• Developed Delivers iBots/Scheduler to automate report delivery and provide alerts on Interactive Dashboards.
• Experience in managing users and groups, setting up their privileges and administering the Object Level Security and Data Level Security using different authentication methods.
• Strong experience in developing warehousing applications and customizing Reports using OBIEE 11.1.1.5, 10.1.3.4.x/10.1.3.2.x, XML/BI Publisher,Siebel Analytics 7.x
• Expertise in designing and developing custom reports using BI Answers and making them available in Dashboards.
• Highly reliable and productive, possess good interpersonal communication skills and leadership qualities.

Confidential

• Technical Skills Summary:
• BI Tools: Oracle Business Intelligence Enterprise Edition 10.1.3.x,
• Siebel Analytics 7.8.x, 7.7.x, 7.5.x, Oracle BI Apps 7.9.6.2
• ETL Tools: Informatica power Center 9.0.1x/8.x/7.x/6.x.
• Data Modeling: Dimensional Modeling, Star, Snowflake.
• Databases: Oracle 9i/10g/11g,SQL Server.
• Programming Languages: C, C , .NET, PL/SQL, UNIX Shell Scripting
• Admin Console: DAC 10.1.3.4/1 Data Warehouse Administration Console
• . Web Technologies: HTML, XML, Java Scripts.
• Operating Systems: Windows 98/NT/2000/XP/2003 Server.

Professional Experience:

Confidential

Oracle BI Consultant

Description:

Confidential provides a comprehensive line of banking, loans, insurance, investment, mortgage, and trust and payment services. OBIEE Platform Solutions was implemented for providing interactive Dashboard access to strategic business information on services, finance and various features of the Bank, top of the house from the company-wide data warehouse analytical information in Re-Anticipation Loan at HSBC, a world-wide financial services company.

Responsibilities:

• Involved in Gathering, Analyzing Business Requirements for Reports.
• Created/Modified Metadata repository .rpd , Customized BI Repository, defined/developed Physical Data Layer, Business Model and Presentation Layer using BI Administration Tool.
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
• Development of interactive flash-based drillable charts such as bar-charts, pie-charts, radars, bubble-charts, etc using BI Server.
• Implemented Delivers using iBots for delivery of reports through email, hand-held devices and mobile phones.
• Involved in Security management for users, groups and web-groups using the various authentication systems such as LDAP authentication using Session Variables, as well as Dashboard / Report-level security.
• Implementation of criteria filters to narrow-down the result set from the analytics requests.
• Implemented event polling cache refresh strategy to cache reports and improve performance of long running reports.
• Developed/Bench-Marked performance tuning strategies with business model-level calculations versus Data warehouse level pre-computations and aggregations.
• Expertise in Creation of Subject areas and Developing Reports .
• Involvement with ETL Extract-Transform-Load development team to communicate the specification for the required dimensional, aggregate and indexed data tables.
• Implemented different Passive and Active transformations like Source Qualifier, Joiner, Aggregator, Lookup, Rank Expressions, Update Strategy and Stored Procedure Transformations in Mappings.

Environment: OBIEE 11.1.1.5, Oracle BI Publisher 11.1.1.5, Oracle 11g, , SQL Developer, Oracle Application Server 11.1.1, Datastage 8.1

Confidential

Oracle BI Consultant

Description:

This project is to use a data warehouse to analyze the effectiveness of the marketing campaigns for the incentives and financial services offered by Advanced Auto Parts. This data warehouse was developed by extracting data from Oracle and different sources and is loaded into an oracle target. Different customer related metrics like customer opinions, loyalty, customer profiles and customer satisfaction are analyzed.

Responsibilities:

• Worked on Oracle BIEE Administration tool for customizing the Physical layer, Business layer, Presentation layer and modifying it according to the business requirements.
• To create Connection pools, import physical tables and define joins in the Physical Layer.
• Developed and customized some of the existing Dimensions Drill-Down Hierarchies Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Created Global/Local Prompts, Narrative Views, Filters, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Created Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also managed security for groups in BI Answers.
• Developed Dashboards for each of metrics by embedding reports and providing intuitive drill-downs and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Worked in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Enhance performance of Reports/Dashboards by implementing the Aggregate tables, Table execution path by making use of hints, Creation/Re-building of Indices and Cache Management.
• Involved in developing the Incremental ETL process Mappings Mapplets using various Transformation and Workflows with Sessions/Tasks, executed workflows through shell scripts using pm cmd.
• Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 10.1.3.2, EBS R12 Financials Oracle BI Apps 7.9.5,7.9.6, Informatica Power Center 7.8.4, Data Warehouse Administration Console DAC , Oracle BI Publisher, Oracle Delivers, Windows XP, UNIX/LINUX Oracle 11g/10g, SQL, PL/SQL, and TOAD 6.3/7.0.

Confidential

Oracle BI Consultant

Description:

Consumer Sales reporting project built using their stand alone Siebel Analytics to report effective sales of various consumer products globally. It enabled them to report the consumer sales trends and to take effective business decisions.

Responsibilities:

• Designed and Developed the Analytics repository Physical Layer, Business Model and Mapping Layer and Presentation Layer .
• Developed many Reports / Dashboards with different Analytics Views Pivot Table, Chart, Tabular, etc. for performing the Marketing Trend analysis using Siebel Analytics Web.
• Developed Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions AGO and TODATE functions based on the Requirements.
• Designed and tested reports for Sales analytics and Order management analytics in Oracle BI Apps.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business.
• Developed complex mappings by extensively using the Informatica transformations and flagging the records using the update strategy for populating the desired SCD tables.
• Used Workflow manager and Workflow monitor for Workflow, sessions and database connection management and workflow monitoring.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler iBots.
• Enhance performance of Reports/Dashboards by implementing the Aggregate tables, and Cache Management.
• Created saved several BI Publisher reports by selecting an Answers request as Data Source.
• Performed Pre/Post implementation testing of Dashboard, Answers and validating Repository.

Environment: Siebel Analytics 7.1.3, Oracle BI Apps 7.9.5, Informatica Power Center 8.1, Data Warehouse Administration Console DAC , Oracle BI Publisher, Oracle Delivers, Windows XP, UNIX/LINUX, Oracle 11g/10g, SQL, PL/SQL.

Confidential

Oracle BI Consultant

Description:

Confidential Business Intelligence Team delivers Enterprise reporting capability using a powerful combination of Oracle'sbusiness Intelligence Suite OBIEE , Pre-built analytics of Financial Management and Procurement applications, as well as dashboards, Pre-built reports, and queries for Business Intelligence users that leverage these tools. Reporting and publishing capabilities deliver pre built reports in support of standardized business processes and decision making activities.

Responsibilities:

• To analyze the specifications provided by the client, understanding the business.
• Involved in RPD Development, Oracle BI Server, Oracle BI Answers, DAC Configuration, ETL Configuration, and Oracle BI Publisher.
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports.
• Created various reports to fulfill the marketing needs and customized the views using Oracle BI Answers.
• Designed and Configured Interactive Dashboards in Analytics for different groups of users which include like Managers, functional heads, Department Heads.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, criteria filters, Pivot Table, Chart, Column Selector, Tabular with global and local Filters using Siebel Analytics Web / Oracle BI Presentation Services.
• Installed and set up Informatica environment and responsible for administration and migration or repositories between various environments.
• Used various transformations like Source qualifier, Aggregators, Dynamic Lookup, Router, Sequence generator for mappings based upon the requirement.
• Designed and developed Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for extraction, transformation loading.
• Worked for performance tuning by finding out the bottlenecks in various mappings.

Environment: OBIEE 10.1.3.4, Oracle BI Server, BI Answers, BI Administration, BI Dashboards, BI Scheduler, BI Publisher, Oracle BI apps 7.9.5, Informatica 8.1, Oracle 10g, PL/SQL Windows XP Prof.

Confidential Consultant

Description:

• Confidential is the most successful specialty retailer in operation today. Their casual, classic, all-American lifestyle brand of clothing is synonymous with quality and encompasses five concepts: Abercrombie Fitch, Abercrombie, Hollister Co., RUEHL No. 925, and Gilly Hicks. As a OBIEE developer I worked on Trickle Tender and NEEDS which help users to know their foreign customers transactions and the store Inventory Needs . Responsibilities:
• Identified the granularity level of the data required to be available for analysis.
• Developed Metadata repository .rpd , configured metadata the Business Model Layer Physical Data Model and Web Catalog Objects as per the reporting requirements using OBIEE Admin and Web tool.
• Worked on Oracle BI 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 OBIEE Dashboard using cascading style sheets.
• Involved in Reconciliation Process while testing loaded data with user reports.
• Developed different kinds of Reports pivots, charts, tabular using global and local Filters.

Environment: OBIEE 10.1.3.4, Netezza, Oracle10g , SQL, Oracle SQL developer, data stage, Linux.

Confidential

Oracle data warehouse developer

Description: Involved in the design and development of Inventory Control System. It provides information like products available, quantity on hand, vendor information vendor evaluation etc. The basic functions include receiving indents from various departments and consolidating, generating tender documents, quotation evaluation, generating purchase orders and amendments, scheduling of material receiving, generating goods receipts, preparing material rejection notes, invoice verification etc.

Responsibilities:

• Involved in the design, development, testing phases of the project and Enhancements.
• As an Oracle implementation team member, worked on writing custom forms and custom tuning the reports.
• Developed Database Triggers in order to enforce complicated business logic and integrity constraints, and to enhance data security at database level.
• Developed Custom forms to view edit the data in custom interface tables and event handling tables using template forms.
• Created packages for initial load and daily updates.
• Developed and tested Store procedures, Functions and packages in PL/SQL for Day to Day Production support.
• Root Cause Analysis and Fixing issues.
• Involved in fixing the bugs reported back after initial stages of implementation.

Environment: Oracle 8i, MS Access, SQL, PL/SQL, XML, Windows XP.