I'm a technology consultant based in Houston, Texas.
I have lived in three countries and four U.S. states and territories including: United States (Guam, Virginia, Florida, Texas); Indonesia and the United Kingdom.
I have worked in Information Technology and Systems since 1998.
|
Curriculum Vitae
SKILLS
- Programming: VBA and VBScript, T-SQL, I-SQL, .ASP, HTML
- Programming: T-SQL, I-SQL, .ASP, ASP.NET, VBA, VBScript, VB.NET 2008, HTML
- MS SQL Server 7.0/2000/2005 Relational Database Management System
- Oracle 9i/10g Relational Database Management System
- Borland Interbase 6.0 Relational Database Management System
- Windows SharePoint Services 3.0
- MS IIS 5.0 & 6.0
- Windows 95/98/NT/2000/XP/Vista
- MS Office 97/2000/2002/2003/2007 (MS Word, MS Excel, MS Access, MS PowerPoint)
- MS Visio 2000/2005
- Reporting suites/systems: Business Objects, Crystal Reports
- Intergraph SmartPlant Foundation
- Documentum
- PDMC
- VMware ESXi, VM Player, VM Converter
- Primavera Expedition
- Walkinside 3D Modeling
- TechNet Knowledge-Base
- Mindjet MindManager Pro 6.0, 7.0, 8.0
- Camtasia Studio 6.0
WORK HISTORY
03/2006 – Present
Engineering Database Specialist
- Application administrator for SmartPlant Foundation
- Setup VMWare ESXi personal lab environment utilizing VM Converter and VM Player
- Administer Windows 2003 domain with emphasis on group policy and scripting automation
- Developed web based tools for administration of SmartPlant Foundation
- Developed & modified SmartPlant Foundation methods, functions and menus for users (VB.NET, VBScript for .ASP)
- Developed VBA Tools to automate routine work processes
- Developed proof of concept services for integration of SmartPlant Foundation with other applications (such as Maximo and Documentum)
- Deployed development and test environment for SharePoint Services 3.0 (wiki, document management and custom web parts)
- Created custom databases (SQL Server 2005 & MS Access) for Records Management and Document Control groups
- Mapped and documented workflow processes for information management team (MS Visio 2005)
- Responsible for extraction, transformation and loading of project database into Smart Plant Foundation
- Deployed and administered Wiki platform for documenting the administration aspect of SmartPlant Foundation (OpenWiki)
- Analyze and QC project related data
- Modified existing/created new applications and databases for the staging and loading of data
- Participated in the coordination of the delivery of project data (engineering & vendor) from Project (CAPEX) to Operations (OPEX)
- Managed onsite vendor tasks
- Developed user guides and installation guides for distributed software
- Conducted beginner and advanced training sessions for users of SmartPlant Foundation
- Created videos for training and presenting application features for various applications and integrations
- Created procedures for various areas of responsibility
03/2004 – 03/2006
Records/Information Management Lead
- Developed VBA Tools to automate or increase efficiency and assure consistency of work flow
- Coordinated with offsite office for document control and record management
- Mapped Workflow processes for document control and record management
- Tracked and reported on ABS certification status
- Managed team initiatives as they related to record management and data handover requirements
- Created and maintained databases to track compliance to document control and record management initiatives
- Developed solutions to record and information management issues to adhere to data handover requirements
07/2000 – 03/2004
Senior Information Systems Analyst
- System Database Administrator (Borland Interbase 6.0)
- Administrator for various MS Access 2000 database
- Designed and programmed changes to intranet helpdesk site (MS IIS 5.0, .ASP, VBScript)
- Programmed dynamic online reporting for various databases (MS SQL Svr 2000, MS Access 2000)
- Programmed VBScript for .ASP web pages
- Programmed VBA to automate departmental processes in MS Office 2000 Suite
- Administrator for MS SQL Server 2000 test environment
- Administrator MS IIS 5.0 web server test environment
- Designed MS SQL Server 2000 database for 3COM NBX phone data
- Migrated front-office systems
- Responsible for Reporting with T-SQL, I-SQL, Crystal Reports, Business Objects, MS Access 2000 and MS Excel 2000
- Responsible for data flow and quality control
- Responsible for the development of a global consolidated reporting system
- Responsible for change control documentation for various systems
- Responsible for creating and maintaining standard operating procedures for the IT/IS Department
- In charge of all recurring internal/external reporting needs
- Established back office quality control methods
- Responsible for maintaining backup of data on server farm
- Deployed MS SQL Server 2000 on MS Windows 2000 Advanced Server.
01/2000-07/2000
Information Systems Analyst
- Responsible for reporting to internal/external clients using Crystal Reports and MS Excel
- Created MS Excel templates for Quality Control purposes
- Responsible for Quality Control of back office data
- Responsible for analyzing data for Account Management
- Responsible for credit card reconciliation reporting
08/1998-07/2000
Information Systems Support
- Responsible for Reporting, data integrity, data entry/correction, report analysis and miscellaneous projects
CERTIFICATIONS
- Certificate of achievement for Querying Transact – SQL, SQL Server 2000 (official Microsoft curriculum)
- Certificate of completion for Business Objects Administrator
- Certificate of completion for Business Objects Universe Designer
|
|