We provide IT Staff Augmentation Services!

Sr. Tableau Developer/admin Resume

Freehold, NJ

SUMMARY:

  • Around 8+ Years of IT experience in Business Analysis and Business Intelligence Projects, along with 4+ years of Tableau Development using Tableau Desktop, Tableau Server and Strong background in Databases and Data warehousing concepts.
  • Expertise in Tableau 10.0/9.3/9.2/9.1/8.0, Tableau Sever, Tableau cloud, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader
  • Good understanding of Tableau Server and Desktop architecture for designing and developing dashboards.
  • Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources.
  • Experienced in Tableau report developing, Testing and deploying reporting solutions using Tableau Server.
  • Expertise in complex BI Reports , Dashboards, Project Management , Change/Incident Management, Maintenance, upgrade , Fix pack/Service pack installations, and Root cause analysis, Resolution Methods Time/ Cost/ Budget Management.
  • Published Workbooks on Tableau Server by creating User filters and sites (User groups, access) so that only appropriate teams can view it.
  • Setup and configuration of Tableau server 9.1 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to bestpractices.
  • Setting a Cluster by adding Worker Nodes, Backgrounders and a Failover.
  • Setup trusted authentication in Tableau server and pass requests from Web server
  • Experience in Assessing Built Tableau Cluster Environment and preparing a Health Check Audit.
  • Expertise in managing schedules and schedules workbooks, Set permissions on Tableau Server.
  • Expertise in setting permissions on content for specific users or group on a site basis
  • Extensive Experience in Tableau Server includes Automatic Backup, restore, migration Cluster Node environment.
  • Expertise in Working with log files, analyzing issues in a cluster, finding out bottlenecks, analyzing solutions and Optimizing Cluster.
  • Reporting and fixing failed Data Extracts and rescheduling to avoid bottlenecks and reduce overload on server and backgrounders.
  • Setup of SSO between Tableau portal and oracle .
  • Used various authentication methods like SAML in configurationof Tableau Server and authenticated LDAP/ AD login.
  • Involved in upgrading Tableau platforms in clustered environment and performing content upgrades. Setup security profiles for various user groups and users using Tab admin and Tabcmd Tools.
  • Used the REST API with Tableau Server to manage and change Tableau server resource programmatically.
  • Used SAML configuration of Tableau Server SSO supplementing Kerberos authentication on the side
  • Strong knowledge in AWS, Cloud stack,Openstack Prepared, arranged and tested Splunk search strings and operational strings.
  • Generated various List Reports, Grouped Reports , Cross tab Reports, Chart Reports, Drill - Down and Drill-Through Reports.
  • Used Tableau’s flexibility to build a tabbed application with wide range of options like quick filters, calculated fields, dynamic interaction, flexible ad-hoc capability in various functional areas like finance, sales, marketing and HR.
  • Created Ad- hoc reporting based on user requirements Expertise in creating custom views using Tableau Sever repository database.
  • Familiarity with reporting tools like COGNOS, Crystal reports, SSRS
  • Good knowledge with SSAS, creating views, cubes and converting business requirement into logical data models
  • Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
  • Strong experience in implementing Stored Procedures, Triggers, Nested Queries and Joins.
  • Experienced in Oracle Business Intelligence Enterprise Edition
  • Extensive knowledge in creating complex SSIS and DTS packages for ETL purpose
  • Worked on Data Warehouses with expertise in all phases of data warehousing life cycle.
  • Extensive experience in SSIS, SSAS and SSRS(MSRS) of SQL Server.
  • Strong knowledge of Software Development Life Cycle (SDLC).
  • Good understanding and background in financial services, media, and telecom industry.
  • Good knowledge in ETL Tools like Informatica, Talend.
  • Comfortable working independently or with team with limited supervision and working in tighter schedules, meeting deadlines, and ability to learn on the fly.
  • Good knowledge on Python Scripting

TECHNICAL SKILLS:

BI/Visualization Tools: Tableau 10.0/9.3/9.2/9.1/8.0, Server 10.0/9.3/9.2/9.1/8.0 Qlikview, Power BI, BO Universe Designer, BO Web intelligence, Splunk, Cognos,Crystal reports XI/2008, Business Objects XI R1.

Programming: SQL, UNIX Shell,HTML, PL/SQL, XML, C, C++, Java/J2EE.

Utilities: MS Office Suite, MS Share Point, MS Project

Databases: Oracle 8i/9i/10g/11i, Oracle SQL Server 2008 R2, Oracle Business Intelligence MS Access, MS Excel, DB2, MySQL, Mango DB, Tera data

