SUMMARY

• 8+ years of experience in Oracle Business Intelligence Applications (OBIA)/ BIApps with expertise in gathering user requirements, designing, developing and supporting.
• Exceptional Background in administration and implementation of BI Apps including Financials, Procurement and Spend, Supply Chain and Order Management, HR and Project analytics.
• Expertise in utilizing ETL tools including Informatica and RDBM systems like Oracle and Teradata.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehousing Designer, Transformation Developer, Mapplet and Mapping Designer.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
• Expertise in Installation, configuration, and administration of the OBIEE platform.
• Strong experience in developing and customizing OBIEE and BI Publisher Reports.
• Experience in Project methodology, SDLC, DW, BI infrastructure and architecture using OBIEE, OBIA, data loading, schedule and monitor workflows/jobs, dimensional modelling using Star schema in Data warehouse life cycle.
• Installed and Configured DAC (Data Warehouse Administration Console) to manage ETL process for OBIA Analytics.
• Have experience in CDC and daily load strategies of Data warehouse and Data marts.
• Hands on experience in installation, administration and maintenance of OBIEE, OBI Applications, DAC and Informatica.
• Experience in dimensional modeling, designing data marts, star and snowflake schemas.
• Hands-on experience in Performance tuning of Informatica ETL and OBIEE Queries.
• Experience in gathering requirements, Proof of concept, gap analysis, design, development, Testing and Implementation of the OBIEE/ETL/Data Warehouse projects.
• Expertise in developing PL/SQL Stored Procedures, Packages, Functions, Triggers, Indexes and Shell scripting.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• 24/7 Support and effectively to production & development issues and taking responsibility for seeing those issues through resolution.
• Have strong interpersonal skills along with proficient written and verbal skills. Overall strength lies in precise translation of business requirements into technical documents.
• Proven ability to quickly learn and apply new technologies with strong technical background.
• Excellent analytical, problem solving skills and ability to follow through with projects from inception to completion.

TECHNICAL SKILLS

Oracle Applications: Oracle E-Business suite R12/11i OM, INV, GL, AP, AR, PO, FA, AOL.

Application Tools: OBIEE 11g/10g, OBIA/BI APPS 11g/7.9.6.x/7.9.5, DAC, Informatica 9.x/8.x, BI/ XML Publisher, TOAD, SQL*Loader.

Operating Systems: Windows XP/7, UNIX, Linux.

Languages: SQL, PL/SQL, C, C++, Java, HTML, XML.

Scripting Languages: Unix Shell scripts, Perl.

RDBMS: Oracle 9i/10g/11g, Teradata, SQL Server 2003/08.

PROFESSIONAL EXPERIENCE

Confidential, Foster City, California

OBIEE/ Informatica Developer

Responsibilities:

• Interacted with Business Users and Business Analyst to gather the Requirements and Business logics.
• Expertise in OBIEE Admin Work like installation, configuration of OBIEE Security External Database, LDAP, Aggregate Table Configuration of nqsconfig file and also Instanceconfig.xml files.
• Setup and Configure OBIEE Delivers, Creating Materialized Views, Setup Mode Environment Repository Merge, Catalog Merge, Deployment from development to production.
• Implementing Oracle BI Apps in Designing ETL, metadata management using DAC, OBIEE RPD development, OBIEE reports and Dashboards for Financials, Procurement and spend Analytics.
• Developed Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
• Designed and developed complex Informatica mappings including Type-II slowly changing dimensions.
• Extensively worked on heterogeneous data sources like flat files, SQL server, Hyperion, Teradata and Oracle.
• Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger (GL).
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Deployed Informatica workflows to the DAC, created dependency and dependent hierarchical tasks and streamlined the Execution Plans with their respective tasks in DAC.
• Involved in adding all the newly developed Dimension, General, Aggregate and Fact tables in to DAC and creation of new Subject Areas.
• Extracted the pre-built BI solutions of tables by using Oracle BI Apps to configure and created repository (.rpd) and prepared a detail design document.
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View) and drill-down capabilities using global and local Filters.
• Implemented Time Comparison and Calculation measures in the business model using Time series wizard and modeled Slowly Changing Dimension Data.
• Extensively involved in performance tuning of the Informatica Mappings/Sessions by increasing the caching size, overriding the existing SQL.
• Performance tuning in OBIEE repository level and reporting level.
• Designed, implemented and tested security privileges on Dashboards and reports.
• Implemented LDAP authentication and configured application roles for authorization.

