PROFESIONAL SUMMARY

Around 8 years of software development in the Information Technology specifically in Business Intelligence Applications, OBIEE 10g/11g, BI Publisher and Informatica/DAC. Extensive experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Analysis/Answers, creating reports / Dashboards, cache monitor, and building Repository using Siebel Analytics/OBIEE. Proficient in Data Modeling, Dimensional modeling, and acquired excellent analytical skills, co-ordination, interaction skills, strong leadership potential.

KEY STRENGTH INCLUDE

• Handled Full systems Development Life-Cycle Implementation of OBIEE Projects.
• Experience in Requirements gathering, Analysis, Design, Development, Implementation and Testing of OBIEE Reports, dashboards and ETL Processes. Key member in client interaction and compiling end-user specifications, modification and testing.
• Experience in Oracle BI Apps 7.9.6 SCM Supply Chain and Order Management Analytics
• Very strong in Configuring Metadata OBIEE repository at three different layers Physical, Business Model and Presentation Layer.
• Experience in creating entity relational dimensional relational data models with Dr. Ralph Kimball Methodology i.e., Star schema and Snowflake schema
• Strong experience in creating Logical tables and columns, Dimensional Hierarchies with drill down, Level Based Measures, Time series wizard, and Repository Variables.
• Expertise in using OBI Answers for creating/managing dashboards, reports, Filters, Views, Charts, Interactive Dashboards with page and dashboard Prompts, handling presentation variables
• Involved in OBIEE Administration. Cache management, User authentication, based Permission and Security data and object level .
• Strong expertise in Implementing MUD Multi User Development Environment.
• Exposure on various projects involving Data warehousing using Informatica Power Center 9.x
• Experience in Informatica concepts like Source Analyzer, Target Designer, Work Flow Designer and Task Developer.
• Expertise in developing Informatica Mappings/Mapplets using various Transformations Filter, Expressions, Router, Aggregative, Lookups, Update Strategy
• Strong experience in using different Informatica Designer Components. Debugged issues in the mappings with ease and gave prompt solutions to correct failed workflows.
• Expert in writing complex SQL queries, creating Stored Procedures, Triggers, Tuning the code, and also in using SQL Loader for loading data into Data Warehouse/Data Mart.
• Worked on Test Scripts, Test Cases to perform Unit testing, System Testing.
• Experience in extraction of data from various Heterogeneous sources Relational database, Flat Files, XML, Excel to load into data warehouse/data mart targets .
• Excellent skills in understanding business needs and converting them into technical solutions.
• Experience in working with onsite/offshore model projects as coordinator.

RECENT PROJECTS

Clientconfidential

OBIEE Consultant

Responsibilities

• Gathered the Business Requirements from various analysts like planners, supply and quality teams, HR Generalists etc.
• Identifying the gaps and the customizations required in order to achieve the EMR reports and Talent Management Dashboards
• OBIEE customizations in Supply Chain and Order Management analytics to integrate the data from the third party systems called Trackwise and LIMS in order to fit in the business needs of Biogen and also extending the inventory of Supply Chain and Order Management analytics to meet their needs.
• Involved in Repository Configuration, Troubleshooting and Migration. Created/Modified Metadata repository .rpd , Customized BI Repository, defined/developed Physical Data Layer, Business Model and Presentation Layer using BI Administration Tool.
• Modified the existing Business Layer to add more Dimensions in the Oracle BI Admin Tool.
• OBIEE Admin workNew Id creation, Account modification of existing users.
• Implemented OBIEE Security Object Level and Data Level Security in the OBIEE Repository and Answers using Repository Variables, Session Variables and Initialization Blocks.
• Knowledge of setting up and working in MUD Environment.
• Experience on merging repositories Full Patch merge in different environments Dev,Test,Prod
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics. Configured Intelligence dashboards by including embedded content such as links/images HTML objects.
• Worked on Write back functionality of OBIEE to update the database values with the user updated values at the presentation.
• Security management for users, groups and web-groups using the various authentication systems such as LDAP authentication using Session Variables, as well as Dashboard / Report-level security.
• Done the installation and configuration of OBIEE 11.1.1.5 in Development, Test and Production environment and upgraded the 10G RPD and Web catalog to new version.
• Worked extensively on OBIEE 11 G for RPD and Web catalog upgrade and also created new reports.
• Unit, integration and system testing for all components in OBIEE. Test cases have beenprepared and documented the results.
• Create the user guide for end-users and documented design and model for intuitive understanding and future reference.
• 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
• EnvironmentOBIEE 10.1.3.4/ BI Publisher, Oracle 9i/10g, Microsoft Suite, , Siebel 8.0, Documentum, DAC, Remedy, Quality Centre, Test Director

