SUMMARY:

• Overall 6 years of experience in IT industry as Tableau Developer with Data Analyst and Business Intelligence tools with strong background in Databases and Data warehousing concepts.
• Experience in Design, Development, Integration, Implementation and Maintenance of MS Business Intelligence and Tableau platforms like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 10.5/10.4/10.3/10.2/10.0/9.2/9.1.
• Installed Tableau 10.5 version and worked on 64bit operating system. Compared and tested with previous versions. Observed the advantage of improved Data engine with usage of .hyper format.
• Utilized all Tableau tools including Tableau Desktop, Tableau Reader and Tableau Public. Strong understanding of project life cycle and Software Development Life Cycle (SDLC) methodologies including RUP, RAD, Waterfall and Agile.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices. Developed Tableau dashboards for data discovery and routine reporting needs.
• Expert in design/development using Tableau Desktop for Data visualization, reporting and Analysis. Cross map, Scatter plots, Geographic map, Pie charts and Bar charts, page trails and Destiny chart.
• Expert in resolving the reports, dashboards, performance issues and implementing best practices using Tableau.
• Extensive experience in designing, developing and publishing visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
• Installed Tableau Server in a distributed environment and worked on Worker Nodes and added additional worker nodes. Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Experience in Publishing and Sharing Workbooks, Data Sources with User Filter to Tableau Server, Setting Schedules, Subscriptions, Authorization and Permissions, incremental refresh extracts and updating server data that are using extracts.
• Used the REST API with Tableau server to manage and change Tableau server resources programmatically.
• Used API for the functionality enhancement on server for site users and sites on Tableau server.
• Experienced in Creating the extracts, published data sources to Tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Exceptional experience in dealing with various databases like Teradata, Oracle, DB2, SQL Server, MS Access, and Flat files.
• Proficient knowledge in dealing with RDBMS including E/R Diagrams, Normalization, joins, keys and Data import/Export.
• Experience in writing SQL Queries, user defined functions, Triggers, Constraints, Indexes, stored procedures and Batch Scripts using various DDL and DML commands, Query optimization and performance tuning.
• Experience in writing SQL joins, Nested Queries, Unions, Multi - table joins and experience in creating scheduling jobs, sending alerts.
• Expertise in ETL tools like SQL server integration services (SSIS) and Relational Database Management systems.
• Hands on experience of data preparation experience with Alteryx.
• Good command on MS SQL Server worked on Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAP).
• Extensive experience on using SQL for Tableau and in writing parametrized queries for generating Tableau reports, formatting reports layout and expressions.
• Worked on all phases of Data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Strong understanding of Data Modeling in data warehouse environment such as Star schema and Snow flake schema.
• Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Required Specifications (SRS) and identifying interface and Business Process Specifications.
• Strong Data analysis expertise in the field of Financial Analysis, Financial Modeling, Capital Markets, Industry research and Product Development.
• Ability to quickly master new concepts/applications & identify operational deficiencies and system improvements. Strongly self-motivated, willing to assume responsibilities & very detail oriented. Excellent at communication, analysis & presentation.

TECHNICAL SKILLS:

Operating Systems: Linux, MAC OS, Windows.

Software Packages: MS Office (Word, Excel, PowerPoint, Visio, Project), Rational Rose.

Programming Languages: SQL, PL/SQL, T-SQL, C, Python, SAS, HTML, XML.

Web technologies: HTML, CSS, JavaScript API.

Database Servers: MySQL, MS Access, Oracle 9i/10g, SQL Server 08/10, Teradata, Netezza, Amazon Redshift, DB2

Processes/Technologies/Tools: Waterfall, Agile, RUP, Clear case, Workflow and UML, Django framework.

Analytical Tools: Tableau (Desktop / Server / Reader), Business objects, SSRS, SSAS, ETL.

Tableau Desktop: 10.5/10.4/10.3/10.2/10.0/9.3/9.2/9.1 , Used various Tableau versions to create visualization appealing to end users and customers.

Tableau Server: 10.5/10.4/10.3/10.2/10.0/9.3/9.2/9.1 .

PROFESSIONAL EXPERIENCE:

Confidential - Bridgewater, New Jersey

Sr. Tableau Developer/ Data Analyst

Responsibilities:

• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Interacted with Subject Matter Experts & End Users and gathered business requirements.
• Acted as liaison between Business Intelligence and Business User groups to relay change requests.
• Worked in coordination with clients for Feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.
• Deployment of Tableau Server in clustered environment by mapping server nodes to primary machine
• Developed the Teradata Macros, Stored Procedures to load data into Incremental/Staging tables and then move data from staging into Base tables.
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
• Created Heat Map showing sales data by color that were broken into regions allowing business user to understand sales pattern (least vs. highest) in various regions.
• Dealt with initials, delta and Incremental data as well Migration data to load into the Teradata
• Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.
• Generated guided navigation links for Interactive dashboards in Tableau.
• Used extensively Teradata Analyst Pack such as Teradata Visual Explain, Teradata Index Wizard and Teradata Statistics Wizard.
• 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.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Used utilities of FLOAD, MLOAD, FEXP, TPUMP of Teradata and created batch jobs using BTEQ.
• Developed views and templates with Python and Django's view controller and templating language to create user-friendly website interface.
• Knowledge about setting up Python REST API Frame work using Django.
• Extracted large data to Tableau from Amazon RedShift to analyze, visualize and share information.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states
• Developed metrics, attributes, filters, reports, dashboards and created advanced chart types, visualizations and complex calculations to manipulate the data.
• Used Python to build statistical models involving Linear Regression, Ridge Regression, Lasso Regression, Elastic Net Regression, Gradient boosting for estimating the risks of assets.
• Worked with Individual Axes, Blended Axes, and Dual Axes.
• System data to ensure accurate data for reporting.
• Worked in Business Intelligence integration wizard to integrate query templates, BEX Query Designer, BEX Analyzer. Created numerous time calculation customer exit variables in project management for reporting in CMOD using ABAP (Advanced business application programmed) language.
• Created and updated stored procedures and functions to meet the requirements and changes specified by the users
• Pushed all the created stored procedures and functions to the development, training and production servers.
• Ensured on-time and on-budget performance of the assigned efforts to the mutual satisfaction of the business partners/ sponsors.
• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Provided post implementation production support.

Environment: Tableau 10.x/9.x (Desktop/ Server), Teradata 15.10,14.10, Python (2.x/3.x), MS SQL Server, SAS, Teradata SQL Assistant, Teradata Manager, Java Script, Oracle 10g, Erwin

Confidential - Phoenix, Arizona

Sr. Tableau Developer/ Data Analyst

Responsibilities:

• Facilitated interview sessions to identify Business rules and Requirements and then documented in a format that can be reviewed and understood by the whole team.
• Provided mock up visuals to speed up requirements visualization.
• Translated business needs into technical requirements.
• Worked closely with business and data teams to gather key stakeholder requirements and convert them into technical specifications.
• Designed, developed, tested, and maintained Tableau reports and dashboards based on user requirements.
• Published the workbooks and data sources to the tableau server for further review as well as to enable users to do slicing and dicing on data to derive more insights.
• Created action filters, Parameters and calculated sets for preparing dashboards and Worksheets.
• Developed and implemented SSRS reports with multi-parameter, chart, sub-report and interactive sorting capability for administration and accounting department.
• Administered user, user groups, and scheduled instances for reports.
• Executed and tested required queries and reports before publishing.
• Converted metric insight reports to tableau reports.
• Performance tuning of reports and dashboard.
• Resolved the bugs reported by QA team in existing dashboards.
• Built Tableau visualizations against various Data Sources like Flat Files (Excel, Access) and Relational Databases (Oracle, Sybase).
• Effectively used data blending, filters and hierarchies.
• Creation of packaged workbooks (TWBX) for end-users.
• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Effectively used bar chart, bubble chart, maps, and heat maps to answer business questions.
• Work with product management to determine, validate and implement a long-term strategy for Tableau.
• Conducted training session for business users.
• Scale up/ Scale out Tableau Server to meet the requirements of the company.
• Administered Tableau server and created tab admin scripts for automating backup procedures through windows scheduler.
• Responsible for implementation of Tableau desktop and server.
• Implemented data security by creating user filters.
• Conducted Business Acceptance and user Acceptance testing and sign-off meetings.

Environment: Tableau 10.x/9.x (Desktop/Server), SSRS, Oracle, Toad, SQL Server, MS Office Suite (Excel, PowerPoint).

Confidential - Marietta, Georgia

Tableau Developer/ Data Analyst

Responsibilities:

• Developed various Dashboards using objects such as Chart Box (Drill Down, Drill Up) List, cross tab etc. using Tableau.
• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web.
• Built Tableau dashboards for showing insights of different portfolios dashboards and customer level detailed.
• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web.
• Developed various data connections from data source to Tableau Desktop for report and dashboard development.
• Designed dashboard templates as per the requirements and dashboards content which included bar charts, water fall charts, score cards, Gantt charts, Bubble charts, Word maps, Geospatial visualizations, network charts.
• Generated reports using SQL queries and published them to users through Tableau analysts.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the business analysts.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Conducted performance tuning in Tableau improve report response time.
• Assisted users with questions and issues using Tableau Worked with various infrastructure teams and Tableau support team to help improve dashboard response time.

Environment: Tableau Desktop 7/8.1, Tableau 8.2/8.3/9.0, Tableau Server, MS Office Suite, SQL Server, Power BI, MS Excel.

