SUMMARY

• Business Intelligence professional with 5+ years of IT experience in analyzing designing developing applications.
• 4+ years of experience on Tableau which includes development, creating interactive dashboards, Server support and trainings
• Extensive experience working with Business Intelligence data visualization tools with specialization on Tableau 6.0/7.0/8.0/9.0/10.0.
• Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges
• Experience in creating aggregates, hierarchies, formatting, sorting and grouping.
• Experience in creating various customized views along with webpage integrations in Tableau.
• Experience in creating Filters, quick filters, table calculations, calculated measures, Parameters.
• Proficient in using Dashboard Action, Data Source and Context Filters according to the end user requirement.
• Experience in using various functions in Tableau like logical, number, string, aggregation for calculations.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop - down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau
• Complete knowledge on project life cycle.
• Excellent skills in designing and developing various dashboards and reports usingTableauVisualizations like Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Dual axis, Symbol maps, Geographic Visualizations.
• Expertise in generatig reports by retriving the data from different sources like RDBMS, text, excel, csv.
• Experstise in creating ad-hoc reports in Tableau.
• Experience in data modeling design and Analysis. Managed user access and Created new security accounts.
• OptimizedTableauWorkbooks and background tasks for targeted interactions and necessary analytics.
• Experience in PowerPoint presentations for end users using MS Access and MS Excel.
• Expertise in writing dynamic SQL queries in updating and fetching the data in the databases.
• Excellent team player with good analytical, reasoning, interpersonal and logical skills.
• Strong and detrmined ability to work in hard environments and aggressive project schedules.

TECHNICAL SKILLS

BI Tools: Tableau9.x/8.x/7.x/6.x,Business Objects,SSRS,Cognos,Obiee,MicrostrategyWeb Technology HTML,HTML5,CSS

Databases: MS SQL Server 2005/08/10/12, Oracle 8i/9i/10g/11g, Teradata, MS Access. SAP.

Tools: and Packages SQL Server Management studio, SSIS Toad, Profiler, Microsoft Visual Studio.

Languages: SQL, PL/SQL, C, HTML, XMLJava Script

Operating Systems: Windows 9x/XP/2000/Vista/7, Unix

Configuration Management Tools: Team Foundation Server

PROFESSIONAL EXPERIENCE

Confidential, FL

Tableau Developer

Responsibilities:

• Worked with business users and analysts closely to develop in creating dashboards and ad-hoc reports in Tableau 9.x/10.x.
• Created complex reports utilizing the features like hierarchy, New Calculated Columns, Drill functionality, Tables, graphs, line Charts and Bar Charts to explain the scenarios to the user.
• Analyzed the data by performing Hive queries and running Pig scripts, shell scripts to know user behavior in the application.
• Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right, full) in Tableau desktop to validate data.
• Supporting peers and stakeholders as a Subject Matter Expert (SME) through troubleshooting and analysis of results
• CreatedTeradataExternal loader connections such as MLoad, Upsert, Update, and Fastload while loading data into the target tables inTeradataDatabase
• Involved inTableauServer configuration, creating Users, Groups, Projects and assign Privileges etc.
• Worked with Business Analysts and Business users to understand the user requirements, layout of developed applications and design an interactive dashboard.
• Developed story telling dashboards using Tableau Desktop and published them on Tableau Server which allowed end users to understand the data on the fly.
• Actively Handled Tableau Server related administrative responsibilities that involved user authentication, permissions etc.
• Experience inTableauInstallation (Desktop as well as Server)
• Develop Predictive modelling techniques like Regression, Decision Tree, A/B Testing etc with Alteryx to address project requirements
• Responsible for refreshing the data in the timely manner on Tableau server to ensure views and dashboards were precisely showing changes in data.
• Experience in Database Programming, SQL, PL/SQL (Stored Procedures, Functions and Triggers) for faster transformations and Development usingTeradata.
• Designed and Optimized Connections, Data Extracts, schedules for background tasks and data refreshes for the corporate Tableau server
• Developed various types of complex reports like Standard reports, Group reports, Crosstab reports, Graphical reports, drilldown reports on demand with the client.
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Charts, Drill through and Drill Down Reports.
• Created advance chart visualizations in Tableau like Symbol charts, Box Plots, Bullet Graphs, Tree maps, Dual Axis, Bubble, Water Fall charts, funnel charts etc., to assist the business users in solving complex problems.
• Created AD groups on dashboards and utilized them in effective visualization.
• Responsible in developing SQL queries to fetch complex data from different tables in remote databases using Joins and formatted the results into reports and kept logs.
• Used Sql Server, Mysql data source connections to integrate with Tableau to create daily refreshed, fully-automated, end-to-end dashboards to optimize user experience.

