Professional Summary:

• Over 8 years of work experience in the IT, acquiring both technical and functional skills
• Over 6years experience in Business Intelligence projects that span the full life cycle implementation of Oracle Business Intelligence Siebel Analytics, Informatica and Data Warehousing
• Very strong experience in developing OBIEE Repository .rpd at three layers Physical Layer, Business Model Presentation Layer, Interactive Dashboards with drill - down capabilities using global local Filters, Security Setup groups, access / query/report privileges, configured Analytics Metadata objects Subject Area, Table, Column, Web Cat Objects Dashboard, Pages, Folders, Reports and scheduling Agents
• Expert in creation and customization of repository using Siebel Analytics Administration Tool.
• Expertise in analyzing and designing customized analytical reports and creating Interactive Dashboards with drill-down capabilities using OBIEE
• Expertise in Creating projects and Working In MUDE environment
• Expertise in creating complex reports in Answers using various views
• Extensive experience in setting up Session and Repository Variables using various Initialization Blocks.
• Extremely strong in OBIEE Metadata development
• Ability to create templates for Oracle BI Publisher, and deploy those templates to an Oracle business Suite instance
• Expertise in creating dimensional hierarchies, Level based measures, Fragmentation content, Aggregations, and complex joins.
• Expert in Creating Security Policy in OBI Servers and by designing Projects Groups Power Users, Analysts... in OBI Console and adding Users to respective Groups in AD
• Experience in OBIEE DAC configuration
• Have a working knowledge on Oracle Exalytics in memory machine
• Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas using RalphKimball and BillInmon Methodology
• Expertise in Report Bursting using BI Publisher
• Develops, executes, and manages Customer Relationship Management CRM marketing activities in an organization, including e-marketing programs and strategies, campaign management, and analytics.
• Experience in creating Execution Plans, Subject Areas, Tasks and Repository Management using Data Ware House Application Console.
• Constructed Oracle ODI interfaces and customized Knowledge Modules for data replication, and transformation.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution.
• Developed various ODI interfaces to load data from Flat file Relational Sources to Oracle DataMart
• Experience in Upgrading, Maintaining all the L3 Environments DEV/STAGE/QA
• Expertise in analyzing business issues and providing possible reporting solutions to end users
• Expertise in providing end-to-end user training and support and provided detail documentation
• Excellent analytical, problem solving skills and a motivated team player with an excellent inter-personal skills and familiar with offshore and multi site development
• Strong Collaborative skills and had an excellent communication, Diagnostic, Problem solving skills.
• Strong technical background with advanced personal computer skills and experience in different operating systems.

Technical Skills

• Methodologies: Dimensional Data Modeling Logical / Physical
• Reporting Tool: OBIEE 11.x/10.x, Siebel Analytics 7.x
• ETL Tool: Informatics 7.1/6.2, ODI,Pervasive Data Integrator v9.1/Essbase7.1.6
• Databases: Oracle9i / 10g/11g, MS SQL Server, DB2, Teradata.
• Query Tools: SQL, PL/SQL, TOAD
• Web Technologies: HTML, XHTML, XML
• Languages: C/C Java, Visual Basic, ASP, VBScript, JavaScript.
• Operating Systems: Windows 98/00/2003/NT/XP/7, Red hat Linux, UNIX
• Other: Visio, MS Office, Adobe Acrobat

Professional Experience:

Confidential

Sr OBIEE Developer

Responsibilities:

