Visual Basic Programmer / Developer


[ Philippines Online Resume Listing ] [ FAQ ]

Posted by on October 22, 19102 at 16:31:51:


QUALIFICATIONS SUMMARY:
I have 7 years of I.T. experience. 6 yrs in VB, I am a Microsoft Professional in Visual Basic (MCP), My expertise is in programming Visual Basic 5.0/6.0, MS XML 2.0, DOM, SOAP, COM, DCOM, MTS, COM+, ActiveX, Object Oriented Programming in VB6, VB.Net, and multi-tier environment. I specialize in ADO 3.0, DAO 3.5, RDO 2.0 and ODBC database objects for SQL Server 7/6.5 TSQL, MS Access 2000 And ORACLE 8.i RDBMS, PL/SQL, ORACLE Advance Queue and MS XML 3.0. I have had experiences working on Banking, Financial, Credit Card Applications and Trading systems. I am also had experience working on Web Development, Active Server Pages 3.0 (ASP) and DOCUMENTUM, JAVA SCRIPT, VBSCRIPT, HTML 4.01 and doing systems analysis. I also have working experience programming in Centura Team Developer/ GUPTA.

EXPERIENCE 02/2002 – present

ICOR Brokerage - New York City
Software Engineer

ICOR BackOffice and Customer Relationship Management System
ICOR broker is foreign exchange trading company (FX Options) funded by Reuters. The company uses a fully automated trading system to do a foreign exchange trade. I was involved in maintaining and enhancing the back-end process and the monitoring of trades. I was also responsible for database design and program optimizations, 3 tier architectural design of the whole back office system.

- Create installation systems for the back office software.
- Write test cases and software documentation.
- Write release notes for software revisions.
- Create and modify ORACLE PL/SQL stored procedures, views and triggers.
- Create and modify reports.
- Debug trade transactions.
- Design and develop user interface for the back office software.
- Develop ActiveX and COM components for the back office software.
- Design and stream line batch and build process.
- Formulated and designed coding standards.
- Conversion of COM components to VB.Net

Responsibilities:
Coding in Visual Basic 6.0, create installation programs using InstallShield and WISE for Windows Installer, creation of Merge Modules for the installs, ORACLE Database design, coded PL/SQL stored procedures, ORACLE Advance Queue configuration, HTML coding, design and code COM components GUI design and coding. 24/7 technical support for the London, Sydney and Tokyo offices.

Environments:
VB 6.0, VB.Net, COM, Talarian Smart Sockets 6.2, ORACLE 8.i PL/SQL, ORACLE Advance Queue, InstallShield Developer 7.0, WISE 3.52 Installation for Windows Installer, ORACLE OO400 COM, TOAD, StarTeam 5.0, Farpoint Spread, Crystal Reports 8.0, UNIX, CITRIX

EXPERIENCE 08/2001 – 01/2002

Entology Inc. – New Jersey
Consultant/Software Engineer

Centocor University Project – Malvern, PA
The project is an employee enrollment application. That lets students or employees enroll on courses offered internally within the company. Centocor is a subsidiary of Johnson and Johnson.
There are two aspects of the Application, One is the Administrator side, which lets the registrar enter new course that are going to be offered on specific dates, and the student or user side, which lets the student register for a course.

Responsibilities:
Coding in Visual Basic 6.0, coded HTML, ASP pages, created web pages using DreamWeaver, created JAVASCRIPT codes, Created MTS components, coded TSQL stored procedures. MSSQL Server database design.

Environments:
VB 6.0, Visual Interdev 6.0, JAVASCRIPT, VBSCRIPT, ASP 3.0, IIS 4.0, HTML 4.01, COM+, MTS, DREAMWEAVER, MS Visual SourceSafe 6.0, Farpoint Spread, Visual Interdev

EXPERIENCE 11/2000 – 07/2001

Digital Lighthouse Inc. – New Jersey
Consultant/Software Engineer

Deutsche Bank Tombstone Project – World Trade Center, New York City
Tombstone is a front-end VB application that is launched from MS Word. It lets the user create images of Deutsche bank client’s logos. These logos represent deals made by the banks client and are then published for presentation. The project was implemented using VBA code to manipulate the image in Word, XML, JAVA and Web Logic as back-end web server, SOAP protocol and DOCUMENTUM, so that images are created from any branch from anywhere in the world.

Responsibilities:
Program Design, Program development and coding in Visual Basic 6.0 using COM, DCOM, COM+, Business and Server objects. Program development for the JAVA server side codes. Full life cycle.

