We provide IT Staff Augmentation Services!

Tableau Developer/administrator Resume

5.00 Rating

Bloomfield, CT

SUMMARY

  • Over 8 years of professional experience in client requirement Analysis, Physical and Logical design, Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using Tableau, Teradata, SQL Server 2008/2005/2000/7.0 , DTS, SSIS,SSRS and SSAS.
  • Proficient in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
  • Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services SSIS/DTS.
  • Experience in developing different types of Tabular Reports, Matrix Reports, Drill - Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS) using SSRS.
  • Extensively worked onTableau6.x/7.x/8.x (Desktop, Server) and SSRS.
  • Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services SSIS/DTS.
  • Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
  • Extensive experience on building Analytical & Operational Dashboards using Tableau.
  • Mastered the ability to design and deploy rich Graphic visualizations using Tableau.
  • Involved inTrouble Shooting, Performance tuning SQL Serverand resolving issues withinTableau ServerandReports.
  • Experience in Data Conversion and Data Migration from earlier versions to current SQL server using SSIS and DTS services across different databases like Oracle, MS access and flat files.
  • Experience with SQL Server and T-SQL in constructing triggers, tables, views, stored procedures, user defined functions, indexes, user profiles and relational database models with data integrity.
  • Experience in working with different data sources like OLE-DB, flat files and Excel to source data in SSIS and proficient in creating SSIS packages from scratch and deploying them.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule ETL Packages.
  • Experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
  • Excellent verbal and written communication skills combined with strong interpersonal and conflict resolution skills and possess strong analytical skills.

TECHNICAL SKILLS

Databases & Related Technologies: Teradata SQL Assistant 14.01, SQL Server 2008/2005, Oracle 11g/10g/, MS Access, DBMS excel 2010, MS Share point

Operating Systems: Windows 8/7/XP/2003

ETL/BI Tools: SSIS (SQL server integration services), DTS

Modeling Tools: MS-Visio

Reporting: Tableau, SQL Server Reporting Services, Business Objects

Languages: T-SQL, SQL, PL/SQL, C, C++, JAVA, VB, MS ACCES

Office Tools: Microsoft Office / and XP

PROFESSIONAL EXPERIENCE

Tableau Developer/Administrator

Confidential, Bloomfield, CT

Responsibilities:

  • Involved in all phases of software development life cycle (SDLC) requirements gathering, analysis, design, development, testing and deployment using Agile (Scrum) methodology.
  • Worked on Proof of Concept (POC) to provide tableau insight to the business users.
  • Created semantic layer data mapping and Tableau dashboard mapping documents.
  • Worked on data model for Semantic layer.
  • Created DDL’s for semantic layer to fulfill the reporting requirements.
  • Created a tableau server site for Pharmacy IT to deploy dashboards.
  • Used custom Sql connections to extract data for reports and published them to tableau server.
  • Built dashboards using different types of visualizations like text tables, Scatter Plots, Area charts and stacked bars.
  • Developed analytical dashboards to analyze trends of the service over years, quarters and months and operational reports to provide insight into the service daily.
  • Created action filters, parameters and calculated fields to add interactivity to dashboards and worksheets in Tableau.
  • Strong experience to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameter’s using Tableau.
  • Provided support for Tableau developed objects and understand tool administration.
  • Defined best practices for Tableau report development.
  • Created ESP scripts to Schedule tableau data extracts and dashboards using ESP job scheduler.
  • Worked closely with business users to review the dashboards and get feedback from them.
  • Conducted training session for business users to help them understanding the functionalities of the tool and create ad hoc reports using the data sources published to tableau server.
  • Conducted KT sessions for production support team.
  • Extensively worked on Tableau desktop 8.1, 8.2 and Tableau Server 8.1, 8.2.
  • Worked on Teradata SQL Assistant, Oracle SQL developer, SQL server.

Environment: Tableau Desktop 8.1,8.2,Tableau server 8.1,8.2,Teradata Tools & utilities, Teradata Sql Assistant, Oracle Sql developer, Sql server, Windows 7,CA WA Work station.

Tableau Developer

Confidential, San Francisco, CA

Responsibilities:

  • Experience with the design and development of Tableau visualization 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 in Tableau 6.1. Created report schedules on Tableau server.
  • Installed and upgrade Tableau server form Tableau 6.0 to Tableau 6.1 and experienced in server performance tuning for optimization.
  • Administered user, user groups, and scheduled instances for reports in Tableau.
  • 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 for Tableau server logons and security checks.
  • Preparing Dashboards using calculations, parameters, calculated fields, 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.
  • Excellent analytical, 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 creating Tableau Workbook's, Publishing workbooks and Dashboard.
  • Find efficient ways 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 preparing SOP.
  • Responsible for Developing a Dashboard and preparing ad-Hock Reporting.
  • Working knowledge on Tableau Server / Administration.

Environment: Tableau Desktop 6.02,7.0, 8.0 Tableau server / Administrator, Oracle 10g, Microsoft Excel 2007,MS Access, Microsoft office 2007.

Tableau / SQL BI developer

Confidential, Bismarck, ND