Environment: Tableau Desktop 9.x/10.x, Tableau server, Sql Server, My SQL, Oracle, Amazon Redshift, Microsoft Excel 2010, MS Access.

Tableau Developer/Admin

Responsibilities:

• Worked closely with all teams within the organization to understand business processes, gather requirements, understand complexities and end goals to come up with the best plan of execution.
• Defined, created and managed the business specifications, technical specifications, and other project documentation for applications development
• Responsible in Installation, configuration, upgradation, troubleshooting and maintenance of Tableau server.
• Created rich dashboards with Tableau Desktop and developed stories from them and made clear and understandable interface to the user.
• Created Data Extracts connecting to Hive database and wrote custom SQL queries based on requirement.
• Was responsible in creating dashboards like weekly monthly and daily reports using tableau desktop and publish them to server.
• Managed developers, designers, functional experts, and contractors across multiple projects simultaneously.
• Experience in Tableau Server Management,Administered user, user groups, and scheduled instances for reports in Tableau.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Lead team in review and troubleshoot day-to-day dashboard support issues.
• Eliminated ambiguous relationships in the database and developed proficient dashboards.
• Created Data Connections and published onTableauServer for usage with Operational/Monitoring Dashboards.
• Experience in fetching the data from Oracle data sources and filtering it and producing reports from the data.
• Connected Tableau workbook with SharePoint portal and setup auto refresh feature.
• Developed database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Developed Stored Procedures, Triggers, and created indexes. Created Database Tables and database views.

Environment: Tableau Server 7.x/8.x, Tableau Desktop 7.x/8.x, SQL Developer, Oracle, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) T-SQL, SharePoint server, Microsoft Excel.

Confidential

Tableau Developer/Admin

Responsibilities:

• Experience in designing and development of Tableau visualization solutions and Created Technical document on top of BRI document for the business users.
• 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.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with advanced analysis Actions, Calculations, Parameters, Background images, Maps.
• Worked inTableauenvironment to create dashboards like weekly, monthly, daily reports using tableaudesktop & publish them to server.
• Created Workbooks and dashboards for analyzing statistical billing data usingTableau8.1.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards and access dashboards from any browser or tablet.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Creating users, groups, projects, and Data connections as a tableau administrator.
• Involved in creating dashboards and reports in Tableau 8.1 and Maintaining server activities, user activity, and customized views on Server Analysis.
• Analyzed thedata using statistical features intableauto develop Trend Analysis reports.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Experience in development of MDX queries to extract and modify the data from Multi-Dimensional data sources (Cubes).

Environment: Tableau Desktop Tableau server / Administrator, SQL server 2008.

Confidential

BI/SQL Developer

Responsibilities:

• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Strong performance, diagnostic, and query tuning skills.
• Involved in creating ER Diagram, Data Architecture design, Data modeling.
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2008).
• Designing SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Excel, and Access to MS SQL Server.
• Handled slowly changing dimensions to maintain the history of the data.
• Optimized indexes, SQL queries and stored procedures to improve the quality of the software.
• Design, review, and create primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Developed Ad hoc reports for the clients as per their requirements using SSRS.
• Variance reports using Reporting Services (SSRS).
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation.
• Responsible for taking data objects across different databases: Development -Test - Production.
• Created trace in SQL Profiler and used Data-base engine tuning advisor for Performance tuning on stored procedures and script.

Environment: MS SQL Server 2005, Windows Server 2003, Management Studio, Business Intelligence Development Studio (SSIS, SSRS), Team Foundation Server, MS-Visual Studio, VSS