PROFESSIONAL SUMMARY:

• 7+ years of experience in designing and developing end - to-end BI solutions according to standard OLAP methodologies using Oracle Business Intelligence (OBIEE)/ Oracle Data Integrator (ODI).
• 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 of Stored 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.
• Experienced in OBIEE 11.1.1.7,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 11g & OBIEE10g) and have a strong understanding on OBIEE 11g capabilities with Web logic 10.3.5 as an Application server. Knowledge on Tableau 8.1
• 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 customizing reports, filters and charts in Oracle BI Answers, Interactive Dashboards, BI Publisher (Excel) and Delivers. Expert knowledge of report development execution in a complex environment.
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, 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.
• 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.
• 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 configuring Usage Tracking and Multiuser Development Environment (MUDE).
• Experienced in creating Dimensional hierarchies and designing customized interactive dashboards in 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.
• Expert ability to trouble shoots and prioritizes issues.
• Excellent interpersonal and communication skills for efficient client interaction.

TECHNICAL SKILLS:

Oracle Applications: General Ledger, Accounts Receivables, Accounts Payables, Order Management, Inventory, Purchase Order.

Application Tools: OBIEE 11g/10g, Discoverer /9i/10g/11g, BI Publisher, Forms 6i/9i/10g/11g, Reports 6i/9i/10g/11g, Siebel Analytics 7.x, Oracle BI Apps

ETL Tools: Informatica 9.x/8.x/7.x/6.x, SQL Server Integration Services, ODI 11g

Databases: Oracle RDBMS, Oracle 8i /9i/10g/11g, MS SQL Server 2000/2003

Languages: SQL, PL/SQL, C, C++, Java, JDBC, JSP, XML, PERL, COBOL

Operating System: UNIX, Linux (Red hat enterprise),Solaris and WINDOWS 98/2000/NT/XP

Other Tools: Toad, cognos, SQL Navigator, SQL*Plus, SQL*Loader

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. OBIEE / ODI Developer

Responsibilities:

• Installed, Configured and Developed OBIEE 12.2.1.1.x, Tableau 9 on Windows Server 2012 R2 & Redhat 7.x
• Actively Involved in BI Apps and Informatica customization
• Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer
• Created ODI packages, scenarios using interfaces, variables, procedure
• Used ODI commands like OdiFileMove, OdiFileAppend, odiFilecopy etc.
• Worked extensively with ODI Designer, operator and metadata Navigator.
• Designed & Implemented Map viewer integration with OBIEE 12c.
• Designed architectural frameworks for OBIEE 12C applications to meet business needs
• Implemented Object level security for customized application roles with in the RPD and Web catalog level.
• Implemented the Data level security using session variables based on user responsibilities for their corresponding associated Ledger, Division, Access set and Operating unit by creating a customized table in Data base.
• Performed Data validations by testing several cases against the Source E-Business suite R12 and OBIEE.
• Involved and did several customizations for creating the additional reports and Dash boards for General Ledger analysis, Fixed assets analysis, Intercompany reporting analysis and Account receivables analysis.
• Generated Tableau dashboards, writing complex SQL queries on Hive/Impala and worked on transforming project reports from other tools to Tableau.
• 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).
• Converting all 11 g reports to the 12c configuration in all the environments like Development and STAG.
• Involved in transformation project of reports from OBIEE to Tableau, performed full repository and web catalog merge.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Imported Supply chain data into Tableau to perform data manipulations, data analytics by creating calculated fields, parameters and generated reports.
• Used ODI Operator for debugging and viewing the execution details of interfaces and packages.
• Created Unit test cases for Analytics reports and Analytics dashboards and executed manually.
• Develop data extracts from the data warehouse environment using ODI.
• Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
• Involved in configuring pre-defined SDE's and SIL's in ODI studio.
• Configured Interactive Dashboard with drill-down capabilities using Filters, Metadata Objects and Web Catalog Objects.
• Involved in customizing OBIEE (Analytics) repository and Reports testing and data validations and Offshore team coordination
• Created an Automatic control data base schema switching table in Data base to ensure that end users does not be affected to run the reports while the ETL loads are running.
• Configured the separate Data base schema connection pool in RPD for Automatic Data base schema switching using the variables and Initialization blocks
• Tested Initialization blocks used in RPD by running the Queries against Database to ensure the correct data being fetched
• Verified the defects by validating the results in the reports as well as with Data base before and after they fixed.
• Created dimension hierarchies and level based measures to drill down to the most detailed level of data as per the business requirements.
• Debugged the issues by capturing the SQL issued for the reports in manage sessions.
• Created new logical measures required as per the business requirements.
• Customized Out of the box Repository (RPD) to work with other ERP systems and Essbase. Pulled new physical tables to physical layer of RPD, joined them with dimensional tables, developed hierarchy and presented them to presentation layer.
• Created Aggregate Level facts to improve the performance in the reporting needs.
• Configured Row Level Security, Column Level Security and Object level security to allow users to view their respective data only according to the requirement.

Environment: OBIEE 12c, ODI 11g, Oracle 11g, SQL Developer, PL/SQL, Informatica 9.0.1, Quality Centre 11.0, Win 7, UNIX - Solaris, COBOL, Tableau 10.1/9.3

Sr. OBIEE/ETL Developer

Responsibilities:

