SUMMARY

• 7+ Years of experience in Analysis, Application Development, Maintenance, Implementation on Oracle 11g/10g, Informatica power center 9.x/8.x, OBIEE11g/10g, DAC 10g/11g and OBIA Reporting.
• Extensive Experience in End to end implementations and working in all levels of the OBIAstack including OBIEE, BI Publisher, DAC, Informatica, Database, RPD, Web Catalog.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Implemented OBIA OOTB Supply Chain and Order Management and Financial Analytics for Oracle EBS
• Experience in Installation and Configuration of OBIA (including Informatica, DAC and OBIEE) Out of the Box Reports.
• Expertise in analyzing and designing customized analytical reports and creating Interactive Dashboards with drill - down capabilities using OBIEE.
• Experience with repository development, configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Pages, Folders, Reports). Added Metadata changes to the OBI RPD.
• Customized OBIA Out of Box Reports to meet the requirements by doing Business Analysis, Technical Analysis and RPD Modifications.
• Extensive experience inOBIEE Administration Tool, OBI Answers, OBI Intelligent Dashboards, OBI Publisher, Delivers and iBots with OBIEEApplications.
• Developed Application Flow, Application Configuration and Application Filter setup using OBIEE 11g platform.
• Extensive experience using ETL tools in data integration and data-warehousing with hands on knowledge with data modeling and developing data marts, multi-level dimensions.
• Experience in developing Dimensional Hierarchies/Creating Aggregate Measures/Aggregate Tables/New logical columns/Filters/Variables/Time Series Functions as per business requirements.
• Proficient in configuring Security settings at various levels both in Repository level (OBIEE Administration Tool to setup Groups, Access Privileges and Query Limits) and Presentation Catalog level.
• Experience Integrating LDAP Server for authentication of users and working in Multi User Development Environment (MUDE).
• Experience developing reports & dashboards in OBIEE (BI Publisher, Dashboard, Answers, Delivers, Oracle BI for Microsoft Office).
• Expertise in Creating Dynamic Dashboards and OBIEEAnswers using Prompts, Filters, Calculations, Charts, Pivot tables, View Selector and Conditional Formatting.
• Configured, Designed and developed BI Publisher reports by integrating them with Microsoft Office application according to client's requirement.
• Experience in migration techniques for OBIEE, ODI, Informatica and DAC components into various test and production environments.
• Experience using OBIEE 11g, especially in configuring Security settings using Weblogic Server (Users and Groups), Oracle Enterprise Manager (OEM for Roles and Privileges) and Presentation Catalog.
• Strong Knowledge and Understanding of upgrading and implementing OBIEE 11g.
• Created 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.
• Experience in designing and testing mappings, mapplets and workflows using Informatica PowerCenter.

TECHNICAL SKILLS

OBIEE Infrastructure: OBIEE/ BI Publisher 11.1.1.7, OBIEE 11.1.1.6, OBIEE 10g

OBIEE Applications: OBIA7.9.6.3, 7.9.6.1(Financialanalytics, HR Analytics, Sales, Service, Marketing)

ETL Tools: Informatica Power Center9.0, InformaticaPower center8.6.1, DAC 10.1.3.4.1 , ODI 11g

Languages and Web Technologies: SQL, PL/SQL, Java, C, C++ XML, HTML/XHTML, TOAD, SLA

ERP and Applications Servers: Oracle Applications 11i, R12, PeopleSoft 8.9, Oracle Web Logic Server 10.3.5

RDBMS: DB2 UDB (8.x and 7.x), Oracle11g/10g, MS-Access, SQL-Server 2008,Hyperion System 9 Essbase

Operating Systems: Microsoft Windows 8.x, Windows 7, Solaris 5.8, UNIX, Oracle Enterprise Linux 5.7, Mac OS X

Methodologies: Software Development Life Cycle (SDLC) -Waterfall ModelAgile Methodology, Rational Unified Process (RUP)

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Sr. OBIEE Developer

Responsibilities:

