SUMMARY:

• Tableau Developer with nearly 8 years of experience in the design and development of database applications and data visualizations across multiple domains.
• Hands on experience in RDBMS concepts such as tables, user defined data types, indexes, indexed views, functions, CTEs, table variables and stored procedures.
• Experience in developing complex visualizations reports using data from relational databases using Tableau Desktop.
• Strong hands on experience in implementing dash boarding, data visualizations, and analytics using Tableau.
• Focused, intuitive and competent individual with a knack for completing projects on time.

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

Integration Tool: SSIS

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

Programming Language: Java

Cloud Experience: MS Azure (IaaS, PaaS, SaaS), Azure SQL, Azure Data Warehouses, Data Factory, PowerShell, Azure Storage (BLOB, Tables, Queues, and File Share)

PROFESSIONAL EXPERIENCE:

Confidential, New York City, NY

Tableau Developer

• Met the stakeholders for requirement gathering and understanding the ongoing process for reports.
• Participated in JRD and JAD meetings.
• Analyzed the existing Excel reports with VB Macro for querying MRI Database.
• Performed Data Blending for connecting data arriving from multiple sources.
• Used SSMS login into MRI Database and inspected the query responsible for data retrieval for reports.
• Created dynamic reports using parameters.
• Created dashboards using different reports and controlling functionality with the help of filters and parameters in order for the dashboard to be dynamic at runtime.
• Joined all dashboards into story line to have all required reports for building linked with each other.
• Replicated the SQL Query into Data Source of Tableau in order to build report, dashboard, and story line.
• Published dashboards, storyline, data source connections to Tableau Online.
• Made complex calculations in Tableau reports including string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements, and quick table calculations.
• Contributed in Tableau Bridge Implementation in order to handle live connection and Data Extract Refresh for Tableau Online.

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

Confidential, Scottsdale, AZ

Tableau Reports Developer

• Collaborated with business users and project managers in gathering system specification requirements for the project via JRD sessions.
• Facilitated development and maintenance of quality guidelines and procedures along with necessary documentation.
• Developed stored procedures, triggers, and SQL scripts for performing automation tasks for various activities.
• Contributed in performance tuning of the SQL scripts and batches utilizing SQL profiler and DTA for development environments.
• Developed various data connections from data source to Tableau for report and dashboard development.
• Designed complex formulas and calculations within Tableau to meet the needs of complex business logic.
• Created interactive dashboards using parameters, actions, and various data visualizations using Tableau Desktop.
• Gained experience in creating spreadsheet, bar chart, pie chart, and filled/symbol map with Tableau Desktop Software.
• Used bar charts, straight tables, pie charts, dual combination charts, and filled maps using Tableau.
• Participated in troubleshooting and performance tuning of reports along with resolving issues within the Tableau Server and Reports.
• Combined Tableau visualizations into interactive dashboards using filter actions, highlight actions, and so on.

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

Confidential, Irvine, CA

Tableau Report Developer

• Analyzed OLAP requirement in detail with the project stakeholders by conducting Joint Requirements Development sessions
• Documented the complete process flow to describe database development, logic, implementation, and application integration.
• Maintained referential, domain, and column integrity utilizing various constraints such as primary key, foreign key and check constraints.
• Created business-crucial stored procedures and functions to support efficient data storage and manipulation.
• Implemented triggers for checking complex business conditions, providing security for the tables.
• Implemented exception handling in T-SQL with try-catch block, throw statement and error functions.
• Deployed Tableau for creating user interface dashboards to match business requirements.
• Contributed in generating daily reports with Tableau Desktop.
• Designed stunning visualizations using Tableau Software; published and presented dashboards on web and desktop platforms.
• Gained extensive experience working with Business Intelligence data visualization tools with specialization in Tableau.

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

Vital Decisions, Edison, NJ

SQL Tableau Developer

• Participated in JRD sessions to gather requirements and define functional requirements.
• Conceptualized data migration strategy to populate the data-mart with facts and dimensions.
• Enhanced and incorporated pre-existing logical and physical database.
• Created functions to provide custom functionalities according to the requirements.
• Utilized data viewer, break points, checkpoints and transactions to debug and control packages at run time.
• Possess in-depth knowledge of Tableau Desktop, Tableau Viewer and Tableau Server.
• Designed and deployed reports with drill down, drill through, and drop down menu option and parameterized and linked reports using Tableau.
• Gained extensive knowledge in various reporting objects such as facts, attributes, hierarchies, transformations, filters, prompts, calculated fields, sets, groups, parameters, and so on, in Tableau.
• Successfully designed and deployed data visualizations using Tableau.

Tools & Environment: SQL Server 2012, Erwin, T-SQL, SSMS, SSDT, Tableau

Kearny Bank, Fairfield, NJ

SQL Developer

• Participated in weekly status meeting and daily scrum meeting for project updates.
• Contributed in normalizing tables to remove redundancy and maintain system consistency.
• Designed dimensional data mart by analyzing the business requirements as well as identifying dimension tables and fact tables along with setting up appropriate granularity level.
• Created stored procedures and functions for data storage and manipulation.
• Enhanced performance with index analyses on tables and clustered and non-clustered indexes.
• Optimized the performance of queries with modifications to the existing index system and the reconstruction of indexes.
• Developed critical staging procedures to load data marts and report databases with multiple features.
• Monitored runtime events for better troubleshooting and debugging of packages with loggings.
• Created SSAS cubes to facilitate the reporting application utilizing SSRS for business analysis.
• Implemented features such as document map, bookmarks and URL actions in SSRS.
• Implemented report access security at server, report, and report item levels in SSRS.

Tools & Environment: SQL Server 2008 R2, Erwin, T-SQL, SSIS, SSRS, SSAS, SSMS, BIDS, MS Excel

Confidential, New York, NY

SQL Developer

• Coordinated for the planning and implementation phases of the data mart by analyzing business requirements.
• Designed the logical model with Erwin based on business requirements.
• Defined multiple constraints in the logical phase of the data modeling life cycle.
• Created database objects such as tables, views, stored procedures, and triggers.
• Formulated multiple complex queries for data profiling and auditing purposes.
• Implemented transactions with multiple isolation levels and locks technique to avoid dirty reads and deadlocks.
• Automated report deliveries to multiple recipients with subscriptions in SSRS.

Tools & Environment: SQL Server 2008, T-SQL, SQL Profiler, SSMS, BIDS, SSRS, DTA, Windows Server