Sales System

MARCELLA KEMP

*** ******** *********, ************@*****.***

Pickering, ON L1W 1T7 905-***-****

Systems Analyst

Profile

A bilingual (English/French) individual with 15 years+ of problem solving experience, outstanding analytical and communication skills both written and verbal. Superior knowledge of data systems, including regulatory, compliance and controls based project work with ISO, MSDS, and DOT requirements. Excellent management of research, development, testing and implementation of IT projects, liaising between user groups and designers of the mainframe program. Highly skilled in data research and identification of root causes related to data discrepancies. Ability to gain the trust, confidence and respect of management and co-workers, while playing an integral part of leading or assisting the team to meet or exceed company goals.

Career Highlights

Indispensible in creating and maintaining a Cognos sales cube as well as providing training to entire organization.

Persuaded the company executives after researching alternative platforms and programs (SAP, JD Edwards) for Y2K compliance issues that is was more economical to use and upgrade of the existing program saving the company hundreds of thousands of dollars.

Became systems operator within 6 months.

Taught college course to an external company on how to use Chempax software.

Relevant Experience

Administrative SkillsWas the master file coordinatorManually added all P & C products, suppliers, customers to SLC database.Modified existing product file database to streamline transactions.Designed a bill of lading to conform to all DOT regulations.Modified an existing bill of lading to comply with all DOT regulations.Provided support for internal and external, provincial and federal, tax audits with respect to accounting system information.Received program change requests from users, conveyed them to programmer and got a time and money quote back.When the change was approved and ready I would install the changes and instruct the relevant staff how to adapt their procedures to include the modification. Wrote flow charts for changes in proceduresContributed to the creation, development and maintenance of ISO 9001.

MARCELLA KEMP

845 Grenoble Boulevard, ************@*****.***

Pickering, ON L1W 1T7 905-***-****

Training and Development SkillsIntegrated each department of a 40 person company into using the Chempax system.Taught the staff of a 100 person company how to use the Chempax system to the best corporate and personal advantage.Taught new employees how to use software and hardware. Taught staff how to use the modifications to existing software and hardware.Provided support for users of Lotus 1-2-3, Wordperfect, Excel and Word.Taught sales representatives and staff how to use the Cognos sales cube.

Technical SkillsMaintained and operated System 36, AS400 IBM computers.Converted software and hardware from System 36 to AS400.Was responsible for all hardware connected to mainframe computer and to individual PC’s.Was responsible for daily backups of mainframe and peripheral systems.Learned Lotus 1-2-3, Wordperfect, Microsoft Office.Oversaw all printing of reports, cheques, invoices and bills of lading.Assisted in an external review of Chempax accounting module.Installed and supported the CompuData accounting module that was grafted onto the Chempax program.Created an Excel spread sheet used by Montreal and Toronto to keep track of empty returnable gas cylinders.Member of a committee to research alternative platforms and programs (SAP, JD Edwards) for Y2K compliance.Helped to create and maintain the Cognos sales cube.Helped to create and maintain the MSDS system which standardized and translated supplier MSDS’s. Supervised the clerk who ran the automated portion which allowed us to send these MSDS‘s by e-mail, fax or mail, to all our customers as required by law.

Work Experience

Systems Analyst 16 years

St. Lawrence Chemical, Montreal, Quebec

System Analyst-RPG Programmer 5 years

Pigment and Chemical Inc., Montreal, Quebec

Education

Grade 12 Diploma

In House Training: RPG Programming, WHMIS certification, Cognos certification and

Responsible Distribution.

St-John’s Ambulance certificate: Standard First Aid with CPR A and AED.

References Available Upon Request

Contact this candidate