I am an analytical and results-driven IT professional with over 17 years of experience delivering value through research, analysis, and hands-on development. I have worked on market intelligence, GIS workflows, ETL processes, BI reporting, and ERP testing across global projects, collaborating with cross-functional teams and partners to improve data quality and operational efficiency. I excel in requirements analysis, test planning, end-to-end readiness, and team leadership, with strong SQL, data visualization, and GIS skills. I am always exploring new tools and technologies to drive process improvements and better decision-making.

Ravi Bansal

I am an analytical and results-driven IT professional with over 17 years of experience delivering value through research, analysis, and hands-on development. I have worked on market intelligence, GIS workflows, ETL processes, BI reporting, and ERP testing across global projects, collaborating with cross-functional teams and partners to improve data quality and operational efficiency. I excel in requirements analysis, test planning, end-to-end readiness, and team leadership, with strong SQL, data visualization, and GIS skills. I am always exploring new tools and technologies to drive process improvements and better decision-making.

Available to hire

I am an analytical and results-driven IT professional with over 17 years of experience delivering value through research, analysis, and hands-on development. I have worked on market intelligence, GIS workflows, ETL processes, BI reporting, and ERP testing across global projects, collaborating with cross-functional teams and partners to improve data quality and operational efficiency.

I excel in requirements analysis, test planning, end-to-end readiness, and team leadership, with strong SQL, data visualization, and GIS skills. I am always exploring new tools and technologies to drive process improvements and better decision-making.

See more

Language

English
Fluent
Hindi
Fluent
Panjabi, Punjabi
Fluent

Work Experience

Programmer Analyst at Waterloo Regional Police Service
February 1, 2020 - Present
Improved map quality and data accuracy by identifying issues and discrepancies in data formats; engaged with partners to resolve in a timely manner. Analyzed, designed, developed, implemented, documented and maintained applications and systems. Designed GIS workflows and ETL processes for emergency applications and reports. Prepared test plans, tested, identified and fixed bugs and defects. Created custom dashboards and reports using BI tools. Researched and identified new tools and technologies to enhance process improvements and increase efficiency.
Market Data Researcher at Toronto Real Estate Board
December 1, 2017 - February 1, 2020
Produced monthly and quarterly reports from scratch using Dundas BI published for scheduled automated generation. Held stakeholder meetings to resolve data analysis/reporting issues and brainstorm presentation improvements for TREB members. Prepared informative ad-hoc presentations and reports for MPs/MPPs/Board of Directors. Created Municipal, Provincial and Federal GIS reports, heat maps and community maps. Integrated MS-SQL databases with BI tools to deliver live dashboards and charts for members.
Professional Development Coordinator (Temp) at Toronto Real Estate Board
June 1, 2017 - December 1, 2017
Aided members with issues and queries; organized and managed training sessions, tracked attendance, and maintained orientation and training records. Handled inquiries via phone and in-person, ensuring timely and helpful resolutions. Maintained records of membership orientations and training requests.
Project Manager/QA Analyst at CoachOFF Inc.
February 1, 2017 - May 1, 2017
Managed iOS mobile app development projects; prepared and presented reports on app issues, market trends, and usage research. Conducted Scrum meetings and daily progress reporting with stakeholders.
ERP Consultant at Infosys Limited
June 1, 2012 - December 1, 2016
Designed and implemented ERP solutions for Barcode implementation as part of US$ 200K Warehouse Management solution. Delivered across three development releases with ad-hoc requirements and high-priority fixes. Reviewed user requirement documents, conducted design discussions, prepared requirements traceability matrices and test plans. Created/tested test data in databases and validated results with SQL; generated and cross-checked reports from Oracle ERP and databases. Served as Onsite Test Team Lead and SPOC in China for a US-based client; mentored global QA teams and managed multiple stakeholders.
Test Analyst at Infosys Limited
September 1, 2011 - May 1, 2012
Designed and executed test plans; managed test data in databases and verified results with SQL. Updated and verified databases with data from legacy ERP systems. Demonstrated functional solutions to senior managers for training; improved QA documentation practices to enable repeatability and cost reduction; acted as liaison for a US-based client in China.
Senior QA Analyst at ClickSoftware India Pvt. Ltd.
April 1, 2011 - September 1, 2011
Prepared test plans, resource estimates, and detailed test scripts for product solutions; tested ClickSoftware Workforce Management. Documented software defects for root-cause analysis and presented quality metrics to stakeholders; managed multiple client projects concurrently.
Systems Engineer at Tata Consultancy Services Limited
August 1, 2007 - April 1, 2011
Led a team of 6 resources in Oracle ERP Suite implementation projects; performed functional point analysis for effort estimation; developed reports highlighting critical issues; conducted Business Value Analysis for effective test scripts. Recognized for thorough analysis and leadership; volunteered as Offshore Lead and delivered 0% defect live environments.

Education

Certificate at Ryerson University, Toronto, Canada
September 1, 2019 - December 1, 2020
Certificate at Ryerson University, Toronto, Canada
September 1, 2017 - December 1, 2018
M.E., Electronics Engineering at Punjab Engineering College, Chandigarh, India
July 1, 2005 - August 1, 2007
B.Tech., Electronics & Communications Engineering at Kurukshetra University, Haryana, India
July 1, 2002 - June 1, 2005
Diploma in Electronics & Telecommunications Engineering at Haryana State Board of Technical Education, Haryana, India
July 1, 1999 - June 1, 2002

Qualifications

Dundas BI Certified Analyst
January 11, 2030 - January 16, 2026
ISTQB Foundation level certified
January 11, 2030 - January 16, 2026

Industry Experience

Government, Professional Services, Real Estate & Construction, Education, Software & Internet