SUMMARY:

• Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist.
• Dimensional Modeling in Depth certification from Kimball University
• More than 8 years of IT experience.
• 8 years of Experience across Development, Administration and Testing innumerous OBIEE projects.
• 2 year experience in designing and implementing various Dimensional Modeling Techniques
• Sound knowledge of Architecture and hands on experience on OBIEE 11g components including OBIEE Repository, Analytics (OBIEE Answers & Dashboards), Enterprise Manager, Admin Console, Administration activities and Security implementation.
• Almost 2 years of experience with OBIA 11.1.1.7.1 Financial Analytics with EBS as the source
• Experience in leading ODI 11g and Informatica 9.5.x teams. Extensive experience with Onsite - Offshore Model

TECHNICAL SKILLS:

Business Intelligence: OBIA 11.1.1.7.1 Financial Analytics with EBS 11.5.10, OBIEE 11.1.1.x, BI-Publisher 11.1.1.x, OBIEE 10g, Siebel Analytics 7.8

Databases: Oracle 11g, Oracle10g, Oracle 9i, MS-SQL Server

Platforms: Windows (XP/7),UNIX (IBM-AIX)Tools Oracle SQL developer, Toad, Putty, WinSCP

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Informatica 9.5.x,WhereScape

Data Analyst

Responsibilities:

• Interacted with Business to create Functional and Technical Design document
• Gathered Business requirements and Data Realities
• Responsible for Building & deploying OBIEE Repository code
• Responsible for Building & deploying OBIEE Reports & Dashboards
• Defined Row and Object level Security
• Conducted Unit Testing and participate in SIT and QA testing

Confidential, Charlotte, NC

Environment: OBIA Financial Analytics ( ODI 11G / OBIEE 11.1.1.7.1 )

OBIA Lead

Responsibilities:

• Understanding Business Requirements and create High and Low Level Functional Design and Technical document
• Creating Robust/Scalable data model that enabled LPL internal users to generate a dashboard view for varying levels of advisor models
• Lead the ETL Team who was successfully able to accommodate data from multiple source systems within the firm
• Creating interactive OBIEE Dashboards & Reports to give insight information to determine an advisors level of usage / non-usage of the technologies. This helped accelerate operational efficiency /Decision enabling.
• Created underlying RPD and implemented object and Data Level security
• Customizing OBIA Financial Analytics Warehouse tables and Out of the box reports and Dashboards
• Participate in Design Reviews, SIT and QA Testing

Confidential, Charlotte, NC

Environment: OBIEE 11.1.1.714 g

OBIEE Consultant/ Data Warehouse Architect

Responsibilities:

• Interact with Business and create Functional and Technical Design document
• Build & deploy OBIEE Repository code
• Build & deploy OBIEE Reports & Dashboards
• Define Row and Object level Security
• Conduct Unit Testing and participate in SIT and QA testing
• Gather Business requirements and Data Realities
• Define Business Process, Grain. Design and Implement Dimension tables and Fact tables
• Define Fact table structure - Foreign Keys, Degenerate Dimensions & Metrics. Design and Implement Transaction, Accumulating and Periodic Snapshot tables
• Define Dimension table structure - Primary Key, Attributes. Design and Implement various Dimension Modeling techniques like Snowflake, Outrigger, Conformed, Role Playing and Mini Dimension
• Design and Test Type-0 to Type-4 Slowly Changing Dimension techniques
• Create and maintain Bus Matrix to track Grain
• Design and Test Bridge table to resolve many to many relationship between two tables
• Conduct and Participate in Design Reviews, SIT and QA Testing
• Provide assistance to the ETL team during Design, Coding and Testing

Confidential

Environment: OBIEE 11.1.1.7.0/7.1 , Oracle SQL Developer, Putty, WinSCP

OBIEE Technical Lead

Responsibilities:

• Installed patches on various OBIEE versions in UNIX environment(IBM-AIX)
• Developed/modified OBIEE/BI-Publisher reports, dashboards and underlying Repository/Data Model as per Business requirement
• Implemented Data and Object level security for new projects and enhancements
• Suggested Client to implement MUDE process for Repository code migrations. Created and presented Proof of concept to the client. Successfully Implemented MUDE process across 3 environments. Received appreciation email from client for this effort
• Created a presentation capturing features of 11g ( 11.1.1.6.5 ) BI-Publisher. Conducted trainings for client IT department on the same. Created a presentation capturing new features in OBIEE 11.1.1.7 and presented it to Client IT managers and end users. Created quick Proof of concepts to demonstrate new features like Smart View, Best Visualization view, Tile view etc. Created POC to demonstrate new features in 11.1.1.7 BI-Publisher. This included creating BI-Publisher report using Subject area, creating BI-Publisher report using Logical query etc.
• Troubleshoot performance and incorrect data issues in PROD. Created root cause Analysis document. Provided Solutions/work around
• Assisted in Data center move project which was aimed to patch 11.1.1.6.5 to get to 11.1.1.7.0. Provided Solutions/work around for the issues faced during the patch

Confidential, Chicago, IL

Environment: OBIEE 11.1.1.6.5 , Oracle SQL Developer, Putty, WinSCP

Onsite coordinator/Technical Lead

Responsibilities:

• Understood and documented existing Business processes
• Created and presented Business requirement documents to the Business. Got sign-off from Business Stakeholders on the same
• Created and presented Technical design documents to Client IT Managers and Business Analysts. Got sign-off from IT team on the same
• Discussed Business requirement documents and Technical design documents with offshore counterparts. Ensured that requirements are understood. Set Technical expectation from the team
• Active involvement in coding OBIEE reports, dashboards, Repository, BI-Publisher reports. Implemented data and object level security
• Conducted code reviews first with Offshore counterparts and then with Client IT Managers and Business Analysts.
• Assisted users in UAT. Resolved issues and provided enhancements as requested
• Active involvement in production implementation
• Striking features in the project
• Implemented Write-back in OBIEE 11.1.1.6.5
• Created Subject area in OBIEE for ad-hoc analysis. Created scheduled reports using agents
• Integrated BI-Publisher reports with OBIEE Dashboard.
• Created complex reports in BI-Publisher by joining data sets. Used Repeating section concept on the web template. Did xml coding to achieve conditional formatting in rtf template
• Implemented Bursting in 11.1.1.6.5 BI-Publisher

Confidential

Environment: OBIEE/BI-Publisher 10g, MS-SQL Server 2008, Oracle 10g

Senior Developer

Responsibilities:

• Studied the Source system and created high level Design document
• Studied the existing reports and created Reporting Requirement and design document for OBIEE and BI-Publisher
• Created a new Subject area OBIEE RPD. Configured all 3 layers in RPD.Worked on OBIEE security, variables, projects etc.
• Worked on OBIEE Answers and Dashboards to replicate the existing reports on OBIEE
• Worked on BI-Publisher to create pixel perfect reports expected by the Client
• Assisted and performed issue resolution in UAT Phase
• Involved in validating the functionality of reports
• Conducted Testing of the Report Metrics, attributes and format of OBIEE and BI-publisher reports

Confidential

Environment: OBIEE/BI-Publisher 10g, Putty, Oracle DB 10g

OBIEE Administrator

Responsibilities:

• Involved in merging of the OBIEE Repository in Multi-User environment
• Performing UNIX based OBIEE Repository migrations in various environments
• OBIEE Web Catalog migration in various environments
• Security setup for a new project
• Creating and managing TNS entries for various environments on the UNIX server
• Granting access to the users in OBIEE and BI-Publisher
• Creating JDBC connections and managing the security in BI-Publisher
• Migration of the Catalog across various environments
• Involved in troubleshooting and fixing the issue incase Application is slow/not available
• Creation of low level design document
• OBIEE RPD code creation/modification. Configured all 3 layers in RPD,security,variables and projects
• Worked on OBIEE Answers and Dashboards to create/modify OBIEE Reports /dashboards according to Business requirements
• Studied the existing security model and added changes pertaining to the requirements
• Conducted Backend Testing for the Reports

Confidential

Environment: OBIEE 10g, Oracle DB 10g

Senior Developer

Responsibilities:

• Created connection pools, physical tables, schema folders and catalog folders in thephysical layer of the repository.
• Defined Primary key-Foreign key relationships, complex joins between dimension tables and Fact tables. Created Opaque views for complex queries
• Created Business model with logical tables in the Logical Display folders.
• Created Dimension Hierarchies in Business layer for Drill down functionality.
• Created Preferred Drill Down Path.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Design various reports with Drilldown, Navigation.
• Created Pie Charts, Pivot Table, Narrative Views, Static Views etc.
• Maintained Effectiveness in creating the Dashboards by appropriately including guided Navigational links and drilldowns.
• Review of Unit test cases, Integration test cases of all the assigned modules.
• Testing individual modules of the software against the Unit test cases.
• Created canned Report using “Combine Similar Request” feature
• Created Complex Filters for Date Selection
• Used Presentation Variables for passing values from prompts to reports
• Used Filter based on another request
• Worked on Object Level Security
• Involved in validating the functionality of reports
• Configured & Scheduled OBIEE I-bots/Agents
• Implemented data level security on OBIEE RPD
• Studied the Source system and created high level Design document
• Worked on OBIEE Answers and Dashboards to replicate the existing reports on OBIEE
• Worked on BI-Publisher to create pixel perfect reports expected by the Client
• Provided OBIEE Trainings and played mentor role

Confidential

Environment: OBIEE 10g, Oracle DB 10g

Developer

Responsibilities:

• Studied existing system and customer requirements and understood the High Level Design
• Prepared the Project Documentation as per the Process
• Analyzed the requirement and identified the Physical Tables at the Backend.
• Worked on OBIEE Answers to create the reports as per the client requirements
• Configured intelligent Dashboards for different groups and users
• Added new users and assigned them to appropriate groups for visibility to reports and dashboards
• Studied the usage Tracking mechanism for the Project
• Conducted full fledge Backend Testing for the Reports
• Involved in validating the functionality of reports
• Created ad-hoc Reports as per the Client request

Confidential

Environment: Siebel Analytics 7.8.5, Oracle DB 9i

Associate Developer

Responsibilities:

• Was responsible for publishing reports using BI Publisher
• Created RTF templates for reports in MS word
• Published simple as well as pivot table reports in BI publisher using table wizard and crosstab
• Used Oracle BI answers and SQL query as source to publish the reports
• Using SQL query created own SQL's and also used OLAP query of dashboards to publish the reports
• Confidential 's (List of Values) and Parameters in BI Publisher were used to filter the data according to the input provided
• Created RTF templates in landscape and portrait mode using MS word
• Created connection pools, physical tables, schema folders and catalog folders in the physical layer of the repository.
• Defined Primary key-Foreign key relationships, complex joins between dimension tables and Fact tables.
• Created Business model with logical tables in the Logical Display folders.
• Created Dimension Hierarchies in Business layer for Drill down functionality.
• Created Preferred Drill Down Path.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Design various reports with Drilldown, Navigation.
• Created Pie Charts, Pivot Table, Narrative Views, Static Views etc.
• Maintained Effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Review of Unit test cases, Integration test cases of all the assigned modules.
• Testing individual modules of the software against the Unit test cases.