SUMMARY

• 10 years of experience in IT industry as BI Lead Developer with Tableau and Business Intelligence tools as well as BI Developer with Tableau and Business Objects with strong background in Databases and Data warehousing concepts.
• Experienced in writing Python and Bash Scripts.
• Proficient in Tableau desktop 2019.x/2018.x/10.x/9.x/8.x, Tableau Server, Tableau Public, and Tableau Reader.
• Configuring Tableau Server to use Secure Sockets Layer (SSL) encrypted communications on all external HTTP traffic.
• Used Amazon Elastic Compute Cloud (Amazon EC2) to provide resizable compute capacity in the cloud.
• Used Amazon EC2 for the servers that run Tableau as an application along with web servers, databases, and Tableau Server.
• Proficient in Tableau desktop 2020.x/2019.x/2018.x/10.x/9.x/8.x, Tableau Server, Tableau Public, and Tableau Reader.
• Worked on different Tableau versions (Tableau 2020.x/2019.x/2018.x/10.x/9.x/8.x)
• Performing business analysis, software validation and testing for client/server, multi - tier and web-based applications for EMR and commercial business for managed healthcare plans and Industries
• Setup and configuration of Tableau server in various environments.
• Experience with working in diverse sectors with a solid background of working in Healthcare and Finance sectors.
• Optimize the VizQL server processes to handle loading and rendering views for Tableau Server.
• Registered and responsible for implementing push notification using Firebase Cloud messaging.
• Outstanding knowledge& working experience of Snowflake, slice & dice Looker, Power BI & Cognos.
• Expertise in Installation, configuration, upgrading and administration of Tableau Desktop/Server.
• Having constant involvement in tasks such as back up recovery techniques, High availability, Security, Installation, Trouble shooting and Performance Tuning.
• 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.
• Installed and setup cluster environment for Tableau server.
• Performance tuning for the Tableau Visualizations and Tableau server for more than 150 concurrent users.
• Used Tableau’s flexibility to build a tabbed application with wide range of options like quick filters, calculated fields, dynamic interaction, flexible ad-hoc capability in various functional areas like finance, sales, marketing, Healthcare and HR.
• Setup the configuration of Tableau server 10.1 in various environments and used Tableau CMD and Tableau admin tools to configure the server as per the best practices.
• Expert in configuration and development of different dashboards, reports utilizing Tableau Visualizations like bar graphs, pie-charts, scatter plots, geographic visualization and other making use of actions, other Local and Global Filters as per the end client requirement. in-Depth understanding of SnowFlake Multi-cluster Size and Credit Usage
• Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement.
• Worked on creating interactive, real-time dashboards using drill downs and customizations.
• Worked on Tableau, linux JavaScript API (JS API) to integrate Tableau visualization into own web applications to enable custom interactions.
• Setup Trusted Authentication/Active directory in Tableau server and pass requests from Web server.
• Created automated scripts for tableau workbook refresh when not using live connections.
• Experience with Tableau maintenance tools and Tableau server monitor to start/stop services and maintain statuses.
• Worked heavily using Tabadmin tools and Tableau Cmd for setting up security profiles for various User groups and Users.
• Used Tableau Cmd for various Dashboard migrations from one environment to another.
• Setup of Distributed Server environments for optimum load balancing.
• Working knowledge of adding WebFocus Environments to the Developer Studio.
• Experience with scheduling, report bursting and delivery via email.
• Developed Scripts to load data into Tableau and work with multiple data connections including Hadoop/Hive and by Data Blending.
• Expertise in slicing and reshaping data for tableau and Ad-hoc reporting based on user requirements.
• Designed and Created power cubes for multi-dimensional analysis.
• Used Tableau’s flexibility to build a tabbed application with wide range of options like quick filters, calculated fields, dynamic interaction, flexible ad-hoc capability in various functional areas like finance, sales, marketing and HR.
• Using the command line tools and configuration utility on the primary server pushed the updates to the workers.
• Performed configuration of Tableau Server SSO using SAML for supplementing Kerberos authentication.
• Assigning various extract schedules and using blending techniques to optimize the performance of Tableau.
• Used R functions and models in Tableau by creating new calculated fields that dynamically invoke the R engine and pass values to R
• Was able to access any R package or function that has been installed in an R server and take advantage of all of the visualization capabilities in Tableau to further analyze and understand data without having to manipulate data in R.
• Experienced in managing schedules and scheduling workbooks and activities on Tableau Server.
• Combined multiple data sources using blending in Tableau to keep track of sensor data, operator inputs, and real-time systems all in one dashboard.
• Experienced in Analysis, Development, Design and Maintenance of Business Intelligence applications.
• Experienced in writing queries, triggers, stored procedures and functions using SQL.
• Quick Learner with excellent analytical, problem solving, interpersonal, decision making, presentation skills with positive attitude towards new challenges.

