Varun Narvaneni
Plain City,OH
Summary
- Experienced with ETL processes and data transformation techniques essential for optimizing data workflows. Utilizes advanced SQL and data warehousing skills to ensure seamless data integration and improvement in data quality. Track record of effective collaboration with cross-functional teams and adaptability in dynamic project environments.
- Developed strong data integration and transformation skills in collaborative and fast-paced environment, seeking to transition into new field. Deep understanding of ETL processes and data warehousing principles, with hands-on experience in SQL and scripting. Aiming to apply analytical and problem-solving skills to drive innovation and efficiency in new role.
Overview
9
9
years of professional experience
Work History
Senior ETL Developer
PNC Bank
09.2024 - Current
- Enhanced data integration by designing and developing efficient ETL processes using Informatica PowerCenter.
- Successfully migrated legacy ETL processes to Informatica PowerCenter, resulting in increased efficiency and reduced maintenance effort.
- Collaborated with business analysts to translate complex requirements into functional ETL mappings, meeting project goals and timelines.
Senior ETL Developer
State of Ohio-BWC
10.2021 - 08.2024
- Design, Develop and test ETL/ELT process using DBT/Python/SQL to move data to/from relational and star-schema structures
- Automated routine tasks using Python scripts, increasing team productivity and reducing manual errors.
- Implemented Snowflake data models and optimized performance for efficient data processing.
- Implemented and maintained Snowflake solutions to support data warehousing needs.
- Implemented DBT solutions to enhance data pipeline efficiency and accuracy.
- Evaluated new technologies as potential solutions for enhancing current ETL processes, providing recommendations based on research findings.
ETL Developer
Cardinal Health
03.2020 - 08.2021
- Utilized Alteryx to design and implement efficient ETL solutions for data integration.
- Developed and optimized data workflows using Alteryx to streamline ETL processes.
- Executed data analysis tasks utilizing Alteryx to drive strategic insights.
- Enhanced ETL processes by optimizing complex SQL queries and streamlining data extraction procedures.
- Managed data quality issues during ETL processes, directing qualitative failures to team lead for amelioration.
ETL Developer (Data Archiving)
Franciscan Alliance
01.2019 - 03.2020
- Completion of data mapping requirements investigate various forms of inputs (from flat file to DB) to complete data reporting
- Archive selected databases - no longer actively used to a separate storage device (metadata mining, data throughput/threading, retention policies)
- Written test cases to test the application in Quality Center9.0 and11.0(ALM)
- Developed parameterized mapping solutions that accommodated changing business requirements with minimal modifications needed in future updates.
Data Analyst
JP Morgan Chase
01.2017 - 12.2018
- Produced monthly reports using advanced Excel spreadsheet functions.
- Utilized data visualization tools to effectively communicate business insights.
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
- Supported marketing strategies by providing detailed customer segmentation analysis.
Data Analyst
DSW Shoe Warehouse
10.2015 - 12.2016
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.
Education
Master of Science - Computer Science
NORTHWESTERN POLYTECHNIC UNIVERSITY
Fremont, CA08-2015
Bachelors of Engineering - Computer Science
JNTU Hyderabad
Hyderabad, Telangana04-2013
Skills
- ETL modeling
- SQL and databases
- Business intelligence
- Data analysis
- Alteryx tools
- Snowflake
- PowerCenter
- Tableau
- Data Archiving
Timeline
Senior ETL Developer
PNC Bank
09.2024 - Current
Senior ETL Developer
State of Ohio-BWC
10.2021 - 08.2024
ETL Developer
Cardinal Health
03.2020 - 08.2021
ETL Developer (Data Archiving)
Franciscan Alliance
01.2019 - 03.2020
Data Analyst
JP Morgan Chase
01.2017 - 12.2018
Data Analyst
DSW Shoe Warehouse
10.2015 - 12.2016
Master of Science - Computer Science
NORTHWESTERN POLYTECHNIC UNIVERSITY
Bachelors of Engineering - Computer Science
JNTU Hyderabad
Similar Profiles
Erica HendryErica Hendry
Personal Banker/Loan Officer at PNC Bank/National City BankPersonal Banker/Loan Officer at PNC Bank/National City Bank
Abel Maldonado JrAbel Maldonado Jr
International Trade Specialist at PNC Bank, Pittsburgh National Corporation BankInternational Trade Specialist at PNC Bank, Pittsburgh National Corporation Bank
Courtney KutscherCourtney Kutscher
Bank Teller at PNC Bank/National City BankBank Teller at PNC Bank/National City Bank