Ramesh Pabba

Sr Lead Tableau Consultant/Architect

Oracle Certified Professional – OCP SR3465215

484-***-****

acxeql@r.postjobfree.com

** + years of Total IT experience.

** ***** ** ** ******** Specialist possess and Architect in Business Intelligence Applications using Bigdata Hadoop, OBIEE/BI Apps and Tableau, SAP BO, Hypérion Essbase with Oracle EBS R12 source background. Played the key roles with OBIEE,OBIA,ODI,Informatica & MDM.

Worked on all phases of DW/BI implementation lifecycle from conceptualization, requirement gathering, document Business requirements such as (Oracle standard MD-50,MD-70),analysis, design, implementation, testing, Server Administration, maintenance and support.

Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partner’s relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers.

Business Stakeholders to understand the future initiatives and define scope, high level application architecture, system impacts

Tremendous client interfacing experience and exposure to Pre-Sales activities including PoC, Project Costing, Proposal Making, RFP, RFI.

Expertise in Business Intelligence Applications using Oracle Business Intelligence (OBIEE/OBIA) in Financial, HR modules.

Installation & Creating repository OBIEE 12c & 11g administration Tool on Linux/windows.

Experienced installing, configuring, administering and troubleshooting of Oracle Fusion Middleware products (OBIEE/BI Apps,BI Publisher,OAM,OID etc).

Implemented Migration projects from SAP BO and Cognos BI and Microstrategy to OBIEE.

Setting up the OBIEE environments in Linux, UNIX, windows with SSO setup.

Installation, Configuration & Administration on ODI11g/12c environment with scheduling & monitoring.

Experience Oracle EPM Hyperion Essbase installation, configuration and performance tuning.

Experience using ETL tools such as Oracle Warehouse Builder (OWB) and Integrator (ODI).

Experienced with Informatica ETL and CDC configuration&Administration and train developers.

Excellent Knowledge of Data Governance as a component of a MDM solution, and how to apply governance to a MDM program as a whole.

Installation, configuration of Exalytics box, OBIEE on Exalytics with TimesTen in-memory DB.

Extensively worked on the Remediation projects on the Oracle BI Apps Financial Analytics.

Studied the Existing Oracle EBS source data table structure and data flow and worked on the Fit Gap Analysis to implement BI Apps Project.

Develop and maintain project plans, including Work Breakdown Structures, timelines, resource plans, training plans and any other project related plans.

knowledge in Oracle Utility Analytics only functionally and technical process to implement.

Developing, Designing and supporting interactive Tableau Dashboard reports.

Administration skills with Tableau Server Admin 9.0,Tableau Desktop, Tableau Online.

Work directly with business units to define and prototype QlikView Applications

Knowledge & Technical Skills:

Oracle Business Intelligence, BI Applications, BI Publisher

Middleware Products: Weblogic, Portal, serviceBus, SOA, webcenter, OAM, OID

Microsoft Business Intelligence Tools, SSAS, SSIS, SSRS

Microsoft Windows Server, SQL Server, BIDS, SSMS, Data Tools

Dashboards, Scorecards, Report Builder, Power View, Tableau

Methodologies & Framework: Information Delivery, Data warehouse, Kimball, Data Science.

Technologies: Microsoft BI, OBIEE, Tableau, IBM Neteza, QlikView, Business Objects

Emerging Technologies: Hadoop, Statistical R, In- memory Analytics, Cloud,Splunk Monitoring.

Industries: Manufacturing, Oil & Gas, Health Care, Retail, Manufacturing, Finance, Education / Publication

Database & ETL/ELT Tools: Informatica, ODI, Oracle warehouse Builder.

Project #

Client

McDonalds - Contract thru Wipro

Location

Chicago, IL

Role

BI Tableau Lead & Admin

Duration

April – Present

Team Size

4

Environment

Tableau 9.0 OBIEE 11g, Essbase, ODI 11g Database Oracle, flat files.Peoplesoft HCM,Oracle EBS,Informatica 9.5,O/S: Windows,Linux

Role & Responsibilities:

Involved in gathering requirements from business users and stake holders.

Actively participated in Business Analyze sessions conducted by Stake holders to understand the business and answer business questions about capabilities of Tableau.

Convinced business to use Tableau by exposing the capabilities of Tableau reporting.

Built Tableau dashboards for showing insights of different portfolios dashboards and customer level detailed reports for relational managers, Directors and VP. Generated various Analytics reports like Formulary Report and Direct Sales Report using global and local filters.

