SUMMARY

• Over 8 years of IT experience working with OBIEE 10.1.3.x/11g, Siebel Analytics 7.x, Oracle BI Applications 7.9.x, which includes building and configuring repository, creating and managing Oracle/Siebel Intelligent Dashboards, Oracle/Siebel Answers, Oracle/Siebel Delivers, Oracle/Siebel iBots, BI Publisher and Extraction Transformation and Loading using Informatica
• Expertise in converting and using Oracle pre - built rpd’s (Financial, HR, Sales, Supply Chain, Order Management, Procurement and Spend, Manufacturing Analytics etc.) according to business requirements.
• Expertise in Business Model development with Facts, Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Experience on Software Development Life Cycle (SDLC) in enterprise, client/server applications with models like Waterfall, Agile Methodology.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling. Extensive experience with Fact and dimensional tables, and slowly changing dimensions.
• 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.
• Expertise in implementing Caching Strategy for the reports and usage tracking of reports
• Hands on experience in Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication and also implemented Single Sign on (SSO).
• Expertise in implementing Security Models for Dashboards, Row level, Object Level, Role Level, Dashboard Level
• Experience in creating Aggregate tables using materialized views and using Aggregate Persistence wizard.
• Expert in converting Functional specs to Technical Specs and implementing OBIEE Best practices.
• Expertise in developing Interactive Dashboards with drill-drown capabilities using global and local filters, Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports) and KPI’s for performance indication.
• Expertise in implementing Oracle BI Apps in all phases like implementing Out of order Box(Vanilla mappings) prebuilt mappings, Designing ETL, metadata management using DAC, Creating Oracle provided data warehouse BAW,OBIEE RPD development, OBIEE reports and dashboards
• Expertise in developing ETL Strategies using Informatica Power Center and Loading of data from multiple data sources and creating workflows with worklets and various tasks and scheduling them using both workflow manager.
• Logical and Physical Data Modeling and Dimensional modeling skills in Physical database design, Relational Models, Star Schemas, and Snowflake Schemas.
• Expertise in Data warehouse Administration console (DAC) to configure, monitor and schedule ETL routines.
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center.
• Designed and developed efficient Error handling methods and implemented throughout the mappings. Hands on experience in tuning mappings, identifying and resolving performance bottlenecks.
• Expert in Unit, System and Integration Testing and Performed Data Validation for all the ETL’s and reports generated from Informatica and OBI/Siebel Analytics.
• Experienced in troubleshooting production issues and production support for projects.
• Experience in customizing mappings to transform data from a transactional database and other sources to staging tables and further to target tables.
• Extensive experience in working with RDBMS like Oracle, Sybase, UDB and SQL Server.
• Experience in creating SQL, PL/SQL, Stored Procedures/Packages/Triggers/Cursors and UNIX Shell scripts.
• Ability to define project technical requirements, documenting and communication for conversion into robust system designs.
• In-depth knowledge on TableauDesktop,TableauReader and TableauServer.
• Proficient inTableaudata visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
• Unique combination of personal, analytical, technical and communication skills.

TECHNICAL SKILLS

ERP: Oracle Applications R12/11i, People Soft 9.x

BI/Reporting tools: OBIEE 11g/10g, Siebel Analytics 7.8/7.7, BI Publisher, Oracle Business Intelligence Applications 7.9.x, Tableau 8.x

Data Modeling/ETL/Scheduling Tool: Informatica Power center 9.1/8.6.x/8.1.1, 7.x, 6.x, Star and Snow flake Design, DAC, ODI 11g

Database Tools: Oracle 11g/10g/9i/8i, SQL Server 2008/2005/2000 , Netezza 7.2.0, Toad

Web Technologies: HTML, Java, JavaScript, JDBC, XML, XHTML.

Programming Languages: C, C++, SQL /PLSQL

Operating Systems: Windows XP/2000/2003/NT, UNIX (Solaris, Linux).

PROFESSIONAL EXPERIENCE

Confidential, Leawood, KS

Sr. OBIEE Consultant/Tableau Consultant

Responsibilities:

