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, Tableau 8.x and Tableau 9.
• 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
• 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 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.
• 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.

TECHNICAL SKILLS

BI/ETL Tools: Tableau, SSIS (SQL server integration services), DTS & Data stage

Databases & Related Technologies: SQL Server 2008/2005, Oracle 11g/10g/, MS Access, DB2 MS excel 2010, MS Share point & Team Forge

Operating Systems: Windows 8/7/XP/2003 & Unix

Modeling Tools: MS-Visio

Reporting Tools: SQL Server Reporting Services

Defect Management tool: HP ALM & Bugzilla

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

Office Tools: Microsoft Office /

PROFESSIONAL EXPERIENCE

Confidential, Mount Laurel, NJ

Sr. Tableau Consultant

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 Dashboard migration from Tableau 6 to Tableau 9
• Involved in creating dashboards and reports inTableau. Created report schedules onTableau server.
• Worked on Oracle, SQL and tableau server to configure data connectivity clients to connect production environment system and run queries through the supported drivers.
• 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 forTableauserver logons and security checks.
• PreparingDashboardsusing calculations, parameters, calculatedfields,groups, sets and hierarchies in Tableau.
• Designed Physical Data Models for FHMC, call center and other diversified major components of the user interface for the projects.
• Created and assisted users in Tableau dashboard development.
• Administered and provided production support in a wide range of Tableau application consisting of multiple key functional business domains.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development, provided 24/7 production support for Tableau users.

ENVIRONMENT: Tableau 9, Tableauserver / Administrator, Oracle, Microsoft Excel 2007,MS Access, ETL, Microsoft office.

Sr. Tableau Consultant

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 inTableau. Created report schedules onTableau 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 forTableauserver logons and security checks.
• PreparingDashboardsusing calculations, parameters, calculatedfields,groups, sets and hierarchies in Tableau.
• Interacted professionally with a diverse group including executives, managers.
• Created data blending in case of merging two different datasets.
• 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, Tableauserver / Administrator, Oracle 10g, Microsoft Excel 2007,MS Access, ETL, Microsoft office 2007.

Confidential, Phoenix, AZ

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 infographics and Dashboarding 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, Detroit, MI

SQL/ BI Developer

Responsibilities:

• Analyzed available data from MS Excel, MS Access, 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, West Chester, PA

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

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.