JAMES P POWER
74-11 ASTORIA BLVD.
JACKSON HEIGHTS N Y 11370
PHONE: [Send email to request phone number] 45-5411 [Send email using form at bottom]
HARDWARE: Dell, COMPAQ, IBM PC, IBM 3090, IBM 4341, CDC CYBER
SERIES, CDC 18/20, HONEYWELL 200 MODEL 115
SOFTWARE (PC): Excel 2002, Access 2002, VBA, Visual Foxpro (ver 6.0,
Ver 7.0, ver 8.0),Foxpro (ver 2.0, 2.5, 2.6 for Dos, ver 2.5b, 2.6 for Windows),
Visual Maxframe ver 4.0, SQL-SERVER 2000, T-SQL, Microsoft C, dBASEIII+, Focus,
MS-DOS, Word, Microsoft Excel'97, Microsoft SQL, Microsoft Access'97, Crystal
Reports (Vers. 5.087 and 8.0), Checkfree, Sybase SQL, Unix, Clipper’87, Clipper
ver. 5.01, Windows NT, Novell, Windows XP
SOFTWARE (MAINFRAME): COBOL, FOCUS, IDMS, ADS/O, INTERACT, CULPRIT,
IDMSDC/UCF, VM/CMS, OS/JCL, DOS/JCL, DOS/VSE, CICS, RPGII,
OS/MVS/XA, TSO/ISPF
April 2005 – Present 1199 SEIU/League Training & Upgrading Fund
Consultant
Consultant responsible for updating/maintaining existing Visual FoxPro
multi-user application using Visual Foxpro Forms, Foxpro reporting tool, Crystal
Reports ver 8.0, SQL statements; Develop new applications in Visual Foxpro using
Crystal Reports as the reporting tool; maintenain tables as needed; user
interface
June 2004 – December 2004 D-Bug Computer Consultants
YMCA Retirement Fund
Consultant responsible for the development of a multi-user module that was
added to an existing application. All development was in Visual Foxpro ver. 7.0
with Visual maxFrame as the main developing tool. Application was for the
splitting up of an individual’s fund assets either by a dollar amount or by
a percentage to another individual. Application uses views created on the
SQL-Server side as well as remote views created within FoxPro; Heavy
Use of T-SQL as well as embedded sql within the application.
Gave demo’s to user community as well as to upper management
Feb 2004 – May 2004 RMS Computer Corporation
CitiBank
Consultant converting an old FoxPro application to
Visual FoxPro ver 8.0 for the fund Services group within Citibank; Includes
conversion of all source code in forms, reports, programs; Old application is a
mixture of FoxPro for DOS and Foxpro for Windows ver 2.6
AXA Financial
Independent Consultant providing development and application support for the AXA
Financial Application Packaging Project. Responsibilities included adding fields
to existing tables updating various reports both in Access and then passed along
to Excel. Software used was Excel2002/Access2002/VBA in a Microsoft XP
environment
May 2003 – June 2003 Morgan Stanley
Controllers Division
Independent Consultant providing development of various reporting applications
for the Brokerage and Fees department within the Controllers Division within
Morgan Stanley one being skeleton Access Table that read in data feeds with data
fields being added to the end of each data row; This was then passed into an
Excel spreadsheet for the user; Software used was Excel 2002/Access2002/VBA in a
Microsoft XP environment
Feb 2002 - June 2002 Orion Telecommunications
Senior Programmer Analyst
Updated reports in a Visual Foxpro ver 6 system; These reports included a Trail
Balance showing current month activity along with prior three months activity;
various P/L for the accounting department; Developed user friendly screens to
produce reports based upon various selections made by the user in the sales
department developed in Visual FoxPro ver 6.0; Developed user friendly screen to
select reports on demand.
October 1996 - August 2001 AETEA INFORMATION TECHNOLOGY
CONSULTANT
Responsibilities include maintaining, developing new applications
for the Global Equities group of JP Morgan. Software developed in
FoxPro for Windows, running in a NT environment; Application was
used by the Syndicate area on the trading floor of JP Morgan; Heavy
user interface; Developed and maintain several applications used by
the back office and front office of JP Morgan for their Profit/Loss
and Trade Auto Reconciliation; Original application was in FoxPro
for Windows; Converted the date used by the auto-reconciliation to
be used by a third party vendor Checkfree; Created the imports,
matching criteria for the Checkfree application and created reports
using Crystal Reports ver 5.087; Tested the Checkfree reports using
Crystal Reports ver. 8; Developed Unix scripts to manipulate data
and ftp the data to be read by the Checkfree application; Converted
a Daily Trade Volume report using Sybase tables and Access'97;
Developed Sybase SQL to create, populate the Sybase tables to be
read by Access'97 using ODBC; Developed a front end screen in
Access'97 for the user to select the daily trade volume report date;
Developed an Excel'97 spreadsheet for the daily Trade Volume report
using the Sybase tables via ODBC.
January 1995 - October 1996 MULTIPLAN, INC.
SENIOR PROGRAMMER ANALYST
Responsibilities include developing multi-user menu driven
accounting Systems. These include Cash Posting, Refund Posting, Void
Checks, and Lease Networks. Developed using FoxPro ver. 2.6 Dos/
FoxPro 2.6 for Windows. Development included creating the various
tables, indexes, screen layouts, report layouts; Heavy use of
FoxPro's power tools Screen Builder, Report Writer, RQBE, Embedded
SQL in programs; Maintain existing SPARQ system developed in FoxPro
2.0; Updated parts of the system to FoxPro 2.6. This included
programs, screens, reports (both standard and ad-hoc). Medium to
heavy user interface with all levels of management
January 1994 - January 1995 COOPERS & LYBRAND'S
CONSULTANTING GROUP
Responsibilities include developing multi-user LAN based Risk
Management application using both FoxPro 2.5 for DOS and FoxPro2.6
for Windows.
Development included creating various tables, indexes, screen
layouts, report layouts; Heavy use of FoxPro's power tools Screen
Builder, Report Writer, RQBE; Part of a developing team to design,
code and test a Human Resources application using Lotus 123 ver 4.1
for Windows macro language; Application consisted of Data
Entry/Validation, Data Query (using the database functions of
LOTUS), and reporting. Developed user-friendly menu system
INDEPENDENT CONSULTANT
August 1993 - January 1994 Client was the DIAICHI KANGYO BANK.
Responsibilities included the design, coding, testing and
implementing various applications using FoxPro 2.5 for DOS for a
multi-currency Security Processing Accounting and Reporting System;
Some of these applications included POPUP lists and POPUP windows
input screens; Created new tables, executed RQBE for quick queries
and Report Writer for ad-hoc reporting
June 1993 - July 1993 Major company located in Stamford Ct.
Responsibilities include maintaining a multi-user HTRIS
Clipper'87/Foxpro application; Used FoxPro's Screen Builder, Report
Writer and RQBE
November 1991 - October 1992 Maintained a network based multi-user
Personal Portfolio Management System for Merrill Lynch. Responsible
for converting the system from Clipper'87 to Clipper ver 5.01 and
FoxPro 2.0; This included redesigning, coding, testing, debugging
and implementing all input screens as well as reports; Technical specialist at
Chase MetroTech responsible for testing PC's and
existing software
October 1992 - April 1993 JJ KENNY/S&P
SENI0R PROGRAMMER ANALYST
Maintained a network based multi-user menu-driven A/R application
for CUSIP; System was written in Clipper'87; Was responsible for
converting the A/R application to Clipper ver 5.01; Designed, coded,
tested debugged and implemented new input screens for updating data
received from CUSIP's Oracle database; Designed, coded, tested and
implemented new screen input and report programs; All new programs
were written using Clipper ver 5.01 accessing FoxPro tables; Used
FoxPro's Report Writer for ad-hoc reports, RQBE for quick queries.
Developed a Name/Address application using Gupta's SQLReportWriter
accessing Gupta's SQLBASE; Developed a confirmation Letter
application using Gupta's SQLReportWriter accessing Oracle;
Developed an application accessing Oracle using Microsoft C, Pro C
and embedded Oracle SQL commands; Accessed Oracle using Gupta's
SQLTalk and Oracle's SQLPlus using Windows ver. 3.1
Sept. 1987 - Nov. 1991 STANDARD& POORS
MUNCIPAL FINANCE DEPARTMENT (Oct 1988-Nov. 1991)
GROUP LEADER/PROJECT LEADER/SYSTEM ANAYLST
Project Leader responsible for the following systems;
GENERAL OBLIGATION - Performed overall system design for an on-line
multi-user system that replaced a manual system
RURAL ELECTRIICATION ADMINISTRATION - Responsible for the overall
design of an on-line multi-user system for the Utility group.
Converted the application to Gupta's SQLBASE using Microsoft C with
embedded Gupta SQLTalk commands
MUNCIPAL ANALYTICAL PLATFORM - Functioned as part of a project team
supervising an outside consultant who coded in C.
Group Leader responsible for maintaining the various systems written
in Pascal using HLI as the interface accessing PC FOCUS data tables
STRUCTURED FINANCE DEPARTMENT (Sept.1987-Oct.1988)
SENIOR PROGRAMMER ANALYST
Part of a project team to design, code, test implement and document
a network based multi-user Clipper'87 application that performed an
analysis of mortgage pools; System included screens, reports;
Responsible also for the on going maintenance of this system.
Responsible for designing, coding, testing and implementing several
applications that dealt with LOC(Letters of Credit), Asset Backed,
CMO's(Collateralized Mortgage Obligations) using LOTUS 123 (version
2.01) macros
Dec. 1985 - Sept 1987 CHASE MANHATTAN BANK
GENERAL AUDITING DEPARTMENT
SENIOR PROGRAMMER ANALYST
Developed and maintain audit software for systems that included
Foreign Exchange, Employee Deferred Expense and Prior vs. Current
month analysis reports for Savings, CD's, Nest Eggs and Demand
Deposit. Systems were in COBOL, CULPRIT, EDP-AUDITOR. Developed an
on-line Branch Automated General Ledger system using mainframe
FOCUS. Developed a menu-driven Automated Time Summary system using
Symphony
Aug. 1983 - Dec. 1985 HEIDELBERG EASTERN
PROJECT LEADER/SENIOR PROGRAMMER ANALYST
Responsible for the conversion from a Texas Instruments 990 to an
IBM 4341 os/mvs IDMS Accounts Receivable system. Used Culprit to
produce reports; Converted data entry screens from TI COBOL to
ADS/O. Designed, coded, tested, documented and implemented several
business applications.
Apr. 1980 - Aug 1983 KMG-MAIN HURDMAN
EDP AUDIT DEPARTMENT
PROGRAMMER/ANAYLST
Developed financial and audit applications on TI 990. Provided
technical support to audit staff and assisted in in-house seminars
Mar 1978 - Mar 1980 CONTROL DATA CORPORATION
PROGRAMMER/ANALYST
Developed various financial systems for clients using RPGII
July 1973 - Mar 1977 EMPIRE LIQUOR CORPORATION
LEAD OPERATOR/ ASSISTANT MANGER, OPERATIONS
Operated Honeywell 200 model 115 using GCOS. Programmed in Honeywell
COBOL
Military: VietNam Veteran with a secret security clearence
REFERENCES: Available on request
|