HIMAJA KUNCHALA

Data Warehousing & Analytics for Food Manufacturer

Project Description - Working with leading food manufacturer client to automate the process of Reporting & Analytics across CSPL (Customer Service, Supply Planning & Logistics) in AMEA (Asia, Middle East, and Africa).

• Streamlined the data collection and analysis process by automating the processes to retrieve, consolidate, and analyse data from various sources.
  
• Created stored procedure to do transformation on the data as per the business requirement.
  
• Created triggers to automate the execution of jobs.
  

Data Warehousing & Analytics for a Ad-Tech Client

Project Description - Create a Data warehouse to help business analyse the performance of their Ad-Space bidding, campaigns and products on different levels.

• Technologies Used – PySpark, SQL, AWS Glue, AWS Lambda, AWS S3, AWS Redshift.
  

Responsibilities –

• Created end to end data pipelines using PySpark, AWS Glue, Docker and AWS Api Gateway.
  
• Created data marts in AWS Redshift, to be further used for data visualization.
  
• Code unit Testing, Integration Testing, Debugging and fixing the issues reported by QA.
  

VERIZON (JAVA APPLICATION SUPPORT):

Project Description: Verizon is an American wireless network operator, it offers mobile phone, telephone and internet services through a variety of devices.

• Technologies used: Java, Cassandra, SQL,Microservices

Responsibilities -

• Involved in Client interaction on regular basis to understand the Business of the Client
• Involved in the Analysis, Design, Coding, modification and implementation of user requirements
• Involved in analysis and providing RCA for the Non prod and production defects.