Gurwinder Parhar

Developed and maintained advanced data management strategies and SQL-based databases (SQL, Azure), ensuring data accuracy and accessibility. Designed and implemented interactive dashboards, data models, and automated reports using Power BI, Excel, and Python, driving data-driven decision-making. Conducted in-depth analysis of transit data (e.g., schedule adherence, passenger volumes) using SQL, Python, and Power BI to provide actionable insights. Implemented rigorous data quality checks,leveraging SQL and Python scripts to reduce errors and ensure high data integrity. Collaborated with stakeholders to translate complex data into clear, actionable recommendations using Power BI, Excel, and strong communication skills. Managed data collection and integration from diverse sources, including APC/AVTS systems, field surveys, and onboard checks, ensuring comprehensive data coverage. Led process improvements using data analysis tools (Power BI, Excel, Python) to enhance operational efficiency and reduce costs. Leveraged programming skills in Python, R, and JavaScript to automate reporting processes and streamline data workflows. Played a key role in transitioning to cloud-based data infrastructure using Azure, enhancing data security, scalability, and accessibility. Consistently delivered data-driven insights - through Power BI, Excel, and Python that improved decision-making and earned positive stakeholder feedback.

• Coordinate and conduct comprehensive training program for Calgary Transit. These programs consist of classroom presentations, on-line instruction, on-board instruction and daily coaching and evaluations. • Train new employees to provide positive and accessible public transit service through out the city in time sensitive manner and present City of Calgary image positively • Help recruitment team in screening new applicants and through out the recruitment process • Train employees to prepare different route with help of transit software and google map • Respond to customer needs such as information about schedules, routes, directions and transfer points • Report employee collisions or other traffic disruptions to Calgary Transit Control and preparing a report

• Perform various administrative and basic accounting functions such as research and billing support tasks, accounts receivables, transfer and key logs, run miscellaneous reports, supply maintenance, process customer billing • Dispatch the drivers in timely manner to pick up and drop off customers • Manage outbound calls for callback management, renewal options and services. • Provide a high level of customer service by helping customers to meet their needs and Also, provide directions and general assistance • Understand and communicate rental terms and conditions, vehicle features and other services • Sold optional protection products, upgrades, fuel options and other additional equipment

• Prepare reports and maintain the record of revenue and warehouse assets for higher management. • Investigate and report reasons for discrepancies and problem area with regards to reoccurring, adjustments, damages, and order pick errors and process issues. • Assist where necessary in training team member on inventory SOPs, Order Manager, SAP, LORP, and YMS. • Communicate to vendors and hazmat response team through emails and phone. Also, making sure product quality to match customer expectation. • Assist to higher management in special projects such as health and safety training. • Offers ideas to enhance inventory accuracy and process improvement. • Reporting of inventory record accuracy by location, case and value etc. • Create and maintain up to date inventory control procedures. • Conduct regular inventory account according to cert specifications. • Work closely with Customer to ensure inventory discrepancies are dealt with and advice Inventory Control Manager of any issue.

• Monitor and observe the day-to-day activities of subordinates, coordinates breaks for hourly associates, and keeps management informed of area activities and any significant problems • Complete daily opening and closing procedures/checklists in accordance with company policies/procedures • Coordinate with management for on-the-job training of new associates. • Operate cash register and voids transactions as needed while following all the company's cash handling policies and procedures, and maintains proper security of cash at all times • Transfer supplies and equipment between storage and work areas by hand or use of a hand truck. • Implement product rotation based on product code dates in warehouse and concepts, orders product and participates in physical inventory counts as required • Resolve customer complaints in a manner consistent with company policy, and with customer satisfaction in mind • Practice excellent food safety and sanitation practices and complies with HACCP standards • Monitor compliance with safety guidelines, builds awareness about safety, and reports any safety concerns to management.

• RF/Network planning optimization solutions for GSM , CDMA ,WI MAX, 3G, 4G networks. • Microwave Link Planning & LOS Surveys. • EMF Surveys and Measurements. • Network installation and commissioning services to various vendor. • Microwave installation and commissioning. • BTS/BSC/NODE B installation and commissioning. • BSC / RNC AND Transcoder installation.

Python - Numpy, Pandas, Matplotlib, Seaborn SQL - Different type of joints etc and Querying with Sql Talbeau - Basics of Tableau R - Basics of R

HRIS And Advanced Software Advanced professional communication Canadian labour laws Strategies for training and development Management of recruitment and its strategies Occupational health and safety