Professional Summary

• Dedicated IT professional with 7 years of progressive expertise in design, configuration, development, testing and implementation of Siebel Analytics, Oracle Business Intelligence, ETL Tools, RDBMS projects and Data warehousing.
• Expertise in handling all phases of Software Development Life Cycle SDLC including Planning, Analysis, Design, Implementation, Installation, Upgrading , Migration ,Maintenance and post production support of the BI Projects.
• Experience in providing end to end BI solutions configuring Star schema design, Fact and Dimensions tables, Physical and logical data modeling in OBIEE 10g and 11g.
• Strong experience in OBIEE 11.1.1.5/10.1.3.x, Siebel Analytics 7.x, which includes design and development of OBIEE repositories at three levels Physical Layer, Business Model and Presentation Layer .
• Expertise in converting Functional specs to Technical Specs and implementing OBIEE Best practices.
• Proficient in providing end-to-end business intelligence solution by dimensional modeling design and customization of BI Answers/Analysis, Reports, Interactive Dashboards, Oracle Delivers.
• Experience in configuring Security Settings groups, roles, access/query/report privileges at different levels of data and objects.
• Worked on scheduling iBots/Agents for OBIEE 10g and OBIEE 11g.configuring Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, and Reports .
• Experienced in Global Delivery Model Onsite/Offshore . Coordinated activities onsite offshore towards meeting project timelines.
• Extensive experience in Repository and Reports performance tuning using Cache management techniques.
• Experience in extraction of data from various heterogeneous sources Relational database, Flat Files, XML, Excel to load into data warehouse/data mart targets.
• Expertise in implementing Oracle BI Apps in all phases including implementing Out of order Box prebuilt mappings, Designing ETL, metadata management using DAC, OBIEE RPD development, OBIEE reports and dashboards.
• Monitoring the operation of servers in cluster by using cluster controller.
• Expertise in creating Dynamic Dashboards and Reports using prompts, filters, calculations, conditional formatting and drill down properties.
• Developed Reports / Dashboards with different Analytics Views Drill-down / Dynamics, Cascading style sheets, Pivot table, Chart, Column Sector, Tabular with local and global filters using Presentation service.
• Proficient in back-end programming with Oracle PL/SQL and SQL
• Proficient in Oracle Tools such as SQL Developer, SQL Loader, SQL Plus, Data Loader and TOAD
• Designed Report Templates using XML/BI publisher
• Strong experience in creating scorecards in OBIEE 11g
• Providing an integrated way to manage Oracle Application Server components through OPMN

Technical Proficiencies:

Professional Experience:

Confidential

OBIEE Consultant

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:

• Work closely with end users to designing reports and dashboards, suggesting better ways of reporting in OBIEE so that the required information is visualized by end users.
• Customized Oracle BI Repository defining Physical Data Layer and developed Business Model and Presentation Layer using Administration Tool.
• Implemented BI Publisher and created business reports using BI Publisher.
• Configured Database to authenticate users against Microsoft Active Directory.
• Extensively worked with performance tuning of the mappings, sessions and Stored Procedures.
• Developed re-usable transformations, mappings and Mapplets conforming to the business rules.
• Involved in the design, development and testing of the PL/SQL stored procedures and packages for the ETL processes.
• Developed many Reports / Dashboards according to the requirements of the users using Presentation Services
• Created dimensional hierarchies and set levels in the Business Model Layer and Mapping Layer of repository for implementing drill down, Aggregation and sum over columns
• Used appropriate column filters, dashboard prompts and calculations in reports
• Added users and configured security in web logic console of OBIEE 11g
• Created various Ad-hoc reports for day-to-day business requirements
• Building scorecards with OBIEE 11g.
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment
• Configured Agents to deliver Analytics content based on schedule, automated Agent queries to obtain daily and weekly reports
• Monitored day to day data load of the warehouse
• Involved in resolving the issues related to access of reporting application Used Informatica Mapping Designer to create/update mappings using different transformations required to move data into data warehouse
• Monitoring Incremental and Full load through DAC
• Used Informatica Mapping Designer to create/update mappings using different transformations required to move data into data warehouse

Environment: Oracle 11g, OBIEE 11.1.1.7, Web Logic Server, Informatica Power Center 9.0.1, DAC 10g, SQL Developer

Confidential

OBIEE Developer

The Finance department of the bank categorizes customers based on a significant set of portfolio services that includes checking accounts, savings accounts, personal loans, credit cards etc. It enabled organization to develop and influence more intelligent business decisions, improve overall profitability. The Data Warehouse incorporated financial information from various data sources into one central repository providing the organization a cross-enterprise consolidated view of the information. Siebel Analytics was used to analyze information on revenue, cost, profitability, volumes, productivity and revenue generated by region, market segment.

