Product Safety system► Gathered requirements from Product Safety team and gained universal agreement on requirements form users throughout the Asia Pacific region.► Gave presentations► Setup database schema.► Developed working prototype to demonstrate functionality.► System was released along Agile lines, using short releases to user gain engagement. ► Get universal agreement on functionality with users for Asia Pacific region.► Develop and unit test programs. ►… Show more Product Safety system► Gathered requirements from Product Safety team and gained universal agreement on requirements form users throughout the Asia Pacific region.► Gave presentations► Setup database schema.► Developed working prototype to demonstrate functionality.► System was released along Agile lines, using short releases to user gain engagement. ► Get universal agreement on functionality with users for Asia Pacific region.► Develop and unit test programs. ► Cleansed and populated with user supplied master data for user acceptance testing. OUTCOME: Ensures quality products were only built from approved materials and had a side benefit of rationalizing all raw material supplies for the Asia/Pacific region. Show less

Product Cost Estimation and Technical Specification ► Transformed an existing character based system into a nth tier system with a modern graphical interface. Added extra functionality to allow users to view multiple items at the same time whereby allowing new items to be constructed by dragging and dropping details from other items.► Gave numerous user presentations to show a prototype to give users the look and feel.► Develop programs and testing procedures.► Provided user… Show more Product Cost Estimation and Technical Specification ► Transformed an existing character based system into a nth tier system with a modern graphical interface. Added extra functionality to allow users to view multiple items at the same time whereby allowing new items to be constructed by dragging and dropping details from other items.► Gave numerous user presentations to show a prototype to give users the look and feel.► Develop programs and testing procedures.► Provided user support BAU and enhancements.OUTCOME: Simplified the processing and accuracy Bill of Materials and produced timely cost estimates. Show less

Payment Tracker System► Gather and document requirements.► Design and setup database schema► Develop programs through an iterative process. Use prototyping to firm up functionality.► Perform unit testing and get user to conduct acceptance testing. ► Implement system.► OUTCOME: Allowed financial advisers could keep track of institutional payments past and make future estimates. This enables the financial adviser report payments collected on a client products and to… Show more Payment Tracker System► Gather and document requirements.► Design and setup database schema► Develop programs through an iterative process. Use prototyping to firm up functionality.► Perform unit testing and get user to conduct acceptance testing. ► Implement system.► OUTCOME: Allowed financial advisers could keep track of institutional payments past and make future estimates. This enables the financial adviser report payments collected on a client products and to forecast revenues for the year. The application included PDF report generation and the extensive use of MS charting to represent trends. Reporting summarized results by client, institutional provider, products. Each of these reports could be ranked. Show less

Data Migration ► Wrote a series of programs to extract and transform master and transactional data into a format based on Pacific Brands specification.► Wrote SQL scripts to interrogate Pacific Brands data warehouse to reconcile whether all transactional data had been transferred correctly.OUTCOME: All Yakka's ERP data was been transferred to Pacific Brands data warehouse.Offshore Goods Distribution ► Attended meetings with Australia Post to gather requirements for the… Show more Data Migration ► Wrote a series of programs to extract and transform master and transactional data into a format based on Pacific Brands specification.► Wrote SQL scripts to interrogate Pacific Brands data warehouse to reconcile whether all transactional data had been transferred correctly.OUTCOME: All Yakka's ERP data was been transferred to Pacific Brands data warehouse.Offshore Goods Distribution ► Attended meetings with Australia Post to gather requirements for the transfer and processing of goods through Australia Post network. ► Wrote computer programs based on an Australia Post designed file formats to align data between Pacific Brands and Australia Post systems.► Conducted tests in conjunction with Australia Post.OUTCOME: Pacific Brands uniform goods manufactured China never reached Pacific Brands Australian warehouse. All goods distribution was handled by Australia Post from the country of manufacture (China), directly to Pacific Brands customers in Australia. Show less

