Resume for Laura Bebault

Meditech International		Huntington Beach, CA
*Consultant*		Jan 2003 to Present
w	Part-time consultant responsible for general IT services including network setup and maintenance, website design and development, technical problem resolution.

PAULA Insurance Company		Pasadena, CA
*Consultant*		Jul 2002 to May 2003
w	Developer/DBA responsible for general system maintenance including fixes and updates using Access, Visual Basic and a SQL Server database on a Windows 2000 platform.

Cap Gemini Ernst & Young		El Segundo, CA
*Consultant*		Apr 2002 to Jul 2002
w	Created Business System Design documents for various projects, including new Branding and Channel additions as well as Billing Statement and Customer Notice enhancements. This involved defining requirements as requested by the user, documenting all related business transactions and determining the process flow of all of the changes required down to a program level. This required the analysis of hundreds jobs and the code that they executed, including COBOL, Assembler and Easytrieve programs on a mainframe platform.

Insuretrade.com		Santa Ana, CA
*Consultant*		Apr 2001 to Oct 2001
w	Modified existing non-secure website to use SSL at member level only. This involved several coding changes for a smooth transition between secure and non-secure pages.
w	Created reports as requested by management, accessing data from a SQL Server database using SQL Stored Procedures interfacing with ASP / Crystal Reports to create a web interface.
w	Started out as a senior web developer, working with a staff of approximately 50 employees. Two months later the company downsized, leaving me as the only developer/DBA responsible for all fixes / updates / system design / new development on website utilizing three tier architecture consisting of ASP, Visual Basic COM+ and a SQL Server database using complex stored procedures on a Windows 2000 platform.

OhGolly.com		Newport Beach, CA
*Consultant*		Apr 2000 to Mar 2001
w	Responsible for set up and maintenance of SQL Server databases, including use of Stored Procedures, Triggers, DTS, and Constraints.
w	Created a Customer Billing system using Access 2000 interfacing with a SQL Server database.
w	Designed/coded a new Order Entry/Billing system utilizing three-tier architecture – ASP front end, Visual Basic COM+ middle tier and SQL Server database back end, on a Windows NT platform.
w	Project leader coordinating work of three programmers and one QA analyst for above system.
w	Created requested reports/queries from SQL Server databases as needed using Crystal Reports, Access, Filemaker Pro, Excel, ODBC, and/or MS SQL Server Enterprise Manager.
w	Provide general IT support, including interfaces, infrastructure and databases for all applications.

Celerity Solutions		Irvine, CA
*Consultant*		Mar 2000 to Apr 2000
w	Responsible for Detail Design Specifications for a quoting and sourcing system, which provided process control and visibility as well as on-going historic access to all vendor quotation and customer quote package information. This system uses a Visual Basic front end with Micro Focus COBOL, connecting to an Oracle Database, in a Windows NT environment.

Fluor Daniel		Irvine, CA
*Consultant*		Apr 1999 to Mar 2000
w	Project Leader responsible for the upgrade of Payroll, Accounting, and Labor systems written in 16-bit Micro Focus COBOL version 1.1 to version 4.0, necessary so that these applications could be run on a 32-bit operating system. After automating the process, I monitored the progress and provided assistance to offshore programmers.
w	Primary programmer responsible for a sales force automation tool written in a proprietary language similar to Visual Basic, for a product called “Avenue”, which worked with an Oracle database.
w	Support technician responsible for resolving application issues for Payroll, Accounting and Labor systems written in Micro Focus COBOL using a Btrieve database. I also set up new procedures and automated several processes including mass compiles/links and installation for these applications at new and existing job sites.
w	Reverse engineered an accounting system written for an Argentinean construction company, which needed to be upgraded for Y2K compliance, where most of the source code was missing.

Celerity Solutions		Irvine, CA
*Consultant*		Jan 1999 to Apr 1999
w	Designed and coded a vendor managed inventory system interfacing Visual Basic with Micro Focus COBOL, connecting to an Oracle Database, on a Windows NT platform. This online parameterized modular system supported the customer’s requirements by accepting both inventory and order information either manually or electronically and is integrated with a sales order management system, used to forecast future inventory needs.

Corsair Communications (formerly Subscriber Computing, now Primal Billing)		Irvine,CA
Sr. Systems Engineer		Apr 1996 to Dec 1998
w	Project Leader responsible for several projects including a new enhanced paging usage system with cycle billing capabilities.
w	Re-designed a wireless telecommunications usage system to work around a Novell system limitation of 4 gig maximum file size by splitting the file and using an indexed key file to access data.
w	Primary client support technician responsible for resolving all usage system related issues.
w	Played a key role in redesign of customer care and billing system for cellular service providers and resellers to include cycle billing.

Hand Systems Consulting, Inc.		Los Angeles, CA
*Consultant*		Feb 1996 to Apr 1996
w	Designed and coded a PC based system in Micro Focus COBOL to convert files from a Microsoft COBOL environment. This included programs to browse, search and update the files after conversion.

SunAmerica Life Insurance Co.		Los Angeles, CA
*Systems Engineer*		Mar 1994 to Feb 1996
w	Designed and coded a system which extracted data from Vantage and RPS for all clients meeting criteria requested by users. This data was then sorted, duplicate client records were removed, and then was formatted to create several different types of automated customized letters using SCRIPT.
w	Redesigned annuity statement system, including reformatting of statements using SCRIPT, AFP and OGL, adding statements for new companies, reorganizing and streamlining jobs to save processing time and make system more uniform and easily maintainable.
w	Member of team responsible for developing and implementing systems for all new products. My areas of expertise were agent commissions, all agency sales and promotion systems, tax systems, and annuity confirmation, quarterly and annual statements.

Great American Life Insurance Co.		Los Angeles, CA
*Senior Programmer/Analyst*		Apr 1990 to Mar 1994
w	Designed and coded an automated letter writing system where a library of XEROX text was merged with a list of policy or agent numbers, producing variable text letters without manual word processing. Trained users in procedures for requesting specific letters as needed.
w	Member of the team responsible for a major software conversion. Coded several programs performing file conversion, clean-up, reformatting, reporting and error correction.
w	Provided assistance and training for PC applications such as OS/2, Windows, various word processors, Micro Focus COBOL, MS-DOS, and file transfers between PC and mainframe to other application programmers in my department.
w	Converted programs from assembler to COBOL II and OSVS/COBOL to COBOL II. Modified programs to operate in both MVS and Micro Focus environments.
w	Designed several COBOL submodules such as reading a variable segmented data structure which COBOL could not handle naturally; conversion of the system date to English format; conversion of dates between Gregorian, Julian, and LIFE/70 formats; edit name fields from Last Name, First Name, M.I. to a format suitable for letter addresses and salutations.
w	Designed a system to track and report the status of agent licenses. A report was produced and a letter was sent when an agent's license was near expiration. A CICS program permitted updates to the agent's license expiration date after renewal.
w	Designed on-line documentation for entire annuity processing system. Gathered requirements from applications developers, operators, and production control staff members. Created a plan for a database that organized the jobs, procedures, files, programs, reports, and forms.
w	Wrote and maintained Assembler, COBOL, CICS and Dyl/280 applications.

Farmers Insurance Group		Los Angeles, CA
*Programmer*		Mar 1988 to Apr 1990
w	Redesigned outdated programs, updating punch card logic and removing unused routines, rewriting code to meet company standards. Added program documentation where needed.
w	Wrote and maintained Assembler, COBOL and Easytrieve Plus applications.
w	COBOL and Easytrieve Plus tutor for my department.