PROFILE

• Nine plus Years of Total IT Experience
• Six plus Years of OBIEE/ Siebel Analytics Experience

Summary

• Over Nine years of extensive experience in IT with Six years in Oracle BI Apps (Financial, Sales, Supply Chain, HR, Projects and Order Management), OBIEE 11.1.1.6/10.1.3.x/Siebel Analytics 7.x, which include, Design and Development of OBIEE repositories, and building OBIEE Dashboards/Reports, iBots, Oracle BI publisher and Delivers.
• Experience in designing Data model i.e. Star Schemas/Snow Flake Schemas.
• Experience in Administering Weblogic 10.3.5 for OBIEE11g.
• Experience in Implementing Security using Roles in OBIEE11g.
• Experience in Administering DAC 10.1.3.4 and Informatica 9.0.1
• Extensive experience in working with OBIEE Answers, Delivers, iBots, and Intelligent Dashboards
• Strong experience in creating Logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data, and Repository Variables.
• Extensive experience in using OBI Answers for creating different Requests, Filters, Views, Charts, Interactive Dashboards with page and dashboard Prompts.
• Experience in security tasks like creating user groups, users and managing users by setting up their privileges and profiles.
• Experience in configuring interactive Dashboards with drill-down, drill across capabilities using Filters and Dashboard Prompts, Siebel Security Setup (groups, access privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports) and guided navigation links.
• Expertise in accomplishing the performance using materialized views, aggregate navigation, and partitioning and cache management techniques.
• Expertise in fine tuning reports by using view selector, column selector, is prompted, drill down- drill through analysis, creating master/detail reports, using database, numeric, date and time functions, etc, where ever necessary to increase performance.
• Experience in using Data Warehouse Administration Console (DAC 10.1.3.4) for scheduling and executing Incremental ETL loads.
• Experience in Scripting Language such as PHP.
• Good Knowledge on ODI (Oracle Data Integrator).
• Experience with Oracle OLAP to produce analytic measures, including time-series calculations, financial models, forecasts, allocations, regressions,
• Experienced in Design, Development, Implementation, Testing and Maintenance of Oracle Databases, ETL Processes and Database Deliverables.
• Experience in implementing Security at object level and data level using Repository Variables, Initialization Blocks, and Session Variables.
• Created, Enhanced and troubleshoot reports on BI Publisher.
• Expertise in developing Informatica Mappings/Mapplets using various Transformations (Filter, Expressions, Router, Aggregative, Lookups, Update Strategy) and also in creating Workflows.
• Expert in writing complex SQL queries, creating different PL/SQL Objects, Fine Tuning the code, and also in using SQL*Loader for loading data into Data Warehouse/Data Mart.

EDUCATION

• BACHELOR OF ENGINEERING

TECHNICAL SKILLS

OBIEE

OBIEE 11g(11.1.1.6)/10.1.3.x, Siebel Analytics 7.5/7.7/7.8,OBIA Apps 7.9.6.3, BI Publisher, Oracle OLAP

ETL

Informatica Power center 7.x, 8.x, 9.x DAC 10.1.3.4

Database

Oracle 11g/10g/9i/8i, SQL Server 2008/2005/2000, MS Access

Languages

SQL, PL/SQL, T-SQL, C, C++

Oracle Tools/Utilities

SQL*Loader, SQL Developer, Toad, SQL PLUS

Operating System

Windows 98/2000/2003, Win XP/7, UNIX, Linux

Web Technologies

HTML, XML

PROFESSIONAL EXPERIENCE

CONFIDENTIAL VIENNA, VA May10’ - Present
Senior OBIEE Admin/ Developer, Informatica and DAC 
CONFIDENTIAL provides a full lifecycle of secure, innovative information technology solutions to the federal government. We help customers solve their toughest mission-critical IT challenges, enabling them to concentrate their resources on their core mission. As one of the largest IT solutions providers supporting the U.S. Department of Defense (DOD), CONFIDENTIAL is the ideal partner for leading intelligence, military, and geospatial agencies with highly-secure IT requirements.

Responsibilities:

