KEY SKILLS

• Five Years experience in OBIEE, 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.
• Five years expertise in Oracle BI Server, Oracle BI Answers, BI Scheduler, Oracle BI Interactive Dashboard and BI Publisher.
• Extensive experience in OBIEE repository Physical, Business Model and Mapping and Presentation layers for both Stand-Alone OBIEE implementations.
• 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 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.
• Proficient in implementing comprehensive Security functionality - created users web groups, external table security using session variables, tested and validated the model using OBIEE Admin tool and associating Catalog objects Web modules with the created users / groups to data and object level security

TECHNICAL SUMMARY

• Operation Systems : XP Professional/Vista, Windows 2000 Server, AS400, Latitude
• Business Intelligence: Oracle Business Applications, OBI EE Dashboards, Answers, Ibots, BI Publisher
• Databases: Oracle 10g/11g
• Databases And Office: MS Office Enterprise

PROFESSIONAL EXPERIENCE

OBIEE DEVELOPER

Confidential

Roles Responsibilities

• Identified Created Facts, Dimensions, and Hierarchies of the business models.
• Developed 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 objects in the presentation
• catalogue and privileges and permissions to users and groups
• Created Interactive reports with drill-down capabilities using global and local filters, Metadata Objects and Web Catalog Objects
• Applied Multi Level Prompts on Dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Worked with ETL in the developmental stage of creating tables for user requirements.
• Developed Multiple Reports pivots, charts, tabular using global and local Filters.
• Meeting with the users to establish their requirements from the reports based on the original specs.
• Upgrading from DEV to Stage and have a few users test the reports
• Getting feedback from the testers and logging them in SharePoint
• Addressing and fixing the issues
• Promoting from Stage to PROD.

Environment: Oracle Business Intelligence suite OBI EE , AS400 , Latitude

OBIEE DEVELOPER

Confidential

Roles Responsibilities

• Building connections pools and configuring metadata in repositories, Physical, Business Model and Mapping Layer and Presentation
• Building Star Schemas and Snowflake Schemas and creating Alias tables
• Deploying RPDs using the Enterprise Manager
• Performance tuning through the Admin tool
• Copying SQL query from the log and running it in SQL Developer to test columns running slow
• Developing reports, graphs, tables in analytics
• Involved in Building Dashboards and creating interactive dashboards via Dashboard prompts.
• Involved in creating the reports requested by users using the BI Publisher , previously they used only analytics and dashboards for reports.
• Introduced multiple views like View Selectors, Column Selectors, Pivot tables in OBI dashboards.

Environment: Oracle Business Intelligence suite OBI EE , Oracle 10g and 11g, SQL

BUSINESS ANALYST

Confidential

• Regional Acceptance is a nationwide company that trades in cars sales now merged with BB T. Their were migrating their system from AS400 to Latitude and manual files to Oracle ,MS SQL database and required a team to reconstruct the data files into AS400 then to Latitude operating system and Oracle Database and train their personnel in the new system
• Roles Responsibilities
• Consulted with functional unit management to identify, define and document business needs and objectives, current operational procedures, problems, input and output requirements, and levels of systems access.
• Analyzed the feasibility of, and developed requirements for, new systems and enhancements to existing systems ensured the system design fits the needs of the users.
• Tracked and documented changes for functional and business specifications wrote detailed universally understood procedures for permanent records and for use in training.
• Acted as a liaison between departmental end-users, technical analysts, information technology analysts, consultants in the analysis, design, configuration, testing and maintenance of management systems to ensure optimal operational performance
• Participated in user acceptance testing and testing of new Latitude system functionality.
• Provided technical assistance in training, mentoring, and coaching professional and technical staff.

Environment: Oracle Business Intelligence suite OBI EE , AS400 , Latitude