Martin Vera 
52 Grand Meadow Crescent 
Edmonton, AB. T6L-1A2 
Phone: (780) 450-8181 
Cell phone: (780) 710-0861 
E-mail: jmveraa@yahoo.ca 
---------------------------------------------------------------------------------------------------------------------- 
Profile: 
Strong background in AS400 platform as Analyst and RPG Programmer supporting accounting/financial (Enterprise application Infinium for AS400), sales and logistics applications. Knowledge of Gentran and TIVOLI tools for AS400, windows NT/2000 servers and desktops. 
Design and implementation of SQL Server/2000 and DB2 databases. Experience with VB desktop and multi-tier applications. Web applications using PERL, CGI, JavaScript, HTML, DB2, Apache and Linux 
---------------------------------------------------------------------------------------------------------------------- 
Career Objectives: 
To be a member of a dynamic IT team as 
Consultant, Analyst/programmer, programmer, technical support or Database Analyst by utilizing my knowledge, experience and individual strengths. 
---------------------------------------------------------------------------------------------------------------------- 
Technical Experience: 
-Twelve years of experience with AS400 platforms in a Microsoft Windows LAN/WAN environment as Analyst, RPG programmer, administrator, operator and help desk. 
-Advanced knowledge of RPGII, OCL procedures, RPGIII, RPGIV, RPG400, RGP/ILE, CL programming, OS/400 operating system and commands, SQL and Query 400. AS400 tools: DFU, SDA, PDM, RLU, OPNQRYF, DDS specifications for physical and logical files, Sub files, FTP, SNA. 
-Installation and configuration of AS400 related PC software: Client Access/400 for Windows, Rumba, Compleo 400, among others. 
-Eight years of experience using Microsoft Office: Excel, Word, Power Point, Access, as well as Microsoft Project, Microsoft Visio, Front page, Visual Foxpro. 
-Eight years of experience supporting financial and accounting applications into AS400, including: General Ledger, Payables Ledger, Accounts Receivable, Fixed Assets, Financial Application (Enterprise Application Infinium for AS400). 
-Two years as Visual Basic desktop and distributed applications programmer, using MTS, COM/DCOM, Crystal Reports, ADO, ODBC and other features. Projects example: Cycle Inventories, Large scale Emailer. 
-Two years as SQL server 7.0/2000 programmer (T-SQL, store procedures and triggers), designing and implementing large scale databases for web and datawarehouse applications. Project examples: Sales/Statistics data transformation from AS400 to SQL database for datawarehouse applications. 
-Two years of experience supporting logistics applications into AS400: Inventory, Import/Export/Domestic Purchase Orders and Production/Inventory Cost. 
-One Year of experience supporting Sales applications into AS400: Customer Orders and Sales Statistics. 
-One year of experience in EDI projects using GENTRAN Server for AS400 
-One years of experience as on-Site administrator using TIVOLI tools. 
-Working knowledge of IBM Mainframe 3090. JCL and PL/1, Roscoe 
-Experience developing web applications using PERL, CGI, HTML Java Script and DB2 databases. 
---------------------------------------------------------------------------------------------------------------------- 
Work Experience 

2002 Current: 
Position: Software Developer 
Company: The Babelfish Corporation. 
Responsibilities: 
-Designing and implementing DB2 databases. Including Store Procedures and triggers coding. 
-Developing and implementing new functionality for MC-GlobalSuite® workflow web application: Multicurrency, Accounts Payables and Receivables. Using Perl, CGI, JavaScript , HTML, Apache, Linux, and DB2. 
-Running testing cases for each new release of MC-GlobalSuite®. 

