Rushabh Shah Email & Phone Number

Toronto, Ontario, Canada

• Leveraged advanced SQL skills to develop and optimize complex queries to resolve credit card data discrepancies, resulting in effective revenue investigations and identification of missing revenue and missing credit cards in the backend system• Created and owned key Looker scorecards and dashboards utilized by cross-functional teams, including C-level management, enabling stakeholders to access real-time data insights, visualize key metrics, and make informed business decisions for… Show more • Leveraged advanced SQL skills to develop and optimize complex queries to resolve credit card data discrepancies, resulting in effective revenue investigations and identification of missing revenue and missing credit cards in the backend system• Created and owned key Looker scorecards and dashboards utilized by cross-functional teams, including C-level management, enabling stakeholders to access real-time data insights, visualize key metrics, and make informed business decisions for the Everyday Banking business unit• Employed Heap and Google Analytics to meticulously track and analyze user behavior, including button clicks, navigation paths, and engagement metrics to derive actionable opportunities for website optimization and enhanced user experience• Leveraged dbt to enhance data modeling, transformation, and deployment processes, identifying and resolving discrepancies in SQL queries through thorough investigations. Applied fixes and edits to optimize query performance, ensuring accurate and reliable data transformations.• Collaborated on automation of monthly revenue reconciliation process using Airflow, effectively reducing manual effort and ensuring accurate and timely reconciliation Show less

Toronto, Canada Area

• Develop new reporting methods through SQL queries to present data to C-level executives, including visualizations of market share growth and dealer performance, to aid in decision-making processes• Manage a team of two analysts creating and utilizing complex Excel workbooks and PowerPoint dashboards to model data points and report unique findings on weekly, monthly and quarterly basis to over 30 brokers and 50 issuers (ranging in $1M to over $2B in market cap)• Prepare trading… Show more • Develop new reporting methods through SQL queries to present data to C-level executives, including visualizations of market share growth and dealer performance, to aid in decision-making processes• Manage a team of two analysts creating and utilizing complex Excel workbooks and PowerPoint dashboards to model data points and report unique findings on weekly, monthly and quarterly basis to over 30 brokers and 50 issuers (ranging in $1M to over $2B in market cap)• Prepare trading fee revenue schedule to evaluate competitiveness of NEO trading fees, resulting in changes to fees and strategies that increased NEO market share by 2% in two months, and provided invaluable insights that helped drive growth from 7% to 15% market share in 2 years• Create new marketing campaigns based on self-driven data discovery through SQL and Bloomberg data mining, having pitched one of NEO’s most successful marketing campaigns in 2021 (creating top 10 lists of most traded securities by various segments and a Year in Review infographic), resulting in 5k+ impressions across all platforms• Oversee the intern recruitment process each term in conjunction with HR: reviewing applications, creating and conducting interviews, administering technical exams and managing the onboarding process, resulting in successfully recruiting, onboarding, and managing 8 interns over the last 2 years Show less

Toronto, Canada Area

• Developed a Knowledge and Skills Resource Repository to streamline training and onboarding process, which was successfully used to onboard a new hire• Prepared schedule and resource utilization rates for $1.5 million project migrating 30 clients to new contact centre platform, along with accompanying presentations for senior management • Designed test cases and conduct QA analysis on newly developed contact centre systems

Kitchener, Canada Area

• Administered the Co-op Student Mentor Program • Represented the co-op program at events such as Laurier Day, the Ontario Universities Fair, Headstart, co-op information sessions and workshops• Organized special projects to educate students about co-op program and admissions

Toronto, Canada Area

• Coordinated strategic initiatives within the company through proactively assisting with various SAP Business Objects analytics and Excel modelling assignments • Worked with the Strategy team to track and analyze Sales Representative activities and performance levels to determine activities that correlate to success• Prepared and communicated daily, weekly, monthly, quarterly, and annual reports/analysis across all Sales channels• Assisted with special projects and ad… Show more • Coordinated strategic initiatives within the company through proactively assisting with various SAP Business Objects analytics and Excel modelling assignments • Worked with the Strategy team to track and analyze Sales Representative activities and performance levels to determine activities that correlate to success• Prepared and communicated daily, weekly, monthly, quarterly, and annual reports/analysis across all Sales channels• Assisted with special projects and ad hoc tasks as required Show less

