Tableau Data

Harika Aswadhati

Email Id: *****************@*****.***

Contact: 832-***-****

SUMMARY:

Responsible and highly motivated professional with 7+ years of experience in Tableau, OBIEE, Informatica, PL/SQL programming.

Expertise in complete SDLC analysis, design, development, maintenance and documentation of various functionalities of data warehouses and data marts.

Expertise in designing Star Schema/ Snowflake Schema methodologies, data analysis, requirement's gathering, gap analysis, creating technical design documents and identifying slowly changing dimensions.

Good Knowledge in Developing BI Reports using Tableau desktop 10.2/9.1, Tableau Server, OBIEE 12C/11G and SSRS.

Good Knowledge on Cognos, QlikView, Power BI.

Expertise in creating, modifying and administering BI Intelligence Dashboards.

Expertise in configuring Interactive Dashboards with drill-down capabilities using global and local Filters.

Mastered the ability to design and deploy rich Graphic visualizations using BI Reporting tool suites.

Expertise in performance tuning by implementing cache management and aggregate navigation techniques.

Implementing Database tuning as well.

Work with the other IT groups such as Infrastructure, Networks, Web Application Development to design BI solutions for internal and external use.

Experience with utilizing scripting languages to leverage Tableau's APIs.

Experience in developing tableau worksheets, workbooks by using complex measures to perform data analysis and reporting.

Expertise in conducting performance tuning of tableau worksheets and workbooks.

Involved in training end users on ad-hoc tableau queries.

Extensive experience in developing BI Publisher Reports.

Experience in the ADMIN tasks of the OBIEE 12c and OBIEE 11g. Starting and Stopping the services, migrating the RPD and catalog, creating the application roles and groups in the enterprise manager, changing the config files as per the needs, reading the log files and debugging when necessary.

Extensive experience in customizing RPD and Web catalog of OOTB Implementation of various OBI Applications like Financial Analytics.

Developed data visualizations using BI reporting tools.

Expertise in debugging and optimizing the BI Dashboards / Reports and Informatica Mappings / Workflows.

Good Understanding about ODI Architecture.

Well versed with using SQL and PL/SQL for BI Publisher.

Proficient with BI Publisher reports and using various templates to publish the reports as per user requirements.

Experience in troubleshooting Complex SQL queries and improve data delivery performance.

Extensively used Informatica Power Center for Extract, Transform and Loading of data from multiple data sources to Data Warehouse and creating various mappings, sessions and Workflows.

Working knowledge on different data sources ranging from flat files, Teradata, Oracle, SQL Server, DB2 databases and Sybase.

Expertise in Essbase cube analysis, design and maintenance, performance tuning and optimization on Windows environment.

Created Ad-Hoc Facility and trained business users in getting familiar with BI tools in developing the reports.

Create unit test reports for new and existing BI systems this includes the implementation of any ad-hoc reporting tool solutions.

Excellent communication skills, ability to meet tight deadlines and prioritize tasks.

Experience on Production support.

Expertise in Documentation.

TECHNICAL PROFICIENCIES:

OLAP/BI Tools: Tableau Desktop 10.2/9.1, Tableau Server, SSRS, OBIEE 12C/11g/10g,

Power BI, OBIEE Publisher 10.1.3.4/11.1.1.5.

ETL Tools: Informatica Power Center 9.1/8.1.1/7.1.2, DAC 10g/11g.

RDBMS: Oracle 9i/10g/11g/12c, SQL Server 2000/2005.

Languages: PL/SQL, SQL.

EDUCATION DETAILS

Masters in Computer Science, UHCL, August 2013

Bachelors in Computer Science, JNTU Kakinada, 2011

PROFESSIONAL WORK EXPERIENCE:

State University of New York (SUNY), Albany, NY July2017 – till date

BI Developer

Responsibilities:

Worked on all phases of Data Warehouse Lifecycles, ETL design and implementation to assist new and existing applications.

Complete application design, code, unit test and integration test tasks adhering to design/development standards within agreed time frames.

Gathered business requirement from the business users for converting the reports from Oracle discover desktop version to BI reporting suites.

Analyze the data on the existing excel sheets to graphically visualize the report on Tableau Desktop meeting the business requirements.

Developed many BI Dashboards/Reports for providing analytical information.

Prepared the dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies on Tableau.

Designed, Developed, tested and maintained Tableau Functional Reports Based in User Requirements.

Developed Tableau data visualization using Cross tabs, Heat maps, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.

Created Ad-Hoc Facility and trained business users in getting familiar with BI tools in developing the reports.

Active participation in review meetings with the project manager, collaborating with the team mates and cross- functional team to ensure that the development of projects meets business and system requirements to design, develop, test and monitor production roll-over of reports on Tableau Desktop Environment.

Converted Oracle discover desktop version reports to OBIEE Dashboards and Implemented Object level and data level security.

Scheduled IBots/Agents to deliver the weekly and quarterly reports to deliver to users email.

Created Opaque views and PLSQL views.

Performed Tableau Admin duties that compromises configuration, adding users, groups, managing licenses, data connections and scheduling tasks in Tableau Server.

Involve in the research of the new tools, Tableau extensions and introducing new features to the organization which enhances the project hence meeting the client requirements.

Monitored the scheduled data refresh and live connections on Tableau server for daily, monthly and quarterly increments based on the business change to ensure that the views and dashboards display the changed data accurately.

Upgrading the Tableau Desktop environment version from Tableau Desktop 2018.1 to Tableau Desktop 2019.3 also installation of Tableau tools and maintenance.

