Summary

• Demonstrated Functional expertise inCommunication wireless, Product Base, Port Transportation domain with in depth knowledge of Software Development life cycle SDLC , Business process Re-engineering and project management principles.
• Strong techno-functional service attitude exceptional organizational ability, works well within a large group, holding meetings and reaching out to others for information, have excellent written and verbal communication,polish professionalism and demonstrate logic skills, and able to create and follow procedures. Ability to work unsupervised, have the ability to work proactively, possess attention to detail and a 'can do' attitude. Commit to getting the job done, excellent troubleshooting skills, works well under pressure and have the ability to multitask. Excellent interpersonal and leadership skills in working with onsite/offshore software development teams.
• Innovative Principal Consultant with more than 7 years of software development in designing and supporting BI DW implementations ranging from requirements gathering, conducting interviews, Business/Data Analysis, design, customizations, Integration, conversions, development, unit and system testing. Demonstrated expertise in OBIEE.
• Experience in OBIEE 10.1.3.4, OBIEE 11.1.1.6.0, and OBIEE 11.1.1.7.0 providing end-to-end business intelligence solutions by dimensional modeling design, building business models, configuring metadata, creating reports and using dashboards.
• A very good understanding of a Customized database helping users in understanding the reports and the reporting
• Excellent problem solving skills with strong technical background and good inter-personal skills, Quick learner and excellent team player, ability to meet deadlines and work under pressure.
• Expertise in Oracle BI Server, Oracle BI Answers, BI Scheduler, Oracle BI Interactive Dashboard and BI Publisher.
• Experienced in interacting with Business users conducting interviews to gather, analyze and document user needs, business processes, identifying reports/KPIs and other requirements then rolling out deliverables.
• Extensive experience in OBIEE repository Physical, Business Model and Mapping and Presentation layers for both Stand-Alone and Integrated OBIEE implementations.
• Expertise in using dimensional hierarchy modeling and time series modeling in the Business Model and Mapping layer to meet business requirements.
• Expertise in OBIEE Publisher using multiple data sources. Trained end users to easily design report layouts directly in a Web browser, this dramatically reduced the time and cost needed to develop and maintain reports.

Technical Skills

Detailed Professional Experience

Confidential

Oracle Business Intelligence Analyst

Role:

• Worked closely with Business Users and Subject Matter Experts SMEs , reviewed Functional Design Document, created Technical Design Document and gathered the requirements from different user groups and created the design for the metadata repository. Some of the reports include Bed availability, click to inquiry, customer conversion, monthly facility web traffic and monthly facility placement reports.
• Developed OBIEE metadata repository model with the necessary logic that involved creating the Physical, BMM and the Presentation layer.
• Developed hierarchies, variables, joins, time series objects, and aggregate navigation and event poll strategies in the repository.
• Developed Calculated Measures and assigned Aggregation levels based on Dimension Hierarchies, thereby achieved performance enhancement.
• Created various reports in multiple views such as Pivot Table, Charts, Tabular, View Selector,
• Configured Global Filters and Prompts these reports were placed under various dashboards based on the subject areas that were used for managerial decisions.
• Performed Performance Tuning of Dashboards/Reports by implementing strategies like aggregate navigation, cache management, materialized views.
• Created Action Links, generated navigational reports with conditional formatting of columns.
• Customized logical tables and columns, defined the Analytics dimensions, aggregations and levels.
• Implemented Security Object Level, Column Level by setting up users, groups with access privileges and query privileges.
• Deliver final test results

Technical Environment: OBIEE 11g, Jira, Oracle 11g,Informatica, Qlikview

Confidential

Oracle Business Intelligence Business Analyst/Developer

