Vedang Kawadkar Email and Phone Number

Contributed to the company digital transition to Microsoft Azure and PowerBIMigrated finance & supply-chain datasets from legacy DBMS to Azure CloudQueried SQL scripts, wrote stored procedures, and created pipelines to port finance and SC dataCreated documentation for datasets and stored proceduresWorked to visualize data in stg and fin layers using data engineering conceptsCreated early BI views for business usersWorked cross-functionally with finance and supply-chain teams to ensure data integrity and resolve bugsConducted biweekly meetings with managers & directors of SC & data engineering, ensuring project alignment, clearing any queries/concernsCoded a Python tool to automate manually writing SQL queries, tool ideally saves the team around 20 hours of manual work per weekOrganized an intern volunteering session with the Canadian Red Cross food bank, volunteering team packed 300 emergency meals for delivery to in-need families.

Designed an Excel VBA Tool to simplify and sort credit information scattered across raw-data Excel files in company SharePoint; Tool saves 20+hrs of manual data-handling time per quarterWrote necessary documentation to allow users to work with the automation tool appropriatelyFiltered data present in large-scale credit databases using PROC-SQL language commandsWorked with & analyzed historical credit data trends, to study the impact of COVID-19 on company credit card sales, cardholder accounts, and credit payment defaults.Created and presented a varied set of graphical analyses of the trends to senior executives and risk portfolio managersWorked with managers to conduct risk forecasting and mitigate credit risk threats by developing risk-mitigation strategies.Worked with a team of fellow interns to design a system targeted towards boosting PC Optimum benefits for High School, College & University students, which received significant praise from the CEO.