Mark Okun's resume

	MARK OKUN
Address:	30500 Fairfax Southfield, MI 48076
Cell:	(248)797-8047
Home:	(248)594-4893
E Mail:	mokun@setupgroup.com

OPERATING
SYSTEMS LANGUAGES DATABASE SOFTWARE

C, C++, JAVA, C# ORACLE Oracle CRM 11i

UNIX PL/SQL SQL Server Oracle Developer 2000

LINUX PERL MS ACCESS Oracle Designer 2000

WINDOWS VISUAL BASIC MySQL Oracle JDeveloper, Oracle Scripting

PALM OS PHP FOXPRO SQL Plus, SQL Loader

WINDOWS CE SQL DBASE WebLogic, IIS, Apache, Tomcat

MS DOS Java Script/HTML MS Office, Visio

SUMMARY: 21 years experience in application systems development. Strong technical and interpersonal skills. Strengths in C, C++, VISUAL BASIC, database development: Oracle, SQL Server, MS Access development for PALM OS, Pocket PC (C, C++) and Web development: (HTML, Java, J2EE, Java Servlets, JSP, EJB, JDBC, Swing, JavaScript, ASP, PHP, Perl). Sun Certified programmer for Java 2. Sun Certified J2EE Web Component Developer. Strong mathematical skills with experience in optimization, simulation and scientific applications.

EXPERIENCE:

10/04-present Ford Motor Co

Application Specialist

Design and develop Factory Information System: ActivPlant, SQL Server, Oracle, T-SQL, PL/SQL, SQL, XML, ASP, SQL, VB and VC++. The application provides run-time and historical data for vehicle operation and power train plants of North America:

Improved performance of many stored procedures and ASP pages.

Design and developed stored procedures for multiple XML reports, web pages, installation utilities.

Developed MS Excel reports using VBA , T-SQL, C#

Designed and implemented highly effective synchronization jobs between ActivPlant and reporting databases.

Developed ActiveX controls using C++.

Worked as technical lead for internal and outsourced projects (Asia-Pacific region).

Participated in installation of FIS for multiple plants (Oakville assembly, Dearborn Truck, Lima Engine Plant and others).

Did run-time support. Fixed many critical problems. Got Ford�s award for this task

Created worked prototype of 12 reports for power train plants for 2 weeks (multiple stored procedures, VBA, Excel). These reports were studied by developer of AcivPlant

Developed database model for power train report system, designed reports and developed stored procedures and supporting ASP pages

Designed and develop off-line reporting database for assembly plants.

Customer Support

Coaching and mentoring offshore developers in Asia-Pacific region

08/03-09/04 Wayne County

Sr. Data Analyst

Design and develop database system for Health Department: SQL Server, T-SQL, SQL, VB, VC++, MS ACCESS and Crystal Report.
Design and develop county internet web site using PHP, MySQL, JavaScript and HTML.
Design and develop county internal web site using J2EE: JSP, Java Servlets, Oracle, JavaScript and HTML.

2/02-present Setup Group

President/Sr. Software Engineer

Design and develop web and client/server applications for clients:

6/2003-8/2003 Developed and Siported Product develoment System for Vertare Corp. Used : J2EE, EJB, Servlets, SilverStream

Training in computer languages: Java, C, C++, VB, PERL, SQL and Web Development HTML, JavaScript, CGI, ASP, Java: J2EE, JDBC, Java Servlets, JSP

Design and develop company's web site using HTML, JavaScript, Dreamweaver , Flash, Java, Java Applets, Java Web Start, JDBC, Swing, PHP, MySQL, PERL, Apache, IIS, Linux/Windows

Design and develop company's software using Java, JDBC, Java Applets, Java Web Start, C++, VC++,eVC, Oracle, MySQL, MS ACCESS, Install Shield, Artificial Intelligence for Windows, Unix/Linux, Windows CE and PALM OS.
For some applications got five stars from five

4/02-4/03 D.P.M Consulting

Sr. Application Developer at BCBSM

11/02- 4/03

Designing and developing client/server and web reporting system for Time and Project Management using Microsoft Project, SQL Server, Oracle 8i, MS Access, VB 6, Crystal Reports 8.5, ASP, HTML, JavaScript, Dreamweaver. Full life-cycle development.

09/02- 04/03

Designing and developing interface form Microsoft Project (SQL Server) to General Ledger (People Soft, Oracle). Full life-cycle development.

10/02-11/02

