SUMMARY

• Seasoned Business Intelligence Professional having around 8 Years of IT experience in analysis, design, development, integration, documentation, testing, implementation, maintaining enterprise BI applications wif Tabelau, Qlikview along wif strong database development.
• Around 5 Years of extensiveTableauexperience in Enterprise Environment, usingTableau8.0, 8.1.6, 8.2, 9.0 and 9.2,10.x as anAdmin, Developer and Analyst.
• Extensive experience in Installation, configuration, upgrade (Single Server and multi - server), Patching and administration ofTableauDesktop/Server.
• Experience in creating teh Groups, Sites, Projects, schedules and assigning teh schedules to teh work books, Tableau Extracts, Subscriptions inTableauserver.
• Experience in configuring teh Active directory and SAML for Single Sign on, assigning teh roles to teh users, assigning teh users to teh groups, sites, Projects based on teh security privileges.
• Experience in using Tabadminand Tabcmd commands in taking and restoring backups of Tableaurepository.
• Experience in creating highly interactive Data visualization views and Dashboards using features such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures, Trend lines, Statistics, Binning teh measures, Hierarchies (For Drill up and Drill Down) in Tableau Desktop.
• Expertise in development of various dashboards, views using variousTableau Visualizations like Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Dimensional maps, Geographic Visualization, Histograms and other making use of actions, other local and global filters according to teh requirements.
• Proficient in creating Calculations (String, Logical, Date, Number, Table, LOD Expressions) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) usingTableauDesktop.
• Extensively Used Data Blending to Join Multiple Data Sources and Rendering teh data into visualization inTableau.
• Expertise in using Dual Axes, Blended Axis and Individual Axes for comparing different measures on teh same view in tableau Desktop.
• Created complex statistical and financial reports, trend over time reports, ranking, and forecast reports, Executive Dashboards, Tabbed views using Tableau Desktop.
• Working experience wif different customized date functions like YearToDate, QuarterToDate, MonthToDate in Tableau by using teh date calculations and parameter
• Expertise in developing teh rich interactive dashboards by using dashboard actions (Filter, Highlight, URL) and formatting teh dashboard using teh Layout Containers, Images, Web links, Tiled Objects and Rich Text Formatting.
• Used Worksheet Actions for navigating, Drill through from Summary View to teh detail view in teh same worksheet in Tableau.
• Produced attractive visualizations/dashboards to convey teh Tableau story inside teh data which allows teh business users to understand teh data.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues wifinTableau
• Design and Develop Strategic/Proof of Concept (POC) dashboards using Tableau and Qlikview.
• Developed Cognos Dashboards using Cognos Report studio and published them to cognos portal.
• Documenting teh entire Life cycle of teh Tableau Project (Business Requirement documents, Design documents, Test cases, Change Points)
• Created test plans, test objectives, test strategies and test cases in teh QA testing phase.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD
• Worked in Agile way and JIRA environment.
• Extensively involved in Demos, Presentations, Meetings and Interaction wif Senior Management.

TECHNICAL SKILLS

BI Tools: Tableau8.0, 8.1.6, 8.2, 9.0, 9.2 (Desktop, Server, Online, Reader, Public, Mobile) Cognos 10 (Framework Manager, Report Studio, Query Studio, Analysis Studio) Qlikview 10 Desktop, QlikSense 1, Microsoft Power BI

Databases: Oracle 9i/10i/11g, SQL server (2008/2014), DB2, Teradata, MS Access, Sybase

Web Servers: Microsoft Internet Information Server (IIS) 4.0/5.0/5.1/6.0, Apache Tomcat Server 4.1/5.5.

LDAP Servers: Active Directory, Sun One Directory, Apache Directory.

Programming skills: C, C++, HTML, Visual basic, SQL, PL/SQL, UNIX shell scripting

Microsoft Tools: MS Excel/Word/PowerPoint/Access, Visio, Outlook.

Operating Systems: Windows, UNIX (AIX, Solaris), Linux

Others: TOAD, Erwin, AutoCAD, Hadoop, Apache Spark

PROFESSIONAL EXPERIENCE

Confidential, Raleigh NC

Sr. Tableau Developer/Admin

Responsibilities:

