Poonkodi B
Snowflake Developer
Chennai
Summary
Dynamic SQL Developer with a proven track record at Wells Fargo Bank, adept in ETL tools and SQL, showcasing strong analytical skills and a knack for optimizing data performance. Excelled in transforming complex data into actionable insights, leveraging JIRA/GIT for enhanced project management. Demonstrates exceptional problem-solving abilities and a commitment to excellence.
Overview
5
5
years of professional experience
Work History
Associate
Wells Fargo Bank
San Francisco
06.2022 - Current
- Done analysis of source, requirements, existing OLTP system and identification of required dimensions and facts from the database
- Worked in AWS External stage using S3 and IAM
- Worked using blocks to make the engine to execute at one go
- Created queries using cursors (Implicit cursor, Explicit cursor) to perform complicated queries
- Good working knowledge of ETL tool
- Build logical and physical data model of snowflake as per the changes required
- Define roles, privileges required to access different database objects
- Developed mappings, sessions and workflows to extract, validate and transform data according to business rules using SQL and snowflake
- Involved in fixing various issues related to data quality, data availability and data stability
- Wrote scripts and indexing strategy for confidential data from SQL server
- Used JSON script to define table and column mapping
Associate
Swag Tech Solutions
Chennai
12.2019 - 03.2022
- Actively participated in gathering Business Requirements and system specifications from system users
- Extensively worked in oracle SQL, Query performance, created DDL scripts, database objects like Tables, Indexes, Sequences, Procedures etc
- Used Materialized view to create monthly snapshot
- Provided quality assurance for all modules developed
- Developed UNIX scripts and generated .csv files to load the files to target system
- Created snowpipe for continuous data load
- Created internal and external stage and transformed data during load
- Created Views in snowflake to increase the performance
- Extensively worked on views, stored procedures, SQL queries and loading the data to enhance and maintain the existing functionality
- Writing SQL queries for data retrieval involving complex join conditions
Education
B.E - Electronics and Communication Engineering
Sri Venkateshwara College of Engineering and Technology
Thiruvallur04.2011
Skills
SQL Developer
- JIRA / GIT
- GIT
- SQL
- UNIX
Accomplishments
- Achieved star performer award for delivering the output on time.
- Received appreciation mails from end customer for delivering the service with quality and for the proactive work.
- Offered “Best Employee of the Month" for handling maximum number of queries within a stipulated time with 100% quality.
Declaration
- I hereby declare that all the information furnished above is true to the best of my knowledge.
Timeline
Associate
Wells Fargo Bank
06.2022 - Current
Associate
Swag Tech Solutions
12.2019 - 03.2022
B.E - Electronics and Communication Engineering
Sri Venkateshwara College of Engineering and Technology
Similar Profiles
Frederick TulayFrederick Tulay
Commercial Banking Portfolio Associate at Wells Fargo Bank NA (Commercial Investment Bank-CIB)Commercial Banking Portfolio Associate at Wells Fargo Bank NA (Commercial Investment Bank-CIB)
Carey JonesCarey Jones
Loan Verification Analyst at Wells Fargo BankLoan Verification Analyst at Wells Fargo Bank
JACQUELINE PROWELLJACQUELINE PROWELL
Lending Officer at Wells Fargo Bank Home MortgageLending Officer at Wells Fargo Bank Home Mortgage
Yesenia SalgadoYesenia Salgado
Associate Personal Banker at Wells Fargo Bank, N.A.Associate Personal Banker at Wells Fargo Bank, N.A.
Maruthu PandiMaruthu Pandi
Apps Software Development, Associate at AthenahealthApps Software Development, Associate at Athenahealth