Summary
Overview
Work History
Education
Skills
Technical Profile
Languages
Certification
Timeline
Generic

SOWMYA DAVULURI

Irving,USA

Summary

Data Engineer with over 5 years of experience in web application development using Python and Django. Proficient in data structures, algorithms, and Python libraries for data science, with hands-on experience in AI/ML and container orchestration. Demonstrated success in optimizing data retrieval processes and developing ETL solutions in AWS Glue, enhancing system efficiency and data management. Strong communicator and collaborative team player, skilled in database design and big data processing frameworks.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Python/Data Engineer

Citigroup
Irving, TX
08.2022 - Current
  • Developed generic code modules and defined strategy to extract data from different Vendors and build ETL logic on top of them.
  • Developed Data pipelines using Lambda Functions to get the policy related data from s3 to aurora RDS on daily basis.
  • Involved in Designing Data Acquisition flow to get data from s3 to snowflake, Created DynamoDB tables for intermittent storage purpose.
  • Working with State Functions and create state machines and architecture to build a serverless application.
  • Building a Scheduled data pipeline using Amazon Event Bridge and configuring the alerts in CloudWatch.
  • Conducted SQL query optimization and indexing strategies, improving data retrieval performance by 50%.
  • Developed Data Pipeline using Glue in Python for Historic Data Load from OnPrem to Cloud.
  • Involved in installing EMR clusters on AWS and used AWS Data Pipeline to schedule an Amazon EMR cluster to clean and process web server logs stored in Amazon S3 bucket and Created monitors, alarms, notifications and logs for Lambda functions, Glue Jobs, EC2 hosts using Cloudwatch.
  • Developed MapReduce/Spark Python modules for machine learning & predictive analytics in Hadoop on AWS. Implemented a Python-based distributed random forest via Python streaming.
  • Worked Closely with DataBase Admin team to solve gitlab deployment errors.
  • Developed a chatbot using the Kore.AI platform to handle customer service workflows and automate responses.
  • Developed a production-ready chatbot using the Kore.AI platform to automate customer service workflows and support operations.
  • Demonstrated strong knowledge and implementation of constructors in object-oriented programming to ensure efficient class initialization and code maintainability.
  • Worked on integrating AI/ML functionalities, including LLMs and Python-based models, within chatbot frameworks for enhanced conversational intelligence.
  • Built scalable data pipelines using AWS Glue and Lambda to process real-time and batch data feeds from multiple sources.
  • Managed infrastructure using Docker and lightweight Kubernetes (K3s), including load balancing with MetalLB and routing via Traefik and Nginx.
  • Deployed services using Kubernetes K3s, with networking and load balancing managed through MetalLB, Nginx.
  • Utilized GPU-based cloud services and LLMs to enhance ML workloads and accelerate inference pipelines.
  • Orchestrated docker container for microservices.
  • Built and maintained RESTful APIs supporting chatbot integration and data applications.
  • Monitored application performance and uptime using AWS CloudWatch and fine-tuned autoscaling policies.
  • Collaborated closely with cross-functional teams to translate business requirements into scalable technical solutions.

Python Developer/Senior Systems Engineer

