PROFESSIONAL SUMMARY:

• Holding 8+ years of IT experience with 6+ years of experience in Tableau tool.
• Expertise on Tableau Desktop to analyze and obtain insights into large data sets.
• Created visually compelling and actionable interactive reports and dashboards
• Evaluated bug fixes and identified the changes from 10.3 to 10.4 and digested the customer accordingly.
• Identify production faults and critical issues followed and troubleshoot them.
• Worked on Tableau versions 10.4/10.3/10.2/ 10.1/9.2/9.1 /8.0.
• Worked on Hyper version of 10.5 & 2018.1
• Possess good knowledge in Tableau Prep (Combining, transforming, and cleaning data).
• Having good amount of knowledge in Healthcare and finance domain.
• 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 visualization techniques.
• 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.
• Visualized Hadoop data by connecting to Hive server or Hiveserver2 using Tableau.
• Used ODBC drivers to connect to Apache Hive directly from Tableau and integrated Tableau with Hadoop Cloudera Hive server using cloudera provided ODBC drivers.
• Removed the need for users to have advanced knowledge of query languages by providing clean visual analysis interface that makes working with big data more manageable for more stakeholders.
• Used Tableau’s flexibility to build a tabbed application with wide range of options like quick filters, calculated fields, LODs, dynamic interaction, flexible ad-hoc capability in various functional areas like Health & life science, finance.
• Setup and configuration of Tableau server 10.1/9.2/9.1 in various environments, used Tableau CMD and Tableau admin tools to configure the server per 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.
• Experienced in writing queries, stored procedures and functions using SQL.
• Designed and setup user security for the entire landscape to facilitate Windows AD login and used Tableau CMD for various Dashboard migrations from one environment to another.
• Setup of Distributed Server environments for optimum load balancing and used efficient load balancing techniques to manage the load on the server for concurrent user logins.
• Created automated scripts for tableau workbook refresh when not using live connections and 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.
• Analyzing web traffic and creating google analytic dashboards to visualize the web traffic interactively and Setup of SSO between Tableau portal and Oracle.
• Performance tuning for the Tableau Visualizations and Tableau server using blending techniques and Optimize the VizQL server processes to handle loading and rendering views for Tableau Server.
• Organized dashboards in Tableau to analyze the data over various attributes of the user, project, time and location dimension to perform YOY, QOQ, YTD, QTD and MTD type of analysis.
• Proficient in R Programming Language, Data extraction, Data cleaning, Data Loading, Data Transformation, Predictive Modeling and data visualization using R and Tableau.
• Possess good knowledge in downloading packages, extracting data in R studio & Cran R.
• Have good knowledge in Forecasting and showing Trend Lines in tableau to predict future business needs.
• Expertise in building visualization using Power BI, Power View, Power Query.
• Worked with SSAS, building cubes and writing MDX queries.
• Connected Tableau directly to Hortonworks Data Platform through Hive interface so that business users can quickly find insight with Hadoop deployment.
• Worked on creating Ad Hoc parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS.
• Used SSRS for visualization and report writing. Utilized SSRS, SSAS, SSIS and MS Excel for reports and analysis.
• For the project management, we used tools such as JIRA interface and the project was managed by the AGILE SCRUM technique.
• SDLC expertise with both Waterfall and Iterative Methodologies like Agile.

SOFT SKILLS:

• Improving operational efficiency
• Detecting and responding to business change
• Identifying business opportunities
• Measuring and monitoring productivity
• Increasing internal and external regulation compliance
• Tracking of all project goals, tasks and resources
• Status reporting
• Negotiations
• Interactions
• Research and analysis
• Presentation/ demo

STRENGTHS:

• Communication
• Working in teams and independently as required
• Status reporting
• Onshore-off shore models
• Meet deadlines
• Flexibility
• Self starter
• Problem solving skills

TECHNICAL SKILLS:

• Tableau Desktop …, Tableau Server …, Tableau Prep, Tableau cloud, Tableau Public, Tableau Mobile, Tableau Reader.
• SSRS, SSIS, SSAS.
• Power BI, HANA, QlikView, Cognos Analytics 11
• Oracle 9i/ 8i/7.3, MS SQL Server …, Access, DB2, Teradata, AWS Redshift.
• Hadoop, Hive, YARN, Impala, Sqoop, flume, pig, Spark.
• Windows, UNIX, LINUX, MAC OS, Apache/Tomcat.
• ASP.NET, SQL, PL/SQL
• Oracle, SQL, Erwin
• Salesforce
• JIRA
• Scrum, Agile, Waterfall.
• SDLC fundamentals.
• Cran R, R studio
• Informatica
• Power Query
• Knime Analytics
• XIR 2/10.0/9.0/8.0 , Universe Designer, Xcelsius 2008/4.5
• 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,
• SAP - BI, BW, SAP BOBJ 4.0/3.1

