SUMMARY

• 3 years experience in Tableau development
• Hands - on experience with both Tableau Desktop and Tableau Server
• Experience in Data Blending, creating Parameters and creating Level Of Detail Expressions
• 8 years experience in OBIEE 10.1.3.4, OBIEE 11.1.1.6.0 , 11.1.1.7.0 , OBIEE 11.1.1.9.0 , OBIEE 12C
• Experience working with BI Publisher in 11g and 12C
• Tableau Developer who possesses over 10 years' experience with Business Intelligence, providing end-to-end business intelligence solutions
• Experience managing DEV, UAT and PROD environments with deployments and unit testing
• Expertise in Oracle BI Server, Oracle BI Answers, BI Scheduler, and Oracle BI Interactive Dashboards
• Experience in interacting with Business users conducting interviews to gather, analyze and document business requirements and excellent oral and written communication skills
• Extensive experience in OBIEE repository (Physical, Business Model and Mapping and Presentation layers) for both Stand-Alone and Integrated OBIEE implementations.
• Proficient in implementing comprehensive Security functionality - creating Application Roles and administering Data and Object level security.

TECHNICAL SKILLS

• Tableau
• OBIEE 10g, 11g and 12C
• BI Publisher (RTF and XML)
• OBIEE Answers
• SQL Developer
• TOAD
• OBI Presentation Services
• OBIEE Admin tool (RPD)

PROFESSIONAL EXPERIENCE

Confidential, Birmingham, AL

Tableau Developer/Analyst

Responsibilities:

• Consulting with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle
• Collaborating with stakeholder groups across the organization to ensure business and technology alignment.
• Proposed solutions meeting defined specifications and needs.
• Working during the whole life cycle of the Tardy and Fraud project from requirements gathering to deployment.
• Identifying and reconciling errors in client data to ensure accurate business requirements.
• Drafting and maintaining business requirements and align them with functional and technical requirements.
• Facilitating monthly meetings with clients to document requirements and explore potential solutions
• Performing quality assurance, system integration and user acceptance testing facilitating on-time, on-budget and acclaimed “go-live” of enterprise implementations.
• Creating stories and dashboards in Tableau using multiple data connections that included Oracle and excel using the blending technique
• Managing large volumes of Data using SQL
• Creating reports and dashboards using facts, attributes, hierarchies, transformations, filters, prompts, calculated fields, sets, groups, and parameters in Tableau.
• Creating effective visualizations based on the type of reports and data being reported.
• Creating Heat Maps to effectively show how data is distributed
• Creating stories so as to identify data trends
• Creating conditional formatting calculations
• Creating complicated calculations like Confidential, Month AGO using parameters to make reports more dynamic
• Creating and maintaining Level of Detail expressions
• Effectively using Actions to link worksheets from one dashboard to another
• Developing story telling dashboards.
• Creating links between dashboards making it easier for users to navigate from one to another
• Publishing workbooks on to Tableau Server making sure the dashboards are posted on the right sites and projects
• Applying security to different projects. Allowing or denying access to different groups and users
• Applying refresh options on workbooks that use extracts as data source
• Modifying existing queries to improvement performance
• Working on JIRAs to fix issues and make report enhancements
• Involved in Agile environment of development
• Educating users of how to navigate reports in Tableau server with the use of filters and links.
• Mentoring self-service developing teams on the best practices on how to develop effective and interactive reports and dashboards
• Performing several demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the Senior Management
• Scheduling tasks, and embedding views in the Tableau Server.
• Always researching on Best Practices and ways to improve performance and visualizations.

Confidential, Tampa, FL

Tableau Developer/Analyst

Responsibilities:

• Gathering and understanding business requirements.
• Developing business architecture using requirements such as scope, processes, alternatives, and risks.
• Analyzing client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis.
• Conduct 5+ levels of testing including functional, regression, user acceptance, integration and performance to verify the client’s needs are met.
• Communicate client’s business requirements by constructing easy-to-understand data and process models.
• Creating Business Requirements Documentation to highlight mappings to data sources and custom column calculations
• Generating various dashboards in Tableau server using multiple sources such as Oracle / Excel
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, and dashboard actions
• Using Data Blending to create relationships between multiple data sources
• Developing effective dashboards in Tableau Desktop
• Creating parameters, calculations, actions links and conditional formatting using Tableau Desktop
• Creating calculated columns using complicated functions like TO DATE and AGO functions
• Effectively using Parameters to make the reports more dynamic
• Using parameters to view a single report using multiple dimensions.
• Creating multiple date options to view one report using parameters e.g. Viewing a report by last 30 days, last twelve months or last 15 weeks
• Creating histograms, pie charts, box plots, scatter plots for inventory management - background maps illustrating the potential revenue change across different geographic markets.
• Using time-series statistics for price variance across different vendors, and using heat maps to show different activities across business units.
• Publishing dashboards on to Tableau Server, and providing users with quick filters to easily access and manipulate information
• Implementing Tableau Mobile to help those users who are always travelling and don’t have access to the system
• Creating and maintaining Level of Detail Expressions
• Publishing stories to server considering the site and projects being used
• Applying security to different projects
• Applying User Filters to restrict or grant permission to appropriate users
• Creating schedules on the server on when to refresh data especially data from extracts
• Building SQL automations helping in improving data processing speeds
• Modifying existing SQL queries to improve performance
• Creating Functional Specification Documentation (FSD) to show what I worked on and what I used to create the Worksheets, Dashboards and Stories

Confidential, Des Moines, IA

OBIEE & BIP Developer/Analyst

Responsibilities:

• Working during the whole life cycle of the Tardy and Fraud project from requirements gathering to deployment.
• Working with DBAs and Project Manager to gather design requirements, create and review technical design documents based on the business requirements.
• Going through the BRD (Business Requirements Document) with the Project Manager, Business Analyst, DBA, ETL specialist and the users
• Preparing the FSD (Functional System Design) together with the DBAs.
• Recommending and developing reports for validation of data using the PeopleSoft query tool and SQL query.
• Using PeopleSoft as a data source creating Tardy reports that showed when employees clocked in for work, how may breaks they are taking and how many hours they are working in total.
• Working in an Agile development process
• Developing metadata repository and configuring metadata objects in all three layers using Oracle BI Administration tool.
• Analyzing the data and developing Logical Star Schema model in the Physical Layer
• Employing best practices while deploying and maintaining RPD
• Migrations of Web Catalog objects Dashboard, Pages, Folders, Reports from DEV to UAT and UAT to Prod
• Managing and maintaining the web catalogue
• Working closely with developers to make sure Change Requests are submitted on time and all deadlines are met.
• Maintaining data level and object level security.
• Update and upgrade the OBIEE platform to customize the system as per needs
• Install and configure OBIEE tools across multiple tools and versions
• Research and remain abreast with latest technologies and techniques to recommend new changes or upgrades
• Involved in PL/SQL Performance tuning when reports ran slow.
• Working with the DBA to figure out if we needed to create indexes, aggregate or partition the columns to increase the processing time of our reports
• Developing test cases and performing Unit Testing and Integration Testing of the Repository and Web Catalogs
• Creating detailed design documentation, configuration documentation, and unit test plans. Execute and track test plans through the development life cycle
• Experience working with variables defining session and repository variables and initialization blocks to streamline administrative tasks
• Modeling the data in the BMM Layer. Creating hierarchies, Time series functions, calculated columns, level based measures and column source mappings.
• Creating and customizing presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Designing complicated reports in Answers.
• One of the requirements for the project was to have Managers only see their agents.
• To achieve this result I had to use a session variable that limited Managers access using their ID.
• Using different and efficient report building techniques like guided navigation, view selectors, column selectors and session variables.
• Enabling drill through and drill down.
• Developing KPIs and scorecards
• Creating links between dashboard pages using the action link and link or image options
• Validating data in SQL Developer to ensure that reports were consistent
• Creating, scheduling and maintaining Agents/iBots in Oracle BI Deliveries
• Regular meetings with users and Business Analyst working on data issues, report issues and enhancements
• Responsible for working on open tickets/JIRAs and making sure that the issues are resolved in a timely manner.
• Providing guidance and support to end users during the implementation and in production
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Confidential, Dallas, TX

