SUMMARY

• Over 7 years of IT experience in delivering Business Intelligence solutions with expertise in gathering requirements, analyzing, developing, testing, deploying Business Intelligence BI applications using OBIEE/Siebel Analytics, Oracle Business Intelligence Publisher BI Publisher , Informatica ,BI System Administrator.
• Experience in providing end-to-end Business Intelligence solution by dimensional modeling design, developing and configuring OBIEE Repository RPD , Interactive Dashboards, OBIEE Answers, security implementation, Analytics Metadata objects, Web Catalog Objects Dashboard, Pages, Folders, Reports and scheduling Agents/iBots.
• Hands on experience in Installation, Configuration, Up-Gradation, Customization, Migration and Administration of OBIEE BI Publisher.
• Worked on Multiple source systems like Siebel , Oracle Apps on various versions.
• Extensive experience in implementing BI Publisher Pixel reports using Multiple Templates like RTF, XSLT, EXCEL.
• Hands on Configuring Usage Tracking, Configuring LDAP like OIM, AIM weblogic LDAP .
• Knowledge on Exa analytics Machine and installation experience with latest OBIEE version with OEL 5.9.
• Installation and Configuration of Oracle Business Intelligence 11.1.1.7.0, Informatica 9.0.1, Oracle DB 11.0.2.3 Software's in windows server 2008/Linux 5.9/ Oracle Enterprise Linux 5.9.
• Expertise in Handling Linux environments for Deploying OBIEE RPD Catalog and handling weblogic components.
• Expertise in Bursting the Reports with Different Output Format like PDF, Excel and RTF in BI Publisher and Different Delivery Channels like E-Mail, FTP and File.
• Expertise in converting Functional Design Documents to Technical Design Documents
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling. Extensive experience with Fact and dimensional tables, and slowly changing dimensions.
• Expert in implementing and handling the complex environments which include clustering of servers, Back up and Failover Strategies with connected and disconnected analytics
• Experience in developing Informatica Mappings/Mapplets for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets Tasks and scheduling using both Workflow Manager and Unix Shell scripts.
• Experience in performance tuning at the Database level by creating Aggregate tables, Bitmap, B-Tree Indexes, RPD level by creating Database hints in Physical Layer, Tuning Reports.
• Expertise in developing new reports, testing and customizing existing reports using SQL procedures, Reports in XML/BI Publisher and OBIEE by interacting with the business analysts and end users.
• Expertise in Design and Development of interfaces and conversion programs to integrate Oracle Applications modules and to import data from various sources into Oracle Applications.
• Strong experience in hierarchies, complex and foreign joins, initialization block, presentation/repository/session variables, calculations, aggregates, partitions, fragmentations and slowly changing dimensions.
• Expertise in gathering business requirements from end users and develop technical solutions.
• Proven ability to quickly learn and apply new technologies. Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.

PROFESSIONAL EXPERIENCE:

Confidential

BI Technical Consultant

Building Efficiency

The Building Efficiency business unit designs, produces, installs and services heating, ventilation and air conditioning systems, industrial refrigeration, building management systems, fire and security systems and mechanical equipment for commercial and residential buildings. The brands produced under this business unit are York, Metasys, Panoptix, Frick and Sabroe.

Responsibilities:

• Design, development and deployment of new OBI Reports
• Redesigning the new changes in Business with the existing warehouse system and modifying repository Answers.
• Involved in Detailed Impact analysis on the existing reports new changes into the reports and Repository.
• Experience in Offshore Onsite model coordinating with the end client with daily calls over the EOB.
• Involved in providing technical solutions to the scenarios as part of the support enhancement and redeveloped the reports as per new requirement.
• Deployed OBIEE 11g RPD and Web Catalog using Enterprise Manager.
• Extensive Development of the repository according to the BRD Business Requirements Document and building the metrics in accordance with the FSD Functional Specification Document .
• Hands on experience in data warehousing technologies including ETL, Oracle BI Server architecture, and metadata management
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer design of hierarchies, dimensions, and aggregates
• Define appropriate joins, calculations, dimensions and measures 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, Pivot, Break down Reports, Narrative and Nested reports in Answers
• Created reports with different views Compound, Chart, Table, Pivot, Ticker and Narrative
• Developed and scheduled agents for delivering personalized reports to users on time
• Secured Dashboards and Reports by defining user roles
• Implemented OBIEE security at the data and object levels.
• Worked on Creating Level based hierarchies to support drill down.
• Created report templates using BI Publisher.
• Created new reports in Usage tracking to monitor the usage of different reports and dashboards.
• Developed templates and reports in Oracle BI Publisher in rtf format.
• Applied Optimization techniques and tuned performance of the reports such as caching and building summary tables.
• Created saved filters using dynamic repository variables so business users can use these filters for ad-hoc reporting.
• Extensive usage of Presentation Variables as part of Dashboard Prompts and filter the reports accordingly.
• Created agents to seed and purge cache for cache management.
• Extensive Use of Catalog Manager to migrate the reports/prompts/dashboards from one environment to another environment.
• Conducted Training and workshops sessions for Business users from different groups and departments for smooth transition into OBIEE as BI Consumers.
• Configured Bi publisher agents to alert the users based on the requirements and scheduled BI Publisher reports in PDF/Excel/CVS formats.

