SUMMARY

• Over 6 years of experience in IT Industry and over five(5+)years of experience in designing, development and implementation of OBIEE 10.1.3.x/ Siebel Analytics 7.x
• Expertise in full life cycle Business Intelligence implementations and has an understanding of all aspects of an implementation project usingOBIEE10.1.3.x/Siebel Analytics 7.x.
• Experienced in up gradation andmigration of OBIEE between dev/test/prod environments.
• Proficient in defining Key Performance Metrics (KPIs), facts, dimensions, hierarchies and developing Standard Snow Flake schemas.
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers includingPhysical, Business Model and Mapping, and Presentation layer.
• Expertise in design and development of the three layers (Physical/Business Model and Mapping/ Presentation)ofan OBIEE Metadata Repository(.rpd) using Oracle BI Administration Tool.
• Experienced indesigning customized interactive dashboardsin OBIEE using drill down, guided navigation, prompts, filters, and variables.
• Expert in usingOBIEE Answersto create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Experienced in working wifVariable Managerto definesession and repository variablesandinitialization blocks to streamline administrative tasks and modify metadata content dynamically.
• Highly skilled at configuring OBIEE Metadata Objects including repository, variables,interactive dashboards, and reports.
• Proficient in Installation, configuration, and administration of the OBIEE platform.
• Ability to combine data from disparate sources and expose them to TIBCO Spotfire client users through information links
• Experienced in developingDimensional Hierarchies,Level Based Measures,and adding multiple sources to business model objects.
• Skilled at creating and schedulingiBotsinOracle BI Deliversto provide real - time, personalized and actionable intelligence data to subscribers.
• Experienced in configuringUsage Tracking and Multiuser Development Environment (MUDE).
• Experienced in configuring and set up ofOBIEE Security using LDAP and External Database Tablesand configuring object level and database level security.
• Extensively worked wif DBAs and BAs towardsperformance tuningin OBIEE and Data Warehouse environment using cache management,aggregate tables, and indexes.
• Extensive experience in creating executive reports wifBI Publisherintegrated wif OBIEE.
• Highly skilled in Data Analysis, Data Modeling, Dimensional Modeling, and Data Warehousing.
• Well versed in working wifETLTools such asInformatica Power Center/ Power Mart 8.x/7.x in creating Source/ Target definitions, building Mappings/ Mapplets and creating and monitoring Sessions/ Workflows.
• Experienced in creating interactiveUI Design(Siebel Answers, Delivers, and Dashboards) including experience in User Interface Design usingCSS, HTML, XML and Java Script.
• Experienced in creating Sessions, Workflows, Mappings, Mapplets using various available transformations in Informatica, including Router, Aggregator, and Lookup.
• Very Good experience wif 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.
• Familiar wif Oracle EBS 11i- R12 iModules - iProcurement, iSupplier, and iPayment.
• Functional noledge ofOracle EBS 11i- R12in Finance (AR, AP, GL, FA) and Supply Chain (OM, INV, BOM, WIP, PO), Project, and Manufacturing.
• Familiar wifOracle BI Apps (OBIA) 7.9.xmodules- Sales, Service, Marketing, HR, and Finance.
• Experience in creating and understandingUse Case Specifications and UML diagramsincluding 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 includeBusiness Analysis, in accordance wif 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 wif strong communication and people skills who can work in a team or independently.

TECHNICAL SKILLS

Business IntelligenceTool: OBIEE 10.1.3.x, Siebel Analytics 7.x Databases Oracle 9i/10g, MS SQL Server 200x, MS Access Database Tools TOAD, Oracle SQL Developer

ETL tools: Informatica Power Center 7.x/8.x

Tibco tools: TIBCO Spotfire 3.2/4.5/5.0/6.0

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

PROFESSIONAL EXPERIENCE

Confidential, Auburn, ME

OBIEE Developer/Admin

Responsibilities:

• Worked during the whole life cycle of the project from requirements gathering to deployment.
• Installed and configured OBIEE repository Server, OBIEE Presentation Sever, oc4j, JDK, BI Publisher.
• Migrated and merged OBIEE Repository and Catalogs
• Monitoring the overall usage and taking necessary steps to improve the performance if needed
• Server Space management as per the need.
• Did the Necessary RPD and Catalog upgrades and applied patches as part of admin team.
• Provided extended production support based on the demand and complexity of the issue.
• Implemented Over all security, SSO, OBIEE content and Data level security
• Acted as aliaison between business users and BI teamto facilitate understanding of business requirements.
• ConductedFunctional Requirements review and walk throughwif BI Architect, Designers, and Stakeholders.
• CreatedRequirements Traceability Matrix and Mapping Documentto trace requirements in BI implementation.
• Analyzed the data and developedLogical Star Schemamodel wif consultation from Data Modelers and Business Analysts.
• Created various Reports using Spotfire and involved in Performance tuning
• Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
• Developed metadata repository usingOBIEE Administration toolin Physical, Business Model and Mapping, and Presentation Layer.
• Designed and developed variousInteractive Dashboardsand reports wif drilldowns, guided navigation, filters, and prompts.
• Developed Time Series Objects usingAgo and ToDate functionsfor time series comparisons.
• Worked towards the Performance Tuning of Dashboards and Reports wif Business Analysts and DBAs.
• Developed Dashboard reports for Project portfolios which help in better analysis for decision making using Spotfire
• Created varioussession and repository variablesand initialized them in theInitialization Blocksto change metadata dynamically as the environment changes.
• ConfiguredBI SchedulerandOracle BI Delivers- iBotsto deliver alerts and publish updated content to subscribed users as per the schedules and requirements.
• Implementedsecuritybased onLDAP Autantication.
• Perform day to day administration of Spotfire, including group/library management, upgrades, monitoring log files, performance tuning, troubleshooting and reporting
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
• Createdsecurity settingsin OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
• IntegratedBI Publisherwif OBIEE to build reports in word, excel and doc format.
• Created various templates, reports, and prompts in BI Publisher.
• Developed test cases and performedUnit Testing and Integration Testingof 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, Maynard, MA

