SUMMARY

• Over 8+ years of progressive expertise in design, configuration, development, testing and implementation of Data warehousing and Business Intelligence Applications.
• Deep understanding of Information Technology Software Development Life Cycle (SDLC) methodology and project management principles.
• Experience in Informatica Power Center, Oracle BI Apps that include OBIEE/Siebel Analytics, ETL Tools and DAC in Financial, Pharmaceutical, Insurance and Sales & Marketing domains.
• Extensive Data Modeling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables, Physical and logical data modeling.
• Design, Development and Documentation of the ETL strategy to populate the Data Warehouse from the various source systems.
• In depth knowledge on Data Mapping, Data Conversion, and Data Cleansing.
• Experience in performance tuning of Informatica mappings and sessions, Siebel Analytics Reports and SQL query.
• Extensive experience in Siebel Analytics/OBIEE repository for both Stand - Alone and Integrated Siebel Analytics implementations.
• Experience with and Knowledge of Configuring Oracle EBS, Oracle CRM, PeopleSoft ERP for Oracle BI Applications.
• Executed OBIEE administrative tasks such as OBIEE server installation, migration and user maintenance.
• Excellent proficiency in data and object level Security in Siebel Analytics/OBIEE.
• Extensive experience in customizing Siebel Analytics/OBIEE dashboards and reports.
• Extensive experience in Repository and Reports performance tuning.
• Proficient with BI Publisher reports and using various templates to publish the reports as per user requirements.
• Worked on the Agile methodology for last 1 year for different projects.
• Worked on Data warehouse Application Console (DAC) Architecture.
• Worked in extracting data from Siebel CRM, Hyperion, Oracle EBS, OLTP, flat files and integration and loading data to OLAP systems.
• Configured Oracle SCM Applications in INV, OM and PO modules in the Test & Production Instance
• Good Knowledge on Siebel EIM to import/export data between legacy and Siebel Databases.
• Performed unit, integration and system testing for all components in Siebel Analytics.
• Extensive experience using Oracle, Teradata, PL/SQL, Toad, SQL Assistant.
• Enthusiastic team player, with excellent communication and interpersonal skills.

TECHNICAL SKILLS

Data Warehouse: Informatica 5.1, SQL Loader.

Business Intelligence: Siebel Analytics 7.8.5, OBIEE 10g and 11g, Siebel Answers/Delivers

Databases: SQL Server 2000, Oracle 9i/10g, 11i, Teradata, Siebel CRM, V2R5, MS Access.

Operating Systems: Windows 2000, XP, HP-UX, Linux and Solaris.

Languages: Java Script, VB Script, UNIX Scripting, PL/SQL.

Software: Autosys, MS Project, Office, Visio

PROFESSIONAL EXPERIENCE

Confidential, NC

OBIEE / BI Publisher Technical Lead

Responsibilities:

• Successfully managed the 7 people team as a team lead.
• Followed the complete Agile methodology to develop the FD404 project.
• Gathered the requirement from various business teams and architected and designed a BI Solution for the financial department.
• Worked in various projects in Confidential Fee Disclosure (FD404 and FD408), Erisa Enhancemnets, Loan default Update, and Fee Disclosure 2012 and 11g Upgrade.
• Design and developed the OBI repository services. Created different level of hierarchies in RPD.
• Created the interactive dashboard and worked on creating the OBI workflow and write back function.
• Created the file movement notification on the dashboard to show which stage the reports are in (Ready, In process, Completed).
• WroteCustom SQL Codesfor the reports.
• CreatedCatalog Groupsand setpermissionsfor items in thepresentation catalogandprivilegesand rightsto users and groups.
• Developed different kinds ofReports(pivots, charts, tabular) using global and local Filters.
• Created proactive agentsiBotsand interactive Dashboards to alert the financial team about business changes.
• EnhancedQuery performance, byanalyzing & modifyingSQL QueryandFilters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution.
• Managed OracleDelivers,Scheduler & iBots.
• Worked on BI Publisher reports, XML creation and generation, designing of custom RTF template.
• ImplementedBIPublisherand created bursting reports usingBIPublisher.
• Successfully created the backend tables for the BI Publisher bursting.
• Each bursting will generate 95 different reports for each plan.
• Worked closely with Java team to setup Autosys Jobs for report generation.
• Upgraded my entire TIAA- CREF projects (FD404, FD408, Loan default Update and ERISA) to OBIEE11g environment.
• Trained End Users and Pilot Users aboutOBIEE Tools.

Environment: OBIEE11g (11.6.X.X), OBIEE 10g, BIPublisher, Datastage, Toad, Linux

