Yash Agarwal Email & Phone Number

Ottawa, ON, CA

Ottawa, Ontario, Canada

Toronto, Ontario, Canada

• Implemented advanced data engineering techniques to optimize the company's internal projects. Along with upskilling in various technologies, was also placed at TD Bank where I worked as a contractor for 13 months.
• The team deployed in an Agile Environment which involved daily stand-ups, sprint planning, and sprint review meetings based on bi-weekly sprints.
• Led the database team for a Payments Project. During the project initiation phase, designed the basic data flow and the overall database structure. Noted different possibilities of the project scope and presented two.
• Integrated with a colleague in learning prompt engineering techniques to develop a model for a client company namedEquitable, which could replicate the Chat GPT 3.5 model, based on the requirements stated by the.

Toronto, Ontario, Canada

• Contributed to mini projects that were ultimately linked to the DART platform – an internal project of the company that the employees of different teams like development, reporting, human resources, finance, and many.
• Performed data ingestion into various tables in SQL Server Management Studio, based on the requirements. These ingestions were performed in two different ways, first using SQL queries and Stored Procedures for minor.
• Compiled Python Scripts to extract data from the databases by setting up successful connections using Python libraries as well as from raw data sources like Excel Sheets (CSV Files). The extracted data was transformed.
• Collaborated with the stakeholders directly to gather all the requirements and identify opportunities for process improvement and data optimization. Also discussed the action plans by providing brief information about.

Ottawa, Ontario, Canada

Ottawa, Ontario, Canada

• Maintained my department’s metric scores as per the required standards (83% and above) which were key for the organization’s business sales and the resulting employee profit shares.
• Managed to raise the metric scores to 91% as compared to the previous average which ranged between 82% to 87%, within 6 months into the new department – a result that the organization had not achieved in the last 12 to.
• Analyzed the inventory reports which included tasks like analyzing the factors causing shrink and losses, checking if proper reduction processes were being followed, and making sure that the reduction percentage was.
• Maintained the gross profit of the organization while ensuring that the sales were always greater than the purchases, as well as any markdowns within the inventory of the department, were below 2%.

Ottawa, Ontario, Canada

Pune, Maharashtra, India

• Represented as a member of Board of Directors of the club and participated in the monthly Board of Directors meetings where ideas were brainstormed regarding community service and social service events.
• Handled the photography and marketing department of the club. Additionally, organized various community and public service projects, one of which was a sanitary pads distribution drive to girls of a local school in a.
• Educated the girls about sanitary pads, explaining them their needs and ways to use them, about personal hygiene, which was the primary goal of the project along with the distribution drive.
• Assigned as the head of photography for Rotasia 2018 - an international convention of Rotaractors and Rotaract clubs of South Asia.

Gatineau, Quebec, Canada

• Worked in the Agriculture, Forestry and Other Land Use (AFOLU) section within Pollutant Inventories and Reporting Division (PIRD).
• Directed a pilot project that acted as a stepping-stone for the company. The basic highlight of the project was to transition from previously existing inefficient software technologies like MS Access to more efficient.
• Created a separate database in SQL Server Management Studio using SQL queries and then established a connection between R Studio and SQL Server Management Studio to extract the required data.
• Scripted the transformation process by formulating the values from a pre-established project in MS Access, into R Studio using R libraries like Tidyverse. Additionally, added Data Quality Check and automated.

Pune

Worked as one of the Lead Photographers. Covered numerous events and meet and greets with various Bollywood Celebrities like Madhuri Dixit, Arjun Rampal, Abhay Deol, Tiger Shroff etc.

Pune, Maharashtra, India

Worked as a photographer at many restaurants. Also worked as an event photographer.

Post Graduate Diploma, Project Management

Post Graduate Diploma, Business Intelligence

Bachelor'S Degree, Information Technology

Diploma, Information Technology

Activities and Societies: Football Team

Education record

Activities and Societies: Football Team, Sports Secretary