Candidates About

 

Abhinav Veerelli

 

PROFESSIONAL SUMMARY

•      8+ years of experience in Business Intelligence technologies and Data warehousing along with around 5+ years of data visualization as Tableau Developer in which 3+ years as a Tableau Administrator.

•      Expertise in Tableau 10.4/10.3.1/10.2/10.1/10.0/9.2/9.1/8.x/7.x, Tableau Desktop, Tableau Server, Tableau Online, Tableau Mobile, Tableau Public, and Tableau Reader.

•      Designed several business dashboards using Tableau Desktop, Tableau Server, Tableau reader and Tableau Online.

•      Experience in analysis, data aggregation, blending among other things, and deploy statistical methods in Tableau.

•      Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at an application level, folder level, and user level.

•      Proficient with R language to write the appropriate scripts and functional calls they require.

•      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 the portal.

•      Setup trusted authentication in Tableau server and pass requests from the Web server.

•      Worked heavily using Tabadmin tools and Tableau Cmd for setting up security profiles for various User groups and Users.

•      Administered access to users to an R server to access R functions from Tableau Desktop or Tableau Server.

•      Worked on AWS EC2 Instances Provisioning, VPC setup, Auto Scaling for the availability of EC2Instances and availability of applications.

•      Designed and set up 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.

•      Used efficient load balancing techniques to manage the load on the server for concurrent user logins.

•      Experience with Tableau maintenance tools and Tableau server monitor to start/stop services and maintain statuses.

•      Experienced in managing schedules and scheduling workbooks and activities on Tableau Server.

•      Created Operational Dashboards to track information throughout the course of daily operations, understanding the status of production, machine utilization, web traffic, or other critical systems.

•      Combined multiple data sources using blending in Tableau to keep track of sensor data, operator inputs, and real-time systems all in one dashboard.

•      Proficient in integration, the configuration of R with Tableau.

•      Connected Tableau Server to Amazon Redshift with SSL and insured the connections are encrypted.

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

•      Analyzing web traffic and creating google analytic dashboards to visualize the web traffic interactively.

•      Setup of SSO between Tableau portal and Oracle.

•      Installed and setup cluster environment for Tableau server and used JMeter for load balancing and load analysis.

•      Experience in Designing and deploying AWS solutions using EC2, S3, RDS, EBS, Elastic Load Balancer, Auto-scaling groups.

•      Using the command line tools and configuration utility on the primary server pushed the updates to the workers.

•      Used Kerberos for user authentication thru Active directory (Win AD).

•      Experience in Migrating the existing BI system to the AWS cloud and Redshift.

•      Performance tuning for the Tableau Visualizations and Tableau server for more than 150 concurrent users.

•      Experience in the Installation and maintenance of Tableau in the cloud via Amazon Web Services EC2 services.

•      Experience with server migration and the Tableau Server installation process.

•      Optimize the VizQL server processes to handle loading and rendering views for Tableau Server.

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

•      Experience in visualizing using JavaScript API from Tableau Server, Tableau Public, and Tableau Online in web pages.

•      Capable of creating reports, designing Universes, Full Client/Web reports, Crystal reports etc.

•      Documenting reports requirement and details obtained from business users to design, develop, and maintain Business Objects, Web Intelligence, and Crystal reports

•      Excellent communication and interpersonal skill, decision-making skills, presentation skills along with management and ability to interact with end-users, managers, and technical personnel.

•      Experience on new Business Objects 4.1 client tools like Dashboard Design, BI Launch Pad, and Crystal Reports Enterprise etc.

•      Experienced in Analysis, Development, Design, and Maintenance of Business Intelligence applications.

•      Experienced in writing queries, stored procedures and functions using SQL.

•      Identifying Business Data and requirement and modifying it to logical data models.

•      Knowledge in creating Crystal Reports using crystal reports formulas, Grouping, Parameters, selection criteria to handle the customer’s requests from Tables, Views, and command objects.

