Resume - Johann Varela Page *

Dear Sir/Madam,

Kindest regards and let me introduce myself.

I am JDEdwards Technical / Business Intelligence Consultant for 15 years, of which I have 9 years working independently. I have total experience of 20 years in the IT area. I have experience with JDEdwards modules: Finance, Distribution, Maintenance, Manufacturing, HR, in more than 20 projects for implementation, migration, adjustments and improvements.

In IT / JDEdwards projects I have participated in Ecuador and customers in Colombia, Venezuela, Peru, Brasil and England as a Lead/consultant and technical support. The Industry areas of customers are: Oil, Pharmaceuticals, Textiles, Comercialization of Products, Ceramics, Wood, Construction, Manufacturing, Floriculture, Brewery, Sugarmill, Cars Factory, Cement, Banking, Consulting, Tourism, Market Research, Insurance, Pollsters, Distributors.

The most of my JDE works contains integration with other external systems and tools such as Excel, MS Project, expanding his functionality. My developments also have integration with peripherals (reading and printing labels with bar codes, information capture) and BI analysis, KPIs generation in all JDE modules.

Within migration projects I have interacted with platforms AIX, Linux, Windows, AS400. I have knowledge of some Business Intelligence and CRM tools. I trust that your company requires a professional with my experience. I hope to hear from you.

Sincerely,

Johann Varela

Resume - Johann Varela Page 2

JOHANN VARELA

Strategy and Operations Consultant with 20 years of experience in IT. JDEdwards ERP, Business Intelligence, CRM, Business Process Reengineering, technical consultancy in IT projects in different areas of the Industry: Oil&Gas, Pharmaceuticals, Textiles, Consumer products, Ceramics, Wood, Construction, Manufacturing, Floriculture, Brewery, Sugar mill, Jointer cars, Cement, Banking, Consulting, Tourism, Market Research, Insurance, Pollsters, Distributors. Personal information

ADDRESS : Quito-Ecuador-South America.

TELEPHONES : +593-*-******* (home); +593-*-******** (mobile) EMAIL : acuzn9@r.postjobfree.com

Studies

Master in Systems Engineering. National Technical University “Kharkov Polytechnic Institute”. Kharkov-Ukraine.

Bachelor’s degree in Systems Engineering. National Technical University “Kharkov Polytechnic Institute”. Kharkov-Ukraine.

Master in University Teaching and Educative Investigation. National university of Loja. Ecuador.

French language. French Alliance of Quito.

German language. Humbolt Association. Quito.

Diplomes

Systems engineer with the degree of " Master of Science" in Engineering. (1994).

Teacher of the Russian Language. (1994).

Graduated from the Master in University Teaching and Educative Investigation.

(2000).

Certification: Technical Consultant of JDEdwards. ORACLE (2007). Languages

Spanish (Native). Russian (Bilingual). French (Advanced). English (Technical). German (Basic).

Resume - Johann Varela Page 3

Competences

Methodology, development and implantation of Systems ERP (JDEdwards versions: One World B7332, B7333, XE, Enterprise One ERP 8.0 – 8.12, 9.0). Development Projects Methodologies (RUP, SCRUM).

Design and evaluation of Projects.

Lean Manufacturing Concepts applied to the office. Business Intelligence. Data Mining. Multidimensional analysis of the information. Development of Statistics Plans. Management of statistical tools. QlikView, SSAS, SSRS, VBA Excel, Access, Lotus Approach.

CRM-Administration and processes improvement, reengineering. Programming Languages (C, Java, JavaScript, REXX, LISP, Expect, Prolog, Visual Basic, Access, Lotus Approach, PL1, VisualAge for Java 3.0-3.5, VisualAge Generator for Java 4.0, WebSphere Studio 4.0, VisualAge for Smalltalk). Data Bases (Universal Database-DB/2, ORACLE - Developer 2000 - Reporter Builder, Accell/IDS, Informix, Lotus Approach, Access, SQL, SQL Server 2008 R2).

Methodologies and tools of Object Oriented Analysis and Design (UML, Rational Rose, Persistence Builder y VisualAge for Java, WebSphere Application Server 2.0/3.0/3.5).

Operating systems (AIX 4.0, SCO UNIX, Windows XP, OS/2 Warp, VMS, MVS). Quality test of SW.