• Worked closely with Business Users and Subject Matter Experts SMEs , reviewed Functional Design Document, created Technical Design Document and gathered the requirements from different user groups and created the design for the metadata repository. Some of the reports include Bed availability, click to inquiry, customer conversion, monthly facility web traffic and monthly facility placement reports.
• Developed OBIEE metadata repository model with the necessary logic that involved creating the Physical, BMM and the Presentation layer.
• Developed hierarchies, variables, joins, time series objects, and aggregate navigation and event poll strategies in the repository.
• Developed Calculated Measures and assigned Aggregation levels based on Dimension Hierarchies, thereby achieved performance enhancement.
• Created various reports in multiple views such as Pivot Table, Charts, Tabular, View Selector,
• Configured Global Filters and Prompts these reports were placed under various dashboards based on the subject areas that were used for managerial decisions.
• Performed Performance Tuning of Dashboards/Reports by implementing strategies like aggregate navigation, cache management, materialized views.
• Created Action Links, generated navigational reports with conditional formatting of columns.
• Customized logical tables and columns, defined the Analytics dimensions, aggregations and levels.
• Implemented Security Object Level, Column Level by setting up users, groups with access privileges and query privileges.
• Deliver final test results

Technical Environment: OBIEE 10g 10.1.1.3.4.1 , OBIEE 11g, Oracle 10g, Toad, SQL, Weblogic

Confidential

Oracle Business Intelligence Business Analyst/Developer

• Involved in GAP Analysis and gathered requirements of the various work streams by meeting with the Business Analyst and Business Users and base lining the details.
• Designed repository based on business requirements, followed design best practices for the RPD and Dashboard designs.
• Worked extensively on OBIEE Repository, that includes Physical Layer, Business Model layer and Presentation Layer using OBIEE Administration Tool.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Used different filter conditions both in the repository and in front end based on business rules provided by the business users.
• Created dimension hierarchies, aggregates and keys in the BMM layer.
• Worked with DBAs to create materialized views and aggregates to improve performance.
• Created the prompts of OBIEE as to navigate in a Map.
• Created reports which are used to analyze the Performance and Response of the Campaigns held by the Marketing Team.
• Delivered Reports and Dashboards: Sales by Region, Geo Sale by Product, New device by Customer, ASM by Region, PPI Dashboard, Product order Dashboard

Technical Environment: OBIEE 10g 10.1.1.3.4.1 , Oracle 10g, SQL Developer, SQL, Perforce

Confidential

Oracle Business Intelligence Business Analyst/Developer

• Supports the process of translating business needs into formal Business Requirements deliverables. Assist the team manager in maintaining the relations with Senior Business executives.
• Worked for Delivery Management, Management Reporting, Collections/Default Servicing processes Analytics and Portfolio Management analytics processes.
• Gathered requirements for reports/processes being requested and documented required processes. Deliverables included data lineage documents, support and troubleshooting documents and process flow diagrams
• Established and maintained communication between the line of business and Consumer Risk MIS
• Maintained the storage and retrieval of all project communications data and business metrics.
• Facilitated customer-facing meetings and respond to questions / analysis requests using data analysis techniques
• Performed data mining for the purpose of understanding data lineage in legacy systems
• Design and developed report mockup and UI design using MS-Visio
• Designed and developed the OBIEE Metadata Repository using OBIEE Server Admin tool by importing the required objects Dimensions, Facts Aggregates with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions Drill-down Hierarchies Logical Facts Measure objects in Business Model Layer, and creating Presentation Catalog in Presentation Layer.
• Design Aggregate tables to improve performance
• Created a new subject area as per the business requirements
• Created new dashboard which is only visible to users of the corporation
• Created and scheduled iBots Agents for delivering personalized reports to users
• Designed Intelligent Dashboards for different user groups to view updated KPIs
• Developed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative and Nested reports in Answers
• Performed complex OBIEE Analytics configuration involving report generation from OLTP and OLAP databases systems
• Upgrading Analytics RPD and made changes to the physical area to reflect merges in ETL and changes in the Upgrade Data Model
• Performed extensive debugging on existing ETL routines and repository .rpd layers
• Created detailed filters in repository .rpd to implement position based visibility
• Created Design and Development Documents for creation of new subject areas/customization
• Responsible for Data Modeling, Functional and Technical Design for the client
• Established aggregate tables and set up the repository to perform aggregation navigation
• Developed detailed documentation for the business users
• Trained End users.

Technical Environment: OBIEE 10g, Oracle 10g, MS-Office, SQL Server 2005.