Sales System
Resume:
SENIOR PROGRAMMER/ANALYST
Boonton, NJ 07005
*********@*********.***
http://www.alexnavia.com
http://www.linkedin.com/in/alexnavia
EXPERIENCE
Case Tools Inc. 2011
Environment: COBOL, CICS, DB2, IMS, VSAM
Provided testing and debugging support for a company acquisition process. The acquired company s data was loaded to DB2, IMS, and VSAM data stores which comprised customer, billing and accounting systems. Created test cases, debugged or improved existing programs, and provided support of legacy systems.
Yourtownmall LLC. 2004 2010
Environment: ASP, VBScript, JavaScript, HTML, XML
Developed the company s local business directory of 72,000 cities and towns in the US and Canada, with information on over 12 million businesses, schools, hospitals, and government and local organizations.
Incorporated a new video-on-demand feature with geographically targeted dynamic advertising allowing local merchants to display commercial ads within their geographical area.
ADT Security Services Inc. 1987 2004
Environment: COBOL, CICS, IMS, DB2, VSAM
Replaced a payroll company interface with a new self-correcting online/batch system reporting to the company s general ledger, which simplified the task of validating the bi-monthly payroll. This resulted in a cost saving reduction in the company s payroll staff.
Developed an online data entry application for the company s pension benefits plan to accumulate personnel data used in pension evaluations.
Developed a billing application to invoice security services on telephone company statements and accept remittances collected by the telephone company, thereby significantly reducing the cost of collecting receivables.
Created a contract termination charges management subsystem to automatically write-off selected termination charges, post the results to the general ledger, and reduce taxable income. This subsystem saves the company seven million dollars annually.
Designed and implemented a sales and use tax tracking subsystem interfacing with the company s construction-work-in-progress system. This subsystem calculates tax based on the system installation s geographical area.
Designed and implemented a 401K plan anti-discrimination system to project employee 401K income deferrals. The system calculates individual deferral percents needed to comply with federal 401k requirements, automating a time-consuming process involving over 14,000 employees.
Developed an online and batch interface to a telemarketing system to add new orders to the company s order entry and customer maintenance subsystems. This removed the need to enter telemarketed orders into the company s order entry subsystems manually.
Designed and implemented an acquisitions subsystem to incorporate a purchased company's customer information into order entry and customer databases. Designed as a general purpose API, the subsystem has been used in the acquisition of several different companies.
Manufacturer's Hanover Trust Bank 1987
Environment: COBOL, VSAM
Developed a mortgaged obligations system producing payable date bond blotters for institutional bondholders recorded on the dividend and interest register and modified a loan processing system to incorporate auto-settlement of taxes and legal fees.
As part of a project team, modified a loan processing system to incorporate auto-settlement of taxes, recording and legal fees, and fees for conducting the settlement.
New York Times Newspaper 1985 1987
Environment: COBOL, CICS, IMS, VSAM
Designed and implemented a contract management system for classified and commercial ads which maintains a database of advertising contracts and automatically generates the ad print copy for the paper's printing subsystems.
Developed an automated contract renewal subsystem interfacing with the contract management system described above. Together, these two applications replaced a labor intensive manual contract process for classified and commercial ads.
Health Insurance Plan of NY 1984 1985
Environment: COBOL, ISAM
Developed an actuarial rate table subsystem to calculate individual insurance premiums based on published population morbidity statistics. This system replaced manual underwriting procedures which resulted in significant time and cost savings.
Merrill Lynch 1983 1984
Environment: COBOL, VSAM
Designed and implemented a medical insurance benefits system involving human resources, payroll, and accounting systems which was funded by employee payroll deductions.
Scholastic Magazines Corporation 1983
Environment: COBOL, CICS, VSAM
Installed the McCormack and Dodge General Ledger and Accounts/Receivable software, both batch and online. The A/R was a new installation, while the G/L upgraded several releases.
Avon Products Corporation 1981 1982
Environment: COBOL, CICS, VSAM
Developed a sales trends and projections system to predict future product sales based on a cumulative database of national sales statistics. This system replaced the manual procedures used by the company s sales trending department.
Designed and implemented a production line system controlling industrial robots that fulfilled ad-hoc package sales orders based on customer selections or Avon designed package promotions.
Equitable Life Assurance Corporation 1978 1981
Environment: COBOL, VSAM
Coded and implemented a cash flow reporting system for a portfolio of stocks and bonds managed by the group pensions department. This system replaced time consuming manual procedures.
Rewrote a cash flow projections system for a portfolio of stocks and bonds managed by the group pensions department. This new system streamlined processing and added new functionality.
Expertise
• Business Analysis
• Functional Requirements
• System Specifications
• User Interface Design
• Application Programming
• Product Testing
• Technical Writing
• Project Management
My Resume
Contact Me
Contact this candidate