Hariramacharan Pothula

Data Scientist with 1.8 years of experience working with Snowflake, SQL, Python, dbt, and cloud-based data solutions. Hands-on experience in building ETL/ELT pipelines, developing data transformations, stored procedures, Snowflake Tasks, data validation workflows, and scalable reporting-layer objects. Experienced in schema evolution, data security, performance optimization, and Snowflake Cortex AI for AI-assisted analytics and data workflows.

Data Scientist - P99SOFT PVT LTD

(2025-01)

• Developed Snowflake-based data solutions using SQL and Python for data ingestion, transformation, validation, analytics, and reporting.
• Built and maintained ETL/ELT pipelines for structured and semi-structured data, including automated transformations, schema evolution handling, and curated reporting-layer objects.
• Developed and optimized SQL transformations, stored procedures, and Snowflake Tasks to automate data processing and improve pipeline reliability.
• Worked with dbt for SQL-based data transformations and modular data modeling within analytical workflows.
• Used Snowflake Cortex AI and LLM-based workflows for AI-assisted analytics, natural language querying, and data exploration.
• Implemented data validation, schema comparison, masking policies, and secure data-access mechanisms to improve data quality and governance.

B.Tech - Electronics and Communication Engineering - Sreenidhi Institute of Science and Technology (2020 - 2024)