An accomplished Information Systems professional with extensive experience in bringing high-end technology to corporate clients. Distinguished ability to build and motivate teams, conduct strategic planning and manage projects, to conduct accurate needs analysis, solve problems, assess technical capabilities, develop software solutions, all of which comes from broad experience in an IBM and Windows environments.

SUMMARY OF QUALIFICATIONS

oCarry out analysis functions by gathering, reviewing, analyzing and evaluating detailed business requirements, documentation, process flows and developing projects including: project requirements documents, IT business process design, IT business process documents, and cost/benefits analysis using best practices of process design and documentation and review, guide and authorize the development of project specifications.

oAssign, co-ordinate and review projects. Meet with clients to discuss system requirements, specifications, costs and timelines.

oPlanning, organizing, directing, controlling and evaluating daily operations keeping in mind the ROI.

oSupport system implementation and production readiness by liaising with developers, IT architecture, organization change management and the business.

oDevelop use cases, define and document user procedures and workflows, and how each class of user interacts with new and/or existing solutions.

oOrganize and run Joint Application Development (JAD) sessions with different groups of users including Subject Matter Experts (SME), other technical staff, vendors, and contractors to understand business and/or system requirements that drive the analysis and design of system enhancements and project implementations.

oiSeries, AS/400 and s/38 platforms hardware/software, operations and connectivity.

oExperience with AS400/iSeries Operational Support, Job Scheduler, and Error Messages.

oExperience with adding/ deleting user profiles within AS400.

oExperience in customer facing and training.

oFluent in RPGII, RPGIII, RPG400, RPG-ILE, COBOL, CLLE, CLP, SDA, Query/400 and SQL400.

oMicrosoft Office Suite - WORD, PROJECT, VISIO, EXCEL and ACCESS.

oWin2K, networking, Exchange, Internet, Firewalls and Active Directory.

oJD Edwards World Version and JD Edwards EnterpriseOne software development and support in the following modules: Order Entry, Invoicing, Distribution, Shipping, Accounting, Sales Analysis and Payroll.

oJDA Software – Third Party Distribution and Logistics - EDI, Order Entry, Invoicing, Distribution, Shipping, Accounting and Sales Analysis.

oLeading team members and client departments in the implementation of projects.

oProject and change management.

oUser guidance (testing), training (enhancements) and interviewing (needs analysis).

oFull project life cycle (SDLC) with focus on user interface and documentation.

oDisaster Recovery planning, implementation and support (revisions).

oData conversion, analysis and mapping (legacy system vs. new system).

oMicrosoft Server Reporting (SSRS) - creation, deployment, managing of reports with the full range of ready-to-use tools and services.

oExcellent oral and written communication skills and superior analytical investigative skills.

oNatural inquisitive nature to understand the business and system processes so that IT adds business value to the projects worked on.

oCapable of working independently, relying on business knowledge.

oAbility to learn quickly and apply strong creative problem solving skills.

oAnalytical and creative while applying strict attention to detail in all matters pertaining to assigned tasks.

oSelf-motivated and proactive.

oExperience developing solutions with distribution & warehouse management packages i.e. JBA/LogPro/DPR.

oExperience developing WEB based solutions utilizing CGI/RPG and HTML standards.

oExperience with EDI AS400 software (i.e. TrustedLink) and EDI/AS2 over internet, mapping of transaction sets and application interfacing from/to trading partners.

oExperience with AS400 file transfer protocols; FTP, SFTP, FTPS, QSHELL and IFS.

oExperienced with AS/400 database tools such as; Hawkeye/DBU.

PROFESSIONAL EXPERIENCE

XTL Transportation Co. – Toronto, Canada (Remote) Feb 2023 – May 2023

AS/400 (iSeries) - EDI developer

Develop, test, analyze and maintain existing and new EDI software applications in support of the achievement of business requirements (according to specifications received from customers). Assist IT Manager to resolve issues with transmissions. Housekeeping of IFS to check or clear transmissions.

