Sr.tableau Developer Resume
San Jose, CA
SUMMARY
- Developer with 7 years of experience onTableau, data visualization, data analysis, report development, MS SQL Server Developer/ ETL Developer in analysis, design, implementation & administration of Business intelligence solutions (SSIS/SSRS/SSAS) with Microsoft SQL server 2012/2008 - R2/2008/2005 in development, testing & production environment
- Experience with the design and development ofTableauvisualization and dashboard solutions using Tableau Desktop.
- Involve in design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
- Expert in evaluating data models to designTableausolutions.
- Responsible for developing interactive data visualizations.
- Experience including technical support, troubleshooting, report design and monitoring of system usage.
- In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
- End to end experience in designing and deploying data visualizations using Tableau
- Deployed the reports andScheduled Reportsfor the use of end users and customers
- Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
- Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
- Extensively used Erwin for Logical Data Modeling, Physical Data Modeling, Logical-to-Physical Transformation, Forward engineering, Reverse engineering, and Model-to-model comparison.
- Strong knowledge of Data Warehousing methodologies and concepts, including Star Schemas, Snowflake Schema, SSIS processes, Dimensional Modeling and Reporting tools.
- Proficient in Installing, Configuring and Administration of Tableau Server.
- Expertise in designing and development of various dashboards, reports utilizingvarious TableauVisualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
- Extensive experience inTableauAdministration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms..
- Highly proficient in using T-SQL for developing complex Stored Procedures, Effective Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity, SQL Joins, Indexing and Query Writing.
TECHNICAL SKILLS
- Tableau Desktop 7/8
- Tableau Server 6/7/8
- Tableau Online
- Tableau Public
- Tableau Reader
- TabCmd
- Microsoft SQL Server 2012/2008-R2/2008/2005
- MS SQL Server Integration Services (SSIS)
- MS SQL Server Reporting Services (SSRS)
- MS SQL Server Analysis Services (SSAS)
- T-SQL
- PL-SQL
- OLAP
- OLTP
- Erwin Data Modeler v7.0/v4.x
- Microsoft Visual Studio 2010/2008/2005
- Microsoft Access
- Microsoft Office(MS Word/ Excel/PowerPoint)
- MS Project
- HTML
- XML
- Java
- C++
- C#
- Visual Basic 6.0
- Microsoft Office Visio
- Windows 2008/2003/2000 Advanced Server
- Windows NT/95/98/2000/XP/7
- Ultra Edit Text Editor
- Visual Safe Source 2005 (VSS) .
PROFESSIONAL EXPERIENCE
Confidential, San Jose, CA
Sr.Tableau developer
Responsibilities:
- Gathered user requirements, analyzed and designed software solution based on the requirements.
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
- Effectively used data blending feature in tableau.
- Defined best practices for Tableau report development.
- Administered user, user groups, and scheduled instances for reports in Tableau.
- Executed and tested required queries and reports before publishing.
- Developing Standard and Create reports using Tableau Desktop.
- Developing Attributes, Facts, Metrics, Filters, Prompts and Hierarchies as per Specifications for developing reports.
- Creating DB views for the reporting purpose.
- Preparing Report Mapping Documents as per Specifications.
- Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
- Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
- 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.
- Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
- Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
- Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
- Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
- Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
- Publish the developed dashboard, reports on theTableauServer so that the end users having access to the server can view the data.
- Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
- Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
- Created Test Cases and documented the Test Results.
Environment: Windows Server 2012,TableauDesktop 8.2/8.0/7.0,TableauServer, SQL Server 2008/2012, PL/SQL, MS-Access, MS Excel and JavaScript.
Confidential, Canton OH
Tableau Developer
Responsibilities:
- Experience with the design and development ofTableauvisualization solutions.
- Worked in developing strategy and technical specifications for implementing reporting portal/semantic layer in conjunction with data layer.
- Involved in creating dashboards and reports inTableau6.1. Created report schedules onTableau server.
- Installed and upgradeTableauserverformTableau6.0 toTableau6.1and experienced in server performance tuning for optimization.
- Administered user, user groups, and scheduled instances for reports inTableau.
- Extracting data from different sources connecting them and used the same to create dashboard
- Experience with creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks.
- PreparingDashboardsusing calculations, parameters, calculatedfields,groups, sets and hierarchies in Tableau.
- Creating data blending in case of merging two different datasets.
- The ability to interact professionally with a diverse group including executives, managers.
- Excellentanalytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
- Excellent experience and expertise in creatingTableauWorkbook's, Publishing workbooks and Dashboard.
- Findefficientways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
- Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
- Proof-read all documents and maintain accuracy of information and preparingSOP.
- Responsible for Developing aDashboardand preparingad-Hock Reporting.
- Working knowledge onTableau Server / Administration.
Environment: Tableau Desktop 6.02,7.0,8.0 Tableauserver / Administrator, Oracle 10g, Microsoft Excel 2007,MS Access, Microsoft office 2007.
Confidential, Phoenix, AZ
Tableau developer
Responsibilities:
- Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
- Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 7 desktop/Server.
- Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
- Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
- Create interactivereportsand dashboards inTableauDesktop.
- Subscriptions to Reports or Worksheets in Tableau Desktop.
- Created report schedules on Tableau server.
- Administered user, user groups, and scheduled instances for reports in Tableau
- Worked as technical architect in developing strategy, architecture, and technical specifications for
- Created and assisted users in Tableau dashboard development
- Defined best practices for Tableau report development.
- Executed and tested required queries and reports before publishing.
Confidential, Jersey City, NJ
SQL Developer
Responsibilities:
- Worked on Full life cycle development (SDLC) involving in all stages of development.
- Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
- Used various transforms in SSIS to load data from flat files, Siebel CRM and FTP to the SQL databases.
- Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
- Created Grouping, Sorting columns and writing expressions according to the business requirements.
- Migrated old data from MS Access and Excel into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
- Created SSIS packages (.dtsx files) using SSIS to validate, extract, transform and load data to data warehouse databases and data mart databases.
- Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
- Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.
- Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
- Good Knowledge of Installation and Configuration of Clustered Servers in Active/Passive and Active/Active mode.
- Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
- Developed tabular queries for efficient analysis of report using Pivot/Unpivot in T-SQL.
- Created and maintained logins, roles and permissions on the SQL instances and databases and provided required privileges according to the user’s requirements.
- Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Constraints.
- Designed, tested (unit testing and integration testing) and implemented stored procedures and triggers for data processing of huge volume of data.
- Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.
- Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan.
- Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.
- Implemented High availability concepts, Data base Mirroring, Replication and log shipping.
- Provided index tuning as required for performance improvement of the applications (SQL tuning).
- Created parameterized and drill through reports in Cognos Report Studio.
- Designed developed and deployed reports in Cognos portal and made available to render them to HTML and PDF formats.
Environment: SQL server 2005/2008 on Windows 2003 server, IIS, Visual Studio, SSIS, SSAS, SSRS, Database Mirroring, Replication, Log shipping, Framework Manager, BIDS and SSMS.
Confidential, Irving, TX
SQL Developer
Responsibilities:
- Created detailed design and requirements documents with logic to help team members understand the requirements and design.
- Developed and optimized database structures, Stored Procedures, Indexes, Views, Triggers (DDL & DML), Cursors and User Defined Functions (UDF).
- Gather requirements and design of data warehouse and data mart entities·
- Built Data marts (Fact and Dimension tables) from the warehouse tables.
- Understanding Customer requirement via interaction and writing functional specifications.
- Involved in creation of Dimensions using Star and Snow Flake Schema.
- Developed OLAP Cubes, Dimensions, Data Source View, Partitions and Aggregations.
- Responsible for identifying and defining Data Source and Data Source Views.
- Defined attribute properties in a Parent ChildDimensions.
- Installed, configured and maintained SQL Server Integration Services.
- Developed, deployed and monitored SSIS packages.
- Created packages using Integrated Services (SSIS) for data extraction from Flat files, Excel Files, OLE DB.
- Used SSRS to create reports, customized reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
- Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
- Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, Locks and performance of SQL Server.
- Designed and implemented Stored Procedures and Triggers for automating tasks.
- Incremental and full database recovery with experience of complex recovery scenarios.
- Designed, added, eliminated and maintained indexes, organized tables, recommended changes to application development team.
Environment: MS SQL Server 2005/2008, SSIS, SSRS, SSAS, T-SQL, Windows Server 2008, Windows 7.
Confidential
SQL Server Developer
Responsibilities:
- Developing T-SQL queries, triggers, functions, cursors and stored procedures.
- Responsible for logical and physical design of SQL Server databases.
- Alter the schema for the required objects.
- Used DDL and DML for writing triggers, stored procedures, and data manipulation.
- Created views to restrict access to data in a table for security.
- Expert in extracting data using SSIS from OLTP to OLAP.
- Performed Bulk data migration using DTS and SSIS from flat files.
- Designed and optimized all the SSIS packages.
- Created SSIS packages to Export data from text file to SQL Server Database.
- Designed and implemented stylish report layouts.
- Identified the Data Source and defining them to build the Data Source Views.
- Scheduling backups and automating weekend maintenance tasks.
- Created users and roles for login authentication and validating permissions.
- Administering MS- SQL Server, performing day-to-day tasks such as Database tuning by checking indexes.
- Upgraded SQL Server 2000 to SQL Server 2005.
- Assisted developers in tuning Stored Procedures, Triggers and Functions over performance issues.
Environment: SQL Server 2005/2000, T-SQL, DB Artisan, MS Reporting Services, Management Studio, Query Analyzer, Windows 2003 Server, Oracle 9i.
