SUMMARY

• Over 7+ years of experience with Business Intelligence Tableau 9.2/9.1/9.0/8.2/8.1/8.0/7, Microsoft SQL Server, Microsoft Excel.
• Reports development using various reporting tools like Tableau.
• Involved in creating Dashboards as needed using Tableau Desktop and Tableau Server.
• Involved installation of Tableau desktop 9.2.
• Involved in creating dashboards and reports in Tableau 9.1, Created report schedules on Tableau server.
• Experience in development of Storyboards and Dashboards using Tableau Desktop.
• Good Knowledge on Tableau Architecture, Publish workbooks, Scheduling refresh.
• Experience in Tableau Enterprise Environment and Tableau Administration.
• Experience includes technical support, troubleshooting, report design and monitoring of system usage.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
• End to end experience in designing and deploying data visualizations using Tableau.
• Experience in creating aggregates, hierarchies, charts, table calculations, trend lines and calculated measure.
• Designed and developed various analytical reports from multiple data sources by blending data on a single Work sheet in Tableau Desktop.
• Designing outstanding visualizations using tableau software.
• Extracted data from SQL Server 2008 into data marts, views, and/or flat files for Tableau workbook consumption using T - SQL.
• Experienced using tableau against multiple data sources like SAP data, Oracle, SQL Server etc.
• Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Dimensional maps, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
• Publishing and presenting dashboards on web and desktop platforms.
• Creating dashboards using calculations, groups, sets, parameters, calculated fields and hierarchies.
• Experience in creating filters, quick filters, data source filters, global filters, context filters and user filters.
• Experienced in Databases such as Oracle, Microsoft Access 2000, DB2 and SQL server2000/2005.
• Installed, configured, maintained Tableau Environments; DEV, QA, and Production.
• Responsible for maintaining User and Group permissions across servers and dashboards.
• Extensive experience working as a Business Intelligence Consultant with specialization in Business Objects 6.0/ 6.5/ XIR2/ Crystal XI and Web Intelligence.
• Extensive experience working in Windows, UNIX, LINUX environments.

TECHNICAL SKILLS

BI Tools: Tableau Desktop, Tableau Server, Tableau Public, Tableau Online

Database: SQL Server, DB2, Oracle, MS Access

Other Tools and packages: SQL Server Management Studio, Microsoft Visual Studio, Microsoft Office, SQL Developer

Languages: SQL, C, C++, Java, HTML, C#

Reporting Tools: Tableau

Operating Systems: Windows 2000/2003,2008 Server, Windows 95/98/2000/XP/7/8/10, Ubuntu

PROFESSIONAL EXPERIENCE

Confidential, Chevy Chase, Maryland

Sr. Tableau Developer

Responsibilities:

• Involved in reviewing business requirements andanalyzingdata sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Created views/reports inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Converted charts and Crosstabs for further underlying data analysis inMSExcel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blendeddata frommultiple databases into one report by selecting primary key’sfrom each databasefor data validation.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Developed storytelling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Environment: TableauDesktop 8.0 & Server 8.x,DB2, SQL Server 2008, MS Office

Confidential, MA

Sr. Tableau Developer

Responsibilities:

• Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7, 6 and 5.1. Also involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.
• Worked closely with all team members in implementing Tableau BI tool in all IT projects.
• Generated reports using SQL queries in Tableau 5.1/6.0/7.0 and published them to users in online thru Tableau server.
• Involved in generating Daily/Weekly Sales & Finance trending reports using Tableau by identifying the dimensions, measures, measure values and level of details for Business Analytics & Top Executives to give an overview current Trends.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Managing the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards reports and workbooks from Tableau Desktop to Tableau servers.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Assisted users to publish and collaborate reports via a web browser embed Tableau views in other web applications like SharePoint.
• Worked on Business Objects Universe development with Universe Designer tool and Document development primarily with Web Intelligence, Dashboards for executive management decision-making tools.
• Used Flash Variables, Extremely Extensive Dynamic Visualizations, Chart and Map Drill Downs
• Used Open Docs to allow users to move from the Dashboard to its related detailed Webi report and also from Webi reports to another reports using hyperlinks achieved through using OPEN Docs
• Used User row level security for data in the Dashboard.
• Enabled Dashboards on mobile devices.

Environment: Tableau 7.0, 6.0, 5.1, Teradata 13, Oracle 10g, Oracle SQL Server R2, MS Office Suite.

Confidential, Atlanta, GA

Sr. Tableau Developer

Responsibilities:

• Developed reports using custom SQL queries and created .twbx, .tde and .twb files.
• Created reports on desktop and filtered them by various measures and dimensions.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Converted charts and Crosstabs for further underlying data analysis in MS Excel.
• Involved in creating Dashboards using advance table calculations, parameters, calculated fields, groups, sets, forecasting and hierarchies in Tableau.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Have been involved in creating Stacked bar, Filters, Scatter Plot, Geographic Map, Histograms etc
• Designed and developed monthly, quarterly and yearly reports at branch level.
• Scheduled incremental refresh and subscriptions.
• Identified resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Scheduled data refresh onTableauServer for weeklyand change to ensure that the views and dashboards were displaying the changed data accurately.
• Developed effective and interactive Dashboards using Parameters and Actions.
• Actively participated in clarification meeting with the Clients.

