PROFESSIONAL SUMMARY:

• 7+ years of experience in Business Intelligence, Data Warehousing and DatabaseApplications including Analysis, Design, Development, Testing and Support using ODI, Informatica, OBIEE, BIP and BI APPS.
• Expertise in Building Executive Dashboards using Dashboard Manager for OBIEE.
• Expertise in building Metadata Repositories (.rpd) using Physical layer, Business Model and Mapping layer, Presentation layer with the Oracle BI Administration tool.
• Good in Business Intelligence Applications using Oracle Business Intelligence (OBIEE/OBIA) in Human Resource, Supply chain, Spend Analysis & Sales modules.
• Skilled in configuring OBIEE Metadata objects including repository variables, initialization blocks, and connection pools using ODBC, OCI and Universal Adapters.
• Experienced in designing customized and complex interactive dashboards in OBIEE using drill down/ drill up, guided navigation, prompts, filters and variables.
• Experienced in developing and implementing Dimensional Hierarchies, Level Based Measures, Aggregation Rules, Time Series Functions, and Rank Functions.
• Expertise in creating RTF, EXCEL, XSL and PDF Templates using BI Publisher.
• Experienced in configuring and set up of OBIEE Security using LDAP and External Database Tables besides configuring object level and database level security.
• Proficient in Data Warehousing, Dimensional modeling using star schema/ snow flake schema modeling, Fact and Dimension identification.
• Expertise in Data Modeling design, analyze and implement - conceptual, logical and physical data model, Data conversion, Data integration and Data Mining specialization in the area of Data Warehouse and Business Intelligence.
• Proficient in rpd designing, developing and generating dashboard Reports, Business views, Unit Testing, Quality Assurance, Project Planning and Documentation.
• Good knowledge in using OBIEE answers to create queries, format views, and charts to enhance the user experience.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository.
• Skilled at creating and scheduling Agents (iBots) using Oracle BI Delivers to provide real-time, personalized and actionable intelligence data to subscribers.
• Expertise with all ODI graphic tools - Topology, Security Manager, Designer and Operator.
• Hands on experience working with ODI Knowledge Modules- LKM, IKM, RKM, JKM and CKM. Customized versions for the existing ODI Knowledge modules, which can be re-used in data integration projects.

TECHNICAL SKILLS:

RDBMS: Oracle 11g/10g, Oracle Exadata

Database Tools: SQL developer, SQL*Plus, TOAD, SQL Loader.

Programming Languages: C, C++, SQL, PL/SQL, HTML.

ETL Tools: ODI 10g/11g/12c

Operating system: Windows XP, Windows 7, Linux

Tools: MS Office

Reporting Tools: OBIEE 11G/10G

PROFESIONAL EXPERIENCE:

Confidential, ROSEVILLE, CA

OBIEE/BI PUBLISHER DEVELOPER

Responsibilities:

• Assist with the sprint deployment process.
• Troubleshoot any issues with the deployment process, database issues, applications and development tools.
• Provide technical support to application development and test teams.
• Assist with impact analysis of any changes made to the database objects.
• Installed and configured of Oracle BI Publisher and OBIEE.
• Prepared the web catalog and repository. Created security groups and application roles.
• Administration of the existing environment with respect to changes and the development changes and implementation feasibility.
• Developed measure for time comparison using time functions ToDate and Ago.
• Used Filters and provided Prompts appropriately to make interactive reports and to avoid excessive data showing up on Reports.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Implemented and configured iBot on development, Test, Production and UAT assigned users are groups and also masked the data and restricted users.
• Configured BI publisher and implemented the RTF, PDF template in the report.
• Designed and developed Data Models, Datasets templates, final reports and documents from multiple data sources.
• Worked with LOV's, Parameters, Bursting and configuration of delivery options for reports.
• Worked on converting existing Crystal reports to BI publisher reports.
• Implemented User access, authentication and authorization following best practices in the Repository.
• Coordinated with business users in understating and implementing the security feature.
• Using Object level and Data level Security. Expert in using OBIEE Analysis to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Worked on creating deadlines for the development and engineering team to make application ready to deploy.
• Worked extensively on reports and dashboards to minimize the source system upgrade impact and data availability.
• Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Analysis.
• Involved in performance tuning of the dashboards with DBAs and BAs using cache management and aggregate tables.
• Worked on Repository (.rpd), customized the RPD with the requirements of the End User. Designed and developed the three layers (Physical, BMM, and Presentation).
• Developed Dashboards, Reports, drillable charts, pivot table views, guided navigation, prompts, and compound layout.
• Implemented Dimensional hierarchies, Level based measures, Fragmentation content, Aggregation, Complex joins in rpd, Configured Repository and Session variables and Initialization block for Dynamic, Customized, Prebuilt reports.
• Worked on administration of OBIEE Cache management, Security Management for Users, groups and web groups using the various authentication system such as LDAP Authentication using Session variable as well as Dash board / Report level Security.
• Implemented Row Level Security.
• Activity objective is to bring the application live after complete disaster of the environment.
• Involved in cross training to the new employees to understand the Application and responsibilities.
• Involved in documentation of environment using Visio tool.
• Applied the patches to the WebLogic servers.

