PROFESSIONAL SUMMARY:

• 8 years of extensive TableauExperience in Enterprise Environment and TableauAdministrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 8/7/6 and SQL, PL SQL and VB scripting.
• Deploying and scheduling Reports to generate all daily, weekly, monthly and quarterly Reports including current status. EstablishedBest Practicesfor EnterpriseTableauEnvironment and application intake and development processes.
• Extensive experience inTableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Expertise in writing SQL Queries, Dynamic - queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Experience in designing Data Mart and Data Warehouse using Erwin Star and Snowflake Schemas.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Blendeddata frommultiple databases into one report by selecting primary key’sfrom each databasefor data validation.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Developed story telling 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.
• Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased 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.
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating and implementing interactive Dashboard and other user interface elements.
• Expert in T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Thorough understanding of Kimball/Inman strategies, KPI, Data mining structures.
• Advanced extensible reporting skills using SQL Server reporting services (SSRS). Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP, Sub reports, ad-hoc reports, parameterized reports, interactive reports & custom reports .
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment.
• Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures.

TECHNICAL SKILLS

Business & Technical skills: Tableau desktop 6/7/8, Tableau Server 6/7/8, Tableau Reader 6/7/8, Tableau Public 6/7/8, MS SQL Server 2012 /2008R2/2008/2005/2000, SSRS, SSAS 2012/2008R2/2008/2005/2000, SSIS 2012/2008R2/2008/2005/2000, DB2, MS-Access 2013, MS Excel, Erwin 8.0/7.2/7.1, MS Visio 2010/2007/2005, VB 6.0, T-SQL, HTML, XML, XSL, Java script, VB Script, C#, Visual Studio 2012/2008 R2/2008/2005/2000, ODBC, MS office, Windows NT/ 2000 Server/ XP, Oracle, DB2.

PROFESSIONAL EXPERIENCE

Confidential, Mettawa, Illinois

Tableau Developer/Administrator

Responsibilities:

• Actively involved in creating Custom Reports by understanding the Management and senior level Management’s need to support in business.
• Performed the administration, configuration, maintenance & upgrade of Tableau Servers.
• Ensured Tableau Server configuration settings are optimal.
• Managed Data Extract Schedules and Access to Reports.
• Create custom SQL connections and calculated fields within Tableau to facilitate automated production of data visualizations.
• Build interactive Tableau dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently.
• Worked on the development of Tableau Dashboard reports for Key Performance Indicators for the top management.
• Rebuild existing Reports into Tableau Visualizations with user and action filters
• Published Workbooks by creating user filters so that only appropriate users can view/edit them.
• Generated context filters and handled performance issues while dealing with huge volume of data.
• Generated tableau dashboards with forecast and reference lines.
• Installing and Configuring of Tableau Server and Tableau Desktop.
• Usage of Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Creating groups, projects, workbooks and the appropriate permissions for Tableau server and security checks.
• Involved in Tableau Administration Tool for configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platform like web portals.
• Creating Bookmarks, Actions, worksheets and workbooks.
• Created extract files for improving the performance and Tableau server performance tuning for optimization
• Involved in troubleshooting and resolving issues within Tableau Server and Reports
• Used Tableau command line commands to publish workbooks periodically.
• Automation of sending Email process on a daily basis, to view refreshed tableau dash boards.
• Performed the administration, configuration, maintenance & upgrade of Tableau Servers.
• Ensured Tableau Server configuration settings are optimal.
• Managed Data Extract Schedules and Access to Reports.
• Performance tuning of workbooks, data sources, and providing best practices for user community.
• Provided guidance and insight on data visualization and reporting/dishoarding best practices.
• Documented reporting requirements and defined report templates and dashboard specifications.
• Established, maintained and ensured adherence to application standards for data reporting.
• Used Tableau to contextualize information in a manner suitable to executive audiences.
• Identified key business metrics measurements and developed methods to represent data in support of the measurements.

Tools & Technologies: Tableau desktop 8, Tableau Server8, Tableau Reader, Tableau Public, Tableau online, MS SQL Server 2012, SQL server reporting services (SSRS) 2012/2008 R2, MS Excess 2013, and MS Excel 2013, Oracle, DB2, Salesforce.

Confidential, Morristown, New Jersey

Tableau Developer/Administrator

Responsibilities:

• Redesigned the data source having data from different sources into one SQL Server and to tableau.
• Interacted with Business Teams to understand what needs to be visualized.
• Understanding what the client is expecting out of the reports, data cleaning to get to the right numbers for the weekly report.
• Generated tableau dashboards with forecast and reference lines.
• Analyzed and gained understanding of the underlying data. Enterprise Key Metric Tableau dashboard is sourced from multiple Excel files.
• Designed Tableau dashboards for Project/Resource analysis application and Enterprise Key Metric application. These dashboards were utilized by higher management to do analysis, product development and their market share.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Developed Tableau dashboards pertaining to Revenue and Sales monitoring using Tableau 8.1.
• Demo of Tableau dashboard to users to enhance their knowledge on all the key capabilities of application.
• Also developed a process in the company to generated tableau dashboards, which can be used for all the clients in the company by gathering the requirements.
• Build interactive Tableau dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently
• Worked on the development of Tableau Dashboard reports for Key Performance Indicators for the top management
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, actions, Hierarchies 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.
• Converted metric insight reports to tableau reports.
• Working extensively with Tableau Business Intelligence tool to develop various dashboards.