Responsibilities:

  • Used Tableau to design Reports and Interactive Dashboards.
  • Built complex formulas in Tableau for various business calculations.
  • Created and assisted users in Tableau dashboard development.
  • Analyzed available data from MS Excel, MS Access, and SQL server 2000/2005.
  • Designed new database on SQL server 2008R2.
  • Normalized the data, created different tables, views, indexes, triggers and efficient stored procedures and Functions.
  • Checked Performance Tuning of the Database by optimizing the queries with modification in T-SQL queries. Normalized tables, established joins and created indexes wherever necessary.
  • Building query execution plans and making sure each and every query is using appropriate indexes.
  • Involved in backup and recovery strategies.
  • Designed new SSIS packages to extract data from various sources, transformed it based on Business needs and loaded it to OLAP servers for further analysis.
  • Exported and imported data from text files and Excel to SQL Server database using bulk insert.
  • Worked on developing Reports and managing reporting services.
  • Developed Reports in SSRS to send the reports directly to the respective E-mails using Subscriptions.

Environment: Tableau, SQL Server 2000/2005/2008 R2 Enterprise Edition,.NET, T-SQL, MS Access, MS Excel, & Windows 2003 server, TFS, Business Intelligence technologies like SSIS,SSRS, VSTS2008,BIDS.

SQL / BI Developer

Confidential, Columbus, OH

Responsibilities:

  • Created Complex Reports like Cascaded Reports, Drill Through, Tabular Reports, Matrix Reports, Drill-down, and Cross Tab Reports IN SSRS.
  • Developed Report Models, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
  • Designed and developed various Service management reports, utilizing cascading Prompts, sub-reports, charts, Formulas, parameterized rep and dynamic reports using SSRS.
  • Effectively Used Report Manger and Report Builder in SSRS.
  • Used the SSIS to migrate Databases such as Oracle and Access database, flat file, SQL Server 2000 to SQL server 2005.
  • Efficiently Migrated packages from DTS to SSIS.
  • Responsible for Developing, Monitoring and Deploying SSIS packages.
  • Implemented Batch Logging, Error Logging for the SSIS packages.
  • Used C # and VB in SSIS to design customized tasks.
  • Developed Cubes and done Dimensional Modeling in SSAS.
  • Efficiently implemented OLAP/MOLAP with the effective MDX scripting.
  • Efficiently designed KPI’s, Partitioning in the Cube development.
  • Developed multiple reports from SSAS.
  • Developed cubes using SSAS with effective Dimensions and Facts.
  • Managed and Supported Complex reports like Drill Through, Parameterized using SSRS 2005.
  • Designed complex reports like Cascaded Reports.
  • Effectively implemented changes in the .Net changes accordingly with the SQL Server migration and business enhancements.
  • Created Crystal Reports using Visual Studio 2005.
  • Effectively designed the Star schema and Snow Flake schema according to the Business requirements.
  • Developed Complex Queries in T-SQL, Stored Procedures, and Views with best Execution plan.
  • Experience in conducting Performance Tuning by using SQL Profiler, Data Engine Tuning Advisor, and Execution Plan.
  • Responsible for Monitoring and making recommendations for performance improvement in hosted databases
  • Best in Index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and Update Statistics in databases.

Environment: MS SQL Server 2008, Erwin, SSIS, SSRS, ProClarity, Visual Studio, MOSS 2007

SQL / BI Developer

Confidential, Gainesville, FL

Responsibilities:

  • Interaction with clients for Business Requirements during design & implementation phases.
  • Migrated databases from SQL Server 2005 & various other sources into SQL Server 2008.
  • Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, & import/export wizard while developing packages.
  • Design, develop & test the ETL processes according to industries best practices using SSIS.
  • All data were migrated to the staging server and then that data were later populated to the OLAP (Online Analytical Processing) Server.
  • Involved in implementing different types of reports & schedule them for reporting purposes using SSRS.
  • Generating on-demand, ad-hoc, custom reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
  • Involved in writing T-SQL, stored procedures, views, triggers, used indexes, constraints & business rules wherever applicable.
  • Used SQL profiler for performance tuning & debugging issue whenever necessary.

Environment: SQL Server 2000/2005/2008 R2 Enterprise Edition,.NET, Visual Studio, SQL, T-SQL, MS Access, MS Excel, & Windows 2003 server, Business Intelligent technologies like SSIS,SSRS.

SQL Server Developer

Confidential

Responsibilities:

  • Oversaw installations, upgrades of SQL 2008, SQL 2005 to SQL 2008.
  • Involved in Database design, creation and maintenance of Databases.
  • Managing the use of disk space, memory & connections by monitoring.
  • Created tables and views.
  • Created functions, stored procedures, triggers and constraints using T-SQL.
  • Monitoring & tuning SQL scripts by performance monitoring. Creating upgrade scripts for production Database and supporting it.
  • Server & Application fine-tuning & trouble shooting.
  • Wrote maintenance plans and code optimization. Worked on database designing, logical and physical data modeling, worked on large scale data migration using SQL Scripts, stored procedures, triggers, views, etc.
  • Monitoring MS SQL Server performance and network issues.
  • Performance monitoring and tuning of SQL servers.
  • Managed and Monitored System Utilization. Managed Backup and Disaster Recovery of the systems. Managed the security of the servers as a part of administration duties.

Environment: MS SQL Server 2008/2005, Windows XP Server, MS Access, SSRS, SSIS, XML, Windows 2000/2003/NT/XP, MS-Excel.

We'd love your feedback!