Surya Prasanth Email & Phone Number

Chennai, Tamil Nadu, India

• Developed and implemented comprehensive data pipelines for end-to-end ETL processes on Google Cloud Platform (GCP).• Successfully migrated on-premise ETLs to GCP, utilizing native tools such as BigQuery, Google Cloud Storage, and Composer.• Enhanced and troubleshooted existing data flow jobs to address data issues, ensuring data integrity and accuracy.• Created sophisticated Type1 and Type2 Change Data Capture (CDC) workflows for both batch and historical data loads.• Constructed ETL pipelines in Airflow/Composer on GCP, employing various Airflow operators for diverse data processing tasks.• Led efforts in data extraction, migration, validation, encryption, and replication from on-premises systems to GCP.• Technology Stack: GCP Composer, BigQuery, Cloud SQL, Cloud Functions, Cloud Dataflow.

Chennai, Tamil Nadu, India

• Extensively worked on billing preprocessing, including client data processing and payment handling for custom deals, network sourcing clients, hosting services, and various innovative services.• Collaborated closely with business users to gather and understand requirements.• Prepared comprehensive documentation for requirements and report enhancements.• Developed and modified triggers, packages, functions, and stored procedures for data conversions, and created dynamic database objects using PL/SQL based on user inputs.• Created automated reports for business users using TOAD for Oracle.• Managed client permissions and performed reconciliation and validation of billing data.• Scheduled and automated jobs, ensuring validation processes were in place.• Designed and developed complex PL/SQL procedures, packages, and functions.• Technology Stack: PL/SQL, Unix shell scripting, Oracle SQL.

Chennai, Tamil Nadu, India

• Over six months of Hands-on experience in PL/SQL & SQL.• Expertise in database programming involving Stored Procedures, Triggers, Views and implementation with SQL Server and Oracle.• Team player with good interpersonal skills. Thrives well within the group environment. Designed and presented flow charts.• Build productive relationships at all levels within the Organisation.