We provide IT Staff Augmentation Services!

Business Intellige Nce Lead (obiee) Resume

SunnyvalE

SUMMARY:

  • Over 10+ years of rich experience in IT industry.
  • Extensive experience in customization and configuration of OBIEE/BI Technology, BICS(Cloud Computing) and Siebel Applications (EIM, Configuration). Oracle certified professional: “Oracle Business Intelligence Foundation 10 Certified Implementation Specialist”
  • Having Complete understanding of OBIA 12c,11g,10g Financial, Manufacturing, sales, marketing, HR analytics tables - created dimensions and fact tables like star and snowflake schema
  • Implemented OBIEE Security like SSO and Development of RPD and the OBI EE Dashboards, Setting up the Security for reports like (Row level Security, data level, objects level, database level…)
  • Worked on Financial, Sales, Oracle Process Manufacturing Procurement & Spend Analytics, Supply Chain and Order Management Analytics, HR
  • Having Experience in installation, configuration, troubleshooting, performance tuning and administration of OBIEE 12c
  • Data model analysis to build the Star/Snowflake Schema in RPD and Data Analysis to understand the Joins for the Dimensions, Facts involved in the Schema
  • Having 2 full lifecycle of OBIEE 12c,11g,10g financial report implementation for Deutsche Bank
  • Have 8 years of extensive experience in Business Analyst and Oracle business Intelligence Application/tool (OBIEE). as, consultant, developer; Technical Support Lead which includes managing the releases
  • Managed, offshore teams as a Support Lead and in setting up and the offshore support team.
  • Having Experience in implementing Smart View for OBIEE, Strong experience building prototypes and presenting client demonstrations. Along with Strong understanding of source tables in the Oracle EBS database schema
  • Having experience with upgrade on versions of OBIEE and OBIA Knowledge of Accounting as well as working knowledge of data modeling Experience in Financial Analytics, Sales, Finical Report
  • Experience working with systems that handle sensitive data. Successful track record in working on cross-functional, cross-team projects
  • Experience with multiple BI reporting packages. (For example, OBIEE, POWER BI) Involved in, testing, and implementation of Application

TECHNICAL SKILLS:

Primary Skill category: OBIEE 12c 11g, 10.X, BICS (Cloud Computing), BI Analytics MS Power BI, PYTHON

Secondary Skill category: ETL, Data Modeling, Azure

RDBMS: Oracle8/8i/9i/10g/11g, Teradata, MySQL

Languages: JAVA, C, C++, SQl, PLSQl, PYTHON

