Summary
Overview
Work History
Education
Skills
Security Clearance
Timeline
Generic

Mohammad Sheikh

Ottawa,ON

Summary

Over 8 years of combined experience with development in industries including banking, shipment, education, and finance Highly experienced in developing and providing support in migrating websites, hosting websites internally and externally for public Expertise in analyzing business and data requirements to develop business solutions including data models, pipelines, business rules, data life cycle management, governance, lineage, and reporting Expertise in automating complex business processes using Web frameworks, REST services, APIs and programming languages including Java, JavaScript, HTML, CSS and MySQL Excellent organizational skills, communication, teamwork, problem-solving skills, able to meet deadlines and experienced in Agile methodologies Ability to multitask in a fast-paced Agile work environment, have strong work ethics, trustworthy and bondable with ability to learn quickly

Overview

8
8
years of professional experience

Work History

Programmer Analyst/ Developer

Canadian Space Agency
Ottawa, ON
08.2024 - Current
  • Involved in various phases of the Software Development Life Cycle of the application, such as requirement gathering, design analysis, code development, testing, and deploying.
  • Participated in weekly team meetings with project managers, business analysts, testers, and other team members.
  • Supported the development of eight EGI tools, each built on different programming languages like Java, Angular, JavaScript, Vue.js, PHP, C Sharp, Python and using different databases like Oracle, Postgres, MariaDB, MongoDB, and MySQL.
  • I used Spring Tool Suite in a Linux virtual machine to test, debug, and deploy code using a JAR file.
  • Implemented Java EE components using Spring MVC, Spring IoC, Spring transactions, and Spring security modules.
  • Implemented code for applications using the Spring Boot framework, and handled the security using Spring Security.
  • Worked with Spring MVC and Hibernate in the backend to build the business logic.
  • Developed a data access layer using Hibernate and the DAO design pattern.
  • Used Apache Flink for stateful stream processing in event-driven applications.
  • Used the CSA task tracking tool and Jira to investigate SARs and action items that were assigned, provide task completion estimates, and propose solutions.
  • I tested the code in Eclipse and Spring Tool Suite, held code reviews, and deployed the code in the dev and UAT environments.
  • Responsible for setting up Jenkins, creating pipelines to automate, build, test, and deploy processes.
  • Implemented containerization technologies such as Docker and Kubernetes for faster delivery cycles.
  • Responsible for installing and setting up OpenShift for deploying and managing containerized applications
  • SonarQube was used as a tool for continuous inspection of code quality, identifying bugs, and vulnerabilities.
  • Worked with writing, handling Kafka producers sending messages to the queue, and consumers receiving messages from the queue.
  • Used Postman and SoapUI for testing endpoints and functionalities of the application, and frameworks like Karate for Java-based applications.
  • Created and automated test cases, and test scripts to optimize performance.
  • Integrated multiple data sources into one unified view using views or joins in SQL queries.
  • Developed stored procedures, functions and triggers to support application requirements.
  • Analyzed business requirements and translated them into logical data models.
  • Implemented ETL processes using SQL and additional tools to migrate data across different systems.
  • Optimized existing queries for better performance using SQL query tuning techniques.
  • Developed database schemas, scripts, and models in collaboration with application developers to meet project requirements.

Software Developer