PROFESSIONAL EXPERIENCE:

Confidential, LISLE, IL

TABLEAU DEVELOPER/ADMIN

Responsibilities:

• Worked on developing report named ‘ Confidential ’ to analyze down hours and days of trucks which consists of two different companies, International and Peterbilt.
• Also analyzed total down hours, average down hours, down hours by model, down hours by model year, plotted outliers and showing top 5 trucks by down hours and down days.
• Worked on building report named ‘ Confidential ’, duty is to calculate average time between each step of the repair sequence. Starting with the fault fired from the truck, opening case manually, truck in-zone, dealer operations, out-zone and case closed.
• Worked on building ‘ Confidential ’ report for one of our customer called Cowan. Calculated Average Confidential, count of trucks that are below & above the average Confidential, minimum & maximum Confidential and reported about better performed trucks for both International and Peterbilt.
• Further jumped into more granular level on Confidential report showed International vs Peterbilt trend and their year and model wise Average Confidential Trend, metrics of Confidential .
• Worked on building ‘Uptime Dashboard’ report for one our customer named Hirsbach. Replicated same as ‘ Confidential ’ report, which consists of five different types of trucks.
• Worked on building ‘DIA Parts’ report, which shows number of parts at each dealer in-stock, number of claims approaching each dealer, percentage of claimed parts to parts in stock, metrics of parts available on truck arrival at dealer.
• Worked on creating ‘Dealers & Repair Cases’, which shows total number of cases received by each dealer, and their escalation time and pending cases at each dealer.
• Assisted lead in maintaining Tableau Server.
• Designing, developing, testing and deploying solutions using tableau dashboards.
• Researching industrial management data and design solutions that provide high performance visuals in Tableau.
• Developing and implementing interactive analytic reports and dashboards.
• Working with business users to establish reporting and analytic requirements.
• Providing technical and business knowledge support to the team.
• Participating in defining best practices around report development, testing, access management, and report refresh scheduling.

Confidential, TX

TABLEAU DEVELOPER/ADMIN

Responsibilities:

• Created dashboards to compare gene sequence from multiple patients which helped management to analyze new trends, and take suitable decisions on trials.
• Created Health indicator dashboards that helped the management gauge the health of the R&D business unit and enables them to consistently drive innovation.
• Implemented Health Privacy (HIPAA/HITECH) processes including data protection and auditability.
• Delivered timely and accurate manufacturer reports, clinical reports, and data exchange with internal and external business partners.
• Collaborated with both technical and business stakeholders to understand reporting and data requirements based on customer and internal needs.
• Assisted with creation of reporting business requirements, technical design, testing and maintenance processes.
• Maintained all documentation required for the change control and testing processes.
• Responsible for identification and analysis of errors/inconsistencies in the data and provided timely resolutions.
• Configured Tableau Server in AWS EC2 instances.
• Configured tableau server for subscriptions enabling business to receive dashboards periodically.
• Connected to the AWS Redshift directly from Tableau to access cloud data warehouse and quickly perform visual analysis.
• Worked with larger data sets and heavy Tableau extract usage environment.
• Created Complex workbooks and Dashboards by connecting to multiple data source using data blending.
• Preparing Dashboards using calculations, parameters in Tableau and Developing Tableau reports that provide clear visualizations of various industry-specific KPIs.
• Migrated existing reports from Share-point\excel to Tableau Server by recreating them in batches.
• Managed the migration of fixed income data mart from oracle to Tera data.

Confidential, OH

TABLEAU DEVELOPER/ADMIN

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.1 in various environments and used Tableau CMD and Tableau admin tools to configure the server per 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.
• Setup trusted authentication in Tableau server and pass requests from Web server
• Worked heavily using Tab-admin tools and Tableau Cmd for setting up security profiles for various User groups and Users.
• 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.
• Worked on creating schemas and connecting tableau to AWS Redshift and Hive.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Creating New Schedule's and checking the task's daily on the server.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, Log Axes, Groups, and hierarchies, sets to create detail level summary report and dashboard using KPI's.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Connected to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Identified opportunities to develop forecasts, statistical models, segmentation schemes, and data-driven analyses to drive marketing and merchandising efforts around customer acquisition and conversion.
• Managed the migration of fixed income data mart from oracle to Teradata.
• Partnered with the Technology teams to deliver a stable and highly available reporting platform.
• Planned and implemented the overall analytics and business intelligence strategy.

