SUMMARY:

• Senior Tableau/BI Developer with 7+ years of IT experience in Analysis, Design, Development, Testing and Implementation of Business Intelligence Reporting using various versions of Tableau desktop 6.x/7.x/8.x/9.x/10.x and Tableau Server.
• Experience in Tableau Desktop and Server, creating highly interactive Data Visualization Reports and dashboards using Data Blending, Extracts, Calculation Fields, LOD, Filters, Actions, Parameters, Context Filters, Sets, Groups, Aggregate measures, Page Trails etc.
• Strong knowledge in Agile/ Scrum methodologies.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards and Tableau suite.
• Extensive knowledge of statistics and econometrics and experience with statistical software (SAS, Python).
• Create a more efficient conversion funnel by scoring your users' behavior with a predictive model.
• Created multiple predictive analysis reports using numpy, pandas etc. scripts.
• Created dashboards in tableau using databases in AWS, which includes SQL Server, Oracle and Amazon Redshift.
• Experience in developing multiple dashboards/reports using various charts like Stacked Bar/Pie, Line/Area, Donut, Dual - axes charts, Geo-Maps, Bubble, Scatter 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, Symbol Map, Box & Whiskers Plot, Word Cloud, Funnel chart, Waterfall, Gantt 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.
• Experience in TABCMD & TABADMIN, Email alerts, scheduling, data backup, SAML and driver’s setup activities.
• Experience in writing complex SQL queries involving multiple tables joins.
• End to end experience in Installation and configuration, designing and deploying rich graphic visualizations with Drill Down and Drop-down menu options using Tableau.
• Excellent Verbal & Written Communication skills and strong in Documentation.
• Performed Load and Performance Testing using Tab Jolt.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Hands-on experience in Trouble Shooting, Performance tuning of reports and resolving issues in Tableau Server and Reports.
• Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements.
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables.
• Having working experience in Normalization and De-Normalization techniques for both.
• Experience in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
• Experience in working with Relational databases such as MS SQL Server 2012/2008R2/2008, Oracle 12/c 11g/10g, DB2, Teradata, Salesforce, Microsoft power pivot and MS Access.
• Results oriented, self-starter looking for challenges, ability to rapidly learn and good interpersonal skills.

TECHNICAL SKILLS:

BI Tools: Tableau Desktop/ Server/ Online, Business Objects, Crystal Reports, Dashboard designer, Xcelsius. SSRS, PowerBL, SAP Lumira

Database: Teradata, MS SQL Server 2012/2008, DB2, SAP HANA, Oracle, Hadoop, MySQL, Hive

Languages: SQL, PL/SQL, Stored Procedure, Ansi 89, Ansi 92, Python

Data Modeling: Star Schema, Snow Flake, SCD Type 1/2/3, Data Dimensional Modeling, FACT and dimensions tables

Domains: Financial, Banking, Retail, Entertainment, Healthcare, Pharmaceutical

SQL Tools: Query Analyzer, SSMS, SQL Developer, Toad, SQL Assistant, SQL plus, TFS Methodologies: Kimball/Inmon, OLAP, OLTP, Waterfall, Agile

Web Tools: HTML, XML, AJAX, Java Script, AWS

Others: Unix, Linux, MS Word, Excel, JIRA, PowerPoint, SharePoint, Version One, VISIO 2007

PROFESSIONAL EXPERIENCE:

Confidential, New York, N. Y

Senior Tableau Developer

Responsibilities:

• Work closely with the Business stake holders to design, develop and deliver the visual analytics
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Gathered data from different data sources like Excel, Sales Force, Oracle and Hive etc.
• Integrated tableau with python using Tabpy.
• Effectively managed cross-functional team (IT, commercial, and customer) to deliver a new real-time recommendation solution based on SQL/Python analytics, BI Dashboards, and mobile tablets.
• Development of Python APIs to dump the array structures in the Processor at the failure point for debugging.
• Created dashboards in tableau using databases in AWS, which includes SQL Server, Oracle and Amazon Redshift.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Used parameters and quick filters. Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Designed and developed Big Data analytics platform for processing customer viewing preferences using Java, Hadoop, Hive and Pig.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non- geographic data using Java API scripting.
• Embedded Tableau reports/dashboards on to the external web pages.
• Published Workbooks and Dashboards to the Tableau server.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server.
• Created report schedules on Tableau server and Tableau Online.
• Generated the test plan specifying an overview of testing approach, testing strategy, scope.
• Extensively involved in doing user acceptance testing (UAT).
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.
• Performed report tuning using extracts, Cache options, removing unused fields.
• Created complex calculations including arithmetic calculations, custom aggregations, logic statements and quick table calculations.

Environment: Tableau Desktop /Tableau Server, Oracle, Hive, Cloud database, Salesforce, Microsoft PowerPivot, Pivotal HD, HDFS, Microsoft SQL server 2012, Python, AWS.

