SUMMARY:

• Have 14 + years of IT experience in delivering Business Intelligence solutions by gathering requirements, analyzing, developing, testing, deploying Business Intelligence (BI) applications using OBIEE/Siebel Analytics and OBIEE Apps.
• Extensive experience in OBIEE 12c/11g/ 10.1.3.3/10.1.3.4. x, Oracle BI applications 11.1/7.9.5/7.9.6 and Siebel Analytics 7.7.1/7.8.5 which includes creating, customizing and managing repository and Presentation services (Answers, Dashboards & Delivers), OBI/Siebel iBots (BI Scheduler), OBIEE Maps, BI publisher, BI(RPD and Web - catalog) administration.
• 3+ year experience on OBIEE Apps11.1.x/ 7.9.6 (OBIA) like OBIEE Financial Analytics, Supply chain Analytics, Sales Analytics and OBIEE HR Analytics.
• Expertise in handling all phases of Quality Assurance Life Cycle(QALC) and Software Development Life Cycle(SDLC) of the BI Projects.
• Having very good knowledge in Banking Domain, Financial Domain and Supply chain Domain
• Strong understanding of Data Warehouse concepts, ETL, OLAP, ROLP, Star Schema, Snow Flake Schema Dimensional Data Modeling, FACT & Dimensions tables, Aggregate persistence wizard.
• Strong working knowledge in Metadata modeling in all three layers (physical, BMM, presentation). Worked Extensively on OBIEE Administration Tool, OBIEE Presentation Services, Answers, Interactive Dashboards and BI Publisher.
• Experience in creating Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures, and parameters.
• Expertise in Security Administration (authentication, object & row level security, role-based)
• Experience in using Presentation, Repository and Session variables and Initialization blocks
• Good experience on other reporting tools like Business Objects (BO), Cognos, Tableau, Power BI.
• Converted Webi BO (Business Objects) reports into OBIEE Answers requests (Reports).
• Experience on OBIEE Administration, Production support, Up gradation and Migration
• Integrated Maps with OBIEE by using Map Viewer.
• Strong knowledge of RDBMS databases like Oracle, MS SQL server, IBM DB2
• Experience in developing customized Oracle SQL queries and PL/SQL Programs.
• Strong Knowledge in Data Stage, ODI, Informatica Power center designer, Power center workflow manager.

TECHNICAL SKILLS:

Packages: Oracle EBS: R12/11.5.10, PeopleSoft, Hyperion Essbase 11.1.1.1.0

Technical Skills: OAS 5.9, OBIEE12c/11g/10g, Oracle Data Integrator (ODI) 12c/11g, OBIA 11.1.1.10/ 11.1.1.9/ 7.9. x, DAC 11.x, Scheduler DAC 7.x, BI Publisher, RPD,, WebLogic 11g, Tableau 10.1/9.3/9.2, BI Publisher, DAC 7.x, Siebel Analytics

Relational Databases: Oracle 9i/10g/11g/12c, SQL Server 2000/2005, OLAP, Teradata, IBM DB2Operating Systems: Windows Server 19/12 & UNIX (Linux)

ETL Tools: Data Stage 11.x,Informatica Power Center 9.1/8.1/7.1, ODI, DAC 7.x

Database Tools: TOAD, SQL*plus, ODBC, SQL*Loader, SQL Developer, SmartView.

PROFESSIONAL EXPERIENCE:

Confidential: Houston, TX

Senior OBIEE/OBIA Developer/Administrator

Responsibilities:

• Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE.
• Acted as aliaison between business users and BI teamto facilitate understanding of business requirements.
• Analyzed the data and developedLogical Star Schemamodel with consultation from Data Modelers and Business Analysts.
• Used the OBIEE 12c/11g Administration tool to develop and enhance Meta data.
• Installed and Configured OBIEE 12c/11g on windows server from start to end.
• Worked extensively on OBIEE 12c/11g Answers, Dashboards and Delivers to create reports.
• Worked on Oracle 12c/11g, PeopleSoft EPM databases.
• Provided guidance and support to end users during the implementation and in production.
• Working on BI Campus Solutions, Financial and HR Modules.
• Created mockup reports and dashboards for review by the business users.
• Migrated repositories and catalogs from Dev environment to QA and Production environments.
• Created new Action Links in OBIEE 12c/11g.
• Expert in developing and analyzing of data warehouse applications using Data Stage, ODI 12c.
• Good Understanding on ODI Navigators like Designer, Topology, Operator and Security Navigator.
• 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).
• Involved in Develop data extracts from the data warehouse environment using ODI.
• Created Reports and Dashboards based on different Subject areas.
• Worked on other reporting tools like Tableau and Power BI.
• Migrated some Finance reports from OBIEE to Tableau for better visualizations.
• Built, published customized interactive reports and dashboards, report scheduling using Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Created Security model in OBIEE based on PeopleSoft EPM model.
• Created reports by using set operations like Union, Union ALL.
• Createdsecurity settingsin OBIEE Administration Tool, set up groups, access privileges and query privileges, and managed security for groups in Answers.
• Created new Users, Groups and Application Roles in BI.
• Integrated Hyperion Essbase with OBIEE.
• Installed and Configured Oracle Analytics Server (OAS 6.4).
• Created new reports and Dashboards in OAS/OAC.
• Worked on WebLogic EM and WebLogic Console.
• Involved in up gradations and Migrations in OBIEE.
• Involved in Data modeling to design Star Schemas and Snowflake schemas.
• Created Bridge tables, helper tables to handle many to many relationships in OBIEE.
• ConfiguredBI SchedulerandOracle BI Delivers- iBotsto deliver alerts and publish updated content to subscribed users as per the schedules and requirements.
• Created new Repository Variables, Session Variables, and Presentation Variables.
• Created new subject areas in BI Repository based on Excel Data and Share point data.
• Involved in preparation of documents to give end User .
• Developed test cases and performedUnit Testing and Integration Testingof the Repository and Web Catalogs.
• Working knowledge on DevOps, GitHub, TeamCity, and Octopus.
• Proficient in Agile methodology and Process Compliance.
• Used SQL tools TOAD and SQL Developer to run SQL queries and validate the data in warehouse.
• Worked on MUD environment.
• Involved in creation of Aggregate tables in ETL to increase the performance of OBIEE.
• Configured EPT (Event Pooling Tables) to purge the Cache.
• Configured LDAP for user authentication in BI system.
• Configured SSL.
• Involved in applying patches for Web logic and OBIEE.
• Worked on ETL Data Stage tool.

Environment: OAS/OAC 6.4, OBIEE 12.2.1.4,12.2.1.3,11.1.9, 11.1.6, OBIA 11.1.1.10,7.9.6.3, Tableau, Power BI, Oracle 11g/12c/19c, DevOps, GitHub, Octopus, PeopleSoft EPM, ETL Data Stage, ODI, Agile, Web logic, Service Now, DAC, Windows Server, UNIX/Linux, TOAD.

Confidential: Houston, TX

OBIA Developer/Lead/Administrator

Responsibilities:

• Used the OBIEE 11.1.6 Administration tool to develop and enhance Meta data.
• Worked extensively on OBIEE 11g Answers, Dashboards and Delivers to create reports.
• Integrated Maps with OBIEE by using Map Viewer/Builder.
• Created New Styles, Themes in Map viewer.
• Worked on OBIA Analytics 7.9.6.3 like Financial Analytics, HR Analytics and Supply Chain Analytics.
• Worked on Procure to Pay and Order to Cash life cycle in Supply Chain Analytics.
• Worked on entire Oracle BI Stack.
• Created new Dashboards based on OBIA (Out of Box) requirements.
• Created new logical columns, metrics, and level based measures in Financial Analytics.
• Created new Dashboards in Financial Analytics based on user requirements.
• Worked on Financials - AR Transactions, Financials - AP Balances subject areas in Financial Analytics, and Procurement and Spend-Purchase Orders, Procurement and Spend-Requisitions subject areas in Supply Chain Analytics.
• Worked on Oracle 11g, PeopleSoft Financials, and Oracle EBS R12 Data bases.
• UsedInformaticaPower Center for extraction, transformation and load (ETL) of data in the data warehouse by closely working with the ETL Team and extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup and Update strategy.
• Used DAC tool to schedule ETL jobs.
• Created Tasks, task Groups and Subject areas in DAC.
• Worked with On Shore/Off Shore model.
• Worked on MUD environment.
• Handled Skipped level and Ragged level hierarchies in OBIEE 11.1.6
• Worked on UNIX/Linux to maintain servers.
• Created Database Hints and Materialized Views to increase the performance of reports.

