SUMMARY

• Overall 9+ years of experience in Oracle Technologies.
• 9+ years of software development experience in IT Industry, with 9+ years of hands on experience in Business Requirement Gatherings, Analysis, Design, Data Modeling, Development, Testing and Implementation of Data warehouse/Business Intelligence using OBIEE 10.x, OBIEE 11g.
• 9+ years of hands on experience in oracle PLSQL development and UNIX technologies.
• Ability to write complex SQL queries to analyse the production environment and to write strong PLSQL procedures, functions, triggers, packages.
• Strong experience in performance tuning techniques in coding plsql blocks.
• Ability to debug the functions, procedures and packages.
• Extensive experience in OBIEE Administration Tool, BI Answers, Intelligent Dashboards, BI Publisher, Oracle BI Apps, Delivers and Agents (alerts) with OBIEE Applications.
• Experienced in designing and developing Data Modeling and Analysis using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables and Physical and Logical data modeling in the OBI Administration tool.
• Strong experience in developing OBIEE time series objects, Interactive Dashboards with drill - down capabilities (using global and local filters), dashboard prompts, Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Experience in managing users and setting up their OBIEE application access in External database table and configure user access by using session variable in RPD.
• Expertise in Data Warehousing Concepts, OLAP technologies, Data Modeling and Cache monitor.
• Experience in building metadata Repository file (. rpd) consisting of three layers (Physical Layer, Business Model & Mapping and Presentation Layer)
• Highly Experienced in Training Resources in OBIEE, Discoverer and creating BI Delivery Kits, OBIEE Learning Material and user guides for OBIEE Workshops.
• Adept at all phases of SDLC, which includes Design, Analysis, Coding, Testing, Code Reviews, Implementation and System Support.
• Well versed with Agile Methodology, Extreme Programming, Microsoft Patterns and Practices.
• Ability to take independent responsibility as well as ability to contribute, work under pressure and be a productive team member.
• Ability to work in a fast paced, collaborative environment and handle multiple concurrent projects.
• Possess keen business acumen in analyzing and understanding business requirements, customer-value maximization and developing new business processes and revenue streams.
• Strong analytical, troubleshooting organizational, communication, prioritization, and problem solving and leadership skills with ability to create and sustain high work tempo.

PROFESSIONAL EXPERIENCE

Confidential - Boca Raton, FL

OBIEE Developer and PLSQL Developer

Responsibilities:

• Met with business representatives and business analysts to understand the business models and functionality.
• Developed user friendly reports/ interactive dashboards with different analytic views including column selector, pivot tables, charts allowing managers to analyze the business from different perspectives and in an orderly and summarized manner
• Used Filters and provided customized prompts appropriately to avoid excessive data showing up on reports
• Performed administrative tasks related to the development and configuration of Interactive Dashboards
• Actively trained users so that they could efficiently navigate the dashboards
• Helped create connection pools, imported physical tables and defined joins in the physical layer of the repository
• Assisted with Building the Physical, Business Model and Mapping and Presentation Layer of the repository.
• Defined facts, dimensions, Level based measures/Hierarchies, Time Series and Aggregation in dimensional modeling.
• Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and validating repository level calculations done in the business model layer
• Created variables in OBIEE to streamline administrative tasks
• Created group level security for intelligence dashboards and assigned users to groups based on Business Requirements.
• Managed performance by using cache management and aggregate tables to speed up query response time.
• Fully installed OBIEE at client site

Environment: Oracle 11g, PLSQL, SQL Developer, Reports, Dashboards, BI analytics, Windows 7/10, HPQC

Confidential - New Jersey - NJ

OBIEE Developer and PLSQL Developer

Responsibilities:

• Coding at all the levels of the application.
• To generate the report for policies with / without Anniversary Rate Date endorsement using OBIEE.
• Handling additional responsibilities like source code control, team management etc.
• Created stored procedures and functions.
• Unit Testing.
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using OBIEE Analytics Administration Tool.
• Creation of Dimensional Hierarchies to analyze the business trends in various ways.
• 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.
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users.
• Created the Requests and view the results in different views like Table, Compound Layout, Chart and Pivot Table.
• Developed different brand level Reports, Filters, and Prompts using Siebel Analytics Web.
• Created various reports to fulfil the marketing needs and customized the views using OBIEE Answers

Environment: Oracle Business Intelligence 10.1.3x Windows XP, oracle 10g, SQL, PL/SQL, TOAD

Confidential

OBIEE Developer and PLSQL Developer

Responsibilities:

• Installing Oracle BI Analytics and configuring the connection parameters with Oracle 10g.
• Created/Modified Metadata repository (. rpd) as per the data requirements by using Oracle BI Analytics Server Admin tool.
• Independently Designed and developed subject areas in the RPD (Physical, BMM and Presentation layer)
• Defined appropriate joins, calculations, dimensions and measures in the repository.
• Created Repository Users/ Groups and Web Groups and assigned permissions to the user groups to define security in the repository.
• Involved in Data Modeling, Design Documents, and data warehouse.
• Conducted project planning and work estimations.
• Responsible for supporting and enhancements for the existing projects in OBIEE.
• Updated the RPD layers and OBIEE reports upon modifications.
• Hands on experience in data warehousing technologies including ETL, Oracle BI Server architecture, and metadata management.
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer (design of hierarchies, dimensions, and aggregates).
• Created Snowflakes and Star Schema to perform data modeling for proposed architecture.
• Created and customized various Reports and Dashboards for various user groups.
• Designed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative and Nested reports in Answers.
• Created reports with different views (Compound, Chart, Table, Pivot, Ticker and Narrative).
• Created materialized views to fasten slower queries with complex joins in them.
• Identified Data Sources (Oracle BI& Enterprise DW) & Extension columns - Identified Oracle BI OLTP tables, fields, Map them with Staging Tables and finally map them to OLAP's Physical layer tables/schemas.
• Secured Dashboards and Reports by defining user roles.
• Participated in the implementation of any OBIEE product upgrades. Performance tuning ETL mappings and Reports
• Implemented OBIEE security at the data and object levels.
• Manage/modify database security and database schema.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Applied Optimization techniques and tuned performance of the reports such as caching and building summary tables.
• Supported business operations via OBIEE including: investigating defects or issues.
• Identified the gaps between user requirements and existing applications - Primarily the Finance App.
• Done data migrations using Import/Export, FTP, Database Links and SQL*Loader.
• Trained End Users to Build Ad Hoc Reports using OBIEE.

Environment: OBIEE 10.1.3.4, PL/SQL, TOAD and Windows