AMARNATH M
Morrisville,NC
Summary
PROFILE SUMMARY Having 10 years of experience in Information Technology in which 7 years of Experience in Visualization tools like Tableau, Power BI along with SSRS and 5 years of experience in Python and Excel Reporting Responsible for interaction with Business stake holders, gathering requirements, managing delivery, and covering entire Tableau development life cycle. Responsible for developing code / reports, to testing and release / deployment. Experience in writing Python code and connected with data sources like excel, SQL server as part of project deliverables. Worked on data from various data bases like SQL Server, Snowflake, SharePoint, and Excel Experienced in writing complex SQL queries to do various data related tasks like creating views, tables, stored procedures etc.
Overview
1
1
year of professional experience
1
1
Certification
Work History
Senior Software Engineer
Saminavi
01.2023 - Current
- Snowflake, Tableau Desktop, Tableau server
- Responsibilities:
- Requirement gathering, creating tableau data sources using views and tables from Snowflake database
- Creating Dashboards with interactive views, trends, and drill downs
- Creating visualizations as per user requirements
- Creating views and writing SQL queries as part of data gathering and validation
- Migrating existing reports from excel to Tableau
- Testing and publishing dashboards in Tableau server
- Assist business power users to create reports/dashboards using tableau desktop.
Sherwin Williams
- Snowflake, SQL Server, Tableau Desktop, Tableau server
- Responsibilities:
- Connecting with users and SMEs for understanding and gathering requirements
- Created Tableau data sources based on SAP BO reports data queries
- Created queries in Snowflake to fetch data and worked with Data Engineering team to create required views
- Worked with Business users to understand and document dashboard requirements
- Creating, testing, and publishing Tableau dashboards
- Resolving tickets related to Tableau dashboards published in the production server
- Created Tableau Published data sources as per client requirement
- Responsible for developing, testing, and deploying the dashboards
- Connect and interact with users to fix bugs in production dashboards.
Applied Materials
- Excel, Tableau Desktop, Tableau Server
- Responsibilities:
- Involved in understanding, gathering requirements and Tableau end to end development cycle
- Created stored procedures, Tables, views in MS SQL server and write SQL queries to perform data validation
- Responsible for developing, testing, and deploying the dashboards
- Created dashboards using Drill up, Drill down and Drill through methods
- Created Parameterized dashboards as per the requirements
- Worked on Data blending and Cross database joins
- Created trend lines, Donut, Pie, Tree Map charts.
Boeing
- Tools : Python, SQL Server, Excel, SharePoint, Tableau Desktop, Tableau Server
- Responsibilities:
- Connecting with stakeholders for understanding and gathering requirements
- Analyzing the data from sources and work with partners for cleaning and modelling the data
- Created python code to schedule pilot availability as per the business rules
- Worked on migrating reports from excel to Tableau
- Worked on Actions, Context filters, parameters, and groups
- Created Gantt, bar, text table and Map charts
- Created data flow model based on client existing reports
- Created Tableau dashboards using SharePoint data.
Honeywell Aero
- Tools : SQL Server, Excel, Power BI, Tableau Desktop and Tableau Server
- Responsibilities:
- Created charts such as Bar, Line, Text Table, Donut etc
- As per the requirement
- Involved in administrative tasks like setting permissions, managing ownerships and providing access to the users
- Created reports for drill up and drill down purposes
- Created SQL queries for data validation
- Created SQL views, stored procedures, and tables as part of data gathering
- Write Python scripts for web scraping to reduce manual effort
- Created various visualizations like bar, stacked bar, tree map, heat map using Tableau
- Created effective and informative Visualizations using Viz
- In tooltip feature
- Created Tableau dashboards to report weekly and monthly metrics
- Published dashboards in Tableau server and created subscriptions for business users.
Member of Technical Staff
Synopsys
- Working as MTO pricing analyst for, Tools : Excel, SQL, Tableau Desktop
- Responsibilities:
- Created excel reports as per client requirements
- Created weekly, monthly status reports
- Created interactive reports for business users
- Created dashboards to show skill learning and course content progress analysis
- Created dashboards to show important KPIs.
Education
Master of Technology (M. Tech) -
Jawaharlal Nehru Technological University
Skills
- TECHNICAL SKILLS
- BI Tools : Tableau Desktop, Power BI, SSRS
- Tools : MS Office, SSIS
- Servers : Tableau Server
- Databases : MS-SQL Server, Snowflake
- Languages : SQL, Python
Certification
Certified Tableau Desktop Specialist
Additional Information
- Created SSRS reports to send status reports via email. Expertise in creating interactive visual reporting Dashboards and publishing them in Tableau server. Involved in giving access, setting up permissions and adding users to specific groups. Wrote custom SQL queries to support business requirements. Scheduled extract refreshes for weekly monthly status reports Used multiple measures like individual axes, blended axes, and dual axes. Designed and deployed reports with Drill up, Drill Down, Drill Through and Parameterized reports using Tableau. Developed queries to query data from database for data validation purposes. Worked on Actions to create interactive dashboards. Developed map charts using custom geo coding and Map Box Quick learner and able to work independently while connecting with stakeholders and help team members whenever necessary.
Timeline
Senior Software Engineer
Saminavi
01.2023 - Current
Sherwin Williams
Applied Materials
Boeing
Honeywell Aero
Member of Technical Staff
Synopsys
Master of Technology (M. Tech) -
Jawaharlal Nehru Technological University