• Implemented Financial Analytics.
• Gathered requirements from the client for Confidential Analysis, translated them into technical design documents and worked with team members in making recommendations to close the Confidential .
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Designed and Tested Reports in the Dashboards for Financial Analytics, created the Ad-hoc report according to the client needs.
• Worked on Project, Procurement and Spend and finance related source queries to get the exact data required to built the report
• Created complex Union reports .
• Created Views in physical layer combining data from different tables
• Configured Interactive Dashboard with drill-down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects.
• Maintained Repository, Web catalog backups up to date for Development and test environments.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instance.
• Customized the Repository by creating Facts and Dimensions and adding some extra columns to the Existing Facts and Dimensions.
• Responsible for implementing data-level security and object-level (dashboards/reports) security among users, groups and web-groups.
• Highly experienced in setting up session variables and repository variables using various Initialization Blocks.
• Created Dimension hierarchies to achieve the drill down functionality.
• Created filters and customized prompts (filtering options)
• Created various BI Publisher Reports on top of BI Answers and aligned them on various Dashboards as per the requirement.
• Integrated data from Finance enterprise systems and transformed data using ODI.
• Designed and Developed General Ledger, Payables, Receivables, Profitability Dashboards in OBIEE.
• Worked closely with business power users to create reports/complex dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advance features ofTableausoftware like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Effectively used data blending, filters, actions, Hierarchies feature intableau.
• Performed End-to-End development (mappings, data sources, business rules/logic, RPD, subject areas, reports/dashboards and administration).
• Created Technical design documents
• Involved in the creation of test cases for Analytical reports and dashboards.

Environment: OBIEE 11.1.1.7.1 , BI Apps 7.9.6.3(Financial, Procurement and Spend Analytics, Projects),BI Publisher 11g, Oracle EBS R12.1.3, Informatica 9.1, SQL Server 2008/Netezza 7.2.0, Tableau 8.0

Confidential, Queensbury, NY

Sr. OBIEE Consultant/OBIA Consultant

Responsibilities:

• Worked closely with the end users to collect the requirements and did the necessary Confidential analysis to fulfill the client needs.
• Configured Financial, Procurement and Spend and Supply chain analytics domain value files.
• Did data validation for Finance, Procurement and Spend and Supply chain Analytics comparing data between EBS production and OBAW Production
• Developed new reports and customized Financial Analytics OOTB reports.
• Customized out of box Dashboard pages like Sourcing Trends, Revenue, Customer, Backlog, Shipping Performance, Total Spend Overview, Exceptions, Purchase Requisitions, Purchase Orders and Employee Expenses in Supply Chain, Procurement and Spend Analytics.
• Designed Star-Schema using Facts, Dimensions, Physical, Logical, Alias and Extension tables and established relationships & Foreign Keys (Physical & Logical) between tables.
• Customized OOTB Informatica mappings for financial analytics based on the business requirements.
• Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.
• Worked extensively on BMM (Business Model and Mapping) layer to capture the changes.
• Responsible for documenting all the mapping changes in the Physical Layer /Business Model / Presentation Layer of a Repository.
• Designed Intelligent Dashboards for different user groups to view updated KPIs.
• Worked on SQL queries for better database performance.
• Optimized performance using Indexes, Aggregate tables and materialized views.
• Developed Unit and System test plans and performed testing for data validation.
• Trained End Users on how to build dashboards and reports.

Environment: OBIEE 11.1.1.6.0 , BI Apps 7.9.6.3(Financial, Supply Chain and Procurement and Spend Analytics), Oracle Applications R12.1.3, Informatica 9.1, Oracle 11g, TOAD, windows 7, SQL Developer

Confidential, Addison, IL

Sr. OBIEE Consultant/OBIA Consultant

Responsibilities:

• Responsible to develop and customize HR Analytics OOTB reports related to Absence, Compensation, HR performance, Retention, Recruitment and Workforce Profile.
• Configured Workforce Event,Recruitment Event Reason,Pay Type files
• Customized the OOTB mappings to alter the actual "Headcount" metric to exclude non executive directors (NED)
• Created different types of Customized Reports (Drilldown, Aggregation, Levels) to meet business requirements.
• Generated various Analytics Reports like Formulary Report, Union Report.
• Developed Ad-hoc and standard Reports/Dashboards pages with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Graphs, Column Selector and Tabular with prompts, global and local Filters), contextual navigation.
• Worked extensively on BMM (Business Model and Mapping) layer to capture the changes.
• Responsible for documenting all the mapping changes in the Physical Layer /Business Model / Presentation Layer of a Repository.
• Developed many Dashboards / Reports for providing analytical information using Oracle BI Answers.
• Analyzed Informatica ETL mappings and transformation and suggested the changes based on the business requirements.
• Performance tuning of Dashboard/Reports.
• Responsible for cache management.
• Responsible for document the logic and design of the reports and the reporting structure.
• Created filters and provided customized prompts (filtering options) appropriately to avoid excessive data visibility in reports.
• Performed unit testing and Responsible for the End User support.
• Configured OBIEE iBots/ Agents to deliver daily and weekly reports.
• Responsible Training End User on How to use the OBIEE Tool and How to creating Adhoc reports using OBIEE 11 G.

