SUMMARY:

• Self - motivated and highly accomplished I.T Professional with broad knowledge spectrum in Systems Design and Development; implementing and integrating cost-effective, results oriented solutions in parallel with the business requirements.
• Outstanding verbal and written communication skills. Able to adapt, stay flexible, multitask and change priorities to meet the business needs.
• 10+ years of experience in the I.T industry and 5+ years experience in Oracle Business Intelligence Enterprise Edition (OBIEE 10G/11G), Oracle 11g, Oracle Business Intelligence Applications (7.9.6.4/11g), Informatica 9.5, Oracle Data Integrator (11g/12c) and Data Warehousing.
• Champion of strategic planning, Project Management, implementing best practice methodologies and consistent improving of delivery times and service levels.
• Worked extensively on OBIEE/Siebel Analytics Administration Tool involving all 3 layers; The Physical Layer, BMM Layer and the Presentation Layer.
• Highly experienced in OBIEE security model implementation and OBIEE Environment Administration (MUD creation, configuration and support).
• Skilled in implementing Oracle BI Security Setup (data access/query privileges, users and groups), Metadata Objects (Subject Area, Tables and Columns) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Experienced in Business Model development and various functionalities like Dimension Hierarchies, Measures, Aggregation Rules, Time Series and other functions.
• Advance understanding and application of Data modeling (Dimensional and Relational) concepts like Star-Schema modeling, Snowflakes modeling, Fact and Dimensional modeling of data.
• Extensive knowledge in building interactive Dashboards with drill-down/up and drill-across capabilities using global and local Filters. Business Rules with User identity and Roles, Profiles and Personalization.
• Extremely organized and proactive in translating high-level business requirements into logical business dimensional models, building business models, configuring metadata, Answers/Analytics, Delivers/iBots, creating Reports / Dashboards, Cache monitor.
• Advanced ELT (ETL) knowledge with ODI Studio’s declarative design and working with all four Navigators (Topology, Designer, Operator and Security) .
• Adept at writing and debugging SQL queries, Optimizing and Performance tuning of OBI Dashboards / Reports to improve overall performance.
• Excellent with Caching and Mapping, data-level and object-level security, MUD implementation and configuration of Variables / Initialization Blocks.
• Extremely quick at learning new concepts, skills and methodologies.

TECHNICAL SKILLS:

Applications / Modules: OBIEE 10g/11g, BI Publisher 10g/11g, OBIA 11g, ODI, Informatica, DAC

Operating Systems: MS Windows, UNIX

Software: Microsoft Office Suite, XML, WebServices

Language: SQL,HTML, XML

Database / Tools: Oracle 11g/12c, Oracle SQL Developer, Oracle SQL Plus, Toad

Methodologies: Oracle AIM, PMP, SDLCInformatica Power Center Oracle Data Integrator

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas

OBIEE Developer

Responsibilities:

• Worked closed with business executives, analysts and users to gather business requirements and from that developed a project scope and model available OLAP data to meet reporting objectives.
• Participated in the design and implementation of the metadata and reporting end of the solution; including testing and deployment of the components.
• Build the RPD with three layers in the BI tool to model the data, namely: the Physical Layer, BMM layer and the Presentation layer.
• Imported metadata from the data warehouse (OLAP) into the repository and defined the primary keys to Dimension tables.
• Designed data models using star schemas architecture for increased performance and decrease report query time.
• Designed logical dimensional hierarchies; Level-Based and Parent-Child hierarchies in the BMM layer for drill down or drill up request.
• Maintained company standards in architecture development and naming conventions while modeling the data.
• Configure user security in BI Tools to execute direct database request (DDR) for select report provisioning in BI Analytics / Answers.
• Designed hierarchy architecture in the BMM layer with logical joins and keys required to support drill-down request.
• Created visually stunning custom Dashboards with views using graphs and pivot tables in OBIEE Answers/Analytics to enhance report analysis.

Confidential, Fairfield, New Jersey

OBIEE Developer/Consultant

Responsibilities:

• Worked closely with business analysts to comprehend the requirements and systematically translated them into data models and implemented periodic check-in meetings to present and reconfirm project scope.
• Performed work on the security settings in the BI Administration Tool to setup users and group access privileges.
• Utilizing the BI Admin Tool, build the Physical Layer, BMM Layer and the Presentation Layer of the repository.
• Created Aliases to Schema tables used in the project for trace-back, troubleshooting and organizational purpose.
• Designed Star Schemas and assign joins in the Physical Layer of the Repository to meet the business requirements.
• Added multiple sources to logical tables in the BMM layer.
• Worked on creating repository variable and session variables.
• Created measured columns in the BMM layer with time series function.
• Designed, configured and implemented Usage Tracking for select users.
• Organized and customized the Presentation Layer in a format that is easy for the end users to navigate through.
• Designed and developed interactive Dashboards per business requirements using various reporting features and functionalities such as; formulas, filters, charts, pivot tables.

Confidential, Dallas, Texas

OBIEE Developer

Responsibilities:

• Worked with business executives, analysts to gather requirements and tailor project to fit and meet business objectives.
• Installed and configured OBIEE 11G including all the web components (Enterprise Manager, Analytics, Console, and Publisher).
• Created the repository in BI Tool with complete Physical, Business and Presentation layers.
• Created repository account and user groups for new users.
• Migrated Repositories and Web Catalog from local to production servers.
• Modified repository account and user groups for existing users.
• Designed interactive Dashboard and created dashboard prompts with multiple selection.
• Involved in performance turning of reports by identifying the indexes required on the backend tables and also from the data available in the cache.
• Integrated reports created in Oracle BI Publisher with Oracle Business Intelligence Enterprise Edition.
• Translated the reports request to the Excel Worksheets and applied Excel specific data formatting to Gauge Views and Funnel Views to the charts and pivot tables.

Confidential

Systems Analyst

Responsibilities:

• Reconfigure franchise store database and model reports to reflect business needs and changes.
• Develop step by step process for franchise stores to implement system backup and recovery.
• Remotely access client servers to diagnose and resolve system issues.
• Developed and technically wrote installation procedures for new hardware and software.
• Maintained a knowledgebase for system issues and resolve.
• Mitigated system downtime by proactively scheduling maintenance during off business hours.