SUMMARY:

• Goal - oriented Tableau Developer with proficiency in SSMS, SSRS as well as Azure cloud computing with other self-service, that is Tableau.
• Extensive experience working in mid-sized to large organization in various domains including Healthcare, Finance, and Technology services.
• Merit of designing complex SSAS cubes with fact measures groups and multiple dimension hierarchies.
• Gained in-depth knowledge on Tableau Desktop, Tableau Viewer and Tableau Server.
• Skilled in creating rich dashboards using Tableau Dashboard and preparing user stories to create compelling dashboards to deliver actionable insights.

TECHNICAL SKILLS:

Database: MS-SQL Server 2012/2008R2/2008/Azure SQL

T-SQL Programming: Dynamic SQL, C#.Net

Data Modeling: ER-win, MS Visio

BI Tools: Power BI, Power Pivot, Tableau

SDLC: Agile, Scrum, Waterfall, and Spiral

PROFESSIONAL EXPERIENCE:

Confidential, Racine, WI

Tableau Developer

Tools and Environment: SQL Server 2016/2012, T-SQL, SSAS, SSMS, SSDT, Erwin, SSRS, Crystal Reports, Tableau, Excel, TFS

Responsibilities:

• Interacted with stakeholders, gathered requirements and the delivery management.
• Created dual-axis bar with multiple measures, trend lines and forecast for displaying prediction of data.
• Worked with context filters, quick filters, data source filters while handling huge data.
• Worked with reference lines, reference band and distribution band for data analysis.
• Created dashboards with dimensions and measures coming from various data sources using data blending concept.
• Generated legend fields placed on color, size, tool tip, shape on the marks card and also used pages shelf for analyzing the data.
• Identified and wrote code to prepare for newer SQL Server version migrations.
• Designed, tested and implemented Tableau functional dashboards based on user requirements.
• Created advanced chart types, visualizations and complex calculations to aggregate the data at different granular levels.
• Developed Tableau data visualization using heat maps, scatter plots, geographic maps, pie and bar charts, symbol maps, horizontal bars, histogram, and packed bubbles.
• Worked extensively with the parameters, action filters, calculations, images, trend lines, statistics, table calculations, conditional color formatting in the development phase.
• Implemented advanced Tableau features such as integration joins, row-level security, statistical calculations for developing ad-hoc reports.
• Connected to the Tableau Server for publishing the data sources and dashboards and set up the Auto-refresh feature for the data refresh and shared the reports with the business users.
• Worked with subscriptions, permissions, tags, revision history and alerts on Tableau Server and shared link to the business users for the analysis.
• Created metrics, attributes, filters, reports, and dashboards.
• Used Groups to combine dimension members into higher level categories and bins to create reference with the dimension or numeric bin and hierarchies to drill down.

Confidential, New Kensington, PA

Tableau Developer

Tools and Environment: SQL Server 2016/2012, T-SQL, SSAS, SSMS, SSDT, Erwin, SSRS, Crystal Reports, Tableau, Excel, TFS

Responsibilities:

• Documented functional needs of proposed project by reviewing business requirements.
• Collaborated with front end team to develop stored procedures and functions as required.
• Formulated complex SQL statements with joins, sub queries, and correlated sub queries.
• Protected sensitive data from multiple tables with schema binding views.
• Manipulated data in target tables based on source tables utilizing merge statement.
• Deployed and processed SSAS cube weekly to update information by using SQL Server Agent.
• Created new cubes and modified existing cubes using SSAS 2008 to make data available.
• Created complex calculations in Tableau reports including string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.
• Combined Tableau visualizations into interactive dashboards using filter actions, highlight actions, and so on.
• Utilized Tableau for creating user interface dash boards to match business requirements.
• Used bar charts, straight tables, pie charts, dual combination charts, filled maps using Tableau.
• Participated in generating daily updating reports with Tableau Desktop.
• Designed stunning visualizations using Tableau software and published and presented dashboards on web and desktop platforms.
• Developed complex visualizations reports using data from relational databases using Tableau Desktop.
• Utilized crystal migration services to convert existing crystal report to SSRS.
• Followed reporting life cycle steps (Authoring, Managing and Delivering) to generate SSRS reports.
• Created linked reports on report manager for easy access to business users.
• Created report snapshots and caches for enhancing performance and scheduled the reports with subscriptions.

Confidential, Scottsdale, AZ

Tableau Report Developer

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

Responsibilities:

• Collaborated with team members, product owner, and technical manager to gathering requirements, clarifying request with various meetings utilizing agile methodology.
• Implemented database integrity techniques with the help of constraints like primary key, foreign Key and check constraints.
• Modified and tuned existing permanent database objects per change request and business needs.
• Implemented business logic utilizing temporary objects such as CTE, temp table, and table variable.
• Implemented index analysis in OLTP and OLAP and came up with more efficient solutions to use clustered and non-clustered Indexes for significant performance boost.
• Identified slow changing dimensions and role playing dimensions.
• Implemented data mart with star schema/bottom up approach.
• Extracted data from various sources such as SQL Server 2012/2008 R2/2008, Oracle, .CSV, Excel and text files from client servers.
• Implemented the master child package model for the Incremental load packages for easier maintenance and better performance.
• Configured the packages utilizing parameters to get values at runtime and deployed those packages to the production server (in to Integration Services Catalog).
• Designed user defined hierarchies in SSAS including parent-child hierarchy.
• Dealt with huge amount of data and used SSAS in order to retrieve the data.
• Designed and deployed reports with drill down, drill through and drop down menu option and parameterized and linked reports using Tableau.
• Gained knowledge in various reporting objects such as facts, attributes, hierarchies, transformations, filters, prompts, calculated fields, sets, groups, parameters, and so on, in Tableau.
• Created data connections, published on tableau server for usage with operational/monitoring dashboards.
• Built complex formulas in Tableau for various business calculations.
• Generated aggregated calculated field in the Tableau Desktop.
• Created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials, and so on, for the client at a glance, using Tableau Desktop.
• Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau Dashboards and managing the delivery
• Created ad-hoc, parameterized, drill down, drill through reports and formatted reports with expressions.
• Customized SSRS reports with different actions (drill through, URL and bookmarks).
• Checked execution logs to track frequently used reports, parameter details and user information in Report server.
• Collaborated with team members with Team Foundation Server.

