Tableau, OBIEE, Informatica/ODI, Oracle

Vijaya Kumar S Yashodappa

Email Id: *******@*****.*** Mobile # +1-408-***-**** Location: San Jose, CA, USA

Professional Summary

IT Professional with 10+ years of experience in providing Business Intelligence and Data warehousing solutions using Visualization & Reporting tools like Tableau, Oracle Business Intelligence - OBIEE, ETL ODI/Informatica, Oracle/Teradata SQL, exposure to DataStage, Siebel CRM, TAC/TalenD, Automic, Qlik View

Proficient in BI Implementation cycle includes Analysis, Logical & Physical design, development, testing, migrating and implementing business solutions using Tableau & OBIEE, ODI/ETL & SQL tools

Develop & implement data level security in Tableau, administer users, user groups, define & schedule extracts

Consult with business & technology partners on data visualization solutions for their existing legacy reports

Drive Tableau code migration process across Dev/UAT/Prod and implement best practices & standards

Create & schedule Tableau data extracts auto process with Daily/Weekly/Monthly incremental & full basis

Troubleshoot Tableau related issues & queries, provide customer support to users and help them to write custom SQLs to meet their requirements

Converted OBIEE/Discoverer Reports & legacy MS Excel based reports into Highly Interactive Tableau Dashboards for Advanced Visualizations

Created various rich & intuitive interactive dashboards including the dashboard navigations using URL Actions to navigate to detail Reports, action & quick filters, Parameters, Sets, Groups, custom hierarchy, Bins, calculated fields, table calculations, Level of Details

Created Executive Dashboards by blending heterogeneous data sources by extracting millions of records with decent performance & combined multiple dashboards into a story to enhance the visual appeal of the reports

Used advanced charts in Tableau Desktop like Box and Whisker plots, bullet charts, drill downs, stack bars, bar graphs, scattered plots, geographical maps, pareto, waterfall charts

Very well versed with Tableau connections when to use Extract vs. Live connects for data size vs. performance

Strong experience in dimensional modeling and data warehouse best practices

Experience in Debugging, Optimizing and Performance Tuning of Oracle BI/Siebel Analytics Dashboards/Reports by implementing Aggregate navigation, cache management and materialized views

Experience in Installation, Configuration, Migration & Administration activities of Tableau and OBIEE

Proficient in Repository Design & Development of OBIEE Repository (rpd), Analysis & Dashboards, concepts like Fragmentation, Time Series, Level based metrics, Hierarchies, Aggregate Navigation, etc using OBIEE Admin tool

Expertise in implementing different Security Models like Object & Row level security, RPD level, Webcat level etc.

Expertise in Creating various Variables, Dynamic Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and Drill down Properties, Cache Management, Event polling, & Cache seeding

Involved in Extraction, Transforming and Loading data from heterogeneous data sources into Enterprise Data Warehouse by creating mappings/workflows using ETL tools like Informatica & ODI

Cloud proof of concept – Used Oracle Cloud Solutions & Amazon AWS to test & perform advanced data analytics by transforming current On-Prem BI platforms to Cloud platform solutions

Excellent interpersonal and communication skills for efficient client interaction

Strong Conceptual, Business, Analytical skills and highly motivated team player.

Skills

Reporting Tools: Tableau 10/2018/2019.x.x, OBIEE 12c/11g/10g, Informatica 9.x, Oracle Data

Integrator 11x, DataStage 7.x, BI Publisher, Siebel CRM, Power BI

Databases & OS: Oracle, Teradata, Toad, SQL Developer, Win 7/8/10 & Unix

Script: Python & Unix scripts

Others: Service-Now, Workday, Putty, Kintana, TAC/Automic, DAC

Certifications:

Tableau Essentials Training

ORACLE BUSINESS INTELLIGENCE FOUNDATION SUITE 11G ESSENTIALS

SIEBEL 8 CONSULTANT CERTIFIED EXPERT

Education:

Bachelor of Engineering with major in Computer Science from VTU

Professional Experience:

Marvell Semiconductor Inc., Santa Clara, CA, USA Jun 2017 – Present

Staff BI Analyst

Skills: Tableau 10.5/2018.x/2019.x, Oracle 11g, MS SQL Server, ODI 11g, OBIEE 11g/12c

Responsibilities:

Responsible for setting up meetings with different business stake holders for requirements gathering then involve in Design, Development, Implementation and maintenance activities

Developed numerous Data Marts in EDW and built highly rich & reliable Visualizations using Tableau for Sales Operations, Quality & Reliability Engineering, Finance & Revenue teams

Replaced MS Excel Legacy reporting mechanism existed for more than 10 years to Tableau dashboards for their Weekly/Monthly/Qtry Ops review meetings with VPs & other executives

Worked closely with different teams across geography to integrate heterogeneous systems like PDM, FavoWeb, MS Excel, Oracle, Cavium & Phred into mainly 2 Data Marts for Tableau reporting purpose

Closely work with offshore team to allocate tasks and code review to make sure we have quality delivery to users

Built highly reliable daily/weekly summary metrics in Tableau and added users for subscription to schedule them deliver to executives in Quality & Reliability Engineering on daily and weekly basis

Prepared Tableau User Guide Manual and conducted training sessions for Licensed Developers of different stake holders to brief the functionality of Tableau so that they can build their own visualizations as needed

Responsible for Tableau Code migration activities including Data Sources, Workbooks, and Security set up/modify for new users, user groups etc.

Setup different data level security in Tableau dashboards based on Division, BU, Region level requirements

