SKILL:

• Data Warehousing, ETL & Migration
• MS SQL Server (SSIS, SSMS, SSRS)
• MS Access & VBA
• Reporting & Document Management
• SAP/BO Crystal Reports
• Adobe RoboHelp
• MS SharePoint
• AutoIt Script & SciTE
• TFS, Source/Version Control
• MS Visual Basic (VB6 - .net 4.5)
• MS Office Automation
• .Net Framework
• UI & U/X
• HTRI
• OSI PI & SCADA
• Application & Information Security
• SoftwareKey
• HTML, CSS, JavaScript
• Cisco, Network Routing & Switching
• RF (Amateur Radio: WV5N)
• ITIL/ITSM, SDLC
• Project Management, MS Project
• Technical Writing
• Remedy

PROFESSIONAL EXPERIENCE

Confidential, Concord, CA

Business Systems Analyst

Responsibilities:

• Agile environment, committed to delivering working software on time. Incorporated changes as needed to keep the customers happy. Worked closely with stakeholders weekly & daily (as needed) to ensure their satisfaction. Kept up with best practices, and adjusted accordingly.
• Support, stabilized and expanded upon a vital tool, PETools, which Process Engineers use on a daily basis for process monitoring & optimization (PMO), analysis and reporting. This is an Excel add-in, part of which enables, through VBA, approximately 300 custom engineering functions from a VB DLL - which I also expanded upon and maintain. Made these functions very easy to add/use. Another part of the add-in interfaces, using VBA, with the data historian (OSI PI & DataLink) to pull the archived data into Excel.
• Further integrated HTRI with this tool, for industry standard heat exchanger monitoring & optimization efforts. The engineers are now able to press a button once to pass data from multiple heat exchanger units to HTRI, have it process the data, and return the multi-variable calculated results to Excel, very quickly. This works due to VBA automation. Prior to this they would have to: manually enter the half-dozen data points into HTRI; press the run button, wait from 10 seconds to 10 minutes depending on complexity; then hunt down the output variables for which to do their calculations; and finally enter those results manually into Excel.
• An auxiliary tool I built for the above HTRI integration was a VB.net (4.5) command line application. This tool was used to do a dump of all HTRI file values, along with their internal configuration path and parameter names. This was run (leveraging VBA) from, and automatically imported into Excel, for quickly drilling down to find the correct parameter name.
• Provided for easy units-of-measure conversion of data, for accurate & reliable results globally without requiring compromise.
• Along with the Excel add-in, expanded upon and converted a previously incomplete help file to RoboHelp. This is then packaged as a CHM for offline usage in Excel as well as available as a website. Internal and joint venture users enjoy private access to this website. The help system is a knowledge base that has usage, installation & troubleshooting. Function specific help is also available within the built-in Excel function wizard, along with individual parameter descriptions.
• The above is packaged for deployment in a Windows environment, using a custom AutoIt compiled script that I wrote for this. This installation program has built-in security features to make sure that only authorized users can install and use it.
• Ongoing work with wholly-owned refineries and joint ventures worldwide to support and train over 500 users, using RDP for remote troubleshooting as needed. Ongoing work with the process technology masters to continually enhance these tools for improved refinery reliability monitoring.

Confidential

Programmer/Analyst

Responsibilities:

• Developed a site-wide Metrics tracking and reporting system for the NASA White Sands facility, using MS Access & VBA. Project encompassed 8 departments with over 100 reports and growing. Utilized solid design and best technology to quickly create solutions that met immediate needs, yet are flexible enough to grow with business.
• Planned, developed, implemented and administered for the acquisition, storage and retrieval of data for a variety of databases that support the programmatic and administrative functions of this system.
• Collaborated with department managers to determine functionality requirements, resolve data quality issues, and improve the quality of the source data. Analyzed and defined data requirements, specifications and procedures; planned for and anticipated changes in data capacity requirements, and evaluated new technologies and architectures.
• Worked with the Health & Safety department manager on the design and implementation of a database driven web portal for monthly check-up reporting, using VB.net and ASP.net.
• Extracted data from Maximo and Remedy for storage and reporting into custom SQL data warehouse. Built VBA UDF’s (user defined functions) for conversion of Julian dates (ddd/hhh:mm:ss) for use across applications.

Confidential, Santa Ana, CA

Information Management Scientist

Responsibilities:

• DBA and developer for the Navy NEDTS Manifest Management and Compliance Tracking database system. Some highlights of this system include:
• Maintains hazardous waste manifests (including chain-of-custody, one-time requirements, deadlines)
• Manages multiple ID numbers (site name, contact info, status, and dates)
• Provides restricted access for pre-approved users to QC the chemical result data submitted from labs and from the manifest documents through user-friendly data input and web verification forms
• Developed a manifest tracking module to include status of deliverables and rate the labs’ performance
• Ability for the users to make ad-hoc queries
• Utilizes automated functions to include generating and emailing of reports and/or data errors to the chemists
• All regulatory-compliance information for each site was housed in this system (e.g. regulatory agency responsible for review and approval, well-development (graphical overview of the well) & Chain-of-Custody manifest information along with the detailed transactions). It currently has over 1.2 million chemistry results records that were analyzed from over 31,000 samples taken at over 9,700 hazardous waste clean-up sites. Utilized non-proprietary commercially available software throughout, such as MS SQL, Access and Excel, Lotus Notes, and Crystal Reports for the data warehouse and reporting functionality, using VBA to tie them together.
• Provided the technical expertise using information management as a platform for these various science based programs and reporting. In addition, I incorporated extensive storage and reporting improvements while in this role. Implemented database security and built audit controls to monitor and reverse unauthorized data changes (e.g. what changed, with the old and new data stored along with the user login information and time stamp).

