Summary
Overview
Work History
Education
Skills
Timeline
Generic

Bhavana Kolli

Denton,TX

Summary

Proven Data Engineer with a track record of enhancing data-driven decision-making at JPMorgan Chase through expert ETL development, data warehousing, and the creation of user-friendly dashboards. Excelled in cross-functional collaboration and significantly improved data quality and efficiency. Skilled in SQL, Python, and Business Intelligence tools like QlikSense, demonstrating both technical proficiency and teamwork. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.

Overview

5
5
years of professional experience

Work History

Data Engineer

JPMorgan Chase
Dallas, TX
12.2023 - 05.2024
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
  • Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
  • Increased efficiency of data-driven decision making by creating user-friendly dashboards that enable quick access to key metrics.
  • Designed scalable and maintainable data models to support business intelligence initiatives and reporting needs.
  • Collaborated with cross-functional teams for seamless integration of data sources into the company''s data ecosystem.
  • Performed basic sanity checks on data using PySpark, SparkSQL on Azure Databricks.
  • Created Dataflows in Power BI in order with Dimensional tables that can help users to build self-service reports, that in fact increased the re-usability of data

Senior Systems Engineer / Data Analyst /BI Developer

Infosys
India
11.2020 - 01.2023
  • Accomplished Business Intelligence Professional with a strong background in designing, developing, and maintaining Business Intelligence solutions using QlikView and Qlik Sense.
  • Proficient in building data models and integrating data from multiple sources including ODBC connections (Amazon Redshift), SAP BW, Salesforce, flat files, XML files, Excel files, and SQL Server.
  • Experienced in implementing ETL processes to enable the creation of interactive dashboards, reports, and incremental data models.
  • Specialized in optimizing performance and ensuring compliance with data security.
  • Skilled in maintaining and supporting BI products and providing technical assistance to end users.
  • Responsible for data quality assurance, regularly assessing and enhancing data consistency and accuracy.
  • Proficient in responding to ad hoc data analysis requests and collaborating with cross-functional teams.
  • Strong hands-on experience with MySQL and adept at working in Agile methodology environments, participating in scrum meetings.
  • Well-versed in QlikView Scripting, Set Analysis, and Section Access.
  • Proficient in managing job failure analysis and providing production support for various applications.
  • Deep understanding of data modeling, including dimensional and relational concepts such as Star-Schema modeling and Snowflake schema modeling, and creating fact and dimension tables.

Systems Engineer Intern

Infosys
India
08.2020 - 10.2020

Worked as an intern and was trained on SAP BW and SAP HANA

  • Completed specialized training in SAP BW (SAP Business Warehouse), a prominent data warehousing and business intelligence platform.
  • Acquired essential skills in data modeling, ETL (Extract, Transform, Load), and data reporting with SAP BW.
  • Proficient in designing and managing data objects, data providers, and data sources in SAP BW.
  • Developed expertise in creating data queries and reports, facilitating data-driven decision-making.
  • Familiar with SAP BW's data integration capabilities for holistic business data analysis.

Research Assistant /Junior Research Fellow

Boltzmann Labs
India
05.2019 - 05.2020
  • Performed statistical, qualitative, and quantitative analysis.
  • Participated actively in regular meetings with fellow researchers to discuss project updates, challenges faced, and lessons learned during ongoing activities.
  • Spearheaded a Research Internship focusing on the application of cutting-edge machine learning methodologies to expedite drug discovery processes.
  • Successfully implemented and fine-tuned machine learning models to predict a comprehensive set of ten distinct molecular properties associated with compound clearance and metabolism.
  • Designed and implemented an advanced deep learning model with a focus on predicting the Blood-brain barrier of molecules, a critical element in pharmaceutical research.
  • Rigorously trained and fine-tuned the model to achieve exceptional levels of accuracy, consistently surpassing industry standards and establishing a new benchmark in molecular property prediction.

Education

Master of Science - Information Technology

University of North Texas
Denton, TX
05.2024

Bachelor of Science - Information Technology

Gayatri Vidya Parishad College of Engineering
India
09.2020

Skills

  • ETL development
  • Data Warehousing
  • Data Modeling
  • SQL Expertise
  • Business Intelligence (QlikSense, Qlikview, Tableau)
  • Python (Numpy, Pandas,TensorFlow)
  • C, JAVA
  • Azure DataBricks
  • HTML, CSS, JavaScript

Timeline

Data Engineer

JPMorgan Chase
12.2023 - 05.2024

Senior Systems Engineer / Data Analyst /BI Developer

Infosys
11.2020 - 01.2023

Systems Engineer Intern

Infosys
08.2020 - 10.2020

Research Assistant /Junior Research Fellow

Boltzmann Labs
05.2019 - 05.2020

Master of Science - Information Technology

University of North Texas

Bachelor of Science - Information Technology

Gayatri Vidya Parishad College of Engineering
Bhavana Kolli