Rajatha P

• ● Data Reporting & Analysis: Created and maintained KPI/KRI metrics, operational performance, and risk mitigation reports, including scheduled and ad hoc reporting using SQL, Power BI and Cognos Analytics.

• ● Developed standardized Cognos data modules for enterprise-wide wealth reporting, reducing data silos and enabling consistent analytics.

• ● Partnered with internal teams to evaluate business processes and develop automations using RPA tools like Automation Anywhere, Power Automate and Python scripts, leading to a 10% increase in efficiency for Middle Office Operations in the Wealth Management division.

• ● Coordinated with BI teams to design data mapping strategies and plan ETL processes, ensuring seamless data integration from source systems to the Cognos reporting platform.

• ● Designed reports that enabled senior leadership to track operational KPIs and compliance risk indicators, reducing decision-making delays by 40%.

• ● Reduced manual data reporting efforts by 30%, enhancing report accuracy, consistency, and turnaround time.

• ● Collaborated on the development of an early cancer detection model on Azure Databricks.

• ● Extracted and conducted exploratory data analysis on cancer data from Medicaid and Genomic Data Commons databases using Python.

• ● Identified and ranked the top 10 features that were the indicators of cancer presence using the Random Forest algorithm.

• ● Collaborated with cross-functional teams to design an integration platform to clinical study data between data management systems using microservice architecture principles.

• ● Designed and developed 10+ REST APIs in collaboration with system architects.

• ● Designed and maintained data models to define entity relationship mapping (PostgreSQL/Oracle) using tools like LucidChart.

• ● Enabled business teams to identify data integration failures by developing a real-time visualisation through a Power BI dashboard.

• ● Developed and executed complex SQL queries on the Oracle database to extract clinical trial data insights across patient records. Analyzed adverse event patterns, enrollment metrics, and protocol deviations using derived tables, nested queries, and analytical functions in Oracle SQL.

• ● Developed an error notification framework by integrating mulesoft applications with Splunk system to improve error tracking by 20%.