Header image

Randeep Dosanjh - Consultant




Randeep Dosanjh

Canada  | +1(604)319-1736 | 

randeepdosanjh@clickstreamconsulting.onmicrosoft.com | http://www.clickstreamconsultinginc.com



Computer Information Systems | April 2007 | Kwantlen Polytechnic University

·     Major: Computer Information Systems

·     Minor: Business

·     Related coursework: Systems Analysis and Design, Organizational Behaviour, Cisco CCNA exam#1, Information Systems Development


Business Objects (SAP), Customer Feedback Analyst

o Information Specialist doing data analytics on Customer Feedback 

Club Intrawest (Intrawest Corp.), IT Support

o Workstations Support Agent, Setting Up Servers with Group Policy & Security, Hardware & Software Support

Associations and Memberships

·     Listed Microsoft Solution Provider

·     Federal Security Clearance: Yes

·     Microsoft Partner Network: Action Pack, Solutions Provider, MS Cloud Reseller and Support Partner

·     Kwantlen Polytechnic University Alumni

·     Cisco Alumni

·     Registered for on-demand Microsoft Partner Training (self-paced)

Skills & Abilities

Project & Team Management

·     For over 15 years, my career as a Management and Technology professional has spanned 6 business sectors, spanning projects in more than 12 Fortune 500 firms, more than 5 Government entities with security clearances and 5+ years with a European Union regulated firm which later became a US company as division of Cargill. I hope to bring value to your team.

·     The sectors I have worked in are Manufacturing and Distribution, Time-Share and Real Estate, Video Gaming, Financial, Utilities, Energy and Banking as well as Research and Development. This independent consulting practice is in addition to founding 3 of my own firms which work as linear channels to bring value added services to clients.

·     This includes several Inside Sales and Distribution channels with technology firms, a Recruitment practice registered here in BC for a short time as well as a number of Angel Investment projects and, being a listed and registered Microsoft Solution Provider.

·      My responsibilities when engaged with clients can range from working with account executives to build solutions, participate in client facing meetings to determine business and technical requirements to be used in developing solutions or solution alternatives which map within the client’s capabilities while managing people and deliverables.

Technical SOlutions Roles

·     Architect, Develop and Design Solutions

·     Technical Support Agent for Solution Maintenance

·     Direct Software, Hardware and Cloud Sales and Solutions

·     Agile & Scrum Experience

·     Reporting and Data Analytics

·     Multiple Project Developer and Management experiences

·     MS Project, MS Excel


·     Over the years, with consulting, contracting and the business development of my own business operations can be seen with strategically collaborating with clients to drive the business where I have been responsible for assisting managers and teams in defining, positioning, designing and presenting a range of solutions.

·     I believe in interacting on a regular basis with management and stakeholders while being able to deliver results using agile or waterfall methodologies, applying exceptional leadership skills in managing expectations, mitigating risk and removal of any roadblocks.

·     Often my responsibilities have included being asked to develop proposals which define client expectations with product and service requirements necessary to achieve company and team objectives as well engineering and development with a `hands-on` approach.

·     Over the years working with different departments and teams to manage time expectations and milestones has been a key part of my professional growth.


·     In development projects, I have been a Full Stack Developer or, brought on to teams to be assessing opportunities and performing necessary due-diligence around technical, operations and financial impacts.

·     I bring a broad knowledge of business solutions and professional services within my threshold.

·     There is a focus to develop interpersonal and leadership skills while being be highly self-directed where needed.

·     Highly adaptable in taking initiative when in need, with an emphasis on effectively liaising with all levels of management while working as a team member.


IT Contractor | Various | 

·     Client Contracts:

o Cargill (Ewos Canada), IT Workstations & Servers Support, Software Developer,

o Crossmark Canada, Bell Canada Sales Representative,

o Electronic Arts, Mastering Media Technician,

o BC Transmission Corp, Systems Support Administrator,

o Metafore IT Solutions (now: Compugen), Technical Support for Rollouts of Workstations & Devices –

