Summary:

• Result Oriented IT professional with 7+ years of progressive expertise in analyzing the requirements, application design, development, testing and a comprehensive background in Oracle Business Intelligence (OBIEE) 11.1.1.5/Siebel Analytics 7.9.x with 3 full life cycle implementations.
• Expertise in Installation and Configuration of OBIEE on various platforms of AIX/Windows and developing Metadata, Repositories, Dashboards and Reports. Scheduling and Monitoring Informatica ETL through DAC.
• Involved in working closely and effectively with a variety of Business/Technical analysts and a Variety of Business users to meet their Business Objectives.
• 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.
• Extensive experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers / IBots, creating reports / Dashboards, cache monitor, and building Siebel Analytics Repository using Siebel Analytics/OBIEE.
• Experience in implementing security in OBI using Repository Variables, Initialization Blocks, and Session Variables.
• Expertise in Creating Filters, Global Prompts in Dashboards, Presentation Variables, and Narrative Views to filter the data.
• Experienced in working with DAC design and development including Customizing Execution Plan, Subject areas, Tables groups and Task definitions.
• ImplementedData Level Security,Object LevelSecurityand LDAP authentication.
• Experience configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports) and setting up office integration for BI publisher.
• Worked in the integration of Essbase 9.3.1 with OBIEE to enable reporting on top of OLAP cubes and accomplish slicing and dicing of data.
• Worked on implementation of Data Warehouse, BI solutions and a strong understanding of Data Warehouse concepts, ETL, Star Schema, Data Modeling, Business Process Analysis, Dimensional Data Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling.
• Experienced in Extracting Data from different source Systems i.e. Oracle, SQL SERVER, Flat Files, Excel etc.
• Experienced in Design, Development, Implementation, Testing and Maintenance of Oracle Databases, ETL Processes and Database Deliverables.
• Ability to create templates for Oracle BI Publisher, and deploy those templates to an Oracle e-Business Suite instance.
• Good Knowledge in Oracle PL/SQL Packages, Procedures, Functions, Triggers and other objects.
• Excellent Self Driven project management skills, Team Player, Good communications, Presentation and Telephony skills.

Certification

Oracle certified professional on Introduction to Oracle 9i

Technical Skills

ETL Tools : Informatica Power Center 8.6.1/7.x/6.x/5.x.
BI Tools : OBIEE 11G ,OBIEE 10.1.3.4/Siebel Analytics 7.7,
Oracle(IBots), BI Apps 7.9.5, 7.7.1,OBIEE
Operating Systems : MS Dos, Win 95/98, NT 4.0, Win 2000, Win XP,AIX UNIX.
RDBMS : Oracle 11g/10G/9i/8i/8.0/7.x,MS SQL SERVER 2008/2005, SQL/PLSQL
Languages: C, SQL, PL/SQL, UNIX Shell Scripting.
Web Servers : Apache, IBM Web Sphere, Web Logic, and IIS
Modeling Tools: Erwin, Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential, Winsdor CT Jan 12 - Till Date
ROLE: SR OBIEE DEVELOPER/ ADMIN/HYPERION ADMIN

Responsibilities

