Tableau Developer/administrator Resume
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.