Резюме программист Oracle

Михаил Макаркин

Должность:	программист Oracle
Образование:	специалист
Имя:	Михаил
Фамилия:	Макаркин
Страна, регион:	Украина, - /согласен на смену жительства/
Адрес:	ул. Дворцовая 32-40, г.Краматорск, Украина, 84301
Заработная плата:	open
Возрост:	44
Телефон:	+38006264-50278
Факс:
email:
Языки:	английский(SRw)
First name: Mykhaylo Last name: Makarkin Home phone: 06264-50278 (available from 19:00 till 23:00 Moscow time) Office phone: 06264-78111 (available from 9:00 till 16:00 Moscow time) Cell phone: +380953923666 E-mail: mmak@krm.net.ua Summary • Fifteen (15) years of summary experience in IT industry includes Design, Development, Implementation, Testing, Documentation; • Nine (9) years of experience in server-side, client/server and multi-tier software development using RDBMS Oracle; • Seven (7) years of experience in Internet technologies: HTML/DHTML design, JavaScript and JSP programming, SMTP/POP3/IMAP protocols; • Worked Extensively on Client/Server, Web Applications; • Excellent expertise in RDBMS Oracle (7.1, 8.1.7, 10g) technologies and architecture, SQL, optimization of queries, PL/SQL, stored procedures, functions, packages, objects and triggers; • Excellent expertise in client/server programming using Borland Delphi (v. 5, 7, 8), Oracle Developer with RDBMS Oracle; • Very good experience in web programming using DHTML, Java Script, JSP, Java, PL/SQL cartridge, Oracle Forms and Reports servers with Oracle Internet Application Servers; • Having Excellent Knowledge in mail protocols (SMTP, ESMTP, POP3, IMAP), anti-spam technologies. • Possess Excellent Knowledge in IDEF0, IDEF1, CASE*Method (by Richard Barker) methodologies (using BpWin, ErWin, Oracle Designer). Education Bachelor in aircraft instrument making. Specialty: Engineer-electrician. Diploma with honors. - Kharkov Aviation Institute, Kharkov, Ukraine, 09/1983 - 02/1989 Authorized courses of qualification improvement: `Programming in Borland Delphi 3.0` (Specialized in programming for RDBMS Oracle) - Training center `SoftServise`, Moskow, Russia, 05/1998 - 05/1998 Professional Certification RDBMS Concepts; Java 2; English Vocabulary. All - Brainbench (ID Number is 3194207) Technical Skills Languages : PL/SQL, SQL, Pascal, Java, C, C++, x86 Assembler Database : Oracle 7.1, 8.1.7, 10g; IBM SQL/DS, FoxPro, Clipper Middleware : Oracle iAS Development Tools Borland Delphi 5-8, Oracle iDS, Oracle JDeveloper 9i, SQL Navigator, TOAD Internet Tools : Apache, Oracle Forms and Reports servers, HTML/DHTML, VB Script, Java Script Messaging Tools : Oracle AQ Office Tools : Word, Excel, PowerPoint Operating System : Windows 2000/XP/NT Reports : Oracle Reports, Fast Report Source Control : CVS Others : SMTP/POP3/IMAP, Multithreading, JavaBeans Professional Experience (recently completed or interesting projects) Project for corporative ERP system, New Kramatorsk Machine Building Works, Kramatorsk, Ukraine (www.nkmz.com) Role: Sr. Software Developer May’2005 – till date This project is intended for automation of business-processes in financial department, 5 marketing departments, accounting department. It provides facilities for taking stock of incoming monetary funds and allocation them for invoices, contracts and contract items. Consists of two parts: the main client/server module (Borland Delphi, PLS/SQL and RDBMS Oracle) and the web-based reporting system (Oracle iAS, PL/SQL cartridge) for high-level managers. The system is able to get information from banking systems, preprocess in the financial department, control allocation and reallocation of monetary fund in marketing departments in coordination with other departments. It has advanced reporting subsystem for high-level managers. The system takes into consideration presented bills, contract delivery dates, production plans. The information of this project is used in many other corporative information systems (accounting, management of contracts, production planning and etc.) Responsibilities: • Developed and implemented (PL/SQL) complex server-side row-based access control system (using Oracle fine grained access control facilities); • Developed and implemented users access management tool using Borland Delphi; • Heavily involved in implementation of the front-end for allocation and reallocation subsystems (Borland Delphi, PL/SQL stored functions). • Heavily involved in tuning the most part of the “heavy” database queries (SQL, Oracle). Environment: Oracle 9i, Oracle iAS 9i, Borland Delphi 8, PL/SQL, SQL Navigator, Windows 2000, Windows XP, OLE, Microsoft Office 2003. Project for corporative ERP system, New Kramatorsk Machine Building Works, Kramatorsk, Ukraine (www.nkmz.com) Role: Sr. Software Developer Jul’2005 – Jan’2006 This is the migration project basically migrate from DBF (Clipper) based system into client/server environment. The existing DBF databases were migrated into Oracle tables. The existing Clipper based application was rewritten using Delphi and stored procedures and functions. This application is main part of the “Bookings” module of the corporative ERP-system. It’s integrated with many Oracle-based and legacy applications. So it has the advanced module for information exchange and uploading data into the legacy systems. Responsibilities: • Involved in understanding of Clipper based coding and converting into Delphi code • Heavily involved in Delphi application for to migration from DBF based system. • Heavily involved in Oracle stored packages, views and triggers, ensuring set up relations includes indexing, constraints, foreign keys etc. • Code review, unit testing, debugging and integration testing of the application Environment: Borland Delphi, Oracle Reports, PL/SQL, Oracle RDBMS 8.1.7, SQL Navigator. Project for corporative ERP system, New Kramatorsk Machine Building Works, Kramatorsk, Ukraine (www.nkmz.com) Role: Sr. Software Developer Dec’2004 – May 2005 This project is the client-server and web-based information system for shipment scheduling. Consists of two parts: client/server module for shipment scheduling and web-based reporting module. All parts are based on the tables of the corporative information storage (Oracle). Reporting module is based on the corporative application server (Oracle iDS 9i). This module is evolves periodically. It uses 3-tier architecture. The front-end is developed using HTML, JavaScript, PL/SQL web cartridge of Oracle iAS, JSP. The middle-end is the set of CGI applications. These applications run specialized reporting applications. Specialized reporting applications generate very complicated reports in MS Excel format. Then CGI applications will return reports to the end users. All processes are synchronized and they work in the multi-user environment. The middle-end is developed using Borland Delphi, OLE Automation, MS Excel, PL/SQL stored functions. The middle-end connects to the database using DOA components. Responsibilities: • Involved in implementation of the front-end using HTML, JavaScript for reporting module. • Heavily involved in design and implementation of the middle-end CGI and reporting applications using Borland Delphi, OLE Automation, MS Excel, PL/SQL stored functions. • Heavily involved in design and tuning the most part of the database queries (SQL, Oracle). Environment: Oracle 9i, Oracle iAS 9i, Borland Delphi 8, PL/SQL, SQL Navigator, Windows 2000, Windows XP, OLE, Microsoft Office 2003. Anti-spam system “MailBox Sentry”, shareware Role: Architect / Developer March’2004 – till date This is the anti-spam system based on the challenge/response approach. This application is a multithreaded POP3/SMTP proxy based on the freeware components. It has several unique features. For example, challenge/response system is tightly integrated with SMTP proxy. It allows always admitting replies to your messages and separating and getting valid delivery error messages from incoming mail. This system sends only 1 challenge for each sender; it can detect dead loops and etc. The “MailBox Sentry” analyses history of web browser and it can get all mail messages from visited sites (to get registration messages and etc.). Site of this project: http://sentry.com.ru/eng/index.htm. Project is based on Borland Delphi and Indy. Responsibilities: • Done requirement analysis, architecture design, object oriented analysis and design. • Designed and developed the end-user interface. • Designed and implemented all algorithms for the project (using Borland Delphi and Indy). • Designed the help and web-site for the project (using Macromedia Dreamwaver 4). • Heavily involved in testing and end-user support. Environment: Borland Delphi, Indy 9, Macromedia Dreamwaver 4, SMTP, POP3, Windows Project for corporative portal, New Kramatorsk Machine Building Works, Kramatorsk, Ukraine (www.nkmz.com) Role: Developer, Oracle iAS Administrator 2004 After the Oracle Corporation has changed its application server platform radically (Oracle Application Server 4 is very different from Oracle iAS), we had to resume the project for corporative portal, that was finished in 2000. The project was improved and ported onto the Oracle Internet Application Server platform. The core Java servlet was changed and improved to work in the new environment. Up to now this is the main part of the corporative information portal; it has more then 1000 active users and it works 24/365. Responsibilities: • Improved and ported the “kernel” Java Servlet to the new environment; • Ported JSP pages to the new environment. • Heavily involved in installing and administration of the Oracle Internet Application Server. Environment: Oracle JDeveloper, Oracle iAS, Oracle iDS, PL/SQL, Oracle RDBMS 8.1.7, SQL Navigator. Project for corporative ERP system, New Kramatorsk Machine Building Works, Kramatorsk, Ukraine (www.nkmz.com) Role: Sr. Software Developer Sep 2004 – Dec 2004 This is the migration project basically migrate from DBF (Clipper) based system into client/server environment. The existing DBF databases were migrated into Oracle tables. The existing Clipper based application was rewritten using Delphi and stored procedures and functions. This application is the computer-based system of automated generation of customs and shipping documentation. Outgoing forms is generated using Microsoft Word and Excel OLE servers. Responsibilities: • Involved in understanding of Clipper based coding and converting into Delphi code • Heavily involved in Delphi application for to migration from DBF based system. • Developed Delphi application and stored procedures for automated generation of customs and shipping documentation. • Code review, unit testing, debugging and integration testing of the application Environment: Borland Delphi, Oracle Reports, Ms Office, OLE, PL/SQL, Oracle RDBMS 8.1.7, SQL Navigator. Project for corporative ERP system, New Kramatorsk Machine Building Works, Kramatorsk, Ukraine (www.nkmz.com) Role: Sr. Developer Feb 2004 – Aug 2004 This is the web-based project for corporative accounting system. The project is intended for the calculation and distribution of expenditures of auxiliary production`s workshops. The project contains three major subsystems. The first subsystem was developed for importing the information from the legacy information system (dbf). It was developed using Delphi. The second subsystem is web-based. It was developed using Oracle forms and reports servers. The third subsystem is database based. It’s intended for storing information, information exchange and implementing the calculations. Responsibilities: • Involved in architecture design and database design. • Heavily involved in implementation forms and reports using Oracle Developer. • Developed program for importing the information from the legacy information system • Heavily involved in Oracle stored packages, procedures, functions, views and triggers, ensuring set up relations includes indexing, constraints, foreign keys etc. • Heavily involved in performance optimization, functional and integration testing. Environment: Oracle Developer 6i2, Oracle Forms and Reports servers, Borland Delphi, Oracle iAS, PL/SQL, Oracle RDBMS 8.1.7, SQL Navigator. Projects for corporative ERP system, New Kramatorsk Machine Building Works, Kramatorsk, Ukraine (www.nkmz.com) Role: Sr. Developer 2001 - 2003 These projects are the web-based reporting systems. All of them are based on the tables of the corporative information storage (Oracle). Reporting modules work on the corporative application server (Oracle Forms and Reports servers). Reporting modules present analytical information for managers and specialist. Reporting modules include information about commodity output production, personnel, shipment, and incoming monetary funds. The front-end is developed using HTML, JavaScript, Oracle Reports and Graphics. Responsibilities: • Heavily involved in implementation forms, reports and graphics using Oracle Developer; • Heavily involved in performance optimization, functional and integration testing. Environment: Oracle Developer 6i2, Oracle Forms and Reports servers, Borland Delphi, Oracle iAS, PL/SQL, Oracle RDBMS 8.1.7, SQL Navigator. Project for corporative portal, New Kramatorsk Machine Building Works, Kramatorsk, Ukraine (www.nkmz.com) Role: Architect / Developer 2000 This project was started because the Oracle Application Server 4.0.8.2 didn’t have “single sign-in” support and good tools for integration of heterogeneous applications at that time. In fact this project looks like a “lightweight” portal. The kernel of this portal is Java Servlet that works like a HTTP-proxy. This servlet implements “single sign-in” support and security mechanisms. It gets URLs and it checks user access rights. If access is permitted, this servlet convert the source URL into the “real” URL then it calls the “real” web applications, get results and return them to the client’s browser. There are some JSP pages and ActiveX components to run Oracle Forms and client/server applications from the browser without additional authentication. Database layer stores information about users’ rights, aliases and “real” URLs. Stored packages are used to check permissions, display users’ rights driven portal menu and etc. Client/server application (Oracle Developer) is used to manage the portal. Responsibilities: • Developed architecture design, object oriented analysis and design. • Developed the “kernel” Java Servlet • Developed JSP pages and ActiveX component to run Oracle Forms and client/server applications from the browser without additional authentication. • Heavily involved in Oracle stored packages, views and triggers, ensuring set up relations includes indexing, constraints, foreign keys etc. • Involved in client/server application for administering the portal. • Heavily involved in performance optimization, functional and integration testing. Environment: Oracle JDeveloper, Oracle Application Server 4.0.8.2, Oracle Developer 6.0, PL/SQL, Oracle RDBMS 8.1.7, SQL Navigator, Visual Basic. Project for corporative ERP system, New Kramatorsk Machine Building Works, Kramatorsk, Ukraine (www.nkmz.com) Role: Sr. Developer 1999 This was the prototype of corporative human resource module in client/server environment (Oracle). It was necessary to create a data bank with personal information about all workers (more then 20000 at that moment). Information was migrated from legacy systems into RDBMS Oracle using developed ETL software. Then there were developed front-end and back-end software for filling and editing personal data about workers in the human resource department. Responsibilities: • Involved in architecture design and database design. • Heavily involved in implementation forms and reports using Oracle Developer. • Heavily involved in Oracle stored packages, procedures, functions, views and triggers, ensuring set up relations includes indexing, constraints, foreign keys etc. • Heavily involved in performance optimization. Environment: Oracle Developer, PL/SQL, Oracle RDBMS 7.1. Project for New Kramatorsk Machine Building Works, Kramatorsk, Ukraine (www.nkmz.com) Role: Sr. Consultant 1998 – up to now This is the retrain project for “Department of corporative information system” of New Kramatorsk Machine Building Works. At the beginning it was related with changing the development environment from file-server (Clipper, FoxPro) and mainframe (SQL/DS) to client-server (Oracle). I taught programming in PL/SQL and application development in Oracle Developer 6.0, Borland Delphi environment more than 40 specialists. Now this project is resumed periodically for new developers. Permanently I am responsible for checking all new data models to accordance with corporative standards. Responsibilities: • conversion training of the specialists of department to programming in architecture client-server; • consultant duties on application development and programming in PL/SQL and Oracle Developer; • development of the corporative standards of programming and data modelling; • checking all new data models to accordance with corporative standards. Environment: RDBMS Oracle, Oracle Developer, Borland Delphi, SQL, PL/SQL, ErWin. Project for corporative ERP system, New Kramatorsk Machine Building Works, Kramatorsk, Ukraine (www.nkmz.com) Role: Software Developer 1996 – 1997 This is the project for Computer Integrated Manufacturing system of metalware shop. The project included: creation a local network, installation distinguished Netware file server, integration the local network with corporative network, creation the software for all-round automation of planning and management processes in the metalware shop №1 (the most biggest one in the USSR). The software were developed for file-server environment. Responsibilities: • Involved in architecture design and database design. • Heavily involved in implementation. • Heavily involved in performance optimization, functional and integration testing. Environment: RDBMS FoxPro, Nowell Netware, MS/DOS, MS Windows 3.1, 95 Project for corporative ERP system, New Kramatorsk Machine Building Works, Kramatorsk, Ukraine (www.nkmz.com) Role: Software Developer 1994 – 1995 This is the migration project: corporative archives from flat files to mainframe RDBMS SQL/DS platform. I developed programs and OS VM/SP scripts for information transfer of corporative archives from flat files to RDBMS SQL/DS and their support and administration on IBM 9370 mainframe platform. Then I developed software for material flow management for the shop automatic system control, software for collecting and analyzing information about molding quality and energy consumption. Responsibilities: • Involved in architecture design and database design. • Heavily involved in implementation. • Developed programs for importing the information from flat files. Environment: RDBMS IBM SQL/DS, SQL, OS VM/SP, REXX, PL/1, Perl. Projects for Scientific research and designing-technological machine-building institute, Kramatorsk, Ukraine Role: Software Developer 1991 – 1992 All projects were done for based on Intel 8080 processor household PC’s. The household PC’s (not IBM PC compatible) were manufactured by one of the production departments of the institute. I developed the main part of kernel function for a small operation system, command shell, file manager (like a Norton Commander), memory dispatcher of spreadsheet. Responsibilities: • Heavily involved in architecture design, interface design; • Heavily involved in programming. Environment: Assembler for Intel 8080, 8086 and Z80, C Projects for Mechanical Plant, Voronezh, Russia Role: Software Developer 1989 – 1991 All projects are parts of industrial control systems. I developed: • The program for processing the results of hydraulic tests and quality production control; • The program for temperature regulation for heat treatment control. Responsibilities: • Programming. Environment: Fortran IV, Pascal, Assembler for “CM-2M” minicomputer.
добавлено 2006-11-24	показано 432 раз