Jim Peta

Experiences

07/06 – Present TJD Consulting

· MS SQL Server used to develop stored procedure, tables, processes and procedures.

· Developed process for reporting Check 21 administration and balancing. Check 21 is Bank checks being truncated at point of entry.

· Utilized the use of VPN to customer in Detroit, MI. All development is done off site in Atlanta, GA.

TJD Consulting, Atlanta, GA; Tom Daniel

08/05 - 06/06 Assurance America

· Used MS SQL Server 2000 for Data Warehouse using Analysis Service and Reporting Services. Departmental reporting to html reports over intra-net using Reporting Services.

· Developed and maintained store procedures, triggers, tables and data integrity.

· Developed SQL Server nightly backup plans for System Administrator.

· Automated process job flows for daily, nightly and monthly updating and reporting.

· Developed solutions for users from the business requirements that we agreed on.

· Business Requirement Definitions for reporting with accounting for end of month reporting. This department was the biggest user of the Data Warehouse.

Assurance America – Atlanta, GA; Terry Murphy

04/05 – 08/05 Karmalaa Industries

· Create WEB Application using MS FrontPage 2003 and MIVA Shopping Cart. Used VBScript for low level coding.

· The company has a new herbal product that is sold over the internet. It involved working the marketing and sales to determine the presentation of the web pages for the product.

· We sampled some population to view the site to assist in qualifying the “look and feel” of the site and it reception.

Karmalaa Industries – Atlanta GA; Karmalete Webber, President

11/04 – 05/05 Interactive Data

· Performed MS SQL Server 2000 DBA and VB developer responsibilities.

· Created database tables, store procedures and Visual Basic 6.0 programs and DTS processes.

· The company, ID, receives customer data files on daily to be formatted into a proprietary database table layout for a match process. The match process returns information back to their customer in the format that the customer has selected.

· Created DTS packages for different processes to manipulate the data. These processes vary from T-SQL to Visual Basic 6.0 executable code that was in the DTS plan.

· Customized a EXCEL spread sheet with VBA coding to present monthly billing for Accounting.

Interactive Data, Duluth GA - John Schaeffer, President

11/04 - 01/05 MP2 Solutions

· Create WEB Application using MS FrontPage 2003 and MS ACCESS database back-end, complete life-cycle

· Product allowed their customers to search the database of real estate properties over the web. The site maintained user login and control level to each users data

· Specified Plans to convert Data to MS SQL SERVER.

06/04-12/04 Clearwater Cabinet Co

· Developed, implemented and maintained Sales Estimating Application for 10 users

· Application written in MS ACCESS for front-end and back-end database

01/03-07/04 Davis Hammond Direct

· IT consultant and member of Steering committee

· Implemented and tested CRM salesforce.com

· Developed, Implemented and maintained an MS Access Customer Service Application for 20 users containing over 250,000 customers and orders

· Interfaced sales orders from five different sources of web orders, accounting, and shipping for Postal Partner software.

· Used VBA for detail level program control.

· Converted MSACCESS back-end to MSSQL Server with MS Access front-end

06/98-12/02 Atlanta Casualty Company AVP John Gaunder

· Managed a team and provided technical consulting to develop a Web Application for Claims Dept. and a team for a CUBE process

· Used MS SQL Server for Data Warehouse and Decision Support Service (DSS), Visual Studio 6.0 (ASP, IIS) Web Application and Front Page.

· Created and maintained Data Warehouse and Data Model for Data Mining containing 300 gigs of data

· Created Decision Support Services for Product Management in a practical application of CUBE Analysis. Created fact and dimension tables for the bases of the CUBE presentation using SAGENT

· Extractions of data were obtained through the use of stored procedures and Data Transformation Service (DTS) plans and T-SQL.

· Used MS Server SQL 7.0 and later stages used the BETA version of MS Analysis Services

· Tested with the Microsoft MDX, multidimensional expressions, and their solutions for data-analysis.

· Created a WEB Application for their Claims’ department Intranet. Appraisers were able to track claim assignments and performance of appraisers. Application used the following tools: Visual Studio InterDev, VBScript, Internet Information server and SQL Server.

· Implemented and designed Crystal Reports Designer 8.5 and Crystal Enterprise 8 for web based reporting

02/95-05/98 Atlanta Casualty Company AVP John Gaunder

· Used MS SQL Server for Data Warehouse and Decision Support Service (DSS). Used Visual Fox Pro 5.0 and Visual Basic 4.0 to clean department data.

· Created T-SQL, BCP’s, Stored Procedures, View’s and Process Flows to Import Historical data from the Mainframe into Data Warehouse

· Used GUI front-end tools to display information from MS SQL Server

· DBA responsibilities for MS SQL Server with 300gig of Raid 5

· Used Data Modeler tool on FoxPro and MS SQL Server Tables.

08/95 – 05/98 Federal Home Loan Bank of Atlanta

· Major conversion of FoxPro Applications conversion to MS SQL Server and Sybase

· Used Visual Basic 5.0 as Front End to replace all user interfaces for applications.

06/94 – 01/95 The Network

· Six (6) month project using MS ACCESS to process and track Customer callings

08/94 – 01/96 Moore Copies Inc.

· Developed and Implemented Novell LAN, Visual Basic, SQL and FoxPro2.X Windows Order Entry and Tracking System

· Product allowed users to enter orders and track process through product, and controlled inventory

08/95 – 09/96 Envelopes and Forms Inc.

· Developed COBOL Inventory Application

01/92 – 06/94 Guaranty Federal Bank

· Developed SQL and FoxPro DOS Check Item Float and Endpoint Analysis application with interface to their mainframe

10/86 – 4/97 Federal Home Loan Bank

· Used SQL and LAN environments to support multiple applications

· Converted FoxPro2.x to Visual FoxPro 5.0 for Unsecured Credit Department Application

· Developed Bank Member Application to track Authorization Loan Signature

Remote Bank Products for Banks to capture data for Central Processing (data collected by Xcellnet).

04/86 – 11/95 Southern Index Inc.

· Developed COBOL, dBase and FoxPro Order Entry, Billing and Manifest Application

04/83 – 03/86 Unisys Corporation

· V-Series and A-Series COBOL development for GFS (Global Financial System) Bank Application. Online transaction processing and User interaction Processes.

Employment History
1983-Present Eastern Management Inc. Atlanta, GA
Sr. Consultant assisting business concerns, sales targets, and product development. Project management and contract programming using Visual Basic, Visual FoxPro, 2.X FoxPro, Dbase III, Clipper, MS Access, COBOL, Visual Basic, Front Page and MSSQL Server.

1980-1983 Data Copy Inc. Atlanta, GA.
Branch Systems Manager in Houston - Software development and services for client base. Senior Analyst - COBOL programming for corporate national support center.

Education
BA Computer Science, State University of New York at Potsdam
AAS Math Science, Onondaga Community College Syracuse New York

Military

United States Air Force

Skills

Applications