Stephen Smith Email & Phone Number

Lindsay ON

• Lead team of System Analysts in development and maintenance of key ERP (JD Edwards).
• Translate company objectives into projects; assigning and managing projects to achieve objectives.
• Analyze existing processes and their impact on business drivers and strategy to drive positive change.
• Continue to manage the Crayola Canada Data Warehouse and related Cognos Business Intelligence
• Develops and maintains local intranet services (C4) and future digital initiatives.

Lindsay, ON

• Plans, develops & extracts the data structures; teaches new techniques; builds & delivers high level reporting via the local intranet portal (C4)
• Analyze existing processes and their impact on business drivers and strategy to drive positive change.
• Develop information architecture and nomenclature for current and future content.
• Resolve data discrepancies and ensure integrity between ERP and Database Applications.
• Periodically review BI environment for improvements and problem avoidance including metrics to assess usage and emerging technologies.
• Manage the Crayola Canada Data Warehouse and related Cognos Business Intelligence Tools including development, scheduling and documentation of BI operations and tasks.

Lindsay, ON

• Manage the Crayola Canada Data Warehouse and related Cognos Business Intelligence Tools including maintenance and training.
• Resolves daily issues over Database Applications to ensure system integrity and accuracy of data.
• Develop and maintain local intranet services.
• With the IT Team, develop direction and strategy to support growth and development of the Crayola Canada business.
• Actively maintain awareness of state of the art and varied applications in information technology and recommend solutions which are aligned with the IT Strategy, which will be beneficial to the company.
• Facilitate training services that relate to business intelligence and collaborative tools.

Markham, ON

o Develop and make changes to magazine subscription and renewal pages using PHP/HTMLo Maintain and manage PostgreSQL databaseo Work with Java servlet to port data from PostgreSQL to DB2 on AS400o Deal directly with client to determine and develop to specific business requirements o Take designers image and work with CSS and HTML to present via the.

o Developed VBscript/Active-X control tools to convert customers old email settings to new settingso Setup CRON jobs that pull data from one server to another using SSH on a nightly basiso Designed customer database to provide statistics on all customer related support requestso Work with oracle database to query support and customer information for.

Oshawa, Ontario

Aalborg, Denmark

Oshawa Ontario

Computer Programmer, Computer Science

Diploma W Honours, Information Technology