Balwinder Purewal
Edmonton,Canada
Summary
Professional software development specialist with background in creating innovative software solutions and optimizing systems for improved performance. Proven ability to collaborate effectively within team environments and adapt to evolving project requirements. Expertise in systems development and maintenance, specializing in SQL Server stored procedures, SSIS ETL packages, and UI development using PowerBuilder and .NET technologies. Proven leadership as the lead developer in a team of three for the successful redevelopment of the SSIS ETL project WORP for the Government of Alberta. Proficient in both Waterfall and Agile methodologies across various projects, demonstrating adaptability and a commitment to best practices. Recognized for exceptional troubleshooting skills, meticulous attention to detail, and a strong ability to resolve technical challenges efficiently.
Overview
33
33
years of professional experience
1
1
Certification
Work History
Software Developer
Self-employed
08.2024 - Current
- Incorporated in Alberta.
- Mobile phone and computer repair (part time from home).
- IOS and macOS development using Xcode/Swift.
- Developing Single Page Web Application with Vue 3.
Systems Analyst/Consultant/Software Developer
CGI I.T. and Management Consultants Inc.
10.2010 - 04.2024
- Development and Maintenance Analyst for applications used by the Government of Alberta.
- Lead analyst and developer for the redevelopment of existing GOA SSIS application - WORP: Work Outcomes Reporting Program - an SSIS ETL application.
- Performed code reviews on colleagues’ work.
- Performed unit testing, system testing and assisted client during acceptance testing.
- Responsible for gathering user requirements, identifying, proposing use of, and implementing Microsoft R Services for the random selection of individuals for potential surveying in WORP.
- Responsible for identifying and resolving performance issues with WORP due to SQL Server queries that were exceeding acceptable execution time.
- Led regular bi-weekly meetings with client at client site (GOA).
- Tools and technologies used: TFS (Visual Studio 2010) used for source code repository, SQL Server 2015, SSIS, Microsoft R , C#.NET, Agile methodology, GOA EDB, JIRA for time reporting and incident management, GOA SharePoint site for document management. Azure Virtual Desktop for logging into GOA virtual machines used 4 development and testing.
- Bombardier Recreational Products project (BRP CGI Montreal) 01/2023 - 06/2023.
- Development and maintenance of SQL Server/Azure SQL stored procedures for Bombardier Inc. web portal used by their worldwide sales offices. Worked remotely from Edmonton.
- Tools and technologies used: SQL Server/Azure SQL, Google Workspace for document management and team collaboration.
- Saskatchewan General Insurance project (CGI Saskatchewan) 06/2023 - 04/2024.
- Responsible for incident resolution, coded the “Vehicle” SQL Server stored procedure used by SGI brokers to return vehicle and owner information (current and historical). Worked remotely from Edmonton.
- Tools and technologies used: Appeon/Sybase PowerBuilder 12.5 and SQL Server 2016, ServiceNow.
Systems Analyst/Software Developer
Department of Energy (DOE) Government of Alberta
01.2006 - 08.2009
- Systems Analyst for Corporate Applications, Information Technology Business Unit.
- An integral member of the Foundation Project team responsible for development, maintenance and support of the “Foundation” Windows application and interfaces - an N-tier application developed using C# (Visual Studio .NET 2003, Visual Studio 2005, .NET Framework 1.1 and 2.0), SQL Server 2005, Infragistics NetAdvantage 6.2, Rational Unified Process (RUP) methodology. Classes in “Foundation” were designed using the Unified Modelling Language (UML). Unit testing done using TestDriven NUnit.
- Developed and maintained sub-systems to replicate Petroleum Registry of Alberta (PRA) data into Foundation database in real time via XML files (“ReplicatePRA” jobs. XML files sent via DOE ELECTRAN application).
- Tools and technologies used: C# (Visual Studio .NET 2003, Visual Studio 2005, .NET Framework 1.1 and 2.0), SQL Server 2005.
- Other responsibilities included: Gathering requirements by meeting with client, requirements analysis, creating technical design document, system use case creation, maintenance of system documentation, coding enhancements, developing SQL Server 2005 queries and stored procedures, providing daily support to the production operations team, ensuring application changes meet the DOE standards and follow the change management process, provide on-call support after regular business hours on an as-needed basis, providing test coverage and performing unit and system testing, liaising with testing teams (system test and acceptance test), and providing regular status reports to the Project Manager.
- Gained technical knowledge of the DOE’s applications (ELECTRAN, Foundation, and MRIS), environments, standards and procedures.
Systems Analyst/Consultant/Software Developer
CGI I.T. and Management Consultants Inc.
10.2001 - 01.2006
- Application Support Analyst providing support for several client-server and web-based applications for Alberta Human Resources and Employment (June 2002 to January 2006).
- Responsible for requirements analysis and specification, estimation, object-oriented design, implementation, testing, system maintenance and enhancements. Provided estimates, designed, developed, and implemented various enhancements for Employment Standards Information System (ESIS), Mediation Arbitration Retrieval System (MARS), Program Approval Information System (PAIS), Office of the Public Guardian Information System (OPGIS), Client Correspondence Contact Management System (CCMS), OneView, WHSExams, EASC (Enterprise Address Security Component).
- Participated in regular client status meetings to discuss any issues or concerns, progress of current work and any future service requests/enhancements required.
- Development and maintenance of SQL Server stored procedures.
- Tools and technologies used: PowerBuilder 7, PowerBuilder 8, Visual Basic version 6, Visual Basic .NET, Visual C# .NET, ASP, ASP.NET, HTML, Crystal Reports, JavaScript, MS Access 97, MS Access 2000 and SQL Server 2000 running in a Windows NT/2000 environment.
- Application Support Analyst providing support for client-server applications and website for WCB of NWT and Nunavut 09/2001 - 06/2002.
- Responsibilities included: requirements analysis and specification, estimation, object-oriented design, implementation, testing, system maintenance and enhancements. Provided estimates, designed, developed, and implemented various enhancements for WCB custom applications. Maintained and enhanced the WCB website. Other duties included writing and modifying stored procedures. Also involved in regular client meetings to discuss any issues or concerns with the applications.
- Tools and technologies used: PowerBuilder 7, HTML, JavaScript and SQL Server 7 running in a Windows NT/2000 environment.
Systems Analyst/Software Developer
PricewaterhouseCoopers, LLP
05.1996 - 04.2001
- Lead Programmer/Analyst for NGK project consisting of 3 to 10 members involved in creation of an order entry/invoice client server system 11/2000 - 04/2001.
- Responsible for requirements analysis, design, coding, testing and implementation of an order entry/invoice system.
- Writing SQL Server stored procedures.
- Delegated and coordinated the coding tasks.
- Mentored junior members of the team.
- Tools and technologies used: PowerBuilder 7 with PFC, SQL Server 7 running in a Windows NT environment.
- Programmer/Analyst for BP Amoco on a data conversion project for the oil and gas industry 10/2000 – 11/2000.
- Responsible for gathering requirements, coding, testing and implementation of an interface module that converted data from a previous system into a new client-server system (ETL), writing stored procedures, and attended meetings with the client.
- Tools and technologies used: PowerBuilder 6.5 with PFC, Sybase Adaptive Server Anywhere running in a Windows NT environment.
- Programmer/Analyst for Rent-On-The-Dot project 09/2000.
Software Developer
Advanced Micro Design
05.1995 - 09.1995
- Programmer on project for Canadian Association of Petroleum Producers (CAPP).
- Designed, coded and implemented a Query Engine and Graphical User Interface for a large database used by CAPP.
- Support and maintenance of other applications used by CAPP.
- Tools and technologies used: Microsoft Access2.0
Software Developer
Telelink Technologies Inc. Vancouver, BC
03.1993 - 09.1993
- Software Engineer for real-time personal paging system.
- Designed, coded and implemented real-time software used for Motorola based paging terminals.
- Tools and technologies used: C, Motorola 68030 platform.
Education
M.Sc. - Computing Science
University of Alberta
01.1996
B.Sc. - Computing Science
University of Alberta
01.1992
Skills
- Proficient in SSIS and ETL package creation
- PowerBuilder application development
- Microsoft NET development expertise
- SharePoint content management
- Microsoft Azure platform expertise
- Skilled in utilizing Microsoft R Services
- Proficient in Microsoft Team Foundation Server
- Microsoft 365 proficiency
- Experienced with Vue 3 framework
- Systems analysis expertise
- Proficient in Waterfall and Agile methodologies
- JIRA timesheet management
- Experienced with MacOS, ChromeOS, iOS, and Android
- Familiarity with networking concepts
- Skilled in Azure Virtual Desktop
- Effective communication in both verbal and written forms
- Deliver accurate time estimates
- Ensures timely completion of tasks
- Guiding users through software challenges
- Detail-oriented approach
- Technical problem resolution
- Code debugging
- Testing and debugging
- Code review
- Git proficiency
- Application development
- Technical writing
- Technical support
- Technical analysis
- Customer-oriented
- Technical design documentation
- Performance optimization
- Data structures and algorithms
- Proficient in HTML
- Version control systems
- Full-stack development
- Code documentation
- Javascript
Accomplishments
- 20-year service award from CGI.
- ITIL Certified.
- Granted the Alexander Rutherford Scholarship for Honors in High School.
- Completed the Honors Computing Science degree at the University of Alberta.
- Teaching Assistant at the University of Alberta while completing M.Sc.
Languages
English
Native or Bilingual
Punjabi
Native or Bilingual
Certification
ITIL Certified, 2020
Timeline
Software Developer
Self-employed
08.2024 - Current
Systems Analyst/Consultant/Software Developer
CGI I.T. and Management Consultants Inc.
10.2010 - 04.2024
Systems Analyst/Software Developer
Department of Energy (DOE) Government of Alberta
01.2006 - 08.2009
Systems Analyst/Consultant/Software Developer
CGI I.T. and Management Consultants Inc.
10.2001 - 01.2006
Systems Analyst/Software Developer
PricewaterhouseCoopers, LLP
05.1996 - 04.2001
Software Developer
Advanced Micro Design
05.1995 - 09.1995
Software Developer
Telelink Technologies Inc. Vancouver, BC
03.1993 - 09.1993
B.Sc. - Computing Science
University of Alberta
M.Sc. - Computing Science
University of Alberta