SUMMARY

• 8 Years of experience in designing, developing and implementation of OBIEE 10g, 11g and 12c.
• Experienced in OBIEE 12, Oracle BI Applications 7.9.6.x, Siebel Analytics 7.x which include building and configuring repository, creating and managing oracle/Siebel Intelligent Dashboards, oracle/Siebel Answers, oracle/Siebel Delivers and oracle/Siebel iBots (ETL Informatica, Reporting - Siebel Analytics, Scheduling-DAC). Experienced in Data Warehousing Methodologies.
• Experienced in OBIEE solution architecting (OBIEE 10g, OBIEE 11g and OBIEE 12c) and have a strong understanding on OBIEE 11g capabilities with Web logic 10.3.5 as an Application server. Knowledge on Tableau 8.1.
• Experience in complete Software Development Life Cycle (SDLC) - Requirement gathering and analysis, Software Design and development, Unit Testing and Project Implementation
• Primary specialization in Oracle Business Intelligence Enterprise Edition (OBIEE 10g, 11g & 12c) Administration and Development, BI Publisher Development and Administration, Tableau Development and Informatica (9.0.1 and 9.5.1) Administration, ODI 11g Administration, DAC 10g Administration and BOXI XI 3.1 SP4 Administration.
• Skilled in Infrastructure management for OBIEE ranging installation, upgrade and troubleshooting performance issues, capacity modeling, simulation and analytics of performance testing data.
• Performance planning for new systems and tuning for existing systems. Infrastructure considerations like clustering, server sizing, space management, memory management, horizontal & vertical clustering, overall health of servers and processes. Design considerations like cache management, model/query tuning, database tuning.
• Well experienced in requirement gatherings, regular updates on project progressions, documenting and team-managing.
• Handling Status calls with business and technical teams and delivering Qualitative products.
• Experienced in creating technical, functional and requirement documentation as per the functional design.
• Experience in designing RPD using Multi User Development (MUDE) and its 3 layers (Physical, Logical, and Presentation layer) configuration with Dimensional Hierarchies, Level Based Measures, Aggregate tables, Fragmentation, Query Federation and Time series Functions based on the requirement.
• Extensive experience in providing end-to-end business intelligence solution by dimensional modeling designing, building business models, configuring metadata, BI Publisher, Answers, building Analytics Repository using OBIEE, configuring delivers / ibots, creating reports / dashboards, cache monitoring.
• Design and implement Business Intelligence best practices, methodologies, and standards and serve as the BI SME for Corporate Performance Systems, Dashboards, Scorecards, KPI’s.
• Experience in working with different Modules Finance ( AR, AP, GL ), Projects, Procurement, iExpense, P2P (Procure to Pay), Supply chain and Order Management, Sales, Manufacturing Analytics, Web Centre, HRA, Retail and Merchandise Analytics etc.
• Experienced in setting up Security and Architecture with OBIEE 11g,12c by using WebLogic Admin Console and Enterprise Manager
• Worked extensively with ODI Designer, operator and metadata Navigator.
• Good understanding of ODI architecture and installation of Topology, Security Manager, agents, Designer, Operator, Master repository and Work repository.
• Experienced in implementing LDAP & External Table Authentication and Authorization for OBIEE and Informatica.
• Experienced in implementing Enterprise Single Sign-On (SSO) for OBIEE.
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of Oracle BI Apps (Finance, HR, Projects, Supply Chain and Order Management), BOXI and Informatica Power Center.
• Proficient in Data Analytics, Transformation, Implementation and Development of projects working with Tableau Desktop
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.
• Experienced in Tableau functionalities with best practices from data extraction to around Worksheets, Dashboards and Report visualizations by using Tableau reporting objects i.e. Facts, Attributes, Hierarchies, Alias, Comments, Transformations, Filters, prompts, Calculated fields, Sets, Groups, Parameters, etc.,
• Delivered innovative solutions with Excellent leadership, team management and communication skills in leading teams during the project phase, training & guiding team members and enabling knowledge sharing sessions among the team.

PROFESSIONAL EXPERIENCE

Confidential,NC

Sr. OBIEE Developer/Admin

