|
|
|
|
|
Jim Edward Espaillat
Skills
Business Experience
Banking, Brokerage (Fixed Income and Equity Options), Commercial Leasing, Employee Benefits, Publishing, Retail and Consumer Services, Telecommunications, Training, Utilities
Languages & Platforms
C#.NET, ADO.NET, ASP.NET, XML, Web Services, COM+/MTS, SQL Server Reporting Services (SSRS), PowerBuilder (4,5,6,7,8,9), EAServer (Jaguar CTS), PowerBuilder Foundation Classes (PFC), Distributed PB, Java (1.2, 1.4), JAXB, Java Server Pages (JSP), J2EE, Apache Tomcat, HTML, JavaScript, ASP, Visual Basic for Applications (VBA), Cobol/Cobol II, CICS, Windows 95/98/NT/2000/XP, UNIX, Shell Scripting, JCL, MVS/ESA, PVCS, ObjectCycle, ClearCase
Databases & Tools
SQL, Sybase (4,10,11,12), Oracle (7,8,9), SQL Server 2000/2005, Transact-SQL, PL/SQL, SQL Anywhere (5,6,7), mySQL, MS Access, DB2, XDB, Watcom SQL, PowerDesigner (5,6,7), ERwin (3.5), SQL Navigator, DBArtisan
Methodologies
End-User Requirements, Business Analysis, Object-Oriented (Use Case) Analysis, User Interface Design, Object-Oriented Design, Application Architecture, Database Design and Normalization, Data Modeling, Code Specifications
Skills Assessment
BrainBench Certifications (www.brainbench.com/transcript.jsp?pid=5133414)
Professional Experience
.NET Experience
Unilever/Best Foods, Englewood Cliffs, New Jersey - Consultant
As technical leader of a team of four developers, designed and developed a commission system to calculate payments to brokers. Application consists of an ASP.NET front end, written in C#, with business logic deployed as Transact-SQL stored procedures in a SQL Server 2005 database. Primarily responsible for overall application design and data modeling, as well as implementing most of the back-end business rules. Implemented numerous reports using SQL Server Reporting Services (SSRS).
Also responsible for performing maintenance and enhancements on the legacy commission system, written in PowerBuilder 9 and Oracle 7/8.
Dynamic Delivery Services, South Kearny, New Jersey - Consultant
Designed and developed an ASP.NET application to monitor EDI transaction logs. Written in C#, against a SQL Server 2000 database.
NYC HRA, New York, New York - Consultant
Converted Distributed PowerBuilder components to.NET components deployed on a COM server, and running against an Oracle 9i database. Used Sybase DataWindow.NET to leverage business rules embedded in legacy code.
SetFocus Master's Program, Parsippany, New Jersey - Developer
Developed solutions for diverse programming scenarios in C#.NET, employing object-oriented programming concepts such as; encapsulation, inheritance, polymorphism, and abstraction.
Developed a Windows n-tiered "Public Library Management System" application and then ported the application to a dynamic ASP.NET Internet/Intranet model utilizing the same secure middle tier data access components. Non-public web pages were secured using Windows integrated and ASP.NET forms security models.
Used C#.NET and ADO.NET to define and implement secure middle-tier components using both connected and disconnected environment strategies. Components were consumed by web applications and windows applications utilizing SQL Server and stored procedures to perform logical business transactions.
Created and deployed XML Web Services using ASP.NET. Consumed Web Services from both Windows forms and ASP.NET web applications.
Created complex business components in C#.NET using .NET Class Library assemblies while migrating and implementing them in a multi-tier environment suitable for Microsoft Transaction Server (MTS) and COM+ to address application infrastructure issues associated with building scalable enterprise level applications used by many clients.
Created deployment projects for .NET applications using Microsoft's MSI packages.
PowerBuilder Experience
Time Inc., New York, New York - Consultant
Performed enhancements on OMS, a magazine layout and composition system written in PowerBuilder 9, to improve the performance of image rendering and page manipulation routines. Added several reports using Sybase EAServer as an application middle tier.
Using Java 1.4 and JAXB, enhanced the XML interface between OMS and BOSS, an ad sales tracking system. Instituted new procedures for using PVCS version control.
Alliance Capital Management, New York, New York - Consultant
Performed enhancements on APEX, a fixed income trading system, to improve compliance with Sarbanes-Oxley audit and security requirements. Made extensive improvements to the tracking of bond quality ratings and sector classification schemes within the application. Responsible for dozens of minor corrections and enhancements to the system. APEX was written in PowerBuilder 6.5 and converted to PowerBuilder 9, running against Sybase ASE 12.
BrainBench, Chantilly, Virginia - Developer
Author/developer for an online PowerBuilder 9 skills evaluation exam.
Pepsi Bottling Group, Somers, New York - Consultant
Performed maintenance and enhancements on a vending machine servicing application. Identified numerous errors and performance issues not originally identified in project scope. Also performed enhancements to an inventory system to allow users to define relationships between PBG and Pepsi North America products. Applications were written in PowerBuilder 6.5, running against both Oracle 9i and Sybase ASE 12.
DoAll Disk Jockeys, Flanders, New Jersey - Consultant
Designed and developed a disk jockey scheduling and contract management system, written in PowerBuilder 8 on Windows 98 and XP, against a Sybase SQL Anywhere 7 database.
Footstar, Mahwah, New Jersey - Consultant
Designed and developed an application to automate distribution and tracking of vendor shipments. Written in PowerBuilder 8 on Windows 98, against an Oracle 8.1 database running on UNIX. Database was converted to Oracle 9i after initial deployment. Batch processes were written in either COBOL or Oracle PL/SQL using SQL Navigator, and executed using UNIX shell scripts.
ReviewNet, Jenkintown, Pennsylvania - Reviewer
Paid reviewer for an online PowerBuilder 7 skills evaluation exam.
New Horizons, Concord, New Hampshire - Instructor
Provided technical training in advanced PowerBuilder 8 techniques to the NH Department of Health and Human Services.
Refund Consultants, Franklin Square, New York - Consultant
Designed and developed an application to analyze water usage bills received from the City of New York. Written in PowerBuilder 7 on Windows 98, the application uses OLE automation of Attachmate Extra! terminal software to download data from the City's CICS billing system. Data is then stored locally in a Sybase SQL Anywhere 7 database, and subjected to various business rules to identify potential billing discrepancies.
Bank of New York, Teaneck, New Jersey - Consultant
Designed and developed an asset management application to be used to automate purchasing decisions, track orders, and manage inventory. Application was written in PowerBuilder 7 on Windows NT, against a Sybase 11.x database running on UNIX, using a Delphinus-designed custom 3-tier application framework (originally developed for another client), to which client-side support for the Model-View-Controller (MVC) paradigm was added. Application was designed to allow easy conversion to a browser-client interface.
CIT Group/Newcourt Credit, Parsippany, New Jersey - Consultant
Designed and implemented a distributed architecture for an existing lease origination application. Initial project assignment involved performing performance and architecture improvements to the original application, written in written in PowerBuilder 6.5 on Windows 95, and deployed against a Sybase 11.x database on UNIX.
Project evolved into re-designing system to support reuse of existing business logic by both PowerBuilder and HTML/ASP (Web) clients. This was accomplished by developing modular business components and deploying them to a Distributed PowerBuilder (DPB) server. ASP access was provided through custom COM bridge objects, written in PowerBuilder and deployed under MTS.
Subsequent deployment effort involved the migration of PowerBuilder clients to Version 7.0, and conversion of the server objects to run under a Sybase Enterprise Application Server (EAServer/Jaguar CTS), using a Delphinus-designed, custom 3-tier application framework. New components were written in Java and deployed to EAServer. ASP pages were modified to directly access EAServer via COM. Migration was undertaken as part of a company-wide effort to establish a uniform middle tier to host common business logic across applications.
Vitech Systems Group, New York, New York - Senior Programmer/Analyst
Designed and implemented a commercially successful software product to assist trade unions and public pensions with the administration of member benefits. Written in PowerBuilder, and designed to work using either a Sybase or an Oracle database server, the system is (as of mid-1998) in its third version, with five completed installations and six others in progress.
Version 1 was originally written using PowerBuilder 4, and featured:
Version 2 was updated to PowerBuilder 5, and featured:
Version 3 featured:
Personally responsible for all aspects of Version 1 system, from application and database design, to development and testing, and finally installation at two clients. Responsibility for subsequent versions gradually shifted to an emphasis on application and database design, with extensive development involving database stored procedures.
Footstar/Meldisco, Mahwah, New Jersey - Consultant
Designed and implemented SAMS, a size management application to control store allocation and distribution of merchandise on a size basis. Written in PowerBuilder 5 using a mainframe DB2 database system, the application included extensive graphing abilities to enable users to visually identify sales patterns.
Meldisco, Mahwah, New Jersey - Programmer/Analyst
Designed and implemented systems for various facets of retail operation. Client/server projects include inventory analysis tools (PowerBuilder/XDB) and foreign store operations (PowerBuilder/WATCOM).
Other Experience
Independent Computer Consultants Association - Webmaster
Provide ongoing administration of the Northern New Jersey Chapter's public website, www.iccannj.org. Developed Microsoft Access application to maintain membership information and automate the generation of HTML pages for the site. Volunteer position.
myrestaurantwebsite.com, Wurtsboro, New York - Consultant
Designed and developed a web (e-commerce) application to allow consumers to place restaurant orders online. Application is customizable with the intent of re-selling the service to various restaurant clients. Written in Java Server Pages, running on a Tomcat servlet engine against a mySQL database. Subsequent duties involved new customer setup and ongoing maintenance.
Professional Software Consortium, Morristown, New Jersey - Consultant
Provided database (Sybase SQL Anywhere 7) and object-oriented application design services for development of a travel expense system written for the Department of Defense.
XO Communications, Paramus, New Jersey - Consultant
Developed Microsoft Access application to assist in identifying potential customers based on proximity or hierarchical relationships to existing customers.
AT&T Wireless Services, Paramus, New Jersey - Consultant
Developed Microsoft Word scripts to automate personnel review documents.
Nextlink Communications, Paramus, New Jersey - Consultant
Developed Microsoft Access application to assist in assigning sales territories.
Meldisco, Mahwah, New Jersey - Programmer/Analyst
Designed and implemented systems for various facets of retail operation. Mainframe projects on the IBM System 390 included automatic distribution (COBOL 2), demographic store allocations (COBOL 2/DB2/CICS), sales analysis (COBOL 2/DB2/CICS) and reporting (COBOL 2/DB2), and operations support (COBOL 2/DB2).
Formal Education
Set Focus, Parsippany, New Jersey
C#.NET Master's Program (currently enrolled)
Chubb Institute, Jersey City, New Jersey
Diploma in Computer Programming
Arizona State University, Tempe, Arizona
Graduate program in Zoology
Cell and Developmental Biology Predoctoral Fellowship University of Pennsylvania, Philadelphia, Pennsylvania
Bachelor of Arts in Biology
Benjamin Franklin Scholars/General Honors Program Certificate
Industry Training and Seminars
Sybase Techwave 2001, San Diego, California
Rapid Application Development Using PowerJ
Building J2EE Applications Using PowerJ and EAServer Data Caching and Rapid Data Access Real-World Examples of the MVC Design Pattern Leveraging Design Patterns EAServer 4.0 Internals Introduction to Clustering in EAServer Sybase Techwave 2000, Orlando, Florida
Fast Track to Java
Object-Oriented Modeling using PowerDesigner XML Primer Best Practices in Object-Oriented (OO) Modeling with PowerDesigner Guidelines for PowerBuilder and EAServer Design & Development WebDataWindow Design Considerations Advanced Web DataWindows Secure Connections with PowerBuilder and EAServer Edward Tufte, Boston, Massachusetts
Presenting Data and Information
Sybase Techwave '99, Orlando, Florida
Architectures for Object-Oriented Development
Architecture of Performance Design and Development of n-Tier Applications Web Security Building Highly Reusable Components with PowerBuilder 7.0 Creating Truly Cross-DBMS Applications Using PowerBuilder PowerBuilder 7.0 Virtual Machine Internals Sybase Learning Center, New York, New York
Building Applications Using the PowerBuilder Foundation Classes
PC Strategies & Solutions, Parsippany, New Jersey
Introduction to PowerBuilder
IBM On-site Training, Mahwah, New Jersey
Client/Server Fundamentals
Professional Affiliations
Independent Computer Consultants Association
Board of Directors, Northern New Jersey Chapter
PowerObject! Yahoo Discussion Group
Moderator
International Sybase Users Group
New Jersey Sybase Tools User Group
Software Contractors' Guild
All information contained herein is © 1998-2007 Delphinus Consulting, Inc., and may not be reproduced in any form without the express written consent of Delphinus Consulting, Inc.
|