Professional Summary

• Over Six years of IT experience including implementation of Siebel Analytics, Oracle Business Intelligence, ETL Tools and RDBMS projects.
• Strong experience in OBIEE 11.1.1.5/10.1.3.x, Siebel Analytics 7.x, which includes design and development of OBIEE repositories at three levels (Physical Layer, Business Model andPresentation Layer).
• Worked on Oracle Discoverer 10g/11g Administrator and Answers.
• Experience with Noetix Analytics.
• Expertise in converting and using Oracle BI Apps pre-build rpd’s (Financial, Supply Chain and Order Management) according to business requirements.
• Experience inconfiguring Security Settings (groups, roles, access/query/report privileges) and scheduling iBots/Agents for OBIEE 10g and OBIEE 11g.
• Experience with weblogic server and Enterprise manager in OBIEE 11g.
• Proficient in the Design and customization of BI Answers/Analysis, Reports, Dashboards, Oracle Delivers.
• Highly experienced with repository development, configured metadata objects (Subject Area, Table and Column) and Web Catalog objects (Dashboards, Pages, Folders, Reports).
• Expertise in fine tuning reports by using View Selector, Column Selector, is prompted, where ever necessary to increase performance.
• Expertise in developing Logical Tables and Columns, Dimensional Hierarchies, Level Based Measures, Time series data and Repository Variables.
• Created reports using BI Publisher.
• Proficient in accomplishing the performance using aggregate navigation, partitioning and Cache management techniques.
• Familiarity with the Ralph Kimball Approach to data warehousing.
• Experience in design and implementation using Informatica (Power Center) Designer, Repository Manager and Workflow/Server Manager.
• Good experience in designing Informatica logic for SDE, Transformations, Workflows, DAC Subject areas and Execution plans.
• Good Analytical, logical, communication & problem solving skills.
• Can work independently and as a team player.

Technical summary

BI Tool OBIEE 11.1.1.5/10.1.3.3/10.1.3.4, Discoverer 10g, Siebel Analytics 7.8.3, OBIA 7.9.5/7.9.6, Noetix Analytics

ETL Tools\ Informatica Power center 7.x/8.x, DAC

DBMS/RDBMS Oracle 9i/10g/11g , SQL Server 2005/2008

Languages C#, SQL, PL/SQL

Oracle Tools/Utilities SQL developer, TOAD, SQL* PLUS, SQL Developer

Operating Systems Windows 98/2000/2003/XP, Win 7, Linux

Web Technologies ASP.NET, CSS, HTML, XML, JavaScript

Software Joomla, Visual Studio 2005/2008

Education

B.E Computer Engineering

PROFESSIONAL EXPERIENCE 

Confidential June 11 – Till Date
Sr. OBIEE Developer/Administrator
Reimplementation: R12
Responsibilities

• Worked closely with Project manager, Team lead and Users to do GAP analysis.
• Experience with Oracle Business Intelligence Enterprise Edition 11.1.1.5.
• Experience with Weblogic server and Fusion Middleware.
• Worked on Oracle Discoverer Administrator and Discoverer Answers.
• Re-developing all current Oracle Discoverer Finance and Publishing reports in OBIEE 11g.
• Extensively worked on developing Data model based on STAR schema concept using OBIEE 11g Administration Tool for current and future reporting requirement.
• Migrated current OBIEE 10g repository and web catalog to OBIEE 11g.
• Performed full repository and web catalog merge.
• Working on NOETIX analytics and NOETIX generator.
• Developed reports based on AR, AP, GL, CE, INV, WIP, BOM, PA module.
• Developing Finance reports in OBIEE 11g using NOETIX generated rpd file for FIN module.
• Developed new dimensions, facts and aggregate tables.
• Tuning OBIEE reports by using different performance improvement techniques.
• Created Complex Joins, Alias Tables and Views.
• Created dimensional hierarchies in BMM layer to query from multiple fact tables by defining aggregation content level in Fact LTS.
• Generated interactive and selective data reports (pivots, charts, tabular) using concepts such as filters, column selectors, prompts.
• Extensively used repository and presentation variables.
• Integrated OBIEE 11g security model with Oracle R12 EBS.
• Created Initialization blocks, Repository Variables and Session variables for Data level and User level security.
• Managed and provided Permissions for Reports and Dashboards in OBIEE Presentation Services Web Catalog.
• Unit testing all the reports for performance and data validation.

Environment: OBIEE 11.1.1.5/OBIEE 10.1.3.4, Discoverer 10g, Oracle 10g/11g, Noetix Analytics, Toad, SQL Developer, Linux, PL/SQL, AP,AR,GL,CE,PA,WIP,BOM,PO

Confidential Washington DC March 10- May 11
OBIEE Administrator/OBIEE Developer 
Blackboard works with clients to develop and implement technology that improves every aspect of education. Blackboard enables clients to engage more students in exciting new ways, reaching them on their terms and devices, keeping students informed, involved and collaborating together to build a better education experience.
Responsibilities