Innovapost Transition to Deloitte
Ottawa, ON
02.2022 - 08.2024
  • Played a key role as a developer/production support person for the team, mainly supporting two applications: GTP (Global Trade Platform) and GDE (Global Direct Entry).
  • Participated in daily stand-ups and meetings to discuss ongoing issues, possible solutions, and dividing up work with the team.
  • Assisted with the Java backend development, API fixes in the Jira ticketing system, using Agile methodology. Worked with technologies like Spring, Hibernate, Web Services, JUnit, XML, JMS, Struts, JSP, XLS, Servlets, EJB, JMX, JTA, and JCA.
  • JavaBeans, JDBC, Ajax, Angular JS, JavaScript, JSF, and source code version control tools were involved in the implementation of MVC architecture using Spring MVC, Struts, and extensively used J2EE design and Java patterns, Spring.
  • Integration, Spring Security, and Bean Validation
  • Worked with the Spring framework, bean configuration file for dependencies.
  • Used annotations and XML-based configuration to inject dependencies into classes.
  • Involved in website customizations using Angular 12+, JavaScript, Node.js, HTML5, CSS3, jQuery, JSON, and Bootstrap.
  • Worked with CSS background, CSS positioning, border, margin, padding, pseudo classes, and behaviors. Involved in designing the user experience interface, UI/UX strategy, UI requirements, and converting findings into UI design.
  • Worked extensively on Angular 12+ Single Page Application domains, Angular directives, controllers, reactive forms, filters, dependency injection, services, templates, events, and injectors, integrated with Node.js server-side code.
  • Developed and maintained scalable and robust backend systems using Python.
  • Developed Python scripts to automate data processing tasks.
  • Designed and developed web and N-Tier applications using C#, ASP.NET, ASP.NET MVC, ADO.NET, Entity Framework, and Razor.
  • Developed user controls using ASP.NET, VB.NET, and C#, and used them dynamically in web pages using master pages.
  • Worked with Apache Flink for processing and moving data across systems in event-driven applications.
  • Worked on the REST/Web API to create the services, and tested them on Postman.
  • Deployed web application using WebLogic, created Web Application Archive (WAR) file containing the application, and deployed it on the server.
  • Provided WebLogic administration, monitoring, and troubleshooting using the admin console and JMX.
  • Designed and developed architecture, page layout, navigation, graphics, and other elements of the website. Involved in creating, modifying, and deleting user accounts and groups within Active Directory.
  • Planned and implemented disaster recovery strategies for Active Directory, including backup and restore procedures. Worked with database engines, Oracle, and MySQL Workbench.
  • Handled all database production support requests for the team coming from Purolator and Canada Post Group of Companies.
  • Led the development of a side project from the manager called mulF induct to add a functionality to the existing application.
  • Improved system performance by optimizing database queries and implementing caching mechanisms.
  • Collaborated with the QA team to identify and fix bugs, and improve overall software quality.
  • Implemented security best practices to safeguard sensitive data and ensure compliance with industry standards.
  • Involved in DevOps activities such as continuous integration, continuous deployment, containerization using tools like Docker, Kubernetes, etc.
  • Regularly prepared database scripts and PL/SQL programming to resolve database production issues. Performed PL/.
  • SQL programming with stored procedures, functions, indexes, packages, SQL tuning, etc.
  • Performed complex SQL queries to look up and modify company data stored inside the database. Created new schemas for different projects, insertion and deletion of tables within schemas, moving data from existing platform to a new database instance.
  • Refactored, tuned SQL scripts to modify and extract company data, created and managed schema objects like tables, views, indexes, stored procedures, functions, and triggers.
  • Used different joins, subqueries, and nested queries in SQL queries.
  • Performed DML, DDL operations as per business requirements.
  • Worked with Behavior Driven Development and Test-Driven Development (TDD) frameworks using JUnit. Frequently set up and hosted Lambda functions in AWS to send out reports and email notifications to the team members and stakeholders, containing production data for data analysis.
  • Created and presented comprehensive reports and visualizations to support decision-making processes. Analyzed and interpreted large datasets using data visualization tools like Excel, Power BI, and Tableau. Full-time analyzing emails and reports being sent to the team from the production environment, indicating any failures with batch processing and taking the necessary action to rectify the issue.
  • Involved in supply chain activities like onboarding different customers and retailers, pulling packages, parcel information from database engines, and sending out to Purolator and Canada Post operations. Frequently attended meetings with big retailers and shippers like H&M, American Eagle, Carhartt, Williams Sonoma, EShopWorld, and others to understand project requirements and troubleshoot any issues.
  • Used Eclipse IDE for Java backend development and Visual Studio Code for front-end ISS-GTP application. Performed deployments in AWS dev server and tested server-side changes through MySQL Workbench database, deployed in the staging environment as well as production with the team.
  • Performed unit testing and integration testing on the application using JUnit and Spring Test. Gained hands-on experience using Amazon Web Services to test, deploy, and debug code.
  • Frequently accessed AWS server logs to debug and troubleshoot code.
  • Used the company’s standardized IDEs, such as Eclipse and IntelliJ, for Java backend development, and GitHub for creating/cloning repositories and merging source code.
  • Developed and consumed REST web services.
  • Used Postman and Advanced REST Client to test web services.
  • Developed both XML and JSON requests and responses using REST.
  • Used the following tools for API testing and automation: Postman, Rest Assured, SoapUI, TestNG, or.
  • JUnit used JUnit, Mockito, and Karate as frameworks to test Java applications.
  • Performed test planning, test case design, test execution, and defect tracking.
  • Performed black-box testing, white-box testing, functional testing, regression testing, and performance testing.
  • Extensively used testing tools such as Selenium, JIRA, TestRail, and LoadRunner.
  • Conducted tests on Node.js applications and performed JavaScript testing using Jest, Supertest, and.
  • Cypress
  • Developed and executed test plans and test cases based on project requirements and specifications.
  • Identified, documented, and tracked software defects using bug tracking systems.
  • Collaborated with developers, product managers, and other stakeholders to resolve issues and improve product quality.
  • Participated in Agile scrum meetings and provided input on product features and improvements.
  • Participated in discussions with the cloud security, cloud migration platform teams, and database upgrades.
  • Reported bugs, issues found in the application code depending on specification changes coming from the business side to the development team, and proactively gave snapshots of the fixes and time estimates to complete them.
  • Gained experience with setting up CI/CD pipelines, used Maven to create builds and JAR files needed for the deployments on servers hosted in AWS.
  • Responsible for setting up Jenkins, creating a pipeline to automate, build, test, and deploy processes.
  • Responsible for configuring Jenkins to pull code from a repository, e.g., GitHub, and trigger builds on code changes, and run UI tests.
  • Responsible for installing and setting up OpenShift for deploying and managing containerized applications.
  • Worked with Java 8, JEE application, and had to write good, readable code in company standards using techniques like multi-threading and unit testing.
  • Always used principles like object-oriented programming and test-driven development when implementing.
  • Used Kaqa message queues for handling asynchronous tasks.
  • Worked on front-end development with REST API design.
  • Frequently checked SFTP folders on WinSCP for any issues with the intake or processing of files that would need to be consumed by our GTP application.

