Sumit K Email & Phone Number

Eden Prairie , Mn, Us

Experience with the design and development of Tableau visualization solutions.Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts,Financial Reports etc to assist business users in solving complex problems.Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.Design and development of various reports and dashboards that can be easily accessible through Tableau App in Ipads, IPhones, and other smart mobile phones.Actively participated in clarification meeting with the Clients.Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.Environment: Tableau 7.x/8.x (Desktop, Server), Teradata, Teradata SQL Assistant, Teradata Administrator, SQL, PL/SQL, MS Project.

Dallas, Tx, Us

Involved in creating dashboards and reports in Tableau. Created report schedules on Tableau server.Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.Mentored business power users to create reports/dashboards using tableau desktop.Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau with Javascript Frameworks and Jquery.Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts,Financial Reports etc to assist business users in solving complex problems.Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.Environment: Tableau 7.x/8.x (Desktop, Server), Teradata, Teradata SQL Assistant, Teradata Administrator, SQL, PL/SQL, MS Project.

Interacted with Business analysts to understand data requirements to ensure high quality data is provided to the customersWorked on numerous ad-hoc data pulls for business analysis and monitoring by writing SQL scripts.Created monthly and quarterly business monitoring reports by writing Teradata SQL queries includes System Calendars, Inner Joins and Outer Joins to retrieve data from multiple tables.Developed BTEQ scripts in Unix using Putty and used cron-tab to automate the batch scripts and execute scheduled jobs in UnixPerformed verification and validation for accuracy of data in the monthly/quarterly reports.Analyzed and validated data in Hadoop lake by querying through hive tables.Created reports, charts by querying data using Hive Query Language and reported the gaps in lake data loaded.Good knowledge on Json format data and performed the source, target validations using aggregations and null validity functions.Created multi-set tables and volatile tables using existing tables and collected statistics on table to improve the performance.Developed Teradata SQL scripts using RANK functions to improve the query performance while pulling the data from large tables.Experience in performing Dual Data Validation on various Businesses critical reports working with another Analyst.Designed Marketing Campaigns using IBM Unica Affinium Campaign Management ToolExtracted data for the segmentation process for different channels like direct mail and email using the IBM Affinium Campaign Management Tool.Developed Python programs for manipulating the data reading from various Teradata and convert them as one CSV Files, update the Content in the database tables.Technical