Engineer Software

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

Elk Grove, California *****

Office: 916-***-**** Fax: 916-***-****

Email: abh2zi@r.postjobfree.com

www.jcs-consulting.com

www.linkedin.com/in/jaypersanchez

http://twitter.com/jaypersanchez

JAYPER C. SANCHEZ

Over ten years of IT experience as a Programmer Analyst and Software

Engineer. Jayper's development skills consist of both Cache database from

Intersystems since 2005; and Java since 1999.

Jayper's Cache development experience and skills is very broad from CSP,

Ensemble, ZEN and to legacy MUMPS systems

Jayper has provided his expertise with the Cache technology for both Health

and Financial industry and many small shops and startup companies. He is

knowledgeable with object oriented development and have worked a lot in an

Agile environment.

TECHNICAL SKILLS

Programming: Java/J2EE, Cache/MUMPS, Ensemble, ZEN, Jasper Reports

Operating Systems: Unix/Linux, Microsoft Windows

Miscellaneous: Apache Tomcat, NetBeans, Eclipse, ArgoUML,

Hibernate,WinSQL,Clearcase, SQL

FivePoints Technology

Cache & Jasper Reports Consultant

August 2010

. Developed reports for the FAMIS system using Jasper and iReport

. Developed Java classes to generate PDF and CSV format from Jasper

files

. Developed Cache CSP reporting web application to run reports from

Jasper server

. Developed Cache CSP and business classes for the FAMIS and FSS web

application

Medical Health Record Corp, Startup Company

Cache Developer/ABBY Developer(OCR)

February 2010

. Developed encounter OCR forms using ABBY OCR engine

. Develop Web Service & SOAP application for Cache backend interface

with remote client running on a USB device

. Develop CSP web application to interface with an external patient

survey web application

. Develop Java base component called Jalapenos; that provided as POJOS

and interfaced with Cache database

Department of Health Service, State of Florida

Cache Developer Consultant

October 2009, April 2010

. Developed Ensemble SQL business and operations to import data from

legacy version of Cache and into Ensemble database

. Supported FloridaShots web application

. Developed new CSP application per department requirements

. Javascript and AJAX for field validation and data processing

Dynamic Clinical Systems

Cache Developer Consultant

October 2009 to April 2010

. Developed Ensemble data extract module to gather data from Cache 5.0

globals and into a flat file that is imported into an MSSQL database

warehouse

. Currently analyzing existing web application running on Cache version

5.0

. Develop a logical database schema design for a data warehouse

. Develop solution to export Cache data and import into a SQL database

. Developed Java application to run on DOS prompt, connected to Cache

database via Cache's ODBC/JDBC driver to extract patient data

J2 Interactive

Cache Developer Consultant

September 2009, November 2009

. Developed Ensemble Business Service, Business Process and Business

Operation to import data from MSSQL and oracle with SQL and File

Adapter for New York University School of Law

. Developed web reporting for New York University users using Zen

framework

CGI

Part time Independent Junior Oracle DBA - Subcontractor for an Independent

Consultant

April 2009 to October 2009

. Support client's help desk ticket through the use of Remedy

. Run nightly export/import scripts for backup services

. Install instances of Oracle database and patches

. Administers database instances; adding new datafiles to tablespaces

TDAmeritrade - Omaha, NE

Intersystems Cache Programmer

January 2008 - April 2009

. Converted internal JSP/Servlet back office reporting front end to CSP,

Cache Server Pages

. Javascript on CSP pages

. Supported backend office, BOSWeb & BOSTelnet, that handled all online

trading activities from Stock trading, Mutual Funds and Options in

Cache 5.1 on Linux platform

. Develop CSP and Cache classes in support of new features and

requirements in Cache 2007

. Team member in conversion of current Cache database back office into

new database framework, Cache classes.

. Use Clearcase for source control and Studio for development

QUEST DIAGNOSTICS - Sacramento, CA

Intersystems Cache Programmer

May 2007 to January 2008

. Supported current laboratory web application, Care360 in Weblink

. Developed reports from imported files in HL7 specification

