Jim Peta
(Cell) (404) 395.5735
(678) 482.9587
Objective
Interested in being a part of a Project
Development Team with an organization requiring a proven and versatile set of
skills with technical and project experience.
Background Summary
Have extensive
technical abilities, customer support and management experience with user
departments. Have provided and implemented advance computer based business
solutions. Have ensure policies, procedures and
standards are in place within corporate guidelines.
Have
successfully helped companies’ right-size their computer hardware and application
software for today’s changing times. I have implemented small to large software
application projects from periods of two weeks to thirteen people years of
effort on mainframes, Client Servers, data marts, data warehouse,
MS Office
Products
MS SQL
Server
(Vers. 6.5 – 2005)
MS
Analysis Service
MS DTS
(ETL)
MS VB 6.0
MS VBA
MS
VBScript
MS Visual
Studio
MS
InterDev
MS Fox
PRO
MS ACCESS
MS
FRONTPAGE
Reporting
Services
Crystal
Enterprise
Windows
2003/Pro
Accounting
Payroll
Human
Resources
Auto
Insurance
Claims
processing
Data
Marts
Data
Warehouse
CUBES
Client
Server Apps
Banking
Electronic
Data Interface
Billing
Work Order
Tax
Billing
Customer
Service
Inventory
Mgmt
1983-Present Eastern Management
Inc.
Sr.
Consultant
assisting business concerns, sales targets, and product development. Project
management and contract programming using Visual Basic, Visual FoxPro, 2.X
FoxPro, Dbase
Experiences
03/08 – Present Rent Recovery Solutions
·
Business Development procedure, information collection
and data input procedures.
·
Office
data flow with respect to interface to accounting software
·
On
going support on demand
RRS,
07/06 – Present TJD Consulting
·
MS SQL Server used to develop stored procedure, tables, processes and
procedures.
·
Developed
process for bank 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
TJD
Consulting,
08/05 - 06/06 Assurance
·
Used
MS SQL Server 2000 and 2005 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
04/05 – 08/05 Karmalaa
Industries
·
Create
·
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 –
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,
11/04 - 01/05 MP2 Solutions
·
Create
·
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.
·
Developed,
implemented and maintained Sales Estimating Application for 10 users
·
Application
written in MS ACCESS for front-end
and back-end database
·
IT
consultant and member of Steering committee
·
Implemented and tested
·
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
·
Managed a team and
provided technical consulting to develop a Web Application for Claims Dept. and a team for a
·
Used
MS SQL Server for Data Warehouse and Decision Support Service (
·
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
·
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
·
Tested
with the Microsoft MDX, multidimensional expressions, and their solutions for
data-analysis.
·
Created
a
·
Implemented
and designed
02/95-05/98 Atlanta Casualty Company
·
Used
MS SQL Server for Data Warehouse and Decision Support Service (
·
Created
T-SQL,
·
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
·
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
·
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
·
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.
Education
BA Computer Science,
Military