o WestPort Innovations, SharePoint Resource Lead,

IT Contractor | Sole Proprietor |

·     Client Contracts:

o Central1 Credit Union Centre, Programming Services (Unix, Cobol),

o G & F Financial Group, SharePoint Project Consultant,

Solutions Consultant | Clickstream Consulting Inc (self) | 

January 2010 - current

·     Projects & Client Contracts

o Cargill (Ewos Canada), Data Analyst & Production IT Lead,

o IBM – Government, Microsoft Specialist (SharePoint, SQL Server, Microsoft Technologies Integration),

o TechMahindra, Tech Lead,

§ Telus (TechMahindra), Business Systems Analyst (BSA),

o Canadian Nuclear Laboratories (PlanIT), Application Developer (VBA),

o Electronic Arts, SharePoint Developer Analyst (Solution Provider, Technical Writer, Developer),

o BCHydro, SharePoint Technical BA / Technical Solutions Consultant,

Volunteer Roles

Fundraiser | Covenant House Vancouver | 

·     Covenant House provides housing and supportive services to youth facing homelessness by helping young people transform their lives and put them on a path to independence.

o Computer room aid who helped adults learn about computers, document formatting and resumes using computers

General Help | India Mahila Association | 

·     Since 1976, this association advocates to empower South Asian Women by means of educated lectures, speeches, and other resources so that they can be more proactive using constitutional rights and human freedoms here in Canada and around the world.

o Helped with the video editing bit for their 25th anniversary party that fall/winter and on a number of volunteering campaigns where a hand was needed


Overview & Operating Name

Solutions Consultant

Clickstream Consulting Inc –                                                                                      

·         Per Diem work orders as needed

Company Profile:

·         Clickstream Consulting Inc is my consulting practice of which, there are 8 enterprise business partners of which I am a technical solution builder and sales agent in the business partner respect with 4 distributors in the United States and Canada

Business Case(s):

Build Solutions - Sell Solutions - Technical Support Agent

Service Offerings

·         Build solutions with integrated technologies

·         Support & Technical Consultant for integrating Partner and Non-Partner technologies and services

·         Products, Services and Solution sales

·         software sales

·         hardware sales

·         hosting services sales* cloud sales

·         Business Partners:

·         Microsoft

·         Hostway Corp

·         IBM

·         Oracle

·         Salesforce.com


Project: #18

SharePoint Technical Business Analyst


Client Profile: Government Division

Business Case:

·         This job requires me to be a SharePoint Development Resource to and with it’s teams. Wrote technical documents, project meetings, working with teams, setting up developer and support station environment to respond to support requests

Technologies and Tools:

·         Building and configuring SharePoint websites using web UI,

SharePoint Designer, and workflows.

·         Responsible for developing applications around the core concepts

of business process management, collaboration, business intelligence or

enterprise content management.

·         Specific work elements include assisting in project development, defining requirements with

 clients and developing solutions on-going support for applications designing

 and customizing SharePoint solutions Design and integration for content

 management, portals, collaboration, business process or other solutions

 planning and assisting software version upgrade releases troubleshooting and

 debugging SharePoint sites.

·         Participate in requirements analysis and develop solutions for all tiers of the SharePoint

       application such as user interface, middle-tier business components, database

layer, etc.

·         Key contributor to innovation and build proof of concept examples.

·         Have the ability to determine the most suitable presentation method, visual

 elements, and programmatic objects that meet design and business objectives.

·         Maintain flexibility to meet changing needs and requirements.

·         Plan and execute appropriate unit and integration tests that ensure maximum

 reliability and minimal defects.

·         effectively communicate with clients to identify needs, and evaluate

 alternative business solutions.

·         out-of-the-box solutions using SharePoint but not limited to:

·         Using the functionality and features of SharePoint Solutions that

       access external data by using Business Connectivity Services SharePoint

workflow, InfoPath custom solutions

·         Managed metadata and user profile services SharePoint s content management services

·          Branding solutions using Master Pages, CSS, and JavaScript, SharePoint Designer, ASP.NET, .Net Architecture, Solution Architecture, SharePoint, Architecting

