We provide IT Staff Augmentation Services!

Bi Solutions Architect Consultant Resume

4.00/5 (Submit Your Rating)

Miami, FL

SUMMARY:

  • I have successfully completed multiple BI projects. Been involved in Analysis, Designing, build conforming Dimensional Data Models, developed ETLs, done Data Quality and Cleansing for various data marts related to Finance, Marketing, CRM, Supply Chain, HR, Manufacturing to name a few.
  • In depth experience in requirements gathering, existing system study, gap Analysis, documenting functional & technical specifications, mapping data from different sources to DW and OBIEE repository, Proto typing and POC methodologies.
  • Extensive experience with different BI technologies like OBIEE, Answers, Dashboards, iBots, Agents, Publisher, Tableau, Hyperion System 11, Brio, Hyperion Interactive reporting, Hyperion Dash Boards, Oracle Warehouse Builder 11g, Informatica 9.1,9.0.1,8.6, SSIS, SSRS, ER Studio, ERWin for Data Modeling.
  • Implemented, configured and administered ETL pipelines using Informatica, Oracle Data Integrator (ODI) and DAC
  • Data warehouse, data mart and SQL performance tuning.
  • Data sources for some of the key projects were Oracle Apps 12/11, SAP R3, Salesforce.com, Siebel CRM OD, RightNow (CRM). Interfaced with more than 100 partners, vendor sites and internal systems for ETL.
  • Lead multiple offshore and onsite development teams and mentored development staff.
  • Extensive experience with Prebuilt OBI Applications 7.9.6.4, 7.9.6.3, specially Finance, HR, Projects, Procurement and Spend, Supply Chain and Order Management Analytics.
  • Well versed with tables related to Oracle Order Management, GL, Payables and Receivables of Oracle Apps 12,11i.
  • Strong analytical problem solving, interpersonal communication, presentation and user interaction skills.

WORK EXPERIENCE:

BI Solutions Architect consultant

Confidential, Miami FL

Responsibilities:

  • Installation and configuration of OBIEE 11g, Informatica 9.1, DAC
  • Configuration, setup, testing of OOTB modules
  • Conversion and redesigning of existing data marts for better performance.
  • Customization of OOTB dashboards, reports like Balance sheet, P&L Statements, Budgets vs Actuals
  • SmartView implementation and user training.
  • OBIEE object and data level security implementation.
  • Providing technical solutions, setting guidelines and standards for development teams
  • Conduct proto typing, proof of concept sessions and get project sign off from business owners
  • Setting up of ODI 11g, conversion of Informatica code to ODI

Environment: OBI - Prebuilt 7.9.6.4, OBIEE 11.1.7.1, Oracle 11g, EBS 12, DAC, Informatica Power center 9.1, ODI 11g, Linux

OBIEE Consultant with Oracle Consulting

Confidential, Financial, HR

Responsibilities:

  • Gap analysis, implement OOTB pre-built, installation and configuration of OBIEE 11g, Informatica 9.1, DAC, Supply Chain module prebuilt configuration.
  • Customization for custom flex fields, user defined fields and DFFs.
  • Providing technical solutions, setting guidelines and standards for development teams
  • OBIEE object and data level security implementation.
  • Conduct proto typing, proof of concept sessions and get project sign off from business owners

Environment: OBI-Prebuilt 7.9.6.3, OBIEE 11.6.5, Oracle 11g, Oracle Apps 11i, DAC, Informatica Power center 9.1, Linux

OBIEE Architect Consultant

Confidential

Responsibilities:

  • Interact with project sponsors, stake holders and business users to gather requirements.
  • Create custom dashboards for helpdesk system and Agile
  • Providing technical solutions, setting guidelines and standards for development teams
  • Monitor and administer ETL pipelines.
  • OBIEE object and data level security implementation.
  • Conduct proto typing, proof of concept sessions and get project sign off from business owners

Environment: PLM BI OOTB, OBIEE 11g, ODI, Pentaho, ETL Manager, Linux, Oracle.

We'd love your feedback!