SUMMARY

• Done Post Graduation in Master of Computer Applications and have 9 years of experience in IT industry.
• Over 8 years of extensive experience in complete life cycle (System Analysis & Design, Data Modeling, Development, Testing and Implementation of BI applications) of Siebel Analytics, OBIA & OBIEE Applications (Sales, Service, Marketing, Financial, Supply Chain and Procurement and Spend Analytics).
• Around 5+ years of extensive Experience as an Informatica Administrator and developer.
• Around 6+ years of experience in Oracle Database technologies.
• Good understanding on Dimensional modeling and STAR/SNOWFLAKE schema
• Experience in performing end to end testing including Data Validation, Unit Testing and User Acceptance.
• Excellent analytical, programming and business - to-technical communication skills.
• Installation, Upgrade and integration of OBIEE/Siebel Analytics with Informatica and DAC (Data warehouse Application Console) on Windows and UNIX environment, MUD (Multi User Development) Setup.
• Extensive experience in developing Informatica Mappings / Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & Tasks.
• Expertise in debugging, optimizing the performance tuning of Oracle BIEE 10g/ 11g Repository & Dashboards / Reports by implementing Aggregate tables, Fragmentation of data sources, Indexes and Cache management.
• Excellent interpersonal skills, ability to interact with people at all levels, good presentation skills, excellent team player, ability to meet deadlines.

TECHNICAL SKILLS

OBIEE: OBIEE 10g/ 11g

OBI Applications: OBIEE, Informatica and DAC

Languages: SQL, PL/SQL, UNIX Shell Script

ETL Tools: Informatica 8.6

Databases: Oracle 9i, 10g

BI Tools: OBIEE 10g and OBIEE 11g, Hyperion Essbase 9.3

OS: Windows 2000/XP, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

OBIEE Lead

Responsibilities:

• Responsible for Leading team in offshore
• Working on onsite offshore model to handle team in offshore.
• Working vendors to resolve the issues as per the adhoc reports created by them
• Working on Remedy tool used to log the errors.
• Responsible for building Application Turnover documents.
• Working on OBIEE 11g support for financial Analytics modules GL, AP, AR, Procurement & Spend and Project Analytics.
• Working on DAC to monitor the jobs and execution process
• Building the support documents for transition and issue logs

Confidential, Piscataway, NJ

Sr. Technical OBIEE Admin Lead

Responsibilities:

• Configured Physical layer, Business Model Layer and Presentation Layer of the repository.
• Configured the OBIEE Server to import the Essbase cube
• Created the environmental variables which maps to the client location of Essbase installed.
• Created the UDA’s
• Built the flat measures
• Build the reports and dashboards.
• Created prompts
• Built the security based on role to view the dashboards.
• Prepared the design document which provides the information with the configuration details and business requirements.
• Build star schema using data modeling tool Erwin
• Built test case scenarios to test the dashboards
• Built Unit Test documents to provide testing.
• Created the initialization blocks.
• Implemented weblogic performance tuning at domain level
• Implemented WLST in online and offline modes configure and tune WebLogic domains/applications for performance
• Prepared configuration document to deploy from Development instance to QA instance.

Environment: Hyperion EPM 11.1.2.2, OBIEE 11.1.1.6, Windows XP.

Confidential, Seattle, WA

Sr. OBIEE Admin Lead/ ETL Developer

Responsibilities:

• Configured Physical layer, Business Model Layer and Presentation Layer of the repository.
• Renamed the components as per business terminology
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other various features to meet the business requirements.
• Performed data analysis on the sources(Oracle EBS)
• Created Repository, system and non-system session variable and initialization blocks for various reporting needs.
• Created role based dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts.
• Utilized OBI reporting features such as Navigational, Drill Down, Drill Across, Guided Navigation, Security
• Configured the Extract date, Global and Local Currencies, Fiscal Calendar, Exchange Rate Types.
• Experience in setup of General Ledger account Hierarchies.
• Experience is setup of HR Analytics
• Implemented Procurement Analytics supplier informations
• Experience in Mapping Oracle GL Natural Accounts to Group Account Numbers.
• Implemented User, Object and Data security
• Performed testing in all standards functional, security and data integrity
• Complex measures are broken and evaluated
• Web Logic performance tuning at domain level.
• Create, configure and tune WebLogic domains/applications for performance
• Functionality of the reports is written and make it available to business community
• Trained & educated functional and business team as well