Data Warehousing Tools: Informatics (Power Center 9.0.1/8.6.1/7.1.4/ 6.2/5.1 , DAC 10.1.3.4.1 , ODI, OWB, VISIO

Operating Systems: Windows 98/2000/2003/ NT/XP, Linux, Ubuntu, Amazon MI

Domain: Telecom, Marketing, Networking, Communication, Supply Chain, HR

WORK EXPERIENCE:

Confidential, Sunnyvale

Business intellige nce Lead (OBIEE)

Environment: Languages: JAVA, C, C++,SQL,PL/SQL,PYTHON

Database: SQL, Teradata, Excel

Tools: OBIEE 12C, BICS, POWER BI, Informatics, Bi publisher, SQL Loader

O/s: Windows, Linux

Responsibilities:

  • Requirements study and discuss the feasibility & finalizing the technical design according to the architectural guidelines.
  • Dashboard parameters finalization & Dashboard design concepts
  • Current Qtr,Q+1,Q+2,Q+3,Q+4 inventory calculation with different sites.
  • Find the future Shortage calculation.
  • High shortage NO of components BU to the Low shortage Components
  • Building prototypes and presenting client demonstrations. & understanding of source tables in the Oracle EBS database schema
  • Involved in, testing, and implementation of Application .
  • Sync RVBD dashboard with OBIEE reports and update on each Monday
  • Involved in, testing, and implementation of Application communicate with client on requirements, design, build, and test of OBIEE solution
  • Development of RPD and the OBI EE Dashboards, Setting up the Security for reports
  • Worked on ELT tools like ODI Designed, developed Mappings and implemented Business
  • Development of RPD and the OBI EE Dashboards, Setting up the Security for reports
  • Oracle certified professional: “Oracle Business Intelligence Foundation 10 Certified Implementation Specialist
  • Having extensive experience in data warehousing sourced from Oracle E-Business Suite instance
  • Having extensive experience in business requirements understanding and functional design of reporting\dashboard requirements
  • Having experience in developing and establishing the standards and checklists for report development, especially with respect to requirements and design documentation. (Prepared HLD, LLD, Test Case Documents etc.)
  • Strong knowledge in Oracle SQL to provide data mapping details to build team.
  • Having Knowledgeable in OBIEE 11g as an end user.
  • Created RPD, Reports, Dashboard with Various types of chart communicate with client on requirements, design, build, and test of OBIEE solution
  • Strong experience building prototypes and presenting client demonstrations.
  • Strong understanding of source tables in the Oracle EBS database schema
  • Experience with Oracle Business Intelligence Analytics (OBIA), Oracle E-Business Suite, Data Relationship Management (DRM)
  • Auto Configuration of OBIEE 11g on Windows System. Applying, Up gradation of OBIEE 12c whenever fixes are required for our project.
  • Manage Users and Web Groups
  • Involved in Estimation the Requirement.
  • Worked on POC’s related to OBIEE.
  • Involved in Unit, Integrated, Regression and Peer testing

Confidential

Lead Consultant (OBIEE)

Environment: Languages: JAVA,C,C++,SQL,PL/SQL

Database: Oracle 10.1.2.0.2 , Teradata

Tools: OBIEE11g, ODI, Toad

O/s: Windows, Linux

Responsibilities:

  • Liaising with the BA team to gather requirements and discuss the feasibility & finalizing the technical design according to the architectural guidelines.
  • Having Good Knowledge of Oracle ERP upgrade to R12 and integrations with OBIA
  • Involved in, testing, and implementation of Application
  • Creation of Technical design docs for our Project
  • Formulates and defines systems scope and objectives based on both user needs and a thorough understanding of business systems and industry requirements.
  • Creates or modifies procedures to solve problems considering technology capacity and limitations, operation times, and form of desired results
  • Analysis to understand the Joins for the Dimensions, Facts involved in the Schema
  • Build Warehouse model to the Star/Snowflake Schema in RPD.
  • Having experience with Oracle Business Intelligence Enterprise Edition (OBIEE) and Oracle Data Integrator (ODI)
  • Extensive experience on Oracle E-Business Suite General Ledger, Fixed Assets and Cash Management modules worked for Deutsche Bank
  • Having extensive experience in data warehousing sourced from Oracle E-Business Suite instance
  • Having extensive experience in business requirements understanding and functional design of reporting\dashboard requirements
  • Having experience in developing and establishing the standards and checklists for report development, especially with respect to requirements and design documentation. (Prepared HLD, LLD, Test Case Documents etc.)
  • Strong knowledge in Oracle SQL to provide data mapping details to build team
  • Having Knowledgeable in OBIEE 11g as an end user. communicate with client on requirements, design, build, and test of OBIEE solution
  • Strong experience building prototypes and presenting client demonstrations.
  • Strong understanding of source tables in the Oracle EBS database schema
  • Experience with Oracle Business Intelligence Analytics (OBIA), Oracle E-Business Suite, Data Relationship Management (DRM)
  • Development of RPD and the OBI EE Dashboards, Setting up the Security for reports
  • Independently handled Application ( Confidential Sales Current Quarter Applications)
  • Worked on ELT tools like ODI Designed, developed Mappings and implemented Business
  • Auto Configuration of OBIEE 11g on Windows System. Applying, Upgradation of OBIEE 11g whenever fixes are required for our project.
  • Involved in Estimation the Requirement.
  • Worked on POC’s related to OBIEE.
  • Involved in Unit, Integrated, Regression and Peer testing

Confidential

System Analyst (OBIEE)

Environment: Languages: JAVA,C,C++,SQL,PL/SQL

Database: Oracle 10.X, MySQL

Tools: OBIEE 10G, ODI

O/s: Windows, Linux

Responsibilities:

  • Liaising with the BA team to gather requirements and discuss the feasibility & finalizing the technical design according to the architectural guidelines.
  • Creation of Technical design docs for our Project
  • Analysis to understand the Joins for the Dimensions, Facts involved in the Schema
  • Build Warehouse model to the Star/Snowflake Schema in RPD.
  • Analyzed Reports and resolved Data Issues Related to Reports.
  • Designed & Developed Siebel Analytics Dashboard.
  • Analyzing and Solving the Tickets.
  • Deployed Users and provided appropriate privileges.
  • Configured Physical Layer, Business Model & Mapping Layer & Presentation Layer in
  • Siebel Analytics Administration Tool.
  • Provided Column Filters and Global filters in Dashboard.
  • Designed & Developed Siebel Analytics Dashboards.
  • Involved in unit, Regression and Peer testing

Confidential

Technical Associate (OBIEE)

Environment: Languages: SQL,PL/SQL, JAVA, C, C++

Database: Oracle 10.X, SQL Server

Tools: Siebel Analytics, Informatic

O/s: Windows, Linux

Responsibilities:

  • Siebel Analytics Platform/Application installation
  • Post installation verification and other tasks
  • Configured Siebel Analytics 7.8.4.2 iBots on windows Environment.
  • Merged two different web cats using Catalog Manager.
  • Involved in Upgradation of Siebel Analytics from SA 7.7 to SA 7.8.4.2
  • Analyzed Reports and resolved Data Issues Related to Reports.
  • Deployed Users and Provided appropriate privileges
  • Configured Physical Layer, Business Model & Mapping Layer & Presentation Layer in Siebel Analytics Administration Tool.
  • Provided Column Filters and Global filters in Dashboard.
  • Designed & Developed Siebel Analytics Dashboard.
  • DATA LOADING - ETL
  • Run Exception Reports
  • Data Cleansing
  • Run Complete ETL Execution Plan, resolve ETL/Informatics data issues

Confidential

Siebel Consultant (SIEBEL Analytics)

Environment: Languages: SQL,PL/SQL, JAVA, C, C++

Database: Oracle 10.X, SQL Server

Tools: Siebel Analytics

O/s: Windows, Linux

Responsibilities:

  • Extensively customized and added new Siebel GUI layer (Screens, Views, Applets) Objects to add the New Functionality.
  • Customized page tab objects like Opportunity to Case, Accounts to Customers etc.
  • Enhancement of Functionality of Siebel Business Components using Joins, Links and MVGs, Drilldown applets.
  • Customization of Joins, Links, MVG, pick lists, Pick applets etc.
  • Working experience in EIM.
  • Worked on User properties
  • Performed Functional Testing
  • Actively Coordinating with the Team Members.
  • Worked on Few User Properties.
  • Migrate the code from DEVLOPEMENT/TEST/STAGE and to PRODUCTION.
  • Work in Cluster Model at STAGE and Production

Hire Now