• Participated in the Requirements Gathering of the various work streams by meeting with the business user and base lining the details.
• Responsible to Explaining a team for Defining plans, schedules, monitors, and coordinates the activities of the team.
• Installed configured and administrated OBIEE 11.1.1.7.1
• Customized Oracle BIEE Metadata Repository using Composite Data Source by importing some of the required objects with integrity constraints into Physical Layer.
• Worked on Key Performance Indicators KPI within the BI environment, which can be used as the catalyst toward driving more responsive interaction between users and data.
• Designed and developed Performance Measurement Dashboards/Reports that are Dynamic Interactive with drill-down, drill-across capabilities split reports for summary details information, and local global filters using Oracle BI Presentation Services.
• Developed custom reports/Ad-hoc queries using Oracle Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports pivots, charts, tabular using global and local Filters.
• Enhance performance of Reports/ Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions and managing Cache.
• Worked on Metadata Repository objects and also Web catalog Objects which include Dashboards, Reports, Pages and Folders
• Implemented data level security Location Managers, Sales Executives etc using Session Variables by creating content filter in dimension table in rpd.
• Implemented object level security for both repository objects and web objects by creating users and groups in repository and web catalog groups in the Presentation Services.
• Created Dimensional Hierarchies and Level Based measures, worked on Expression Builders and Calculation Wizards to generate certain expressions.
• Configured LDAP server to Authenticate users and implemented both object level and data level security based on roles and responsibilities.
• Performed Unit, Integration and Regression testing to validate reports and mappings.
• Created 30-35 Init Blocks using Teradata Database Query's to Accommodate the Business Needs
• Participated in the Upgrade of Servers from 11.1.1.6.2 BP1 to 11.1.1.6.8 by applying patches for Both DEV and TEST Environments.
• Maintained MUDE Shared Drive and Responsible for Deploying Latest RPD to DEV Servers.
• Designed simple, scalable and sustainable ETL templates using ODI
• Responsible for Creating Security Policy in OBI Servers and by designing Projects Groups Power Users, Analysts, .. in OBI Console and adding Users to respective Groups in AD
• Responsible to Lead the Meetings of Pre-Deployment Call and Acted as bridge between L3 and L2 team to have a Seamless deployment from lower level to Higher level environments
• Responsible for UAT/SIT testing with Business users and L2 teams
• Responsible for Coordinating off Shore and Onsite L2 and L3 teams.
• Responsible to Lead off Shore Development Team.
• Responsible for doing Teradata Query banding to Eliminate Multiple Sessions Creating at the Backend

Environment: OBIEE 11.1.1.7.1, Composite 6.2, Teradata 13.10.06.09, Informatica Power Center 9.5.1, ODI 11g,Windows 7, SQL Server 2008

Confidential

Senior Oracle BI Developer

Responsibilities:

• Worked with business users and performed gap analysis.
• Involved in the gap Analysis, worked on documenting the functional and technical specifications, development, deployment and testing of the project.
• Involved in Architect's role is to help lead the implementation and ongoing maintenance of data warehousing and business analytics solution.
• Created connection pools, imported new tables and columns from the Data warehouse defined Physical joins in Physical layer and in Business Model Layer created Logical Joins.
• Created Dimensional Hierarchies and Level Based measures, worked on Expression Builders and Calculation Wizards to generate certain expressions and formulae, created new logical columns based on the requirement, wrote Case SQL Statements to manipulate the data as per the needs.
• Designed repository based on business requirements, followed design best practices for the RPD and Dashboard designs.
• Responsible for creating additional Users and maintaining Visibility Privileges using Analytics Administration on Repository side as well as front end to display reports based on the business user for that particular area.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Used different filter conditions both in the repository and in front end based on business rules provided by the business users.
• Worked on creating repository and session variables such as static and dynamic along with initialization blocks.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Worked with DBAs to create materialized views and aggregates to improve performance.
• Created reports which are used to analyze the Performance and Response of the Campaigns held by the Confidential Marketing Team.
• Involved in setting up the environments for Development, Unit Testing, System Testing and Production for the developers and testing teams.
• Migrated reports from existing database to new data base using Hyperion intelligence explorer 8.5.
• Upgraded and configured OBIEE 11 g and enhanced new features.
• Involved in User Training for effective Use of Ad- Hoc Querying.

Environment: OBIEE 11.1.1.x/OBIEE 10.1.x, Windows 7, Oracle 11G, SQL Server 2008,

Confidential

OBIEE Consultant

Responsibilities:

• Interacted with Business Analysts and Users in gathering and analyzing and designing the Business Reports Requirements.
• Performed the gap analysis, Identified Facts and Dimensions with levels hierarchy and made required changes to the Data Marts.
• Implemented the Time Series Wizard YTD, QTD, and MTD for comparing measures in different time Periods.
• Configured Physical Layer Import tables, Create Tables, add/change physical joins/keys.
• Configured Logical Layer Create Logical tables/dimensions, columns, Create Logical Joins/keys, Set levels to support Drill-down, Aggregation / Sum over Columns.
• Configured Presentation Layer Create Folders/sub-folders, Standard Queries for different User Groups.
• Created Repository Static and Dynamic variables. Also created Initialization blocks for Session variables, which are used for authentication and security.
• Imported, physical tables, defined join in the physical layer in admin tool.
• Created Dimension Hierarchies in the BMM layer to drill down and drill across on various dimensions as per client requirement.
• Developed and debugged many Dashboards / Reports with different Analytics Views Pivot Table, Chart, Tabular and View Selector, Alerts, Guided Navigation, and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Performed query optimizations/tuning in physical layer as well as on the database.
• Implemented OBIEE Security Object Level and Data Level Security in the OBIEE Repository and Answers using Repository Variables, Session Variables and Initialization Blocks.
• Created Security settings in OBIEE Admin Tool to setup groups, access privileges and query privileges. Implemented Object level as well as Date level security.
• Created Catalogs in Presentation layer used for both ad-hoc and Dashboard end users.
• Worked on cache purging strategy using Event-polling table. Worked on IBots using OBIEE/BI Delivers for caching and delivering the reports to subscribed users.
• Documented the Functional and Technical design documents in MS word and latter converted the Technical design document in to the report Field Mapping Document.
• Performance tuning in OBIEE for star schemas by implementing aggregate navigation, cache management, Materialized Views and Database tuning.
• Debugged and resolved data matching issues ranging from the base tables to BI dashboard reports.
• Develop Mappings and Workflows to generate staging files.
• Created Request past due and Cost Details Analysis report to view of end user.