Senior Developer Analyst

National Bank of Canada
Ottawa, ON
09.2021 - 01.2022
  • Project: Credit Card Pricing Approval Application.
  • Involved in analysis, design, development, UAT, and production phases of the application.
  • Worked on the implementation of an application that is used by National Bank of Canada executive teams to provide appropriate credit line approvals for the submitted request.
  • Architect optimal solutions to address business problems and requirements, and collaborated with other developers and business analysts to plan, design, develop, test, and maintain app solutions based on MS Power Platform, Office, and Azure cloud platforms.
  • I learned how to use Azure DevOps and how to use it to set up pipelines.
  • Planned and implemented disaster recovery strategies for Active Directory, including backup and restore procedures, assigning appropriate permissions, managing group memberships, and implementing password policies.
  • Implemented guidelines that enforced the use of complex passwords, regular password changes, and password length requirements, multi-factor authentication, and restricted access privileges.
  • Set up DEV, UAT, and PROD environments for the application, and conducted testing of the application to ensure the application is error-free and working according to the client's requirements.
  • Developed quality solutions using Power Apps, which include CRUD functionality, multiple filters to allow different views for Relationship, Pricing, and Compliance teams, search records, components, reporting features, approvals, escalation, and resubmission of requests.
  • Understand business requirements, translate them into designs, lead, and take part in proof-of-concept prototypes, and final deliverables.
  • Documented best practices and references in developing and deploying solutions.
  • Created test cases, debugged code, and contributed to testing stories created by the BA.
  • Contributed to the budgeting and informed senior management of project scope changes. Worked in a Scrum Agile process with daily stand-up meetings.
  • Project: National Bank of Canada Website.
  • Involved in key Agile processes – daily scrum meetings, scoring user stories, feature development sprints, code, and quality reviews using Git Extension and JIRA.
  • Assigned JIRA tickets to junior programmers and analysts, conducted code reviews, provided feedback, and solved highly complex JIRA incident tickets with complex business requirements.
  • Held client requirements gathering meetings with the development team, and was involved in performing testing for user access, GUI layout, functional, and integration.
  • Continuous Integration CI tools like Jenkins or GitHub Actions were used to automate running tests whenever code changes were made.
  • Deployed web applications in Tomcat server environments utilizing DevOps tools like Jenkins, Docker and Kubernetes.

  • Implemented containerization technologies such as Docker and Kubernetes for faster delivery cycles.
  • Built National Bank website customizations with JavaScript, Node.js, HTML, CSS, and maintained web application in Visual Studio, and used Git for the collaboration/management of code.
  • Involved in GUI design, website customizations using Angular, JavaScript, Node.js, Vue.js, HTML5, CSS3, and jQuery.
  • Developed and maintained scalable and robust backend systems using Python.
  • Developed Python scripts to automate data processing tasks.
  • Configured and maintained development and production environments for Python applications.
  • Created simple and scalable code for SPA using Angular and Angular CLI to develop and maintain the Angular application.
  • Created TypeScript Angular components, directives, services, and reactive forms to collect input from the user, and Angular routers to enable navigation from one view to the next.
  • Performed code reviews and unit testing where possible.
  • Involved in gathering, design, development, and testing application using ASP.NET MVC.
  • Assisted with the Java development in the Jira ticketing system using Agile methodology.
  • Created new user accounts in Active Directory, assigned them the necessary group memberships, and configured the accounts to enforce password complexity requirements.
  • Worked extensively in core Java, Struts, Spring (Core, MVC, AOP), Hibernate, JSP, EJB, JDBC, JMS, JMX, and JTA.
  • JCA, Servlets, JavaBeans, source code version control tools.
  • Involved in the implementation of MVC architecture using Spring MVC, Struts, and extensively used J2EE design and Java patterns.
  • Worked extensively with Spring Core, Spring Integration, Spring Security, and Bean Validation. Used Oracle database and performed SQL development, wrote stored procedures, packages, procedures, and functions using PL/SQL.
  • Performed integration testing with SuperTest, end-to-end testing with Cypress, and unit testing in JavaScript using Jest and Karate frameworks.
  • Tested RESTful APIs with REST Assured by making HTTP requests and validating responses. Led test automation implementation and guided testing approaches for new feature development. Carried out regression testing using Selenium after each medication and enhancement.
  • Analyzed and interpreting large datasets using statistical techniques and data visualization tools. Collaborated with cross-functional teams to gather data requirements and deliver actionable insights for business improvement.
  • Picked up medium to high priority tickets each day, completed them on time, and presented them to the scrum master.
  • Investigated and fixed development front-end and back-end issues in the Compass website appearing in the Kanban board. Developed and maintained back-end services using Java and related technologies.
  • Collaborated with front-end developers to integrate user-facing elements, using server-side logic.
  • Implemented RESTful APIs to support various client applications.
  • Conducted code reviews to ensure code quality, performance, and adherence to coding standards.
  • Participated in the full software development lifecycle, from requirements gathering to deployment.
  • Worked on database design, optimization, and maintenance.
  • Used Urban Code Deploy to deploy code into the DEV and UAT environments for the Compass website, which is the main website of the company.
  • Tested code in production environment of the company to ensure no functionality is broken.
  • Postman to test different endpoints of the applications, did manual and other automated testing.
  • I wrote test cases in Java and worked on testing stories assigned by the team on a weekly basis.
  • Bitbucket was used to access the company's project code repositories and check them out in SourceTree.
  • Created pull requests after making changes to the code and merged files into the master branch.
  • Manually cloned repositories, removed files, or added them to Bitbucket using Git Bash.
  • Developed JEE applications using JDBC, Servlet, EJB, and Spring Boot REST APIs.
  • Used Eclipse and IntelliJ to integrate code-based features, and the Eclipse debugger to improve the quality of code, and implemented software design code using the MVC pattern.
  • Analyzed large datasets to address strategic and operational business questions.
  • Developed and maintained databases, data systems, reorganizing data in a readable format.
  • Leveraged SQL queries to extract, transform and load data into databases.
  • Developed dashboards with Tableau to monitor key performance indicators.
  • Developed ETL packages to extract, transform, and load data from multiple sources into a data warehouse.
  • Designed and developed stored procedures, functions, views and triggers using T-SQL for efficient data transformation.
  • Worked closely with Business Analysts, System Analysts, Data Architects in gathering requirements for developing ETL solutions.

