SUMMARY:

• Goal oriented, creative IT professional having hands - on experience in all aspects of software development lifecycle (architecture, design, coding, testing and maintenance of software systems). Seeking assignments in IT Program with a growth oriented organization.
• A dynamic professional with 8+ years of rich experience in development which includes maintaining OLAP/OLTP applications by using OBIEE and oracle PL/SQL.
• 5+ years of experience in OBIEE includes building and creating repository(RPD), creating and managing the Oracle Intelligence Dashboards, Answers and creating Delivers and iBots
• Expert in developing Dimensional hierarchies, Expression builder, Time series wizard.
• RPD Development (physical, Business Mapping & Modeling, presentation Layers) by using OBIEE 11.1.1.6.10/ 10.1.3.4.
• Experience working with Analysis (OBIEE 11g) to build reports and customizing them based on requirements
• Develop and support creation of new Ad-hoc Answers requests and Dashboards inOBIEE.
• Performance Tuning OBIEE (aggregation strategy, Cache management,SQL)
• Experience in managing users and groups, setting up their privileges and administering the Object Level Security and Data Level Security using different authentication methods.
• Implement external database authentication security.
• Expert in RPD development and configuring metadata objects (subject area, Alias table)
• End to end BI solutions delivery includes dimensional modeling design and building business models.
• Perform validation of data on the reports and monitor the performance status of the same
• Familiar with BI Publisher.
• Knowledge of OBIEE Architecture.
• Strong programming experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL and PL/SQL.
• Good Knowledge on Data Warehousing concepts i.e Star Schema & Snowflake schema.
• Familiar with SDLC Agile and waterfall methodology.
• Functional knowledge on Oracle GL.
• Planning and executing all phases of software life cycle starting with requirement study, Analysis, design, development, testing, implementation and production support.
• Strong communication skills, both verbal and written, with an ability to express complex business concepts in technical terms and Ability to learn and adapt to new technologies.
• Possess rich experience working in a multi-national/culture environment including Onsite-Offshore model and in various domains like Information, Media & Entertainment, and Banking& Financial Services.
• Lead the resources within a team.
• Able to proactively work alone and within a team environment
• Work with business users on defining and documenting requirements.
• Detail oriented with strong analytical and troubleshooting skills.
• Administer and create documentation on reports and system environment
• Provide system integration support to other teams and troubleshoot critical issues

TECHNICAL SKILLS:

OBIEE: 11.1.1.6.10/ 10.1.3.4.

Languages: SQL/ PLSQL

Databases: Oracle 10G/ Oracle 11G.

PL/SQL: Web Tool Kit.HTML / JavaScript.

Toad: SQL Loader Utility, Putty, Winscp, HP Quality Center, SQL Developer Microsoft office.

All phases of Software Development: Life Cycle (SDLC).

PROFESSIONAL EXPERIENCE:

Confidential, Parsippany, NJ

OBI Consultant

Responsibilities:

• Lead a team of 4 resources.
• Customized Repository (physical, BMM, and presentation layers).
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, and Alias.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository. Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Built Business model and established relationships & Foreign Keys Physical & Logical between tables. Created business reports using BI Answers per requirements.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Develop Analytics Reports using global and local filters.
• Migrate Web Catalog from DEV to QA and Migrate rpd to QA for GCC Project.
• I am the point of contact between User and offshore team.
• Provide training for the end-users for using reports.
• Participated in scheduled support calls with Business Users concerning the Production Tickets.
• Tested the reports and worked closely with the UAT testers to figure out the modifications if required.
• Customize reports look and feel using column formatting, conditional formatting.
• Implement external database authentication security by creating tables in the database, assigned roles and permissions for the users in the Administration tool as well as in the presentation service areas.

Confidential, Cleveland, OH

OBIEE Lead/Developer

Responsibilities:

• Creating reports and publishing them in the dashboards using answers.
• Worked extensively on OBIEE Administration tool and Presentation Services.
• Involved in the analysis of the existing system reports and modification of the reports, created new reports based on the user requirements.
• Get the database connectivity and design the Physical Layer, Business model and Mapping layer and the Presentation layer in the repository (.rpd).
• Developed Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, and Column Selector, global and local Filters) for performing the customer insights / trends using Presentation Services.
• Created customized reports using Answers from the existing Subjects Areas & incorporated Global Prompts, Cascading Prompts, Filters and configured iBots as per need.
• Granting access to users and maintain security by using database authentication and authorization.
• Implemented Object level security and Data level security.
• Organize Presentation Layer in a format that is easy for end-user to use as a basis for reporting.
• Perform validation of data on the reports and monitor the performance status of the same

Confidential, Dallas, TX

OBIEE Developer

Responsibilities:

• Build the Repository (physical, BMM, and presentation layers).
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository. Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Created Customized Reports Drilldown, Aggregation.
• Built Business model and established relationships & Foreign Keys Physical & Logical between tables. Created business reports using BI Answers per requirements.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Develop Analytics Reports using global and local filters.
• Provide training for the end-users for using reports
• Manage and resolve issues, which includes diagnose errors and establish facts.

Confidential, Bloomington, IL

OBIEE Developer

Responsibilities:

• Analyze and document business processes, user requirements, functional needs, and provide solutions.
• Full cycle implementation from gathering requirements, documenting, designing, developing, testing, deploying, production, and support.
• Developed Metadata repository (.rpd) model using aggregates, dimensions, hierarchies and time series.
• Developed reports (Dashboards, Answers,) using features like Pivot tables, charts, and view selector. Created new reports, dashboards, and dashboard prompts in Answers.
• Implemented user level security for dashboards and reports based on business users’ requirements.
• Created users/groups and manage their permissions.
• Managed appropriate security privileges on Subject Areas and Dashboards.
• Validated reports using SQL Developer and identified reporting issues to troubleshoot and fix discrepancy.

Confidential

Software Engineer

Responsibilities:

• Developed Metadata repository (.rpd) model using aggregates, dimensions, hierarchies and time series.
• Developed reports (Dashboards, Answers) using features like Pivot tables, charts, and view selector.
• Create new reports, dashboards, and dashboard prompts in Answers.
• Implemented user level security for dashboards and reports based on business users’ requirements
• Involved in (Database related) Development.
• Involved in creation of most of the complex stored procedures related to batch jobs in the project and in testing.
• Creating and executing unit test cases.
• Raising issue using tool E-Tracker/ Confidential 2.0 and doing Estimation through it.
• Analyzing and developing new requirements using SQL, PL/SQL, PL/SQL Web Tool Kit.
• Using SQL*Loader for importing the data into intermediate tables.
• Bug-Fix, Enhancement.
• Raising issue using tool E-Tracker/ Confidential 2.0 and doing Estimation through it.
• Participated in internal audits.