SUMMARY

• Over 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 inOBIEEsolution architecting (OBIEE 10g, OBIEE11g andOBIEE 12c) and have a strong understanding onOBIEE11g capabilities with Web logic 10.3.5 as an Application server. Knowledge on Tableau 8.1
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers includingPhysical, Business Model and Mapping, and Presentation layer. Experienced in working with Oracle Fusion & Web Logic.
• Experienced in designing and developing Data Modeling and Analysis using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables and Physical and Logical data modeling in the OBI Administration tool.
• Highly skilled at configuring OBIEE Metadata Objects including repository, variables,interactive dashboards with Map viewer/Big Maps/Google Maps, reports and three tier OBIEE architecture.
• Experienced in writing, testing and implementation ofStored Procedures and Packages at database level using PL/SQL, Database designs Methodologies.
• Experienced in Integrating OBIEE with Hyperion Essbase 9.x and in developing RPD and reports against multidimensional databases.
• Expert in configuring, designing, development, implementation and using Oracle pre-build RPD’s (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.) and ETL Mappings according to business requirements. Experienced in Oracle EBS R12 Financial.
• Extensive experience in OBIEE/Siebel Analytics, Oracle BI applications and Informatica
• Expert in building repositories using star schema, developing Subject Areas, and applying security (group, access / query privileges) at object and data level in Administration Tool. Hands on experience in customizingreports, filtersandchartsin Oracle BIAnswers, Interactive Dashboards, BI Publisher (Excel) and Delivers. Expert knowledge of report development execution in a complex environment.
• Comprehensive knowledge in general accounting principles, business functions of general ledger, treasury accounting, accounts payable, asset management, billing, cash flow statements and receivables.
• Experienced in Simplifying Migration Process - Changing environment specific variables in RPD development, administration, analysis report.
• Created and scheduled iBots using delivers to send alerts, run reports, and deliver reports to the users. Experienced in supporting performance tuning and process tuning at all levels.
• Proficient in using the time-series functions to support historical time comparison analysis and creating requests, adding filters, creating prompts, and creating pivot tables.
• Experienced in configuringUsage Tracking and Multiuser Development Environment (MUDE).
• Hands on experience on using Hadoop components like MapReduce, Hive, Pig, Impala, Zookeeper, Sqoop, Hbase, Oozie, and Flume for data extraction, storage and analysis.
• Experienced increating Dimensional hierarchies and designing customized interactive dashboardsin OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Experienced in translating business requirements into a business dimensional model, key subject areas, dimensions, hierarchies, attributes and measures.
• Excellent interpersonal and communication skills for efficient client interaction.

TECHNICAL SKILLS

Reporting Tools: OBIEE 12C, OBIEE 11.1.1.7, OBIEE 11.1.1.6, OBIEE 10g, Siebel Analytics7.5, 7.7, 7.8.X, Oracle BI Apps7.9.X

