SUMMARY

• 6 years of experience in Information Technology which includes Business Requirement Gatherings, Analysis, Design, Data Modeling, Development, Testing and Implementation of Data warehouse/Business Intelligence using OBIEE 10.x/11g and SQL server 2005/2008
• Extensive experience in implementing Business Intelligence functions and solutions for various clients across diverse business segments
• Strong understanding of dimensional Modeling, star and snowflake Schemas
• Experience on OBIEE 11g Administration using WebLogic Administration console and Oracle Enterprise Manager Fusion Middleware Control
• Experience in Business Model development with various functionalities like Hierarchies, Measures, Aggregation Rules and Time Series
• Experience in installing, configuring and administering the different versions of OBIEE and Web Logic Server on windows environments
• Expert in developing Oracle BI Repository (.rpd) which consists of: Physical Layer, Business Model and Mapping Layer, Presentation Layer
• Expert in developing Interactive Dashboards, Reports with drill - down capabilities using page and dashboard prompts and other Web Catalog Objects such as Filters, Folders, & Agents/iBots
• Expert in setting up and managing security in OBIEE 11g, 10g
• Implemented Data Level Security, Object Level Security and LDAP authentication
• Experience in setting up Multi User Development (MUD) environment
• Expertise in tuning performance by utilizing aggregate tables, materialized views etc
• Expert in Supporting implementation and maintenance of reports and dashboards using Oracle Business Intelligence Enterprise Edition on production and development environments for different OBIEE versions
• Expertise in fine tuning reports by using view selector, column selector, is prompted, drill down- drill through analysis, creating master/detail reports, using database, numeric, date and time functions, etc, where ever necessary to increase performance
• Excellent problem solving and inter-personal skills with strong techno-functional background
• Quick learner, able to work with conflicting priorities, excellent team player with the ability to meet deadlines under pressure

TECHNICAL SKILLS

OLAP Tools: OBIEE 11g/10g, Siebel Analytics 7.8/7.7/7.5, BI Answers

Databases: Oracle 11g, 10g/9i, MS SQL Server 05/00, MS Access

Operating Systems: Windows 98/2000/NT/XP/Vista, Sun Solaris

Web Technologies: HTML, XMLApplications MS Word, MS Excel, Outlook, FrontPage, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential - Manfields, TX

OBIEE Developer

Responsibilities:

• As a Developer, my role has provided me a wider scope in the life cycle of the project from creating and analyzing the business requirements, gathering new business requirements from the respective stakeholders
• Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance
• Worked on OBIEE Administration tool for customizing the physical layer, business layer, presentation layer and modifying it according to the business requirements
• To create RPD, 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 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 reports
• Created and saved several BI Publisher reports by selecting an answers request as Data Source
• 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
• Worked on Oracle 11g, SQL Server 2008 for getting the financial data
• Created comprehensive and easy-to-understand documentation (functional specifications, technical specifications and mapping documents) of the complete implementation of the customer sales business modules (reports, dashboards, security and star schema)
• 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) 11g, Oracle BI Publisher, Oracle Delivers, Windows XP and SQL server 2008

Confidential - Irving, Texas

OBIEE Developer (Lead)

Responsibilities:

• Involved in Project SDLC, Gathering of user requirement and requirement specification from users
• Documenting business requirements, functional specifications and test requirements
• Involved in RPD Development, Oracle BI Server and Oracle BI Answers
• Identified and designed star schema for fact & dimensional tables and created alias for the dimensional tables when necessary
• Developed physical layer, business model and mapping and presentation layer using Oracle BI Server Administration Tool
• Specified dimensional hierarchy, aggregate levels for the dimensions and involved in configuration of Web Catalog Security and Cache Management
• Developed different brand level reports, filters and prompts using Oracle BI Answers
• Used filters and provided customized prompts to avoid excessive data showing up in the reports
• Identified Financial Analytics facts, dimensions & star schema models of workforce profile subject area
• Used catalog manager to migrate custom dashboards, requests, filter and prompts to Prod environments
• Configured analytics repository with logical dimensional modeling using star schema
• Worked extensively on OBIEE Answers to create the reports as per the client requirements
• Worked on setting up of aggregate navigation/table
• Created calculation measures in the business model and mapping layer
• Performed Repository Testing and validation before exposing Business Models in the Presentation layer
• Created corporate standard variables in the metadata to ensure standard measures and best practices are followed
• Creating physical, logical and complex joints
• Set-up the visibility of dashboards to employees with respect to their responsibilities
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance
• Design various reports, i.e. Drill down, Pivot and Narrative Reports in OBIEE Answers as per the client requirements
• Created Dashboards for different groups of users to view data across regions
• Providing object level security for different web groups based on responsibilities
• Used OBIEE Administration Tool for customizing and modifying the physical layer, business model and mapping layer and presentation layer of the repository
• Developed interactive dashboards using reports with different views (Drill-Down, guided navigation, Pivot Table, Chart, Column Selector and page prompts) using Oracle Presentation Services
• Implemented security by creating session variables and initialization blocks, Repository variables and associating catalog objects and Web modules with the created groups
• Imported metadata from different sources using the Administration Tool into the Physical layer
• Collaborate with business users to capture & define business requirements and then contribute to defining the appropriate data warehouse BI solution

Environment: OBIEE 10.1.3.4.1/11 g, SQL server 2005/2008, Windows XP, Windows server 2003

Confidential - Dallas, Texas

Reports Developer

Responsibilities:

• As a Report Developer, had the responsibilities of analysis, design, development, configuration, customization, validation and deployment for enterprise Business Intelligence solutions
• Gathered and analyzed reporting requirements for the Sales and Returns departments
• Involved in Data Modeling, Design Documents
• Conducted project planning and work estimations
• Responsibilities included analysis, design and implementation of the Siebel Analytics Architecture, reports
• Independently Designed and developed subject areas in the RPD
• Mapped different data sources from the physical layer to the business model and mapping layer (design of hierarchies dimensions and aggregates table)
• Define appropriate joins, created calculation measures in the repository
• Created Repository Users/ Groups and Web Groups and assigned permissions/security to the user groups so as to allow and disallow
• 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
• Writing the queries using SQL
• Created reports with different views (Compound, Chart, Table, Pivot, Ticker and Narrative)
• Developed and scheduled iBots for delivering personalized reports to users on time
• Secured dashboards and reports by defining user roles
• Responsible for daily/weekly/monthly on time report delivery to the end users. Developed front end reports

Environment: Siebel analytics 7.8.4, Oracle 10g, SQL Server 2005, Oracle 8i/9i, SQL, SQL*Plus, Windows XP/2003 server