Summary:

• Over Seven years of extensive experience in IT with OBIEE/Siebel Analytics, Informatica, Oracle Applications, and Data Warehousing Complete Software Development Life Cycle SDLC including System Requirements Collection, Architecture, Design, Coding, Development, Testing, Production Support, Maintenance and Enhancement in variety of technological platforms with special emphasis Client/Server, Data Warehouse and Business Intelligence applications in Windows and Unix environments.
• Over four years of experience in OBIEE Oracle Business Intelligence Enterprise Edition /Siebel Analytics, Oracle BI Applications-Prebuilt Analytic Packages and Oracle Apps Oracle EBS implementations
• Expertise in developing all 3 layers of the Analytics Repository Physical Layer, Business Model and Presentation Layer .
• Hands on experience in Creating Oracle provided Business Analytics Warehouse OBAW , OBIEE RPD development, reports and dashboards and Oracle EBS.
• Experience customizing OBIA prebuilt dashboards and reports, Oracle Business Analytics HR Analytics and Spend Analytics Warehouse metadata objects, and web catalog objects.
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center.
• Expertise working with dimensions and fact tables in the BI Apps and experience with understanding universal adaptors in order to load into BI.
• Experience in developing Dimensional Hierarchies/New logical columns/Filters/Variables as per business requirements.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Experience in developing OBIEE Siebel v.8 Analytics Repositories, Dashboards, Answers/Reports, iBOTs, Enterprise Data Warehouses EDW , Data Marts DM , Operational Data Stores ODS , and Data Integration, and Client/Server OLAP/OLTP systems, PL/SQL development.
• Experienced in prebuilt And customized OBI Applications like Finance, Marketing, pharma, WorkForce analysis, HR and OM.
• Highly proficient in Design, Development, Implementation, Administration and Support of ETL processes for Data Marts and large scale Data Warehouses using Informatica Power Center 8.6 , 8.1 ,7.x, 6.x, and 5.x. and Power Mart 6.2/5.1 and implementing OBIEE platform with more than 6 years of experience.
• Experienced in Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources into data warehouse using Informatica Power Center Repository Manager, Designer, Workflow Manager and Workflow Monitor .
• Designed and developed complex mappings, from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner and Update Strategy.
• Worked with DAC to configure, schedule, monitor and schedule ETL routines.
• Hands on experience working with OBIEE RPD modeling.
• Worked independently as well as in team and experienced in coordinating with different groups in projects.
• Expertise in creating, modifying, using and debugging Stored Procedures, Views, User Defined Functions using SQL Server/PL SQL.
• Good knowledge in different flavors of UNIX such as HP-UX, AIX, and SOLARIS.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre post session operations.
• Strong analytical and problem solving skills coupled with excellent written, verbal and inter-personnel communication skills.

Technical Skills:

Professional Experience:

Confidential

OBIEE Developer

Responsibilities:

• Worked with business users to identify, analyze and document business requirements for OBIEE/DW Projects.
• Worked on applying patches to OBIEE 11g environment after upgrading from OBIEE 10g.
• Designed the physical layer, BMM layer, Presentation Layer in RPD, created the session variable and Dynamic variable in RPD.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Enhanced and designed the reports in OBIEE for Various Horizon and Snapshot date dimensions in STAR.
• Woking with Client entire suite of business intelligence products, including OBIEE 11G, Informatica, Erwin.
• Woking in Financial, Procurement, Supply Chain and HR analytics Spend analytics.
• Used ETL processes to load data from Flat files, Oracle Databases into the target OLAP database.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Interacted with Solution Architect to implement the OBIEE application for Housing stats, National forecast and Information to run the business.
• Analyzed the structure and the granularity level of the EDW Enterprise Data Warehouse for the advanced implementation of the WRITEBACK feature of OBIEE.
• Extensively worked on Answers, Created Reports using different Analytics Views Pivot Table, Chart, Column Selector and Table .
• Evoluting database structures including GoldenGate, Oracle 11G upgrades.
• Worked with data modelling, including multi-dimensional modelling, ETL and metadata development.
• Developed different brand level Reports, Filters, and Prompts using Oracle Business Intelligence Answers.
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users which include business users from various parts of the world.
• Successfully implemented the code in DEV and deployed in SIT and UAT, Debugged and tested in final Test and deployed in Production.
• Designed and Developed the RPD and reports by using the column selector, pivot table view selector.
• Achieved the Radio Button functionality in OBIEE by creating the prompts and using those prompts as the presentation variables in OBIEE front end thereby manipulating the selected columns measure.
• Implemented Forecast Subject Area in OBIEE.
• Created and Developed the Groups in RPD and implemented Dashboard and Report-level security.
• Implemented the IBOTS for the Forecast Accuracy release and assigned the groups in OBIEE front end.
• Worked on OBIEE functional capabilities of Out of the box dashboards including full understanding of underlying table structures.
• Good Understanding of Data warehousing Concepts like Star schemas and Snowflake Schemas.
• Involved in Analysis, Requirements gathering, SRS Software Requirement Specifications HLDD High Level Design Document LLDD Low Level Design Document . Develop a ETL mapping and Load data tables for Proof of Concept .
• Used XML/BI Publisher for Multi language reporting purpose.
• Performed Informatica Mapping between Enterprise Data warehouse and the abstract layer of Data warehouse.
• Involved in the design and development of Data Warehousing project for the improvement of Financial System.
• Used Transformations like look up, Router, Filter, Joiner, Stored procedure, Source Qualifier, Aggregator and Update strategy extensively.
• Created mapplets and used them in different Mappings.
• Partitioned Sessions for concurrent loading of data in to the target tables.
• Used DAC Data warehouse Administration Console for both incremental and full loads.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Performed incremental aggregation to load incremental data into Aggregate tables.
• Conducted training Sessions on Informatica power center and OBIEE.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 11.1.1.3/10.1.3.4, XML/BI Publisher 5.6.3, Procurement and HR Analytics /Sales Analytics /Spend Analytics,Informatica Power Center 8.6, Data Warehouse Administration Console DAC , Data Quality 8.6.2, Java,Data Explorer 8.6, Informatica Power Exchange 8.5, Data Modelling,Oracle 11g, PL/SQL, SQL Plus, UNIX Sun Solaris .