Other duties (programming in RPG free format or SQL) as requested.

McKesson Canada – Montreal, Canada (Remote) Nov 2021 – Nov 2022 AS/400 (iSeries) Sr. Programmer Analyst - Application developer

Define, develop, test, analyze, and maintain new software applications in support of the achievement of business requirements. This includes writing, coding, testing, and analyzing software programs and applications. Assist any other developers by leading projects or major development. Research, design, document, and modify software specifications throughout the production life cycle.

oCollaborate with Programmer Analysts, designers and the Manager of Application and Development in conceptualizing and development of new and existing software programs and applications.

oBusiness requirements gathering, Functional analysis & solution proposals following McKesson Canada’s standards & methodology;

oApplication development detailed design & programming following McKesson Canada’s standards & methodology;

oUnit, Volume, Performance, Functional, & Cycle testing execution and documentation;

oAssistance to business users in User Acceptance testing coordination & execution (as needed)

oSupport & transfer knowledge to Change Adoption Analysts for system documentation and release note preparation

oKnowledgeable on Supply Chain ERP: Warehousing/Order to Cash/Procure to Pay/MDM

Manitoulin Group of Companies July 2019 – July 2020 AS/400 (iSeries) Sr. Programmer Analyst - Application developer - EDI

Define, develop, test, analyze, and maintain new software applications in support of the achievement of business requirements. This includes writing, coding, testing, and analyzing software programs and applications. Assist any other developers by leading projects or major development. Research, design, document, and modify software specifications throughout the production life cycle.

oCollaborate with Programmer Analysts, designers and the Manager of Application and Development in conceptualizing and development of new software programs and applications.

oAnalyze and assess existing business systems and procedures with some guidance.

oLead in the definition, development, and documentation of software’s business requirements, objectives, deliverables, and specifications on a project-by-project basis in collaboration with internal users and departments.

oLead in defining software development project plans, including scoping, scheduling, and implementation.

oResearch, identify, analyze, and fulfill requirements of all internal and external program users.

oConduct research on emerging application development software products, languages, and standards in support of procurement and development efforts.

oLiaise with vendors for efficient implementation of new software products or systems and for resolution of any adaptation issues.

oRecommend, schedule, and perform software improvements and upgrades.

oLiaise with network administrators to assist in resolving problems with software products or company software systems.

oConsistently write, translate, and code software programs and applications according to specifications.

oWrite programming scripts to enhance functionality, scheduling and/or performance of company applications as necessary.

oDesign, run and monitor software performance tests on new and existing programs for the purposes of correcting errors, isolating areas for improvement, and general debugging.

oAdminister critical analysis of test results and deliver solutions to problem areas.

oGenerate statistics and write reports for management and/or team members on the status of the programming process.

oDevelop and maintain user manuals and guidelines.

oTrain end users or super users to operate new or modified programs when required.

oInstall software products for end users as required.

oManage and/or provide guidance to team members

oMaintain system data integrity to reduce impact and errors on all application

oWork professionally with external customers, Government Agencies and auditors

oCompliance of IT best practices, documentation procedures and company/government regulations

oWork within service desk environment to resolve customer issues

oLead other junior and intermediate analysts by example

oFluent in RPGII, RPGIII, RPG400, RPG-ILE, COBOL, CLLE, CLP, SDA, Query/400 and SQL400.

oExcellent understanding of ARCAD and Jira software

oExcellent understanding of coding methods and best practices, including the RPG Integrated Language Environment.

oExtensive relational database and operating systems experience with O/400 V6, DB2, MySQL, IBM query, NGS query

oThorough understanding of platforms such as Development Studio Client, ACMS

oSolid working knowledge of current Internet technologies, including web services, HTTP, XML,HTML

oProficient in EDI technologies including customer requirements, EDI specifications, system monitoring and VAN interfacing

oPrior experience interviewing end-users for insight on functionality, interface, problems, and/or usability issues.

oKnowledge of applicable data privacy practices and laws.

