PROFESSIONAL EXPERIENCE:

• 8+ years of experience in IT industry involving requirement analysis, design, development and implementation of Business Intelligence, RDBMS applications under different environments.
• Extensive experience in OBIEE 10g/11g/12c including configuring repository, creating/managing OBIEE Intelligent Dashboards including gauges, graphs and charts, Analysis, Answers (AdHoc) and BI Publisher.
• Experience with all components within Oracle's BI Applications (OBIEE) including Presentation Services, Dashboards, Agents, BI Server, BI Publisher and Report Server.
• 8+ Years of Architect/Lead experience in handling all phases of SDLC of BI projects.
• Have an excellent experience in working on UNIX/LINUX platforms.
• Extensive experience in Metadata Modeling at all three layers (Physical, Business Model and Presentation) using the OBIEE Administration Tool.
• Expert in creation of dimension and fact tables, logical columns, hierarchies, drilldowns, level based measures in Business model& mapping layer. Created many session and repository variables. Created users, roles in console and assigned them to groups in Enterprise Manager and implemented security.
• Extensive experience on assigning Data security & Object Level Security to the users using OBIEE repository objects, external database and LDAP.
• Experience in creating users and assigning them to their respective groups and roles.
• Extensive experience in creating Metadata Objects (subject area, table, column) and Web Catalog Objects (Dashboards, Pages, and Reports).
• Developed reports and dashboards with various analytical views with Global and Local Filters, Customized Prompts at page level and Dashboard level. Created exclusive views as Trellis view, Pareto charts, Sliding graphs for providing an excellent and interactive interface for end users.
• Executed OBIEE Administrative Tasks and BI Publisher reports (formerly known as xml publisher) in assigning various templates to publish the report as per requirements.
• Involved in upgrading the application from OBIEE 11g to 12c and configured the internal and external Components to retain the application functionality, security, look and feel.
• Used XML, and XSL for advanced report features and formatting.
• Designed Star schemas, Snowflake schemas for Data Marts and Data Warehouses.
• Participated actively in many major and minor releases and deployed RPD and migrated catalog from development environment to testing and from testing Environment to PROD.
• Worked with Smart View and developed reports using BI data in Excel, Word and PowerPoint for presenting to users.
• Worked extensively on BI Publisher and published reports to users.
• Have good Knowledge working with OBIEE 12C and Visual Analyzer.
• In - depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
• Data Validation to check if data is consistent in the reports and dashboards and performance tuning the reports. Comprehensive knowledge in debugging, optimizing and troubleshooting the Oracle BI / Siebel Analytics Dashboards /Reports.
• Extensively experienced in designing, building, implementing, and deploying data universes/data models against Oracle and other databases.
• Played a prominent role in testing data accuracy in reports with backend data.
• Implemented ETL(extract Transform Load) using ODI. Expertise with all ODI tools - Topology, Security Manager, Designer and Operator.
• Implemented the Projects, Interfaces, Scenarios and Packages in ODI. Scheduled and Monitored the load process using ODI.
• Design ODI/ETL mappings and flows by interacting with the in-house BI technical Lead, business analyst and other team members
• Worked on setting up the ODI connection with Oracle, MS SQL Server and flat files.
• Experience in Translating the Business Requirements to Functional and Technical specifications (Design documents (LLD AND DLD) and unit test cases.), ensuring the delivery and tracking requests.
• Expertise in creating SQL, PL/SQL, Stored Procedures/Packages/Triggers/Cursors and UNIX Shell scripts.
• Improve the performance by creating Indexes (B Tree, Bitmap), Hints, Partitions, Bulk Processing, Collections (nested tables, arrays, and associative arrays) and defining exceptions to handle the run time errors.
• Expert in working with MUD (Multi User Development) environment in OBIEE.
• Worked on various OBIA modules as sales, financial and hr.
• Experience in Oracle database, SQL Server, Essbase and other databases.
• Have excellent knowledge in connecting to various databases and data modelling to create various views as charts, graphs using Tableau.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau 7.0/8.1.
• Recently started implementing Devops (onestash, Jenkins and GIT HUB) for viewing various files in server and automated process of deploying RPD instead of using em.
• Create deployment artifacts for migration of the solution on various environments following the stages of the project and provide documentation on all deliverables.
• Have immense ability to multi-task and have excellent communication skills.
• Had meetings and dealt with clients and developers on a regular basis.

