Resume 3

Mission critical systems software development

• History of successes building software systems ground up
• Solid expertise designing software and relational databases
• Extensive practical hands-on with full software life cycle
• More than fifteen years of IS development experience
• Strong ability to expand expertise in new technologies

• Languages: Visual FoxPro, VB, HTML, JavaScript, VBscript, SQL, Visual C++,C,Java,RPG, CL, Natural, JCL, PL1, Pascal, FORTRAN, Assembler, COBOL, Mumps
• Systems & Tools: Visual Interdev, MS ACCESS, dBase, Adabase, DB2, Lotus Notes, AS/400, NetWare, Mainframe, TSO, UNIX, PDP/11, RUMBA

SAG America NATURAL Programming 1998
Chubb Institute Advanced VB Programming 1996
BELLCORE Telecommunications course 1995
Hewlett Packard UNIX Operating System 1994
IBM Learning Center AS/400 SysAdmin, RPG, CL 1990, 1992
State School of Economics JCL, Assembler, PL/1, COBOL, OS/VS 1980
Assembler, PDP-11, FORTRAN
Moscow State University MS in Physics 1979

Clearance: USPS Sensitive Security Clearance
Foreign Languages: Fluent conversational Russian

• Payroll applications.
• SQL stored procedures.
• Web Reporting.

• Muzinich ASP, JavaScript, VBScript, SQL, HTML .

  WEB site for investment firm. Developing WEB pages using VBscript and JavaScript, upgrading existing software and SQL Database.

• Roof Leak Journal e-Commerce, ASP, JavaScript, VBScript, SQL, HTML .

  WEB site advertising, selling and delivering Roof Leak Journal software package via Internet. Online sales orders entry. Credit cards information processing and online sales. Delivering software product to customer s workstation.

• Tech Calendar ASP, JavaScript, VBScript, SQL, HTML .

  WEB site to maintain the calendar of workload, projects and assignments for technical stuff of the company. Developing WEB pages using VBscript and JavaScript, upgrading SQL database.

• Xilinx ASP, JavaScript, VBScript, MS Access, HTML .

  WEB site to maintain the building administration information. Areas controlled by the system include building repair requests and schedules, conference rooms occupancy log, business lunches ordering pages etc.

• Cosine VB, MS Access .

  Sales forecasting system. Data entry, processing and reporting. Development, maintenance, upgrading.

• Implemented proprietary forecasting concept based on eighteen months rollover schema.

• Evapco Visual FoxPro .

  Product pricing system, designed for sales representatives. Generates quotes based on the selected equipment order configuration. Upgrading, maintenance and troubleshooting.

• Productivity Information Management System PIMS MS Visual C++ .

  Application for time and attendance as well as postal machinery data collection. Source code Y2K compliance analysis. Unit and system level testing, troubleshooting and Y2K bugs remediation process. Independent verification, validation and Configuration Management.

• Remote Encoding Center Management System - RECMAN VB .

  Software package for managers and supervisors to maintain control over remote sites, to input data and to output reports. Source code Y2K compliance analysis. Unit and system level testing, troubleshooting and Y2K bugs remediation process. Independent verification and validation.

• Corporate Benefits Technical Support Adabas, Natural, TSO, JCL .
• Maintenance of existing Corporate Benefits System. Ad Hoc requests development.
• Adding functionality and building documentation for the system in production.
• Working on Year 2K project.

• JDEdwards into SAP conversion MS ACCESS, VB, RPG, CL .
• Software converting General Ledger and Accounts Receivable data. Legacy system is located on AS/400 platform in JD. Edwards. Data had to be uploaded into SAP over ORACLE.

• KPI data base MS ACCESS, VB .

  The purpose of the database is to provide various levels of management with efficient controlling tool. Data Base designed to store and access information for Key Point Indicators KPIs are major performance characteristics of the corporation and it s departments . KPIs graphically implement the image of the dashboard instruments. The Data Base contains functionality for KPI parametrization.

• Dashboard simulator MS ACCESS, VB .

  Allows generation, maintenance and viewing of Performance Dashboards. Dashboard is a configuration constructed and build from the set of KPI instruments.

• Switch Command File Generator VB .

  Software analyzes current status of Communication Switches and generates switch command files. Command files then uploaded to the switch and run as a switch programs.

• Issues data base system Microsoft Access and VB .

  Specialized Project Management System developed for needs of Revenue Assurance Department. Provides data entry, reporting and querying functionality to maintain a Data Base of requests, problems, and issues. This information supports corporation re-engineering process.

• CDR Conversion System C .

  System designed to create and maintain data base of CDRs phone Call Detail Records . CDRs are generated and stamped by telecommunication switch. They represent traffic of phone calls on the telecommunication network. The Data base is populated in the process of converting original CDR records from switch into DB2 format.

