Over seven years of Industrial Experience as IT professional with over Five Plus years of experience as Oracle BIEE Developer and experience in gathering Business Requirements , performing GAP Analysis, Design / Data Modeling, Development, Testing, Implementations and Documentation of various functionalities on different environments like Development ,BRK, Test environment, etc.

Overview

• Experience in Development of Siebel Analytics/OBIEE Repository Administration, and creating, modifying Intelligence Dashboards for integrated Siebel Analytics applications, using Siebel Answers
• Results-driven Business Intelligent professional with significant and progressive experience and expertise throughout the entire Software Development Life Cycle (SDLC).
• Involved in Repository Configuration, Troubleshooting,
• Developing Dimensional hierarchies, Expression builder, Time series wizard, Calculation wizard.
• Experience in migrating metadata and web catalogue between different environments.
• Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Experience with repository development, configured metadata objects (subject area, Alias table And column) and web catalog objects (Dashboards, Pages, Folders, Reports)
• Experience in providing end to end business intelligence solutions by dimensional modeling design, building business models, configuring metadata, creating reports/dashboards
• Created dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports.
• Experience in Siebel eBusiness Application configuration by using Siebel Tools.
• Expert knowledge in developing reports for Siebel Applications by using the Actuate Tool.
• Experience with preparing the High level and Low Level Design Documents.
• Experience in communicating with the User's directly.
• Strong programming experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL and PL/SQL.

Technical Skills Summary:

Oracle applications: Business Intelligence Enterprise, Edition (BIEE) platform 11g, 10.x, Siebel, Analytics 8.x/7.x, Siebel CSW 8.x/7.x Oracle platform and architecture: Oracle 11g, 10g, 9i, High Availability, Performance Tuning Non-Oracle Databases : SQL Server 2005, 2008, Microsoft Access Hardware & Operating Systems: Windows 7/XP, DOS, Solaris Tools & Methods: Informatica 8.x , 9.0, Star schema, Snow Flake, SDLC, Oracle Enterprise Manager (OEM), Oracle SQL developer, SQL*Plus, SQL*Loader , ER-Modeling, Object Oriented Analysis and Design Programming Languages: SQL, PL/SQL, HTML / XML, UDML, Java / JavaScript Software Packages: MS Office Suite, MS Project, MS Visio, MS FrontPage

PROJECT DETAILS

Confidential, Waukesha, WI July'11 to Apr'12 OBIEE Developer

Description: Service Application is a CRM Solution which Confidential has deployed to deal with its Sales and Service business. The vanilla application provides the ways to track different Sales Opportunities and convert them to their business. This Project dealt with enhancing the vanilla application to track the Service Opportunities (e.g. Opportunities created by Service Engineers) and convert them into business. Confidential CS Service Workbench deals mainly with the creation of Contracts, Service Request, Activities and invoicing them. It involves Assets, Contracts, Warranties, Entitlements and Customers etc.

Responsibilities

• Requirement Gathering, functional and technical specifications and writing requirements and interface with end users.
• Extensively used Oracle BI Administration Tool for customizing and modifying the physical, business model and mapping and presentation layers of metadata repository.
• Created and modified repository file and modeled data in physical and BMM layer using physical and complex joins.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Developed Business models to represent business logic for Service and created logical tables and defined the complex joins for a business model.
• Involved in Understanding the user requirement and developing the Technical documentation.
• Extensively involved in review of the Design documents with the peers(at different levels)
• Involved in resolving the UI layer formatting issues at OBIEE Answers level.
• Created dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports.
• Responsible for the administration and migration of user reports or repositories between various environments
• Extensively worked with Administration team to resolve the issues happened while migration to different environments.
• Involved in Modifying the existed Fact tables and Dimension tables in the Business Model and Mapping Layer as per the requirement changed.
• Modified reports, filters and charts in Answers and added them to Intelligence Dashboards
• Involved in Modifying the Columns at BMM and Presentation layers by using existing joins.
• Involved in modifying the calculations at Answers level based on the requirement changes.

Environment: OBIEE 11g, Oracle 10g, Toad, Erwin.

Confidential Feb'10 to June'11 OBIEE Developer

Description: Siebel Life Sciences Application is a CRM Solution which Confidential has deployed to deal with its Sales and Service business. The vanilla application provides the ways to track different Sales Opportunities and convert them to their business. This Project dealt with enhancing the vanilla application to track the Service Opportunities (e.g. Opportunities created by Service Engineers) and convert them into business Confidential Sales Workbench deals mainly with the creation of opportunities and orders and converts them into business.

