SUMMARY:

• Over 8+ Years of professional IT experience in all aspects of Data Warehousing System Development Lifecycles (SDLC) including, requirement gathering, data modeling, development, Testing, deployment, maintenance, and enhancements using Reporting & ETL tools - OBIEE, Oracle BI Apps, Informatica, Tableau 10.0 , ODI, DAC.
• Business Intelligence experience using OBIEE 12c and Siebel Analytics 8.1.1, Informatica 7, 8, 9.x, ODI 11g/12c, Endeca Information Discovery and Clover ETL process, MicroStrategy 9.4, Business Objects XiR2/R3/R4 and QlikView V 11, Qlik Sense, Cognos.
• Implemented an easy way for the Business and end users for directly modifying and updating mouse over definitions within their control from logging into Database instead of making the changes in RPD ( OBIEE Repository)
• Experience in Design, Development, Analysis, Implementation, Administration, Maintenance and Support of Siebel Analytics/OBIEE 12c, ODI 11g, 12c, Informatica 9.1 & DAC
• Proficient in Oracle Tools and Utilities such as SQL Developer, SQL*Loader, SQL*Plus, Data Loader, and TOAD.
• Expertise in BigData platforms Hadoop, Hive, HBase, Google BigQuery. Architected solutions that process massive amounts of data on corporate and AWS/cloud based servers.
• Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local filters, Guided Navigation, Alerts, Security Setup (groups, access privileges) on Metadata Objects and Web Catalog Objects like Dashboard, Pages, Folders, Reports, Prompts
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Gauge, Column Selector, Tabular, KPIs, with global and local Filters) using OBIEE Web.
• Expertise in debugging and optimizing the OBIEE Dashboards / Reports
• Highly experienced in working with OBI Answers, OBI Dashboards, BI Publisher and OBI Delivers.
• Worked with Global Business Executives of the BI Project and Business users to analyze and determine enhancements and defects while providing knowledge of OBIEE/BI Publisher capabilities to help improve business processes and reporting output.
• Actively involved setting up OBIEE and BI Publisher across multiple server locations
• Integrated the BI Publisher with Oracle EBS, BI Answers, Reports, and Dashboards, to generate standardized reports.
• Experience in OOTB Reports & Dashboards which includes Oracle BI Applications and has worked with Finance Analytics, and Sales Analytics/Procurement & Spend analytics.
• Involved in User Acceptance Testing (UAT) and responsible for bug fixing exercises.
• Involved in ETL development using Informatica Power Center
• Developed Informatica Mappings/Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources and Creating Workflows & Tasks, and Scheduling using Workflow Manager.
• Involved in ODI development using ODI components like Designer, Operator, Topology, and Security
• Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources into dimensions and facts.
• Used Topology Manager to define data servers and physical schemas for various sources and target databases.
• Experience on dealing with ODI Knowledge Modules like, LKM, IKM and JKM, CKM
• Extensive Experience in developing BI Publisher Reports in 10G/11G
• Strong experience in OBIEE admin activities as well with managing Migration activities with respect to Dev to QA and QA to Performance environment & Performance to Production environments.
• Experienced in developing Unit test strategies, Technical requirements, performing end to end testing, creating Test Plans including Data Validation, Unit Testing and User Acceptance.
• Expertise in Business Model development with Dimensional Hierarchies, Measures, Aggregation Rules, Time Series, Caching & Mapping.
• Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP authentication setup and configuration of Multiuser Development Environment
• Experienced in BI Publisher, MS Office Plug-in for rich reporting and Expertise in Cache, Usage tracking, Aggregate navigation, Variables/Initialization Blocks configuration etc.)
• Involved in Installation and configuration of OBIEE 12c and developed POC using OBIEE 12c.
• Expertise in implementing Security Models for Dashboards, Row level, objects Level, Role Level, and Dashboard Level.
• Experience in integrating OBIEE with EBS.
• Excellent skills in handling Offshore/Onsite team, Good communication, strong leadership and Inter personal skills.

