Candidates About

 

Nikhilesh Kumar 

PROFESSIONAL SUMMARY

Ø  Extensive Experience in Tableau Desktop and Tableau Server in various versions of Tableau 7.0, 8.0, 8.1,8.2,9.3,10 as a Developer and Administrator. 

Ø  Deep experience with design and development of complex Tableau visualization solutions. 

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

Ø  Created business driven dashboards using different chart types like Crosstab's, Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Gantt charts, Bubble charts, Scatter Plots, Trend lines, Bullets, Bullet Graphs, Highlight tables and Histograms in Tableau Desktop. 

Ø  Proficient in design and development of various Dashboards, Reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, Geographic's and other making use of actions, local and global filters according to the end user requirements. 

Ø  Experience in Enterprise Environment and experience including technical support, troubleshooting, report design and monitoring of system usage. 

Ø  Experience in Installation, Configuration and Administration of Tableau Server in a multi-server and multi-tier environment. 

Ø  Good Knowledge in relational/multidimensional databases and data modeling for OLAP/ROLAP. 

Ø  Good experience in Migration of Reports and Packages. 

Ø  Proficient in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards. 

Ø  Deployed Tableau server in clustered environment by adding worker machines. 

Ø  In-depth knowledge on SQL queries and working with Oracle 11G/8i, PL/SQL, SQL Server, MySQL. 

Ø  Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), MS Access and client/server applications. 

Ø  Extensive technical knowledge and work experience in SQL & PL/SQL with Oracle. 

Ø  Very Good Understanding and Experienced in Informatica Powercenter 8.6.1 and   

above. 

Ø  Good interaction with clients, understanding Business Applications, Business Data   

Flow and Data Relations.

Ø  Experience in extensively coordinating across all phases of SDLC applications mainly in Data Warehousing (Informatica Power Center, Informatica Power Mart), Oracle (SQL, PL/SQL). 

Ø  Extensively worked on Informatica Designer Tools (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer) and Workflow Manager Tools (Task Developer, Worklet and Workflow Designer). 

Ø  Experience in importing and exporting data from existing databases that provide SQL interfaces using Big Data Hadoop Sqoop 

Ø  Well versed with Big data Hadoop echo system and web analytics 

Ø  Worked on POC of Qlik view business discovery kit, Alteryx and Tibco Spotfire (6.x/7.0) 

Ø  Developed Slowly Changing Dimension Mappings of type I and type II. 

Ø  Experience in implementing the complex business rules by creating transformations (Expression, Aggregator, Unconnected and Connected Lookups, Router, Rank, Update Strategy) and developing complex Mapplets and Mappings. 

Ø  Excellent skills in retrieving/manipulating data by writing simple/ complex SQL Queries and optimizing SQL. 

Ø  Worked with different source systems like Flat Files, XML and Rational Databases. 

Ø  Experience/Exposure in Fine Tuning of Informatica Mappings, Sessions and workflows.

Ø  Strong interpersonal skills with demonstrable verbal and written communications 

to maintain effective work relationships with all levels of personnel. 

Ø  Strong commitment to organizational work ethics, value based decision-making and managerial skills

 

 

 

TECHNICAL SKILLS

 

BI Tools	Tableau Server6/7/8, Tableau Desktop 6/7/8/9/10, Tableau Online, Tableau Public, Tableau Reader, Informatica Power center 9.5.1, Informatica Power Exchange, Cognos 10, QlikView, OBIEE 10g,11g, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS), TabCM
Database/ERP	MS SQL Server, Oracle, MS Access, OLAP, OLTP, SAP.
Tools and Packages	SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio, MS Office (Word, Excel, PowerPoint), Adobe Acrobat, Visio, JIRA, TOAD.
Languages	SQL, PL/SQL, C, C++, ASP.Net, HTML, XML, XSL, CSS.
Operating Systems	Windows Server, Windows, UNIX, LINUX, Macintosh.
Methodologies	SDLC, Scrum, E-R Modeling, Star Schema, Snowflake Schema.
Specialties	Data Visualization, Business Intelligence (BI), Software Management and Data Collection

 

 

 

 

 

 

 

 

 