Environment: OBI Apps financial Analytics 7.9.x, OBI Apps Procurement Analytics, OBI Apps HR Analytics, Oracle EBS 11i, Informatica 8.6, Oracle 10g, Windows XP.

Confidential, CA

OBIEE Administrator

Responsibilities:

• Interacted with Procurement and Operation/Maintenance business representatives for gathering the OBIEE Reports & Dashboards requirements and to define business and functional specifications.
• Responsible for design, development, and supporting enhancements of OBIEE.
• Hands on experience in data warehousing technologies including ETL, Oracle BI Server architecture, and metadata management.
• Independently Designed and developed subject areas in the RPD.
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer (design of hierarchies, dimensions, and aggregates).
• Define appropriate joins, calculations, dimensions and measures in the repository.
• Assist in performance of Gap Analysis related to Data Models and data extracted in ETL’s, and map client requirements into OBIEE functionality
• Implemented Supplier Information using Procurement and spend analytics
• Debugged and implemented the best practices in mappings, sessions, and workflows for data extraction and loading from source to target databases.
• Created Repository User/ Groups and Web Groups and assigned permissions to the user groups to define security in the repository.
• Created and customized various Reports and Dashboards for various user groups.
• Created reports of Oracle EBS using BI Publisher through OBIEE.
• Designed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative and Nested reports in Answers.
• Expertise in writing the queries using PL/SQL.
• Created reports with different views (Compound, Chart, Table, Pivot, Ticker and Narrative).
• Developed and scheduled i-Bots for delivering personalized reports to users on time.
• Secured Dashboards and Reports by defining user roles.
• Implemented OBIEE security at the data and object levels.
• Extensively worked on different transformations like Source Qualifier, Expression Filter, Lookup, Update Strategy, Stored Procedure, Sequence Generator, Joiner, Router, Aggregator Transformation and SQL override.
• Created Analytics that provide detailed analysis of HR programs and Workforce performance.
• Applied Optimization techniques and tuned performance of the reports such as caching and building summary tables.
• Created user manuals and troubleshooting guides.
• Trained End Users to Build Ad Hoc Reports using OBIEE.
• Implemented drill down capability on location data using Graphical Maps.
• Created prompts in OBIEE to navigate on maps, passing parameters between Summary and detailed Reports.
• Worked on support role to do the enhancements in answers pages to make the reports look similar to OBIEE 10g reports.

Environment: OBIEE 11g, Oracle HR Analytics, Oracle Procurement Analytics, Oracle EBS 11i, Informatica 8.x, BI Publisher, Oracle 10g, Windows XP.

Confidential, WA

OBIEE Admin Lead/ ETL Developer

Responsibilities:

• Gathered Business Requirements and documented using Oracle’s process Templates like MD50s etc.
• Participated in the scope definition meetings.
• Performed data analysis on the source data Oracle EBS.
• Configured Physical layer, Business Model Layer and Presentation Layer of the repository.
• Renamed the components as per business terminology.
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other various features to meet the business requirements.
• Created Repository, system and non-system session variable and initialization blocks for various reporting needs.
• Created role based dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts.
• Utilized OBI reporting features such as Navigational, Drill Down, Drill Across, Guided Navigation and Security.
• Data and objects are restricted in accordance with application.
• Cache is purged programmatically.
• Integrated OBIEE with Oracle Map Viewer for using Maps into dashboards.
• Integrated OBIEE with Oracle EBS and Siebel Application.
• Created reports using the BI Publisher.
• Delivers (Ibots) are created and scheduled for fast response.
• Conducted code walkthrough for the reports.

Environment: OBIEE 10g, Oracle EBS 11i, Informatica 8.6, BI Publisher, Oracle 10g, Windows XP.

Confidential

Sr. OBIEE Administrator

Responsibilities:

• Worked on OBIEE RPD development in order to integrate with Hyperion.
• Created Proof of Concept with the integration of OBIEE 10g with Hyperion Essbase 9.3.
• Involved in Data Modeling, Design Documents, and data warehouse.
• Responsible for supporting and enhancements of OBIEE.
• Implemented drill down, hierarchies, Aggregate navigation.
• Implemented Ragged Hierarchy.
• Utilized OBI reporting features such as Navigational, Drill Down, Drill Across, Guided Navigation and Security.
• Created Repository Users, Groups and Web Groups and assigned permissions to the user groups to define security in the repository.
• Created and customized various Reports and Dashboards for various user groups.

Environment: OBIEE 10.1.3, Hyperion Essbase 9.3, Oracle 10g, Windows XP.

Confidential

Sr. Informatica Developer

Responsibilities:

• Custom implementation is done with consideration of future enhancements and upgrades.
• Developed custom SDE mappings that tapped to source systems and load staging area.
• Developed custom SIL mappings to load data from the staging into target area.
• ETL tasks related to Hierarchies & Aggregates are created.
• Used transformations like “Source Qualifier”, “Expression”,” Update Strategy”,” Look up” etc.
• Configure Custom Workflows.
• Custom incremental mechanism applied to non-application data.
• Performance tuning done to all jobs.
• Full mode / incremental migration are done across different instances.
• Configured DAC for OBIEE Financial Analytics.
• Applied custom incremental mechanism that controls the data set.
• New Subject Areas created.
• Analyze Execution Plan.
• Tested execution Plan in both Incremental mode and Full Mode.
• Parallel processing the ETL tasks that belong to same task order.
• Performance tuning is achieved.
• Exported the DAC repository in full / incremental mode (Logical, System and Run).

Environment: Informatica 8.6, OBIEE 10g, Oracle 10g, Windows XP.

Confidential

OBIEE Developer

Responsibilities:

• Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Involved in Data Modeling using Star Schema.
• Used OBIEE 10.1.3.4.1 Administration tool to develop and enhance meta-data.
• Designed and developed the OBIEE Metadata Repository (.rpd) using OBIEE Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• 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).
• EnhancedQuery performance, byanalyzing & modifying SQL Query and Filters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Custom implementation is done with consideration of future enhancements and upgrades.
• Developed custom SDE mappings that tapped to source systems and load staging area.
• Developed custom SIL mappings to load data from the staging into target area.
• ETL tasks related to Hierarchies & Aggregates are created.
• Used transformations like “Source Qualifier”, “Expression”,” Update Strategy”,” Look up”. etc.
• Configure Custom Workflows.
• Custom incremental mechanism applied to non-application data.
• Performance tuning done to all jobs.
• Full mode / incremental migration is done across different instances.
• All Informatica tasks are configured.
• Configured DAC for OBIEE Financial Analytics.
• Applied custom incremental mechanism that controls the data set.
• New Subject Areas created.
• Analyze Execution Plan.
• Tested execution Plan in both Incremental and Full Mode.
• Parallel processing the ETL tasks that belong to same task order.
• Performance tuning is achieved.
• Exported the DAC repository in full / incremental mode (Logical, System & Run).

Environment: Oracle BIEE 10g, Siebel 7.9.5 Analytics - eClinical and Clinical Trials Analytics, Informatica 8.6, Oracle 10g, Windows XP.

Confidential

OBIEE Developer

Responsibilities:

• Worked on file loading process using UNIX.
• Used the tools CONTROL-M to schedule the tables.
• Worked on harvest which is used to import and export the database files into the servers.
• Developed custom SDE mappings that tapped to source systems and load staging area.
• Developed custom SIL mappings to load data from the staging into target area.
• Used transformations like “Source Qualifier”, “Expression”,” Update Strategy”,” Look up” etc.
• Configured Physical layer, Business Model Layer and Presentation Layer of the repository.
• Renamed the components as per business terminology.
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other various features to meet the business requirements.
• Created Repository, system and non-system session variable and initialization blocks for various reporting needs.
• Created role based dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts.

Environment: OBIEE 10g, UNIX, Control-M Server, Oracle 10g, Informatica 8.6, Windows XP.