Evaluated different Time reporting and project management applications as Microsoft Project and NIKU software

4/02-10/03

Designed and developed client/server and web reporting system for Time and Project Management using Project Continuum (CA), Oracle 8i, MS Access, VB 6, Crystal Reports 8.5, BRIO Reporting, JSP, HTML, JavaScript.

5/00-2/02 Oracle Corporation

Senior Principal Consulting

5/00-2/02
Design and developing CRM solution for customers

7/01-2/02

CRM 90
Functional/Technical Consulting in full life-cycle development. Assisted in project management. Created business, functional and technical documentations using Oracle life cycle methodology. Participated in web and reports development, created test cases for unit and system testing.
Used: Oracle 8i, CRM 11i, Oracle Foundation, Oracle Service for communication, Oracle JDeveloper, UML, Java, J2EE, Servlets, JSP, JDBC, JNDI, EJB, XML, BC4J, WinRunner, Oracle Reports, JavaScript, DHTML, HTML, UNIX (HP and Sun), Oracle Application Server, Object-oriented design and programming

6/01-8/01

Telmex
Worked as Functional/Technical Consulting. Created presentations, demo and functional documentations: iStore, Oracle Sale - Mobile, Oracle Services - Mobile, Order Management and Order Capturing.
Used: Oracle 8i, CRM 11i, Oracle JDeveloper, UML, Java, J2EE, Java Servlets, JSP, JDBC, XML, JavaScript, DHTML, HTML, UNIX (Sun), Oracle Application Server, Object-oriented design and programming

9/00-6/01

ADSL for BellSouth
Tech. lead for a team of 12 developers in full life-cycle development. $60,000,000 project. Assisted in project management. Created functional and technical documentation for iStore and Oracle Scripting using Oracle methodology. Directly worked with customers and third parties. Worked on security requirements. Created worked demo, created panels for Oracle Scripting, participate in development, created test cases, participated in unit and system testing. Coaching and mentoring to developers of my and other teams. Worked under tight time constraints with changing requirements.
Used: Oracle 8i, CRM 11i, Oracle iStore, Oracle Scripting, Oracle JDeveloper, UML, Java, J2EE, JDBC, JNDI, EJB, XML, BC4J, PL/SQL, WinRunner, JavaScript, DHTML, HTML, UNIX (Sun), Oracle Application Server, Object-oriented design and programming

5/00-12/00,
11/01,
6/01

Sales online for Humana
Tech. lead for a team of 16 developers. Designed, developed and supported: wrote technical documentation using Oracle methodology, created alerts, design and develop new screens and customized existing screens and reports. Did customer support. Participated on migration from Oracle CRM 3 to CRM 11i. Coaching and mentoring to developers. Worked under tight time constraints with changing requirements.
Used: PL/SQL, HTML, DHTML, JavaScript, Java, J2EE, Java Servlets, JSP, JDBC, Unix Script. Software: Oracle JDeveloper, Oracle Developer, SQL Plus, Macromedia Dreamweaver. CRM 3i, CRM 11i, Oracle sales online. Environment: UNIX HP, Oracle 8i. Oracle Application Server. Object-oriented design and programming.

6/96-5/00 The Bartech Group, 50 West Big Beaver, Suite 100, Troy, MI 48084.

Senior Programmer/Analyst at Ford Motor Company, Transportation group

1/99-5/00

Training other personal in PERL and Web Development

Designed, developed and supported Client/Server and Web applications for Ford Transportation group. Worked alone and as member of team. Directly worked with customers. Wrote functional and technical documentation. Designed data model for Oracle and MS Access database systems. Worked on security requirements. Participated in testing. Created installation procedures. For some projects worked under tight time constraints with changing requirements
Used: HTML, DHTML, FrontPage, JavaScript, VBScript, Java, JDBC, Appletes, Perl, ASP, C++, Unix Script, Oracle Designer 2000, Oracle Developer 2000 (Oracle Report), Oracle Objects for OLE, SQL Loader, VC++, J++, VB 6.0, ActiveX Controls, MS ACCESS, Crystal Report, Oracle 7.x, Apache, IIS, UNIX (HP and Sun), MS WINDOWS, Object-oriented design and programming.

3/99-6/99
Client/Serevr application: Bar Code

1/99-5/00
Web application: Launch Tracking System

4/97-5/00
Web application: Compact

3/96-5/00
Transit analysis reporting system for Web

9/96-5/00

