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

VENKAT SAI CHARAN KOVI

Bloomington

Summary

Results-driven Data Engineer with expertise in big data processing, ETL development, and cloud technologies (AWS, Azure, GCP). Skilled in designing scalable data pipelines, optimizing SQL performance, and implementing data governance strategies. Strong background in data warehousing, BI visualization (Tableau, Power BI), and machine learning applications. Experienced in networking, IT support, Active Directory management, and cloud security, ensuring smooth infrastructure operations. Adept at troubleshooting network issues, managing IT ticketing systems (ServiceNow), and supporting enterprise hardware deployments. Passionate about leveraging data engineering best practices and analytical solutions to enhance enterprise decision-making and healthcare analytics. Holds a Master’s in Business Analytics (Healthcare Analytics) from Lewis University and a Bachelor’s in Computer Science Engineering.

Overview

6
6
years of professional experience
1
1
Certification

Work History

AWS Data Engineer

Devoir Software Solutions
Indianapolis
09.2022 - Current
  • Company Overview: Client: Eli Lilly
  • 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 APIs and integrating into databases
  • Provided global thought leadership in analytics solutions to benefit customers
  • Configured high availability solutions using replication technologies like Mirroring
  • Built interactive dashboards using Tableau and Power BI, enabling stakeholders to gain actionable insights
  • 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 AWS Redshift or RDS
  • Developed and maintained data pipelines for large-scale data storage in AWS S3 buckets
  • Led a cross-functional team of data engineers and scientists, fostering collaboration across departments
  • Implemented automated monitoring for data flows using CloudWatch and AWS Lambda
  • Architected solutions for migrating legacy systems to cloud-native architectures using API Gateway, Lambda, and DynamoDB
  • Designed cost-effective cloud solutions meeting customer requirements
  • Developed and implemented cloud-based solutions using AWS services
  • Created PySpark and SparkSQL scripts to apply business rules after data preprocessing
  • Conducted meetings with stakeholders to gain insights and improve data-driven decision-making
  • Designed and developed Tableau and Power BI dashboards for visual analytics
  • Managed the transition of data flow from Oracle to Redshift using AWS Athena and S3
  • Designed and developed cubes utilizing Microsoft Visual Studio with SSAS
  • Designed and implemented custom resources for efficient AWS deployments
  • Optimized SQL queries and database schemas for improved performance
  • Configured and maintained cloud-based data infrastructure on AWS, Azure, and Google Cloud
  • Managed CI/CD pipelines using Git, Docker, and Jenkins
  • Participated in agile development, contributing to sprint planning and stand-ups
  • Implemented data visualization tools for enhanced business insights
  • Developed scalable data pipelines using Python, SQL, Talend, Informatica, and Airflow
  • Client: Eli Lilly

Network Analyst / IT Support Specialist

HCL Technologies
Chennai
06.2019 - 08.2021
  • Company Overview: Client: Exxon Mobil
  • Provided IT support and had ticketing system knowledge for resolving technical issues efficiently
  • Resolved customer service requests related to networking issues
  • Installed and repaired network fiber optic cables, Ethernet cables, and networking cabling
  • Monitored and upgraded network servers, operating systems, and applications
  • Assessed network vulnerabilities and implemented risk mitigation
  • Evaluated LAN and WAN performance for troubleshooting network problems
  • Trained teams in emerging network technologies
  • Audited firewall rulesets to align with security policies
  • Configured routers, switches, firewalls, and optimized network security
  • Managed and troubleshot server print queues and local print queues to ensure seamless printing operations
  • Navigated and managed Organizational Units (OUs) in Active Directory, retrieved and modified attributes, and performed password resets and account unlocks
  • Managed two-factor authentication (2FA) policies and device compliance through Microsoft InTune
  • Configured and deployed iOS devices (iPhones/iPads), including setting up new devices, resetting iTunes accounts, restoring network settings, and performing backup/restoration
  • Provided technical support and troubleshooting for Cisco WebEx, MS Teams, and Cisco Presence video conferencing solutions
  • Diagnosed and resolved internal vs
  • External network issues, including VPN connectivity, LTE networks, and Wi-Fi troubleshooting
  • Resolved application issues related to account permissions, compatibility settings, and browser vs
  • Installed application performance
  • Created and maintained Knowledge Base Articles (KBAs) to document and resolve networking issues, software installations, and system configurations, improving team efficiency
  • Developed and updated KBAs for common IT incidents and service requests, ensuring consistency in troubleshooting across the support team
  • Delivered remote support via Microsoft Remote Assistance (MSRA), Remote Desktop Protocol (RDP), MS Teams, and WebEx
  • Installed, configured, and deployed enterprise hardware to support corporate IT infrastructure
  • Managed IT service requests and incidents through ServiceNow ticketing system, ensuring timely ticket assignment and resolution
  • Provided VPN configuration support for remote users
  • Managed and resolved Windows installation issues, ensuring system configurations met user and organizational requirements
  • Provided support for software installations, troubleshooting installation errors, and ensuring proper software functionality across various systems
  • Collaborated with cross-functional teams to create clear, accurate, and actionable KBAs, enhancing overall user experience and reducing resolution times
  • Regularly reviewed and updated KBAs to reflect the latest system updates, network configurations, and best practices
  • Maintained documentation regarding all network infrastructure changes
  • 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
  • Client: Exxon Mobil

