Jeena Jacob

Company Name

Grundic Corporation

Dates

0000 - Present

Details

eXPERIENCE BLOCK11 years of progressive experience with the Grundic Corporation including : Produced first time quality programs in the following industries : Automotive Aerospace Health Care Petroleum and Entertainment. Experience in debugging, design, development, testing and implementation of industrial applications with Environment : Visual Basic, ASP, SQL, Sybase, Access, and SQL Server in a Windows NT environment. Strong back-end data manipulation background using COM programming style. Solid front-end background using Microsoft s standards for form controls, structured coding , naming convention, error trapping, and documentation.eXPERIENCE BLOCKTech Media 04/01 Current Environment : Visual Basic 6.0/Sybase/SQL-Server 6.5/UNIX/Oracle/Access2000 Developed a security application for maintaining ID s and Usernames on 16 Unix servers hosting a replicated Sybase database in terminals throughout the West coast. Developed COM objects to encrypt/decrypt server ID s and passwords, as well as data access objects using ADO wrappers. Establish a process for converting BP s Terminal Operating System TOS written in Visual Basic 3.0 to 6.0 Visual Basic application. Converted 16 bit controls to 32 bit controls and made the necessary code changes. Worked in a team environment using SourceSafe, Rapid-SQL, Transact-SQL,SQL-PLUS Oracle and Unix scripting. Created simple maintainable and easy to test code using API wrapper for INI files , and Registry entries. Performed on call duties on TOS related issues by handling trouble tickets application supported 24/7 , 365 days a year opened in Vantive Support System. Modified SQL statements in the Gas Ordering System application due to changes in the Petrosoft s Oracle database tables. Performed maintenance on application using Microsoft s Winsock control that interfaces with IBM mainframe. Created and modified stored procedures. Toyota Corporation 08/00 02/01 Environment : Visual Basic 6.0/Access97/SQL-Server 7.0/ASP Developed, modified, and debugged Toyota s leasing ordering system and financial system at the headquarter facility in Torrance. Vehicles are ordered through Lotus Notes and maintained through an Access97 front-end. The back-end data stored on a SQL Server 7.0 database. Ten users clerks and office administrators utilized the two tier application to handle the administration of cars in service that were sold or leased to over two thousand associates employees in the southern California area. The Access97 front end contained over 100 tables, 50 forms, and modules. Scheduled SQL Server MTS Packages to clean up data dumped via Lotus Agents from Lotus database documents created daily from new car activity. Daily activities included working developing new GUI s for enhanced functionality of existing business practices rules not already incorporated in the newly deployed application 1 year . Responded to users problems new application bugs by debugging and fixing them as a number one priority. Prepared documentation for training and desktop procedures. Created and modified Lotus Notes agents and SQL Server 7.0 MTS Packages for data manipulation. Performed job duties in a team environment with five programmers 2- VB/Access , 3 Lotus Notes . Created VB 6.0 executables for deployment of application through Lotus Notes agent. Pacific Medical Care 05/00 08/00 Environment : Visual Basic 6.0/Sheridan Grid/Toolbar/Listbar Debugged and modified developmental phase of Pacific Medical Care s Reconcile Billing financial application. This Two tier application would replace 400 manual laborers that reconcile bills for the entire Pacific Care organization. The application was built on a VB 6.0 front-end consisting of class modules, Sheridan Grid for accounting , Sheridan Toolbar Toollist, and approximately 50 forms. The backend resided on mainframe DB tables which interfaced with VB via and program called ACMS. Daily activities included working with a weekly revised squawk and enhancement list controlled by a project manager and distributed to a team of six programmers 3 VB , 3 Cobol . Each squawk or enhancement was given an allotted amount of time to work which were closely monitored by the project manager for project cost control. Utilized version control and synchronized code through SourceSafe. ElMapsUSA inc., Hot Rod Magazine 02/00 05/00 Environment : Access97/Class Modules Performed routine maintenance on Hot Rod Magazine s Special Events reservation system. The two tier Access97 Application consist of 20 forms, Acess97 security, 30 tables and ActiveX documents class modules . User group consist of two phone preservationists, office manager, and manager. Daily duties included implementing front-end change request and generating reports. Grundic Corporation 5/88-6/99 Visual Basic Developer, Sr. Methods Engineer Environment : Visual Basic 5.0/Access 97/Microsoft Project 98/SQL/SAS Developed a world class scheduling and data warehouse application for the new Grundic 717 aircraft. Users were able to switch between the scheduling system and the database via a front-end. Trivial scheduling knowledge was incorporated in code to eliminate the learning curve of the new engineers. Built SQL statement on the fly using pull-down menus and check boxes in a Visual Basic 5.0 front-end to query an Access97 database. Designed an optimal one to many relationship layout of tables in an Access97 database back-end. Substantiated Microsoft Project 97 in code via a Visual Basic 5.0 front-end for viewing schedule data from the database. Utilized the Win32 API for server connection to the database. Finally, incorporated Error handlers for run-time errors. Performed testing, distribution, documentation, and training on final application. Utilize SAS to populate database with actual start and finish times for over 2000 tasks store in archive on As400 mainframe. Access Developer/Sr. Methods Engineer Access/Environment : Visual Basic/Microsoft Project/SQL Delivered an in-house scheduling system using Microsoft Access as a front-end and data warehouse, while integrating Microsoft Project as a scheduling engine in producing schedules for the build-up of the MD80 and MD90 aircraft. Created a multi-user database and graphical user interface for a team of ten Industrial Engineers and five USC intern students. The database was originally populated with 7 ,000 records with the aid of Teradata s SQL from the mainframe. A text file was generated on the mainframe and downloaded into the PC environment using Extra. This text file was imported into Access. Forms, pull-down menu s, buttons, and radio dials were used as GUI s for navigating through the database. Utilizing Visual Basics 5.0 , data could be passed from Microsoft Project into Microsoft Access and vice versa. Visual Basic in code was used for massive updating of records. Security was added to prevent unwanted intrusion and inadvertent updating of someone else data. Performed testing, distribution, documentation, and training on final application. Application Developer/Sr. Methods Engineer Environment : Unix Based Compass/SQL/Microsoft Project Tested , Developed, and converted NASA s Space Shuttle operations scheduling system Unix based into a manufacturing application for scheduling the build-up of aircraft MD80 s Nose as pilot . Using the MD80 Nose Build-up as a pilot, resources and predecessor information was downloaded from the legacy mainframe system using Teradata s SQL for 300 Assembly Orders AO s . Microsoft Project was used as an intermediate tool to store the scheduling data for testing prior to FTPing a generated text file into the Unix based Compass scheduling system. In Compass, true constraint based schedules were produced with the aid of Script programming. Performed testing, distribution, documentation, and training on final application.

