SUMMARY

• 10+ years of experience in IT industry as BI Developer with Tableau and Business Objects with strong background in Databases and Data warehousing concepts.
• Expertise in Tableau 10.4/10.3/10.2/10.1/9.3/9.2/9.1/8.0 , Tableau Server, Tableau cloud, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader
• Designed several business dashboards using Tableau Desktop, Tableau Server, Tableau reader and Tableau Cloud
• Worked on different Tableau versions (Tableau 10.4/10.3/9.3/9.2/9.1/8.0/7.0 )
• Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices
• Setup and configuration of Tableau server 10.0/9.2 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices
• 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.
• Designed, developed and implemented Tableau Business Intelligence reports.
• Create basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and ratios, date math, logic statements and quick table calculations.
• Representing data using the visualizations such using Charts.
• Setup trusted authenticationinTableau serverand pass requests fromWeb server
• Worked heavily usingTakamine toolsandTableau Cmdfor setting upsecurity profiles for various User groups and Users.
• Used the REST API with Tableau server to manage and change Tableau server resources programmatically.
• Used the API for the functionality enhancement on server for site users and sites on Tableau server.
• Created Operational Dashboards to track information throughout the course of daily operations, understanding the status of production, machine utilizations, 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.
• 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
• Used SAML for configuration of Tableau Server SSO supplementing Kerberos authentication on the side
• Used Kerberos for user authentication thru Active directory (Win AD).
• Used Sign in Method using the REST API for successful sign in operations
• Setup of SSO between Tableau portal and Oracle.
• Used Kerberos for user authentication thru Active directory (Win AD).
• Performance tuning for the Tableau Visualizations and Tableau server for more than 150 concurrent users.
• Improved Reports performance in tableau using extracts and context filters.
• 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.
• Setup security profiles for various user groups and users using Tab admin and Tabcmd Tools.
• 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.
• Good understanding of OSIModel, TCP/IP protocol suite (IP, ARP, TCP, UDP, SMTP, FTP, and TFTP). Used SQL to perform basic database administration.
• Strong knowledge on Java, PHP, JavaScript, JQuery, HTML, CSS, Bootstrap, JSON, XML.

TECHNICAL SKILLS

DevOps Tools: Data Connectivity, Automation, Data science Integration, embedded analytics

Build Tools: Maven, Ant

Application Servers: Web Logic 9.x, 10.x, Apache Tomcat 5.x/7.x, JBoss 4.22. GA Web Sphere 6.x/7.x/8.x

Tableau Desktop, Server: 10.4/10.3/10.1/9.3/9.2/9.1/8.0

Database System: MS SQL Server, MySQL, PL/SQL, Oracle 9i/10g, IBM DB2

Tableau: Tableau Cloud, Tableau Reader, Tableau Public, Tableau Mobile

Networking/protocol: DNS, DHCP, TCP/IP, NIS, NFS, SMTP, LAN, FTP/TFTP

Scripting: Perl, Python, JavaScript, Ruby, Bash shell, Power shell scripting

Virtualization Technologies: VMWare ESXi, Windows Hyper-V, Power VM, Virtual box, Citrix Xen

Cloud Environments: AWS, Azure

Monitoring Tools: Tableau, CloudWatch, Splunk

Programming Languages: C,C++, Java, Python, Ruby

Web Programming: PHP, HTML, Javascript, JQuery, CSS, AJAX

Operating system: Redhat Linux 6.x/7.x, Ubuntu, CentOS, Solaris, Windows

Volume manager: VERITAS volume manager, LVM with Linux

PROFESSIONAL EXPERIENCE

Sr. Tableau Admin/ Developer

Confidential, Dallas, TX

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 9.3 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Hands on experience with Tableau 10.4
• Used the multiple data sources joins in Tableau 10.0
• 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 and embedded them into portal.
• Setup trusted authenticationinTableau serverand pass requests fromWeb server
• Importing the data in Splunk through inputs’.
• Installation, configuration and administration of Continuous Integration tool Jenkins and integrated with GERRIT.
• Unlock the insights in your machine-generated Splunk data
• 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 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.
• Connect to Data pane, scroll to the bottom and, under On a Server, click Other Databases (ODBC).
• 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 performance 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