TECHNICAL SKILLS:

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

Application Tools: OBIEE 12C,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 Jersey

Sr. OBIEE / ODI Developer

Responsibilities:

• 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.
• 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.
• 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
• 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 .
• Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer
• Designed & Implemented Map viewer integration with OBIEE 12c.
• 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.
• 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).
• 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.
• 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.
• Configured Interactive Dashboard with drill-down capabilities using Filters, Metadata Objects and Web Catalog Objects.
• Modified out of the Box (OOB) dimension hierarchies.
• Involved in customizing OBIEE (Analytics) repository and Reports testing and data validations and Offshore team coordination
• Created a 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.
• 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.
• Configured Row Level Security, Column Level Security and Object level security to allow users to view their respective data only according to the requirement.
• Integrated BI Publisher with OBIEE. Created Templates such as Employee Account Attendance Detail, Reports such as Turn Over/Period/Department, Prompts such as Customer Name in BI Publisher
• Schedule reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards.
• Created Various BI Publisher Reports on top of BI Answers and aligned them on various Dashboards as per 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,BI Publisher

Confidential, New jersey

Sr. OBIEE/ODI 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.
• Creating New Schedule's and checking the task's daily on the server.
• 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.
• 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 12c.
• 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.
• Working on Amazon Redshift and AWS and architecting a solution to load data, create data models and run BI on it.
• Integrated BI Publisher with OBIEE. Created Templates such as Employee Account Attendance Detail, Reports such as Turn Over/Period/Department, Prompts such as Customer Name in BI Publisher
• Schedule reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards.
• Created Various BI Publisher Reports on top of BI Answers and aligned them on various Dashboards as per the requirement.
• Defined and deployed monitoring, metrics, and logging systems on AWS.
• Implemented AWS Cloud RDS for centralized reporting system for multi-location business owners.
• 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, SQL Developer, AWS Redshift, PL/SQL, ODI 11g, Oracle 11g/12c, Bugzilla, Win XP Professional, UNIX - Solaris, COBOL, Tableau 10.1/9.3,BI Publisher .

Confidential, MA

OBIEE Admin/ ETL Developer

Responsibilities:

• Worked on the Technical and Functional Design Business Requirements gathering, and documented the Technical Design Documents, Functional Design Documents and Data Lineage Documents as per the business rules.
• Created Dashboards with the Reporting Standards and Requirements as per the Business requirement rules and documents.
• Worked on different projects for developing and enhancing existing reports for FIMT to replace AS400 green screens and incident management reporting.
• Created various time series formulas for Incident Management reporting to represent time base trends.
• Created and Configured Physical layer, Business Model Layer and Presentation Layer of the repository with business logics, Hierarchy and Security privileges for both fact-dimension and fact less fact schemas on RPD
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, Variables and other various features to meet the business requirements.
• Created Opaque views on RPD to meet certain reporting requirements.
• Extensive experience in creating the conditional logical columns and customizing the logical table sources.
• Created lookup columns in RPD to display CLOBS on BI Answers.
• Customized default skins and styles for the organization according to the business needs.
• Created Repository, Session variables and initialization blocks for various reporting needs.
• Configured Action links to and Go URL's to drilldown to same and different dashboards.
• Created Presentation variables on front end to meet certain business requirement such as case insensitive filters on dashboard prompts.
• Created role based dashboards, pages, reports with various views and prompts associated with Security for User Authentication.
• Used Filters and provided customized dashboard prompts appropriately to avoid excessive data showing up Reports and Maintained effectiveness in creating the dashboards.
• 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.
• Involved in merging two different OBIEE Instances by comparing configuration files, merging RPD and merging catalog for both shared and user folders.
• Involved in Cache management by purging programmatically and Server Cache management.
• Involved in Production support and Deployment, Upgrading of OBIEE reports from older version to OBIEE newer version.
• Configured the hive tables to load the profitability system in Talend ETL Repository and create the Hadoop connection for HDFS cluster in Talend ETL repository.
• Validated Hadoop data against source files using Hive SQL queries.
• Queried Hadoop table structure and list of partitions using hive SQL queries.
• Used Teradata fast Load and Multi Load for copying Hadoop data into Teradata temporary tables.
• Validated dimensions and facts in Teradata using Hadoop base data.
• Conducted Usage Tracking Auditing to remove unused catalog from the Instance.
• Conducted Performance Testing on dashboards for 1000 users using Load runner based on number of hits on the dashboard.
• Involved in Creation of 3-way merging and 2-way merging of RPD and working in MUD environment.
• Performed data analysis on multiple sources coming from Data marts.
• Created Testing scripts for Testing Team and giving directions to test the reports with necessary SQL queries and analyzing the data.

