Summary

• Eight years of software development experience in the field of Business Intelligence/Data Warehousing using the Informatica ETL tool and OBIEE/Siebel Analytics/BI Publisher reporting tool, possessing superior analytical skills and the ability to meet deadlines.
• Experience in designing and developing end-to-end BI solutions according to standard OLAP methodologies using Siebel Analytics/Oracle Business Intelligence OBIEE , including 3 Data Warehouse Development full life cycle implementations.
• Strong understanding of logical and physical database designs and also dimensional modeling schemas like Star and Snowflake schema.
• Experience in Upgrading OBIEE environments.
• Working experience with new administration features of OBIEE 11g OBIEE 11g Web logic Administration Console, OBIEE 11g Enterprise Manager
• Expertise in design and development of the three layers Physical/Business Model and Mapping/Presentation of an OBI Metadata Repository using Oracle BI Administration Tool.
• Configured Answers ad-hoc querying, reports , Interactive Dashboards with drill-down capabilities charts/tables/graphs , Delivers/iBots/Agents alerts and administered Web Catalog Objects pages, folders .
• Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP authentication setup to the external tables and configuration of Multiuser Development Environment MUDE .
• Sound knowledge of database architecture for OLTP and OLAP applications, Data Analysis, ETL processes in developing data marts and Enterprise Data Warehouse.
• Development strategies for Extraction, Transformation and Loading ETL of data from various sources into Data Marts and Data Warehouses using Informatica Power Center Repository Manager, Designer, Workflow Manager and Workflow Monitor .
• Experience in Writing Technical Design Document and converting Functional Specs to Technical Specs.
• Experienced in Performance Tuning of Source, Targets, Mappings, Sessions and Transformations.
• Experience as Informatica Administrator and experience in DAC.
• Used DAC Data Warehouse Administration Console to configure, administer, load and monitor modular data warehouse applications.
• Hands on experience with Hyperion Financial Reporting, Interactive Reporting.
• Experienced in Software Analysis, Design, Development, Testing and Implementation phases of Data Warehousing using Oracle 11g/10g, MS SQL Server, Essbase, Teradata and DB2.
• Proficient in all the phases of the Software development lifecycle, including requirements Definition, Analysis, Design, System Implementation, Performance Tuning, Testing and Production Support.
• Experience in UNIX Shell Scripting.
• Active team player with excellent communication, organization and Interpersonal skills, self motivated and quick learner.
• Ability to work independently as well as in a team, fun-filled and challenging environment.

Professional Experience:

Confidential

OBIEE Consultant

Responsibilities:

• Involved in gathering and analyzing the user requirements in coordination with Business and Identified Facts, Dimensions, and grain of the Dimensional modeling. Also prepared the requirement specifications document based upon the background study and research.
• Merged new RPD, dashboard and Answers requests with existing OBIEE content and Upgraded RPD, Catalog from 10.1.3.4.1 to 11.1.1.3 and 11.1.1.3 to 11.1.1.5.
• Worked with OBIEE Analysis, Intelligence Dashboards. Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, scheduling, guided navigation, customization, conditional formatting, and complex union reports to satisfy the end users.
• Used ETL processes to load data from Flat files, Oracle Databases into the target OLAP database.
• Designed and developed Custom Mapping and Workflows in Informatica to bring the data from other data sources systems and integrated using Universal Adapters in DAC.
• Extensive usage of repository variables, server variables, and presentation variables, following best practices and standards.
• Configured interactive dashboards by adding embedded content such as links/images, HTML objects, Java Scripts and folders.
• Expertise in Setting Up Multiuser Development Environment MUDE and Cache Management Event Pooling Table Using Oracle BI Administration Tool.
• Implemented Security by creating roles, web groups and policy checks with External tables and LDAP Active Directory .
• Working experience with Oracle Weblogic Server Administration Console to create and manage users and groups in the embedded LDAP server.
• Worked with Oracle Enterprise Manager to monitor, manage and configure Oracle BI system components.
• Set up Usage tracking and Scheduler in OBIEE 10.1.3.4.1 and 11.1.1.3.
• Created iBots/Agents to Deliver Reports via Email, Pagers and Mobile Phones.
• Worked on applying patches to OBIEE 11g environment after upgrading from OBIEE 10g by working with oracle after identifying the bugs.
• Implemented BI Publisher Bursting for scheduling the reports to deliver based on user role with security.
• Involved in migration to various environment DEV, UAT and PROD for .RPD migrations and Web Catalogs using catalog manager.
• Developed Performance Tuning Strategies for optimizing the performance.
• Created the High Level Design Document HLD and Technical detailed design document TDD of Repository and Web Catalog file reports/dashboards .
• Written Technical design Specs and converted functional to Technical Specs and Production Support document.