Worked with EBS modules like AR/AP/GL/P2P and migrated the objects with PPM and scheduled Concurrent Program which intern does the incremental loads every day.

Worked closely with DBA/Release Team in scheduling the Concurrent Program and migration Process approvals and attended the CRB meetings for approval.

Working on the incidents and give the turnaround time and try to resolve the Tableau issues raised by business.

Involved in the setup of AWS and Redshift ODBC configuration in cluster environment.

Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.

Developed Data Models and Metadata Repository (.rpd) with multiple business layers using complex joins.

Extensively used Tabadmin and Tabcmd commands in creating backup's and restoring back up's of Tableau repository.

Identified and improved infrastructure and processes. Ensure environments are stable and available.

Administer and support tableau Infrastructure including Upgrades, testing, Security Administration, License Management, troubleshoot workbooks, Performance Monitoring and System maintenance.

Design a Data Source or Extract Layer to reusable in Tableau from EBS and Essbase.

Processing Financial data out of Essbase and into Tableau into hands of executives.

Test and explore new releases of Tableau Application and drivers, suggest and support user with proper drives install.

Coordinating across multiple business groups to setup support and user meeting.

Document best practices for Development and administration of the tableau Platform.

Maintaining Security and Create/manage users, Groups, Licenses and integrate with Active Directory.

Ability to train or coordinate business users to setup Site and Access policies.

Project #

Client

AT&T (Consulting Inc) – Contract

Location

New Jersey, US

Role

OBIEE/Tableau/ODI Architect/OBIEE Business Analyst

Duration

Nov -2015 to Mar 2016

Team Size

9

Environment

Oracle BIEE 11g/12c, BI Apps 11g, Tableau, ODI 11g Database: Netezza DB, Oracle, flat files. Informatica 9.x,Unix

Enhance performance by requesting Aggregate tables, Indexes and managing Cache after Benchmarking performance tuning strategies with business model-level calculations versus database level pre-computations and aggregations.

Improved Performance by creating materialized views and Partitions tables for the fact tables.

Role & Responsibilities:

Requirement gathering from the business and leading the project and creating the required design documents.

Involved in assisting building detailed project schedule, completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs and Unit test scripts.

Upgraded to higher version environment from OBIEE 11.1.1.7 to 11.1.1.9

Installed & Upgraded from 11g to 12c.

Performed Migration steps from OBIEE 11g to 12c.

Designed and tested reports in the Dashboards for the Oracle HR Analytics modules like compensation, HR Performance, Retention and Workforce Profile.

Assists in Self Service HR and Self Service benefits configuration and troubleshoot customization issue.

Provided HR benefits and Salary base table and column information to technical team and assists them in defining OBIEE Repository requirements, and defines design and content requirements for Dashboards.

Experience with OBIEE Security implementation as Application groups/Roles, Catalog Permission, Data & Object level security.

Designing the whole solution to integrate Employee attributes from HR Analytics tables with timesheet data feed from Clarity tool. This is to create comprehensive data set that can be analyzed through Tableau.

Worked extensively with Physical Layer, Business Layer and Presentation Layer.

Designing the solution to integrate existing Oracle data ware house data to GBS data ware house, this is to create comprehensive data set that can be analyzed through Tableau.

Created parameters for Prompts in Calculations for various Tableau workbooks and dashboards.

Executed and tested required queries and data before publishing Dashboard to Tableau Server.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Created complex data Views manually using multiple measures, also used sort, Filter, group, Create Set functionality.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.

Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.

Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.

Performed Tableau administration function like Migration of Tableau Workbook and Dashboard from one server /environment to others.

Experience Implementing Proactive Tableau Environment Health Checks and Performance Threshold Alerting

Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.

Designed multiple Dashboards for CDI, helping them to convert from manual reporting

Creating currency conversion table and loading currency conversion data from rss feed. Also loading factual data after converting it into US dollars using the currency conversion table.

Set up the ODI Topology including physical architecture, logical architecture and context.

Performed reverse engineering for the data sources and targets and performance tuning on ODI interfaces.

Optimized the knowledge modules to improve the functionality of the process.

Implemented logic to archive the source files with date stamp affixed after the successful load.

Experience with MPP Databases like Netezza, ETL tools like Informatica & ODI.

Coordinating with offshore development team and on shore business team for development and requirements gathering.

Creating required views for reporting in Oracle BI & Tableau reports.

Project #

Client

Hilton Worldwide Inc – Dell International services

Location

Austin, Texas

Role

OBIEE Architect & Sr Consultant

Duration

Jan 2015 – Oct 2015

Team Size

14

Environment