Infosys LTD
Bangalore, India
05.2018 - 12.2020
  • Involved in building database Model, APIs and Views utilizing Python, to build an interactive web based solution.
  • Developed views and templates with Python and Django's view controller and template language to create a user-friendly website interface.
  • Used Django forms to get vehicle entry and information.
  • Used matplotlib and D3 for viewing trends as part of Financial Analysis module.
  • Worked extensively with Django models as various modules in DMS requires only specific fields from the Master Customer Database.
  • Created restful web services using vehicle and customer information for various banks and insurance companies.
  • Developed entire front end and back-end modules using Python on Django Web Framework.
  • Wrote python modules using Matplotlib, pandas, etc. to embed graphics.
  • Used python pandas module to read CV files to obtain data and store the data in data structures provided in the numpy module.
  • Wrote and executed various MySQL database queries using Python MySQL connector and MySQL dB package.
  • Rewrite existing Java application in Python module to deliver certain format of data.
  • Utilized PyUnit, the Python unit test framework, for all python applications.
  • Used Python and Django to interface with the jQuery Ul and manage the storage and deletion of content.
  • Creating unit test/regression test framework for working with new code.
  • Responsible for debugging and troubleshooting the web application.
  • Managed MySQL content database, security and role management, apply updates and maintain schema and documentation.
  • Used Python's pandas and matplotlib libraries to conduct data exploration and visualization of electricity consumption data.
  • Created Python scripts for analyzing large quantities of data.
  • Maintained detailed databases of energy storage projects and country-specific energy policies.
  • Generated Python Django Forms to record data, login, and signup of users.
  • Built various graphs for business decision making using Python matplotlib library.
  • Utilized standard Python modules such as cv, itertools and pickle for development.
  • Worked on Python OpenStack APIs and used Numpy for Numerical analysis.
  • Responsible for search engine optimization to improve the visibility of the website.
  • Performed different testing methods like Unit testing, Integration testing, web application testing.
  • Migrated older Java-based website to Python/Django.
  • Implemented user interface guidelines and standards throughout the development and maintenance of the website using the HTML, CSS, JavaScript and jQuery.
  • Created data tables to display employee information and add, delete and update details for administrators.
  • Used Query and Ajax calls for transmitting JSON data objects between frontend and controllers.
  • Developed Merge jobs in Python to extract and load data into MySQL database.
  • Implemented the entire back-end in Python for integrating the Application.
  • Managed, developed and designed a dashboard control panel for customers and administrators using Django/Python, MySQL.
  • Responsible for scripting data manipulation using SQL.
  • Used REST API to perform Get and Post methods to obtain and send data from and to backend database.
  • Experience in designing and development of software using Agile development practice.

Education

Masters of Science - Data Science

University of New Haven
West Haven, CT

B. Tech - Electronics and Communication Engineering

ANU University
Guntur

Skills

  • PostgreSQL, MySQL, and SQLite
  • PL/SQL and Dynamic SQL
  • Python programming
  • Data pipeline development
  • Cloud computing and AWS services
  • Data warehousing and ETL processes
  • Data integration and quality assurance
  • Machine learning and predictive modeling
  • Agile methodologies and DevOps practices
  • Data visualization with PowerBI and Matplotlib
  • Cross-functional collaboration and teamwork
  • Effective communication and problem solving
  • Database design and administration
  • Big data technologies including Hadoop ecosystem
  • RDBMS expertise and SQL optimization

Technical Profile

  • PostgreSQL, Sqlite3, MySQL, SQL
  • Plus, IBM DB2, MySQL, PL/SQL, SQL
  • Plus, Dynamic SQL, COBOL, Python, Kafka, Spark, AWS, AWS S3, AWS EMR, Redshift, PySpark, AWS Glue, HTML, CSS, XML, Informatica, Talend, AWS Glue, Databricks, Django, SQL Server Reporting Services, PowerBI, GitHub, Git, MS Office, Windows NT/2000/2003/XP/7/8/10, Linux, UNIX, Crontab, Control-M, Autosys, Predictive modeling, clustering, classification, time-series analysis using Python (Pandas, NumPy, SciPy, Scikit-learn, Matplotlib, Seaborn), Agile (Scrum), CI/CD Pipelines, Git, DevOps, Terraform, Kubernetes, Jenkins, PyCharm, Eclipse, Visual Studio, IntelliJ

Languages

English
Full Professional
Hindi
Native/ Bilingual

Certification

  • Conversation designer - Kore.ai - Jul 2023

Timeline

Python/Data Engineer

Citigroup
08.2022 - Current

Python Developer/Senior Systems Engineer

Infosys LTD
05.2018 - 12.2020

Masters of Science - Data Science

University of New Haven

B. Tech - Electronics and Communication Engineering

ANU University

Similar Profiles

CREATE PROFILE
SOWMYA DAVULURI