TECHNICAL SKILLS:

Business Intelligence tool: OBIEE 11.1.x,10.1.3.x,12C BI Publisher, OBI Marketing, Siebel Analytics

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

Web Development Tools: HTML, DHTML, XML, CSS, XHTML

Database Technologies: SQL Server 2000/2005, Oracle 11g,10g,SQL, PL/SQL

Operating Systems: Windows 2000/2003/NT, Unix, Linux

Tools: SQL *PLUS, SQL Developer, Toad, DAC, MS OFFICE, SmartView 9.3.1,Visual Analyzer, Tableau

ETL Tools: ODI 11.1x/10.1.3.x, Informatica Power Center 8.x/7.1/6.1

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Senior OBIEE Developer

Responsibilities:

• Gathered business requirements for various projects from end users and efficiently converted the requirements to technical specifications for developing the OBIEE Reports/Dashboards
• Participated in upgrading the entire application and components from OBIEE 11g to OBIEE 12c, re-designed the security, customizations and modified styling sheets for look and feel. Raised various SRs and worked with oracle on several issues we faced and was successful in resolving them.
• Designed and developed Metadata Repository using BI Server Administrator tool by importing the data with integrity constraints into Physical Layer using Connection Pool.
• Worked on building OBIEE Repository at 3 layers i.e., Physical Layer, Business Model and mapping Layer and Presentation Layer.
• Performed admin tasks as deploying and migrating RPD in various environments as DEV, SIT and PROD.
• Migrated RPD and catalog from SIT environment to PROD environment for monthly releases.
• Categorized the Facts, Dimensions and identified the Granularity level in accordance with the need of end user before implementing the Multi-Level Based Hierarchies.
• Customized Star and Snowflake schemas by linking the Fact and Dimension Tables.
• Created measures and Aggregated Tables to better the performance/understanding of the reports.
• Effectively implemented Time Series Functions, calculation Wizard and Expression Builder to generate trend analysis reports.
• Developed Performance Tuning Strategies, for optimized performance, by implementing Aggregate Navigation, Cache Management, re-organizing data, and making some changes to Reports.
• Implemented writeback for various reports for the user to directly update the data in DB.
• Implemented Security by setting Security Realms in Weblogic Console and by configuring Policies, Roles and Groups in Enterprise Manager and integrated them with LDAP.
• Created catalog groups and set permissions for items in the presentation catalog and rights to users and groups.
• Provided access to various users using Confidential ’s internal Security tool CAM.
• Implemented Security at Object level and Data level in the OBIEE Repository and Answers.
• Created Repository and Session Variables and initialized them using Initialization Blocks.
• Developed end-user and migration Documentation briefing the features and capabilities of various reports with screenshots and supporting description on how to schedule and execute the reporting process.
• Developed reports and dashboards with various analytical views with Global and Local Filters and prompts.
• Developed Guided Navigation drill downs, Pivot Tables, Narrative Views, Charts to improve accessibility of dashboards. Built some exclusive view like Trellis View, Pareto graphs, Slider graphs for providing an excellent and interactive dashboards to end users.
• Configured presentation layer used by different user groups and also established various standard queries in order to create precise presentation layer.
• Validated the data in reports with backend data by writing various SQL queries and fixed the inconsistencies in data.
• Participated in all the phases of project - development, testing, deployment and support.
• Integrated reports and with MS Office tools using SmartView and MS Office Integrator.
• Configured agents to deliver content based Analytics on schedule, automated agents to obtain daily and weekly reports.
• Maintained RPD and created reports using NAR standards.
• Deployed the test cases and test scripts to test the reports during the Testing phase.
• Expert in creating design documents (LLD and DLD). Created unit test cases validating the standards and data in dashboard.
• Recommended & debugged legacy PL/SQL packages, procedures, functions and views for systems & converted them in to ETL.
• Played a prominent role in testing data accuracy in reports with backend data.
• Set up the Topology including physical architecture, logical architecture and context and reverse engineered them to designer for creating models. Created new models for the data sources in ODI. Monitored the data load process and work flow in ODI using the operator.
• Creating procedures, variables, interfaces and packages in ODI. Created packages with interfaces, procedures and variables as package steps and loaded the target tables with appropriate mappings and work flow.
• Postproduction support, enhancements and performance tuning the ETL Process.
• Debugged and developed stored procedures to load data from source tables into facts and dimension tables for some projects which did not use ODI ETL.
• Improved the Performance of data retrival from tables in database by creating indexes.
• Expertise on working with tools like TOAD for Oracle and SQL Developer
• Expert in working with MUD (Multi User Development) environment.
• Experience in data analysis, data profiling and validation
• Worked with Smart View and developed reports using BI data in Excel, Word and PowerPoint for presenting to users.
• Developed and created various graphs, views and charts using Tableau for some of the projects.
• Connected to various data sources (file, oracle and others) and created star schema in Tableau and provided reports, dashboards and various charts.
• Have an excellent experience in working on UNIX/LINUX platforms.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images.

