Northbridge, MA *****
Phone: 508-***-****
E-Mail: **********@*******.***
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