SUMMARY

VBA / VB.Net Developer with extensive experience in the design and development of large scale applications and customized applications for manufacturing, industrial, oil and gas clients like Transocean, ExxonMobil, and others.

HIGHLIGHTS

Extensive experience of designing and developing complex application using VB.Net and related technologies for large scale oil and gas clients.

Rewrote the process to copy all the rig information when creating a duplicate rig that had the same specifications using VB.Net at Transocean.

Worked on rewriting the current access application in VB.net using visual studio 2013.

Created VB front-end programs utilizing the crystal report ActiveX control to display data to the screen or print to a report.

PROFESSIONAL EXPERIENCE

VBA / VB.Net Developer Jun 17 – Dec 18

Orion Holdings Inc., Houston, TX

Worked on rewriting the current access application in VB.net using visual studio 2013.

Created new applications that linked to the AS/400 database files to display requested information rather than going thru the current access application.

Created queries to gather needed data to export to excel spreadsheets using SQL 2012.

Created update scripts to add new fields to the current database tables for the requested changes.

Made changes to an existing Access 2016 application that is used for payroll, accounting, HR as well as other reports and functions used by the company.

VB / VB.Net Developer Jul 07- Dec 16

Royal & Ross

Client: Transocean, Houston, TX

Worked on rewriting the VB 6 application in VB.Net using visual studio 2013.

Rewrote the process to copy all the rig information when creating a duplicate rig that had the same specifications using VB.Net. This was to cut down on the amount of data that was needed to be entered.

Wrote a couple of smaller separate applications that did monthly tasks using VB.Net.

Main function was to send emails to selected users.

Made modifications to the planned maintenance system.

Made sure all maintenance schedules are done, and all procedures are followed when working on each piece of equipment.

Research and fix bugs on the current system as well as discover ways to speed up the creation of data for the reports.

Worked on the process where data is collected from readings on a piece of equipment and processed them without any manual entries.

Designed and created tables, queries and stored procedures in the SQL database to be used in the VB application backend.

Created SQl queries that gathered data for references and audit validations.

Designed reports that are called from the VB application to print detail as well as graphs and charts.

Made changes to the current reports to add new fields that were added to the database tables.

VBA Developer May 07 - Jul 07

IS&T

Client: Allied Alloys, Houston, TX

Made changes to existing applications to add new features and fix programming bugs.

Created new forms, queries, and tables for the requested changes to the application.

Converted the access applications to use the SQL tables instead of back end access databases.

Converted the current access tables into the new SQL tables.

Created views and stored procedures to replace the access queries and speed up the application processing time.

VB Developer Nov 06 – May 07

Strategic Careers,

Client: Transocean, Houston, TX

Worked on making changes to the current tool used by the company for their daily business, keeping track of stock available, people on board and other daily events.

Created functions to due specific tasks multiple times, and to also be called by other forms or procedures.

Created new forms to add, update and delete records.

Some forms were created to prompt for more information to filter for a smaller set of data.

Designed multiple stand-alone reports from an Access 2002 database using Crystal Reports 10.

Created VB front-end programs utilizing the Crystal Report reader to display data to the screen or print to a report.

VBA Developer May 06 – Oct 06

Volt Technical Resources

Client: ExxonMobil, Houston, TX

Developed an Access 2003 ADP application which used to keep track of the tasks needed to be done to get a change management process complete.

Application contains several tabs with both single forms as well as datasheet subforms used for maintenance on the tables.

Fixed bugs on existing queries, reports and forms on access 97 applications.

Created the DTS packages that were used to import data into the SQL Server tables from Excel spreadsheets and other access tables.

VBA Developer Jul 04 – May 06

Ajilon Consulting

Client: XEROX, Houston, TX

Created client server applications to add, update, delete and display records from both SQL Server and Access databases.

Made enhancements to existing applications to add new functionality and features requested.

Developed reports, forms, queries, and applications to display and print requested data.

Fixed bugs on existing queries, reports and forms.

Sarbanes-Oxley procedures and protocols.

Created DTS packages to move data from one SQL server to another.

Created DTS packages to create and populate SQL tables, using various sorts of databases (i.e. MS Access, Excel, and Oracle) as well as text files.

Developed Stored Procedures and table Views used in generating reports and invoices in both access reporting and crystal reports.

RPG / VB Developer May 93 – Feb 04

VINSON & ELKINS, Houston, TX

Created VB front-end programs utilizing the crystal report ActiveX control to display data to the screen or print to a report.

Created conversion programs to format data from an old AS/400 system to a Microsoft server windows system.

Designed programs to process and format data from various sources like Federal Express, and other courier delivery companies using ADO and other ActiveX controls.

Created applications to receive vendor electronic accounts payable excel spreadsheets and process them into a billing file format.

Designed, built and implemented multiple systems using SQL 7.0 and 2000 databases.

Managed data transformation services and created stored procedures used for the billing system as well as a client phone allocation system.

Created jobs used for nightly backups as well as a restore for disaster recovery.

Designed multiple stand-alone reports from both SQL Server 2000, and Access 2000 databases using Crystal Reports 8.5 and 9.

Development and maintenance on interactive and batch programs for Lawyer/Client support systems such as records retention, employee benefits, financial services and mailroom package delivery services.

Training

Microsoft .NET Developer Training

Courses: Programming Structure and Development of Applications Using .NET Products.

IBM Technical Programming Class

Courses: Structured Interactive Program Design, Subfiles, Group Jobs and Screen Design.

Technical Expertise

SQL Server

Crystal Reports

Visual Basic 6

VB.Net

MS Access (VBA)

RPG400

Education

Associates Degree, Computer Programming, Southern Technical College, Lafayette, Louisiana. 1998.

Contact this candidate