Edward M. Lufrano

631-***-****

ac6bbi@r.postjobfree.com

PROFESSIONAL SUMMARY

Seasoned professional with significant Mainframe development, design and conversion experience including conversion from VSAM to DB2 as well as a replacement/conversion of large order processing system from Mainframe to SAP using Informatica. Technically skilled as the point person for requirements document gathering and liaising between business groups. Skilled at learning legacy systems quickly in order to replace or convert and learning new environments to accomplish the same goal. Significant architecture, design and development experience.

Qualifications & Expertise

Application Design, Development, Testing, Planning, Integration, Implementation, Problem Diagnosis, Scheduling, Database Design, Data Gathering/Analysis, Code Optimization, Requirements Gathering, Business Collaboration, Meeting Milestones, Project Lifecycle.

TECHNICAL EXPERIENCE

Software/Databases: COBOL, CICS (Command and Macro), JCL, DB2, VSAM, SQL, QMF, SPUFI, InterTest, CA Scheduler, CA Sort, ChangeMan, FileAid, TSO/ISPF, SAP, JCL and Procs, Informatica

Methodologies: Application Design, Development, Testing, Planning, Integration, Implementation, Database Design, Data Gathering/Analysis, Code Optimization, Business Collaboration, Project Lifecycle

Others: Problem Diagnosis, Scheduling, Requirements Gathering, Meeting Milestones

PROFESSIONAL EXPERIENCE

PERSONAL STATEMENT Jan 2017 – Present

Received an early retirement package from Estee Lauder due to outsourcing my job. Trained my offshore replacements. Looking to get into employee or contract assignments to help organizations with their design, re-design, transformation and conversion projects.

THE ESTEE LAUDER COMPANIES, INC., Melville, NY Jul 2002 - Dec 2016

Senior Business Analyst and Application Architect

Responsible for projects affecting large-scale applications

Gathered requirements from User Community; Developed requirement/functional/technical/design specification documents

Tracked and reported project status to upper management and business community,

Built and designed home-grown batch process scheduling system to ensure that batch jobs were executed successfully and on-time

Designed, built and implemented Physical Inventory Tracking system (VB.NET connecting to Mainframe DB2 tables)

Converted Physical Inventory application from VSAM to DB2,

Designed and developed a Mainframe-to-Unix Excess inventory reporting application utilizing COBOL, BV and Oracle stored procedures

Designed and created a multitude of DB2 tables and supporting maintenance jobs,

Re-designed and re-developed marketing tracking system to interface with SAP

Designed and built 24/7 interface between IBM platform and SAP Order Management system,

Developed batch interface between IBM platform and Unix based retail order recommendation system

All of this work done primarily using: COBOL, CICS, DB2, SQL, JCL and Procs

EML COMPUTING SERVICES, INC., Lake Grove, NY Jul 1994 - Jun 2002

Business Application Software Consultant (Owner)

Worked for Estee Lauder Companies supporting and enhancing global Order processing application

Designed, developed and maintained Replenishment application utilizing COBOL, CICS and VSAM

Designed and implemented on-line, real-time Credit Hold and Review system

Implemented EDI Inventory Adjustment Processing system collaborating with EDI technical team and Major retail organizations.

Developed applications utilizing VB and DBASE/Clipper for clients including: Cleaning Service Invoicing, inventor and sales application, Security alarm customer service system, Retail pharmacy management system, Time-clock interface and payroll system, Auto body shop job Scheduling and tracking system, Financial loan Collections and account management system.

THE CHASE MANHATTAN BANK, GARDEN CITY, NEW YORK/METRO-TECH COMPLEX, Brooklyn, NY Sep 1990 - Jul 1994

Project Manager (Second Vice-President) – Consumer Credit Card Accounts Receivable System

Managed a group of 25 programmers who designed, implemented, maintained and enhanced a large-scale, real-time, on-line Accounts Receivable system which interfaced with Fraud detection, Authorization, Customer service, Credit application, Collection and settlement systems

Gathered requirements from User community, developed requirement/functional/technical/design specification documents

Developed system that processed transactions received from TWA and NYNEX and calculated bonus points based upon frequent flyer mileage and phone usage

Tracked projects via project management workbench, reported project status to upper management and Business community

Responsible for interviewing and hiring new technicians, wrote and presented annual performance reviews, collaborated with upper management in the recommendation and calculation of salary increases and bonus allocations.

Project Manager – Consumer Credit Card Collections System Oct 1986 - Aug 1990

Managed group of 15 programmers who developed and maintained a large-scale Credit Card Collection system, tracked projects via project management workbench, reported project status to upper management and Business community, responsible for interviewing and hiring new technicians, wrote and presented annual performance reviews, collaborated with upper management in the recommendation and calculation of salary increases and bonus allocations.

Project Leader – Consumer Loan Applications System Aug 1984 - Sep 1986

Lead team of technicians in the design, creation, testing and implementation of a large-scale, real-time credit bureau interface system utilizing BAL and CICS and TCAM, maintained and enhanced nation-wide personal loan application system, tracked projects and reported status to management, responsible for interviewing and hiring new technicians.

Senior Programmer Analyst Sep 1983 - Jul 1984

Enhanced and supported a national credit card application system utilizing BAL, COBOL and CICS.

Developed real-time Credit Bureau interface system which performed credit inquiries with the 5 major credit bureaus and received and analyzed credit report details to determine consumer credit worthiness.

THE NEW YORK TIMES, NYC, NY Nov 1982 – Sep 1983

Systems Programmer

Upgraded and maintained IBM mainframe operating systems (CICS under DOS/VSE in VM environment).

Tested and installed new releases of CICS, DOS/VSE.

Applied operating system patches, created specialized utilities utilizing BAL (IBM assembler language).

HARVEY ELECTRONICS, Syosset, NY Oct 1979 - Nov 1982

BAL (assembler) Macro-level CICS Programmer

Programmed and implemented wholesale electronics component sales, inventory, distribution and reporting systems using BAL, Macro level CICS, RPG and VSAM on IBM mainframe.

Lead Computer Operator Jul 1978 – Sep 1979

Responsible for batch job set-up, scheduling, execution and trouble-shooting, database sizing, applying Operating system updates, interacting with programming staff, DOS/VSE JCL creation and modification.

EDUCATION

Bachelor’s Degree

Queens College

Associate’s Degree

Queensborough Community College

Contact this candidate