SUMMARY:

• Around 7+ years of experience of IT experience which includes Analysis, design, development, Testing and Implementation of complete Software development life cycle and all aspects of gathering Business Requirements.
• Experience in OBIEE 11g and OBIEE Analytics 7.8 which include building and configuring repository, creating and managing Oracle / Siebel Intelligent Dashboards, oracle/Answers, Oracle / Siebel Delivers and Oracle / Siebel iBots (ETL Informatica, Reporting - Siebel Analytics, Scheduling-DAC), Oracle data integration(ODI)
• Extensively worked with Administration Tool to customize the RPD in all the layers Physical, BMM and Presentation Layers.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Expertise in Creating Dynamic Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and Drill down Properties.
• Experience in Data Modeling using Dimensional data modeling, Star schema modeling, Snow-Flake modeling, Physical and Logical data modeling.
• Extensive experience in building and administering the metadata repository and front end reports in answers/dashboards for both standalone and integrated Siebel Analytics applications
• Expertise in debugging, optimizing the Performance Tuning of Oracle BI / Siebel Analytics Repository & Dashboards / Reports and Informatica / Mappings / Workflows.
• Strong experience in setting up a Multi-User Development Environment (MUDE)
• Created session & repository Variables to achieve desired functionality.
• Implementing Siebel Security Setup (groups, object and data level), LDAP, External Tables, Single sign on (SSO) etc.
• Used EBS to track the performance of the database.
• Performed relational database design and normalization, client-server development, object-oriented analysis and design.
• Very good at inter-personal skills, problem solving with good technical background able to complete the task very frequently and works hard.

TECHNICAL SKILLS

Operating Systems: Windows 7 … MS-DOS, UNIX, Solaris, LINUX.

Languages: SQL, PL/SQL, C, C++, Java

Web Technologies: HTML, XML, XHTML

Data Modeling: ER Diagram, Entities, Attributes, Cardinality, Relational ModelingPhysical Modeling, Logical Modeling, Dimensional Modeling(Star Schema, Snow-Flake, FACT, Dimensions)

Tools: Toad, SQL*plus, DAC, Auqadata Studio

WORK EXPERIENCE:

Sr. OBIEE Developer

Confidential

Responsibilities:

• Use OBIEE 11g (Oracle Business Intelligence Enterprise Edition) to design and develop BI Reports and Dashboards.
• Recently Upgraded to OBIEE 11.1.1.9.1 version and built an report using the new features and graphs.
• Design and document technical solutions to complex business problems.
• Extensively use BI Admin tool for RPD Modeling which includes building star schema as per the business requirements and configuration of Physical, Business Model & Mapping and Presentation layers
• Build, edit, and review challenging and complex SQL procedures.
• Creating view and adding number of Useful metrics to Views(SQL Scripts) for better performance
• Extensive use of Pivot table, Charts, Bar - Graph, gauge and tables for better dashboard.
• Used Extensive features like Agents, Briefing Book, Presentation variable, prompts Filters, Hidden prompts, Formatting the dashboard for better PDF using HTML and CSS code.
• Creating new analysis, subject Areas, drilldown, sorting of the Reports and dashboards for Better Visualization.
• Created number of union reports combining the two different subject areas and get the value required for the Business users.
• Management of cache and Querying the SQL from OBIEE server back-end.
• Taken Care of Catalog migration and RPD Deployment.
• Used Netezza Auqadata Studio for Data Validation of the Dashboards and Query Scripts for Better understanding of data flow and calculation of the Metrics.
• Troubleshoot existing import/export processes to increase efficiencies and develop solutions.
• Support and conduct Root Cause Analysis on existing ETL processes to detect and correct issues with supplied data sources.
• Perform data analysis and research and farm and mine data from both a technical and business point of view.

Environment: Oracle11g, OBIEE 11.1.1.7.0 , 11.1.1.7.1 .14 , 11.1.1.9.1 SQL*PLUS, Netezza Auqadata Studio, UNIX, Windows XP and windows 7

OBIEE Developer/Admin

Confidential

Responsibilities:

• Managed, developed and maintained OBIEE environments.
• Upgraded to 11.1.1.7.1 new version and worked on RPD (physical, BMM, presentation)
• Worked on the latest waterfall graphs and stacked graphs.
• Implemented OBIEE Catalog Security model for all the environments from the business user's perspectives.
• Worked on drill - down, action links, agents, view selector and column selector graphs and reports
• Given support for front-end application for BI publisher reports.
• Merge and split subject's areas to and from the unified RPD files in each environment.
• Implementation MUDE Setup in development environment.
• Managed OBIEE to enable privileges on the catalogs based on Active-Directory based groups.
• Implemented and documented steps to apply patches, fixes, upgrades and rollbacks of OBIEEreleases from Oracle.
• Worked with Middleware team to design and implement various monitoring alerts.
• Assisted Middleware teams with new environment builds and ongoing production support as needed.
• Assisted development teams in fine tuning reports and RPD models, and report development.
• Deployment of RPD through Enterprise Manager (EM) and manually through UNIX servers.
• Managed various application roles through EM and worked on creating LDAP authentication through web logic administration console.
• Occasionally worked on Cognos reports and promotion of reports.

