Professional Summary:

• Over 10 years of programming experience as an OBIEE and Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System RDBMS .
• Involved in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.
• Expertise in design and development of the three layers Physical/Business Model and Mapping/ Presentation of an OBIEE Metadata Repository .rpd using Oracle BI Administration Tool.
• Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports.
• Experienced in developing Dimensional Hierarchies, and Level Based Measures.
• Extensively worked with DBAs and BAs towards performance tuning in OBIEE and Data Warehouse environment using cache management, aggregate tables, and indexes.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Client-Server application development using Oracle 11g/10g/9i, PL/SQL, SQL PLUS, and TOAD.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, and Materialized Views.
• Good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Created Tables, Views, Constraints, Index B Tree, Bitmap and Function Based .
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Partitioned large Tables using range partition technique.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Created Shell Scripts for invoking SQL scripts and scheduled them using Appworx and Dollar Universe.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Extensive experience in requirement elicitation, documenting and maintaining Business

Technical Skills:

• OLAP Tools: OBIEE 10x, OBIEE 11x
• Database: Oracle 11g/10g/9i
• Languages: SQL, PL/SQL, C, C , UNIX Shell scripting. Operating Systems: Windows 98/00/XP/2008 server, Linux, UNIX. SQL Utilities: Toad for Oracle, SQL PLUS, PL/SQL Developer. Data-Modeling Tools: MS Visio.
• Tools: Kintana, PVCS, Remedy Applications: MS Word, PowerPoint, FrontPage, Outlook

Professional Experience:

Confidential

OBIEE Developer

Key Responsibility:

• Worked closely with Business Analyst in understanding the Analytics requirements and created the business model for generating reports as per the user requirements.
• Configured OBIEE Repository, set connection pools, implement physical data model as per requirements, importing the tables and having the physical joins/keys required and changed the physical joins/key on the existing tables.
• Modeling activities, which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns in Business and Mapping model layer.
• Created Dimension hierarchies and assigned levels for each level, established the logical joins/keys required to support drill-down aggregation.
• Configured Oracle BI Scheduler to integrate Delivers with OBIEE Answers so as to deliver alerts and reports to end users by setting up the DB schema for Scheduler that is used to store the runtime data, configuring the scheduler on Windows, configuring the Presentation Services in order for it to connect to Scheduler and by starting the Scheduler Service.
• Developed Role-Based Dashboards for Managers and Business Heads to review the Forecasts and customized pre-built dashboards.
• Implemented the delivery of iBots using OBI Delivers to alert the associated teams.
• Set up Security at two levels Object level security control access to Metadata through the Administration tool and BI Answers. Data level security, which controls access to content and data in the end-user reports and Dashboards.

Environment:

PL/SQL Oracle 10g, OBIEE 11.1.1.7, SQL PLUS, PL/SQL Developer

Confidential

PL/SQL and OBIEE Developer

Key Responsibility:

• Involved in the continuous enhancements and fixing of production problems.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL TRACE, TKPROF and AUTOTRACE.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.

Confidential

• Migration from Seibel Analytics to OBIEE, Software upgrades Java, Oracle, Perl, Dollar Universe .
• Validation of application functionality and data for Oracle version upgrades.
• Extensive data validation of applications and jobs to ensure system work as is after migration.
• Maintaining Code Version using PVCS.
• Deployment of application to latest software versions using Kintana.

Confidential

Management System Development

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Experience in Database Application Development, Query Optimization, and Performance Tuning and implementation experience in complete System Development Life Cycle.
• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using Toad.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Confidential

OBIEE Development

• Worked during the whole life cycle of the project from requirements gathering to deployment.
• Acted as a liaison between business users and BI team to facilitate understanding of business requirements.
• Created Requirements Traceability Matrix and Mapping Document to trace requirements in BI implementation
• Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.
• Created new logical columns, mappings, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
• Developed Time Series Objects using Ago and ToDate functions for time series comparisons.
• Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.
• Created various session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.

Confidential

• Designed logical and physical data models for snowflake schemas.
• Designed Data Modeling, Design Specifications and to analyze Dependencies.
• Creating common Database objects Partitioned Tables, Indexes, Materialized View, View, DBLinks, Global temporary tables, Util Packages, VARRAYS, etc
• Creating Database model using Visio.
• Loading table from external database through DBLink. Used Global temporary table for initial load to enhance performance and ensure quick release of connect to external Database.
• Applying business rules to the raw data in global temporary table to make it ready for current application use.
• Truncating and reloading real-time table with GTT using exchange partition to ensure least lock time on table and quick availability of data.
• To ensure performance, rebuild indexes and gather table statics after each data load completion.
• Sending notification emails to support group on completion of load success/failure
• Develop a common UTIL package to have all commonly used functions and procedure at one place.
• Create Materialized View to fetch snapshot of data for quick reference in current database.
• Scheduling jobs In Dollar Universe using Shell Script to load data in system as per business required frequency.

Confidential

• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Worked on enhancement requests, involving implementing new business requirements.
• Wrote SQL, PL/SQL, SQL Plus programs required to retrieve data using cursors and exception handling.
• Created DBMS Jobs to refresh data in tables and materialized view.
• Involved in Cisco Year end activity, to seed new geographical hierarchies for new fiscal year.

Environment:

PL/SQL Oracle 10g, OBIEE 11.1.1.7.1 and 10.1.3.4, Dollar Universe, CDB, TOAD, SQL PLUS, PL/SQL Developer, Shell Script

Confidential

PL/SQL and Shell Script Developer

Key Responsibility:

• Creating business reports using Magic v2.0 software.
• Scheduling reports using Appworx.
• Creating Shell Script to deploy scheduled report run scripts on to Appworx.
• Creating PL/SQL queries to embed in Magic v2.0 to implement complex business logic
• Tuning PL/SQL existing report queries to handle huge data improving overall performance.

Environment:

PL/SQL Oracle 9i, SQL PLUS, PL/SQL Developer, Shell Script, Linux v2.1, Appworx, Magic v2.0

Confidential

C Developer

Key Responsibility:

• Workspace memory allocation for each user as per Business requirement
• Assigning server memory location using C pointers
• Writing C code in Linux for allocation of memory, freeing unused memory.
• Periodically calculating used/unused memory by each user.
• Scheduling report to send usage statistics to admin.

Environment:

Linux, C