Resume of System Analyst

Title
System Analyst

Primary Skills
IT professional with 11+ years experience in the complete software development lifecycle within medium to large projects

Location
US-NY-Brooklyn

Posted
May-21-07

Objective: To secure a position in the corporate sector where I can apply my skills and experience to help achieve the organization's success.

Profile: Resourceful, IT professional with over 11 years solid experience in the complete
software development lifecycle and development practices on medium to large
projects. Able to prioritize, plan and track project progress. Ability to work with
other departments, users and clients. Excellent communication and
interpersonal skills.

Technologies: Visual Basic 6.0, VBA, VBScript, JavaScript, HTML, ASP, Sybase SQL Server
Microsoft SQL Server 7.0 and 2000, Sybase SQL AnyWhere, Access,
Excel,Crystal Report,TCP/IP,WISE(Installation System),RDO,ADO.Third Party
custom controls (Sheridan;Farpoint Technologies,INC; VideoSoft and
Crescent). Job Management AutoSys. DBArtisan. BCP, DTS(Data
Transformation Services.)
* 10+ Years of MS: SQL Server development experience
* 10+ Years of VBA
* Experience with Transact-SQL (advanced queries, complex joins, indexes)
* Knowledge of DTS, BCP and Data Extraction and Transformations

Professional
Experience:

Medidata Solutions New York, NY 01/2007 - 03/2007
Independent Consultant

* Design and implement reporting tool which validates accounting data
extracted from Medidata Solutions accounting systems. System developed in
ACCESS.

JP Morgan Chase Brooklyn, NY 06/2003 - 10/2003 ; 10/2005 - 04/2006
Consultant

Analyze user requirements, procedures, and problems to automate or improve
existing systems and review computer system capabilities.

* Adding and updating JP Morgan's BDAS system with new securities.
Securities data such as Prices and ratings are entered and uploaded
Via Reflection for Regis software program.

- Nightly price feeds from IDSI (Interactive Data) form the basis for updates to Price information. There are several files with update price information dependent upon the security type. Each morning I validate all pricing updates to ensure pricing accuracy.
- Update daily moody's, S&P and Fitch ratings with files coming directly from those rating agencys. The files are pulled through an internal FTP site, then updated to the JP Morgan's BDAS system.

* Design and implement automated system to replace manual process of
uploading specific types of securities on JPMorgan Chase BDAS system.
This system places dealer rates and security prices in dollar amounts as a
temporary price until vender prices the securities. Pricing information are
downloaded from Bloomberg directly in the application database for
processing before BDAS upload. This system was developed in ACCESS.

* Design and implement securities Stale Pricing system for Broker Dealer
department. This system downloads all securities that have not been
priced within 30 days. Securities are sorted by cusips and sent to Vendor(s)
via email for pricing. Vendor(s) are required to return a list of priced
securities in excel format which will then be imported by the system and
update securities prices. This system was developed in ACCESS.

CitiGroup New York, NY 09/2000 - 07/2002
SR. Programmer/Analyst

* Develop supporting databases using MS SQL Server 6.5/7.0 and Sybase.
* Develop supporting scripts using Autosys Scheduler.
* Create and maintain SDLC (Software Development Life Cycle)
documentation.
* Design, develop, implement and support web base Reporter application
written in VB Script, JavaScript and HTML. This application enables Sales
Reps to view Sales Reports over the intranet in Crystal Smart viewer.
* Design and implement utility written in Visual Basic, which generates excel
files from mainframe trade files and loaded onto a SQL Server database
using BCP calls. All required fields are extracted and parsed, saved as a
.csv file and FTP to file server. This process is triggered by AutoSys each
business day.
* Provide production support for the following CitiGroup and SmithBarney
systems.
- CitiGroup Global Compliance Systems
- Salomon Unitrac Reporting Systems
- Salomon and CitiGroup SalesPage Systems

Chase Manhattan Bank Brooklyn, NY 10/1997 - 09/2000
SR. Programmer/Analyst

* Designed, developed, implement and support Audit Report utility for Chase
InfoStation System. This utility creates and prints/displays reports by
user/application/functions/Profile, for all local users on Chase InfoStation
database. It was developed using Visual Basic and a suit of third party
custom controls by Sheridan; Farpoint Technologies and Crescent.
Includes Sheridan THREED controls, Crescent Calendar and Farpoint Grid
control. Visual Basic was used to access an API, which interfaced with the
database. The API returned safe arrays, which contained the reports,
information. The array is then used to populate fields on a customize form
for viewing or printing.
* Developed Visual Basic application that retrieve instructions from centralize
Sybase database and send to the designated department printer to be
printed. This application is able to connect to a Sybase database via ADO
with ODBC. SQL Server Client Utility is used to configure client to use
TCP/IP. The application uses the Connection object to establish a
connection with the database server and retrieve all instructions. These
instructions are then placed on a customize form for printing.

Chase Manhattan Bank Brooklyn, NY 10/1996 - 10/1997
Consultant

* Programmed, and implemented WISE(Installation system) allowing ease of
installing and upgrading application releases such as Chase InfoMatch,
Teams and Chase InfoStation System. The Installation expert editor was
used to create and update the installation scripts for each new release.
* Performed Technical support and Quality Assurance duties. These duties
include testing Chase InfoStation systems on various operating systems
such as Windows 95 and NT 4.0. Testing involved installing and configuring
RAS as well as TCP/IP for WIN 95/NT. Also, provide comprehensive day-to-
day workstation support for clients in a Windows NT/95 environment and
maintain and update troubleshooting logs.

LeRays Arts Corp Brooklyn, NY 07/1992 - 10/1996
Co-Owner / Manager
* Responsible for all gallery management functions, including employee
relations and routine accounting.
* Tracking and ordering Art supplies.
* Assist customers with customize framing selections.

Education and Credentials:

College of Staten Island The City University of New York
Bachelor's Degree in Computer Science June, 1992

Technical Training:

* Windows NT 4.0 Administration
* Windows XP Professional
* SQL Server
* AutoSys Scheduler
* WinRunner
* Vantive HelpDesk

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-NY-Brooklyn »
View all resumes in US-NY »

View other System Analyst resumes, IT Manager resumes