Gnanavel A

• 3+ years of experience on Google Cloud Platform (GCP)
• Implemented and migrated Elastic Search DB to GCP BigQuery
• Implemented GCP solutions using BigQuery, Compute Engine
• Good knowledge of SQL
• Work closely with application developers and Administrators to create and improve data flows between internal/external systems and the data warehouse
• Installable shifts to learn new things and to enhance comprehensive problem-solving abilities
• Writing Report queries and Data validation between Staging to information layer

Experience and Accomplishments of Key Projects

Data Engineer - Retails Marketing (Macys)

Client: Macys

Technology: SQL,GCP,Python

· Designed and maintained data pipelines using GCP services such as BigQuery, Cloud Storage, and Cloud Composer.

· Built optimized SQL queries for customer segmentation, sales trends, and marketing insights.

· Automated ETL processes using Python, improving data refresh time for marketing analytics.

· Collaborated with analytics and marketing teams to deliver accurate campaign performance reporting.

· Implemented data quality checks and validation between staging and production BigQuery datasets.

• Handled all queries related to inward/outward payments including non-receipt, amendments, cancellations, FX conversions, and fraud cases.
• Managed investigative processes for foreign currency transactions and ensured strict adherence to compliance and sanction policies.
• Efficiently managed Nostro accounts, cleared outstanding payments daily, and guided/trained new hires for smooth operations.

• Investigated client enquiries received through SWIFT, FED, and email channels, reconciling outstanding entries and coordinating with business units to resolve fund transfer and recruitment-related queries.
• Skilled in SWIFT message handling (MT series), with strong proficiency in Swift Alliance, Finacle Core, UAE FTS, and IPI systems, ensuring accurate and timely resolution of all payment investigations

• Monitored online transactions in real-time and near real-time at authentication and authorization levels, analyzing parameters such as IP, device, browser, OS, ISP, merchant details, amount, and transaction patterns.
  
• Handled customer queries related to card and net-banking transactions via email and calls, ensuring quick and accurate issue resolution.
  
• Investigated and reviewed suspicious account activities, assessed fraud risks, and recommended cases for further review or account closure.