• Worked closely with Business Analysts in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements.
• Worked on developing the STAR model after identifying required data granularity level that exactly meets the user reporting requirements.
• Extensively worked on Oracle Business Intelligence Administration Tool.
• Used Hyperion Intelligence as a reporting tool.
• Developed reports for GL, AR, AP modules (Oracle Financial Analytics).
• Managed Security settings in OBIEE Administration Tool.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Developed new dimensions, facts and aggregate tables.
• Worked on BMM to create logical tables and defined the complex joins.
• Created dimensional hierarchies in BMM layer.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Worked on the Time Series Calculation and implemented time comparison.
• Responsible in creating Alias and configured repository with logical dimensional modeling using star schema.
• Performed Consistency Check and Global Consistency Check of the Business Model.
• Configured MUDE for OBIEE Tool.
• Designed Intelligence Dashboards and created Global Filters like Year, Quarter, Month, Product, and Distributor.
• Generated interactive and selective data reports (pivots, charts, tabular) using concepts such as filters, column selectors, global prompts and extensively used repository and presentation variables.
• Generated Drill down Reports, Charts, Summary Reports, Navigational Reports.
• Created customized dashboard prompts as per the business requirement.
• Migrated web catalog and RPD from DEV and PROD environments.
• Created iBots and Delivers to send Alert messages to subscribed users especially during Month end Reconciliation.
• Worked on Informatica power center 8.5/7.1.4 client tools.
• Used ETL to load data from wide range of source such as flat files and XML to ORACLE.
• Loaded the data having complex calculations using aggregator and router transformations.
• Developed training documents and on-line help docs for end users and trained them accordingly to business plan.

Environment: OBIEE 10.1.3.4, LINUX, TOAD 10.0, Oracle 11i, R12, AP, AR, GL, OBIA 7.9.6 – FI , Informatica Powercenter 8.6, DAC

Confidential Huntersville, NC March 09- March 10 
OBIEE Developer
SABIC Innovative Plastics is a world leader in providing engineering thermoplastic material solutions. It supplies information, technology, and advanced materials solutions to meet global customer needs.
Responsibilities:

• Involved in Analysis, Requirement gathering, function/technical specification, development, deploying and testing.
• Developed repository using Oracle BI EE 10.1.3.4.
• Worked on OBIA - Financial and Supply Chain and Order Management Analytics.
• Defined relationships in Physical layer and BMM layer.
• Identified Facts, Dimensions, and Hierarchies of the business model.
• Identified the granularity level of the business model based on the end user requirements.
• Worked extensively on OBIEE Answers and Dashboards to create the reports as per the client requirements. Used session and repository variables to control access and data. Used filters to restrict data.
• Created Complex Joins, Alias Tables and Views.
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance gains.
• Created multiple aggregated tables and setup aggregated navigation to enhance performance.
• Implemented Time comparison and calculation measures in the business model using Time series Wizard.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Created reports using BI Publisher.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Managed and provided Permissions for Reports and Dashboards in OBIEE Presentation Services Web Catalog.
• Involved in developing ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center.
• Involved in fine-tuning of Informatica Mappings.

Environment: OBIEE 10.1.3.4, BI Publisher, Oracle 10g, Informatica 8.1, Toad, Windows XP, PL/SQL, Oracle 11i , AR, AP, GL, OM, INV, OBI Apps (FI & SCM)

Confidential, Atlanta, GA Aug’08-Feb’09
Siebel Developer 
Home Depot is the world’s largest home improvement specialty retailer with stores in the USA, Canada, Mexico and China. In 2010 was ranked 29 in the fortune 500 list of companies.
Responsibilities:

• Gathered, analyzed, and identified the GAP of Business Reports Requirements.
• Created Siebel Analytics Repository at 3 layers i.e. Physical Layer, Business Model Mapping and Presentation Layer level.
• Developed many Reports using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Extensively used Siebel Delivers and iBots.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• Implemented security by creating roles, web groups, and external tables.
• Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
• Performed testing to validate reports and mappings.
• Involved in developing the Incremental ETL process.
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 7.1.
• Created mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and Update Strategy to store the data in target table.
• Extensively worked in fine-tuning of Informatica Mappings.
• Used different application development tools like TOAD (Oracle).

Environment: Windows XP, Linux, Siebel 7.8.4, Oracle 10g, SQL, PL\\SQL and TOAD

Confidential, Birmingham, AL Oct’06-June 08
Siebel Analytics Developer
Responsibilities:

• Evaluated business requirements against the Siebel CRM out-of-the-box capabilities and looked for opportunities to adapt the business needs to existing functionality.
• Presented functional and technical requirements information in group meetings
• Analyzed and recommended enhancements to Metadata Reporting in all 3 layers (Physical, Business and Presentation) for the financial data model.
• Enhanced existing Business Models & created customized Dashboards.
• Implemented measures & dimensions and organized the data into related subject areas.
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports)
• Configured iBots to deliver analytics.
• Imported List/Contact details by interfacing with the ETL team.
• Configured existing dashboards, metadata objects and report level security to set up position based functional dashboard access.
• Responsible for knowledge transfer/cross-training with other members of Siebel Application Development Staff.

Environment: Siebel Service Analytics 7.5,Siebel Marketing Analytics, Informatica Power Center 6.1, MS-SQL Server 2000, Windows 2003 Server

Confidential WI June’05-Sep’06

• Involved in Software Development Life cycle starting from requirements gathering and performed object oriented analysis and design to implementation & maintenance.
• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Worked on Slowly Changing Dimensions to update frequent data using lookup and update transformations.
• Implemented Join, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router Transformations.
• Used the SQL tables and records in transaction processing in the backend.

Environment: Informatica Power Center 7.1.4, TSQL,Oracle 10g, 9i, SQL, PL/SQL, SQL*Plus