Vamsi Sivapuram

Data Engineer with 4 + years of experience at Kipi.ai in building scalable data pipelines with proven expertise in Snowflake, SQL, Streamlit, Python, ADF, Alteryx, Airflow and DBT. Handled multiple client projects in a fast paced environment. Excelled in the client facing role, handled regular client calls to present updates and refined solutions based on feedback, resulting consistent appreciation from the client and leadership team.

Senior Software Engineer at Kipi.ai (2022-01 – Present)

• Set up Snowflake infrastructure with RBAC, SSO, MFA, Key Pair, Resource Monitor, Trust Center, and applied Row-Level and Column-Level Security and IP Address Whitelisting to ensure 100% data security and governance.
• Led end-to-end pipeline development for data ingestion by creating Historical and incremental pipelines using Snowflake, Airflow, DBT, ADF, Alteryx, SQL, and Python, reducing manual effort by 80%.
• Optimised pipelines by implementing multi-threading and parallel processing, reducing data load time by 75%, and automated reconciliation checks in pipeline logic to ensure data accuracy.
• Successfully migrated pipelines from Snowflake, Nexla to Airflow, and Views from Snowflake to DBT and set up CI/CD for Airflow DAG deployments.
• Flattened semi-structured data and created views on cleansed tables for Power BI analytics, reducing manual effort by 85%.
• Worked on Snowflake advanced features like Time Travel, Data sharing, Cloning, Snowpipe, Streams, and Tasks.
• Conducted extensive data validation, delivering 99.5% data accuracy and Integrated failure email alerts to enhance operational transparency, significantly reducing Mean time to Resolution (MTTR) by 50%.
• Automated object cleanup activity to optimize storage cost and operations overhead.
• Built Streamlit Applications for automatic email alerting and Fiscal calendar data generation.
• Enabled watch keeper accelerator in Snowflake.
• Developed and published Snowflake Native Apps like Service Compass and BAU Apps on Snowflake Marketplace.
• Collaborated with cross-functional stakeholders to gather requirements, define scope, and align data solutions with business objectives.
• Delivered solutions aligned with client standards for data compliance, security, and operational efficiency.
• Mentored Junior Team members on Snowflake Best practices and provided Technical guidance. code review and deployment checklist review.

Bachelors of Technology in Electronics & Communications – Gandhi Institute of Technology, Visakhapatnam, Andhra Pradesh (2018 – 2022)