SUMMARY

• 7+ years of experience in Information Technology with specialization in data warehousing and business intelligence(BI) using OBIEE 10.x/11.x, SQL 2005/2008
• Hands on experience in using Oracle Business Intelligence including Answers, Delivers, Dashboards, Agents, Admin tool, Catalog manager, Administration, Setup and maintenance
• Worked in Data modeling, creation and configuration of metadata objects
• Experience installing and configuring OBIEE platform, DAC and out of the box BI applications.
• Strong experience in creating and administrating the OBIEE Repository at Physical, Business & Presentation Layer
• Experienced in developing Dimensional Hierarchies, Level Based Measures, Aggregate navigation and adding multiple sources to business model objects.
• Experience in developing Reports / Dashboards with different analytics view.
• 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 where ever necessary to increase performance.
• Proficient in using the Time-Series function to support historical time Comparison analysis and creating requests.
• Expert in developing Subject Areas, and security administration (authentication, group, access / query privileges) at object and data level in Administration Tool.
• Experience in creating users and groups and adding multiple users in different groups.
• Expertise in creating and scheduling iBots using delivers to send alerts and deliver reports to the users.
• Experienced in gathering business and user requirements, observing business processes, identifying reports needed by analyzing Key Performance Indicators (KPIs)
• Experience in in installing, configuring and customizing DAC (subject areas, tables, task) and monitored ETL process using DAC 10.1.3.4.1 and Informatica work flow manager
• Experience in developing customized SQL queries and a strong knowledge of RDBMS databases
• Strong domain knowledge in Retail Industry - Involved in Marketing, Sales and Customer Analytics
• Very strong analytical and presentation skills, problem-solving techniques, proven leadership qualities with emphasis on individual and team effort backed by excellent communication skills.
• Excellent written and verbal skills with an ability to rapidly learn and apply new technologies and improve processes with solid work ethic.

TECHNICAL SKILLS

BI Tools: Oracle Business Intelligence (Obiee) Suite 11.1.6x, 10.X, Oracle Business Intelligence Applications (Obia) 7.9.X, Siebel Analytics 7.7.X

ETL Tools: Informatica power center 7.x/8.x/9.x, MSSIS

Data Modeling: Dimensional Modeling, Star-Schema, Snowflake Modeling, Erwin 3.X, Microsoft Visio

RDBMS: MSSQL server 2000/2005, Oracle 8i/9i/10g/11g, IBM DB2, Teradata

Languages: SQL, PL\SQL, HTML

Operating Systems: Windows Server 2000/2003/2008 , Windows 2000/Xp/Vista/7, Unix, Mac OS

Project Skills: Business Requirements Gathering, Functional Requirements Gathering, Design Documents,Agile, GAP analysis, User Interviews, Process Flow & Data Flow Diagrams, MS Project, Microsoft Office

PROFESSIONAL EXPERIENCE

Confidential, GA