Environment: OBIEE 11.1.1.7/OBIEE 10.1.3.4, Oracle 11g/10g, Windows NT, SQL *PLUS, Toad, BI Publisher, SmartView 9.3.1, ODI 10.1.X/11g, Tableau 8.1.

Confidential, Englewood, CO

OBIEE Developer

Responsibilities:

• Worked with end users to gather business requirements from clients and efficiently converted the requirements to technical specifications for developing the OBIEE Reports/Dashboards and ODI Interfaces/Scenarios
• Upgraded the entire application and components from OBIEE 10.1.3.4.2 to OBIEE 11.1.1.5.0/11.1.1.6.0/11.1.1.7.1, re-designed the security, customizations and re-configured the external applications.
• Designed and developed Metadata Repository using BI Server Administrator tool by importing the required objects with integrity constraints into Physical Layer using Connection Pool.
• Worked on building OBIEE Repository at 3 layers i.e., Physical Layer, Business Model and mapping Layer and Presentation Layer.
• Performed some admin tasks as deploying RPD in various environments as DEV,QA and PROD.
• Categorized the Facts, Dimensions and identified the Granularity level in accordance with the need of end user before implementing the Multi-Level Based Hierarchies.
• Customized Star and Snowflake schemas by linking the Fact and Dimension Tables.
• Created measures and Aggregated Tables to better the performance/understanding of the reports.
• Effectively implemented Time Series Functions, calculation Wizard and Expression Builder to generate trend analysis reports
• Developed Performance Tuning Strategies, for optimized performance, by implementing Aggregate Navigation, Cache Management, re-organizing data, and making some changes to Reports.
• Implemented Security by setting Security Realms in Weblogic Console and by configuring Policies, Roles and Groups in Enterprise Manager and integrated them with LDAP and External Table
• Implemented Security at Object level and Data level in the OBIEE Repository and Answers.
• Created Repository and Session Variables and initialized those using Initialization Blocks.
• Created Security settings in OBIEE Administration Tool to set the groups and access privileges. Also implemented security for the groups at the BI Answers
• Developed end-user and migration Documentation briefing the features and capabilities of various reports with screenshots and supporting description on how to schedule and execute the reporting process.
• Developed reports and dashboards with various analytical views with Global and Local Filters and prompts.
• Customized Prompts at page level and Dashboard level, in accordance with the requirements.
• Developed Guided Navigation drill downs, Pivot Tables, Narrative Views, Charts to improve accessibility of dashboards.
• Configured presentation layer used by different user groups and also established various standard queries in order to create precise presentation layer.
• Performed data validation of reports in dashboards to check if data is consistent in them and created unit test cases validating the standards and data in dashboard.
• Participated in all the phases of project - development, testing, deployment and support.
• Integrated reports and with MS Office tools using SmartView and MS Office Integrator.
• Deployed the test cases and test scripts to test the reports during the Testing phase.
• Setup connection with Oracle and flat files. Creating and debugging procedures, variables, interfaces and packages in ODI.
• Set up the Topology including physical architecture, logical architecture and context.
• Developed stored procedures to load data from source tables into facts and dimension tables for some projects which did not use ODI ETL.
• Expertise on working with tools like TOAD for Oracle and SQL Developer.