Client confidential

BI Developer

Responsibilities

• Gathered and documented user requirements, Business Requirements and System Requirements from Business users
• Installed and Configured BI Publisher and integrated with MS Word to create BI Publisher report
• Configured Usage Tracking to track usage of reports by users and Subject Area etc.
• Configured BI Scheduler for scheduling proactive agents Ibots and worked on interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler iBots.
• Developed session initialization blocks and variables for data level security.
• Created business model and designed a dummy fact model for the OLTP data model.
• Defined outer joins and logical keys in the business model and put filters to restrict data to only a particular business group.
• Created presentation tables as per Business Area definition in OLTP Screen
• Worked extensively in configuration and development of the OBIEE Web Catalog Reports, Filters, Prompts, and Dashboards
• Created reports in BI Answers depending on business requirements using different views such as view selector, pivot table, table, chart, Metrics Reports etc.,
• Defined object level security by giving permissions to dashboard pages and prompt sections to different user groups.
• Extensively created BI Publisher reports, defined data source, created parameters for prompts and created BI Publisher .RTF Templates for repeated grouping data for different fields in the report.
• Analyzed and helped in modifying the use cases using MS Visio and created the Test cases based on them.
• Executed tests and participated actively in system testing and regression testing.
• Developed and maintained automated test scripts to support regression testing.
• Created and maintained documents, Report Validation Document RVD and Installation verification document to provide the procedures for set up, implementing and maintaining the system and to provide documented instructions for operations associated with the system.

Environment Oracle 11g, OBIEE 11.1.1.5, OBIEE 10.1.3.4, Informatica 9.0.1, SQL Developer, TOAD.

confidential

OBIEE Developer

Responsibilities

• Involved in Gathering, Analyzing Business Requirements for Reports
• Created/Modified Metadata repository .rpd , Customized BI Repository, defined/developed Physical Data Layer, Business Model and Presentation Layer using BI Administration Tool.
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
• Development of interactive flash-based drillable charts such as bar-charts, pie-charts, radars, bubble-charts, etc.
• Worked with Oracle Modules such as Sales and Marketing Analytics.
• Implemented Delivers using iBots for delivery of reports through email, hand-held devices and mobile phones.
• Security management for users, groups and web-groups using the various authentication systems such as LDAP authentication using Session Variables, as well as Dashboard / Report-level security.
• Analytics Application Response-time Performance management using optimization efforts such as aggregate navigation, indexes and Oracle materialized views.
• Implementation of criteria filters to narrow-down the result set from the analytics requests.
• Used Workflow Monitor to monitor the ETL Jobs.
• Life-cycle support for migration efforts from development to QA to production analytics.
• Create the user guide which end-user can follow while accessing the dashboard.

Environment Oracle 11g, OBIEE 10.1.3.4 Physical Layer, Business Model Layer Presentation Layer , Informatica 8.6.1, SQL Developer, Windows 2003 Server, TOAD.

confidential

OBIEE Developer

Responsibilities