Confidential, DC

Informatica / OBIEE Consultant

Responsibilities:

• Involved in analysis and requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Designed, developed and maintained the Informatica mapping for ETL.
• Business analysis and data model design for new tables related to ETL.
• Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Siebel/Oracle BI Analytics platform.
• Worked on the detailed design of the reports/dashboards and data model.
• Involved in the installation and configuration of Informatica and OBIEE 10.1.3.4.1 in the windows as well as the Linux environment.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, and event poll strategies in the repository.
• Enhance performance by creating Aggregate tables, Indexes and managing Cache.
• Worked on BI publisher to deliver the reports.
• Worked on Integration of Siebel CRM with OBIEE.
• Worked on TOAD to create the tables and load the data in Database.
• Modified some of the existing reports and dashboards, and fixing some of the issues related to performance, data quality etc., during production support.

Environment: OBIEE 10g, Informatica Power Center 8.6.1, Siebel CRM, Oracle 11g, Windows 2003 server, Linux.

Confidential, NJ

OBIEE Consultant

Responsibilities:

• Worked closely with the business users and developers to make sure that business requirements are correctly translated into database schemas and ultimately into the application.
• Interacted with end users and developers to validate the data model.
• Designed, developed and maintained the Informatica mapping for ETL.
• Business analysis and data model design for new tables related to ETL.
• Requirement validation of the reports and drill downs with business users.
• Analysis of existing OLTP system and Identification of required dimensions and facts from the Database.
• Creation and Customization of the OBIEE Repository.
• Responsible for creating users and maintaining visibility privileges using Analytics administration on the repository side.
• Expert in cache management, Repository migration, data level and object level security in OBIEE Analytics.
• Worked on repository and session variables.
• Created materialized views and aggregates to improve performance.
• Customized reporting with OBIEE Answers and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Configured Oracle SCM Applications in INV, OM and PO modules in the Test & Production Instance.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Created user level security for intelligence dashboards based on Business Requirement.
• Performed Data Validation of data in the reports and dashboards.
• Worked on evaluation of Oracle BI Enterprise Edition and its new utilities including BI Server, Answers, Delivers and Publisher.
• Documented the design for intuitive understanding and future reference.
• Performed production support for the project.

Environment: OBIEE 10.1.3.4.1 , Oracle 10g & 11g, SCM, Windows XP, BI Publisher, DAC.

Confidential, Milpitas, CA

OBIEE Consultant

Responsibilities:

• Architected and designed a BI Solution for the finance department at Cisco sourcing data from Oracle, Teradata, PeopleSoft and Hyperion.
• Configuring the Application according to the Client’s need at Data and Business Logic Levels.
• Organization setup and implementation which includes setting up List of values, users, automated activity creation, email templates and position hierarchy.
• Implemented a unique solution enabling the users to pick weekly, monthly or quarterly reports by using a drop down on the dashboard. (This was done through a combination of presentation variables and guided navigation).
• Configured the BI server and the presentation in a clustered environment.
• Implemented multiple levels of data security based of the product and Sales Hierarchy. The solution also had security based on levels in the hierarchy as well.
• Heavily enhanced the user experience on the dashboards by creating a tab under tab navigation. This was done with java scripting.
• Installing the OBIEE Products and Deployments to Production.
• Design and development OBIEE Analytics reports, OBIEE repository, metadata as per Business requirement.
• Analysis and Design the Key reports to our Business.
• Configured OBIEE RPD (Physical Layer, Logical Layer, Presentation Layer)
• Interact with System Engineering team to design - Facts & Dimensions for Repository.
• Gathered business data to design the business model.
• Defined initial blocks and created repository variables to be used in the expressions mapped logical columns in BMM layer to physical columns in the physical layer.
• Worked extensively on the physical layer, business layer and presentation layer of the repository in the Siebel Analytics Administration Tool.
• Designed RPD based on business requirements followed design best practices for RPD design to achieve Company standards.
• Modeled physical layer/logical layer for SCDs and fact/dimension extension tables.
• Customized the presentation catalog and created a personalized view of the data for various employees.
• RPD design Review with Siebel Systems Expert Services
• Designed reports based on the business requirements.
• Designed Intelligence Dashboards based on the UI Experts Doc.
• To achieve dynamic display things JavaScript is used.
• Set up Delivers to configure IBots based on the threshold value to the users.
• Involved in creation of materialized views to achieve business requirement.

Environment: OBIEE 10.1.3.3 & 10.1.3.4.1 OBIEE 10.1.3.3.2 , DAC, Siebel CRM, Windows XP/ 2003.