•      Exposure to Big Data Hadoop environment and its components HDFS, ApachePig, Hive, Sqoop, MapReduce, HBase, ZooKeeper, Flume.

•      Quick Learner with excellent analytical and problem-solving skills with a positive attitude towards new challenges.

TECHNICAL SKILLS

·  Tableau 10.4/10.3.1/10.2/10.1/10.0/9.2/9.1/8.x/7.x, Tableau Server, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader

·  SAP-BI, BW, SAP BOBJ 4.0/3.1, HANA

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

·  Platform: UNIX, Win 98/XP/2000/NT, DOS

·  XIR2/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 9i/ 8i/7.3, MS SQL Server 2000/7.0/6.5, Access, MongoDB, DB2, Teradata, Hive, Redshift, AWS

 

EXPERIENCE

Fresenius Medical Care, Lexington, MA                                                                                                June 2016 - Present                                                                                                                         

Tableau developer

Roles and Responsibilities:

•      Involved as a technical expert providing input to application design regarding production tuning and administration requirements.

•      Created Relationships, actions, data blending, filters, parameters, hierarchies, Level-of-Detail (LOD), calculated fields, sorting, groupings, live connections, and in-memory in both tableau 10.4 and excel.

•      Building, publishing customized interactive reports and dashboards, report scheduling using Tableau online.

•      Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.

•      Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

•      Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop 10.4.

•      Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in Tableau 10.4. 

•      Connected to the AWS Redshift directly from Tableau10.3 to access cloud data warehouse and quickly perform visual analysis.

•      Worked on conversion of SSRS reports into Tableau in various visualizations.

•      Created automated scripts for tableau workbook refresh when not using live connections.

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

•      Created users using Tableau Admin and assigning privileges to create report/publishing reports to Tableau server.

•      Implemented row level, data-level, user-level security in Tableau 10.4.

•      Worked on Global Sales and created monthly, quarterly, yearly sales across various regions.

•      Used Elastic Load Balancing to distribute requests across multiple gateways in a Tableau Server cluster.

•      Used R functions and models in Tableau 10.4 by creating new calculated fields that dynamically invoked the R engine and pass values to R where the results are then returned to Tableau.

•      Used R for statistical Analysis on Tableau Data.

•      Used R built-in functions like SCRIPT_REAL, SCRIPT_STR, SCRIPT_INT and SCRIPT_BOOL to call R models and functions.

•      Used R and exported data via a supported data source and then visualized that data in Tableau.

•      Used R functions as Table calculations (aggregated) like Sum, MIN, MAX etc. in Tableau.

•      Lead the design and development of analytical projects designed to understand key business behaviors that drive customer acquisition, retention, and engagement.

•      Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.

•      Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

•      Partner with the Technology teams to deliver a stable and highly available reporting platform.

•      Plan and implement the overall analytics and business intelligence strategy.

Environment: Tableau 8.0/9.0, Tableau (server and desktop) 10.1, SQL Server 2016, Microsoft Windows 7/8.

Zelis Healthcare, Bedminster, NJ                                                                                                              Oct2015 - May2016                                                                                                                                        

Tableau Developer

Roles and Responsibilities:

•      Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards with HANA as Data Base.

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

•      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 accurately. 

•      Experience in integration of Python through TabPy, Tableau Python Server in Tableau 9.1.

•      Gathered Business Requirements by interacting with Business Users, Project Manager, and SMEs.

•      Analyzed metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.

•      Created python script for creating data source as .tde files.

•      Created python scripts for data push from Tableau/Teradata to S3.

•      Used Iron python scripts for few actions like carrying of filters from one filtering scheme to other, toggling between different visualizations etc.  Handled user licenses for projects.

•      Designed workflow in ETL tools and data preparation using Python (2.7) & Tableau.

•      Importing tables using Warehouse catalog and Creating Logical Tables.

•      Used Tableau with AWS cloud connecting to AWSEMR and AWS redshift.

•      Actively involved in the Server migration and the Tableau Server Installation process.

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

