SUMMARY:

• Self - motivated and proactive Tableau developer with over 8 years of experience in implementation & administration of Tableau Business intelligence solutions, Microsoft SQL server 2017/2016/ 2014/2012/2008 R2/2008 in development, testing & production environment and ad-hoc statistical analysis.
• Expertise in design and development of interactive Tableau visualization solutions.
• Worked a great extent with the design and development of Tableau visualizations which includes preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
• Expert in evaluating data models to design Tableau solutions.
• Ensured maintenance and security control of the Tableau products and solutions.
• Broad experience on building dashboards using Tableau and involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization, making use of actions, other local and global filters according to the end user requirement.
• Experience in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization. Data was processed in Alteryx to create tde for reporting.
• Extensively used Erwin for Logical Data Modeling, Physical Data Modeling, Logical-to-Physical Transformation, Forward engineering, Reverse engineering, and Model-to-model comparison.
• Strong knowledge of Data Warehousing methodologies and concepts, including Star Schemas, Snowflake Schema, SSIS processes, Dimensional Modeling and Reporting tools.
• Working on creating various dashboards in Tableau Desktop by querying various ODBC connections such as Teradata, Oracle SQL Developer.
• Highly proficient in using T-SQL for developing complex Stored Procedures, Effective Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity, SQL Joins, Indexing and Query Writing.
• Proficient in Creating, Configuring, Deploying and Fine-tuning MS SQL Server Integration Service (SSIS) packages.
• Well versed in the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS Packages with the proper control flow and data flow elements by using MS SQL Server 2014/2012/2008 R2/2008.
• Good understanding and working experience of agile management.
• Self-learning ability, Leadership Quality, good team player and determination to learn new technologies and maintain positive relationships at all business levels.
• Experience with SQL development - MariaDB, MySQL, or PostgreSQL
• Strong knowledge and applied experience in database and enterprise-wide information systems preferred (SAP, Oracle Financials, PeopleSoft, JD Edwards)
• Responsible for Tableau Server Administrative functions, upgrades, installations, configuration, license management

TECHNICAL SKILLS:

Reporting Tools: Tableau Desktop 2019.2/2019.1 / 10.2.16/10.2 /9.1, Tableau Server 2019.2/2019.1 /10/10.3/9.2, Tableau Online, Tableau Public, Tableau Reader, Tab cmd, Alteryx 2018.2, QlikView, QlikSense.

Scripting languages: T-SQL, Microsoft SQL Server 2017/2016/ 2014/2012/2008 R2

ETL Tool: - MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), OLAP, OLTP, Erwin Data Modeler v7.0/v4.x

Other: Microsoft Visual Studio 16/15/14, Microsoft Access, Microsoft Office (MS Word/Excel/PowerPoint), MS Project, Microsoft Office Vision

PROFESSIONAL EXPERIENCE:

Confidential

Tableau Developer and Tableau Administrator

Responsibilities:

• Designed reports/graphs/presentations using Tableau for specified projects. Produced accurate analysis of project datasets as defined by the required specification.
• Developed the business logic and the design of data queries and calculations used to extract and format data for project reports and external presentations.
• Worked a great extent with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.
• Installed and upgraded Tableau server and server performance tuning for optimization.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Created Users, User Groups and Projects through Tableau Server Web and assigned roles and permissions for Tableau Users.
• Developed batch scripts for Tableau Server backup atomization on weekly basis and save the backups in a particular folder.
• Maintaining Tableau data source connections and scheduled refreshes and updates.
• Data was processed in Alteryx to create tde for reporting.
• Extensively used Tabadmin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Published Tableau workbooks (.TWB) and Tableau data Extract (.TDE) from Tableau desktop to Tableau Server.
• Involved in end to end implementation and enhancements on trading behavior data starting from requirement gathering and dashboards development in Tableau Desktop.
• Involved in modifying Teradata stored procedures and performance tuning of various Teradata/Oracle tables, Informatica mappings to improve the performance of Tableau reports/Dashboards.
• Created numerous dashboards in Tableau Desktop based on the data collected from financial reporting systems by importing and blending data from MS Excel, CSV and MS SQL Server, Hbase, Hive and Spark SQL Databases.
• Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development.
• Developed Geo/Area Maps to show details on which states are most connected vs. the least states.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future trend of the performance based on sales.
• Compiled interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling behind the market spread with Quick Filters for on demand needed information with just a click of a button.
• Responsible for Tableau Server Administrative functions, upgrades, installations, configuration, license management,

Back up of servers and load balancing techniques.