Project: #17

SharePoint Developer Resource

Electronic Arts - Remote                                                                   

Client Profile:

·         Client is a blue-chip software firm specializing in games development with global operations and offices

Business Case:

·         This job requires me to be a SharePoint Development Resource to and with it’s teams. Wrote a 200+ page technical document after setting up developer server/environment to show the many ways this could be done

Technologies and Tools: Installed & Worked With:

·         3rd Party client outsourced team

·         SharePoint Admin Permissions

·         SharePoint Site Features

·         SharePoint Designer

·         Visual Studio 2017

·         Visual Studio 2013

·         Node.js,

·         REACT JavaScript

·         HTML, CSS

·         C#.NET* ASP.Net

·         JavaScript & JQuery* Yeoman

·         Work Order details:

·         Wrote and Published: a 230+ page Technical document

·         used technical writing document style,

·         site Analysis of existing infrastructure

·         Setup Windows Server 2012 R2 for Development


Project: #16

Vba Developer

Government of Canada - Remote -                                                            

Company profile:

·         PlanIT is a Project and Work-Order outsourcing firm, specifically in the industry of IT and ERP,

Client Profile:    

·         Client is in the energy sector. This operation is in an office in Eastern Canada

·         Business Case: This job requires Federal Security Clearance. I was brought in to develop Windows Office forms and MS Excel Modules as well as MS Word Forms for this client’s end client which was a Federal Agency.


·         VBA

·         Windows Forms Development using VBA

·         MS Word Macros

·         MS Excel Macros

·         MS Word Forms

·         Query Developer

·         Code creation, Implementation and editing

Project: #15

Data Analyst, Operations

Cargill - Surrey, BC                                                                                   

Company Profile:

·         Ewos Ltd is a division of Cargill

Client Profile:

·         EWOS Ltd is the Canadian aqua division of Cargill

·         EWOS Ltd is a R &D, Manufacturing and Distribution of Cargill

·         EWOS Ltd was a branch of an EU firmed called Cermaq ASA

Business Case:

·         Consultant to aid in bridging Production Projects with IT objectives for operations projects and reporting.

·         Measure metrics, manage technical operations and develop reports for Ewos Canada Ltd* Microsoft Business Solutions and IBM Business Analytics partner relationships allows me to access their tools if need be to help my clients with reporting and data metrics for business analysis or preparing anything on my that front, if asked by my client

Reporting & Application Development:

·         Bridging Production Projects with IT objectives for organizational project milestones

·         Demonstrating use of Data Centres for analyzing and problem-solving skills

·         Reporting Writing Proposals

·         Reporting to management with reports to access troubleshooting issues with software, hardware and human workflow

·         Working with staff to count inventory to see how scanning software (being tested) and manual results match then clearing any issues with hardware, software and its back-end data systems

·         Gathering requirements of what will be needed in each phase of testing

·         UI Testing production

·         Train Users

·         Technology

·         Report App development

·         Reporting Writing

·         MS Excel Macros, MS Word Forms

·         Visual Basic, VB Scripting, VBA

·         Visual Studio

·         Windows Forms Development

·         Windows Presentation Foundation

·         Windows Communication Foundation

·         SQL Server, Cognos

·         Movex M3

·         Infor Lawson- Infor M3,

·         Barcode software

·         Tekynx LabelView Software

·         Zebra Printers

·         Datamax Printers

·         JavaScript, MS Excel Queries & SQL Queries

·         Writing Report Developer Scripts

·         Java, VB, VBA, C#, SQL, XML/XAML

·         LINQ, ADO

·         Software design patterns, unit testing, performance/memory analysis, and n-tier architecture


Production Tech / Projects Manager

·         Managed Projects related to technology (hardware and software) within the production environment

·         Managed end users, user testing and the communication workflow between Upper

·         Management, Middle Management and End Users with technology related to Production Workflow

·         Risk Management with Change Management for each Report for Proposals I write

·         Software & Hardware Implementation & Testing