Environment: OBIEE 11.1.1.7, Oracle BI Publisher 11.1.1.7 SQL, Oracle Database 10g/11G, SQL Developer, WebLogic server 10/11g, HP ALM.

Confidential, OWINGS MILLS, MD

BI PUBLISHER

Responsibilities:

• Worked with Business Analysts and key business contacts to translate functional and technical specifications into a comprehensive reporting design.
• Participated in Design, Development and Testing phases of BIP reports.
• Assessed the customer needs utilizing a structured requirements process (gathering, analyzing, documenting, and managing changes) to assist in identifying business priorities and provided advice on options.
• Experience on installation and setup of the BI Publisher desktop version and OBIEE 11g.
• Trained the end clients by providing the required material and conducting training sessions.
• Designed and developed Data Models, Datasets templates, final reports and documents from multiple data sources.
• Worked with LOV's, Parameters, Bursting and configuration of delivery options for reports.
• Worked extensively with RTF templates and Sub templates for developing the reports as per the business requirement.
• Worked with the interactive reporting online using BIP tool and extracted the output in various forms like HTML, PDF, EXCEL, CSV file.
• Designed, programmed, tested, debugged, maintained and documented hardware/software for an advanced level of projects to meet business application needs interpreting policies, procedures and guidelines.
• Worked on using variables for Totals and Subtotals in BI Publisher.
• Used the Totals/Subtotals/group/sort features of BI Publisher to make data intense operations happen at the template level.
• Experience in developing complex BI Publisher reports and have good Oracle SQL experience.
• Prepared detailed design document for specifications from which the reports are designed, tested, debugged.
• Performed maintenance, tuning and troubleshooting on existing and newly developed BI Publisher Reports.
• Worked with project managers, developers, and end users to ensure BI Publisher Reports and SQL design specifications meet the customer's business requirements support technical design activities related to data, databases.

Environment: BI Publisher 11.1.1.7.15 , Oracle 11g, Windows 7, SQL plus, Toad, MS Office, Adobe, HP ALM, Serena dimensions.

Confidential, Erie, PA

OBIEE DEVELOPER

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document for Kronos Analytics.
• Installed, Configured and developed BI Apps Supply Chain, Procurement and Spend, HR modules.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created numerous executive level reports. Dashboards were generated to provide insight into the financial data.
• Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Built Business model and established relationships between Primary Key & Foreign Keys in Physical & Logical layers between tables.
• Created business reports using BI Answers as per requirements.
• Generated various Analytics Reports using global and local filters.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Added users and configured security in web logic console of OBIEE 11g.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Setting up LDAP authentication to enable Single Sign on for Users in Development environment leveraging Analytics Repository.
• Trained End Users and Pilot Users about OBIEE Tools.
• Responsible for installing, configuring, developing, support and maintenance of the BI APPS.

Environment: OBIEE 11g, BI Apps 7.9.6.3, Web Logic Server, Oracle 11.2.0.2, SQL, DAC, UNIX, Windows 7.

Confidential, CHICAGO, IL

OBIEE DEVELOPER

Responsibilities:

• Used the OBIEE Administration tool to develop and enhance meta-data. Configured and Created repository using OBIEE Admin tool.
• Developed various trending reports to analyze the revenue generate by products and sales reps.
• Worked extensively on BMM (Business Model and Mapping) layer to develop various business models like Credit control and balance sheet management models using Star Schema and Snowflake Schema.
• Configured Logical Layer, Created Logical tables/dimensions, columns, Created Logical Joins/keys, Set levels to support Drill-down and Aggregation navigation.
• Created Level Based Measures, new logical columns and enforced conditions on the columns in the logical layer for query optimization.
• Implemented Time Comparison and Calculation measures in the business model using Time series Wizard.
• Performed Repository Testing and Validation before exposing Business Models in the Presentation Layer.
• Setup the visibility of Dashboards to employees with respect to their responsibilities. Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
• Configured iBots to alert the management and sales teams as per their requirements.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up reports.
• Slice and Dice data using filters and used pivot tables and charts for better presentation.
• Performed Unit tested for mappings before adding new developed sessions into the existing batch.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.

