DHEERAJ VARTHI
Summary
Over 8 years of IT experience in Data warehousing and Business intelligence with an emphasis on Project Planning & Management, Business Requirements Analysis, Application Design, Development, testing, implementation, and maintenance of client/server Data Warehouse. Seeking to have a challenging career in Data Warehousing and Business Intelligence with growth potential in technical as well as functional domains and to work in critical and time-bound projects where can apply technological skills and knowledge in the best possible way.
Overview
6
6
years of professional experience
Work History
Data Engineer (Snowflake Developer)
HDFC Bank
12.2022 - Current
- Bulk loading from the external stage (AWS S3), internal stage to snowflake cloud using the COPY command.
- Loading data into snowflake tables from the internal stage using snowsql.
- Used COPY, LIST, PUT and GET commands for validating the internal stage files.
- Used import and Export from the internal stage (snowflake) from the external stage (AWS S3).
- Writing snowsql scripts in snowflake cloud data warehouse to business analysis and reporting.
- Used SNOW PIPE for continuous data ingestion from the S3 bucket.
- Developed snowflake procedures for executing branching and looping
- Created clone objects to maintain zero-copy cloning.
- Data validations have been done through information_schema.
- Performed data quality issue analysis using Snow SQL by building analytical warehouses on Snowflake
- Experience with AWS cloud services: EC2, S3
- Cloned Production data for code modifications and testing
- Perform troubleshooting analysis and resolution of critical issues
PL SQL Developer
TATA CONSULTANCY SERVICES
04.2020 - 11.2022
- Created technical design for the back end PL/SQL based on business requirement documents and the functional system design.
- Creation of database objects like tables, views, synonyms, materialized views, stored procedures, packages using Oracle tools like PL/SQL developer.
- Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
- Involved in updating procedures, functions, triggers, and packages based on the change request.
- Built complex queries using SQL and wrote stored procedures using PL/SQL.
- Used ref cursors and collections for accessing complex data resulted from joining of a large number of tables.
- Involved in moving the data from flat files to staging area tables using SQL loader.
- Extensively used for all and bulk collect to fetch large volumes of data from the table.
- Enhanced database performance by identifying and resolving query inefficiencies and implementing indexing strategies.
- Optimized existing PLSQL routines using performance tuning techniques such as indexing, query optimization, and partitioning strategies.
SQL Developer
TATA CONSULTANCY SERVICES
07.2018 - 04.2020
- Created complex SQL queries, views, and stored procedures to extract, manipulate, and analyze data for business needs.
- Managed and maintained relational databases, ensuring data integrity, consistency, and availability across multiple environments.
- Optimized SQL queries and database performance through indexing, query refactoring, and execution plan analysis.
- Worked closely with application developers, data analysts, and stakeholders to gather requirements and deliver database solutions that align with business objectives.
- Provided technical support for database-related issues, diagnosing and resolving problems to minimize downtime and maintain data accuracy.
- Created and maintained comprehensive documentation for SQL queries, procedures, and database structures to support ongoing development and maintenance efforts.
- Developed and optimized reports using SQL, providing actionable insights to management and business teams.
- Utilized version control systems (e.g., Git) to manage and track changes to SQL scripts and database objects, ensuring smooth deployment processes.
Skills
- Cloud Technologies: Snowflake, AWS
- Programming Languages: C, SQL , PL/SQL ,Python
- DataWarehousing: Snowflake
- DBMS: Oracle,SQL Server
Timeline
Data Engineer (Snowflake Developer)
HDFC Bank
12.2022 - Current
PL SQL Developer
TATA CONSULTANCY SERVICES
04.2020 - 11.2022
SQL Developer
TATA CONSULTANCY SERVICES
07.2018 - 04.2020
Similar Profiles
KAMALA SUBRAMANIANKAMALA SUBRAMANIAN
Senior Vice President and Unit Head at HDFC Bank Limited, HDFC BankSenior Vice President and Unit Head at HDFC Bank Limited, HDFC Bank
Jignesh PatelJignesh Patel
Relationship Manager at HDFC Sales Pvt. Ltd. (Group Company Of HDFC Bank)Relationship Manager at HDFC Sales Pvt. Ltd. (Group Company Of HDFC Bank)
Prodip SahaProdip Saha
Collection Officer at HDFC Bank, Bajaj Finance, Axis Bank, IDFC BankCollection Officer at HDFC Bank, Bajaj Finance, Axis Bank, IDFC Bank
Rajan GargRajan Garg
Assistant Manager at HDFC Bank LTD (HDFC Sales Pvt Ltd)Assistant Manager at HDFC Bank LTD (HDFC Sales Pvt Ltd)
SARAVANAN RSARAVANAN R
Data Engineer (Snowflake Developer) at LTIMINDTREEData Engineer (Snowflake Developer) at LTIMINDTREE