Company Name

Lloyds

Position Held

broker

Dates

0000 - Present

Details

RFIB Lloyds broker 21/01/2013 to 23/07/2013 Specialty, Non-marine, Aviation, Motor Technician - Contract Checked clients proportional treaties, premiums and APs and processed to reinsurer market on Brokasure policy administration system LORS submissions via the Insurance Portal Submitted Treaty Statement LPANs to Xchanging via IMR Insurance Market Repository Chased clients for monthly/quarterly accounts and adjustments using the diary system Maintained computer and paper records, updating statistics

Company Name

MEDRE - The Mediterranean Ins. and Reins. Company Ltd

Dates

0000 - Present

Details

MEDRE - The Mediterranean Ins. and Reins. Company Ltd. 05/2007 to 17/12/2012 Marine, Non-Marine, Engineering and Motor Reinsurance Technician - Permanent Set up new offers and endorsements on the Subscribe policy administration system Sent underwriting response e-mails on behalf of the underwriter - acceptance/declinature, et cetera Maintained close liaison with our Tunisian office technicians and London underwriter in the underwriting workflow Issued confirmations and reminders to brokers and direct cedants Made policies Live on the system and applied outward retrocession to accepted risks Checked cover notes and wordings, implemented slip, cover note, wording and amendment signing procedure Processed proportional and XL treaties Processed facultative premiums and claims Maintained premium reserve and loss reserve spreadsheets and statistics Monitored the Underwriting mail box for new offers Logged and scanned inward post Resolved processing queries and liaised with the Accounts Department Regularly archived paper records

