Vaishnavi Suresh

Project: American Eagle Outfitters

Roles & Responsibilities

• Experienced in GCP (Google cloud Platform) on various services including Data fusion, Bigquery, cloud storage, cloud composer, cloud functions, Datastore and Dataflow.
• Developed Directed Acyclic Graphs (DAGs) with changes:- source file available check, operator changes, query optimization to reduce 70% runtime.
• Enhanced many ETL pipelines to modify source connection, handle special characters in data, optimize query to minimize its run time.
• Orchestrated a seamless migration, modifying an operator change for around 700 DAGs, without any issues or delays in BAU.
• Debugged many critical PROD bugs tickets, identifying the root cause of the issue, and resolved them within SLA hours.
• Implemented CI/CD pipelines using Bamboo and GitLab.
• Revolutionized cloud storage management by deploying lifecycle policies, achieving a 60% reduction in storage cost without sacrificing performance.
• Implemented data retention policies and managed BigQuery data as part of cost optimization, optimizing around 70% of BigQuery cost.
• Troubleshot issues in ETL pipelines and SQL scripts, communicated with clients to understand bugs and issues, and resolved them promptly, ensuring minimal disruption to operations.
• Actively participated in Composer migration and Data Fusion migration activities without any disruption to the existing workflow with 90% scalability.

Projects: Security Master Central (SMC) & PRICE MASTER CENTRAL(PMC)

Client: CITI Group

Roles & Responsibilities:

• Implemented SQL scripts to load critical hierarchy, intraday data, that are consumed by 40% of clients for the purpose of trading.
• Developed audit triggers for tables across various schemas to capture all audit-related information.
• Created ServiceNow Tickets for delivering change activities, including data analysis and documentation, and ensured 100% successful implementation of change/release.
• Attended weekly meetings to gather business requirements, analyzed user story, developed, and received user signoff.

Projects: Security Master Central (SMC) & PRICE MASTER CENTRAL(PMC)

Client: Citi Group

Roles and Responsibilities:

• Majorly involved in release management activities, which includes: ServiceNow ticket creation, understanding functional requirements, metadata management, gathering technical specifications, and test strategy documentation.
• Developed and tested many ETL pipelines based on Vendor requirement (Internal/Host Server migration, VIN level threshold check, Few logical mapping changes, Null value filter & SCP process change).
• Gathered business requirements from BA and developed domain scripts and its metadata scripts using CITI internal tool, Meta manager, and analyzed its impact on several downstream users.
• Attend meetings with CITI managers to procure go-live approval for metadata changes.

Projects: Security Master Central (SMC) & PRICE MASTER CENTRAL(PMC)

Client: Citi Group

Roles and Responsibilities:

• Developed UNIX Ad-hoc scripts to identify files that occupy 80% or 90% of space on each environment (DEV, UAT & PROD), secured project tags differences across environments (EME tag, SIT, UAT, PROD) and reported the same.
• Developed ETL graphs for parsing raw data sourced from vendors like Bloomberg, Thomson Reuters, Broadridge, etc. Monitored job failures in PROD and PRE-PROD(UAT) environments and analyzed the reasons for failure and action plans to avoid the same.
• Implemented domain data (look ups for ETL process) into tables per BA requirement using an internal tool: Meta-manager. These are crucial data that will impact various market sectors like CMO, CORP, OPTIONS, WARRANT, etc., across the globe.