PROFESSIONAL SUMMARY:

• 7 plus years of experience in design, development, implementation and administration of various Business Intelligence Tools (Tableau, Power BI) and mastery in Database Design, Development of Microsoft SQL Server.
• Competency in using Tableau Server, Tableau Desktop, Tableau reader and Tableau Online from Tableau Versions 7.x/8.x/9.x/10.x.
• Created multiple user - interactive, real-time Tableau Dashboards employing drilling downs and tailored to requirement with Filtering, ability to merge numerous data sources and the data to obtain the desired outcome.
• Published Tableau Workbooks by creating user filters and sites to give controlled access to user groups on Tableau Server.
• Fabricated different Tableau Visualizations using Bars, Maps, Scatter plots, and Gantt charts, Histograms, Bullets, Heat maps and Highlight tables.
• Created applications in various areas like Health, Finance (e-commerce) and Sales etc using Tableau’s Desktop to achieve options like filters, dynamic interactions, and calculated fields.
• Created Cascading Filters to filter the data within the hierarchy and prompt to specific filter that is applied by cascading.
• Used Tableau 10.5 version for workbook version compatibility, web authoring improvements, enterprise enhancements and mobile updates.
• Worked on connecting tableau to various other data sources like AWS, Teradata, Oracle, Microsoft Excel, Microsoft Access, Microsoft SQL Server and experience in establishing respective driver connections.
• Created extensive detailed reporting spreadsheet using intricate formulas and macros to track document status for each account. Continued improvement.
• Experience in working with Advanced Excel Functions, VLOOKUP's, Pivot Tables and formulas.
• Involved in the mappings and extensive use of simple and complex transformations like SQL Query Transform, Merge, Vlookups etc. in Data flows.
• Proficient understanding of Advanced Excel Formula like Derivatives, V-Look up, H-Look Up and Macros.
• Developed new or modified existing SQL datasets for statistical data analysis to support client reporting solutions and wrote multiple PL/SQL queries to analyze the data and presented the results using EXCEL, Access, and Tableau Reports.
• Proficient in creating Tableau Scorecards, Tableau Dashboards using advance Tableau functions like Calculated Fields, LOD (Level of Detail), Adhoc Calculations, etc.
• Utilized the REST API with Tableau Server to manage and change Tableau server resources programmatically and permissions to users.
• Worked on the API for the functionality enhancement on server for site users and sites on Tableau server.
• Practiced JavaScript API to integrate Tableau workbooks and dashboards with web applications.
• Expert in installing, configuring tableau server and using Tableau Command line utility for administrative tasks like creating users, groups, projects and permissions.
• Engaged in day to day activities like creating workbooks, dashboard and published on server.
• Associated in creating automated scripts for tableau workbook refresh when not using live connections.
• Expertise in creating custom views using Tableau Server repository database (workgroup).
• Experience in Tableau report developing, testing and deploying reporting solutions on Tableau Server.
• Setup and configuration of Tableau server 10.0/9.2 in various environments and used Tableau Cmd and Tableau admin tools to configure the server according to best practices.
• Used Tableau Cmd for various Dashboard migrations from one environment to another.
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Used Oracle, SQL Server, Google Analytics and Advanced MS Excel as input data in Tableau database connection and used database extract for publishing database on Tableau Server.
• As part of AWS Cloud environment evaluation, I explored all major cloud services related to Networking, Storage and Database services and implemented various POC projects and came up with detailed documentation on how to implement those solutions on specific requirements, best practices and challenges.
• Professional experience in the MS BI stack: Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Dashboard & Securities: Designed and developed dynamic dashboards to evaluate the Company's performance. Implemented Row Level Security, Object Level Security, Package Security, Folder Security and created user classes as per the requirement.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using PL/SQL.
• Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Designed a Tableau Interface to Enter, Report & Schedule Hive jobs. Execute SQL statements for Validation via single user interface & Monitor the Scheduled Jobs.
• Experience in Analysis, Development, Design and Maintenance of Business Intelligence applications and Experienced in writing queries, stored procedures and functions using PL/SQL programming.
• Experience in Assessing a built Tableau Cluster Environment and preparing a Health Check Audit.

TECHNICAL SKILLS:

Tableau Desktop and Tableau Server (10.5/10.4/10.3/10.2/10.1/10.0/9.3/9.2/9.1/8.0/7.0/6.0 ), Tableau Reader, Tableau Public, Tableau Mobile, Power BI, MSSQL Server 2000/14, MS Access, SSIS, SSRS, C, C#, T-SQL, MD, DAX and Visual Studio 2005/17.

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Sr. Tableau Developer