Confidential

OBIEE Developer

Responsibilities:

• Created and administered the Physical Layer, Business Model and Mapping Layer, Presentation Layer in a Siebel Analytics repository.
• Troubleshooting and debugging of defects and production issues in the areas of SQL, Informatica and OBIEE 11g/10g.
• Collaborating with the BI Architect / BI Team and the business community to define information use cases and approaches for supporting them with Oracle BI Analytics HR Spend dashboards reports
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• 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 .
• Configured iBots to deliver content based reports on schedule, automated iBots queries to obtain daily and weekly reports.
• Created VPD security for reports in OBIEE.
• Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables including Physical, Logical data modeling in the OBIEE Administration tool.
• Worked with creating RTF templates in MS Word by connecting to BI Publisher, and publish these templates for the reports to view data in BI Publisher.
• Migrated Repository and Catalog between environments like Dev, Test, QA, maintenance and Performance.
• Involved in setting up Ibots to run reports at scheduled time.
• Customized the OBIEE Repository physical, BMM, and presentation layers .
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level the Application level.
• Developed and configured various reports in BI Publisher such as vendor listing, AP Invoices and Check Printing.
• Developed Different Components in User Interface UI Layer like Folders, Dashboards, Pages Columns, Sections, Requests / Answers, Filters, Global Filters, Navigation Links, Views / Charts using Oracle BI Presentation Services.
• Created BI Business Intelligence discoverer End User Layer EUL , workbooks, worksheets, Business areas BA , Folders, Items to support ad hoc reporting using BI Discoverer desktop, Discoverer Administration, Discoverer Plus and Discoverer viewer.
• Registered new tables, indexes, tasks in DAC and created custom ETL execution plan for nightly data warehouse load.
• Involved in Query Tuning to maximize the performance of reports and Dashboards
• Used ETL processes to accommodate changes in source systems and new business user requirements.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Repository.

Environment:Oracle Business Intelligence Enterprise Edition OBIEE 10, BI publisher 8.6.2, DAC, Data Explorer 8.6, , HR Analytics , Procurement and Spend Analyticss,Informatica Power Exchange 8.5, Oracle 10g, PL/SQL, SQL Plus, UNIX.

Confidential