Confidential

OBIEE Technical Consultant

Responsibilities:

• Design, development and deployment of new OBI Reports
• Designed the Global Analytics Reports.
• Implementation of Custom Dashboards with Budget, Forecast Accuracy, F B reports.
• Processed Reconciliation of Seeded OBIA Analytical Reports.
• Performance Tuning of the OOTB OBIA ETL process and Dashboards/Reports. This including OBIA data warehouse tuning, and caching improvements in OBI Services
• Deployed OBIEE 11g RPD and Web Catalog using Enterprise Manager.
• Extensive Development of the repository according to the BRD Business Requirements Document and building the metrics in accordance with the FSD Functional Specification Document .
• Hands on experience in data warehousing technologies including ETL, Oracle BI Server architecture, and metadata management
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer design of hierarchies, dimensions, and aggregates
• Define appropriate joins, calculations, dimensions and measures in the repository
• Created Repository Users/ Groups and Web Groups and assigned permissions 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, Pivot, Break down Reports, Narrative and Nested reports in Answers
• Created reports with different views Compound, Chart, Table, Pivot, Ticker and Narrative
• Developed and scheduled agents for delivering personalized reports to users on time
• Secured Dashboards and Reports by defining user roles
• Implemented OBIEE security at the data and object levels.
• Worked on Creating Level based hierarchies to support drill down.
• Created report templates using BI Publisher.
• Set up Usage tracking to monitor the usage of different reports and dashboards.
• Developed templates and reports in Oracle BI Publisher in rtf format.
• Extensively worked with DBAs and BAs towards performance tuning in OBIEE and Data Warehouse environment using cache management, aggregate tables, and indexes.
• Applied Optimization techniques and tuned performance of the reports such as caching and building summary tables.
• Created saved filters using dynamic repository variables so business users can use these filters for ad-hoc reporting.
• Extensive usage of Presentation Variables as part of Dashboard Prompts and filter the reports accordingly.
• Created agents to seed and purge cache for cache management.
• Conducted Training and workshops sessions for Business users from different groups and departments for smooth transition into OBIEE as BI Consumer's.
• Extensive Use of Catalog Manager to migrate the reports/prompts/dashboards from one environment to another environment.
• Conducted Training and workshops sessions for Business users from different groups and departments for smooth transition into OBIEE as BI Consumers.
• Configured Bi publisher agents to alert the users based on the requirements and scheduled BI Publisher reports in PDF/Excel/CVS formats.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 11.1.1.6.6, BI/XML Publisher, Oracle DB 11.2.0.3, Toad, PL/SQL, Oracle Enterprise Linux, OBIA/BI APPS 7.9.6.3 Accounts payable, Accounts Receivable, General Ledger, Human Resource INFORMATICA 9.0.1, PEOPLESOFT 8.9/9.1, Oracle Applications R12.

Confidential

Sr OBIEE Consultant

Responsibilities:

• Created and developed repository in various stages like importing data into the physical layer, building hierarchies in the BMM layer and finally grouping the logical tables into subject areas in the presentation layer.
• Coordinating with the ETL developers as the warehouse is updated on a weekly basis in the initial stages.
• Reports developed typically are like consolidated summary, Market summary, Corporate marketing and Distributor compensation and sales.
• Participated in the installation and upgradation of OBIEE components and contributed in documentation process.
• The reports developed are to give detail insight to the Company's executive branch in various sectors of organization performance like Key business indicators, Business Excellence, Distributor Experience, Consumer experience, Product and Brand Management on both calendar year and performance year basis.
• The above mentioned segments give in detail focus on sales of various products, changes in customer renewal counts, Distributor counts, share of a particular product in market of the related products etc,.
• Reports developed will be based on various parameters like region level, sub region level, affiliate level, market cluster level and country level.
• Developed Ibots to send reports to the customer team on a weekly basis.
• Once the development is complete, testing and validating of data across reports, migration of catalogs across DEV, QA environments.
• Created agents to seed and purge cache for cache management.
• Migration of RPD files and Web catalogs across environments as well as version controlling.
• Participating in regular meeting session to convey them of the status of development.