Client/Server database system " Global Transportation Procurement"

6/96-6/97

Client/Server transit analysis reporting system

6/98-5/00 Goal Training, Inc. 17356 W. 12 Mile Rd., Southfield, MI 48076,Instructor

Training students in Visual Basic and Oracle

7/95-6/96
Resource Technologies Corporation, 431 Stephenson Hwy, Troy, MI 49083.

Senior Programmer/Analyst at Chrysler Corporation.

11/95-3/96

Designed and developed Client/Server book of knowledge allowed users to work with documents and images, using MS VISUAL BASIC 3.0, Sybase, MS ACCESS 2.0; MS WINDOWS v3.X.

7/95-6/96

Designed, developed and maintained production reporting system: database - Clipper, user interface � MS VISUAL BASIC 3.0; MS WINDOWS v3.X.

7/95-6/96

Maintained existing xBase (DBASE, Clipper, FoxPro) database applications (payroll systems, database tools and operations and others); MS DOS, MS WINDOWS v3.X. Got recognition of excellence from Chrysler Corporation for this job.

3/94-7/95 Renaissance Systems Technologies Inc., Town Center 3000, Suite 2222. Southfield, MI.

Programmer/Analyst at Ford Motor Land Services Corporation.

6/94-7/95

Designed, developed, implemented new Database Client/Server Systems, using ORACLE 7.0 (CASE -Tools, Forms 4.0/4.5, Report 2.0, PL/SQL), MS VISUAL C++ 1.5, UNIX C, FoxPro 2.5. These systems allowed users to wok with information about Ford's properties, buildings, land, leases, e. t. c.)

3/95-7/95

Maintained database systems: MS ACCESS 2.0 Project Management System and FoxPro 2.5 application provided access users to budget and project information loaded from mainframe systems and allowed to create new budget entries for next year.

3/94-7/95

Worked as database administrator for FoxPro 2.5 database system.

Developed different projects using FoxPro 2.5 and MS ACCESS to different customers.

Environment: Client-Server: UNIX (Sun 5) -based Server, TCP/IP, MS WINDOWS -based Client.

3/94-6/94 Independent Computer Consulting

Helped create database system to company CFI. Environment: MS WINDOWS 3.x, FoxPro 2.5.

6/87-3/93 Agriculture Mechanization Institute, Novosibirsk, Russia.

Programmer/Analyst

Applied modern methodologies of structural analysis to design, development and implementation of business and scientific systems for agricultural industry. Developed software, which include databases, user-friendly interfaces and graphics applications. These software tools have been implemented to:

improve effective utilization of equipment and time;
optimize assignment of agricultural machines to field areas and tasks; (Proposed new optimization method to solve this problem, Wrote article about my solution)
optimize distribution of feeding resource for rural animals and birds.
Software developed on IBM PC (MS DOS), DEC PDP 11 (UNIX) using C, C++, FoxPro, Clipper, FoxBase, BASIC.
Solved financial tasks using LOTUS-1-2-3, EXCEL and other spreadsheets.
Trained other personnel in UNIX, MS DOS and BASIC
Supervised 1-3 programmers.

9/83-5/87 Geological Research Institute, Kiev, Ukraine.

Programmer

Programmed systems for solving geological problems.
Software developed on DEC PDP 11 (UNIX, RSX), IBM 370 (OS) using FORTRAN and C.
Wrote device driver for tape drive.
Software developed on DEC PDP 11 (RSX) using ASSEMBLER.
Wrote user documentation.

TRAINING:

11/01	Oracle Corporation 11i Implement iStore
8/01	Oracle Corporation Object-Oriented Analysis and Design Using the Unified Modeling Language
1/01-3/01	Oracle Corporation Java Enterprise Developer
11/97-1/98	Quality Information System SAP Expert R/3 System Architecture, R/3 Data Dictionary, ABAP/4 Programming BDC session programming, SAP Script FI Module: General Ledger, Account Receivable, Account Payable, Asset Account
6/97	EPCOM Perl
6/95	Oracle Corporation Oracle SQL Forms, SQL Reports.

EDUCATION:

1983-1987 Polytechnic Institute, Pensa, Russia - M. S. in Mathematical Analysis.

1978-1983
Polytechnic Institute, Pensa, Russia - B. S. in Computer Science.

Got the first place in computer science Olympiad for students of Volga region
Got the second place in math Olympiad for students of Russia

REFERENCES: Available upon request.