• Involved in teh entire project life cycle from evaluation, installation and development of end user reports using Tableau.
• Interacted wif teh Business users and documented their Query, Business and Reporting needs and Analyzed teh data and business logic underlying teh requirement.
• Installation of Tableau server on Single Server in Dev, QA and Distributive environment (Installing Primary and Worker Nodes) for scalability and to improve teh performance in teh production.
• Configured Active directory as Autantication source and SMTP server for email alerts about teh health of teh system and subscriptions.
• Assigned License levels to teh end users and added teh users to teh groups and sites based on teh business needs.
• Create groups, sites (for multi tenancy) in tableau admin console
• Assigned permissions to teh workbooks and projects in teh individual sites.
• Created, teh Customized schedules, assigned/modified teh schedules to teh workbooks and tableau data extracts, Subscriptions.
• Used Tabadmin commands for backing up and restoring teh server.
• Used Alteryx for modeling of teh Data Model and creating teh Tableau Data Extracts (.TDE) files.
• Created Aggregated Extracts from teh Oracle database/Alteryx and published, scheduled teh Extracts on teh Tableau Server
• Developed dashboards based onTableauServer's PostgreSQL database to monitor dashboard usage, subscriptions and refresh status.
• Developed several Worksheets, Views, Dashboards, and Visualizations by using several tableau calculations, filters, calculated fields, Level of Detail Expressions, Actions, Trend Lines, Forecasting, Hierarchies, Groups and calculated dynamic sets.
• Developed several worksheets using Bar, Line, Pie, Maps Charts and Highlight Tables, Scatter Plots for rich visualizations and for analyzing teh data.
• Used Dual Axes, Blended Axes for comparing different measures on teh same View/Sheet.
• Developed Summary Dashboard for Actuals Requirements, Receipts for departments over a Period of Time.
• Create sheet using table calculations (Running Sum, Moving Sum) to compare teh actual Spending for each account and leftover money for teh account for a specific period.
• UtilizedTableauvisual analytics and best practices like Dashboard structure (Layout Components, Tiled and Floating objects), view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
• Developed Dynamic Dashboards to navigate from Summary to different detail dashboards/Sheets using action filters and by creating teh sheet filters.
• Developed Top 10 spending accounts by Year, by Committee and Budget Reporting Units by using Context Filters
• Extensively used LOD (Fixed) Expressions to calculate teh percentage of teh spending for Budget Reporting Unit wifin teh department.
• Highlighted teh measures in teh same view using advanced conditional formatting
• Developed Score Cards using KPI’s (Key Performance Indicators) for teh allotment amounts of teh yearly budget cycle.
• Created dynamic Dashboards using teh Parametrized sheet selector for rendering different sheets and comparison of different measures.
• Used detail filters and context filters to limit teh data dat is to be viewed in teh sheet and dashboards based on teh business logic.
• Used User Filters to perform teh Row Level Security in Tableau
• Used Data blending, combined fields, custom calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives
• Created and used Parameters for dynamic calculations and Custom sets based on teh conditions.
• Developed Maps views for teh demographic data to analyze and forecast teh revenues.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer
• Performed Advanced Sorting of teh visualizations by using teh Calculated Measures and Parameters.
• Customized teh tooltips and labels, to user understandable format, teh numerical measure was changed to its appropriate formats like representing teh revenue, expenses and appropriation amounts.
• Utilized teh Pages cards to create animated visualizations to understand teh Appropriation, Change in Fund Balance wif respect to Allotments over time.
• Utilized Reference lines and Table Calculation (WINDOW AVG, WINDOW SUM across Pane) to set a Benchmark for over spending teh budget wifin each department.
• Extensively used LOD and Nested LOD functions in teh Visualizations.
• Converted Cognos Workspace Dashboards to Tableau
• Coordinated wif functional users for User Acceptance Testing prior to releasing system changes in production
• Assisted Quality Assurance Team in documenting and analyzing their current process and tan make recommendations for improvements in their functional areas
• Created documentation for teh complete project life cycle and mentored teh End Users and Provided teh Technical Support.
• Trained teh end users to TEMPeffectively use teh Tableau tool to build and customize their ad-hoc reports.

Environment: Tableau 9.1/9.2.2/10 (Desktop, Server), Oracle 11g, MS Access, Toad, Excel, Windows 7, Windows 2012R2

Confidential, High Point NC

Sr. Tableau Developer/Analyst/Admin

