Ranganadh N

Looking only Corp to Corp

Employer: Libsys, Inc

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

TIAA-CREF, NC / NJ

July 2011 - Till date

OBIEE / BI Publisher Technical Lead

Project Description: "Teachers Insurance and Annuity Association - College

Retirement Equities Fund" (TIAA-CREF). TIAA-CREF is a Fortune 100 financial

services company and a leading provider of retirement benefits nationwide.

TIAA-CREF is a leading financial services organization with $440.7 billion

in combined assets under management. The firm is a leader in helping those

in the academic, medical, cultural, governmental and research fields plan

for and live in retirement.

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 TIAA-CREF 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).

. Wrote Custom SQL Codes for the reports.

. Created Catalog Groups and set permissions for items in

the presentation catalog and privileges and rights to users and

groups.

. Developed different kinds of Reports (pivots, charts, tabular) using

global and local Filters.

. Created proactive agents iBots and interactive Dashboards to alert the

financial team about business changes.

. Enhanced Query performance, by analyzing & modifying SQL

Query and Filters, for all the reports and dashboard prompts, to

minimize the delay in Physical Query Execution.

. Managed Oracle Delivers, Scheduler & iBots.

. Worked on BI Publisher reports, XML creation and generation, designing

of custom RTF template.

. Implemented BI Publisher and created bursting reports

using BI Publisher.

. 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 about OBIEE Tools.

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

Linux

MBDA, Department of Commerce (Federal Government), DC Dec

2010 - June 2011

Informatica / OBIEE Consultant

Project Description: MBDA, a part of the U.S. Department of Commerce is an

entrepreneurially focused organization committed to wealth creation in

minority communities. The Agency's mission is to actively promote the

growth and competitiveness of large, medium and small minority business

enterprises (MBEs)

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.

BD (Becton, Dickinson and Company), NJ

Aug 2009 - Dec 2010

OBIEE Consultant

Project Description: BD (Becton, Dickinson and Company) is a global medical

technology company. BD develops, manufactures and sells medical supplies,

devices, laboratory instruments, antibodies, reagents and diagnostic

products through its three segments: BD Medical, BD Diagnostics and BD

Biosciences. These company worldwide resources include approximately 75,000

employees, manufacturing facilities on five continents, and a discovery and

development of medical devices.

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.

Cisco Systems Inc, Milpitas, CA

June 2008 - Aug 2009

OBIEE Consultant

Project Description: Cisco is the worldwide leader in manufacturing of

wireless products. The goal of the project was to develop Business

Intelligence (BI) solutions for various work streams (e.g. Sales,

Marketing, Customer Care) by comparing and contrasting data from various

sources and then consolidating them at the report / dashboard level to the

managers Worldwide.

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.1OBIEE 10.1.3.3.2, DAC, Siebel CRM,

Windows XP/ 2003.

Maruti Udyog, Chennai, India. Feb 2006 to

June 2008

Siebel Analytics Developer

Environment: Informatica Power Center 5.1, Siebel Analytics 7.5, Siebel

OLTP 7.5, Oracle9i, UNIX, Windows 2000.

Life Insurance Corp, Hyderabad, India June

2005 to Feb 2006

Business Analyst

Environment: Oracle8i/9i, SQL, PL/SQL, SQL*Loader, Oracle D2K, Sun Solaris

Education

. B-Tech from Nagarjuna University, India.

Contact this candidate