Product Data Management System ► Developed an interface to transfer details between a CAD product and a SQL database. The interface was able to place electronic symbol and its parametric details on the PCB or schematic diagrams by fetching details from the database. The bill of materials could also be constructed from a CAD diagram.OUTCOME: Selection of approved electronic component used in the construction process was controlled from a SQL database. Automatic bill of material was… Show more Product Data Management System ► Developed an interface to transfer details between a CAD product and a SQL database. The interface was able to place electronic symbol and its parametric details on the PCB or schematic diagrams by fetching details from the database. The bill of materials could also be constructed from a CAD diagram.OUTCOME: Selection of approved electronic component used in the construction process was controlled from a SQL database. Automatic bill of material was constructed from CAD diagrams. Product changes were also managed though version control. Show less

System Integration► Wrote a series of extract programs to transfer open sales orders, product and customer details from National Foods system and to upload invoice, order status and stocking information passed back from the 3PL warehouseOUTCOME: Aligned National Foods and third party logistics warehouse (3PL) databases with item, customer, stock storage and distribution details.

Business Intelligence► Designed a Business Intelligence system that highly configurable by users. Controllers could grant permission to users of any field and level of data access.► Designed a flexible OLAP database.► Coded system incorporating nth tier technology and generic programming.► Tested system for accuracy and performance.OUTCOME: This system was a cheap and effective Business Intelligence that was aimed at small to medium sized businesses. Once the database… Show more Business Intelligence► Designed a Business Intelligence system that highly configurable by users. Controllers could grant permission to users of any field and level of data access.► Designed a flexible OLAP database.► Coded system incorporating nth tier technology and generic programming.► Tested system for accuracy and performance.OUTCOME: This system was a cheap and effective Business Intelligence that was aimed at small to medium sized businesses. Once the database structure was defined and upload programs written to populate the OLAP database, the company had total control of the levels of consolidation and freedom to define users access. Controllers could manage user access at a field and data levels. Show less

Marketing BI & Reporting► Gather reporting requirements. ► Design, develop & test programs. OUTCOME: Able to successfully target markets, follow current marketing trends & pinpoint operational performance issues.Data Warehouse Project ► Design & code programs to transfer date from live database to a data warehouse & purge live database of old transactions.OUTCOME: Provide an independent database for reporting & online inquiry.System Integration Project►… Show more Marketing BI & Reporting► Gather reporting requirements. ► Design, develop & test programs. OUTCOME: Able to successfully target markets, follow current marketing trends & pinpoint operational performance issues.Data Warehouse Project ► Design & code programs to transfer date from live database to a data warehouse & purge live database of old transactions.OUTCOME: Provide an independent database for reporting & online inquiry.System Integration Project► Design & wrote programs to transfer data between ERP & warehouse management systems.OUTCOME: Align ERP & WMS databases. Data Migration Project► Design, code & test programs to cleanse, extract, transform and upload data into the Head Office database. OUTCOME: All disparate state operations were merged onto a common central system.Scan Pack Dispatch System ► Code and test programs, based on Coles specification, to handle EDI for incoming PO's & outgoing ASN's.► Design, develop & test programs to accurately record dispatched products, produce dispatching & invoice documentation & update database with invoice related details, stock level adjustments, create back orders when necessary. Enhance to pack of an inner cartons in an outer carton.► Gave user training & BAU support.OUTCOME: Improved the accuracy of shipped goods, aid the handling of shipping containers by bar code labelling & the ability to cut freight costs by packing inner cartons.Product Budget & Forecast► Gather requirements and gave management presentations.► Design, code & test programs.OUTCOME: Produce fully tracked budgets at volume, cost, price & projected profit levels. Contract & Promotional Pricing ► Design, code & tested a system to manage contract pricing of products for customers.OUTCOME: Able to pursue corporate and government customers with dedicated pricing strategy.Procurement System► Design, code & test programs OUTCOME: Automatically generated orders. Show less