Patrick Lima Email & Phone Number

Wellington & Wairarapa, New Zealand

Customer: SITADeveloped and maintained n-tier framework to easily build and customize applications for airport/airlines, such as check-in application business logic, that includes a custom workflow designer, a workflow host engine service, and additional integration services. The client is a self-build application that collects and shows data as designed in the workflows through WCF. There are two clients, one is coded in Silverlight to run in the kiosks (the industry standard CUPS platform to control devices like OCR, barcode scanners and printers) communicating by TCP sockets, and the second one is a web application built in ASP.NET MVC.• Worked in a team using Scrum agile process.• Used C# and Oracle backend.• First used WPF to re-host the workflow designer, and then later migrated to Visual Studio plug-in integrated with Team Foundation Services to control the versioning.• Implemented a tool to allow the customer itself to change the application configuration that may change the flows, resources, client view, etc.

Database developer and business analyst of a web based e-learning solution.• Development and management of SQL Server including important tasks like migration from SQL 2005 to 2008, performance optimization through server/database configuration, creating/rewriting transact-SQL commands and stored procedures, creating and integrating custom .NET assemblies(functions) with the SQL Server engine.• Developed and maintained the integration processes between many different sources such as SQL Server, Oracle and Web Services by using SQL Server Integration Services (SSIS).• Team training for SQL Server management, development and optimization of T-SQL queries/stored procedures, data integration.• Worked in a project to implement a BI tool, doing the development of some dashboards in each tool presented in order to evaluate the complexity versus costs, so the board could choose for the best choice available.

Analyzed, designed and developed various projects.• Worked in a web based ERP using ASP.NET and SQL Server 2005 that required the creation of many components to help the development, and including a window service based message engine to orchestrate and distribute the messages in order to process large amounts of data and some java applets to integrate with the client devices and to print a high number of documents.• Developed a management application for taxi fleets using a GPS/GPRS device running windows CE.• Worked as an external consultant to improve the performance and fix bugs of E-commerce application; database consulting and team training regarding development and optimization of T-SQL commands/store procedures/functions, resolving multi-thread access, and server configuration.

Especialization, Strategy And Business Management

Bachelor, System Information