SUMMARY:

• Over 8 years of experience in Data Analysis/Business Analysis, System Analysis & Design, Development, testing and implementation of BI/Data Warehousing projects
• 5+ years of Experience in Tableau Desktop/Server, creating highly interactive Data Visualization Reports and Dashboards using features such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.
• Extensive experience in creating highly interactive Data Visualization Reports and Dashboards using features such as Data Blending, Calculations, Filters, Actions, Parameters, Maps, Extracts, Context Filters, Sets, Aggregate measures etc.
• Experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 10.x,9.x,8.x,7.x.
• Implemented Tableau, performed admin activities across multi - environment infrastructure.
• Involved in Tableau Server Installation, Configuration, Creating Users, Groups, Projects and Assign Privileges etc., in a multi-server and multi-tier environment.
• Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• In-Depth Experience in analysis, design and development of reports using Tableau, Oracle SQL, PL/SQL and Data analysis
• Extensive experience in Software Development Lifecycle (SDLC) managing project scope, requirement definition, resource management, change management, analysis, managing work schedules, project status reporting, project coordination and conflict resolution.
• Experience in using Tableau functionalities for creating different Requests, Chart, Interactive dashboards with Page and Dashboard Prompts.
• Proficient at using Alteryx for Data Blending, Data Cataloging, Data Profiling and In- Database Processing.
• Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings Workflows, Customized Analytics Reports.
• Experienced in Tableau working with different Enterprise Data sources like SAP HANA, SSAS Cubes, Hadoop HDFS, SQL Servers, Amazon Redshift and the Extracts (auto/incremental).
• Played a key role in the agile team including overseeing job sprints on SCRUM based projects.
• Experienced with ETL tools like Informatica, SSIS, SSRS and Data Stage
• Strong understanding of Data warehouse concepts, OLTP, OLAP, ETL, Star Schema, Snowflake, data modeling and SQL.
• Participated in the architecture and design of features associated with Collaboration and Scaling of Alteryx across the business.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member and individually.
• Analytical, methodical and resourceful approach to Problem Solving, Root-Cause Analysis, Impact Analysis and providing corrective actions to meet business requirements.

TECHNICAL SKILLS:

Data Visualization Tools/ Reporting Tools: Tableau Desktop 10.x/9.X/8.X/7.X, Tableau Server, Tableau Reader, Tableau online.

Operating systems: Windows, UNIX, Linux.

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

Databases: MS SQL Server 2000/2005/2008/2008 R2/2012, MS Access 2000, Oracle 11g/10g, Teradata, Redshift.

Productivity Tools: MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project, Erwin, Alteryx

Methodologies: Agile, Waterfall, Scrum.

WORK EXPERIENCE:

Confidential, Chicago, IL

Sr. Tableau Developer / Admin

• Took part in the end-to-end implementation and enhancements from gathering requirements to dashboards development in Tableau Desktop.
• Studied and analyzed applications and brainstormed with the business team for gathering effective requirements for the system.
• 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.
• Transformed raw data into Visual Analytics with a projection of significant KPIs.
• Created Dashboards to allow the users to dynamically interact with the data to the lowest level of granularity.
• Created Tableau Semantic Metadata dashboard, acts as a self-service tool to quickly pull the Data Mapping of in-house 65 + Tableau Data Sources.
• Created crosstabs for displaying underlying data based on various graphs and charts for future data analysis.
• Optimized workbook using Work Book Tools (Performance Analyzer).
• Created Custom Admin Views dashboard by connecting to Workgroup database and allowed the users to audit the usage of Workbooks, Data Sources and Views.
• Created Actions in Worksheets and Dashboards and enhanced the user interactivity.
• Built Excel, Qlik View and Domo reports in Tableau. Developed and Documented technical architecture, system design, performance test results and other technical aspects of the implementation.
• Followed SCRUM (Agile) methodology and developed dashboards with value-added products.
• Worked on editing Data connections and changing data sources in Tableau.
• Generated Tableau Dashboards with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Conducted Data blending, Data preparation using Alteryx and SQL for tableau consumption and publishing data sources to Tableau server.
• Worked with unstructured data creating workflows in Alteryx with documentation and implementation of the processed data.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields, to compare and analyze data in different perspectives.
• Developed and reviewed SQL queries with use of join clauses in Tableau Desktop for validating static and dynamic data for data validation
• Involved in the development of back-end (Oracle) to fulfill the UI requirement.
• Used different Mark types and Mark properties in views to provide better insights into large data.
• Worked in the application UI to present to the end users with Tableau dashboards and visualizations on multiple platforms.
• Built complex calculations using advanced functions (ATTR, DATEDIFF, STR, IFs, nested IFs, OR, NOT, AND, SUMIF, COUNTIF, LOOKUPs and QUICK TABLE calculations).
• Worked on using different visualizations like Bars, Lines, Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat Maps, High Light tables and rendered the data into data visualization with high performance.
• Developed reports using multiple measures like Individual Axes, Blended Axes and Dual Axes.

