Candidates About

 

Akki Dandu

SUMMARY

·         8+ years of experience in Data Analysis, Design, Development, Integration, and Implementation of Business Intelligence and 6 years of experience working with Tableau.

·         Having experience working with Tableau Desktop and Tableau tools including Tableau Server, Tableau Reader, Tableau Public, Tableau Mobile, Tableau Online from versions 8.x to 10.x.

·         Worked on Tableau 10.5 beta version.

·         Experience in Tableau server installation, configuration, and administration & experience in creating Tableau Mobile dashboards. 

·         Experience in creating highly interactive Dashboards using Tableau Desktop.

·         Experience in publishing Tableau dashboards.

• Used filters, parameters, sets, groups, hierarchies (Customer and default), calculated fields and table calculations to create highly interactive, user friendly and creative dashboards.

·         Expertise in managing & setting permissions, publishing various data sources and workbooks to Tableau Server.

·         Experience in working on generating various dashboards to Tableau Server using different data sources such as Oracle, SAS datasets, Teradata 14/12, MS Excel etc. 

·         Experience in Tableau admin roles such as managing user roles, create/manage groups, workbooks, and Projects. 

·         Experience in using advanced SQL techniques to extract data from SAP HANA database

·         Experience in using Java Scripting via API Connector to create dynamic Dashboards in Tableau. 

·         Used Sign in method using the REST API for successful sign in operations.

·         Experience in migrating Workbooks and Tableau Server Backup, Debugging and monitoring using Tableau Server commands.

·         Created Parameters on reports to give a more User-friendly experience to End Users. 

·         Expert in Using Global Filters, Context Filters, Action Links in Dashboards.

·         Experience in adding Base lines, Trendlines, Quick &Table Calculations, and Annotation's. 

·         Experience working with Legends, Marks, Colors, Sizes, and Shapes in Tableau Desktop.

·         Building and publishing customized interactive reports and dashboards, report scheduling using Tableau server.

·         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.

·         Experience in monitoring server activities and usage statistics to identify possible performance issues. 

·         Used SAML for configuration of Tableau Server SSO supplementing Kerberos authentication on the side

·         Experience in creating various User groups by assigning row and column level security at application level, folder level and user level

·         Configured Tableau Server for SSO using Kerberos authentication with key tab file.

·         Used Kerberos For User authentication thru Active Directory

·         Used Tableau Cmd for various Dashboard migrations from one environment to another. 

·         Setup Distributed Server environments for optimum load balancing.

·         Assigning various extract schedules and using blending techniques to optimize the performance of Tableau

·         Experience in implementing AWS security features in Tableau server and Migrating the existing BI system to the AWS cloud.

·         Tracked Tableau Server Performance for Alerts, Monitoring, Tuning, and Troubleshooting. 

·         Experienced in creating Tables, Stored Procedures, Views, Indexes and writing DDL, DML and DCL commands in both SQL Server and Oracle.

• Used SSRS to create and manage a wide variety of different types of report, and deliver them in a range of formats.
• Used SSRS to create basic reports containing tables and graphs and more complex data visualizations, using charts, maps and sparklines.
• Used Report Manager to view the reports within the web based applications.
• Worked on SSRS reporting using the report wizard, designing the tables, and creating reports using report designer.
• Created interactive, tabular, graphical, and free-form reports from relational, multidimensional, or XML-based data sources using SSRS.

·         Experience in Integrating Alteryx with Tableau and publishing to Tableau server from Alteryx 

• Experience in using Alteryx for data prep, blending and shaping for insight and analysis.

·         Experience in Agile and Scrum Methodology

 

 

Experience

Johnson & Johnson - New Brunswick, NJ

Tableau Consultant/Administrator                                                      April 2016 to Present

RESPONSIBILITIES: 

·         Responsible for creating, designing, and developing User Interaction dashboards using Tableau Desktop

• Worked on creating schemas and connecting tableau to AWS Redshift and Hive

·         Developed YoY, QoQ, MoM reports which compare the hiring activity parameters from the previous years, quarters, and month in a fiscal year. 

·         Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation. 

• Worked with Tableau’s JavaScript API and Oracle Database

·         Created Metadata dictionary dashboard and allowed the business users to audit the metadata of identified data sources.

·         Combined multiple dashboards into a single story to enhance the visual appeal of the report. 

·         Used excel sheet, flat files, CSV files to generated Tableau adhoc reports. 

·         Gathered business requirements and transformed the business into high interactive Data Visualization using Tableau. 

·         Transformed complex data into easy-to-understand visualizations using Tableau and created a Story. 

·         Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps, Highlight tables etc. 

·         Generated Tableau Dashboards with filters, quick filters, context filters, global filters, parameters, and calculated fields on Tableau reports. 

·         Generated Tableau reports with Trend lines, Reference lines and Bands and generated several drills down and drill up reports. 

·         Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes. Combined Multiple data sources by joining tables and using Data Blending. 

·         Published Workbooks by creating user filters and security, so intended teams can view it. 

·         Worked on groups, sets, different calculation functions including Table calculations. 

·         Validating and Testing the server content after Major Version Upgrade 

·         Monitoring schedules and extracts and debugging issues with data extracts if any

·         Hands on Tableau Administrator installation, configuration, and load balancing.

·         Scheduled data extracts/refresh on Tableau Server to ensure that the views and dashboards were displaying the changed data accurately 

·         Created a Row Level Security and shared the reports with users. 

·         Creating/Managing the Projects, Groups, Users, Schedules, tasks and assigning the right permissions to them. 

