Amith Heiden Email & Phone Number

Toronto, Ontario, Canada

Ontario, Canada

- Proficient in communicating with stakeholders to collect requirements and understand user needs.- Able to collect relevant data and organize the data for efficient data analysis.- Able to perform simple to complex SQL Queries for exploratory data analysis and data cleaning.- Experienced in transforming data insights into interactive dashboards using Tableau & Power BI.- Experienced working with Python programming.- Experienced in ad hoc analysis and reporting.

Barrie, Ontario, Canada

• Involved in Database migration.• Analysed the crystal reports and SSRS reports after database migration.• Debugged existing crystal and SSRS reports using MS SQL server to obtain the desired results.• Tested the converted crystal and SSRS reports before implementing them into the Production line.• Converted crystal reports to SSRS reports.• Performed database table validation and enhancement.• Performed other activities as assigned.

Coimbatore, Tamil Nadu, India

Coimbatore, Tamil Nadu

• Designed SQL Query reports (involving Joins, Where Clause, Correlated subqueries, CTL, Temp Tables, and Partition By), PLDs, Crystal Reports, and Tableau reports and made recommendations for easy business progress.• Designed Dashboards and Visuals using Microsoft Excel (involving Pivoting, Formulas, Formatting, VBA, and Power Query) and designed Dynamic Tableau Dashboards displaying KPIs for Sales Analysis.• Designed Financial reports like Accounts Payables and Receivables, and Customer Outstanding reports to assist in planning budget for Quarters and Financial Year.• Diagnosed and executed resolution for all SAP module-related issues.• Standardized job tasks and trained SAP Users on industry best practices.• Used Power Apps and Power Automate to automate workflow and improve business process efficiency.• Used critical thinking to analyse data, evaluate solutions and make decisions.• Analysed sales-related data tables and inventory coding tables to determine inconsistent data – misspelled states, UOM.• Determined the distinct entries of inconsistent data from the data tables.• Created mapping tables with target data to be mapped in place of inconsistent data.• Used relevant joins to map data and provide data consistency for reporting purposes.• Implemented performance tuning measures like adding missing Indexes on SQL Queries.• Created non-Clustered Indexes to improve the speed of data retrieval from tables.• Analysed the Execution plan to determine the part of the query that affects the performance.• Successfully implemented SAP B1 in the manufacturing industry and ensured that all functionalities were integrated with existing systems such as MRP, CRM, etc. • Troubleshot and resolved application issues escalated from end users.• Provided technical support to end users for the configuration of various modules.• Responded to telephone inquiries, and provided quality service to customers to ensure customer satisfaction.

Mumbai, Maharashtra

• Involved in all stages of Software Development Lifecycle (SDLC) including Requirements Gathering, Analysis, Design, Development, Testing, UAT, Production, and Post Production Support.• Coordinated with Business analysts to identify the data requirements and integrate them with the data sources. • Compilation of reports based on analysis, keeping in mind the end user’s requirements. • Used critical thinking to analyse data, evaluate solutions and make decisions.• Produced databases, tools, queries, and reports for analysing, summarizing, and root-causing board failure data.• Retrieved data from Azure data warehouse systems and organize the data in a meaningful way.• Provided static, dynamic Dashboards and ad hoc report to Stakeholders using Microsoft Power BI to assist in data-driven decision-making and communicated to external stakeholders through effective storytelling.• Analysed existing SQL queries to identify opportunities for improvements. Reviewed and interpreted business report requirements to address user needs.• Interacted with developers to support data models, Queries, and Stored Procedures.• Designed a logical and physical Entity-relationship data model for customer datamart.• Created database objects as per the physical data model – Tables, Indexes, primary and foreign keys, roles, privileges, and views.• Denormalized data in the data warehouse for fast reporting purposes.• Maintained more than 200 Back Office Starbucks servers and monitored data flow into the Central Instance server in a fast-paced environment. • Assisted in the deployment of Software release patches across all servers and troubleshoot issues during deployment.• Provided Application Support to end-users, tracked defects using Service Now, and resolved the defects.• Performed UAT testing before implementation of the new requirement into production.• Maintained a consistent number of open/closed tickets and provided remote assistance to customers.

Postgraduate Degree, Big Data Analytics

Bachelor Of Engineering (B.Eng.), Production Engineering