SUMMARY

• Shiva has over 8 years of proven skills in complete lifecycle of Design, Analysis, Development, and Implementation of Business Intelligence with Star and Snow flake Schemas using OBIEE, OBIA and Informatica.
• Experienced in Data Analysis, Identification of dimensions, Facts, Measures and Hierarchies.
• Extensive experience in providing end-to-end BI solution by dimensional modeling design, Logical/Physical models, building/configuring RPD, Answers, Delivers / iBots, creating reports / Dashboards, Cache management, and setting up Security using LDAP Authentication and Basic RPD Authentication.
• Proficient in working on production and development environment in different RDBMS (in Oracle 9i/10g, SQL Server) and strong troubleshooting skills.
• Extensive experience in business process reconciliation, design, configuration, testing, quality analysis and production support.
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers and developers across multiple disciplines.

EDUCATION

Bachelor in Computer Sciences

TECHNICAL SKILLS

Reporting Tools : OBIEE 10.1.3.4.1/Siebel Analytics 7.x, Presentation Services/Siebel Analytics Web, Siebel Answers, Dashboards, i-BOT's
Data warehouse Tool : Informatica Power Center/Power Mart 6.2/7.x, SQL*Loader
Relational Databases : Oracle 8i/9i/10g/11g
Database Languages : SQL, PL/SQL, UNIX
Operating Systems : Windows XP/2000/NT, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, MN Apr '10 - Till Date
OBIEE Sr.Consultant/Lead
OBIEE Platform Solutions was implemented for providing interactive Dashboard access to strategic business information on Sales, Finance and top of the house from the company-wide data warehouse analytical information in yearly growth at Imation. Implemented OBIA for several analytical modules like Order Management, Procurement and Supply chain, HR , Inventory and Finance

Responsibilities:

• Interacted with functional & technical leads, SME's and other business groups to identify, analyze, and document business requirements.
• Designed and implemented custom business intelligence solutions along with the pre-built solutions (Metadata and Dashboards/Reports).
• Developed Metadata Repository (.rpd) with multiple business layers using complex joins, presentation catalogs with access validations and external table security repository and repository migration.
• Designed and developed many Smart Works Dashboards/Reports that are Dynamic & Interactive with intuitive drilldowns, drill-across & flash-based drillable charts (bar-charts, pie-charts, radars, and bubble-charts), Capabilities split reports for summary & details information, and local & global filters and cache monitor using Siebel Analytical Web.
• Performed the Security management for users, groups and web-groups using the various authentication systems.
• Enhance performance by requesting Aggregate tables, Indexes and managing Cache after Benchmarking performance tuning strategies with business model-level calculations versus database level pre-computations and aggregations.
• Life-cycle support for migration efforts from development to QA to production analytics
• Involvement with ETL (Extract-Transform-Load) development team to communicate the specification for the required dimensional, aggregate and indexed data tables
• Development of many complex Informatica mappings and mapplets to build key interfaces using transformations and reusable transformation units (Update Strategy, Filter, Router, Expression, Lookup, Aggregator) for loading data into Data Warehouse
• Involved in upgrade from 10g to 11g

Environment: Oracle BIEE 11.1.1.5, OBIA 7.9.6.3, Informatica Power Center 9.1, Oracle 11g, Linux

Confidential, MI June '09 - Mar '10
OBIEE Consultant / Analyst
Vehicle Fleet Management (VRM) is an application for Master leasing. VRM has been developed for the tasks of buying and selling vehicles, leasing vehicles, maintenance control, administration, accident management and vehicle disposal.

Responsibilities:

• Gathered and analyzed requirements from the business users and wrote functional documents and technical specifications
• Designed Metadata repository (.rpd) in the Administration Tool by importing metadata from data marts
• Defined dimensions and facts in the repository according to the business entities in the Administration Tool
• Designed reports in Answers and published them in dashboards as per the user requirements
• Used appropriate filters, column filters, prompts, dashboard prompts and calculations in reports
• Created reports in different views as Pivot Table view, Table View, Ticker view and selector views
• Worked on administration tool to create users, user groups, set permissions to the user groups and assign users groups to the users
• Involved in developing ETL processes, Informatica Mappings, Sessions, Workflows and Mapplets using various Transformations (Joiner, Aggregate, Lookup, Filter and Router Transformations in Mappings.)
• Identified gaps and fed back data requirements to other source systems. Identified data sources, extension columns, OBIEE OLTP tables, Fields and mapped them to staging tables and ultimately to OLAP physical layer
• Tuned the OLAP database including techniques at the file systems and table spaces, placement of aggregate tables and bit-mapped join indexes, to maximize I/O and optimize performance
• Worked very closely with development activities with respect to configuration, scripting (e script) and building custom business services and workflows to automate business processes
• Trained end users to build Ad Hoc Reports using OBIEE Analytics

Environment: Oracle BIEE 10.1.3.4.1, Informatica Power Center 8.1, Oracle 10g, Windows 2003 Server

