Shavitha Andavar

CI/CD Dev Ops: Git,Snowflake 8.19.2,DMS,AWS Glue,Airflow,Python,CloudFormationTemplate,OCI,PostgreSQL,SFTP on Prem to cloud migration,Snowflake Cost Optimization.

Led product operations, optimizing workflows, aligning cross functional teams, driving data driven decision, and enhancing delivery efficiency and customer impact

• Optimise migration solution in cloud for reducing cost with respect to snowflake and assisted company in saving in 3 million
• Reduction of 40% month over month cost of snowflake
• AWS cost reduction of 20%

• Led data management and data governance project with 3 teams in parallel
• Customer Insight cloud migration to landing zone from Netezza to AWS Redshift via Informatica within an AWS cloud environment
• Set the goal and led the team to achieve 720k (+8% YoY) incremental story producers within a year via end to end automation
• Airside portal migration to a Landing Zone
• Data governance project using Informatica IDQ/EDC
• Cross-functional Collaboration: Worked with 24+ stakeholders across Product management, Research & Insights, Portal designs, UX design, Privacy & Legal teams, and Data engineering teams to influence product decisions and contribute to the overall organizational goals

• Led the Customer Insight Project consolidating data from a heterogeneous system into a Snowflake database
• Data sources housed in AWS S3 were transformed applied data quality checks & loaded into the EDW and DM layers using Datastage for Business Intelligence reporting

• Implemented SMART Alerts to automatically notify Informatica team of any failures or anomalies in data load in near real time based on data captured for workflow execution statistics data stored in Informatica PC repository Database

• Deloitte Project: Worked on Consolidating data from Raw layer to GBM layer from data coming through PAS system to hive database(Datalake) for IFR747 Finance project using Informatica Big Data Management ETL

• CAG Project : Consolidated data from various source system into Netezza database using Informatica tool into Enterprise warehouse and supplied to BI layer for Reporting
• Developed QC checks and reusable codes with stored procedures according to new type of surveys and touchpoint addition in airport
• Worked in Stored Procedure, Netezza, My SQL, Informatica Powercenter 10.1, MSTR 10.10, VB scripts, Batch Scripts, Audit tables, configuration tables, Reject handling, PDPA regulatory Salesforce retention Automation system
• Developed Data Model for Airside AWS Cloud Project from Airside Portal to BI Schema
• Worked in Pentaho to extract data from Portal My SQL Database and load it into AWS Oracle RDS Target Database for Tableau Reporting