Environment: OBIEE11g, OBIA/BI APPS 7.9.6.4, DAC 11g, Informatica Power Center 9.0.1, XML/BI Publisher 11g, TOAD, SQL, Microsoft SQL Server 2012.

Confidential, New Jersey

OBIA/ BIAPPS Developer

Responsibilities:

• Installed, configured and extended Financial, Procurement and Spend, HR analytics.
• Worked on complete Software Development Life Cycle (SDLC), from gathering requirements to deployment.
• Involved in gathering the requirements, performing scope analysis and identifying gaps.
• Created Dimension hierarchies to achieve the drill down functionality.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy and Aggregator.
• Implemented Financial Analytics, integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Created hierarchies, complex and foreign joins, initialization blocks for repository or session variables, presentation variables in analyses calculations, aggregates, partitions, fragmentations and slowly changing dimensions.
• Created security groups in repository, web groups in presentation services and configured privileges for security groups in Administration.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Documented the Requirements and implemented a Design Solution for the BI Architecture.
• Worked extensively on the Oracle BI Admin Tool to create the Physical, Business and Presentation Layers.
• Part of STEP ERP project by implementing Oracle BI Apps using ODI and OBIEE application tools.
• Granting access to users and maintain security by using database authentication and authorization.
• Implemented Type-II Slowly Changing Dimension (SCD) logic in OBIEE environment.
• Performed OBIEE Admin works likenew ID creation, Account modification of existing users, Password reset and Deletion of accounts.
• Developed Unit and System test plans and participated in resolution of bugs in OBIEE suite.
• Provided reports in Financials by gathering business requirements from Business users.
• Customized Supplier Paid Invoice History Report, Supplier Audit Report, and Supplier Payment History Report in Account Payables (AP) using XML/BI Publisher.
• Tuning of PL/SQL queries for better database performance, worked on tools like TKPROF and Explain Plan.
• Automated process of migrating Data Definitions and Templates from instance to instance.
• Resolved open issues with production system.
• Prepared technical documents (MD 70, TE 20) for customized work.
• Implemented object and Data security in OBIEE.

Environment: OBIEE11g, OBIA/BI APPS 7.9.6.4, DAC 11g, Informatica Power Center 9.0.1, XML/BI Publisher 11g, TOAD, SQL, PLSQL, Microsoft SQL server 2008.

Confidential, Denver, Colorado

OBIEE/ Informatica Developer

Responsibilities:

• Installed, Configured and extended Supply Chain, Financial, Order management and project analytics.
• Analyze Design, and Develop OBIEE Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer and Presentation Layer.
• Gathered requirements from the client for GAP analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
• Performed the Setup, Installation and configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the data warehouse.
• Worked on the testing and validating the Repository in OBIEE.
• Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures and Security using External Table Authentication, Session Variables, and Initialization Blocks.
• Developed process and business rules around setup of new users (Logins, Responsibilities).
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Built reports using Analyses including drilldown objects, union based reports, formatting and functions within the reports, dashboards, filters, and prompts.
• Created new requests and opened Analyses for ad hoc reporting to the End users.
• Developed Dashboard like Recycling Report, Shipments & Bookings, Invoices detail, Orders detail, Global Price and Enterprise Order Number in Order Management and Supply Chain.
• Customized Out Of Box Dashboard pages like Sourcing Trends, Total Spend Overview, Exceptions, Purchase Requisitions, Purchase Orders and Employee Expenses in Supply Chain Analytics.
• Trouble shooting the issues related to repository models and report development.
• Verified and tested ETL mappings using Informatica Power Center Designer.
• Developed many complex Full/Incremental Informatica Objects (Workflows / Sessions, Mappings/ Mapplets) with various transformations.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Used the Totals/Subtotals/Group/Sort features of Oracle BI Publisher to make data intense operations happen at the template level.

Environment: Oracle Applications 11i/R12 (General Ledger, Accounts Receivables, Account Payables, Supply Chain (SCM)), BI Apps 7.9.6.2, OBIEE 10.1.3.4.1 , Oracle 11g/10g, Informatica 8.6, DAC 10.1.3.4.1 , Oracle BI Publisher, PL/SQL, SQL, TOAD.