OBIEE 11g, Cognos 10,Informatica,OWB Big Data, Oracle DB

Role & Responsibilities:

Worked closely with users to understand KPI, gather and document reporting, analysis and data requirements

Designed ETL strategy, performed data loads into the data mart and ensure data quality.

Implemented the business logic using business layer with BI Administrator tool.

Updated dashboards and report designs showing trends, patterns and other required data analysis using OBIEE Answers.

Implementing & Administration security setup for OBIEE dashboards and KPI’s as per the requirements.

Develop and support forms generated using legal pre-printed forms through Oracle BI

Work as an Oracle Business Intelligence Publisher specialist in Data Architecture and Reporting team

Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.

Design Oracle BI Publisher Data Models, Data sets and Templates / sub templates which will be used by business in daily basis.

Analyze Freight Forwarding data, XML supersets to develop XML, XSLT, SQL coding to create Client Facing Documents through OBIP.

Design complex RTF, PDF, Adobe Flex and Excel templates for Oracle BI Publisher reports.

Eliminate the need to copy data from the underlying storage system to HDFS

Leverage rich, deep and fast analytics on Hadoop data files of various kinds

Conducted statistical and analytical functions from HAWQ on HBase or Hive Data

Run complex analytical queries that join in-database dimensional data with fact data stored in HBase.

Performed the enhancements to the existing reports based on new requirements.

Upgraded from 10 g to 11g environment and installed patches to the given versions.

Project #

Client

BioMarin Pharmaceutical Inc - Dell International services

Location

Austin, Texas

Role

Oracle BI/BI Apps Sr Consultant/ Tableau

Duration

Oct 2014 – Dec 2014

Team Size

8

Environment

OBIEE/BI Apps 11g, Informatica, Netezza DB, Oracle DB,

This particular project was developed to maintain all the details of the details, Market retail sales and distribution and patience details that use their medication. All data maintained in the GBI for their sales force or call center in order to increase the sales using Oracle BI reporting data.

Role & Responsibilities:

BioMarin DB source is implemented and Interact with Business users and understanding their requirements.

Designed ETL strategy, performed data loads into the data mart and ensure data quality

Implementing & Administration security setup for OBIEE dashboards and KPI’s as per the requirements.

Initiated data management, data governance and data stewardship strategies

Updated dashboards and report designs showing trends, patterns and other required data analysis using OBIEE Analysis.

Worked closely with users to understand KPI, gather and document reporting, analysis and data requirements

Worked closely with and ETL development team Working on generating various dashboards in Tableau server using various sources such as Teradata.

Performed Data extraction, Data profiling, and other data intensive solutions to create advanced BI visualizations.

Determined the data visualization based on the business value.

Improved system responsiveness of Tableau Dashboards by implementing best practices for Tableau Desktop.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.

Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Analyzed the source data and handled efficiently by modifying the data types.

Created tableau dashboards for measures with forecast and reference lines.

Generated tableau dashboards with combination charts for clear understanding.

Assisted Business users and recommended features, charts, KPI's for their business analysis in Tableau.

Created Cascading dashboards, data extracts Action filters for better performance of Tableau.

Trained senior executives/users in making the best use of the BI solution.

Project #

Client

Calix Inc

Location

California, CA

Role

Oracle BI/BI Apps Lead Consultant

Duration

June 2014 – Aug 2014

Team Size

12

Environment

OBIEE, BI Apps, Oracle EBS, Oracle DB, Unix

Implementing the financial reporting application cost of goods sold(COGS) which relates to revenue generated from various customers fetched from receivables. We had to verify the data populated in this application with OBIEE and Oracle BI apps custom reports and backend database.

Role & Responsibilities:

Involved in requirement gathering, As is study, To be study, GAP analysis, solution design, documentation, implementation of the project.

Provided Functional on AP module in P2P cycle and also on PO, GL and AP related issues which are integrated with AP module.

Migration from SAP BO reports to OBIEE using the universes.

Develop metadata repository development, including development and implementation of a Global Business Metadata Repository, to ensure consistency and standards in data naming conventions, definitions, and corporate standards for formulas, calculations, and formats.

Building the solution architect to connect multiple sources and generate financial analytics deliverables.

Implementing the OBIEE dashboards and KPI’s as per the requirements.

Project #

Client

Toshiba

Location

Irvine, CA

Role

OBIEE/BI Apps Developer

Duration

Oct 2013 – Jan 2014

Team Size

8

Environment

OBIEE 11g, ODI 11g, Discoverer,BI Apps Financial Module 7.9.6.4,HR Analytics,Spend Analytics