Confidential, San Ramon, CA

SQL /BI Developer

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

Responsibilities:

• Conducted JAD sessions with tech leads, scrum master, and stack holders to implement end-user requirements.
• Implemented normal forms (such as 1NF, 2NF and 3NF) to avoid duplication, anomalies and manage functional dependencies.
• Implemented data modeling to design and later deploy permanent tables to SQL Server utilizing Erwin per business need.
• Wrote various stored procedures composed of dynamic SQL to apply business logic in development enviornment and later deployed on production server.
• Analyzed slow running scripts utilizing execution plan and late enhanced performance based on needs.
• Designed and deployed a DWH architecture utilizing hybrid schema (Star/Snow Flake) per business requirements.
• Implemented checkpoint, logging, and error handling with event handlers at control flow level.
• Designed various cube objects such as KPIs, calculated members, derived members, perspective, and translations utilizing basic MDX scripting.
• Defined specific read/process permissions for the users in SSAS instance.
• Designed and Implemented different types of reports including drill through, drill down, sub-reports, and parameterized/cascaded parametrized reports utilizing SSRS.
• Created and Deployed user defined stored procedures that were used in SSRS datasets to create user-interactive reports.
• Implemented TFS for project source control, version control, team coordination and collaboration.

Confidential, Flemington, NJ

SQL/BI Developer

Tools and Environment: Microsoft SQL Server 2008 R2, BIDS, SSMS, T-SQL, SSAS, SSRS, Erwin, TFS, DTA, C#.Net, Excel

Responsibilities:

• Collaborated with end users and business analyst to gather and document system requirements based on extensive JRD and JAD sessions during the conceptual design phase.
• Created complex stored procedures to perform Index maintenance within OLTP and OLAP environments.
• Wrote multiple scripts with proper error handling (e.g. TRY CATCH, IF-ELSE CASE), transactions and performance tuning features.
• Implemented modular programming techniques within OLTP environment such as master-child stored procedure to make automated execution with less complexity.
• Improved performance issues with existing T-SQL scripts and database objects to resolve slow running queries with the help of both actual and estimated execution plans.
• Designed reusable ETL mapping documents for data migration, data import, Initial and Incremental load.
• Implemented various incremental loading strategies to load data on a weekly basis to OLAP which was later used for reporting purposes.
• Designed and developed SSAS cubes with KPIs, aggregation, calculated members, and partitions for reporting.
• Worked on various reporting requirements utilizing SSRS to generate ad-hoc reports as well as configure data driven subscriptions with reports manager.

Confidential, Hollywood, FL

SQL/ETL Developer

Tools and Environment: MS SQL Server 2008R2, BIDS, Erwin, SSAS, SSRS, SSMS

Responsibilities:

• Attended JRD sessions to gather requirements.
• Created and deployed triggers to track DDL operations at server and database levels on OLTP servers.
• Created and implemented views per the requirements of the front-end developer to improve implementation on web pages.
• Implemented and optimized indexes on tables and views for optimum performance tuning.
• Performed DBCC consistency checks, and fixing data corruption in user databases.
• Wrote multiple complex stored procedures for data profiling and auditing purposes.
• Designed and deployed SSAS multi-dimension cubes used in analytic research and report generation.
• Used TFS for version control, change management, and bug tracking.

Confidential, Coppell, TX

SQL /BI Developer

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

Responsibilities:

• Diagnosed database objects to find anomalies; normalized further and maintained referential integrity.
• Presented static data on webpages by creating and implementing view to application development team.
• Designed user defined functions to support front end team for data search related requirements.
• Applied pre-migration and post-migration considerations on migrated data sets to follow business code and constraints.
• Designed efficient stored procedures to address parameter sniffing issues.
• Debugged issues with various database objects and used Microsoft recommended optimization techniques to improve their performance.
• Deployed packages to other environments after creating package configurations.
• Developed numbers of SSAS cube objects such as KPIs, calculated measures, and named sets.
• Modified reports including profit/loss analysis by vendor and explore business opportunities areas utilizing SSRS.

Confidential, Parsippany, NJ

ETL BI Developer

Tools and Environment: SQL Server 2008, SSMS, T-SQL, SSAS, Erwin

Responsibilities:

• Collaborated with QA team in developing SQL scripts for validation requirements.
• Transformed frequently used queries into views and stored procedures per requirements.
• Created multiple stored procedure to handle business logic for performance related issues.
• Improved query performance by normalizing and de-normalizing tables as required.
• Altered tables and views to include new columns to support modified requirements.
• Moved data from multiple sources to staging area for further processing.
• Created aggregations, named queries, and KPIs as per reporting needs in SSAS.
• Collaborated with development team using TFS (Team Foundation Server) to work with cross functional team environment including on-shore and off-shore.