Venkat Sai Charan Kovi
Bloomington,IN
Summary
Experienced Data Engineer and Network Analyst with a proven track record of delivering innovative solutions and optimizing network and data infrastructure to meet organizational objectives. Adept at developing data models, implementing ETL processes, and designing cloud-based architectures to enable seamless data integration and analysis. Skilled in optimizing database performance, developing automation scripts, and leveraging AWS services for scalable and cost-effective solutions. Proficient in network security configurations, troubleshooting, and monitoring, with a focus on enhancing connectivity and protecting sensitive information. Strong leadership abilities, demonstrated through successful cross-functional team management and collaboration with stakeholders to implement data-driven solutions. Seeking opportunities to leverage technical expertise and drive business success through strategic IT initiatives.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Engineer
Eli Lilly
Indianapolis, IN
08.2023 - Current
- Developed data models and implemented database designs to optimize data storage and retrieval.
- Optimized existing queries to improve query performance by creating indexes on tables.
- Analyzed user requirements and designed ETL processes for loading enterprise data into the Data Warehouse.
- Created stored procedures to automate periodic tasks in SQL Server.
- Developed Python scripts for extracting data from web services API's and loading into databases.
- Provided global thought leadership in analytics solutions to benefit customers.
- Configured high availability solutions using replication technologies like Mirroring.
- Analyzed business requirements to recommend appropriate database solutions.
- Built various dashboards with interactive visualizations using D3.js library.
- Developed Spark applications on top of Hadoop clusters running on EMR for performing complex analytics operations.
- Created ETL processes using Python scripts to move data from various sources into the target databases on AWS Redshift or RDS.
- Developed and maintained data pipelines to ingest, store, process and analyze large datasets in AWS S3 buckets.
- Performed maintenance tasks such as backups, restores, patching, capacity planning and performance tuning of databases on AWS EC2 instances.
- Led a cross-functional team of data engineers and scientists, fostering collaboration with stakeholders from various departments.
- Implemented automated monitoring for data flows through the use of Cloudwatch and Lambda functions.
- Architected solutions for migrating legacy systems to cloud-native architectures utilizing serverless technologies like API Gateway, Lambda Functions and DynamoDB tables.
- Designed cost-effective solutions that leverage public clouds while meeting customer requirements.
- Developed and implemented cloud-based solutions for clients using Amazon Web Services.
- Created PySpark and SparkSQL scripts to apply business rules once data was cleaned and preprocessed.
- Achieved successful implementation of POC, enhancing Development of Record Retention Policies for data integration project.
- Conducted productive meetings with stakeholders to gain insights into their specific data requirements, facilitating the implementation of effective data-driven solutions for improved decision-making.
- Designed and implemented data pipelines for extracting, transforming, and loading data from multiple sources such as JSON and XML files into a centralized data storage.
- Developed efficient PL/SQL statements and stored procedures in DB2 to facilitate the extraction and writing of data.
- Managed conversion of extensive JSON and XML datasets into organized format to facilitate analysis and reporting.
- Streamlined workflows for provisioning and managing various AWS resources like EC2 instances, RDS databases, and S3 buckets.
- Incorporated Step Functions into AWS services like Lambda, S3, and DynamoDB to construct advanced applications.
- Managed successful transition of data flow from Oracle to Redshift through thorough utilization of AWS Athena and AWS S3.
- Designed and developed cubes utilizing Microsoft Visual Studio with SQL Server Analysis Services (SSAS).
- Utilized Splunk installation and configuration to track real-time application performance metrics, analyzing data from multiple sources including S3 buckets logs.
- Designed and implemented custom resources to streamline the deployment process for infrastructure components on AWS.
Network Analyst
HCL Technologies
Chennai, Tamil Nadu
06.2019 - 08.2021
- Assisted various departments in maintaining network security by configuring remote routers and firewalls.
- Optimized, improved, expanded and upgraded network capabilities and connectivity through network monitoring tools.
- Implemented policies for user authentication, authorization and data encryption.
- Performed daily system monitoring of the networks and reported any irregularities or performance issues.
- Developed, deployed and maintained network infrastructure including routers, switches, firewalls and wireless access points.
- Created detailed reports outlining security threats identified during regular scans of the network environment.
- Monitored system performance metrics to ensure optimal throughput levels were maintained.
- Configured and tested network hardware such as routers, switches, hubs and bridges.
- Provided technical support on LAN and WAN equipment installations, configurations and upgrades.
- Maintained documentation regarding all changes made to the network infrastructure.
- Provided end-user support for network-related issues.
- Installed and repaired network fiber optic cables, Ethernet cables and other networking cabling and conduits.
- Trained staff on proper use of networking technologies.
- Troubleshot LAN/WAN infrastructure to maintain optimal performance.
- Supported remote users through VPN configuration and management.
- Collaborated with IT team on large-scale projects.
- Evaluated local area network (LAN) and wide area network (WAN) performance data to verify availability and speed, identifying network problems.
- Resolved customer service requests related to networking issues in a timely manner.
- Coordinated with vendors on installation of new hardware or software components required by the organization.
- Analyzed software, hardware and network systems for various transmission systems.
- Configured routers, switches, firewalls and other hardware to deploy and manage LAN, WAN and wireless networks.
- Configured and implemented Cisco ASA firewalls to provide clients with comprehensive security, antivirus protection and virtual network capabilities.
Education
Master of Science - Business Analytics
Lewis University
Romeoville, IL05-2023
Bachelor of Science - Computer Science Engineering
Sathyabama Institute of Science And Technology
Chennai, India05-2019
Higher Secondary -
Sri Chaitanya Junior College
Vijayawada, India03-2015
High School Diploma -
Montessori High School
Alampur, India03-2013
Skills
- MS-Word
- MS-PowerPoint
- Excel
- C
- JAVA
- End-user support
- Network operations
- System Upgrades
- Analytical Thinking
- Documentation And Reporting
- NoSQL Databases
- Data Modeling
- Data Warehousing
- Data Security
- Performance Tuning
- Data Migration
- SQL and Databases
- Data Analysis
- Time Management
- Interpersonal Skills
- Task Prioritization
- Adaptability and Flexibility
- Requirements Gathering
- Teamwork and Collaboration
- Problem-Solving
- Technical Support
- Data Mining
- Business process improvement
- Quality Assurance
- Data Interpretation
- Agile Methodology
Certification
- English writing proficiency- certified by Aspiring minds
- Web Application Development-certified by Chennai IT Training Solutions
- Programming with Python in 100 steps- Udemy certified
- Introduction to algorithms and data structures in C++ - Udemy certified
- Android Development for Newbies- Udemy certified
- Fundamentals of digital marketing-Google Certified
Activities
- Worked as a member of Community Development Club (February 2016-November 2017)
- Attended a 2-day workshop on Android Development at Sathyabama Institute of Science & Technology (August 2015)
- Visit to a Government school for the purpose of community service (February 2017)
- Participated in blood donation camp-Gleneagles global health city (May2018)
Languages
English
Full Professional
References
References available upon request.
Timeline
Data Engineer
Eli Lilly
08.2023 - Current
Network Analyst
HCL Technologies
06.2019 - 08.2021
Master of Science - Business Analytics
Lewis University
Bachelor of Science - Computer Science Engineering
Sathyabama Institute of Science And Technology
Higher Secondary -
Sri Chaitanya Junior College
High School Diploma -
Montessori High School
- English writing proficiency- certified by Aspiring minds
- Web Application Development-certified by Chennai IT Training Solutions
- Programming with Python in 100 steps- Udemy certified
- Introduction to algorithms and data structures in C++ - Udemy certified
- Android Development for Newbies- Udemy certified
- Fundamentals of digital marketing-Google Certified
Similar Profiles
Rhonda JACKSONRhonda JACKSON
Expert Reach Operator at Eli LillyExpert Reach Operator at Eli Lilly
RICHARD DEDERTRICHARD DEDERT
Executive Territory Manager at Eli LillyExecutive Territory Manager at Eli Lilly
Houssine OUMOUCHHoussine OUMOUCH
Lead Systems and Network Engineer at Astek GROUP for ELI LILLYLead Systems and Network Engineer at Astek GROUP for ELI LILLY