EXPERIENCE

 

Tableau Developer

CDPHP, Albany, NY                                                                          (Oct’2016-Jan’2018)

Responsibilities: 
• Oversee the performance of design to develop technical solutions from Analysis  

   documents. 
• 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. 
• Involved in creating views, stored procedures, and custom SQL queries to import data

   from SQL server to Tableau. 
• Created Tableau worksheet which involves Schema Import, Implementing the business

   logic by customization. 
• Created Data Connections, Published on Tableau Server for usage with Operational or

   Monitoring Dashboards. 
• Tableau Logs - Reviewing the Server logs for any errors or security issues that are

   unexpected. 
• Performance Logs - Reviewing the performance metrics to determine if the baseline  

   exceeded or for the slow points during the day that need to be reviewed. 
• Tested reports and uploaded Tableau dashboards on to server and provided production

   support for Tableau users. 
• Created Bullet graphs to determine profit generation by using measures and dimensions

   data from Oracle SQL Server and MS Excel. 
• Worked on Performance tuning of report with huge queries using concurrent query

   execution for better performance of report. 
• Responsible for daily communications to management and internal organizations

   regarding status of all assigned projects and tasks. 
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by

   connecting live/dynamic and static datasets. 
• Developed 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..

×  Perform installation, configuration and administration of the Tableau server and              desktop.

×  Manage application users, groups, Workbooks and Projects, Database Views, Data Sources, Data Connections and integration with Active Directory. 

×  Follow SOPs and administration guidelines for server upgrades, backups, patching, performance tuning, and security and administration of the applications. 

×  Perform administrator duties including publishing reports, creating, modifying, or managing server task schedules, monitoring server activity and usage statistics to identify possible performance issues and enhancements. 

×  Analyzing documentation for policies, procedures and best practices to provide users with Tableau support. 

×  Knowledge of Tableau server licensing mechanism and using command line utility tools (tabadmin and tabcmd) to automate tasks.

×  Identify, gather, prep, and blend data through the use of Alteryx to populate data marts, front-end big data applications, and dashboards.

×  Own the delivery of insight and business intelligence across the business units, developing insights and reporting, making recommendations, and implementing improvements to current business practice.

×  Implement various data modeling, visualization and reporting techniques

×  Creating qvd file, Transformation

×  Create different types of charts for QlikView Dashboard Analysis

×  Implementing set analysis in qlikview

×  Provide input on proposing, evaluating and selecting appropriate design alternatives which meet client requirements and are consistent with client’s current standards and processes.

  Environment: Tableau Desktop 10/9, Tableau Reader, Tableau Public, Tableau Server 10/9,

 Tableau Desktop 8.2 & 9.3, Oracle SQL Server R2, MS Excel, WDC, SQL Server

 2012/2008R2/2008, Alteryx Designer, Alteryx Server 10.5, T-SQL.

 

 

 

 

 

Tableau Developer

DJO GLOBAL, Vista, CA                                                        (May’2014-July’2016)

                                                                       

Responsibilities:

• Developed various dashboards, used Context filters, sets while dealing with huge

   volume of data.

• Created and used Filters, Quick Filters, Table Calculations and Parameters on  

   Tableau reports.

• Creating Sales Growth Dashboard metrics measure the pace at which your

   organization's sales revenue is increasing or decreasing. Current sales revenue: The   

   total dollar value of sales during the current time-period. Previous period sales revenue:  

   The total dollar value of sales during the period.

• Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic

   maps, Line chart, Pie charts.

• Creating the Sales Bookings metric measures the value of bookings over a given time

   period, where a "booking" is a won, signed, or committed sale. Booking: A won, signed, or

   committed sale where the purchase order has been received and approved.