Environment: OBIEE 11.1.1.6.0 , BI Apps 7.9.6.3(HR Analytics), PeopleSoft 9.0, Informatica9.0.1, BI publisher 11g, Oracle 11g, TOAD, windows 7, SQL Developer

Confidential, Arlington, VA

Sr. OBIEE Developer/Admin

Responsibilities:

• Installed and configured OBIEE repository Server, OBIEE Presentation Sever, oc4j, JDK, BI Publisher.
• Migrated and merged OBIEE Repository and Catalogs
• Monitoring the overall usage and taking necessary steps to improve the performance if needed
• Server Space management as per the need.
• Did the Necessary RPD and Catalog upgrades and applied patches as part of admin team.
• Provided extended production support based on the demand and complexity of the issue.
• Implemented Over all security, SSO, OBIEE content and Data level security
• Created users and groups in the LDAP server, and administered these users and groups using the WebLogic Server Administration Console
• Worked with Business analysts to identify, analyze and document business requirements.
• Gathered requirements for Confidential Analysis, translated them into technical design documents and worked in making recommendations to close the Confidential .
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Worked in End to End construction of the BI model from repository to reports development
• Worked with OBIEE Answers, Intelligence Dashboards in OBIEE 11g.
• Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Designed and developed physical, logical and presentation layers of the repository with new data model changes.
• Developed dimensional hierarchies to facilitate the drill down and report navigation.
• Implemented the Caching Strategy according to the client’s data load frequency
• Enabled Usage Tracking to monitor the usage and performance of reports
• Managed/Administered OBIEE web catalog using Catalog Manager
• Implemented MUDE (Multi User Development Environment) in OBIEE
• Created complex measures in BMM(Business Model and Mapping Layer) using Level based Measures, Time Series calculations and different Aggregation Strategies
• Created new Repository Variables, Session variables and Initialization blocks to configure security, data access and authorization on Repository and Catalog objects
• Implemented connection aggregate navigation by creating multiple logical table sources for the same logical table
• Configured the pool settings according to the requirements
• Created Answers reports using various analytics views like Table, Pivot tables, Charts, Column Selectors, View Selectors, Narrative, Static text etc.,
• Created common header and footer templates for all the reports in Answers
• Created new Dashboards according to best practices by using Columns, Sections and Guided Navigation
• Created Dashboard Prompts for Selective viewing and User Interactivity. Implemented column selector functionality using Dashboard Prompts and Presentation variables
• Was responsible for performance improvement of the reports by using various strategies in both the database and OBIEE like Indexes, Hints in Physical Layer, Materialized views and Caching
• Involved in Integrating Oracle BI Presentation Services with BI Publisher.
• Set up BI publisher Security to control access given to business users.
• Experienced in working with BI (XML) Publisher, Data Templates, RTF, and XSL Templates and provided the capability to download the reports in the user defined formats.

Environment: Oracle Applications R12(Financials, Projects, Supply chain and Order Management), OBIEE 10.1.3.4.1 /11.1.1.5 , BI publisher 10g, Oracle 11g, Toad, PL/SQL, HPUX, Windows XP

Confidential, West Palm Beach, FL

Sr. OBIEE Technical Consultant

Responsibilities:

• Involved in full life cycle implementation of Financial, Supply Chain and Order Management Analytics including installation, configuration, extension and customization
• Worked with both Onsite- Offshore teams.
• Conducted workshops to gather user requirements and performed Confidential analysis
• Installed and Configured OBIEE, DAC and Informatica on linux environment
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to OLAP system.
• Designed and Developed Custom Mappings and Workflows in Informatica to bring the data from other data source systems and Integrated using Universal Adapters in DAC.
• Implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
• Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.
• Migrated Analytics RPD and Webcat from one environment to another.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Designed and implemented the single sign on (SSO).
• 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 and roles within the OBIEE suite.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.
• Developed Informatica Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, Aggregator.
• Created and Customized Dimension Hierarchies to achieve the drill down functionality as per Business Requirements.
• 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.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star and snowflake Schemas.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Involved in customizing out of the box reports to support the business requirements.
• Involved in configuring and customizing sources, targets, tasks and execution plans using DAC.
• Involved in Query Tuning to maximize the performance of reports and Dashboards.