Toshiba implemented Financials and HRMS modules with the source system EBS11i and EBSR12.

BI Apps financial analytics projects on the complete environments and includes with Remediation and implementation of projects on the functional and technical end to end.

Role & Responsibilities:

Analysis of the problem / issue reported on the tool and Suggest solutions.

Interaction with users and seeking information as required for resolving the issue.

Testing new business requirements in the Test Instance and validating the same in Production.

Analysis of the issue reported on the tool and Suggesting solutions.

Involved in creating invoices of type Standard Invoice, Debit Memo, Credit Memo, Invoice, Deposit Invoice, and Guarantee Invoice.

Installed and configured OBIEE 11g, BI Apps 7.9.6.4

Designed and customized OBIEE rpd as per HRMS and Financial modules.

Integrated OBIEE11g, Informatica 901, DAC service components, High availability architecture, custom development.

Implemented Absence, Compensation, HR Performance learning management,

Recruitment, Workforce development, Retention, Workforce profile, AP, AR and GL dashboards.

Created Custom reports based on HRMS module. Validated HRMS and financial reports metrics.

Modified the OBAW schema by adding new Fact for better performance.

Deployed and tested HR and Financial Analytics. Validated all the out-of-the box dashboards and resolved issues in configuration for the reports with errors.

Project #

Client

Cisco

Location

California, CA

Role

OBIEE/OBIA Sr Solution Architect

Duration

Nov 2012 – Oct 2013

Team Size

8

Environment

OBIEE 11g, BI Apps, Informatica, Oracle DB

This project BI implementation is mainly with existing user’s data, developed for reporting purpose of various reports.

Role & Responsibilities:

Actively Interacted with project managers & team members to discuss timely deliverables, project status & documented technical specifications from functional specifications in reporting point.

User requirements identified various fit-gaps on existing Oracle analytics warehouse and developed solutions to meet requirements and loaded the user required data into the OBAW

Involved in developing Project Plan for the future scope of the Financial Analytics project which includes developing learning management and recruitment subject areas from flat files provided by third party vendors using Universal adapters

Involved with Project managers and users to gather KPI's from warehouse for Financial reporting

Administrated BI Environment by debugging identified issues and delivered solutions

Identified Financial Analytics facts, dimensions & star schema models of workforce profile.

Project

Client

Tech Mahindra

Location

Bangalore, India

Role

OBIEE/OBIA Sr Solution Architect & Pre sales Lead

Duration

June 2011 – Oct 2013

Team Size

6

Environment

OBIEE, Essbase, BI Apps, ODI, Exalytics, Golden Gate, Oracle DB

Handling multiple projects within the FMW competency center and providing the project delivery to the different project teams. Implementing the architecture solutions to the different clients on the requirements and giving solutions with POC, RFP, RFI.

Roles & Responsibilities:

Delivering critical solutions at various levels in the field of Project solution.

Development and client interfacing experience and exposure to Pre-Sales activities

Due Diligence including POC, Project Costing, Proposal Making, RFP, and RFI.

Installation, configuration of Exalytics box, OBIEE on Exalytics with TimesTen in-memory DB.

Project

Project Financial Management System

Client

Riyad Bank

Location

Saudi Arabia

Role

OBIEE SME/ Business Analyst – Advisor

Duration

Sep 2010 to Feb 2011.

Team Size

6

Environment

OBIEE 11g, Informatica, SAP BO, Oracle

This Project is implementing for Riyad Bank on the financial transactions and customer segment. It uses the Golden service customer Information system for all financial reports. The system consists of operational features and analytics reports.

Role & Responsibilities:

Collect data change requests and coordinate information gathering to ensure that the data Domain owners have all required information to approve changes.

Facilitate meetings with data users, data stewards and other stakeholders to ensure data governance rules and standards are applied to data related changes/projects

Leading the OBIEE Designing and Implementation team as part of SME role and Advisor to OBIEE Sizing and capacity planning on OBIEE infrastructure.

Project management understanding of project management concepts and ability to perform duties within the construct of a project up to and including leading the project.

Project

Client

Oracle Corporation

Location

Bangalore, India

Role

OBIEE Systems Lead Specialist

Duration

July 2007 – Sep 2010

Team Size

10

Environment

OBIEE, ODI, Informatica, OWB, DAC,Oracle DB

Project ORION and the structure of this program expands into truly revolutionary functionality and into new areas such as Internal Helpdesk (80,000+ users) and potentially, our Product Development Organization (25,000 users). In addition, we expect to add significant partners to the ORION structure as we collaborate with other organizations within Oracle.

