Ivan Micklin

Eastern District Manager

New York Office

PICK/InfoLease Programmer, Systems Analyst & Consultant since 1987

Never give up, for that is just the place and time that the tide will turn.  --  Harriet Beecher Stowe

     EDUCATION

     EXPERIENCE

 2004 to Present

Garnerville, NY

Ivan has Project & Software Management expertise in Global Financial Services, Retail, and Entertainment Industries with extensive experience and in-depth knowledge of System Administration, System Design & Development, team building, customer service, problem identification & resolution.  He has modified back-end UniData code for a Human Resource Services company to replace Redback middleware with UniObjects.  Ivan has also gathered user requirements and produced code to add functionality and features to the UniVerse system of an international freight and logistics services company.  And he built and deployed a website for a new business.  Technologies include:  U2 (UniData/UniVerse), AIX/UNIX, UNIX Scripting, PERL, PERL Scripting, ASP.Net, VB.Net, SQL, Windows 2000, MS Word, Excel, Project, Visio, PowerPoint.  Primary application:  InfoLease (revision IL.9F, sub-releases 307, 277, 259, 201).  Modules include:  Accounts Receivable, Automated Clearing House, General Ledger, GL Link, Federal Highway Use Tax, Floating Rate, Inventory, Insurance, Universal Contract Interface, and Renewals.

 2010 to Present

Ivan manages automated schedules which run more than 200 processes in eight databases.  Troubleshoots program aborts, identifies cause, corrects, then resets the schedule.  Analyzes program code to identify concerns which cause data integrity issues.  Extracts data to satisfy user requests for data analysis and regulatory reporting.  Technologies include:  UniVerse, Sun Unix.

 2008 to 2010

Ivan analyzed requirements for data extract to feed an external auto-replenishment system.  Gathered user requirements and designed modifications to write code for inventory control system.  Analyzed input and output requirements to modify existing and develop new maintenance and inquiry screens.  Designed and coded style and vendor data extracts to feed an EDI process.  Analyzed requirements for programs to exchange data between retail system and an external Accounts Payable system.  Gathered user requirements then authored various sales and merchandising reports.  Technologies included:  UniVerse, IBM AIX.

 2006 to 2008

Ivan determined requirements to write programs exchanging data between different database systems.  Provided production and technical support to helpdesk personnel.  Analyzed user requirements for printing payment and VAT schedules for various countries within European database.  Determined requirements and created GL interface programs to feed data to PeopleSoft and the CIT user database.  Designed and developed lockbox processing and cash batch creation for Canadian and American databases.  Gathered requirements for a detailed process to score contracts/customers.  Determined needs and modified various processes to integrate newly purchased portfolios into existing databases.  Updated custom invoice print programs.  Modified processing of LIAS insurance and ACH files.  Technologies included:  UniData, HP Unix.

2004 to 2006

Ivan managed project to develop software change management methodology, providing change management/version control for 60 independent CitiCapital applications.  Managed project to implement IBM Rational ClearCase & ClearQuest software configuration management tool.  Supported user helpdesk.  Automated helpdesk processes to allow faster problem resolution.  Developed data flow diagrams to document existing and proposed processes.  Developed use cases, decomposition diagrams, business requirements documents, workflow analysis, etc.  Designed/developed/modified new and existing processes to improve efficiency and productivity.  Technologies included:  UniData, IBM AIX.

1998 to 2004

Ivan managed projects which included building a GUI front-end to a character-based UniData application using VB.Net.  Added browser-based reports from a UniData system to download automatically to users' PCs.  Managed software development projects by developing specifications, determining scope, identifying potential risks, and hands-on involvement including programming in UniData, testing, and implementation.  Managed conversion project from a non-UniData to a UniData application.  Followed concepts of SDLC in managing projects and providing status updates.  Provided production support to clients, including preparation of documentation & training.  Directed activities of all project managers which increased the ratio of billable-to-total hours by 22%.  Managed client relationships and provided consulting services.  He also supported the following modules:  Marketing Rights Management, Worldwide Distribution Licensing, Residual Payment Processing, and Advertiser/Barter Sales.  Technologies included:  UniData, UNIX, Mentor Operating Environment, mvBase, Windows NT, Novell, VB.Net, HTML, HostAccess.

1992 to 1998

Ivan transformed an unused system into an effective management reporting & decision support tool for this multi-location retailer by modifying existing programs and writing new programs to add functionality.  Customized price change and inter-store transfer modules by recoding existing PICK processes to work with OS/2 based Point Of Sale.  Established infrastructure to support corporate systems and allow for future growth.  Provided advisory services to all departments and advised senior management on technical issues.  Identified areas where existing processes could be automated or improved.  Directed project to select hardware & software to replace existing systems in order to provide management with additional information on a more timely basis.  Technologies included:  Ultimate PICK, Honeywell DPS6, OS/2, Fujitsu POS, Windows.

 1991 to 1992

Ivan provided Information Systems and Telecommunications services to clients in various industries, including retail, direct marketing, and ticket sales.  Projects included review of least cost routing for eastern US network, saving client $350,000.

 1989 to 1990

Ivan managed all IT, Point Of Sale, and voice/data communications functions in multiple locations.  Led project to design, develop, and implement an inventory system to provide merchandise personnel with more detailed information on performance by merchandise categories.  Implemented Software Development Life Cycle (SDLC) process.  Ensured that IT and telecommunications strategies were consistent with corporate goals & objectives.  Trained store personnel in new & enhanced processes.  Technologies included:  Reality PICK, McDonnell Douglas S18 and Spirit, Novell, Windows, IBM POS.

 1979 to 1989

Ivan managed software development, computer operations, voice & data communications, and data entry.  Prepared work flow analysis, designed forms, documented operating procedures, and trained users to comply with corporate policy & loss prevention requirements.  Led project to design & implement a direct marketing system with a call center, resulting in development of a multi-million dollar direct mail business.  Member of project team that implemented a retail software package.  Managed mainframe systems, including human resources & payroll, credit management, and online general ledger.  Developed & administered budgets in excess of $1.55 million.  Technologies included:  Reality PICK, McDonnell Douglas S18, C. Itoh PICK, Windows, IBM Mainframe, IBM POS.

     EXPERTISE

• .NET

• Distribution / Sales Orders

• PERL scripting

• Accounting

• ETL Data for Export or Import

• Point of Sale / Service

• Accounts Payable

• Finance

• Printer Interfacing - PCL

• Accounts Receivable

• Forms Generators

• Project Management

• AccuTerm GUI

• General Ledger

• Retail

• Ad Hoc Reports

• HTML

• Sales Analysis

• ASP.NET

• Human Resources

• Software Conversions

• Asset Depreciation

• InfoLease

• SQL

• Automated Clearing House

• Insurance

• Systems Administration

• Business Analysis

• Inventory Control

• U2 and Oracle Data Exchange

• Cross Reference Indexing

• Loans / Contracts Mgmt

• UNIX scripting

• Data Mining / Extraction

• Lock Box / Cash

• Visual Basic .NET

• Database Administration

• Maintenance Utilities

• Voice / Data Communications

• Database Conversions

• Manufacturing

• Warehousing

• Database Migration

• Payroll / TimeClock

• Web Development

• Direct Marketing