We provide IT Staff Augmentation Services!

Sr. Obiee Consultant/lead Resume

Sunnyvale, CA

Summary:

Over 9 years of professional IT experience as BI/Data Warehouse Analyst and as Functional/Tech lead for BI projects in various domains like Sales, Manufacturing, Finance and Marketing. Experience includes data architecture, data modeling, working on ETL processes, Business Intelligence (BI) technologies and on different databases like Oracle, MS-SQL Server, Teradata. Design, Development and Implementation of Data Marts with ETL & OLAP tools using strong relational & multi-dimensional database modeling skills. Extensive experience in using BI reporting tools like OBIEE (Siebel Analytics), Tableau and ETL tools like Informatica.

EXPERTISE:

  • Lead DW/BI development teams delivering the projects on time as per Business reporting needs on different domains like Manufacturing, Marketing, Finance and Sales.
  • Extensively worked on providing decision support systems for executives, managers and different Global business partners (GBPs) in the organization.
  • Assisted the project manager in creating project plans, work breakdown, timelines, risk assessments and deliverables.
  • Experience in creating project plans, technical and functional design documents and ETL data mappings by translating the business user project needs.
  • Worked on all phases of data warehouse development lifecycle (SDLC) and agile methodology including requirements gathering, design, development, testing, implementation and support.
  • Expert in Impact Analysis, Application Design, Data Mapping, Interface analysis and ETL design.
  • Participated in Logical Data Modeling (LDM) and Physical Data Modeling (PDM) sessions to design the database tables as per business and reporting requirements in third Normal Form (3NF)
  • Experience in implementing full life cycle Datamarts with Star and snowflake schemas and designed the tables considering Slowly Changing Dimensions and dimensional modeling techniques.
  • Extensive knowledge in physical and logical data modeling using ERwin data modeling tool.
  • Installing and configuring Oracle Business Intelligence tool (OBIEE) and have hands on experience with OBIEE 11.1.7/ 10.1.3 and Siebel Analytics 7.8.4, 7.7 and 7.5.3.
  • Worked extensively on OBIEE Answers, dashboards, Delivers using BI Presentation Services and extensively worked on earlier versions of OBIEE i.e Siebel Analytics Answers and Siebel Delivers etc;
  • Analyzed, Designed and developed multiple end to end BI Tasks such as repository (rpd) development, OBIEE dashboards and reports.
  • Hands-on experience in visualization/front-end reporting tools with specialization on Tableau 8.1.
  • Extensively worked in Extraction, Transformation and Loading (ETL) of data from multiple sources in DWH using Informatica tool and have hands on experience with Informatica 9.5/9.1/8.6.1.
  • Extensively worked on Informatica PowerCenter components from 6.1 to 9.5 like Repository Manager, Mapping Designer, Server Manager, Workflow Manager and Workflow Monitor, Re-Usable transformations, mapplet designer, performance tuning, error handling, and Informatica best practices.
  • Experience in performance tuning after identifying the bottlenecks in ETL process at various components like sources, mappings, targets and sessions using database tuning, partitioning, aggregate tables(MT tables), load strategies, commit intervals.
  • Extensive Knowledge in deployment process using Kintana SCM, PVCS (version control) and running the batch jobs using Dollar Universe, TIDAL software and knowledge of shell scripting.
  • Experience working with Teradata utilities like MLOAD, Fast Load, TPump and BTEQ.
  • Experience in Agile Product Life Cycle Management (PLM) Datamart and configuring the ODI tool to extract the data from Agile PLM data source.
  • Experience in troubleshooting, root cause analysis, providing the long term fixes and knowledge of using Mercury Quality Center.
  • Strong experience in writing complex SQL Queries, PL/SQL stored procedures, triggers, packages and creating tables, indexes and views.
  • Interacted with cross functional teams and other teams like Quality Assurance (QA), Release Management, Production Ops and all other teams who are involved in System Development Life Cycle.
  • Actively involved in providing training to end users and worked in on-site/off-shore environment
  • Excellent problem solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Reporting Tools: OBIEE 11.1.1.7/10.1.3 , BI Publisher, Siebel Analytics 7.8.4, 7.7.1.2/7.5.3 , Tableau 8.1

ETL Tools: Informatica PowerCenter 9.5.1/8.6.1 , Informatica PowerMart 6.2/5.1, Informatica
DAC, Oracle, Data Integrator-ODI 10.3,

Database: Oracle (11g, 10g, 9i), Teradata 14/13/V2R6, SQLServer (2007/2005),MS-Access

Database Utilities: Teradata MLOAD, FastLoad, TPump, BTEQ, Fast export, SQL Loader

Database Skills: SQL Optimization in SQL Server, Stored Procedures, Database Triggers, and Packages, Database design, Normalization

