SUMMARY

• IT Professional with over 9+ years of experience in application, designing, development and implementation of Oracle Business Intelligence, BI Publisher, Siebel Analytics, Informatica and RDBMS projects.
• Expertise in gathering Business Requirements, assessing & developing Business Intelligence Program strategies, and designing and implementing BI information & analytical solutions.
• Experience with the latest version of OBIEE Tools such as, OBIEE and BI Publisher 12C and older.
• Extensive experience on OBIEE/Siebel Analytics web features (Answers, Dashboards, Agents/ I - Bots, BI Publisher, Scheduler).
• Extensive experience on OBIEE/Siebel Analytics Repository (Physical Layer, Business Model & Mapping Layer and Presentation layer).
• Extensive experience on OBIEE/Siebel Analytics administration features (i.e. Security, OID, cache, usage tracking, dimensional hierarchy, aggregate navigation, MUD, Integration Variables/Initialization Blocks configuration).
• Expertise in implementing the Oracle BI / Siebel Security Setup (groups, data access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Detail understanding of OLTP and OLAP Data models to create and manage the repository with the available metadata using OBIEE /Siebel Analytics.
• Expertise in Performance Tuning of Data Warehouses by implementing the materialized views, bitmapped indexes
• Strong understanding and designing of Schemas such as Star schema and Snowflake schema used in relational, dimensional and multidimensional modeling.
• Strong experience in Database such as Oracle 11g/10g/9i.
• Team player and self-starter with good communication skills and ability to work independently as well as part of a team
• Multi-platform experience on UNIX / Linux and Windows Server family.

TECHNICAL SKILLS

Business Intelligence Tools: OBIEE 12C, OBIEE 11.x, OBIEE 10.x, Siebel Analytics 7.x, BI Publisher

ETL Tool: Golden Gate, Informatica Power Center 5.x

Databases: Oracle 11g/10g/9i

Languages/ Technologies: SQL, PL/SQL, HTML and XML

Operating Systems: UNIX, Linux, Windows 2000/XP/7

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Sr. OBIEE Application System Analyst/Programmer and BI Team Lead

Responsibilities:

• As a programmer analyst:
• Work and customize financial analytics dashboards like AR (Accounts Receivable) and created Financial reports as per detailed design requirements.
• Worked on Usage Tracking, Collections Data, Audit and HR Analytics dashboards like PeopleSoft.
• Design and Configure Dashboards for different groups of users which include Managers, Functional Heads, Department Heads and Broad Band Executives.
• Identify the granularity level of the data required to be available for analysis.
• Develop Metadata repository (rpd), configure metadata in the Business Model Layer & Physical Data Model and Web Catalog Objects as per the reporting requirements using OBIEE Admin and Web tool.
• Develop Business Intelligence Analysis, Dashboards and BI Publisher reports using Oracle Business Intelligence Enterprise Edition (OBIEE) 11g.
• Create measures in Administration tool for the requirements using expression builder.
• Develop different kinds of Reports (pivots, charts, tabular, graphs etc).
• Developed many ad-hoc reports for performance and measurement analysis, using SQL.
• Work on Oracle BI Answers to build Interactive Dashboards with drill-down capabilities.
• Implement dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Set up OID Groups and Users, WebLogic Application Roles, RPD data level security, Catalog security, essentially all realms of security involved with setting up Dashboards and BI Publisher Reports.
• Implement and Administer OBI security using a LDAP security model.
• Other admin duties such as access management, migration process, troubleshoot and resolve issues, daily maintenance.
• As a team lead of the reporting team:
• Train and mentor Junior and new developers on the team.
• Prioritize BI Releases.
• Prepare and allocate workload and daily jobs.
• Monitor and manage team performance and progress.
• Coordinate and direct multiple projects that are at various stages.
• Research new application development techniques.
• Work with internal users, other team leads and managers to develop Software Development Life Cycle by gathering requirements, analyze data, use BI applications to implement projects.

Environment: OBIEE 12C/ OBIEE 11.1.1.6.12/ OBIEE 11.1.1.6.8/ OBIEE 11.1.1.5, BI Publisher, Oracle 11g, OID, SQL Developer, Golden Gate, Windows XP/7, UNIX

Confidential, Boston, MA

OBIEE Report Developer

Responsibilities:

• Worked closely with the business users and developers to make sure that business requirements are correctly translated into database schemas and ultimately into the application.
• Identified the tables that needed to be bought in from Cisco data center.
• Designed and developed the 3 layers of the repository, Physical Layer, Business Model and Mapping Layer and the Presentation Layer.
• Imported Physical tables from Oracle database and defined relations between Physical tables at the Physical Layer
• Created Business Facts, Dimensions and defined Logical relation between them at the Business model and mapping layer.
• Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency Check.
• Worked on Initialization Blocks and Variables development to achieve security and personalization.
• Set up data level security for different application roles/groups.
• Caching options configured and defined overall cache strategy.
• Build mockup reports from crystal reports during the requirement phase to visualize the reports and clarify requirements
• Designed, developed and implemented complexOBIEEuser interface objects (e.g. reports, ad-hoc queries, dashboards, etc.)
• Worked extensively on OBIEE Answers to create different kinds of reports (rank, union, pivot, charts, graphs).
• Used a new feature in OBIEE 11g Selection Steps, to make complex reports simpler and faster.
• Used conditional formatting and data formatting extensively.
• Implemented Dynamic Dashboard Prompts to zoom into different segments of the Brokers, to achieve performance optimization and easy navigation of reports.
• Used session variable and repository variables to filter reports and dashboard prompts.
• Applied security on dashboard sections and setup access and query privileges.
• Performed validation of data in the reports and dashboards.
• Enhanced Query performance, by analyzing & modifying SQL Query and Filters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution.
• Worked extensively on BI Publisher, creating reports and bursting them to various users.
• Helped set up daily, monthly and quarterly jobs for bursting various reports to end users.
• Worked on various ad hoc requests and trouble shoot reporting issues.
• Enhanced existing reports and created customized dashboards.

Environment: OBIEE 11.1.1.5/ OBIEE 11.1.1.3, BI Publisher,Oracle10g/ 11g, PL/SQL developer, Golden Gate, Windows XP

Confidential, Edison, NJ

OBIEE Report Developer

Responsibilities:

• Identified the granularity level of the data required to be available for analysis.
• Developed Metadata repository (.rpd), configured metadata in the Business Model Layer & Physical Data Model and Web Catalog Objects as per the reporting requirements using OBIEE Admin and Web tool.
• Worked on Oracle BI Answers to build Interactive Dashboards with drill-down capabilities.
• Mapped the configurations to accommodate for the territorial hierarchy that were accommodated via chart drilldowns
• Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives provided optimized Analytics request using column selector.
• Implemented dynamic dashboard prom.
• pts to zoom into particular segments of the business in a performance-optimized manner.
• Implemented and Administered OBI security using an external security model consisting of Oracle user accounts and database tables.
• Created templates for presenting results and Analytics and modified the OBIEE Dashboard using cascading style sheets.
• Involved in Reconciliation Process while testing loaded data with user reports.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.

Environment: OBIEE 10.1.3.4, Oracle10g, PL/SQL developer, Windows XP

Confidential

Jr. Siebel Analytics Developer

Responsibilities:

• Involved in the Analysis, functional and technical specifications, development, and deployment and testing of the project
• Configuration management of Siebel and Informatica custom components.
• Gathered business needs by Interacting with the business users for analytical data requirements.
• Build prototype reports from excel spreadsheet during the requirement phase to visualize the reports and clarify requirements.
• Requirement validation of the reports and drilldowns.
• Designed repository based on business requirements, followed design best practices for the RPD and Dashboard designs.
• Worked on the design of logical data model.
• Customized the Siebel Analytics Repository (physical, BMM, and presentation layers).
• Worked on repository and session variables.
• Performed production support for the project.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Customized Claims, Holdings and Service requests star schemas.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.

Environment: Siebel Analytics 7.5, Informatica Power Center 5.1, Oracle9i, SQL Plus, Windows