Summary
Overview
Work History
Education
Skills
Timeline
Generic

KOCHERLA SHALINE SREEMATI

Houston

Summary

Positive, analytical problem-solver with strong foundation in data systems and processes. Possesses solid understanding of data modeling and database design, coupled with skills in SQL and Python. Capable of driving data-driven decision-making and improving data infrastructure.

Experienced with machine learning, and data visualization. Uses Python to develop and interpret complex data sets for actionable insights. Strong understanding of team collaboration and adaptability in fast-paced environments.

Overview

9
9
years of professional experience

Work History

Sr Developer

The Home Depot
08.2022 - Current
  • Worked with Vertex AI (gemini model) to build prompts for ticket categorization project (Customer feedback Queue in Zendesk ), and also worked on getting top key words from product reviews (for UGC team)
  • Worked with tf-idf, sentence transformer, bert embeddings
  • Worked with K-neighbor, Bert, SVM, Xg-boost,LinearSVC classification models to determine the ticket category
  • Responsible for building and maintaining DPO (Digital Portal Content) website using python
  • Write code in the Django framework to build automation tools and APIs
  • Creating and maintaining GBQ (google big query) tables
  • Build python scripts to do web crawling through Home Depot official website to generate reports on the product level/ product collection level etc
  • Write code to extract data from graphQL - API and dump it into Google big query tables
  • Help other teams in organization to cut labor hours by writing automation python scripts/tools that reduce manual work hours
  • Work with zendesk api and build automation python scripts to automatically change ticket status and send responses and emails
  • Work with Bazaarvoice api to build vendor specific analytics reports
  • Attending daily stand-ups, team meetings
  • Conducting seminars on projects to fellow peers and managers
  • Helping the offshore team by building automation python scripts to send responses and update status of customer feedback zendesk tickets
  • Writing python automation web scraping scripts using graphQl-API to generate brand product level reports to help brand advocates in their analyzation and decisions making based on the data
  • Generating reports by writing scripts to helping various (COPS, HOPS )teams analyze the reports
  • Helping UGC team by building a brand level products report with product reviews and overall product performance using Django framework so that it gives more insight and recommendations to the vendors


Software Engineer-II

O'Neil Digital Solutions
10.2019 - 08.2022
  • Responsible for building new projects in Python, using SQLAlchemy, Alembic and flask using OOP’s, and OORM Concepts
  • Responsible to deploy Python Project to production and staging by running CI/CD Jobs in Gitlab
  • Responsible to create controllers and points using marshmallow, and schedule automation jobs using scheduler
  • Responsible for developing SQL Server Integration Services (SSIS) packages in Visual Studio by writing C# scripts
  • Designing and creating relations between SQL/PostgreSQL tables like one to one, one to many, etc
  • Writing C# scripts, SSIS packages to extract XML/Excel/CSV/text/JSON file type data into SQL/PostgreSQL tables by mapping columns with the Raw data
  • Writing complex SQL stored procedures to create data pipelines and generate required output
  • Writing Bash scripts to automate data migration from one database environment to the other database environment
  • Performing ETL data transformations, using SSIS and SQL Server to generate member specific requested pdf documents
  • Automating the process to post generated Print Files (pdf files) to the client on a website called “OneSuite” (an O’Neil Product)
  • Responsible for maintaining the backend of the OneSuite website and automating the process of sending print files to the production floor in our office to print and mail
  • Handling daily production issues, investigating the cause for the bugs and fixing them by making code changes
  • Automating the process of creating manifest files, summary completion reports, monthly SLA reports
  • Working with Jira ticketing systems, following agile methodology for project development, attend regular scrum meetings
  • Expertise in using GitLab and flyway as open-source database-migration tools
  • Attending meetings with CSM (Client Service Manager) and discussing new projects and improvements

IT Apprentice (Internship)

O'Neil Digital Solutions
07.2019 - 09.2019
  • Acquired hands on experience with the internal framework called “Job Scheduler” programmed using bash script, SQL, SSIS and C#
  • Worked on writing C# and SQL scripts to assign Barcodes for validation purposes on the production floor (Printing Machine Floor), using SQL Server Integration Services (SSIS) packages in Visual Studio
  • Worked on daily production issues, finding the root cause of the issue and fixing it by proposing a solution

Teaching Assistant

University of North Texas
08.2018 - 05.2019
  • Worked as a Teaching assistant for course Principles of Systems Programming (CSCE3600) at University of North Texas under Professor Mark Thompson
  • I taught C, Bash Scripts to students
  • Graded assignments and projects, conducted Recitation labs, used GitLab to grade student’s projects
  • I Learned different ways of solving a problem as I got to see different solutions (coding) for one problem.

Application Developer Intern

Smart Bridge IoT Private limited
02.2016 - 07.2016
  • Company Overview: (It is an Internet of Things (IOT) based Startup Company, it builds up smart solutions by analyzing the problem)
  • Worked on Project “Smart Allergen Notification System”
  • A device which detects the allergens in the air and notifies it to the user with the help of an android application
  • Developed an android application using android studio for user interface with IoT devices
  • Through this android application, the user is asked to input the safe limits and by using SQLite, stored these values to phone storage which acts as a database
  • Android application will fetch the data from ThingSpeak Cloud by using ThingSpeak API, here the data is from sensors which is stored on ThingSpeak Cloud
  • Lastly, I wrote Java code in an android application to check if the data is greater than the safe limits from the user and notifying the user by generating android notifications accordingly

Education

Master of Science - Computer science

University of North Texas
Denton, Texas
05.2019

Bachelor of Technology - Computer Science

Sreenidhi Institute of Science And Technology
Hyderabad, Telangana
05.2017

Skills

  • Languages: C, C, Java, Python, C#, PHP, JavaScript, embedded C, CSS, HTML, Reactjs
  • Framework: Django, Spring Boot Framework, Flask
  • Python API knowledge: SQLAlchemy, Alembic
  • GitHub, GitLab
  • IDE Platform: Jypytor Eclipse, Arduino IDE, Anaconda, PyCharm, Visual Studio, Android Studio
  • Database: MS SQL Server, GBQ
  • Mobile App Designing: Android application development
  • Internet of Things (IOT)
  • Cloud Platform Services: GCP, Vertex AI ,GBQ,AWS Lambda, Glue, EMR, S3, EC2
  • Data Analysis Tools: Power BI

Timeline

Sr Developer

The Home Depot
08.2022 - Current

Software Engineer-II

O'Neil Digital Solutions
10.2019 - 08.2022

IT Apprentice (Internship)

O'Neil Digital Solutions
07.2019 - 09.2019

Teaching Assistant

University of North Texas
08.2018 - 05.2019

Application Developer Intern

Smart Bridge IoT Private limited
02.2016 - 07.2016

Bachelor of Technology - Computer Science

Sreenidhi Institute of Science And Technology

Master of Science - Computer science

University of North Texas

Similar Profiles

CREATE PROFILE
KOCHERLA SHALINE SREEMATI