Environment: OBIEE 11g (11.1.1.7), Oracle 11g, SQL Developer, Windows 2008 Server.

Confidential, Phoenix, AZ

ODI/OBIEE DEVELOPER

Responsibilities:

• Worked with business analysts for requirement gathering, business analysis, and testing and project- coordination.
• Primary focus and/or development efforts were in the reengineering of the ETL processes using ODI.
• Created Topology which includes creating Master/Work repositories, Physical/Logical schemas, Agents, and Context.
• Developed Source to Target Mappings using ODI Designer to load data from source systems to target database, implementing the business rules.
• Developed processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Worked on Reverse Engineering Knowledge Module (RKM), Loading Knowledge Module (LKM), Integration Knowledge Module (IKM), and Service Knowledge Module (SKM).
• Used ODI to implement CDC through Journalization Knowledge Modules (KM’s) and to Implement SCD’s.
• Granted privileges to the ODI users using Security Manager and purged the logs in operator.
• Used OBIEE 11g/10g to create dashboards and reports.
• Developed and customized the Business Model and Mapping (BMM) layer, physical layer and Presentation layer as per the business requirements.
• Created aggregate tables in physical layer, and created dimensional hierarchy in logical layer for several subject areas.
• Worked extensively on OBIEE Presentation Services to create reports as per the client requirements and also created, modified and formatted multiple requests, along with charts and filters, in BI Answers.
• Worked on providing security at presentation layer and at Dashboard level according to the required permissions and privileges.
• Installed and configured Oracle Data Integrator (ODI) 10g for identity management solutions where and whenever necessary.

Environment: ODI 11g/10g, OBIEE 11.1.1.5, Oracle 10g/11g, UNIX Shell Scripts, Windows XP.

Confidential, SAN FERNANDO, CA

OBIEE DEVELOPER

Responsibilities:

• Worked with Client for gathering requirements, Identified KPI, Identified Analytics Report requirements.
• Responsible for gathering Business Requirements, preparation of Business Requirement Specification document and performed Gap and Data Analysis.
• Used Administration Tool for customizing and modifying the physical, business and presentation layers of metadata repository (.rpd).
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down/ Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with Global and local Filters) using Answers in OBIEE.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Developed Dashboards for each of Metrics by embedding Reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Implemented Dynamic Navigation to allow the system to pass parameters from the summary dashboards to the details dashboards.
• Used Answers to create queries, format views, charts, and added user interactivity and dynamic content to enhance the user experience.
• Building interactive and selective data reports (pivots, charts, tabular) using concepts such as filters, column selectors, global prompts and extensively used repository and presentation variables.
• Used Oracle BI Publisher to created RTF Templates and used prebuilt templates to view and report data
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Designed and Developed Custom Mappings and Workflows in Informatica to bring the data from other data source systems and Integrated using Universal Adapters in DAC.
• Worked on creating PL/SQL Tables, Views, Stored Procedures, Triggers and Functions that are used in the ETL Mapping.
• Monitored Incremental and Full load of Data through Data Warehouse Administration Console (DAC) and Informatica Workflow Monitor.
• Trained End users and developed trainingdocuments and on-line help docs.

Environment: OBIEE 10.1.3 & 11.1.1.3, Oracle BI Publisher, Informatica Power Center 8.1, Oracle 10g, Windows 2003.

Confidential, San Francisco, CA

ODI Developer

Responsibilities:

• Extensively worked in the ETL procedures and processes.
• Created data servers and physical & logical schemas for IBM DB2, Oracle database and flat files.
• Used ODI designer to create interfaces, packages to facilitate data loading. Tune SQL statements to Insert and update data into the DIMENSION and FACT tables.
• Designed the ETL processes using ODI Designer.
• Monitoring the ETL process using Operator and Metadata
• Error checking and testing of the ETL procedures and programs using Informatics session log.
• Created variables, procedures, packages in ODI as part of Integration needs.
• Used standalone agents to schedule ODI scenarios.
• Worked extensively on Oracle database 9i and flat files as data sources.
• Huge volumes of Data extraction from legacy systems and uploaded into Oracle using SQL*Loader and PL / SQL.

Environment: Oracle Data Integrator (ODI 10g), Oracle 9i, SQL developer, Flat Files.