We provide IT Staff Augmentation Services!

Bi Architect Resume

CA

SUMMARY

  • Senior IT professional with over Ten years of experience in Business Intelligence, OBIEE(11.1.1.7), OBIA(7.9.6.4), OBIA ( 11.1.1.7.1 ), Data warehousing, Informatica, ODI, WebLogic, ODI(10g/11g), DAC, implementation and support of Oracle Databases 7x - 12c and Oracle E-Business Suite R 12, 11i and 11.0.3
  • Extensive experience in gathering requirements, documentation, analysis, design and development in an enterprise warehouse environment
  • Technical competence in implementation of RPD and reports using OBIEE ( 10g/11g/12c ) /Siebel Analytics/ BI Publisher
  • Enabled key design decisions by performing proof of concepts to explore several out of the box OBIEE 11g features and explored ease of customizations to meet the requirements
  • Expertise with slider charts, KPI’s, collapsible hierarchies and scorecards
  • In-depth knowledge of the overall architecture of OBIEE (10g/11g/12c)
  • In-depth knowledge of data modeling using star schema and snow flake schema
  • Experience and knowledge in setting up Clustering, Load Sharing/Balance Multiuser Development (MUD), Security and Repository Management.
  • Experience in installing and configuring Data Warehouse Administration
  • Console (DAC), Web Logic Server and OBIA 7.9.6.3/OBIEE 11.1.1.6.5/ Informatica 9.0.1 interface with oracle ERP R12, PeopleSoft and Sales Force.
  • Hands on experience Oracle Data Integrator(ODI 11.1.1.7)
  • Experience in configuring and generate Load Plans using BI Application Configuration Manager (BIACM).
  • Migrated OBIEE 11g Version 11.1.1.7.0 to 11.1.1.7.1
  • Migrated Informatica 8.6 to 9.0.1 on Linux and Windows.
  • Extensive expertise using Informatica, Web Logic Server, ODI and other ETL technologies in an Enterprise Warehouse environment
  • Performed in various capacities including technical architect, techno-functional lead, technical lead, and technical consultant.
  • Experienced in leading on-site and offshore development teams and provides the team with functional and technical expertise
  • Knowledge of Tableau Reporting tool.
  • Develop and execute activities related to end-to-end project management
  • Very much involved in project plans and estimates, scoping and requirements

TECHNICAL EXPERTISE

Data Warehouse: Oracle Data Integrator(10g/11g), Informatica(9.0.1) and DAC

Business Intelligence: Oracle Business Intelligence Enterprise Edition (10g/11g) and OBIA (7.9.6.3)

Oracle Applications: E-Business Suite R12, 11i, 11.0.3, and 10.7SC

Software Tools and Programming Languages: PL/SQL, Oracle Developer (Forms and Reports builder), Oracle Discoverer, Oracle Workflow, SQL*Loader, SQL*Plus, ADI, OEM, Shell Programming, ODI - Oracle Data Integrator, OBIEE and Informatica.

Databases: Oracle 7.x / 8i / 9i / 10g/ 11g/12c

Operating Systems: Windows, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential, CA

BI Architect

Responsibilities:

  • Major changes made to Prebuild Repository (.RPD) physical, logical and presentation sections as required by business - replaced legacy source system with E-Business Suite R12.
  • Created new database schema objects for new enterprise warehouse with HR and Sales Bookings.
  • Documented all changes to EDW for removal of legacy systems with E-Business Suite R12.
  • Migration of RPD and Catalog from Develop to QA and UAT instances.
  • Modified reports using XML editor to accommodate new presentation layer.
Confidential, Virginia VA

BI Architect

Responsibilities:

  • My primary responsibilities BI design and lead offshore ETL technical team.
  • Project implementing by Accenture in OBIA ( 11.1.1.7.1 ) with using PeopleSoft Source System.
  • Collected requirements as per business needs and Prepared Techno Functional documentation and implementing custom mappings per business requirement.
  • Worked on new ELT mappings and customizations existing ELT Mappings in ODI
  • Hands on experience of ODI 11.1.1.7.1
  • Designed Data Model and Build Custom Fact and Dimension tables for HR, AR Deposits and Payments of VDOT
  • Customized Time and Labor, Accruals - Extended Absence, Headcount Gain & Loss HR Analytics Subject Areas.
  • Very much involved in project plans and estimates, scoping and requirements .

­

Confidential, WA

BI Architect

Responsibilities:

  • My primary responsibilities are modifications existing ETL Mappings, DAC in OBIA 7.9.6.4 with OBIEE 11g and DAC11g.
  • Also involved in develop and execute activities related to end-to-end project management.
  • Did customizations to about 100 Informatica ETL Mappings, developed about 40 incremental and Deletion mappings.
  • Above new Mappings/Tasks are added in new Subject Areas in DAC and modified logical folders for customized Mappings/Tasks.
  • Installed OBIA in windows and Linux Servers.
  • Changes made to Prebuild Repository (.RPD) physical, logical and presentation sections to add above customization.
  • Migrated Informatica 8.6 to 9.0.1 (part of OBIA 7.9.6.4)
  • Migration of ETL and DAC code from Develop to QA and UAT instances
  • Migrated OBIEE 11g Version 11.1.1.7.0 to 11.1.1.7.1 on Development and Prod Windows Server as a separate project.
  • Part of Security, created Application Roles, Applications Profiles, added Data and Object level securities using Enterprise Manager/WebLogic and BI Admin tool.
