SKILLS:

Data Warehousing & ETL technologiesExpertCurrently used15years

Microsoft SQL ServerExpertCurrently used13years

Crystal ReportsExpertCurrently used13years

Adobe RoboHelpExpertCurrently used6years

AutoIt Script & SciTEExpertCurrently used7years

Microsoft Visual Basic (VB)IntermediateCurrently used9years

Microsoft Office AutomationExpertCurrently used18years

EXPERIENCE:

Confidential, Richmond, CA

Operations & Technology Analyst

Responsibilities:

• Support, stabilized and expanded upon a vital tool (PETools) that the 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 approximately 300 in-house engineering functions that are packaged in a custom VB DLL - which I also expanded upon and maintain.
• Made these functions very easy to add/use.
• Another part of the add-in interfaces with the data historian (OSI PI & DataLink) to pull the archived data into Excel.
• I 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 results to Excel, very quickly.
• Provided for easy units conversion of data, for accurate & reliable results worldwide without requiring compromise.
• Along with the Excel add-in, I 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, White Sands, NM

Programmer/Analyst

Responsibilities:

• I developed a site-wide Metrics tracking and reporting system for the Confidential White Sands facility, using MS Access. 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 UDF’s (user defined functions) for conversion of Julian dates (ddd/hhh:mm:ss) from for use across applications.

Confidential, Santa Ana,CA

Information Management Scientist

Responsibilities:

• 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.
• I utilized non-proprietary commercially available software throughout, such as Microsoft SQL, Access and Excel, Lotus Notes, and Crystal Reports for the data warehouse and reporting functionality.
• I 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:

• I was contracted with the Information Technology department to build an automated Project Tracking application using Excel with VBA.
• Their original estimate was a month for development.
• I finished the research, development and roll-out in three days.
• They were quite pleased with my work and subsequently the contract to help them complete several other projects.

Confidential, Rio Vista, CA

Programmer

Responsibilities:

• I 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, I 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, I 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 resumes to unique email addresses that were mostly qualified matches.
• I was able to obtain six interviews that were quite productive, receiving three offers. Ninety eight percent of the email responses I received from this were also automatically generated. Even three years after stopping this process, I still get some first time read/deleted receipts.
• I 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.
• I 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.