Amit Rawat

Computer Science master’s student seeking challenging work opportunities that allow me to continue learning and developing. Strong technical proficiency with work history as an IT Consultant. In-depth knowledge of programming and database languages. Strong work ethic and dedication to quality assurance. Adept at collaborating with teams or independently in fast- paced settings.

SCI Group Inc. Etobicoke, ON 

Application Services Intern May 2022 – December 2022

• Implemented Shopify store for SCI clients using REST API (Node.js and XML)
• Data cleansing and processing on the SCI’s client raw data using SQL and Excel.
• Prepared SQL scripts for SAP team to work on data extraction and for business needs.
• Analyzed data growth and archive objects in SAP using SARA, SARI and ILM.
• Combined data from multiple data sets and developed financial reports for forecasting and results analysis.
• Researched for a Webapp for customers to place and ship orders to various locations according to their needs.
• Designed Business Required Documents, Technical Design Documents and UI Design Documents for different initiatives.

Oracle Technical Consultant September 2019 – August 2021

• Fixed Technical issues on Reports, Invoices and Orders in Oracle e-Business Suite Applications (R12, 11i).
• Involved in writing PL/SQL Triggers, Procedures, Functions and Packages.
• Developed SQL scripts and PL/SQL APIs to load the legacy data from databases to Oracle Application.
• Hands-on experience in Data Conversion, Data Migration and Data Analysis using SQL within different modules in Oracle.
• Prepared and reviewed the technical/functional documentation e.g., technical design documents (MD070) and Migration documents (MD0120).
• Assisted in day-to-day activities of production support of Oracle environment in AP, AR, GL, PO, OM and INV.
• Collaborated with a team of two interns to develop time-efficient new scripts for the technical team. 
• Worked with the Business user / leads / SME to recognize their needs and meet them while consistently meeting deadlines.

IT Intern May 2018 - July 2018

• Authored a research paper on a device Head Mounted Display using Augmented Reality. 
• Created coding manuals for departmental research projects.
• Wrote SQL scripts to analyze data with BEL customers and perform specific data queries for business needs.
• Analyzed financial statements, business summary reports, and dashboard to attain data based on product comparable percentages and penetration rates for Finance manager, increasing company efficiency using SQL and Excel.

University of New Brunswick Fredericton, NB

Masters in Computer Science Graduation Date: April 2023

Sharda University Greater Noida, Uttar Pradesh

Bachelors in Computer Science Graduation Date: June 2019