Position Held

Technician

Dates

0000 - Present

Details

Lambourn/CMGL contracted out to Aspen-Re Reinsurance Technician - Permanent - 19/06/2006 to 22/12/2006 UK Property Validated all policy records in Aspen-Res data migration from Guss to Subscribe within a small team in fixed term project. Entries on a master spreadsheet were checked back to slips for accurateness Calculated insurance premium tax for Aspens first Premium Tax declaration validated financial data on hundreds of policies and performed system checks Assisted the Accounts Department with ad hoc credit control tasks

Company Name

Xchanging

Position Held

Consultant

Dates

0000 - Present

Details

Xchanging Consultant - 22/02/2006 to 17/03/2006 Data migration project Marine and Non-Marine Accurately entered policy data and coded paid and outstanding claims for Arch Insurances data migration from RiskWrite to Iris to meet the tight deadline

Position Held

Technician

Dates

0000 - Present

Details

Equitas Lloyds Syndicates in run-off - Synd 53 , Synd 206 , Synd 367 and others Reinsurance Technician - Permanent - 01/03/2001 - 05/12/2005 North America, UK, worldwide - all non-life classes Billed $26m losses outward reinsurance for Equitas and advised over $175m to reinsurers with ARCF Asbestos Reinsurance Claim Form documentation, maintaining accurate net reserve information at contract level Monitored inward paid claims for XL reinsurance recoveries and outstanding losses for cover remaining on outward reinsurance recoveries Reported syndicates reinsurance asset and net reserves showing true Asbestos, Pollution and Health Hazard breakdown with Non-APH. Reconstructed and validated contract cover histories from syndicate and broker files extracting information from manual records to Excel spreadsheets in support of the accounts ledger Resolved technical queries with brokers to enable cash settlements and provided documentation to facilitate commutations Researched archives for outward reinsurance policies and entered newly-coded underwriting security and pool participants into new Max system

Company Name

Atmos

Position Held

Assistant

Dates

0000 - Present

Details

Cuthbert Heath, Whittington Syndicate Services, Omni Whittington/ Aviation Syndicate Atmos 581 and Syndicate 942 Claims Assistant - Permanent - 1993 to 2001 Aviation and Space Produced and issued outward proportional treaty statements and calculated Excess of Loss claims and advices Produced and issued quarterly outward reinsurance treaty statements General Aviation Reinsurance Contract with full APH breakdown Checked every inward claim for facultative and treaty reinsurance recoveries and monitored Non-APH and Asbestos, Pollution and Health Hazard losses for outwards reinsurance breakdown and reporting Reported the syndicates reinsurance net reserves Maintained both computer and manual records of inward and outward reinsurance for several syndicates Transcribed handwritten claims settlements from books into spreadsheets

Position Held

Technician

Dates

0000 - Present

Details

Nicholson Stewart-Brown/Nicholson Chamberlain and Colls Premium Technician - Permanent - 1989 to 1992 Aviation and Aerospace Processed proportional treaties Prepared aviation Excess of Loss slips and cover notes Compiled wordings and delivered approved copies to syndicates at box Monitored the progress of agreement to wordings Processed Excess of Loss premiums and adjustments Gave backup assistance to placing brokers

Position Held

Insurance Clerk

Dates

0000 - Present

Details

AHRB - Alexander Howden Reinsurance Brokers Insurance Clerk - Permanent - 1978 to 1989

Company Name

North American

Dates

0000 - Present

Details

Marine 1978 to 1984 Processed quarterly treaty proportional treaty technical accounts from London, North American and International markets Compiled premium and claims statistics to support brokers for renewals Updated computer records for renewals and treaty processing Submitted closings to LPSO, ILU, PSAC, LIRMA bureaux, London market and overseas companies Recent system skills Microsoft Excel, Outlook, Word LORS, IMR ROOM/NIIT Subscribe S2000 Brokasure