SUMMARY:

• I am adept at anticipating business needs and delivering elegant BI solutions that align with organizational objectives. I thrive in an ambiguous environment by generating innovative ideas that map to the big picture. As a BI Consultant I consistently join the right talent with a project, maximize efficiency, and deliver on a deadline. My extensive experience has afforded me the opportunity to take on highly visible roles, but I get my satisfaction from the appreciations and challenges I achieve.

• I am looking for opportunities to work for a company, with a high degree of visibility and a high business impact. I do not simply submit a good plan, but always provide metrics to prove the impact of my strategies. My objective is to find a company that can exploit my skills in the interests of creating a success story within the organization.

• Over 10 years of extensive BI Experience in Enterprise Environment, in Tableau 2019.X,10.4, 10.3/10.2/10.1/9.2/9.1/8.0/7.0 , Business Objects, Power BI and Qlikview as a BI Developer and Analyst.
• In - depth knowledge on Tableau Desktop, Tableau Server, Tableau reader, Tableau Online, Business Objects 4.1/3/1, Power BI, Qlikview and designed several business dashboards and reports. Worked on different Tableau versions (Tableau 2019.x, 10.4/10.3/10.2/10.1/10.0/9.2/9.1/8.0 ) .
• Extensive experience of around 6+ years as a Tableau Developer and 4+years as a Tableau Administrator.
• Experience in Tableau 2019.x,10.x and 9.x as a BI Developer and Analyst. End to end involvement in designing and deploying data visualizations and creating Calculations, Formatting using Tableau Desktop
• Expertise in providing end to end BI solutions by configuring metadata and building Dimensional Modelling designs, building business models, generating reports, Visualization and creating dashboards using Tableau.
• Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Experienced in Data Modeling, Multi-Dimensional Modeling and involved in creation of Star Schema and Snowflake dimensional schema
• 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.
• 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.
• Used R functions and models in Tableau by creating new calculated fields that dynamically invoke the R engine and pass values to R.
• Accessed many R packages or functions that has been installed in an R server and take advantage of all the visualization capabilities in Tableau to further analyses and understand data without having to manipulate data in R.
• Prepared scripts to ensure proper data access, manipulation and reporting functions with R programming languages.
• Formulated procedures for integration of R programming plans with data sources and delivery systems.
• 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.
• Worked on configuring reports from various Data sources using Data blending.
• Expert in Tableau server commands to migrate workbooks and Tableau server backup, Debugging and monitoring.
• Extensive knowledge in different reporting objects like Facts, Attributes, Hierarchies, Calculated fields, Transformations, filters, Sets, Groups, prompts, Parameters etc. in Tableau.
• Generated and implemented MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using MicroStrategy Desktop.
• Extensively worked with MicroStrategy Intelligence Server, MicroStrategy Web and Micro Strategy Administrator reporting basic using MicroStrategy Desktop and MicroStrategy Web.
• Involved in troubleshooting MicroStrategy prompt, filter, template, consolidations and custom group objects in an enterprise data warehouse team environment.
• Worked on the improvement of Dashboard reports by creating KPI (key performance indicators) for the top administration.
• Improved Reports performance in tableau using extracts and context filters.
• Experienced in data warehousing using Amazon Redshift when dealing with large sets of data. Developed complex visualizations using Amazon Redshift.
• Published Workbooks by creating User filters and sites (User groups, access) so that only appropriate teams can view it.
• Created calculated fields to interact with parameters dynamically to visualize the data on the fly.
• Used the Tableau Online sync application to schedule automatic refresh tasks for extracts of data and to maintain on local network.
• Used Kerberos for user authentication thru Active directory (Win AD).
• Used Sign in Method using the REST API for successful sign in operations
• Used Amazon Elastic Compute Cloud (Amazon EC2) to provide resizable compute capacity in the cloud.
• Familiarity with tools like Python, R, parallel query processing, Hadoop, Hive, Pig, Elastic
• Experienced in developing Web Services with Python programming language
• Migrated Tableau Server to AWS cloud and viewed from the framework of a traditional infrastructure.
• Working knowledge in gather external data to Tableau from different sources like Oracle, MySQL, AWS Redshift, SQL Server & flat flies etc., for data visualization
• Used Amazon EC2 for the servers that run Tableau as an application along with web servers, databases, and Tableau Server.
• Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, V arrays, Records, Types.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DBMS SQL and PL/SQL collections and used BULK binding involved in writing database procedures, packages and functions for front end module
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, TK-Prof and Table Partitioning. Expertise in constructing T-SQL and Oracle PL/SQL Tables, Stored Procedures, Views, Functions, Packages, Triggers, Cursors, Indexes, User Defined Data Types, Constraints to facilitate efficient data manipulations as per the business rule.
• Connected to Tableau through SQL, AWS Redshift databases (Now implementing in Azure) to create customized interface for Tableau workbooks to provide native intranet style navigation.
• Setup security profiles for various user groups and users using Tab admin and Tabcmd Tools.
• Installed Tableau Server in a Distributed Environment and worked on Worker Nodes and added additional worker nodes
• Used Configuration utility to work on setting up of worker nodes by configuring and updating Primary nodes.
• Used Kerberos for user authentication through Active directory (Win AD).
• Extensively worked on setting up of Sites, Projects, groups, Users, Schedule refreshes & subscriptions
• Configured the SMTP setup for the subscriptions and alerts to get emails accordingly
• Monitored the disk usage accordingly to maintain optimum free space for other activities to run smoothly
• Setup Active directory authentication and local authentication for various users and maintained various security profiles accordingly.
• Created various User groups by assigning row and column level security at application level, folder level and user level.
• Configured the distributed Tableau Server environment for real-time replication and failover support.
• Worked on setting permissions on content for specific users or group on a per site basis
• Created sets and used them in the calculated fields to retrieve the specific data by combining multiple sets and visualize the data.
• Participated in day to day activities like creating workbooks, dashboard, published on server.
• Created cascading filters to filter the data within the hierarchy and prompt to specific filter that is applied by cascading.
• Configured Tableau Server for SSO (Single Sign-On) using Kerberos authentication with key tab file.
• Experience in Agile and Scrum (Scrum master) Methodology.
• Capable of forming and keeping up positive and gainful working connections in interior/ external and team environments.

