During my tenure at ANZ Bank as an Data analyst from Aug 2021 to Till date, I spearheaded client requirement gathering and business concept comprehension, driving strategic testing and implementation reports with precision. I orchestrated the extraction of data from Oracle databases using SQL Pass-thru queries and Libname facility, optimizing data retrieval efficiency. Furthermore, I formulated and structured data to meet the analysis and reporting specifications, enhancing report clarity and impact. I streamlined data sub-setting and summarization processes, aligning with reporting needs and bolstering data-driven insights. Additionally, I innovated and managed campaign tracking reports, pioneering new ideas and employing robust test/control techniques for enhanced campaign performance. Moreover, I executed comprehensive analysis to uncover profit/loss and utilization insights, enabling informed decision-making and strategic planning. Leveraging SAS Visual Analytics, I crafted visually captivating reports, elevating data visualization standards and facilitating data interpretation. I evaluated and refined reports to surpass client expectations, ensuring accuracy, aesthetics, and timely delivery. I also authored meticulous test case documents and technical specifications, ensuring project documentation integrity and facilitating seamless project execution.Skills: SAS ADVANCE · SAS MACROS · SAS Programming · Report Generation · Proc Tabulate · Data Manipulation · SAS ODS · SAS/Pass-through · SAS/SQL · Proc Summary · Proc Contents · Ad-hoc Querying · Proc Mean · Proc Append · SAS SQL · SAS PROCEDURES · Data Analysis · Data Extraction · SAS Functions · Proc Reports · SAS Base · SAS Visual Analytics · SAS/Base · SAS/Macros · Proc Univariate · HTML Reporting · Oracle · Proc Freq · Proc Sort