• Installed ,configured and administrated OBIEE 11G
• Identify the OLTP tables, design the mappings, and finally map them to the OLAP Tables.
• Installed, configured and administrated Hyperion 11.1.2.1 on windows Environment.
• Configured active directory to the shared services and import all the users from the directory by using filter
• Designed and Tested Reports in theDashboardsfor theOracle Financial Analyticsmodules likeGL, AP, ARand created the Ad-hocreport according to the client needs
• Worked on loading FDM data in to the application in series or parallel ways.
• Created scripts for start and stopping the obiee services
• Worked with maintenance team by creating scripts like kill the process ,moveing the logs , and also setting up the cronjobs for every week to recycle the OBIEE server
• Worked on Weblogic in obiee 11g to create users and groups
• Worked on migrating RPD and catalog to OBIEE 10G to OBIEE 11G
• Worked on upgrading OBIEE 10G to OBIEE 11G(11.1.1.5 Version)
• Worked on OBIEE security like configuring LDAP authentication ,creating users and groups etc
• Migrating security from DEV to Test env in OBIEE 11g by exporting the exportindex.dat file
• Worked on variables like repository and session variable
• Worked on cache management which deals with purging the cache ,enable the cache etc
• Worked on configuring SSL(secure socket layer ) for providing the encryption of the data i.e communication between two process like browser and webserver etc .
• Worked on EM Console to deploy the rpd and provide the catalog .
• Customized Oracle BIEE Metadata Repository using Siebel Analytics/OBIEEAdmin Tool by importing some of the required objects with integrity constraints into Physical Layer.
• Executed OBIEE administrative tasks such as OBIEE server installation, migration and user maintenance.
• Migrate the repository and presentationcatalog between different environments like Dev, Test, QA and Maintenance.
• Created Time Series measures Year Ago, Month Ago, Year-to-date measures using Ago and To Date functions.
• Created Requests in Answers with various views Title, Table, Compound Layout, Chart, Gauge and Pivot Table.
• Defined Level Based Measures based on the Dimensional Hierarchies created in the Business Model & Mapping Layer.
• Identified Facts and Dimension Levels/Hierarchies of Dimensional model.
• Customized and developed RPD (Physical, Business Model and Presentation layer), configured metadata objects and Web Catalog Objects.
• Developed many reports/dashboards Analytic views (Pivot tables, Charts, Column Selector, and View Selector) using OBIEE 11g.
• Created Measures and Level Based Measures in Business Model.
• Created Logical Tables and Logical Columns, Physical Columns.
• Created Measures with Logical columns and Physical columns.
• Created Dimension Hierarchies in Business Model and Mapping Layer.
• Performance tuning of Dashboards/Reports and made changes to database by implementing materialized views and partitions, rebuilding indexes.
• Worked on security management for users, groups and web groups using the various authentication systems such as LDAP, OS, Database and Database Table Authentication using Session Variable features, as well as Dashboard/ Report level security.
• Created iBots and delivers to send Alert messages to subscribed users.
• Implemented Single Sign On (SSO) on the existing OBIEE environment by integration with Site Minder, Editing the credentialstore.xml files and getting the rpd groups in sync with Database roles was part of it.
• Monitoring performance and drive business decisions to help improve upon that performance by using KPI scoreboard
• Worked on Oracle BI Administration tool for customizing the Physical Layer, Business Layer, Presentation Layer that came with OBIA and modifying it according to the business requirements.
• Worked on performance tuning to increase the performance of Hyperion product (heap size tuning, OS tuning etc)
• Worked on issues like Essbase crash, Server crashed, FR reports are not working Etc
• Worked on shared services by creating group and adding users to the groups.

Environments : OBIEE 11.1.1.5.0,DAC 7.9.6,Hyperion EPM 11.1.1.2,HFM,FDM, Informatica Power Center 8.6, OBIA 7.9.5, TOAD, Oracle 10g, Windows 2003, , Red Hat Linux, WebLogic Server 11gR1 PS3, Financial Analytics, HR ( Human Resources) Analytics ,Pharmaceutical analytics.

Confidential, Round Rock TX July11- DEC 11
ROLE: SR OBIEE DEVELOPER/ADMIN

Confidential, is an American multinational information technology corporation based, Round Rock, Texas, United States that develops, sells and supports computers and related products and services. As a Senior OBIEE Developer, I worked on Human Resources Analytics Which Deals with pay roll , employee information ,compensation, work forceand also worked on financial analytics . This project converts all the data to the people soft HR and also worked on informatica