TCP/IP, LAN Server 4.0 for OS/2, Novell Netware.

Tools for electronic design (PCAD, ORCAD, ARTWORK). Courses and Seminaries

Qlik View (Design and Programming). Novatech. October-2010. PHP y MySQL Fundamentals. EPN. May-2009.

Lean Manufacturing (Office). March-2008.

Tools 8,96 of JDEdwards. ORACLE. March-2007.

Certification JDEdwards (development tools). ORACLE. February-2007. JDEdwards CNC. Structured Intelligence. March-2002. Development Tools - JDEdwards. Structured Intelligence. February-2002. Report Writer - JDEdwards. Structured Intelligence. November-2001. MFC Visual Fundamentals using MS C++. CompuEducación. October-2001. Quality Assurance Workshop. IBM Ecuador. September-2000. WebSphere and VisualAge for Java Workshop. Bogota. IBM Colombia. May-2000. Object-oriented programming using VisualAge for Java. IBM Ecuador. April-2000. Skills and employees productivity Workshop (CRM - IBM Ecuador). Lima. IBM Peru. June-1999.

Contracts Management Workshop (CRM – IBM Ecuador). Lima. IBM Peru. May- 1997

Business Opportunity Management Workshop (CRM – IBM Ecuador). Lima. IBM Peru. May-1997.

Resume - Johann Varela Page 4

Customer Satisfaction Workshop (CRM - IBM Ecuador). Caracas. IBM Venezuela. May-1997.

Methodology of computer science in education using Microworlds and LogoWriter, and other tools. IBM Ecuador.

AIX/6000 TCP/IP Networking and Internet. IBM Ecuador. May-1997. AIX/6000 V.4 Advanced System Administration. IBM Ecuador. April-1997. AIX/6000 V.4 Basic System Administration. IBM Ecuador. April-1997. OS/2 LAN Server 4,0 Workshop 2. IBM Ecuador. September-1996. OS/2 LAN Server 4,0 Workshop 1. IBM Ecuador. September -1996. DB/2 Administration for AIX. IBM Ecuador. July-1996. International Seminary of Internetworking. IBM Ecuador. July-1996. Introduction to Integrated Networks. IBM Ecuador. June-1996. SQL Workshop. IBM Ecuador. May-1996.

DB/2 Fundamentals. IBM Ecuador. April-1996.

ACCELL/IDS. February-1995.

Technological information in the industry. In the Institute of Educational Improvement. Járkov-Ukraine.1993.

Maintenance, operation and repair of personal computers. In center Methodical

"Integratsia". Járkov-Ukraine.1993.

Profesional Experience

JDEdwards Senior Technical / Business Intelligence Independent Consultant.

(October 2007 to present). Independent activity of JDEdwards and Business Intelligence consultancy in optimization, upgrades, migration and integration projects and process improvements in:

SIGMAPLAST S.A. (Factory of plastic envelopes). Finantial, Manufacture reports/ BI analysis for making decision of Company Managers with SSAS, SSRS, VBA Excel, Lotus Approach. OLI S.A. (Colombia) (Factory of plastic envelopes). System for Sales, Processes invoices and Control of Sales staff and reports/BI analysis for making decision with VBA Excel, Access, Lotus Approach. ECUADORIAN CONSULATE IN LONDON (England). System of Management for the control, administration and improvement of processes. Reports for Analysis and decision making with VBA Excel, Lotus Approach. DANEC S.A. (Soaps, detergents and oil industry). Finantial and Distribution reports and applications development (Balances, Inventory Control, Sales, Control Providers, Finantial Analysis). Technical support in migration from BAAN to JDE. FARCOMED

(Pharmaceutical industry). Finantial reports development. Technical support. MARATHON SPORTS. (Commercialization of Sport articles). Applications and reports development with JDEdwards (Finantial, Distribution). ACOSA S.A.

(Wood Industry). Electronic Payments. Reports development for Finantial Module. PROPHAR S.A. (Pharmaceutical industry). Applications and reports development with JDEdwards (Finantial, Distribution, Manufacture Modules). BI Analysis with QlikView, VBA Excel, Access, Lotus Approach. METROPOLITAN TOURING

