SUMMARY:

• 8 years of experience in overall SDLC, 5+ years of experience in OBIEE (Oracle Business Intelligence Enterprise Edition)/Siebel Analytics.
• Expertise in complete SDLC which involves Requirement Gathering, Proof of concept, Gap analysis, Converting functional to technical Spec, Design, Development, Testing and Implementation of the OBIEE/Siebel Analytics.
• Expertise in configuring and installing OBIEE.
• Expertise in developing all 3 layers of the Analytics Repository (Physical Layer, Business Model & Presentation Layer).
• Extensive experience in OBIEE RPD Development, Answers Intelligent Dashboards, Delivers, iBots
• Implementing security using LDAP, Single sign on (SSO)
• Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning,Aggregation Rules, Time Series, Cache Management.
• 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.
• Expertise in Debugging and Performance Tuning of Siebel Analytical Dashboards.
• Expertise working with dimensions and fact tables and experience with understanding universal adaptors in order to load into BI.
• Involved in performance tuning at the DB level, OBIEE-RPD ,Dashboard Server Level
• Experience in development & customization of BI Publisher (XML Publisher) Reports.
• Worked with Oracle Utilities like Toad, Putty and expertise in SQL * Loader, SQL, PL/SQL and Shell scripting, MS Word, Visio for documentations and diagrams, and Excel spread sheets.

Technical Skills:

• Business Intelligence OBIEE 10.1.3.4/3/2, Siebel Analytics 7.8/7.7
• RDBMS Oracle 10g/9i/8i/7, Essbase, SQL Server, MS Access
• Methodologies Star Schema, Snowflake Schema.
• Languages SQL, PL/SQL, C, C++, HTML, XML, SQL Scripts
• Tools Mercury Quality center, Microsoft Visio, TOAD
• Operating System UNIX, SUN Solaris, Windows
• Reports Reports 6i, BI (XML) Publisher

Confidential Chicago, TX Aug 10 - till date
Sr.OBIEE Developer

NAVTEQ is the leading global provider of maps, traffic and location data (digital location content) enabling navigation, location-based services and mobile advertising around the world. NAVTEQ supplies comprehensive digital location content to power automotive navigation systems, portable and wireless devices, Internet-based mapping applications and government and business solutions. By revolutionizing the way people think about and interact with maps, we foresee a world in which everyone finds their way to people, places and opportunities more easily and safely than before.

Roles & Responsibilities:

• Worked closely with Business Analyst in understanding the Analytics requirements and created the Kimball Matrix for generating reports as per the user requirements.
• Presented the overall rpd metadata development methodology.
• Provided Weekly status reports to the Senior manager.
• Configured and installed OBIEE in all environments.
• ConfiguredOBIEE Repository like implementation of physical data model as per requirements, importing the tables and having the physical joins/keys required and changed the physical joins/key on the existing tables.
• Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business Model and Mapping layer. Established the logical joins/keys required to support drill-down aggregation.
• Developed Role-Based Dashboards for Region Managers, CFO and Business Heads to review the Forecasts vs. Revenues and Contact Relationship Management (CRM) to analyze the financial service center statistics for different campaigns.
• Configured advanced Navigation reports, guided navigation link, Union reports etc.
• Implemented the delivery of iBots using OBI Delivers to alert the associated teams.
• Performing Testing of the IT Defects and CR raised by the Testing team.
• Implemented security by creating roles & web groups, checks with LDAP Authentication.
• Migrate the rpd metadata & web catalog contents to Test & Production environment.
• 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.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to the OBIEE Repository.

Environment: OBIEE 10.1.3.4, Informatica, PL*SQL scripts, Oracle 10g, Sql's, TOAD, Unix

Confidential, Los Angeles, CA Mar 09 - Jul 10
Sr.OBIEE Developer
Roles & Responsibilities:

