Likith Kumar Lingutla

Project 1 Description:

Applications: Mainframes,Email,Excel,Sharepoint

Nature of work: Development

• The process begins by receiving an input file from the business team and logging into the system to run a transaction and enter specific fields from the file.
• The system displays details which are read and adjustments are made using the Teller Cash matrix table from the PDD stored on the shared drive.
• After adjustments, the process moves to the Mainframe system where regions are run and relevant data is copied.
• Data calculations are performed again in the Mainframe to ensure alignment with the input file before updating the data.
• Once a record is completed, the process loops to pick the next record and repeats the entire sequence until all records are processed.

Project 2 Description:

Applications: SAP, Email, Excel,PDF

Nature of work: Development

• The automation bot launches the SAP system and executes 3 specified transaction codes to download a total of 6 Excel files containing end-of-day data.
• Once all Excel files are downloaded, the bot extracts data from specific fields within these files for further analysis.
• The extracted data undergoes further processing and analysis to generate a detailed reconciliation report.
• The extracted data undergoes processing to generate detailed reconciliation information, ensuring accuracy and completeness.
• This extraction and processing cycle repeats until all relevant records are processed completely.
• Upon completion, the bot consolidates the processed data and delivers a comprehensive final report to the business stakeholders for review and action.

Project 3 Description:

Applications: SAP,Email,Excel,Desktop Applications

Nature of work: Development

• Extract data from SAP’s 'PR vs PO' transaction code for the last 2 years in 6-month intervals.
• Perform Excel operations and data cleansing on extracted data before uploading to the database.
• Extract data from 'SAP_CHANGE_LOG,' perform Excel processing, and upload to the database.
• Use an Excel list of plant names to extract, process, and upload data from 'AUTO_PO_POSS' to the database.
• Extract data from 'PO_DATA,' apply VLOOKUP and other Excel operations, upload to temporary tables, then transfer data to the main table in the database.