Writing Testing Procedures when implementing in software or hardware

·         Evaluating Testing Plans, Results then Reporting this information to Upper Management* Monitoring Testing

·         Troubleshooting real time testing issues

·         streamline test results to narrow testing scope

·         working with Management, Users and IT to write testing procedures and result reports* Monitoring and reporting this Linear, 4 layers, n-tier Production Workflow and the results there of a IBM based scanning

·         Full Life-Cycle project work-flow and people management

·         Workflow Management

·         measuring risk

·         writing reports for business solutions

·         business analysis of testing metrics, designing visuals i.e. charting and graphing results* analyzing metrics and working with production management and IT to discuss the success of such projects

·         writing reports to measure Usage vs Consumption then measuring and recording metrics to write reports for upper management

Project: #14

SharePoint Developer/Consultant & Principal

Clickstream Consulting Inc - Remote -                                              

Projects Business Case:

·         I founded Clickstream Consulting Inc in 2010, in these years developed then, setup and now maintain this company SharePoint pages and Portal, admin and use the MS Dynamics CRM site and as well the full Microsoft Cloud with Email Services & integration with AD Azure


·         Microsoft Partner Support, Hostway Corp Server Support. Tech


·         Cloud based SharePoint Development

·         MS Cloud .NET Development

·         Reporting using SQL Queries, Stored Procedures, Triggers

·         Technologies:

·         VS.NET

·         SharePoint Designer

·         SQL Server (DB, SSRS, SSIS, SSAS)

·         Project plan research and documentation

·         VB.NET

·         C#.NET

·         HTML, CSS

·         JavaScript, JQuery

·         SharePoint365

·         Office365

·         MS Dynamics (MS Cloud)

Project: #13

Business Systems Analyst

TELUS Communications - Burnaby, BC -                                                   

Company Profile:

·         Tech Mahindra is an global outsourcing giant which outsourced me to work with Telus as one of it’s many global clients

Client Profile:    

·         Telus is a major telecom firm in Canada. It is a Blue-Chip Fortune500 company which was once BCTel.

Business Case:

·         I was brought in to help with trouble tickets maintenance of business systems within Telus. BMC Remedy tickets and on-going solution building consultation with Telus teams across Canada was a mandate under my set of duties in the short time I was there.

Project: #13

Tech Lead

Tech Mahindra - Canada -                                                                                                  

·         Tech Mahindra assigned me to Telus to help with their Business Systems teams in Burnaby, BC (Canada)

Project: #11

SharePoint Developer (Microsoft Specialist)

IBM - Victoria, BC -                                                                       

Company Profile:

·         Placed by 3rd Party Vendor

End Client:

·         Provincial Government, BC Ministry of Technology

Tech Skills:

·         SharePoint Development using SharePoint Designer

·         .Net Development using Visual Studio

·         WPF - Windows Presentation Foundation

·         Documentation Technical writing (60+ page document on 'procedure')

·         .NET Development

·         SQL Server (SSRS)

·         SQL Queries

·         Stored Procedures using Triggers

·         Technologies:

·         VS.NET

·         SharePoint Designer

·         SQL Server (DB, SSRS, SSIS, SSAS)

·         Project plan research and documentation

·         C#.NET & VB.NET

·         HTML/CSS

·         ASP.NET

·         JavaScript, jQuery,

·         MS SQL, PL/SQL

Project: #10

SharePoint Developer/Consultant

G & F Financial Group - Burnaby, BC -                                                   G & F Financial Group is a mid sized and growing credit union in British Columbia which is a part of the Central 1 Credit Union Centre system

Business Case:

·         I was brought in to develop a SharePoint Site to Portal the Sales, Marketing and Relationship Tracking to increase service time and increase availability of client information in real time to maximize the value of relationships. This is a Company-wide project.


·         IT Department, All Levels of Management, Real Time Users, Trainings users on SharePoint,

·         Meeting with end users to discuss SharePoint Development for their sites

·         Full Stack SharePoint Development & .NET Development


·         Visual Studio

