SUMMARY

• Over seven (7)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, OBIEE 11.1.1.x
• Expertise in full life cycle Business Intelligence implementations and have an understanding of all aspects of an implementation project using OBIEE10.1.3.x/Siebel Analytics 7.x and OBIEE 11.1.1.x
• Five years of strong experience on Siebel Analytics/OBIEE in designing Dashboards (Oracle/Siebel), Answers (Oracle/Siebel) and Analytics/Oracle Administration, Scheduler and BI Publisher tool.
• Good Analytic and Statistical Exposure to create Reports, Proficient in building analytical repository, presentation layer, business models, generating reports, and creating dynamic Dashboards using OBIEE.
• Installation & Configuration of OBIEE, Dashboards, portal both on windows and UNIX environments.
• Experienced in Extracting Data from different source Systems i.e. Oracle, SQL SERVER, Flat Files, Excel etc.
• Expert in data warehousing concepts like OLAP, Dimensional Modeling, Data Modeling using Normalization, Dimensional Data Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling, Aggregate persistence wizard.
• Strong expertise in developing SQL and PL/SQL codes through various procedures, functions, and packages to implement the business logics of database in Oracle.
• Production Support (24/7) and Maintenance of Data Warehouse application.
• Experience in implementing security in OBI using Repository Variables, Initialization Blocks, and Session Variables
• Experienced in up gradation andmigration of OBIEE between dev/test/prod environments.
• Efficient in creating and schedulingibots/agentsinOracle BI Deliversto provide real - time, personalized and actionable intelligence data to subscribers.
• Strong aptitude for learning and understanding business process and needs.

TECHNICAL SKILLS

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

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

Languages: SQL, PL SQL, C, C++, HTML And XML.

Operating Systems: Windows, UNIX, Linux

Web Servers: Apache, Web Logic, and IIS

Modeling Tools: Erwin, Microsoft Visio.

Applications: MS Office Suite, Dreamweaver and Adobe Photoshop.

PROFESSIONAL EXPERIENCE

Confidential, Conway, AR

Sr.OBIEE Developer

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document
• Assisted with the upgrade of OBIEE10g to OBIEE11g
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables, created Kimball Matrix
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Built Business model and established relationships & Foreign Keys Physical & Logical between tables.
• Created business reports using BI Answers as per requirements.
• Generated various Analytics Reports using global and local filters.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Added users and configured security in web logic console of OBIEE 11g.
• Managed security privileges for each subject area and dashboards according to user requirements
• Setting up LDAP authentication to enable Single Sign on for Users in Development environment leveraging Analytics Repository.
• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
• Created workflows for full load and incremental loads to be used by DAC, worked with two offshore developers to ensure delivery and accuracy
• Assembled subject areas and created execution plan and accommodated the new Informatica mappings.
• Monitoring Incremental & Full load through DAC.
• Trained End Users and Pilot Users about OBIEE Tools.
• Responsible for installing, configuring, developing, support and maintenance of the BI APPS.

Environment: OBIEE 11.1.1.3, Oracle 11g, Informatica 9.6, DAC, OBIA 7.9.6, Windows 7, Windows Server 2003, TOAD for Oracle, BI Publisher.

Confidential, Denver, CO

Senior OBIEE Developer

Responsibilities:

• Worked with Business Users, Involved in Discussing and Gathering the Analytics requirements from different user groups.
• Identify Data Sources & Extension columns - Identify OLTP tables, fields, Map them with Staging Tables and finally map them to OLAP’s Physical layer tables/schemas.
• Configured and developed Order Management and Order Fulfillment reports using OBIEE Answers and Oracle BI Publisher.
• Worked on Repository Physical Data Layer, Business Model and Mapping Layer and Presentation Layer using OBI Administration Tool.
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Used the Security settings in OBIEE Admin Tool to set up users, groups, access privileges and query privileges.
• Created Dimensional Hierarchy, Logical columns, Aggregate columns, Level based Measures and Aggregate navigation in BMM layer.
• Configured charts, pivot table views, Gauge Views, filter in user interface.
• Configured Global Filters and Dashboard and page Prompts in OBI Web.
• Expertly used the OBIEE add-ins to insert and analyse reports in Word, Excel and PowerPoint.
• Developed new reports and migrated existing excel reports to OBIEE dashboards.
• Configured repository and session variables to get dynamic reports and dashboards.
• Designed and developed Performance Measurement Dashboards/Reports that are Dynamic & Interactive with drill-down, drill-across capabilities split reports for summary & details information, and local & global filters using Oracle BI Presentation Services.
• Created iBots using Oracle BI Delivers to deliver reports to different devices across enterprise.
• Configured LDAP server to Authenticate users and implemented both object level and row level security based on roles and responsibilities.
• Hands on experience with DAC in creation of Tasks, Task Groups, Subject Areas, and Execution Plans.
• Experienced in DAC to configure, monitor and schedule ETL routines.
• Used Informatica for ETL purpose, for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center.
• Extensively worked in fine-tuning of Informatica Mappings, Troubleshoot ETL performance issues.
• Created sessions, tasks, and workflows etc. in Workflow Manager.
• Involved with the Testing team to resolve, fixing and testing problems found during the Systems integration test, UAT Phases.

