Candidates About

 

Trilok K

Professional Summary:

 

·         8 + years of total IT experience in Analysis, design, development and Implementation of Business Intelligence solutions using Data Warehouse/ Data Mart Design, BI Solutions, OLAP, Client/Server and Web applications on Window and Unix platforms.

·         Designed, developed, deployed and supported ETL to load data into Data Warehouse from PostgreSQL Server.

·         Developed custom data verification process applied to the raw data, identifying data issues, fixing them wherever possible and/or moving data into error tables for future analysis.

·         6+ years of experience in Tableau Desktop, Tableau Server, Tableau online.

·         Involved in Requirements gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.

·         End to end experience in designing and deploying data visualizations using Tableau.

·         Expert in gathering external data to Tableau from different sources like Oracle, SQL Server & flat files etc., for data visualization.

·         Worked on Power BI and prepared dashboards using Tableau to make it more attractive.

·         Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.

·         Knowledge in Developing Power BI Reports and Dashboards from multiple data sources using Data Blending.

·         Experience in installing/upgrading the Cognos servers from Version 6.0 to EP series version 7.0 MR1, MR2 and Cognos 8.X, in Unix, Solaris and windows environments,

·         Extensively used Report Studio, Query Studio, Event Studio, Analysis Studio for Report design in Cognos BI version 8.x

•  Sound knowledge of relational database concepts and writing customized SQL/TSQL queries.

•  Strong knowledge on Other BI Tools like (SAP BO, PowerBI, Alteryx)

·         Specialized in creating complex query reports using Oracle, SQL Server, SAP HANA, MS Access, local files, and various RDBMS.

·         Expert in generating on-demand and scheduled reports for business analysis or management decision using Tableau and Power BI.

·         Experience in administration activities like creating and managing repositories, monitoring/granting permissions and rights to users, user groups through Central Management Server. 

•      Consolidating data from different sources like DB2, SQL Server & Oracle for data manipulation and

     data cleansing purpose using SAS Data Integration Studio 4.2 and SAS Enterprise Guide.

·         Wrote and executed various MySQL database queries using R, Python MySQL connector and MySQL DB package.

·         Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.

·         Skilled at building and deploying multi-valued parameterized reports using Power Bi, Tableau.

·         Have good understanding of Tableau architecture, design, development and end user experience.

·         Worked extensively with Advance analysis like Actions, Calculations, Parameters, and Background images, Maps, Trend Lines and Statistics.

·         Was actively involved in the Server migration and the Fresh Tableau Server Installation process.

·         Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau desktop.

·         Used REST API with Tableau Server to manage and change tableau server resources.

·         Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).

·         Good knowledge of System Development Life Cycle (SDLC), Agile and Waterfall development environments.

 

 

Technical Skills:

 

BI Tools	Tableau Suite of Tools 10.1/9.x/8.x/7.x which includes Tableau Desktop, online and Public. TableauServer10.0/9.3/9.2/8.3, SAS, SAP Business Objectives 4.x/3.x. Power BI, Cognos, Alteryx.
Databases	Oracle 11g/10g/9i, MS Sql Server 2008/2005, T-SQL, MS Access, DB2, HANA.
Environment	Windows, Unix, Linux.

 

 

Professional Experience:

 

Novantas Inc, NYC

Tableau Consultant                                                                                                                              June 2017 – Till Date

 

Worked closely with Client Services/Finance/Fraud & Risk team to gather requirements for designing Tableau Reports.

 

Responsibilities:

 

·         Restricted data for particular users using Row level security and User filters.

·         Developed Price Benchmark Regression curves using the client financial data.

·         Synchronized version control – especially with respect to PDF vs. Tableau reports.

·         Modify reports to use the user specified variance for conditional formatting.

·         Developed Audit reports based on the clients logins and download PDF reports in the portal.

·         Developed ECR calculations and benchmark regression power trend line curves.

·         Gone through all the calculations used in Tableau reports and moved them to the Database.

·         Worked under SQL Server stored procedures and big data environments.

·         Worked on homegrown analytic SAAS solutions which are most widely installed in the industry.

·         Administered projects, user, groups, permission and scheduled instances for reports in Tableau Server.

·         Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains. 

·         Analyzed and resolved performance and server based issues. Prepared backups using Tabadmin and Tabcmd commands.

·         Formulated procedures for installation and configuration of Tableau desktop.

·         Performed advanced Tableau server management tasks including clustering, load balancing etc.

·         Extensive used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

·         Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

·         Created metadata model and packages by using Framework Manager and published those packages into Cognos Connection.

·         Interacted with customer to get various business needs, resolve issues and develop appropriate solutions.

·         Optimized package and applied right joins.

·         Created List, Cross Tab, Chart Reports using Report studio for end users analysis.

·         Created cascading prompts and worked with various prompt controls such as Value Prompt, Tree Prompt, Date and Time Prompt.

·         Worked with the join functionality to create various reports.

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

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

·         Highly experienced in end-to-end dashboard automation using Tableau, SQL and Alteryx by gathering  data from different sources like SQL (databases), Excel (or any other file format from shared drive) and Alteryx.

·         Worked with Alteryx and Tableau Scheduler to provide end-to-end automation. Scheduled (monthly) Tableau Data Extract (.tde) refreshes and auto publishing of Workbooks and Dashboards to TableauServer 

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

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