• Worked with business analyst on user requirements and wrote functional and technical requirements documents.
• Worked on migration, validation of OBIEE platform from 11G to 12C.
• Daily attending the status meeting with clients and coordinating with onsite team to discuss further move.
• Understand and design the generic metadata RPD, physical and business model diagram mapping and joins with facts and dimensions based on the star and snow flake schemas as per best practices.
• Implemented and Worked on MUDE (Multi-User Development Environment) mode setting up with different users and developers prospective.
• In Business model mapping Layer implemented the dimensional hierarchy, level based measures, aggregations, security groups and roles using LDAP authentication, etc.
• Created new logical columns defining the business logic as per the requirements.
• Involved in setting up session such as user session and repository (static and dynamic) variables such as location as static and current day/month/year as dynamic variable using various initialization blocks.
• Merging the RPD and web catalog folder with OBI admin tool and catalog manager.
• Responsible for implementing data-level security and object-level (dashboards/reports) security among users, groups and web-groups.
• Highly experienced in setting up session variables and repository variables using various Initialization Blocks.
• Responsible for creating additional users and maintaining visibility privileges using OBIEE administration on repository side as well as front end to display OBIEE reports based on the business user for that particular area.
• In reports created the filters and time dimension prompts for all the dashboard pages, charts, tables, Pivot tables, Narrative view and View/Column selector, etc.
• Developed time series objects using Ago and ToDate functions for time series comparisons.
• Implemented write back capability to enter values directly into a report and have those values used in calculations and charts in the report.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
• Handled complex navigation using GO-URL navigation syntax.
• Used JavaScript code to enable email feature to send across the OBIEE runtime report in multiple formats dynamically, as per the groups selected by the user via prompts.
• Experience in implementing Data Model, Multiple Data Set Join, Parameter, procedure call.
• Experience in implementing Data template (RTF)
• Developed many complex BIP report. Added Multiple Group, If else condition, For Loop, Exception condition, complex template level calculation.
• Experienced in working with baseline validation tool in 12C.
• Migrating the application from development environment to QA staging and production environments.
• Developed test cases and performed unit testing and integration testing of the Repository and Web Catalogs.
• Execute defect prevention and causal analysis activities.

Environment: Oracle BI Administration tool 11g/12c, Oracle BI Presentation, Oracle BI Dashboards, Oracle BI Application Server & MUD Environment, BI Publisher, JavaScript, XML, MS Office, Oracle 11g/12c, SQL Developer, Toad, Windows 2008/XP

Confidential, AL

Sr. OBIEE/ODI Developer/Admin

• Worked on Oracle Enterprise Manager (OEM) to activate and Deploy RPD.
• Extensively used Catalog Manager for migrating Web Catalog.
• Worked in developments of analytics Reports using OBIEE Answers and assign them to specific Dashboards with Oracle Financials EBS as source of data from the modules like AP, GL and FA
• GG setup integrated capture to replace CDC.
• Experience in installing, maintaining, upgrading and patching Golden Gate.
• Worked on the RPD for the new Subject area design for the Cash flow Metrics Created Reports, Dashboard Prompts and Dashboard Pages like - Budget and Actual, Balance Sheet.
• Responsible for designing, developing and testing of the ETL strategy to populate the data from various source systems (Flat files, Active Directory-LDAP, SQL Server and Oracle).
• Created Repositories, Agent, Contexts and both of Physical & Logical Schema in Topology Manager for all the source and target schemas.
• Installing ODI 11.1. On all the environments and configuring ODI.
• Testing the newly upgraded ODI 11G and ODI 12C fixing issues related to upgrading and running ODI jobs as per schedule.
• Patching ODI 11.1 to 11.1.1.and Upgrading ODI from 10.1.3.4 to 11.1.1.
• Created ODI Procedure, ODI Package, ODI Variables, ODI Scenarios, ODI Functions, ODI Mappings, ODI Load Plans.
• Created the users, profiles using the ODI security manager.
• Financial Planning Manager and other developers
• As an administrator I was responsible for security across multiple users and groups.
• Created Packages, Scenarios and Load Plan Components, Load Plans using ODI.
• Generated Load Plans and Executed Integrated Testing over Payroll Subject Area using ODI.
• Provide ad hoc ability in the OBIEE system for query and build reports.
• Configured the OBIEE repository(Physical, BMM and Presentation layer)
• Created dimension hierarchies and aggregates in the BMM layer.
• Customized reports in OBIEE answers and integrated them into the Dashboards according to the Business requirements.
• Performed Data Validation of data in the reports and dashboards.
• Unit, integration and system testing for all components of ETL and reporting. Prepared test cases and documented the results.
• Created PL/SQL stored procedures, functions and triggers for change data capture (CDC).
• Creating standalone agent on windows server.
• Implemented CDC through ODI Journalization Knowledge Modules (KMs).
• Developed Expressions, filter, joins, Split, Variables, user functions Using ODI
• Developed interfaces for loading the lookup and transactional data.
• Developed interfaces to load the data from flat files, SQL Server to stage and from stage to Oracle HUB.
• Created Dynamic and Session Variables and Performance tuned the ODI interfaces.
• Changed knowledge modules using Java code for AP/AR for General Ledger tables in ODI.
• Performance Tuning of Reports and made required changes to repository and database.
• Complete responsible for preparing the END to END Document.
• Working on UAT data and hierarchy issues.
• Worked with the team and a DBA to communicate and negotiate data needs.