•      Collecting data, text standardization and performing text mining using different python libraries to create clusters and classify to compare the results and improve search of the platform.

•      Executed and tested required queries and reports before publishing.

•      Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.

•      Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.

•      Worked in the conversion of SQL server functions into the Teradata Store procedure for confirming the data.

•      Worked on Teradata Store procedures and functions to conform the data and load it on the table.

•      Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.

•      Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps, and Symbol Maps according to deliverable specifications.

•      Worked with business team and technology team in substantiating the system Requirement specifications document.

•      Proficient in discussing and defining project, Gap Analysis with the clients from both a business and technical perspective.

•      Identify opportunities to develop forecasts, statistical models, segmentation schemes, and data-driven analyses to drive marketing and merchandising efforts around customer acquisition and conversion.

Environment: Tableau 7.0/8.0/9.0, SQL Server 2015, Visual Studio 2015, Windows XP/Vista/7, Excel.

POP HealthCare, Franklin, TN                                                                                                                                    Nov 2014- Sep 2015

Tableau developer

Roles and Responsibilities:

•      Upgraded Tableau 7.0 to tableau 8.0 and gathered requirements, analyzed from raw data.

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

•      Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, Level-of-Detail (LOD), 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.

•      Developed mappings to support incremental loading. Used change data capture (CDC) tables as source tables for incremental.

•      Created and published packages for different functional areas and assigned security rules to them in Cognos Framework Manager.

•      Created Active reports using data deck, tab data button bar and sliders.

•      Created reports containing multiple data containers like List, Cross-tab, and Repeater tables in Cognos Report Studio.

•      Created dashboards for a managerial overview with drill up and drill down capabilities.

•      Scheduled reports using Cognos scheduler and emailed to various recipients as required.

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

•      Prepared many other reports by using master details, cross-tabs, 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.

Environment: Tableau Desktop 8.2/8.3, Cognos 6.0/7.0, SQL 2014, Windows XP, Vista, Excel

 

The Claro Group, Los Angeles, CA                                                                                                                            June 2013 - Oct 2014

Tableau Developer

Roles and Responsibilities:

•      Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and table calculations.

•      Hands-on experience in building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's.

•      Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.

•      Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

•      Utilized Tableau server to publish and share the reports with the business users.

•      Also involved in administration tasks such as Setting permissions, managing ownerships, and providing access to the users and adding them to the specific group.

•      Distributed Tableau reports using techniques like Packaged Workbooks, PDF to different user community.

•      Understand the Requirements and Functionality of the application from specifications.

•      Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

•      Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.

•      Created reports using prompts, sections, dynamic filtering, conditional layouts and multi lingual reports in Report Studio.

•      Developed Reports with multiple Cognos Viewers and integrated multiple Cognos reports onto a Single Page Report.

•      Scheduled and Distributed Reports through Schedule Management in Cognos Connection.

•      Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.

•      Defined best practices for Tableau report development and effectively used data blending feature in tableau.

•      Added views, objects, legends, and quick filters to Dashboards. Also added highlight, filter, and URL actions.

•      Used various calculation techniques like table, number, string, and logic calculations.

•      Used various join types (left, inner, right, outer joins) based on business requirements.

•      Created different KPI using calculated key figures and parameters using Oracle.

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

•      Developed donut charts and implemented complex features in charts like creating bar charts in tooltip.

 

Environment: Tableau Desktop 8.x, Tableau Server, Metadata, SQL 2012, Oracle 10g/11g, Windows XP.

 

 

Aetna, Hartford, CT                                                                                                                                        Aug 2012 - May 2013

Cognos Developer

Roles and Responsibilities:

•      Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and table calculations.

•      Hands-on experience in building Groups, hierarchies, sets to create detail level summary reports and Dashboard using KPI's.

•      Strong Dashboard design experience and passionate practitioner of effective data visualization. Familiarity with best practices around visualization and design.

•      Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

•      Utilized Tableau server to publish and share the reports with the business users.

•      Also involved in administration tasks such as Setting permissions, managing ownership