Responsibilities:

• Involved in full project life cycle implementation of Data Warehouse and participated in designing STAR schema and developed complex Mappings/Mapplets using various Transformation/Re-usable Transformations Update Strategy, Filter, Router, Expression, Stored Procedures, Lookup and Aggregator for implementing the Data Warehouse.
• Involved in full project life cycle implementation of Data Warehouse and participated in designing STAR schema and developed complex Mappings/Mapplets using various Transformation/Re-usable Transformations Update Strategy, Filter, Router, Expression, Stored Procedures, Lookup and Aggregator for implementing the Data Warehouse.
• Created reporting metrics and transferred key performance indicators to a process and database design.
• Worked on the enhancements of the existing reports as well as Change Requests.
• Provided Application support by identifying inconsistencies and implementing alternative and efficient solutions
• Worked with customers to help identify the best ways to improve the current reports/dashboards.
• Involved in performance tuning activities for the problematic reports.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups
• Developed and tested stored procedures, functions and packages in PL/SQL for data ETL process.
• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Developed different kinds of reports pivots, charts, tables using global and local filters.
• Configured Interactive Dashboards with delivers/iBots to alert the marketing team about business changes.
• Managed day-to-day Repository, Siebel Delivers, Scheduler and iBots.
• Member of application team with knowledge of oracle financial application Billing and revenue management BRM .
• Configured metadata objects Subject Area, Table, and Column and Web Catalog Objects Dashboard, Pages, Folders, and Reports .
• Used SQL Loader to load the data from flat files and CSV files into the database.
• Deployed OBIEE 10.1.3.2 RPD and catalog by using Enterprise Manager
• Configured Row Level Security, Column Level Security and Object level security to allow users to view their respective data only according to the requirement.
• Performed Unit, Integration and Regression testing to validate reports and mappings.

Environment: Oracle Business Intelligence 10.1.3.2, BI Publisher 10g, Oracle 10g, TOAD, DAC 7.9.5, SIEBEL Analytics 7.x, RPD, Dashboards, Delivers iBots .

Confidential

OBIEE Developer

The project involved developing a BI solution for strategic analysis by sales, marketing, and pricing to provide marketing and campaign management capability, an ability to measure effectiveness across all products and provide single data set for analysis and tracking of results to the management. Worked with Business Analyst and analyzed the business requirements for developing the Repository and extraction of Reports.

Responsibilities:

• Analyzed the specifications provided by the client, understanding the business.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, and BI Publisher.
• Designed Star Schema for fact dimensional tables and created Alias for the dimension and fact tables when necessary.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports.
• Developed Physical, Business Model Mapping and Presentation Layer using Oracle BI Administration Tool.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions.
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Created various reports to fulfill the marketing needs and customized the views using Oracle BI Answers.
• Designed and Configured Dashboards in Analytics for different groups of users, which include like Managers, Functional Heads, Department Heads.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions
• Designed and developed General Ledger, Payables, Receivables and Profitability Dashboards in OBIEE.
• Developed Dashboard pages like Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
• Developed Dashboard pages like Overview, Margins, Revenue, Products and Customers in Profitability Dashboard.
• Developed and debugged many Dashboards using different Analytics Views Pivot Table, Chart, and Column Selector, View Selector , Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Used the Catalog Manager and maintained the Analytics web catalog to manage Dashboards Answers.

Environment: OBIEE 10.1.3.2/10.1.3.3, Informatica 8.1.1, XML/BI Publisher 5.6.3, BI Apps 7.9.5, Oracle 10g, BI Publisher, Windows XP, Toad.

Confidential

Siebel Developer

The Accounts and Administrative system deals with the overall functions of the accounts department right from the initial input of the transaction to the final presentation of the financial statements. The system was built to transport data from these source systems into one integrated data warehouse, which would allow for storage and reporting.

Responsibilities:

• Evaluated business requirements against the Siebel CRM out-of-the-box capabilities and looked for opportunities to adapt the business needs to existing functionality.
• Created detailed designs related to Siebel applications using Siebel tools.
• Configured and modified the Siebel Applications as per the Detailed Design.
• Responsible member of the Siebel Operations Support Team with rotational and on-call duties for Tier II and III support of the Siebel application.
• Performed Unit Tests and Documents modifications made to the Siebel Applications.
• Analyzed development or support requests in to technical design and developed appropriate solution on Siebel platform
• Responsible for knowledge transfer/ cross-training with other members of Siebel Application Development staff.

Environment: Siebel Analytics 7.5.2, Oracle 9i, PL/SQL, Windows 2000, UNIX