Summary
Overview
Work History
Education
Skills
Timeline
Generic

Siva Krishna Chava

NJ

Summary

  • Expertise in leveraging Python, R Programming, Tableau, and SQL for robust data analysis, visualization, and reporting, enabling comprehensive insights.
  • Extensive proficiency in database management encompassing Mongo DB, MySQL, and SQL Server. Mastery in SQL/PLSQL, crafting Procedures, Triggers, and Packages.
  • Skilled in navigating various Software Development Life Cycle phases, contributing to the achievement of organizational missions and objectives.
  • Demonstrated expertise in Data Analytics, Wrangling, Exploration, Visualization, and Modelling, ensuring precise reporting and thorough analysis.
  • Hands-on experience in creating and modifying worksheets, data visualization dashboards, and database objects using SQL, fostering seamless user interaction.
  • Comprehensive understanding of Oracle architecture, EBS database/tables structures, and proficient in database design principles.
  • Proficient in version control using Git and GitHub, facilitating efficient collaboration and streamlined code management.
  • Solid foundation in statistical analysis, data wrangling, exploration, and visualization. Familiarity with machine learning techniques such as Clustering, Classification, Regression, SVM, Random Forest, Gradient Boosting, among others.
  • Seasoned in developing diverse Tableau Reports and adept at tailoring data models to specific requirements, unlocking valuable insights crucial for strategic decision-making.
  • Experienced in Amazon Web Services (AWS) and Cloud Data Management, specializing in crafting and developing rich Power BI Dashboards.
  • Proficiency in developing data applications for Windows and macOS environments, backed by strong problem-solving, analytical, communication, and teamwork skills.

Overview

4
4
years of professional experience
5
5
years of post-secondary education

Work History

Data Engineer

Accenture
01.2023 - Current

Data Engineer

Dell Technologies
05.2020 - 07.2022
  • Involved in the creation of tables, indexes, sequences, and constraints and created stored procedures that were used to implement business rules
  • Designing effective ETL architecture that matches the requirement and provides the required outputs Developed Unit Test
  • Cases to ensure successful execution of the data loading processes
  • Actively involved and interacted with Business Analysts while preparing technical design documents and Functional Design specifications
  • Work closely with the business team in gathering the data requirements
  • Preparation of High- and Low-Level design documents based on the business logic and requirements
  • Migration of ETL jobs onto testing and preproduction repository environments
  • Prepared various mappings to load the data into different stages like Landing, Staging, and Target tables
  • Involved in the creation of tables, indexes, sequences, and constraints and created stored procedures that were used to implement business rules
  • Mapped data from various source systems such as Excel and Flat files into the SQL 2012 server target staging database
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability

Data Engineer

Siva Krishna Chava
  • Collaborated with cross-functional teams to design and develop scalable data pipelines and ETL workflows, ensuring efficient data extraction, transformation, and loading processes
  • Implemented robust data integration solutions using Python, SQL, and ETL tools such as Alteryx, resulting in improved data accuracy and reduced processing time
  • Worked closely with data scientists and analysts to understand data requirements and provide optimized data structures for analytics and reporting purposes
  • Developed and maintained data models, schemas, and database architecture using technologies like Mongo DB, MySQL
  • Oracle, and Google Big Query
  • Implemented and optimized data quality checks, data validation rules, and error-handling mechanisms to ensure data integrity and reliability
  • Utilized big data processing frameworks like Data bricks, Apache Spark, and Hadoop to handle large-scale data processing and analysis
  • Collaborated with the infrastructure team to design and optimize data storage solutions, leveraging cloud technologies like
  • AWS and Google Cloud Platform
  • Conducted performance tuning and optimization of data workflows and database queries, resulting in improved efficiency and reduced latency
  • Implemented and maintained version control systems such as Git and SVN for efficient code management and collaboration
  • Generated, authored, and executed SQL scripts to implement critical database changes in the healthcare domain, including table updates, index additions, and creation of views and stored procedures
  • Contributed to the creation, testing, and implementation of triggers, stored procedures, and functions at the database level using PL/SQL, ensuring seamless data handling within the healthcare domain
  • Manipulated, cleansed, and processed healthcare data using Excel, Access, and SQL.

Education

Master of Science - Computer Science

University of Bridgeport
08.2022 - 12.2023

Bachelor - Civil Engineering

Jawaharlal Nehru Technological University
07.2015 - 04.2019

Skills

Technical Skillsundefined

Timeline

Data Engineer

Accenture
01.2023 - Current

Master of Science - Computer Science

University of Bridgeport
08.2022 - 12.2023

Data Engineer

Dell Technologies
05.2020 - 07.2022

Bachelor - Civil Engineering

Jawaharlal Nehru Technological University
07.2015 - 04.2019

Data Engineer

Siva Krishna Chava
Siva Krishna Chava