Environment: OBIEE 10.1.3.4, SSIS 2008, Toad, SQL Server 2008, UNIX

Confidential

Oracle BI Developer

Responsibilities:

• Collaborated with Business contacts Business Analysts in the analysis and preparation of OBI data requirements
• Participated in the walkthroughs of the data models, identification of dimensional attributes, Facts and Star Schema to fulfill requirements
• Creating dimensions, aggregations and keys using admin tool. Customizing Physical Layer, BMM Layer and Presentation Layer using OBI Administration tool.
• Created the new columns in existing fact and dimension tables and creating all together the new dimension and fact tables
• Content settings, Complex joins fragmentation content and defining of Most Economical Source as per business requirement.
• Creation of presentation layer tables by dragging appropriate BMM layer logical columns.
• Developed Global prompts, Filters, Customized Reports and Dashboards using OBI presentation services.
• Imported the custom fact and dimension tables and configured it in the 3 layers of the RPD. Implemented Level Based Metrics in the BMM layer. Created Compound facts in the BMM as per the client requirement.
• Created Dimension Hierarchies in the business model and mapping Layer to drill down custom Store and product dimensions.
• Creating Users and Groups and managing the object level and data level security.
• Managing the intelligent dashboards by using dashboard, page and report level security.
• Creation of views like Pivot table, Column Selector, Compound layout.
• Identified the granularity level of the data required to be available for analysis
• Customized and developed repository, configured metadata objects Subject Area, Table, Column and Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Configured measures in the Business Model Layer and mapped to multiple logical source tables.
• Extensively used Oracle Delivers and iBots so as to provide alerts.
• Worked on OBI presentation Answers to build Interactive Dashboards with drill-down capabilities.
• Created RTF templates in MS Word by connecting to BI Publisher and publish these templates for the reports to view data in BI Publisher.

Environment: OBIEE 10.1.3.2, Oracle BI Publisher, Oracle 10g, SQL, Windows Xp, Toad

Confidential

PL/SQL Developer

Responsibilities:

• Responsible for writing and modification of PL/SQL stored procedure, functions, packages and Database triggers.
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements
• Created materialized views, Inline Views normal views where business requirements needed
• Tune the SQL queries and complex procedures to improve performance
• Created database triggers for data security Consistency
• Performance tuning of Oracle Databases and User applications
• Used Timestamp and Time zone functions Loading Database
• Extensively Used JOINS writing views in the Database
• Created and used different type of Indexes.
• Created and used Sequences.
• Configuring ODBC connectivity for new instances and clients
• Wrote PL/SQL backed stored procedures for database access and tuned them efficiently
• Worked in Production Support Environment testing for projects, work orders, maintenance
• Interacted with Business Analysts and Users in requirement gathering Built complex queries
• Using SQL and wrote stored procedures using PL/SQL
• Introduction of OBIEE to end Users and Provided Documentation with Advantages and Disadvantages to it
• Installed and Configured OBIEE 10g at Clients Place.
• Provided POC of OBIEE and Oracle Database as Data source
• Created Basic reports, Pivot Tables and Dashboards Using OBIEE.
• Design and developed Metadata repository .rpd that consists of physical layer, business model / layers with aggregates dimensions, presentation layers with catalogs folders
• Involved in Requirement gathering and writing Functional and Technical documents

Environment: Oracle 10g, TOAD, PL/SQL, OBIEE 10.1.3.4.1, MS Office Suite, Windows 2003.