OBIEE Admin

Responsibilities:

• Interacted wifSubject Matter Experts and Business Analystsfor reporting requirements analysis and to define business and functional specifications.
• Provide support in the implementation of OBIEE components
• Install, upgrade and configure all components of OBIEE
• Design and implement data in various layers including physical, business and presentation
• Assist the teams in generating dashboards and reports properly
• Use the best practices of business intelligence to administer the analytical solutions
• Perform validation of data on the reports and monitor the performance status of the same
• Assist and administer the deployment process of UNIX, OBIEE and repository codes
• Prepare monthly reports and present it to the management
• Monitored and documentedchange requestsin requirements and ensured modified requirements are met during BI development.
• Interviewed SMEs,asking detailed questions regarding reporting requirements to refineBRD and FRD.
• 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 metadatarepositoryand configured metadata objects in all three layers usingOracle BI Administration tool.
• Developed variousReports, Interactive Dashboardswif drill-down capabilities, wif various charts and views, and tables using global and local Filters.
• UsedOBIEE Web Catalogto set up groups, access privileges and query privileges.
• Configured schedulers and usediBotsto generate and deliver reports based on business requirements.
• Created dimension hierarchies, aggregation criteria and multiple logical sources in the BMM layer.
• Developed Reports and Dashboards wif different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector wif global and local Filters using Oracle BI Presentation Services.
• Involved in performance tuning of the dashboards wif DBAs and BAs using cache management and aggregate tables.
• Created schedules to seed and purge cache forcache management.
• Implemented security by creating roles and web groups, and defined Object Level and Data Level Security.
• AttendedJAD and White Boarding Sessionswif Users and Business Analysts to keep business synchronized wif the progress.
• Developer templates and reports inOracle BI Publisherin rtf format.
• Create Test Plans, Test Cases and performed unit and integration testing
• CreatedWireframes and Web-Mockupsto give look and feel of UI to end users.
• Participated in designing, coordination and execution ofUser Acceptance Testing (UAT)wif 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, Portland, OR

OBIEE Developer

Responsibilities:

• Interacted wif business representatives and business analysts forrequirements analysisand to definebusiness and functional specifications.
• Analyzed the Reporting Requirements and participated in the documentation of Business Requirements.
• Developed interactiveDashboards and ReportsinOracle BI Answersas per the reporting specifications.
• Defined and createdInitialization Blocks, Repository and Session Variablesfor generating filters and defining security.
• DevelopedOracle BI Metadata repositoryusing BI Administration tool.
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
• 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.
• Developed measure for time comparison using time functions,ToDate and Ago.
• Performed thePerformance Tuningof Dashboards and Reports and made required changes to repository and database in consultation wif DBA.
• Implemented security based onLDAP Autantication.
• Created schedulers and developediBotsto deliver reports and dashboards to the subscribers as per the schedules and alerts.
• Configured Measures in the Business Model Layer and mapped to multiple logical table sources.
• Createdreport prototypesand presented them to users to get approval.
• Attended weekly meetings wif BA and Stakeholders for project status updates.
• Performedunit and integration testingof reports and dashboards.

Environment: OBIEE 10.1.3.4, Informatica 8.6, Oracle 10g, SQL, Toad 9.0, Windows XP.

Confidential

Informatica/ Siebel Analytics Developer

Responsibilities:

• UsedInformatica Power Center Designerfor 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.
• Used Informatica Server manager to create sessions, batches to run wif the logic embedded in the mappings.
• Created Stored Procedures to transform the Data and worked extensively inPL/SQLfor various needs of the transformations while loading the data.
• Worked wif Informatica Designer tool in developingmappings and mappletsto extract and loading the data from flat files, oracle to Oracle.
• Worked on completeSDLCfromExtraction, Transformation and Loading (ETL)of data using Informatica.
• Extensively used Informatica for loading the historical data from various tables for different departments.
• Worked wif Siebel Analytics Developer to createRepositorywifSiebel Analytics Admin tool.
• Set up delivers to configure iBots based on the threshold value to the users.
• Created and granted privileges for the users using Analytics Catalog Manager.
• Worked extensively inSiebel Answers and Dashboards.

Environment: Informatica 7.1/8.1, Siebel Analytics 7.8.2, PL/SQL, Oracle 9i, Erwin, Windows 2003.