Summary
Overview
Work History
Education
Skills
Projects
Achievements & Launches
Timeline
Generic

Emayathilagam Suriamurthy

Chennai

Summary

Results-driven Data and Risk Management professional with over 4.8 years of experience in data pipelines, ETL, analytics, and risk operations. Skilled in designing and optimizing Snowflake and MySQL-based workflows, creating Amazon QuickSight dashboards, and executing complex SQL queries for operational insights. Adept at collaborating with cross-functional teams, resolving escalations, and delivering actionable insights to improve fraud detection, data integrity, and business decision-making.

Overview

5
5
years of professional experience

Work History

Risk Management Specialist

Amazon Development center
Chennai
12.2022 - 05.2024
  • Integrated AWS S3 with Snowflake using external stages and Snowpipe, enabling seamless ingestion of structured (CSV, Parquet) and semi-structured (JSON, Avro) data into Snowflake tables.
  • Built and orchestrated SQL-based ELT pipelines within Snowflake to transform raw S3 data into analytics-ready fact/dimension models, leveraging CTEs, window functions, and analytical SQL for scalable transformations.
  • Designed and optimized complex SQL queries by applying query profiling, clustering keys, and result caching, reducing BI query runtime by 40% and improving reporting efficiency.
  • Automated continuous ingestion pipelines using Snowpipe, Streams, and Tasks to deliver near real-time data availability for publisher account monitoring and compliance reporting.
  • Developed Amazon QuickSight dashboards directly connected to Snowflake datasets to monitor high-risk publisher activity, royalty discrepancies, and account violations, improving fraud detection visibility.
  • Automated anomaly detection processes using advanced SQL queries (outlier detection, pattern matching, duplicate checks) to flag fraudulent publishers, reducing manual audit effort by 60%.
  • Managed end-to-end data migration workflows from legacy systems to Snowflake and MySQL, staging raw datasets in AWS S3 before applying Snowflake transformations for scalable storage and analytics.
  • Enforced Snowflake RBAC policies by defining custom roles and access controls, ensuring secure handling of sensitive royalty and account data in compliance with publishing policies.
  • Collaborated with cross-functional teams to optimize SQL workflows, improve ETL logic, and enhance fraud detection models.

Risk Analyst

Amazon Development center
Chennai
11.2020 - 12.2022
  • Monitored and analyzed large-scale publisher datasets (account details, royalty transactions, book metadata) by writing and optimizing complex SQL queries, enhancing anomaly detection accuracy across millions of records.
  • Developed SQL-driven QuickSight dashboards and ad-hoc reports, enabling operations teams to proactively detect and intervene in high-risk publisher activities.
  • Led root cause analysis for escalations by leveraging advanced SQL techniques (joins, CTEs, window functions, subqueries), significantly reducing turnaround time for resolving data quality issues.
  • Engineered anomaly detection logic in SQL to flag irregularities such as duplicate ISBNs, content theft, metadata impersonation, and copyright violations.
  • Collaborated with cross-functional teams to optimize SQL workflows, ETL logic, and reporting pipelines, resulting in faster data validation and improved fraud detection efficiency.

Quality Assurance Associate

Amazon Development center
Chennai
06.2019 - 11.2020
  • Conducted end-to-end manual testing on internal publishing tools to validate customer account workflows, book metadata accuracy, royalty calculations, and publishing lifecycle records against business requirements.
  • Executed functional, regression, integration, and user acceptance testing (UAT) by preparing detailed test scenarios, test cases, and test data sets, ensuring stable and defect-free releases.
  • Logged, tracked, and prioritized defects using defect management tools (JIRA / Bugzilla / HP ALM), collaborating with developers to resolve issues and improve system reliability.
  • Performed data validation and backend testing using SQL queries to verify data integrity across publishing systems, royalty databases, and metadata repositories.
  • Applied boundary value analysis (BVA), equivalence partitioning (EP), and exploratory testing techniques to identify edge cases and uncover hidden defects.
  • Prepared test summary reports and traceability matrices (RTM) to ensure full requirement coverage and compliance with QA standard

Education

Bachelor of Engineering - Electronics & Communication Engineering

MNM Jain Engineering College
Chennai
05-2017

MBA - Financial Management

Annamalai University
Chidambaram
05-2020

Skills

  • Databases & Querying: SQL, Snowflake, MySQL, Data Modeling, ETL/ELT
  • Cloud & Storage: AWS (S3, QuickSight, Glue, Lambda), Data Pipeline Design & Optimization
  • Data Analytics & Visualization: Power BI, Amazon QuickSight, Advanced Excel (Macros, Pivot Tables, Lookups)
  • Risk & Compliance Analytics: Fraud Detection, Risk Scoring, Publisher Activity Monitoring, Data Validation
  • Quality Assurance: Manual Testing, Functional/Regression/Integration Testing, Test Case Design, Defect Management

Projects

Publisher Risk Analytics & Data Pipeline | Snowflake, AWS S3, SQL, Snowpipe, Tasks

  • Integrated AWS S3 with Snowflake using external stages and automated Snowpipe for seamless, continuous ingestion of publishing data.
  • Built SQL-based ELT pipelines to transform raw data into analytics-ready models for fraud detection and publisher risk scoring.
  • Optimized complex SQL queries (joins, CTEs, window functions) to improve reporting performance by 40%.
  • Designed Snowflake tasks for event-driven orchestration, ensuring timely availability of risk monitoring data.
  • Supported downstream BI dashboards by delivering accurate and timely datasets for risk assessment and compliance reporting.

Account Resource Management (ARM) Tool | SQL, Risk Analysis, Compliance

  • Utilized the ARM tool to monitor and validate publisher account status (active, suspended, terminated) and corresponding violation reasons.
  • Performed SQL-based data validation to ensure accuracy of account records, suspension timelines, and termination history.
  • Executed functional and regression testing on account workflows to confirm proper handling of suspension, reactivation, and compliance rules.
  • Conducted negative testing and edge case analysis to identify gaps in publisher account risk evaluation.
  • Supported risk management investigations by extracting and analyzing publisher data from ARM, enabling informed decisions on account actions.
  • Ensured compliance with SOX 404 and ITGC controls by validating account data integrity and documenting test results.

Publishing Tools Quality Assurance & Data Validation | Manual Testing, SQL, CAPA, KDPOW

  • Conducted functional, regression, and integration testing on internal publishing tools to validate customer information, book metadata, royalty records, and publishing workflows.
  • Performed backend database validation using SQL to ensure consistency and integrity of royalty transactions and publisher details.
  • Documented defects, edge cases, and system gaps, collaborating with developers to improve tool reliability and reduce publishing errors.
  • Executed test scenarios, boundary value analysis, and negative testing to identify vulnerabilities in publisher account workflows (suspension, termination, reactivation).
  • Enhanced overall risk controls by ensuring compliance with SOX 404 and ITGC requirements during QA processes.

Achievements & Launches

  • Insight Innovator – 2023
  • Top Performer – 2022
  • Benchmark Setter – 2019
  • Collaboration Champion – 2024
  • Successfully contributed to multiple product launches(Falkor,ARM,CAPA)

Timeline

Risk Management Specialist

Amazon Development center
12.2022 - 05.2024

Risk Analyst

Amazon Development center
11.2020 - 12.2022

Quality Assurance Associate

Amazon Development center
06.2019 - 11.2020

Bachelor of Engineering - Electronics & Communication Engineering

MNM Jain Engineering College

MBA - Financial Management

Annamalai University
Emayathilagam Suriamurthy