SUMMARY:

• Highly accomplished and solutions oriented IT Professional with broad based knowledge in Systems Design and Development, implementing and integrating cost - effective, high performance technical solutions to meet challenging business needs.
• Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist
• Excel in strategic planning, project management, implementing best practice methodologies and consistently improving delivery times and service levels while reducing costs.
• Extensive experience in OBIEE security models implementation and OBIEE Environment administration (MUD creation, configuration and Support).
• Excellent aptitude in translating high-level business requirements into logical business dimensional models, building business models, configuring metadata, answers, delivers / iBots, creating reports / dashboards, cache monitor.
• Expertise in business model development with various functionalities such as Dimensional Hierarchies, Measures, Aggregation Rules, Time Series and other functions.
• Highly skilled in building Interactive Dashboards with drill-down & drill-across capabilities using global & local filters, business rules with user identity & roles, profiles & personalization
• Knowledge of implementing the Oracle BI Setup (groups, data access/query privileges), Metadata Objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Debugging, Optimizing and Performance Tuning of OBI (Siebel Analytical) Dashboards / Reports to improve performance at Database.
• Proficient in working on production and development environment in different RDBMS (in Oracle 10g/11g).
• Practical understanding of the Data modeling (Dimensional & Relational) concepts including Star-Schema modeling, Snowflake modeling, Fact and Dimension Tables modeling of data
• Experience in onsite / offshore development model.

TECHNICAL SKILLS PROFILE:

Applications / Modules: OBIEE 10g/11g, BI Publisher 10g/11g, Informatica, ODI, SSMS (2012, 2016), MDR, Visual Studio 2017, Hadoop

OBIEE Versions: 11.1.1.9, 10.1.3.4.1 , 10.1.3.2.1 & Seibel Analytics

Languages: SQL, HTML, XML, C#, HiveQL

Methodologies: Oracle AIM, SDLC, Waterfall, Agile.

Operating Systems: MS Windows, UNIX

Software: Microsoft Office Suite, including MS Project, XML, Web Services

Databases / Tools: Oracle SQL Developer, Toad, SQL Server, Hive

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

OBIEE Developer

Responsibilities:

• Created Dashboards and Reports with Pivot tables, charts and view selector features.
• Created documentations and archives for migration to higher environments.
• Customized the OBIEE Repository to satisfy LOB Report requirements.
• Supported Ad-Hoc requests for report and dashboard enhancements.
• Responsible for merging repository file in OBIEE.
• Coordinated and managed work with offshore team members to meet timelines
• Received intense in Hadoop framework.
• Worked on SSMS 2016 enhancements and new feature implementation with focus on Always Encrypted.
• Created HIVE database, tables, and views.
• Imported data into HIVE tables from file/table
• Created Hive tables with partitions/ Created partitions on existing tables.
• Exported tables from HIVE to Oracle Database using Sqoop.

Confidential, Albany, NY

OBIEE Developer

Responsibilities:

• Worked closely with the Business Analysts, Business Users and Developers to gather, analyze and in corporate business requirements into the project deliverables
• Complete requirement analysis, by helping to capture, document and prioritize the customer’s business and technical needs.
• Converted Oracle Discoverer Reports to OBIEE.
• Participated in the design and implementation of the metadata and reporting end of the solution. This includes testing and at times the deployment of the components
• Ensured that development activities adhere to the team’s standards and best practices so that overall business intelligence data integrity is maintained.
• Individually built the RPD within OBIEE, which includes the physical, business and presentation layers following the company’s standards, to meet the business requirements of the project.
• Proactively communicate issues to team to assist in managing defects.
• Testing of the repository, reports and dashboards to make sure they meet business requirements after complete development.
• Created reports using multiple views and also utilizing presentation variables to dynamically change report columns and titles with changes within the dashboard prompts.
• Created Dashboards with Dashboards Prompts including Dashboard Objects such as, Text, Action Link, Embedded Contents.
• Created Project Home Page with navigation links to different dashboards and reports, utilizing HTML context in all the dashboards
• Provided conditional filtering for some columns in the RDP level and for specific columns in the report level.
• Created object level security to dashboard folders and dashboards, including individual reports within certain catalog folders.
• Provided support to other team members on Repository, Reports and Dashboards Issues.
• Created test data and imported into schema tables.
• Scheduled reports delivered to users’ emails and dashboards.

Confidential, MI

OBIEE Developer

Responsibilities:

• Requirement validation of the reports and drill downs with business users.
• Creation and Customization of the OBIEE Repository (Physical, Business and Presentation layers)
• Maintaining and configuring BI Publisher application
• Convert existing analysis into BI publisher reports
• Ensure the necessary data source connections are defined and pointing to the appropriate database.
• Configuring MUDE (Multi User Development Environment), OBIEE scheduler, usage tracking.
• Knowledgeable in cache management, Repository migration, overall security, data level and object level security in OBIEE Analytics.
• Created dimension hierarchies, level based measures, Time Series metrics and derived columns of business metrics in the BMM layer.
• Worked on repository and session variables.
• Customized reporting with OBIEE Analysis and integrated them into the Dashboards.
• Generated Reports and Dashboards by using Report features like Pivot tables, charts and view selector.
• Created dashboards with global prompts, column selectors, navigation, and automatic drill-down.
• Created user level security for intelligence dashboards based on Business Requirement in OBIEE 11g.
• Performed Data Validation of data in the reports and dashboards.
• Performed production support.

Confidential, San Jose, CA

OBIEE Consultant

Responsibilities:

• Gathered business requirements by interacting with the Business Analysts and the Business Users and created mockup reports.
• Customized the Siebel Analytics Repository (physical, BMM, and presentation layers).
• Created dimension hierarchies, aggregates, and logical sources in the BMM layer.
• Worked on repository variables and session variables.
• Used the security settings in the Console and Enterprise Manager to setup users, Groups and Access privileges.
• Involved in the upgrade task force as well as verifying the new environment.
• Defined ibots/agents and delivers for various request.
• Generated Reports by using Report features like Pivot tables, charts and view selector.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables in 10g/11g
• Performed Data Validation of data in the reports.