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 / NJ

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.