Software Developer

Mthree Wiley Edge
Ottawa, ON
05.2021 - 09.2021
  • Web Portal Project.
  • Involved in key Agile processes – daily scrum meetings, scoring user stories, feature development sprints, code, and quality reviews.
  • Built user interfaces using HTML, CSS, and JavaScript, Angular, and provided bug fixes.
  • Performed SQL development and stored procedures.
  • Developing JEE applications using JDBC, Servlets, EJB, and other technologies.
  • Involved in the implementation of MVC architecture using Spring MVC, Struts, and extensively used J2EE design and Java patterns.
  • Responsible for front-end and back-end development, and assisted with key user interface and architectural design.
  • Tested and validated work produced as part of the development process, and provided UML and design reports to the management.
  • Implementing security and password policies using Active Directory.
  • Created Spring Boot web apps using Spring Boot with Thymeleaf and Spring Boot with JDBC Template.
  • Worked with MVC, tiered application design, and service layers, controllers, and DAO implementations. Front-end development with REST API design using CRUD.
  • Developed stored procedures, functions and packages using PLSQL to support the application development needs.

Programming Coordinator

Carleton University
Ottawa, ON
04.2018 - 05.2021
  • For Web Development, Data Structures, and Discrete Mathematics, I held weekly tutorials to help students understand their coursework, assignment problems, and upcoming exams.
  • Coordinated weekly tutorial sessions with other TAs and professors to deliver the best set of problems to students in order for them to succeed in their courses.
  • Participated in Java-based software test automation tools, which automatically marked the submitted assignments and checked for plagiarism.
  • Answered web development, Java, and discrete math questions during meeting hours and over emails.
  • Held group tutoring sessions to help students struggling in computer science courses, mainly with Java, Python, C#, HTML, CSS, and JavaScript programming languages.
  • Installed automation testing tools and software to run, debug, troubleshoot, and test code for assignments, labs, and projects.
  • Performed unit testing, integration testing, regression testing, and manual testing.
  • Performed testing on JavaScript code using frameworks like Jest.
  • Monitored student progress and provided feedback to both students and teachers.
  • Established positive relationships with students, parents, fellow teachers and school administrators.
  • Maintained accurate records of student attendance, grades, and behavior reports.