(Tourism). Applications and reports development of the financial module. Balance. Costs Analysis. Profitability Analysis of services and products. Portfolio of clients. Materials Orders. Inventories Analysis. Reports of taxes. Interfaces from JDEdwards with external systems of the company. BI Analysis with VBA Excel, Resume - Johann Varela Page 5

Lotus Approach. ECUDOS (Sugar industry). System of Internal Invoicing. Applications and reports development for the maintenance module at the transport area of the company. GROUP WONG (Manufacture of nutritional products). Applications and reports development for the financial and distribution modules.

Structured Intelligence of Ecuador (October 2001 - September 2007). Company dedicated to the consultancy of JDEdwards.

JDEdwards Senior Technical Consultant in projects of implantation, upgrades, integration and migration in the following clients of Ecuador and Colombia: INTACO (Construction equipments). Imports System. I teached training courses in JDEdwards development tools to the technical staff. Electronic payments. PROPHAR S.A. (Pharmaceutical industry). Imports System. Analysis and development of Payroll System. GRAIMAN (Ceramic Factory). Electronic Payments. Imports System. METROPOLITAN TOURING (Tourisme). Electronic payments. Applications and reports development of the financial module. ACOSA S.A. (Wood Industry). Imports System. Developments for Finantial Module. FLEXIPLAST (Factory of plastic envelopes). Applications and reports development for reading and labels print with Bar code and interaction with the JDEdwards Distribution and Manufacture modules. Imports System. I teached training courses in JDEdwards development tools to the technical staff. FARCOMED (Pharmaceutical industry). Applications and reports development for the Accounting and Finances modules (Balances, Checks, Electronic Payments). I teached training courses in JDEdwards development tools to the technical staff. MALIMA (Plantation of flowers). I teached training courses in JDEdwards development tools to the technical staff. Development of Applications and reports for the module of sales. Invoices. INSTITUTO ECUATORIANO DE SEGURIDAD SOCIAL (State company of social security). Applications and reports development for the Accounting, Finances, Distribution modules. (Control of Inventories, Flow of Box. Budgets, Balance). Interfaces for data migration. I teached training courses in JDEdwards development tools to the technical staff. SUPERMAXI (Company of product commercialization). Interfaces development for data migration between systems. Applications and reports development for the financial module. I teached training courses in JDEdwards development tools to the technical staff. INDURAMA S.A.(Factory and sale of electric appliances). Applications and reports development to connect external systems of Reading of Bar code with the module Distibution module. (Control of Inventories, Offices, Purchase Orders, Delivery, Traceability of sold products). Module of Finances

(Invoices, Balances, Electronic Payments). Reports for the Client services module. I teached training courses in JDEdwards development tools to the technical staff. GROUP WONG (Company of nutritional product elaboration). Technical support of the project. I teached training courses in JDEdwards development tools to the technical staff. CEMENTS OF THE CARIBBEAN (Colombia). (Cement factory). Applications and reports development for the Accounting and Finances modules. MARATHON SPORTS (Commercialization of Sport articles). Applications and reports development to integrate external programs of Reading of Bar code and Impression of Labels with the purchases, Sales and Inventories modules. Electronic payments. Prices System of articles for the sales module. ECUDOS (Sugar industry). Applications and reports development for the Finances, Accounting, Manufacture, Maintenance modules. I teached training courses in JDEdwards development tools to company technical personal. CERVECERIA SURAMERICANA (Factory of beer). Applications and reports development for the Finances and Distribution modules. DELLTEX S.A. (Textile factory). Applications and reports development to integrate external programs for Reading of Bar code Resume - Johann Varela Page 6

and Print of Labels in the purchases, Sales, Inventories and Manufacture modules. Payments Control System. Prices System. Invoices. Interfaces for data load in different modules. Manufacture programming system. Inventories Control. Simulation of Manufacture Costs. Balances. OLEODUCTO DE CRUDOS PESADOS (Company of petroleum transport). Applications and reports development for taxes system. Electronic payments. Invoices. KPI’s system with Exel-JDE. Statistics of Maintenance module for MS Project-JDE. System for revision of scanned documents from JDE. BI Analysis with VBA Excel. ANDES PETROLEUM (Oil company). Applications and reports development for the Accounting module. I teached training courses in JDEdwards development tools to the technical staff. AYMESA (Car Factory). Applications and reports development. Technical support of the project.

