SUMMARY:

• 7+ years of experience in Analysis, Design, Development, Administration, Testing, Support and user training of Data Warehousing and Business Intelligence applications using ODI,OBIEE and Oracle Applications.
• Excellent experience in designing OBIEE Dashboards, BI Answers, and Analytics using Administration Tool of Oracle Business Intelligence Enterprise Edition on Top of Data Marts and Data warehouse.
• Analyze, design, develop, modify and test OBIEE 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.
• Excellent experience in Dimensional Data modelling using Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modelling.
• Expertise in providing end-to-end business Intelligence solutions using (OBIEE 10g/11g) with greater emphasis on BI Administration Tool and BI Analytics web, Dashboard Creation, Answers, BI Publisher.
• Expertise in creating and implementing functionalities like Dimensional Hierarchies, Measures, Aggregation rules, Level based measures, Rank functions, Time Series Object
• Well-versed in Data Transformations and Data Migrations using Oracle Data Integrator 10g/11g from heterogeneous sources such as Oracle, MS SQL Server, DB2, Legacy systems, Flat Files and XML Files to perform ETL operations.
• Highly experienced in using Oracle Data Integrator (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into Enterprise data warehouse (EDW).
• Skilled in using ODI graphical interface modules - Security Manger, Topology Manager, Designer and Operator with versions ODI 10g/11g and 12c.
• Expertise in ODI setup, Master Repository, Work Repository, Projects, Models, Packages, Interfaces, Scenarios, Filters, Metadata and extensively worked on ODI knowledge modules (LKM, IKM, CKM, RKM and JKM).
• Worked extensively on debugging, troubleshooting the defects and production issues in the areas of ODI jobs and OBIEE reports.
• Extensively utilized OBIEE delivers for sending alerts via intelligence agents (iBots) to interactive dashboards for subscribed users.
• Excellent experience in designing and implementing complex ETL/ELT jobs.
• Experienced in working with Multi User Development environment (MUD) and configuring the security settings in OBIEE administration tool to setup groups, access privileges using LDAP and external database authentication.
• Familiar with database performance tuning by implementing materialized views with query rewriting, creating appropriate indexes, usage of hints, rebuilding indexes and analyzing query execution using the explain plan.
• Highly experienced in working with OBI Answers, OBI Dashboards, BI Publisher and OBI Delivers.
• Extensively involved in developing Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Involved in performance tuning of Oracle SQL, PL/SQL queries.
• Extensively worked with third party database tools like TOAD, SQL Developer.
• Experience working closely with client in order to understand their requirements, issues and suggesting relevant solutions.

TECHNICAL SKILLS:

OBIEE Infrastructure: OBIEE 11.1.1.7, OBIEE 11.1.1.6, OBIEE 10gOBIEE Applications OBIA7.9.6.3, 7.9.6.1(Financialanalytics, HR Analytics, Sales, Service, Marketing)

ETL Tools: Knowledge in Informatica Power Center9.0, Informatica Power 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 Model,Agile Methodology, Rational Unified Process (RUP)

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. OBIEE/ODI Developer

Responsibilities:

• Gathered requirements from the customer, designed the technical specs and technical documentation, developed Interfaces and Workflows as per the business requirement, tested the application and deployed it to production.
• Built the Interfaces with ODI 11g Designer using transformations like Source Qualifier, Expression, Filter, Router, Joiner, Sequence developer, Update Strategy, Lookup, Sorter, Aggregator, Normalizer, XML Source Qualifier, Stored procedures
• Responsible for creating interfaces, procedures, packages and load plans using ODI and monitored the workflow run and statistic properties on ODI Operator.
• Involved in creating rules and transformation on staging tables in ODI designer and using variables in ODI like counter variables and filename variables.
• Created ODI design documents and used the documents in development of ODI interfaces and packages.
• Hands on experience for reverse engineering of databases using ODI designer tool.
• Involved in installation and configuration of ODI 11g.
• Used Topology manager to create connections to various technologies (Such as Oracle, SQL server, Flat files, XML etc.)
• Wrote conversion scripts using SQL, PL/SQL, Stored procedures, functions and packages to migrate data from SQL server data base to Oracle database.
• Wrote SQL, PL/SQL, SQL* Plus programs required to retrieve data using cursors and exception handling.
• Involved in Performance tuning for sources, targets, interfaces and sessions.
• Conducted data investigations and assisted the business partners with complex data analysis and ad-hoc queries
• Developed stored procedures, triggers, functions and complex extensively using Oracle 11g PL/SQL.
• Experienced in creating database connections, physical and logical schema using Topology Manager.
• Designed, documented and tested logical and physical data models optimized for operational and analytical reporting.
• Created Income Statements and Balance Sheet reports from GL, Top 10 supplier and Invoice reports from AP, Aging Reports from AR.
• Used BI Publisher and created complex pivot table reports and cross-tabular reports using connected queries of data models with parameters passed from data model as well as parameters.
• Reconciled the data in the reports to tie numbers back to PeopleSoft, which was the system of record.
• Effectively communicated and collaborated with cross-functional business partners and made them love the flexibility the OBIEE tool has to offer.
• Used PLSQL Developer for running SQL queries.

Environment: ODI 11.1.1.9x/11.1.1.7 x, OBIEE 11.1.1.9/11.1.1.7, OBIA (Inventory, Sales, Bill of Material, Order fulfilment, Shipping), Oracle 11g, PL/SQL, SQL, ODBC.

OBIEE/ODI Developer

Responsibilities:

• Created and developed the ODI Interface metadata mappings to extract the data from Exhibition Event Master and EBS Apps to consolidate the data into Enterprise data warehouse.
• Involved in system performance tuning to improve the performance from OBIEE report/dashboard wise and RPD.
• Designed ETL mappings for bringing in data from various data sources using ODI.
• Identified the fact and dimension tables, designed the Kimball Matrix, created the data mapping field matrix
• Developed multiple Dimensions with multiple Drill-Down Hierarchies in Business Model Layer and customization of Presentation catalogs in Presentation Layer
• Designed Aggregate Tables modeled the repository for improving performance of reports.
• Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
• Developed OBIEE dashboards using JavaScript and Cascading style sheets.
• Created Roles/Groups in OBIEE to provide the access to multiple departments without relying on the responsibilities.
• Integrated LDAP server in order to authenticate the users along with Native authentication. Maintained the groups in LDAP and applied the security on user level.
• Identified Gaps by analyzing the Datamart instance and provision of alternative solutions as well as recommendation of changes to databases.
• Developed Time Series objects for computing Year Ago, YTD, MTD, WTD measures. Also created Fragmentation content for few fact tables
• Involved in data model designs and assisted in ETL design mappings using Oracle Data Integrator (ODI) to extract the data.
• Modify existing ETL jobs in Oracle Data Integrator(ODI).
• Develop data extracts from the data warehouse environment using ODI.
• Built Interactive Dashboards with drill-down capabilities, use of global prompts and Presentation variables
• Extensively worked on complex Interfaces which involved slowly changing dimensions.
• Created Complex procedures and used them in the interfaces to load the data to simplify the interface design. Automated the schema name using ODI interface function in procedures.
• Customized requests and modified the OBIEE Dashboard using cascading style sheets
• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements
• Performed Unit, Integration, and Regression testing to validate report and mapping
• Respectively participated in weekly Project status meetings and communicated effectively with Project Managers

Environment: OBIEE 11.1.1.5.x, BI Publisher, Oracle 11g, ODI 11.1.1.9, SQL, PL/SQL.

OBIEE Developer

Responsibilities:

• Worked with end users to gather Business Requirements and efficiently converted the requirements to technical specifications for developing the Reports/Dashboards as defined.
• Upgraded the entire application and components from OBIEE 10.1.3.4.2 to OBIEE 11.1.1.5.0/11.1.1.6.0/11.1.1.7.1, re-designed the security, customizations and re-configured the external application.
• Implemented Security by setting Security Realms in Weblogic Console and by configuring Policies, Roles and Groups in Enterprise Manager and integrated them with LDAP and External Table.
• Designed and developed Metadata Repository using BI Server Administrator tool by importing the required objects with integrity constraints into Physical Layer using Connection Pool.
• Categorized the Facts, Dimensions and identified the Granularity level in accordance with the need of end user before implementing the Multi-Level Based Hierarchies.
• Customized Star and Snowflake schemas by linking the Fact and Dimension Tables.
• Created measures and Aggregated Tables to better the performance/understanding of the reports.
• Effectively implemented Time Series Functions, calculation Wizard and Expression Builder to generate trend analysis reports.
• Developed Performance Tuning Strategies, for optimized performance, by implementing Aggregate Navigation, Cache Management, re-organizing data, and making some changes to Reports.
• Implemented Security at Object level and Data level in the OBIEE Repository and Answers by creating Repository and Session Variables and Initialized Blocks.
• Created Security settings in OBIEE Administration Tool to set the groups and accessprivileges and query privileges. Also implemented security for the groups at the BI Answers.
• Developed end-user and migration Documentation briefing the features and capabilities of various reports with screenshots and supporting description on how to schedule and execute.
• Developed reports and dashboards with various analytical views with Global and Local Filters.
• Customized Prompts page level and Dashboard level, in accordance with the requirements.
• Developed Guided Navigation drill downs, Pivot Tables, Narrative Views, Charts to improve accessibility of dashboards.
• Configured presentation layer used by different user groups and also established various standard queries in order to create precise presentation layer.
• Designed and Integrated BI Publisher reports to oracle BI Dashboards for Analysis to PDF/RTF templates.
• Deployed the test cases and test scripts to test the reports during the Testing phase.

Environment: OBIEE 10.x/11.x, Oracle 11g/10g, SQL *PLUS, Toad, BI Publisher, Smart View 9.3.1

Sr. OBIEE Developer

Responsibilities:

• Analyze, Design and Developed OBIEE Metadata repository (.rpd) that consists of physical layer, multiple business model / layers with aggregates, dimensions & time series objects, presentation layers with catalogs & folders, external table security using session variables, test and validate the model using Siebel Analytics Server Admin tool.
• Designed Star Schema for fact & dimensional tables and created alias for the dimensional tables when necessary.
• Worked Extensively on OBIEE/Siebel Analytics Administration Tool, Siebel Analytics Web/Presentation Services, Answers, & Interactive Dashboards and Security Implementation.
• Worked on repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration Tool.
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Developed many Dimensions and Time Series Objects with Security settings for analyzing
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Organize presentation layer in a format that is easy for end user to use as basis for reporting using Oracle BI Administration tool (.RPD).
• Used Optimization Techniques and Database hints to improve the query performance and better reporting.
• Worked extensively on Oracle BI Publisher and provided the capability to download the reports in the user defined formats.
• Configured iBots using Delivers to seed server cache and send requests to dashboards as Alerts.
• Customized Activity and Revenue star schemas.
• Deployment of the OBIEE RPD to the BI Presentation Services.

Environment: OBIEE 11.1.1.5/6, OBIEE 10.1.3.4, BI Publisher 10.1.3.4, Informatica 8.6, SQL Server 2005, Oracle 10g/11g, SQL, TOAD, Windows XP.

OBIEE Consultant

Responsibilities:

• Gathered Business Requirements by interacting with IT and documented
• Created High-level Design Documents (HLD) according to the Business System Requirements
• Worked as an Application Designer for Mapping & Designing RPD and ETL development.
• Documented Application Design Mapping & ETL Mapping, which helps Developers to implement ETL and RPD.
• Designed and Developed Custom Business Intelligence Solutions (Metadata and Dashboards/Reports) using OBIEE platform.
• Developed the OBIEE Metadata repository (.rpd) model with the necessary logic that involved creating the Physical, BMM layers with aggregates, dimensions & time series functions, Presentation layer with catalogs & folders and external table security using Siebel Server Admin tool. Also created hierarchies, variables, and event poll strategies in the repository.
• Developed Dashboards for each of Metrics by embedding Reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Implemented Dynamic Navigation to allow the system to pass parameters from the summary dashboards to the details dashboards.
• Implemented Groups and Hierarchy Level Based security to dashboards based on Role.
• Configured and automated iBots to deliver daily and weekly reports based on schedule.
• Performance Tuning of Reports by implementing the aggregate navigation, Cache and Oracle Materialized Views.
• Worked on DAC, Analytics for creating Auto Execution and Scheduling Tasks.

Environment: OBIEE 10g, Oracle 10g, Oracle Enterprise Manager, Oracle Developer 6.0/6i, SQL*Loader, SQL*Plus, PL/SQL, Windows 2000, Autosys, UNIX (Sun Solaris), TOAD, PL/SQL Developer