Confidential, VA

TABLEAU DEVELOPER/ADMIN

Responsibilities:

• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Setup and configuration of Tableau server 9.1 in various environments and used Tableau CMD and Tableau admin tools to configure the server per best practices.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• 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.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Connected to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Handled user licenses for projects.
• Importing tables using Warehouse catalog and Creating Logical Tables.
• Provided support to consultants, Technical Support engineers in creating and troubleshooting Micro strategy SDK customizations.
• Used Administrator tools like Project Merge and object Manager to move the objects from one environment to another environment.

Confidential, NJ

TABLEAU DEVELOPER

Responsibilities:

• Understand Requirement, Analyzing Systems and Source Databases.
• 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 Quicktable calculations.
• Representing data using the visualizations such using Charts.
• Development of back-end (Oracle) to fulfill the UI requirement.
• Used Trend Lines, Reference Lines and statistical techniques to describe the data.
• Used Measure name and Measure Value fields to create visualizations with multiple measures and dimensions.
• Responsible for dashboard design, look and feel and development.
• Used parameters and input controls to give users control over certain values.
• Combined data sources by joining multiple tables and using data blending.
• Understanding the functional and technical specification.
• Deep experience with the design and development of Tableau visualization solutions.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Regular involving in calls with customer and discussing about status and new requirements of the project.
• Preparing Dashboards using calculations, parameters in Tableau.

Confidential, MD

TABLEAU DEVELOPER/ADMIN

Responsibilities:

• Worked heavily using Tab-admin tools and Tableau Cmd for setting up security profiles for various User groups and Users.
• Check internal and external customer’s need and abilities to provide appropriate solutions.
• Design the dashboard application with multiple dashboards as required as per the security requirements.
• Developed the web-intelligence reports, provided a supporting role in building the universes
• 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.
• Perform analysis for a wide range of requests using data in different formats and form various platforms.

Confidential, MO

SAP BI/BO CONSULTANT

Responsibilities:

• Interacted with the Business Users to analyze the business process and gathered the requirements.
• Designed functional and Technical specifications for Implementation and Development of BO XI 3.1 over SAP BI.
• Extensively worked on SD info cube 0SD C03 and data sources 2LIS 13 VDHDR, 2LIS 13 VDITM, 2LIS 13 VCITM and financial data providers, multi provider's 0FIAP M40 data sources 0FI GL 40 according business needs in SAP BI.
• Involved in development, integration testing, UAT to Go live production support of OTC, RTR, APO reports.
• Created new info providers in SAP BI depending upon the end user needs.
• Extensively worked on BEx reporting and workbooks.
• Extensively worked on RRI, cell definitions, variable offsets, exemptions, conditions, RKF's and CKF's.
• Extensively worked on Central Management Console (CMC) in configuring Bo environment.
• Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
• Successfully implemented transports of BOBJ in SAP BI environment.
• Created (Master/Detail, Cross tab, Chart templates) reports using Crystal Reports.
• Worked on Hierarchy Levels and Developed hierarchies to support drill down reports.
• Extensive experience in creating reports with Charts (bar chart, Pie chart etc.), Cross-tabs and Sub reports.
• Extensively worked on SAP Life Cycle Manager (LCM), transported objects from one environment to another using this brand-new tool.
• Transferred objects from Development to Quality and to production using SAP LCM, including security rights.

Confidential

REPORTING ANALYST

Responsibilities:

• Used Report level joins and unions in some of the reports, created prompts and calculations in RS and FM model.
• Validated the schema and found the errors present in the ETL and took part in giving the recommendations to fix the problem.
• Modified existing Universes to meet user reporting requirements.
• Interacted with Business Objects technical team to solve the bugs involved in Business Objects.
• Met with the Business Analyst, Users and Business leads to understand their needs. Modified universes and created reports for them accordingly.
• Experience with Data Extraction and transforming data from using Data Integrator.
• Provided technical leadership for Business Intelligence (BI) roadmap and the direction of application projects from data capture through application design & implementation.
• Implemented the best practices for Business Objects Environment.