Software Engineer Sales

Remo Morettini

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

Valhalla, NY *0595

914-***-**** *******@***.***

www.linkedin.com/in/remo124

Summary

A Senior Software Engineer with great skills in COBOL DB2, SQL queries, QA

Tester, and in Mainframe applications development. I started out in the

Data Center, and then moved to the Information Technology department

writing reports, analysis, fixing programs, expanding tables, extracts,

updates, conversions, and modifying systems. Gave support to users in

other departments like Finance, Order Entry, Credit Collection, Marketing

and Fulfillment. My major contribution at Thomson Reuters was in

supporting systems like Demand Print for customer intro fulfillment, NSP

auto-ship rollovers, and Time Management. I would like to continue to work

in IT to further my skills, and learn new technology.

TECHNICAL SKILLS

. TSO/ISPF, IBM Mainframe z/OS, JCL, Batch

. COBOL expert, DB2, CICS

. SQL expert, distinct, count, substr, inner join, to_char, exists,

group by, concatenate

. CA Librarian (Change Control Facility)

. Compuware File-Aid for DB2, ABEND-AID

. Easytrieve Plus Reporting, Siebel, Actuate

. Unison Oracle DB

. Visual Studio, SQL Server, Aqua Data Studio

Professional Experience

COMPANY NAME, Thomson Reuters, Valhalla, NY 01/1979 -

07/2010

Senior Software Engineer 05/1999 -

07/2010

. Latest project, created and converted SQL for automation

. Documentation of systems and user requests, notified all departments

of changes

. QA mainframe tester, Developed plans and procedures to be used by QA,

make sure they meet requirements. Test applications thoroughly,

assemble all programs, include copybooks, DCLGEN all views, run SQL,

and reports. Test for all possible conditions, documents results, and

make sure requirements are met. Communicate with users with results

. Cobol DB2, Design program to meet customer specifications and needs.

Include all Tables, copy books, DCLGEN all views, subroutines, calls,

cursors and all logic needed. Develop and code all logic into

program. Compile and bind application to the proper Development Test

environment. Perform proper test procedures, document, and

communicate with the user that all requirements are met.

. COBOL internal sorts, SQL queries, views, bind programs, JCL, feeds to

DIVER models

. Creating acknowledgment letters for new order, renewals, and

reinstatements

. CICS changes to attributes, EXTENDED-COMMAREA, modifying logic,

subroutines, adding new fields to screens, pricing calculations,

validations,address changes, customer header security overrides,

product header screen, postage rates, demand print fulfillment, and

NSP schedules

. Batch programs, projects included campaign system, mail order system

trigger records, tracking orders, royalty cash freezes, accounts

receivable table, Bill-Hold codes for Time Management ageing bypass,

subscriber intro mail codes, acknowledgment and dunning letters, Bill-

to Ship-to reports, Sales Tax Audits by state/ county/city

jurisdiction, pricing and discounts for big accounting firms

. Creating flat delimited data sets, used in FTP and Excel import wizard

. Demand Print. this system consisted of CICS schedules that would drive

the daily requisitioning of customers for billing as in Bill-in-the-

Box, and get FTP

. NSP auto-ship, 1 time quick sale for Non Subscription products, if the

auto-ship flag was equal to a yes, the customer would receive a new

version of the product next year automatically, rewrote this system,

daily extracts and updates, weekly feeds to Diver models

. Transaction table new sales, conversions, renewals, reinstatements,

financial adjustments, billing contract postage tax, balance due,

cash, bad debt

. Time-Management, module to maintain orders, order status active to

inactive, normal expires, free service, renewal turnovers, automatic

cancels, ageing, billing, servicing, revenue

. Gave support at off hours fixing programs using ABEND-AID, for the

next sequential instruction, S04C, SQL error codes -811 duplicate

rows, -818 timestamp rebind, -911 deadlock time out, or -904

unavailable resources

Software Engineer 09/1984 -

05/1999

Computer Operator 01/1979 -

08/1984

IBM Mainframe

COMPANY NAME, Fidelity Trust Company, Stamford, CT 08/1978 -

12/1978

Computer Operator IBM Mainframe

United States Army, Specialist 4 (Corporal), Honorable Discharge

Computer Operator IBM Mainframe

Education

Thomson Reuters classes - C/C++, Xpediter, Unison, Word, Excel

Comet-Tech, NYC - HTML class

Westchester Community College, Valhalla, NY

AAS, Major: Business Accounting

COBOL Intro - Advanced

Contact this candidate