Confidential - St. Louis, MO

Sr. Tableau Developer/ Sr. Data Analyst

Responsibilities:

• Served as Tableau Developer meeting deadlines and budget requirements.
• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Wrapper developed in Python for instantiating multi-threaded application and running with other applications.
• Worked on several python packages like numpy, scipy, pytables etc.
• Development of test framework using the Python.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Created interactive dashboard and applied filter, highlight and URL actions to the dashboard.
• Developed Standard Operating Procedures (SOP) for Monitoring.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Mentored Power users in creating and modifying worksheets and data visualization dashboards.
• Involved in license management SLA's with Tableau support.
• Defined best practices for Tableau report development.
• Used TabAdmin and TabCMD commands in creating backups and restoring backups of Tableau repository.
• Provided production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Created FRs and Provided Tableau server and Tableau desktop training junior developers and Users.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Indicators (KPI) and Measures.
• Actively tracked schedule, clear and crisp communications with key resources, stake holders and SMEs to Kept everyone involved in the project on the same page, milestone tracking and avoiding scope creep issues.

Environment: Tableau Desktop 9.x/8.x, Tableau Server, MS SQL Server, Oracle, Hadoop, SAP HANAInformatica, Teradata, Salesforce, Windows 8, MS Excel/Access, SSIS, SSRS, Redshift, Python/R.

Confidential - Collegeville, PA

Sr. Tableau Developer/ Data Visualization Consultant

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Created and modifying Business Intelligence analytical reports using Tableau.
• Extensively used Visio to create Use Cases Diagrams, Activity Diagrams.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Built and published customized interactive reports and dashboards, report scheduling using Tableau server.
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, quick filters, data source filters, global filters, context filters, actions, Hierarchies feature in tableau.
• Executed and tested required queries and reports before publishing.
• Hands-on development assisting users in creating and modifying worksheets.
• Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.
• Implemented best practices and standards in developing Tableau reports.
• Integrated Tableau dashboards into internal web portal using Java Script API.
• Worked on the backend database development which was the source data for the tableau.
• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau server, allowing end users to understand the data on the fly with the usage of quick filters for on demand needed information

Environment: Tableau Desktop 8.3, Tableau Server, MySQL, SharePoint, Microsoft SQL Server, Windows, Microsoft Visual Studio, ERWIN, SSIS and SSRS.

Confidential, N.J

Tableau Developer / BI Developer

Responsibilities:

• Developed and created classes with Dimension, Detail & Measure objects and Developed Custom hierarchies to support drill down reports.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Conducted trainings to user on interact, filter, sort and customize views on an existing visualization generated through Tableau desktop.
• Extensively involved in identifying and solving the problems by coordinating with senior managers in emergency and normal issues to meet the goals.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Participated in Preparing Detailed technical documents from the functional specifications.
• Created Global Filters and applied for all the views in the dashboard.
• Created Data Source and published into the server for other users.
• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.
• Developed parameter and dimension based reports, drill-down 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.
• Extensively worked on Tableau Desktop, by creating Complex reports & Dashboards.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.
• Extensive experience in using URL's, Hyperlinks, Filters for developing Complex dashboards.

Environment: Tableau 6.0/7.0, Tableau Server, Webi, Lumira, UDT, Oracle, SQL, Share Point, Agile-Scrum, Vertica, Windows2003.

Confidential, New York, N.Y

BO Developer

Responsibilities:

• Analyze requirements and develop derived metrics, custom report objects as required.
• Involved in collecting the business requirements from users by understanding the Source System (OLTP) and interacting with the users.
• Created Complex Metrics forcing Dimensionality and Conditionality embedded with prompts.
• Developed logical and physical data model by defining strategy for Star Schema with Fact and Dimension tables with Detail, Summary, Look-up Tables, Indexes and Views.
• Extensively involved in data modeling to create attribute relationships.
• Developed new reports and converted existing reports for the business line to satisfy the specifications using Web Intelligence and Crystal Reports.
• Responsible for testing of developed reports and report objects.
• Created transformations to-do time series analysis and to compare the values at various times such as sales at this year versus last year, or month-to-date.
• Created Dynamic Enterprise Dashboards and utilized the new features to convert the dashboards into Flash mode.
• Supported all phases of the project such as, Analysis, Design, Development, Testing and Implementation of the project.
• Maintain design, development, testing and deployment task documentation.
• Created Applications, Dashboards, Metrics, Menus, Rules, Alerts and Analytics using application Foundation 6.5.
• Deployed QAAWS from import wizard.
• Used query as web option to build visualizations based on the reports built in Business Objects.

Environment: MS SQL Server 2008, T-SQL, Webi, Crystal reports, Dashboard Designer, SQL Server Integration Services (SSIS), MS Access, Windows.