Role & Responsibilities:

Involved in completely on Oracle BI servers and applications, setting up the Oracle BI environments for different projects.

Involved working with Development teams on the environmental systems.

Supporting and Maintain the Siebel analytics clients and servers, BI Publisher, DAC, Informatica including Siebel Analytics Applications, and as per agreed service level agreements.

Provide technical/user documentation and training.

Perform peer reviews of work items produced at various stages of the project.

Effectively communicate with various teams and stakeholders, escalate technical and managerial issues at the right time and resolve conflicts.

Project

WW CRM

Client

IBM UK

Location

Bangalore, India

Role

Systems Operations Lead Specialist

Duration

June 2005 – July 2007

Team Size

12

Environment

Siebel Analytics 7.7, Informatica, DAC ETL, IBM DB, AIX

This is Implemented for the IBM internal global customers and supporting at the user level

for the Siebel end users where using the IBM Siebel CRM.

Role & Responsibilities:

Maintaining the Siebel Analytics servers, which includes DAC and Informatica server

Resource planning and work allocation based on skill set of the team member and ensuring service delivery on time, planning technical and process training desired by the team.

Providing Technical Support to Issues related to Opportunity, Service Request, Accounts, Contacts and other Siebel functionality.

Troubleshooting issues related to Workflow, Assignment Manager, Call Center Server Components and other Siebel Object Managers.

Implemented Changes related to Siebel, AIX and DB2 environments Troubleshooting Maintenance Jobs related to Flash copy, ADB Data Mart Extract, SNR ETL Extracts, Audit DB ETL, Backup Jobs

Perform Daily System Health Checks related to AIX, DB2 and Siebel.

Performance tuning the Siebel application and providing recommendations for performance enhancement.

Performing Migration and Staging environment refresh.

Running and troubleshooting EIM loads.

Project Siebel sales & Marketing and Siebel Analytics

Client : Owen Corning Inc

Duration : July 2004 – May 2005

Environment : Siebel 7.5.3 Tools Enterprise Application, Oracle 9i, Win-XP

Role & Responsibilities:

Configuring and working with siebel analytics Answers, Dashboards, Scheduler, delivers and configuring IBOTS and Configure Symbolic URL

Able to configuring Enterprise Integration Manager, running database scripts for Siebel Tools, Repository Management, installing Siebel server software, scheduling and running Siebel server processes

Accountable for User administration such as creating initial user and developer accounts, setting system parameters, establishing mobile clients for front-end developers.

Release and deployment management

Siebel report server administration, Siebel anywhere, Assignment administration Remote Administration and Thin Client Administration.

Project Siebel Sales & Call center

Client: Polar Lens Inc

Duration: Oct 2003 – June 2004

Environment: Siebel 7.0.3 Tools, Oracle 9i,Win 2000

Role & Responsibilities:

Configuring various object definitions based on the technical design document

Customized BO’s, BC’s, Applets, MVG applets, and Screen to match the user requirements.

Creating fields to the existing Business components using custom extension columns in the base table.

Configuring new joins and links to display the required data at the applet level to meet the company’s requirements.

Established Responsibility/Positions and assigned views to various users, based on Visibility

Populated the EIM tables contacts and accounts.

Loading EIM Control files using bad, bat, log files.

Created and customized EIM configuration file (.ifb) run Server tasks and verify the results.

Performing Unit testing, involved in functional testing process.

Project : Siebel Call Center

Client : 121 Insurance Company

Duration : Feb 2003- Sep 2003

Environment: Siebel 7.0.3 Tools, Oracle 9i, Win 2000

Role & Responsibilities:

Configuring various object definitions based on the technical design document.

Customized Business Objects, Business Components, Applets, MVG applets, and Screen to match the user requirements at user interface layer.

Configuring new joins and links to display the required data at the applet level to meet the company’s requirements.

Responsible for configuring different types of applets like Pick List, Multi Value Group, Associate Applet, Standard, List Applet.

Educational Qualifications

Master of Science in Information Technology MSc (IT) 2002-2004.

Certifications & Trainings

Process Management & Project Delivery certifications:

Certified PRINCE2® Foundation & Practitioner Certificate in Project Management

ITIL V3 Certified Professional by EXIN.

Trained with PMCC on PMP PDU’s.

Trained on Agile Scrum Certification

Oracle Certification:

Certified as Oracle BI 10 g foundation specialist.

Certified as Siebel Analytics 7.7 Server Architect Professional (OCP).

Certified as Hyperion BI+ 9.3 System Administrator.

Trained on Exalytics Architecture.

Contact this candidate