Tools & Technologies: Tableau desktop 8, Tableau Server, Tableau Reader, Tableau Public, Tableau Online Windows 2007-Advanced server and Enterprise Server 2003, MS SQL Server 2012, SQL server integration services (SSIS) 2012, SQL server reporting services (SSRS) 2012, TSQL, Erwin tool 8.0, Oracle, DB2

Confidential, Jersey City, NJ

SQL/SSIS/SSRS Developer/Tableau Developer

Responsibilities:

• Participated with Business Analyst in order to gather requirements for design and implementation of database.
• Designed logical/physical data models using Erwin tool 7.2.
• Providing ad-hoc reports in both graphical method and tabular method upon requirement by client and management for operational & management requirements
• Generated complex reports utilizing the features like Hierarchy, new Calculated Columns, Drill functionality, Tables, graphs, Line Charts and Bar Charts
• Created Parameters to achieve desired functionality
• Implemented extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Created Filters, Groups, Sets on Tableau Reports
• Publishing sheets and dashboards on server using Tableau Desktop
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Used Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Implemented Binning & Blending concepts in my Tableau Reports
• Worked on Dual Axis concept while working with reports
• Created conditional filters and Action links to filter the data on dashboard
• Develop and maintain the documentation level to the team and business
• Designed high level ETL architecture for overall data transfer from the OLTP to Data warehouse with SSIS and also prepared ETL mapping processes and maintained the mapping documents.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views, and Roles.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.

Tools & Technologies: Tableau desktop 6, Tableau Server 6, Tableau Reader, Tableau Public, Tableau Online, MS SQL Server 2008R2, Enterprise Edition, MS SSRS 2008R2, MS SSIS 2008R2, T-SQL, VB Script, Windows Server 2007, Erwin 7.2

Confidential - Mundelein, Illinois

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Assisted in walkthroughs/sessions (JRDs/JADs) with business stakeholders and SMEs as well as development teams to gather system requirements. Worked with business analysts to develop and finalize test plans.
• Analyzed key business requirements and assisted in the development of Business Requirement (BRS), Functional Requirement (FRS), and System Requirement Specification (SRS).
• Assisted in generating ETL packages with different data sources and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Documented specifications for transformation of old data from various sources like flat files, MS Access, and Excel into SQL Server using SSIS Packages.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Acted as Member of the reporting project team for analyzing and designing a system that would improve reporting of customers data.
• Documented specifications for various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Employed SQL queries for back end testing and data validations

Tools & Technologies: UML, MS Access, MS Office, MS Visio, SQL Server 2005/2008, SSIS, SSRS,VB Script

Confidential

Data Analyst/SQL Developer

Responsibilities:

• Gathered information from various sources and evaluate them according to the client's needs.
• Performed QA Testing of newly added Validations within Salesforce customized pages, in addition to performing detailed Smoke Testing and Regression Testing of existing contact & account functionality.
• Create & update client user manual for a Customized Salesforce CRM, to reflect all software changes completed since the last release.
• Worked on compiling user info using excel to upload new data into Salesforce via a customized Client User Interface.
• Troubleshoot errors generated when uploading data into Salesforce using a customized Client User Interface.
• Researched and recommended multiple Marketing Application Tools for client use, providing more efficient Marketing campaign functionality and metrics. Provided training and other assistance in a BA role during the implementation of Campaign Monitor & Mailchimp.
• Worked on various salesforce.com standard objects and fields like Accounts, Contacts, Leads, Opportunities, Reports, Dashboards, Marketing, Campaign and Sales.
• Designed the Custom objects, validation rules, Page layouts, Custom tabs, Components, Auto-Response Rules to suit to the needs of the application.
• Customized page layouts for Salesforce standard and custom objects.
• Configured security and organizational hierarchy for sales for Salesforce implementation.
• Created PL/SQL procedures to populate base data mart.
• Analyzed and fine-tuned PL/SQL scripts.
• Involved in Design and development of Workflows rules, triggers, validation rules and other customizations with Salesforce.
• Designed various types of Email templates (HTML and custom), New Templates, Mail Merges and created automated Email Process for new and existing customers using campaign monitor.
• Administered Salesforce CRM applications for Sales, Marketing and Support Departments.

Tools & Technologies: Visual Studio 2005, T- SQL, Visual Source Safe 2005 (VSS), XML, MS-Access, MS-Excel, MS- Power Point, MS- Word, MS- Project, HTML,C#, Java Script, Salesforce