SUMMARY

• Over 7+ years of experience in design, development, implementation and administration of various Business Intelligence tools such as Tableau 9.0/8.0/7.0, SAS BI, JMP, OLTP and OLAP Microsoft SQL Server, SSRS and SSIS and expertise in implementing various functionalities of Data Warehouse.
• Experienced working in Agile/Scrum methodologies and fast pace dev. projects.
• Extensive Experience in analysis, modeling, design, and development of Tableau reports and Dashboards for analytics and reporting applications
• Extensive knowledge of Tableau architecture, design, development and end user experience
• Created Tableau Scorecards, Dashboards using stack bars, bar graphs, scattered plots, geographical maps and Gantt charts using show me functionality
• Working knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau
• Proficient in designing and deploying rich Graphic Visualizations with Drill Down and Drop Down menu options using Tableau.
• Involved inTroubleshooting, Performance tuning of reportsand resolving issues withinTableau ServerandTableau Desktop report Experience in Installation, Configuration and administrationof Tableau Server in amulti - serverandmulti-tierenvironment.
• Experience in Software Development Life Cycle (SDLC) that include duties like providing documentation on design, testing and migration from development to production.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved in installation of Tableau 8.x/9.x Desktop and Server Software
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan and performed upgrades from Tableau 8.3 to Tableau 9.1.
• Very proficient in working with large Databases in DB2, Oracle, Teradata and SQL Server.
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Expert in modeling, Extraction Transform Loading (ETL) using DTS and SSIS.
• Extensive Dimensional Modeling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables.
• Team player and self-starter with good communication skills and ability to work independently and as a part of the team.
• Excellent multitasking capability and ability to efficiently plan and prioritize projects along with strong technical and business management skills.

TECHNICAL SKILLS

DW/ETL: SSIS, Informatica, Power Center 8 .X,7.X, Talend, Teradata, Hadoop

Databases: SQL Server 2012/2008R / 2000/7, MS Access, Oracle 8i/9i/10g, Green plum database, MYSQL, Teradata, AWS

Reporting Tools: Tableau 9.1/9.0/8.3/8.2/8.1/8.0/7.0 , SAS, SSRS, Crystal Reports 9.0, Cognos, Power BI

Scripting: T-SQL, PL/SQL, Unix shell scripting, Java, C

Operating Systems: UNIX, Linux, Microsoft 2003/2000/ NT/98/95

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr. Tableau Developer

Responsibilities:

• Built Strategic, Analytical and Operational Dashboards using Tableau,
• Built custom tableau Dashboards for Salesforce for accepting the parameters from Salesforce in order to show the relevant data for that particular selected object.
• Created calculated fields and parameters besides appropriate filters and plotted the measures on the respective graphs with the base data.
• Used measures such as Individual axes, Blended axes and Dual axes.
• Developed Tableau dashboards embedding into Salesforce for the continuous data experience for the users.
• Best practices in order to save on IDP service provider and data security.
• Performed Tableau type conversion functions when connected to relational data sources.
• Worked on seamless single sign on experience for Salesforce and tableau users
• Demonstration of tableau Dashboards and its functionality to the business users for the self-service business intelligence
• Connecting and extraction from different data sources including Teradata, MS SQL Server, flat files using ODBC driver installation on the tableau server machines
• Developed Tableau Dashboard landing page for embedding into Salesforce in order to provide integrated views and navigation inside Salesforce for the users
• Developed various dashboards for non-Salesforce group of users for their specific goals of understanding data
• Customization of the Single sign on page for Salesforce and tableau
• Best practices to enhance the response time of Tableau Dashboards and the speed for the embedded Dashboards.
• Developed various Tableau Dashboards prototypes for future uses and conversion of current excel reports into Tableau Reports.
• Implemented row level security for the Tableau Dashboards
• Upgraded the Tableau server and desktop from 8.3 to 9.0.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server using SSIS.
• Effectively used tabcmd for the maintenance of server. Scheduled tasks, imported user list, restarted server and performed various other roles through tabcmd.

Environment: Tableau Desktop 9.0/8.3, Tableau Server, MS Office Suite, SQL Server, SSRS, SSIS, MS Excel, Salesforce

Confidential, Dallas, TX

Sr. Tableau Developer

Responsibilities:

• Developed interactive data visualizations and developed automated processes for updating content used in standardized Dashboards.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Developed story telling Dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Tableau server upgrade to tableau server 8.2
• Data connections to the Cloudera Hadoop server for the data analysis and visualization in tableau
• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• 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.
• Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Reviewed SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Created Views in Tableau Desktop which were published to internal team for review and further data analysis and customization using filters and actions.
• Involved in creating calculated fields, mapping, hierarchies and Drill through Reports.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Created extracts and published data sources on tableau Server for the users from various databases in Green Plum. Used complex joins and validated them by running and tuning long SQL queries.
• Extensive work on tabcmd utility for the custom scheduling and tableau server administration.
• Implemented best-practices for the dashboards with a solid understanding of the use of Contexts and their impact on performance.
• Involvement in end-to-end activity of dashboard development from requirements gathering to deployment phase.

Environment: Tableau Desktop 8.x, Tableau Server, SQL Server, SSRS, SSIS, MS Excel, Teradata, IBM Cognos, Hadoop

Confidential, Newport Beach, CA

