Alex Roy

Collaborated with clients, primarily a leading insurance company in the US, to understand and address their business needs, creating customized dashboards using Tableau for various purposes. Utilized SQL queries on Netezza and Oracle databases to extract and manipulate data, ensuring accuracy and alignment with business requirements. Conducted thorough data analysis to identify and rectify errors, implementing quality checks by comparing query results with source tables, enhancing data accuracy. Played a key role in cross-functional collaboration by sharing wireframes and designs with other teams, contributing to the optimization of SQL queries for improved data retrieval. Demonstrated a commitment to process improvement by ensuring consistency between query results and source tables, enhancing the reliability of data outputs. Contributed to converting close to 40 dashboards to the latest dashboard template given by the company. Led the conversion of previously existing SAS workflows to SQL queries and prepared ETL workflows in Tableau Prep. Effectively communicated findings to stakeholders through visually appealing dashboards, with a notable achievement in revamping an existing dashboard to simplify usage and improve visual appeal, receiving positive feedback from stakeholders. Contributed to data governance initiatives by implementing dashboards that monitored specific fields to ensure compliance with industry regulations, involving a detailed understanding of regulatory documentation.

Identified trends and patterns in the data to facilitate informed decision-making by stakeholders. Created pivot tables and charts to analyze data for villages in Tamil Nadu using Excel. Collaborated with stakeholders to understand their needs, providing training and support on interpreting data. Shared actionable insights, contributing to the development of village strategies.