Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

K Balu

Summary

Having over 6+ years of comprehensive experience in SENIOR DEVELOPER both in cloud and on premise across diverse lines of business. Demonstrated success in establishing robust, collaborative partnerships with key stakeholders, resulting in improved quality, cost reduction, and increased operational efficiencies. Extensive collaboration with vendors and outsourcing firms in deploying data engineering solutions in a dynamic, fast-paced environment.

Overview

9
9
years of professional experience

Work History

SQL,PLSQL Developer

Wipro
01.2021 - Current
  • Created Data pipelines to ensure continuous data loading from AWS to Snowflake.
  • Created snow pipe using auto ingest and we get the errors through mail.
  • During the data loading process, transformation was implemented by establishing both internal and external stages.
  • Improved performance by redesigning the views in Snowflake.
  • Accountable for crafting diverse objects and managing the loading/unloading of data into tables from various sources, leveraging both external and internal storage within the snowflake environment.
  • Determine the size of Snowflake's virtual warehouse for various workloads.
  • Responsible for creating views, materialized views, and synonyms for developers to hide complexity and secure direct access to DB tables.
  • Generated SQL and PL/SQL scripts to install building database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms with oracle 11g database.
  • Created complex functions, stored procedures, and packages by using PL/SQL.
  • Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.
  • Responsible working with user groups, analyzing reported problems, performing root cause analysis, and presenting alternatives to correct the problem.
  • Wrote complex SQL queries using Joins, sub queries and inline views to retrieve data from the database.
  • Created Cursors, Collections, and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
  • Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large tables using Range Partitioning, creating Index Organized Table, Rollback Table space.
  • Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target And Worked on Windows Batch scripting, scheduling jobs, and monitoring logs.
  • Involved in Dimensional modeling and developed the star and snowflake schemas.
  • Performed unit testing and supported integration testing and end user testing.
  • Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.
  • Involved in SQL tuning, PL/SQL tuning and Application tuning using tools like EXPLAIN PLAN etc.
  • Environment: Snowflake, Oracle 12C, SQL, TOAD, Explain Plan.

Oracle PLSQL Developer

CTS
07.2019 - 01.2021
  • Generated SQL and PL/SQL scripts to install building database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms with oracle 10gdatabase.
  • Created complex functions, stored procedures and packages by using PL/SQL.
  • Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.
  • Responsible working with user groups, analyzing reported problems, performing root cause analysis and presenting alternatives to correct the problem.
  • Developed back-end interfaces using PL/SQL packages, stored procedures, functions, Object Types, Pipelined functions, Oracle queues and used Collections, Bulk Collects to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
  • Wrote complex SQL queries using Joins, sub queries and inline views to retrieve data from the database.
  • Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
  • Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large tables using Range Partitioning, creating Index Organized Table, Rollback Table space.
  • Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target And Worked on Windows Batch scripting, scheduling jobs and monitoring logs.
  • Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.
  • Involved in SQL tuning, PL/SQL tuning and Application tuning using tools like EXPLAIN PLAN etc.
  • Environment: Oracle 11g, SQL, PL/SQL, SQL Loader, TOAD, Explain Plan.

Virinchi Technologies
12.2015 - 07.2019

Education

Master’s - computer applications

Krishna University
Machilipatnam, India
01.2014

Skills

  • Snowflake
  • Oracle
  • Data Pipeline
  • SQL
  • PL/SQL

Accomplishments

  • Understanding of Snowflake cloud technology, specializing in Snowflake cloud data warehouse and AWS S3 bucket for seamless integration of data from various source formats CSV, Parquet, and JSON structured data into Snowflake tables.
  • Constructing Snow pipes for continuous data consumption from external stages and experienced in Snowflake performance tuning using Clusters, Search Optimizer, and QAS.
  • Knowledgeable in Data Masking Policy, Security Snowflake Clone, and Time Travel. Demonstrated expertise in developing Secure/Materialized/Views within the Snowflake environment.
  • Having knowledge in Oracle Database Programming, including PL/SQL, SQL, Oracle Tuning & Optimization.
  • Having experience in developing Procedures, Packages, Functions, Triggers, views, Cursors, PL/SQL Collections, and optimizing query performance and other database objects using SQL, PL/SQL.
  • Accomplished in developing Extraction, Transformation, and Loading processes using Pre-Stage, Stage, Pre-Target, and Target tables.

Timeline

SQL,PLSQL Developer

Wipro
01.2021 - Current

Oracle PLSQL Developer

CTS
07.2019 - 01.2021

Virinchi Technologies
12.2015 - 07.2019

Master’s - computer applications

Krishna University

Similar Profiles

CREATE PROFILE
K Balu