Environment: OBIEE 11.1.6, OBIA 7.9.6.3, Oracle 11g, PeopleSoft, Map Builder 11, Oracle EBSR12, ETL Informatica, ODI, Weblogic, PL/SQL, Agile, DAC, UNIX/Linux, TOAD.

Confidential: Denver, CO

Senior OBIEE/OBIA Developer

Responsibilities:

• Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE.
• Performed gap analysis and feasibility study for the given requirement.
• Integrated Maps with OBIEE By using Map Viewer and Designed State level OBIEE Maps.
• Designed Map layouts and backend Maps by using Map builder 11.
• Used the OBIEE 11.1.6/11.1.5 Administration tool to develop and enhance Meta data.
• Worked extensively on OBIEE 11g Answers, Dashboards and Delivers to create reports.
• Generated Reports and Dashboards by using Report features like Pivot tables, Graphs, charts and view selector.
• Migrated repositories and catalogs from Dev environment to QA and Production environments.
• Upgraded 10g Repositories into 11g.
• Scheduling OBIEE Dashboard daily/weekly results by using OBIEE iBots.
• Configured BI Scheduler in OBIEE for Cache Seeding to get the results very quickly.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using ODI tool.
• Involved in creation of Aggregate tables in ODI to increase the performance of OBIEE.
• Involved in creation of PL/SQL programs to load data into tables.
• Created new Initialization Blocks, Dynamic Variables and Session Variables.
• Worked on UNIX/Linux to maintain servers.

Environment: OBIEE 11.1.6, OBIA 7.9.6.3, Map Builder 11, PeopleSoft, Oracle 11g, SQL, PL/SQL, ETL ODI, Weblogic, OLAP, DAC, UNIX/Linux, TOAD.

Confidential: Chicago, IL

Senior OBIEE 11g/OBIA Developer

Responsibilities:

• Used the OBIEE 11g/10.1.3.4 Administration tool to develop and enhance Meta data.
• Worked extensively on OBIEE Answers, Dashboards and Delivers to create reports.
• Worked extensively on OBIEE 11g Answers.
• Worked on OBIA Analytics 7.9.6.3 like Financial Analytics and Supply chain Analytics.
• Worked on Procure to Pay full life cycle in Supply Chain Analytics.
• Used Oracle EBS as a source system.
• Created new Action Links in OBIEE 11g.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters)

Environment: OBIEE 11g/10.1.3.4, OBIA 7.9.6, Oracle 10g/11g, ETL Informatica 9.1, Oracle EBS, UNIX/Linux, DAC 7.7, BI Publisher, TOAD.

Confidential: Chicago, IL

Senior OBIEE 11g/OBIA Developer

Responsibilities:

• Used the OBIEE 11g/10.1.3.4 Administration tool to develop and enhance Meta data.
• Worked extensively on OBIEE Answers, Dashboards and Delivers to create reports.
• Worked extensively on OBIEE 11g Answers.
• Upgraded OBIEE 10g repositories into OBIEE 11g.
• Migrated Business Objects (BO) reports into OBIEE.
• Involved in Unit Testing, System Integration Testing and User Accepantance Testing (UAT).
• Debugged OBIEE reports and OBIA reports by using HP Quality Center.
• Worked on DAC tool to Schedule the ETL jobs.
• Worked on Informatica Transformations like Aggregator, Union, Filter, Routers, and Normalizer.
• Customized SDE and SIL mapping in Informatica for OBIA project
• Implemented user security authentication using LDAP server directory
• Created BI Publisher reports by using BI answers.
• Created template based reports by using BI Publisher.
• Used Oracle EBS as a source system.
• Worked data modeling schemas like Star Schema and Snow Flake Schema.
• Involved in SQL Tuning by using Explain Plan
• Worked on UNIX/Linux to maintain servers.