Teacher at the Eloy Alfaro University of Manabí – Jipijapa Study Programm

(July/2005- 2009).

Teacher and Computer Science Area Coordinator. Specialty of Exact Sciences of the Faculty of Philosophy of the Central University of Ecuador (96/97 and 97/98).

IBM Ecuador. (May 95 - January 2001).

Call Dispatch Coordinator (Technical calls reception of Clients and distribution of technical attendances). Multidemensional analysis of data and reports generation for Services Area Managers. Technical support of VisualAge Java and WebSphere Application Server. Design, development of Web applications, OOProgramming under operating systems AIX and NT. Technical support of the system to services provide in mobile telephony (MDS/SAS) on the Movistar Project. Macros in Expect to fit the operation of system MDS/SAS. Technical support on the project of the international Corporation of aerial transport (IATA) - Automatization of office staff-financiers processes. Activities: Support in the Database management Informix under the operating system Windows NT. Information analysis of the data base and automatic generation of reports. Development of Administration System. Technical support on the projects with: VisualAge for Java, VisualAge Generator, WebSphere Studio, WebSphere Application Server, under the operating systems Windows NT and AIX. Technical support for the SW Unit of IBM Ecuador. VisualAge for Java, VisualAge Generator and WebSphere Application Server demonstrations to the clients. Teacher in training courses of VisualAge for Java and OOP. Corporation systems Administrator (Technical Skills/Support, Labor, Knoledge). Re-engineering Processes (CRM). System administrator of corporation CRM systems. Opportunity Management Systems, Contracts of businesses, Customer Satisfaction, Products data bases, Employees labor and productivity, under systems MVS and Internet. I organized and teached training courses on the CRM processes tools to end users. Multidemensional analysis of data and reports generation for Managers of the company. Technical-pedagogical support on the educative Project Genesis - Educative technology support and methodologies to schools and colleges with Microworlds and LogoWriter. Technical support on the Project of the ESPOL (University) - Development of applications Office staff- Financier in VisualAge. Activities: DB/2 and VisualAge support under OS/2 and AIX. Technical support on the Project of National Port of Guayaquil (State company of Port operation) - Systematization of processes. Activities: support in the migration of applications. Technical support on the Project of the Mutualista Pichinchat (Bank) - Development of the Financial Administrative System. Activities: Quality control of the software developed on the Project. Technical Resume - Johann Varela Page 7

Support of: OS/2, DB/2, LAN for Server OS/2, Installation of applications under OS/2 Warp, AIX operating systems. Development system installation in REXX.

Cementos Selva Alegre (Lafarge). (Septembre 94 - Abril 95). Development of Payroll System with ORACLE and Accell/IDS, under UNIX SCO. Personal Works

Systems developments for analysis and process improvement. Development of systems for data mining, CRM and Business Intelligence:

System of Management for the control, administration and improvement of processes in Ecuadorian Consulate in London. Reports for Analysis and decision making. Data mining (2014).

System of Management for the control, administration of vehicles maintenance. Analysis and data mining (2007).

System for the control and improvement of the Clients attention in all agencies of Bank in country. Entrances, searches and multidimensional analysis. Department of Quality at the Pichincha Bank. (2006).

Systems for Administration/controls of computer science Audit (2005). System for Administration and Process Control of consulting projects. (Entrances, Control of projects/persons/clients, Knowledge base, Attention to the client). Structured Intelligence. (2003).

System for Administration/control, entrance, searches, validation of the entered information of airlines and travel agencies. Analysis and mining of data. IATA

(International Corporation of Aerial transport). (2000). System for Educative Administration. Analysis and mining of data, for the decision making (1998).

System for the Administration/control of the processes and educative evaluation. Analysis and data mining (1998).

System for handling of libraries. Analysis and data mining (1998). System for the analysis, creation of information cubes, and multidimensional analysis of the CRM processes (Business Oportunity Management, Contracts, Employess Skills/Labor/Productivity, Customer Satisfaction, Products Management). IBM Ecuador (1997).

Systems for investigation in the medical area (several specializations). Analysis and information cubes development (1996).

Contact this candidate