SUMMARY

• Over six years of experience in IT which includes 5.5 years of diverse experience in OBIEE / Siebel Analytics and Data warehouse projects with outstanding record for accomplishment as a Senior OBIEE Developer in Accenture.
• Worked on BI Projects in Retail and Confidential domains.
• Experience in Answers and Dashboards for both OBI/Siebel Analytics stand - alone/ integrated implementation.
• Extensively designed Interactive Dashboards and reports, incorporating capabilities such as dashboard prompts, navigation, drill-down, writeback, views and other Web Catalog Objects using OBIEE.
• Worked with CRM and ERP applications as Siebel econsumer goods and their integration with OBIEE.
• Experience in Dimensional Modeling, Data Warehousing concepts, Ralph Kimball and Bill Inmon Methodologies, Star and Snowflake schemas.
• Worked on BIPublisher Report, Report RTF templates.
• Developed iBots in OBIEE to automate report delivery, seed cache and provide alerts on Interactive Dashboards.
• Experienced in installation, upgrade and administration tasks in Windows and UNIX Environment.
• Exposure on OBIEE 10g to 11g Upgrade process, RPD and Web-catalog migration.
• Worked on OBIEE features (i.e. Clustering, Security, cache, usage tracking, dimensional hierarchy, aggregate navigation, MUD, Single Sign-on, Variables/Initialization Blocks configuration etc.).
• Experience in development and designing in Informatica .Well versed with Informatica Designer, workflow manager and monitor.
• Experience in Developing Informatica mappings/ Mapplets using various Transformations for Extraction, Transformation and Loading of data to data warehouses and creating workflows with work lets & tasks and scheduling using workflow manager.
• TEMPHas been involved in business-related project milestones such as in Requirements Gathering, Data modeling (logical and physical design of databases), Business Gap Analysis, Unit/Integration Testing, Data Migration, User Training, and System Maintenance.
• Experience in ETL tools Data Administration Console (DAC) including configuration and exposure on ODI 11g.
• A good team player with excellent communication, analytical, and programming skills with teh ability to work in a high speed, quality conscious, and multi tasked environment and grasp new concepts and apply them as per business requirements. Possess strong work ethics and willingness to work hard to achieve employer goals and targets.

TECHNICAL SKILLS

BI: OBI EE 10.x /11.1.1.6 (Administration Tool, Analytics, Answers, Dashboards, Delivers and BI Publisher) and Siebel 7.x (Administration Tool and Analytics)

ETL: Informatica Power Centre 8.x/7.x, ODI, DAC

DB: Oracle 10g/9i/8i

DB Tools: SQL Developer, TOADOS Windows XP/2000/NT 4.0/Vista, UNIX and Linux

Languages: Java, Shell Scripting

CRM: Siebel CRM Finance, Siebel CRM Call Center Application

Other: ITSM, Winscp,Putty

PROFESSIONAL EXPERIENCE

Confidential, Atlanta

OBIEE Senior Developer

Responsibilities:

• Configuring and deploying OBIEE 11.1.1.6 Application for development
• Worked on RPD and Web-catalog upgrade activity and migrating-deploying configuration files.
• Worked on ETL and OBIEE enhancements.
• Re-modeling Physical schema from data marts and defined Physical Joins in teh Physical Layer and validating OBIEE Metadata Repository.
• Configured security in OBIEE Server creating and assigning responsibilities to Repository Users, Groups and Web Groups.
• Designed Physical Layer, Business Model & Mapping Layer (logical modeling) and Presentation layer in Metadata Repository (.rpd) in building different Subject Areas using OBIEE Administration Tool.
• Used OBIEE Answers to develop Ad-hoc and standard Reports / Dashboards with various Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters).
• Integrated BIPublisher on OBIEE dashboard/Report and associated with OBIEE Report Dashboard Report prompts
• Involved in administration tasks - server monitoring, RPD and Webcatalog deployment activities.
• Modified Informatica mappings and workflows.
• Work in collaboration with business users and internal teams

Environment: OBIEE 11.1.1.6, BI Publisher, Linux, Informatica 8, Oracle

Confidential

OBIEE Developer

Responsibilities:

• Setting up OBIEE Repository Multi User Development Environment, implemented and configured to projects driven by Subject areas on centralized Repository.
• Involved in end to end process of upgrading OBIEE 10g to 11g Upgrade process
• Involved in RPD/catalog upgrade, configuration file changes, report layout changes and RPD issue fixes.
• Design and develop custom made business intelligence solution according to teh plan using BI applications
• Customized Oracle BI Repository, set up data level security using Oracle BI Session variables using in OBIEE Administration Tool.
• Develop and design ad hoc queries, reports and analytics
• Creating teh Dimensional Hierarchies, Level Based Measures, Time- series Functions, Initialization Blocks and Variables depending upon teh need for Business Reports using teh OBIEE Admin tool.
• Implemented security at teh data and object levels as per teh business user requirement
• Good Knowledge in Reports, different charts, narrative view, column selector, view selector, pivot table and Dashboards with Prompts.
• Extensively used pivot table view and chart views to enhance teh presentation.
• Used appropriate filters, column filters, prompts, dashboard prompts and calculations in reports.
• Used Java script in reports that invokes a stored procedure.
• Created Informatica mappings and workflows and used various transformations.

Environment: OBIEE 10.1.3.4, OBIEE 11.1.1.6, Informatica 8.0, Linux Platform

Confidential

OBIEE Developer

Responsibilities:

• Involved in teh entire SDLC (Software Development Life Cycle) process which includes documentation, development, testing, deployment, Implementation, and maintenance.
• Interacted with business representatives for gathering teh Reports / Dashboards requirements and to define Business and Functional Specifications
• Created/Modified Metadata repository (.rpd) and configured Metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard Pages, Folders, Reports).
• Displayed TEMPeffectiveness in dashboard creation by appropriately including guided navigational links and drilldowns.
• Repository creation and modeling.
• Report Layout Designing and Report Creation.
• Involved in building physical layer, business model layer and presentation layer of analytics repository using OBIEE administration tool
• Involved in configuration changes and deployment activities through enterprise manager in 11g.
• Was involved in performing basic tasks in ODI 11g.

Environment: OBIEE 10.1.3.4, OBIEE 11.1.1.6, ODI 11g, Linux, Spatialnet

Confidential

OBIEE Developer

Responsibilities:

• Interacting with business users and gathering teh business requirement for Application Change Requests.
• Developed custom reports/Ad-hoc reports using Siebel Analytics and assigned them to application specific dashboards
• Configured Dashboard and page prompts for various departments supporting teh global organization structure and configured drill down reports to provide insight into Sales.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to send alerts to related managers and secured team members.
• Created dimension hierarchies aggregates and logical sources in teh BMM layer
• Developed different kinds of Reports (pivots, charts).
• Implemented Security Groups and Roles using LDAP Authentication.
• Created materialized views and aggregates to improve performance.
• Used Siebel Analytics Answers to develop Ad-hoc and standard Reports / Dashboards with various Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters)
• Created Initialization Blocks, Repository Variables and IBots
• Troubleshooting for Data discrepancy issues reported by Users. dis involves a back tracking of data from Report to ETL and then to teh source Siebel applications (eConsumer Goods).
• Handling Change requests reported by user groups.
• Contributed in Deployment activities.
• Communicating and interacting with teh Users and external teams to resolve tickets(ITSM)
• Contributed to activities in DAC (Data Warehouse Application Console)

Environment: Siebel Analytics 7.8, Siebel CRM Econsumer Goods, Informatica 7.8, DAC, UNIX Platform, ITSM