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.

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.
• 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.
• 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.

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.
• 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.
• Mainframe modifications, added Edwards calculations to Mini PL Spreadsheet Y2k Project