Work Experience

Programming Analyst
Confidential, September 2001 to Present

Database developer

• Administer, maintain, support and enhance applications running on MSSQL databases.
• Developed a SQL Server ASP.NET application that provides offshore data entry to accommodate daily production reports employing SSRS, a monthly allocation system, and historical data as well as cost estimates.
• Provide ad hoc queries for office use, managing users, support for all issues from minor bugs to server issues and adding features and reports to the applications.
• Wrote a process that enables offshore users to sync data via the Dynacap and Procount, allocate daily data and provides a daily production report using ASP.NET, triggers and SQL Server Service Broker (as an asynchronous trigger).
• Responsible for the transition of moving production data from the Access application to the SQL Server application (Procount and Dynacap) by converting the data, building reports using Active Reports, SSRS and T-SQL, developing an ASP.net web application and setting up and maintaining the servers.
• Developed a production data mart that contains pertinent data for users' needs throughout the company in order to enable users to query production data much easier than using the transactional, production database.
• Built automatic notification email alerts (SQL Server Agent Jobs) for producing wells with no well tests in the past 45 days, when completion status changes occur for a completions or a new completion has been added to the production database and distribution of excel spreadsheets containing production sent to accounting once an allocation has been locked (completed) in the production system.
• Integrated the reservoir information database with the production database via ensuring that all keys, lookup tables and well information are identical in both systems. Built a routine to automatically export production data from the production database into the economics database using Openrowset in SQL Server.
• Integrated the accounting database with the production database and created distributed queries for SSRS reports comparing financial and production information for given wells or cost centers.
• Created SSRS reports to enable users to easily access and view AFE information (budget, actuals and accruals) from the accounting system.
• Developed processes to query financial data from the accounting database into an intermediary database in tables or views for users to work with the data via access or powerpivot.
• Developed a database and created Total Compensation Statement using SSRS and SQL Server for human resources to distribute to all employees.
• Field any Access or SQL Server problems and questions throughout the company.

Accounting System Administrator

• Administer, support and data extraction in the Bolo accountingsystem.
• Manage all user accounts and user permissions from within the application. Provide support fortechnical issues such as user logins, database locks and installation issues.
• Provide ad hoc queries via Bolo Connect SQL Server or UniQuery foroffice use.
• Created a SQL odbc interface for the Unidata multi value database which Bolo resides in foruse in Excel, Access and reporting tools.

Drilling Software Administrator

• Administered, supported and extracted data in the Peleton Wellview drillingapplication.
• Managed all user accounts and user permissions on the SQL server database.
• Providedsupport for technical issues such as user logins, installation issues, user access problems from the officeand offshore.
• Developed ad hoc reports in Excel using an ODBC connection to the database.

Technical Support

• Help the technical support group by helping with Windows client and server and Office applicationissues.

Developer

• Build in house applications to facilitate business needs.
• Created a front end for the file server to enable users to upload files remotely, email users to notify them of the file or files and automatic emailnotifications of files upload.
• This application uses Active Directory to ensure proper users are putting filesin the correct place as well as a small SQL Server database to maintain the automatic email notifications.This application was built using C# and ASP.Net.
• Built a C# program to fix large tiff files that werescanned but weren\'t rendering correctly.

Web Developer- Freelance

• Develop websites during free time using php, html, css, jquery, javascript and xml.
• Built a web site toraise money for a nonprofit organization which facilitates monetary transactions.
• Developed awebsite in wordpress using php, mysql and wordpress functions to build template pages.

Database Programmer
Confidential, February 2001 to September 2001

• Developed an Access database to manage course equipment, personnel and scheduling using VBA. Helped withsupport issues.

Support Technician
Confidential, April 1999 to January 2001

• Handled all support for a network of two servers and 20 clients.
• Maintained and developed reports in an Access database which contains a listing of addresses,
• Management information and phone numbers for all locations throughout the country.
• Developed anASP web site to allow users to access the information. Created reports using Crystal Reports.
• Administered and supported the Great Plains Dynamics accounting application.
• Oversaw a project to convert from a Novell Netware network to a Windows network. Prepared clientsby replacing computers and upgrading hardware. Assisted with the server setup and the migration ofdata and applications to the new network.
• Handled all year 2000 bug issues. Ensured that all computers and applications were current. Ensureda disaster recovery plan was in place.

Bachelors in Information Systems and Decision Sciences

Skills

• Administration of SQL 2000, 2003, 2005, 2008, 2008 R2 Servers. Back up and Maintance.
• Development of SQL 2000, 2003, 2005, 2008, 2008 R2 Servers. T-SQL, Stored Procedures, Funtions, Triggers, Office3 Interoperability (Openrowset for Jet 4 and ACE 12), SSRS, SQL Server Agent Jobs, Linked Servers, PowerPivot and the Service Broker.
• ASP, ASP.net, MVC,AJAX, JQuery, .Net framework development in C# and VB.net.
• Silverlight using the MVVM Model.
• Web site development using HTML, CSS, Javascript, Php, JQuery, XML and Mysql.
• Administration of Windows Servers: NT 4.0, 2000, 2003, 2003 R2, 2008 and 2008 R2.
• Development of scripts in Windows Servers to ensure applications are running at all times. Minimize downtime.
• Knowledge of Windows 95,98, 98 SP2, 2000, XP, Vista and 7.
• Administration, Merrick Systems Software, Peleton Wellview management, Bolo Systems management as well as in house applications.
• Knowledgeable in Great Plains Dynamics, and Pervasive SQL.
• Knowledgeable in Redhat, Ubuntu and Corel Linux.