Remo Morettini

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

Valhalla, NY *0595

914-***-**** kox4ya@r.postjobfree.com

www.linkedin.com/in/remo124

www.wix.com/remo11/remom-web-site

Summary

A SENIOR SOFTWARE ENGINEER with great skills as a Mainframe COBOL DB2 Developer, and SQL Automation. I started out in the Data Center as a Computer Operator. Later I wrote some COBOL programs, and moved to the Information Technology. As a programmer I wrote applications, developed reports, data analysis, fixed programs, expand tables, created extracts, updates, conversions, track adjustments, and modifying systems. I gave support to users in other departments, like Finance, Order Entry, Credit Collection, Renewal Retention, Marketing, Fulfillment, Customer Service, Quality Assurance, and Product Managers. I am currently employed full time, but actively looking for a good opportunity in IT.

-- Batch applications -- Support for DW --

-- SQL specialist ---- Data Center support –

-- Debugged 10,000 lines of code --

-- Show me something new + I will pick it up – --

-- Knowledge of -- HTML -- C++ -- C# --

TECHNICAL SKILLS

• TSO/ISPF, IBM Mainframe z/OS, AS/400, JCL, Batch, SDSF – Ticket Tracking – RDBMS --

• COBOL -- 26 YRS, CICS – FTP-- -- COBOL DB2 SQL Oracle--

• SQL DB2 -- 23 YRS, distinct, count, substr, inner join, to_char, exists, group by, concatenate

• CA Librarian (Change Control Facility), Batch restart

• Compuware File-Aid for DB2, abend-aid

• Easytrieve Plus Reporting, SQL Server

• Unison Oracle DB, Visual Studio, Aqua Data Studio, Excel import, Access 2010

Professional Experience

Thomson Reuters, Valhalla, NY 05/1999 - 07/2010

Senior Software Engineer

• Support 24/7 for all systems – allocate datasets, FTP files mainframe to PC, debugging

• SQL - ad hoc reports Excel - VLOOKUP - search spreadsheet for a value, import wizard flat delimited files, export PRN files FTP to mainframe, copy/paste from SQL, formatting columns/editing data/dates/ headers/freeze/split/filters/sort

• UAT Tester -- tested applications in Test Environment, Analyze specifications, design programs

• ACCOUNTS RECEIVABLE TABLE, FINANCIAL ADJUSTMENTS, CASH payments

• Cobol internal sorts, SQL queries, views, bind programs, JCL, Agency

• Data Mining/Data Analysis, Mainframe applications to feed SAS Diver models, and Siebel

• CICS – change attributes, EXTENDED-COMMAREA, modifying logic, add new fields to screens, calculations, validations, address changes, customer header security overrides

• COBOL DB2 Developer -- daily NSP Auto-ship rollovers -- wrote all new batch programs, extracts, updates, and reports. This system was for 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. NSP online CICS schedules, paid logic 85% 40% 25%, free supplements within 60 days, revision 180 days, overrides, reject codes.

• Weekly NSP projections – for DIVER models, used to forecast future dollars

• Monthly Cash NSP – recapture late cash payments on rejected unpaid orders, to be reinstated

• Special NSP rollovers – As required special, customized to create a new rollover product

• Support daily batch – pending shipment, requisitioning, fulfillment, BILL-in-the-BOX,

CICS schedules that feed batch, find errors, investigation, and tracking orders for discrepancies,

Campaign, Mail Order system, Bill-to Ship-to reports, pricing/discounts for Big Accounting firms

• Support – End-of-Month order maintenance – to expire active contracts, turnover the renewal order to be current, free service, automatic cancels for unpaid orders

• Support – Begin-of-Month Billing – to create Cycle Billing records, Term-Billed, Billed-Contract-Postage-Tax, Pay-Plans Annual-Quarterly-Monthly, Product Taxability within state, unit-rate, Servicing calculations, Revenue recognition, Ageing buckets for balance dues , Tax rates

• Sales Tax Audits by state/county/city jurisdiction

• Last project -- SQL Automation in Visual Studio – create + convert SQL for automation on Unison Oracle DB, report on orders entered in Unison, find errors, track ROYALTY payments

• DATA MIGRATION – wrote applications for conversion Legacy Mainframe to Unison Oracle DB, transfer of knowledge, archive data, Conference calls/meetings NY-TX-MN Coordination

Thomson Reuters, Valhalla, NY 09/1984 – 05/1999

Software Engineer

• COBOL DB2, VSAM, CICS, modifications and support -- ROYALTY reporting/SQL/freezes

• ACTIVITY TABLE, report registers, new sales, conversions, cancels, Non-Financial Adjustments

• Mail Order Secured – Telemarketing – Salesman ID file, Commission inventories, City-ID file

• Fixing production problems, ABENDS, going through data dumps, lead generation

• DATA ANALYSIS, expanding internal tables, SOLICITATIONS, Credit Balance Notifications

• Record layouts, designing forms, flowchart diagrams, documentation

• Generating 2up acknowledgement and dunning letters, Gum Intro Labels 2 up, Cheshire 4 across

• Developer – Refunds a feed to create checks on PeopleSoft -- Data Center support --

Thomson Reuters, Valhalla, NY 01/1979 – 08/1984

Computer Operator

• IBM Mainframe, CICS

• Monitor mainframe, interpret console messages

• JCL, run jobs per schedule, print reports

• Maintain shift logs, escalation of issues, responsible for phone calls

• Follow flowcharts to meet production deadlines

Education

Thomson Reuters classes – Word, Excel, Xpediter, Unison, C, C++, C#

Comet-Tech, NYC – HTML class

Westchester Community College, Valhalla, NY

AAS, Major: Business Accounting (COBOL)

Contact this candidate