Environment: - Tableau Server 10.4, Tableau Desktop 9/7,MS SQL Server 2008,Oracle 10g, SQL BI Suite (SSIS, SSRS, SSAS, Visual Studio 2010, Windows.

Tableau Developer

Confidential, PA

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 9.3 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.
• Hands on experience with Tableau 10.0
• Used the multiple data sources joins in Tableau 10.0
• Build from the ground up reliable infrastructure services inAWSto deliver highly scalable services.
• Configure the VPC, EC2 instances, S3 buckets, RDS (MySQL)
• Configuration ofAWSin built SNS/SQS setup for job scheduling
• Create required shell or python scripts for data push from Tableau/Teradata to S3
• Provide the user access to team forAWSconsole and SSH connectivity to the Edgenode
• Used Tableau to provide the standard user interfaces for visualizing and filtering date/time data, and Hive will construct the Map/Reduce jobs necessary to parse the string data as date/time to satisfy the queries Tableau generates.
• Used Hive to have native support for date/time as a data type, but it does have very rich support for operating on date/time data stored within strings, changed the data type of a string field to Date or Date/Time to work with pure date or date/time data stored in strings.
• Used Tableau to provide the standard user interfaces for visualizing and filtering date/time data, and Hive will construct the Map/Reduce jobs necessary to parse the string data as date/time to satisfy the queries Tableau generates.
• Used Hive and Hadoop configuration variables for a given connection from Tableau to tune performance characteristics
• Used additional UDFs which Tableau does not yet expose as formulas for use in calculated fields in HIVE.
• Used Tableau "Pass Through" functions for using UDFs, UDAFs (for aggregation) and arbitrary SQL expressions in the SELECT list
• 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.
• Published Tableau dashboard on Tableau Server and embedded them into portal.
• Setup trusted authenticationinTableau serverand pass requests fromWeb server
• Worked heavily usingTabadmin toolsandTableau Cmdfor setting upsecurity profiles for various User groups and Users.
• 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.
• Used Tableau and Google Analytics to analyze web traffic and make business decisions on the traffic coming from different locations.
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created parameters and quick filters.
• Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau 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.

Environment: - Tableau Desktop 9.3, Tableau Server 8.0, Microsoft Office 2007, SQL Server 2008, PL/SQL, T-SQL

Tableau Developer

Confidential, NC

Responsibilities:

• 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.
• Used data connectors that are already available in Tableau, to create web data connector (WDC) that reads data from virtually any site that publishes data in JSON, XML, or HTML.
• Used Tableau and Google Analytics to analyze web traffic and make business decisions on the traffic coming from different locations.
• Used the Tableau Web Data Connector Javascript library to connect to the Google Analytics data without having pitfalls going directly with the GA connector
• Used Tableau web data connector to create gets stock price data from the Yahoo site.
• Used the Yahoo provided REST API that send queries for financial data.
• The connector then gets the closing price for the specified company for one year back from today's date.
• Used the Web Data Connector JavaScript library for enabling the app to interface with the Tableau API
• Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.
• Created parameters and quick filters. Created sets to display top products based on their sale.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Created Dashboards with interactive views, trends and drill downs.
• Published Workbooks and Dashboards to the Tableau server.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Created groups and users in Tableau server
• Used commands in Tab cmd. and Tab admin utility tool and migrated Workbooks and Dashboards

Environment: Oracle 11g, Python, Chef, Puppet, Kickstart, Cron, Perl, Tableau Desktop 8.2, Tableau server, Oracle SQL developer, SQL Server 2012, Oracle 10g, PL/SQL, T-SQL,MS Access, Windows 2007 server, Teradata, MS Office 2007

Tableau Admin

Confidential, Charlotte, NC

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 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, cross-tabs, slice and dice and drill mode as per the requirement of the end-uses
• Work experience in advanced Xcelsius concepts like, what if analysis, dynamic visibility, narratives, interactive charts, hierarchies and experience in connecting Xcelsius/ QaaWS, live office
• 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 Server 8.3, Tableau Desktop 8/7,MS SQL Server 2008,Oracle 10g, SQL BI Suite (SSIS, SSRS, SSAS, Visual Studio 2010, Windows. Cloud Watch, Cloud Formation Unix/Linux, Bash Shell script, Python, Chef, Apache Tomcat, MongoDB, Oracle DB.

Data analyst

Confidential

Responsibilities:

• Installed and configured Oracle 10g/11g RAC databases as per company standards.
• Installation, Configuration, upgradation and administration of Sun Solaris, Linux.
• Implemented and managed Oracle 10g RAC and 11g RAC databases on UNIX, LINUX and Windows platforms.
• Manipulating, cleansing & processing data using Excel, Access and SQL. Responsible for loading, extracting and validation of client data.
• Liaising with end-users and 3rd party suppliers.
• Analyzing raw data, drawing conclusions & developing recommendations Writing T-SQL scripts to manipulate data for data loads and extracts.
• Developing data analytical databases from complex financial source data. Performing daily system checks.
• Data entry, data auditing, creating data reports & monitoring all data for accuracy. Designing, developing and implementing new functionality.
• Monitoring the automated loading processes.
• Advising on the suitability of methodologies and suggesting improvements. Carrying out specified data processing and statistical techniques.
• Supplying qualitative and quantitative data to colleagues & clients.
• Using Informatica & SAS to extract, transform & load source data from transaction systems.

Environment: ToolsandTableau for setting upsecurity profiles for various User groups and Users, Data tracking, sql, monitoring, sas.

System Administrator

Confidential

Responsibilities:

• Maintained History of all the repositories using Subversion.
• Used Clear case (Base) as version control to store source code.
• Helped developers to resolve subversion code merging issues.
• Involved in creating new elements in vobs.
• Responsible for designing and deploying best SCM processes and procedures.
• Used ANT as build automation tool for Java based projects.
• Build and release software baselines, code merges, branch and label creation and interfaced between development and infrastructure.
• Good Quality release notes. Implemented sustainable branching models for organizations.
• Performed regular builds and deployment of the packages for testing in different Environments.
• Production Support & Systems engineering duties related to Red hat system administration DNS, DHCP, NFS, NIS, LDAP, user account maintenance, backup & recovery, Auto-mounting, License Management, Printer configuration.
• Following up with the Test Team & Development Team to resolve the build issue. Documented the policies and procedures for branching, labeling, code merging, checkin/check-out, and builds.
• Deployed artifacts to WebSphere application servers.
• Installing and configuring Apache Tomcat and supporting them on Linuxproduction servers.
• Troubleshooting the network issues and response problems.
• Installation and configuration of Logical volume manager-LVM and Netbackup.
• Experience with Nagios Network management and System monitoring tool.
• Documentation of all the setup procedures and System Related Policies (SOP's).
• Experience in configuring DNS, NFS, NTP, FTP on Linux servers.
• Worked in the Java development team, assisting in coding using core java programming and MS SQL Server.

Environment: Kickstart, Cron, Solaris, RedHat, Tomcat, Java, LVM, Nagios, Oracle Virtual box, VMware, SSH, RHEL, FTP, SCP, WinSCP, Subversion, Clear Case, Red hat Linux, ANT, Web sphere, Shell Scripts, Clear Quest.