- VB technical leader for the project.
- Software Architect.
- Create and modify reports.
- Formulated and designed coding standards.
- Adhere to strict coding standards of the company.
- Involve in user discussions and project planning.
- Directed and mentored 2 VB programmers under my team.
- Program development, coding and testing and debugging in VB 6.0.
- Created and designed COM and ActiveX controls for the project.
- Created the Binary 64 images COM component.
- Implemented Drag and Drop capability for the application.
- Created COM server components accessing DOCUMENTUM on an ORACLE 8.0 database via SOAP method calls.
- Created COM business components accessing COM server and sending them to the GUI ActiveX controls.
- Prepared the technical specifications, GUI and documentation of the application.
- JAVA server side development
- Created MS Word COM wrapper, did Word VBA coding, created MS XML DOM parser COM wrapper, Created a SOAP COM wrapper, Created the HTTP COM wrapper to the SOAP server, did MTS and COM+ coding.
- User Training, Software distribution and deployment.
- Maintained Visual SourceSafe Database.
- Created the Wise 3.11 installation script for the application.

Environments:
VB 6.0, TOAD, XML Spy 3.5, ORACLE 8.i, COM, JAVA, BEA Web Logic, SOAP, VBA, DOCUMENTUM 4i, MS Visual SourceSafe 6.0, ActiveX, MS ACCESS, Crystal Reports, WISE 3.52 for Windows Installer.

EXPERIENCE 5/1999 – 10/2000

Pyramid Consulting Inc. – New Jersey
Consultant/Software Engineer

Eli Lilly & Co. FDA Electronic Submission Project – Indianapolis, Indiana
The system is an electronic document submissions program submitted to the FDA for a new drug approval. Documents from the drug research, reports and journals are stored in ADOBE PDF or Word Format. They are organized into single submission, containing volumes and organized into Table of Contents. A documented submission of a new drug can contain as much as 60,000 pages. The application organizes all these documents into an organized collection of PDF files that has links in it and then submitted to the FDA for drug approval.

Responsibilities:
Design and Program development, coding in Visual Basic 6.0 COM, DCOM, COM+

- Adhere to strict coding standards of the company.
- Involve in user discussions and project planning.
- Program development, coding, testing and debugging in VB 6.0 using OOP.
- Created COM business object components in VB 6.0.
- Created COM server object components in VB 6.0 accessing DOCUMENTUM on an
ORACLE 8.0 Database.
- Development and testing of the import, volumnization of documents and ADOBE PDF renditions modules.
- Prepared the technical specifications, GUI and documentation of the application.
- Designed and coded the classes.
- Created ActiveX controls, business objects, did COM+ and MTS coding in VB 6.0.

Environment:
VB 6.0, DOCUMENTUM, MS Visual SourceSafe 6.0, Sheridan Data Widgets, ADOBE Acrobat COM objects, MS ACCESS, ActiveX, COM, ORACLE 8i, PL/SQL

Executive Perspective Simulation Project – Boston, MA
The system is a supervisor/manager training system that calculates employee relations and efficiency, sales forecast, profits gained, company growth scenarios and investigates problems of the company that needs solution.

Responsibilities:
Program development and coding in Visual Basic 6.0 Program development, coding and testing and debugging in VB 6.0, Created COM components in VB 6.0, Development and testing of the Powerpoint VBA import module. Tested the Installation system and distributed the application.

Environment:
VB 6.0, Lotus Notes 5.0, InstallShield installation system 5.0, Win NT/98 SR 2/95, MS Access 97, Powerpoint 97 VBA, DAO 3.5, Sheridan Data Widgets 3.12, COM, ActiveX, Object Oriented design and classes implementation, Reusable COM components, Visual Source Safe 5.0, MS SQL Server 7.0, TSQL

RND Systems Relocation Project – River Edge, NJ

Responsibilities:
In-charge of program development, interface design and program coding in VB 6.0, Project team leader

Environment:
VB 6.0, WISE installation system 7.0, Crystal Reports 7, ACTIVE X,
Win NT/98 SR 2/95, MS Access 97, DAO 3.5, Sheridan Data Widgets 3.12, COM, ActiveX

RND Systems AREV Transfer Project – River Edge, NJ

Responsibilities:
Design of the process, program design and coding, Database design, program, design, program coding in VB 5.0, program testing, Designed and created the stored procedures in MS SQL Server 7.0