TECHNICAL SKILLS

Visualization Tools: Tableau Desktop2020.x/2019.x Tableau Prep(2019.x/2018.2,2018.1),Tableau Server(10.4,10.3,10.2,10.1,/9.x/8.x/7), Tableau Reader, SAP BO, Web Intelligence, linux,Tableau Desktop (2019.2, 2019.1, 2018.2/18.1, 10.5, 10.4/10.3/10.2/10.1/9.3/9.2 )

ETL: Alteryx Analytics

Tools: SQL Developer, TOAD, Pl/SQL Developer Tidal Enterprise Edition and MS Visio, MS Excel, Tableau, Excel, Power BI, thoughtspot SSIS, SSAS, SSRS, AWS, Google Analytics, Jupyter, R studio, MS Visio

Databases: Oracle 10g/9i/8i, MS SQL Server 2000/2005, Teradata, and IBM DB2PostgreSQL, MySQL

Languages: SQL, HTML, Python, DAX, R

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. bUSINESS INTELLIGENCE Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop (2020.X/2019.X/2018.x/ 10.5/10.4/10.3/10.2/10.1/9.2 ).
• Created Relationships, actions, data blending, filters, parameters, hierarchies, Level-of-Detail (LOD), calculated fields, sorting, groupings, live connections, and in-memory in Tableau 10.4.
• Undertook leading role in the design and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards for a Diabetes care company.
• Proficiency in Tableau 2019.x/2018.x/ 10.5/10.4/10.3 /10.2/10.0/9.3/9.1/8.2/8.0, Tableau Server, Tableau Cloud, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader.
• Identified healthcare KPI’s to understand the requirements for the dashboards
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop (2019.1/2018.1/10.5/ 10.4/10.3/10.2/10.1/9.3/9.2 ).
• Worked on creating interactive, real-time dashboards using drilling downs and customizations.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• Setup trusted authenticationinTableau serverand pass requests fromWeb server
• Designed and setup user securityfor the entire landscape to facilitate Windows AD login.
• Used Tableau Cmd for various Dashboard migrationsfrom one environment to another.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Worked closely with Business users to collect requirement and dashboard functionality design.
• Designed dashboard layout and functionality to measure different metrics for the sales team and drill down navigation setup to get the possible granularity.
• End-to-end performance tuning of Hadoop clusters andHadoop MapReduceroutines against large data sets.
• Involved in designing and deploying multiple applications utilizing almost all the AWS stack (Including EC2, Route53, S3, RDS, Dynamo DB, SNS, SQS, IAM) focusing on high-availability, fault tolerance, and auto- scaling in AWS Cloud Formation
• Experience in working with AWS, Azure and Google data services Prior experience in client facing projects.
• Managed a migration project by building interactive dashboards on Tableau2019.1 for IT leaders to track day forecast progress via calendar visuals, view status matrix of stakeholders and app % complete tracker.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Handled user licenses for projects
• Identify opportunities to develop forecasts, statistical model, segmentation schemes, and data-driven analyses to drive marketing and merchandising efforts around customer acquisition and conversion
• Importing tables using Warehouse catalog and Creating Logical Tables
• Involved as a technical expert providing input to application design regarding production tuning and administration requirements.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.
• Partner with the Technology teams to deliver a stable and highly available reporting platform
• Plan and implement the overall analytics and business intelligence strategy
• Provided support to consultants, Technical Support engineers in creating and troubleshooting Micro strategy SDK customizations.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment
• Worked with the administrator to monitor and fine tune SQL queries for better performance of reports

Confidential

Senior BUSINESS iNTELLIGENCE Developer

Responsibilities:

• Gathering the report requirements from various stakeholders, cross functional departments, business users and documenting them in the report’s specifications document and report inventory.
• Streamlined FM modeling process using best practices to import metadata, preparing business logic, data models involving cardinalities, joins, unions, resolving loops using contexts/aliases and variables, setting up object level security.
• Performance tuning and testing stored procedures, indexes and triggers using Database Engine tuning advisor and SQL server profiler.
• Local IS/IT Project Lead for Business Intelligence.
• Fine tuning and optimization of SQL queries and Stored procedures using SQL Profiler, Trace and Performance monitor and ensuring indexes are using updated statistics.
• Provide database coding to support various business applications using T-SQL.
• Prepared Project Plan identified and notified the project team members.
• Plan, manage, and monitor all aspects of Enterprise Management support as the Reporting Lead Analyst.
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver.
• Setup and configuration of Tableau server in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Setup trusted authenticationinTableau serverand pass requests fromWeb server
• Setup of Distributed Server environmentsfor optimum load balancing.
• Created parameters, calculated sets and action filters for preparing worksheets and dashboards in Tableau.
• Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts, Tree maps, Word clouds, Bubble Charts, Pareto Charts, Waterfall Charts, Bump Charts, Funnel Charts, Bollinger Charts) based on client’s need.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets..
• Effectively used data blending feature in tableau and defined best practices for Tableau report development.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Worked heavily usingTabadmin toolsandTableau Cmdfor setting upsecurity profiles for various User groups and Users.
• Setup user securityfor the entire landscape to facilitate Windows AD login.
• Managed report scheduling using Tableau server. Creating New Schedules and checking the tasks daily on the server.
• Involved in maintaining server activities, Customized view and user activity on Server Analysis
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Handled user licenses for projects.
• Importing tables using Warehouse catalog and Creating Logical Tables.
• Involved as a technical expert providing input to application design regarding production tuning and administration requirements.
• Lead the design and development of analytical projects designed to understand key business behaviors that drive customer acquisition, retention, and engagement.
• Partner with the Technology teams to deliver a stable and highly available reporting platform.
• Plan and implement the overall analytics and business intelligence strategy.
• Provided support to consultants, Technical Support engineers in creating and troubleshooting Micro strategy SDK customizations.
• Provided the supporting role in designing the Security Architecture in the Business Objects
• Worked on CMC to create the User-groups and worked on the security rights.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.

Confidential, KENILWORTH, NJ

BUSINESS INTELLIGENCE Developer

Responsibilities:

• Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Setup and configuration of Tableau server 10.4 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Gathered user requirements, analyzed, and designed software solution based on the requirements.
• Worked on Agile methodology and involved in scrum meetings to give inputs as technical expert to application design for performance tuning and admin requirements.
• UsedPowerBItools likePowerBIdesktop, injecting on-premises and cloud data source, DAX, EmbeddedPowerBI, Publishing Dashboards, DAX queries and integration with other office products.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Hands-on and extensive working experience on Business Intelligence IT solutionETLprocesses.
• Worked with Line of Business team in Automation of Loans issues to clients on site with SAP
• Work with stakeholders to assist them with analyzing their data and defining performance management requirements.
• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Setup and configuration of Tableau server in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Defined relationships, created actions, filters, Level-of-Detail (LOD) expressions parameters, data blending, hierarchies, calculated fields, sorting, groupings, live connections, in-memory in both tableau and excel.
• Convert business requirements into storytelling viz by developing views and dashboards in Tableau Desktop and publish them to Tableau Server
• Used Alteryx Analytics to simplify the complex task of determining and gathering the relevant data and then cleansing the data for consumption.
• 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.
• Worked on creating interactive, real-time dashboards using drilling downs and customizations.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• Setup trusted authenticationinTableau serverand pass requests fromWeb server
• Designed and setup user securityfor the entire landscape to facilitate Windows AD login.
• Used Tableau Cmd for various Dashboard migrationsfrom one environment to another.
• Setup of Distributed Server environmentsfor optimum load balancing.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development andeffectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Extensively worked on micro strategy administration that includes intelligence server administration, configuration of memory settings and performance monitoring
• Handled user licenses for projects
• Identify opportunities to develop forecasts, statistical models, segmentation schemes, and data-driven analyses to drive marketing and merchandising efforts around customer acquisition and conversion
• Importing tables using Warehouse catalog and Creating Logical Tables
• Involved as a technical expert providing input to application design regarding production tuning and administration requirements.
• Lead the design and development of analytical projects designed to understand key business behaviors that drive customer acquisition, retention, and engagement
• Managed the migration of fixed income data mart from oracle to Teradata
• Partner with the Technology teams to deliver a stable and available reporting platform
• Plan and implement the overall analytics and business intelligence strategy
• Provided support to consultants, Technical Support engineers in creating and troubleshooting Micro strategy SDK customizations.
• Provided the supporting role in designing the Security Architecture in the Business Objects 4.1
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment
• Worked with the administrator to monitor and fine tune SQL queries for better performance of reports