Web/App Servers: Apache Tomcat, Web logic Server 8.1/9.2/10, MS IIS 5/6.0, JBoss

Platforms: Windows 7/8/2003/NT, MS Server 2008 R2, Mac OS, DOS, UNIX.

Networking: TCP/IP, LAN/WAN Technologies.

Data Warehousing: BW 3.5, 3.1c, 3.0b, BI 7.0.

Tools: Informatica, Talend.

PROFESSIONAL EXPERIENCE:

Confidential, Freehold, NJ

Sr. Tableau Developer/Admin

Responsibilities:

  • Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
  • Hands on experience with Tableau 10.1/ 10.0& used the multiple data sources joins in Tableau desktop.
  • Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
  • Installed the architecture of Tableau security by customizing access levels and creating various user groups by assigning row and column level security at both the application and user level.
  • Created and updated the architecture of Tableau security by customizing the access levels.
  • Designed and setup user security for the entire landscape to facilitate Windows AD login.
  • Created Automated scripts for Tableau workbook refresh when not using live connections.
  • Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
  • Gather requirements, design, build, test and deploy Tableau reports
  • Implementedbug-fixes, application enhancements, customer training, business process changes or other measures
  • Setup of Distributed Server environments for optimum load balancing.
  • Setup and configuration of Tableau server 9.3 in various environments and used Tableau CMD and Tableau admin tools to configure the server
  • Upgraded Tableau 9.3 to Tableau 10.0 and gathered requirements, analyzed from raw data.
  • Build from the ground up reliable infrastructure services in AWS to deliver highly scalable services.
  • Experienced in managing schedules and schedules workbooks, Set permissions on Tableau Server.
  • Extensively experienced in managing sites
  • Setup trusted authentication in Tableau server and pass requests from Web server
  • Scheduled data extracts and monitor daily basis.
  • Worked on Tabadmin tools and Tableau Cmd for setting up security profiles for various User groups and Users.
  • Used Tableau Cmd for Backups and Dashboard migrations from one environment to another.
  • Provided auditing capabilities for Reporting Workbench as requested.
  • Worked with all levels of development from analysis through implementation and support.
  • Provide hands-on Tableau production support. Identify and research problem trends and work with internal or external subject matter experts to correct and proactively prevent further problems by recommending
  • Used Tableau and Google Analytics to analyze web traffic and make business decisions on the traffic coming from different locations.
  • Optimize the VizQL Server processes to handle loading and rendering views for Tableau Server.
  • Used the API for the functionality enhancement on Server for site users and sites on Tableau Server
  • Developed Dashboard with URL action passing from Tableau to Internal websites
  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Experiment with new features and enhancements released by Tableau, and bring them into the platform & organization.
  • Analyzed and Resolve Performance and server issues
  • Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
  • Creating New Schedule's and checking the task's daily on the server.
  • Used Tableau to provide the standard user interfaces for visualizing and filtering date/time data, and Hive will construct the Map/Reduce jobs necessary to parse the string data as date/time to satisfy the queries Tableau generates.
  • Used Hive and Hadoop configuration variables for a given connection from Tableau to tune performance characteristics
  • Used additional UDFs which Tableau does not yet expose as formulas for use in calculated fields in HIVE.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Created parameters, quick filters Sets to display Top Products based on their sale
  • Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.

Confidential, Indianapolis, IN

Sr. Tableau Developer/ Admin