Completely responsible for developing new enhancements to existing Tableau reports delivery to QRE & Sales Ops

Developed and maintain Tableau security model, performance improvements, configuration, etc.

Worked with Sales Operations, Finance, Revenue, Supply Chain teams for configuring dynamic security for users

Responsible for setting up new daily summary metrics reports using Tableau Desktop BI solution and scheduled them to deliver to VP, Store Managers, Divisional and regional heads on daily and weekly basis

Involved in building new mappings/interface/packages & scheduling them in ODI ETL tool to support end to end

Involve in any production support activities for any Daily/Weekly/Qtrly flash reports data discrepancy, month end closure revenue activities, any other reporting issues, security setup, incidents/tickets management etc.

Provide support to existing OBIEE reports & new enhancements in addition to Tableau support for Sales Operations, Finance, Revenue, Supply Chain teams and involve in OBIEE code migration activities to UAT & production instances, setup security for new users

Walmart Global eCommerce (Walmart Labs) Sunnyvale, CA Apr 2013 – Jun 2017

BI Consultant

Product: Online Grocery (US)

Description: Walmart’s Online Grocery (OG), also called as US Grocery is a Delivery/Pick up service from Walmart Inc for Grocery items. This OG has introduced multiple services like Thunderbolt for express pickup and delivery, Curbside, Same day delivery etc. Product and Finance Business team would want to get real time update of the data from source system through Tableau/BI Reports to do better business by evaluating their important KPIs.

Responsibilities:

Responsible for meeting business users directly for Requirements gathering and Design, Development,

Implementation and Maintenance of an Online Grocery reporting project module

Completely held responsible for architecture, design, development, implement & migration of all existing BI reports/dashboards/Repository from Oracle data source to Teradata data sources as part of historical migration project by redesigning, rebuilding them

Developed Finance and daily summary metrics reports using Tableau Desktop BI solution and scheduled them to deliver to VP, Store Managers, Divisional and regional heads on daily and weekly basis

Created different levels of drill down hierarchies, measures with forecast, complex calculations at metric level for Thunderbolt service reports, Pickup Only reports, Manifest Reports and published using Tableau

Developed numerous Tableau reports to capture some of key metrics like YOY, QOQ, MOM, YTD, MTD

Implemented security setup to access reports & dashboards at different levels in Tableau BI desktop & OBIEE for Divisional, Regional, Market Heads and Store Managers for all Tax reports(sales, refund and consolidated), Thunderbolt reports, Pickup Only reports, Manifest Reports

Support new enhancements to existing OBIEE reports and dashboards, tuning the performance of some of ad hoc queries generated by ad hoc users and assisting them in rewriting the queries

Responsible for conducting trainings, guiding & mentoring junior members in the team to bring them up to speed

Provided leadership and direction through subject matter expertise & prepared technical standards to be applied across all elements of the BI delivery spectrum

Cisco Systems, San Jose, US as OBIEE Lead Dec 2009 – Apr 2013

Product: Cisco Management Metrics Center (CMMC)

Description: CMMC is a decision support application which provides access to highly confidential, accurate, timely and secure data from HR and Finance applications that enables HR Professionals to analyze and manage workforce metrics to effectively support their clients and programs

Responsibilities:

Responsible for directly interacting with Onsite Business users & coordinators to providing offshore deliverables

Understand the business requirements on OBIEE, Providing the high level and low level estimation of the business requirement from OBIEE stand on new developments/engagements from offshore

Successfully released some of major enhancements of CMMC called CPC (Cisco Performance Connect), ILM(Identity Lifecycle Management) which helped CISCO to review Employee Performance & also to differentiate Vendors & Partners in CISCO (ILM)Created Technical Design documents based on the FSD designed by IT Analysts

Ensured the quality of design and code before deliver the results to business users from offshore front

New monthly enhancements to increase functionality of CMMC application by releasing them into Production

Oracle India Private Limited, Bangalore, India Apr 2006 - Nov 2009

PFIZER CTMS IMPLEMENTATION, US May 2008 – Nov 2009

GLOBAL CONTRACTS REPORTING PORTAL - GCRP, Bangalore Sep 2007 – May 2008

MERCK SLI - ETL IMPLEMENTATION, Bangalore, India Jun 2007 – Aug 2008

PEOPLESOFT EPM IMPLEMENTATION, Bangalore, India Apr 2006 – May 2007

Senior Developer

Description: Design & develop multiple client specific implementation and enhance oracle products for some of clients including Pfizer Clinical Trial Management System (CTMS), Merck Inc., project which dealt with implementation of Siebel CRM eClincial, Informatica, OBIEE & XML/BI Publisher reporting requirements

Responsibilities:

Involved in analyzing the requirement, coordinating with Onsite team & Client on daily basis

Involved in customizing the Repository (RPD), creating numerous analytical reports based on mockup reports’ templates provided by Pfizer which also involved ad-hoc reports per their request basis

Extensively involved in repository & Web Catalog migration and designing BI Publisher reports

Designing & Developing the Reports using an XML Publisher Reporting Tool which was integrated to PeopleSoft’s EPM Environment

Involved in writing the test scripts for System Integration Testing and Worked on SQL for helping ETL/RPD design

Designed the ETL mappings in order to load Siebel Source tables with Vendor File information provided by Merck

Extensively involved in creating the design documents including Technical Design Documents, Test Scripts etc

Involved in preparing Installation Instruction/Operation Qualification/Post Installation documents for OBI

Contact this candidate