OBIEE Applications: OBIA7.9.6.3, 7.9.6.1(Financial analytics, 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, ODI 12c

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, Boston, MA

Sr. OBIEE Developer

Responsibilities:

• Designed and populateddimensional modelsbothstarandsnowflake schemasfor a data warehouse andData marts.
• UsedParallel extender (Informatica 8.1.1)while running jobs for bulk data splitting and to pass the data into subsets to all available nodes for best job performance.
• Used ODI to convert at type of data (OLTP to OLAP) in to Star or Snow Flake Schema.
• Requirement analysis, Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using theOracle Business Intelligence(OBI) Analytics platform.
• Involved in the design of the BAL (Business Analytics Layer) & designing the DW for the BAL.
• ConfiguringOBIEEwithLDAPserver for Security.
• Configured BI Publisher with OBIEE
• Worked on Installing ODI on windows.
• Designed and Developed OBIRepositoryat 3 layers i.e., Physical Layer (connecting to Data Warehouse & imported objects with joins), Business Model / data mapping (create Logical tables,Drill-Down Hierarchies&complex joins) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.
• Used ODI to Extract, Load and Transform Data.
• Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
• Extensively involved in production issues.
• Used Yellow Interfaces Reusable mappings in ODI 11g for developing most complex interfaces.
• Increased performance of loads by applying proper Hints, Indexes, and Analyzing master tables and explain plans to check cost.
• Configured Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
• Extensive Experience on Topology Navigator with developing Physical and Logical Architecture, Contexts and Configuring Agents.
• Created and Configured ODI Repositories, Interfaces, Packages, Procedures and Scenarios.
• Extensively used ODI to load data from Oracle, XML files and flat files
• Implemented security atObject Level&Data Levelfor different level of hierarchies & Subject Areas.
• Worked with differentData Sourcesin OBIEE.
• Used OBIEE as a way to report and graph ODI ETL Execution.
• Developed Different kinds of Reportspivots, Interactive Dashboardswith drill-down capabilities, charts, tabular using global and local Filters using Siebel Analytics Web.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layerof a Repository by using Star Schemas
• Installed and configuredOBIEE.Admin tool and Siebel webcomponents includingIntelligence Dashboards, answers, delivers and Analytics web and BI Publisher.
• AddedAggregate measuresusing Aggregate Persistence Wizard
• EnabledUsage TrackingTable and Dashboards
• Developed complex reports involving complexSQLfilters.
• Developed strategy for migration from Siebel Analytics 7.9.5 to OBIEE 11.1.1.7.
• Performed the benchmark and SLAs for up gradation process and runtime ofOTBand new reports while doing migration from Siebel Analytics toOBIEE.
• Extensively worked onworkflow managerandworkflow monitorto create, schedule, monitorworkflows,work lets, sessions, tasks etc.
• Extracted data from heterogeneous sources forETLprocess,
• Worked on complex transformation scenarios for successful completion of mapping.
• Optimal utilization ofobject-reusabilityfeatures likereusable transformations, mapplets, copying objects from other repositories, usingvariable/parametersfor simplifying mappings.
• Performance tuning of Informatica data warehouse loads, includingInformatica Server Managerand PL/SQL procedures.

Environment: OBIEE 11.1.1.7, Informatica 8.1.1/9x, BI Publisher, Hadoop, ODI 11.1.1, DAC 7.8.5, OBI Publisher 11.1.1.9, Siebel Analytics 7. 9.5, XML (BI) Publisher, SQL Server 2008, Oracle 10RG2, PeopleSoft 9.0, TOAD, Windows XP.

Confidential, Boston, MA

Sr. OBIEE Developer

Responsibilities:

• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.
• Created/Modified Metadata repository (.RPD), Customized BI Repository, defined/developed Physical Data Layer, Business Model & Mapping Layer and Presentation Layer using BI Administration Tool.
• Created and used Repository Variables, Session Variables, Presentation Variables and Initialization Blocks into BI Admin tool & Answers.
• Configured & managed Application role & Application Policies for Users & Users group using Enterprise manager.
• Built Business model and established relationships & Foreign Keys Physical & Logical between tables.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Developed many Reports with different Analytics Views (Drill-Down, Pivot, View Selector and Tabular with Filters) using OBIEE Answers.
• Security management for users, groups and web-groups using the various authentication systems such as LDAP authentication using Session Variables, as well as Dashboard / Report-level security.
• Using OBI EE Delivers to configure, schedule, and deliver Personalized Alerts to Intelligence Dashboards via Intelligence Agents (iBots)
• Used Different BI Publisher Templates like RTF, Excel to replicate the layouts based on sample reports provided by the users.
• Worked on BI Publisher reporting to create structured reports using Microsoft word for SEC fed filings
• Responsible for development and running Map-Reduce jobs on YARN and Hadoop clusters to produce daily and monthly reports as per user's need.
• Responsible for scheduling and managing jobs on a Hadoop cluster using Oozie work flow.
• Experienced with the Scala, Spark improving the performance and optimization of the existing algorithms inHadoop using Spark Context, Spark-SQL and Pair RDD's
• Expertise in designing and deployment of Hadoop cluster and different Big Data analytic tools including Pig, Hive, HBase, Oozie, Sqoop, Flume.
• Responsible for setting up the environment including installation of OBIEE, BI Apps and Informatica.
• Experience in the development of BI publisher reports, as well as upgrade of reports from 10g to 11g.
• Worked with application teams to install operating system, Hadoop updates, patches, version upgrades as required
• Responsible for cluster maintenance, adding and removing cluster nodes, cluster monitoring and troubleshooting, manage and review data backups, manage and review Hadoop CSV/XML files
• Involved in the upgrade done for OBIEE and ODI.
• Worked closely with Users and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Repository.
• Assembled subject areas and created execution plan and accommodated the new ODI mappings.
• Hands on experience in installation, administration and maintenance of OBIEE,OBI Applications,DACandInformatica.
• Developed data extracts from the data warehouse environment using ODI. Modify existing ETL jobs in Oracle Data Integrator (ODI).
• Worked extensively on OBIEE Skin & Branding as per client requirement.
• Created schedules to seed and purge cache for cache management.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Migrated Development RPD to the QA and Production environment and used Catalog Manager to migrated catalog files like Dashboard, Reports and other object from one environment to the other environment.
• Analytics Application Response-time Performance management using optimization efforts such as aggregate navigation, indexes and Oracle materialized views.
• Worked towards the Performance Tuning of Dashboards and Reports with Business Analysts and DBAs.
• Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.
• Implementation of criteria filters to narrow-down the result set from the analytics requests.
• Developed/Bench-Marked performance tuning strategies with business model-level calculations versus Data warehouse level pre-computations and aggregations.

Environment: OBIEE 11g, OBIEE 12C, BI Apps 7.9.6, BI Publisher 10x/11x, Informatica 8x/9x, Hadoop, ODI 11.1.1.9.x, OBIA 7.9.6.4, Oracle EBS R12, Oracle Database 11.2.0.4, SQL Developer, Linux 6.0

Confidential, Weston, MA

OBIEE Developer

Responsibilities:

• Participated in multiple end to end implementations which consists of gathering requirements from multiple user groups, analyzing Business Requirements Documents (BRD’s), preparing high level and low level design documents, Development, Support.
• Participated in GAP analysis, Impact Assessment, and prepared necessary documents for multiple projects.
• Expert in presenting the designs to business and in getting signoff’s with some report mockups (without actual developing the reports).
• Expert in designing and developing Rpd (repository) using OBIEE Admin tool. Developing all the three layers (Physical, Business Model and Mapping, Presentation) with oracle’s best practices.
• Developing Reports/Dashboards using OBIEE front end (OBIEE Presentation Services). Created Reports using different views like table, pivot, narrative, filter, compound etc based on the requirement.
• Implemented Fragmentation content, dimensional hierarchies for drill down and associated the proper level of granularity to the fact table. Created Level based Measures and share measures, Time series functions using dimensional hierarchies and Time dimension.
• Designed Aggregate Tables modeled the repository for improving performance of the reports.
• Added column/data level security at the repository level. The data was restricted with respect to the group user. Managed security privileges for each subject area and dashboards according to requirements Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Configured OBI Agents to deliver Analytics content based on schedule, automated iBot queries to obtain daily Weekly, monthly and yearly reports.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.
• Created Intelligent Dashboards for different groups of users to view across regions, Customer Demography with the facility to drill downs and graphs.
• Developing highly formatted reports using BI Publisher, developing multiple rtf templates, Used Answer Queries as source, Implemented stitching technology in the template to meet client’s requirement.
• Supporting Infrastructure team in merging multiple projects from multiple development teams into one development rpd and deploying it into server. Preparing UAT, Production deployment checklists, testing the environments after each and every deployment.
• Tracking Production Issues, UAT Defects in Quality Center and Fixing, deploying the changes in all the environments with very less time.
• Documenting all the changes and maintaining them, which help future enhancements.
• 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.
• Concurrent execution of load plans is disabled in ODI by verifying the status of previous run.
• Design and developed process for Initial loads and Ongoing loads (Incremental Aggregation with Extract Date concept).

Environment: OBIEE 11.1.1.7.x, ODI 11.1.1.6.x, ODI 12c, BI Apps 7.9.6, Informatica 8x/9x, BI Publisher 10x/11x, Windows Server 2008, OBIA/BI APPS 7.9.6.4, Oracle 11g, PL/SQL.

Confidential, Stamford, CT

OBIEE Consultant

Responsibilities:

• Installing Oracle BI Analytics and configuring the connection parameters with SQL Server, Oracle 10g.
• Created/Modified Metadata repository (RPD) as per the data requirements by using Oracle BI Analytics Server Admin tool.
• Independently Designed and developed subject areas in the RPD(Physical, BMM and Presentation layer)
• Defined appropriate joins, calculations, dimensions and measures in the repository.
• Created Repository Users/ Groups and Web Groups and assigned permissions to the user groups to define security in the repository.
• Involved in Data Modeling, Design Documents, and data warehouse.
• Conducted project planning and work estimations.
• Responsible for supporting and enhancements for the existing projects in OBIEE.
• Updated the RPD layers and OBIEE reports upon modifications.
• Hands on experience in data warehousing technologies including ETL, Oracle BI Server architecture, and metadata management.
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer (design of hierarchies, dimensions, and aggregates).
• Created Snow flakes and Star Schema to perform data modeling for proposed architecture.
• Created and customized various Reports and Dashboards for various user groups.
• Designed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative and Nested reports in Answers.
• Created reports with different views (Compound, Chart, Table, Pivot, Ticker and Narrative).
• Created materialized views to fasten slower queries with complex joins in them.
• Identified Data Sources (Oracle BI& Enterprise DW) & Extension columns - Identified Oracle BI OLTP tables, fields, Map them with Staging Tables and finally map them to OLAP’s Physical layer tables/schemas.
• Developed and scheduled iBots for delivering personalized reports to users on time.
• Secured Dashboards and Reports by defining user roles.
• Participated in the implementation of anyOBIEEproduct upgrades. Performance tuning ETL mappings and Reports
• The other module includes development of BI Publisher reports which comprises of Analysis of Actuate reports, gathering the requirements from Actuate, preparing functional and technical document, development of BI Publisher reports.
• Design, Develop, unit testing and SIT support for the assigned BI Publisher reports.
• Documentation for technical approach, product build and Migration Strategy.
• Configuring the BI Publisher reports with the Siebel UI.
• Involved in improving the performance and optimization of the existing algorithms in Hadoop using Spark Context, Spark-SQL, and Data Frames.
• Used Apache Impala to read, write and query thedata in HDFS/ HBase/ Cassandra.
• Implemented OBIEE security at the data and object levels.
• Manage/modify database security and database schema.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Created/designed functional and technical documentation for Reports, RPD and Informatica mappings.
• Applied Optimization techniques and tuned performance of the reports such as caching and building summary tables.
• Supported business operations viaOBIEEincluding: investigating defects or issues.
• Identified the gaps between user requirements and existing applications - Primarily the Finance App.
• Done data migrations using Import/Export, FTP, Database Links and SQL*Loader.
• Trained End Users to Build Ad Hoc Reports using OBIEE.

Environment: OBIEE 10.1.3.4, OBIEE 11g, Informatica 8x/9x, BI Publisher 10x, Hadoop, PL/SQL, TOAD and Windows.

Confidential, Houston, TX

OBIEE Developer

Responsibilities:

• Gathered information by interacting with clients and end users.
• Involved in full Life Cycle Implementation of OBIEE.
• Involved in requirement analysis, designing of Data Warehouse, populating Warehouse using Informatica ETL, Design and implementation of custom business intelligence solutions (Metadata and Dashboards/Reports) using the Oracle Business Intelligence (OBI) Analytics platform.
• Performed the detailed design implementation and testing of Reports/Dashboards and Analytical Data Model (Metadata/RPD).
• Designed and built Star schemas/snowflake schemas upon requirements.
• Configured repository (RPD) to use the LDAP authentication.
• Define the mapping from various physical databases to Business Layer to create the various subject areas in Presentation Layer.
• Defined dimensions and facts in the subject areas.
• Implemented OBIEE security for users and groups in administrator tool.
• Created reports by applying views, filters, calculations and conditional formatting in answers.
• Designed Intelligent Dashboards for different user groups to view updated KPIs.
• Created and scheduled iBots as per the business requirements.
• Participated in the Modeling of several multidimensional Data Marts including surrogate key design and index placement.
• Created the source and target instances and various transformations (Joiner, Aggregate, Lookup, Filters and Router Transformations) in Informatica and also created mappings, sessions and workflow to run ETL process using Informatica Power Center.
• Used DAC (Data Warehouse Administration Console) Client to manage, configure, customize and monitor ETL process.
• Applied Optimization techniques and tuned performance of the reports.
• Provided technical and user documentation and training. Created Dashboards on Pharma Sales Analytics.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Worked in the development of OLAP Databases and Structures used in the Health Care sector.
• Development of Siebel BI publisher technical design documents
• Development/Testing and UAT support for the Siebel BI Publisher Reports.
• 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.
• Migrated the tested code of Repository, Dashboard reports, and Workflows from Development to QA and from QA to Production Environments.

Environment: OBIEE 10.x, OBIEE 11g, Power Center 7.1.3, BI Publisher 10g, Informatica 8.1, Oracle 10g, TOAD, Teradata and Windows 7.

Confidential

OBIEE Consultant

Responsibilities:

• Gathered Business Requirements by interacting with IT and documented them unambiguously as System Requirements Specifications (SRS) combination of (FR/NFR).
• Created High level Design Documents (HLD) according to the Business System Requirements (FR/NFR)
• 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 Worked on DAC, Pharmacy 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.