Environment: ODI 11.1.1.5.0, ODI12c, WebLogic Server 11.x, OBIEE 11.1.1.6.5, OBIA 7.9.6.3, Oracle EBS, Oracle 11g, SQL*PLUS, SQL Developer, Windows XP

Confidential

Sr. OBIEE Consultant

• Involving in business meetings for requirement analysis and to define business and functional specifications.
• Working in Extensive Projects, Perfect Order Index, Thunderbolt, Sephora, Retail Sales, Retail and Merchandise Analytics (RMA), Supply chain and order management
• Identifying the gaps by analyzing the data mart instance and providing alternative solutions as well as recommended changes to database.
• Played the role of Sr. BI Server Administrator and Technical Lead - completely responsible for the availability and stability of all the OBIEE and BI Publisher environments
• Extensively worked in infrastructure management for OBIEE, BI publisher ranging installation, upgrade and troubleshooting performance issues.
• Admin activities ranging from Cache management, Space management, Memory management, Horizontal and Vertical clustering, overall health of servers and processes.
• Implemented MUDE (Multi User Development) environment across the whole organization which helps in smooth, easy, fast rpd development.
• Upgraded OBIEE from 11g to 12c
• Upgraded OBIEE 11.1.1.7.141014 to OBIEE 11.1.1.9.160419
• Successfully implemented the Retail Merchandising Analytics(RMA) by merging with the existing HR and Finance Analytics
• Implemented Usage Tracking and BI Publisher Auditing for understanding and gaining more insights about the reporting environment
• Implemented BI SQL Provider & LDAP authentication for OBIEE 11g
• Implemented Enterprise SSO for OBIEE 11g
• Implemented “Act As” functionality to help the support team to troubleshoot the user access issues
• Experienced managing environments using Node manager and other server administration utilities
• Actively involved in Strategic Backup, Restore and Recovery for complete recoverability
• Responsible for maintaining and administering the user access setup and the complete security setup implementation.
• Actively involved in the Design review meetings to provide Business Intelligence best practices, methodologies, and standards and serve as the BI SME for Corporate Performance Systems, Dashboards, Scorecards, KPI’s.
• Applied bundle patches and one-off patches across the environments to address the issues and to keep the environment up to date with the latest release.
• Identifying the sources and preparation of Data mapping matrix Technical Design Document.
• Collaborate with business/management to improve and customize reports/existing processes
• Provide regular status reports to management on application status and other metrics
• Onsite coordination and follow up with Developers on Daily status.
• Designing and developing the Metadata Repository using OBIEE Admin Tool by importing the required data base objects both Facts and Dimensions with integrity constraints into physical layer using connection pool
• Designing and developing Web catalog objects - Reports/Dashboards.
• Working closely with users/developers and administrators to resolve the production problems by reviewing design changes.
• Debugging reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• Performance tuning of Dashboard/Reports and made changes to database by implementing materialized views and partitions, rebuilding of indexes
• Performing unit, Integration and Regression testing of various Dashboards/ Reports and repository.
• Supporting migration of the Code to TEST, UAT and PROD

