Obiee Developer Resume
Professional Summary:
- Over seven (7)years of experience in IT Industry and over five(5+)years of experience in designing, development and implementation ofOBIEE 10.1.3.x/ Siebel Analytics 7.x
- Expertise in full life cycle Business Intelligence implementations and have an understanding of all aspects of an implementation project using OBIEE 10.1.3.x/Siebel Analytics 7.x.
- Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.
- Experienced in up gradation and migration of OBIEE between dev/test/prod environments.
- Proficient in definingKey Performance Metrics (KPIs), facts, dimensions, hierarchiesand developing StarandSnow Flakeschemas.
- Expertise in design and development of the three layers(Physical/Business Model and Mapping/ Presentation)of anOBIEE Metadata Repository (.rpd)usingOracle BI Administration Tool.
- Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports.
- Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
- Expert in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
- Experienced in working with Variable Manager to define session and repository variables and initialization blocks to streamline administrative tasks and modify metadata content dynamically.
- Proficient in Installation, configuration, and administration of the OBIEE platform.
- Experienced in developing Dimensional Hierarchies, Level Based Measures, and adding multiple sources to business model objects.
- Skilled at creating and scheduling iBots in Oracle BI Delivers to provide real-time, personalized and actionable intelligence data to subscribers.
- Experienced in configuring and set up of OBIEE Security using LDAP and External Database Tables and configuring object level and database level security.
- Experienced in configuring Usage Tracking and Multiuser Development Environment (MUDE).
- Extensively worked with DBAs and BAs towards performance tuning in OBIEE and Data Warehouse environment using cache management, aggregate tables, and indexes.
- Extensive experience in creating executive reports with BI Publisher integrated with OBIEE.
- Experienced in creating interactive UI Design (Siebel Answers, Delivers, and Dashboards) including experience in User Interface Design using CSS, HTML, XML and Java Scripts.
- Highly skilled in Data Analysis, Data Modeling, Dimensional Modeling, and Data Warehousing.
- Well versed in working with ETL Tools such as Informatica Power Center/ Power Mart 8.x/7.x in creatingSource/ Targetdefinitions, building Mappings/ Mappletsand creating and monitoringSessions/ Workflows.
- Experienced in creating Sessions, Workflows, Mappings, Mapplets using various available transformations in Informatica, including Router, Aggregator, and Lookup.
- Very Good experience with Data warehousing and OLAP technology – designing star schema, snowflake schema, fact and dimension tables, physical and logical data modeling using Erwin/MS Visio/Smart Draw.
- Functional knowledge of Oracle EBS 11i- R12 in Finance (AR, AP, GL, FA) and Supply Chain (OM, INV, BOM, WIP, PO), Project, and Manufacturing.
- Familiar with Oracle EBS 11i- R12 iModules – iProcurement, iSupplier, and iPayment.
- Familiar with Oracle BI Apps (OBIA) 7.9.x modules- Sales, Service, Marketing, HR, and Finance.
- Experience in creating and understanding Use Case Specifications and UML diagrams including Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and Class Diagrams, Data Flow Diagrams, and Flow Chart Diagram using Rational Rose and MS Visio.
- Experienced in creation of technical, functional and requirement documentation.
- Competencies include Business Analysis, in accordance with the RUP methodology, outlining system design and dependencies, writing functional and technical specifications, business requirements and system requirements documentation, Issue Resolution, and Defect Management.
- Quick learner with strong communication and people skills who can work in a team or independently.
Technical Skills:
Business Intelligence Tool: OBIEE 10.1.3.x, Siebel Analytics 7.x Databases Oracle 9i/10g, MS SQL Server 200x, MS Access Database Tools TOAD, Oracle SQL DeveloperETL tools: Informatica Power Center 7.x/8.x
Languages: SQL, PL SQL, JavaScript, HTML, XML Operating Systems Windows, Unix, Linux
Business modeling Tools: IBM-Rational Requisite Pro, IBM-Rational Rose, Erwin, MS Visio, SmartDraw, MS Project, Oracle-Primavera SureTrack, Unified Modeling Language (UML)
Methodologies: Software Development Life Cycle (SDLC), Agile methodologies including Extreme Programming (XP), Rational Unified Process (RUP)
Packages: Microsoft Office Suite, AutoCAD, SPSS, Crystal Xcelsius
Testing Tools: HP-QTP, HP-QC, Bugzilla
EDUCATIONAL QULIFICATION:
BS, Mechanical Engineering
PROFESSIONAL EXPERIENCE:
Confidential, High Point, NC Nov 09- Till Date
OBIEE Developer
New Breed is a privately held, third-party logistics services provider that helps companies design and operates efficient supply chains. The project was to develop BI and dashboards about the reverse logistics supplied by New Breed for a major telecom company in the United States. OBIEE was used to provide the clients with information specific to their supply chain to help market responsiveness and to coordinate activities by providing tracing and tracking facility.
Responsibilities:
- Worked during the whole life cycle of the project from requirements gathering to deployment.
- Acted as a liaison between business users and BI team to facilitate understanding of business requirements.
- Created Requirements Traceability Matrix and Mapping Document to trace requirements in BI implementation.
- Conducted Functional Requirements review and walk through with BI Architect, Designers, and Stakeholders.
- Analyzed the data and developed Logical Star Schema model with consultation from Data Modelers and Business Analysts.
- Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.
- Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
- Developed Time Series Objects using Ago and ToDate functions for time series comparisons.
- Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.
- Created various session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
- Configured BI Scheduler and Oracle BI Delivers- iBots to deliver alerts and publish updated content to subscribed users as per the schedules and requirements.
- Worked towards the Performance Tuning of Dashboards and Reports with Business Analysts and DBAs.
- Implemented security based on LDAP Authentication.
- Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
- Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
- Integrated BI Publisher with OBIEE to build reports in word, excel and doc format.
- Created various templates, reports, and prompts in BI Publisher.
- Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.
- Provided guidance and support to end users during the implementation and in production.
Environment: OBIEE 10.1.3.4, BI Publisher 10.1.3.4, Oracle 10g, SQL, Toad 9.7, Windows XP, HTML, CSS.
Confidential, Salt Lake City, UT Feb 09- Oct 09
OBIEE Developer
Boart Longyear is a global mineral exploration company headquartered in Salt Lake City, Utah. Boart Longyear is the leading provider of mineral exploration services and drilling products for the global mining industry and water exploration, environmental sampling, energy, and oil sands exploration. The project called One Core was to build Business Intelligence on top of their Data Warehouse to provide analytical reporting to its managers. Dashboards and reports were built for daily and executive reporting about finance, sales, services, and warehouse.
Responsibilities:
- Interacted with Subject Matter Experts and Business Analysts for reporting requirements analysis and to define business and functional specifications.
- Monitored and documented change requests in requirements and ensured modified requirements are met during BI development.
- Interviewed SMEs, asking detailed questions regarding reporting requirements to refine BRD and FRD.
- Developed metadata repository and configured metadata objects in all three layers using Oracle BI Administration tool.
- Build repository by importing the data, defining keys and joins, creating business model, defining complex joins, mapping columns and sources, creating measures, and developing subject areas.
- Developed various Reports, Interactive Dashboards with drill-down capabilities, with various charts and views, and tables using global and local Filters.
- Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.
- Used OBIEE Web Catalog to set up groups, access privileges and query privileges.
- Configured schedulers and used iBots to generate and deliver reports based on business requirements.
- Created dimension hierarchies, aggregation criteria and multiple logical sources in the BMM layer.
- Involved in performance tuning of the dashboards with DBAs and BAs using cache management and aggregate tables.
- Created schedules to seed and purge cache for cache management.
- Implemented security by creating roles and web groups, and defined Object Level and Data Level Security.
- Developer templates and reports in Oracle BI Publisher in rtf format.
- Attended JAD and White Boarding Sessions with Users and Business Analysts to keep business synchronized with the progress.
- Created Wireframes and Web-Mockups to give look and feel of UI to end users.
- Create Test Plans, Test Cases and performed unit and integration testing
- Participated in designing, coordination and execution of User Acceptance Testing (UAT) with QA, BA and selected business users.
Environment: OBIEE 10.1.3.4, BI Publisher, Oracle 10g, EBS (Financial, Manufacturing, Projects, Supply Chain) Noetix, SQL, Toad 9.6, Linux, Windows XP, XML.
Confidential, Sunnyvale, CA Jan 08- Jan 09
OBIEE Developer
Juniper Networks, Inc. is an information technology and computer networking products multinational company. The company designs and sells Internet Protocol network products and services. I worked on the Sales Data Mart project. The goal of the Sales Data Mart project was to implement a data warehouse as a single repository of sales data to provide reports of Order Bookings and Forecast data for the Sales Organization. The Reports were developed to cater the needs of all levels of Sales organization, from Sales Representatives to Executives.
Responsibilities:
- Interacted with business representatives and business analysts for requirements analysis and to define business and functional specifications.
- Analyzed the Reporting Requirements and participated in the documentation of Business Requirements.
- Developed Oracle BI Metadata repository using BI Administration tool.
- Developed interactive Dashboards and Reports in Oracle BI Answers as per the reporting specifications.
- Defined and created Initialization Blocks, Repository and Session Variables for generating filters and defining security.
- Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
- Developed measure for time comparison using time functions, ToDate and Ago.
- Used Filters and provided Prompts appropriately to make interactive reports and to avoid excessive data showing up on Reports.
- Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
- Performed the Performance Tuning of Dashboards and Reports and made required changes to repository and database in consultation with DBA.
- Implemented security based on LDAP Authentication.
- Configured Measures in the Business Model Layer and mapped to multiple logical table sources.
- Created schedulers and developed iBots to deliver reports and dashboards to the subscribers as per the schedules and alerts.
- Created report prototypes and presented them to users to get approval.
- Attended weekly meetings with BA and Stakeholders for project status updates.
- Performed unit and integration testing of reports and dashboards.
Environment: OBIEE 10.1.3.4, Informatica 8.6, Oracle 10g, SQL, Toad 9.0, Windows XP.
Confidential, Irving, TX Mar 07- Dec 07
OBIEE Developer
Nissan Motor Acceptance Corporation (NMAC), the captive finance company for Nissan North America. The BI platform was built on OBIEE at their centralized Customer service facility in Irving, TX. OBIEE was deployed across the organization; over 700 employees are now using the system to manage customer and dealer accounts and relationships. NMAC expects to utilize OBIEE to improve customer and dealer service levels, increase owner loyalty to the Brand and advance the levels of efficiency and effectiveness with minimal customization of the package software.
Responsibilities:
- Worked closely with Business Analyst in understanding the BI and reporting requirements and created the business model for generating reports as per the user requirements.
- Worked closely with the data modeler in designing the logical data model in star schema in BMM Layer.
- Configured and created repository using OBIEE Administration Tool.
- Created and administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Repository using Administration Tool.
- Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
- Managed security privileges for each subject area and dashboards according to the requirements.
- Developed various kinds of request queries using BI Answers and assigned them to specific Dashboards.
- Configured iBots to deliver BI content to subscribers based on schedule and events.
- Created Security settings in OBIEE Administration Tool to set up groups, access privileges and query privileges and also managed security for groups in Answers.
- Developed intuitive and user friendly Dashboards by appropriately including guided navigational links, prompts, and drilldowns.
- Used the Catalog manager and maintained the Oracle BI web catalog to manage Dashboards, Answers.
- Involved in unit testing, integration testing of the reports generated by OBIEE.
Environment: OBIEE 10.1.3.3, Informatica Power Center 8.1, Oracle 10g, OBIA 7.9.x (Oracle Service Analytics), DAC, Toad, SQL, Windows XP.
Confidential, Mounds View, MN Aug 06- Feb 07
OBIEE Developer
Medtronic is the world leader in medical technology providing lifelong solutions for people with chronic diseases. This Assignment involved implementation of OBIEE to analyze Sales and Marketing data. The name of the project is Sales Data Mart which involved the entire life cycle of Business Intelligence. I worked on both Repository development and User Interface (UI) development.
Responsibilities:
- Analyzed business requirements and developed Functional Requirement Document and Technical Requirement Document.
- Interacted with BA, Sales Managers, Sales Representatives, and DBA to gather Analytics Reports/ Dashboards requirements and to define business and functional specifications.
- Identified Facts, Dimensions, Levels/Hierarchies of Dimensional Modeling.
- Customized and developed RPD (Physical, BMM and Presentation Layer).
- Developed many Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, and Tabular with global and local Filters) using OBIEE.
- Used various Time series functions to create trending reports of sales.
- Configured iBots to deliver analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
- Worked with DBA and SME towards performance tuning.
- Performed unit and integration testing of reports and dashboards.
- Conducted UAT sessions with end users.
- Implemented security by creating roles and web groups.
Environment: OBIEE 10.1.3.3, Informatica Power Center 8.1, Oracle 10g, Toad, SQL, Windows XP.
Confidential, India Jan 05- Jul 06
Informatica/ Siebel Analytics Developer
Dr. Reddy’s Laboratories is one of the largest pharmaceuticals company in India. This project was to build a data warehouse as a central information point for various kind of analytical and market analysis. The data warehouse was built by consolidating data from multiple sources. The main component of the project was to create sales and marketing analysis decision support system.
Responsibilities:
- Used Informatica Power Center Designer for developing mappings, using transformations, which includes aggregation, Updating, lookup, and summation. Developed sessions using Server Manager and improved the performance details.
- Maintain Development, Test and Production mapping migration using Repository.
- Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
- Used Informatica Server manager to create sessions, batches to run with the logic embedded in the mappings.
- Worked with Informatica Designer tool in developing mappings and mapplets to extract and loading the data from flat files, oracle to Oracle.
- Extensively used Informatica for loading the historical data from various tables for different departments.
- Worked on complete SDLC from Extraction, Transformation and Loading (ETL) of data using Informatica.
- Set up Delivers to configure iBots based on the threshold value to the users.
- Worked with Siebel Analytics Developer to create Repository with Siebel Analytics Admin tool.
- Worked extensively in Siebel Answers and Dashboards.
- Created and granted privileges for the users using Analytics Catalog Manager.
Environment: Informatica 7.1/8.1, Siebel Analytics 7.8.2, PL/SQL, Oracle 9i, Erwin, Windows 2003.
Confidential, India Mar 04- Dec 04
ETL Developer
HDFC Bank is a leading financial services company in India. This project was to build a data warehouse that will facilitate management as a decision support system to target their new financial products. The data warehouse captures the customer spending trends which were further analyzed using various reporting tools
Responsibilities:
- Installed and configured Informatica Server and Power Mart.
- Created Repository, Folders, and User accounts using Power Mart Repository Manager.
- Created database objects like tables, views, synonyms, indexes and sequences.
- Designed and developed mappings using Power Mart Designer.
- Used all Transformations such as Expression, Filter, Joiner, aggregator, Lookup and Router, to load consistent data into Warehouse Database.
- Used Server Manager to create database connections, sessions to run the mappings.
- Wrapped the sessions with pre-session and post-session UNIX shell scripts. Created and scheduled batches for the daily load of the data.
- Used various performance tuning methods to make the loads more efficient.
- Tested the Informatica mappings and creating QA Test Plans.
- Developed the documentation on the complete data mart ETL process.
- Supported the data mart in Production.
Environment: Informatica 7.1, Oracle 9i, SQL, PL/SQL, Windows 2003, Unix.