Environment: OBIEE 11.1.1.7/OBIEE 10.1.3.4, Oracle 11g/10g, Windows NT, SQL *PLUS, Toad, BI Publisher, SmartView 9.3.1, ODI 10.1.X/11g..

Confidential, Mc Lean, VA

OBIEE/ODI Developer

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document by access and retrieval of financial and personnel data from one single source.
• Identified & Created Facts, Dimensions, and Hierarchies of the business model.
• Developed Segment Value Detail, Work Order Detail and OGA Repositories (RPD) by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
• Created catalog groups and set permissions for items in the presentation catalog and rights to users and groups.
• Designed and Tested Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc report according to the client needs.
• Configured Interactive Dashboard with drill-down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects.
• Applied Cascading Prompts and Multi Level Prompts on Dashboards.
• Created Session variables for security.
• Created presentation and Repository variables which are used in reports and dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Improved the performance by caching, Aggregate Navigation and Usage Tracking.
• Deployed RPD in various environments as DEV,QA and PROD
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Wrote Custom SQL Codes for the reports.
• Applied Optimization Techniques for the better performance of the reports.
• Involved in Monitoring and Scheduling different process flows using Oracle Work Flow Manager.
• Used external tables to Transform and Load data from Flat files into target tables.
• Used Debugger to validate Mappings by creating break points to analyze and monitor Data flow.
• Involved in troubleshooting the load failure cases, including database problems.
• Implemented Security by authenticating against the LDAP and external table.
• Trained End Users and Pilot Users about OBIEE Tools.
• Have Excellent hands on experience working on tools like PL-SQL Developer, Toad and SQL Developer.
• Designed and Integrated BI Publisher reports to oracle BI Dashboards for Analysis to PDF/RTF templates
• Created various unit test cases, test scenarios, unit test documents and also verified the test scenarios of the QA team. Unit tested for all the possible test scenarios.
• Worked extensively with ODI Designer, operator and metadata Navigator.
• Conducted code reviews and planned the knowledge transfer to client.
• Created Design and test documents used in reporting.
• Implemented Oracle BI Apps using ODI and OBIEE application tools.
• Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger GL .

Environment: OBIEE 11.1.1.7/OBIEE 10.1.3.4, Oracle 11g/10g, Windows NT, SQL *PLUS, SQL Developer, Toad, BI Publisher, Smart View 9.3.1, ODI 10.1.X/11g.

Confidential, Atlanta, GA

OBIEE Developer

Responsibilities:

• Involved in translating high-level business requirements into logical business dimensional model.
• Worked on UNIX/LINUX operating systems.
• Designed and developed the OBIEE Analytics Metadata Repository (.rpd) using OBIEE Admin Tool by importing the required data base objects both Facts and Dimensions with integrity constraints into physical layer using connection pool.
• Imported Physical tables from Oracle database and defined relations between Physical tables at the Physical Layer.
• Worked on building OBIEE Repository at 3 layers i.e., Physical Layer, Business Model and mapping Layer and Presentation Layer.
• Created Business Facts, Dimensions and defined Logical relation between them at the Business model and mapping layer.
• Mapping in data sources using Oracle BIEE Admin tool to create repository.
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
• Identified and created aggregate tables to improve query performance.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local filters.
• Created Session & Repository Variables to achieve desired functionality.
• Created web-groups for security purpose with access privileges
• Created OBIEE Intelligent Dashboards, & Answers.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Customized Dashboard reports using drill-down capabilities.
• Integrated BI Publisher with OBIEE. Created Templates, Reports and Prompts in BI Publisher
• Created Interfaces, Procedures, variables and mappings to load data from source to target tables.
• Imported knowledge modules for work flow and customized them according to the requirements.
• Created packages with interfaces, procedures and variables as package steps and loaded the target tables with appropriate mappings and work flow.
• Developed Informatica Mappings, Mapplets, Tasks and Workflows using various transformations.
• Redesign Informatica ETL & DAC mappings based on new requirements.
• Configured DAC to run nightly data loads by Schedule.
• Migrated mappings and workflows from development server to Test Server to perform integration and system testing.
• Involved in developing testing documents, including Estimates, Test Strategy, Test Plan, Use Cases, Test cases, Test Scenarios and Test Data according to Requirements Specifications.

