Senior Obiee Consultant Resume Samples

Description :

1. Developed the Risk reports for different clients including their Market Exposures, Equities and Limits.
2. Involved designing the data models using RPD and creating reports for two different teams and supporting Business Users to resolve their issues from reporting perspective.
3. Worked on OBIEE 10.1.3.4.1 version for creating the repository and generating reports for different Aexeo Development Warehouse and Risk Development Warehouse.
4. Developed and fine tuned OBIEE metadata repository using Admin Tool.
5. Worked on the Baskets Functionality for Equities, options related Instruments at Client Vendor Broker and Fund Levels as per time series related report dates.
6. Responsible for Installations included Oracle Client, Oracle BI Enterprise Suite 10.3.4.1 on Windows Vista.
7. Worked on Limits Functionality which would help users to see the trends for different Entities and their Gross Exposures, Soft Limit Values and Hard Limit Values along with references amounts and Result sets.
8. Worked on end to end Development in RPD with Dimensional Hierarchies for Publishers, Instruments and other attributes, Variables (both session and repository) and also Logical Table Sources from different facts.

Experience

0-2 Years

Level

Entry Level

Education

Bachelor's

Description :

1. Responsible to consult, administer, analyze , secure and audit HR Data.
2. Provided knowledgeable support and guidance to HR and Business Professionals thereby positively influencing Human Resources decisions, which will ultimately result in heightened business performance and efficiency.
3. Installed and configured complete suite of OBIEE 10.1.3.4 and OBIA 10.1.3.4 in test and development environment.
4. Completed SDLC of implementing Out of the box Order Management Analytics, HR Analytics from Oracle's packaged solution (OBIA) for analytics reporting.
5. Installed and configured of Out of the box solution of OBI Application (Order Management Analytics, SCM Analytics, Financial Analytics, HR Analytics) on version 10.1.3.4.
6. Worked to modify HR - Compensation, HR - Performance, HR - Retention and HR - Workforce Planning Out of the box Repository.
7. Changed Out of the box dashboards and provided detail level drill downs to as per business requirements using Oracle Answers.
8. Worked extensively on OBIEE Administration tool and Presentation Services.
9. Worked on the different layers in the data model (Physical, Business and Presentation).

Experience

2-5 Years

Level

Junior

Education

Bachelors

Description :

1. Responsible for Packard is an American multinational information technology corporation is now one of the world's largest IT companies, operating in nearly every country.
2. Implemented OTM/FTI and Demantra/APCC by addressing the need for end to end order visibility from customer order to supplier PO including linkages across all platforms, show on-hand and intransit inventory and to provide milestone status on order life cycle.
3. Involved in Project Scoping, Project Organization and Management including Business & IT Requirements, Priorities, Project Execution Plan and Resource Plan.
4. Performed Gap Analysis to understand the Modifications in OOTB FTI/OTM(OBIEE) to fulfill the business requirements.
5. Interacted with business representatives for gathering the Reports / Dashboards requirements.
6. Developed PL/SQL Stored Procedures to create agents for Automatic update between related or dependant orders, for ex: if the executable order ICPO changes, the status of the related ICSO should change automatically.
7. Analyzed the architecture and data warehouse structure of the OOTB Advanced Planning Command Center (APCC) and Fusion Transportation Intelligence (FTI).
8. Modified PL/SQL stored procedures to extract and load data from GLOGOWNER to HDOWNER.
9. Validated the business model of Fusion Transportation Intelligence by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.

Experience

5-7 Years

Level

Executive

Education

Bachelor's

Description :

1. Experiences in Dimensional Modeling
2. Experiences in ETL using either PL/SQL and/or ODI
3. Experiences in Oracle Database Designing tables, views and materialized views for use in BI Applications
4. Experiences as an Architect on a Datawarehouse project
5. Experiences in Setting up security to authenticate users and grant permissions and privileges to appropriate users
6. Experiences in Relational database design (relational models, star schema, keys, common terminology)
7. Experiences in development of technical design documentation

Experience

2-5 Years

Level

Junior

Education

Bachelor's

Description :

1. Designs and develops all aspects of new Hyperion implementations and required changes to existing applications.

1. Translates client business needs into practical architecture for budgeting, reporting, or consolidation solutions.

