HIGHLIGHTS OF QUALIFICATIONS

Committed to delivering results with exceptional quality through a combination of technical aptitude, creativity and interpersonal skills. I am exceptionally reliable, a team player and natural leader to drive change and deliver quantifiable results.

PROFESSIONAL EXPERIENCE

Confidential,Toronto, ON 2000 - 2009
Senior Developer Consultant/Data Modeler/DBA
Hardware: IBM ISeries
Software: RPG/ILE, SYNON (CA 2E), CL, Mercury Quality Center, CA ERWIN Modelmart, Turnover, IBM MQ, Over 2E, Query 400, Client Access, SQL, Microsoft Access, SEU, and Probe

• Created detailed level design, database design and functional specifications sourced from Business Requirement documentation and through Joint Application Development sessions with Business Analyst. Chaired detailed design document walkthrough with the Business Analyst and QA leading to their signoff prior to development.
• Lead a team of 3 developers on a multi-year cross platform project to create a new Automotive Ordering system for Canadian Tire’s 450+ stores. This involved the creation of databases, design documents and system walkthroughs with the developers. Coordinated development efforts with Project Manager, Quality Assurance and Business Analyst to ensure requirements are met with integrity within timelines
• Developed and successfully implemented customer returns applications and internal staff ordering applications to control customer fraud and prevent out of stock/over stock situations for 450+ stores..
• Develop unit testing standards (test script templates) for the development team to ensure unit testing coverage, including sub-functions to maintain development quality using Mercury Quality Center test tool. Trained and presented standards to the development team.
• Create (including security provisions) over 7 multi-level SYNON Data Models for Canadian Tire’s 450+ stores\' Inventory Ordering system and Canadian Tire’s 270+ Gas Stations\' Payment /Reconciliation System. The Data Models are created consistently in time for the Development team at the start of every development phase.
• Created numerous internal reporting tools for management to provide quantifiable measurements of QA defect ratio using lines of code per release.
• Work alongside the Business Analyst throughout the development phase to ensure changes to requirements are updated in the data model and communicated to the Development team.
• Create development templates to enforce development standards and drive efficiencies within the development team by eliminating the need for recoding. Maintain development templates to meet the changing needs of the business.
• Created numerous internal development tools to increase development quality and development efficiency. Such as development tools to highlight missed programs that failed to be promoted to QA and program comparison to highlight changes between program versions.
• Created Logical Data Modeling using ERWIN, physical Data Modeling using 2E.
• Reversed engineer data relationships to ERWIN (28 Subject Areas) entity relationship diagram to better understand the requirements by visually present the business requirements for the Development team and Business Analyst.
• As a Subject Matter Expert, mentor the Development team on SYNON and Over/2E.
• Assess the Development team’s Ordering System programs and investigate root causes of performance / response time issues and modify programs to reduce CPU processing time.

Confidential, Chicago, IL 1999 - 2000
Senior Development Consultant
Hardware: IBM AS/400
Software: RPG,CA 2E (SYNON), CL, Query 400, Client Access, CM (MKS)

• Create business requirements, detailed design requirement and prototypes for business review and signoff. Build stakeholder trust by understanding business concepts and issues to manage change during the system development life cycle.
• Implement and customize new SYNON 2E development tool according to development standards.
• Develop and implement an archival application for an Order Entry System to maximize disk space capacity and processing efficiency.
• Lead a team of developers to gather the business requirements, develop, test and implement an inventory forecast system (Product Allocation System).
• Elicit business requirements and successfully develop application enhancements for an EDI and Order Entry module within an ERP (CENSYS) system.

Confidential, Toronto, Ontario 1998 - 1999
Senior Development Consultant
Hardware: IBM AS/400
Software: RPG, CA 2E (SYNON), CL, Query 400, Client Access, CM (MKS)

• Implement and customize new SYNON 2E development tool according to development standards.
• Project Manager for converting NT based WMS to AS/400 within timeline and budget.
• Develop application enhancements according to change requests for an Order Entry, WMS and Financials module within an ERP (CENSYS) system.

Confidential, Richmond Hill, Ontario 1997 - 1998
Senior Development Consultant
Hardware: IBM AS/400
Software: RPG, CA 2E (SYNON), CL, Query 400, Client Access, Ironworks

• Develop an Electronic Commerce Order Entry System using Java thin Client (IRONWORKS).
• Create business requirements, detailed design requirement and prototypes for business review and signoff.
• Elicit business requirements for stakeholder sign off, develop according to specifications and provided post implementation support for a cross platform project that involved the creation of an Order Entry Interface to Windows NT based WMS application within an ERP (CENSYS) system, using RPG embedded SQL statements.
• Develop according to enhancement requests of a complete module suite of an ERP (CENSYS) system according to multi-model configuration.
• Upgrade AS400 hardware to Model 170 and migrate application and data seamlessly to the user.

Confidential, Markham, Ontario 1996 - 1997
Senior Development Consultant
Hardware: IBM AS/400, HP Servers
Software: RPG, CA 2E (SYNON), Ironworks, Sterling Software

• Development Team Lead for EDI & Electronic Commerce Projects to ensure development enhancements are responded with efficiency and within timeline.
• Develop according to user specifications of an in-house Order Entry, Accounts Receivables, Account Payables and Warehousing system.
• Elicit business requirements for stakeholder sign off and develop EDI Invoice System (810) using ANSI X12 standards.
• Elicit business requirements for stakeholder sign off and develop Internet Order Entry, Order Inquiry, Product Inquiry systems using Java thin client (IRONWORKS).
• Configure and convert data models for new releases of SYNON 2E.

QUALIFICATIONS

• Extensive in design and code structured RPG programs.
• Extensive experience with CASE (SYNON) technology
• Extensive experience in data modeling.
• Extensive experience of CA’s Erwin Modelmart
• Solid knowledge of EDI (Financial & Distribution).
• Effective communication skills to understand user needs in business terms and translating them into development specifications.
• Effective managerial and leadership skills.

EDUCATION:Confidential