·         Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI’s.

·         Created customized and interactive dashboards using multiple data sources using Tableau; Good hold over SQL databases and using SQL queries within Tableau and Alteryx.

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

Environment: Tableau Server 10.3/9.3, Tableau Desktop 10.3/10.3.4 and 10.5, Cognos, Windows Server Standard R2,T-SQL, Power BI 2013, Excel, SQL Server management studio, MS SQL Server 2012.

 

 

ISO, Jersey City, NJ                                                                                                                               Feb 2015 – June 2017

Sr. Tableau Consultant

 

Developed complex Tableau Visualizations. Participated in requirement gathering. Extensively used parameters, Calculated fields, Sets, Action Filters in the Report Development. Setting up Tableau Server with SAML configuration.

 

Responsibilities:                                                                                                                                                                             

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

·         Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

·         Connected to Tableau PostgreSQL database to create customized interface for Tableau workbooks to provide native intranet style navigation.

·         Utilized the Extract API in Tableau 9.3 to create dynamic Tableau data extracts using R, Python programming.

·         Performed data profiling, data Cleansing and data Analysis using complex SQL on various sources systems including Oracle.

·         Involved with dataprofiling for multiple sources and answered complex business questions by providing data to business users.

·         Maintained and managed Tableau and Power BI driven reports and dashboards. 

·         Created few Tableau data extracts using R language, Python programming and Extract API within Tableau9.3.

·         Actively involved in the Server migration and the Fresh Tableau Server Installation Process. 

·         Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau desktop.

•    Administered user, user groups, and scheduled instances for reports in Tableau by controlling the access      of resources  

   to intended user. 

·         Strong Experience in SQL Performance tuning with Code optimization, Indexing, Execution Plan Analysis.

•  Displayed changes of annual usage trend and annual productions from Year to Year with   

R and Tableau.

·         Designed and developed the reports according to the requirements using Tableau and Power Map.

·         Defined best practices for Tableau report development.

·         Created various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar  Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet

·         Graphs and Histograms in Table Desktop, Power BI and Excel to provide better data visualization.

·         Extensive experience in Tableau Interactive Dashboards, Tableau suite.

·         Provided support for Tableau developed objects and understand tool administration.

·         Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.

·         Manage Production, Test, Development environments and security administration and access controls in Tableau.

·         Designed and implemented SSO security model giving access to users from main application to Tableau using Tableau API calls.

·         Consulted on Tableau server performance enhancements; upgrades from version 9.3 to 10.3 and server reconfiguration based on workbook complexity and data extraction

 

Environment: Tableau Server 10.3, Tableau Desktop 10.3.5/10.4/10.5, Windows Server Standard R2,T-SQL, Excel, SQL Server management studio, MS SQL Server 2012.

 

 

 

AT&T, Tampa, FL                                                                                                                                     Dec 2012 – Feb 2015

Tableau Server Administrator

 

Gathered requirements from Business Users and prepared Technical Design Document. Prepared Tableau wireframes for the business. Used Custom SQL for the Tableau Data source.

 

Responsibilities:

·         Responsible for Designing the Reports as per client Requirements and translated them to technical specifications.

·         Involved in the migration of content from old Tableau server to new Server.

·         Created Groups, hierarchies, and Sets to create detail level summary reports and dashboards using KPI's.

·         Published and shared views on Tableau server. Scheduled extract refresh and subscriptions.

·         Also involved in administration tasks such as creating and managing Sites, Setting permissions, managing ownerships and providing access to the users using user filters and adding them to the specific group.

·         Deployed Tableau Dashboards and worksheets in clustered environment using Google Analytics.

·         Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.

·         Developed working documents to support findings and assign specific tasks.

·         Developed Tableau data visualization using Pareto's, Combo charts, Box and Whisker charts, Geographic Map, Cross tabs, Histograms etc.

·         Developed donut charts for analyzing sales planning data.

·         Created different KPI's using Table calculations and calculated key figures Manipulating's strings, arithmetic calculations, aggregation options and Logical functions

 

Environment: Tableau Desktop 8.3/7.0.11, Tableau server, SQL developer, SQL Server 2012 2008, Oracle11g/12c, Hive, NoSQL, Microsoft Excel 2012, Microsoft office suite.

 

 

Blue Cross Blue Shield, NJ                                                                                                                    Jan 2011 - Dec 2012

Role: Tableau Developer

                                                                                                                                                                                                               

Developed Complex cross tab Reports. Used advance charts like Dual Axis charts, Donut Charts, Bullet Graphs, Histograms in Data Visualizations.

 

Responsibilities:

·         Created dashboards for analyzing data using Tableau 8.0.

·         Consistently attended meetings with the client subject matter experts to acquire functional business requirements.

·         Developed case studies to understand new product launch, promotion effectiveness, trend detections, Seasonal forecasting.

·         Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.

·         Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets.

·         Created Custom Function's Date range, Time functions, array functions, and Conditional formatting functions in the reports.

·         Scheduled extract refresh for weekly and monthly reports.

·         Worked on workbook Permissions, Ownerships and User filters.

 

Environment:Tableau Desktop 7.0.3, SQL Server 2008.

 

 

 

Sonata Software – Hyderabad, India