oAble to communicate effectively with non-technical staff and with members of interdisciplinary teams.

oFlexible and adaptable in regards to learning and understanding new technologies.

oStrong written, oral, and interpersonal communication skills.

oAbility to conduct research into software-related issues and products.

oHighly self-motivated and directed.

oKeen attention to detail.

oProven analytical and problem-solving abilities.

oAbility to effectively prioritize and execute tasks in a high-pressure environment.

oAbility to work both independently and in a team-oriented, collaborative environment

STAPLES Canada Oct 2018 – May 2019 AS/400 (iSeries) Sr. Programmer Analyst - Application developer

Provide iSeries based applications development and support services, including the design, creation and maintenance of moderate to complex custom developed applications and functions. Support cross platform interfaces and cross-functional projects with multiple business processes, by delivering high quality projects and support services.

oResponsible for delivery of assigned projects through the entire life cycle on a committed timeline.

oProvide iSeries applications development and support requirements and development specifications, programming, data setup, testing and implementation to deliver high quality business information processing systems.

oMaintain optimal software integrity, continuity and efficiency.

oProvide regular status updates of projects in progress.

oAssist in major iSeries operating system upgrades as required.

oWork with 3rd parties, (e.g. JDA, IBM, Staples U.S.) to determine problem solutions and corrective actions.

oPerform 24/7 on-call support for critical business applications.

oProvide training on applications and iSeries tools to various levels of the user and I.S. communities.

oProvide iSeries technical training to I.S. staff.

oAnalyze, design, test and implement enhancements to the enterprise system to meet the functional needs of the business.

oGather business requirements and provide solutions in RPG IV, RPG ILE, Control Language ILE, SQL scripting and RPG 400.

oIFS, ODBC, FTP/SFTP

oProject work including documentation

oJDA background – retail industry

oExperience with AS400 file transfer protocols; FTP, SFTP, FTPS, QSHELL and IFS.

Kohl and Frisch Oct 2017 – Mar 2018 AS/400 (iSeries) Sr. Programmer Analyst

oAddressed all project needs by interpreting specifications and writing the necessary software code in an efficient manner to deliver the desired results.

oPerformed extensive testing of programs to ensure bug free code.

oWrote testing scripts and processes to aid and execute IT internal quality assurance as part of the internal test team.

oDeveloped test data for the testing environment.

oWorked with internal and or external customers when required, arranging tests and diagnosing errors.

oKept communications open and current on status, issues, timelines, etc.

oProgramed all assigned modifications making sure that all technical needs were addressed.

oTracked project time and reported on status on a daily basis.

oMade recommendations on corrective actions and revised timelines.

oDeveloped any additional documentation to assist end users in utilizing the deliverables.

oAccepted other related tasks from the Director Information Technology (DIT) and or System Analyst (SA) as required.

oMade sure that all data elements were completed within the project.

oTested and implemented computer programs and provided training to user department testers and Help Desk Support Programmers.

oPrepared a project implementation plan with project manager (DIT or SA) and communicated plan to IT staff.

oCommunicated issues in a timely manner to the SA and or DIT on problems that would impact project deliverables and timelines.

oParticipated in test trial runs of the systems.

oPrepared or assisted in the preparation of technical, instructional or operational documentation i.e. Standard Operating Procedures (SOP)

oImplemented programs etc. as per department standards and processes.

oAdhered to IT Guiding Principles and Development Standards.

Red Apple Stores Inc. May 2017 – Sep 2017 AS/400 (iSeries) Sr. Programmer Analyst

o Analyze, design, test and implement enhancements to the in-house enterprise system to meet the functional needs of the business.

oShare in the Support/Maintenance of the enterprise software (JDA-MMS)

oShare in the Support/Maintenance of the POS (point of sale) software (JDA-WinDSS)

oShare in the after office hours on-call support

oBack up AS/400 team member during vacation periods

oAnalyze, design, test and implement enhancements to the in-house enterprise system to meet the functional needs of the business.

oGet high-level details and provide high-level solution.