Environment: OBIEE 10.1.3.4,OBIEE 11.1.1.3,ODI, Oracle 11g, Oracle Data warehouse, Unix.

Confidential

OBIEE Technical Consultant

Responsibilities:

• Involved in full life cycle implementation of Inventory and SBR Modules including installation, configuration, extension and customization
• Worked with Yield Management, Pricing Management, Revenue Optimization, and other business groups to identify, analyze, document business requirements and prepare technical specifications
• Configured Integration of OBIEE with BI Publisher environment using SSO
• Configured Bi Scheduler and created iBots/Agents to schedule and deliver Analytics content to multiple delivery destinations and also as Cache Seeding mechanism.
• Implemented the Caching Strategy according to the client's data load frequency
• Enabled Usage Tracking to monitor the usage and performance of reports
• Managed/Administered OBIEE web catalog using Catalog Manager
• Implemented MUDE Multi User Development Environment in OBIEE
• Created complex measures in BMM Business Model and Mapping Layer using Level based Measures, Time Series calculations and different Aggregation Strategies
• Configured drill downs for various types of Hierarchies using Dimensional Hierarchies in BMM layer
• Created new Repository Variables, Session variables and Initialization blocks to configure security, data access and authorization on Repository and Catalog objects
• Implemented aggregate navigation by creating multiple logical table sources for the same logical table
• Configured the connection pool settings according to the requirements
• Expertise in merging repositories using UDML Universal Database Markup Language
• Experience in modifying the Request XML for Answers reports
• Created Answers reports using various analytics views like Table, Pivot tables, Charts, Column Selectors, View Selectors, Narrative, Static text etc.,
• Created common header and footer templates for all the reports in Answers
• Created new Dashboards according to best practices by using Columns, Sections and Guided Navigation
• Created Custom Styles s custom folders according to the look and feel requirements to include the client's banners, images and fonts
• Customized the OBIEE messages by creating Custom Message XML files
• Created Dashboard Prompts for Selective viewing and User Interactivity. Implemented column selector functionality using Dashboard Prompts and Presentation variables
• Was involved in Unit, Integration and System testing and performed data validation for the reports generated using Informatica and OBIEE
• Was responsible for performance improvement of the reports by using various strategies in both the database and OBIEE like Indexes, Hints in Physical Layer, Materialized views and Caching
• Integrated OBIEE with BI Publisher and created Bi Publisher reports using OBIEE metadata Requests and Subject Areas

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 11.1.1.7.0,Oracle Data Integrator 11.1.1.7.0,BI/XML Publisher, Oracle Airline data Model OADM 11.2.0.1A, Oracle DB 11.2.0.3, Toad.

Confidential

Oracle BI Apps Technical Consultant

Responsibilities:

• Participated in Installation and configuration of OBIEE and BI Apps components like DAC, Informatica Power Center and Analytics Server.
• Loaded incremental and full load data into Data Warehouse tables using Informatica and Data Warehouse Administration Console DAC .
• Involved in developing the Incremental ETL processes i.e., Mappings Map-lets using various Transformations and Workflows with Sessions/Tasks. Executed the workflows through shell scripts using pmcmd. Registered the new tasks in DAC.
• Responsible for Implementing DAC Process Life Cycle i.e. Setup, Designing, Execute, Monitor.
• Performed migration and merging of RPD's using Administration tool
• Designed and developed custom reports for Service Contracts Analytics using Answers.
• Developed Reports/Dashboards with different Analytics Views Drill-Down/ Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with Global and local Filters using Answers.
• Designed and Configured Interactive Dashboards in Analytics for different groups of users which include Managers, Functional and Department Heads.
• Implemented security by creating roles web groups, external table security using session variables, LDAP, and Object Level Security.
• Modified and created new requests in Answers using global and local filters, prompts, calculations, conditional formatting in various analytical views.
• Setup usage tracking and developed usage tracking reports.
• Created iBots and delivers to send alert messages to subscribed user groups.
• Scheduled iBots and seeded server cache using Delivers to improve system performance. Also used iBots to clear server cache using NQCmd utility. Scheduled reports to be e-mailed using iBots.
• Created Dimension hierarchies to achieve the drill down functionality.
• Developed Mappings using Transformations like Source Qualifier, Sequence Generator,Filter,Router,Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Designed and Developed Informatica Sessions and Workflows.
• Designed, implemented and tested security privileges on subject areas, dashboards and reports.
• Customized standard reports like Aging and Invoice reports in Receivables using XML/BI Publisher.
• Developed Inventory BI Publisher reports like Inventory details, Price evaluation.
• Customized the existing XML/BI Publisher reports as per client requirements.

