SUMMARY

• Tableau Developer with 7 years of experience in design, development and implementation of data visualization projects across various domains.
• Strong Data Modeling experience using ER diagram, dimensional data modeling, star schema modeling, snow - flake modeling using tools like Erwin.
• Hands on experience in developing parameterized, drill down, drill through, chart, matrix, ad-hoc, sub-reports using SSRS.
• Focused professional with excellent analytical, negotiation and presentation skills.

TECHNICAL SKILLS

Database: SQL Server 2016, 2014, 2012, 2008/R2

SDLC: Agile, Scrum, Waterfall, and Spiral

Data Modeling: Erwin, MS Visio

Database Programming: T-SQL, Dynamic SQL, MDX, DAX

Development Tools: BIDS, SSDT, SSMS

Analysis Services: SSAS, OLAP Cubes, Tabular Model

Reporting Tools: SSRS, Tableau Desktop, Power BI, Excel Power BI

Source Control & Collaboration Tool: Team Foundation Server (TFS), SharePoint

Cloud Experience: MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouses, Azure Storage

PROFESSIONAL EXPERIENCE

Confidential, Foster City, CA

Tableau Reports Developer

Responsibilities:

• Gathered system requirements through end-user collaboration through JRD and JAD meetings.
• Created data mapping document (DMD) by analyzing data sources and mapping to data mart schema.
• Implemented indexes on tables and views for optimum performance tuning.
• Optimized the existing queries to improve performance with the use of Profiler and Execution Plans.
• Designed and developed various dashboards and reports utilizing Tableau Visualizations according to the end user requirement.
• Set up and managed Tableau Server with large volumes of data.
• Configured the installation and management of Tableau Server with large data volumes such as setting up Tableau data sources, filters, blending, and joins for optimum performance and troubleshooting issues.
• Generated various dashboards in Tableau Server using various sources.
• Prepared dashboards using calculations and parameters in Tableau.
• Generated aggregated calculated field in the Tableau Desktop.
• Stored all source code in the Team Foundation Server (TFS) and updated development status in the TFS timely.

Tools: & Environment: SQL Server 2016, SSAS, SSRS, SSMS, SSDT, T-SQL, Erwin, TFS, Tableau, SQL Profiler

Confidential, Richmond, VA

SQL Tableau Developer

Responsibilities:

• Attended JRD sessions to gather requirements and outlined functional requirements
• Built logical and physical data models using the Erwin data modeler tool.
• Designed and implemented OLAP database utilizing star schema structure.
• Written multiple complex queries for the data profiling and auditing purposes.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Built complex formulas in Tableau for various business calculations.
• Built customized interactive reports and dashboards, report scheduling using Tableau Server.
• Created actions, parameters, and calculated sets for preparing dashboards and worksheets using Tableau.
• Effectively used data blending, filters, actions, and hierarchies feature in Tableau.
• Analyzed the data using statistical features in Tableau to develop trend analysis.
• Published the developed dashboard and reports on the Tableau Server so that the end users having access to the server could view the data.
• Implemented TFS for version control and change management of BI solution for cross-functional communications.

Tools: & Environment: SQL Server 2012, Erwin, SSDT, SSAS, SSRS, Tableau, T-SQL, Erwin, MS Excel, TFS

Confidential, NY

Tableau Reports Writer

Responsibilities:

• Analyzed and documented business requirements by participating in JRD sessions.
• Designed and implemented clustered and non-clustered indexes on tables ensuring the efficiency of queries.
• Wrote SQL queries to validate data on staging tables and data warehouse tables to validate the data results.
• Created and modified indexes to optimize query performance of several stored procedures supporting front end applications and reports.
• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensured that the views and dashboards displayed the changed data accurately.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server.
• Tested the data connections that brought the data from the database to the Tableau dashboards in order to develop the reports.
• Interacted with business stakeholders to understand their decision making parameters and analyzed the available data to build Tableau dashboards and manage the delivery.

Tools: & Environment: SQL Server 2008 R2, T-SQL, SSMS, BIDS, SSAS, SSRS, Power BI, SQL Profiler, DTA, TFS

Confidential, CA

SSRS Developer

Responsibilities:

• Defined functional requirements by collaborating with development team in JAD sessions.
• Normalized tables to remove redundancy and maintain system consistency
• Supported production environment by optimizing existing stored procedures and scripts.
• Utilized Excel Power BI to amplify data visualizations with interactive sharing, collaboration, and data management.
• Create parameterized reports using charts, cross-tab and sub-report types.
• Developed reports for business end users using Report Builder with updating statistics.
• Participated in troubleshooting, performance tuning of reports and resolving issues within Reports Server and Report Manager.
• Tested the data connections that brought the data from the database to SSRS in order to develop the reports.

Tools: & Environment: SQL Server 2008, T-SQL, SSMS, BIDS, SSAS, SSRS, SQL Profiler, DTA, Excel Power BI, TFS

Confidential, Irvine, CA

SQL Developer

Responsibilities:

• Participated with the business analysts via JRD sessions for gathering business requirements.
• Completed dimensional modeling with Erwin.
• Contributed in modifying temporary tables, indexes, and lookup techniques for optimizing stored procedures.
• Wrote complex stored procedures, functions, and triggers for implementing business logics in the OLTP database.
• Framed indexes on tables and views for elevated performance.
• Originated functions for providing custom functionalities according to requirements.
• Administered data from heterogeneous sources such as SQL Server, Excel, and CSV.
• Utilized reports to the report server in native and SharePoint integrated mode.

Tools: & Environment: MS SQL Server 2008, TSQL, Erwin, SQL Profiler, DTA, TFS, SSRS, SSMS, BIDS