PROFESSIONAL SUMMARY:

• Over 7 years of experience in Software Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Extensive experience in Tableau Desktop, Tableau Server, Tableau Reader, Public and Mobile in various versions of Tableau 6, Tableau 7 and Tableau 8.x.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades. In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle. Extensive experience on building Analytic Dashboards using Tableau.
• Mastered the ability to design and deploy rich Graphic visualizations using Tableau. Experience in client requirement Analysis, Physical and Logical design, Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000/7.0 , DTS, SSIS,SSRS and SSAS.
• 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.
• Involved in Trouble Shooting, Performance tuning SQL Server and resolving issues within Tableau Server and Reports.
• 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.
• Experienced 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.
• Experienced 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.

PROFESSIONAL EXPERIENCE:

Confidential, Lincoln, NE

Sr. Tableau Consultant

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. Created report schedules on Tableau server. 
• Worked on Netezza JDBC, ODBC and OLE DB to configure data connectivity clients to connect Netezza system and run queries through the supported drivers.
• Installed Tableau Server in Dev, QA, UAT and Prod environments. Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Monitored Vizql and WGSQL Server activity to track performance and system stability.
• 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.
• Created data blending in case of merging two different datasets. Interacted professionally with a diverse group including executives, managers.
• Designed the Conceptual and Physical Data Models, as well as the major components of the user interface for the “MDW” project. The Data Models were built with Sybase Designer.
• Created and assisted users in Tableau dashboard development. Administered and provided production support for Fedex Enterprise wide Tableau application consisting of multiple key functional business domains.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Defined and created procedures to install Tableau desktop in silent mode. Defined best practices for Tableau report development.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository. Provided 24/7 production support for Tableau users

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

Confidential, Omaha, NE

Tableau Consultant

Responsibilities:

• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Expert in info graphics and Dash boarding for data visualization. Interact professionally with diverse group of professionals in the organization including managers and executives.
• Experience in standardizing Tableau for shared service deployment. Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau. Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Involved in license management SLA’s with Tableau support. Defined best practices for Tableau report development.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository. Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues. Experience in providing Tableau server and tableau desktop training.
• Installed drivers for the Teradata and upgraded ODBC drivers to 13.00.00.01 for better performance.

ENVIRONMENT: Tableau Server v6/v7, Tableau Desktop v6/v7, Windows Server Standard R2, Clearquest, Clearcase, Oracle 11i, Sybase, Crystal XI, Info view, ETL, CMS, CMC, Excel, JAVA, J2EE, Tomcat, TSQL, UNIX, Linux RHEL 5.4.

Confidential, Lincoln, NE

SQL/ BI Developer

Responsibilities:

• 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 ETL 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. 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.

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

Confidential, NorthPlatte, NE

SQL /BI Developer

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 ETL SSIS. Responsible for Developing, Monitoring and Deploying SSIS packages.
• Implemented Batch Logging, Error Logging for the SSIS packages. Used C # and VB in ETL 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 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, MSBI, ProClarity, Visual Studio, MOSS 2007

Confidential, Beatrice, NE

SQL Server Developer

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.

ENVIRONMENT: MS SQL Server 2008/2005, Windows XP Server, MS Access.