AMADOR V. YRANON

** ******** **, ***********, ** M1H 1E2

e-mail: acxmh1@r.postjobfree.com

Tel : 416-***-**** Cell : 416-***-****

SUMMARY

Over 15 years in analyses, design, development, implementation and support of business applications.

Hands-on experience in C#, ASP.Net MVC 4, JavaScript, JQuery, Ajax, JAVA, HTML, MS-SQL 2005/2008, Transact-SQL, Knockout.js, Razor, Crystal Reports, VB, Windows Services, VS-2015, PostgreSQL, Active Report v6, Win Forms, Team Foundation Server with emphasis on agile and sprint development.

In-depth knowledge of object-oriented programming and in all aspects of software development cycle (SLDC).

Extensive development experience in Property and Casualty Insurance, Reinsurance, Accounting and Body Shop Collision Management

Excellent analytical and problem-solving skills and the ability to efficiently handle several tasks simultaneously

Ability to transform the needs of business users and stakeholders into functional/technical requirements

Strong understanding in Entity Framework v6, Angular.js, Bootstrap, REST API, WCF.

Microsoft Certified Software Developer (MCSD) and IBM-Curam Certified Developer v6 (J2EE)

Scrum Master Certificate – International Scrum Institute

TECHNICAL SKILLS

Languages

C#, ASP.Net MVC 4, Razor, JQuery, Knockout.js, JavaScript, Ajax, Visual Basic 6, MS Entity Frame Work, LINQ, HTML, CSS, Crystal Reports, JET Tags (C# & JavaScript), T-SQL, PL/SQL, Unisys COBOL, RM-Cobol, Report Builder 2,.Net 4.5, ADO, RDO, Windows Services, XML, Win Forms, WCF, Active Report v6, NSIS Build packaging

Database

MS-SQL 2012/2008/2005, PostgreSQL 9/8, Oracle 11/10, MS Access

Tools/Environment

Team Foundation Server, Visual Studio 2013/2010, Eclipse, Text pad, Smart Draw, CVS, SVN, IIS 7, Apache Tomcat 7, MS-Office, IIS, JIRA

Architecture/Modeling/Design

a client-server, web-based applications, n-tier architecture, MVC/MVP Pattern, Object Oriented Analysis and Design

Process/Methodology

Agile, Extreme Programming, Sprint, Scrum

EMPLOYMENT HISTORY

Programmer/Analyst July 2016 – Oct 2016

Sunwing Travel Group, Toronto, ON

Project: My Booking Portal, Friends and Family Employee Loyalty Award

Technologies and Tools: ASP.Net MVC 4, JQuery, Knockout.js, JavaScript, C#, WCF, Structure Map (IoC, Dependency Injection), Razor, Ajax, JSON, MS SQL 2012, Visual Studio 2013, Transact-SQL, Team Foundation Server, Bootstrap, Agile, Scrum

Responsibilities:

Team member in the development of company’s My Booking Portal, site for travelers’ and agents’, to manage holiday/flight bookings such as pre-flight selection of seat and room, room upgrade, travel insurance, flight alerts and status, cruise, excursions, airport special assistance, booking cancellation and parking assistance.

Developed and/or modified login module, hamburger navigation menus, excursions shopping cart, navigation breadcrumbs, promotional alert sign-up, booking cancellation and penalty payments including localization (French/English).

Provided ad-hoc SQL queries of the production data to technical support team to enable them to analyze and correct erroneous production records affected by recurring bugs of their Friend and Family Loyalty award.

Converted various in-line SQL statements used in Friends and Family Loyalty into MS-SQL 2012 Stored Procedures and refactored their corresponding ASP.Net code-behind to make use of C# using statement.

Transformed wireframes and mock-ups created by our UX designer into interactive implementations using Knockout.js, JavaScript, JQuery, Ajax, and ASP HTML helpers

Documented assigned modules business process and rules using Team Foundation Sever

Senior Software Developer/Engineer May 2013 – June 2016

Audatex, Solera Holding Company, North York, ON

Project: AudaShop Manager Vehicle Claim Repair Management, AudaWatch Windows Service, Vehicle Parts Order Management, Vehicle Claim Repair Estimation and Audatex XML Data Pump.

Technologies and Tools: MS SQL 2008/2005, Visual Studio 2008/2010, XML, ASP, Transact-SQL, Visual Basic 6, VB.Net, Active Report 6, C#, .Net 4/4.5, Team Foundation Server, Nullsoft Scriptable Install System (NSIS), JIRA.

Refactored and retrofitted AudaShop Manager for Canadian market. AudaShop Manager is a vehicle claim body shop collision management application. Includes parts order management, accounting, invoicing, repair estimates, time tracking, technicians’ payroll, costing and capacity planning, reporting.

Developed Insight+ Data Pump, a windows service to extract Vehicle Claim Repair information into an XML and download into an SFTP site for continuous and seamless integration with Insight Oracle Data Warehouse, a Business Intelligence applications for Multi Body Collision Shops and Insurance companies.

Development and enhancement of AudaWatch, a windows service to upload vehicle claim repair status to a web site (www.shopbackroom.com), consuming web services written in ASP.net.

Provided input to Product Management by identifying areas of the system requiring improvements including prioritizing tasks based on 80/20 principle during sprint planning.

Worked with Technical Support to trouble shoot production issues encountered by existing clients

Create a release build and package applications for deployment to clients using NSIS.

Technical Consultant Oct 2011 – Dec 2012

Computer Aid Inc., Toronto, ON

