Summary
Overview
Work History
Education
Skills
Certification
Languages
Projects
Conference Presentations
Activities
Languages
Publications
References
Timeline
Generic

Venkat Sai Charan Kovi

Bloomington,IN

Summary

Results-driven Data Engineer with a strong track record in delivering high-quality data solutions. Expertise in big data processing frameworks like Hadoop and Apache Spark, complemented by advanced SQL management and data visualization skills using Tableau. Known for outstanding problem-solving capabilities and effective collaboration in fast-paced environments, leading innovative initiatives that enhance operational efficiency. Dedicated to utilizing technical proficiency to support organizational objectives and improve decision-making processes.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Data Engineer

Devoir Software Solutions | Client: 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 interactive dashboards using Tableau and Power BI, enabling stakeholders to gain actionable insights from complex datasets
  • 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
  • Designed and developed Tableau and Power BI dashboards to provide visual analytics and reporting for data insights
  • 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
  • Optimized SQL queries and database schemas for performance improvements in data retrieval operations.
  • Configured and maintained cloud-based data infrastructure on platforms like AWS, Azure, and Google Cloud to enhance data storage and computation capabilities.
  • Managed version control and deployment of data applications using Git, Docker, and Jenkins.
  • Participated in agile development processes, contributing to sprint planning, stand-ups, and reviews to ensure timely delivery of data projects.
  • Developed and implemented data models, database designs, data access and table maintenance codes.
  • Implemented data visualization tools like Tableau and Power BI to create dashboards and reports for business stakeholders.
  • Designed, constructed, and maintained scalable data pipelines for data ingestion, cleaning, and processing using Python and SQL.
  • Streamlined data flow from diverse sources using ETL tools such as Talend, Informatica, and Airflow.

Network Analyst

HCL Technologies | Client: Exxon Mobil
Chennai, Tamil Nadu
06.2019 - 08.2021
  • Resolved customer service requests related to networking issues in a timely manner.
  • Installed and repaired network fiber optic cables, Ethernet cables and other networking cabling and conduits.
  • Monitored and performed hardware and software upgrades to network servers, operating systems and applications.
  • Assessed networks and systems to identify weaknesses and implemented fixes for risk mitigation.
  • Evaluated local area network (LAN) and wide area network (WAN) performance data to verify availability and speed, identifying network problems.
  • Trained team members and users in newly implemented and emerging technology to enhance business productivity.
  • Audited firewall rulesets periodically to ensure they are up-to-date with current security policies.
  • 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
  • Compiled data from various sources into comprehensive reports using Microsoft Excel.
  • Created spreadsheets using Microsoft Excel for collecting data for use in estimating property values.
  • Created spreadsheets using Microsoft Excel to track performance metrics across the unit.
  • Created reports using software such as Microsoft Excel, Access, SQL Server Management Studio.

Education

Master of Science - Business Analytics

Lewis University
Romeoville, IL
05.2023

Bachelor of Science - Computer Science Engineering

Sathyabama Institute of Science And Technology
Chennai, India
05.2019

Skills

  • MS-Word
  • MS-PowerPoint
  • Excel
  • C
  • JAVA
  • End-user support
  • Tableau
  • Power BI
  • Network operations
  • System Upgrades
  • Analytical Thinking
  • Documentation And Reporting
  • NoSQL Databases
  • Data Modeling
  • Data Warehousing
  • Data Security
  • Performance Tuning
  • 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
  • SQL expertise
  • ETL development
  • Data pipeline design
  • Data warehousing
  • Hadoop ecosystem
  • Performance tuning
  • NoSQL databases
  • Data security
  • Data integration
  • Data modeling
  • Data governance
  • Data quality assurance
  • API development
  • Data migration
  • Spark framework
  • Big data processing

Certification

  • Google IT Support by Google on Coursera
  • Udemy Spark and Python for Big Data with PySpark
  • Udemy SQL-MySQL for data Analytics and Business Intelligence
  • 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
  • English writing proficiency - certified by Aspiring minds

Languages

English, Full Professional

Projects