Data Modeling Tools: AllFusion ERwin DM 4.1.4/3.5.2 , Microsoft Visio

Testing tools: Mercury Quality Center, Mercury Quick Test Professional

Languages: SQL, PL/SQL, C, C++, JavaScript, UNIX Shell Scripting

Technologies: HTML, DHTML

Web Servers: Tomcat 4.1.1, Microsoft IIS, Apache Server 2.0

Operating Systems: Windows 7/XP/NT/2000, Red Hat Linux, UNIX (Solaris, HP-UX, Confidential AIX)

Other Tools: Agile PLM Datamart, Dollar Universe, Tidal, Kintana SCM, PVCS (version control),
Golden Gate, TOAD

Work Experience:

Sr. OBIEE Consultant/Lead

Confidential, Sunnyvale, CA

Confidential through their products and apps like Good for Enterprise (GFE), Good Connect, Good Dynamics delivers comprehensive secure mobility solution. The company focuses on security of the data as well as the devices. As a Sr. OBIEE Consultant led the BI team and worked on Good Tech Revenue Reporting dashboard and worked on replacing Actuate reports into BI Publisher and OBIEE dashboard. Confidential has engaged KPI Partners Inc. to assist with a recovery and continuation of their OBI system and underlying data warehouse efforts. Implemented reporting content related to Revenue Analysis, Carrier Billing and Customer Care. The goal of this effort is to decommission Actuate by moving the solution to OBI.

Responsibilities:

  • Handling team with 4 ETL and OBIEE Developers.
  • Participated in all project phases including Design, Coding, Testing and Productiondeployment with documentation.
  • Involved in gathering business requirements and created Data Model Reference Guide (DMR)and mapping documents.
  • Responsible for creating analysis documents, estimates, project specifications
  • Responsible for assigning tasks to onsite and offshore team members and reviewing work done periodically during the week
  • Worked in BI Apps environment with Finance, Order Management modules.
  • Designed and worked on Revenue Reporting dashboard which gives revenue metrics based on Geo, Channel and Industries.
  • Extensively worked on OBIEE rpd and reporting UI by following best design practices to achieve standards.
  • Worked on MUD (Multi User) environment and extensively worked on OBIEE- BM layer to build additional measures which will give more flexibility to business users for more analysis
  • Involved in assessing the effort to replace Actuate reports to OBIEE and BI Publisher reports.
  • Worked on BI Publisher list reports and have experience building reports and layouts using rtf templates.
  • Extensively worked on BI Publisher layouts parameters, triggers and worked on delivering & scheduling the reports.

BI Analyst/Data (ETL) Analyst

Confidential, Milpitas, CA

As Sr. BI/Data Analyst worked on various Data Warehouse/BI applications providing solutions for the Global Business Service group covering marketing analytics, opportunity analytics, metrics for sales users , new product implementation (NPI) yields and usage metrics. Designed and developed several Datamarts for Marketing IT through ETL Process and developed multiple BI dashboards and reports using OBIEE and Tableau.

Application -- Customer Intelligence Center (CIC)

CIC offers through its intelligent dashboard design offers the ability for users to drill millions of data to extract business insights and intelligence for strategic and tactical decision making. The dashboard supports innumerable capabilities pertaining to the functional organizations like Marketing, Sales and Finance. Additionally CIC Opportunity Analytics dashboard offers a wide range of information for sales territory managers to identify their top accounts, cross-sell/up-sell and new opportunities across all products and propensity to buy across all customers related to Install Base

Responsibilities:

  • Created data models, built Informatica ETL processes including dimensional data modeling primarily star schema, performed data migration and executing large projects with quality.
  • Designed Marketing performance metrics covering targets, responses, leads and associated derived measures by analyzing marketing investments across campaigns & programs in marketing ODS.
  • Involved in data analysis for Product Hierarchy from TG to BU to PF to PID and come up with ETL design to load the hierarchical tables.
  • Designed and prepared the technical specification document (TSD) and ETL design documents and share with integration and development teams.
  • Design the required dimension and fact tables which satisfy the OBIEE reporting requirements by coordinating with BI development and other ETL development teams.
  • Exclusively worked with Informatica and Teradata teams to come up with control tables for smooth execution of ETLs
  • Extensively worked on evaluating the ETL work done by development team by analyzing the data flow, Informatica mappings, workflows and recommending best practice methods for better performance.
  • Developed parameter file templates and used variables and parameters in the ETL mappings for more flexibility and developed shell scripts to automate the process
  • Designed and developed complex ETL Informatica mappings using various transformations and developed pre and post session tasks to manage the indexes for better performance at ETL runtime.
  • Worked with Enterprise Release Management team (ERMO) for the project scope and release dates and also involved in coordinating with development, QA, performance and Ops team to explain the project details.
  • Designed OBIEE rpd design considering the star schema models and developed OBIEE dashboards and reports using BI Answers.
  • Extensively worked on analyzing and building the data model for Marketing Campaigns, Leads, Targets and Responses coming from sales force.
  • Involved in administering permissions and privileges to groups and users for Dashboard visibility based on their role and responsibility.
  • Involved in Unit, Integration, System and Business Validation Testing of generated reports and supported user acceptance testing team.
  • Worked on Tableau Security, publishing reports to Tableau Server.
  • Experience in creation of users, groups, projects and workbooks in Tableau.
  • Lead onsite and offshore teams in implementing solutions under the Global Business Delivery model.

