Pranali R.

• Designed Data-Lakehouse medallion architecture (Bronze-Silver-Gold) in Microsoft Fabric; stored 18 TB of parquet, shortened E2E latency from 24 h to 45 min. • Acted as Product Owner for BI stream (risk data warehouse replacement); groomed Jira backlog, translated regulatory requirements into 400+ user stories, achieved 98 % acceptance-criteria hit-rate. • Managed 3 offshore ETL developers; instituted code-review checklist that cut production incidents from 15 to 2 per quarter. • Managed end-to-end project lifecycle, collaborating with cross-functional teams to gather business requirements, defined project scope, and delivered solutions aligned with business objectives. Employed DevOps practices and used Azure DevOps and streamlined team management and velocity. • Wrote 200-line PL/SQL script that extracts 1.2 M active-card records nightly, calculates 30+ DPD flag and roll-rate, loads into SQL Server staging. 2-hour workshop with Credit-Risk & Portfolio teams to lock KPI definitions and alert thresholds • Built an automated self-service risk portal in Power BI Service (row-level security, incremental refresh) feeding 800 users across 12 countries; replaced 120 legacy Excel files and cut data-quality issues by 90 %.

• Ran requirement-gathering workshops with Finance & Ops BAs; created reusable requirement matrix that cut UAT defect leakage to <2 % and accelerated go-live by 3 sprints. • Experience in creating and managing workspaces and gateways, tuning performance, and deploying Power BI reports. • Built reusable semantic models and DAX measures to support evolving reporting needs across markets, while ensuring performance optimization and consistency in calculations. • Delivered training webinars (Power BI & risk interpretation) to 200+ business users; created DAX cheat-sheet that reduced internal support tickets by 35 %. • Experience and understanding of data modeling techniques like Snowflake schema and Star schema to improve the performance of reports.

Developed ETL pipelines using Azure Data Factory (ADF), and administered data extraction, cleaning, preprocessing, and transformation to generate actionable insights. • Captured reporting requirements from various stakeholders, architect the solution/report, understand/analyze the source data and deliver the reports in agile mode. • Expedited tasks by using advanced SQL, data visualization and report authoring skills along with Power Automate which eliminated manual work and improved productivity for tasks by 70% daily. Participated in building large-scale infrastructure applications, focusing on writing maintainable code across multiple programming languages. • Developed foundational knowledge in cloud computing platforms, including Google Cloud Platform (GCP) and Amazon Web Services (AWS). • Engaged in building data platforms using tools like Spark with attention to data quality, SQL performance tuning, and fundamental data warehousing principles. • Gained introductory experience in modern data architecture, including implementing data mesh principles to enhance organizational data management. • Mapped trading-book risk taxonomy to FRTB-SBM; identified 180 nm EUR capital reduction opportunity through risk-factor granularity optimization.

Experience working with top-tier EU bank deep knowledge of credit, market, liquidity and operational risk frameworks (Basel III) Experienced in implementing agile software development best practices, including Test-Driven Development (TDD), refactoring, Continuous Integration/Continuous Deployment (CI/CD) Skilled in custom ETL design, implementation, and maintenance, utilizing modern data orchestration tools. Extensive expertise in distributed data processing and query engines, including Apache Spark, Snowflake, and BigQuery, enabling efficient data analytics and processing at scale.

● Understanding and experience with data cloud computing technologies ● Collaborated with senior management on multiple functions including customer success and finance. ● Simplified tasks by using advanced SQL, data visualization and report authoring skills along with Power Automate which eliminated manual work and improved productivity for tasks by 70% daily.