TECHNICAL SKILLS:

• Tableau 2019.X,10.4, 10.3/10.2/9.2/9.1/8.0 , Tableau Server, Tableau Reader, Tableau Online, Tableau Mobile, Tableau Public, Qlilkview, Informatica, Microstrategy.
• SAP-BI, BW, SAP BOBJ 4.0/3.1, HANA
• C, C+ +, Visual Basic, ASP.NET, SQL, PL/SQL. Platform: UNIX, Win 98/XP/2000/NT, DOS
• XIR 2/10.0/9.0/8.0 , Universe Designer, Xcelsius 2008/4.5
• Windows, UNIX, LINUX, Web Sphere, Apache/Tomcat.
• ABAP/4 and Web Technologies
• ERP: SAP R/3 4.7, 4.6c, 4.5b and 3.x.
• Data Warehousing: BW 3.5, 3.1c, 3.0b, BI 7.0,
• Oracle 11g/ 10g/9i/ 8i/7.3, MS SQL Server 2000/7.0/6.5 , IBM DB2, Netezza, Teradata, Amazon Redshift.

PROFESSIONAL EXPERIENCE:

Confidential, New York City NY

Sr. Tableau Consultant

• Designed and developed self BI Analytics platform and trained the Business Users to use this BI platform on their own to analyze their data by building simple reports.
• Collaborated with end users, project stakeholders and support partners to identify needs, goals, and business models.
• Extensively worked on metadata in Tableau desktop to modify data types, rename fields, joins, assign roles, refresh data and change extract data options to prepare data sources to be used by users
• Developed or maintained standards, such as data architectures, data models, tools, Organization business structure and nomenclature, for the design of BI Analytics platform
• Worked on large data sets performing data analysis, data manipulation, data cleansing and data mining.
• Worked on different domains of data like Ticketing & Operations, Food, Beverages & Merchandise, Marketing, CRM Analytics and Fan 360.
• Developed complex queries in Redshift for loading data from AWS Redshift staging to Redshift Warehouse.
• Responsible for bringing data from Source systems such as SAP BW (via SAP BODS jobs) and Oracle system to data lake (Redshift warehouse).
• Develop various dashboards to monitor the server performance by accessing the Tableau server data by connecting through PostgreSQL
• Develop interactive visualizations utilizing various reporting components from multiple data sources.
• Use advanced and complex calculations like Level of Details (LOD) to remove duplicate records from de-normalized joins and develop business critical KPI's by fixing the values on fixed dimensions.
• Maintain and own DQ reports which are built using Tableau Extracts and Redshift for different business domains like Ticketing sales and Operations, Marketing etc.
• Developed the ETL framework to automate data load of Dimensional and Fact table from Source system using Data services SAP.
• Connected Tableau with Python to provide fast visual analytics solutions with data mapping. Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
• Automated data inflow from the different CSV files and worked on data cleaning and ensured data quality, consistency, integrity using Pandas, NumPy.
• Experience in installing Tableau Server on both on-Premise as well as the Cloud, using Amazon EC2 instances in Amazon Web Services (AWS)
• Involved in testing Tableau reports, Dashboards, Scorecards and handled the performance issues effectively using extracts, data source filters and context filters.
• Good knowledge on Tableau JavaScript API's implementing on the cloud environment.
• Good Understanding in integration of Python through TabPY, Tableau Python Server in Tableau 2018.X
• Expertise in enhancements/bug fixes, performance tuning, troubleshooting, impact analysis, Unit testing, Integration Testing and UAT.
• Designed and setup user security for the entire landscape to facilitate Windows AD login.
• Used Tableau CMD for various Dashboard migrations from one environment to another.
• Setup of Distributed Server environments for optimum load balancing.
• Set up Script based installation to trigger Tableau Desktop installation on the user local systems once user request is approved.
• Configured Viz Alerts to trigger email to Production support whenever there is an extract failure.
• Developed various dashboards to monitor the server performance by accessing the Tableau server data connecting PostgreSQL
• Leveraged full range of Tableau platform technologies to design and implement production ready web solutions and created advanced BI visualizations.