Confidential, Hartford, CT

OBIEE/ Informatica Developer

Responsibilities:

• Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher.
• Designed Star schema for fact & dimensional tables and created alias for the dimension and fact tables when necessary.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports.
• Created Session & Repository Variables to achieve desired functionality.
• Involved in setting up ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• Used SQL * Loader for Data Conversions and to load the data from flat files into Oracle tables.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions.
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Analyses.
• Customized Dashboard pages like AP Balance, Payments Due, Effectiveness, Payment Performance, Supplier Report, Invoice Details and AP Transactions in Payables Dashboard.
• Involved in developing the Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks.
• Developed Mappings and Workflows using various Transformations (Update Strategy, Router, Expression, and Aggregator) for extracting sales data.
• Developed balance sheet, profit and loss statement using BI Publisher.
• Scheduled Workflows and Session tasks comprising of different mappings in order to load data into target database and fine-tuning ETL Mappings and Sessions. .
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.

Environment: Oracle Applications 11i/R12 General Ledger, Accounts Payables, Accounts Receivable, Inventory, Purchasing, Fixed Assets, OBIEE 10.1.3.4.1 , Oracle BI Apps 7.9.6.1, Informatica Power Center 8.6.1, Oracle 10g, DAC 10.1.3.4.1 , Toad, Linux.

Confidential, California

OBIEE Consultant

Responsibilities:

• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Integrated OBIEE with EBS for Single Sign On (SSO).
• Defined Connection Pools to the Source Data warehouse tables in the Physical Layer.
• Designed Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Created Aliases and defined Role-Playing Dimensions.
• Created Repository Groups and Web Groups and assigned users to configure security in OBIEE.
• Verified and tested ETL mappings using Informatica Power Center Designer.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions in the BMM Layer of RPD.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.
• Involved in setting up ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity.
• Customized Dashboard pages like Marketing, Field Sales, Marketing Service etc, which have their own drilldown, and Navigation Reports.
• Customized Dashboard pages like Profit and Loss, Revenue, Products and Customers in Profitability Dashboard.
• Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Customized Employee listing Report, Invoices on Hold report and Suppliers report as per the business requirements using Oracle BI Publisher.

Environment: Oracle Applications 11i/R12 General Ledger, Accounts Payables, Accounts Receivable, Inventory, Purchasing, Fixed Assets, OBIEE 10.1.3.4.1 , Oracle BI Apps 7.9.6.1, Informatica Power Center 8.6.1, Oracle 10g, DAC 10.1.3.4.1 , Toad, Linux.

Confidential

OBIEE Developer

Responsibilities:

• Used Oracle BI for generating Sales reports, which provides web-based reports for executive, management individuals.
• Was responsible for the design, development and management of Daily, Weekly and Monthly reports from the database
• Proficient in defining key metrics, dimensions, hierarchies, attributes and building Star and Snow flake schema.
• Get the database connectivity and design the Physical Layer, Business model and Mapping layer and the presentation layer in the repository (.rpd).
• Creating reports and publishing them in the dashboards using answers.
• Customized and developed repository, configured metadata objects (Subject area table column) and web catalog Objects (Dashboards, Pages, Folders and Reports).
• Add users to the new group and apply the data level security and object level security at the rpd and Web cat.
• Configured Low Level Security to allow users to view data only according to this requirement.
• Worked Extensively on OBIEE Analytics Administration Tool, Web/Presentation Services, Answers, & Interactive Dashboards and Security Implementation.
• Used unconstrained filters, column filter prompts and various views such as Pivot tables.
• Developed many PL/SQL procedure & functions and used the same in mappings.
• Created reports and delivered the same to the end-user through Delivers.
• Created Dimensional Hierarchy fro Date, Facility and Location Dimensions, Level based Measures and Aggregate navigation in BMM layer.
• Merging Catalogs folders to master catalog using Catalog Manager.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Developed many Dimensions and Time Series Objects with Security settings for analyzing.
• Configured charts, pivot table views, filters, and ticker in user interface.
• Developed aggregate fact tables using the content tab.
• Configured Repository and session variables to get dynamic reports and dashboards.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• Worked on Power center Designed client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.

Environment: OBIEE 10.1.3.2/10.1.3.3 Oracle 10g, SQL, Windows 2003 Server, TOAD, PL/SQL.