Tableau Developer/ Tableau Admin

Responsibilities:

• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
• Worked with Trend Lines, Statistics, and Groups, hierarchies, Sets to create detailed summary level Report and Dashboard rs functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Building and 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.
• Effectively used data blending feature in tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• See a comprehensive view of your sales pipeline and results.
• Access dashboards from any browser or tablet.
• Involved in the installation of Tableau Desktop 8.0, Tableau server Application software
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.
• Creating New Schedule's and checking the task's daily on the server
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Worked on tabcmd to schedule the report's and setup email reports using command lines.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Environment: Tableau Desktop 8.0/7.0, Tableau Server/Administrator, Tabcmd, SSIS

Confidential, Atlanta, GA

Tableau Developer

Responsibilities:

• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• Involved in design and development of two main technological components, a Database to store data of all transactions related with each purchase and a Data Warehouse to store historical forecast and real demand by vaccine and by country, to measure the forecasting changes.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Assisted users to collaborate and publish reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Involved in conducting trainings to user on interact, filter, sort and customize views on an existing visualization generated through Tableau desktop.
• Created Complex workbooks and Dashboards by connecting to multiple data sources (Teradata) using Data Blending.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex Reports & Dashboards.
• Created complex Data Views Manually using multiple measures, also used Sort, Filter, Group, Create Set functionality.
• Published Reports, workbooks & data source to server and exported the reports in different Formats.
• Good experience in using URL's, Hyperlinks, Filters for developing Complex Dashboards
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures ( KPI ) and Measure

Environment: Tableau 7.0, SQL Server 2008 R2, SSMS, MS Excel, T-SQL.

Confidential, New York, NY

Tableau/SQL BI Developer

Responsibilities:

• Involved in creating various kinds of Dashboards and data visualizations like scatter plot, heat map, field map, symbol map, gun, bar and bubble chart using Tableau.
• Created calculated fields and parameters besides appropriate filters to plot the measures on the respective graphs with the base data.
• Implemented data blending to blend related data from two different data sources.
• Created Sets, Groups and Data Bins as per user requirements
• Created individual Worksheets and integrated it into Dashboards with suitable filters
• Implemented Tableau data extracts and created dependencies to trigger subscriptions once the extracts are finished through tabcmd utility
• Designed ETL packages with respect to various data sources and loaded the data into target data sources by conducting various transformations using SSIS.
• Created SQL server Analysis Projects andcreated multi-dimensional databases and OLAP cubesand dimensions using SSAS.
• Involved in maintaining and updating database objects like tables, views, procedures, functions using SQL queries to provide definition, structure, and to maintain data efficiently.
• Used SQL Profiler for troubleshooting, monitoring and optimization of SQL Server and database code and traced slow running queries and in order to optimize their performance.
• Conduct client interviews, high-level reviews, and be part of focus groups to derive and execute action plans, meet deadlines, and follow industry standards and best practices.
• Assist BAs in the team with appropriate documentation and domain knowledge.
• Interaction and coordination with end users and management to identify Business system needs evaluated solutions for business problems bottlenecks and evaluated alternate methods to increase efficiency and improve control.

Environment: Tableau 7.0, SQL Server 2008, SSIS, SSAS, MS Office, MS Excel.

Confidential

ETL Developer/Data Analyst

Responsibilities:

• Assessing and analyzing the quality of data fit for use.
• Extracting the Data from the required sources and loading into the Target system.
• Developed complex Talend ETL jobs to migrate the data from flat files to Oracle database.
• Monitoring the system objects like huge files/ unused indexes and taking necessary steps to improve the performance of applications as well as batch jobs.
• Improving the batch jobs performance, by suggesting the effective ways of design to application development team and automated the batch jobs by writing complex stored procedures.
• Resolution and analysis of critical end-user issues.
• Responsible for the system stability
• Integration of the new web services into the other applications, to improve the system performance by reducing the number of connections
• Creation of tickets and getting the required approvals to perform any changes in production environment if required.
• Performing Analysis like Column Analysis, Table Analysis and Redundancy Analysis necessary for the Data

Environment: Talend Data Quality, Oracle 10g, Windows XP, Flat Files, Thod.

Confidential

SQL Server Developer/SQL Server DBA

Responsibilities:

• Assisted clients with physical database modeling, data archiving strategies, data purges and disaster recovery planning.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification, indexing and statistics update.
• Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.
• Involved in writing T-SQL statements for retrieval of data.
• Worked on performance tuning of T-SQL queries and Stored Procedures. Optimized query performance by creating indexes.
• Performed daily database backup & restoration, monitored the performance of the Server.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database. Created necessary indexes to make data retrieval process faster.

Environment: MS SQL Server 2005, SSMS, T-SQL, DTS, Query Analyzer, SQL Profiler.

Confidential

Intern SQL Server Developer

Responsibilities:

• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, indexing and statistics update.
• Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.
• Involved in writing T-SQL statements for retrieval of data.
• Directly interacted with clients to elicit the requirements and translate them into terms that development team can comprehend.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database. Created necessary indexes to make data retrieval process faster.
• Trained by senior developer with respect to project specific tasks.
• Excellent multitasking capability and ability to efficiently plan

Environment: MS SQL Server 2005, SSMS, T-SQL, DTS, Query Analyzer, SQL Profiler.