Dexcom - San Diego, CA

Sr. Tableau Consultant                                                           November 2014 to April 2016

Responsibilities: 

•        Developed Ad-hoc reports using Tableau Desktop. Used excel sheet, flat files, CSV files to generated Tableau adhoc reports. 

•        Worked as Tableau SME in standardizing Tableau for shared services deployment. 

•        Created data dictionaries and identified the data items required for the dashboards. 

•        Created views using various axes like Individual Axes, Dual Axes and Blended Axes. 

•        Marked up the dashboards and walked through the end users. 

•        Involved in reviewing business requirements and analyzing data sources for design, development, testing and production. 

•        Interacted with business users and performed Gap Analysis of Client requirements. 

•        Developed Pie, Horizontal and Donut Charts to represent the SLA's of various departments and Ticket distributions.

•        Created Data extracts for better performance and accessing data offline

•        Created views/reports in Tableau Desktop and published to internal team for review and further data analysis. 

•        Wrote SQL queries for data validation by using join conditions.

•        Worked closely with business power users to create reports/dashboards using Tableau desktop. 

•        Implemented AWS security features in Tableau server by providing AWS security features that Tableau Server can use to protect the environment, including Amazon Virtual Private Cloud, Security Groups, AWS Identity and AWS Direct Connect.

•        Integrated Alteryx with Tableau and Published to Tableau server from Alteryx 

•        Created customized Calculations, Conditions, and Filters for various analytical reports. 

•        Combined views/reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users. 

 

 

 

 

 

STANLEY Healthcare - Waltham, MA

Tableau Developer                                                                  November 2012 to October 2014

Responsibilities: 

•        Responsible for development of global reports and dashboards to server multiple external/internal users using Tableau Desktop/Server

•        Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality. 

•        Administer and support Tableau Infrastructure including Security Administration, troubleshoot workbooks, Performance Monitoring and System Maintenance Responsible for Data modelling and implementing security on reports for external customers. 

•        Involved in Migration of SSRS reports to Interactive Tableau Dashboards. 

•        Used advanced SQL techniques to extract data from SAP HANA database.

•        Designed and developed various analytical reports using Tableau Desktop. 

•        Utilized advanced features of Tableau software to link different data sources together on one dashboard and to filter data in multiple view at a time. 

•        Design and develop various reports and dashboards which can be viewed through iPad, iPhone, laptop, Desktop, Smartphones, etc.

•        Used Java Scripting via API Connector to create dynamic Dashboards in Tableau. 

•        Defined best practices for Tableau reports/dashboards development. 

•        Involved in performance tuning, Reports tuning, caching, and report optimizations. 

•        Created/modified interactive dashboards, Guided navigation links within interactive dashboards. 

 

 

 

J Knipper & Co Inc - Lakewood, NJ

SQL Developer/BI Developer                                                 September 2010 to October 2012

Responsibilities: 

•        Interact with Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema. 

•        Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs, C# and VB code as required 

•        Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages. 

•        Performed in slow changes SSIS packages dimension.

•        Performed incremental data load packages in SSIS. 

•        Developed, monitored, and deployed SSIS packages. 

•        Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.

•        Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports

•        Designed and developed parameterized reports, linked reports, Matrix and generated multiple Enterprise reports (SSRS) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc. 

•        Optimize SQL queries for improved performance and availability.

•        Responsible for fine tuning of the database, troubleshooting, memory management. 

•        Created reports based on database usage and perform capacity planning. 

•        Involved in using T-SQL to provide definition, structure and to maintain data efficiently.

•        Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers. 

 

Fidelity Investments - Westlake, Texas

SQL Developer                                                                                        May 2009 to July 2010

Responsibilities: 

•        Involved in Database design and Database objects and partly Involved in Performance tuning

•        Loaded the data into database tables using ETL from text, Excel files, etc.

•        Automated the SSIS Packages using the SQL Server Agent Jobs. 

•        Troubleshooted the SSIS/SQL job Agent whenever necessary. 

•        Created SSIS packages to clean data and load data. 

•        Imported the various files provide by the clients into the relational database systems. 

•        Created new tables, views, materialized views, Packages, Stored Procedures, functions, triggers, and Cursors per the requirements.

•        Developing ETL Packages using SQL Server Integration services to populate data from different sources like flat files/CSV Files to the staging databases.

•        Involved in developing E-R diagrams, logical & physical data modeling, development, and implementation of the system.

•        Developed reports using SSRS and maintained the application as per the user requirement. 

•        Worked as the liaison to resolve organizational gaps. 

 

 

Technical Skill Set

·         Tableau Desktop 10.5/10.4/10.3/10.2/10.0/9.3/9.2/9.1/8.2: Used various tableau versions to create visualizations appealing to end users and customers

·         Tableau Cloud, Tableau Reader, Tableau Public, Tableau Mobile: Well versed with other products of Tableau on what to use per requirements

·         C, C+ +, Visual Basic, R, Python, ASP.NET, SQL, PL/SQ.

·         XIR2/10.0/9.0/8.0, Universe Designer, Xcelsius 2008/4.5

·         Platforms: UNIX, Win, LINUX, Web Sphere, Apache/Tomcat, Oracle, MS SQL Server, Access, DB2, Teradata, Cassandra, Alteryx.

·         Oracle 9i/ 8i/7.3, MS SQL Server 2000/7.0/6.5, Access, MongoDB, DB2, Teradata, Hive, Redshift, AWS