SUMMARY

• Over 8 years of IT experience in analysis, design, development, implementation and testing of various client/server and data warehousing technologies
• Over 7+ years of experience on Siebel Analytics 7.7.1, 7.8.5/OBIEE 10.1.3.x/OBIEE 11.1.1.x/OBIA 7.9.6.2 in designing dashboards (Oracle/Siebel), answers (Oracle/Siebel), and analytics/oracle administration tool.
• Extensive experience in the Siebel Analytics RPD metadata. customized siebel analytics repository, defined physical data layer, developed business model and presentation Layer using siebel analytics administration tool
• Excellent in developing business intelligent solutions using data warehouse and OLAP techniques.
• Good Knowledge of Agile Methodology (SCRUM and Extreme Programming and Unifies Process).
• Strong data modeling experience using dimensional data modeling star schema/snow flake schema, fact and dimension tables, physical and logical data modeling.
• Experience in Informatica (data warehousing ETL experience using Informatica PowerCenter 8.1/7.1/6.2, source analyzer, mapping designer, mapplet designer, transformation designer, warehouse designer, repository manager and server manager).
• Extensively used all the transformation components like source qualifier, expression, aggregator, filter, router, sorter, update strategy, lookup, joiner and sequence generator and experienced in tuning mappings
• Proficient in installing and configuring Siebel Analytics/OBIEE on windows operating system.
• Expertise in data warehousing, data analysis, reporting, ETL, data modeling, development, maintenance, testing and documentation.
• Extensive experience in Oracle 11g/10g/9i/8i - design and developing stored procedures/packages, database triggers, cursors using SQL, PL/SQL.
• Expert in database design, relational integrity constraints, normalization, denormalization of database.
• Strong knowledge of SQL*Loader for extraction of data from legacy databases to Siebel interface tables.
• Experience in performance tuning of database.
• Excellent communication, leadership, organizational, analytical and problem solving skills.

TECHNICAL SKILLS

• Oracle 8i 9i 10g 11g
• SQL Server 2000
• 2005/2008
• MS Access.
• C
• C++
• SQL
• PL-SQL
• Informatica (Power center 8.1/7.1/ 6.2)
• Oracle OLAP
• Siebel Analytics 7.8.5/7.7.1
• OBIEE 10.1.3.x
• OBIEE 11.1.1.x
• OBIA SQL Loader
• People Soft HR Analytics
• Oracle Finance Analytics
• TOAD
• SQL Developer
• Unix Shell Scripting
• JavaScript
• HTML
• XML
• Windows 98/2000/XP/Vista
• Unix
• Linux
• Aix
• SDLC
• SCRUM.

PROFESSIONAL EXPERIENCE

Confidential, Savannah GA

Sr. OBIEE Developer/ADMIN

Environment: Oracle 11g, OBIEE 10.1.3.4/11.1.1. x, SQL, Toad, Cygwin, UNIX Shell Scripting.

Responsibilities:

• Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.
• Upgrading of existing Sprint 2 system to Sprint 2.1 in test, UAT, production, break fix and training environment.
• Installed and configured of Oracle BI Publisher on Red hat 5.0, IBM-AIX 7.1
• Installed and configured OBIEE on Red hat 5.0, IBM-AIX 7.1
• Configured UCM with BIPublisher/OBIEE
• Prepared the webcat and repository. Created security groups and application roles.
• Administration of the existing environment with respect to changes and the development changes and implementation feasibility.
• Implemented and configured iBot on development, Test, Production and UAT assigned users are groups and also masked the data and restricted users.
• Configured BI publisher and implemented the HIX template in the report.
• Worked on the memory utilization and reports using report optimization technique.
• Implemented User access, authentication and authorization following best practices in the Repository.
• Coordinated with business users in understating and implementing the security feature. Using Object level and Data level Security.
• Worked on creating deadlines for the development and engineering team to make application ready to deploy.
• Worked extensively on reports and dashboards to minimize the source system upgrade impact and data availability
• Worked on Repository (.rpd), customized the RPD with the requirements of the End User. Designed and Developed the three layers (Physical, BMM, Presentation)
• Developed Dashboards, Reports, drillable charts, pivot table views, guided navigation, prompts, and compound layout.
• Implemented Dimensional hierarchies, Level based measures, Fragmentation content, Aggregation, Complex joins in rpd, Configured Repository and Session variables and Initialization block for Dynamic, Customized, Prebuilt reports.
• Implemented Delivers using iBots for delivery of report through email, hand held devices and mobile phones.
• Worked on administration ofOBIEECache management, Security Management for Users, groups and web groups using the various authentication system such as LDAP Authentication using Session variable as well as Dash board / Report level Security.
• Implemented Row Level Security.
• Lead of analytics tier in disaster recovery activity. Activity objective is to bring the application live after complete disaster of the environment. Involved in cross training to the new employees to understand the Application and responsibilities
• As per client requirement me have done the Skin and Custom Style Changes in Analytics.
• Integrated OBIEE with OUD and OAM.
• Automated the Services Start and Stop using Shell Scripts
• Automated backup of Catalog, Repository and Config Files using Shell Scripts
• Configured OBIEE and BIP with Oracle UCM(Web Center Content)
• Worked on Oracle BI EE Administration tool for customizing the Physical layer, Business layer, Presentation layer and modifying it according to the business requirements.
• Worked with the physical layer to create Connection pools and imported physical tables and defined joins.
• Developed and customized some of the existing multiple Dimensions (Drill-Down Hierarchies) & Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Created Global/Local Prompts, Narrative Views, Filters, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Created Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.
• Developed Dashboards for each of Metrics by embedding Reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Used OBIEE Delivers to automate iBot queries, obtain weekly reports and to send alerts to related managers and secured team members.
• Worked in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.
• Enhance performance of Reports/Dashboards by implementing the Aggregate tables, Table execution path by making use of hints, Creation/Re-building of Indices and Cache Management.
• Created and saved several BI Publisher reports by selecting an Answers request as the Data Source.
• Built multiple execution plans in DAC for weekly and daily loads.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of the Customer Sales Business modules (Reports, Dashboards, Security and Star schema).
• Build test cases and tested the Reports / Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
• Troubleshoot any issues with the deployment process, database issues, applications and development tools.
• Identify Process improvements and implement them.
• Work with data architect to implement the reference data change requests.
• Implement the database change requests (DBCR) and data change requests (DCR).
• Provide support to the application teams on general Database Requests.
• Assist the application teams with running Repository Creation Utility (RCU) to install the underlying database schemas.
• Create naming standards for all the DDL and DML scripts.
• Perform reviews on the design and code frequently to ensure the project standards are being adhered to.
• Provide technical support to application development and test teams.
• Assist with impact analysis of any changes made to the database objects.
• Creating and Scheduling Oracle Backend Process Jobs in Crontab
• Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/ImportDatapumputilities).

Confidential, Columbus Oh

Oracle Business Intelligence Developer/ADMIN

Environment: Oracle 10g, OBIEE 10.1.3.4, OBIEE 11.1.1.X, Informatica 8.6.1, SQL, Toad, Cygwin, UNIX Shell Scripting.

Responsibilities:

• Participated in user meetings to understand the requirements.
• Involved in upgrade of existing Sprint 2 system to Sprint 2.1 in test, UAT, production, break fix and training environment.
• Involved in upgrade whereOBIEE10 g was replaced byOBIEE11g in spectrum along with the existing environment.
• Involved in setup, installation, configuration ofOBIEE11g in Linux operating system also integrating with the existing environment. Involved in trouble shooting of errors encountered. And worked with Oracle support to analyze the issue.
• Executed the run installer for Data ware house and Informatica mappings as a standard process. Emplacing the OHSCDA halp and image files and folders.
• Prepared the webcat and repository. Created security groups and application roles for OHSCDA.
• Administration of the existing environment with respect to changes and the development changes and implementation feasibility.
• Worked on Oracle application server and Apache web server.
• Worked on the environment setup of development, Test, Production, UAT, Training and break fix servers.
• Implemented and documented the best practices which are followed during the application installation and configuration.
• Worked on the Production environment and configured the clustered environment on the Linux system.
• Implemented and configured iBot on development, Test, Production and UAT assigned users are groups and also masked the data and restricted users.
• Configured BI publisher and implemented the HIX template in the report.
• Worked on the memory utilization and reports using report optimization technique.
• Implemented User access, authentication and authorization following best practices in the Repository.
• Coordinated with business users in understating and implementing the security feature. Using Object level and Data level Security.
• Worked on creating deadlines for the development and engineering team to make application ready to deploy. Migration of Repository, Webcat and Informatica mapping across the environment.
• Create new tables and schemas as a part of Fusion middle ware setup. As part of OHSCDA2.1 upgrade new informatica mappings were created and synchronized by creating new database tables in the Data ware house.
• Created shell scripts to automate the start and stop services of theAdminserver, node manager, Managed server and OBI server component services.
• Worked on various layers ofOBIEEarchitecture Application layer, Presentation layer.
• Involved in developing the Incremental ETL process me.e., Mappings & Mapplets using various
• Transformations and Workflows with Sessions or Tasks.
• Identified and worked with various application areas in identifying, analyzing, and documenting various information sources solutions to meet the business requirements
• Extensively worked on OBIEE repository modeling at Physical, BMM and presentation layer
• Designed, developed and customized Reports and Dashboards using different analytical views.
• Designed and tested Reports in the Dashboards for the Oracle Financial Analytics and created the adhoc reports according to the client needs.
• Extensively worked with BI Publisher Reports and resolved the issues relating to BI Publisher and OBIEE integration.
• Created BI Publisher reports using OBIEE Answers: Union Report, Chart View, Drill Down.
• Created session variables for users to provide row- level security to build the query
• Implemented Row level, Column level and object level security.
• Used various options in an OBIEE to improve the performance of reports.
• Used OBIEE Answers to create the Financial Statement reports and Dashboards as per the detailed design requirements
• Coordinated the OBIEE RPD and Presentation Catalog objects migration across instances.
• Merged Presentation Catalogs (Web Catalogs) using OBIEE Catalog Manager
• Set permissions on users in Catalog Manager.
• Involved in setting up and working in multi-user developer (MUD) environment
• Written Shell script to change the format of a column in all the reports of a particular subject area in the web catalog.
• Written shell script for Regression test.
• Performed Regression test.
• Extensively used time series functions AGO and TODATE
• Extensively used repository variables and session variables and initialization blocks.
• Implemented LDAP security.
• Worked on Answers, Dashboards and Delivers.
• Configured web catalog objects.
• Created dashboard prompts and column prompts to filter the selection criteria.
• Developed 2 Dashboards / 8 reports using different views (pivot table, charts, graphs, table, view selector, column selector).
• Configured permissions to restrict the access of users to the dashboards.