Environment: Tableau Desktop 9.0, 9.1 & 9.2 Server, MYSQL Server, MS SQL Server 2005, HTML5.

Confidential, Detroit, MI

Tableau Developer

Responsibilities:

• Created dashboard views from NetMining, Dealer.com and UPTRACKS.
• Worked on Inventory, Sales and Service, Advertising, Social, Website, Leads, Website Metrics to create the visualisation dashboards for the Dealers.
• Created KPIs across channel presence, digital media reach and engagement into a single Digital IQ scorecard. Evaluated the score for each dealer, zone, region and nationally to gauge system performance using the Tableau.
• Created Rich Graphic visualization/dashboards to enable a fast read on sales and key business drivers and to direct attention to key area
• Incorporated a regional and national comparative / benchmark metrics to give context to individual performance
• Online and offline KPIs are included for sales and inventory data through Paid Search and CRM
• Created a proof of concept for the optimal data integration process.
• Designed high-level view of the current state of dealer operation, leads, and website activity using Tableau
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI’s
• Created workbooks and Dashboards using calculated metrics for different visualizationrequirements
• Drew upon full range ofTableauplatform technologies to design and implement proof of concept solutions and create advanced BI visualizations.

Environment: Tableau Desktop 7, Tableau server / Administrator, tabcmd, Hadoop, HDFS, Map Reduce, Hive, Sqoop, UNIX.

Confidential, Knoxville, TN

MSSQL Server Developer/Report Programmer and Developer

Responsibilities:

• Plan, design, and implement application database code objects, such as CONCUR, KRONOS, and LOFTWARE.
• Worked with end users to resolve their issues on all applications on priority basis using ITSM tool.
• Involved and supported users with ITSM incidents and Change management issues.
• Implemented Service Now and Migrated data from ITSM databases to Service Now.
• Resolved issues on Concur Travel and expenses configuration issues Audit rules and Cognos reports.
• Migrated data and objects from Oracle toSQLusing SSMA (SQLServer Migration Assistant).
• Processed Daily expenses through SSIS jobs by collecting data from Concur FTP servers.
• Configured user delegation roles in Concur. Created documentation on HCP recipients for each country globally (complete Spend and Aggregate Spend Projects).
• Created reports and deployed on SharePoint Servers. Created users and User roles on SharePoint servers.
• Migrated from ITSM to Service now with along with vendor. Customized the application reports and worked as Service now admin.
• UpgradedSQLDatabases and changed compatibility levels, configured and implemented Always On availability.
• Created Shared storage, created machine user names to resolve configuration issues in Always On availability setup.
• Build and maintainSQLscripts, indexes, and complex queries for data analysis and extraction.
• Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
• Experienced in extracting data from Development / UAT / Production servers by using SSIS.
• Provide database coding to support business applications using T-SQL.
• Experienced with Clustering setup and Active Directory in Windows 2010.
• Implemented Always on Availability between Primary and secondary Production servers with configuring Shared Witness server and Windows Failover cluster.
• Develop new processes to facilitate import and normalization, including data file for counter parties.
• Work with business stakeholders, applicationdevelopers, and production teams and across functional units to identify business needs and discuss solution options.
• Created many Cascaded parameters in the reports using MDX and T-SQL.
• Involved in Database Modeling, Database Mapping, And Normalization Using ERWIN.
• Design/Build Extract Transform Load procedures inSQLServer Integration Services using packages to import/export data feeds to/from data warehouse and claim system.
• Design and develop reports usingSQLServer Reporting Services (SSRS) and Crystal Reports.
• Migrated databases among the servers using copy, attach/detach, copy/restored utilities.
• Worked on SQLServer Integration Services (SSIS) for data integration from heterogeneous data sources, Ad hoc request and ETL related operations.
• The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Supported 24X7 in production issues and User's issues on applications.

Environment: Windows Server 2008 Enterprise Edition, MS-SQLServer / 2008 R2 / 2005, IIS, SharePoint, Clustering, VB.Net scripting, SSIS, SSRS, T-SQL, Visual Studio 2013/2012/2008, Toad, Indexes, Cluster, .Net Framework 3.5, 4.0, snapshot, backup/restore, MS Office suite 2003

Confidential

SQL Developer

Responsibilities:

• Collected business requirements from different sources and wrote the technical specifications for building the Data model.
• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• Transformed the Business Requirements into Functional and Non Functional Requirements and interface between the client and the development team.
• Interact with internal and external clients to understand requirements, explain issues and prioritize work.
• Created functions, stored procedures, triggers and constraints using T-SQL.
• Developed database structures and SQL queries for web applications.
• Worked with development team to improve application performance by tuning queries.
• Analyzed poorly performing SQL queries to improve application performance.
• Connected to different types of sources to extract data and destinations to load the data using Connection manager.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

Environment: SQL Server 2005/2008, SQL Developer, Windows XP, MS Access, MS Excel