We provide IT Staff Augmentation Services!

Bi Consultant Resume

OBJECTIVE:

Skilled and highly - motivated executive BI Consultant professional seeking a position in a dynamic organization to contribute to organizational objectives and charting mutual growth

SUMMARY:

  • 8 years of experience in BI consulting, data warehousing, ETL, solution design and implementation
  • Result-driven and goal-oriented professional with superb skills and successful experience in Data Warehouse and development (including physical and logical data modeling utilizing star schemas), implementation, and deployment (via Business Intelligence Reporting tools in Legal, Energy, Services, Insurance and communication domain)
  • Talent for proactively identifying and resolving problems, maximizing productivity, and delivering exceptional results
  • Deep understanding of Information Technology Software Development Life Cycle (SDLC)
  • Overcome complex business challenges and make high-stakes decisions using experience-backed judgment, strong work ethics, and irreproachable integrity. Respected as a proponent of empowerment and accountability
  • Easily adapt to any working environment while maintaining professionalism and high quality performance
  • Dynamic and self-motivated leader with ability to train, coach, and motivate team members
  • Proficient in developing OBIEE Repository (RPD Development) to form the framework for OBIEE Reporting and analysis using OBIEE Administration Tool
  • Demonstrated strengths in developing OBIEE Reports, Dashboards, Scorecards, KPIs and Agents using web based OBIEE client tool as OBIEE Presentation Service
  • Excel at Debugging, Optimizing, and Performance Tuning of OBIEE reports with Oracle DB and Exadata
  • Well convergent in Star Schema modeling, Fact and Dimension tables, Physical and Logical data modeling in the OBI Administration tool
  • Wide experience in extracting data from E-Business Suite 12.1.3, JDE XE, Billing and Revenue management system, Flat Files, integration, and lading data to OLAP systems
  • Worked as solution lead in BI Apps Financial Analytics implementations involving complex requirements in Confidential 7963 and 11.1.1.7.1
  • Expertise in implementing security models and integration for OBIEE involving LDAP, EBS, DB and Custom requirements
  • Extensive experience in Design and Development of ETL methodology for supporting Data Transformations & Processing using Informatica Power Center
  • Involvement in the Competency building for OBIEE and BI Apps

AREAS OF EXPERTISE:

Reporting: OBIEE 12c, OBIEE 11g, BI Publisher 11g, 10g, BI Apps 7.9.6.3, BI Apps 11.1.1.7.1 , Tableau

ETL and Scheduling Tool: Informatica 9.0.1, 9.5.1 and 10.1.3.4 DAC

Query Languages: SQL, Teradata Macros

DBMS: Oracle 10g/11g, Teradata v13, MSSQL 2005, DB2

RDBMS Utilities: Toad 7.5, 8, SQL Assistant Teradata, IBM Showcase

PROFESSIONAL EXPERIENCE:

Confidential

BI consultant

Software: OBIEE 12c

Responsibilities:

  • Planning, scheduling and coordinating the tasks for the upgrade project
  • Resolving and debugging critical issues involved in the upgrade
  • Follow up with Oracle Support for the issues in 12c OBIEE version
  • Facilitating Oracle expert services reviews and incorporating suggested configuration changes
  • Coordinate QA Testing, User Acceptance testing
  • Deployment and User training of new OBIEE 12c version

Confidential

BI consultant

Software: OBIEE 12c, OBIEE 11.1.1.7.x, Tableau

Responsibilities:

  • Planning the business requirements gathering sessions and process
  • Coordinating all business requirements gathering efforts with the Project Manager
  • Facilitating the business requirements gathering sessions
  • Capturing the information and producing the deliverables from the business requirements gathering sessions
  • Understanding and documenting business definitions of data
  • Developing the data model
  • Ensuring integration of data from external vendor systems and Siebel
  • Fielding questions concerning the data content, definition and structure

Confidential

BI consultant

Software: Confidential 11.1.1.7.1

Responsibilities:

  • Technical Lead for Enhancement track
  • Requirement analysis, Solution design and Implementation
  • Coordinate development activities within multiple teams

Confidential

BI consultant

Software: OBIEE 11.1.1.6.2 , Informatica 9.0.1, Informatica 9.5.1, DAC 11.1.1.6.4 , JDE B7333

Responsibilities:

  • Technical Lead for Asset management Track
  • Requirement analysis, Solution design and Implementation
  • Coordinate development activities within multiple teams
  • Conducting CRPs

Confidential

BI consultant

Software: BI Apps 11.1.1.7.1 , ODI 11.1.1.7.1 , OBIEE 11.1.1.7.0 , E- Business Suite R12.1.1.3, R11.5.10.2, Exadata

Responsibilities:

  • Solution Lead for Financial Analytics implementation
  • Configuration setup for Confidential by analyzing business requirements
  • Development of Essbase OBIEE integration for financial reconciliation reporting and KPIs, scorecard for the business critical metrics
  • Coordinate development activities

Confidential

BI consultant

Software: BI Apps 7.9.6.3, OBIEE 11.1.1.6.2 , BI Publisher 11.1.1.6, Informatica 9.0.1, DAC 11g, E- Business Suite R12.1.3, R11.5.10.2, Exadata

Responsibilities:

  • Mentoring team
  • BI Apps configuration for all three modules
  • Assess feasibility of functional and technical requirements and provide solution which involved loading data from two COAs for R1213 and R115 in warehouse, security implementation with EBS OBIEE SSO and third party tools, Geo spatial data in BI reports
  • Manage development and testing effort
  • Performance management of reports with high data volume
  • Suggesting design for the Executive dashboards with excellent user interface in BI and information to help the university to gauge the performance as compared to other competent universities

Confidential

BI consultant

Software: OBIEE 10.1.3.4, Informatica 9.0.1, Autosys 11.3, DB2

Responsibilities:

  • Managing Project Requirement Gathering
  • Coordinating with offshore and leading and mentoring a team of ETL and report developers
  • Handling the ETL enhancement requests

Confidential

BI consultant

Software: OBIEE 11.1.1.3, OBIEE 11.1.1.5, Oracle 11g, BI Publisher 11.1.1.3

Responsibilities:

  • Requirement analysis, design
  • Server setup for all the instances including clustering and high availability and load balancing
  • Security Setup with LDAP
  • Formulating test strategy for the developed code and testing the same under stress conditions to optimize report response time
  • Planning and managing day - to - day activities and interaction with client to facilitate smooth implementation
  • Provide consulting to client about the capabilities of OBIEE and suggesting augmentations in the requirements which proved helpful in measuring KPIs and enhancing the architecture

Confidential

BI consultant

Software: Informatica 9.0.1

Responsibilities:

  • Development of Informatica mappings
  • Code walkthrough and unit testing

Hire Now