OBIEE Consultant

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.
• Created and customized intelligence Dashboards in Oracle Business Intelligence to suit the client's requirements.
• 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
• Specified Dimensional hierarchy and Aggregate levels for the dimensions.
• Setup Multi User Development Environment MUDE in OBIEE.
• Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports
• Created various reports to fulfill the marketing needs and customized the views using Oracle BI Answers.
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users, which include like Managers, functional heads, Department Heads.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Used the Catalog Manager and maintained the Analytics web catalog to manage dashboards answers. Developed Dashboard pages like Liquidity,GL Balance,Cash Flow and Balance Sheet in General Ledger Dashboard.
• Developed Dashboard pages like AP Balance,Overview,Payments Due,Supplier Details and Invoice Details in Payables Dashboard.
• Developed Dashboard pages like AR Balance,Payments Due,Invoice Details and All AR Transactions in Receivables Dashboard.
• Worked in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Extensively worked on workflow manager and workflow monitor to create, schedule, monitor workflows, work lets, sessions, tasks etc.
• Developed Mappings using corresponding Source,Targets and Transformations like Sequence Generator,Source Qualifier, Router,Filter, ,Joiner, Lookup, Expression, Aggregator and Update Strategy.
• Worked extensively in Oracle BI Security, Web Object Security and Data Level Security.
• Created Presentation catalogs and Folders in Presentation Layer and Performed Global Consistency Check in Oracle BI Administration Tool.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
• Performed Unit testing, integration testing to verify the report functionality and debugged dashboard reports to verify data matches as expected.

Environment: Oracle Applications 11i/R12 iProcurement, Accounts Payables AP , counts Receivable AR , General Ledger GL , Supply Chain SCM , OBIEE 10.1.3.2, Oracle 10g, Informatica 8.1.1, XML/BI Publisher 5.6.3, Discoverer 10g/4i/3i, PL/SQL ,SQL PLUS, SQL Loader, TOAD,Unix.

Confidential

Oracle Applications and OBIEE Consultant

Responsibilities:

• Data modelling STAR schema design and architecture, created new facts, dimensions and alias tables for the dimensional tables when required.
• Extensively used OBIEE Administration Tool for customizing and modifying the Physical, Business and Presentation layer of the Repository.
• Architecture design of business model. Identified Facts, Dimensions, and Hierarchies of the business model. Created complex calculated measures based on time dimension to calculate Quarter Ago and Year Ago metrics.
• Designed and Developed Financial Dashboard like General Ledger,Payables,Receivables.
• Created AD hoc reports in Acount Payables.
• Worked extensively on OBIEE Answers to create the reports as per the client requirements.
• Created reports in Answers and embedded them in Dashboards according to the requirements.
• Used Analytics Web Catalog to set up groups, access privileges and query privileges.
• Designed and developed BI Publisher reports according to client requirement
• Created and scheduled iBots as per the business requirements
• Designing data warehouse to support RPD schemas.
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users which include business users from various parts of the world.
• Created customized dashboard prompts as per the business requirement
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Created Alias and configured repository with logical dimensional modeling using star schema.
• Created Dashboard prompts and advance filter criteria.
• Customized GL Detailed Trial balance report, GL Period to Date Balances reports in General Ledger using FSG's.
• Designed and developed Customer Interface, Auto Lockbox Interface.
• Designed Customer Products Summary Report in Install base using OBIEE.
• Worked on Service Contract interface program by using the standard API's.
• Customized Supplier Payment History Report in Account Payables to meet client requirements.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the sql execution path by making use of hints etc

Environment: Oracle Applications 11i 11.5.10 General Ledger, Account Payables, Accounts Receivable,Inventory, Supply Chain SCM , OBIEE 10.1.3.2, XML/BI Publisher 5.6.3, Discoverer 10g, SQL PLUS, SQL Loader, TOAD, Unix.

Confidential

Informatica Developer

Responsibilities:

• Involved in Systems Study and Analysis and understand the business needs and implement the same into a functional database design.
• Defined the ETL strategy for Data Warehouse population.
• Involved in Data Quality Analysis to determine cleansing requirements.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Performed extensive analysis of metadata to test the integrity, consistency and appropriateness of the data to be brought into the centralized City Data from various sources.
• Installed, Maintained and Documented the Informatica Power Center setup on multiple environments.
• Designed the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Worked on Informatica Power Center 6.2 and created Informatica mappings with PL/SQL procedures/functions to build business rules to load data. Most of the transformations used were like the Source qualifier, Aggregators, lookups, Filters Sequence generators.
• Created sessions and batches to move data at specific intervals on demand using Workflow Manager.
• Extensively worked on the Database Triggers, Stored Procedures, Functions and Database Constraints. Written complex stored procedures and triggers and optimized for maximum performance.
• Analysis and Design of Migration Procedures for the DB Migration between Relational and Extended ERP Data Sources.
• Performed Database Migration from sources to the Data Warehousing database. Worked closely with Oracle DBA for migration support.
• Created UNIX shell scripts Scheduler utilities for automating the backup of Database/ Transaction log.

Environment: Informatica Power Center 7.1/6.2, Oracle 9i, DB2, Teradata, TOAD, SQL Navigator, SQL Server 2000, PL/SQL, XML, Windows NT 4.0.