Environment: Tableau Desktop 10.0.6, Tableau Server, MS SQL Server 2014, Alteryx, SQL Server Management Studio, UNIX, SQL, PL-SQL, TSQL, Microsoft Excel.

Confidential, Plano, TX

Tableau Developer / Admin

• Gathering the report requirements from various stakeholders, cross-functional departments, business users and documenting them in the reports specifications document and report inventory.
• Worked on gathering and converting data over to Tableau using SQL /Excel data over to tableau reports and Dashboards.
• Created metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data Creating New Schedule's and checking the task's daily on the server.
• Involved in creating ad-hoc analysis and reporting requests in a timely manner for Business Risk related to fraud, Approval's, Declines daily, monthly and yearly.
• Created organized, customized analysis and visualized projects and dashboards to present to executive leadership.
• Created Complicated Calculation Based LOD (Level of detail) feature. Designing and developing data warehouse and Amazon Redshift BI based solutions.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Involved in managing the application's users, groups, and integration with Active Directory
• In-depth knowledge of T-SQL, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics. Evaluated database performance issues and executed database optimization.
• Use various data sources like SQL Server, SQL Analysis server (cube), Amazon Redshift, Hadoop and Hive
• Expertise in installing, configuring, Clustering, Load balancing and Multi-node installation of Qlik view and Qlik Sense Environment
• Administered user, user groups, and scheduled instances for reports in Tableau. Handling Big data loads to Qlik view and Qlik Sense and implemented impactful solutions.
• Act as a Tableau Administrator, using Tableau Server for publishing the developed dashboards to server, authentication, authorization, security, Tableau Extracts scheduling and refreshments, User Management Adding users and Groups, Content Restriction to users, to content based on access level as a Tableau Content Administrator
• Communicated effectively with team members and Business teams to Tableau the requirements to ensure the correct functionality is achieved. Designed and implemented SSL server authentication for Redshift clusters.
• Acted as a Developer for designing and developing, prototyping the various dashboards using tableau desktop.
• Involved extensively for building the dashboards such as creating Tableau Extracts, refreshing extracts, Tableau Layout designing, Tableau Work Sheet Actions, Tableau Functions, Tableau Connectors (Live and Extract), Dashboard color coding, formatting and report operations (sorting, filtering (Quick Filters, Cascading filters, context Filters), ranking, Top-N Analysis, hierarchies)
• Involved in scheduling data refresh on Tableau Server on a weekly and monthly basis to ensure that the views and dashboards were displaying the updated data correctly.
• Experience with managing multiple Data Analytics work streams, spanning across Data Engineering, Data Science and Review of data visualization.
• Wrote heavy Netezza SQL scripts to load the data between Netezza tables and implemented ELT process for SCD type 1 and SCD type 2 dimensions
• Implementation of Physical modeling on Teradata such as creation of tables, indexes, views, normalization.
• Hands on experience with Alteryx in developing sample Dashboards by connecting to Alteryx.
• Involved in designing Amazon Redshift DB Clusters, Schema, and tables.
• Created complex SSAS Cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Worked with clients to better understand their reporting and dashboard needs and present solutions using structured Waterfall and Agile project methodology approach.
• Connected to Amazon Redshift through Tableau to extract live data for real-time analysis.