Environment: Hyperion FR 9.3.1, Oracle 11/10g, Toad 10.1/9.0.1, OBIEE 11.1.1.3, Windows 2008/2003/XP, Essbase 11.1.1.3 /9.3.1, Essbase Plug in.

Confidential

OBIEE Developer

Responsibilities:

• Effectively interacted with business users for requirement gathering and defined requirements specifications document.
• Performed Project Scoping, Project Organization and Management including Business IT Requirements, Priorities, Project Execution Plan and Resource Plan.
• Worked on the complete life cycle implementation of OBIEE 10.1.3.4.
• Built the OBIEE repository .rpd ./metadata Physical Layer, Business Model and Mapping Layer and Presentation Layer and created the subject area where reporting and analysis are centered around.
• Modified the Business Layer to add more Dimensions, developing multiple Dimensions Drill-Down Hierarchies in the Oracle BI Admin Tool.
• Identified the Aggregate levels for measures and created dimension hierarchy sources for each level of Aggregates for performance enhancement.
• Used Security setting in OBIEE Administration tool to set up external database authentication for users.
• Expert in Cache management, Repository migration, Data level and Object level security in OBIEE Analytics.
• Implemented security by creating roles, web groups, and LDAP Authentication.
• Implemented Time Comparison and Calculation measures in the business model using Time series Functions.
• Developed many Reports using different Analytics Views Pivot Table, Chart, View Selector and Column Selector , Presentation Variables, Dynamic / Interactive Dashboards with drill-down and drill-through capabilities, charts, tabular using global and local Filters.
• Configured Oracle BI delivers iBots in Unix Environment.
• Configured iBots to deliver Analytics content based on schedule, automated iBots queries to obtain daily and weekly reports.
• 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.,
• Extensively used Catalog Manager and Job Manager.
• Developed many PL/SQL procedure functions and used the same in mappings, pre and post sessions
• Writing Shell scripts to automate the export data into flat files for back up and delete from staging tables for the given time period and sending emails about statistics on regular basis.
• Written Technical design Specs and converted functional to Technical Specs and Production Support document.
• Logical database design, physical database design, data modeling with Erwin/Model mart.

Environment: OBIEE 10.1.3.4.1, Flat files, Oracle 10gR2, DB2, Erwin 4.3, PL/SQL, UNIX Shell Scripting, Toad 10, OBI Publisher 10.1.3.4, WinSCP, Putty, Windows 2003 server, Windows NT.

Confidential

OBIEE Developer

Responsibilities:

• Designed custom star schemas and ETL mappings to meet user requirements.
• Requirement analysis, Designed and implemented custom business intelligence solutions Metadata and Dashboards/Reports using the Oracle Business Intelligence OBI Analytics platform.
• Designed and Developed OBI Repository at 3 layers i.e., Physical Layer connecting to Data Warehouse imported objects with joins , Business Model / data mapping create Logical tables, Drill-Down Hierarchies complex joins and Presentation Layer level create presentation catalogs , create presentation folders, test and validate the model.
• Developed Time Series object for comparing between the months, quarter's sales.
• Developed complex reports involving complex SQL filters.
• Extensively used presentation variables to develop the logic for the reports.
• Implemented Security by creating roles web groups, checks with External tables and LDAP.
• Implementation of different views of report i.e. Pivot table, Titles, Graph, Filters etc.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters using Presentation Services/Siebel Analytics Web.
• Extensively worked on workflow manager and workflow monitor to create, schedule, monitor workflows, work lets, sessions, tasks etc.
• Extensively used all the transformations like source qualifier, aggregator, filter, joiner, Sorter, Lookup, Update Strategy, Router, Sequence Generator etc. and used transformation language likes transformation expression, constants, system variables, data format strings etc.
• Registered new tables, indexes, tasks in DAC and created custom ETL execution plan for nightly data warehouse load.
• Coordinated the Analytics RPD and Web Catalog objects migration from Developer environment to QA environment.
• Implemented OBIEE and done Administration for informatica.
• Written Technical design Specs and converted functional to Technical Specs and Production Support document.
• Logical database design, physical database design, data modeling with Erwin/Model mart.

Environment: Informatica Power Center 8.6/8.5.1/8.1.1, OBIEE 10.1.3.4, HR Analytics 7.9.5, Flat files, Oracle 10gR2, Oracle Apps, DAC, MS SQL Server 2005, DB2, OBI Publisher 10.1.3.4, Erwin 4.3, PL/SQL, UNIX Shell Scripting, Toad, Business Object 6.5, Windows NT.

