Karan Oberoi

Data Analyst

Definity•  January 2024 - April 2024•  Toronto, ON

Designed and optimized automation data ETL pipelines for high volumes of insurance, claim, and census data reducing the data load time using Apache Airflow DAGs, GCP composer, google bigquery and increased the efficiency by 40%. Identified and debugged potential bugs in 100+ bitbucket repositories triggered by change in the data flow variables and worked with cross-functional teams to understand business data strategy, build and maintain data pipelines architecture. Automated Cloud migration auditing processes using VLOOKUP queries.

Business Analyst

JD Irving•  September 2023 - December 2023•  Halifax, NS

Identified and implemented automation opportunities by developing PowerShell scripts for Active Directory group management, achieving a 15% reduction in manual workload, equivalent to saving approximately 8 hours of labor per month. Developed and implemented LoadRunner scripts to automate manual testing processes, decreasing regression testing timelines by 25% and enhancing overall testing efficiency by 30%. Documented and created detailed test scenarios, test cases and test scripts derived from business requirements contributing to 20% increase in the test case count.

Data Scientist

TD Bank•  January 2023 - April 2023•  Toronto, ON

Developed a Savings Accounts Volume forecasting system working in collaboration with a team of data scientists, data analyst, data engineer, and business stakeholder. Utilized deep learning techniques to implement a convolution neural network(CNN) and recurrent neural network (LSTM) to build a graph-based forecasting model, validated and Improved results for 87.5% of the savings account volume. Pitched at an innovation Design thinking competition based on AI/ML application and best practices in finance with a collaborative team of interns.

Sales Specialist Associate

OSL•  January 2022 - December 2022•  Halifax, NS

Provided Technical support to clients, dealt with troubleshooting problems in store, and reached out to appropriate channels for more nuanced problems. Coordinated on sales events with manufacturer staff, setting up displays and going over the device details, ensuring all on hand documents are accurate up to date.

Machine Learning Intern

3F Waste Recovery•  June 2022 - August 2022•  Main Brook,NL

Led the development of a statistical machine learning time series predictive algorithm as a SaaS solution that addresses international climate change and waste problems. Published a statistical learning-based research paper for developing strategic proprietary natural resource business models with machine learning approaches for feedstocks susceptible to a by-product First solution. Developed and presented the company’s vision via PowerPoint presentations, data visualizations and advanced analytics.

Business and Technical Consulting Intern

CGI•  September 2021 - December 2021•  Halifax, NS

Developed an interactive customer-focused front-end and back-end web page for a huge Canadian insurance provider company using PHP, HTML, CSS, and JavaScript. Documented Technical reports, summarizing team/client consulting meetings to recall important discussions.