Project Analyst

Ellen Berlin

** ******** *******, ***.***

Brooklyn, New York 11235

e-mail: ************@*****.***

917-***-**** cell

718-***-**** home

SUMMARY IT multiplatform professional with strong analytical, programming and leadership skills. Extensive experience for over than 15 years in the Mainframe online and batch processing using COBOL, DB2, CICS, JCL, VSAM, MQ Series, Changeman, Endevor, PL/I.

Applications Brokerage, Banking, Accounting, Billing, Payroll.

HARDWARE IBM 30XX, 40XX, IBM Compatible PCs, SUN SOLARIS

SOFTWARE MVS/XA, MVS/ESA, WINDOWS, UNIX, OS/390, PL/I, COBOL, COBOL II, EASYTRIEVE, CICS, MQ SERIES, DB2/SQL, JCL, VSAM, TSO, IMS, BMS, SDF, FTP, CHANGEMAN, ENDEVOR, PANVALET, QMF, SPUFI, TELON, FILE-AID, STARTOOL, INTERTEST, XPEDITOR, ERWIN, PLATINUM, ABEND AID, CA7, SYNCSORT, LOTUS NOTES, SAS, MS OFFICE, VISIO, XML, HTML, SAP/R3-ABAP4

EXPERIENCE

PNC Bank, Pittsburgh, PA 09/2011 – current

Senior programmer/analyst, consultant;

Environment COBOL II, DB2, CICS, JCL, MQ Series, Endevor, FTP, NDM

Within the Retail On-line Banking group, involved in the RBCB and FlagStar banks to PNC Data Integration projects:

• On-line Bill Payments: analyzed business requirements, created technical specs, wrote batch and on-line programs, created and executed test plans;

• QuickBooks/Quicken: coded, tested, implemented, provided UATs and production support;

UBS Financial Services 09/2010 – 08/2011

Senior programmer/analyst, consultant

Environment COBOL II, DB2, CICS, JCL, MQ Series, CHANGEMAN, FTP

Order Trade Processing group:

- Prepared technical specs for the new Advanced Trade Corrections system;

- Provided production support for Order Entry and Managed Account subsystems;

- Created, tested and implemented programs to process Split Trade corrections;

- Maintained applications for the history of original trades and subsequent corrections;

- Created test plans for UATs and SITs, tested and implemented on-line and batch applications for Trades Alert email notifications;

Fidelity Investments, New York, NY 3/2007 – 07/2010

Senior Programmer/Analyst, consultant

Environment COBOL II, DB2, CICS, MQ Series, JCL, Endevor, FTP, NDM

Mutual Funds group:

-‘Freedom 401K’ funds:

Created technical specs (TSDs) from BRDS, wrote CICS/DB2 programs for new on-line cross reference functionality/screens to add/change/delete relationship of the existing Retail Fund cusips to the new 401K Freedom funds;

-FDIC Bank Sweeps:

Created new daily net activity process for the vendor’s new product CUSIPs;

-Fidelity Income Replacement Funds (IRF):

Modified Fidelity Income Prepayments and Announcements applications to accommodate IRF;

-Fidelity Funds as core sweep vehicles:

Created new main and detail screens to display/update eligible cusips/funds/accounts;

-Funds conversion:

• Created TSDs to provide automated Share Class conversion for funds;

• Created batch and on-line for single account/cusip conversion;

• Created and executed test plans to conduct the UAT and SIT testing;

-Private label Self-Clearing (SCO) for broker/dealer:

• Wrote technical specs for the Order Entry on-line and batch modifications and provided onsite coordination for the offshore team's modifications;

• Modified programs, created test cases for the onshore and offshore teams

• Coordinated UAT testing and implementation for SCO changes to the Order Entry subsystem’s applications;

JPMorgan Chase 02/2006 – 02/2007

Senior Programmer/Analyst, consultant; Data Warehousing Group

Environment COBOL II, DB2, CICS, JCL, MQ Series, Endevor, FTP

Within the Data Warehousing group, involved in the Bank One to Chase Data Integration project:

• Analyzed business requirements and created TSDs to land BankOne data for MIS and profitability reporting as per Line Of Business requirements, into new and existed Chase DB2 tables;

• Coded, tested, implemented, provided UATs and production support for new Customer profitability applications;

• Created and implemented batch and on-line programs to introduce and support multiple level of the Financial Segment hierarchy;

• Upgraded performance of the primary monthly batch jobs that distributes the feed data to downstream systems by improving DB2 SQL queries. Conducted extensive negative testing for QA and user acceptance

UBS Financial Services 01/2004 –02/2006

Senior Programmer/Analyst, consultant

Environment COBOL II, DB2, CICS, JCL. MQ Series, CHANGEMAN, FTP

Securities Clearance group:

DTCC UBS communication conversion LU 6.2 to MQ:

• Provided detailed business analysis, flowcharts and wrote TSDs for conversion of the real time data communications link for DTC Delivery Orders, into MQ;

• Created MQ/COBOL/CICS/DB2 applications to implement data message routing for Affirmations, Delivery Orders and Confirmations sent to DTCC;

Project Hudson:

• Analyzed and created TSDs for non-COD Fails Conversion;

• Created, and implemented match/merge process to update Fails master ;

Retail Delivery Project:

• Created detailed specs and test plans for Internal Audit for RETA system;

• Developed, tested and implemented new on-line Release function;

• Created batch applications for capturing and reporting Retail Daily Activities;

Products & Pricing DB group (PRDB): Securities Research Settlement Project :

• Created and implemented new End-Of-Day process (COBOL/DB2) for Statements and Confirmations;

• Maintained the FullQuote (FQDB) subsystem (MQ/CICS/COBOL/DB2);

Prudential Securities, New York 06/2000 –10/2003

Senior Programmer/Analyst

Environment OS/390, CICS, COBOLII, DB2, JCL, MQ Series, CHANGEMAN,

Windows NT, XML

PruFn.com project:

Developed and implemented Prudential Financial Communications Infrastructure system for client’s brokerage accounts web site PruFn.com by using multi-region architecture and MQ clustering on two mainframe processors.

Responsibilities:

- Involved in design of the system architecture on the Mainframe

- Created specifications, test development plans and UATs

- Developed batch and on-line applications for clients real time Portfolio, Accounts Overview, Asset Allocation, Expand Account History, Research & Opinion, Online Password Reset and Logon functions for Financial Advisors

- Formatted and converted the front-end XML host data requests into MQ messages

- Maintained Market Data pricing module

- Designed and developed the Alerts process for exceptions handling

- Developed migration plans, Integration testing and Roll out, production Support

Port Authority of NY and NJ, New York 04/1997 - 06/2000

Senior Programmer/Analyst, consultant

Environment OS/390, CICS, PL/1, COBOL II, DB2, JCL, FTP, TELON,

SAP R/3- ABAP/4, UNIX

• Provided 24 hours production support, modifications including migration process to OS/390 LE environment, testing, customer requested enhancements for the on-line and batch Contract Ledger, Fixed Billing, Accounts Payable;

• Coded new and modified the existing ABAP/4 modules for conversion project of the legacy COBOL-PL/1-DB2 systems to the SAP R/3 Unix System;

Fidelity Information Services, New York 05/93- 04/97

Programmer/Analyst

Environment CICS, PL/I, IMS, VSAM, Librarian

Applications Wholesale Banking System including following subsystems:

Foreign Exchange, Commercial Loan, Current Account, Primary Money Market; Capital Market

• Designed, created, tested, implemented and provided customer support of the On-line Inquiry CICS panels for balances, accruals, Cash Flow positions;

• Lead the customer support (24x7) group for the major German bank.

EDUCATION Bachelor Degree; Engineering and Computer Science

Training IBM MQ Series, UNIX and C fundamentals, Object Oriented Analysis and Design, VB.NET, HTML, JavaScript, Oracle, SAP/R3/ABAP4;

Contact this candidate