Riya Patel

Experience

• 

  Accenture in India

  Sept 2019 - now

  Skillfully utilize SQL Server Reporting Services (SSRS) to design, develop, and refine comprehensive reports and dynamic dashboards, accurately illustrating critical market risk metrics such as value-at-risk (VaR), stress tests, scenario analyses, and risk exposures.Design and implement state-of-the-art interactive visualizations using SSRS, SSMS, Power BI enhancing stakeholder engagement and enabling deep dives into substantial risk data sets.Leverage Microsoft Power BI to construct and deploy intuitive and actionable dashboards, facilitating enhanced decision-making processes through superior data visualization techniques.Worked on the migration of risk analysis projects of in- house tools from outdated systems to modernized analytical platforms, driving significant improvements in process efficiency and data accuracy.Systematically extract, clean, and transform complex market risk data from diverse sources, including trading systems, advanced risk management platforms.Collaboratively engage with risk management teams to meticulously define and iteratively refine risk reporting standards and key performance indicators (KPIs) tailored to precise market risk monitoring.Apply expert knowledge in data analytics using a comprehensive toolkit that includes Report Builder, SSMS, Power BI, Microsoft Excel, and specialized in-house tools for data project migrations and analytics.Utilized Agile tools such as Jira to maintain project artifacts, track sprint progress, and adapt sprint plans in response to changing requirements.Led sprint planning meetings, collaborating with the team to establish achievable sprint goals while accommodating changes in scope and priorities. Show less Designed and developed dynamic dashboards and interactive visual reports using Power BI, enhancing business decision-making processes.Conducted in-depth analysis, employing DAX queries and functions in Power BI to analyze and optimize existing ETL processes, ensuring efficient data handling and accuracy.Led a proof of concept (POC) for developing a Power BI report aimed at managing employee proficiencies and workforce analytics within the organization. This tool enabled managers to perform futuristic analysis concerning active skill sets and headcount, facilitating strategic staffing and resource planning. Executed SQL queries to extract maximum utility from data, utilizing sophisticated filtersand graphical presentations for enhanced data comprehension and stakeholder reporting.Utilized a suite of tools including Microsoft Power BI Desktop, pgAdmin4, and PostgreSQL to deliver high-quality BI solutions and reports.Conduct detailed analytics to derive deep insights from business data. Analyze and optimize current ETL (Extract, Transfer, Load) processes to improve data accuracy and efficiency. Show less Responsible Initiate client discussions to capture and define business requirements, swiftly gaining trust and understanding client needs for Wireline and Wireless solutions.Implement core pricing and offerings through structural design, and continuously enhance product features and functionalities.Improvised the client’s legacy codebase to boost system performance and delivery efficiency.Created and execute over 500 test cases, identifying and addressing key defects to ensure the application’s reliability.Identified a few key defects which were present in the existing system.Have gained client confidence in a very short span and playing a major role in understanding Business requirements, activities and solution proposals.Employ tools like SQL, SQL Developer, Eclipse, ATG Oracle Commerce, and BCC Tool for optimal development and management. Show less

  • Packaged App Development Analyst

    Feb 2022 - now

  • Application Development Analyst

    Sept 2021 - Feb 2022

  • Application Development Associate

    Sept 2019 - Sept 2021