Education

Master of Science - Business Analytics (Healthcare Analytics)

Lewis University
Romeoville, IL
05.2023

Bachelor of Science - Computer Science Engineering

Sathyabama Institute of Science and Technology
Chennai, India
05.2019

Skills

  • Programming: Python, Java, SQL, C
  • Big Data Technologies: Hadoop, Apache Spark, PySpark, Kafka
  • Databases: MySQL, PostgreSQL, Redshift, NoSQL (MongoDB, DynamoDB)
  • Cloud & DevOps: AWS (S3, Lambda, Redshift, Glue, Athena), Azure, Google Cloud, Docker, Kubernetes, Terraform
  • Data Engineering: Data Modeling, Data Warehousing, ETL Development, Data Pipelines, Data Governance
  • Visualization & BI: Tableau, Power BI, D3js, Looker
  • Networking & IT Support: Active Directory, VPN, Wi-Fi, LTE, Network Troubleshooting, Remote Desktop (RDP), Microsoft Remote Assistance (MSRA)
  • Device & Endpoint Management: Microsoft InTune, iOS Device Management (iPhones/iPads), Two-Factor Authentication (2FA), Mobile Device Backup & Restore
  • Collaboration & Video Conferencing: Cisco WebEx, Microsoft Teams, Cisco Presence
  • IT Service Management: ServiceNow, IT Ticketing Systems
  • Hardware & Printer Administration: Print Server Management, Printer Queue Troubleshooting
  • Security & Access Management: Password Resets, Account Unlocks, User Permissions
  • Other Tools: Airflow, Talend, Informatica, Git, Jenkins, API Development, Splunk

Certification

  • Google IT Support – Google & Coursera
  • Spark and Python for Big Data with PySpark – Udemy
  • SQL for Data Analytics and Business Intelligence – Udemy
  • 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

Projects

  • Healthcare Data Breach Analysis Using Business Intelligence Models, Led a team in developing a business intelligence and decision-making model using the Major US Health Data Breaches dataset from Kaggle to analyze breach patterns and risk factors. Directed project planning, execution, and monitoring while overseeing data collection, preprocessing, and integration using Excel and WEKA. Managed data analysis and visualization efforts using Tableau, applying quantitative business methods to derive actionable insights. Developed and implemented a database solution utilizing SQL Server and Visual Studio for efficient data storage and retrieval. Applied association rule mining and clustering techniques in WEKA to identify breach patterns and correlations. Conducted performance evaluation and validation to ensure model accuracy and reliability. Designed a data warehouse model to streamline breach data storage and analysis. Presented project findings at departmental meetings, receiving positive recognition for innovative approaches to breach prevention. Received accolades for leadership and project management, enhancing the project's impact within the academic community.
  • Spam Mail Detection and Prevention at Server Side, Developed an innovative spam filtering approach integrating collaborative filtering with semantics-based text classification to enhance detection accuracy and efficiency. Implemented machine learning algorithms such as Latent Dirichlet Allocation (LDA) and Support Vector Machine (SVM) for spam classification. Designed and developed a web application prototype resembling Gmail to demonstrate the effectiveness of the proposed method. Conducted feature selection by extracting semantic meanings from text content to improve classification accuracy. Evaluated the accuracy and performance of the implemented algorithms, ensuring superior results compared to traditional spam filters. Collaborated with team members to analyze results, optimize the approach, and propose further enhancements. Applied natural language processing (NLP) techniques to improve text classification and filtering capabilities. Gained expertise in collaborative filtering methodologies and their application in spam detection. Developed proficiency in web application technologies, including HTML, CSS, and JavaScript, for building the prototype. Achieved notable results in spam detection, demonstrating improved efficiency and accuracy through the innovative approach.

Languages

English
Full Professional

Publications

Venkat Sai Charan K. Spam Mail Detection and Prevention at Server Side. Innovations in Power and Advanced Computing Technologies (i-PACT) 2019, IEEE, Vellore, India, March 22–23, 2019. DOI: 10.1109/i-PACT44901.2019.8959960. ISBN: 978-1-5386-8190-9.

References

References available upon request.

Timeline

AWS Data Engineer

Devoir Software Solutions
09.2022 - Current

Network Analyst / IT Support Specialist

HCL Technologies
06.2019 - 08.2021

Master of Science - Business Analytics (Healthcare Analytics)

Lewis University

Bachelor of Science - Computer Science Engineering

Sathyabama Institute of Science and Technology
VENKAT SAI CHARAN KOVI