** ******** ******

Northbridge, MA *****

Phone: 508-***-****

E-Mail: acyxo0@r.postjobfree.com

Bernard A. Lapierre, Jr.

Skills Flex 1.5 – 3.5, ColdFusion 5-10, Actuate BIRT, InetSoft, Oracle (v7-v11), COBOL, SQL, PL/SQL, T-SQL, JCL, EZTrieve, MicroFocus Cobol, PowerBuilder, Perl, Perl DBI, ABAP, Database Modeling, UML, REXX, CICS, Java, JavaScript, XML, HTML, Wordpress, PHP, Microsoft Project, Visio, Brio, IMS, DB2, SQLSever, Linux RedHat, OS390, Solaris 2.x, AIX, HP-UX, Windows Clients/Servers, Microsoft Office

Employment February 2005 – Present LogicManager, Inc. (www.logicmanager.com) Boston, MA

Solutions Expert

Responsibilities Include:

oCo-Inventor of a patent pending Enterprise Risk Management SaaS application, which has been acknowledge in Gartner’s Magic Quadrant and Forrester’s Wave.

oPart of executive team and key decision maker in various aspects of company strategy

oArchitect all aspects of system.

oEngineering

Provide technical leadership and engineering responsibilities, working with key strategic partners.

Drive product-centric look-and-feel of product

Discuss and review functional specifications with customers and staff

Write technical specifications for team engineers

Set priorities of new features and bugs

Designed and developed original version (1.0) of LogicManager software application, released in the fall of 2005

Develop policies and procedures for engineering team to follow

Implemented business intelligence tool into application to provide robust ad-hoc reporting.

Implemented data security strategy for reporting.

Wrote numerous Oracle objects to support business intelligence environment.

oSupport

Setup of case management systems

Lead support team and respond to customer inquiries and issues in regards to all aspects of usage of software application

Develop policies and procedures for support team to follow

Provide personalized training to customers on an as needed basis

oOperations

Setup and maintenance of network infrastructure including VoIP

Setup and maintenance of internal/external servers and applications

Setup and maintenance of hosting provider of company website.

Setup and maintenance of hosting provider of our SaaS application

Setup and maintenance of Oracle Databases.

June 2004 – February 2005 Houghton Mifflin Co. (www.hmco.com) Boston, MA

Sr. Application Architect

Responsibilities Include:

o Design and Develop Intranet ColdFusion applications to support business needs.

o Member of SAP development team

Review functional specifications

Write technical specifications

Develop custom ABAP programs

Develop business workflows

oDevelop Brio reports using information from a corporate data warehouse.

March 2000 – June 2004 Self Employed Contract Consultant

System Architect/Business Analysts/Project Manager

Houghton Mifflin Co. (www.hmco.com) Boston, MA (Jan. 2003 – June 2004)

Responsibilities Included:

Converting SQR scripts to Perl script.

Converting Perl scripts accessing Sybase into Perl accessing Oracle, utilizing Perl DBI.

Writing Unix and Perl scripts to generate scripts to extract data from Sybase (BCP) and import into Oracle (SQLLoader).

Writing business requirements based on existing scripts.

Part of development team to expand functionality of business application on IBM mainframe using COBOL, IMS, and DB2

Part of development team, expanding functionality of PowerBuilder 6.5 & 8.0 systems.

BancTec Inc. (www.banctec.com) Dallas, TX (March 2000 – Nov. 2002)

Responsibilities Included:

Meeting with clients to gather requirements.

Writing Functional and Detail Specifications.

Writing technical proposals based on requirements. Recommending server sizes, storage devices, networking, and software.

Installing proprietary software as well as DBMS software (Oracle & SQLServer), Hardware, and operating systems.

Ensuring that customer enhancement specifications are delivered

Integrating proprietary software with client systems

Tuning of database and server settings.

Working with developers to performance tune applications, mainly from a SQL standpoint.

Writing PL/SQL and T-SQL, triggers and stored procedures, which bridged gaps between the application and the business data.

Writing PL/SQL and T-SQL to extract information for use in reporting matrix.

Provide expertise in process engineering and reengineering.

Provide customer service after installation.

Required to travel extensively throughout the United States.

June 1989 – Feb 2000 Allmerica Financial (www.allmerica.com) Worcester, MA

Sr. Systems Consultant

Image and Workflow System Administrator – Commercial Lines BPR II System

Decreased the time to underwrite a Commercial Line Property and Casualty policy by 30%.

Responsible for the stability and maintenance of Plexus software running on Sun Solaris 2.6 servers and Windows NT Terminal servers using Citrix MetaFrame.

Responsible for enhancements of workflow mapping, using Meta Software Workflow Analyzer.

Writing PL/SQL to extract information to present to the business unit.

Writing PL/SQL to correct any data integrity issues or business data conversions needed.

Involved with technology and architecture decisions.

Lead Architect, Developer, and Project Manager – Allmerica Claims Inventory Management System

Prior to installation of project, claims examiners had only weekly knowledge of their claims inventory. Project provided claims examiners with up to the second knowledge of inventory and past performance.

Management can now track performance history and balance inventory, based on up to the second information provided.

Designed DB2 tables on OS390 system that summarized and historically logged all activity that occurs on medical and dental claims.

Developed all batch and online COBOL programs that needed to access the new tables and extracted information from IMS databases.

Designed and oversaw all PowerBuilder development of presentation layer of the system. Used Sybase’s MDI Gateway to access the information stored on the mainframe.

Administrator, Developer, and Project Manager – Allmerica Medical Management System

Increased productivity by rewriting one application and combining it with another separate application.

Designed rewrite of entire managed care system from MicroFocus COBOL to PowerBuilder.

Responsible for the everyday maintenance and development of managed care system. System was written in MicroFocus COBOL and PowerBuilder accessing an Oracle database on a Sun server.

Designed and developed PowerBuilder development of a new correspondence system that replaced 150 existing different correspondence.

Decreased the amount of time to add or modify correspondence from a 2-week effort down to 1-day effort.

Designed and developed a new “work in progress” system. System allows the nurse to view work “to be done” immediately.

Administrator and Developer – IVR Systems

Redesign of existing application, decreased the transfer to CSR by 40%.

Responsible for the everyday maintenance and development of all of Risk Management’s voice response units.

Redesigned applications, using a proprietary GUI application that generated REXX.

Developed CICS screens, accessing IMS databases, to retrieve claims and policy information that the IVR used to interact with the customer.

Lead Developer and Architect – Medical and Dental Claims System

System handled 60,000 – 120,000 claims per day, of which 20-40% Medical and 40-50% Dental claims were adjudicated without initial or further review. Which meant for EDI claims, no one touched a claim.

Designed and developed batch COBOL and IMS system that adjudicated medical and dental claims without the need for examiner review.

Designed and developed all reporting for automated system, using QMF.

Designed and developed COBOL, IMS, and CICS system that automatically distributed claims to examiners.

Designed and developed batch COBOL system that takes in electronic data and feeds the IMS claim payment system.

Education 1985 – 1989 Anna Maria College Paxton, MA

Bachelor of Science – Computer Science

References Upon Request

Contact this candidate