Responsibilities

• Gathering requirements, Analysis, functional and technical specifications, interacting with Business Managers and End users.
• Using admin tool to creation of repositories by using physical layer, business model and mapping layer and presentation layers.
• Worked on layer to customize the tables, hierarchies, dimensions and aggregations and calculations.
• Used aggregate persistent wizard to aggregate data at higher level for performance tuning.
• Implemented various Repository Variables and System Variables depending up on user requirements.
• Created transformations like Expression builder, joiner, and router.
• Utilized various building blocks like calculation measures, time series measures, initialization blocks, session and repository variables, fact tables, dimension tables, dimension hierarchies.
• Designed various reports i.e. Pivot, Narrative and Chart reports in Answers and Configured Intelligent Dashboards for different groups of users to view across regions, Customer Demography with the facility to drill downs and Charts.
• Giving security permission / privileges as per the role of each user.
• Developed custom dashboards and reports using OBIEE Answers.
• Scheduling the Developed reports according to Client requirements.
• Tested and validated the repository, reports and dashboards

Environment: OBIEE 10.1.3.3.1, Oracle 10g, Toad, Erwin, Oracle BI Publisher 10.1.3.4.0, Date Warehouse Administration Console (10.1.3.4.1.), Siebel 8.0

Confidential Apr'09 to Jan'10 OBIEE Developer

Description: Siebel Life Sciences Application is a CRM Solution which Confidential has deployed to deal with its Sales and Service business. The vanilla application provides the ways to track different Sales Opportunities and convert them to their business. This Project dealt with enhancing the vanilla application to track the Service Opportunities (e.g. Opportunities created by Service Engineers) and convert them into business. Confidential Service Workbench deals mainly with the creation of Contracts, Service Request, Activities and invoicing them. It involves Assets, Contracts, Warranties, Entitlements and Customers etc.

Responsibilities

• Created reporting metrics and transfer key performance indicators to a process and database design.
• Create/Modify Metadata repository suiting to company's data requirements by using OBIEE tool.
• Created connection pools, physical tables, schema folders and catalog folders in the physical layer of the repository.
• Defined Primary key-Foreign key relationships, complex joins bridge tables between dimension tables and Fact tables in the physical layer.
• Created dimension sources for each level of aggregated fact data and specified aggregate levels for each source.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Created Aggregate tables and fragmented fact tables for efficient query performance.
• Extensively used filter, update, lookup, expression, router and sequence generator transformations.
• Defined the refresh extraction logic based on the last updated column in the Transactional Tables.
• Created workflows for the Initial load and refresh load.
• Created mappings to populate the aggregate, hierarchy and helper tables.
• Involved in the integration testing and unit testing the data. Identified bugs during the testing phase and fixed them.

Environment: OBIEE 10.1.3.4, , Oracle 10g, Toad, Erwin, Oracle BI Publisher 10.1.3.4.0, , Date Warehouse Administration Console (10.1.3.4.1.), Siebel 8.0

Confidential Jan'08 to Mar'09 OBIEE Developer

Project 1: Motorola Siebel Field Service Project Description: This project's objective is to identify how to operationalize future business vision for Service and Repair operations of the client with end-to-end service and repair visibility. The Repair Asset Tracking also includes identification and authorization of devices entering the service network, tracking service request fulfillment, and end-to-end device movement during the repair process. This project is the development and deployment of a technology solution set used to automate the process creating operational efficiency, improved early detection of issues, expanded service offerings, and reduced IT cost.

Responsibilities

• Created reporting metrics and transfer key performance indicators to a process and database design.
• Create/Modify Metadata repository suiting to company's data requirements by using OBIEE tool.
• Created connection pools, physical tables, schema folders and catalog folders in the physical layer of the repository.
• Defined Primary key-Foreign key relationships, complex joins bridge tables between dimension tables and Fact tables in the physical layer.
• Created dimension sources for each level of aggregated fact data and specified aggregate levels for each source.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Created Aggregate tables and fragmented fact tables for efficient query performance.
• Analyzed and recommended enhancement to metadata reporting in all three layers (Physical Business and Presentation).
• Extensively used filter, update, lookup, expression, router and sequence generator transformations.
• Defined the refresh extraction logic based on the last updated column in the Transactional Tables.
• Created mappings to populate the aggregate, hierarchy and helper tables.

Environment: Oracle Business Intelligence 10.1.x, Oracle 9i/10g, PL/SQL, SQL server, Siebel 8.x

Project 2: Confidential July'07 to Nov'07

Siebel Financial Services

