SUMMARY

• Over 8 years of total IT experience in Analysis of data, designing the data, Development of structured data, Documentation and Implementation of Business Intelligence applications.
• Strong knowledge in Agile/ Scrum methodologies.
• In - depth knowledge in Tableau Desktop and basics of Tableau Server in various version of tableau including Tableau 7x and Tableau 8x.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Histograms, Bullets, Heat maps, scatter plots, Gantts, Bubbles and Highlight tables.
• Extensive Tableau Experience in Tableau Administration and Enterprise environment experience including technical support, Troubleshooting, Report design and Monitoring of system administration parameters.
• Good experience in Tableau Administration Tool for creating users, groups, sites projects etc.
• Extensive experience in Installation, configuration, upgrade and administration of Tableau Desktop/Server.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards and Tableau suite.
• Experience in developing multiple dashboards/reports using various charts like Bar, Stacked Bar, Line, and Dual-axes charts, Geo-Maps, Bubble, Histograms and Heat Maps.
• Expert in Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management i.e., Connections, Data Model and VizQL Model.
• Highly skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Hands-on experience in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Working Knowledge of Qlikview 11.
• Worked extensively with Calculations, Parameters, Background images, Mapping, Advanced Analysis Actions.
• Extensive experience on using functions like Index, Discrete, Table down, Table across, Pane Down, Product Category.
• Good understanding of building Dimensional Models, Data warehouse architecture.
• Extensive experience on setting of multiple filters using Default filters, Show quick Filters, Context filters and cascading filters.
• Strong complex reporting skills utilizing Burst Reports, Crystal reports, Summary reports, Complex Drill- Through and Discontinuous Cross-Tabs.
• Experience on various types of Joins and Queries, Custom SQL, Pivot, assume referential integrity, Join Culling.
• Outstanding team player with good interpersonal and communication skills and the ability to work in a team or as an individual.
• Excellent problem-solving skills with excellent business communication.

TECHNICAL SKILLS

BI Tools: Tableau 7.0, 8.0, 9.0, QlikView11 (Trained), MS Excel, ROAMBI, Spot Fire

Relational Databases: MS SQL Server .., Oracle .. ETL, Teradata, MS Access

Operating Systems: Windows ..., Unix, Linux

Configuration Management Tools: Team Foundation Server, IBM Data Management

Tools: and Packages SQL Server Management Studio, Microsoft Visual Studio, Toad

Languages: SQL, C, C++, HTML, PHP

PROFESSIONAL EXPERIENCE

Confidential, Parsippany, NJ

Sr. Tableau Developer

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification from system users.
• Participated in the daily stand up SCRUM agile meetings as part of AGILE process for reporting the day to day developments of the work done.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• 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.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Provided support for Tableau developed objects and understand tool administration.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Provided resolution to performance problems of dashboards deployed on tableau server using out of the box performance analyzer tool of tableau desktop and tableau server.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple functional business units responsible for operations and strategic decision making.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Prepared the design documents using Crystal Reports.

Environment: Tableau 8.1/8.0, Tableau Server, Oracle, Microsoft SQL Server, Microsoft Office, Microsoft Visio, Windows 7, Custom SQL.

Confidential, NYC, NY

Sr. Tableau Developer

Responsibilities:

• Involved in Gathering Business Requirements for the Model and for developing reports from the business users.
• Created Framework Manager Packages with various security settings defining the cardinalities and namespaces and published them onto Cognos Connection.
• Established Relationships and Joins between the query subjects of the Model
• Implemented object level security for query subjects and query items to make them available only for the end users who are authorized.
• Developed various reports using table's types like Table Across, Pane Down, Pane Across.
• Enhanced reports with new features and functionality based on the business requirements.
• Developed List, Cross Tab, Chart and Drill through Reports in tableau.
• Worked on Context Filters and Cascading Filters page and implemented various parameters, filters, calculated table calculations, aggregations, specific conditions, & created analytical reports.
• Developed many reports using the conditional variables according to the need of end users.
• Testing and improving report performance, performance tuning on complex reports on the report level.
• Worked on scheduling reports to run Monthly, weekly and daily basis using scheduler.
• Created Tableau worksheet and dashboards which involves Schema Import, Implementing the business logic by customization.
• Created Data Connections, published on Tableau Server for usage with Operational Dashboards and story points.
• Built Complex Formulas (using "calculated-field" feature) in Tableau for various business calculations.
• Spot Fire: Created analytics, dashboards, reports by using main concepts like data on demand, filtering scheme and property controls etc.
• Technical documentation with the concepts of various business processes integration.
• Designed and developed reports using Qlikview.
• Maintained and supported Microsoft Team Foundation Server (TFS) to give access for code management from various sources and reporting in a multi-team environment.
• Developed performance management dashboards internally and externally by using Crystal Reports.

Environment: Tableau Desktop 7, Tableau Server 7, Tableau Server 8, Tableau Desktop 8.1, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, UNIX, SQL Server 2008, Oracle 11g, MS Office, Visual Studio 2010, ROAMBI, Micro-strategy, Toad, Qlikview.

Confidential, NYC, NY

Tableau Developer

Responsibilities:

• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Transformed TABLEAU into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and production Support issue resolution.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Work directly with management, vendors, and third parties to ensure that Web-site's financial transactions and database management applications operate at peak efficiency.
• Played key role in enhancing client's Web reporting system, reducing time of delay financial tracking analysis by 30%.
• Purchasing, Setting up and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.
• Sophisticated stored procedures and triggers to provide complete technical solutions.
• Worked with all levels of development from analysis through implementation and support. Participated in test planning and test script definition.

Environment: Windows XP, Linux, Windows 7, Tableau, Tableau Server, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and SQL, Java, JavaScript, SQL, VB

Confidential, Parsippany, NJ

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Gathered requirements from the end users, discussed business rules, created functional and technical specification documents and the highly critical design documents.
• Designed, developed and deployed new packages in the SSIS environment to facilitate loading data from legacy systems and other diverse sources into staging.
• Designed the ETL architecture, analyzed and stream lined the flow of data from the Topspeed database into SQL Server 2008 R2.
• Installed and configured the appropriate drivers, Microsoft SQL Server 2008 R2 and all the other suite of products such as SSIS, SSAS, SSRS 2008/2008R2.
• Created complex Stored Procedures/T-SQL code involving complex joins, CTEs, Correlated sub queries, views and functions to check for the integrity and consistency of the data, to enhance performance and migrate data to the Target Staging Database.
• Developed Visual Basic scripts in SSIS to achieve complex functionality that would facilitate the profiling as well as the loading of the Target Staging Database tables.

Environment: Microsoft SQL Server 2008/2005/2000 , DTS, SSIS, SSAS, SSRS, Microsoft SharePoint, Microsoft Visio Professional 2005. VB.NET

Confidential

Programmer

Responsibilities:

• Designed DTS Packages to transfer data between servers, load data into database, archive data file from different DBMS using SQL Enterprise Manager/SSMS on SQL Server 2005 environment, and deploy the data; scheduled the jobs to do these tasks periodically.
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation.
• Set up database backup and recovery strategies.
• Maintained all records of project status and followed changes as per control procedures.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: MS SQL Server 2005 Enterprise, Windows Enterprise Server 2003, .NET, Microsoft Visual Studio 2003/2005, T-SQL