SUMMARY

• Over 7 years of IT industry experience in Tableau Server, Microsoft SQL Server 2000/2005/2008 , MSBI SSIS/SSRS in OLTP and OLAP Data warehousing environments Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6/7/8.x
• Strong experience in SQL Server development, System Analysis, Design, Development.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
• Well versed in query optimization for performance tuning and monitoring of processes.
• Expert in creating universes on OLAP SAP BW, Oracle, SQL server, Teradata, DB2
• Extensive knowledge on visualization of data and knowledge of tools such as tableau.
• Worked on complex KPI scorecards, heat maps, tree views, circle views, bar charts etc... Data visualizations and interactive dashboard which helped business get a good handle on the team's productivity.
• Worked on different table calculations for different Scorecards.
• Published dashboards on Tableau public.
• Worked closely with Tableau support team during tableau server upgrades to 8.1
• Worked on data blending and increased the dashboard performance by extracting data.
• Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Workflows, Customized Analytics Reports.
• Deployed tableau server in clustered environment by adding worker machines.
• Expertise in migrating Universes and Reports between Environments like Developing, QA, Production.
• Extensive experience in dealing with Relational Database Management Systems, including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
• Experienced in SQL Server Business intelligence tools like SQL Server Integration services (SSIS),SQL Server Reporting Services (SSRS)
• Well versed in query optimization for performance tuning and monitoring of processes.
• Expert in creating universes on OLAP SAP BW, Oracle, SQL server, Teradata, DB2
• Extensive knowledge on visualization of data and knowledge of tools such as tableau.
• Worked on complex KPI scorecards, heat maps, tree views, circle views, bar charts etc Data visualizations and interactive dashboard which helped business get a good handle on the team's productivity.
• Excellent requirements gathering skills
• Worked on different table calculations for different Scorecards.
• Published dashboards on Tableau public.
• Worked closely with Tableau support team during tableau server upgrades.
• Worked on data blending and increased the dashboard performance by extracting data
• Work with Infrastructure to upgrade Tableau Server instances
• In - depth knowledge in building/maintaining Repository, Universes and creating adhoc reports.
• Working in both Semantic layers of Business objects like Universes and Business views as Data source for Crystal reports.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

Programming Languages: T-SQL, XML, Oracle

Business Intelligence tools: Tableau, Business Intelligence Development Studio (SSIS/SSRS), Informatica Power Center 7.1/8.6/9.1, Web intelligence, Xcelsius 2008 and Crystal Reports 2008 XI.

Data Base: SQL Server 2000/20 R2/2012, MS Access, Teradata

Operating Systems: XP, Windows NT / 2000. Windows Server 2003/2008/2008 R2, Linux

SDLC tools: Perforce, Team foundation Server (TFS), HP Quality center

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr.Tableau Reports Developer

Responsibilities:

• Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development.
• PreparingDashboardsusing calculations, parameters, calculatedfields,groups, sets and hierarchies in Tableau.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Connecting to multiple data sources including Big query, Oracle MDW and Sales force and using data blending functionality to blend the data.
• Used Sheet filters to produce multiple chart types in a single view.
• Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling behind the Mobile App usage with Quick Filters for on demand needed information with just a click of a button.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
• Created Crosstab's to display underlying data based on various graphs and charts created for further data analysis.
• Foundefficientways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Worked on various complex SQL Queries, Stored Procedures, Views, and User Defined Functions to implement the business logic.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with Mobile analytical portal and setup auto refresh feature.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change to ensure that the published dashboards are displaying accurate and up-to-date information.
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau 8x, SQL Server 2012, Oracle MDW, R12, Sales Force, Big Query, MS Excel, Windows 2007

Confidential, St Louis, MO

Tableau Developer

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development lifecycle.
• Working with Multiple data Connections.
• Experience with troubleshooting.
• Created Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Experience in tableau created Rapid Analytics and Reporting.
• Experience withTableau for Data Acquisition and data visualizations for client and customers.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Experience in Marks,Publisher and Security.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Responsible for setting up the Database logon info and parameters on Info View for the users to run the reports.
• Enhance/modify existing reports by creating new Parameters, Formulas.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Optimize various SQL queries to make the reports run faster.
• Expertise in Tableau Analysis.
• Experience with creating Worksheets, Dash boarding and info graphics.
• Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Experience in BI interactive Dashboards and TableauPublisher.
• Experience in developing Dashboard using OLAP cubes.
• Experience of Client-Interaction on onsite/Offshore.
• Involved in Test Evaluation, Summary Reports.
• Live, optimized connections to Teradata to leverage the investments.
• Expertise in connecting to Oracle and SQL databases and troubleshooting.