Environment: Tableau Desktop 9.x, Tableau Server, Teradata, SQL Server, Alteryx, Oracle 10g, MySQL, API Development Toad, Netezza, AWS, VLOOKUP, MS Access, Windows 2007 server, Informatica.

Confidential, Marietta, GA

Tableau Developer

• Gathered Business Requirements, interacted with the Executive Directors, Project Manager and SMEs to get a better understanding of the Business Processes.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data.
• Provided Tableau desktop training for end users. Worked on creating Pivots, sets, groups, and parameters.
• Worked on Creating various plots and drill down analysis using Tableau desktop. Worked on scheduling reports, managing data sources and refresh extracts. Developed SQL scripts to create database objects like Tables, Views and Sequences.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Prepared dashboards using calculated fields, groups, sets and hierarchies in Tableau. Generated Tableau dashboards with combination charts for clear understanding.
• Cleaning and blending multiple data sources to allow for different views on application data in a single dashboard.
• Created side by side bars, Scatter Plots, Stacked Bars, Pareto Charts, Bollinger Bands, Radial Charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Conducted Gap Analysis, created Use Cases, workflows, screenshots and PowerPoint presentations for the Web Applications.
• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to the server.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Published the dynamic dashboard reports to Tableau server for navigating the developed dashboards on the web.
• Administered and provided production support for Enterprise-wide Tableau application consisting of multiple key functional business domains.
• Worked on Tableau Admin for scheduling the Data refreshing frequency, manage automatic subscription, security and controlling access.
• Successfully administered users, user groups, and scheduled instances for reports in Tableau. Resolved various performance issues and analyzed the best process distribution for different projects.

Environment: Tableau (Desktop/Server), MS SQL Server 2008, UNIX, Oracle 10g, Microsoft Office Suite (Word, Excel, PowerPoint), Teradata Administrator.

Confidential

Data Analyst / SQL Developer

• Interacted with business users and performed Gap Analysis of Client requirements.
• Build a common utility framework to handle all the exceptions in a Business process.
• Using Excel and VBA in the development of robust and flexible reporting systems.
• Retrieved data from data warehouse and generated a series of meaningful business reports using SSRS.
• Validated and tested reports, then published the reports to the report server.
• Performed and conducted complex custom analytics as needed by clients.
• Designed and developed specific databases for collection, tracking and reporting of data.
• Designed, coded, tested and debugged custom queries using Microsoft T-SQL and SQL Reporting Services.
• Designed and implemented the proof of concept solutions and created advanced BI visualizations using Tableau platform.
• Built data input and designed data collection screens - Managed database design and maintenance, administration and security for the company.
• Discussed intelligence and information requirements with internal and external personnel.
• Data output - Made data chart presentations, coded variables from original data, conducted statistical analysis as and when required and provided summaries of analysis.

Environment: SQL Server 2008 Enterprise Edition, Python, T-SQL, SSRS

Confidential

Business Data Analyst

• Responsible for Requirements Gathering, Analysis, detailed Process Flow Design, User Acceptance Testing and rollout of new & modified feature functionality deployed on the e commerce website applications.
• Tested various files for the scenario testing.
• Created Functional Requirement Document (FRD) for the process.
• Gathered and validated requirements for shopping cart, checkout and order management modules.
• Performed tactical hands-on work of creating concept sketches, interactive wireframes, visuals designs, user journey flows and more.
• Supported the quality assurance testing to ensure that business requirements were addressed in the Test Plans.
• Clearly and concisely communicated business requirements to developers and interacted with IT team to clarify and resolve any issues.
• Prepared technical project documentation and reports to enable users to accomplish their tasks with ease without wasting time and effort.
• Communicated the project status through meetings and status reports, and translated technical language into common language for staff and customers.
• Worked closely with Technical Architects, Developers, Test Managers, Business Stakeholders and Project Managers to achieve project objectives in defined time frames.

Environment: Rational Rose, MS Office Suite, Python, MS Project, SQL Server 2005, Agile, HTML, XML, JavaScript, MS Visio.