Environment: OBIEE 10.1.3.4.0/10.1.3.4.1, BI Publisher, Oracle 10g, Informatica Power Center 8.6, Toad, Windows XP, ODI, PL/SQL.

Confidential

OBIEE Developer

Responsibilities:

• Created/Modified Metadata repository suiting to data requirements using OBIEE Admin tool (.RPD).
• Created the Physical Layer, Business Model and Mapping Layer and presentation Layer using OBIEE Administration Tool (.RPD).
• Developed Answers, Filters, Customized Reports and Dashboards using OBIEE Analytics Web. Build Interactive dashboards with drill-down capabilities.
• Configured Sales & marketing Campaign management.
• Configured the Web reports for the Marketing application.
• Developed and enhance meta-data to Build Business model (SCD’s, Hierarchies, Measures, and Partitions) and establish relationships.
• Simplifies and reorganizes the Meta data into a single business model.
• Organize presentation layer in a format that is easy for end user to use as basis for reporting using OBIEE Analytics Administration tool.
• Cache management and enhancing query performance. Applied best practices to enhance the performance of the application.
• Created users, groups, access privileges and query privileges using Security settings across OBIEE.
• Developing custom dashboards and reports using OBIEE Answers.
• Created customized reports and charts in OBIEE Answers.
• Created Prompts, Filters and charts, pivot tables and views as per client requirement.
• Scheduled Reports using Delivers (Intelligent ibots).
• Developed PL/SQL packages, procedures, triggers, functions, indexes and collections to implement business logic.
• Generated server side PL/SQL scripts for data manipulation and validation.
• Used standard packages like UTL FILE, DBMS SQL, and UTL SMTP.
• Fine-tuned poorly running SQL queries by examining execution plans
• Involved in database development by creating oracle PL/SQL functions, stored procedures, triggers, packages, cursors, records and collections.
• Created PL/SQL program units to include DML, DDL statements using dynamic SQL.

Environment: OBIEE 10.1.3.2, Oracle 10g/9i/8i, TOAD, SQL Navigator, Erwin 3.5.2, Windows NT, SQL Developer

Confidential

OBIEE Developer

Responsibilities:

• Performed Dimension modeling, Identify Fact tables & Measures, Identify Dimension Tables to store business attributes, Created Snowflakes, Star Schemas for proposed architecture.
• Configured physical, business model and presentation layers of the Analytics Repository. Customized/Modified Metadata repository (.rpd) suiting to the organization’s data.
• Built Reports and Dashboards that leverage configured data model to meet client’s analysis business requirements.
• Configured Intelligence Dashboards by adding, included and embedded content such as links/images, HTML objects and folders.
• Created Subject Areas, Folders/Sub-folders, and Presentation/Business columns; Prepared Charts & Tables in pane; Query, Filter, Drill-downs, User / User group level Security requirements.
• Cache management and enhancing query performance. Applied best practices to enhance the performance of the application.
• Created users, groups, access privileges and query privileges using Security settings across OBIEE.
• Created iBots and Delivers to send Alert messages to subscribed users.
• Involved in developing testing documents, including Test Plan, Test cases, Test Scenarios and Test Data according to Requirements Specifications.

Environment: OBIEE 10.1.3.2, Oracle 10g/9i, Windows NT, SQL.