Sandra David Email & Phone Number

Quincy Ma

10/11 - 06/12 Project to replace Mainframe transaction processing system.• Analysis and research of current mainframe pricing processes.• Write Functional Requirement Documents to be used by developers to build new process and to create reports. Verify that reports created have no errors.• Enter pricing data into new system in specified order from scripts. Research the results. If incorrect research where the transaction was dropped and request change to the system . • Enter test results into Excel spreedsheets.

Westborough Ma

POCC Vendor Shipping Instructions project.• worked within a team of technical designers on mainframe project to accept 10 vendor emails from the server via MQSERIES and to send changed Vendor Instructions back to the server . • Analysis of CICS transaction non screen components to determine changes. Also the analysis of turning off the current IMS auto fax system. • Analysis of 24 CICS screens with DB2 update programs to determine where to capture data changes and when to write the trigger record in order to send changes to the server in real time. • Design of new DB2 Tables and new CICS screen to change email addresses. Design of DB2 tables which will accumulate data updates and create version comments.• Wrote technical design documents and detail technical design for all programs.

Westborough Ma

02/10-04/11 Store Systems - Region District field expansion for TJX Europe. • Complete responsibility for technical design of field expansion and translation of the store catalog file to new values. Wrote technical specs. Changed Cobol programs and batch procedures. Unit tested all changes. UAT tested all changes to the financial reports associated with each country, region and district.

Westborough Ma

PCI Compliant Project phase 2 • Redesign previous encryption in programs to call locked box for encryption key

Westborough Ma

Merchandising Systems• Wrote DB2 program to keep Germany’s buyer matrix in sync with England’s buyer matrix tables.• Distribution system – write and review specs. Code and QA test CICS screen program changes.• Code and test batch programs. Write execute JCL and review coding changes by other programmers.

Westborough Ma

TKMaxx - European Expansion Germany - Tested programs and procedures.• TJX Rewards Associate Discount Project - Wrote three programs to report Daily Associate Discounts,Monthly Rollup of Discounts and Coupons Redeemed but not Tendered with a Chase Card.Wrote Procedures, tested and implemented the project to all divisions.• PCI Compliant Project - Responsibility for TKMaxx and Ireland – Analyses of all procedures with sensitive data. Redesign and restructure of procedures to encrypt and decrypt files. Code encryption and decryption programs. Changed unencrypted files within processes to be temp files which disappear when the procedure abends or completes. Tested and compared data results with production. Wrote restart instructions. Implemented procedures. • KPI project - Analyses of KPI processes and programs. Modified programs to produce data files as specified in project plan document.

Westborough Ma

European Expansion Germany Cloned programs, procedures, control cards and docutext according to rules provided.• Created test execute JCL. • Tested programs and procedures in two regions.• Researched control cards to identify any that are in error.• Generated Docutext file control elements.• Production problem Marshalls - Changed space allocation on 6 procs. Changed docutext, Created a changeman package to move to production.

Quincy Ma

• IMS – analyze processes to determine where transactions are being lost. Write programs to maintain databases.• Debug problems with IMS screen programs. Work within a team to expand store number through all pricing systems.• DB2 – modify existing programs. VSAM – write Ezytrieve vsam programs. Production support – oncall duties. • Visual Basic –Add modules to the Inquiry Screen program to process a new company’s data. • Write sequel code to retrieve vendor information. • Change data load program and write a delete program.• Client Server sequel database – load database tables with enterprise manager utility• Pricing Rules Project- Analyze, code, unit test and implement programs that process mainframe pricing and competitive pricing data to the Rules database.

Westborough Ma

Imports for Homegoods Project• Modify CICS screens and DB2 sub programs to add a new division and separate data to be displayed to the user by division.• Also modified DB2 Batch programs to add a new division. Implement to production MVS Cobol DB2 system. Purge and Archive Project- Modify• Enhance, test and implement

Quincy Ma

Non Price Project• Research Non price handle code through systems. Create spreadsheet of analysis work.• Turn off update on screen, redesign to read state database segment to display on screen. Add update to screen with State level data, write transactions to audit database. Write program to update database with state level transactions. Coupon Re-engineering • Add coupon types and unadvertised scan savers to mainframe programs. Visual Basic• Create form and code to select date range, read mainframe file on network and create spreadsheet with page breaks for printing. Add unadvertised coupon input fields and calculations to Mini Pl Spreadsheet. Edwards Project.• Mainframe modifications, added Edwards calculations to Mini PL Spreadsheet Y2k Project • Remediated Supermarket IMS DC and Telon programs. Tested and implemented programs. Coupon Overlap project• Changed Sale input programs to allow user to change a sale within a programmed time frame. • Wrote overlapped coupon information to an audit database. Wareitem project• Researched and analyzed wareitem processes through online input to PC upload using the tool Visio. • Created Eztrieve reports to enable the advertising department to have information from the sale database. DB2• Wrote DB2 program from Eztrieve program to update DB2 tables with information from the weeks processing.Telon • Added fields to screens, processed the fields to a database. Changed batch program to process them. CICS • Add 3 data fields to screen. Add code to update databases with new data fields.