SUMMARY:

• Motivated and highly skilled IT professional with 8+ years of work experience as a TABLEAU Developer Strong experience in using the Microsoft Suite (SQL Server Management Suite (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and Tableau Experience in using a Full System Development Life
• Cycle (SDLC), including Requirement Gathering, Analysis, Design, Development, Testing, and Implementation of various client/server applications in a structured development environment. Knowledgeable in the ETL Lifecycle and Agile Methodology Ability to prioritize multiple tasks. Excellent communication skills, proactive, self - managing, and teamwork spirit, goal-oriented, and highly motivated with excellent analytical, troubleshooting, and problem-solving skills.
• Experience in logical and physical Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Fact and Dimensional tables, and Operational Data Store (ODS). TABLEAU Experience working with Tableau Desktop, Tableau Server, Tableau Reader, and BI tools for data visualization. Built and published customized interactive reports and dashboards, report scheduling using the Tableau server, created new schedules, and checked the tasks daily on the server.
• Experience in the upgrading of Tableau Servers and creating User Groups, Projects, Workbooks, and assigning Access levels in the Server. Experience in using Tableau features like Data blending, Extracts, Parameters, Filters, Calculations, Context Filters, Hierarchies, Actions, and Maps ETL Experienced in transforming unstructured data from various data sources such as
• Excel Spreadsheets, OLTP databases, flat files, XML files, etc. Extensive experience with requirement analysis, design, development, customizations, and implementation of Data Warehousing ETL applications. Experience in all phases of the Software Development Life Cycle (SDLC) with experience in ETL Tools, Microsoft Business Intelligence Suite - SQL Server Integration Service (SSIS), SQL Server
• Reporting Services (SSRS), Alteryx, Tableau, Python, and knowledge in SQL Server Analysis Service (SSAS) Implemented Various Error handling and Event Handling Techniques to ensure efficient package execution. Experience in the Alteryx platform, and involved in data preparation, data blending, and the creation of data models and data sets using Alteryx. Responsible for designing, building, and testing workflows in Alteryx. Experience with Agile Methodology, Sprint Planning, Scrums, and Jira Atlassian Software for user tasks. SQL/ORACLE PL SQL Designing and Implementing Database Schema, Data modeling, creating normalized datasets, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Views, Temp tables, and complex SQL statements.
• Establishing referential integrity, data consistency, indexing, and data cleanup procedures to maintain high- quality data that can be used for reporting. Query Optimization and Performance Tuning of Stored Procedures using SQL Profiler and Estimated Query plans, normalization, indexing, and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes and scripts.

TECHNICAL SKILLS:

Technology and Tools:SQL Server 2016 | SQL Server 2014 | SQL Server 2012 | SQL Server Integration Services (SSIS) | T-SQL Stored Procedures | Tableau Desktop | Tableau Server | Excel | Word | PowerPoint | MS Project | MS OneNote | MS Publisher | Access |Oracle PL-SQL Outlook |SharePoint | Postgres

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Analyzed and gathered business requirements for designing and developing Tableau visualization solutions.
• Used Trend Lines Statistics and Groups hierarchies and sets to create detailed level summary reports and
• Dashboards using KPIs.
• Generated Dashboards with Quick filters, Parameters, calculated fields, groups, hierarchies, and sets to handle views more efficiently.
• Developed storytelling dashboards in Tableau Desktop and published them on Tableau Server which allowed end users to understand the data effectively with the usage of quick filters for on-demand needed information.
• Built, published, and customized interactive reports and dashboards, report scheduling using Tableau server.
• Performed daily integration and ETL tasks by extracting, transforming, and loading data to and from different SQL Server databases.
• Migrated dashboards from Development to the Production server as per business request.
• Performed data cleansing using Alteryx.
• Utilized SQL queries and scripts to extract and aggregate data to validate its accuracy.

Confidential

Responsibilities:

• Preparing and cleaning data for use in Tableau desktop using Tableau Prep.
• Making changes by updating existing tableau dashboards to optimize performance and improve customer usage.
• Meeting with stakeholders to gather client healthcare requirements to generate dashboards.
• Creating and maintaining new and legacy dashboards.
• Maintained tableau server as the administrator and scheduled update run times, permissions, and access.

Confidential

Tableau / BI Developer

Responsibilities:

• Analyzed and gathered business requirements for designing and developing Tableau visualization solutions.
• Supported the Business Intelligence/Analytics data analyst with the understanding of business and data requirements and iteratively designed visualizations for initial concepts and prototypes that can be presented to the business and clients for feedback.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD, and MTD fund performance, risk, and portfolio data for clients, institutional and private investors.
• Contributed to the development and modification of coding standards for the team to ensure consistency, efficiency, and accuracy in reporting and data analysis.
• Used Trend Lines Statistics and, Groups hierarchies, and sets to create detailed level summary reports and
• Dashboards using KPIs.
• Worked on Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, and
• Gantt charts using show me functionality.
• Generated Dashboards with Quick filters, Parameters, calculated fields, groups, hierarchies, and sets to handle views more efficiently.
• Developed storytelling dashboards in Tableau Desktop and published them on Tableau Server which allowed end users to understand the data effectively with the usage of quick filters for on-demand needed information.
• Built, published, and customized interactive reports and dashboards, report scheduling using Tableau server.
• Created and modified the schema objects like Attributes, Facts, Views, and Logical tables.
• Analyzed and created business intelligence reports in Tableau according to business requirements.

Environment: SQL Server 2012/2014/2016 , Visual Studio 2015, MS Excel, Tableau, Integration Services (SSIS), Agile

Confidential

Tableau/Alteryx Developer

Responsibilities:

• Worked with developers on the Operational Risk and Compliance team to design, develop and implement a third-party risk management portal, using Tableau, that streamlined due diligence and delivered transparency reports to our clients
• Coordinated with business stakeholders, application developers, production teams, and across functional units to identify business needs and discuss solution options.
• Involved in the publishing of various kinds of live interactive data visualizations dashboards and reports according to the business requirements using SQL Server Reporting Service (SSRS) and Tableau
• Utilized SQL queries and scripts to extract and aggregate data to validate its accuracy
• Performed daily integration and ETL tasks by extracting, transforming, and loading data to and from different SQL Server databases
• Created calculated fields, Parameters, and Filters to develop user-friendly, interactive, and actionable reports and dashboards.
• Created parameterized reports for the users and clients, with drill-down, and drill-through features.
• Performed data cleansing using Alteryx
• Carried out data extraction and data manipulation using SQL as per business requirements
• Met with Business Executives and sales team weekly to discuss new reports and business needs
• Met with Business users to assist them with UAT on developed reports
• Conducted presentations with Sales VP and Product Managers and received their feedback once all related dashboards were completed
• Conducted functional walkthroughs, User Acceptance Testing (UAT), and supervised the development of user manuals for the business and clients to be shared on SharePoint
• Scheduled refresh tasks with Time stamps, on all completed Dashboards, to Tableau Server
• Utilized Tableau server to publish and share reports with business users and clients.
• Configured site access for users, groups, and domains related to each project via an active directory.
• Analyzed site usage and performance daily and scheduled refresh of data based on business and system changes that occurred to ensure that the developed dashboards are displaying accurate data
• Provided ongoing support and user for Tableau use
• Migrated dashboards from Development to the Production server as per business request.
• Scheduled user request refresh on the Tableau site
• Resolved end-user reporting problems through collaboration with IT and Operations.