Environment: Oracle11g, OBIEE 11.1.1.6.2 , 11.1.1.7.0 , 11.1.1.7.1 , PL/SQL, SQL*PLUS, SQL*Loader, TOAD, UNIX, Windows XP and windows 7

OBIEE Consultant

Confidential Englewood, CO

Responsibilities:

• Created Dashboards and Answers for End user.
• Performed the setting up, Installation, Upgrade and configuration of the complete OBIEE platform from Seibel Analytics Environment including Informatica, DAC and the required connectivity for seamless integration with the data warehouse.
• Developed many Reports/Dashboards with different Analytics Views (Drill - Down/Dynamic, Pivot Table, Chart, and Column Selector with global and local Filters using Oracle BI Presentation Services).
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica WorkFlow Monitor.
• Created and run Sessions & Workflows to load the data into the Data warehouse.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check in Oracle BI Administration Tool.
• Configured and Scheduled Sessions and Workflows.
• Exclusively Involved in Unit Testing, Peer Testing & Regression Testing.
• Worked on multiple folders at time to meet the dead lines of the tasks.
• Designed and developed logical model in BMM in Repository.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.

Environment: Oracle11g, OBIEE 11.1.1.5, Informatica 8.1.0, DAC 7.9.4, SQL*PLUS, SQL*Loader, TOAD, UNIX and Windows XP.

OBIEE Consultant

Confidential Houston, TX

Responsibilities:

• Gathered the needs and requirements from business end - users, management and other users for setting up environment to start.
• Interacted with business analyst to know the functional requirements for the date base to build.
• Installed and configured OBIEE environment components.
• Used EBS to track the performance of the database.
• Monitoring the Active Session Histories, Database Diagnostics Monitoring, Resource Management, Query Optimization using EBS.
• Identifying and importing the tables (facts and dimensions) from the OLTP server.
• Creation and customizing the OBIEE repository three layers (physical, BMM, and presentation layer).
• Built alias table in the physical layer so that we can use without importing the tables several times from OLTP server.
• Used dimension hierarchy, aggregation tables, and time dimension wizard to make the data small, easy and redundant.
• Developed reports using prompts, filters according to the requirements in bi answers.
• Created interactive dashboard pages using dashboard prompts, guided navigation, and presentation variable to view mangers according to the requirement.
• Developed security level (data and object) for different users and groups. Created different types of views like pivot table, chart, and column selector.
• Implemented multi user development (MUD) for different groups.

Environment: OBIEE 10.1.3.4.1 , Administration tool, OBIEE Answers/BI Publisher/ Dashboards, Oracle 10g, Informatica Power Center 8.1, PL/SQL

Confidential

OBIEE Consultant

Responsibilities:

• Installed and configured the Oracle BI server and resolved the installation issues.
• Worked closely with Business Analysts and DBAs on physical database design.
• Presented Functional and Technical requirements information in Group Settings.
• Involved in Siebel Analytics related to data model and ETL, creation of detailed design documentation, accurately mapping requirements into Siebel Analytics functionality.
• Configured Oracle BI Scheduler in an application and server that manages and schedules the job.
• Involved in Conceptual Data Modeling (CDM), Logical Data Modeling (LDM) and Physical Data Modeling (PDM).
• Customized Business Mapping Layer, created Marketing Segmentation Criteria for respective customers.
• Involved in developing Informatica Mappings / Mapplets for ETL per changes in requirements.
• Involved in migrating reports from Siebel Analytics to OBIEE and Configured Proxy Users.
• Created various Ad - hoc reports for day-to-day Business Requirements making use of Global and shared Filters with different views in accordance with the requirements.
• Created sales reports to compare Current cycle and previous cycle sales using Pivot table views.
• Generated iBots using the Delivers to send notifications to the end-users.
• Involved in Data level and Object Level Security model in Analytics Presentation Catalog to view reports according to the user level Privileges and Permissions.
• Performed Repository Testing and Data Validation before Migrating OBIEE objects to Production.

Environment: Oracle BI, Siebel 7.7.1.x, Informatica Power Center, Oracle 10G, Windows XP.

OBIEE Developer

Confidential

Responsibilities:

• Responsible for setting up OBIEE Server, OBI Applications for pharmaceutical business needs
• Requirements gathering and interaction with the client SME's to draft business requirements
• Responsible for converting business requirements into Functional and technical requirements
• Design Data model for Repository development
• Design and development of complex reports to derive Target efficiency Index, Activities, Account and Contacts
• Design and development of OBIEE Answers and Dashboards
• Design and develop ad - hoc reports for Account and Contact history
• Design and develop custom and customization of ETL mappings and workflows
• Responsible for setting up DAC execution plans and Administration
• Responsible for Administration of Oracle BI Publisher
• Design and develop complex reports for Sales module with write back options for forecast analysis
• Design and development of Business model and mapping
• OBIEE server, web administration Customized analytics web user interface
• Design users groups and maintain authentication of user groups
• Design and development of HLD, LLD and UTP
• Responsible for user manual preparation and training

Environment: Siebel 8.0, OBIEE 10.1.3.4, DAC 10.1.3.4, OBIA 7.9.5, BI Publisher, Oracle Business Intelligence Standard Edition, Oracle Warehouse Builder 10gR2, Windows Server 2003