Andy Lloyd Email & Phone Number

Sydney, Nsw, Au

Sydney, Australia

Micro Focus COBOL, .NET technologies (VB.NET, ASP.NET), SQL Server, Java, Spring, XMLResponsibilitiesTechnical Design, Development, Testing and Support of: -• internal website, Sherpa, using VB.NET• internal trading system, Mocom, using Micro Focus COBOL & VB.NET• stored procedures (SQL Server)• .NET web services• customer facing Leverage Online website using Java / SpringAchievements• Proven adaptability, working across many different technologies• 100% availability of critical business systems within key performance indicators• Delivered projects on time within budget• Recognised for strong end-to-end understanding of development environment • Developed strong relationship with business users• Developed transaction fees for day traders resulting in saving to the business of several thousand dollars per year• Developed multi-currency capability enabling the business to enter new markets worth in excess of $80 million• Developed Statements capability on Leverage Online• Developed interface with bank-wide General Ledger system for Group Treasury (daily interest accruals, balances & journals)Mocom is a back-office system allowing for all aspects of a margin loan business in a banking environment including web services allowing for orders and real-time order enquiry, general ledger functions. Sherpa provides real-time margin loan information pertinent to the internal account managers and allows for the running of hypothetical scenarios. Leverage Online provides near-time margin loan positions, a snapshot of current investments, margin loan calculator and allows transfer of monies in / out.

.NET (VB.NET, ASP.NET, C#), SQL Server, JavaScript, HTML, TFS, XML, Java, JSP, JDBC, MVS, COBOL, CICS, DB2Responsibilities• Operational support and troubleshooting of critical business systems• Monitor and manage support issues• Mentoring team members• First contact across several teams for procedural guidelines• User training• Evaluation of new hardware/software• Liaise with internal customers and business analysts to develop system enhancements and new functions within budget constraints• Liaise with third party vendors to define future enhancements and quality assurance• Development and testing of mission critical functionalityAchievements• 100% availability of critical business systems within key performance indicators• Delivered projects on time within budget• Recognised for strong end-to-end understanding of development environment with added responsibility of conducting quality assurance for developers• Provided user training and produced quick reference guides for system changes• Evaluation of replacement package systems for Shelf Edge Label (SEL) • Process improvements and innovative designo Instigated hourly runs of SEL to allow for rapid changes in market priceo Innovation in price display using electronic SEL’s resulting in environmental and financial gain• Troubleshooting and database optimisationo Performance enhancements resulting in 75% reduction in overnight processing timeo Performance enhancements of Model Stocks to improve user experience• Technical Design, development, testing and support of mission critical functionality on johnlewis.com: -o Carousel (http://www.johnlewis.com/Women/Area.aspx)o Add to Basket button (http://www.johnlewis.com/65252/Style.aspx)o Similar Items (http://www.johnlewis.com/65252/Style.aspx)o Express Delivery

UNIX, Oracle 9i, Micro Focus COBOL, PL/SQL, Scripting, Shell Programming, MQ Series, Radio Frequency Terminals (RF Scanners), C-ISAM, Pro IV, C#, .NET Compact FrameworkResponsibilities• Support of international documents / parcels system, all aspects of warehousing operations including interfacing with automated sort systems• Support of Mobile Worker using C# and .Net CF deployed on PDA accessing UNIX via MQe and Websphere• Ensure worldwide business not negatively impacted by computer error• Monitor and manage support issues• Liaise with customers during the resolution of issuesAchievements• 100% availability of critical business systems within key performance indicators• Smooth implementation of all software/hardware upgrades• Scripts to facilitate 1st level Customer Support• SQL extracts into MS Access and Excel presenting business with the data it needs in a format it can use• Development of PL/SQL archiving jobs resulting in significant data storage reduction• Development/maintenance of Unix shell scripts

UNIX, Micro Focus COBOL, Sybase, Transact SQL, DB2 UDB, MQ Series, Visual Age Generator, Radio Frequency Terminals (RF), Stradis, NT, SlickeditResponsibilities• Team Leader, with sole responsibility for warehousing operations including production support and production implementations • Analyst/Programmer involved in all aspects of warehousing including; Receiving, Picking and Shipping, Warehouse Movements, Stock Replenishment, interfaces with other core business systems, bar-coded reports and RF Units• Developer of Warehouse Queries, Order Entry, Order Search and security functions in Visual Age Generator• Analyst on Shop Floor Control (sub-system of Manufacturing)Achievements• 100% availability of warehouse management system within key performance indicators• Maintained excellent relationships with all levels of warehouse staff• Successfully managed complex warehouse management application• Smooth implementation of all software/hardware upgrades• Conversion of Sybase Adaptive Server (11.9.2) to DB2 UDB (7.2)• Development of Sybase stored procedures

MVS, COBOL, CICS, DB2, VSAM• Responsible for ensuring Y2K compliance and readiness for Telstra’s International Card Systems• Produced test cases and scripts• Performed project tests on major charge input and call evaluation systems• Consolidated skills in CICS and DB2, augmenting them with database maintenance• Undertook project reporting, estimating and scheduling• Programmed, tested and deployed several enhancements with responsibility for on-going production support

Owner/Manager of this well-known Sydney vegetarian restaurant; hands on management of all aspects of a 40 seat restaurant and takeaway business, coordinating a team of 4 chefs and 20 staff for lunch and dinner 7 days a week. Established PC based applications to cater for the restaurant’s administration needs and became proficient in:• Providing customer service within the hospitality industry• Providing quality control• Personnel management and customer relations• Preparation of pays, tax and award systems and group certificates• Stock control, purchase orders, menus and pricing • General accounts for submission to accountantAchievements:• Purchased the lease and trading name of an established business and returned operating profit within the first year and a half of operation• Doubled the number of covers within 20 months of ownership• Became recognised in Sydney for innovative vegetarian menu design• Maintained high staff retention through hands-on management style• Consistently received positive reviews in publications such as SMH, 3D, Drum Media, Wentworth Courier• Sold the business in 1997 for considerable profit

CICS, DB2, IDMS, CSP, IBM 3090, MVS, COBOLSeconded to three different organizations namely Telstra, Roads and Traffic Authority (RTA) and Northern Territory Computing (NCOM).