Surendrareddy Vallem

Project 4

Client : Harley Davidson

Role : Team Member

Team Size : 5

Database : SQL SERVER

Environment : Azure Synapse Analytics

Project Duration : Jan 2023 to till date

Description:

Harley-Davidson, Inc. is an American motorcycle manufacturer headquartered in Milwaukee, Wisconsin, United States. Founded in 1903, it is one of two major American motorcycle manufacturers to survive the Great Depression along with its historical rival, Indian Motorcycles

Responsibilities:

• Developing Pipelines, by using DataFlows, Pyspark Notebooks, Datasets, Linked Services, integrations and flowlets for transferring data from different sources to Azure Synapse Analytics
• Worked on Monitoring pipelines analyzing data flow in pipelines and triggering the pipelines.
• Bugs solving in pipeline as per client requirements.
• Developing pipelines for handling historical data by applying full load and increment logic.

Project 3

Client : TUDA TOWERS

Role : DATABASE DISINER

Team Size : 5

Database : MY SQL

Environment : MySQL workbench

Project Duration : July 2022 to Jan 2023

Description:

TUDA (TIRUPATI URBAN DEVELOPMENT AUTHORITY) proposes the construction of Commercial and Residential towers in Tirupati, the spiritual capital of Andhra Pradesh Proposed site is in the prime location of the city on the junction of 150’ Air bypass road and 60’ Rayalacheruvu road. The project is located in a sprawling area of 3.61 acres. The project contains Commercial spaces spread over the ground and first floors, and office space on 2nd and 3rd floors. Well-crafted Residential apartments (2 BHK, 3 BHK and 4 BHK) are planned on the above from 4th to the 13th floor. The uniqueness of the project is in the planned Sky Gardens on 6th, 11th and 13th floors with a Grand view of Tirumala hills.

Responsibilities:

• Developed database schemas and database tables.
• Providing grants and permissions database tables.
• Developing business logic functions and procedures for daily data updating
• SQL PROCEDURES are called by web applications by using based on date and loading the date in database tables.
• We have created highly logical banking payment methodologies and loaded data in database tables for creating all types of collections in procedures and functions loading all payments in the database maintaining historical data providing reports to customers for view their payments .

Project 2

Client : TUDA

Role : DATABASE DISINER

Team Size : 5

Database : MY SQL

Environment : MySQL workbench

Project Duration : Jan 2021 to July 2022

Description:

The Tirupati Urban Development Authority (TUDA) was formed in the year 1983 and its jurisdiction is increasing from time to time. At present, the Tirupati Urban Development Authority is the 2nd largest in Andhra Pradesh. They are renting TTD buildings and they are collecting rent from a shop owner.

Responsibilities:

• Developed DATABASE SCHEMAS and DATABASE TABLES.
• PROVIDING GRANTS AND PERMISSIONS DATABASE TABLES.
• DEVELOPING BUSINESS LOGIC FUNCTIONS AND PROCEDURES FOR DAILY DATE UPDATING
• SQL PROCEDURES are called by web applications by using based on date and loading the date in database tables with a daily penalty of customers.

Project 1
Client : PEARSON
Team Size : 12
Database : Oracle 11g.
Environment : Oracle EBS R12 (PO, AP, GL, OM, INV)
Project Duration : Jan 2022 to July2022

Description:

Pearson is leading global education company with a rich history of publishing high-quality educational materials for learners of all ages, from early childhood to higher education and professional development. It Creates and publishes textbooks, course materials, digital learning solutions, and assessments across various subjects and disciplines.

Responsibilities:

• Responsible for the Study and Analysis of all enhancement Requirements from users.
• Writing PLSQL subprograms and working on advanced PLSQL.
• Involved in the development of XML publisher reports based on business requirements and registered them in Oracle applications
• Involved in performance tuning.
• Involved in the development of interfaces/Conversions to import data from legacy system into Oracle application base tables.
• Worked on SQL*LOADER for the interfaces and conversions.
  Understanding customer issues.
• Coding and Development of RICE as per Naming and Coding Conventions.