Obiee Sr Consultant Resume
Denver, CO
SUMMARY:
- 14years of Total IT experience.
- 10years of BI Solution Specialist possess and Architect in Business Intelligence Applications usingBigdata Hadoop,OBIEE/BI Apps and Tableau, SAP BO, Hypérion Essbase with Oracle EBS R12 source background.Played the key roles with OBIEE, OBIA, ODI,Informatica& MDM.
- Worked on all phases of DW/BI implementation lifecycle from conceptualization, requirement gathering, document Business requirements such as (Oracle standard MD - 50,MD-70 ), analysis, design, implementation, testing, Server Administration, maintenance and support.
- Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partner’s relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers.
- Business Stakeholders to understand the future initiatives and define scope, high level application architecture, system impacts
- Tremendous client interfacing experience and exposure to Pre-Sales activities including PoC, Project Costing, Proposal Making, RFP, RFI.
- Expertise in OBIA in Financial, HR, ProjectAnalytics, Procurement.
- OTBI - Manage and developed VOs (View Objects), used to create the report using RPD.
- Installation & Creating repository OBIEE 12c &11g administration Tool on Linux/windows.
- Experienced installing, configuring, administering and troubleshooting of Oracle Fusion Middleware products (OBIEE/BI Apps, BIPublisher, OAM, OIDetc.).
- Implemented Migration projects from SAP BO and Cognos BI and Micro strategy to OBIEE.
- Setting up the OBIEE environments in Linux, UNIX, windows with SSO setup.
- Installation,Configuration&Administration on ODI11g/12c environment with scheduling& monitoring.
- Experience Oracle EPM Hyperion Essbase installation, configuration and performance tuning.
- Experience using ETL tools such as Oracle Warehouse Builder (OWB) and Integrator (ODI).
- Experienced with Informatica ETL and CDC configuration Administration and train developers.
- Excellent Knowledge of Data Governance as a component of a MDM solution, and how to apply governance to a MDM program as a whole.
- Installation, configuration of Exalytics box, OBIEE on Exalytics with Times Ten in-memory DB.
- Extensively worked on the Remediation projects on the Oracle BI Apps Financial Analytics.
- Studied the Existing Oracle EBS source data table structure and data flow and worked on the Fit Gap Analysis to implement BI Apps Project.
- Develop and maintain project plans, including Work Breakdown Structures, timelines, resource plans, training plans and any other project related plans. knowledge in Oracle Utility Analytics only functionally and technical process to implement.
- Developing, Designing and supporting interactive Tableau Dashboard reports.
- Administration skills with Tableau Server Admin 9.0, Tableau Desktop, Tableau Online.
- Work directly with business units to define and prototype QlikView Applications
TECHNICAL SKILLS:
Oracle: Business Intelligence, BIApplications, BI Publisher
Middleware Products: Weblogic, Portal, serviceBus, SOA, webcenter, OAM, OID
Microsoft Business Intelligence Tools: SSAS, SSIS, SSRS
Microsoft Windows: Server, SQL Server, BIDS, SSMS, Data Tools,Dashboards, Scorecards, Report Builder, Power View, Tableau
Methodologies & Framework: Information Delivery, Data warehouse,Kimball, Data Science.
Technologies: Microsoft BI, OBIEE,OTBI,Tableau, IBM Neteza, QlikView, Business Objects
Emerging Technologies: Hadoop, Statistical R, In- memory Analytics, Cloud,Splunk Monitoring.
Industries: Manufacturing, Oil & Gas, Health Care, Retail, Manufacturing, Finance, Education / Publication
Database & ETL/ELT Tools: Informatica, ODI, Datastage,Oracle warehouse Builder.
WORK EXPERIENCE:
OBIEE Sr Consultant
Confidential, Denver, CO
Environment: OBIEE 12c, ODI 11g/12c,Discoverer, Database Oracle, flat files, Oracle EBS R 11/ R 12,Informatica 9.5, HCM, OTBI,Tableau, Windows,Linux
Responsibilities:
- Oracle Business Intelligence Cloud Service (BICS) implementation performed for client marketing department.
- Integrated with client data and Oracle's Marketing Cloud system. Complex Analytics architecture comprised of hybrid Cloud / On Premise components.
- Assist client with On Premise Data Warehouse design.
- Translates and converts user requirements into OBIEE 12c designs and packages for development.
- Building the data model for Fusion HCM cloud and BI cloud services.
- Extract data from HCM using OTBI to build BI reports.
- Implemented the ODI Knowledge modules with CDC and supporting the ODI batch jobs for daily schedules.
- Design Oracle BI 12c Publisher Data Models, Data sets and Templates which will be used by business.
- Design, develop, test and prepare detailed specification of new requirements and support all technicalissues related to OBIP in Production environments
- Leads BI application change control management by performing Impact Analysis to drive changes
- Leads development and performance improvements of complex reports and debugs long running reports.
OBIEE/ODI & TableauLead Specialist
Confidential, Waltham, MA
Environment: OBIEE 12c,ODI 11g/12c Essbase 11g/12c Database Oracle, flat files. PeopleSoft HCM,Oracle EBS R 11/ R 12,Informatica 9.5, OTBI,Tableau, Windows,Linux
Responsibilities:
- Oracle Business Intelligence Cloud Service (BICS) implementation performed for client marketing department.
- Integrated with client data and Oracle's Marketing Cloud system. Complex Analytics architecture comprised of hybrid Cloud / On Premise components.
- Assist client with On Premise Data Warehouse design.
- Managing of 2 TB improved ETL data performance load.
- OBIEE reports improved user performance using SQL Explain Plan parallelism.
- Speeded up the BI reports execution to 1-2 secs used AWR report SQL ID Advisor statistics
- Improved the ETL hanging session with tuning the SQL query using the trace file logs.
- Improved the CPU performance utilization tuning BI server and validating SQL queries.
- Depending of the quality or latency of client connections increase it to avoid overloads at peak time.
- Consulted on Tableau server performance enhancements; upgrades from version 9.3 to 10.1 and server.
- Built the DW environment using the Tableau and Hadoop Hive tables with Terabytes of data.
- Administer and support tableau Infrastructure including Upgrades, testing, Security Administration, License Management, troubleshoot workbooks, Performance Monitoring and System maintenance.
- Performed report optimization and administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.
- Experience with creation of users, groups from AD level.
- Experience creating projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
- Scheduled the dashboard for a regular cycle Daily,weekly,monthly using the Tableau data extract incremental refresh.
- Design a Data Source or Extract Layer to reusable in Tableau.
- Coordinating across multiple business groups to setup support and user meeting.
- Document best practices for Development and administration of the tableau Platform.
- Maintaining Security and Create/manage users, Groups, Licenses and integrate with Active Directory.
- SSO setup with SAML, Kerberos and local Authentication and Capacity Planning across environment.