Sai G

ac4f5h@r.postjobfree.com

+*(***) *** - ****

Professional Summary:

* + 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.

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

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

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.

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

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.

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 June 2016 – Till Date

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

Responsiblities:

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 are the most widely installed in the industry.

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

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.

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

Created different KPI using calculated key figures and parameters.

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

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, Python, Windows Server Standard R2,T-SQL, Power BI 2013, Excel, SQL Server management studio, MS SQL Server 2012.

ISO, Jersey City, NJ Dec 2014 – June 2016

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 data profiling 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 Tableau 9.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.

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

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.

Blue Cross Blue Shield, NJ Jan 2013 - Dec 2014

Role: Tableau Site Admin

Responsibilities:

Created and updated server architecture for scheduling tasks.

Created various User groups by assigning row and column level security at application level, folder level and user level.

Published Workbooks by creating User filters and sites (User groups, access) so that only appropriate teams can view it.

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

Used the Tableau Online sync application to schedule automatic refresh tasks for extracts of data and to maintain on local network.

Analyzed and resolved performance and server based issues.

Prepared backups using Tabadmin and Tabcmd commands.

Formulated procedures for installation and configuration of Tableau desktop.

Designed and developed SSIS packages for Tableau dashboards.

Utilized data blending activities for Tableau functionalities.

Participated in performance tracking activity by evaluating server tasks.

Modified data visualization dashboards and developed data connections

Environment: Tableau Server 7.0.3, SQL Server 2008.

Karvy Analytics, India July 2011 –Oct 2012

Business Objects Consultant

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

Full life cycle implementation of BW that includes Data Modeling, Data Extraction, Data transformation, Data loading(Full/Delta upload), Scheduling jobs, Monitoring data loads, production support, troubleshooting and reporting

Responsibility for data modeling in the data warehousing effort of the Sales and Distribution, and Master data (Customer and Material Master) for the SAP BW

Worked extensively on standard and custom defined LO and LIS extractors. Used LO extract structures and data sources in sales material management to facilitate the data extraction to BW

Performed various tuning techniques (aggregates, statistics, partitioning and multi-providers, OLAP Cache) to optimize the query performance

Used ABAP Routines (Start Routines, Update Routines) in Update rules and Transfer Rules to Update Key Figures in the Info Cubes

Performed detailed analysis to improve the Performance of Cubes using BW Statistics, Aggregates and Involved in Production Support

Heavy Technical concentration in designing InfoPackages, InfoSources, Update Rules, Reports for Sales and Distribution

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.

Sonata Software – Hyderabad, India May 2010 – July 2011

Role: SQL Developer

Responsibilities:

Managed database objects like stored procedures, views, tables etc.

Optimized queries that were taking long time to display desired result set.

Created groups, roles, users and assigning access privileges to users.

Created new stored procedures and modifying existing ones as per business requirements.

Created various types of reports such as sub reports, parameterized, Tablix and Matrix using SQL Server Reporting Services.

Performed data analysis to generate various trend reports.

Performed identification, analysis and resolved report defects within time scope and established development guidelines.

Environment: SQL Server 2005, SQL Server Management Studio, SQL Server Reporting Services (SSRS).

Contact this candidate