Environment: Oracle Business Intelligence Enterprise Edition 10.1.3.4, Oracle 11GR1, Informatica 8.1, DAC, OBI Apps 7.9.5, Oracle EBS, Microsoft Windows XP, UNIX, SQL Developer.

Confidential, Auburn hills, MI

Sr. OBIEE Developer

Responsibilities:

• Participated in the Requirements Gathering of the various work streams by meeting with the business user and base lining the details.
• Configured the tables and joins between them in the Data Warehouse.
• Identify the OLTP tables, design the mappings, and finally map them to the OLAP Tables.
• Installation of Siebel Analytics/OBIEE and related components for development, QA and production environments.
• Customized Oracle BIEE Metadata Repository using Siebel Analytics/OBIEE Admin Tool by importing some of the required objects with integrity constraints into Physical Layer.
• Migrate the repository and presentation catalog between different environments like Dev, Test, QA and Maintenance.
• Worked on Configuration & Application Deployment Management.
• Worked on Oracle BI Administration tool for customizing the Physical Layer, Business Layer, and Presentation Layer that came with OBIA and modifying it according to the business requirements.
• Worked on Metadata Repository objects and also Web catalog Objects, which include Dashboards, Reports, Pages and Folders.
• Designed and developed Performance Measurement Dashboards/Reports that are Dynamic & Interactive with drill-down, drill-across capabilities split reports for summary & details information, and local & global filters using Oracle BI Presentation Services.
• Developed custom reports/Ad-hoc queries using Seibel Answers and assigned them to application specific dashboards.
• Worked on scheduling tool Data Warehouse Administration Console (DAC) to configure, monitor and schedule ETL routines of the Oracle Business Analytics Warehouse.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Enhance performance of Reports/ Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions, re-building of indexes and managing Cache etc.
• Used Informatica for ETL purpose, for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center.
• Configured LDAP server to Authenticate users and implemented both object level and data level security based on roles and responsibilities.
• Security settings were implemented in Siebel Analytics Administration Tool to set up groups, access privileges and query privileges.
• Configured and Scheduled BI Scheduler for report bursting to File and email locations and used advanced reporting features such as Online Analyzer, Excel Analyzer and report security options.
• Created templates as required by the client using BI Publisher.
• Created sessions, tasks, and workflows etc. in Workflow Manager.
• Performed Unit, Integration and Regression testing to validate reports and mappings.

Environment: OBIEE 10.1.3.3, Oracle 10g, Informatica 8.1, DAC, OBIA 7.9.5, Windows Server 2003, TOAD, BI Publisher, Siebel CRM 7.8, Siebel Call Center 7.7.

Confidential, Dallas, TX

BI developer

Responsibilities:

• Created MUD (Multiple user Development) environment by utilizing projects.
• Splitting of repository projects and make it available to developers.
• Effectively migrating web cat, Skins and Style sheets from one server to another server by using catalog manager.
• Merging of repositories and migrating to multiple servers.
• Installed OBIEE in windows server.
• Created production builds and getting approvals from senior management.
• Customized and developed the OBIEE Business Model and Mapping layer.
• Granting access to users and maintain security by using database authentication and authorization.
• Organize Presentation Layer in a format that is easy for end-user to use as a basis for reporting
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures.
• Created auto purge for repository cache and scheduled as per the demand.
• Trouble shooting the issues related to repository models and report development.
• Designed Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer
• Defined Connection Pools to the Source Data Mart tables in the Physical Layer
• Created Logical Columns based on other Logical and Physical columns in the BMM layer
• Created Presentation catalogs for Sales and Month End Account measures.
• Siebel Analytics Server Administration (Setting up a repository, Administering the Query Environment, Scheduler, Query Caching)
• Created the physical and complex joins in the Physical and Business layers
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Created Repository Groups and Web Groups and assigned users to configure security in the Siebel Analytics Server
• Defined Session variables and the corresponding Initialization Blocks for User Logins at dimensional levels
• Defined Session variables in the repository to populate the current date filters
• Developed/Customized Siebel Dashboards, Siebel Answers, Siebel Delivers (I-Bots)
• Created Reports based on user requirements
• Worked on Dashboard and Page level prompts and Report filters
• Documentation, Knowledge transfer and User training

Environment: Siebel Analytics 7.8, Informatica 7, Sun Solaris 9, Oracle 10g

Confidential, Saginaw, MI

OBIEE Consultant

Responsibilities:

• Interact with the client and end user to collect the list of requirements
• Prepare project layout and provide technical guidance to the development team
• Install and configure OBIEE tools across multiple tools and versions
• Develop data across layers - physical, business models and mapping
• Develop and design data modeling concepts using OBIEE tools
• Develop enterprise dashboards and reports using OBIEE Plus tools
• Identify critical issues and processing faults to optimize BI dashboards and reports
• Perform testing sessions for reports and dashboards and resolve process issues

Environment: OBIEE 10.1.3.2, Siebel Analytics 7.8/7.7.1, Oracle 9i/10g, TOAD, PL/SQL, Windows 2007.

Confidential

Oracle DBA

Responsibilities:

• Providing support and troubleshooting user tickets in Test and Development instance.
• Clone from production to development
• Taking daily backup’s in test and production environments.
• Configuring backups in tool HP Data Protector.
• Applying patch in EBS application.
• Analysis of patches based on installed product in oracle Application.
• Environment: Oracle EBS 11i, HP Data Protector, UNIX, LINUX.