Confidential, San Francisco, CA

Programmer

Responsibilities:

• Built an automated Project Tracking application using Excel with VBA. Their original estimate was a month for development. Finished the research, development and roll-out in three days. They were quite pleased with my work and subsequently extended the contract to have me help complete several other projects.

Confidential, Rio Vista, CA

Programmer

Responsibilities:

• Built an automated system to search on four different jobs-search web sites automatically, focusing on certain keywords. After it found a job posting matching those keywords, it saved the page as a text file on my computer. It then searched those files for email addresses and stored them in a SQL database created for the task. Meanwhile it did extensive validation and data scrubbing of the addresses using the Word functionality through VBA. When it finished that task, used Excel to pull the addresses from SQL along with the job site where it found them. It then stored that information in the workbook for temporary usage. After each batch of 1000 addresses was loaded into Excel, pressed a button that opened an Outlook email object through VBA. This function created a somewhat personalized email that also attached my resume as a Word file. After each batch of fifty (a satellite internet service provider limitation) emails was created, it then completed the process by sending them to the recipients and flagging the appropriate address in Excel noting the date and time each was sent. The final step involved a button press to update the data in SQL to match this. This way I wouldn’t send repeat email to the same address - which was needed since I had retrieved over 400,000 job postings, many from the same addresses.
• Over this two month period I sent out 35,000 individually addressed emails, with attached resume, to unique email addresses that were mostly qualified matches. Obtained 6 interviews that were quite productive, receiving three offers. 98% of the email responses received from this were also automatically generated. Even three years after stopping this process I still received some first time read/deleted receipts.
• Intentionally kept each part separate for easier usage and verification: the job posting search and retrieval, the address retrieval using SQL stored procedures and user defined functions to process the text files, the email generation and sending structure, and the address status that was updated after the resumes were sent.

Confidential, Concord, CA

Programmer

Responsibilities:

• Responsibilities included design and implementation of a basic Excel tool for the recruiters to use that automatically searches for resumes on the web and then uploads them into an Access database for usage. Structured the database for simplicity and elegance in the collection and storage of data along with search functions, note taking and cross-referencing.
• Restructured all other computer functions and took on responsibilities for database and system administration.

Confidential

Programmer

Responsibilities:

• Developed sales incentive application for the purpose of calculating bonuses; consequently, month-end posting time went from three hours to one half hour. Designed them to be flexible and to account for daily adjustments of figures by the department staff. Introduced normality & uniformity for the output of information used in payment of monthly bonuses and in the reports. Created an application so that the MTD, QTD, and YTD reports are sent weekly to the agents and management in PDF, Excel and Crystal formats. The analyst subsequently responsible for the reports being sent only has to spend fifteen minutes each week sending them; previously this amounted to a two-day task. Designed and executed the migration of data and business logic from MS Access to MS SQL several months into the project.
• Responsibilities included design of the databases used to warehouse the data used throughout - from agent names and email addresses, to each agent’s incentive plan and monthly bonuses, to individual sales transactions. Developed ad-hoc and production reports using Access for automating Crystal Reports & PDF output; cubes in SQL for analysis; a one-click process of sending report s to the field agents and management. Approximately 30 unique production reports identified, analyzed, developed and put into production.
• Designed and implemented a nightly extract from Sybase to MS SQL which then processes for month-to-date, QTD and YTD fiscal period data for the reports. Several servers, SQL databases, stored procedures & DTS jobs power the process.

Confidential

Programmer

Responsibilities:

• Client needed a tool to validate lab results reported to this department by the scientists. Listened to the client’s requirements and offered recommendations as to how the project could be structured for automated functionality. Helped the client work out an implementation that would be simple, robust and updateable while also utilizing automation for ease of use.
• For the automation, used the Excel built-in functionality whenever possible or built and added my own VBA functions to handle the requirements.
• This Validation Project software was still in use five years later.

Confidential

Programmer

Responsibilities:

• Designed and maintained MS Access databases, created Excel automation spreadsheets and presentations for trend reporting and analysis in the ATM Fraud unit.
• DBA & developer for the following projects:
• Volume tracking designed to track employee productivity throughout the day for approximately 50-60 employees.
• The Trend Reporting data extracts consisted of HNC Falcon report data, bank mainframe ATM reports and Visa CRIS reports, each ranging from 150,000 to 250,000 transactions per month. Transformed this data - using MS Word & VBA - which was already in flat file report format from those legacy reporting systems based in AS400 and DB2, to normalized data for storage in Access. Used FTP to transfer the data and automated using VBA.
• Developed ad-hoc and production reports from all stored data for comparison, along with GUI's for ease-of-use by management.
• Used Office automation throughout these projects.

Confidential

Programmer

Responsibilities:

• Asked to come in under contract to run simple queries downloading information from Visa-View (AS 400 reporting application), that was previously done by hand, Automated it using Extra VBA. First step was to use macros in VBA; the second was to create queries within DB2 for the top 300 banks. Designed and implemented this system to paste and execute automatically and save to dynamically named text files, utilizing Excel and Access. System handled 1,200 name variations for 300 banks -- allowing Visa to report on the top 100 banks with eight different reports for: current year vs. past year, domestic vs. international, credit vs. debit, approved vs. denied. The Visa View system had a query governor which limited the number of records that can be retrieved at one time; my extract implementation was able to work around these limitations.
• Transferred data from DB2 applications to the desktop environment, using VBA for Extra, Excel VBA and Access VBA. Used JCL/SQL batch combination in DB2, FTP from the MVS system to client desktop. Developed ad-hoc and production Access databases and reports, along with GUI’s for ease of use. Management leveraged these for international analysis in printed, PDF and OLAP formats.