Satya Peri

Tableau Developer

662-***-**** ac789d@r.postjobfree.com

SUMMARY

Extensive professional experience in Designing, Administration, Data Analysis and Management in the Business Intelligence Data warehousing, Databases and Machine learning

Worked on latest in-memory Analysis, data analysis, data visualization such as Tableau BI 8x/9x/10x Spotfire, SSRS.

Hands-on experience in building Tableau Extracts, Actions, Dashboards, color coding and formatting, designs, proto types and mock up reports, Data mapping documents and reporting.

Experience in creating advanced charts types (viola chart, hexbin chart, calendar chart) visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution.

Experience in aggregating data including roll ups at multiple levels and by date (MOM, YOY etc.,) and configuring reports from different data sources using data blending.

Hands on experience in Installing and configuring tableau server. Expertise in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.

Used Tableau server for publishing the dashboards to server, user management, user security, identity recognition and Content Restriction.

Experience in working with various data sources(meta data) like Sql server, Microsoft Access, SAP BO, text files, PDF, JSON, XML

Expertise in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad-hoc reports using tableau desktop.

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

Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues/tickets.

Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.

Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.

Expertise in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, ETL Design, development, System testing, Implementation and production support.

Extensive testing ETL experience using Informatica 9.1/8.6.1/8.58.1 Power Center/ Power Mart) (Designer, Workflow Manager and Workflow Monitor)

Good Experience in creating Transformations and mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

Well acquainted with Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings.

Expertise in Error Handling and Debugging issues and troubleshoot production environment issues Event Handler, and Custom Logging in Informatica.

Hands on experience in using machine learning techniques like Naïve Bays, SWM, Random forest, PCA using Python and R programming.

Experience in gathering requirements, analysis, migration, Design, Development, Testing and Production rollover of Reporting and Analysis projects.

Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple discipline also conducted several training sessions.

TECHNICAL SKILLS

Analytical Tools

Tableau Desktop/Server (9.0,9.2,10.2,10.5,2018.1), Business objects(4x), SSAS, SSIS, SSRS.

ETL Tools

Informatica, SSIS

Requirements Management

Microsoft Office (Word, PowerPoint Excel)

RDBMS and SQL Tools

Teradata, Microsoft SQL Server (2012,2014,2016), SQL Assistant, SQL Plus, data services, Microsoft Access, SQL developer

Languages

C, C++, SQL, T-SQL, PL/SQL, R, Python,

Methodologies

Kimball/Inmon, OLAP, Waterfall, Agile

Operating System

Windows family, Unix, Linux

Other tools

Visual Studio, Automation Anywhere, HPQC

EXPERIENCE

Data Visualization Consultant

Trinity Health, Livonia Michigan August 2018 – Present

Responsibilities

Developed automated WTD, YTD, FY reports that helped users to build strategic decisions specific to Region and Hospital.

Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.

Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database, also involved unit testing and bug fixes.

Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.

Blended data from multiple databases into one report by selecting primary key from each database for data validation.

Worked on building queries to retrieve data into Tableau from Microsoft Access and Oracle SQL Developer, SAP BO and developed T-SQL statements for loading data into Target Database.

Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online.

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

Contribute for building and management of the analytics infrastructure for the Revenue Excellence (Rev-Ex) team.

Tableau developer/admin

Department of Finance and Administration (State of Mississippi), Jackson July 2017- August 2018

Responsibilities

●Involved in Planning, Defining and Designing data based on business requirements and provide documentation.

●Redesigned the tableau default charts based on the requirements like increasing display fields in cross tab etc.

●Obtained data from SAP BW and developed parameter and dimension-based reports, drill-down reports and charts using Tableau Desktop.

●Created Tableau scorecards, dashboards using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart, Gantt charts, Donut charts, Viola charts using show me functionality and calculation fields.

●Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

●Implemented action filters, parameters, calculated fields and sets for preparing dashboards and worksheets in Tableau. Also used tooltip to show complex features in charts.

●Worked extensively with Advance analysis Actions, Calculations, Joins, Data blending, Parameters, Trend Lines, Statistics and table calculations.

●Customized the tooltips and labels, to user understandable format, the numerical measure was changed to its appropriate formats like representing the revenue, expense and margins

●Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

●Perform Tableau Server admin duties; add users/groups from Active Directory; roles & permissions and schedule instances in Tableau Server including weekly data dump.

●Optimized Indexes, Views, Stored Procedures and Functions using T-SQL.

●Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes, data access; performance monitoring; subscriptions and alerts and automated required processes.