Healthcare data breach analysis using business intelligence models, Led a team in developing a comprehensive business intelligence and decision-making model utilizing the Major US Health Data Breaches dataset from Kaggle. The project aimed to address the increasing threat of data breaches in the healthcare industry through the application of various business intelligence techniques and tools., Leading the team in project planning, execution, and monitoring., Conducting data collection and exploration, as well as preprocessing and integration using Excel and WEKA., Overseeing data analysis and visualization efforts, utilizing quantitative business methods and tools like Tableau., Managing database development and implementation using SQL Server and Visual Studio., Applying association rule mining and clustering techniques using WEKA for pattern identification., Conducting performance evaluation and validation to ensure model accuracy and reliability., Proficiency in data analysis and visualization tools such as Excel, Tableau, and WEKA., Strong command of database management systems, particularly SQL Server., Experience in business intelligence methodologies and techniques., Familiarity with data preprocessing and integration techniques., Knowledge of statistical analysis and predictive modeling., Excellent leadership, communication, and project management skills., Development of a robust business intelligence model providing invaluable insights into breach patterns and risk factors within the healthcare industry., Successful identification of trends and correlations in breach data, empowering proactive measures for breach prevention., Implementation of an efficient data warehouse model, streamlining the storage and analysis of breach data., Presentation of project findings at departmental meetings, receiving positive feedback and recognition for innovative approaches to breach prevention., Receipt of accolades for leadership and project management skills, further enhancing the project's success and recognition within the academic community. Spam Mail Detection and Prevention at Server Side, Developed an innovative approach to combat spam emails by proposing a collaborative filtering strategy combined with semantics-based text classification technology. The project aimed to address the inefficiencies in current spam filtering methods caused by the vast size of vector space and the need for extensive computation., Contributing to the conceptualization and development of the collaborative filtering approach with semantics-based text classification., Participating in the selection of feature terms derived from semantic meanings of text content., Implementing machine learning algorithms such as Latent Dirichlet Allocation (LDA) and Support Vector Machine (SVM) for spam classification., Designing and developing a web application prototype resembling Gmail to demonstrate the effectiveness of the proposed approach., Evaluating the accuracy and performance of the implemented algorithms and collaborative filtering strategy., Collaborating with team members to analyze results, draw conclusions, and propose further enhancements to the approach., Proficiency in machine learning algorithms, particularly LDA and SVM., Experience in natural language processing and text classification techniques., Knowledge of web application development using relevant technologies (e.g., HTML, CSS, JavaScript)., Familiarity with collaborative filtering principles and methodologies., Strong analytical and problem-solving skills., Excellent communication and teamwork abilities., Notable results and achievements in spam email detection through innovative integration of semantics-based text classification and collaborative filtering., Development and successful implementation of a more efficient detection method., Careful selection and utilization of semantic feature terms to streamline the classification process, leading to improved accuracy., Creation of a functional web application prototype resembling Gmail, demonstrating the practicality of the approach., Rigorous evaluation confirming superior performance compared to traditional methods.

Conference Presentations

Spam Mail Detection and Prevention at Server Side, Innovations in Power and Advanced Computing Technologies (i-PACT) 2019, 03/22/19, Vellore, India, IEEE (Institute of Electrical and Electronics Engineers)

Activities

  • Worked as a member of Community Development Club, 02/2016 - 11/2017
  • Attended a 2-day workshop on Android Development at Sathyabama Institute of Science & Technology, 08/2015
  • Visit to a Government school for the purpose of community service, 02/2017
  • Participated in blood donation camp - Gleneagles global health city, 05/2018

Languages

English
Full Professional

Publications

Venkat Sai Charan K. Spam Mail Detection and Prevention at Server Side. In Proceedings of the Innovations in Power and Advanced Computing Technologies (i-PACT) 2019, sponsored by IEEE(Institute of Electrical and Electronics Engineers). Vellore, India. 22-23 March 2019, IEEE Xplore, [DOI: 10.1109/i-PACT44901.2019.8959960],[ISBN: 978-1-5386-8190-9].

https://ieeexplore.ieee.org/document/8959960

References

References available upon request.

Timeline

Data Engineer

Devoir Software Solutions | Client: Eli Lilly
08.2023 - Current

Network Analyst

HCL Technologies | Client: Exxon Mobil
06.2019 - 08.2021
  • Google IT Support by Google on Coursera
  • Udemy Spark and Python for Big Data with PySpark
  • Udemy SQL-MySQL for data Analytics and Business Intelligence
  • 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
  • English writing proficiency - certified by Aspiring minds

Master of Science - Business Analytics

Lewis University

Bachelor of Science - Computer Science Engineering

Sathyabama Institute of Science And Technology
Venkat Sai Charan Kovi