Confidential, Wilmington, DE Aug '07 - May '09
OBIEE Consultant/Technical Analyst
The OBIEE Platform Solutions was implemented for providing interactive Dashboard access to strategic business information from the company-wide data warehouse analytical information assets in retail finance at First Bank, a nation-wide leading financial services company. The project involved upgrading Siebel 7.8.2 to OBIEE 10.1.3.2.0. Implemented for several analytical modules like HR and Finance

Responsibilities:

• Upgrade from Siebel Analytics 7.8.2 to OBIEE 10.1.3.2.0
• Worked closely with the business team to assure all business requirements and application objectives are met
• Translated the business requirements into conceptual and detailed technical design
• Supported on-shore and off-shore Development teams and monitored their Analytics Development
• Developed OBIEE Metadata repository (.rpd) that consisted of Physical layer, business model and Mapping layer with Aggregates, Dimensions and time Series objects, and presentation Layer
• Involved in designing and development of building Physical Layer, Business model and presentation layer in Administration Tool
• Involved in Generation, maintenance of Design and Development Documentation
• Designed reports and dashboards in OBIEE Answers as per the user requirements
• Configured Interactive Dashboards with drill-down capabilities using global and local Filters
• Worked on different Views like Ticker, Narrative, Legend, Pivot Table view as per the requirements
• Used filters, column filters, prompts and dashboard prompts in the reports to make it simple
• Implemented Authentication and Authorization privileges for different user groups in Administration Tool
• Involved in creating reusable and non-reusable Mappings and Mapplets using Filters, Aggregators, Lookups, Expression Aggregator, Sequence generator, Joiner and Update Strategy Transformations
• Involved in the Development of Custom Mappings, Sessions and Workflows using Informatica
• Managed OLAP databases in development, test, staging and Production Environments
• Implemented best practices for efficient query processing
• Trained end users to build Ad Hoc Reports using OBI Analytics

Environment: OBIEE 10.1.3.3.0, Siebel Analytics 7.8.5, Informatica Power Center 7.1.2, Oracle 10g, Windows 2003 Server and Linux

Confidential, Houston, Texas Feb '06 - Jul '07
Siebel Analytics Developer / Analyst
The Sales Relationship Management is a product comprised of Sales Process Builder, Sales Champion, Sales Integration Platform and Sales Warehouse. Sales Warehouse was to implement a Centralized database that collects and organizes opportunity data to provide a single source of integrated and historical data for the purpose of end user reporting, analysis and decision support. Implemented several

Responsibilities:

• Involved in life cycle development in Siebel Analytics 7.8.5
• Involved in Installation, configuration, and administration of Siebel Analytics Server, Siebel Analytics Repository, DAC client and Server
• Created new subject area in Logistic department as per the business requirements
• Created new dashboard which is only visible to users of the corporation
• Created and scheduled iBots for delivering personalized reports to users
• Designed Intelligent Dashboards for different user groups to view updated KPIs
• Developed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative and Nested reports in Answers
• Worked on Siebel Analytics Server Administration (Setting up a repository, Administering the Query Environment, Scheduler, Query Caching)
• Performed complex Siebel Analytics configuration involving report generation from OLTP and OLAP databases systems
• Performed extensive debugging on existing ETL routines and repository(.rpd) layers
• Created detailed filters in repository (.rpd) to implement position based visibility
• Designed and modeled custom OLAP Subject Areas using dimensional modeling techniques
• Perform Administrative tasks in Siebel Analytics such as granting privileges, creation of custom, complex and summary folders, linking folders for Drill-to detail and configuration
• Created Design and Development Documents for creation of new subject areas/customization
• Involved in Testing Phase before deploying into production environment
• Granted users with appropriate access to the subject areas and reports
• Trained user to create ad hoc reports and provided necessary user and technical documentation

Environment: Siebel Analytics 7.8.5, Informatica Power Center 7.1.2, Oracle 9i, Windows 2003 Server

Confidential, India Jul '04 - Jan '06
Oracle Developer
This project is a form based application that facilitates employee details like salary calculation, attendance information, loans information, allowance information, dividends information etc. A number of reports have been written to provide all project related information.

Responsibilities:

• Initialized system study and design
• Normalized the database to remove data redundancy
• Prepare Entity relationship diagrams
• Extensively worked on ER diagrams to map existing database elements to 8i database elements
• Developed PL/SQL programs for converting data from CSM to Installed Base and Service Contracts Modules
• Involved in writing PL/SQL Triggers, Procedures, Functions and packages
• Developed various business and ad-hoc reports
• Involved in development, testing, implementation and training
• Involved in SQL Tuning
• Created, modified database objects
• Wrote Technical Design Document, Developed, Tested and Trained Users
• Created data flows diagrams and entity relationship diagrams using Designer

Environment: Oracle 9i, Forms 4.x, Reports 2.x, Windows 2003 Server