• Developed a Business Intelligence BI Environment for the Client Product Claims Management System
• Deliver the Business Information to the end users via web-based end user tools OBIEE in the form of standard reports, dashboards/scorecards, and ad-hoc query capability.
• Created, Administered and Tested the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Analytics Repository .rpd using Oracle BI Administration Tool.
• Worked on Metadata design and development.
• Modified the existing Business Layer to add more Dimensions in the Oracle BI Admin Tool.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration.
• OBIEE Admin work New Id creation, Account modification of existing users, Password reset and deletion of accounts.
• Created materialized views and aggregates to improve performance.
• Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager.
• Used job manager to manage and monitor iBots.
• Analyzed and validated the business model in Oracle BI Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Created Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions based on the Requirements.
• Worked extensively on Oracle Answers, Delivers, and Intelligent Dashboards.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Created Business Model to support Adhoc Reports for User Access based on Requirements.
• Designed the Row Level Security for the Managers to View the Reports pertaining to their Region.
• Created Filters and providing customized prompts appropriately to avoid excessive data showing up on reports.
• Creating QA Test Plans for reports generated. Expertise in writing Test Cases for reports involved from data sources.

Environment Oracle 11g, OBIEE 10.1.3.4 Physical Layer, Business Model Layer Presentation Layer , OBIA 7.9.6, Informatica 8.6.1, SQL Developer , Oracle Answers 10.1.3.4, SQL Developer, Windows 2003 Server, TOAD, HP QC.

confidential

Project Name Consumer Marketing Services

Responsibilities

• Participating in User Meetings to understand the requirements and documenting the functional requirements.
• Ensure the development of the defect enhancements and change requests according to design documents.
• Developing Calculated Measures and dimension hierarchies in the Business Model and Mapping Layer of repository
• Configuring Web Catalog Objects Dashboards, Pages, Folders, Reports
• Implemented column selector to select different column values
• Generating different kinds of reports using Siebel Answers and assigning them to application specific dashboards.
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities based on organization's and product's hierarchies.
• Implementation of different views of report i.e. Pivot table, Titles, Graph, Filters etc.
• Created guided navigation links to help files within the dashboards to help the end users.
• Performed Pre and post implementation testing of Dashboard, Answers and validating repository.
• Creating Users, Groups and giving the permissions in Siebel Analytics Administration Tool and verifying the Permissions of the users in Siebel Analytics web.
• Configured IBots and scheduled reports using ibots configured SMTP server to burst reports to the user mails.
• Assisting in creation of pivot table requests allowing manager's to analyze the business/data from different perspectives.
• Developed user guides for the end users. User guide contained some screenshots of high level reports and also provides instructions in accessing them.
• Also assisted in developing ETL design using OWB.
• Actively participated in unit testing and also assisted the application development team in build and test activities when available
• Actively participated in ongoing production fixing activities.
• Tested and fixed the bugs
• Built and reviewed the documentation to ensure that the team is following the standard documentation.

Environment Siebel Analytics 7.8.5, Oracle Warehouse Builder, Oracle 9i, SQL Query Analyzer, Windows 2000/2003.

confidential

Project Name HWCM Honeywell Contract Manager

Report Developer

Responsibilities

• Responsible for developing OBIEE repository RPD from the scratch. Worked closely with ETL team to understand and implement primary key, foreign key relationship among physical facts and dimension tables.
• Used OBIA packaged solution and customized it as per business requirement along with Siebel Call center Analytics.
• Provided content filtering at BMM layer of RPD and used complex joins on logical data source LTS to join tables in BMM layer.
• Created and managed different functionalities of Siebel Answers combined reports, action link, Navigation link etc. Catalog, Dashboard, Delivers iBots , briefing book etc.
• Automated cache purging process using iBots and configured cache management at various layer i.e. BI server, presentation server, browser etc. Configured Event Polling for clearing the stale cache.
• OBIEE Admin work New Id creation, Account modification of existing users, Password reset and Deletion of accounts
• Installed and configured complete package of OBIEE BI server, Informatica, out of the box RPD and web catalog in development and test instance.
• Developed various test scripts for business users for UAT and assisted them to use and understand the functionality of the tool.
• Worked with the team and a DBA to communicate and negotiate data needs.

Environment Siebel Analytics 7.8.5, Oracle 9i, SQL Server 2005, TOAD, Windows 2000 server, Bugzilla.