CDFC and Usage Analytics Project

Customer Digital Footprint Cisco(CDFC) project will assist sales team by providing deeper visibility into their customer’s cisco.com activities, possible purchasing behavior, opportunity confirmation and advance knowledge of customer interests based on scores and alerts provided by Visual Science team.

Usage Analytics is a common platform where it shows the usage of all OBIEE application dashboards at one place where the higher management can see the adoption rate and usage metrics.

Responsibilities:

  • Coordinated with main stakeholders to comprehend project requirements and prepared their detail definition for implementation.
  • Designed and developed ETL mappings with truncate and incremental logic to pull the records and archiving the records over the period because of huge growing volume of data on daily basis.
  • Extensively worked on creating the aggregate tables based on the logic to calculate score for each customer.
  • Developed the OBIEE rpd as per the design and worked in BMM Layer for additional measures.
  • Coordinated with other cross-functional teams to get their OBIEE usage and modeled the tables to gather and store in one common table.
  • Configured Business Model Layer/Logical layer by creating facts and dimensions. Have created hierarchies to enable drill down in reports.
  • Involved in piloting the Usage Analytics project and presented the estimates and feasibility of the dashboard and then designed to implement on Production

Sr ETL Developer/BI developer

Confidential, San Jose, CA

Global Supply Chain Management (CVCM team)

Under Quality Management System (QMS) project, the Quality IT team developed business reports across all organizations under Product Life-Cycle Solution (PLS) such as Failure Analysis operations, FA sites, Quality Engineering, Customer advocacy and Manufacturing. Agile, Informatica 8.1 and OBIEE have been used to meet the end-to end business requirements.

Environment: Oracle Business Intelligence tool (OBIEE)/Siebel Analytics 10.1.3/7.8.4 , Informatica Power Center 8.1/7.1.4, Oracle 10g/9i, UNIX, WinNT, Telelogic System Architect, Agile PLM, TOAD 9.0/7.6

As an OBIEE/Informatica developer under Segregation of Yields (NPI) dashboard project, we built a new dashboard which provides First Pass Yield (FPY) metrics which in turn creates visibility to manufacturing FPY for Pilot build and Early Production Yields before the First Customer Shipped (FCS) Date. This implementation enables users to monitor and drive continuous improvement for FPY and reduce time it takes to bring FPY to TTQV.

Responsibilities:
  • Analyzed business requirements and translate them into Functional and Technical Design documents.
  • Designed and developed the Datamart and report metrics to provide a unified view of the Failure Analysis of the Cisco products.
  • Involved in data analysis and reviewing the Kimball Matrix to identify the dimensions, facts, measures and hierarchies.
  • Created complex derived measures and level based metrics in the BMM layer.
  • Configured Business Model Layer/Logical layer by creating facts and dimensions. Have created hierarchies to enable drill down in reports.
  • Defined Foreign keys in the Physical layer and the complex joins in the BMM layer of the repository.
  • Worked on creating the dimension level hierarchies for the dimensions and specified level based measures.
  • Extensively worked on using the initialization (init) blocks and variables.
  • Worked on building the Siebel dashboards, pages and reports as per the business requirements.
  • Developed different kinds of report views like pivots, charts and tabular and also worked on the Guided Navigation.
  • Worked on the new features in OBIEE like presentation variables in the reports
  • Enforced object-level and data-level security to different users and groups.
  • Extensively worked on creating the Informatica mappings, workflows to build the data warehouse tables needed for reporting.
  • Analyzed and transformed the Agile source data tables into 3NF form using the ETL techniques.
  • Involved on working with database views, MVs, PL/SQL queries and defined the process for loading the data into staging tables.

Agile PLM Datamart using Oracle Data Integrator (ODI)

Worked on POC project on Agile PLM Datamart which stores all relevant data available in the PPM, PC and PQM modules of the Agile PLM

Responsibilities:
  • Involved in delivering the normalized schema database that captures the business object data of Common, PC, PPM and PQM objects and their related data.
  • Worked on the Agile Datamart which supports incremental extraction for Cover Page, Page 2 and Page 3 data of business objects at transactional side.
  • Worked on the Agile PLM Datamart packages pre-built ETL that leverages Oracle Data Integrator (ODI) technology.
  • Worked on the ODI operator which can schedule and run the scenarios that extract, load and transform (ELT) the Agile PLM Transactional data into the Agile PLM Datamart.