Confidential, Minneapolis MN

Sr. Tableau Consultant

• Gathering the report requirements from various stakeholders, cross functional departments, business users and documenting them in the report’s specifications document and report inventory.
• 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.
• 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.
• Monitoring SQL server performance using profiler to find the performance, dead locks blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Involved in created stored procedures, views, and custom SQL queries to import data from sql server to tableau.
• Ability to work quickly and under tight delivery deadlines with focus on details.
• 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 mockup dashboards and presented to the higher-level end users to have them a look and feel of the dashboards
• Developed mappings to support incremental loading.
• Got involved in designing the Data model for the Data warehouse and for different Data marts
• Created SSIS package for daily email subscriptions to alert Tableau subscription failure using the ODBC driver and PostGreSQL database.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in Tableau.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
• Developed multiple custom admin views by connecting to PostGRES database to improve the Server performance and tuning it for optimization.
• Responsible for Administering Tableau server and user management.
• Automated Server backups, Server logs by using Python script.
• Configured VizAlerts to trigger email to Production support whenever there is an extract failure.
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Used TWB Auditor to audit the workbooks / data sources, tables, columns used in a database directly from the server.
• Developed dashboards showing the render times of different views / workbooks within all sites and calculated the execution times/ delay times.
• Implement Column freeze pane concept in Tableau with multi-layer web object concepts.
• Implement Pop-Up feature in Tableau where users can see some of the filters only when they select a value in the filter/parameter.
• Provided overall support in troubleshooting Tableau desktop/Server problems within IT, Investment Services, Corporate Applications.
• As an Admin Created sites, added new users, published data refresh extract, scheduling subscriptions, configured row and object level securities based on Users and groups.
• Automated Server backups, Server logs by using Python script.
• Configured VizAlerts to trigger email to Production support whenever there is an extract failure.
• Wrote PostGres queries to help Production support team for identifying whether the extracts ran successfully or not.
• Proposed many ideas wherever there is a room for automating Tableau server admin related activities.