Environment: Oracle Applications 11i/R12, OBIEE 10.1.3.4.1 , OBIA 7.9.6.1, Informatica Power Center 8.6.1, Oracle 10g, DAC 10.1.3.4.1 , Toad, Linux, File-Zilla

Confidential, Long Island, NY

OBIEE Technical Consultant

Responsibilities:

• Installed and Configured Financial Analytics and Procurement and Spend Analytics.
• Integrated data from Finance and other enterprise systems and transformed data using Informatica (ETL).
• Gathered requirements from the client for Confidential Analysis, translated them into technical design documents and worked with team members in making recommendations to close the Confidential.
• Integrated OBIEE with EBS for Single Sign On(SSO).
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Created Environment Variable on Unix/Linux Environment.
• Designed and Developed Dashboard Pages Like Total Spend Overview, Trends, Exceptions, Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee Expenses in Procurement and Spend Dashboard.
• Designed and Developed Procurement and Spend and Supplier Performance, General Ledger, Payables, Receivables, Profitability, Dashboards in OBIEE.
• Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics.
• Designed and Developed Custom Mappings in Informatica to Load the Receivables Data from Legacy system.
• To implement incremental logic for Stage load mappings and insert/update logic for all Fact mappings.
• Extracted various sources like Oracle tables and imported Flat files using Informatica Power center.
• Extensively developed mappings on various business areas in the project by employing the available Transformations.
• Responsible for extracting Data from Oracle Apps Modules & loading into stage system and warehouse system.
• Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger Dashboard.
• Customized Dashboard pages like Overview, AP Balance, Payments Due, Payment Performance, Supplier Report, Invoice Details and AP Transactions in Payables Dashboard.
• Customized Dashboard pages like Profit and Loss, Revenue, Products and Customers in Profitability Dashboard.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Customized Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
• Customized the Repository by creating Facts and Dimensions and adding some extra columns to the Existing Facts and Dimensions.
• 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 and roles within the OBIEE.
• 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, Aggregator.
• Designed and Developed Sessions and Workflows.
• Designed, implemented and tested security privileges on subject areas, dashboards and reports.

Environment: Oracle Applications 11i/R12, OBIA 7.9.6, OBIEE 10.1.3.4.1 , Informatica 8.6.0, DAC 10.1.3.4.1 , SQL*PLUS, SQL*Loader, TOAD, Unix

Confidential, Saint Louis, MO

OBIEE/OBIA Developer

Responsibilities:

• Participated in discover/design phase of business requirements by meeting various business users.
• Analyzed the business requirement gatherings and translated the functional specifications into technical specifications.
• Worked on extracting data from Oracle EBS, OLTP flat files and integration and loading data to OLAP systems.
• Extracted the pre-built BI solutions of tables by using Oracle BI Apps, OBI Admin tool to configure and create repository (.rpd) and prepared a detail design document.
• Developed the repository model based on different requirements, with the necessary logic that involved customizing the OOTB Physical, Business Model Mapping and the Presentation layer.
• Analyzed the transaction environment to identify the required facts and dimensions for the OLAP.
• Created hierarchies, variables, time series measures and event poll strategies in the repository.
• Developed and customized HR Analytics OOTB reports and new Reports, performed look-good changes to OTB Dashboards with different subject matter Views (Drill-Down/Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBI Presentation Services for the various work streams.
• Developed calculated measures and assigned Aggregation levels based on dimension hierarchies.
• Worked Extensively on OBIEE Answers to create the reports as per the client requirements.
• Designed and implemented the Bulletproof Single Sign on (SSO) process so that users can navigate from the portal to the OBIEE dashboard.
• Implemented guided navigation within reports.
• Worked with ETL Team on Informatica Power Center tools - Source Analyzer, Data warehousing designer, Mapping Designer and Mapplets, Transformations, Work Flow Manager (Task Developer, Worklets and Work Flow Designer) and Work Flow Monitor.
• Involved in creating custom Mappings, Mapplets to load the new tables and the new information into the warehouse.
• Used DAC Client to customize and execute out-of-the box DAC execution plans to run all ETL mappings at specified interval.
• Customized DAC tasks, tables, table groups and indexes as per requirements.
• Performed nightly incremental loads using DAC.
• Customized the change capture process of DAC to load data incrementally.
• Involved in Performance tuning of reports/dashboards as well as metadata repository using optimization efforts such as re-organizing the data, cache management, indexes.

Environment: OBIEE 10.1.3.3, Oracle BI Applications 7.9.5(HR Analytics), Oracle EBS R12, Informatica 8.1, DAC 10.1.3, SQL Server 2000, Sun Solaris, Windows 2003