Sumit K

Sumit K Email and Phone Number

Tableau Developer @ Optum
11000 Optum Circle, Eden Prairie, MN
Sumit K's Location
St Paul, Minnesota, United States, United States
About Sumit K

Sumit K is a Tableau Developer at Optum.

Sumit K's Current Company Details
Optum

Optum

View
Tableau Developer
11000 Optum Circle, Eden Prairie, MN
Website:
optum.com
Sumit K Work Experience Details
  • Optum
    Tableau Developer
    Optum Jan 2020 - Present
    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.
  • At&T
    Tableau Developer
    At&T Dec 2017 - Dec 2020
    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.
  • Morgan Stanley
    Data Analyst
    Morgan Stanley Jul 2015 - Nov 2018
    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

Frequently Asked Questions about Sumit K

What company does Sumit K work for?

Sumit K works for Optum

What is Sumit K's role at the current company?

Sumit K's current role is Tableau Developer.

Who are Sumit K's colleagues?

Sumit K's colleagues are Tanvi Kedar, Nitu Jha, Ankit Bhalla, Wendy Longo, Do, Faap, Nirmita Biswas, Jaya Suri, J B.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.