. Converted Weblink to CSP and use of Javascripting

. Maintain and developed new Cache object classes and routines per

specification on Windows Server.

. Maintained and administered Cache database namespaces

Department of Health Service

Government of California

Intersystems Cache Programmer

April 2006 to May 2007

. Responsible for developing new routines for new business requirements

module using Intersystems Cache Studio version 5.1 on Linux server.

. Developed and designed %Persistant class tables that store data from

legacy globals.

. Assist in minor development of JSP/Servlet pages for DHS Online MTP/SAR

system along with Cache classes as backend data repository.

. Developed legacy backend routines using Cache classes for data repository

with JSP/Servlet web interface by querying, using SQL, the Cache tables.

. Developed new modules of Cache classes with web interface, implemented

with Java, as part of obsolescing the legacy version of the health care

system.

. Developed and maintained routines for the legacy system using VA Fileman.

. Responsible for monitoring daily, weekly and monthly batch jobs.

THE GOLDEN1 CREDIT UNION

Intersystems Cache Programmer

January 2005 to April 2006

. Responsible for software requirements analysis, design of system

modifications, and software maintenance, coding, testing, and

implementation activities.

. Provided recommendations for best supporting the needs of users in terms

of system performance, and specify, design, test, and implement

appropriate measures for ensuring data access, security and performance

requirements and for maintaining data integrity.

. Developed and supported current reports against legacy system's data

using MUMPS on Mainframe

. Developed new reports against InterSystems Cache's SQL database using

VB.NET, VBA and Java.

. Developed customize application using Access and VBA and Java with

imported data from Cache legacy

. Supported branches throughout California.

. Developed backend system that connected to the Open Exchange Server (OFX)

in order to perform transactions against the legacy system using C#.NET.

. Helped develop Golden 1's online banking application in .NET that used

web services to interface via OFX server that communicates with the

mainframe.

. Environment: InterSystems Cache, SQL, MUMPS, Java, .NET

AGILENT TECHNOLOGIES

Process Engineer - Contractor

November 2003 to January 2005

. Developed new reports and maintained existing reports in Access, Excel

and Oracle databases using SQL for multiple functional groups.

DST OUTPUT

Lead Software Engineer - Product Development Group

November 1999 to December 2002

. Redeveloped Paradox reporting database to Java SWING application with

Oracle database

. Developed new reporting application using internal SDLC process provide

from Xerox

. Client/server application and Web reporting application using Java Swing

objects, JSP, Servlets and XML.

. Maintained database connectivity using Oracle JDBC Drivers for Oracle 8i

and 9i.

. Developed UNIX scripts for version releases and SQL Loader (loading of

old data to new database).

. Assisted in database analysis and design.

. Installed/ Administered BEA WebLogic Application Server on UNIX AIX.

. Code maintenance and external customer support for CD Product Line.

. Coding involved using Visual Basic, UNIX, Perl shell scripting and C/C++

in Windows.

IMRGLOBAL INC.

Programmer Analyst - Consultant

April 1999 to September 1999

. Performed code maintenance using C++ on the UNIX platform.

. Performed code maintenance on PL/SQL procedure on UNIX platform.

. Developed automated testing tools using Rational Robot.

NIAGARA CREDIT UNION

Programmer Analyst - Consultant

October 1998 to February 1999

. Analyzed and Developed financial reports using 4th GL Language named

PROBE and participated in systems implementation of their banking system

in all 20 branches.

SLM SOFTWARE INC.

Software Engineer

October 1997 to October 1998

. Analyzed Designed and Programmed new business requirements; using ANSI C

for the retail banking system product and performed minor database

administration in Oracle 7.

DEGREE, TRAINING & CERTIFICATES:

Associates Degree, Computer Programming & Systems Analysis - CompuCollege

Intersystems: Ensemble

ExitCertified: FrontPage Web Component

Oracle Corporation: Java Programming Fundamentals

CUI: Microsoft Frontpage98

IMRglobal Training Center: Object Oriented Analysis and Design using

Rational Rose98

Prologic Corporation: Multi Tier Client/Server Database Development

Contact this candidate