Engineer Software Sales Project Sql Server .Net
Resume:
Ricardo Eric Galvan *******@************.***
Gijon 101, Col. Bosques de las Cumbres
Monterrey, Nuevo Leon 64345
Mexico
Tel: +528*-****-****
Nationality : Mexican
Languages known : Spanish (100%), English (90%)
Highlights Summary
• Around 7 years of experience in migration of applications written in Visual Basic, C#, ASP.NET, Unisys LINC, XGEN,
COBOL, ALGOL and RPG running on Unisys mainframes, AS/400, Windows and UNIX. Developed software and
methodology to automate the migration process, generating very efficient code based on the source and target platforms.
The result is an application that replicates the same functionality of the original environment.
• 5 plus years of developing Windows and web applications using Visual Basic.NET, C#, ASP.NET, AVR.NET, Java,
Javascript and Ajax.
• 20 plus years in providing programming, development, design, analysis, maintenance and deployment of applications for
various hardware and software platforms, including Unisys mainframes, UNIX and Windows, and design, analysis and
implementation of DMSII, Oracle and SQL Server.
• 15 plus years of experience in the Unisys MCP operating system, system utilities, DMSII database and programming
tools.
• 3 years of working as Unisys employee, providing programming services using LINC and COBOL, training, technical
support and pre sales activities.
• 5 years of working as Unisys contractor in countries like United States, Finland and Spain for financial and manufacturing
lines of business.
• Excellent skills in problem solving, organizational and team building, managing multiple tasks at a time, leading the teams
and the ability to cope with heavy workloads.
• Extremely self motivated with excellent design and analytical abilities; with a strong capability to learn and quick
adaptability to new technologies. Self starter, technically innovative and an excellent team player demonstrating excellent
technical co ordination/team lead.
Software Skills
:
Operating Systems UNISYS MCP, SCO UNIX, HP UX, Windows, MS DOS, OS/400
Visual Basic.NET, C#.NET, ASP.NET, AVR.NET, JAVA, Javascript, Ajax, HTML,
LINC(EAE), XGEN, COBOL74, COBOL85, C, C++, ALGOL, DMALGOL, WFL, JCL,
:
Programming Languages RPGII, III, IV, OCL, Perl
:
Databases ORACLE, MS SQL Server, Unisys DMSII, ACCESS, DB400, DB2
Vault Source Control, Team Foundation, LDA III, LINCLITE, INSYTE, Clearpath and
A Series Utilities, A Series ODT, UNIX Utilities, Assembler for Microcontrollers
:
Other
Academic Information
Bachelor Degree in Electronics and Communications Engineering
Technological Institute and Superior Studies of Monterrey (ITESM), Mexico
Professional Experience
Projects Handled
1. Bluephoenix ASNA – Migration Project(Onsite Assignment)
RW Baird is an employee owned wealth management, capital markets, asset management and private equity firm, dedicated to
providing the best advice and service to the individual, corporate, institutional and municipal clients.
Description: This project mainly focused on converting the AS400 application to the .Net Environment using ASNA tools.
Monarch transforms iSeries applications into AVR.Net application as a large number of gameplans. Datagate is designed to enable
database access to applications with the single, integrated view. The gameplans have been categorized in to batch and interactive
programs.
Environment : AVR.Net, Monarch, Datagate, RPGLE, CLLE, DB2/400, RPG/400, SQL server
2005.
Role : Senior Software Engineer
Client : RW Baird
Duration : January 2009 – July 2009
Responsibilities include:
• Understanding and analyzing the system and requirement specifications.
• Code Analysis in AS400, AVR.NET, ASP.NET, C#, SQL Server.
• Customizing and enhancing the applications as per the client request.
• Developed new interfaces and modules which were not implemented yet in the AVR software.
• Manual handling of unsupported features.
• Worked in the data migration from EBCDIC in the AS/400 to ASCII in Windows.
• Parallel testing with AS/400.
2. Softtek providing outsourcing services to Kaplan University
Environment : Visual Basic.NET, ASP.NET, C++, SQL Server, Team Foundation.
Role : Senior Software Engineer
Client : Kaplan University
Duration : September 2008 – December 2008
Responsibilities include:
• Made new enhancements to the one of the largest web applications used in the University written in Visual
Basic.NET.
• Fixed “Priority One” problems reported by personnel of the University, which had to be fixed and
implemented immediately
• Helped to fix an interface between a module developed by Sofftek and an application developed by a third
party software company for student enrolment. Such problem had around one year.
3. Millennium Technics
Responsibilities include:
• Developed software and methodologies to convert applications written in RPGII, III & IV programming
language to Visual Basic, JAVA or C#, as well as the physical and logical files to ORACLE or SQL Server
databases. The CLs are also converted to Visual Basic, C# or JAVA. The screens can be converted to web
pages including ASP.NET, servlets or HTML, or Windows forms.
• The software developed also helps to upgrade .NET applications from Framework 1.1 to 2.0 or 3.5.
• Developed software and methodologies to convert programming languages, databases and command languages
among various hardware and software platforms. Some examples are from LINC and COBOL to C#, JAVA and
Visual Basic.NET, DMSII to ORACLE and MS SQL Server, and WFLs to PERLs or CLs. The screens can be
converted to web pages including ASP.NET, servlets or HTML, or Windows forms.
• Developed a software and hardware to administrate all the sales transactions in the dispatching equipments of gas
stations. The application is developed in C# and Visual Basic and communicates with the hardware equipment
through the COM1 port. The circuit includes a Motorola microcontroller to automate the process of dispatching.
• Optimized Unisys DMSII databases for different companies. One of the projects was in Banreservas, in Dominican
Republic. The performance of the databases was improved in 42% of their overnight batch process. It usually took 11
hours to run, causing a delay at opening the service in the branches. With this software, we made it run in 6.5 hours.
Other project was in DSW, in Rotterdam, Holand, where the DMSII databases improved their performance in 30% for
their online and batch processes.
Place : Rotterdam, Holand, Santo Domingo, Dominican Republic, Monterrey, Mexico
Environment : Visual Basic.NET, ASP.NET, C++, SQL Server, Unisys DMSII, LINC, COBOL, AS/400 RPG,
CL.
Role : Senior Software Engineer
Duration : January 1997 – September 2008
4. Ford Credit
Responsibilities include:
• Developed part of the new Invoicing Module of the FOCUS system, which is the Integral financial system
of Ford Motor Company, using LINC15.4 on a Unisys A6 and then LINC 16.2 on A16. There were written
several new Ispecs and Reports, as well as some new Global Logics. Gave maintenance to other modules,
including Finance, Dealers, Marketing, etc.
• Helped to move LINC specifications from Mexico (LINC 15 in A6FX) to Australia (LINC 16 in a Unisys A16).
• Developed utilities in ALGOL, COBOL and WFL to automate the overnight process, such as deleting old
files on disk, checking actual populations of the database, etc.
• Wrote a utility in ALGOL to convert the print backup files to data files, as a requirement from the end users to see
and manipulate those files in Excel.
• Provided technical support about LINC, DMSII, COMS, etc. to the development team. I was leading a 5 people team.
• I had the responsibility of providing support of the Overnight process in case of any problem with it. I used an
Internet dialup to connect to Australia to the A16. It took me several months to stabilize it and leave it without any
error or problem.
• I fixed several problems with the Invoicing System, like redundant interest charges to customers, wrong application of
payments, wrong calculation of taxes, etc., which helped to save important amounts of money.
• Developed software utilities to apply currency changes in LINC and COBOL applications to implement them in
several countries. I used the 4GL XGEN in UNIX, as well as COBOL and ALGOL in the A Series mainframe.
• I replaced the former Systems Manager. My responsibilities in this position were to fill the requirements of hardware,
software and services to the end users, as well as services to the customers. My group and me had meetings with
the end users to know all their requirements for the existing and new modules of the financial system. I was in charge
of around 30 people, among analysts, programmers, technical support, systems support for the end users and
support for the customers. I had also to coordinate implementations with the central group in Brazil for the different
countries of Latin America, like Mexico, Venezuela, Brazil and Argentina.
Place : Mexico City, Buenos Aires, Argentina
Environment : Unisys LINC, DMSII, ALGOL, DMINQ
Role : Senior Software Engineer
Client : Ford Credit Mexico, Australia, Venezuela, Brazil & Argentina
Duration : Jan 1997 – April 2000
5. Unisys Corporation USA
Place : Plymouth, Michigan
Environment : RPG/400, CL/400, ILE RPG, ILE CL, DB2/400
Role : Software Engineer
Duration : Jan 1996 – Dec 1996
Responsibilities include:
• Provided maintenance and support to the Installed Products Database (IPD) system, one of the largest
internal applications in transaction processing. The system includes a LINC application, as well as
COBOL and ALGOL programs, along with WFLs, running in a Unisys A19.
• Improved efficiency of the biggest IPD batch process written in LINC by 30%.
• Provided technical support on A Series environment to the teams supporting IPD and SPM (Service Pricing Module)
systems. It included support on LINC, DMSII, COBOL, ALGOL, WFL, etc.
• Coded some LINC reports for the SPM system, dealing with maintenance contracts.
• Migrated IPD and SPM from LINC 15.1 to 15.4, and some months later, from 15.4 to 16.2.
• Provided support to the end users to access the information from the IPD database, using DMINQ and DARGAL.
6. Arkansas State
Place : Little Rock, Arkansas
Environment : Unisys 1100 LINC, XGEN, UNIX, COBOL, IBM mainframes
Role : Software Engineer
Duration : Nov 1995 – Dec 1995
Responsibilities include:
• Conversion project moving the Administration System from a Unisys 1100 maniframe to IBM MVS, involving Unisys
1100 LINC and COBOL to XGEN, and RDBMS database to DB2. The project was completed on time and under
budget.
7. CPI Open Systems for Banco del Atlántico
Place : Mexico City
Environment : Unisys A Series LINC, XGEN, UNIX, DMSII databases, COBOL
Role : Project leader, Software Engineer
Duration : May 1992 – Nov 1994
Responsibilities include:
• Conversion project moving the company's strategic applications from a Unisys A11 maniframe to HP9000 UNIX,
involving Unisys A Series LINC and COBOL to XGEN. The project was completed on time and under budget. The
project helped the bank to get $9 million savings in new Unisys hardware and upgrades.
• Developed and implemented the Integral Atlántico Account System (CAI) using XGEN and DMSII. The development
was performed under SCO UNIX and the generated COBOL was transfered to the Unisys A11 mainframe.
Developed several programs in XGEN and INSYTE for the Retirement Fund System (SAR).
8. CPI Open Systems for Banco Unión
Place : Mexico City
Environment : Unisys A Series LINC, XGEN, UNIX, DMSII databases, COBOL
Role : Project leader, Software Engineer
Duration : Jun 1992 – Jan 1993
Responsibilities include:
• Conversion project moving the Accounting System from a Unisys A6 mainframe to HP9000 UNIX, involving Unisys A
Series LINC to XGEN. The project was completed on time and under budget. The project helped the bank to get
important savings in new Unisys hardware and upgrades.
• Developed and implemented the Home Banking System, which allows to provide the customers with a system running on
Windows to operate several banking transactions from home or the office. This project included the development of a
system using XGEN to run on UNIX HP9000 and the implementation of the communication among this XGEN
application, the LINC SFB System on Unisys A Series and the CPI product XVTI, which allows to integrate a Visual Basic
system on Windows.
9. Codorniú
Place : Barcelona, Spain
Environment : Unisys A Series LINC, DMSII databases, COBOL, ALGOL, Unisys System 80
Role : Software Engineer
Duration : Apr 1991 – Nov 1991
Responsibilities include:
• Developed and implemented the Customers System in LINC for CODORNIU, in Barcelona, Spain generating the LINC
system in A Series to run it on Unisys System 80. At the beginning of this project, CODORNIU was named a Beta Site for
the LINC implementation on System 80.
10. Unisys Spain
Place : Barcelona, Madrid, Spain
Environment : Unisys A Series LINC, DMSII databases, COBOL, Unisys System 80
Role : Software Engineer
Duration : Nov 1989 – Mar 1991
Responsibilities include:
• Developed and implemented LINC systems for TAQSA (Process Control), SPAI (Municipality Administration) and
MOTORSOL (Stock Management), in Barcelona and Tarragona, Spain. Provided technical support and training in A
Series and LINC environments to the Unisys staff and customers, assisting Pre Sales and Sales departments.
11. Unisys Finland for STS Bank
Place : Helsinki, Finland
Environment : Unisys A Series LINC, DMSII databases, COBOL
Role : Software Engineer
Duration : Aug 1989 – Nov 1989
Responsibilities include:
• Provided technical support in LINC14 and A Series, as well as assisting the bank in the evaluation of the OCTAGON
Banking System of Unisys.
12. Banca Promex
Place : Guadalajara, Mexico
Environment : Unisys A Series LINC, DMSII databases, COBOL, ALGOL
Role : Software Engineer, Project Leader
Duration : Mar 1989 – Aug 1989
Responsibilities include:
• Developed and Implemented several LINC applications, including Human Resources System, to run on A Series for
BANCA PROMEX in Guadalajara, Mexico.
13. Unisys Mexico
Place : Monterrey, Guadalajara, Mexico City, Mexico
Environment : Unisys A Series LINC, DMSII databases, COBOL, ALGOL
Role : Software Engineer, Project Leader
Duration : Dec 1985 – Dec 1988
Responsibilities include:
• Provided technical support in A Series and LINC environments, developed LINC systems for Unisys customers, provided
training on A Series and LINC, as well as support to Pre Sales and Sales departments.
• Developed new modules and implemented the Unisys SFB Banking System developed in LINC for BANCA PROMEX in
Guadalajara, Mexico.
• Developed and implemented an interface in ALGOL to communicate several transactions of the LINC SFB System to the
Unisys FT financial terminals for BANCA PROMEX in Guadalajara, Mexico.
• Optimized several banking systems developed in COBOL in Unisys 1100 and moved to Unisys A Series in BANPAIS Bank
in Monterrey, Mexico.
14. Grupo AXA
Place : Monterrey, Mexico
Environment : Unisys A Series COBOL, DMSII databases, COGEN, ALGOL, UNIX
Role : Analyst Programmer
Duration : Jun 1981 – Nov 1985
Responsibilities include:
• Developed a new version of the 4GL COGEN to generate RMCOBOL on Unisys A Series to run it on the CROMIX
Operating System, similar to UNIX in the Cromemco computers in Monterrey, Mexico.
• Developed and implemented several COBOL and COGEN applications on Unisys B6700, B6800, and B6900 mainframes
in Monterrey, Mexico.
Contact this candidate