Software Developer

Carleton University
08.2019 - 06.2020
  • Worked with a team of qualified developers, with the assistance of research computing specialists and other IT professionals, to provide research software solutions for researchers across Carleton University.
  • Worked with the computing research manager to implement solutions for their application.
  • Led and participated in software-related activities to enhance or reuse existing software tools for research.
  • Managed ongoing research software projects, produced metrics, reports, and other documentation as required.
  • Provided expertise to researchers on existing software, development environments, languages, libraries, methodologies, and team recruitment.
  • Worked extensively in core Java, Struts, Spring (Core, MVC, AOP), Hibernate, JSP, EJB, JDBC, JMS, JMX, and JTA. JCA, Servlets, JavaBeans, source code version control tools.
  • Involved in the implementation of MVC architecture using Spring MVC, Struts, and extensively used J2EE design.
  • Involved in design, configuration, documentation, and support of active directory services as directed by the technical lead.
  • Surveyed existing research software and tools, including software available on their website, science.canarie.ca.
  • Worked with the Carleton Office for Research Initiatives to assist researchers in proposal writing for software components of research proposals.
  • Interface with similar groups at other institutions, either directly or through a formal organization.
  • Develop and track metrics to evaluate and report the effectiveness and value of the team to researchers on and off campus.

IT Developer / Architect

