Robert R.

Programmer Analyst Detail and task oriented professional with an exemplary background in conceiving and developing unique initiatives to propel technology to the limit and optimize performance. Creative and visionary, recognized for keeping on the leading edge of technology and developing interactive and batch applications. Results and performance driven, thrives in an environment of constant challenge and diversity. Articulate, breaks the technology barrier down, acts as the conduit between the customer and technical experts. Industrious, exudes energy and confidence, motivates and mentors team members to succeed and deliver quality work within strict specifications, time lines and budgets. Core competencies include: Programming Systems Integration Database Management Project Management Systems Support Documentation/User Manuals End-User Training Web Design Systems Analysis Telecommuting Technical Environments Operating Systems: MS Windows 95/98/2000/XP/NT, S/3X, AS400, iSeries Languages: RPGIII, RPG IV, RPGLE, CL, CLLE, SQL, Java, FTP, HTML, JavaScript, CSS, PhP, [login to view URL], CGI Software: DB2/400, JBA/GEAC System 21, Logistics Pro (PKMS), PRMS, CGIDEV, Byteware, Oracle, SQL Server, MySQL, Microsoft Office, Dreamweaver Business Applications: Distribution, Manufacturing, Accounts Payable, Accounts Receivable, General Ledger, Sales, Warehousing, Inventory, Web Page Design Professional Experience Outkumpu Steel, Chicago, Illinois 2008 – 2009 PROGRAMMER (Contract) Due to expert RPG and System21 knowledge was parachuted in to realign and resolve issues relating to a business critical, behind schedule conversion from System21 to an in house application. Legacy RPGIII code, primary files, level indicators and full use of the RPG cycle were some of the challenges faced in the conversion to RPGIV. Worked autonomously from a home office to complete the project under the direction of the Chicago-based I.T. department. Helped realign the floundering project from the Chicago I.T. department, converting the programs and performing parallel testing on modifications prior to end-user testing and post implementation support. Successfully returned project back in line and completed on schedule and according to demanding mandate. Cinram International, Markham, Ontario 2007 – 2008 SENIOR PROGRAMMER ANALYST Recruited as part of a 28-person project team tasked with designing and writing a highly customized PRMS warehouse and distribution software solution, required as a result of a business expansion. Robert Rogerson Page Two Cinram International, Senior Programmer Analyst….continued Interacted between multiple internal and external I.T. and management stakeholders to define the software solution to meet the business needs. Designed, wrote, customized and tested the PRMS warehousing and distribution software at two locations: Markham, Ontario and Dallas, Texas. Utilized data queues, RPGLE, Java and inline SQL to seamlessly interface with DB2/400 and Microsoft SQL Server databases in batch and interactive environments. Facilitated end-user training and testing at both locations coupled with a successful seamless implementation. Kohl and Frisch, Vaughan, Ontario 2003 – 2007 SENIOR PROGRAMMER ANALYST 1 year CONSULTANT 3 years Challenged to design, build and implement an Automated Customer Returns System to streamline, optimize, expedite, track and log a large volume of returned, over the counter and prescription drugs. Reviewed the existing manual system, created an interface to track work time spent on various departments, developed and configured a project management and time tracking system which instantly provided senior management with real time reports. Automated the interface between the returns system, sales, A/R and A/P, to track and log over 250,000 skus. Developed and installed a second phase to optimize the return process accurately tracking products shipping between the customer, Kohl and Frisch, and the pharmaceutical manufacturer. Completed project according to mandate, providing external customers with the ability to view shipping returns status while producing significant cost savings to Kohl and Frisch. Cascades Boxboard, Toronto, Ontario 2001 – 2003 CONSULTANT Contracted to design and deploy a product quality system to accurately measure the attributes of manufactured goods. Analyzed customer needs, devised and developed an AS/400 based product quality system which seamlessly interfaced in real time with data stemming from the manufacturing process. Utilized RPGLE, SQLRPGLE, Java, JDBC and data queues to access remote data and files. Introduced dynamic display and reporting providing adhoc presentation of the results from the manufacturing process. Upgraded system afforded Cascades a significant competitive advantage, boosted customer service, reduced costs and streamlined order processing. Accurate and comprehensive documentation was provided to customers detailing the manufacturing process. Driescher & Wittjohann, S.A., Mexico City, Mexico 2002 – 2003 CONSULTANT (Part Time) Operated remotely from Canada tasked with modifying existing web site for English and Spanish visitors to strengthen the company's position in the U.S. and Canadian markets. Analyzed existing web presence, applications and functionality. Provided corporate management with various configurations, redesigns and data on copy to enhance web sites effectiveness, driving visitors and profitability. Made modifications using Dreamweaver and Javascript highlighting the corporate message, allowing accurate information on the 70 sku electrical component and conductor product catalogue. Translated web copy into Spanish which radically boosted the Mexican-based presence in the emerging English market, widening the corporate footprint across North America and on the Internet. Robert Rogerson Page Three Gerdeau Courtice Steel, Cambridge, Ontario April 2001 – September 2001 CONSULTANT Appointed as a Programmer/Analyst charged with designing and developing a vendor management inventory system to optimize the sales and inventory processes. Examined existing applications, designed a web-based manufacturing Roll Schedule on AS/400 using RPG, CGI and SQL providing instant access to staff located across the administration of manufacturing facility. Developed an interface program to transfer data between different geographically disparate locations and the remote Oracle database and local AS/400. Gained a thorough knowledge of Java and JDBC coupled with existing application knowledge to deliver the major upgrade to Courtice Steel, which enabled them to optimize internal processes and remain a leader in a mature and saturated steel sector. Grand & Toy, Toronto, Ontario September – December 2000 CONSULTANT Hired to act as a Programmer/Analyst assigned to develop and implement a business critical courier, LTL and full Freight Rating System to meet the existing software vendors HFA standards for use by customer services and with the emerging e-commerce applications. Appraised existing processes, created programs to extract a high volume of daily carrier order information, populating CSV files which were automatically emailed to designated carriers. Final application allowed external access from the customer service teams and web-based applications. Avesta Sheffield, Mississauga, Ontario (Now Outkompu Steel) 1999 – 2000 CONSULTANT Devised and deployed various web-based programs using RPGILE and embedded SQL to reduce response time passing data between AS/400 and an NT server. Modified existing print programs to populate the OnDemand system, migrating and converting existing documents for viewing via the Internet. Hanes Canada, Mississauga, Ontario 1996 – 1999 SENIOR PROGRAMMER ANALYST JBA Software (Canada) Ltd., Toronto, Ontario 1992 – 1996 INTERMEDIATE PROGRAMMER IKO Industries, Brampton, Ontario 1990 – 1992 INTERMEDIATE PROGRAMMER Education Oracle Certified Professional (Oracle8 Database Administration) 2001 Sheridan College Institute of Technology and Advanced Learning, Oakville, Ontario DIPLOMA – Business Computer Systems 1989 Completed 2 of 3 years in the Accounting program 1983 – 1985