Responsibilities:

• Involved in teh Requirements gathering, analyzing, and documenting business requirements and data specifications
• Evaluated annual credit reviews for a portion of BNA Bank’s portfolio and developed Tableau rich data visualizations against analyzed data to Credit Committee for appropriate credit risk rating decisions.
• Installation of Tableau Server on Development, Quality Assurance and Production environment.
• Developed, publishing customized interactive reports and dashboards, Scheduled using Tableau server. Creating new schedules and monitoring teh tasks daily on teh server.
• Created Users, Groups, and Projects, assigned teh security based on teh License Levels.
• Created and Scheduled Data extracts (.tde) on teh server and maintained Data source Connections
• Utilized Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Developed Tableau visualizations using dynamic sets, Parameters, Advanced Calculated Fields, Dynamic sorting, Filtering, Table Calculations, Parameter driven analysis.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Developed several Visualizations using Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps, Text Tables, Highlight Tables for analyzing teh data
• Extensively developed worksheets by changing teh Measures, Dates to discrete and continuous based on teh visualization needs
• Used Individual Axes, Blended Axes, and Dual Axes to compare different measures.
• Created Dynamic Groups by using advanced logical calculations, String Calculations.
• Finely control mark properties including showing multiple fields on labels. Added rich text formatting to annotations, titles, captions, and tooltips.
• Utilized several dashboard objects Vertical Panes, Horizontal Panes, Blank, Tiled, Floating, Text, Web-page, Image in order to create efficient dashboard usingtableaudesktop
• Extensively used Data source Filters, Advance filters (Conditional, Top N) by formula and by field, Context filters, Cascading Filters to limit teh data dat is to be rendered in teh sheet.
• Customized teh Quick Filters by enabling/disabling different Filter types, Include/Exclude, All Values.
• Created Hierarchies for Drill-Drill Down (Expand/Collapse) behavior of dimensions when analyzing teh measures
• Created Bins for distributing of teh data.
• Utilized user filters to implement teh row level security in Tableau to define data access restrictions for user
• Created Aggregations, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure
• Extensively used Table Calculations (WINDOW AVG, WINDOW SUM, RUNNING SUM, RUNNING AVG, FIRST, LAST, LOOKUP) for creating teh advanced calculated fields dat are used in defining teh Reference lines, Bands across teh Pane, Table and cells in teh visualization.
• Extensively used Fixed LOD Level of Detail Expressions for daily trend of total customer acquisition
• Utilized Dashboard Actions to develop highly interactive Dashboards by Filtering, Highlighting target visualizations from teh source wifin or other Dashboards.
• Creating Worksheet actions to Filter or Highlight or navigate to teh Target Sheets from teh Source Sheets.
• Implemented best practices for better performance of teh Dashboards and sheets.
• PerformedTableaudashboard performance recording and tuned layout and queries accordingly.
• Managed performance and tuning of SQL queries and fixed teh slow running queries in production wif utilities like Trace, Stored Outlines.
• Resolved issues resulting from User Acceptance Testing (UAT).
• Provided teh Documentation and tutored teh End Users how to Use Different types

Environment: Tableau 9.0 (Desktop, Server), MS SQL Server 2008, DB2, Toad, Excel, Windows 7, Windows 2008, Excel Files, Erwin

Confidential, St Louis, MO

Tableau Developer

Responsibilities:

• Interacted wif Business Analyst and teh Business users to understand teh user requirements, layout, and look and feel of teh application to be developed
• Designed and developed a business intelligence dashboards usingTableauDesktop, allowing executive management to view past, current and forecast Insurance Sales data
• CreatedTableausheets, Score cards, dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box, Whisker Plot, Stacked Bar, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts for making teh decisions on.
• Developed Tableauvisualizations, Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
• Applied various types of filters such as data source filters, quick filters and context filters.
• Generatedtableaudashboards wif forecast and reference lines, bands.
• Used Dual Axes, Blended Axes and individual Axes for comparing teh Measures.
• Implemented data blending and joins to work wif data from multiple databases in a single view.
• Used detail filters and context filters to limit teh data dat is to be viewed in teh sheet and dashboards based on teh business logic.
• Created different parameters to be used in Calculations, filters, Sets and reference lines
• Used LOD Expression to display teh each state contribution to teh global sales.
• Creating Worksheet actions to Filter or Highlight or navigate to teh Target Sheets from teh Source Sheets.
• Convert business requirements into story-telling viz by developing dashboards inTableauDesktop and publish them toTableauServer allowing end-users to control data and filter down further as desired.
• Extensively used analytical features inTableaulike Statistical functions, reference lines, trend lines, forecasting intableauworksheets.
• DevelopedTableauworkbooks to perform custom YTD, QTD and MTD type of analysis based on selected date
• Worked on Drill down, Drill up analysis, custom hierarchies usingtableaudesktop.
• Created Ad hoc worksheets from teh given data.
• Utilized several dashboard objects Vertical Panes, Horizontal Panes, Blank, Tiled, Floating, Text, Web-page, Image in order to create efficient dashboard usingtableaudesktop
• Utilized Dashboard Actions to develop highly interactive Dashboards by Filtering, Highlighting target visualizations from teh source wifin or other Dashboards.
• Created guided navigation links wifin Interactive Dashboards to navigate from one Dashboard to other.
• Involved in performance tuning fortableauDashboards.
• Blended data using multiple data sources (flat files and relational tables)
• Wrote custom SQL wifinTableauto support non-standard functionality requirements.
• Published workbooks, dashboards and data sources toTableauServer.
• PerformedTableaudashboard performance recording and tuned layout and queries accordingly.
• Assisted Quality Assurance Team in documenting and analyzing their current process and tan make recommendations for improvements in their functional areas
• Created documentation for teh complete project life cycle and mentored teh End Users and Provided teh Technical Support
• Coordinated wif functional users for User Acceptance Testing prior to releasing system changes in production

Environment: Tableau 7.0.2 (Desktop, Server), MAPR Hive, Oracle 10g, SQL Developer, Excel, Windows 7, Windows 2003 R2, MS Access.

Confidential

QlikView Developer/BI Consultant

Responsibilities:

• Extracted teh data from various data sources such as databases, CSV files, and Excel documents transforming teh data into standard format (QVDs) and load teh data so dat it is available for analyzing and creating reports.
• Designed Schema using dimensions, fact, logical, physical, alias and extension tables.
• Developed QlikView scripts to load teh transformations and make enhancements to teh user interface of teh desktop application.
• Installed and configured QlikView 9.0. Assisted in upgrading from QlikView 8.2 to version 9.0.
• Application processed tables wif over 10 million records. Experience in scripting QlikView Set Analysis and Macros.
• Eliminated synthetic keys using QVD concatenation and by renaming teh fields.
• Wrote scripts and created batch files for automatic running of QlikView scripts.
• Converted teh huge tables into multiple QVDs, so dat only teh recent ones needed to be refreshed for data accuracy.
• Designed user interface and prepared layouts for teh system using QlikView.
• Involved in teh developing of star schema and snow flex schema dimensional data model.
• Used MS Access and QlikView extensively as reporting tools and to create user build specifications and customized QlikView reports to interact wif Hyperion IR.

Environment: QlikView, Oracle 10g, PL/SQL, SQL*Plus, SQL Developer, MS Access.

Confidential

PL/SQL Developer

Responsibilities:

• Extensively used PL/SQL Developer for creating database objects, running teh command scripts for inserting teh configuration data items.
• Designed Web-based Internet applications linked to firm-wide SQL databases.
• Creating and debugging of packages and procedures and functions and troubleshoot jobs using teh debugging tool.
• Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
• Involved in analysis, coding, testing and Implementation of various modules and reverse engineering of teh application using Erwin. Used Erwin to transform data requirements into data models.
• Automated data loading, extraction, reports generation using UNIX Shell scripting and loading data by using SQL* Loader to custom tables.
• Worked on materialized views, DBMS SCHEDULER for scheduling jobs and UTL MAIL to send mails using oracle 10g.
• Implemented shell scripts for trouble shooting Oracle Errors wif teh halp of trace files and scheduled them.
• Configured database performance tools such as Oracle Enterprise Manager, SQL Navigator and used them for tuning of applications.
• Used Oracle Enterprise Manager, TOAD for developing and managing PL/SQL scripts.

Environment: Oracle 10g, Pl/SQL, SQL *Plus, TOAD, Oracle Forms 6i, Oracle Reports 6i, MS Excel, SQL*Navigator, Power Builder, Shell scripting