Confidential

Tableau Developer/ BI Developer

Responsibilities:

• The Project is to design and implement Tableau applications including but not limited to reports, Dashboards, Extracts, ad-hoc reports etc. Tableau reports were implemented on sales/Returns database, Order management database and inventory Database.
• Extracting data from different sources connecting them and used the same to create dashboard.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Used excel sheet, flat files, CSV files to generated Tableau ad-hoc reports
• Used sheet filters to produce multiple chart types in a single view.
• Creating data blending incase of merging two different datasets.
• Created rich dashboard using Tableau dashboard and prepared user stories to create compelling dashboards to deliver actionable insights
• Preparing Dashboards using calculations, parameters in Tableau and Developing Tableau that provide clear visualizations of various industry-specific KPIs.
• Access and change extremely large datasets through filtering, grouping, aggregation, and statistical calculation.
• Consult with customers and inside partners to accumulate necessities and set milestones in the research, advancement, and execution periods of the project lifecycle.
• Understanding of Tableau features like calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Developed and Published Packages in Framework Manager- Connecting and testing the data source, created database layer, business layer and presentation layer defining the cardinalities and appropriate relationship between query subjects.
• Created Standard Reports using Report Studio, like Dashboards, List Reports, Crosstab Reports and Chart Reports and Ad- Hoc Reports using Query Studio.
• Created reports which involved Multiple Prompts, Filters, multi-query reports.
• Implemented drill through on columns and cells to get the detailed information, and used style, render variables formatted the reports using layout component reference and Classes.

Environment: Tableau (desktop/server) Oracle Database 8i / 9i, SQL, PL/SQL, Oracle 9i Data Guard, MS Visio, Java Script, HTML.

Confidential

Tableau Developer/ BI Developer

Responsibilities:

• Analyzed the large sets of data using various techniques such as quantitative analysis, advanced analytics and statistical modeling to find solutions.
• Developed predictive statistical models using statistical analysis and other predictive modeling techniques.
• Build and analyze queries from databases using SQL.
• Designed, Developed and Build Informatica Power Center Mappings and workflows using Teradata External Loaders.
• Participated in weekly staff meetings and collaborate with various teams to develop and support ongoing analysis.
• Used Python to build statistical models involving Linear Regression, Ridge Regression, Lasso Regression, Elastic Net Regression, Gradient boosting for estimating the risks of assets.
• Conducted data accuracy analysis and support stakeholders for decision-making.
• Analyzed data using advance Excel functions such as Pivot Table, Charts, Graphs and Macros.
• Handled the company’s day-to-day reporting and data access needs
• Developed and implemented a business intelligence strategy that ensures the system data is secure, integrated and accessible to staff
• Analyzed and designed Logical and Physical data models using E-R diagrams
• Worked across departments to identify and understand key business questions, and standardize key metrics and measures
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Worked with structured and unstructured data sources using Big Data technologies across the solution cycle
• Development of scripts for loading the data into the base tables in EDW and to load the data from source to staging and staging area to target tables using Fast Load, Multiload and BTEQ utilities of Teradata.
• Worked in the conversion of SQL server functions into the Teradata Store procedure for confirming the data.
• Implemented Complex business logic with User-Defined-Functions, Index, Views and created User Defined Data type, Clustered & Non-clustered Indexes
• Prepared high-level Logical Data Models and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements.
• Written several scripts using Java script for file transfers, error logging, data archiving, checking the log files and cleanup process.
• Analyzed and designed Logical and Physical data models using E-R diagrams.
• Redesigned the data source having data from different sources into one SQL Server and to tableau.
• Analyzed and gained understanding of the underlying data and generated tableau dashboards with forecast and reference lines.
• Worked on Information Design Tool and Web Intelligence which has been used for reporting from Hana.
• Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Used extensively Teradata Analyst Pack such as Teradata Visual Explain, Teradata Index Wizard and Teradata Statistics Wizard
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Configured AD security using tableau server
• Responsible for authorizing the users based on their privileges.
• Involved in migration activities related to Tableau across the environments
• Developed Tableau dashboards pertaining to Revenue and Sales monitoring using Tableau 8.x.
• Demo of Tableau dashboard to users to enhance their knowledge on all the key capabilities of application.
• 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
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
• Developed and supported the Extraction, Transformation, and load process (ETL) for data migration using Informatic power center.
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Defined best practices for Tableau report development.
• Executed and tested required queries and reports before publishing.
• Worked on querying data and creating on-demand reports using Tableau Desktop and publish the same to Server.
• Designed and created Report templates, bar graphs and pie charts based on the customer data.

Environment: Tableau (Desktop/Server), SQL Server 2005/2008 R2, SAP Hana, SAP BW, MS Access, MS Excel, MS PowerPoint, Informatica, VBScript, HTML, XML, Visio.