Resume

Sign in

Sr. Systems Analyst (RPG)

Location:
United States
Posted:
November 28, 2017

Contact this candidate

JOSEPH MARREIROS

+ * (403) ***-**** ac2zxm@r.postjobfree.com

SUMMARY

. Strategic Thinker Information Technology Professional/Manager with over 19 years of extensive experience in developing, supporting, administering mission critical applications

. Information Technology, Industry experience in Transportation, Satellite Tracking, Manufacturing, Financial Services, Retail and Telecom

. Significant experience in leveraging Business Acumen to support users of technology through the interface between users and applications

. Technically capable individual with full application development lifecycle (SDLC), including requirements definition, code development, testing of applications and implementation

. Experienced in managing small/medium projects. Proven expertise in business/data analysis through development of requirements definition and scope

. Developed detailed plans of action and lasting relationships with co-workers

. Negotiated alliances with potential and existing business partners

. Able to learn technologies quickly and efficiently to enhance company offerings

. Accumulated eight years of Management and Sales experience with large retail (K-Mart Canada - Assistant Manager), Restaurant (McDonald's - Assistant Manager) and Scaffolding (Brand Scaffolding - Inventory Manager/Sales) companies

. Planned and managed various departments on the best use of resources

. Managed staff of over 100 workers including four department managers

. Attained high degree of comfort in any environment

SKILLS & ABILITIES

Customer/Client focused, Creative, Knowledgeable, Committed, Innovator, Versatile, Goal Oriented, Self-Aware, Delegator, Excellent Communicator, Decisive, Problem Solver, Collaborative, Negotiator, Business Acumen, Strategic Planner, Effective Leader, Person of Integrity, Trusted, Confident, Diplomatic, Technologically Savvy, Sharing, Flexible.

RPG (400, IV, ILE, Free), CL, CLLE, SQL, DB2UDB, PDM, SEU, SDA, DDS, CGI, Subprocedures, Modules, Service Programs, User Defined Functions, Stored Procedures, Prototypes, Subfiles, Query400, IFS, Triggers, File Transfers, FTP, DBU, Aldon LM(e), Mercury Test Director, Hawkeye Pathfinder, TMW, Websphere, IBMi, iSeries, AS/400, Zend Studio, Zend Server, WebSmart ILE and PHP, PHP, HTML, HTML5, CSS, CSS3, MySQL, JavaScript, C#, Microsoft Office Suite, MS Windows, MS SQL Server, MySQL, Microsoft Visual Studio, EDI, EXTOL EEI, EXTOL ESX

EXPERIENCE

. 10/2016 - 10/2017 Assistant IT Manager, Rosenau Transport Ltd. Calgary, AB

. Directed team on production tasks to meet/exceed customer/client expectations

. Directed and prioritized work load of team members

. Organized project status meeting with team members and customers/clients

. Reviewed design, code and testing of maintenance and net-new applications

. Liaised with developers, operations and end users on system troubleshooting, modifications and design

. Worked with IT staff to manage business activities

. Conducted interviews for new hires and consultants

. Prepared reports for Senior Management team

. Procured, evaluated and approved vendors and solutions for process improvement

. Interacted with customers/clients to create and implement effective business solutions

. Expertly developed and supported applications to enhance current ERP in RPGIV, ILE RPG, free-format RPG, embedded SQL, PHP, HTML, JavaScript, CSS, MySQL and various API's

09/2010 - 09/2016 Senior Systems Analyst, TFI International Inc. (Canadian Freightways), Calgary, AB

. Lead Web development for Canadian Freightways with vendor team (remote resources)

. Lead efforts to improve IT processes and procedures

. Provided training and support for Sales force as well as Customer Care team, on IBMi and Web applications

. Procured, evaluated and approved vendors and solutions for process improvement

. Oversaw projects as required by organization needs and goals

. Developed and supported RPG applications (In-House transportation system). Well versed in RPG 400, ILE RPG, free-format RPG and embedded SQL

. Expertly assisted internal and external customer on varied platforms and systems

. Converted legacy Canadian Freightways websites (12 websites) to PHP on Zend Server, utilizing PHP, HTML, JavaScript, CSS, MySQL and various API's

. Developed standalone applications with WebSmart ILE and PHP, tying in to IBMi platform; eliminating data entry errors and saving critical time on data availability

08/2008 - 09/2010 Senior Systems Analyst/Programmer(RPG), J.D. Irving Ltd., Saint John, NB

. Lead team on EDI integration between TWM and WebMethods, co-workers, on shore and off shore resources

. Maintained and enforced consistent and maintainable standards/procedures on implemented technical solutions

. Created schedules for application releases, monitored progress and reporting of statuses

. Developed and supported large Transportation applications using free format RPG

. EDI mapping and Transaction handling using Gentran for ERP systems (JDE World and One World) and ICC

. Installed, managed and supported TMW systems Software. Provided proficient and timely support for various groups

09/2006 - 07/2008 iSeries System Analyst/Programmer, Shaw Tracking, Mississauga, ON

. Liaised directly with vendors on application implementation and problem resolution

. Interacted with customers/clients to create and implement effective business solutions

. Recommended technical solutions for complex business requirements presented by customer/clients

. Created schedules for application releases, monitored progress and reporting of statuses

. Developed Driver SOS and In-Cab Email, both on iSeries (RPG) and Web interfaces (CGI, JavaScript, HTML, Cascading Style Sheets)

. Created custom programs for external customers interfacing with Shaw Tracking's data

. Provided Portal Services (Qualcomm Qtracs and SensorTracs) Upgrade, Support and Management.

03/2006 - 07/2006 iSeries Analyst, CAP REIT, Toronto, ON

. Effectively lead Help Desk Team

. Assisted and trained junior staff on issue resolutions

. Communicated effectively and efficiently with Management and co-workers to resolve existing and potential issues

. Assisted in developing timelines

. Organized project status meeting with team members and customers/clients

. Created schedules for application releases, monitored progress and reporting of statuses

. Provided Project Management and Business Analysis for various internal projects.

. Procured, evaluated and approved vendors for Change Management solutions

. Identified and developed proficient RPG solutions.

. Provided high-level technical support for all AS/400 (RPG) related activities

. Maintained and procured solutions for Disaster recovery.

08/2005 - 01/2006 Sr. RPG Programmer/Analyst and Aldon Consultant, Wells Fargo Financial Services Inc., Minneapolis, MN

. Led effort as a team lead, providing business analysis and project management functions

. Interfaced with business, gathered requirements, analyzed business needs

. Organized meetings, developed implementation schedules

. Acted as single point of contact for vendors and business lines

. Managed Aldon LM(i) (application lifecycle management (ALM) company for IT compliance) installation and implementation for four business lines

. Assisted with various existing Change Management tools migration to Aldon LM(i)

. Developed Free-Format RPG code to allow TCP/IP Socket to action approvals for code migrations in Aldon LM(i)

. Eliminated requirement for manual interface with Aldon LM(i) by external group

08/2001 - 08/2005 Senior Developer Analyst/Aldon Change Management, Allstream Inc, Calgary, AB

. Developed and maintained data standards

. Utilized data modeling methodologies to illustrate data structures and business operations

. Administered and supported Aldon's LM(i) application. Coordinated upgrade of LM(i) to current version and tested system integrity after changes. Reported LM(i) issues and worked with vendor to resolve concerns

. Application development, upgrade and support. Created new applications in RPGLE, Embedded SQL, Query400, CLLE, MS Access, VBA and Excel

. Worked with users to define requirements, wrote specifications, created internal and external design documents, developed, tested and implemented applications

. Provided support for in-house applications

. Acted as liaison between users, developers and ICMS

. Revamped the Business Unit Revenue Reporting and Sales Compensation Applications saving 50% processing time

02/2000 - 05/2001 Senior Application/System Support Analyst (RPG), Palliser Furniture, Winnipeg, MB

. Provided leadership to Level 1 and Level 2 resources on Help Desk for AS/400, Mapics and Microsoft application issues

. Oversaw after hour's support and delegation of issues

. Organized status meeting with team members

. Developed and upgraded RPGLE, MS Access and Visual Basic programs for Mapics (ERP) custom code as well as in-house applications. Mapics modules: CAS, COM, PDM, IM, MRP

. Implemented use of Triggers to update Mapics Master files with Divisional data. Created cross-tabulations and files. Utilized problem-solving skills and the ability to manipulate raw data in a thorough fashion while working under tight timelines

. Revamped World Trade Applications saving 90% processing time

10/1998 - 02/2000 RPG/400 Programmer Analyst, Nygard International, Winnipeg, MB

. Developed and upgraded RPG and MS Access programs for manufacturing, retail and distribution software (ERP) in women apparel industry

. Administered MS SQL Server

. Created Visual Basic applications interfacing with AS/400 through MS SQL Server

. Supported Order Entry and Billing, Cut and Sold (WIP), Carton Packing and Operations Planning and Control (OPC)

. Created test system for programmers' use in development

EDUCATION

03/2017 . .NET Development Certificate of Achievement, Calgary, AB, SAIT

10/1998 . Computer Analyst/Programmer, Winnipeg, MB, Red River College

12/1995 . Business Administration, Winnipeg, MB, Angus Business College

12/1994 . Management Skills Certificate, Edmonton, AB, NAIT



Contact this candidate