1993 2002: 
Position: Analyst/Programmer 
Company: 3M Lima - Peru 
Responsibilities: 
-Maintaining, upgrading and implementing all Financial Area software including General Ledger, Payables Ledger, Fixed Assets, Accounts Receivable, 3M Financial Reports, System Currency Management and local applications, by utilizing RPG400, RPG/ILE, CL programming, SQLRPG programs, SQL400 and OPNQRYF statements. 
-Maintaining, upgrading and implementing Logistic Applications: Costs; Import/Export/Domestic Purchase Orders and Inventories, by utilizing RPGII, OCL and RPG400. 
-Maintaining, upgrading and implementing Sales Applications: Sales Statistics and customer orders, mostly by utilizing RPG400, CL, RPGII and OCL. 
-Administrator of main AS400 in a windows LAN/WAN network environment of 120 users. 
-Member of international team support which includes IT people from USA, Mexico, Colombia, Chile, Brazil and Peru. 
-Implementing and maintaining of 3M Corporation AS400 policies and security guidelines. 
-AS400 server annual Certification processes. 
-Negotiating all AS400 software and hardware service contracts. 
-Maintaining, upgrading and implementing AS400 IBM licensed software and hardware. 
-Designing, writing, implementing and maintaining Visual Basic projects: VB/AS400, VB/Lotus Notes, VB/SQL and VB/Access applications. Examples: delivery of Customer statement via email using Lotus Notes, inter-3Ms company statements and payables, and for financial data queries, cycle inventories among others 
-Downloading and transforming data from AS400 to populate SQL server databases for web and data warehouse applications. 
-On-Site administrator using TIVOLI tools. 

Accomplishments 
-Successfully migration and implementation of the ERP Infinium for AS400 including the modules: 3M Financial, General Ledger, Payable Ledger, Account Receivable and Fixed Asset. 
-3M Corporation Tier 2 AS400 server certification in 2001. 
-ERP Infinium: Development of local fiscal reports and interfaces programs with Foreign Systems. 
-Implementation of IBM TIVOLI infrastructure, including: Software Distribution, Monitoring Control, Remote Control and Hardware and Software Inventory. 
-Development and Implementation of New Account Receivable Local System written completely in RPG400. 
-Installation of Gentran for AS400. Successfully implementation of following EDI documents: Customer order, Customer order status and 3M Price List, as well as integration with 3M On Line Customer Order System. 
-Enroll 3M Peru branch to global IBM Agreement and Microsoft Enterprise Agreement. 


1990 1993: 
Position: Analyst/Programmer 
Company: Deprodeca S.A. Lima - Peru 
Responsibilities: 
-Designing, developing and implementing AS400 applications in RPG400: Delivery, Accounts Payables & Receivables and sales for main site. 
-Designing, developing and implementing applications in DOS Clipper and Foxpro using Dbase files: Delivery, Accounts Payables & Receivables, sales and statistics for branches. 
-Developing communication applications for data exchange between main office and branches by utilizing Clipper and Procom Plus 

Accomplishments 
-Successfully migration and implementation of the new Delivery System. 
-Migration and rewrite Delivery, Accounts Payables & Receivables, sales and statistics applications from Clipper to Foxpro. 


1989: 
Position: Training Internship 
Company: Petroleum of Peru S.A. Lima Peru 
Responsibilities: 
-Maintenance, download and transform data from Mainframe 3090 to Dbase-III database for sales statistic application in Clipper. 
-Maintenance Accounting application programs in Clipper. 
---------------------------------------------------------------------------------------------------------------------- 

Education: 
1991: IBM - Lima - Peru 
AS400 Administration and Control 
RPG 400 
AS400 Relational Databases Design and Codification 
CL/400 
AS400 Facilities: DFU, SEU, RLU 
SQL and Query 
1984 - 1990: Bachelor's Degree in Sciences Major Systems Engineering 
National University of Engineering Lima, Perú 
Complimentary Studies: 
2001: Microsoft windows 2000 Professional and Server 
2001: Microsoft Office 2000 
2001: Lotus Notes 4.7 y 5.0.3, Advanced User 
2000 - 2001: Microsoft Certified Solution Developer track 
Visual Basic 6.0 Desktop and Distributed Applications 
SQL Server 7.0 Design and implementation Database 
Analyzing Requirements and defining solutions. 
2000: IBM - Tivoli International training 
Tivoli systems Management 
Installation and configuration Tivoli Components into an AS400 and NT server 
1999 - 2000: ERP System Infinium for AS400. 
General Ledger, Payables Ledger, Accounts Receivable, Fixed Assets and finance. 
1998: EAN Bar coding 
1998: Gentran for AS400 server 2.0 (EDI support) 

--------------------------------------------------------- 
Languages: English and Spanish. 
--------------------------------------------------------- 
References: Upon request