Confidential, McLean VA

Sr. Tableau Consultant

• Deep experience with the design and development of Tableau visualization solutions.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter and Context filter to improve performance.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Create required shell or python scripts for data push from Tableau/Teradata to S3.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right, full) in Tableau desktop to validate and reconcile data.
• Responsible for Data Extraction and Transformation from disparate sources like Oracle, flat files and Loading to Oracle using Informatica Power Center.
• Worked extensively with advanced analysis Actions, Calculations, Parameters, Background images, Maps.
• Created Transformations for comparative reports like sales this year-to-date, Month- to-date, Quarter-to-date etc.
• Connected to Tableau through SQL, AWS Redshift databases (Now implementing in Azure) to create customized interface for Tableau workbooks to provide native intranet style navigation.
• Developed views and templates with Python and Django's view controller and templating language to created user-friendly website interface.
• Used MySQL as back-end database and MySQL dB of python as database connector to interact with MySQL server.
• Trend lines, Statistics and Log Axes, Groups, Hierarchies, sets to create detail level summary report and dashboards using KPI’s.
• Created Dashboards with interactive views, trends and drill downs.
• Developed SQL Queries to retrieve or create test data from different Redshift databases
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server
• Designed, loaded and managed an Amazon Redshift cluster of more than 2 terabytes of source system data over billions of records of fare-system and bus-location data.
• Provided access to data necessary to perform analysis on scheduling, pricing, bus bunching and performance.
• Queries in the Amazon Redshift environment performed x faster than in legacy environments.
• Used commands in Tab CMD and Tab admin utility tool and migrated Workbooks and Dashboards from Tableau 9.2 to Tableau 10.3
• Implemented new features in Tableau 9.2 to the existing Workbooks and Dashboards.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.
• Involved in installation and upgrade of Tableau Server and Server performance tuning for Optimization.
• Generated dashboards to compare the ILD/ELD losses.
• Created complex calculation using Table Calculation, Date, LOD function, Aggregate functions in Tableau
• Written numerous technical essays and taught workshops on building scalable web applications on AWS
• Used AWS configure network access and security for the VPC.
• Setup and configuration of the Tableau Server 10.2 in various environments and used Tableau CMD and Tableau Admin to configure the server as per the best practices.
• Used Amazon EC2 for the servers that run Tableau as an application along with web servers, databases, and Tableau Server.
• Analyzed and used Tableau Server system requirements based on many factors, including the number of users and target workload.
• Configured Tableau Server to use an external identity provider (IdP) to authenticate Tableau Server users over SAML 2.0
• Used REST API with Tableau Server to manage and change Tableau Server resources programmatically.
• Used the API for the functionality enhancement on the server for site users and sites on Tableau Server.
• Used REST API to create project permissions, sites and users.
• Used Java Script API to integrate Tableau Workbook and dashboard in the web application.
• Restricting data for users using Row level security and User filters.
• Worked on TABCMD & TABADMIN, Database maintenance and Troubleshooting
• Involved in building Dashboards using parameters, sets, groups and calculations.
• Designed Views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Confidential, Davis California

Sr. Tableau Developer

• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
• Understanding the useful and technical specification.
• Deep involvement with the design and advancement of Tableau visualization solutions.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons.
• Connected to different appliances like Oracle, MySQL, Tera Data, etc
• Used data base filters and context filters.
• Preparing Dashboards using calculations, parameters in Tableau and Developing Tableau reports that provide clear visualizations of various industry specific KPIs.
• Access and change extremely large datasets through filtering, grouping, aggregation, and statistical calculation
• Consult with customers and inside partners to accumulate necessities and set milestones in the research, advancement, and execution periods of the project lifecycle.
• Understanding of Tableau features like calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Involved in supporting other Tableau applications which includes creation and cosmetic changes of different
• Migrate existing reports from Share-point\excel to Tableau Server by recreating them in batches.
• Suggest alternate representation of existing reports to highlight the KPI in depth.
• Interact with business analyst to gather ad hoc business requirements and designed functional and technical requirements documentation.
• Provide master counsel to the Business Team on Best Practice design and visualization with Tableau.
• Managed the migration of fixed income data mart from oracle to Tera data.
• Partner with the Technology teams to deliver a stable and highly available reporting platform
• Plan and implement the overall analytics and business intelligence strategy.
• Worked on CMC to make the User-gathers and chipped away at the security rights.
• Managed the migration of fixed income data mart from oracle to Teradata
• 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 4.1
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment
• Worked on CMC to create the User-groups and worked on the security rights
• Worked on life-cycle manager for business objects Xi R3.1. Promotion Management for 4.1

Confidential, Raleigh NC

Sr. Tableau Developer

• Working with business users, functional lead to understand and document the Business requirements.
• Involved in installation of Tableau desktop 10.0, Tableau server Application software.
• Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• Functional role in defining the dashboard requirements and providing the best practices/approach to feed data to the reports/dashboards.
• Working on providing solutions to automate the extract refreshes based on new data feed.
• Created a landing page on SharePoint to link Tableau Server Dashboards to SharePoint
• Working with User for requirements and part of the team developing the data hub.
• Creating connections, joining new tables, creating & managing Extract and Monitoring Queries using SQL Developer.
• Developing parameter and dimension-based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated Tableau dashboards for sales with forecast and reference lines.
• Used multi-level hierarchy in Tableau Dashboard.
• Executing and testing required queries and reports before publishing dashboards.
• Providing support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Creating Tableau scorecards, Heat maps using show me functionality.
• Reviewed basic SQL and SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
• Publishing Reports, workbooks & data source to server and exporting the reports in different Formats
• Developing various types of complex reports like Level of Detail and Summary reports, Crosstab reports, Graphical reports, drilldown reports, on Demand and Linked sub reports using crystal reports, tables, views, business views.

Confidential, Greenwood-Colorado

Tableau Developer/ Admin

• Design the dashboard application with multiple dashboards as required as per the security requirements.
• Developed Life Cycle (SDLC) efforts required to deliver on EIM-related projects and deliverables and used these estimates to assign completion date and milestones for EIM-related deliverables, tasks, etc.
• Developed the web-intelligence reports, provided a supporting role in building the universes
• Ensured solutions meet the expectations of end users and train users
• Gather and analyze the business requirements and then translate them to technical specifications.
• Created different views in workbook to visually analyze data.
• Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets
• Worked on Performance Tuning of the Workbook and improved the performance of the report running for 15 min to 90 secs execution time.
• Effectively used data blending feature in tableau to get data from Sql Server & MS Excel
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations with ODBC connection
• Created out of the box charts for complex end user Requirements. Converted Heat map to funnel chart, Pie chart to a donut chart, Bar chart to a waterfall chart and many others.
• Executed and tested required queries and data before publishing Dashboard
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.

Confidential, Jacksonville FL

Tableau Developer

• Actively involved in review meeting with project manager to make sure that development of projects meets system and business requirements for design, development, testing and production
• Created Heat Map visualizing current service subscribers by color that were broken into regions letting business user to understand where we have most users VS least users.
• Involved in creating Duel-Axis bar chat with multiple measures
• Blended data from multiple databases into a single report by choosing Primary keys from each Database for Data validation.
• Generated report schedules on Tableau Server
• Involved in creating Parameters, Actions, Local Filter, Global Filter and calculated sets for preparing dashboards and worksheets using Tableau Desktop.
• Have seen the factors involving the performance of the reports and coordinated in building Indexes to improve the query turnaround time efficiently.
• Worked on creation of Users, Groups, Projects, Workbooks and the appropriate permissions sets for Tableau Server logins and security checks.
• Exclusively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository
• Performance optimization of the data warehouse by identifying and assisting in correcting EDW/BI performance bottlenecks and debug database, application or data content related issues.
• Worked on developing 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.
• Involved in publishing of various kinds of live interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers
• Using T-SQL, written various stored Procedures and modified them which are used in application.
• Schedule and maintain packages by daily, weekly and monthly in SQL server.
• Updating Databases to ensure Data integrity and performed quality assurance checks.
• Have scheduled Data refresh on Tableau Server for weekly and monthly increments based on business change to make sure that Views and Dashboards were displaying the changed Data accurately.

