We provide IT Staff Augmentation Services!

Bi Solutions Architect Resume

SUMMARY

  • Dedicated IT professional with 10+ years of progressive expertise in design, configuration, development, testing and implementation of Data warehousing and Business Intelligence Applications (specific expertise in OBIEE/OBIA).
  • Deep understanding of Information Technology Software Development Life Cycle (SDLC) methodology and project management principles.
  • Strong experience in developing OBIEE/OBIA Repository (.rpd) - three layers (Physical Layer, Business Model & Presentation Layer) .
  • Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables and Physical and Logical data modeling in the OBI Administration tool.
  • Knowledge in Data warehousing development using ETL tools such as Informatica Power Center, Data Stage and ODI- developed Informatica Mappings and Workflows with Worklets & Tasks using various Transformations for ETL of data from Multiple Sources to Data Warehouse.

TECHNICAL SKILLS

Application Package: OBIEE 10/11g, OBIA 7.9.6.4 and 11g,Informatica Power center,Data Stage, DAC, Answers and Dashboards,BI Publisher,EPM

Databases / DB Tools: Oracle

Desktop Tools: Microsoft Office, Microsoft Project Manager

Operating Systems: Windows, Unix, Linux

PROFESSIONAL EXPERIENCE

Confidential

BI Solutions Architect

Responsibilities:

  • Assist the client to meet consolidated R11 and R12 business requirements after source system upgrade
  • Perform gap analysis as related to ETL processes that populate reporting and analytics and develop documentation on required extensions to the OBIA solution - to adjust ETL code to meet the current and future Target DW.
  • Work closely with client’s BI team to estimate levels of effort for platform changes and work with the business community to set priorities.
  • Identified the impacted mappings / mapplets in the OOTB as well as Custom to determine: complexity of the impact on the mapplet / mapping,Source or target instance changes,Source qualifier query impact
  • Customization of ETL code - Re-apply customizations to the R12 adapter ETL Code, Apply changes to R11 adapter code.
  • Design Unit Testing Plan and coordinate Testing activites.
  • DAC setup,refresh of source system container, built new subject areas and execution plans
  • Designed and participated in data validation to verify accuracy of the newly loaded OBAW
  • Amend reports and dashboards to use the new data - Assessment of current Dashboard Reports is required
  • Environment: OBIEE 11.1.1.7, EBS 11, R12,Informatica Power Center 9, OBIA 7.9.6.4 and DAC, Oracle 11g, Discover, SQL Developer, SQL*Plus, Windows-XP

Confidential

Sr. ERP Consultant

Responsibilities:

  • Design and Develop OBIEE Reports and Dashboards
  • Design and Develop OBIEE Metadata/Logical Data Models(RPD)
  • System Administration of OBIEE Platform
  • Identify what tables/fields from EPM (Peoplesoft Financials and HRMS)that need to be added to the OBIEE subject areas
  • Translate BI requirements into analytic BI subject areas
  • Work with customers and business analysts to understand and develop reporting and BI requirements.
  • Technical Support for OBIEE environments including production control activities. This includes point release upgrades and Software installs and upgrades.
  • Assist in monitoring scheduled jobs and Data currency reconciliations.
  • Perform high level initial analysis and design choices for BI solution(s), including user interface design
  • OBIEE RPD modeling and best practices
  • Details best practice guidelines and works with the development team to ensure compliance
  • Work on reporting solutions.
  • Implementing solutions that align with the defined client’s technology standards.
  • Documenting processes, projects, tools, standards and techniques.
  • Advice the client on implementation matters regarding OBIEE (11g) and ETL TOOL (Data stage).

Environment: OBIEE 11.1.1.6, PeopleSoft EPM (Financials and HCM), IBM Data stage, Oracle 11g, Hyperion, SQL Developer, SQL*Plus, Windows-XP

Confidential

Sr. ERP PRODUCT SPECIALIST

Responsibilities:

  • Responsible for BI inputs to project gating process
  • Perform high level initial analysis and design choices for BI solution(s), including user interface design
  • OBIEE RPD modeling and best practices
  • Details best practice guidelines and works with the development team to ensure compliance
  • Work on reporting solutions.
  • Implementing solutions that align with the defined client’s technology standards.
  • Documenting processes, projects, tools, standards and techniques.
  • Environment: OBIEE 11.1.1.5, (EBS 11i Financials, Supply chain, HR and Sales Analytics), Informatica and DAC, Oracle 11g, SQL Developer, SQL*Plus, Windows-XP

Confidential

Senior OBIEE Consultant

Responsibilities:

  • As an OBIEE Lead was involved in translating functional requirements into technical requirements.
  • Assisted in building detailed project schedule.
  • Interacted with Procurement and Operation / Maintenance business representatives for gathering the OBIEE Reports / Dashboards requirements and to define business and functional specifications
  • Analyzed and used various data sources - Oracle, Excel, and Web Services, Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling
  • Customized and developed RPD (Physical, BMM and Presentation Layer), configured metadata objects and Web Catalog Objects.
  • Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web.
  • Performed Unit, Integration, and Regression testing to validate report and mapping functionality.
  • Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Siebel Analytics Repository.

Environment: OBIEE, Informatica Power Center 8.1.1, Oracle 9i/10g

Hire Now