Aabha Choudhary

Developed and implemented a robust validation layer on the data pipeline, leveraging AWS Redshift and Lambda with statistical modeling to prevent incorrect data loads and highlight inconsistencies, ensuring data integrity for critical dashboards.

Orchestrated complex data workflows using AWS Step Functions and recursive Lambda functions to automate procedure runs for aggregate tables and Quicksight SPICE data refreshes, significantly improving data availability and sending proactive alerts for query failures.

Designed and constructed comprehensive, organization-wide Sales Dashboards in Quicksight, managing the full lifecycle from SQL query formulation to secure dashboard deployment with row-level security, directly impacting merchant transaction volume tracking and sales incentive calculations.

Engineered a real-time alerting dashboard on Tableau, utilizing KSQL DB and AWS Redshift, to provide continuous monitoring of international transactions for the Risk Team, enhancing proactive risk management.

Created and optimized aggregate tables and stored procedures in AWS Redshift, enhancing data extraction, reporting, and dashboard development capabilities by an estimated 15%, which facilitated more efficient decision-making.

Automated data cleaning and conversion of manually generated XLSX files from business teams into pipe-delimited CSV format using a Lambda function, streamlining data integration into SQL queries and dashboard creation.

Engineered and deployed over 100 custom dashboards, significantly enhancing cross-team collaboration and streamlining data dependencies across the organization.

Presented critical performance metrics and in-depth COHORT and RFM analyses to potential investors, directly influencing informed decision-making and securing investment opportunities.

Conducted rigorous statistical analysis on available data to pinpoint potential fraudulent merchants and transactions, developing a dedicated dashboard for the RIC team that expedited investigations by 20%.