Bhabani Shankar Panda

Dynamic Senior Consultant with expertise in data transformation and analytics at Ernst & Young LLP. Proficient in Snowflake and SQL, I drive impactful insights and enhance data visibility. A collaborative problem-solver, I leverage data warehouse management to optimize client profitability, ensuring strategic decisions that elevate business performance.

• SNOWFLAKE SNOWPRO CORE CERTIFICATION

• English
• Hindi
• Odia

• Over 7 years of IT expertise in Snowflake, Teradata, SQL, ETL, UNIX, and Snowflake development, complemented by a SnowPro Core Certification.
• Proficient in the design and development processes required to extract, transform, and load data into data warehouses using Snowflake cloud database and AWS S3.
• Hands-on experience with Snowflake features including Snowpipe, Tasks, Clone, and Internal/External Stages.
• Involved in Zero Copy Cloning for creating DEV and QA environments efficiently.
• Created integration objects, file formats, and stages; utilized COPY INTO for seamless data ingestion.
• Experienced in Snowflake’s Time Travel feature for data protection and recovery.
• Queried historical results using TIMESTAMP, OFFSET, and QUERY ID for audit and analysis.
• Strong understanding of data warehousing concepts and deep knowledge of Teradata architecture.
• Widely used Teradata utilities such as BTEQ, FASTLOAD, MULTILOAD, SQL Assistant, and TPT.
• Proficient in Teradata SQL, including joins, subqueries, set operations, functions, and advanced indexing techniques (JI, PI, SI, PPI) along with OLAP capabilities.
• Engaged in various stages of the Agile project life cycle, including development, testing, and maintenance of enterprise data warehouses.
• Participated in data reconciliation between source systems and data warehouses, ensuring reporting accuracy.
• Experience in the banking domain, with exposure to financial data systems and compliance requirements.
• Skilled in performance optimization, data analysis, and effective customer interaction.
• Prior experience in Data Extraction, Transformation, and Loading (ETL) for building robust data warehouse solutions.
• Demonstrated ability to connect business challenges to underlying data and apply data warehousing technologies to solve them.
• Extensive experience working in UNIX environments, supporting automation and scripting needs.
• Committed to continuous learning and leveraging technical skills to drive organizational success.
• Used Snowpipe to ingest CSV data from external sources into Snowflake efficiently.

If you want, I can help you create a visually formatted resume or LinkedIn summary using these dots as bullet points, or even suggest icons or styles to make it pop further. Just say the word!