KRISHNAVENI R Email: krishnavenironda198@gmail.
com
Contact: +91-9398985307
Data Engineer
PROFESSIONAL SUMMARY:
Having 5+ Years of professional IT experience in this area of snowflake cloud data warehouse and snowflake
developer.
Having 3+ years of Professional Experience in working with Snowflake cloud data warehouse, AWS S3, Azure.
Created Clone objects to maintain zero copies in Snowflake.
Worked on TASK and Strems creation for scheduling/Automate Snowflake jobs.
Extensively worked in ETL process consisting of data transformation, data sourcing, mapping, conversion
along with data modelling.
Experience in Application development and Maintenance/Support projects using SQL, PL/SQL and UNIX
with extensive understanding of different Application development tools and technologies.
Used COPY/INSERT, PUT, GET commands for loading data into Snowflake tables from internal/external stage.
Extensive experience in creating complex database objects like stored procedure, Functions.
Hands-on experience in bulk loading and unloading data into Snowflake tables using COPY command.
Proficient in PL/SQL programming - Stored Procedures, Functions and Packages, Constructing of Tables, Views,
Database Triggers, Synonyms, Sequence, Cursors, user defined exception, indexes, Analytical Functions,
Dynamic SQL.
Handling large and complex data sets like CSV , ORC, PARQUET,JSON files from various sources like AWS S3.
Good exposure in Snowflake Cloud Architecture and Snow SQL and SNOWPIPE for continuous data loading.
Expertise in Client-Server application development using Oracle 11g, PL/SQL, SQL *PLUS, TOAD
and SQL LOADER.
Ability to work independently and as a team with a sense of responsibility, dedication, commitment and with a
continuous drive of learn new technologies.
EXPERIENCE:
• Working for HCL Technologies as a Technical Lead from July 2024 to till date.
• Worked as a Software Engineer for spreader IT solutions pvt ltd , from July - 2018 to Feb-2023
EDUCATION:
Bachelor of Technology from Atmakur College Of Engineering , Nellore.
Technical Skills:
Primary Skill Snowflake, SQL
Secondary Skill AWS, Azure, Informatica
Databases Oracle 11g, SQL Server, Teradata
Tool’s Toad, SQL Developer, Axpert
Code Repository Azure Devops
Client : Nestle
Tools : Snowflake, Azure, Power BI
Role : Snowflake Developer
Description:
Nestle is a global leader in the food and beverage industry, operating in over 180 countries with a diverse
portfolio of brands. The company focuses on nutrition, health, and wellness, leveraging advanced technology and
data-driven insights to optimize its supply chain, production, and customer engagement. Nestle continuously invests
in digital transformation, including cloud data platforms, to enhance operational efficiency and drive business
growth.
Responsibilities:
Analyzed the Excel format received from the Product Owner and used dependency queries to list all tables
required for views in the Snowflake environment for the new solution.
Identified the latest timestamp column to generate JSON files using the PARSE_JSON format.
Developed JSON scripts and deployed them in the pre-prod environment via pull requests in Azure DevOps.
Writing complex Snowflake sql scripts in Snowflake cloud data warehouse to Business Analysis and reporting.
Implemented necessary modifications to the solution as per client requirements to achieve 100% data availability in
the dashboard.
Perform troubleshooting analysis and resolution of critical issues.
Promoted the solution to the production environment through another pull request after ensuring complete data
availability.
Involved in data analysis and handling ad-hoc requests by interacting with business analysts, clients and
resolve the issues as part of production support.
Performed required changes to existing solutions based on client requests, enhancing system functionality and
performance.
Monitored and resolved production pipeline failures, conducting data validation to identify and fix issues
effectively.
Created new DP policies and SLA policies as needed.
Monitored the Data Availability Dashboard for missed SLAs, performed data validation on tables in Snowflake,
and analyzed the root cause of missed SLAs.
Client : UnitedHealth Group
Role : Snowflake Developer
Environment : Snowflake, Informatica, Oracle11g, AWS S3 .
Description:
UnitedHealth Group Incorporated is an American multinational managed healthcare and insurance
company based in Minnetonka, Minnesota. It offers health care products and insurance services. UnitedHealth Group is
the world's eighth largest company by revenue and second-largest healthcare company behind CVS Health by revenue,
and the largest insurance company by net premiums. UnitedHealthcare revenues comprise 80% of the Group's overall
revenue.
Responsibilities:
Created stages like external stage to load data from various sources like S3 and on-premise systems.
Responsible for all activities related to the development, implementation, administration and support of
ETL processes for large scale Snowflake cloud data warehouse.
Used import and export from external stage (S3 Bucket).
Writing complex Snowflake sql scripts in Snowflake cloud data warehouse to Business Analysis and reporting.
Good exposure on snowpipe configuration for continuous data ingestion.
Perform troubleshooting analysis and resolution of critical issues.
Involved in Performance tuning of sessions, mappings, PL/SQL procedures.
Involved in data analysis and handling ad-hoc requests by interacting with business analysts, clients and
resolve the issues as part of production support.
Loading data into Snowflake tables from internal/external stages.
Used COPY, LIST, PUT and GET commands for validating internal and external stage files.
Involved in data cleansing to maintain quality and better performance.
Project Name : CBFS
Client : College of Banking and Financial Studies, Oman
Role : Oracle SQL and PLSQL Developer
sEnvironment : Axpert, Oracle 11g, SQL
Description:
The College of Banking and Financial Studies (CBFS) is a government organization established by a
Royal Decree in 1983 with the objectives of educating and training bankers and encouraging research in Banking and
Financial subjects. It is under the juristic supervision of the Central Bank of Oman (CBO) and is supported by the
commercial banks operating in the Sultanate.
Over three decades, the College has been helping the financial services industry to meet its human resource
development needs by offering academic and training courses that are tailor-made for the emerging needs of Oman. It is
an active partner in the Organization of the banking sector.
Responsibilities:
Developed stored procedures, functions, Triggers, PLSQL programmed unit etc. as per the project requirement.
Created different types of reports and print formats as per the client requirement.
Based on the mapping document we will create tables and write triggers for enhanced validation and
business logic management.
Modified existing procedures, functions as per the Project requirements. Involved in the development
backend code, altered tables to add new columns, Constraints, Sequences and Indexes as per business
requirements.
Using sql developer tool we debugging the code and unit test.
Created record types, tables, collections (nested tables and arrays) for improving Query performance
by reducing context switching.
Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the
error messages in the application.
Using set auto trace on and explain plan for query optimization
DECLARATION:
I declare that the above given details are true and correct to the best of my knowledge.
(KRISHNAVENI.R)