SUMMARY

Oracle BI reports are used by Advisors, Regional, Managers, and Group Managers Line of Business. The reports cater across various Groups, Regions, and Teams Employees. These reports are enhanced or developed on yearly basis so that they provide new organizational enhancements.

Roles Responsibilities:

• Work closely with the Onsite coordinator to understand the requirements and drive the development team for successful implementation maintaining the deadline
• Actively take part in the Development process by creating various complex reports in Answers and placing them in Dashboard
• Customize the look and feel of OBI Dashboard and Answers by creating customized Styles.
• Reviewed the business requirements and translated them to technical design specifications like HLD and LLD
• Developed meta data repository in physical layer, business model and mapping layer and presentation layer of OBI administration tool
• Creating the Reports using multiple Views and Formats
• Gathering requirements, Analysis, functional and technical specifications, interacting with Business Managers and End users.
• Configured and Creating the NQS Config.INI file sections
• Worked and Configured with a Pivot Table, Narrative View, Charts.
• Creating an Interactive Dashboards and Dashboard Prompts using Presentation Variables.
• Involved in Creating Delivers and configuring scheduler tables and scheduler.
• Worked in Administration Tab. Creating users, groups, assign privileges
• Creating the Business Models, Logical Columns, Logical Joins, and Creating Dimensional Hierarchies.
• Involved in Initialization Blocks and Variables Session, Dynamic Repository .
• Worked on Column Selectors and View Selectors.
• Involved in unit testing developing the design documents.

Title : F I A Fraud Image Analysis

Confidential

Environment : OBIEE, Oracle

Roles Responsibilities:

• Developing custom dashboards and reports using OBI Answers. Created Prompts, Filters and charts, pivot tables and views as per client requirement.
• Creating Dashboards, Charts, and Tables using OBI Answers.
• Filters/Column selectors
• Giving security permission / privileges as per the role of each user
• Developing business reports using OBI Answers and to display the reports in Dashboards
• Organizing the presentation layer in a format that is easy for end user to use as basis for reporting.
• Creation of reports in OBI
• Imported physical tables, Connection pool and defined joins and implemented in the physical layer of the repository.
• Worked on business model layer to include numerous calculated fields using expression builder.
• Created logical joins between fact and dimension tables in business model layer.
• Organizing the presentation layer in a format that is easy for end user to use as basis for reporting.
• Implemented Object level security
• Worked on OBI Admin Tool of Layers like Physical, BMM, and Presentation.
• Modifying the dimension hierarchies and measures for Drill downs.
• Worked on Analytics Web like Answers, Dashboards and Views.
• Development of all layers of OBI Physical, Business Model, Presentation layer.
• Creating value based Fragmentation on Dimension Tables.
• Creating and Configuring OBI Security and creating User's Groups and setting Privileges.
• Defining Dimension Hierarchies for the Dimension Logical Table
• Designed customized OBI answers views and charts, create and save filters, create charts and tables in OBIEE answers.
• Developing custom dashboards and reports using OBI Answers.
• Involved in unit testing developing the design documents

Title : BACE Billing Automation Configuration Environment .

Confidential

Environment : Siebel Analytics, Oracle 9i

Roles Responsibilities:

• Using the Siebel Analytics Administration tool to import data and enhance meta-data to Build Business model
• Build Repository at 3 layers Physical Layer connecting Data sources importing schema , Business Model data mapping created Logical tables data source mapping Presentation layer level created presentation catalogs , created presentation folders tested.
• Creating and managing Repository Groups, Initialization Blocks and User Administration using Siebel Analytics Administration Tool and Security Manager.
• Reconfigured the Analytics server metadata .rpd using the Admin tool to develop a reporting environment according to user requirements.
• Involved in the Creation of Dimensions in Business Model and Mapping Layer.
• Created Hierarchy level for dimensions to make drill-down on reports.
• Manual Testing/Database Testing.
• Developed custom dashboards and reports using Siebel Answers.

ITech Minds Pvt.ltd

Confidential

Environment : Oracle 9i, SQL Loader, UNIX

Project Synopsis:

Confidential is a Customer Relation Management System to register customer's requests, complaints and to align these requests with respective departments. It has the features like Auto Escalation. This project is migrated from DB2 to Oracle. CRM applications project is both in-house resource management as well as Customer service management. It also gives the support to decision making for the top management. As a backend programmer I have used oracle 9i, Unix HP and our Team size is 10 members.

Roles Responsibilities:

• Data Migration using SQL Loader and UTL FILE.
• UNIX Shell Scripting for analysis module and operation module to alert manager for pending Calls.
• Writing Stored Procedures and Triggers for operation Module.
• Implementing the projects as per the application requirements
• Team Coordination
• Performing the system coding, testing and debugging

Confidential

Environment : Oracle 9i, SQL Loader

Roles Responsibilities:

• Involved in the writing stored procedures and triggers
• Involved in the Data Migration using SQL Loader, UTL FILE package for data loading.
• Performing the system coding, testing and debugging
• Team Coordination

Confidential

Environment : Oracle 9i, SQL Loader

Roles Responsibilities:

• Writing Stored Procedures, Functions and Triggers.
• Data Migration using SQL Loader, UTL FILE package for loading data.
• Implementing the projects as per the application requirements.
• Team Coordination.
• Performing the system coding, testing and debugging.

Confidential

Environment : Oracle 9i, SQL Loader

Roles Responsibilities:

• Writing Stored Procedures, Functions and Triggers.
• Data Migration using SQL Loader, UTL FILE package for loading data into Oracle.
• Implementing the projects as per the application requirements.
• Team Coordination.
• Performing the system coding, testing and debugging.

Confidential

Environment : Oracle 9i, SQL Loader

Roles Responsibilities:

• Writing Stored Procedures, Functions and Triggers.
• Data Migration using SQL Loader, UTL FILE package for loading data into Oracle.