Confidential

Oracle Apps and OBIEE Developer

Responsibilities:

• Designed and populated dimensional models both star and snowflake schemas for a data warehouse and Data marts.
• Requirement analysis, Designed and implemented custom business intelligence solutions Metadata and Dashboards/Reports using the Oracle Business Intelligence OBI Analytics platform.
• Involved in the design of the BAL Business Analytics Layer and designing the DW for the BAL.
• Configuring OBIEE with LDAP server for Security.
• Configured BI Publisher with OBIEE
• Designed and Developed OBI Repository at 3 layers i.e., Physical Layer connecting to Data Warehouse imported objects with joins , Business Model / data mapping create Logical tables, Drill-Down Hierarchies complex joins and Presentation Layer level create presentation catalogs , create presentation folders, test and validate the model.
• Implemented security at Object Level Data Level for different level of hierarchies Subject Areas.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas
• Added Aggregate measures using Aggregate Persistence Wizard
• Developed complex reports involving complex SQL filters.
• Developed strategy for migration from Siebel Analytics 7.9.5 to OBIEE 10.1.3.3.
• 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 using Siebel Analytics Web and BI Publisher.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Created iBots and Delivers to send alert messages to subscribed users.
• Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports.
• Created role based dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts.
• Performance Tuning of database, sources, targets, mapping and session was performed.
• Developed AP Supplier Contact report that will provide detailed contact information about Vendors/Suppliers for communication purposes.
• Designed and Developed AP Check Printing Report, Invoice Detail Report by Supplier, Payment Schedule Report in XML/BI publisher.
• Customized the standard AR Aging Report and Invoice History Report using XML/BI publisher.
• Customized Chart of Account Detail listing, Trial Balance, Summary Income Statement in General Ledger using FSGs.
• Converted Order Detail Report, Credit Order Summary Report, Orders by Item Report in Order management from report 6i to XML/BI publisher.
• Extensively worked on workflow manager and workflow monitor to create, schedule, monitor workflows, work lets, sessions, tasks etc.
• Worked on complex transformation scenarios for successful completion of mapping.
• Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, using variable/parameters for simplifying mappings.

Environment: OBIEE 10.1.3.3, Informatica 8.1.1, DAC 7.8.5, OBI Publisher 10.1.3.3, Siebel Analytics 7.9.5, : Oracle Applications 11i 11.5.10 , General Ledger GL , Accounts Payables AP , Account Receivables AR , Order Management ORM , Inventory INV , Oracle 9i, Discoverer 10g, SQL Server 2005, Oracle 10GR2, TOAD, Windows XP.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Extensively Modified Shipping INBOUND/OUTBOUND interface programs to accommodate changes in business process.
• Designed Customer Products Summary Report in Install base using XML/BI publisher.
• Worked on Service Contract interface program by using the standard API's.
• Generated Inter Company Transaction Detail Report, Open-Debit Memo Report in General Ledger using Reports 6i.
• Customized Supplier Payment History Report in Account Payables to meet client requirements.
• Customized GL Detailed Trial balance report, GL Period to Date Balances reports in General Ledger using FSG's.
• Created new custom reports in XML/BI publisher, upgraded Standard 6i reports to XML/BI publisher reports.
• Assisted end users in installing Discoverer on the user machines.
• Resolved production related problems and enhanced applications according to requirements.

Environment: Oracle Applications 11i General Ledger GL , Account Payables AP , Account Receivables AR , Service Contract, Install base, Shipping, Oracle 9i, XML Publisher 5.6.2, Reports 6i, Discoverer 10g, SQL,PL/SQL, TOAD, Sun Solaris.

Confidential

PL/SQL Developer

• Interface with Customers Management Team to capture and analyze business requirements.
• Worked with a team of IT developers in the Initial Database Design/Data Modeling/Data approval.
• Experience in writing, testing and implementation of PL/SQL triggers, stored procedures, functions, packages to implement business logic.
• Creating database objects including tables, indexes, clusters, sequences, roles, and privileges.
• Created users and established the application security by creating roles.
• Optimized the embedded SQL queries using statement level optimizer hints when essential, to adhere to the defined OLTP response time.
• Importing/Exporting data from/to different databases using utilities like SQL Loader, Import/Export.
• Developed and modified applications, authored database procedures and triggers for data processing.
• Prepared User manual, Technical documents for the end user.
• Unit testing and monitoring performance and providing System support.

Environment: Oracle 8i, Flat files, MS Access, SQL Plus, SQL LOADER, and Windows NT.