·         Windows Forms Development

·         Windows Presentation Foundation

·         Windows Communication Foundation

·         MS InfoPath, XML

·         SharePoint Services, SharePoint Designer

·         JavaScript & JQuery

·         CSS & HTML

·         SQL Server

·         Software design patterns, unit testing, performance/memory analysis, and n-tier architecture

·         Some UML using Enterprise Architecture, Agile Development & SDLC

·         Presentations of how to use SharePoint

·         SQL Queries, Stored Procedures, Triggers

·         Excel Macros, VBA

·         XHTML/CSS* LINQ, ADP

Project: #9


Central 1 Credit Union - Vancouver, BC -                                              

Client Profile:

·         Central 1 Credit Union is the operating body of which all credit unions in BC and Ontario are governed

Business Case:

·         I was brought in to consult on the redo an FTP Server-side script to work with an updated server technology and software to run more efficiently with the direction in which the client could see itself moving forward.


·         IT Department, All Levels of Management, Real Time Users, Meeting with to discuss project scope/planning, team Agile Development methodology

Tech Skills:

·         Putty (UNIX)

·         Shell Scripting

·         Visio-UML

·         Documentation writing

·         Technologies:

·         Korn Shell with Cobol

·         UNIX Putty

·         FTP for verision control

·         MS Visio

·         MS Project

·         UML and Modeling of Data & other workflows

·         Project Planning

·         Project Team Presentations

Project: #8

SharePoint Developer

Westport Innovations Inc - Vancouver, BC -                                       March 2008 to August 2008

Client Profile:

·         WestPort Innovations is an Engineering firm which does it's own R&D to manufacture and innovate engines which are environmentally friendly.

Business Case:

·         I was brought in to consult on the tangibility of custom .NET and SharePoint Technology to streamline the time and overhead from current to the design and development of several projects using SharePoint 2007 with SharePoint Designer, Visual Studio, ASP.NET using C#.Net as well InfoPath Forms. Projects with Details above under Projects using software design patterns, unit testing, performance/memory analysis, and n-tier architecture (Full stack .NET and SharePoint).

Tech Skills:

·         SharePoint Development

·         .NET Development

·         Some UML using Enterprise Architecture

·         Agile Development using the 7 stage Systems Development Life-Cycle

·         Presentations of how to use SharePoint best practices

·         SQL Server/Oracle

·         LINQ, ADO, Queries, Stored Procedures with Triggers

·         Excel Macros, VBA, Stored Macros with Triggers

·         C#.NET

·         ASP.NET with XHTML/CSS

·         JavaScript, jQuery

·         InfoPath






Project: #7

Technical Support (Desktop)

Metafore IT Solutions - Richmond, BC -                                

Company profile:

·         MetaFore IT Solutions is a Fortune 500 Information Technology and Systems outsourcing firm. Most of their operations are in Ontario and Quebec but the small division I worked with was in Richmond.

·         MetaforeIT Solutions has merged under the name Compugen with the existing Compugen.

Contracting Purpose:

·         I was brought in to install computer hardware with software for each machine set, at MetaforeIT Client Sites. As a Tech Support Agent, I performed rollouts and IT/IS upgrades.

·         Clients were Fortune 500 and Government firms.

·         Most Projects were a week or 2 at the most with each client

Project: #6

Systems Support Administrator

BC Hydro - Vancouver, BC                                                     

Company profile:

·         I worked for the BCTC inside of BC Hydro - BCTC is the Transmission leg of BC Hydro’s hydro energy practice. This firm is a Crown Corporation

Contracting Purpose:

·         As a Systems Support Administrator, my role was Data Entry and run Queries on a MS Access 2003 Forms Application

·         I was hired to upgrade this existing project but was later told that this kind of work was outsourced to Accenture

Project: #5

IT Aid & Software Developer

Cargill - Surrey, BC                                                                            

Company Profile:

·         Ewos Ltd is a division of Cargill

Client Profile:

·         EWOS Ltd is the Canadian aqua division of Cargill