• Worked on the development of the Answers for the different executive dashboards
• Developed Solution Designs and delivered to Development team after reviewing the solutions with Business.
• Actively involved in Administration activities (Repository and Catalog Migration from Dev to QA and QA to Prod environments, Security Setup and Installation setup)
• Developed OBIEE Data Marts (Ad hoc Reporting) for different clients based on the different business logics.
• Involved in OBIEE 10g to OBIEE 11g upgrade for both Repository and Catalog and ensure all the reports and dashboards running on OBIEE 10g is up and running on OBIEE 11g.
• Involved in patch upgrade of OBIEE 11g.
• Implemented security by creating users & groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associated catalog objects and Web modules with the created groups.
• Implemented Financial Analytics, Supply chain, Procurement and Spend Analytics. Integrated data from Finance and other enterprise systems and transformed data using ODI (ETL)
• Integrated data from Finance and other enterprise systems and transformed data using ODI (ETL)
• Managed and customized the ETL ODI loads, RPD and Web catalog metadata according to the reporting needs of the client.
• Designing the collections for AR Transactions, Claims, Disputes, Cash On Account, Credit Memo, Receipts at Risk information using Oracle BI.
• Designing the Month End Closing Mechanism for Accurate Finance Reporting of AR Credit using Oracle BI
• Assisted in setting up in ETL Solution to bring the data from Source system (AS400/SQL Server) to Oracle Data ware house.
• Used Heterogeneous sources in ODI like flat files and Oracle apps tables.
• Customized out of box Dashboard pages like Sourcing Trends, Total Spend Overview, Exceptions, Purchase Requisitions, Purchase Orders and Employee Expenses in Supply Chain Analytics, Procurement and Spend Analytics.
• Customized Dashboard pages like Overview, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
• Involved in complete Procure-to-pay (P2P) and Order-to-Cash (O2C) life cycle.
• Customized Supplier Paid Invoice History Report, Supplier Audit Report, and Supplier Payment History Report in Account Payables (AP) using OBIEE
• Designed and developed mapping Interfaces using Oracle Data Integrator and directly pulling the data from AS400/DB2 and converting into RDBMS format.
• Worked on ODI Designer for designing the interfaces, defining the data stores, interfaces and packages, modify the ODI Knowledge Modules (Reverse Engineering, Journalizing, Loading, Check, Integration, Service) to create interfaces to cleanse, Load and transform the Data from Sources to Target databases, created mappings and configured multiple agents as per specific project requirements.
• Created ODI Packages, Jobs of various complexities and automated process data flow.
• Used ODI Operator for debugging and viewing the execution details of interfaces and packages.
• Configure Ibots for sending alerts to different clients and users based on the access level
• Active interaction with the Business for driving through the project at various phases of the project.
• Installed OBIEE 11.1.1.5.x/ 10.1.3.4.1 across multiple environments supporting various clients.
• Configured Column and Dashboard Filters in OBIEE Requirement validation of the reports and drilldowns.
• Performed and used OBIEE data level securities - (RW) Row-Wise initialized Non system Session variables and a Logical Table Source (LTS) filter feature.

Environment: OBIEE 11.1.1.6.2, OBIEE 10.1.3.4, BI Apps 11.1.1.7, ODI 11g, Oracle 11g, Bugzilla, Win XP Professional, UNIX - Solaris

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 Business Requirement Documents review, HLD, LLD and Data Model Reviews to understand the requirements and to prepare the necessary design documents accurate.
• Participated in GAP analysis, Impact Analysis.
• 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.
• Developed Interactive Dashboards using dashboard prompts, attractive landing pages, with multiple links, Guided navigations, Answer queries, and BI Publisher reports. Formatting Reports/Dashboards with attractive colors, wordings, font as per client’s requirement.
• 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 SIT, UAT, Production deployment checklists, testing the environments after each and every deployment.
• Implementing MUD (Multi User Development) environment across the whole organization which helps in smooth, easy, fast rpd development.
• Tracking Production Issues, SIT Defects, UAT Defects in Quality Center and Fixing, deploying the changes in all the environments them with very less time.
• Participated in Release Management work which consists of raising TFS, Maximo tickets for code deployments in to different environments (SIT, UAT, and Production).
• Documenting all the changes and maintaining them in SharePoint sites which help future enhancements.
• Performing Unit testing, providing test cases for the QA team (TCOE).
• Implemented the advanced concepts of concurrent running of the workflow, session level partitioning techniques and pushdown optimization.
• Performed the Performance tuning to the ETL code at the Database, Mapping, Session and workflow levels.
• Supported the ETL code when it deployed in QA and also at the initial days of the PROD deployment as well.
• Worked towards the knowledge transfer with prod support team for smooth transition.

Environment: s: OBIEE 11.1.1.5.1, OBIA Apps 7.9.6.3 (Marketing Analytics) Informatica 8.6.1, DAC XML, SQL, PL/SQL Oracle, Autosys, DB2, LINUX.

OBIEE/ETL 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 10G Administration tool.
• Built Business model and established relationships & Foreign Keys Physical & Logical between tables.
• Deloped 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, To Date 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.2, Oracle 10g, SQL, Web logic 9x, Informatica, Oracle EBS 9.1, Unix OS.

Jr. OBIEE/ETL Developer

Responsibilities:

• Involved in Creating and Administering the Physical Layer, Business Model and Mapping Layer and Presentation Layer in a Siebel Analytics Repository.
• Configured analytics repository with logical dimensional modeling using Star Schema (Facts and Dimensions).
• Managed day to day rpd, scheduler, and iBots.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Involved in setting up Delivers to configure iBots based on the threshold value to the users.
• Developed UNIX and PL/SQL scripts for pre & post session processes to automate daily loads.
• Created ibots and Delivers to send Alert messages to subscribed users.
• Worked on various Informatica mappings as per business requirement.
• Worked extensively on Unit testing, Integration testing and fixed bugs during the UAT phase.

Environment: Informatica 6.x, Oracle 10g/9i, SQL, PL/SQL, SQL Server 2000/2005.