Confidential, CA

OBIA Consultant / BI Architect

Responsibilities:

  • This project (BI Apps 7.9.6.3) is implementing by a local private company.
  • My primary responsibilities are modifications and enhancements to existing RPD, ETL Mappings, DAC, Analyses and Dashboards.
  • Did customization of Informatica ETL Mappings and DAC.
  • Changes made to Prebuild Repository(.RPD) physical, logical and presentation sections
  • Added Fiscal Calendar Dimension to Sales Booking Lines Fact
  • Migration of RPD and Catalog from Develop to QA and UAT instances.
  • Security: Data and Object Level - Added new users, groups in WebLogic server.

Created new Application Roles in EM and added new Catalog Groups

Confidential, CA

OBIA Sr. Developer / BI Architect

Responsibilities:

  • This project (BI Apps 7.9.6.3) is implementing by Oracle Corporation.
  • New requirements gathering from users and provide Analysis and Design documents by track. Documents should be approved by Change Control Board before development.
  • My primary responsibilities are modifications and enhancements to existing Analyses and Dashboards.
  • Adding new DFF’s and KFF’s to existing prebuild analytics belongs to Accounts Payables, Accounts Receivables and Projects to Invoice (P2I), Enterprise Asset Maintenance (EAM) and HR Analytics.
  • Configuration changes to prebuild Group Account Names/Number thru flat files using ETL
  • Changes made to Prebuild Repository(.RPD) physical, logical and presentation sections
  • Migration of RPD and Catalog from Develop to Testing and Production instances.
Confidential, NH

BI Architect

Responsibilities:

  • This is short term comprehensive project handled independently start to finish.
  • Reviewed all existing Financial Reports (Budget, Revenue, Expenditure and Projects) build in Cognos with backend Informix database.
  • Installed OBIEE 11g (11.1.1.6.0 ) in Windows Server and applied 11.1.1.6.5 patch.
  • Web Logic server installed and configured, Users and Group created using web logic security.
  • Created Application Roles, Applications Profiles using Enterprise Manager.
  • Designed and Developed Physical, BMM and Presentation layers of brand new Metadata repository (.RPD)
  • Authored the Techno-functional specifications document for City team approval
  • Designed the overall Finance dashboard and developed alone without anyone’s help
  • Developed number analyses using Pivot, Graphs, Column and View selector
  • Implemented data and object level securities
  • Configured LDAP authentication for 50 users and groups using Application Roles
  • Used extensively SQL, PL/SQL to get OBIEE Analyses performance improvement
  • Created Views and Materialized Views in Oracle Database connecting to Informix.
Confidential, Chelmsford, MA

BI Architect

Responsibilities:

  • Involved in requirement gathering to understand the business problem areas
  • Key participant in evaluating / reviewing the BRD from an IT perspective
  • Authored the Techno-functional specifications document for stake holder approval
  • Co - architected the overall data and reporting solution
  • Participated in the LDM and PDM sessions in the capacity of an IT lead to facilitate the IT solution for the necessary business problems
  • Spearheaded the BI team responsible for the delivery of the analytic solution provisioning using OBIEE 11g
  • Co-designed the overall dashboard design and solution for the Order management dashboard
  • Provided solutions in user and data level security implementation
  • Developed Metadata repository (.rpd), configured metadata the Business Model Layer & Physical Data Model as per the reporting requirements using OBIEE Admin and Web tool
  • Explored and developed reports using BI Publisher for executive reporting
Confidential, Milford, MA

Sr. BI Consultant

Responsibilities:

  • Successfully upgraded the OBIEE 10g application to OBIEE 11g (11.1.5)
  • Responsible for the end to end installation and configuration of Oracle 11g
  • Worked with Oracle support to resolve several product version related issues.
  • Recommended and modified the data model to overcome the technical challenges due the changes in 11g architecture
  • Solved several upgrade related issues in both RPD and reports
  • Involved in upgrading BI publisher reports
  • Interacted with server administration, QA, development teams for the resolving several critical upgrade related issues
Confidential, Sunnyvale, CA

BI Tech Lead

Responsibilities:

  • Developed Metadata repository (.rpd), configured metadata the Business Model
  • Layer & Physical Data Model as per the reporting requirements using OBIEE Admin and Web tool.
  • Configured Clustering, Load Balance and Multiuser Development (MUD).
  • Worked on Oracle BI Answers to build Interactive Dashboards with drill-down capabilities.
  • Mapped the configurations to accommodate for the territorial hierarchy that were accommodated via chart drilldowns
  • Assisted in creation of pivot table request allowing manager to analyze the business from different perspectives provided optimized Analytics request using column selector.
  • Administered security and created alerts.
  • Created templates for presenting results and Analytics and modified the OBIEE Dashboard using cascading style sheets.
  • Involved in Reconciliation Process while testing loaded data with user reports.
  • Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
  • Working with Offshore and Onsite ETL Teams. Gather Production requirements/changes from onsite and share and executing with offshore team.
