We provide IT Staff Augmentation Services!

Senior Business Intelligence Analyst Resume

San Jose, CA

SUMMARY:

  • Over 14 years of successfully managing full project lifecycle(Initiate, Plan, Execute, Control, Close) and SDLC(Analysis, Design, Development, QA, Performance testing, Release) of Enterprise wide applications, supporting IT infrastructure, Data Integrationn solutions and delivering the projects/products on - schedule and on-budget.
  • Proven ability to bridge technology and business goals to provide productive solutions.
  • Extensive development and implementation of Data Warehousing /Business Intelligence projects.
  • Designed Proactive Monitoring system on Hadoop platform to identify, measure, alert and address, customers, professional service team, sales team based on the risk type.
  • Developed testing strategy for complex global BI initiatives.
  • Helped reduce business user’s manual work of consolidating the reports into a single workbook by automating into a single click download feature.
  • Experienced in Data warehouse projects using Erwin and Power Designer tools for designing Logical and Physical data models.
  • Management of large, diverse teams across various technologies and functions.
  • Design and develop Online Real-Time Analytics Applications.
  • Architecture, Apps Design, Development and Security.
  • Building and operating efficient onsite-offshore, hybrid development, operational teams.
  • SDLC Waterfall, Agile Methodologies
  • Pre-sales technical support.
  • Extensive experience in Extraction, Transformation, Loading (ETL) data from various sources, ex Oracle, SQL Server, Flat Files, XML Files, Teradata, DB2, Mainframe into Data Warehouses and Data Marts using Informatica, Oracle Warehouse Builder and other techniques like Unix Scripting, SQL*Loader and PL/SQL.
  • Excellent balance between technical and business skills.
  • Has proven ability to communicate effectively across functional areas and hierarchies while working autonomously or within large group to achieve client and project deliverables.
  • Leading and mentoring development, design and QA teams

TECHNICAL SKILLS:

Databases: (Oracle, Teradata, DB2)

Data Analysis: and Visualization (Tableau, PIG, Hive, Toad, OBIEE, BIRST).

BIG DATA: (Hadoop), MapReduce, HIVE.

ERP: (Oracle, SAP - Order Management, Install Base, Service Contracts, Global Support)Cloud Computing - Salesforce.com

CASE Tools: ERwin

Business Intelligence: (OBIEE 11g, Cognos, Data Stage, Informatica, Pentaho, DAC) Platforms (AIX, Windows, Linux, Citrix, VMware)

Administration: ( OBIEE 11g, Oracle Warehouse Builder)

Web Technologies: ( HTML, Java Script, Java)

GUI Tools: OBIEE - BI Administrator, BI Answers, BI Publisher, Dashboard, iBOTS, (SQL Plus, PL/SQL, Report Writer), Shell Scripts, Oracle OEM, Cognos - Framework Manager

Data warehouse: (STAR Schema, Snow Flake schema, Multi-Dimension, OLAP, OLTP)

PROFESSIONAL EXPERIENCE:

Confidential

Senior Business Intelligence Analyst

Responsibilities:
  • Created high-level design documents to convert business requirements into conceptual, logical and physical models.
  • Processed 2-3 TB of ASUP log data on a daily basis extracting from Confidential data centre into HDFS (Hadoop) system.
  • Prepare mapping document to provide source to target flow, business logic for deriving measures/facts, joining criteria, extraction logic( load strategy), error handling, data retention and application access requirements.
  • Implemented naming, coding, execution standards.
  • Participated in Business Strategy session to recommend right DW/BI tools.
  • Enforcing data modelling standards and identify and promote best practices and patterns for data modelling.
  • Architecture solutions for Real-time integration between Data warehouse and Enterprise MDM Customer Data Hub for enrichment data attributes and also with Third Party Cloud based products like SFDC.
  • Directly working with Business, to architect and designed self-service analytical solution for the Global support domain.
  • Provided expert decision-support dashboards, to analysts, managers, and executives in the usage and interpretation of data.
  • Designed Proactive Monitoring system on Hadoop platform to identify, measure, alert and address, customers, professional service team, sales team based on the risk type.
  • Gather requirements, analyse the feasibility and understand the business process, gathering different data sources and creatively designing the metrics system to help business have critical information on hand.
  • Designed ETL framework for incremental loads.
  • Good judgment in solving problems as well as identifying problems in advance, and proposing solutions.

Environment: OBIEE 10g and 11g, Hadoop, HIVE, MapReduce, Cognos, Oracle ERP, SAP and Oracle 10g.

Confidential,San Jose, CA

Business Analyst

Responsibilities:
  • As a Subject Matter Expert (SME) worked on designing C3 Business Layer (C3BL) within Cisco - Customer Advocacy (CA) group using source, Oracle Apps 11i CRM module data built to provide ad-hoc reporting and analytics for technical support service user community.
  • CAP is a group which handles high profile customer issues. The cases are closely monitored by Senior Managers, VP, Directors, all the way up to the CEO level.
  • For CAP there was a need for developing a Business Intelligence System for analyzing the data.

Technology: Oracle 10g, Informatica, SQL, PL/SQL, OBIEE, Siebel Analytics, Business Objects XI, $U scheduler, DAC.

Hire Now