Environment: Tableau Server 6.1, Tableau Desktop 6.1, MYSQL Server, MS SQL Server 2005, MS SQL Server 2008 SSAS, Oracle 11i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL, UNIX, Linux RHEL 5.4

Confidential, Austin TX

Tableau Developer

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development lifecycle.
• Installation, maintenance and administration of Tableau Servers.
• Working with Multiple data Connections.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Experience withTableau for Data Acquisition and data visualizations for client and customers.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Involved in Custom Geo coding.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Expertise in Tableau Analysis.
• Created various reports like Master/Detail reports, Cross Tab reports, Slice and Dice reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Experience in BI interactive Dashboards and TableauPublisher.
• Experience in developing Dashboard using OLAP cubes.
• Experience of Client-Interaction on onsite/Offshore.
• Involved in Test Evaluation, Summary Reports.
• Live, optimized connections to Teradata to leverage the investments.
• Expertise in connecting to Oracle and SQL databases and troubleshooting.

Environment: Tableau Server 6.1, Tableau Desktop 6.1, MYSQL Server, MS SQL Server 2005, MS SQL Server 2008 SSAS, Oracle 11i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat, TSQL, UNIX, Linux RHEL 5.

Confidential, NYC, NY

TABLEAU Dashboard Consultant

Responsibilities:

• Read business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements.
• Interacted with business users for gathering requirements and look and feel of the applications to be developer.
• Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data.
• Created pie and bar charts and combined them into dashboards to show top content viewed by customers in each category including sports and news channels allowing interaction between the two charts for drill down analysis.
• Generated Dashboards by joining multiple complex tables.
• Developed geographic maps showcasing demographics broken into age, race, and income category that showed content viewed by individual customers across all content providers.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Executed and tested required queries and reports before publishing dashboards.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Administered user, user groups, and scheduled instances for reports in Tableau Server.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Worked on performance tuning of various OBIEE Reports / Dashboard
• Used calculations, variables, breaks, sorting, filters, alerts and prompts while developing and creating reports.
• Presented, interacted, and communicated with business and user groups for explaining the dashboards that I have created with the ability to change and view the data on the fly.
• Created complex reports using multiple queries and sub queries.
• Involved in migrating reports and WebI reports using the report migration utility.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: SQL 2005/2008, Tableau 6.0.x, Crystal reports, Xcelsius 2008 SP3, Live Office, SSRS, XML, Windows XP,UNIX, Oracle 11g/10g, MS-Excel 2007

Confidential

Tableau/SQL Report Developer

Responsibilities:

• Primarily involved in Onsite-Offshore co-ordination and acting as developer for developing new reports, enhancements and bug fixing using Microsoft SQL server.
• Developed dashboards using Tableau
• Worked in every phase of the SDLC life cycle of product development starting from business requirements gathering activities, design, development, Testing, deployment of the code in the production environment and UAT support.
• Worked with business stakeholders and participated in requirement gathering sessions to understand the business needs.
• Responsible for creating dashboards and overall creation of data visualizations.
• Created dashboard designing with effective data visualization of large data volumes from various data sources (SQL server, oracle, spreadsheets etc).
• Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, and Density Chart.
• Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets and hierarchies etc.
• Used Oracle, SQL server as data sources for designing Tableau Reports and Dashboards.
• Distributed Tableau reports using techniques like Packaged Workbooks, PDF etc.
• Provided customer support to Tableau users and Wrote Custom SQL to support business requirements.
• Expert level capability in Tableau calculations and applied complex, compound calculations to large, complex data sets.
• Worked closely with reporting team for deploying Tableau reports and publishing them on the Tableau and Share point server.
• Validated data at the row level and data level to ensure completeness and correctness of data
• Reconciled the report data with the source systems and reviewed it to find any data anomalies.
• Created custom date time calculations and macros in the reports.
• Created jobs, schedules and report views for the business users.
• Involved in administrative activities, doing deployment and monitoring schedules and jobs.
• Provided Assistance to users in building reports in Report Studio, Query Studio, and Analysis Studios.

Environment: Tableau Desktop, Tableau Server, Oracle 10g, MS Office, Oracle SQL Server 2005/R2, MS Excel, Quality Center, SQL, MS Project.

Confidential

T-SQL Developer

Responsibilities:

• 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.
• Recovered the backups of SQL Server production databases in test server environment.
• Analyzed poorly performing SQL queries to improve application performance.
• Coordinating with peer groups for Network, Infrastructure and DatacenterOperations.
• Built SSRS report to support reporting needs.

Environment: MS SQL Server 2005/2008, Windows 2000 Advanced Server, VB 6.0, and XML.