Tools & Technologies: Tableau Desktop 2019.2/2019.1, Tableau Server 2019.2/2019.1, Tabcmd, MS SQL Server 2017, Hbase, Hive and Spark, MS SQL Server Integration Services, MS SQL Server Reporting Services, MS Visual Studio 16, Erwin r8, Alteryx 2018.2, QlikView, QlikSense.

Confidential

Tableau Developer and Tableau Administrator

Responsibilities:

• Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
• Held responsibility for integration points and the order in which these must be executed.
• Built compelling, interactive dashboards in Tableau that answer key business questions.
• Audited the datasets and data analyzed as required ensuring their continuity, accuracy and consistency.
• Mentored other Tableau reporting specialists.
• Performed administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance
• Accomplished development activities from gathering requirements and designing solutions, through developing code/reports, to testing and release/deployment.
• Reviewed, assessed and promoted adoption and standardization of Tableau support solutions.
• Generated insights out of voluminous and complex datasets and built story lines.
• Produced complex table calculations, use of parameters, actions, filters and other advanced options in Tableau.
• Designed excellent Tableau dashboards and presented correct decisions independently based on what different kind of visuals would make sense for the business.
• Involved in reviewing business requirements and analyzing multiple data sources including HDFS, Hbase and MS SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Formed Heat Map showing current service subscribers by color that were broken into regions allowing users to understand where they have most claims vs. least claims.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from MS SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Involved in modifying Teradata stored procedures and performance tuning of various Teradata/Oracle tables, Informatica mappings to improve the performance of Tableau reports/Dashboards.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Connected to Tableau Postgre SQL database to create customized interface for Tableau workbooks to provide native intranet style navigation.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Responsible for Tableau Server Administrative functions, upgrades, installations, configuration, license management Back up of servers and load balancing techniques

Tools & Technologies: Tableau Desktop 10.2.16/10.2, Tableau Server 10, Tabcmd, MS SQL Server 2017/2016, Hadoop/HDFS, Hbase, Hive and Spark, R/RStudio, Python/Anaconda, MS SQL Server Integration Services, MS Visual Studio 15/16, Microsoft Office Vision, Microsoft Safe Source 2005 (VSS), Erwin r8, Ultra Edit tool, SharePoint, QlikView, QlikSense.

Confidential

Tableau Developer/SQL Server Developer

Responsibilities:

• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Develop, organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types.
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Created visualizations for logistics calculations and departmental spend analysis. Utilized sample data to create dashboard while ETL team were cleaning data from source systems.
• Used SQL Queries at the custom SQL level to pull the data in Tableau desktop.
• Validated the results in Tableau by running SQL queries in MS SQL developer.
• Attended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment.
• Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters.
• Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes.
• Developed Tableau functional design document.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Involved in the development of SSIS Packages for cleaning and scrubbing of data using Lookup and Fuzzy Lookup transformations to validate the data.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Tools & Technologies: Tableau Desktop 10.1/9.1, Tableau Server 10.1/9.1, MS SQL Server 2014, MS SQL Server Integration Services, MS SQL Server Reporting Services, MS Visual Studio 14/15, Erwin r7, R/RStudio.

Confidential, INC

Tableau / SQL Developer

Responsibilities:

• Participated in data modeling meetings to help determine data modeling architecture and helped data modeling team to achieve best practices and performance.
• Involved in requirement gathering meetings to understand requirements and future usage for the reports and documented them.
• Involved in publishing of various kinds of live, interactive data visualizations dashboards, reports, and workbooks from Tableau Desktop.
• Gathered user requirements analyzed and designed software solution based on the requirements.
• Created dashboards to track the study from staring to till the end phase
• By delinquency dashboard we can monitor and view through location and time.
• Worked on LOD’s and Parameters and filters. Worked on Excel based reports used power pivot.
• Enabling security to the VIZ. Backup Extracts and refreshing extracts and creating backups.
• Worked on Tableau server for dashboard publications.
• Designed and developed interactive dashboard.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
• Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications
• Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction
• Wrote complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements
• Optimized existing Stored Procedures and various T-SQL queries
• Wrote Dynamic Store Procedure to move data from Staging to Application
• Improved Performance by creating Clustered and Non-Clustered Indexes and by Optimizing the T-SQL statements using SQL profiler
• Added more audits and alerts in SSIS Packages in case of package failure
• Created package to transfer data between OLTP and OLAP database using container, task and transformation to load underlying data in to the tables from Text files

Tools and Technologies: Tableau Desktop 10, Tableau Server, MS Office Suite, SQL Server 2012, Teradata, MS Excel.

Confidential

Junior Programmer

Responsibilities:

• Involved in completing Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination system.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Tools:& Technologies: MS SQL Server 2012/2008R2, VB.Net, MS Excel, MS Access, ORACLE 10g, Erwin Data Modeler.