SUMMARY:

• 9 years’ experience in Business Intelligence and Analytics.
• 6+ years’ experience in Oracle Business Intelligence Enterprise Edition 11g.
• Expertise in OBIEE complete life cycle; business requirement gathering, analysis, design, data modeling.
• Development of metadata repositories (Physical layer, BMM layer, & Presentation layer).
• Development including creation of connection pools, setting alias tables, BMM, applying business logic, dimensional hierarch modeling, time series modeling, aggregation, creating logical column, and calculation wizards.
• Able to identify facts, dimension, KPIs for different business models.
• BI answers - able to develop reports/dashboards in different subject areas with different analytical views (narrative, chart view, graphs, pivot table, column selector, view selector with drill down capacity).
• Performance tuning experience includes setting user log variables to diagnose performance issues, cache management, aggregation, event polling tables, usage tracking tables.
• Experience with Test Planning including System Integration Testing Units, User Acceptance Testing (UAT).
• 5 + years OBIEE implementation, which include building and configuring repository, creating and managing oracle Intelligent Dashboards, Oracle Answers, BI Delivers.
• Able to Configure security, create users and groups, assign permissions.
• 5+ years’ experience in a Multi-User Development Environment (MUDE), team player with excellent interpersonal skills, change management expertise.
• Self-driven and passionate performer with the yearn to learn new technologies and techniques.
• Experience with Report creation, repository development and configured metadata objects.
• An extrovert with strong command over spoken and written language.

TECHNICAL SKILLS:

Platform: Windows 2008/200.X Server, Linux RH6

Business Intelligence: Oracle Business Intelligence 11.1.1.9.1, 11.1.1.8.1 and 7.9.6.4, OBIEE11g &OBIEE 10g, BI Answers, Dashboards, DeliversETL: Oracle Data Integrator 11 and Informatica 9.1

Versioning Tools: PVCS Tracker, PVCS Versioning Manager

Databases: Oracle 11gR2/10g/9x/8i, DB2.

Design Model Tools: Oracle database designer, MS Office Enterprise and MS Visio UML.

Oracle software: Oracle Toad, Oracle Application Server, SQL Loader and Oracle SQL Plus.

PROFESSIONAL EXPERIENCE:

Confidential - Plano, Texas

OBIEE Developer

Responsibilities:

• Meet with my business representatives, business analysts and end users to understand the business models and functionality.
• Assist the other Informatica ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.
• Assist in building the Informatica ETL source to Target specification documents by understanding the business requirements.
• Tuned Informatica mappings and sessions for optimum performance.
• Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.
• Use Oracle to write SQL queries that create/alter/delete tables and to extract the necessary data.
• Build the Physical, Business Model and Mapping and Presentation Layer of the repository in the OBIEE Admin tool.
• Use BI answers to run queries, tests, and reports and validate the repository.
• Create dimension hierarchies and level based measures, built time and calculated measures of a fact table.
• Customize Data modeling of score cards using departmental metrics and KPIs in BI answers.
• Work on various reports /Dashboards in BI Answers with different analytics views (drill-down, dynamic, Narrative views, charts, pivot tables, column selector, and local filters
• Create groups in the repository and add users to the groups and grant privileges explicitly through group inheritance.
• Work extensively on performance tuning including creating aggregate tables, caching and event polling tables.
• Create iBots for job-critical levels and auditable differences delivered to dashboards, email and cell phones to assist process owners with timely decision making.
• Work in a Multi User Development(MUD) Environment check out repository, make changes, and complete the merge process .
• Test and modify OBIEE security for the internal controls environment.
• Enhance performance tuning using the SQL developer.

Confidential - Dallas, Texas

Business Analyst/OBIEE Developer

Responsibilities:

• Obtain business requirements from functional managers and users through interviews and operation observations.
• Customized the OBIEE Repository (Physical, BMM, and Presentation layers).
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Created dimensions, dimension hierarchies, log levels, level based measures and defined level, attributes level keys.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Build repositories from scratch, perform business modeling and mapping, create security profiles, create variables, send for testing, deploy to OBIEE Presentation Services
• Create drillable/guided navigation reports based on business requirements, create dashboards, ibots, prompts, and set permissions
• Create performance reports to be reviewed by executives for the worldwide firm, by management at local regional and set security to localized regions, as well as functional reports for the detailed financial team
• Test and modify OBIEE security for the internal controls environment
• Created customer faced documents using BI Publisher
• Took part in the preparation of Project plan, user acceptance testing.
• Helped manage risk analysis and mitigation plans, status reports, and client presentations; prepared business process models, defined milestone deliverables, and established critical success factors.
• Got a detailed understanding of business functionality and took the responsibility of preparing the Functionality Test Plan which was used by testing team while doing their testing process.
• Took part in the meetings with Sr. Business Analyst and managers and understood various process plans, business process, and functionality in detail.
• This helped me to prepare Integration Test Plan which was used by functional team as well as development team for doing a detailed testing on the business application.

Confidential - Euless, TX

Logistics Analyst

Responsibilities:

• Assisted the organization in various business operations.
• Used various research techniques and tools to find out market position which enabled the organization to widen their opening in new business ventures.
• Also involved in managing and maintaining inventory which required interaction with members of different department namely managers, suppliers, and vendors.
• Was responsible for producing various day today reports which was used by senior staffs in the organization using Microsoft Excel.
• Interfaced with internal customers to identify areas for systems improvement.
• Defined controls, conversion procedures, and systems implementation plans.