• The Sales Opportunity Dashboard metric organizes prospects based on opportunity   

   value and the probability of closing the sale. Each prospect has an estimated purchase    

   value associated with them to help your team prioritize their efforts.

• Stage: Based on the type of contact your sales team has had with the prospect. Stages

   may Include proposal (sales quote sent and received), qualified, or negotiation.

• Weighted value: A multiplier that is applied to the estimated value of a prospect based on

   the probability of closing the sale.

• Created Sets, Groups and Data Bins as per user requirements.

• The Sales Target Dashboards measures current sales (either dollar value or number of

   wins) and compares that value to a target or past performance. Wins: The number of new

   customers over a certain period. Revenue: Income received through sales activities.

• Calculating the Average Purchase Value KPI measures the average value of each  

   Purchase order your sales team processes. Purchase order: A document used to

   indicate the type of product ordered, number of units, and agreed upon prices and

   Purchase value, Units per transaction.

• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle

   views more efficiently.

• 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 and effectively used data

   blending feature in Tableau.

• The Sales by Contact Method metric measures which contact methods are the most

   successful at generating sales, such as email, telephone, or in person.

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

• Used Trend Lines, Reference Lines and Annotations to describe the data.

• Created Data extracts for better performance and accessing data offline.

• Used parameters and input controls to give users control over certain values.

• Implemented Data blending with multiple data sources on a single worksheet for data

   analysis.

• Created and Published Tableau Dashboards into Tableau Server.

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

• Developed set analysis to provide custom functionality in Tableau application.

• Expertise in creating Hierarchies for proving drill down option for the end user.

 Environment: Desktop OS: Win2000 Professional, Server OS: Windows 2003/2008; MS  

 SQL Server 8.0/2005, XML, Tableau 8.1/8.0, SAP Business Objects 4.1/4.0, IDT, UDT, WEBI

 BI: SAP BW Query Designer, Analyzer.

 

 

Business Analyst(Tableau)

WIPRO Infotech, Hyderabad, AP                                                                (Nov’2009-May’2013)

 

Responsibilities

• Worked on design and development of Tableau visualizations which includes Preparing

   Dashboards using LOD calculations, parameters, groups, sets and hierarchies

• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter

   plots, Gantt, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

• Installation, Configuration and Admin of Tableau Server in a multi-server and multi-tier

   environment.

• Good experience in designing and developing large number of enterprise reports

   (SSRS/Business Objects) using the data from ETL loads, SSAS Cubes and various

   heterogeneous data sources.

• Expert in designing complex reports using Cascading parameters, Drill-Through

   Reports, Parameterized Reports and Report Models and ad hoc reports and deploying

   SRS reports on the portal for user accessibility.

• Involved in various types of testing for the Tableau reports

• Experience in using Change Data Capture for track DML Operation on Database level.

• Experience in developing SSIS Packages to Extract, Transform and Load (ETL)/DTS data

   into the Data warehouse from Heterogeneous data sources such as Oracle, Hadoop,

   DB2, Sybase, Excel and MS Access CSV, Oracle, flat file.

• Developed analytics involving Clinical research data and pharma marketing analysis

• Analytics to measure marketing performance, impact and insights to effective marketing

• Tableau server tasks involving backups, restore and recovery

 Environment: Tableau Desktop 6.1,7.0,8.2 , Tableau Server, Oracle SQL Server R2, MS Excel, WDC, SQL Server 2012/2008R2/2008, Oracle, SQL server Reporting Service, SQL Server Management Studio, MS Excel, T-SQL, Mongo DB Power Designer, .NET.

 

 

UDEMY ONLINE CERTIFICATION

Tableau A-Z: Hands on training for Data Science

Tableau 10: Master Tableau in Data Science

Data Warehouse Concepts: Basic to Advanced concepts

 

EDUCATION

University of Massachusetts Dartmouth, MA                                                                                                2014                                                           

Osmania University, AP, India                                                                                             2010