Responsibilities:

  • Worked on Creating Schemas and connecting Tableau to AWS Redshift and Hive
  • Deep experience with the design and development of Tableau visualization solutions
  • Configured Tableau setup in the Project and did KVI Documentation of the project
  • Worked on Tableau Server maintenance, Tableau Server backup activity
  • Participated in Performance tracking activity by evaluating server tasks
  • Setup of distributed server environment in a multi-tier and multi-threaded configuration for optimum performance in Tableau.
  • Building, publishing customized interactive dashboards and report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
  • Setup and configuration of Tableau server 8.0 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
  • Published Tableau dashboards on Tableau Server or Tableau Online and embedded them into portal
  • Created Groups and Users in Tableau Server
  • Experience with Tableau Maintenance Tools and Tableau Server to start/stop services and maintenance
  • Assigning Various extract schedules and using blending techniques to optimize the performance of Tableau
  • Worked heavily using Tableau CMD and Tableau Admin Tools to configure the server
  • Set up user security and designed security of Tableau to facilitate login into Tableau server.
  • Setup trusted authentication in Tableau server and pass requests from Web server.
  • Designed and setup user security for the entire landscape to facilitate Windows AD login.
  • Worked on Setting Permissions on content for specific users or group on Tableau Server.
  • Used the Web Data Connector JavaScript library for enabling the app to interface with the Tableau API
  • Used the REST API’s that send queries for financial data.
  • Used the Rest API’s with Tableau Server to manage and change Tableau Server resources programmatically.
  • Used the API for functionality enhancement on server for site users and sites on Tableau Server
  • Provided governance and technical expertise for the use and operation of clinical dashboards
  • Provide the user access to Team for AWS console and SSH connectivity to the Edge node.
  • Configure the VPC, EC2 instances, S3 buckets, RDS (MySQL)
  • Configuration of AWS in built SNS/SQA setup for Job Scheduling
  • Create required shell or python scripts for data push from Tableau/Teradata to S3
  • Worked on creating interactive, real-time dashboards using drilling downs and customizations.
  • Created Tableau scorecards, dashboards, donuts, box plots, geographical maps, Gantt charts,Waterfall charts, Funnel Charts in Tableau desktop.
  • Involved in creating database objects like tables, views, stored procedures, triggers, functions using SQL workbench to provide structure and to maintain data efficiently.
  • Worked closely with business leaders, and end users to define operational report templates and aid in their use
  • Importing tables using Warehouse catalog and Creating Logical Tables
  • Lead the design and development of analytical projects designed to understand key business behaviors that drive customer acquisition, retention, and engagement
  • Managed the migration of fixed income data mart from oracle to Teradata

Confidential, Irvine, CA

Tableau Developer

Responsibilities:

  • Deep experience with the design and development of Tableau visualization solutions.
  • Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
  • Used different Mark types and Mark properties in views to provide better insights into large data sets.
  • Created External filter, internal filter and Context filter to improve performance.
  • Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
  • Used data connectors that are already available in Tableau, to create web data connector (WDC) that reads data from virtually any site that publishes data in JSON, XML, or HTML.
  • Used Tableau and Google Analytics to analyze web traffic and make business decisions on the traffic coming from different locations.
  • Used the Tableau Web Data Connector JavaScript library to connect to the Google Analytics data without having pitfalls going directly with the GA connector
  • Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop
  • The connector then gets the closing price for the specified company for one year back from today's date.
  • Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
  • Created parameters and quick filters. Created sets to display top products based on their sale.
  • Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
  • Published Workbooks and Dashboards to the Tableau server.
  • Combined visualizations into Interactive Dashboards and publish them to the web.
  • Created groups and users in Tableau server
  • Used commands in Tab cmd. and Tab admin utility tool and migrated Workbooks andDashboards.
  • Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Confidential

Tableau Developer

Responsibilities:

  • Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
  • Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
  • Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
  • Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
  • Ability to work quickly and under tight delivery deadlines with focus on details.
  • Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
  • Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.
  • Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows
  • Created Metrics, Analytics, Rules, Goals for the Corporate Dashboard.
  • Developed mappings to support incremental loading.
  • Got involved in designing the Data model for the Data warehouse and for different Data marts
  • Performed End to end testing using SQL Queries in Oracle.
  • Prepared many other reports by using master details, cross-tabs, slice and drill mode as per the requirement of the end-uses

Confidential

SQL Developer

Responsibilities:

  • Created procedures, functions, packages, triggers, indexes and views using T-SQL in development and production environment for SQL server 2005
  • Extracted data from xml and flat files using SSIS
  • Developed reports using crystal reports and used table control, matrix control for cross tab reports.
  • Involved in designing of conceptual logical model and physical model
  • Generated parameterized/Drilldown, Drill through & Cascaded reports using SSRS and Crystal Reports.
  • Used SQL profiler and query analyzer to optimize DTS package queries and stored procedures.
  • Involved in performance tuning using indexing (cluster index, non-cluster index) tables.
  • Worked on the project that involved development and implementation of a data warehouse.
  • Developed DTS Packages to transfer the data between SQL Server and other database and files.
  • Scheduled Jobs & Re-Scheduled on Production Databases
  • Wrote and optimize Triggers, Stored Procedures and Queries in T-SQL
  • Created database objects like tables, views and indexes Created and Modified Stored Procedures, Triggers and Cursors.
  • Gathered requirements and created design plan for the database and required analysis for generation of reports
  • Designed, developed and modified various Reports
  • Managing daily team meetings and involved in the business requirements meetings.
  • Designing and modeling database according to requirement and made changes according to it.
  • Designed, developed and tested complex queries for Reports distribution
  • Skilled in running Jobs in Enterprise Manger using Job-Scheduling tool.

Hire Now