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 SkillsLanguages Python, Tableau, SQLDatabase Management MongoDB, MySQL, SQL Server, SQL/PLSQLData Analysis Techniques Data Analytics, Data Wrangling, Data Exploration, Data Modeling, Data VisualizationTableau, Power BI, Excel, AccessVersion Control Git, GitHubMachine Learning Clustering, Classification, Regression, SVM, Random Forest, Gradient Boosting, etcCloud Data Management AWSMethodologies AgileOperating Systems Windows, macOSOther Oracle Architecture, Oracle EBS Database/Tables, Database Design
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