Tableau, SQL, PLSQL.

Amit Sawant

Email: ******.****.*@*****.***

Phone: 831-***-****

Linkedin: www.linkedin.com/in/amit-sawant-v09

Summary

Experienced professional with expertise in business intelligence and analytics, with skills to work in all phases of project life cycle from requirements and design to development and final system deployment. For the last 3+ years, I have developed and deployed several analytics dashboards for a leading healthcare organization. I have domain expertise in Finance and Healthcare, with skills in developing relational database queries, data integration using various tools, scripting, and BI reporting. Tools and technologies expertise include AWS (S3, Redshift), Tableau, MySQL, Oracle, Spotfire, and Jira. Well-trained in Agile methodologies.

Experience

Change Healthcare, San Mateo, CA & Nashville, TN March 2016 to Aug 2023

Project: - Data Products & Services.

Role: Data Analyst, Business Intelligence Analyst and Developer

Description: Helped reduce cost track productivity by developing dashboards that analyzed current trend.

Product: Customer View, Nashville, TN February 2018 to Nov 2023

Role: Data Analyst, Business Intelligence Analyst and Developer

Description: Provided better intelligence during the customer contract renewal process. Developed a one-stop

solution which provided a 360-degrees view of existing customers including their product usage, revenue by segment, and solution area. This helped the sales team to identify future customer needs and come up with better terms at the time of contract renewal.

Product: Financial Data Mart (FDM) San Mateo, CA February 2017 to January 2018

Role: Data Analyst, Business Intelligence Analyst and Developer

Description: Financial Data Mart is an analytical data store that collects capital expenses, budget and approved figures across projects from various systems. This enables the creation of metrics to help the Project Managers and Senior Management across the firm to check the capital expense figures in multiple granular levels. Worked with the end-users and key stakeholders to build the key reporting dashboard such as Spend vs Budget, Spend vs Approved, Spend by Capital Type, Monthly and Yearly Drilldown Expense values etc. in multiple visualizations like Pie chart, Stacked Bar charts and Tabular formats. This allowed the teams to track and project capital expenses and manage their individual portfolio budgets.

Product: Print Payment Tracking System (PPTS) San Mateo, CA March 2016 to January 2017

Role: Data Analyst, Business Intelligence Analyst and Developer

Description: Print Payment Tracking System (PPTS) is data mart which displays existing operations data for print file process flow status and error notifications from the Express Bill system. Designed the Tableau reports to provide access to Express Bill Customer print file records and provide print file status reflecting the current and completed steps in the print process. This helped the operations team to meet their SLA’s.

Amit Sawant

Business Intelligence Developer

Experience in Data research, analysis and requirements gathering.

Strong background in database design and development.

Analytical mind with creative mindset to develop innovative solutions for end users.

Team and goal oriented with skills to deliver under challenging time.

Technical Knowledge

Cloud Technologies – AWS (S3, Redshift)

Databases - MySQL, SQL Server, Oracle, AWS Redshift.

Reporting Tool – Tableau 9/10.X, Spotfire 7.X.

Agile Training - Attended internal skilled Agile training for leaders & product owners/managers.

JIRA – Attended internal training for Atlassian tool – JIRA.

Operating Systems – Windows 10.

Responsibilities:

Analyzing and integrating the data and technical requirements accurately.

Designed single system for all analytics and reporting.

Consolidated data from database systems for products into redshift.

Generating analytics reports using Tableau, Power BI.

Publishing Dashboard and Scheduling data refreshes on Tableau server.

Actively participated in creating POCs for new requirements.

Design and Develop Technical Documents and adopted by team as Standard process.

Developed interactive views and dashboards.

Education

Pursuing Doctorate in Information Systems from Indiana Wesleyan University since August 2023.

Professional Master of Business Administration, Campbellsville University, December 2019

Master of Science in Information Technology Management, Campbellsville University, July 2017

Master of Business Administration in Information Systems Management, ITU, September 2015

Bachelors in commerce, Mumbai University, March 2008

Contact this candidate