• 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.
• Installed configured and administrated OBIEE 11G
• Identify the OLTP tables, design the mappings, and finally map them to the OLAP Tables.
• Configuredand installedBI Publisherand integrated with OBIEE server and created Smart View Report Templates.
• Customized Oracle BIEE Metadata Repository using Siebel Analytics/OBIEE Admin Tool by importing some of the required objects with integrity constraints into Physical Layer.
• Enterprise reporting environment for home office and retail field of 400 stores (previously in Impromptu Web Reports) with OBIEE dashboards.
• 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, accessprivileges 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.
• Executed OBIEE administrative tasks such as OBIEE server installation, migration and user maintenance.
• Migrate the repository and presentation catalog between different environments like Dev, Test, QA and Maintenance.
• Created templates as required by the client using BI Publisher.
• Implemented BIPublisher and created bursting reports using BIPublisher.
• Expertise integrating and customizing BI Office with OBIEE.
• Worked on Key Performance Indicators (KPI) within the BI environment which can be used as the catalyst toward driving more responsive interaction between users and data.
• Monitoring performance and drive business decisions to help improve upon that performance by using KPI scoreboard
• Worked on Oracle BI Administration tool for customizing the Physical Layer, Business Layer, 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.
• Enhance performance of Reports/ Dashboards by implementing the Aggregate tables, Materialized Views, Table partitions, re-building of indexes and managing Cache etc,.
• Configured LDAP server to Authenticate users and implemented both object level and data level security based on roles and responsibilities.
• Created sessions, tasks, and workflows etc. in Workflow Manager.
• Performed Unit, Integration and Regression testing to validate reports and mappings.

Environment: OBIEE 11.1.3.0,DAC 7.9.6, Informatica Power Center 8.6, OBIA 7.9.5, TOAD, ODI, Oracle 10g, Windows 2003, , Red Hat Linux, WebLogic Server 11gR1 PS3, Financial Analytics, HR ( Human Resources) Analytics .

Confidential, Houston , TX Nov09 - July 11
Role: SR OBIEE DEVELOPER/ADMIN

Confidential, previously known as Administaff, Inc. is a professional employer organization with its headquarters in Houston, Texas. Insperity provides human resources services to small and medium-sized businesses. I worked on Human Resources Analytics Which Deals with pay roll, employee information, compensation, work force

Responsibilities:

• Analyzed Business Requirements and Use Cases and converting them to a technical specification. Software Design Document(SDD) is updated with the implementation plan.
• Created Time Series measures Year Ago, Month Ago, Year-to-date measures using Ago and To Date functions.
• Created Requests in Answers with various views Title, Table, Compound Layout, Chart, Gauge and Pivot Table.
• Defined Level Based Measures based on the Dimensional Hierarchies created in the Business Model & Mapping Layer.
• Implemented data level security (Location Managers, Sales Executives etc) using Session Variables by creating content filter in dimension table in rpd.
• Implemented object level security for both repository objects and web objects by creating users and groups in repository and web catalog groups in the Presentation Services.
• Created reports and dashboards with different Views like Pivot table, View Selectors, Column Selectors, Charts with drill-down capabilities for vivid information about Product Lines, Locations, Stores etc.
• Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
• Configured LDAP server to Authenticate users and implemented both object level and data level security based on roles and responsibilities.
• Created subject areas, execution plans to load the data warehouse through DAC10.1.3.4.1
• Involved in creating aggregate tables to increase the performance of reports and access the corresponding logical table source without going to the base fact table.
• Involved in developing performance tuning strategies by implementing aggregations, aggregate navigation, Oracle materialized views and indexes.

Environment: OBIEE 10.1.3.4.1,DAC 7.9.6, Informatica Power Center 8.6, OBIA 7.9.5, TOAD, Oracle 10g, Windows 2003, , Red Hat Linux, WebLogic Server 11gR1 PS3, , Financial Anlalytics, Human Resources ( HR Analytics) .

Confidential, Atlanta GA Jan 08 - Oct 09
Role: OBIEE DEVELOPER

Confidential, provides information technology services as well as business process outsourcing solutions to businesses, government agencies, and non-profit organizations .In one of the project I worked as a OBIEE Developer on Oracle Supply Chain and Order Management Analytics to gain detailed insight into orders and inventory data .

Responsibilities:

• Interacted with Business users and involved in gathering the business requirements.
• Analyzed technical requirements and used metadata designing principles to design repository and followed best practices.
• Identified Facts and Dimensions (with levels & hierarchy)
• Design and Developed repository (.rpd) that consists of physical layer, business model / layers with aggregates & dimensions, presentation layers with catalogs & folders and external table security with session variables using Oracle BI Analytics Administration tool.
• Developed many Dashboards / Reports for providing analytical information using Oracle BI Answers and Dashboards.
• Developed and debugged many Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Alerts, Guided Navigation, and Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters.
• Created iBots using Oracle BI Delivers to deliver reports to different devices across enterprise.
• Integrated data into Hyperion cubes and helped in the implementation of Hyperion planning application.