Tableau and BIP Developer

Responsibilities:

• Performing requirements gathering, analysis, scope and time estimation of ETLs, reports and dashboards
• Creating Business Requirements Documentation and going through gap analysis with the users and developers
• Providing input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.
• Liaise between business and technical personnel to ensure a mutual understanding of processes and applications.
• Going through Functional System Design document to make sure business needs are met and addressed
• Developing Tableau reports that provide clear visualizations of various industry-specific KPIs.
• Creating Ad-hoc reports for users in Tableau using various data sources.
• Developing Tableau workbooks from multiple data sources using Data Blending.
• Managing data blending calculations to avoid getting nulls when measures are combined.
• Creating stories and dashboards in Tableau Desktop
• Creating reports that analyzed the data using Statistical features in Tableau to develop trend analysis
• Creating actions, parameters, Filter Local, Global, hierarchies and calculated sets for dashboards and worksheets using Tableau Desktop
• Developed Tableau workbooks to perform year over year, quarter over quarter, Confidential, QTD and MTD type of analysis
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
• Creating Tableau Dashboards with interactive views, trends and drill downs along with user level security
• Working with End users to ensure BI Publisher reports meet Business requirements
• Working in an Agile development process
• Creating and maintaining hierarchies, setting aggregation rules, and setting up and managing security in the RPD
• Configuring BI Publisher delivery options like creating Bursting definitions and Parameters
• Creating BI Publisher reports using Rich Text Format templates as well as Excel Templates and sending those reports to users using bursting definitions
• Linking BI Publisher reports with Analytics dashboards and use Dashboard Prompt to run BIP Reports
• Developing Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, View Selector and prompts using Oracle BI Presentation Services.
• Developing KPIs and scorecards
• Demonstrating expertise in Oracle BI Server, Oracle BI Answers, Oracle BI Interactive Dashboard, Oracle BI Publisher, and Oracle BI Delivers.
• Configuring the rpd and answers for Ad Hoc reporting
• Creating and maintaining dashboards using different design styles like, linking dashboards, linking dashboard pages, using appropriate prompts on different pages.
• Defining and creating Initialization Blocks, Repository and Session Variables for generating filters and defining security
• Experience in developing dimensional Hierarchies, and level based measures
• Creating, scheduling and maintaining Agents/iBots in Oracle BI Deliveries

Confidential, Houston, TX

OBIEE & BIP Developer/Administrator

Responsibilities:

• Preparing time estimates and justifications for assigned tasks and provide recommendations to project managers
• Meeting with the finance people to discuss what type of reports they needed to improve their day to day operations as well as creating promotional financial reports for different phases.
• Collaborating with Users and Project Manager discussing and identifying the analytics requirements to be obtained from various user groups based on the original specs
• Working with PeopleSoft FIN and HCM as the data source. Collaborating with Human Resources and technical departments to create budget reports for FTEs.
• Acting as the liaison between the users and the Human Resources dept. as well as the Finance team
• Converting and using Oracle pre-build Rpd’s(Financial, HR, Sales, Supply Chain, Order Management, Marketing Analytics, etc.) according to business requirements
• Effectively using Oracle Supply Chain Analytics enabling users to assess inventory levels, product fulfillment needs, and quickly identify potential order backlog issues.
• Effectively using Financial Analytics to help front-line managers improve financial performance with complete, up-to-the-minute information on their departments' expenses and revenue contributions.
• Building/customizing ETLs from Source Systems such as PeopleSoft, EBS to Data Warehouse
• Creating/modifying metadata repository using the OBIEE 11g's Physical, Business Model and Mapping and Presentation Layers. Merging and configuring RPDs
• Deploying and maintaining the RPD while employing the best practices
• Experience with WebLogic server and Enterprise manager in OBIEE 11g
• Update and upgrade the OBIEE platform to customize the system as per needs
• Install and configure OBIEE tools across multiple tools and versions
• Implementing security by creating roles and web groups in Console and Enterprise Manager, and defining Object Level and Data Level Security.
• Configuring LDAP authentication in Weblogic and maintaining user logins and permissions through external Database
• Research and remain abreast with latest technologies and techniques to recommend new changes or upgrades
• Migrations of Web Catalog objects Dashboard, Pages, Folders, Reports from DEV to UAT and UAT to Prod
• Managing and maintaining the web catalogue
• Maintaining data level and object level security. Involved in PL/SQL Performance tuning when reports ran slow.
• Working with the DBA to figure out if we needed to create indexes, aggregate or partition the columns to increase the processing time of our reports Creating star schemas in the repository.
• Using the foreign key link in the physical layer and the new complex join key in the Business Model and Mapping layer to form relationships between fact and dimensional tables.
• Creating and maintaining hierarchies, setting aggregation rules, and setting up and managing security in the RPD
• Setting up security to authenticate users and grant permissions and privileges to appropriate users thus facilitating efficient web use in a large environment.
• Fixing issues with the reports by redoing calculations, fixing report prompts, fixing BI Publisher PDFs, remapping columns in the rpd.
• Involved in the process of re-launching production.
• Upgrading from DEV to Stage and have a few users test the reports then from Stage to PROD
• Getting feedback from the testers and logging them in SharePoint
• Addressing and fixing issues coming from JIRAs
• Creating BI Publisher reports using Rich Text Format templates as well as Excel Templates
• Testing and validating reports before migrating them to Production for the users to access.
• Running ETL jobs every night. Making sure tables and columns are updated. If jobs fails making sure the problem is looked into and fixes or changes are made.

Confidential, Philadelphia, PA

OBIEE & BIP Developer/Administrator

Responsibilities:

• Upgrading from 10g to 11g using Upgrading Assistant
• Tuning performance by recommending indexing, aggregation or partitioning to the DBAs
• Involved in Analysis, Requirement gathering, function/technical specification, development, deploying and testing.
• Installing, upgrading, patching and configuring all components of OBIEE on Development, Test and Production server
• Designing and implementing data in various layers including physical, business and presentation.
• Having Very good Understanding of the business requirements and Transforming the requirements into subject areas
• Working with the Security settings in Oracle Business Administration Tool to set up users, groups, access privileges.
• Developing reports and dashboards with various analytical views with Global and Local Filters. Trained End Users to Build Ad Hoc Reports using OBIEE.
• Building reports using Analyses including drilldown objects, union based reports, formatting and functions within the reports, dashboards, filters, and prompts.
• Excessively working on BI Publisher and proficient with BI Publisher/XML reports using various templates to publish the reports as per user requirements

Confidential, Lewisville, TX

OBIEE Developer

Responsibilities:

• Worked with Business analysts as well as other business teams on requirement gathering.
• Identified Facts and Dimensions according to the design specification.
• Implemented complex requirements like Dimension hierarchies, time comparisons and share measures along with rank measures.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures.
• Implemented logical column measures and calculations with well expertise in the Business Model and Mapping layer.
• Implemented caching and aggregate table techniques to improve the performance.
• Created, modified and formatted requests, along with charts and filters, in OBIEE Answers.
• Expertise in database Performance Tuning by implementing Parallel Execution,
• Partitions, materialized views, creating appropriate indexes, usage of hints, re-building indexes, Explain Plan and SQL Tracing.

Confidential, Richardson, TX

OBIEE Developer

Responsibilities:

• Requirements gathering from users through meetings, understanding business model and end user/ executive objectives.
• Creating connection pools, physical tables and defined Primary key, foreign key joins, complex joins in the physical layer of the repository.
• Also Created Alias tables and deployed opaque views at the database level as necessary.
• Creating and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Working on OBIEE Answers to create the reports as per the client requirements (including compound views, table, charts)
• Involved in creating and documenting Test Plan and Test Cases in Quality Center.
• Maintaining document repository on SharePoint to ensure that any change to the systems documents is communicated effectively to the entire team and business users in a timely manner.