1. Defines systems strategy, develop systems requirements, design, prototype, implement and rollout solutions.

1. Writes and maintains clear, concise functional and technical specifications for Hyperion applications and business system processes.

1. Writes custom Business Rules and/or Calculation Scripts for custom logic to facilitate client budgeting and forecasting needs.

1. Proactively and frequently communicates with customers to build and maintain a solid working relationship.

1. Responsible for Integration of Hyperion applications with existing processes, including budgeting and forecasting, and data warehouse/management reporting.

Experience

5-7 Years

Level

Executive

Education

Bachelor's

Description :

1. Worked in whole life cycle of the project from requirements gathering to deployment.
2. Analyzed data and developed Logical Star Schema modelbased on business requirements.
3. Participated in Installation of OBIEE 11g on Linux and worked on Weblogic Admin console and Weblogic Enterprise manager.
4. Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
5. Developed Time Series Objects using Ago and To Date functions for time series comparisons.
6. Managed security in OBIEE Administration Toolfor access privileges and query privileges.
7. Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.
8. Worked with data admins and tuned Performance for Dashboards and Reports.
9. Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.

Experience

7-10 Years

Level

Management

Education

Bachelors

Description :

1. Ability to obtain and maintain a Public Trust security clearance.
2. Ability to perform installation and upgrade of applications, databases, and tools including patching of technology stack and databases.
3. Ability to apply database and application performance tuning techniques for keeping all environments at optimal performance.
4. Responsible for meeting deadlines and SLAs related to creation and cloning of application and database environments including assignments for special projects.
5. Ability to work in a team environment and provide knowledge sharing to the DBA team.
6. Recommends improvements to processes and procedures to increase productivity, reduce maintenance cycles, and improve quality delivery.
7. Ensures appropriate documentation is created and maintained for projects and operational procedures.

Experience

2-5 Years

Level

Junior

Education

Bachelors

Description :

1. Participates and provides support to testing activities for projects and monthly maintenance.
2. Performs software change configuration management functions through program standard tools to deploy approved changes to applications and database environments.
3. Supports and maintains password resets for server and database accounts.
4. Works with Hosting Service provider for server, storage, network, and firewall requirements.
5. Creates and maintains UNIX Shell scripts for automation of Oracle RMAN backup and recovery, and cloning of applications and database instances, monitoring etc.
6. Ability to perform cloning of application and database instances utilizing Oracle’s Rapid Clone methodology, Oracle RMAN (Recovery Manager), and Oracle RAC.
7. Ability to support and maintain backup and recovery activities and processes utilizing Oracle RMAN (Recovery Manager).

Experience

5-7 Years

Level

Executive

Education

MS

Description :

1. Works on other Hyperion development projects with the rest of the Hyperion Team and business users as needed.
2. Creates and delivers abstracts, webinars and presentations for conferences, user groups and social media.
3. Produces and delivers documentation for design, training and application administration.
4. Operates independently to provide quality work products to an engagement.
5. Demonstrates expertise to deliver functional and technical solutions on moderately complex customer engagements.
6. Effectively consults with management of customer organizations.
7. Gains client acceptance of the defined solution.

Experience

5-7 Years

Level

Executive

Education

Bachelor's

Description :

1. Demonstrated PeopleSoft ERP functional/technical implementation expertise in a large, complex environment
2. Demonstrated expertise of PeopleSoft development tools, integration methods and related technologies.
3. Demonstrated systems integration expertise leveraging and integrating multiple Oracle applications (e.g., ERP (PSFT), GRC, OAM, OIM, Golden Gate, OBIEE)
4. Demonstrated expertise providing technical guidance and leadership to implement information technology solutions that efficiently meet user requirements, are maintainable, and consider future product and market direction.
5. Responsible for development and maintenance of assigned enterprise architecture project and takes project from planning through final delivery. Interfaces with all areas affected by the project including end users, computer services, and client services.
6. Provided technical and analytical guidance for enterprise architecture. Recommend data integration solutions and execute on the ETL solutions.
7. Possessed extensive knowledge of and hands‐on experience with oracle data integrator or other ETL tools.

Experience

0-2 Years

Level

Entry Level

Education

Bachelors