Confidential, San-Rafael CA

Tableau Developer

• Effectively used data blending feature in Tableau.
• Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view past, current and forecast sales data.
• Mentored business power users to create reports/dashboards using Tableau Desktop.
• Using Custom SQL for joining the tables and selecting the required Data.
• Generated Tableau dashboards with combination charts. Used custom SQL connections, filters, quick filters, sets, parameters and calculated fields within Tableau reports to facilitate automated data visualizations
• Involved in creating interactive, parameterized dashboards by extracting data from different sources using data blending and applying actions -filter, highlight and URL.
• Created dashboard from scratch that included drill-through, filters, Heat/Geo/Tree maps, Pie/Bar charts, Circle views, Line/Area charts, Scatter plots and Bullet Graphs.
• Utilized Data story telling in tableau to provide more dynamic and more effective stories from the hidden insights locked in the data.
• Created prompts, customized calculations, conditions and filters (Local, Global) for various analytical reports and dashboards.
• Created and modified interactive dashboards and developed guided navigation links within interactive dashboards.
• Published the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Built compelling, interactive dashboards in Tableau that answer key business questions.
• Produced complex table calculations use of parameters, actions, filters and other advanced options in Tableau.
• Involved in Tableau Server installations, configuration, creating users, groups, and projects.
• Designed excellent Tableau dashboards and presented correct decisions independently based on what different kind of visuals would make sense for the business.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Effectively used data blending, filters, actions, Hierarchies feature in Tableau.
• Using Calculations in Tableau like creating and Editing Calculated Fields.
• Involved in Unit testing the SQL Scripts for report development, Tableau reports, Dashboards and handled the performance issues effectively.
• Extracted data from internal data warehouse system to SSRS.
• Created ad-hoc reports.
• Analyzed data models, data relationships and dependencies for great optimization.
• Designed and developed stored procedures, queries, and views necessary to support SSRS reports.

Confidential, Cincinnati-Ohio

BI Consultant

• Involved in gathering business requirements from users, creating technical specification documents as per the business requirements, development/realization, testing and maintenance of objects
• Ability to communicate effectively with the business users, ensuring clients business processes are mapped in SAP, and aligning client expectations
• Assisted business analysts with requirements gathering and in design and development of ETL processes.
• Attendant in work stream planning process including inception, technical design, development, test and delivery of BI solutions.
• Check internal and external customer’s need and abilities in order to provide appropriate solutions.
• Deployed patches and updates from SAP as required
• Design the dashboard application with multiple dashboards as required as per the security requirements.
• Developed Life Cycle (SDLC) efforts required to deliver on EIM-related projects and deliverables and used these estimates to assign completion date and milestones for EIM-related deliverables, tasks, etc.
• Developed the web-intelligence reports, provided a supporting role in building the universes
• Ensured solutions meet the expectations of end users and train users
• Determining feasibility and providing technical solutions to design right-fit customer solutions enhancing their business functionality and overall performance using latest technologies
• Responsible for documenting modifications of new developments as well as pre-existing development for peer reference and knowledge transfer
• Develop, enhance and maintain custom and pre-delivered extractors to perform data extractions transformations, and application of business rules
• Extensively worked on designing/creating objects like Advanced DSOs, HANA-Optimized Info-Cubes, Composite Providers, Open ODS Views, SAP HANA Views, Web Intelligence reports, Crystal reports, Universes
• Sound technical knowledge and hands on experience in ABAP, ABAP Objects, ABAP Data Dictionary, Customer exits