oInterview users and get details required in designing.

oPrepare project plans and timelines for publication to user.

oDraw/modify flow chart, write/modify technical specs. (File layouts, Designing Reports etc.)

oCode program logic

oCreate files and report layouts

oCreate macros of interface to P.C.

oAssist and/or lead in testing programs and involve users in testing as needed and obtain user approval.

oIncorporate final changes

oJob scheduling

oDefining on Menu

oInform the users involved.

oCommunicate project status regularly to team and user.

oEnsure deadlines are met or that deadline date changes are communicated to the team and user.

oAssist in the creating user documentation including screen shots if applicable

oResearch problems and determine issue.

oCommunicate status of problem to user on a regular basis.

oIf problem can be resolved in-house, correct the problem.

oIf problem cannot be resolved in-house, log the problem with the software/hardware vendor (JDA or IBM).

oAssist vendor in finding/fixing problem.

oAssist IT staff and/or user in testing the fix.

oInform user of resolution and/or obtain written sign off.

oUnderstand the basic features and functions of the POS and the SDI-interface between JDA-MMS and the POS system (JDA-WINDSS)

oAbility to support the SDI-interface on the AS400 -

oIf problem can be resolved in-house, correct the problem.

oIf problem cannot be resolved in-house, log the problem with the software/hardware vendor

oAssist vendor in finding/fixing problem.

oAssist IT team and/or users in testing patches and fixes

oMonitor end of day system jobs on a daily basis.

oMonitor system performance on daily basis.

oRecommend and attend conventions that pertain to the individual’s area of responsibility.

oSubscribe to periodicals that pertain to the individual’s area of responsibility.

oShare in the Support/Maintenance of the enterprise software (JDA’s MMS)

oShare in the Support/Maintenance of the POS (point of sale) software (JDA’s WinDSS)

oBack up AS/400 team members – System Analyst/ Senior Programmer/Operator during vacation periods

oConduct research to remain up to date with emerging technologies that will enhance the company’s ability to design/enhance and run programs.

Hydro 1 Brampton (Alectra) Jan 2017 – Mar 2017 AS/400 (iSeries) Software Developer

oMaintain/Developed and Supported programs to allow users to perform day-to-day tasks in the billing software in RPGII, RPGIII, RPG400, RPG-ILE, CLLE, CLP, SDA, Query/400 and SQL400.

oUsed Compleo to integrate form(s) design in the AS/400 environment.

oUse of SQL, Query, Abstract/Probe.

oWork with IT and the various lines of business to evaluate complex user requests, projects, and clarify objectives and functional requirements for new or modified computer programs.

oDetermine feasibility and time required, compatibility with current system, and system capabilities.

oCode new or modified computer programs into existing systems and test program effectiveness. Evaluate error messages, modify codes and troubleshoot programming problems. Perform analysis of systems issues or changes.

oProvide assistance to IT team members with issues needing technical expertise or systems and/or programming knowledge.

Prudential Benefits Administration Services Inc. May 2014 – Dec 2016 Sr. Programmer Analyst

oDeveloped/Changed/Supported/Documented programs (systems) to allow users to perform Health and Welfare fund management to approximately fifty (50) independent plans and to the Student Benefits Administrators Inc. ("SBTA") in a multi-site iSeries (AS/400) environment.

oMaintained, developed, documented and supported in-house grown systems in RPGII, RPGIII, RPG400, RPG-ILE, COBOL, CLLE, CLP, SDA, Query400 and SQL400.

oPerformed queries (Query400) for users to drill down data and present it in a more user-friendly format.

oUsed SQL (strsql) to update master files as per user requests.

oExperienced in RxClaim: (the following describes the steps needed in adjudication)

oStep 1: Initial Processing Review (yes or no to claim)

oStep 2: Automated Review

And / Or

oStep 3: The Manual Review (for exceptions and/or duplicates)

oStep 4: Payment Determination

oStep 5: Payment

oStep 6: Billing

