CLIFTON ANDERSON
Houston, Texas
Cell: 832-***-****
Email: acvw6q@r.postjobfree.com
Professional Summary
Oracle Certified Professional/Applications Developer.
Received several merit awards for outstanding customer support.
Demonstrated ability to work in a deadline oriented environment with multiple projects running concurrently.
Technical Skills
Web: Microsoft .net Framework, C#, Java, JavaScript, HTML, XML, TCP/IP
Database: Oracle 8/8i, Microsoft SQL Server 2005, Microsoft SQL Server 2008, Microsoft Office Access 2003, Microsoft Office Access 2007, Microsoft Office Access 2010
Business Intelligence: Microsoft SQL Server SSIS
Operating Systems: Windows, UNIX
Integrated Development Environment: Visual Studio 2012
Code Versioning Tools: Microsoft Visual SourceSafe
Professional Experience
The Settlement Alliance, Houston, Texas
Programmer (Contract) 04/2016 - 04/2016
Produced Microsoft Word - Mail merge closing statement form letters for claimants in class action law suits.
Environment: Microsoft Word (Mail Merge)
Westlake Chemical Corporation, Houston, Texas 12/2015 - 03/2016
Programmer (Contract)
Interfaced with the business content owners to identify, assess, analyze and gather business requirements.
Produced cost estimates for new system enhancements.
Designed, developed, and implemented new system enhancements for the company’s FOCUS application.
Maintained, tested, debugged, monitored and programmed Forms, Reports, queries and stored procedures using VBA code.
Provided end-user support with applications as needed.
Environment: Microsoft Access 2010, VBA
Wood Mackenzie, Houston, Texas 05/2014 - 11/2015
Data Analyst, Upstream Research (Contract)
Performed data mining techniques by collecting, transforming, integrating and migrating oil and gas intelligence from many locations (both internal and external), mainly via on-line methods.
Created and maintained Excel VBA Macro tools and processes to manipulate and analyze data.
Performed Ad hoc DBA for SQL server environment – designing the requisite items to store the data.
Environment: Excel VBA Macros, SQL Server SSIS 2012
Ethyl Chemical Corporation, Houston, Texas 01/2014 - 04/2014
Programmer/Developer (Contract)
Continued contract extension work – Phase II.
Designed, developed and implemented various reports and added new system enhancements for the “Good Catch” and “Employee Recognition” applications.
Wrote Technical and User Guide documentation.
Environment: Microsoft Access 2010, VBA
Hilcorp Energy Corporation, Houston, Texas 06/2013 - 12/2013
ETL Analyst (Contract)
Assisted in the ongoing development of data movement, data quality, data cleansing and other ETL related activities.
Monitored HILCORP’s Case Management queues. Reviewed all queue entries, documented and routed them to the appropriate business analyst for approval via the “ENERTIA CM” tracking system for all HILCORP’s active system patches. Upon approval, executed the required ETL patch scripts against the requested Test database for user acceptance testing. Plus, loaded scripts against the production database after final test approval.
Environment: SQL Server 2008
Ethyl Chemical Corporation, Houston, Texas 01/2013 - 05/2013
Programmer/Developer (Contract)
Designed, developed and implemented two new system applications.
Interfaced with client to gather business requirements.
Maintained, tested, debugged, monitored and programmed Forms, Reports, queries and stored procedures using VBA code.
Provided end-user support with applications as needed.
Environment: Microsoft Access 2010, VBA
ExxonMobil, Houston, Texas 10/2012 - 11/2012
Database Programmer (Contract)
Upgraded multiple databases from MS Access 97 to MS Access 2010.
Designed and developed client requested system enhancements.
Merged archived data into a global risk assessment production database.
Wrote technical documentation to explain database's function.
Environment: Microsoft Access 97, Microsoft Access 2010, VBA
Ryder Scott Company, Houston, Texas 06/2009 - 09/2012
Database Programmer (Contract)
Defined system requirements by consulting system users about the types of information needed from engineering, geologist and accounting departments.
Designed and developed data models and database architecture.
Integrated production and archive databases from MS Access and converted into a SQL Server 2008 database.
Wrote T-SQL stored procedures to massage and cleanse newly converted back-end database.
Wrote MS Access (Front-end) pass-through queries utilizing VBA code to link MS Access to SQL Server stored procedures.
Wrote both VBA MS Access (Front-end) and T-SQL (Back-end) code, based on user defined system enhancement specifications.
Created and maintained Excel VB macros used to automate corporate spreadsheets.
Created, deployed and maintained reservoir reserve data reports using SSRS.
Constructed, installed and tested database systems.
Consulted with others to assess the system performance and made modifications as required.
Modified existing databases, as user needs change.
Built various database reports.
Customized databases for specific needs.
Performed database backups and restores.
Wrote user and technical documentation to explain database's function.
Administered and maintained software version control system.
Trained users and provided technical support.
Environment: Microsoft Access 2003, Microsoft Access 2010, VBA, Microsoft SQL Server 2008
Fluxion Biosciences, Inc., San Francisco, CA 10/2008 - 11/2008
Microsoft Access Database Developer (Contract)
Designed, developed, implemented and maintained experimental test database.
Built table definitions, table relationships, queries, forms/reports, VBA programming code and event triggers for an in-house experimental test data application, utilizing MS Access 2003.
Environment: Microsoft XP Professional, Microsoft Access 2003, VBA
Market Live, Inc., Foster City, CA 08/2007 - 07/2008
Customer Support Technician
Satisfied the customers by driving resolution to technical issues, providing diagnostic procedures and answering informational requests by leveraging and contributing to the collective knowledge of the organization.
Drove corrective actions of escalated customer issues by working closely with cross-functional teams (Technical Support, QA, and Engineering).
Researched and resolved technical issues and provided in depth trouble shooting of complex issues.
Utilized SQL stored procedures to analyze and troubleshoot data related issues, created views and procedures to check data integrity, repaired/cleansed data, procured client work requests and maintained Import/Export batch processing jobs.
Performed bug analysis and related product deficiencies.
Achieved and maintained high levels of customer satisfaction.
Provided telephone, email and CRM portal support to customers responding to a variety of customer requests.
Environment: Windows, UNIX, Oracle, Microsoft SQL Server 2000/2005, Java, JSP, HTML, XML
Community Violence Solutions, San Pablo, CA 10/2006 - 08/2007
Data Manager (Contract)
Managed tasks and projects involving database development and launch of the agency’s service provision and donor databases.
Created donor database design.
Built table definitions, table relationships, queries, forms/reports, VBA programming code and event triggers for in-house community service provision and donor applications, utilizing MS Access 2003.
Worked with users to analyze requirements and implement software solutions, enhancements and interfaces needed to optimize their work processes and procedures.
Created stored procedures to analyzed and correct problems with data and improve system functionality and use.
Wrote and/or assisted administrative users in generating ad hoc reports.
Built conversion utilities to process external data from Import/Export Excel files.
Designed and developed interface systems to exchange donor database information.
Oversaw input of agency’s service statistics for grant reports and donor appeals.
Hired, trained and supervised data entry and help desk activities.
Environment: Microsoft Access 2003, VBA, SQL Server 2005
EDUCATION CERTIFICATIONS
Oracle University, San Jose, CA - 2000
Applications Developers Track
Oracle Certified Professional - 2001
Application Developer
University of California, Santa Cruz, CA - 2004
Certificate program in Internet Programming