Confidential, Chelmsford, MA

Sr. BI Consultant

Responsibilities:

  • Analyze Design, and Develop OBIEE Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
  • Created Star Schema, Time Series Objects, Hierarchies, Level Based Measures, and Security using External Table Authentication, Session Variables, and Initialization Blocks.
  • Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters. Extensively used Delivers, iBots and BI Publisher
  • Developed many complex Initial/Incremental Informatica Objects (Workflows / Sessions, Mappings/ Mapplets with various transformations i.e., expressions, aggregators, filters, lookup, stored procedures transformations, join, normalize, filter, router, sorter and update strategy).
  • Performed Unit, Integration, and Regression testing to validate report and mapping functionality.
  • Customized Dashboards, Administered permissions and privileges for Dashboard visibility and modifications to users.
  • Implemented the delivery of iBots using Siebel Delivers to alert the associated teams.
  • Performed Unit testing, Integration testing, and Regression testing to validate report and mapping functionality.
  • Responsible for Functional Design Document.
  • Interact with Users during User Acceptance Testing (UAT).
  • Manages detail design efforts based on agreed requirements/scope.
  • Closely adheres and works towards milestones on development.
  • Develop the repositories keeping in view best practices/methods from vendor.
  • Responsible for deliverables needed for vendor review and/or any internal technical reviews.
  • Help testing team with test scripts, defects resolution, etc.
Confidential, Petaluma, CA

Sr BI Consultant

Responsibilities:

  • Gathered business & functional requirements and translated them into technical requirements
  • Responsible for overall Datamart architecture, Business models and Reporting needs.
  • Designed staging areas for multiple sources of data from Oracle Applications 11i, Agile Flat Files and external Customer enterprise systems.
  • Installed and configured Oracle Data Integrator 10g with Master and Work Repository.
  • Developed more than hundred ETL Interface using ODI.
  • Used extensively Oracle SQL and PL/SQL in Oracle Data Integrator (ODI)
  • Used Oracle and Text file Knowledge modules in ODI Interfaces.
  • Used Full and Incremental interfaces in ODI.
  • Created and configured ODI scheduler Agent for Scheduling process.
  • Used extensively ODI variables for Input file names.
  • Interface Error handling and automated notifications.
  • Installed and configured Oracle Business Intelligence (OBIEE 10.1.3.4) software.
  • Created and configured Repositories (RPD) using the Oracle Business Intelligence Administration Tool.
  • Developed number of Reports, Dashboards using Answers per Business Requirement.
  • Developed Supply Chain, BOM, Inventory and Procurement dashboards and Answers.
Confidential, Campbell, CA

BI Consultant

Responsibilities:

  • Installed and configured Oracle Data Integrator, Oracle Business Intelligence (OBIEE) software.
  • Designed staging areas for multiple sources of data from Oracle Applications R12 and external Forecast system.
  • Developed ETL Interface using ODI.
  • Used Oracle SQL and PL/SQL in Oracle Data Integrator (ODI)
  • Used Oracle and Text file Knowledge modules in ODI Interfaces.
  • Developed Full and Incremental ETL interfaces in ODI.
  • Configured ODI scheduler Agent for Scheduling.
  • Used extensively ODI variables for Input file names.
  • Built ETL interfaces to transfer data from Source to Targets, mappings, error handling and automation.
  • Participated in design, development, testing and implementation of the data warehouse applications.
  • Extensive ETL development experience and Informatics ETL tool utilization.
  • Ensured completeness and compatibility of the technical infrastructure to support system performance, availability and architecture requirements.
  • Collaborated with business users and development team to design, develop and implement data warehousing projects.
  • Developed number of Reports, Dashboards using Answers per Business Requirement
  • Developed Sales, Forecast and Inventory dashboards and Answers.

Confidential, Los Altos, CA

BI Consultant

Responsibilities:

  • Created technical design documents BI Projects
  • Developed RPD’s in Siebel Analytics/OBIEE for Manufacturing and Sales Projects
  • Developed, modified, maintained and supported dashboards, reports in OBIEE
  • Installed and configured Oracle Data Integrator/Sunopsis, Oracle Business Intelligence (OBIEE) software.
  • Developed ETL Interface using ODI/Sunopsis.
  • Used Oracle SQL and PL/SQL in Oracle Data Integrator (ODI)
  • Used Oracle and Text file Knowledge modules in ODI Interfaces.
  • Developed Full and Incremental ETL interfaces in ODI.
  • Implemented the security architecture of Siebel Analytics/OBIEE Role/Access based user management Reports / Dashboards
  • Managing Project teams to customize ERP Applications, New Applications Design & Development in Java.

Hire Now