Confidential, Easton, PA

Oracle Business Intelligence Consultant

Responsibilities:

• Participated in user meetings to understand the requirements.
• Created tables and views in the database.
• Data loading using Toad.
• Developed 3 layers of repository Physical layer, BMM layer and Presentation layer in Oracle BI Admin tool.
• Extensively used time series functions AGO and TODATE
• Extensively used repository variables and session variables and initialization blocks.
• Implemented LDAP security.
• Worked extensively on Answers, Dashboards and Delivers.
• Configured web catalog objects.
• Created dashboard prompts and column prompts to filter the selection criteria.
• Developed 3 Dashboards / 13 reports using different views (pivot table, charts, graphs, table, view selector, column selector).
• Configured permissions to restrict the access of users to the dashboards.
• Performed unit testing of reports.

Confidential, Portland, OR

Sr. Oracle Business Intelligence Consultant

Environment: Oracle 11g, SAP BW, OBIEE 10.1.3.4, Oracle BI Apps(Supply chain Analytics), BI Publisher, ODI 10.1.3.5, SQL Developer, UNIX.

Responsibilities:

• Responsible for full life cycle implementation of OBIEE
• Participated in user meetings to understand the requirements
• Developed Metadata repository (.rpd) that consists of Physical, BMM and Presentation layer using Oracle BI administration tool.
• Created Alias Tables, Views and Dimensional Hierarchies.
• Developed Calculated Measures and assigned these Aggregation levels based on Dimension Hierarchies.
• Implemented external table security with session variables, tested and validated the business model and repository level calculations using Oracle BI Administration tool.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Worked extensively on Answers, Delivers, and Interactive Dashboards for Procurement and Spend Analytics.
• Developed standard and custom SAP BW reports in OBIEE
• Performed Customization of dashboards
• Developed 11 Dashboards / 53 Reports using different Views (Table, Pivot Table, Chart and Column Selector), with guided navigation and dashboard and page prompts.
• Created users, groups, configured the permissions in the administration tool and verified the Permissions of the users in web catalog
• Developed and modified reports in BI Publisher
• Performed unit testing of the reports
• Involved in UAT.

Confidential, Wilsonville, OR

Sr. Oracle Business Intelligence Consultant

Environment: Oracle 10g, MS SQL, OBIEE 10.1.3.3.2 , BI Publisher, UNIX Shell Scripting, MS Visio, MS Excel

Responsibilities:

• Responsible for full cycle implementation of OBIEE.
• Lead an OBIEE configuration team or development team, ensuring design, development and testing work is completed to standard and on time.
• Captured and documented Management Information/Business Intelligence requirements from clients, via interviews or workshops, ensuring suitable balance of business needs and delivery feasibility.
• Designed, configured and documented Logical and Physical Data Model and ETL process and mapping configuration.
• Developed Metadata repository (.rpd) that consists of Physical, BMM and Presentation layer using Oracle BI administration tool.
• Implemented external table security with session variables, tested and validated the business model and repository level calculations using Oracle BI Administration tool.
• Implemented object-level security to restrict the access of data.
• Used Ago and Todate functions extensively.
• Performed cache management using event poling table, cache persistence time, seeding the cache.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Extensively used SQL queries, Indexing, Triggers.
• Developed 3 Dashboards / 27 Reports using different Views (Pivot Table, Chart and Column Selector), with drill-down and drill across capabilities, guided navigation and dashboard and page prompts.
• Used BI Publisher to create reports from an Answers Request, and from BI Server data.
• Performance Tuning using optimization efforts such as re-organizing the data, aggregate navigation, Cache Management, indexes, Oracle materialized views and reports changes
• Involved in Reconciliation Process Oracle BI Reports output with Cognos Reports.
• Prepared and executed Component, System and User Acceptance testing, including bug resolution.
• Involved in OBIEE installation and configuration in LINUX environment.
• Created reports, dashboards, customizing login screen, portal banner.

Confidential, San Fransico, CA

OBIEE Consultant

Environment: Oracle 10g, Informatica 8.1.1, OBIEE 10.1.3.2, BI Publisher, Toad, SQL, SQL * Loader, PL/SQL Procedures, Windows 2000.

Responsibilities:

• Participated in User Meetings to understand the requirements.
• Worked closely with the data modeler in creating logical data model (Star Schema).
• Built the OBIEE repository/metadata (Physical Layer, Business Model and Mapping Layer and Presentation Layer) and created the subject area where reporting and analysis are centered around.
• Developed calculated measures and dimension hierarchies in the Business Model and Mapping Layer
• Configured web catalog objects (Dashboards, Pages, Folders, Reports)
• Implemented data level and object level security.
• Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities based on organization’s and product’s hierarchies
• Implemented different views of report me.e. Pivot table, Titles, Graph, Filters etc.
• Generated Dashboards to provide insight into Sales Analytics, Activity Analytics.
• Created users, groups, configured the permissions in the administration tool and verified the Permissions of the users in web catalog.
• Assisted in creation of pivot table requests allowing manager’s to analyze the business/data from different perspectives.
• Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Installed and configured Oracle BI Publisher and integrated it with Oracle BI Presentation services.
• Developed and modified reports in BI Publisher.
• Extensively used SQL queries, Procedures, Triggers.
• Developed user guides for the end users. User guide contained some screenshots of high level reports and also provides instructions in accessing them.
• Also participated in developing ETL design using Informatica, used Transformations like Aggregator, Joiner, Update, Filter, Lookup, Sorter.

Confidential, Fort Lauderdale, FL

Siebel Analytics Consultant

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements.
• Involved in creating the Star Schema, Logical and Physical Modeling.
• Built the Analytics repository (Physical Layer, Business Model and Mapping Layer and Presentation Layer).
• Created Complex Joins, Alias Tables and Views.
• Tuned Siebel Analytics Reports and designed Query Caching and Data Caching for Performance Gains.
• Developed Calculated Measures and assigned these Aggregation levels based on Dimension Hierarchies.
• Created Aggregated Tables and Configured the Content in Business Model Layer to use the Aggregate Tables for better Performance.
• Worked extensively on Answers, Delivers, and Interactive Dashboards.
• Developed Various Dashboards and Reports and Created the Business Model for Ad-hoc queries using Siebel Analytics Answers and assigning them to application specific dashboards.
• Designed the Row Level Security for the Managers to View the Reports pertaining to their Region.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Managed and provided Permissions for Reports and Dashboards in Siebel Analytics Presentation Services Web Catalog.
• Developed Logical and Physical Data Models that capture current state/future state data elements and data flows using ER Studio.
• Created Transformations like Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• Created Complex Mappings using Lookup, Sorter, Aggregator, and Router transformations for populating Target Table in Efficient manner.
• Created Mapplet and used them in different Mappings.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Extensively Used Sql queries, Triggers, Indexes, Oracle Functions.

Confidential

Database Developer

Responsibilities:

• Wrote several stored procedures/triggers in Oracle (PL/SQL) for the enterprise portal application and data merge.
• Involved in daily, weekly and monthly load of data from mainframe data set to Oracle database.
• Worked on very large database environment in terabytes and tuned queries for performance. Created and maintained parallel queries for very large datasets.
• Creating temporary tables and indexes for loading and updating data.
• Worked on queuing for sending XML data to the calling java APIs.
• Data loading using SQL *Loader.
• Imported/exported several databases through various environments
• Developed and maintained lot of batch scripts in KSH scripts for the production, like scheduled data loading, Create, databases, Tuning and backup and Recovery.