oPerformed tasks based on the work flow of RxClaim, Dental, Health and Welfare claims processing, enrollment, drug utilization review, adjudication, pricing, payments and billing.

oActed as liaison between the major banks and PBAS to ensure daily/weekly/monthly files were uploaded in a timely fashion.

oLoad tables provided by suppliers (excel) to the AS400 using extract, transformed and loaded (ETL) processes.

oOrganized and ran Joint Application Development (JAD) sessions with different groups of users including Subject Matter Experts (SME).

oReviewed, gathered, analyzed and evaluated detailed business requirements, documentation and process flows.

oDeveloped projects including: project requirements documents, IT business process design, IT business process documents, and cost/benefits analysis.

oSupported system implementation and production readiness by liaising with developers and the business.

oSupported technical staff with systems related questions.

oDeveloped and revamped support systems to meet the requirements of the client base.

oEstablished, maintained, improved and updated databases.

oDeveloped standard Contribution Reporting procedures.

The Law Society of Upper Canada Oct 2010 – Feb 2014 Sr. Technical Analyst

oAnalysis, design, implementation and maintenance of designated Law Society computer systems on an iSeries (AS/400) environment using RPGII, RPGIII, RPG400, RPG-ILE, COBOL, CLLE, CLP, SDA, Query400 and SQL400.

oJD Edwards World and JD Edwards EnterpriseOne software in the following modules: Order Entry, Invoicing, Accounting and Payroll.

oLed assessment of system requirements, recommendation regarding system feasibility, significance and scope of related projects, management of systems and application design, modifications and upgrade initiatives.

oProvided timely, effective, integrated computer systems and applications to Law Society client departments.

oAssessed, analyzed and evaluated the feasibility and desirability of application and information systems, including new systems and applications, modifications and upgrades.

oProvided recommendations regarding appropriate systems and application solutions. Developed implementation strategies, managed projects to completion including: user consultation, system and application modeling, development, testing, implementation and support.

oExposure to Waterfall/Agile development methodology.

oMaintained and troubleshot systems, applications and program issues in support of client departments.

oLed technical resources assigned to projects and provided consultation for the delivery of cost-effective, stable, predictable and responsive systems and application functionality.

oBuilt relationships with client department staff and managers, consulted with users regarding system performance issues, development and implementation.

oPreparing and maintaining end-to-end life cycle documentation for The Law Society proprietary and 3rd party applications.

oMicrosoft Server Reporting (SSRS) - creation, deployment and managing reports with the full range of ready-to-use tools and services.

oExperience with all forms of technical writing, documentation, business cases definition and analysis.

oOrganized and ran Joint Application Development (JAD) sessions with different groups of users including Subject Matter Experts (SME).

oReviewed, gathered, analyzed and evaluated business requirements, documentation and process flows.

oDeveloped projects including: project requirements documents, IT business process design, IT business process documents and cost/benefits analysis.

oDocumented, edited, re-wrote and authenticated businesses processes, application architecture documents and technical and procedural manuals.

oDocumented system flows and integration points between applications and platforms.

oReviewed documents with end users and technical staff.

Radian Communication Services Inc. Mar 2006 – Sep 2010 Information Systems Manager

Establishing, directing, implementing and coordinating the activities, policies, procedures and goals of the IT Department in a multi-site iSeries (AS/400) environment. Ensured the computing community's needs were serviced by delivering responsive, reliable and available business systems by the most efficient means possible and preserving the security of computing assets and the safety and integrity of business data. Managed the IT Department with a staff of 7, as well as provided hands on support to the end-user community as required.

oA track record of process improvements initiatives.

oOversaw the smooth running of JD Edwards World and JD Edwards EnterpriseOne development and support in the following modules: Order Entry, Invoicing, Distribution, Shipping, Accounting, Sales Analysis and Payroll.

oExperienced in Win2K, networking, Exchange, Internet, Firewalls and Active Directory.

oAbility to troubleshoot and support day-to-day end user and system issues with a strong customer service attitude and to communicate ideas in both technical and user friendly language.