Kitchener, Canada Area

• Inspired a team of 8 Vice Presidents and 15 executives to help improve the skills and self-confidence of the Laurier community through the use of public speaking• Acted as the liaison between the club, faculty, student body and external organizations • Coordinated the planning and execution of 15 events in one semester on a $1500 budget

Kitchener, Canada Area

• Organized logistics and promotion for key events held by the club in unison with other members of the Executive Team• Created and executed over 30 weekly meetings to develop public speaking skills of over 75+ general members. • Secured sponsorships amounting in over $1200 from the Kitchener-Waterloo area to support club activities and events

Wilfrid Laurier University

• Worked with the Golden Speakers Executive team to plan over 15 general meetings and 5 events throughout the year • Used meticulous research and organization skills to create plans and agendas for each event held by the club• Coordinated with internal and external contacts to promote transparency within the club• Ensured smooth execution of all events

Toronto, Canada Area

• Co-op student in the Corporate Services Division, which aids the Ministry of Economic Development & Growth, Ministry of Energy, Ministry of Infrastructure and the Ministry of Research, Innovation & Science• Collaborated with a team of senior employees and management to advise senior management and Deputy Ministers on improvements to programs for Ontarians• Conducted extensive research to create informative reports used to develop Key Performance Indicators for a group of… Show more • Co-op student in the Corporate Services Division, which aids the Ministry of Economic Development & Growth, Ministry of Energy, Ministry of Infrastructure and the Ministry of Research, Innovation & Science• Collaborated with a team of senior employees and management to advise senior management and Deputy Ministers on improvements to programs for Ontarians• Conducted extensive research to create informative reports used to develop Key Performance Indicators for a group of Ontario Ministries• Analyzed department budgets of up to $13 million to forecast spending and locate discrepancies• Created assessment frameworks and logic models to aid in government decision-making processes Show less

Kitchener

• Applied learned skills and knowledge to help Life Change Adventures, a non-profit organization that provides educational opportunities to youth to improve their chances of achieving their career aspirations, solve current issues • Worked with a partner student-consultant and an MBA mentor to create social change in the community • Secured an opportunity for the organization to visit Laurier's campus and partake in special campus tours for over 60 middle school students to… Show more • Applied learned skills and knowledge to help Life Change Adventures, a non-profit organization that provides educational opportunities to youth to improve their chances of achieving their career aspirations, solve current issues • Worked with a partner student-consultant and an MBA mentor to create social change in the community • Secured an opportunity for the organization to visit Laurier's campus and partake in special campus tours for over 60 middle school students to experience university life and the numerous post-secondary education options available to them Show less

Toronto, Canada Area

• Started a business providing tutoring and training services• Provided educational assistance to students from Grades 1 to 8 and public speaking training to people of all ages• Created lesson plans to help improve students’ study habits, work ethic and grades

Vaughan, On

• Retrieved files and boxes for organization and destruction based on client orders and requests• Entered data from various financial statements, such as TD TFSA and Mortgage Amendments, into SafeKeeper Plus

• Used effective leadership and communication skills to plan school events with an executive council of 10 members and a general council of 40 members • Acted as a liaison between the students, staff, administration and community to engage everyone with all the activities the club hosted

• Created systems to organize school supply shipments which reduced inefficiencies• Created and regularly updated an inventory of the school supplies to keep the team organized• Worked with school staff to coordinate teams to deliver supplies and set up classrooms

• Increased departmental efficiency by using computer programs to organize and sort new and backlogged criminal files• Sorted and delivered files in a timely matter which were distributed among the building and branches of the Toronto Police Service

Bachelor’S Degree, Honours Bachelor Of Business Administration With Co-Op, Marketing Concentration And Economics Minor

Activities and Societies: - Golden Speakers Club (Public Speaking Club) - Coop Student Advisory Council

Ontario Secondary School Diploma

Activities and Societies: - Student Administrative Council (President) - Prefects - DECA - Free the Children