• Design, development and deployment of Tableau reports on Tableau Desktop 10.4 and 10.5
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Utilized tab admin and tab cmd commands in creating backups and restoring backups
• Execute end to end compliance risk assessment and monitoring & testing program management.
• Skilled in identifying potential areas of regulatory vulnerabilities and risk.
• Expertise in establishing risk assessment parameters.
• Migrated 18 sites repositories from user based licensing to core based licensing.
• Performed high detail of oriented views using multiple measures, Individual Axes, Dual Axes and Customer Geo-coding.
• Modelled User filters to enable the row level security in tableau within client’s premises.
• Assembled Advanced Analysis actions and Interactive Dashboards using T ableau 10.5/10.4
• Transformed all the existing tableau dashboards from 10.4 to 10.5 based on the tableau server requirement of the client.
• Developed new or modified existing SQL datasets for statistical data analysis to support client reporting solutions and wrote multiple SQL queries to analyze the data and presented the results using Advanced EXCEL (macros), Access, and Tableau Reports.
• Experience in MS Access and Advanced Excel (vlookups) automation using VBA & SQL for end user Data Visualization.
• Generated Advanced Excel based financial models for forecasting and analyzing financial results using Vlookups, Power pivot, Macros.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
• Built and supported AWS environments for multiple customer environments for a variety of needs centered on BI and custom web applications.
• Performance monitored and tuned the Tableau reports.
• Fabricated User filters to enable the security of Tableau dashboards within client’s premises.
• Engaged in publishing the developed reports to production Tableau server environment
• Experience in creating Schedules for dashboards to refresh automatically
• Designed and setup user security for the entire landscape to facilitate Windows AD login.
• Utilized Tableau Cmd for various Dashboard migrations from one environment to another.
• Setup of Distributed Server environments for optimum load balancing.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently
• Experience in SQL reporting skills with the ability to create SQL views and write SQL queries
• Used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Experience in creating report schedules, data connections, projects, groups in Tableau server
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Experience in Creating custom admin views to monitor tableau server activities on periodic basis
• Creating reports involving Multiple Data providers, Merged Dimensions, Synchronization, Combined Queries, Sub queries, Report Level Details, Charts, Ranking and Report Level Variables
• Security implementation to Tableau server reports based on user community

Confidential, Frankfort, KY

Tableau Developer

• Upgraded tableau 8.0 to tableau 9.0 and gathered requirements, analyzed from raw data.
• Involved in Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections and in-memory in both tableau and excel.
• Fabricated customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Involved in created stored procedures, views, and custom sql queries to import data from sql server to tableau.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Maps and Background images.
• Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
• Ability to work quickly and under tight delivery deadlines with focus on details.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.
• Process data, create reports, analyze metrics, implement verification procedures, and fulfill client requests for information using MS Excel, Word, Access, and Power Point.
• Application development using VBA, Access and Excel for increasing process efficiency.
• Monitored and reported analytics for KPIs in Advanced Excel to capture baseline results and track growth of sales in the company.
• Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, Vlookup etc. in Data flows
• Created Metrics, Analytics, Rules, Goals for the Corporate Dashboard.
• Created mockup dashboards and presented to the higher level end users to have them a look and feel of the dashboards
• Develop and maintain reporting and analytical tools, including Business Objects
• Lead BI work stream projects in the implementation and use of new BI software tools and systems.
• Provided guidance and insight on data visualization and dashboard design best practices in Tableau.
• Involved in designing the Data model for the Data warehouse and for different Data marts.
• Performed End to end testing using SQL Queries in MSSQL 2014.
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-uses
• Worked with business owners to identify information needs and develop reporting; primary partners include the management team, finance & accounting, marketing, online retail, merchandising and operations.
• Involved in creating database objects like tables, views, procedures, triggers, structure and to maintain data efficiently.
• Converted crystal reports to tableau reports as part of migration.
• Designed executive level crystal reports.
• Used sql/pl sql for querying the data base.

Confidential, Chicago IL

Tableau Developer

• Developed executive dashboard for business leaders and client teams to implement marketing and product strategies based upon customer and data-driven insights.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurate
• Used MS Excel, Word, Access, and Power Point to process data, create reports in Tableau and analyze metrics, implement verification procedures, and fulfill client requests for information.
• Fabricated Pivot Table in MS Excel, used Vlookup, IF, Product functions and run through data validation process using pivot tables, Vlookup, and other Advanced Excel formulas.
• Created enterprise level automated reporting solutions for executives, accounting, call center, marketing, fulfillment and other stack holders
• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports.
• Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.,
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution
• Effectively used data blending, filters, actions, Hierarchies feature in tableau.
• Co-ordinate with ETL &; support team to perform full refresh and manage database operations on Tableau server.
• Developed cross table, Bar chart, Tree map and complex reports which involves property controls, custom expressions.
• Actively involved in the creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logins.
• Collaborated with the managers and team members to ensure that the deliverables meet the client’s needs and participated in client’s meeting.
• Identify opportunities and make recommendations to enhance development practices and processes of the team.

Confidential

SQL Server Developer / BI Stack

• Used SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Visual Studio.
• Used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Create different SSRS Reports based on the user’s requirement. All kinds like ad-hoc reports,
• Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using Sql Server Reporting Services 2012.
• Design the ETL for the data load.
• Designed SSIS Packages to transfer data from various sources of the Company into the database that was modelled and designed.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Create Master Package to run different other ETL in one Master package.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Bug fixes in SSIS, SSRS and stored procedures as necessary.
• Scheduling the jobs to run for ETL using SQL Server Agent.
• Played roles like production support of SSIS and SSRS jobs.
• Perform T-SQL tuning and optimizing queries for and SSIS packages.
• Created SSIS process design architecting the flow of data from various sources to target.
• Scheduling SSRS jobs and production support.
• Use of SharePoint 2010 and TFS to store all the related work and report the same by creating Tasks in TFS