Gurjeet Sabharwal

Experience

• 

  Bhaskaracharya Institute For Space Applications and Geo-Informatics

  Sept 2021 - Feb 2022

  Software Intern

  ● Worked on 2 major projects - 1st was a Covid tracking app used by the State Govt. to track vaccination status, quarantine information of residents of theState of Gujarat and the 2nd project was an Electrophoresis result software that reported results, had a SQL database and JavaFx desktop app.● Supported database management and optimization of said Electrophoresis result software and Covid tracking app.● Assisted POs, developers and SMEs with sprint planning, DSUs, backlog grooming sessions through accurate story points by working with various teams for 2major projects to support product development.● Collaborated with project teams to ensure agile development processes, database integrity, and efficient data processing.● Helped prioritize product backlogs and new requests in JIRA and Confluence to prioritize release features.● Contributed to data reporting, test strategy development, executing test plans, QA testing and UAT using Selenium, Swagger, and JTMF ensuring at least 80%code coverage. Show less

• 

  Savers | Value Village

  May 2022 - Jun 2022

  Retail Associate

  Summer job.

• 

  FedEx

  Sept 2022 - Dec 2022

  Intern

  ● Javascript - Worked on a project to migrate RF scanners from legacy to a 50% more efficient newer system eliminating the use of C++ code and utilizingJavascript and REST APIs as the primary softwares.● Created and defined executive level metrics for reporting by centralizing the data gathering process of said metrics using Python and presented the findingsas sets of Tableau dashboards for agile decision making.● Documented system requirements, creating user stories with precise acceptance criteria in JIRA in agile environments.● Collaborated with architects and developers, ensuring clarity in architectural design and software requirements.● Performed backend testing using MySQL Workbench, ensuring data integrity, assisted in automation testing for website testing by integrating NightwatchSelenium and providing pre-go live and post-go live support for 3 projects ensuring at least 80% code coverage. Show less

• 

  Bell

  Jan 2023 - Apr 2024

  Support Analyst

  ● Proprietary BI Tool Support: Supported and resolved issues with the proprietary BI tool, Horizon, which had an MS SQL Server backend with ETL workflows feeding it datawith a reporting front-end) that presented performance metrics of operations and field employees.● Wrote SQL scripts to correct various issues, and reviewed system logs to determine the root causes of issues● Conducted data mapping exercises, enhancing data accuracy between applications to define relations between databases● Assisted with several projects E2E, from identifying requirements, reporting, QA testing, and partner dependencies to workload balancing.● ServiceNow Ticket Management: Managed tickets assigned in ServiceNow, taking action based on complexity, priority, and impact.● Python Code Analysis: Analyzed, debugged and fixed Python code used for web-scraping, file-moving tasks, and data-fetching jobs.● Incident Escalation with Jira: Created Jira tickets for complex incidents that required escalation to the build team.● UAT and Web Testing: Utilized Swagger and Postman for UAT and web testing to assist with development projects other than BAU activities. Show less

• 

  Paladin Security Group Ltd

  Dec 2023 - Apr 2024

  Dispatcher
• 

  Invesco Canada

  Apr 2024 - now

  Advanced Analyst, Eng. Run

  ● Currently leading the design, development, and architectural planning for three automation projects to optimize Alfresco BAU activities and resolve associated blockers. Main SME for Alfresco BAU activities on the team, responsible for KTs and publishing technical documentation.● Excel File Transformation and Upload Automation: Automating the manual process of transforming and uploading Excel, INI, and config documents provided bybusiness partners. A file-watcher job will detect files placed in a network location by BPs, process them via a Python script, and upload them to the Alfresco repository(UAT, Dev, Prod) using Mulesoft API. ● JAR Script Automation: Automating the execution of a manual JAR script that updates existing documents in Alfresco with newer versions. This process leverages Stonebranch UAC and batch scripts to streamline updates.● Downstream Distribution Failure Notification: Automated the process of sending emails to business partners reporting downstream distribution failures fromAlfresco to other reporting systems. ● HTML, XML work: Analyzed, debugged, and performed root cause analysis of faulty HTML, XML, CSS and SQL code in the GCCP application (a proprietary tool with anHTML, XML, and CSS front-end and a SQL back-end) for real-time incidents reported via ServiceNow. Implemented quick fixes, code changes, and enhancements, anduploaded and/or changed data, collaborating with cross-functional teams to ensure timely resolution.● Reporting Applications work: Conducted support activities, code analysis, code fixes, workflow analysis (using Informatica suite - like workflow monitor, analyzer and manager), data corrections for Invesco's Reporting and Data Delivery applications, including Oracle Analytics Cloud, Power BI, and Invesco websites.● Proficiency in Mulesoft and REST APIs: Gained proficiency in Mulesoft, REST APIs, RAML, and Javascript to enhance system connectivity and understanding of systemintegrations. Show less