Edward M. Lufrano
********@*********.***
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