Project Description: This is US Oncology's first Siebel Implementation. The primary requirement of the Client was to replace their existing Access Med Application capturing Patient Data with a new Siebel Application which would enable them to capture all Patient Details as well as other allied details such as Cases, Providers, Payer, etc. The Project also involves certain requirements in the Analytics and Reporting Domains

Responsibilities

• Involved in Modifying the existed Fact tables and Dimension tables in the Business Model and Mapping Layer as per the requirement changed.
• Modified reports, filters and charts in Answers and added them to Intelligence Dashboards
• Involved in Modifying the Columns at BMM and Presentation layers by using existing joins.
• Involved in resolving the UI layer formatting issues at OBIEE Answers level.
• Created dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports.
• Responsible for the administration and migration of user reports or repositories between various environments

Environment: Oracle Business Intelligence 10.1.x, Oracle 9i/10g, PL/SQL, SQL server. Siebel 8.0

Project 3: Confidential Feb'07 to Apr'07

Siebel Sales Description: Confidential is the world's leading diversified manufacturer of motion and control technologies and systems. The projected is implemented for the sales Application in 7.8.2 to parker. (Placeholder1)

Responsibilities:

• Involved in Modifying the existed Fact tables and Dimension tables in the Business Model and Mapping Layer as per the requirement changed.
• Modified reports, filters and charts in Answers and added them to Intelligence Dashboards
• Involved in Modifying the Columns at BMM and Presentation layers by using existing joins.
• Involved in resolving the UI layer formatting issues at OBIEE Answers level.
• Created dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports.

Environment: Oracle Business Intelligence 10.1.x, Oracle 9i/10g, PL/SQL, SQL server, Siebel 8.x

Project 4: Confidential Aug'06 to Dec'06

HTIM Description: Ingersoll Rand features a portfolio of worldwide businesses comprising an enviable roster of leading industrial and commercial brands. In recent years, Ingersoll Rand has transformed itself into a multi-brand commercial products manufacturer serving customers in diverse global markets, and away from the capital-intense, heavy-machinery profile of its past. This is the first CRM implementation

Responsibilities

• Understanding the user requirement and developing the technical documentation.
• Creating the reports in Actuate ere porting Professionals 7 based on the user requirements like simple reports, parameterized reports and master detail reports
• Generating Actuate library (.rol) from Siebel tools.
• BC and Applet Creation for parameterized reports
• Uploading the ROX files to Server by using Actuate Management console
• Involved in Unit Testing and debugging the Bugs, Exported and import the .SIF files.

Environment: Oracle Business Intelligence 10.1.x, Oracle 9i/10g, PL/SQL, SQL server, Siebel 8.x

Confidential May'06 to Aug'06 OBIEE Developer

Project 1: GE Fanuc CNC Online Parts Store (e Sales) Description: The Project is aimed to implementing the e Sales Application in 7.8.2 for GE Fanuc. This e Sales module mainly focuses on implementing Web-based. GE Fanuc Automation is a global enterprise dedicated to helping companies around the world better manage their systems and processes through factory automation solutions. GE Fanuc has operations serving the Americas, Europe and Asia.

Responsibilities

• Working on analysis of Functional document and Technical document preparation
• Creating Tables.

Environment: Oracle Business Intelligence 10.1.x, , Oracle 9i/10g, PL/SQL, SQL server., Siebel 8.x

Project 2: Confidential June '05 - Feb'06 Enhancement and Upgrading from Siebel 7.5 to Siebel 7.8 Description: Confidential Automation is a global enterprise dedicated to helping companies around the world better manage their systems and processes through factory automation solutions.

Responsibilities

• Understanding the user requirement and developing the technical documentation.
• Creating the reports in Actuate eReporting Professionals 7 based on the user requirements like parameterized reports, master detail reports and graphical reports etc.

Environment: Oracle Business Intelligence 10.1.x, Oracle 9i/10g, PL/SQL, SQL server, Siebel 8.x

Confidential Jan'05 -May'05 OBIEE Developer

Project: CARE Application (Sales) This project is aimed to upgrade the existing Siebel 6.0.1.120 application to Siebel 7.5.2 and implementation of Sales Application in Siebel 7.5.2 for CPB.

Responsibilities:

• Creating the reports in Actuate eReporting Professionals 7 based on the user requirements like simple reports, parameterized reports and master detail reports
• Generating Actuate library (.rol) from Siebel tools.

Environment: Oracle Business Intelligence 10.1.x, Oracle 9i/10g, PL/SQL, SQL server, Siebel 8.