OBIEE Developer

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics requirements and created Business Models for generating Reports as per the requirements.
• Designed Technical documents for the conversion programs and interfaces from Functional documents.
• Created and Administered the Physical layer, Business Model and Mapping layer and Presentation layer in Analytics Repository (.rpd) using Oracle BI Administration tool.
• Involvement with ETL (Extract-Transform-Load) development team to communicate the specification for the required dimensional, aggregate and indexed data tables.
• Developed many Reports/Dashboards with different Analytics views (Drill-Down & Drill-Across, Pivot table, Charts, View selector, and Column selector, with global & local Filters using Oracle BI/Analytics web.
• Extensively used Repository variables, Session variables and Initialization blocks for configuring the Data and user Security.
• Created Filters and provided customized prompts appropriately to avoid excessive data.
• Developed accounting and collection time series object (Oracle BI Time-Series Functions) for comparing the billings, collections and adjustments.
• Performed tuning of Dashboards/Reports by aggregate navigation, and cache management.
• Worked on OBI Delivers and configured iBots to deliver Analytics content based on a schedule.
• Experience on OBIEE 11g Administration using Weblogic Administration console and Oracle Enterprise Manager Fusion Middleware Control.
• Worked with SQL and Pl/SQL programming for ODI
• Experience in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Data Warehouse Administration Console (DAC) and Informatica Power Center.
• Identified data warehouse and staging tables, Informatica workflows/mappings and DAC tasks related to financial data and customized Informatica mappings and load historical data
• Worked extensively on Oracle BI Publisher and provided the capability to download the reports in the user defined formats.
• Responsible for unit testing, integration testing of the reports generated using analytics.

Environment: OBIEE 11g, BI publisher, Windows server, Informatica PowerCenter, SQL server 2008

Confidential, Thomasville, NC

OBIEE Admin/Developer

Responsibilities:

• Partnered with Business Analysts in understanding the analytics requirements and creating the business models for generating reports as per the business requirements.
• Designed a complete Business Intelligence solution in a data-warehousing environment using OBIEE. Applied industry best practices to design an optimal BI solution.
• Used the OBIEE Admin tool to develop the three layers in the Repository.
• Created users, groups and giving the permissions in Analytics Administration tool and verifying the Permissions of the users in Analytics web.
• Enforced Row level security for managers to view the Reports pertaining to their region.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Customized RPD (Physical, BMM and Presentation Layer).
• ImplementedData Level Security, Object LevelSecurityand LDAP authentication
• Set up security levels for regional managers and branch managers
• Migrated Informatica and DAC repositories
• Worked extensively on OBIEE Answers to create the reports as per the client requirements.
• Defined additional views (compound, table, chart views) of the data returned by the request to visualize data in many different ways.
• Created Oracle BI Answers Requests, Oracle BI Interactive Dashboard pages and prompts.
• Created Proactive agents (iBots) and configured Interactive dashboards to alert the employees as per the requirements.
• Worked in Security setup at both Object and Data levels, which involved creation of application roles and policies
• Implemented multi user development environment using oracle best practice

Environment: OBIEE 11g, Oracle 9x, Essbase 11.x, Windows server, Informatica 9.1, JD Edwards EnterpriseOne

Confidential, OK

Analytics Consultant

Responsibilities:

• Understanding the customer’s requirements, analysis, design, development and implementation of system. Defined business requirements to improve business processes.
• Interacted with procurement and operation / maintenance business representatives for gathering the OBIEE Reports / Dashboards requirements and to define business and functional specifications.
• Involved in optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views etc.
• Migrated data from Text file to SQL database.
• Installed ODI, set up the ODI connection with Oracle, MS SQL server and flat files
• Set up topology including, physical architecture, logical architecture and context
• Created role based dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts.
• Analyzed requirements, implemented prebuilt business intelligence solutions using the Oracle Business Intelligence Analytics platform
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Provided training to the business users on OBIEE Answers and Dashboards
• Provide functional requirements to describe system process, as well non-functional requirement to describe performance, scalability, security, and usability requirements.
• Involved in fine-tuning and optimization of BMM layer in RPD to insure faster response time.
• Took back-up of DAC, BI and Informatica repositories and BI web catalogs
• Applied aggregation rules, sort orders and calculated measures as per requirement.
• Developed User Interface (UI) components folders, dashboards, pages columns, sections, requests/answers, filters, global filters, navigation links, and views/charts using Oracle BI Presentation Services.

Environment: OBIEE 10.1.3.4.1 , SQL Server, Unix, Informatica 8.6, DAC 10.1.3.4, Seibel CRM 8.0, Oracle Data Integrator 11g

Confidential, Philadelphia, PA

OBIEE Developer

Responsibilities:

• Involved with analysts as well as other business teams on requirement gathering.
• Manage Oracle Business Intelligence Suite Technologies and built metadata repositories, reports and interactive dashboards to meet Business requirements.
• Worked closely with users, ETL team and DBAs to resolve ongoing problems by reviewing changes made to the systems and made corresponding changes to Repository.
• Created Dimensional Hierarchies, Level Based Measures and Time series Functions based on business requirements.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders
• Experience in performance tuning in OBIEE and gathering performance metrics for various measures in reports.
• Used Presentation variable in the Dashboard Prompts to implement the Period Rolling Function.
• Created Repository, system and non-system session variable and initialization blocks for various reporting needs

Environment: OBIEE 10.1.3.4.1 , BI Publisher 10.1.3.4, SQL Server 2005, Windows XP.

Confidential

Oracle Developer

Responsibilities:

• Involved in discussions with the end user to analyze the requirements for generating reports.
• Created users, roles and privileges on the Oracle databases.
• Involved in gathering and analyzing the user requirements in coordination with Business.
• Performed the scope analysis of the user requirements, Identified Facts and Dimensions
• Developed analytical repository using Analytics web Admin Tool (importing database object into Physical layer, defining logical objects that includes Dimensions & Facts in BMM layer and presentation catalog in Presentation Layer).
• Created Dimensional Hierarchy for date, facility and location dimensions, Level based Measures and Aggregate navigation in BMM layer.
• Developed several Dashboards / Reports for providing analytical information’s using Analytics Web.
• Added new dimensions and columns to the Subject Areas to full fill the Additional requirements of the Business Analysts.
• Administered and managed OBIEE Repositories. And performed two way and three way
• Developed BI publisher templates and reports
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.

Environment: OBIEE 10.1.3.3.3 , Oracle 8i/9i, Windows server