Suganya

Professional with 12+ years of experience, including 5 years of experience in Snowflake DB development and data engineering with skills in Snowpipe, Snowsql, stream, task and SQL development. Involved in creating Snowpipe to integrate data seamlessly between the AWS cloud and Snowflake DB and worked on Time Travel and fail-safe for data recovery, historical data analysis.

Applied

Snowflake's Zero Copy Cloning technique to back up data as needed and Tasks to manage tasks scheduling and automatic execution.

Created Snowflake

Stream objects to support audit table backups and preserve data integrity during DML operations on base tables. Experienced in developing scalable ELT pipelines using DBT and Snowflake, including staging, transformation, data modelling, testing, documentation, and deployment.

Built

Oracle stored procedures to validate source-side data, identifying functional dependencies and technical errors to maintain high data quality. Actively participated in data migration activities from AWS S3 and Oracle databases to Snowflake, using ETL tools such as Talend to automate the ingestion process. Experienced in working on projects across Banking and Healthcare domains, and legacy-to-Snowflake migration project for healthcare data using DBT and Snowflake.

Worked in Agile methodology to adapt quickly to changing project requirements while collaborating effectively with cross-functional teams.

Centaur Billing & IT solution (2021-03 – Present) Accenture Solutions Pvt. Ltd. (2011-08 – 2018-10) Snowflake Developer at Centaur Billing & IT solution (2022-11 – Present) Project: Truist (November 2022 - Present).

Domain: Banking and Finance.

• Designed and developed Snowflake data warehouse solutions for banking and financial datasets including customer, account, transaction, payment, and product information.
• Developed end-to-end ELT pipelines using DBT and Snowflake, transforming raw data into curated datasets.
• Developed DBT incremental models to process only newly arrived or modified records. Developed reusable DBT macros using Jinja for common transformation and business logic requirements.
• Developed complex Snowflake SQL transformations involving joins, CTEs, window functions, aggregations, analytical functions, and conditional logic.
• Configured Snowpipe to continuously ingest files from AWS S3 into Snowflake staging tables. Worked with JSON and semi-structured banking data using Snowflake Variant data types and Flatten functions.
• Developed Apache Airflow to orchestrate data ingestion, DBT transformations, validation, and downstream processing.
• Developed Python scripts for file validation and file chunking before data ingestion.
• Implemented Snowflake Streams and Tasks for incremental processing and change data capture requirements.
• Used Time Travel and Fail-safe capabilities as part of Snowflake data recovery and retention strategy.
• Used Git for maintaining dbt models, SQL scripts, Python code, Airflow DAGs, and configuration files. Participated in code reviews, unit testing, integration testing, deployment activities, production support, and issue resolution.

Snowflake Data

Engineer at Centaur Billing & IT solution (2021-03 – 2022-11) Project: AVIVA plc (March 2021 – November 2022).

Domain: Healthcare & Insurance.

• Participated in the migration of large volumes of healthcare data from legacy Oracle and SQL Server systems to Snowflake. Developed source-to-target mappings between legacy healthcare systems and Snowflake target tables.
• Designed Snowflake database structures including databases, schemas, staging tables, dimension tables, fact tables, and reporting tables.
• Configured Snowflake internal and external stages to support bulk data loading.

Developed

Snowflake SQL scripts for post-migration validation and exception reporting.

• Worked with COPY INTO commands to load CSV, JSON, and other supported file formats into Snowflake.

Developed

Snowflake stored procedures for reusable migration and data-processing logic.

• Developed Talend ETL jobs to extract data from Oracle and SQL Server source systems. Used Talend components to implement full-load and incremental-load migration processes.
• Migrated healthcare datasets including patient, provider, claims, encounters, billing, appointments, and healthcare transaction information.
• Optimized ETL processes by improving SQL queries, reducing unnecessary data movement, and optimizing Snowflake workloads.
• Implemented data cleansing rules to handle null values, duplicate records, invalid formats, inconsistent codes, and source-system data-quality issues.
• Investigated migration failures and data discrepancies by analysing logs, query history, source data, and target data.

Senior

Software systems Analyst at Accenture Solutions Pvt. Ltd. (2016-04 – 2018-10) Project: Accenture Cloud Platform (April 2016 - October 2018).

Domain: Cloud Billing.

• Developed cloud usage billing solutions using Orbitera Cloud Billing to process usage data from major cloud providers including AWS, Azure, GCP based on client-specific billing requirements.
• Developed automated processes using Python to extract the usage files from AWS S3 bucket, validate, transform, and load usage data into downstream billing systems.
• Analysed cloud provider usage data and billing requirements to map usage metrics such as compute hours, storage consumption, network usage, and service-level charges to appropriate customer accounts, products, and billing plans.
• Worked extensively with JSON and XML usage payloads and APIs to retrieve the customer invoice data in JSON format to display the details in the customer portal.
• Implemented error-handling and validations to identify invalid usage records, missing customer mappings, duplicate records, incorrect pricing attributes during the usage ingestion process.
• Supported end-to-end billing operations from receiving cloud provider usage files from AWS S3, validating and transforming usage data, applying rates, calculating charges, loading into billing systems, generating invoices.
• Used JIRA, Jenkins for source-code management, requirement tracking, and documentation management.

Senior

Software systems Analyst at Accenture Solutions Pvt. Ltd. (2011-08 – 2016-04) Project: Telstra (August 2011 - April 2016).

Domain: Telecom Billing.

• Configured core Kenan rate tables — recurring and non-recurring charges, discounts, unit credits and usage — for fixed, internet, cable, and mobile products, transforming business requirements into tested configuration.
• Configured Kenan billing tables in TOAD including Recurring Charges, Non-Recurring Charges, Discounts, Unit Credits, and Usage, using SQL and PLSQL stored procedures to support usage rating, billing, invoicing, and collections processes.
• Developed, reviewed, and optimized complex Sql queries and PlSql procedures to validate customer usage information, identify data-integrity issues, and implement solutions for business and production requirements.
• Validate xmls passed on from mediation to billing system in case of customer mapping errors.
• Managed end-to-end billing operations, including usage processing, rating, balance calculation, bill generation, invoice processing, and collections, while analysing database records using Sql and Plsql to ensure billing accuracy and adherence to global standards.
• Performed UAT, defect analysis, and production support, proactively investigating billing and configuration issues using stored procedures to ensure timely resolution of defects raised by testing and operations teams.
• Participated in deployment and release management, prepared implementation plans for client approval, reviewed deployment strategies, and successfully implemented Kenan configurations within planned timelines while following project management, quality, and change control processes.

B.TECH in Industrial Biotechnology – SASTRA University (2007 – 2011)