• Working closely with risk management teams to understand data needs, and deliver insights through Power BI dashboards, emphasizing compliance with regulations and supporting risk mitigation strategies.• Leveraging SQL to query and extract data from corporate database for thorough analysis and to support risk assessment and monitoring.• Utilized Alteryx to design and implement data workflows that automate data transformations, enhancing the efficiency of data processing for risk-related insights• Developing VBA macros to streamline recurring report generation, reducing manual effort and ensuring consistency in risk reporting• Conducted data validation checks and ensured data accuracy across reporting and dashboard outputs, critical for regulatory and compliance reporting.

• Collaborate with stakeholders to understand business requirements and translate into technical specifications for ETL processes• Develop and maintain workflows using Alteryx Designer to transform data from flat files and share in the required format for Power BI consumption• Design, Develop, and implement VBA macros and scripts to automate repetitive tasks and streamline processes in excel reporting • Develop VBA scripts to automate email processes to send weekly email alerts to sector and account leaders with new pipeline opportunities • Providing tech support for global One Pipeline project in data collation, data transformation through various ETL tools and delivering insights in Power BI reports • Load revenue transformed data into SQL databases for various reports • Business Analyst for Power BI reports which involves gathering the requirements from stake-holders, creating mock-ups, validations and delivery of the reports • Responsible for development/ automation of the processes through VBA, Alteryx, SQL• Leading Field of Play Project with stakeholders/ sectors to identify various approaches for mapping and automate the manual efforts along with creating process documents, decision tree, etc• Collect the revenue from different Member Firms to identify trends, patterns and opportunities for revenue growth.• Creating validation test scripts for validation of Power BI reports from SQL database• Documentation of all the processes, SQL queries for future reference• Integrating and tracking the developments in Azure DevOps

• Create excel based solutions for data analysis, reporting and manipulation using VBA scripts, including the development of custom functions, forms and dashboards• Creating Macros to cut monotonous work and provide it to team• Extract data from various source systems such as databases, flat files• Cleanse, transform, and enrich the extracted data to meet the business and technical requirements• Preparation of various reports regarding status of orders/SLA management and presenting to stake holders• Track and evaluate key operational metrics and KPI's to identify bottlenecks in operational workflows and propose process improvements to streamline operations.