• Sales orders distribution program MS ACCESS, RUMBA 95 ARPEGGIO .

  Downloads, processes and distributes sales orders from the database into various queues. Each queue is the workload per worker of provisioning department. Information is filtered by employee duties and specialization. It creates sales orders processing conveyer , when orders dispatched from managerial levels to subordinate workers.

• Calls Profile Package MS ACCESS, Visual FoxPro, RUMBA 95 ARPEGGIO .

  Extracts phone call records from the data base. Provides reports and screens with statistical information. Users of the package are workers of Number Administration department.

• Co-Carrier Billing System FoxPro 2.6 .

  Designed for billing clerks and employees of Cost Management department. Provides data storage and functionality for maintenance of co-carrier invoices. This data base represents rented telecommunication facilities. It allows data entry, auditing, querying and reporting.

• Provisioning system Visual FoxPro .

  Designed for Provisioning and related departments working with collocation facilities. Allows provisioning clerks to maintain inventory of telecommunication facilities and pool of phone lines. Provides tools for allocating and release of collocation facilities per sale orders. Generates Service Requests to Switch Administration and Field Engineering.

• AS/400-DB2 mirroring utility Visual FoxPro , IBM PC SUPPORT, RUMBA 95 ARPEGGIO .

  Refresh mechanism responsible for the ad hoc creation of cross-platform replica and mirroring of the data base located in AS/400 environment. Synchronizes databases located on AS/400 and LAN.

• Sales orders statistical system.

  Software package generating the set of Sales Analysis reports. Initiates ad hoc analysis of master and data files containing millions of records Visual FoxPro, IBM PC SUPPORT, RUMBA 95 ARPEGGIO .

• MS Excel-FoxPro conversion system Visual FoxPro .

  Utility designed to import and merge Collocation facilities information from the library of MS EXCEL spreadsheets into the relational Data Base constructed in FoxPro environment.

• Nynex Service Request generator Visual FoxPro .

  Program extracts information from sales order requested, compliments that with the related co-location facilities information and generates Nynex ASR Access Service Request in the proprietary format defined by the Nynex corporation.

• Human Resources System FoxPro, dBASE, Clipper .

  Custom designed relational Data Base maintaining various aspects of employee information. Provides functionality, required by Human Resources management and clerks including data entry, reporting and querying.

• Sales Orders Import/Export System FoxPro .

  Link between Order Entry System of IBM AS/400 MAPICS and EDI on the network . This batch software receives sales orders from EDI and converts them into MAPICS proprietary format. Generated orders then are being uploaded to AS/400. The system also downloads customer invoices from MAPICS onto network and converts them into EDI format to be sent out.

• Netware 3.11 administration Netware 3.l1 .

  Installation and maintenance of Netware 3.11. Responsibilities included connectivity across LAN, installation and maintenance of IBM PC SUPPORT, RUMBA, FoxPro, LOTUS NOTES, MS Office and the like. Creating user profiles, maintaining security, server backups and performing various administrative functions.

• LOTUS NOTES 3.1 installation and maintenance LOTUS NOTES 3.1 .

  Installing and administrating NOTES server and NOTES workstations. Importing and exporting information between FoxPro 2.6 and LOTUS NOTES 3.1 platforms. Programming forms and reports in LOTUS NOTES.

• AS/400 download system FoxPro, IBM PC SUPPORT .

  Batch system designed for nightly downloads of MAPICS data base located on the AS/400. Extracted information is transferred onto file server and converted into relational data base on the LAN.

• Interactive System for Customer Service and Sales FoxPro .

  Quick response system designed for users working with customers in real time. System generates customer and product sales profiles for ad hoc analysis.

• Accounting Department Reporting and Inquiry System FoxPro .

  Software package creates reports, ad hoc queries, screens and MS EXCEL spreadsheets, requested by accounting clerks and management. Master files of MAPICS GL are used as a source of information.

• Order entry system for customer service S/36, RPG .

  Designed to work as an interface with MAPICS Order Entry. It provides special pricing information and functionality for the operator and Order Entry users.

• Commissions Processing System FoxPro .

  Package implements company commissions policies and maintains commissions information database. Algorithm calculates commissions per sales reps, generates commission reports and queries.

• Profitability system FoxPro .

  Software system matches pricing and sales information with cost information based on the Bill Of Materials. Produces files, reports, queries and screens.

• Research and Development of automated enterprise control software systems.
• Designing and maintenance of interactive software systems for corporation CEO s.

Development and maintenance of software systems and specialized DBMS s storing information for farming equipment, machinery and spare parts inventory industry wide.

• Development of hardware status control software.
• Development of electronic photo-type setting system.

English-Russian translator of theoretical and applied science publications.