We provide IT Staff Augmentation Services!

Bi - Obiee Architect Resume

SUMMARY:

Confidential has more than 18 years of experience in analysis, implementation, development, architecture, and project management in Data Warehouse/Data Mart lifecycle. For the past 12 years’ experience, has been exclusively in Siebel Analytics, OBIEE, Oracle BICS, Tableau, Informatica 7.x, 8.x, and 9x, Oracle Data Integrator (ODI) and DAC used for business needs and developing business cases for data warehouse architecture expansions/customizations. He has acquired over the years a comprehensive understanding of database design and methodology from multiple perspectives (user, designer, and developer) and has hands - on experience in designing, developing, and implementing Extraction, Transformation, and Load (ETL/E-LT) techniques on multiple database platforms and operating system environments using today's cutting-edge technology. Confidential has supported Oracle Business Intelligence (BI) applications including Oracle Customer Relationship Management Analytics, Oracle Financial Analytics, Oracle Human Resources Analytics, Oracle Supply Chain and Order Management Analytics, Oracle Manufacturing Analytics and Oracle Procurement and Spend Analytics .

TECHNICAL SKILLS:

Business Intelligence Tools: Tableau, Oracle BICS, OBIEE, OBIA, COGNOS, and Business Objects

Oracle BI Apps: Oracle CRM Analytics, Oracle Financial Analytics, Oracle HCM, Oracle Supply Chain and Order Management Analytics, Oracle Project Analytics and Oracle Procurement and Spend Analytics

ETL Tools: ODI, Informatica

Oracle ERP: EBS, PeopleSoft

Programming languages: SQL, PL/SQL, UNIX

Database: Oracle 11g & 12c, SQL Server, DB2/400, Informix 7.2

Operating Systems: Windows 95, 98, NT & 2008/2012, UNIX, HP-UX 10.20

Project Management Tools: MS Visio, MS Project, MS PowerPoint

Methodology: Agile - Scrum and Sprint

WORK EXPERIENCE:

Confidential

BI - OBIEE Architect

Environment: Windows 2012, LINUX, Oracle 12c, PeopleSoft 9.2, OBIA (11.1.1.9.2 ), OBIEE 12c, ODI 11gBI Connector, Tableau 10.4

Responsibilities:

  • Responsible for interaction with business stake holders, gathering requirements and managing the delivery
  • Participated in translating business needs into Business Intelligence reporting solutions by ensuring the right selection of Tableau Visualization tool for financial team
  • Introduced Oracle Best practices for ODI and OBIEE customization
  • Introduced Country-Specific Calendar model for global implementation
  • Implemented custom look and feel template using share folder
  • Converted RPD into xml for major customization than reverted to RPD format
  • Using BI Connector to establish OBIEE metadata and Tableau to accomplish visualization
  • Helping team members for creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data
  • Connected Tableau server to publish dashboard to a central location for portal integration.
  • Standardized migration documents for ODI objects, OBIEE rpd & webcat for smooth administration

Confidential

BI Project Lead

Environment: Windows 2012, Oracle 12c, Tableau 10

Responsibilities:

  • Perform data/systems analysis to determine best BI Visualization tool using Tableau
  • Score Card: P& L Metric Trend Analysis, Bill Rate vs Cost Rate Analysis, Utilization Trend Analysis, and Backlog Trend by Month
  • Integrated disparate data from different data sources to Tableau Desktop for report and dashboard development
  • Created Schedules and Extracted data into Tableau Data Engine
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality

OBIEE/OBIA Architect

Confidential

Environment: Windows 2012, LINUX, Oracle 12c, PeopleSoft 9.2, OBIA (11.1.1.9.2 ), OBIEE 11g, ODI 11g, Oracle BICS

Responsibilities:

  • Liaise with business subject matter experts in analysing business requirements (Productivity related - KPIs), understand the various data sources.
  • Develop strategies for use in high volumes of data like AP, GL.
  • Design and develop the technical/functional specification for E-LT development and implement using ODI 11g.
  • Managed versions, including software code, documents, design models
  • Led the OBIA development work for all customizations includes both ODI and RPD design and development
  • Oracle Business Intelligence Cloud Service (BICS), Data Visualization