Environment: OBIEE 11.1.1.7.1 3, 11.1.1.7.1, BI Publisher 11.X, Informatica 9.0.1, Oracle 11g/12c, Toad 11.5.1.2, SQL Developer 4.1.3.20, PL/SQL Developer 10.0.2, UNIX, Putty, Hadoop, Windows 7

Confidential, New Jersey

OBIEE Developer / Siebel BI Analytics

Responsibilities:

• Worked on configuration of different component of OBIEE like OBIEE rpd, OBIEE reports and Dashboards configurations and catalog with the entire OOTB component.
• Preparation of MD 50 & MD 70 documents for Finance, AP, AR, GL, OM & Inventory modules for OBIEE Requirements.
• Involved in customizing OBIEE (Analytics) repository and Reports testing and data validations and Offshore team coordination
• Involved in implementation of Pre built OBI analytics (Financial Analytics and Procurement and Spend Analytics)
• Configured and used DAC to schedule and run the Full and Incremental ETL loads and to schedule the Informatica jobs in Oracle Business Analytic Warehouse.
• Used Analytics Web Catalog to set up groups, access privileges and query privileges.
• Used various transformations like Source qualifier, gators, Dynamic Lookup, Router, Sequence generator for mappings based upon the requirement.
• Worked closely with the development team in developing the efficient solutions for Business Users.
• Configured Informatica connections source DB connection and target DB connection in DAC.
• Modified out Of the Box (OOB) dimension hierarchies.
• Developed Business dashboards for AP, AR, GL, OM & Inventory modules.
• Developed security for Dashboards/reports based on groups and users
• Designed the build/migration documents for Repository and Web catalog.
• Applied content filter in BMM layer to filter data at repository level.
• Installation and configuration of Out of the box solution of OBI Application (Order Management Analytics, SCM Analytics, Financial Analytics, HR Analytics) on version 10.1.3.4.
• Changed Out of the box dashboards and provided detail level drill downs to as per business requirements using Oracle Answers.
• Used BI Office plug-in to view reports in Excel and Power Point..
• Used presentation variable in OBIEE Oracle answers to save prompt values and use them for conditional formatting.
• Worked on Windows platform (pre development environment) and UNIX platform (development/ test environment) to do the administrator tasks.
• Provided user trainings on application and whenever is needed.
• Performed and used OBIEE data level securities - (RW) Row-Wise initialized Non system Session variables and a Logical Table Source (LTS) filter feature.
• Created logical tables and assigned levels and custom aggregation rules
• Created group accesses and privileges for the OBIEE reports.
• Created dimension hierarchies and level based measures to drill down to the most detailed level of data as per the business requirements.

Environment: Siebel Analytics 7.7, OBIEE 10.1.3.4, BI Apps 7.9.6.3, Oracle 9i & 10g, Informatica 8.6, DAC 10.1.3.4, Quality Center 10.0, Win XP Professional, UNIX - Solaris

Confidential

OBIEE Developer /Admin

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 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.