Manufacturing & Engineering Quality Unit - ETL/Siebel Analytics Development

The Quality team in the Manufacturing Department has implemented Repair Data Enablement (RDE) Operational Metrics project which enable creation of new repair record types allowing easy retrieval of performance data. This implementation will benefit the CRM performance comparisons and early identification of quality and training issues. Informatica 7.1.4 and Siebel Analytics 7.8.4 have been used to implement and build the ad-hoc environment for the required metrics.

Responsibilities:
  • Involved in Data Analysis and reviewing the Kimball matrix to identify the Dimensions, Facts, Measures and Hierarchies.
  • Involved on working with database Views, Materialized Views, SQL queries and Defined the process for loading the data (staging).
  • Developed and maintained technical documentation from source to target load process and ETL Informatica development process.
  • Created mappings using various Transformations in Informatica like Aggregator, Expression, Filter, Router, Joiner, Lookup, Update strategy, Source Qualifier, Sequence generator.
  • Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions.
  • Expertise in multi-user environment in Siebel Analytics where the check-in and check out process have been extensively used.
  • Expertise in deploying the analytics rpd and catalogs and migrating from one environment to another.
  • Created connection pools, physical tables, schema folders and catalog folders in the physical layer of the Siebel Analytics repository.
  • Provided the ad-hoc environment to the business users and trained them to create the reports.
  • Created indexes and tuned the SQL queries to improve the performance of Informatica sessions.

Supplier DPMO Project

The project enables DPMO reporting for Supplier using the Autotest traceability data and repair data for Cisco components. It will have the ability to measure, analyze and improve the individual supplier quality for particular class codes.

Responsibilities:
  • Worked on the Auto-test source data to pull the data from MS SQL Server to the Oracle Staging tables.
  • Worked on Informatica mappings to build all the dimension, fact and aggregate tables.
  • Defined and created the required tables, columns, logical tables in the rpd using Siebel Analytics Administration Tool to configure the rpd and worked on Siebel Answers for creating the reports.
  • Set up page and global Filters in requests for customized reporting and Performed Custom formatting with html tags in dashboard.
  • Created Analytics Reports incorporating Charts and Pivot tables using Siebel Answers.

Informatica/Siebel Analytics Application Developer Jul ’05 – Oct ’06

Confidential/ Confidential , Middletown, NJ

Confidential world’s largest telecommunications company has recently implemented Work Flow Support (WFS) to support the process of Sales Forecasting. Under their eCRM project it has analytical processing team (OLAP) to allow the users to create and view reports and also analyze the effectiveness of all the customized supporting sales. Worked in Global Sales Enablement project which deals with standard and non standard opportunities created by sales department. Also involved in some of the other features namely Sales Target (sales target for individual persons), Automation (reports on automation of submitting Sales Order Requests, Service Availability & Credit Check) and Contract Analytic (reports on contracting) modules to enhance the sales team goals.

Environment: Siebel eCommunications and Sales Analytics 7.5.3, Informatica Power Center 6.1.2, Oracle 9i, UNIX, WinNT, Erwin 4.0, TOAD 6.5

Responsibilities:.
  • Worked closely with the Sales, Marketing teams and participated in the sessions which involve gathering the business requirements.
  • Interacted with system/function engineering team to design the Facts and Dimensions to configure the metadata.
  • Designed RPD based on business requirements by following best design practices to achieve standards.
  • Enforced object-level and data-level security to different users and groups.
  • Identified the granularity level of the data required, facts, dimensions and Hierarchies of the business model.
  • Analyzed the data elements for Forecast and Quota Facts and their corresponding dimensions.
  • Configured Physical layer by importing tables, creating tables and changing/adding the required physical joins/keys.
  • Managed security privileges of each subject area and dashboards according to user requirements.
  • Involved in web catalog (webcat) migration between different environments using Siebel Catalog Manager.
  • Performed end-user training to develop ad-hoc reports using Siebel Answers.
  • Worked on creating Dashboards and placed the respective reports under each dashboard as per business requirement mockups.
  • Designed and Developed ETL routines using Informatica PowerCenter within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Source Qualifier, and Stored Procedures.
  • Worked on SDE and SIL mappings in Informatica PowerCenter.
  • Worked on migrating ETL repositories and rpds from one environment to other.
  • Prepared and executed the DDLs and DMLs as per the requirements and created indexes for the purpose of Siebel Answer user’s ad-hocing.
  • Developed the ETL mappings and configured the sessions as per design documents to populate the Data Warehouse.
  • Scheduling and Monitoring Informatica sessions in Workflow Manager.

Hire Now