Create unit test reports for new and existing BI systems this includes the implementation of any ad-hoc reporting tool solutions.

User Java Script API to customize the views, selects, filters, date and time.

Developed client side validation code using JavaScript and JQUERY.

Production, preparation and execution of unit test plans

Document test plans and complete Unit Testing of development objects and reports.

Train end-users on the developed solutions and additional capabilities that the tools provide including ad-hoc and multidimensional analysis.

Developed PLSQL Procedures.

Developed PLSQL Views.

Scheduled IBots/Agents to deliver the weekly and quarterly reports to deliver to users email.

Expertize in Creating the Reports with different Views and Drill Downs to provide the full student expenses in the reports and also seamless navigation capability to business users.

Customized BI Visualizations according to the client requirements.

Involved in various training sessions on Power BI.

Environment: Tableau Desktop 9.1.1, Tableau Server, OBIEE 12C, Power BI, Oracle Discover Desktop, PLSQL.

TIAA-CREF, Charlotte, NC April 2014 – June 2017

BI Developer

Responsibilities:

Involved in Upgrading to OBIEE 12C and tested with various financial analytics applications.

Involved in requirements gathering, design, application development and deployment to server.

Built the Physical layer/Business Model and Mapping Layer/Presentation Layer of a Repository by using Star Schemas.

Participated in Adding Calculations to a Fact Table for various reporting requirements.

Created Dimension Hierarchies and Level-Based Measures for Business requirements.

Used Aggregate Tables and specified Aggregate Levels for each source.

Scheduled IBots/Agents to deliver the reports for specific devices and seeded server cache using Delivers to improve system performance.

Customized BI Visualizations according to the client requirements.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Developed dashboards using OBIEE and Tableau Desktop.

Maintain and develop effective actuarial reports using BI Tools.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.

Worked with Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.

Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail of level summary report and Dashboard using KPI's.

Exclusively Involved in Unit Testing, Peer Testing & Regression Testing and managed defect resolution processed during the test phases of the new integrated implementation.

Expertise in Creating the BI Reports with different Views and Drill Downs to provide the full Expenses in the reports and also seamless navigation capability to business users.

Worked on Exadata, Exalytics to improve the performance of the reports.

Involved in Performance Tuning of reports, created bitmap Indexes, Materialized Views and Table Partitions.

Performed ETL procedure to load data from different sources into data- warehouse using Power Center (Informatica 9.1), Repository Manager, Designer, and Workflow Manager.

Created the AP, GL Reports to provide the expense data from the data sources like People Soft, FDW.

Created session variables for users to provide row- level (data level) security.

Created BI Dashboards to implement the data level security using the budget code Hierarchy.

Extensively used write back, solution for insert and update in database.

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

Developed Tableau workbooks from multiple data sources using Data Blending.

Provided production support for Tableau users.

Work Experience on Scheduling the Data loads Using DAC.

Have experience in data Extraction, Loading and Transformation in data ware house

Environment.

Used Oracle Data Integrator Designer (ODI) to develop processes for data Extraction, Loading and Transformation into Data Warehouses.

Good Understanding about ODI Architecture.

Trained business users in getting familiar with BI Tools in developing the reports.

Worked extensively using the Aggregate Persistence Wizard to create customized aggregates to improve the performance of the reports being generated.

Create and unit test reports for new and existing BI systems this includes the implementation of any ad-hoc reporting tool solutions.

Production, preparation and execution of unit test plans.

Document test plans and complete Unit Testing of development objects and reports.

Work with Quality Assurance business resources to complete System and Integration testing.

Written design documents like Technical Design, Report Design, Unit Test Cases.

Create reports using Oracle BI publisher.

Involved in production deployments and supported in some major go-lives’ for Various Projects.

Migrated the catalog objects to higher Environments

Hands on Experience in various Deployments.

Expertise in Documentation (Technical Design Document, Report Design Document).

Environment: Tableau Desktop 10.2, Tableau Server, OBIEE 11.1.1.6/11.1.1.7/12C, Informatica 9.1, DAC, BI Publisher, SQL, ODI

CITI Bank Warren, NJ Jan 2013 – March 2014

BI Developer

Responsibilities:

Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.

Implemented permissions for users and ensure user security according to various clearance levels of business users.

Scheduled reports and ensured users were informed with each dashboard refresh

Mentored business power users to create reports/dashboards using tableau desktop.

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in tableau Desktop.

Utilized advance features of tableau software like to link data from different data sources together on one dashboard to filter data in multiple views.

Involved in new KPI generation for Scorecards.

Data collection and leveraging on data manipulation teams for required data.

Developed complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.

Set Up Row level security on Tableau dashboards

Responsible for creating reports using Tableau desktop and publishing reports to Tableau server

Enabled tableau Actions to drill down from Dashboard to worksheet.

Extensive experience on creating trend reports including forecast and trend lines.

Configured incremental data refresh for the data sources.

Designed filters, power prompts, and complex financial calculations for various analytical reports.

Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.

Created Filled maps, actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.

Effectively used data blending, quick filters, actions, hierarchies' features in tableau.

Executed and tested required queries and reports before publishing.

Converted Metric insight reports to tableau reports.

Analyzed the data using statistical features in tableau to develop Trend Analysis reports.

Experience in assisting users in creating and modifying worksheets and data visualization dashboards.

Environment: Tableau Desktop 9.0, Tableau Server, SQL Server 2008/2012, Info view, Windows 2008 Server.

Contact this candidate