Post Job Free

Resume

Sign in

Systems Analyst

Location:
Mississauga, ON, Canada
Posted:
February 20, 2024

Contact this candidate

Resume:

Anthony Donato

**** ********** **** **, ******** ON

647-***-**** ad3rxb@r.postjobfree.com

Objective

Keen to become part of an esteemed team where I can leverage my leadership abilities to enhance the prominence and financial success of the entire organization.

Highlights of Qualifications

●JDE (7.3 & 9.2)

●SQL

●Hubble/Reports Now

●Project Management

●Strong interpersonal and communication skills

●Ability to work within a team

●Ability to work independently

●Responsible, Dependable, Ambitious, Punctual

●Certified IBM Cognos TM1 10.1 Analyst

●Attended ProjectWorld & Business Analyst World

Education

Computer Networking & Technical Support Diploma, Seneca College September 2005 – April 2008

Work Experience

Systems Analyst/Project Leader, City of Vaughan

March 2021 - Current

●Providing technical and functional support on the following modules: A/R, A/P, GL, General Accounting, Procurement, Job Cost, HCM, Work Order, Fixed Assets.

●Manage project resources within the city, including T4 implementation, Vertex Payroll Updates, Architecture Enhancements.

●Provide direction based on key stakeholder priorities.

●Experience supporting application integrations to the JD Edwards such as SFTP, Orchestration and SQL Server.

●Developing and testing reports within Reports Now and Report Design Aid (RDA).

●Maintaining queries within SQL Server.

●Performing root cause analysis to ensure system health.

●Troubleshooting, resolving and suggesting improvements for systems security and network problems at an advanced level across converged/multiple solutions platforms and services.

●Managing negative permission security model using JD Edwards security/Q Software.

●Maintenance of User Defined Objects (UDOs).

●Conduct CNC based activities such as package builds, OMW projects, Server Maintenance.

●Ownership of technical and functional tasks within a JD Edwards project life cycle. This includes version setup, processing options, functional requirements gathering, architectural diagrams, user acceptance testing (UAT), end user training.

Functional Analyst, Simmons Pet Food March 2017 – March 2021

●Providing technical and functional support on the following modules: Sales Order Management, GL, AP, AR, Manufacturing, Procurement, Transportation, Warehouse, Master Data, Inventory, Forecasting and Quality within six separate Branch Plants in JD Edwards 9.2.2.7

●VBA programming custom solutions through RFGen data collection based on business needs.

●Experience with SDLC methodology to run projects from requirements gathering, design, testing, documentation and training through project implementation and post live support.

●Managed upgrade projects from JD Edwards 9.1.2 to 9.1.5 and 9.1.5 to 9.2.2.7.

●Development of custom business views using Report Design Aid (RDA) via fat client.

●Creating and maintaining reporting using SQL Server/ReportsNow.

●Writing AS400 DB2 queries to provide backend fixes.

●Utilizing internal ticketing software (Jira) to maintain end user requests.

●Providing root cause analysis to improve system health.

●Cross-functional team building, collaboration, and partnership.

Business Analyst, Trophy Foods June 2015 – March 2017

●Provided functional support on the following modules: Sales Order Management, GL, AP, AR, Manufacturing, EDI, Procurement, Transportation, Warehouse, Fixed Assets, Master Data, Inventory, Advanced Pricing, Forecasting, Maintenance, Quality within three separate Branch Plants in JD Edwards 9.1.5

●Experience with SDLC methodology to run projects from Requirement Gathering, Design, Testing, Documentation and Training through Implementation and Post Live Support.

●Provided BI Publisher 11g development (data model, layout), security and maintenance.

●Advanced analytical skills (Access development, Excel pivot tables, arrays, ODBC, SQL)

●Lead Hubble Reporting Software implementation

●Maintained JD Edwards security. Creation of new users, role enhancements, application security, menu security, action security, processing option security.

●Maintenance of JD Edwards scheduled jobs.

●Application configuration and processing options.

●Development of custom business views and reports using Report Design Aid (RDA) via fat client.

●Creation, maintenance and publishing of One View Reporting.

●Issue documentation and defect reporting to Oracle Support.

●Utilized internal ticketing software (Spiceworks) to record all tickets to be referenced for future instances.

Business Analyst (Consultant), Nelson Education Ltd. July 2014 – June 2015

●Tested modifications and applications within the development environment using business cases.

●Project implementation and post implementation support.

●Wrote documentation used for user training.

●SME on JDE tables, architecture and administration

●Support of JDE modules including Master Data, Sales, Inventory, Finance, Purchasing and Manufacturing

●Maintenance of reporting by module through WorkQuery, ODBC, Access, Cognos

Project Manager, Mosaic Sales Solutions July 2012 – July 2014

●Plan, executive and finalize projects with high profile clients. Projects may vary from: web reporting, data capture, Windows applications (.NET), Android applications (Java, C#), website portals (Flash, HTML5), email campaigns, SMS campaigns.

●Team lead on a large scale Android Call Management System, with over 55 infield reps.

●Team lead on Canadian Breast Cancer Foundation Pink Bus Tour.

●Managed budget for projects in excess of $100,000 through mPower.

●Managed multiple projects concurrently.

●Created detailed project plans that outline scope, objectives, budget, key milestones, risks, assumptions, dependencies, and wireframes for client sign-off and presenting deliverables to Developers/QA Analysts.

●Designed functional diagrams outlining hardware requirements using Visio 2010.

●Managed direction between development and QA to ensure program functionality.

●Managed direction between client and designers to ensure client expectations for logos, flash loops, and ensure that all brand guidelines are met.

●Identified inconsistencies within excel pivot tables and correcting through backend data mining using Microsoft SQL server 2008.

●Efficiently identified and resolved project issues as they arise.

●Provided training sessions to client teams to ensure that program functionalities are met.

Business Analyst, Nelson Education Ltd. December 2009 – July 2012

●Liaised with Business and Applications for requirements gathering to provide functional specifications for project development.

●Tested modifications and applications within the development environment using business cases.

●SME on JDE tables, architecture and administration

●Database Management using Microsoft Access.

●Managed a team of five individuals to translate custom publications from an opportunity of a customer's request to a manufactured textbook to be delivered to the customer.

●Supported JDE modules including Master Data, Sales, Inventory, Finance, Purchasing and Manufacturing.

●Provided training on JD Edwards version 7.3 system for new employees.

●Developed and maintained IBM Cognos Data Warehouse reports. This includes daily, weekly and monthly automated reporting, prompt selections and other ad hoc requests.

●Built and updated report queries within the (iSeries) AS400 using IBM work query application.

●Exposure to IBM Cognos cube design from JD Edwards interface.

●Automated sales reports via job scheduler to reduce company costs and increase productivity.

●Presented forecasting of inventory levels, pricing, and sales of all new titles based on retrieving and analyzing historical data.

●Extensive experience in the SQL Server Reporting Services.

●Communicated with parent company located in USA (Cengage Learning) to ensure product synchronization

●Improved inefficient processes and performing Gap Analysis.

●Managed tickets using Mantis Bug Tracker

Interests:

Computers, Home Renovations and Sports



Contact this candidate