oReviewed, guided and authorized the development of project specifications.

oAssigned, co-ordinated and reviewed projects.

oPlanning, organizing, directing, controlling and evaluating daily operations keeping in mind the ROI.

oMet with clients to discuss system requirements, specifications, costs and timelines.

oHandle difficult situations with diplomacy and tact and to interact with personnel at all levels of the company to obtain, analyze and discuss business processes solutions.

Swift Sure Group Sep 1998 – Mar 2006 Systems and Development Manager

Establishing, directing, implementing and coordinating the activities, policies, procedures and goals of the MIS Department. Ensured the computing community's needs were serviced by delivering responsive, reliable and available business systems (JDA) by the most efficient means possible and for preserving the security of computing assets and the safety and integrity of business data. Managed the IT Department with a staff of 5, as well as provided hands on support to the end-user community as required.

oHands-on management, programming and operation of an AS/400 model 620 with 60+ users and 5 staff using RPGII, RPGIII, RPG400, RPG-ILE, COBOL, CLLE, CLP, SDA, Query400 and SQL400.

oOversaw systems related activities pertaining to Full Truckload (FTL), Logistics Planning & Design Services, Express, Expedited Emergency Delivery Service, Warehousing & Distribution Services and Less Than Truckload (LTL).

oStreamlined and administered JDA Software modules for the following applications: EDI, Order Entry, Invoicing, Distribution, Shipping, Accounting and Sales Analysis.

oReviewed, gathered and evaluated detailed business requirements, documentation and process flows.

oManaged the company’s telephony system, serviced contract reviews, repairs, installations and upgrades.

oControlled purchases of computer supplies, liaison for suppliers, arranged the contracting/hiring of personnel.

oPlanning, organizing, directing, controlling and evaluating daily operations keeping in mind the ROI.

oMet with clients to discuss system requirements, specifications, costs and timelines.

oOversaw wire installation (fibre optics) taking into consideration cost reduction steps.

oOversaw the TELXON System (Waybill sort system) and related activities.

oPlanned, organized and directed the seamless conversion from an AS/400 model 300 to an AS/400 model 620 RISC machine without any down time.

oCreated and implemented the company’s first web site and e-mail system.

oAdministered the planning and execution of all activities leading up to the Y2K challenge.

oInstrumental in the successful planning and execution of company sale including computer equipment (including AS/400, desktops, laptops and peripherals), furniture and equipment and close contracts with vendors.

Nike (Bauer) Mar 1993 – Sep 1998 Sr. Programmer Analyst

Maintained, developed and supported A.C.S. modules for Distribution, Shipping, Accounting and Sales analysis applications.

oSYNON exposure for the generation of RPG programs.

oInterviewed users to understand the business requirements for information and communicate them to the rest of the team; Led Joint Application Design (JAD) sessions with users and SME; Led and conducted stakeholders interviewing; Led interview documentation; Assisted other analysts in analyzing existing reports and identifying iteration metrics; Led preparation of requirements documents: Analyzed existing reports; Led the identification and documentation of business metrics; Helped identify potential sources of data to meet users requirements; Oversaw testing of processes and their implementation into production; Acted as consultant to the extract, transformed and loaded (ETL) processes and front-end programmers.

oReviewed, gathered, analyzed and evaluated detailed business requirements, documentation and process flows.

oSpearheaded the creation of an on-line Return Authorization system.

oDesigned and upgraded modules for A.C.S. system in RPGIII, RPG400, RPG-ILE, CLP, SDA, Query400 and SQL400.

oFocal point for CLP enhancements and development and Y2K Project Leader.

oScheduled all maintenance and responded to users about software customization.

EDUCATION

Sheridan College, General Management Diploma, General I.T. Management courses.

Humber College, Computer Programming Diploma

PC related courses: WORD, PROJECT, VISIO, EXCEL and ACCESS.

JDE courses: Basic foundation, Security, Order entry, Payroll and System Management

Contact this candidate