OBIEE/OBIA Lead

Confidential

Environment: Windows 2012, LINUX, Oracle 12c, EBS 12.x, OBIA (11.1.1.7.1 ), OBIEE 11g, ODI 11g

Responsibilities:

  • Understanding case studies and work closely with business users based on Agile scrum and sprint methodolgy
  • Led the OBIA development work for AP Transaction Type customization to get invoice type and invoice distribution type in single record into custom tables
  • Update AP Transaction fact using X PAY DIST TYPE ID/WID based on custom AP Transaction Type dimension
  • PO Blanket customization, this included both ODI and RPD design and development

OBIEE/OBIA Architect

Confidential

Environment: Windows 2012, LINUX, Oracle 12c, PeopleSoft 9.2, OBIA (11.1.1.7.1 ), OBIEE 11g, ODI 11g

Responsibilities:

  • Perform requirements analysis: Interact with business analysts to get functional requirements, interact with end users to determine reporting needs, and conduct discussions with the project team to identify additional requirements.
  • Led the OBIA HCM Analytics BIACM and PeopleSoft Tree Structure configuration
  • Configured the BISQLGroupProvider in the Fusion Middleware environment in order to leverage a SQ-based table authorization system with a LDAP identity provider configured in WebLogic Server.
  • Customize Oracle Data Interface (ODI) mappings based on client needs and implemented scheduling, security and email
  • Customize OBIEE RPD based on ODI customization and client needs

OBIEE SolutionSpecialist

Confidential

Environment: Windows 2012, LINUX, Oracle 12c, PeopleSoft 9.2, OBIEE 11g, ODI 11g

Responsibilities:

  • Work closely with IT and the Business group to understand business reporting requirements and analyze logical model, and develop subject matter expertise in a short time.
  • Participated in the requirement to segregate account sub groups like carryforward, encumbrance carryforward, other revenue, and state appropriation from account group. Performed analysis and recommended two approaches
  • Applied approach 2 based on limited cost and time
  • Created technical document for client reference

Confidential

Principal Consultant

Environment: Windows 2012, LINUX, Oracle 12c, Oracle EBS 12.1.3, OBIA (11.1.1.8.1 ) ODI 11.1.1

Responsibilities:

  • Implemented OBIA apps like Oracle Financials Analytics and Oracle Procurement and Spend Analytics
  • Implemented and Configured Oracle Data Interface (ODI) security, email etc...
  • Configured Oracle BI Applications Configuration Manager component like functional configuration
  • Configured Financial Analytics and Procurement and Spend Analytics
  • Customized OBIEE /ODI to achieve client needs
  • Implemented Oracle EBS SSO Authentication and Authorization (Application Role)
  • Technical Document peer review

OBIA/OBIEE Architect

Confidential, Tampa, FL

Environment: Windows 2008, LINUX, Oracle 11g, Oracle EBS 12.1.3, OBIA 7.9.6.4, OBIEE 11g( 11.1.1.6.1 ), Informatica PowerCenter Client 9.x, DAC 11g

Responsibilities:

  • Liaise with business subject matter experts in analysing business requirements and translating them into detailed conceptual data models, process models, logical models, physical models and schema development in the database
  • Designed Data Model in EBS HRMS - KFFs, EITs, DFFs, and SITs custom tables
  • Implemented and Customized Oracle Financials, HR Analytics using Informatica tools and DAC
  • More than 40 percent Customization using Informatica and DAC to achieve user needs
  • Lead the application development team in providing support & maintenance of data marts and data warehouses. Maintains the integrity of data movement into the data warehouse.

Confidential

OBIA Consultant / Informatica Lead Developer

Environment: Windows 2008, LINUX, Oracle 11g, JD Edwards, OBIA 7.9.6.3, OBIEE 11g,Informatica PowerCenter Client 9.10

Responsibilities:

  • Migrated Informatica objects based on JD Edwards upgrade
  • Customized Informatica mappings, workflows
  • Migrated and customized OBIEE based on JD Edwards upgrade

Confidential

OBIA Consultant

Environment: Windows 2008, LINUX, Oracle 11g, Oracle EBS 12.1.3, OBIA 7.9.6.4, OBIEE 11g (11.1.16), Informatica PowerCenter Client 9.10, DAC 11g