- Designed the user interface, coded the program in VB 6.0.
- Project leader and software architect.
- Prepared the technical specification for the class modules.
- Coded the classes used for the ActiveX code component.
- Created, coded and tested COM (in-process DLL's) programmatically.
- Used the Sheridan Data Widgets 3.12 ActiveX controls (DB Grid, Dropdown and DB Combo) in the interface design.
- Directed a team of two programmers in the development of the system.
- Prepared the technical specifications for the Crystal 7.0 reports.
- Created some of the reports in Crystal 7.0
- Created common procedures and classes that are used by the programmers.
- Created the WISE 7.0 script for the deployment of the program.
- Tested the program's WISE install against different OS like Win NT 4.0, Win 98 SR 2, and Win 95.

Environment:
VB 6/5.0, MS SQL Server 7, TSQL, MS Access 97, DAO 3.5, Sheridan Data Widgets 2.0, Crystal Reports 6.0, Active X, WISE installation system 6.0, Win NT/98 SR 2/95.

Laidlaw Transit Revenue Management System – Seagirt, NJ

Responsibilities:
Systems Design, Coded and normalized the database in Access 97, Designed program flow, Coded the program in Visual Basic 6.0 and used ADO 2.1 as its database access technique, Prepared the technical design of the different program modules, data structures and report formats.

Environment:
Visual Basic 5.0, Access 97, ADO 2.1, Farpoint Spread, FMS Data Source Book, Green Tree Active Toolbox, Crystal Reports

EXPERIENCE 09/1997 – 04/1999

Equitable Card Network VISA and MASTERCARD – City of Makati, Philippines
Visual Basic Programmer / Software Engineer

VISA and MasterCard Collection Monitoring System/ Social Security Remittance Automation

Responsibilities:
Systems Design, Program Coding, Testing and Debugging, Database administration, Project Leader, prepared technical documentation in English.

- Interviewed users for their requirements, made the database design, normalization and coding.
- Installed and configured the computers and the network that is needed to run the application.
- Created users security access and domain definitions for the database server and Windows NT 4.0 servers.
- Prepared the technical design of various program modules, data structures and report formats.
- Coded the program in Visual Basic 6.0/5.0, compiled unit tested, debugged and distributed to the users.
- Coded the classes for the ActiveX EXE and ActiveX DLL.
- Migrated the application to from SQL Server 6.5 to ORACLE 8.0, migrated the Visual Basic code from VB5 RDO to VB6 ADO.
- Installed the new software to the users computers and configured them for customize use.
- Conducted parallel run, evaluated the results, refined the program and processes, and implemented the system.
- Monitored database efficiency and space requirements on a daily basis.
- Performed necessary database configurations.
- Converted SQL Server 6.5 database objects of CMS to ORACLE 8I objects.
- Created stored procedures for use in the CMS program.
- Conducted ISQL queries for data verification and user request.
- Tested the out-process components (DCOM), and COM components.
- Utilized BCP to upload flat file data to the server, created triggers for use in CMS updates, deletions and inserts.
- Regulated user connection problems and errors that occurred on the back-end or server side.
- Prepared the technical documentation and translated the users manual to English.

Environments:
VB 5.0, COM, ORACLE 7.1 PL/SQL, ORACLE Advance Queue, InstallShield, ORACLE OO400 COM, Farpoint Spread, Sheridan Data Widgets, MSSQL Server 6.5, TSQL, RDO, ADO 1.5, Crystal Reports, AIX UNIX

EXPERIENCE 12/1993 – 08/1997

Rizal Commercial Banking Corporation – City of Pasig, Philippines
AS/400 Programmer/ Visual Basic Programmer / Centura GUPTA Programmer/ Systems Analyst

Current Account/ Savings Account Systems, Online conversion system

Responsibilities:
Database Design and coding, program coding, debugging and testing, and system administration. Administered and directed a group of 6 computer operators in the transactions of the CA/SA. On-call 24 hours for emergency maintenance. Directed and assisted in the conversion of branches.

- Maintenance of the application analyzed and planned the conversion application.
- Assessed and planned the remote printing application, front-end and back-end.
- Designed the wiring and cable connections for the terminals on both the Head Office and the branch site, installed and configured the terminals on all branches and configured the communication lines on both ends.
- Designed the database in DB2/400.
- Designed and coded the front-end and back-end remote printing systems in COBOL/400, compiled and debugged the system.
- Designed and coded the conversion system using Clipper 5.2.
- Coded the Data Description Definition (DDS) and ran Query/400 for adhoc reports and testing.
- Formed space requirements and calculations for the 200,000 records for master file and over 4M records for their transaction records.
- Applied program temporary fixes (PTF) to the AS/400, and assisted with IBM engineers in trouble shooting and installing software on the AS/400.

Environments:
VB 3.0, VB 4.0, MSSQL Server, Centura, GUPTA, COBOL/400, OS/400, CLIPPER 5.2, FOXPRO, DB2, QUERY/400, SQL Windows, SQL Base, Crystal Reports







[ Philippines Online Resume Listing ] [ FAQ ]