Jatinder Singh
Montreal,QC
Summary
Solution-focused Application Support Analyst adept at enhancing system reliability and performance. Thrive in fast-paced environments, ensuring timely resolution of issues and completion of tasks. Key skills include troubleshooting, SQL database management, and script writing. Excel in communication, teamwork, and problem-solving to deliver seamless support and improve user satisfaction.
Overview
10
10
years of professional experience
Work History
Application Support Analyst
HCL Canada Inc.
Mississauga, Ontario
05.2022 - Current
- Currently promoted to Technical Lead.
- Working as the first point of contact for L3 issues.
- Creating packages, functions, and procedures as per new requirements in PL/SQL.
- Debugging and fixing PL/SQL issues.
- Developed scripts for automating processes using Linux to improve application performance.
- Assisted in the development of user documentation for new applications and features.
- Creating new Dashboards in Circle BI using JSON and PL/SQL.
- Worked with clients to determine their needs and develop appropriate training materials.
- Interfaced with internal teams to resolve application related issues quickly.
- Implemented bug fixes within the existing code base when necessary.
- Provided technical guidance and assistance to other team members as needed.
- Maintained a high level of knowledge regarding current industry trends and best practices in application support and development.
- Participated in design reviews and provided input on feature enhancements or changes that could improve usability and overall performance.
- Escalated technical issues to development or technical operations team following prescribed support guidelines.
Application Support Consultant
BNP Paribas
Montreal, QC
08.2021 - 05.2023
- Successfully implemented End To End installation of Projects: Metramodo, Quantum Lutron, WebCTRL in multiple premises
- Collaborated with third-party vendors on integration projects and initiatives.
- End to End monitoring of the data transfer and managing data flow
- RCA during data discrepancy
- Writing PLSQL queries as per client requirements as well as to automate the monotonous work
- Used Genesys automation tool
- Built up logic as per business requirement and implement them accordingly
- Deep understanding of Service Now tool (Change Management, Incident and Request)
Subject Matter Expert
Accenture Solutions Private limited
, Saskatchewan
03.2016 - 12.2019
- Handling the database of Philips Healthcare for Com-Ops (installation of new healthcare products) and SPS (Spare Part Services).
- Deliver optimal business process solutions, in line with corporate priorities, with the analytics team.
- Using data analysis techniques to validate business rules and identify low-quality, missing data in the existing tables on Reporting Tool/Business Objects.
- Verifying data using SAP (SE16N), developer module.
- Working with the Business Object team to fulfill their requirements.
- Providing accurate data to end users for reporting purposes.
- Working with the MDM team on SAP MM03 material module for troubleshooting errors to see the material changes.
- Development of new tables, writing merge, adding new columns, updating data, and deleting data as per client and end user requirements.
- Built up logic as per business requirement and implement them accordingly.
- Building bulk SQL loaders to import huge Excel data into Oracle tables.
- Communicate with source (Informatica) team regarding database health on a daily basis.
- Certification: LEAN Certified by Accenture and approved QEK's (quick and easy kaizen)
Quality Assurance
Girnarsoft Pvt Ltd.
Jaipur, India
08.2014 - 06.2015
- Created new documents to support quality assurance initiatives.
- Participated in quality assurance reviews as needed.
- Follow QBV(Quality Bar Violation) Rules in Test Cases of GDev
- Keyword Testing using Test Complete Tool
- Functional & Regression Testing
- Writing Test Cases
- Working with Gdev as one of our clients within a team of 15-20 people using TestComplete9, and Sahi Pro
Education
AEC - Information Technology- Programmer Analyst
LaSalle College
Montreal, Qc01.2021
Bachelor’s - Computer Science
Punjab Technical University
12-2011
Skills
- SQL
- PL/SQL
- ERP Tools - GOLD, SAP
- Job Monitoring tools - Visual Cron, OpCon, Genesys
- Ticket management - Jira
- Troubleshooting documentation- Confluence
- Supply Chain Management
- Application Support
- Basic Core Java
- Basic C
- Basic Aspnet
- Software Testing
- Test Complete9
- Sahi pro
- JSON
- HTML
- CSS
- ERP Tools - GOLD, SAP
- Job Monitoring tools - Visual Cron, OpCon, Genesys
- Ticket management - Jira
- Troubleshooting documentation- Confluence
- Unix
- Application monitoring
- UAT support
Timeline
Application Support Analyst
HCL Canada Inc.
05.2022 - Current
Application Support Consultant
BNP Paribas
08.2021 - 05.2023
Subject Matter Expert
Accenture Solutions Private limited
03.2016 - 12.2019
Quality Assurance
Girnarsoft Pvt Ltd.
08.2014 - 06.2015
AEC - Information Technology- Programmer Analyst
LaSalle College
Bachelor’s - Computer Science
Punjab Technical University
Similar Profiles
Prasanth KaruppusamyPrasanth Karuppusamy
Senior Technical Lead at HCL Canada Inc.Senior Technical Lead at HCL Canada Inc.
Vivek MathurVivek Mathur
Technical Lead at HCL CANADA INC.Technical Lead at HCL CANADA INC.
VINOD CHOWDARY KOLLURUVINOD CHOWDARY KOLLURU
Senior Technical Lead at HCL CanadaSenior Technical Lead at HCL Canada