• Worked with OBIEE Installation, Oracle BI Server, Presentation Server, Oracle BI Administration Tool and Oracle BI Publisher.
• Developed OBIEE repository to on top of Sales, Marketing data warehouse.
• Used the OBIEE Admin tool to develop and enhance meta-data.
• Performed the detailed design of Reports / Dashboards and Analytical Data Model (Metadata / .rpd).
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, and event polling strategies in the repository.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes.
• Viewing report data in BI publisher using templates.
• Managed the development, release activities and Worked on production Support.
• Modify existing ETL jobs in Oracle Data Integrator (ODI).
• Created numerous Interfaces to load data from Flat files, CSV files and Oracle tables into staging tables and then into respective FACT/DIMENSION/Look-up Tables in Data Warehouse.
• Customized ODI inbuilt KM (Knowledge Modules) to build Interfaces for complex data requirements.
• Used ODI in-built scheduler to schedule Scenarios/Load Plan's in production.
• Setup of OBIEE environments and maintenance.
• Designed Schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Using PLSQL working on Inbound and outbound interfaces.
• Worked with the users to explain about the new features of OBIEE 11g.
• Worked on the performance tuning of the dashboards and reports and managed security.
• Configured Physical & BMM layer - import tables, Identifying facts, dimensions, created physical tables, join the tables, creating the logical tables and logical columns using OBIEE 11G Administration tool.
• Created Drill down Hierarchies and implemented Business Logics and Facts.
• Create OBIEE Publisher RTF template and Data models and Bursting.
• Created customized format and calculation in the OBIEE Publisher reports.
• Experience in migration techniques for OBIEE components into various test and production environments.
• Created Aggregation tables in OBIEE and Created Job Scheduling for Aggregation Tables.
• Prepared documentation on Technical specifications, Scenarios, Business processes, Workflows, Process flows, Unit Test cases.
• Created and Executed 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: Windows server 2008, OBIEE 11.1.1.7.1 , BI Publisher, Oracle 11.1.0.7, WebLogic 10.2, TOAD, Siebel CRM.

Confidential, Boston, MA

Sr.OBIEE/OBIA Consultant

Responsibilities:

• Gathering requirements, Analysis, functional and technical specifications, interacting with Business Managers and End users.
• Expertise in Using admin tool to creation of repositories by using physical layer, BMM layer and presentation layers. Worked on BMM layer to customize the tables, hierarchies, dimensions and aggregations and calculations.
• Used aggregate persistent wizard to aggregate data at higher level for performance tuning.
• Implemented various Repository Variables and System Variables depending up on user requirements.
• Created transformations like Expression builder, joiner, and router.
• Utilized various building blocks like calculation measures, time series measures, initialization blocks.
• Designed various reports on Sales, using Pivot, Narrative and Chart reports in Answers and Configured & Customized Intelligent Dashboards for different groups of users to view across regions, Customer Demography with the facility to drill downs and Charts.
• Expertise implementing Oracle BI Apps in all phases like implementing Out of order Box prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided DataWarehouse, OBIEE RPD development, OBIEE reports and Dashboards
• Extensively worked on Sales, Financial and HR Analytics.
• Experience in Oracle E-Business Suites' Financials module, Conversant with all modules of Oracle EBS 11i/R12 - GL, AP, FA, AR.
• Used Delivers using iBots to provide timely updates to the management.
• Giving security permission / privileges as per the role of each user.
• Tested and validated the repository, the data in reports and dashboards.
• Developed ETL programs (mappings, sessions, workflows) via Informatica.Created complex mapplets for reusable purposes.

Environment: Siebel Analytics 7.7, OBIEE 11.1.1.3, BI Applications 7.9.4/7.9.5 , Informatica Power centre 8.x, Windows XP, and Oracle10g, SQL Server 2005/2008, Financial Analytics 7.9.6.3.

Confidential, Dover, NH

OBIEE Developer

Responsibilities:

• Business requirement gathering, understanding business objectives and analysis.
• A full cycle development of Siebel Analytics (Supply Chain Analytics) was implemented. Involved in indentifying, designing, configuring &testing the application.
• Involved in the Supply Chain & FDM project where it involves replication of SAP BW reports to OBIEE.
• Get the database connectivity and design the Physical Layer, Business model and Mapping layer and the presentation layer in the repository (.rpd).
• Add users to the new group and apply the data level security and object level security at the rpd and Web catalog.
• Involved in the analysis of the existing system reports and modification of the reports, created new reports based on the user requirements.
• Worked Extensively on OBIEE/Siebel Analytics Administration Tool, Siebel Analytics Web/Presentation Services, Answers, & Interactive Dashboards and Security Implementation.
• Define iBots / Delivers for various requests if needed.
• Created reports in BI Publisher using PDF, RTF templates.
• Performed OBIEE Administration -including creation of users and cache management.
• Created hierarchies based on the territory level to territorial level sales and contact reports.
• Developed many PL/SQl procedure & functions and used the same in mappings.
• Created reports and delivered the same to the end-user through Delivers.
• Created Dimensional Hierarchy fro Date, Facility and Location Dimensions, Level based Measures and Aggregate navigation in BMW layer.
• Merge Repositories two way and three way into master repository from each developer.
• Merging Catalogs folders to master catalog using Catalog Manager.
• Developed many Dimensions and Time Series Objects with Security settings for analyzing.
• 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. Mapped the configurations to accommodate for the Territorial hierarchy that were accommodated via chart drilldowns.
• Implemented security by creating roles & web groups, External tables.

Environment: OBIEE 10.1.3.3/10.1.3.4 Oracle 10g/11g, SQL, Windows 2003 Server, Windows Services, UNIX, TOAD, PL/SQL.

Confidential, Woodbury, MN

OBIEE Admin/Developer

Responsibilities:

• Designed Schema using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Configured Physical & BMM layer - import tables, Identifying facts, dimensions, created physical tables, join the tables, creating the logical tables and logical columns using OBIEE 11G Administration tool.
• Built Business model and established relationships & Foreign Keys Physical & Logical between tables. Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local filters) using Oracle BI Presentation Services.
• Created Drill down Hierarchies and implemented Business Logics and Facts.
• Created Aggregation tables in OBIEE and Created Job Scheduling for Aggregation Tables.
• Worked on Dimensional Hierarchies (Ragged&Skipped) and Level Based, Level Based Measures and Time series Functions based on business requirements.
• Experience in performance tuning in OBIEE and gathering performance metrics for various measures in reports.
• Implemented Ago, ToDate and Period Rolling Measures in OBI 11G.
• Developed and Implemented Market Basket Analysis and RFM Analysis for Retail Clients.
• Strong domain knowledge in Retail Industry - Involved in Marketing, Sales and Customer Analytics.
• Experience in migration techniques for OBIEE components into various test and production environments.
• Worked on the Procurement and Spend analytics reports.
• Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard (GL)
• Customized Payments Due, Payment Performance, Customer Report dashboard pages in Account Receivables (AR).

Environment: Windows server 2008, OBIEE 10.1.3.4, Oracle 11.1.0.7, Web logic 10.2, Informatica, Oracle EBS 11.5, Unix OS.

Confidential

Data warehouse Developer

Responsibilities:

• Oracle Business Intelligence, Informatica & DAC
• Gathered and analyzed reporting requirements for the sales and marketing departments
• Interacted with operations and billings subject matter experts (SME) & business analysts in gathering and analyzing the report requirements for the sales managers.
• Involved in developing and documenting technical specifications from business requirements
• Configured metadata objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard, Pages, Folders, and Reports).
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain weekly reports, delivery of reports through email, hand-held devices and mobile phones.
• Implemented Security through external database table authentication and authorization through session system variables, Initialization blocks and groups.
• Involved in Data and Dimensional modeling creating Facts, Dimensions and Measures
• Used Informatica Power Center tools for analysis, design, mapping and workflow.
• Performed extraction, transformation, and loading (ETL) for data warehouses by consolidating data from heterogeneous data sources.
• 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 OBIEE Repository.

Environment: OBIEE 10.1.3.4,10.3.3.x, Informatica Power Center 8.6/8.5.1/8.1.1 , Oracle 10g, Oracle BI Apps 7.9.X, DAC, MS SQL Server 2005, DB2 Flat files, Toad, Windows NT.