Richard Zacharias

* ******* **** ****, *******, MA advmcq@r.postjobfree.com 978-***-****

Senior Software Engineer

Senior Data Engineer ~ Senior Software Engineer

Seasoned client-facing software development professional with proven experience building and managing quality technical solutions. Extensive experience developing IT solutions for Fortune 100 and smaller companies, including ETL import/exports and building Oracle data structures. Deadline and team focused, with strong communication skills.

LANGUAGES

•Oracle PL/SQL

•UNIX Shell Scripting

•Informatica

•Control M

•XML

DATABASES

•Oracle

•Netezza

•MS Access

•SQL Server

OS

•UNIX

•Microsoft

Utilities

•Jira/Confluence

•Alteryx

•GoAnywhere

Work Experience

BONTERRA 2/12 – 1/23 Multiple Positions

Cybergrants/Bonterra Technical Services (Andover, MA)

Senior Data Engineer

Responsible for converting, cleansing and transforming client legacy data from multiple sources into Oracle-based Bonterra products.

Modernized build packages and workflows resulting in a 50% reduction in development effort and delivery time.

Sr. Software Engineer

Full-stack development for Oracle PL/SQL solutions to deliver custom inbound/outbound data feeds, user interfaces, and reporting systems.

Designed and coded corporate standard product Archive and Purge Utility used company wide. This was coded to use Dynamic SQL to be flexible enough for all possible parameters.

Designed and implemented automated tools for feeds, data extracts, and jira payment processing workflows.

Lead client contact for technical discussions.

Interim manager of Technical Services teams.

FIDELITY INVESTMENTS 2/06-2/12

Senior Software Engineer

Fidelity Brokerage Technology (Merrimack, NH)

Working in a data warehousing environment, designed, developed and maintained code bases for the production batch cycle using Unix Shell Scripting, Control M Scheduling, Oracle PL/SQL Development, Netezza Scripting, and Informatica ETL. These are financial based back end reporting and analysis databases.

In 24X7 support, participated with on shore support and managed off shore support teams for standardization and monitoring of the batch cycle during twice weekly meetings and documentation to ensure Service Level Agreements are met daily.

Participated in Fidelity Change Advisement Boards as group CCB Representative. Developed, maintained, and monitored group Change Standards and Activity.

VISIBILITY/VISAER INC. 4/97-1/06

Senior/Principle Software Engineer

Software Development (Wilmington/Andover, MA)

Develop, enhance, and maintain Visaer Aviation Maintenance and Engineering software in all facets of the application environment. This large Web Application is driven by an MS IIS server integrated with COM+, Oracle Database and Oracle Application Server.

Web Application Development (VB6 DLL components, ASP - VBScript and Java Script) – Develop, enhance, and maintain Visaer Maintenance and Inquiry screens (Oracle OLTP database interface web pages). Each screen has a VB DLL component interfacing with the Oracle database via MS ADO, with MS InterDev ASP web pages.

Oracle Application Server Administration – Install, configure, and maintain Oracle 10g and 9i AS Infrastructure and BI components (Report and Discoverer Services) for Visaer BI and business reporting.

Oracle PL/SQL Programming – Develop, enhance, and maintain hundreds of Oracle Packages, Procedures, and Functions written for Oracle Report preprocessing and various business database update utilities to be called via the Visaer R&P subsystem or directly via the VB ADO interfaces. Assist in complex data selection and manipulation to support customer service in analyzing and fixing mass data issues.

Oracle Reports Development – Oracle (6iDS, 9iDS, 10gDS) – Develop, enhance, and maintain hundreds of various tabular style and form style report RDF’s, each using a PL/SQL preprocess to update or summarize data prior to display.

Design and manage the Oracle Application Server/Oracle Reports/Discoverer Visaer Reports and Procedures and BI Subsystem integration project. Includes Visaer Web Application to Oracle Application Server interaction, seamless Report PDF creation with Oracle Reports and PL/SQL programming.

JOHN HANCOCK MUTUAL LIFE INSURANCE 8/94-3/97

Senior Technical Analyst (Supervisor)

Commonwealth Group Health Service Center (Andover, MA)

As Data and Reference Reporting Manager, managed a reporting team responsible for all ad-hoc and scheduled reports for the Andover Service center. This includes support for Finance, Claims, Customer Service, Managed Care, Underwriters, Auditing, and Medical Directors. The platforms were Pyramid/UNIX-based, Informix/SQL, MS DOS, and IBM Mainframe. Responsible for annual performance reviews, bi-annual performance updates, annual goal-setting, and project planning for the four person reporting team.

Developed and maintained a Claims Data Warehouse migrated from the IBM Mainframe, to the Pyramid/UNIX environment using SQL, ACE, UNIX scripts, and C programs.

EDUCATION:

SOUTHERN NEW HAMPSHIRE UNIVERSITY, B.S., Computer Information Systems, Summa Cum Laude

NORTHERN ESSEX COMMUNITY COLLEGE, A.S., Computer Technology, Honors

DIGITAL EQUIPMENT CORPORATION, Programmer Training Program, 6 month Program

Contact this candidate