Glenn De Claro Email & Phone Number

Irvine, California

Application Support Service• Contributed in reducing over 100 backlog support tickets in two months from system related issues to specific lender research items. • Generated reports for OCC audits and created several SQL scripts for recurring control reports. Wintel Administrator • Integral in supporting Wintel Application Development Team in starting, re-starting and taking backup log files for different services for Wintel applications.• Supported monthly claims application upgrades.Data Mapping and Integration• Created, modified and maintained several data models that read, update and extracts data from mainframe applications.• Developed session pools to reduce host workload and speed up queries.• Resolved critical issues that prevented the line of business (LOB) from obtaining real-time data from the system of record (SOR).Electronic Data Interchange (EDI) • Produced a detailed EDI user guide and ran the process outlined in the document that created wires and transaction reports sent to the clients and carriers.

Aliso Viejo, Ca

Determined solutions for urgent service requests.• Provided quick resolution to issues that prevented end users to use the affected application.• Met 100% service level agreement on all service requests. • Took charge of an urgent issue by coming up with the solution and managing a small project to deal with duplicate loans. Provided support to the project management team.• Lead several projects by building test loans, setting up business rules and creating detailed test scripts. • Designed the customer engagement application for the property and home repair services using 2015 Microsoft CRM.

Irvine, Ca

Led and managed several types of projects using all phases of the application development life cycle (SDLC). • Created a new rating routine that eliminated the cost of paying a third party carrier for issuing policies. • Automated report or sub ledger for accounts receivable, which decreased the workload for accounting by eliminating the manual process of creating spreadsheets of receivable balances.• Increased revenue through a core program change that allowed the issuance of wind product to all states in the United States.Instrumental in important business enhancements tasks.• Completed numerous small-scale projects/tasks dealing with updates in rates and taxes.• Developed new internal reports and modified several existing client specific reports.• Implemented changes to the verbiage of existing letters to borrowers including first and final notices.

Irvine, Ca

QBE Insurance (Continued)Resolved several production support tickets and tasks.• Successfully delivered urgent requests such as reports for court cases from clients with turnaround time as short as 1-2 hours utilizing MS Access and Excel (Pivot Table and Functions such as IF, LOOKUP, VLOOKUP and TEXT), DYL280, SQL and ODBC Database.• Pinpointed the root cause of several issues with premium amounts by re-creating the problem in a test environment that involved submitting a COBOL program via a JCL job to load data in a test database. • Provided a detailed document about letter cycle to audit that successfully overturned a target/compliance fail.• Indexed reports to a website so that only data for a particular client is visible.• Resolved issues with files sent to different kinds of information storage systems including AS400, Fiserv and LPS (Lender Processing Services). • Converted several queries written in DYL280 to SQL.• Responsible for .Net Web Application tasks.o Completed a task that fixed the problem with a loss drafts website where the main page isn’t displaying the correct logo and customers were unable to view their account. o Eliminated the time it takes to review exceptions created by an issue where EDI was one of the sources that feed to a database.Designed and developed procedures for production support tasks and tickets.• Created several step-by-step documents on how to properly test rating changes.• Developed requirement templates and procedures.Provided references for users.• Produced user-friendly manuals including systems information and instructions to run complicated queries.Contributed to team improvement.• As a Subject Matter Expert (SME), trained and consulted users including the line of business (LOB) such as Tracking Operations as well as other BSAs, QA and developers.

Bachelor Of Applied Science (B.A.Sc.), Agricultural Biology

Associate'S Degree, Nutrition Sciences