Environment: Oracle Business Applications Loyalty, Finance, Customer care support , Oracle 10G,OBIEE 10.13.4.1,BI Applications 7.9.6.2, Informatica PowerCenter 8.6,Siebel CRM 8.1.1.5, Toad, SQL Developer, XML/BI Publisher 10.1.3.4.1, UNIX, Filezilla, Winscp.

Confidential

Oracle BIPublisher/ Siebel Technical Consultant

Responsibilities:

• Was involved in the installing and configuring of Oracle Business Intelligence Publisher standalone application in multiple instances.
• Analyzed the requirements and developed the technical documents.
• Experience in Integrating Bi publisher application with Siebel Application.
• Managed and Customized reports both in standalone BIPublisher and integrated with Siebel application reports as per business requirement.
• Experience in Configuring various inbound and outbound elements for Siebel integration with bi publisher.
• Configuring LDAP Security implementation with tools like Oracle OID and IBM AIM.
• Gathered requirements from the client for GAP analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
• Worked on deploying code from once instance to another like SIT, UAT and PROD .
• Involved in Installation of BIP latest Patch with the assistance of My Oracle Support .
• Worked on the testing and validating the Repository.
• Created and customized Siebel Integration Objects, Integration components and associated Columns in Siebel Tools as per requirement.
• Worked on Associating Siebel Integration reports to multiple Siebel View's.
• Developed adhoc reports multiple templates like RTF, Excel, XSLT as per business requirement.
• Configured Bi publisher reports on multiple frequency and multiple Output format using BI Publisher Scheduler.
• Involved in Using advanced Bursting features for bursting the standalone BIPublisher reports in order to generate Invoice for Loyalty Members.
• Worked on Multiple Category of reports like customer service , marketing, finance, fraud, Non airline billing partner, Airline billing partner and operation reports from three different Sources like Siebel , PBA and PFX.
• Involved in migration of deliverables such as PL/SQL packages, XDO Files, RTF templates etc to various environments using the Winscp and Filezilla migration tool.

Environment: Oracle Business intelligence Publisher 10.1.3.4.1 /2, Oracle 11G 11.2.0.1,InformaticaPowerCenter 8.6.0,Partner Billing Application Java based application ,SQL Plus, TOAD, PL/SQL, Winscp, Filezilla, UNIX, Windows.

Confidential

OBIEE Developer

Responsibilities:

• Involved in gathering the requirements, performing scope analysis and identifying gaps
• Developed OBIEE Repository RPD per user requirements and available information in DW
• Analyzed and validated the business model in Siebel Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer
• Implemented Security for various users and groups using External Table Authentication
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner
• Created Session and Repository Variables and Initialization Blocks for desired functionality
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities, Dashboard/Page Prompts
• Responsible for creation of pivot table requests and bar/column charts allowing manager to analyze the business from different perspectives provided optimized Analytics request using column selector/view selector, multi-select page prompts
• Created and used Siebel Delivers and iBots extensively
• Developed and debugged Dashboards/ reports visibility with respect to user's responsibility and web groups in an integrated environment
• Developed Informatica mappings with re-usable transformations and Mapplets using various transformations
• Extensively involved in performance tuning of the Informatica ETL mappings like increasing the caching size, overriding the existing SQL
• Developed / modified mappings per gaps identified
• Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug SQL query issued during report execution
• Coordinated the OBIEE RPD and Web Catalog object's migration from Dev environment to QA environment and to the Production environment

Environment: OBIEE 10.1.3.4, OBIEE Apps OBIA 7.9.5, Oracle EBS 11.x, Oracle 10g/11g, Putty, DB2, UNIX, XML, OLAP, Oracle Forms, ETL, DAC 7.5, SQL Loader, SQL, PL/SQL, TOAD.

Confidential

OBIEE Developer

Responsibilities:

• Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities.
• Used the Siebel Analytics Admin Tool to develop the 3 layers in the Repository.
• Created connection pools, physical tables and defined primary key, foreign key joins, complex joins in the physical layer of the repository.
• Configured Security at the object level brought up the OBIEE reports and dashboards to respective users.
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys.
• Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Created Proactive agents iBots and configured Interactive dashboards to alert the employees as per the requirements.
• Used various Transformations like Router, Update Strategy, Lookup, Filter, Aggregator, and Expression for the exact results according to Business Requirements.
• Using Workflow Manager for Workflow and Session Management, database connection management and Scheduling of jobs to be run in the batch process.
• Formatted columns used in generating the requests and used various filtering options as and when needed.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.
• Worked on improving the dashboard performance, readability, and security.

Environment: OBIEE, Siebel Analytics 7.5, Oracle 9i, DAC, Informatica 7.1, UNIX, Win XP.