Environment: Oracle BIEE 10.1.3.4, DAC 7.9.6,Siebel Analytics 7.8.5,BI publisher, Informatica Power Center 8.1, Oracle 10g, PL/SQL, DB2, Windows 2003 server, UNIX.

Confidential, Jacksonville FL Feb 06 - Dec 07
Role:OBIEE/ ETL Developer

Confidential, offers a robust and flexible suite of services designed to meet each client\'s needs.Comprehensive administration services for employee stock option, mortgage loans, personal loans and stock purchase plans. As a Sr. OBIEE developer, I worked on the Financial analytics. This Project is to convert all the Existing Crystal Reporting System to Oracle Business Intelligence.

Responsibilities:

• Created and administered the Physical Layer, Business Model and Mapping Layer, Presentation Layer in OBIEErepository.
• Createdconnection pools, physical tables, defined joinsand implementedauthorizationsin the physical layer of the repository.
• Developed customreports/Ad-hocqueries usingOBIEE Answersand assigned them to application specific dashboards.
• Developed different kinds of reports (pivots, charts, tables) using global and local filters.Configure Interactive Dashboards withdelivers/iBotsto alert the marketing team about business changes.Managed day-to-dayRpd, OBIEE Delivers, SchedulerandiBots.
• Managedsecurity privilegesfor each subject area and dashboards according to user requirements.
• Security management for users, groups and web-groups using the various authentication systems (Database table, Dashboard / Report-level security).
• Createdgroupsin the repository and addedusersto the groups and granted privileges
• Developed various slowly changing dimensions Type1, Type2 and slowly growing dimensional mappings according to the data mart schemas.
• Created Connected and Unconnected Stored Procedure Transformations for pre & post load sessions.
• Developed UNIX shell scripts to get data from external systems flat files to EDW stage area, and to schedule various workflows to load the data into target system.
• Developed and Scheduled workflows using workflow manager created and modified parameter files according to the business requirements.

Environment: OBIEE 10.1.3.1, Siebel Analytics 7.7, Informatica Power Center 6.1, Oracle 8i, SQL Server, Flat files, ERP files, Windows 2000, UNIX Shell scripting, Test Director.

Confidential, BOSTON MA July 05 - jan 06
Role: INFORMATICA Developer

Confidential, is a global health services company, owing to its expanding international footprint and the fact that it provides administrative services only. As a Informatica Developer I Worked on the supply chain where data is loaded daily.

Responsibilities:

• Interacted with Business Analyst to understand the data warehouse requirements
• Analyzed Specifications and involved in identifying the source data that needs to be moved to DM.
• Involved in developing dimensional data model for the Power Center data mart using star schema models.
• Identified and created different source definitions to extract data from input sources like Flat files, SQL Server and load into relational tables like Oracle.
• Created various database objects in Data Mart as per changing technical requirements.
• Designed Reusable Transformations using Transformation Designer like for Date Conversion etc.

Environment: Informatica Power Center 6.x, Oracle 8i, SQL Server, SQL*Plus, SQL*Loader, Windows NT.

Confidential, INDIA July 04 - June 05
Role: ETL/INFORMATICA Developer

Responsibilities:

• Involved in requirement gathering from the business users and converted them into mapping documentation.
• Created mapping documents with the required Transformation logic, Sources and Targets for Facts and Dimensions.
• Analyzed dependencies and developed transformation logic for various enhancements and integrating various sub marts.
• Developed various Slowly changing dimensions Type1, Type2 and Slowly growing dimensional mappings according to the data mart schemas.
• Created Connected and Unconnected Stored Procedure Transformations for pre & post load sessions.
• Developed Workflows for initial loading, historical data loading, Near Real Time data loading and Recovery data loading using sessions, worklets, commands, decisions, events and timers.
• Developed test cases, conducted unit tests, system tests and user acceptance tests
• Migrated meta data from development to staging and production systems,
• Developed UNIX shell scripts to get data from external systems flat files to EDW stage area, and to schedule various workflows to load the data into target system.

Environment: Informatica Power Center 7. X/6.2 .x, Oracle 8i/9i DB2, Windows 2000