Project: Chubb Insurance Company of Canada - SLA 3 support and maintenance of Property & Casualty Applications

Technologies and Tools: .Net 4/3.5, Power Builder 10.5, Java 1.5, C#, ASP.Net, MS SSRS, MSSIS, Report Builder 2, MS SQL 2008/2005, Visual Studio 2008, MS Business Intelligence Studio 2008, XML, Transact-SQL

Performed detailed analysis on assigned production issues and to determine the root cause of the recurring bugs within their commercial/personal insurance application systems

Prepared Bug Investigation Report including a proposed code fixes of the erroneous modules

Performed code fixes and worked with QA team to design test cases for user acceptance testing

Created SQL scripts to correct erroneous production records and for ad-hoc reports requested by various departments

Project: Ministry of Children and Youth Services (Children Protection information Network) - Curam Case Management Customization (COTS)

Technologies and Tool: Java JDK 1.6, J2EE, XML, Ant, JavaScript, CSS, JSP, Struts, Rational Software Architect 8.5, Eclipse, Rational Team, Oracle 11g, EJB, Spring, Power Designer, SOA, and Tomcat

Worked with the IBM team in customizing and configuring IBM/Curam Software – Child Care Service for the use of Ontario's Children Aid Society:

Modifications, customization and configuration of case participants, case intake, assessment and investigation interface.

Modifications, customization and configuration of case outcome plans and plan activities

Participated in the preparation of use cases, ERD, activity diagram.

Project: Arkansas State, Department of Human and Health Services Systems Modernization

Prepared conversion plan, integration use cases and data mapping between state’s legacy data with Curam data store for function point analysis.

Reviewed and categorized all items in the RFP by identifying the item within the context of Curam Software, if out-of-the-box, non-existing, require customization and development or configuration.

Senior Software Developer, Lead Mar 2005 – Sep 2011

Insurance Systems Inc, Toronto, ON

Project: Design and development of Web-Writer Enterprise, web-based, n-tier, fully-integrated Property and Casualty Application System.

Technologies and Tools: HTML, JavaScript, JQuery, CSS, JET Proprietary Tags (Angular-Like tags, Ajax-Like tokens, XML-Like tables), MVC/MVP design pattern, PostgreSQL, Oracle 10, MS-SQL 2005, IIS, Eclipse, .Net 3.5/2, Crystal Report 11/10/8.5, IIS, Textpad, Smartdraw.

Led in the design and development of General Ledger, Brokers’ Accounts Receivable/Payable Administration and Reconciliation, Billing, Reinsurance Treaty, Policy Taxes, Fees and Surcharge, Interface and transaction posting for Claims, Reinsurance and Policy Modules to General Ledger.

Wrote various Financial Reports, Policy Bordereaux, Statement of Accounts, Check Stubs, Vouchers and other accounting related reports

Prepared functional/technical specifications on all accounting and reinsurance modules

Performed production support for live clients while in warranty, and created script to correct production data in the General Ledger and subsidiary ledgers impacted by claims, policy and reinsurance modules

Created staging/mapping tables and wrote an ETL for data migration use, including testing and post-deployment stabilization

Provided technical leadership and mentorship to junior developers

Perform design and code reviews on regular basis

Systems Analyst/Lead Developer Apr 1998 - Jun 2001

Gulf Union Insurance and Risk Management Co., KSA

Project: Property and Casualty Insurance Application Systems

Technologies and Tools: MS-SQL 7.5, Visual Basic 6, Transact-SQL, Visual Interdev, COM, COM+ ADO, RDO, Crystal Reports 7.5, MS-Access, Client-Server

Led in the successful conversion of FoxPro Property and Casualty applications into Client-Server using Microsoft Visual Basic 6, MS SQL and Crystal Report

Solely responsible in the requirement gathering, analyses and application design specifications

Prepared development plan using Gantt chart including acquiring additional resources

Led in all programming, implementation activities including project management and reporting to stakeholders

Designed and developed reusable components as part of the application framework e.g. Contacts, Address, Policy

Provided technical leadership and mentoring to the development team

Business Systems Analyst IV Oct 1996 – Mar 1998

Saudi Aramco, Jeddah/Rabigh Refinery, KSA

Project: Long-Form Contract, Work Order Authorization and Engineering Work Request

Collaborated with the Western Region’s Contract Services and Refinery Engineering Unit to define overall project requirement objectives.

Documented, designed and developed Long-Form Contract, Work order Authorization and Engineering Work Request. A database of multi-million dollar contracts awarded to various third-party contractors through bidding - to perform non-destructive inspections, supply of resources, facilities/refineries upgrades and maintenance, and other engineering services.

Enhanced their Capital Projects and Due Diligence Systems

Documentation of various installed safety relief valves at Rabigh Refinery

EDUCATION

Bachelor of Science, Accounting (3rd Level CGA) University of the East, Manila

Diploma in Software Programming Engineering Prime-Tech Institute, Toronto

PROFESSIONAL DEVELOPMENT

Curam Enterprise Framework for Developers V6 IBM, Virginia, USA

Certified Insurance Professional (CIP - partial completion) Insurance Institute of Canada

SAP FI/CO UWIN PRO, Toronto, ON

Developing Apps in VB.Net Centennial College, Toronto

Visual Basic 6, Visual Studio and MS-SQL InfoWorld Solutions, Saudi Arabia

Unisys Command and Operation (CANDE), COBOL UNISYS (Phil)

AS/400 Operations IBM (Phil)

Contact this candidate