Jim Williams Email & Phone Number

Utah, United States

Utah, United States

Greater Salt Lake City Area

Kellogg, Iowa

Personal S-Corp used for my contract positions.

Montezuma, Iowa

DBA for 50+ servers with SQL Server 2005/2008/2012 and Oracle 11.Maintained 24x7 environment for Brownells.com. SQL Server 2012 with AlwaysOn High Availabilty.Headed up project converting SQL Server 2008 instances to SQL Server 2012. New environment was in Clusters with AlwaysOn High Availability for 24x7 availability and simplified maintenance.

• Independent self-employed IT Consultant
• Monsanto: Evolutionary Prototyping, gathering requirements, designed, modeled, developed, documented, tested, and implemented a Global Forecasting system that helps monitor and control activity in biotechnology labs in.
• GFT won awards at Monsanto for being the “Impact” application of the year in FY2012. Prior to GFT Monsanto tried to monitor / control plant samples via a Spreadsheet. The GFT system helped monitor forecasting, tissue.
• Created, maintained and configured two Oracle 11 DB environments for development and sandbox testing that utilized Oracle APEX version 4.
• Performed analysis, design, and modeling from logical model to physical model utilizing Oracle Data Modeler which was also used to generate all DDL scripts to create the database environment.
• APEX was used for the external interface which supported data input, reporting, configuration, and maintenance. This layer was kept very thin using custom API Oracle database packages to interface with database.

Led Integration effort from Siebel CRM to Singl.eView billing and accounting system. Designed, developed and tested Fuego 5.5 and Oracle 10g PL/SQL programs. System included reading meta-data tables that allowed dynamic mapping of Siebel CRM provisioned telecom products to Singl.eView billed products and programming that process Siebel XML tasks into.

Teletech: Coded, debugged, documented, and tested custom Oracle Applications 11i HR TALX interface application for Teletech Inc. Teletech: Wrote custom SQL and PL/SQL programs to extract and format data from Oracle Applications 11i.Dex: Helped design, code, document, and test custom internal ticket and error tracking system.

Oracle Developer and DBA working with mortgage financial software solutions.Coded, debugged, documented, and tested custom Oracle Database Security administration system to administer and track security for mortgage loan system.Implemented Oracle Application Server 10g with forms server to utilize Oracle web enabled forms and reports.Coded, debugged.

Idea Integration, Denver, Colorado

Information Technology consultant helping clients develop and implement Oracle related database and software solutions.EoTek: Coded, debugged, documented, and tested custom ETL system that transferred mortgage loan data between 2 mortgage loan systems using SQL and PL/SQL.City of Boulder: Project lead for city Sales Tax Adjustments System.Metro Wastewater.

Montana Department Of Commerce, Helena, Montama

Designed and developed software to process 1960, 1970, 1980 and 1990 censuses for the State of Montana.Designed and developed SAS reports to disseminate this census information.