SUMMARY

• Around 8 years of professional IT experience which includes maintaining OLAP/OLTP applications by using OBIEE, Informatica, Siebel and Actuate
• 3+ years of experience in OBIEE 11.1.1.7/10.1.3.4 , OBIA which includes building and creating repository(RPD), creating and managing the Oracle Intelligence Dashboards, Answers and creating Delivers and iBots
• RPD Development (physical, Business Mapping & Modeling, presentation Layers) by using OBIEE 11.1.1.7/ 10.1.3.4.
• Involved in Repository Configuration, Troubleshooting, Defect Fixing by using HP QC
• Experience in migrating metadata and web catalogue between different environments like DEV, QA and PROD
• Experience in implementing Out of the Box OBIEE (OBIA) and RPD and Dashboard customizations
• Expertise in analyzing and designing customized analytical reports and creating Interactive Dashboards with drill - down capabilities using OBIEE 11.1.1.7
• Expertise in Cache management, performance tuning at report level
• Experience in managing users and groups, setting up their privileges and administering the Object Level Security and Data Level Security using different authentication methods.
• Experience with RPD development, configured metadata objects (subject area, Alias table and column) and web catalog objects (Dashboards, Pages, Folders, Reports)
• Created dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts
• Interacted with team to understand the Data warehouse requirements.
• Current hands-on Bi Apps Experience with configuring/customizing analytics for Oracle EBS.
• Involved in analyzing the ETL mappings to meet the business requirements by using Inforamtica9.0
• Experience with preparing the High level and Low Level Design Documents.
• Strong programming experience in creating Procedures, Packages, Functions, Triggers and other database objects using SQL and PL/SQL.
• Committed team player with multitasking capabilities. Excellent interpersonal and human relations skills.
• 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

TECHNICAL SKILLS

Reporting/Data warehouse Tools: OBIEE 11.x/10.x, Informatica 9.x, DAC, OBIA 7.9x

Relational Databases: Oracle 8i/9i, 10g/11g, SQL Server 2000/2005, MS Access

Database Languages: SQL, SQL*Plus, PL/SQL, UNIX shell scripts

Programming Languages: HTML, Java script, PL/SQL

Operating Systems: Windows, UNIX, Linux

Data Models: Star/Snowflake Schema, ER Model.

PROFESSIONAL EXPERIENCE

Confidential, PA

Sr. OBIEE Developer

Responsibilities:

• Interacted with the business for requirement gathering(reports and dashboards) and to define the Functional design Documents for OBIEE 11.1.1.6/10.1.3.4
• Involved Onsite and offshore activities.
• Extensively used Oracle BI Administration Tool for customizing and modifying the physical, business model and mapping and presentation layers of metadata repository.
• Created and modified repository (RPD) file and modeled data in physical and BMM layer using physical and complex joins.
• Extensively worked with Business and Functional owners to get the requirements clarifications.
• Effectively handled the team activities like Code Review approvals, maintaining the object tracker, conducting the team meetings to get the object status.
• Involved in Understanding the user requirement and developing the Technical documentation.
• Created dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports.
• Implementation of criteria filters to narrow-down the result set from the analytics requests.
• Expertise in Creation of Subject areas and Developing Reports by using OBIEE 11.1.1.6
• Implemented event polling cache refresh strategy to cache reports and improve performance of long running reports.
• Worked on OBIA modules like Financials and Supply Chain Analytics.
• Customized the out of box rpd to meet the functionality of business procedure.
• Created and customized the dashboards and reports by using Oracle EBS as the source
• Responsible for the administration and migration of user reports or repositories between various environments
• Extensively worked with Administration team to resolve the issues happened while migration to different environments DEV,QA and PROD
• Involved in Modifying the existed Fact tables and Dimension tables in the Business Model and Mapping Layer as per the requirement changed.
• Modified reports, filters and charts in Answers and added them to Intelligence Dashboards
• Involved in Modifying the Columns at BMM and Presentation layers by using existing joins.
• Involved in modifying the calculations at Answers level based on the requirement changes.
• Involved in unit testing the reports.
• Extensively worked on the defect fixing, Technical document changes and migration process.
• Updating the status sheets on regular basis to know the status of the objects.
• Build test cases and tested the Reports / Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results

Environment: OBIA 7.9.6.2, OBIEE 11.1.1.6, Oracle 10g, Oracle EBS, Win XP, Windows 7, Informatica 9.1, DAC 10.1.3.4.1

Confidential, New Orleans, LA

OBIEE Developer

Responsibilities:

• Extensively used Oracle BI Administration Tool for customizing and modifying the physical, business model and mapping and presentation layers of metadata repository.
• Used aggregate persistent wizard to aggregate data higher level for performance tuning.
• Implemented various Repository Variables and System Variables as for user Requirements .
• Created and modified repository file and modeled data in physical and BMM layer using physical and complex joins.
• Developed Business models to represent business logic for Sales and created logical tables and defined the complex joins for a business model.
• Created presentation catalogs with restricted access to various business users.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) for performing the Marketing Trends analysis using Oracle BI Presentation services.
• Worked on MUD environment.
• Utilized various building blocks like calculation measures, time series measures, initialization blocks, session and repository variables, fact tables, dimension tables, dimension hierarchies.
• Giving security permission/privileges as per the role of each user.
• Customized the out of box rpd to meet the functionality of business procedure.
• Developed custom dashboards and reports using OBIEE Answers.
• Scheduling the Developed reports according to Client requirements.
• Tested and validated the repository, reports and dashboards

Environment: OBIA 7.9.6.2, OBIEE 11g/10g, Oracle 10g, Win XP, Windows 7, Informatica 9.1, DAC 10.1.3.4.1

Confidential, Philadelphia PA

OBIEE Developer

Responsibilities:

• Create/Modify Metadata repository suiting to company’s data requirements by using OBIEE tool.
• Involved in Business Analytical activities like Migration, Testing, User Training and Production Support.
• Defined Primary key-Foreign key relationships, complex joins bridge tables between dimension tables and Fact tables in the physical layer.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Managed security privileges for each subject area and dashboards according to user requirements and Setup the role based visibility of Dashboards to users and business analysts.
• Analyzed and recommended enhancement to metadata reporting in all three layers (Physical Business and Presentation).
• Extensively used filter, update, lookup, expression, router and sequence generator transformations.
• Defined the refresh extraction logic based on the last updated column in the Transactional Tables.
• Created workflows for the Initial load and refresh load.
• Created mappings to populate the aggregate, hierarchy and helper tables.
• Involved in the integration testing and unit testing the data. Identified bugs during the testing phase and fixed them.
• Tested and Validated the Repository before making it available for queries.
• Configured query cache to reduce the cost of database processing and reduce the Server processing overhead.
• Defined session variables for users to enhance data level security.
• Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Responsible for making the end users understand the features of Answers.
• Worked Extensively on OBIEE Answers to create the reports as per the client requirements.
• Created and modified the request, modified the result layout and added filters to them according to the need of end-users.
• Configured I-Bots to deliver analytics content-based alerts as per user requirements.

Environment: OBIEE 10.1.3.4,, Oracle 10g, Toad, Erwin, Oracle BI Publisher 10.1.3.4.0 , DataWarehouse Administration Console ( 10.1.3.4.1 .), Siebel 8.0

Confidential

OBIEE Developer

Responsibilities:

• Involved in Modifying the existed Fact tables and Dimension tables in the Business Model and Mapping Layer as per the requirement changed.
• Modified reports, filters and charts in Answers and added them to Intelligence Dashboards
• Involved in Modifying the Columns at BMM and Presentation layers by using existing joins.
• Created dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports.
• Responsible for the administration and migration of user reports or repositories between various environments

Environment: Oracle Business Intelligence 10.1.x, Oracle 9i/10g, PL/SQL, Sql server. Siebel 8.0

Confidential

PL/SQL, Informatica Developer

Responsibilities:

• Interacted with the business users and collected the requirements.
• Prepared BRS (Business Requirement Specifications) document that gives the information about requirements in more detail.
• Involved in Analysis and designing tasks, developed and managed the development project plan.
• Enhanced existing systems by designing database schema structures to be used for development, and implemented analysis and designed tasks to produce new systems.
• Managed database in Oracle 9i, and developed many application packages, tables and views.
• Involved in database development by creating PL/SQL functions, procedures, triggers and packages.
• Worked on different types of sub queries (Correlated and Inline) and used loops to suit the business logic.
• Prepared program specifications for PL/SQL procedures and functions.
• Worked on physical data modeling.
• Improved query performance by using better joins and hints appropriately.
• Scheduled batch jobs for loading database tables from flat files using SQL*Loader.
• Worked on user-defined and system defined exceptions to handle different kinds of errors.
• Involved in technical documentation, unit testing, and integration testing and writing the test plan.

Environment: Oracle9i/8i, SQL, PL/SQL, SQL*Plus, SQL*Loader, SQL Server 2000, Forms 6i, PERL and UNIX.