• Worked with Client for gathering requirements, Identified KPI, Identified Analytics Report requirements
• Responsible for gathering Business Requirements, preparation of Business Requirement Specification document and performed Gap and Data Analysis.
• Worked Extensively on OBIEE/Siebel Analytics Administration Tool, Siebel Analytics Web/Presentation Services, Answers, & Interactive Dashboards and Security Implementation.
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Set up Obiee Tool Level security for specific users who can access a part of the tool, like just answers, No Dashboard prompts,Etc
• Obiee reports performance improved by tuning long running sql. Created indexes, created materialized views, created Aggregate Tables, Configuring Nqsconfig.ini parameters etc
• Worked on Obiee Administration like , installation, configuration of Obiee Security External Database, LDAP, Aggregate Table Configuration of nqsconfig file and also Instanceconfig.xml files, Setup and Configure Obiee Delivers, Creating Materialized Views, Setup Mud Environment, Repository Merge, Catalog Merge, Deployment from dev to prod
• Setup MUDE Environment for Development of Obiee for Developers.
• Setup and Configure Bi Publisher
• 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.
• Developed many Dimensions and Time Series Objects with Security settings for analyzing
• Created Dimensional Hierarchy for Dimensions, Level based Measures and Aggregate navigation in BMM layer.
• Configured charts, pivot table views, filters, ticker in user interface.
• Developed aggregated fact tables using the content tab
• Configured Repository and session variables to get dynamic reports and dashboards
• Added new Dimensions and Columns to the Subject Areas to full fill the additional requirements of the Business Analysts.
• Implemented security by creating roles & web groups, External tables
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment
• Creation of pivot table to analyze the business from different perspectives provided optimized Analytics request.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.

Environment: OBIEE 10.1.3.3, Informatica, PL*SQL scripts, Oracle 10g, SQL Server 2008, TOAD, Windows XP

Confidential, Irvine, CA Aug 07 - Feb 09 
OBIEE Developer

Washington Mutual was a savings bank holding company and the former owner of Washington Mutual Bank, which was the United States\' largest savings and loan association

Roles & Responsibilities:

• Worked with Business People for gathering requirements, Identified Analytics Report requirements
• Worked Extensively on OBIEE/Siebel Analytics Administration Tool, Siebel Analytics Web/Presentation Services, Answers, & Interactive Dashboards and Security Implementation.
• Configured and Extensively used Siebel Delivers, Schedulers and iBots.
• Expertise in Data Analysis, Performing Gap Analysis, Identification of dimensions (type-1, type-2 and type-3), Facts & aggregate tables, Measures and Hierarchies.
• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration Tool.
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Developed many Dimensions and Time Series Objects with Security settings for analyzing
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports)
• Used the Security settings in Siebel Analytics Admin Tool to set up users, groups, access privileges and query privileges.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Configured charts, pivot table views, filters in user interface. Configured Global Filters and Prompts in Siebel Analytics Web.
• Developed aggregated fact tables using the content tab and fragmentation.
• Hands on experience with DAC in creation of Tasks, Task Groups, Subject Areas, Execution Plan
• 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
• Implemented security by creating roles & web groups, External tables and LDAP
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment
• 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.
• Involved with the Testing team to resolve, fixing and testing problems found during the Systems integration test, UAT Phases.

Environment: OBIEE 10, UNIX Shell scripts, Oracle 10g, SQL Server 2005, Informatica, UNIX, PL*SQL, TOAD

Confidential, Cleveland, OH Aug 06 - Jul 07
Seibel Analytics Developer

Key bank is one of the nation\'s largest bank-based financial services companies, with assets of approximately $94 billion. Key companies provide investment management, retail and commercial banking, consumer finance, and investment banking products and services to individuals and companies throughout the United States and, for certain businesses, internationally.

Roles & Responsibilities:

• Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• Responsible for Data Modeling, Functional and Technical Design for the Client.
• Responsible for the Developing Siebel AnalyticsRepository.
• Developed custom reports/Ad-hoc queries using Seibel Answers and assigned them to application specific dashboards.
• Responsible for the Production and Maintenance Support Siebel Analytics.
• Responsible for Unit, System and Integration Testing and Performed Data Validation for all the reports that are generated from Siebel Analytics.
• Trained end users to build ad hoc reports using Siebel Analytics.
• Developed star schemas and created custom star schema as per the business requirements.
• Analyzed and recommended enhancements to Metadata Reporting in all 3 layers (Physical, Business and Presentation)
• Enhanced existing Business Models & created customized Dashboards for revenue ratio reports for North Alabama and Atlanta regions
• Implemented measures & dimensions and organized the data into related subject areas
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports)
• Configured iBots to deliver analytics content based on schedule, automated iBot queries to obtain weekly reports & sent notifications Alerts to Managers
• Created hierarchy based Sales Card Dashboards for different Business units and end users
• Customized Business Mapping Layer, created marketing segmentation criteria for Prospective customers

Environment: Siebel Analytics 7.7.1.x, Oracle 9i, SQL*PLUS, PL/SQL, TOAD, Erwin, Windows XP.

Confidential, Detroit, MI Sep 05 - Jul 06
Seibel Analytics Developer

Roles & Responsibilities:

• Performed Installation & Configuration of Siebel Analytics Software to set up the enterprise.
• Worked closely with Business Analyst, Discussed & Gathered the requirements from different user groups.
• Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns. Established the logical joins/keys.
• Used Aggregate Tables at Sales Fact over different measures and specified Aggregate Levels for each source.
• Designed Intelligence Dashboards and created Global Filters like Year, Quarter, Month, Product, Distributor.
• Customized the logical tables and columns, defined the Analytics dimensions, aggregations and levels.
• Created Dimensional Hierarchy (Geo, Calendar, Product, Distributor), Level based Measures such as Category Sales, Yearly Sales, Regional Sales and Aggregate navigation in BMM layer.
• Configured bar/pie charts, title/table/pivot table/compound/narrative/filter/gauge/column selector/view selector/static text/no result views, filters by region/product in user interface. Configured Global Filters and Prompts by year/quarter/month and other measures in Siebel Analytics Web.
• Added new Dimensions and Columns to the Subject Areas to fulfill the additional Requirements of the Business Analysts.
• Involved in Unit/Integration Testing & user training of the generated reports in Siebel analytics web.
• Involved with the Testing team to resolve, fixing and testing problems found during the Systems integration test, UAT Phases.

Environment: Siebel Analytics 7.7.1.x, Oracle 9i, SQL*PLUS, PL/SQL, TOAD, Erwin, Windows XP.

Confidential, India Aug 02 - Jul 05
Oracle Developer

Roles & Responsibilities:

• This module is an online system covers finished goods as production receipt, transfer of goods to various Carry and Forward (C & F) agent locations, Order Processing, Invoice Preparation, Inter depot transfer of stocks, Receipts/Payments, Stock Returns, Credit/Debit Memos, Credit Recommended Memo, out standings Adjustment, Various Supporting modules, All types of reports necessary for Field Staff, and reports required for business.
• Study and analyze the business requirements.
• Build models of the system, Confirm and refine the model with the analysts and experts.
• Design the database based on the model developed in the strategy and analysis phase.
• Build the prototype system, Write and execute the commands to create the tables and supporting
• Objects for the database.
• Development of Stored Procedures to encapsulate Business processes, triggers, procedures,
• functions and package Using PL/SQL
• Refine the prototype. Move the application into production, user acceptance testing, conversion of
• existing data, parallel operations.
• Perform Integration and Unit testing of all the modules.
• Monitor its performance, and enhance and refine the system.
• Training internal people.

Strengths:

• High degree of conceptual and analytical skills
• Good written and oral communication skills
• Ability to handle multiple responsibilities
• Ability to understand functional and logical concepts
• Excellent team player

Education:

• Bachelor of Technology in Electrical Engineering.