• Involved in Architecting OBIEE, OBIAPS Environment for the client.
• Installed and Configured OBIEE11g (11.1.1.6) server on UNIX server.
• Upgraded Discoverer and OBIEE 10g Reports to OBIEE 11g (11.1.1.6).
• Administered Weblogic for OBIEE.
• Installed OBIAPS 7.9.6.3
• Configured OBIAPS (HR Analytics ,Project Analytics, Financial Analytics)
• Configured OBIAPS to sources Such as EBS 11i and R12
• Created Repositories, Physical Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration Tool.
• Installed and configured Informatica 9.0.1 for full loads and Incremental loads daily.
• Installed and Configured DAC 10.1.3.4.1 on UNIX server.
• Customized Informatica mappings in OBIAPS according to the client requirement.
• Migrating Repository and Web Catalog files from Development to Test and Production environment.
• Involved in taking backups of Repository and Web Catalog files.
• Managed Security in Admin Tool like Data level and Object level.
• Involved in designing Data Modeling i.e. Facts/Dimension in Star Schemas, Snow Flake Schemas
• Customized Out of the Box reports in 7.9.6 .3 BI apps.
• Created Repositories, Physical Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration Tool.
• Participated in the walkthroughs of the data models, ETL specifications, identification of dimensional attributes Facts and Star Schema to fulfill requirements.
• Created Dimensions in the Business Model and Mapping Layer.
• Developed different Reports, Filters and Dashboards.
• Security for OBIEE11g using EBS Authentication (Cookie based) has been implemented.
• Using BI Publisher developed reports in MS Word using integration feature.
• Worked on Different Templates in BI Publisher.
• Involved in merging changes of OBIEE Repository and WebCat from Development to Test and Production
• Involved in Unit Testing of Reports.
• Involved in Performance tuning of queries.
• Involved in taking backups of Repository and WebCat files.
• Migrating Repository and WebCat files from Development to Test and Production environment.

Environment: OBIEE 11.1.1.6,Weblogic10.3.5,Windows XP, UNIX, Oracle 10/11g, OBI Apps 7.9.6.3, , BI Publisher, Informatica 9.0.1 , DAC, Oracle EBS 11i,R12 Financials(General Ledger, Receivable, Payables), HR and Projects data.

Confidential, CA Dec’ 09 – Apr’ 10
OBIEE Admin/ Developer
Confidential builds niche products into global lifestyle brands by designing and marketing innovative, functional and fashion-oriented footwear, developed for both high performance outdoor activities and everyday casual lifestyle use.

Responsibilities:

• Created New Sales and Supply Chain OBIEE Reports as per the requirement.
• Created Users, Groups and giving the permissions in OBIEE Administration Tool and verifying the Permissions of the users in Presentation services.
• Coordinated the OBIEE .rpd and Web Catalog objects migration from QA to Production environment.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Created the physical and complex joins in the Physical and Business layers for the new design being implemented.
• Customized the repository and created new requests using Answers.
• Re-modeled Metadata repository – Physical layer, Business Model & Mapping layer and Presentation Layer.
• Built Customized Reports and Dashboards in OBI Apps.
• Installed and Configured Informatica Power Center / DAC for OBIA Supply Chain Analytics on Dev Environment.
• Created dimension hierarchies & level based measures in BMM layer based on requirements.
• Developed Month Ago, Year Ago measures for comparison of sales and used Time Series Functions extensively.
• Developed several dashboards and reports which are used by managers to identify most profitable customers and analyze revenue trends by customer to identify opportunity/risk.
• Used Filters (global and local) and provided customized Prompts to avoid excessive data showing up in the reports.
• Created Global/Local Prompts, Narrative Views, Filters, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Configured Intelligence dashboards by including embedded content such as links/images & HTML objects.
• Created Aggregated Tables and configured the content in Business Model Layer to use the Aggregate tables for better performance.
• Implemented security by creating users & groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associated catalog objects and Web modules with the created groups.
• Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to subscribed users.
• Created pivot table requests allowing managers to analyze the business in different perspectives.
• Installed BI Publisher, Publisher Desktop, integrated with OBIEE to develop template. Used MS OFFICE Add-ons in reports, Dashboards and answers.
• Configured and Scheduled BI Publisher scheduler for report bursting to File and email locations and used advanced reporting features such as Online Analyzer, Excel Analyzer and report security options.
• Worked on Oracle BI Publisher and provided the capability to download the reports in the user defined formats.
• Implemented Time Comparison and Calculation measures in the business model using Time series Functions.
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.
• Extensively used Catalog Manager and Job Manager.

Environment: OBIEE 10.1.3.4/10.1.3.3, OracleBI Apps( Inventory, Sales, Bill of Material, Order fulfillment, Shipping) Oracle 10g/9i, Informatica 8.1.1, DAC, Oracle BI Publisher, Toad, PL/SQL, SQL, SQL * Loader, Windows 2000, UNIX, .

