Project Oracle

Name and Nick Aristov

surname

e-mail *********@*****.***

Cell phone +792********

Position Prior specialist

Education 1999 - 2005 Moscow Institute of Physics and Technology

(State University).

Master of Applied mathematics and physics

Nationality Russian

Languages English - fluently

German - basic

Key skills Supply planning

Data warehousing

Data's Systems integration

Problem solving

Technical Consultant

Professional PL/SQL Upper Intermediate

skills SQL, Advanced

T-SQL, Advanced

Java 2, Intermediate

Oracle 9.2,10.1,10.2 administration, Upper Intermediate

MS-SQL2005

Interbase 6.0/Firebird 1.0/1.5 administration

Turbo Pascal, Advanced

JavaScript, Intermediate

Delphi, Intermediate

BEA WebLogic 8.1

Sun LDAP Server

XML,XSL, HTML, Python

Crystal Reports 8.5/9.0

Fast Reports

SCP 6.1.5 OIL language

AIX 5.3 Administration

Solaris administration

MS Reporting Server

Business Objects XI

Visual Basic for Excel, MS RS 2005

Lotus Notes 8.5

Oracle Apex

SOAP

Installation of different i2's products

(SCP,SRM,DP,DF,DM,TM,TP)

Projects/Works Prior Specialist at Mechel Steel Group, Planning systems

department (Jul2009-Curr Time)

Developing SCP Model for one of the Mechel's site and

including in global model.

Support planning process for one of the Mechel's sites

Creating Bug tracker DB in Lotus Notes

Designing form on APEX

Developing interfaces for loading data (shipments,

manufacturing, orders) from different Mechel's sites to

corporate report system (Oracle DB and BO)

Developing custom export from i2 SCP engine to Oracle DB

Used: Oracle 9.2/10.2, Oracle APEX, PL/SQL, Lotus Notes,

Java, Excel (for parsing files with data in automatic

mode), BO XI, SAP RFC (SOAP)

Senior Technical Consultant, i2 CIS (Nov2005-Jun2009)

Main Projects:

Technical consultant on JTI Demand Planning

project(Dec2007 -Apr2009 )

Development of warehouse for DP

Development of interfaces to load data for DP and working

with them

Integration with Microsoft AD,

Report development on MS Excel & MS Reporting Services

Used: MS SQL-2005, T-SQL, Java, Excel (for reports from

DB and as UI), VBA, i2 DP, batch scripts, Tomcat

Technical consultant on OMK Supply Planning

project(Jun2008)

Installation of Business Objects XI, Reports developing.

Used: Oracle 10.2, i2 SCP, PL/SQL, BO XI

Technical consultant on BAT migrating server

project(Dec2007)

Migration of DP server from win2k to win2003 server

Technical consultant on R-Module Stock (Nov2007)

Installing Oracle DB on Solaris

Localization of Aldata Stock decision

Used: Oracle, Solaris, Java, batch scripts, Gaia, PL/SQL

Technical consultant on Russian Nuclear Ministry project

(Apr2006-Feb2007)

SRM install for Solaris, Windows 2000 (installation of

Award Optimizer, Negotiate, Contract manager, Strategic

Sourcing)

Development of load data procedure to Oracle. (Loading

list of items, Organization to SRM DB, to load deal from

flat file to SRM DB)

Administration of Oracle for Solaris.(Migrating DB from

one instance to another, backup/restore DB)

Development of custom functions using XDAPI

Integration of SRM and Digital signatures

Implementation of additional functionality to SRM.

Localization of SRM

Used: Solaris,Win2k, Oracle 9.2, Java, XML, JS, i2 SRM,

PL/SQL, Weblogic, batch scripts

Technical consultant on "Mechel" Steel Group project

(Nov2005-Apr2006)

Installation of SCP 6.1.2,6.1.5, PM 6.1.5

Development of PM warehouse

Development of PM reports and KPI's

Development of procedure for load data from SCP scheme to

PM warehouse

Development of procedure for load data from custom's data

to SCP schema

Development of algorithm of plant scrap's calculation (to

decrease unitcost of end item)

Development of reports in SCP using OIL

Used: Oracle 9.2, PL/SQL, i2 PM 6.1, i2 SCP 6.1,

Informatica, Weblogic

Severstal Supply Planning support

project.(Nov2008-Jun2009)

Used: PL/SQL, i2 SCP

MMK i2 SCP Pilot project (Mar2009)

Used: i2 PM, PL/SQL, Oracle 9.2/10.2, Excel (for reports

from DB), i2 SCP

Internal projects(Feb2007-Apr2009)

Making reports on Access, MS Reporting

Installing and integrating transportation planning

products (TM, TP)

Post of Russia project

Used: Access, VB, MS SQL, Oracle, Interbase, Java,

Solaris, Win2k, XML.

Activity

Jul.2009. for this time - Mechel Steel Group (Steel

group, www.mechel.com), Senior consultant in Supply

planning department.

Nov.2005 - Jun.2009 - i2 CIS ( Supply consulting

company, www.i2cis.ru), Senior Technical consultant

Oct.2002 -Oct. 2005 - Frigat (Small ERP company

www.frigat.ru), Support & reporting specialist

Contact this candidate