Environment: Tableau 10.1 (Desktop/ Server), Oracle, Sales page, MS SQL Server 2012, Alteryx, Redshift, Adobe Analytics

Confidential, DEERFIELD, IL

BUSINESS INTELLIGENCE CONSULTANT

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Created 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 for Amazon.
• 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, Background images, Maps.
• 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.
• 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, lookup 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
• Developed mappings to support incremental loading. Used change data capture (CDC) tables as source tables for incremental
• Lead BI work stream projects in the implementation and use of new BI software tools and systems.
• Got involved in designing the Data model for the Data warehouse and for different Data marts
• Performed End to end testing using SQL Queries in Oracle.
• Prepared many other reports by using master details, crosstabs, slice and dice and drill mode as per the requirement of the end-uses
• Work with business owners to identify information needs and develop reporting; primary partners include the management team, finance & accounting, marketing, online retail, merchandising and operations

Confidential, GA

Tableau Developer

Responsibilities:

• Setup and configuration of Tableau server 9.1 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections and in-memory in both tableau and excel.
• Set up trusted authentication in Tableau server and pass requests from Web server.
• Used quick filter to turn on or off across all worksheet.
• Responsible for developing, unit testing and supporting various testing phases for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files and Access) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Setup user security for the entire landscape to facilitate Windows AD login.
• Involved in writing Complex Calculations, Used Fixed LOD's to avoid Duplicate measure values on One-to-Many Relationship Type Data Mode
• Setup of Distributed Server environments for optimum load balancing.
• Created parameters, calculated sets and action filters for preparing worksheets and dashboards in Tableau.
• Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts, Tree maps, Word clouds, Bubble Charts, Pareto Charts, Waterfall Charts, Bump Charts, Funnel Charts, Bollinger Charts) based on client’s need.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps.
• Trend Lines, Statistics and Log Axes, Groups, hierarchies and Sets to create detail level summary report and Dashboard using KPIs.
• Effectively used data blending feature in tableau and defined best practices for Tableau report development.
• Create, customize share interactive web dashboards in minutes with simple drag drop method and access dashboards from any browser or tablet.
• Involved in maintaining server activities, Customized view and user activity on Server Analysis and in creating dashboards in Tableau 8.1.
• Connected to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Identified opportunities to develop forecasts, statistical models, segmentation schemes, and data-driven analyses to drive marketing and merchandising efforts around customer acquisition and conversion.
• Imported tables using Warehouse catalog and Creating Logical Tables.
• Involved as a technical expert providing input to application design regarding production tuning and administration requirements.
• Lead the design and development of analytical projects designed to understand key business behaviors that drive customer acquisition, retention, and engagement.
• Managed the migration of fixed income data mart from oracle to Teradata.
• Partnered with the Technology teams to deliver a stable and highly available reporting platform.
• Planned and implement the overall analytics and business intelligence strategy.
• Provided support to consultants, Technical Support engineers in creating and troubleshooting MicroStrategy SDK customizations.
• Provided the supporting role in designing the Security Architecture in the Business Objects 4.1.
• Worked on CMC to create the User-groups and worked on the security rights.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.
• Worked on lifecycle manager for business objects Xi R3.1. Promotion Management for 4.1
• Worked with the administrator to monitor and fine tune SQL queries for better performance of reports.

Environment: Tableau Desktop, Tableau Server, Oracle SQL Server, Microsoft Excel 2007, MS Access, Microsoft office.