●Interacted closely with the Business users along with the administration and management to gather the report business requirements, report types and report formats.

ETL/ Tableau developer

Time Inc, Stamford, CT December 2016- June 2017

Responsibilities

Designed the OLAP, star schema in Infomatica power center. Utilized complex SQL join statements to represent relationship between facts and dimensions and enhanced query performance by indexing foreign key fields.

Developed of Informatica mappings Transformations and Mapplets using Source Qualifier, Filter, Lookup, Aggregator, Union, Router, Update Strategy etc.

Performed Push Down Optimization tuning to enable faster data loads to SQL server.

●Generated data extracts in Tableau by connecting to the view using Microsoft SQL server connector.

●Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

●Created Heat Map showing current subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users using Tableau. Built customer cohorts that represented leaving users and joining users yearly.

●Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.

●Projected and forecasted future growth in terms of number of subscribers by developing Area Maps to show details on which states were connected the most and publishing it on Tableau Server.

●Created Bullet graphs to determine profit generation by using measures and dimensions data from Microsoft SQL Server and MS Excel.

●Combined views and reports into interactive dashboards in Tableau that were presented to Business Users, Program Managers, and End Users.

●Reviewed basic SQL queries and edited inner, left, and right joins in Tableau by connecting live/dynamic and static datasets.

●Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

●Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

●Text- mined the chat and email data to identify the issues reported by subscribers

●Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups and offshore teams.

Tableau developer

Ralph Lauren, Lyndhurst, NJ January 2016-Nov 2016

Responsibilities

Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.

Gathered user requirements, analyzed and designed software solution based on the requirements. Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.

Obtained the data from ecommerce website built and published customized interactive reports and dashboards, report scheduling using server.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in tableau desktop.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's

Created Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).

Used SSIS to unite data from existing system and performed transformations on Microsoft SQL Server 2016.

Extracted Transformed Loaded (ETL) the meta data to stage data Using SQL 2016 Integration Services(SSIS)

Created training guides and reference materials to support users in the rollout of new applications, and document database systems and procedures. Provided 24/7 production support for users.

Delegated responsibility for successful resolution of high severity tickets and increased

overall client satisfaction

Reporting Analyst

Karya Property management, Houston Texas January 2015- December 2015

Responsibilities

Successfully interpreted data to draw conclusions for managerial action and strategy.

Presented findings and data to team to improve strategies and operation.

Worked on improving and automating methods for parsing data and incorporating it into real-time models, analysis, and actions.

Produced accurate on-demand, daily, weekly, quarterly and yearly Support metrics.

Use data mining and trend analysis to compile and creatively display data using Dashboards.

Created visualization for logistics calculation and department spend analysis. Generate KPI for customer satisfaction survey results. Maintained Test log and Wrote Test Evaluation, Summary Reports. Extensively involved in user acceptance testing (UAT).

Writing queries, perform ad hoc data analysis, and create data visualizations to keep the nerve center of all operations engine running at full speed.

Built best practices of working with different kinds of data like financial and operational data. (Data sources include Excel, SQL, internal forecasting and planning tools).

Proposed solutions to improve system efficiencies and reduce total expense.

Collected, cleansed and provided modelling and analyses of structured and unstructured data used for major business initiatives.

Created visually impactful dashboards in Excel and for data reporting. Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.

Data analyst

Aquila Software Solutions Hyderabad, India Jan2013 – Dec 2014

Responsibilities

•Developed weekly and monthly sales reports and dashboards in for hospitality clients, analyzed the factors that effected their sales in desktop and publish them to server.

•Created Aggregations, calculated Fields, LOD & Table calculations, window function, Totals, percentages using Key Performance Measures (KPI) and Measures.

•Identified patterns in personnel staffing using R and Python to improve the health care plans.

•Used exploratory data analysis and predictive modeling on hospitality data to find ways to reduce the cost of material, labor and time retaining customer satisfaction.

•Performed various normalization and optimization techniques for fast retrieval of data from database.

•Developed stored procedures using Microsoft SQL Server to perform various tasks.

•Participated in the entire Software Development Life Cycle of projects.

•Created partitions on tables, indexes and indexed views as well as querying and managing partitions from optimization point-of-view per the business criteria

EDUCATION

•Master of Science, Electrical and Computer Engineering, University of Memphis, TN Dec 2016

•Bachelor of Technology, Electronics and Communication Engineering, JNT University, India May 2014

CERTIFICATION

Tableau desktop Qualified Associate Valid through: Dec2020

Contact this candidate