VENKATA SAI PRAVALLIKA DHANEKULA
www.linkedin.com/in/venkata-sai-pravallika-dhanekula
Summary
- Proven track record in enhancing database solutions and migrating systems to Azure for Tata Consultancy Services, showcasing expertise in Azure, java development and Big Data technologies. Demonstrated ability to streamline processes and foster interdepartmental communication, underscoring technical proficiency and collaborative skills. Achieved significant improvements in data infrastructure efficiency and project execution.
- Proficient Assistant System Engineer with 1 years of experience using monitoring tools to troubleshoot performance systems and network alerts. Skilled at generating reports and performing physical equipment movement requests. Articulate communicator committed to exceeding service level goals.
- Results-driven Data Engineer with over 2 years of experience utilizing Azure cloud technologies to deliver scalable and efficient data solutions data pipelines.
- Experienced at managing and analyzing large datasets using data processing frameworks such as Data bricks and Apache Spark. Proficient in database management using MySQL, Oracle DB, SQL, and PLSQL, assuring data integrity, retrieval, and optimization. Expertise in leveraging Azure Cloud technologies to optimize data processing, storage, and migration activities, resulting in efficient and scalable solutions.
- Extensive knowledge in using AWS Glue And Azure Data Factory an ETL solution, to automate data extraction, transformation, and loading operations. This knowledge guarantees that data is seamlessly integrated across a wide range of systems and platforms.
- Strong grasp of Data Structures and Algorithms, Relational Database Management Systems, and Object-Oriented Programming across Windows, MacOS, and Linux environments.
- Utilized Skilled in data visualization and reporting using Power BI and Tableau.
- Utilized Snowflake cloud-native data warehousing capabilities, leveraging Azure infrastructure to design and implement scalable data storage solutions.
Proficient Assistant System Engineer with [Number] years of experience using monitoring tools to troubleshoot performance systems and network alerts. Skilled at generating reports and performing physical equipment movement requests. Articulate communicator committed to exceeding service level goals.
Overview
2
2
years of professional experience
Work History
Assistant System Engineer
Tata Consultancy Services
10.2021 - 12.2022
- Worked For client USAA(United Services Automobile Association) which is a financial services company providing insurance and banking products exclusively to members of military, veterans and their families.
- Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL.
- Migrate data from traditional database systems to Azure databases.
- Working experience on NoSQL databases like HBase, Azure, MongoDB, and Cassandra with functionality and implementation.
- Design and implement migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate, other third-party tools.
- Experience in DWH/BI project implementation using Azure Data Factory.
- Interacts with Business Analysts, Users, and SMEs on elaborating requirements.
- Design and implement end-to-end data solutions (storage, integration, processing, visualization) in Azure.
- Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL.
- Propose architectures considering cost/spend in Azure and develop recommendations to right-size data infrastructure.
- Setup and maintain the Azure SQL Database, Azure Analysis Service, Azure SQL Data warehouse, Azure Data Factory, Azure SQL Data warehouse.
- Provided timely technical support to end-users, resolving issues quickly and effectively.
- Streamlined communication between departments, assisting in the design and implementation of an interdepartmental messaging system.
- Assisted in the planning and execution of large-scale IT projects, ensuring timely completion within budget constraints.
- Established backup protocols for critical data, minimizing potential losses due to unforeseen events or failures.
- Developed conceptual solutions & create proofs-of-concept to demonstrate viability of solutions.
- Implement Copy activity, Custom Azure Data Factory Pipeline Activities.
- Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell.
- Proficient with Azure Data Lake Services (ADLS), Databricks & Python Notebooks formats, Databricks Delta lakes & Amazon Web Services (AWS).
- Orchestration experience using Azure Data Factory, Airflow 1.8 and Airflow 1.10 on multiple cloud platforms and able to understand process of leveraging Airflow Operators.
Data Engineer Intern
RNIT Solutions And Services
11.2020 - 07.2021
- Provided support to RAC as well as standalone OLTP and data warehousing databases on Oracle.
- Experienced with creating new Oracle database environments and providing end to end support to development teams depending on applications' needs.
- Supported efficient data migration processes by designing and implementing robust ETL procedures, ensuring minimal downtime during transitions.
- Experienced with P.LSQL programming for developing applications on databases. Developed PLSQL procedures, functions, triggers, and packages as per application need.
- Automated database health checks and daily operations using Python programming and Unix Shell scripting.
- Developed UNIX Shell scripts for generating HTML email alerts for various performance and monitoring metrics of databases.
- Developed bash scripts to identify database growth periodically and took necessary actions by contacting application developers for either archiving data or purging unwanted data from the production environment.
- As a part of performance management, identified long running jobs and user application queries and accordingly took necessary actions. Identified server and memory level bottlenecks. Helped application developers in resolving their database performance related issues.
- Experienced with identifying worst performing SQLs and fixed them with the help of development Teams. Periodically run automated scripts that show long running queries' reports and thereby understand the performance issues in the databases. Discussed the same with the development teams and took necessary actions such as tuning queries, changing queries, indexing tables, or purging unwanted data from tables.
- Worked on application developers' change requests to roll out the development changes in production.
- Developed Spark ETL scripts that collect application data and store into HDFS.
- Developed Spark jobs to load the database log files from Linux file system to the HDFS for further processing. Also, developed bash scripts for importing the Oracle database tables to HDFS using Soop.
- Performed database installation, upgrade, PSU, CPU, Bugfix patching. Worked on managing disaster recovery (DR) databases and carried out DR drills.
- Increased automation in reporting processes by designing dynamic dashboards using visualization tools like Tableau or Power BI.
- Advocated for a culture of continuous improvement by conducting regular code reviews and suggesting improvements where applicable.
- Facilitated seamless integration between disparate systems by developing robust APIs for efficient data exchange between applications.
- Achieved faster query response times through the implementation of appropriate indexing strategies in databases.
Education
Master of Science - Computer Science
Wichita State University
Wichita, KS05.2024
Bachelor of Technology - Computer Science & Engineering
DVR & Dr.HS MIC College Of Technology
India 07.2021
Skills
- Cloud Providers : Azure, AWS
- Big Data Technologies : Hadoop, HDFS, Map Reduce, Apache Spark, Kafka
- ETL Tools : Azure Data Factory, AWS Glue
- Reporting and Scheduling Tools : Power BI, Tableau
- Programming Languages : C, Python,Core Java ,J2EE,C ,PySpark ,SparkSQL,JavaScript, TypeScript
- Web Technology : HTML, CSS, Bootstrap, jQuery,CSS, ReactJS, NodeJS
- Databases : MySQL, MongoDB, Azure SQL database, AWS RDS, SQLite
- Source Code Management and ticketing Tools : Eclipse, Jupyter, Anaconda, GitHub, JIRA ,Splunk
- Concepts : Data Structures and Algorithms, Relational Database Management System, Object-Oriented Programming
- Operating System: Windows, MacOS, Linux (RedHat, CentOS, Ubuntu)
Timeline
Assistant System Engineer
Tata Consultancy Services
10.2021 - 12.2022
Data Engineer Intern
RNIT Solutions And Services
11.2020 - 07.2021
Master of Science - Computer Science
Wichita State University
Bachelor of Technology - Computer Science & Engineering
DVR & Dr.HS MIC College Of Technology
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Shobha IrikireddyShobha Irikireddy
Accountant at Vijay Mining Pvt LtdAccountant at Vijay Mining Pvt Ltd