SUMMARY

• Over 8+ experience using Tableau Desktop, Tableau Server, SQL Server, SSIS, SSRS, Hadoop, Netezza, Alteryx to analyze data, move data, and create outstanding Reports and Dashboards
• More than 7 years interfacing with business users to
• Strong SQL background (7+ years) writing stored procedures, CTEs, UDFs, Sub - queries, complex joins to create reports and generate Custom SQL for Dashboards
• Deep knowledge from 6+ years designing and working with Data Warehouse using concepts like Star Schemas, Snowflake Schema, along with SSIS packages and Alteryx Workflows
• Expert knowledge of strategically implementing Role Level Security, performance tuning, and various work arounds to enhance users experience, secure reports, and increase performance.
• Expertise in designing and development of various dashboards, reports utilizingvarious TableauVisualizations 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 business/client requirement.
• Responsible for writing SQL Queries, Dynamic-queries, sub-queries, and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors
• Involved with Erwin for Logical Data Modeling, Physical Data Modeling, Logical-to-Physical Transformation, Forward engineering, Reverse engineering, and Model-to-model comparison.
• Expertise in working on all activities related to the development, implementation, administration, and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS) and SSIS with MS SQL
• Proficiency in creating SSIS packages with transformations using SQL Server Integration Services
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling, and reporting tools, worked with high volume databases with partitioned data.

TECHNICAL SKILLS

• Tableau Desktop
• Tableau Server
• JIRA
• Microsoft SQL Server
• MS SQL Server Integration Services (SSIS)
• MS SQL Server Reporting Services (SSRS)
• MS SQL Server Analysis Services (SSAS)
• T-SQL
• PL-SQL
• OLAP
• OLTP
• Erwin Data Modeler
• Microsoft Visual Studio
• Microsoft Access
• Microsoft Office (MS Word/ Excel/PowerPoint)
• MS Project
• HTML
• XML
• Java
• C++
• C#
• Visual Basic
• Microsoft Office Visio
• Windows Advanced Server
• Windows
• Ultra Edit Text Editor.

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr Data Analyst / Tableau Developer

Responsibilities:

• Collaborates with end users and other stakeholders to define detailed requirements.
• Collaborates with end users and other stakeholder for production support.
• Design and published visually appealing and interactive Tableau Dashboards utilizing complex calculated fields, table calculations, filters, parameters, and actions, tool tip visualization.
• Create and use extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Published Workbooks by creating user filters for efficient use by users.
• Interface with Senior management, analysts, various SMEs, and users to gather and document requirements.
• Deploy systematic approach to improve dashboard performance and enhance stakeholders’ experience.
• Schedule data refresh onTableauServer for weeklyand monthlyincremental refreshbased on business needs to ensure that the views and dashboards displayed the changed data accurately.
• Provide knowledge of business processes and application design and understand cross-functional business relationships and their use of information.
• Design, develop, test and implement reports as necessary to fulfill business requirements.
• Effectively communicate analytical findings to users and provide education on dashboards built.

Confidential

Tableau Developer

Responsibilities:

• Communicated with business users and stakeholders to plan and define reporting requirements.
• Designed and developed various analytical reports and dashboards from multiple data sources using data blending on Tableau Desktop and published them to the web portal.
• Applied action filters, combine fields, groups, calculated fields, filters, and sets to prepare worksheets and dashboards using Tableau Desktop.
• Advanced use of Pivot table on spreadsheet
• Created bullet graphs to determine average wages and workers’ compensation by using measures.
• Manipulated data, developed key metrics, and created advanced chart types, and complex calculations to build visualizations and dashboards.
• Used SSIS jobs for importing data from the flat files that brought the data to the application tables.
• Monitored processes that created deadlocks within the database.
• Wrote complex Stored Procedures, Queries, Triggers, Functions, Indexes, User-defined functions.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transferred into data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.

Confidential

Tableau Developer

Responsibilities:

• Worked with various T-SQL objects like tables, views, joins, stored procedures, functions, indexes, and triggers and performed optimization on it.
• Built complex multi-sectional reports with charts and drill-down capabilities, created report models for ad-hoc reports using SSRS to find all the work items open for developers.
• Queried optimization and performance tuning using tools like SQL Server Profiler, Database Engine Tuning Advisor for SQL queries and Stored Procedures.
• Extracted data using SSIS from OLTP to OLAP. Based on the required reports, identified various data sources, and established the connections using SSIS and constructed data source views
• Created actions filters, combine fields, Groups, calculated fields, filters, and sets to create worksheets for dashboards using Tableau Desktop.