·         EWOS Ltd is a R &D, Manufacturing and Distribution of Cargill

·         EWOS Ltd was a branch of an EU firmed called Cermaq ASA

Business Case:

·         I was brought into cut the cost of manufacturing overhead by adhering within and proposing new technology concepts and projects which fit into the management scope of how to move the future of production activities in such a way that through effective and efficient modules of ad-hoc software development projects.

·         My role was to provide Ewos Canada Ltd progressive cost-cutting measures which would lead to greater productivity versus cost. While in this role, I successfully added to a number of IT Aid and Desktop/Laptop Support roles with Server Maintenance.


·         Perform as a Desktop Support agent

·         Help with installation and maintenance of Desktop and Server software including helping withthe physical installation and Maintenance of Desktop, Laptop and Server hardware and as well as their software

·         Troubleshooting: Software and hardware support for laptop and desktop workstations

·         Installed/repaired Desktop and Server hardware & Software to maintain working order of alllaptops and desktops

·         Working with and deploying Norton Ghost images on workstations & Rebuilding Servers

·         Software Development at Ewos Listed under projects with details below:

·         Infor-M3, Lawson with Movex M3

·         IBM Cognos ReportNet

·         IBM Infor-M3 (Lawson) Scanner software on a Windows Mobile 6 OS

·         .NET Development

·         Some UML using Enterprise Architecture

·         Agile Development using the 7 stage Systems Development Life-Cycle

·         Presentations of how to use SharePoint

·         MS SQL Queries, Excel Macros, VBA, Stored Procedures with Triggers

·         Visual Studio with * without SharePoint Designer

·         Eclipse for Java

·         Windows Forms Development

·         Windows Presentation Foundation

·         Windows Communication Foundation

·         C#.NET

·         VB.NET

·         ASP.NET with XHTML/CSS

·         JavaScript, jQuery

Project: #4

Technical Support Specialist

Club Intrawest - Vancouver, BC -                                          


Company Profile:

·         Club Intrawest is the member services for Intrawest Corporation which is a leading Time Share Fortune500 firm.

Intern Objectives:

·         Support Agent for Servers, Desktops, Laptops

·         Hardware & Software Support agent * Implementation Aid * Installing and Setting Up:

·         Windows OS

·         Windows Server OS

·         MS Office

·         Symantec Ghost

·         Norton Anti-Virus

·         Altaris

·         Wide (WAN) and Local Area Network (LAN) specifications for computers and servers

·         Support Duties Include:

·         Implementing and testing all systems worked

·         Citrix Neighborhood Client setup and installation

·         VPN software install and specified settings

·         Applied Group Policy on computers and servers

·         Setup & Deployed: Symantec Ghost images for Citrix

·         Setup & Deployed: Server, Laptop and Desktop workstations images

·         Scheduled server tapes changes

·         Provided Desktop support one-to-one * Provided remote desktop connections

Project: #3

Customer Feedback Analyst

Business Objects - Vancouver, BC -                                       


Company Profile:

·         Business Objects is today’s SAP. SAP is an information systems software developer

Intern Objectives:

·         As a Student Intern, acted as Information Specialist doing data analytics on Customer Feedback using MS Excel then Crystal Reports

Project: #2

Mastering Media Tech

Electronic Arts - Vancouver, BC -                                                         

Company Profile:

·         Electronic Arts is a leading Video Game developer which is commonly known best for their big-league sports games.

Contracting Purpose:

·         I was brought in to Master Media (Burn CDs, DVDs and Cartridges). As a Master Technician, there was the use of Automator’s to burning software: Mastering media for departments on CDs, DVDs and Cartridges.

Project: #1

Sales and Marketing Representative

Crossmark - North Vancouver, BC -                                      

Company Profile:

·         Crossmark is a Fortune 500 Marketing Strategy firm

Contracting Purpose:

·         I was brought in to work for Crossmark with Bell Canada Ltd providing training to market their product line. My role was to represent and add to sales in a Future Shop where these products were being sold over the Christmas Holiday shopping season.