Environment: OBIEE 11g/10.1.3.4, OBIA 7.9.6.3, Business Objects, Oracle 10g/11g, ETL Informatica 9.1, Oracle EBS, OLAP,Teradata, HP Quality Center 10, UNIX/Linux, DAC 7.7, BI Publisher, TOAD.

Confidential: Cleveland, OH

OBIEE Developer

Responsibilities:

• Gathered the requirement, completed the proof of concept, Designed, Developed and Tested Physical Layer, Business Layer and Presentation Layer of OBIEE
• Analyzed and validated the business model in Siebel Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Used the OBIEE 10.1.3.4 Administration tool to develop and enhance meta-data.
• Involved in setting up new MUD in this project.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Worked on Business Objects (BO) reporting tool to convert Webi BO reports into OBIEE Answers requests and Dashboards.
• Worked on OBI Apps Financial Analytics Dashboards pages like Balance sheet, Cash Flow, Liquidity, GL Balance, P&L, Revenue and Asset Usage.
• Scheduled ETL Informatica workflows by using DAC tool.
• Created Loan Template reports by using BI Publisher.
• Involved in creating of Repository Variables, Session Variables, and Presentation Variables.
• Extensively used write back, solution for insert and update in database .
• Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug SQL query issued during report execution.

Environment: OBIEE 10.1.3.4, OBIA 7.9.6, Oracle EBS R12, OLAP, Oracle 10g, ETL Informatica, Control-M, HP Quality Center, DB2, DAC 7.7, BI Publisher, MDM, TOAD.

Confidential: Palo Alto, CA

OBIEE Developer/Administrator

Responsibilities:

• Used the OBIEE 10.1.3.3 Administration tool to develop and enhance meta-data.
• Installation and configuration of all components of OBIEE, including the physical, logical, BMM and presentation layers.
• Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures, and Security using External Table Authentication, Session Variables, and Initialization Blocks.
• Worked on Supply Chain Analytics Dashboards like Procurement and Spend Dashboard, Supplier Performance dashboard and Inventory dashboard.
• Involved in performance tuning for BI server and Oracle SQL queries.
• Highly involved in customizing BMM layer to achieve best performance and access for users.
• Used Filters and provided customized dashboard prompts appropriately to avoid excessive data showing up Reports and Maintained effectiveness in creating the dashboards.
• Involved in Production support and Migration, Upgrading of OBIEE reports from older version to OBIEE newer version.
• Managed security privileges for each subject area and dashboards according to user requirements and Setup the role based visibility of Dashboards to users and business analysts.
• Used DAC for scheduling ETL jobs.
• Also participated in analyzing ETL mappings using Informatica power center 8.1

Environment: OBIEE 10.1.3.3, Oracle EBS 11.x, Oracle 10g, HP Quality Center, DB2, UNIX, XML, OLAP, ETL, BI Publisher, DAC 7.5, OLAP, Teradata, SQL, TOAD, SQL * Loader.

Confidential

 Oracle Apps consultant

Responsibilities:

• Involved in requirements gathering and worked on Functional and Technical Detail Design based on the Business Requirements.
• Implanted EBSsecurity authentication, authorizationandOutOfthe Box (OTB)Financial Analytics to help them provide visibility to detail level General Ledger transactions, Debit and Credit Payments, facilitatetransaction analysis across locations, products, territories and business units.
• Identified the granularity level of the data required to be available for analysis.
• Converted flat files from Excel to Data files and developed the SQL*Loader program to load the data to staging tables for Order Import program to import orders. Wrote packages to validate and populate the interface table.
• Developed on BPEL process with services for reading the source data from legacy data base using DB Adapter in SOA.
• Created parallel queries for the optimization of the SQL queries.
• Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.

Environment: Oracle 9i, Business Objects XI R2, Putty, SQL Server 2003, SQL, PL/SQL, Java, SQL*Plus, TOAD, Sybase, MDX, HTML, XML