Confidential, WashingtonD.C. Jan’ 07- Nov’ 09
Siebel Analytics Developer

Confidential is the world’s # 1 language – learning software. Confidential implemented the Sales and Financial Dashboards. Its Sales data is imported from SalesForce.com and License Server, while the Finance is sourced from the Oracle EBS. This project involved implementing multiple dashboards using the pre-built (OTB) application for Finance (GL, AP, AR, Profitability, OM and OF) and a custom dashboard for SalesForce.com and License Server.

Responsibilities:

• Coordinated in the client installations of Siebel Analytics.
• Worked closely with Business Analyst, discussed and gathered the Analytics requirements and created the Business Model using Star schemas.
• Used Siebel Analytics Administration Tool for customizing and modifying the physical, business and presentation layers of metadata repository (.rpd).
• Worked Extensively on Siebel Answers to create the reports as per the client requirements.
• Configured Intelligence dashboards by adding included and embedded content such as links/images, HTML objects and folders.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, answers.
• Created iBots and Delivers to send Alert messages to subscribed users.
• Created Level Based Measures, new logical columns and enforced conditions on the columns in the logical layer for query optimization.
• Responsible for building effective Cache Management strategy by using Event Polling Tables and Siebel Analytics ODBC Call Functions to purge the cache and iBots to seed the cache.
• Implemented Multi-user environment on Siebel Analytics repository
• Worked using DAC to perform scheduling and executing incremental loads.
• Worked in ETL process using Informatica for various transactions and loading data from Flat Files and Relational Database.
• Assisted in creating Reusable and Non-Reusable Mappings and Mapplets using Filters, Aggregator, Lookups, Expression Aggregator, Sequence generator, sorter, Joiner and Update Strategy Transformation.
• Created Sessions and Worklets in Workflow manager using events tasks e.g. e-mails.
• Worked for performance tuning by finding out the bottlenecks in various mappings.

Environment: Siebel Analytics, Informatica, DAC, Oracle 9i, PL/SQL, XML, UNIX, Erwin4.0.

Confidential Jun’ 05 – Dec’ 06
Informatica Consultant

Responsibilities:

• Analyzed the business requirements and framing the business logic for the ETL process.
• Extensively used ETL to load data from both fixed width as well as Delimited Flat files.
• Validated data, Error reports generated with Error messages.
• Worked extensively on different types of transformations like normalizes, expression, union, filter, aggregator, update strategy, lookup, stored procedure, sequence generator and joiner.
• Designed and Developed complex mappings, reusable Transformations for ETL using Informatica Power Center 7.1/6.2
• Developing and testing all the Informatica mappings involving complex Router, lookups and update strategies.
• Created workflows and sessions to run the mappings.
• Implemented variables and parameters in the mappings.
• Setting up batches and sessions to schedule the loads at required frequency using Power center workflow manager.
• Generated completion messages and status reports using workflow manager. 
  Working on Dimension as well as Fact tables, developed mappings and loaded data on to the relational database.
• Extensively worked in performance tuning of programs, ETL procedures and processes. Also used debugger to troubleshoot logical errors.
• Involved in writing ETL specifications and unit test plans for the mappings. 
  Performed Developer testing, Functional testing, Unit testing for the Informatica mappings.

Environment: Informatica PowerCenter 7.1/6.2, Oracle, SQL, SQL*Plus, PL/SQL, DB2, Windows NT, UNIX.

Confidential Apr’ 03– May’ 05
Oracle Developer

Confidential manufactures a wide range of products for use in India and around the world. These include engines and power generation, quarry and construction trucks, mining trucks, backhoe loaders, wheel loaders and a wide variety of related components 
Responsibilities:

• Performed database design and development.
• Involved in analysis, design and development of the system.
• Provided back-end support for customized Forms like customer and supplier maintenance, bill, receipt, letter of credit, invoice, debit and credit notes.
• Developed PL/SQL Packages to monitor revenue earnings and expenses and to maintain the general ledger of the organization.
• Developed stored procedures and functions using PL/SQL for complex updates and audit trails.
• Performance tuning of SQL Queries ,checking the most expensive queries using explain plan
• Wrote database triggers for audit and data validation.
• Designed the Entity-Relationship model and normalized database.
• Conducted re-sizing of data files, managed table spaces and data files.

Environment: Oracle, PL/SQL, UNIX, Windows NT.