Environment: OBIEE 10g, OBIEE 11g, OBIEE 12c. BI Publisher 11g, Smart View 11, OEM 10g/12c, Oracle 11g, Oracle 10g, PL/SQL Programming, Unix Shell Scripting, Share point

Confidential,Columbus, IN

Senior BI Consultant

• Solution designing for reporting requirements from heterogeneous sources
• Involved in requirement gathering and designed the application architecture as per user requirement and OOTB / DW standards
• Deriving estimations for development effort for each phase of the deployment of Dashboards/Reports. Preparation of Agile approach and detailed task identification, resource estimation, coordination to prepare project plan.
• Upgraded OBIEE 10g to 11g and OBIEE 11.1.1.5 to 11.1.1.7
• Upgraded BOXI from SP4 to SP7
• Upgraded Informatica from 8.1.1 to 9.5.1
• Installed, Migrated and Configured DAC repository due to data center movement.
• Installed and configured OBIA (Finance, HR, Supply Chain)
• Implemented LDAP for OBIEE 11g and OBIEE 10g
• Implemented Usage Tracking in OBIEE
• Stabilized OBIEE 11g migration activities
• Improved stability of OBIEE 11g development servers.
• Developed the applications using different chart objects like Bar Chart, Line Chart, Pie Chart, Straight table and Pivot table, Treemap, Heatmap, Waterfall Chart and Donut Chart in Tableau Desktop.
• Designed and developed the OBIEE Metadata repository along with the security.
• Designed and developed OBIEE reports and dashboards as per the functional requirement.
• Identified and created aggregate tables to improve query performance.
• Used Sets, Bins, Parameters, Aggregate Functions, Filters, Action in Tableau
• Used Tableau Desktop to analyze and obtain insights into large data sets.
• Combine the visualizations into Interactive Dashboards, Stories and publish them to the web using in Tableau Desktop 9.1
• Publishing the Worksheets, Dashboards and Stories on Tableau server to share it with multiple BU’s.
• Have created visualization reports on Tableau Desktop9.1 on existing data model build in DW
• Create visually compelling and actionable interactive worksheets and dashboards for the clients to analyze various KPIs
• Created ODI packages, scenarios using interfaces, variables, procedure
• Worked extensively with ODI Designer, operator and metadata Navigator.
• Good understanding of ODI architecture and installation of Topology, Security Manager, agents, Designer, Operator, Master repository and Work repository.
• Worked with DBA and technical team to identify and resolve performance bottlenecks and provide appropriate solution

Environment: OBIEE 10g, OBIEE 11g, BI Publisher 11g, Smart View 11, Tableau 8.x/9.x, OEM 10g, Oracle 11g, PL/SQL Programming, Unix Shell Scripting, Clear case

Confidential

OBIEE Developer

• Served as Senior Developer and Tech lead for a team of four
• Involved in requirement gathering through face-face workshops with clients
• Consolidated the requirements and created detailed specification document
• Involved in designing of reports after thorough analysis of requirement
• Designing includes data mapping, data base objects creation, data flow logic creation using Stored Procedures and back end data preparation
• Data modeling using RPD (Repository Meta Data)
• Creation of OBIEE reports and pages using Answers and Dashboards
• Data Validation from back end, unit testing of reports and integration testing
• End-to-end analysis and solution of OBIEE issues
• Performance Tuning through caching schemes and usage tracking
• Worked on the security feature like users, user groups and their roles
• Documentation: Involved in tracking the data base changes, preparation of Unit test cases, review of System Test Scripts and Unit Test Cases, creation of Detailed Specification Documents
• Participated in the Business Continuity Plan (BCP) setup and testing as part of Disaster recovery

Environment: OBIEE 10g, OBIEE 11g, Oracle 10g, SQL Server 2000, PL/SQL Programming, Unix Shell Scripting, SVN