Securitas Canada
Ottawa, ON
01.2017 - 04.2018
  • Securitas Canada is a security services company that provides a range of security solutions to businesses, organizations, and individuals across Canada.
  • The company is a subsidiary of Securitas AB, a global leader in security services with operations in over 50 countries.
  • The project was designed to build an application that sends a mobile guard an alert message and shows where the breach and fire alarm is happening.
  • The project required bringing Securitas clients' site data, which was stored in 2013 SharePoint, into MySQL.
  • Tasks Performed:
  • Documented the SharePoint 2013 data structure, including lists, libraries, content types, and relationships.
  • Identified corresponding tables and fields in the MySQL database for each SharePoint data element.
  • Employed tools like ShareGate, PowerShell scripts, or third-party ETL tools to extract data from SharePoint lists and libraries.
  • Exported data to intermediary formats like CSV or Excel for ease of transformation and loading into MySQL tables using MySQL Workbench.
  • Developed a user login authentication page using HTML and CSS.
  • Assigned appropriate permissions, managing group memberships, and implementing password policies.
  • Implemented guidelines that enforced the use of complex passwords, regular password changes, and password length requirements, multi-factor authentication, and restricted access privileges.
  • Used Java web development and Java servlets (compiled in Eclipse) to connect to a MySQL database. Ensured all systems on the network were up to date and securely connected by managing vSphere, VMware.
  • Resolved IT requests for all incoming mobile patrol tickets relating to end-user software and hardware issues for Windows 7 devices, by using TeamViewer for remote control, screen share, and troubleshooting.
  • Managed and maintained all internal IT operations, PC hardware, software, and peripherals.
  • Created an automation test plan, wrote and executed test cases, and maintained and prepared defect tracking reports in Jira.
  • Performed end-to-end testing on the application code and its functionalities.

Education

Bachelor of Computer Science -

Carleton University
Ottawa, ON
01.2022

High School Diploma -

Sir Wilfrid Laurier HS
Ojawa, ON

Skills

  • Agile/Scrum
  • Angular 8/Typescript
  • Java/J2EE/Spring
  • Python
  • NET/C#
  • MySQL
  • PL/SQL
  • Databases
  • JavaScript/Jest/Puppeteer
  • Vuejs
  • Zephyr
  • Selenium
  • Postman
  • Regression Testing
  • Jmeter
  • TestNg/Junit/Javascript
  • API, REST services
  • JIRA/Kanban
  • Building CI/CD pipelines using Azure DevOps
  • OpenShift/Jenkins/Docker/Kubernetes
  • Active Directory
  • Data analysis and visualization
  • Object-oriented design
  • Software development life cycle
  • AWS services
  • Microsoft Office
  • Web technologies
  • Eclipse/IntelliJ/VS code/MyEclipse
  • Nodejs
  • Risk Management
  • Leadership
  • Problem Solving
  • Critical Thinking
  • Data Analysis
  • Collaboration
  • Project Management
  • Financial Analysis

Security Clearance

Active Enhanced Reliability and Secret Clearance

Timeline

Programmer Analyst/ Developer

Canadian Space Agency
08.2024 - Current

Software Developer

Innovapost Transition to Deloitte
02.2022 - 08.2024

Senior Developer Analyst

National Bank of Canada
09.2021 - 01.2022

Software Developer

Mthree Wiley Edge
05.2021 - 09.2021

Software Developer

Carleton University
08.2019 - 06.2020

Programming Coordinator

Carleton University
04.2018 - 05.2021

IT Developer / Architect

Securitas Canada
01.2017 - 04.2018

Bachelor of Computer Science -

Carleton University

High School Diploma -

Sir Wilfrid Laurier HS
Mohammad Sheikh