Responsibilities:

  • Customized OBIA apps like Oracle Enterprise Sales, Financials, Supply Chain, Manufacturing and Quality Analytics
  • Configured DAC and creates execution plans above subject areas
  • Implemented and Configured OBIEE Out of the Box
  • Implemented Oracle EBS SSO Authentication and Authorization (Application Role)
  • Customized Informatica, DAC, and OBIEE to achieve Sale cube and Booking Line Cube
  • Built Lookup tables in OBIEE to get Product Category Description using GL Segment table
  • Created Technical Document for future reference

Confidential

Senior Consultant

OBIEE/OBIA Architect

Environment: Windows 2008, LINUX, Oracle 11g, JD Edwards, OBIA 7.9.6.3, OBIEE 11g Informatica PowerCenter Client 9.10, DAC 10g

Responsibilities:

  • Analysed existing finance modules to achieve goals of working capital project
  • Converted Allocation CSV file into Allocation Dimension and Fact tables
  • Designed and Integrated Allocated data with AP, AR, Inventory, and GL
  • Customized OBIA (Oracle Business Intelligence Applications)
  • Customized and Development of Informatica and DAC
  • Customized OBIEE repository and created new reports
  • Created Technical Document for future reference

OBIEE/OBIA Lead

Confidential

Environment: Windows 2008, LINUX, Oracle 10g, Oracle EBS 12.1.3, OBIA 7.9.6.3, OBIEE 11g, DAC 10g, Informatica PowerCenter Client 8.61

Responsibilities:

  • Migrated Informatica objects from 11.5.10 to 12.1.3 based on Oracle EBS upgrade
  • Customized Informatica mappings, workflows, etc..
  • Migrated and customized OBIEE from 11.5.10 to 12.1.3 based on Oracle EBS upgrade
  • Reconfigured DAC client

OBIA/OBIEE Architect

Confidential

Environment: Windows 2008, LINUX, Oracle 11g, Siebel, OBIA 7.9.6.3, OBIEE 11gInformatica PowerCenter Client 9.0.1, DAC 10g

Responsibilities:

  • Implemented out of the box OBIA and DAC
  • Gap analysis of OBIEE Out of the Box and client requirements
  • Customized OBIA (Oracle Business Intelligence Applications)
  • Managed offshore and onsite team to build Informatica Design, DAC
  • TD (Technical Document) peer review

Confidential

OBIEE / Informatica Consultant

Environment: Windows 2003, UNIX, Oracle 10g, Oracle BI Admin Tool 10.1.3.4.xInformatica PowerCenter Client 8.1.1

Responsibilities:

  • Analysed Kraft foods - Promax reports
  • Integrated/Converted Promax reports into OBIEE reports
  • Implemented OBIEE Architecture
  • Created and Modified OBIEE Repository
  • Created Promotion Customer Clash, Customer centric, and Claims & Resolution reports.
  • Implemented Partitioning option using Informatica through parallel data processing.

Confidential

OBIEE Team Lead

Environment: Windows 2008, UNIX, Oracle 11i, Oracle EBS, OBIEE 10 g, Informatica PowerCenter Client 8.5

Responsibilities:

  • Gap analysis of OBIEE Out of the Box AR Financial module and client requirements
  • Recommended and helped Business Analyst to create functional requirement document
  • Recommended OBIEE Data model solution to Data Modeller.
  • Managed offshore and onsite team to build Informatica, DAC, OBIEE Repository & Reports
  • Provided two types currency reports for USA and Europe using Global exchange rate
  • TD (Technical Document) peer review

OBIEE/Data Model Lead

Confidential

Environment: Windows 2008, UNIX, Oracle 11i, Oracle BI Admin Tool 10.1.3.3.2

Responsibilities:

  • Data Modelling for Key Performance Indicators and Scorecards
  • Analysis, Design and Development of star schema for Pruitt Financial Data Model
  • Configured OBIEE semantic layers for KPI, Scorecard & external source
  • Managed onshore team to build OBIEE Repository & Reports
  • Recommended and applied Business Intelligence Best Practices
  • TD (Technical Document) peer review

Hire Now