Post Job Free

Resume

Sign in

Sql Server Project

Location:
Nashville, TN, 37221
Posted:
September 18, 2010

Contact this candidate

Resume:

Charles R. Beard

P. O. Box ******

Nashville, TN 37221

615-***-****

abk0b4@r.postjobfree.com

SUMMARY

Information System Specialist focusing on support of business functions

including accounting, payroll, manufacturing and logistics. Worked in mid-

to large-sized companies in various industries such as insurance, financial

institutions, manufacturing and distribution. Optimized and analyzed

existing systems, interfaced disparate systems and ported legacy systems.

Have solid reputation for meeting deadlines and working with and leading

teams to successful project completion.

PROFESSIONAL EXPERIENCE

Murtech Consulting, Nashville, Tennessee August 2010 to Present

Contract Developer

Data conversion, through code, of financial institutional clients' data,

delivered via FTP, to system format for processing, and of system-formatted

data to client-specific formats for delivery of acknowledgement files and

reports. Many hundreds of files processed daily in production. Coded as

needed for new files and for modifications to client needs. Performed

testing of changes and properly documented results for Business Analyst

approval.

Self-Employed d.b.a. beard consulting, Nashville, Tennessee June 2009 to

Present

Information Technology Consultant

Data conversion, code conversion, test case generation, unit testing and

user acceptance testing for major national corporation, to assist in

conversion of existing systems to AccuCOBOL by third-party company.

Support major project to aid corporation's financial institutional clients

meet Regulation E deadlines for customer notification and opt-in. Enhance

major statement system to improve throughput performance in creating PDFs

for clients.

Accomplishments

. Improved test case creation process.

. Organized reporting of project goals and milestones.

. Optimized conversion program creation for Reg E project

State Volunteer Mutual Insurance Company, Brentwood, TN 2003 to 2009

Programmer Analyst

Developed and maintained customized programs for interface with all

Accounting, Underwriting and Claims systems.

Accomplishments

. Saved 12 machine-hours per month-end processing period and ensured

greater data integrity by consolidating and optimizing many processes.

. Created and updated reports going to outside underwriting and state

regulatory authority.

. As part of team, ported custom system from HP COBOL II and Cognos

Powerhouse on HP platform to a VB and SQL Server on NT platform for

business continuity.

. Sole programming support for systems on HP 3000 during final twelve

months of transition

Ingram Barge Company, Nashville, TN 2000 to 2003

Financial Applications Systems Analyst Programmer - Lead

Created and maintained customized programs for interface of Accounting,

Payroll and Claims. Supported HP applications, MS Access 97 offshoot

databases, and supported AS/400 users for sister division.

Accomplishments

. Saved six man-hours per pay period and 20 additional man-hours per month

and ensured greater data integrity by streamlining many payroll

processes.

. Modified system to allow for rules governing union-represented

associates.

. Attained quicker divisional payroll interfaces to PeopleSoft payroll

system by porting custom interfaces from Cognos Powerhouse to VB, PL/SQL,

Oracle 8i on NT.

. Created and maintained processes for reports to outside authorities for

check processing and outside agencies, including IRS, for compliance.

Rohm Electronics, USA, LLC, Antioch, TN 1997 to 2000

Programmer Analyst

Wrote and maintained programs for all major in-house systems and

customization of third-party financial and logistics package and EDI

conversion of data in that package. Utilized Microsoft platform to create

business-based solutions.

Accomplishments

. Reduced administration costs by creating an electronic forms system,

allowing universal access, centralized administration, and workflow

routing.

. Reduced costs and increased timely input of branch office payroll by

creating an electronic timesheet application utilizing VB Script, MS

Access and MS Outlook/Exchange.

Ingram Barge Company, Nashville, TN 1996 to 1997

Programmer Analyst

Wrote and maintained programs for all major in-house systems and

customization of Collier-Jackson package to suit current business needs.

Accomplishments

. Supported Accounting departments

. Converted multiple Cognos dictionaries on different versions into one

better documented dictionary in latest version for Y2K project. Supported

users on HP.

ADDITIONAL PROFESSIONAL EXPERIENCE

Lockheed Martin Ordnance Systems, Milan, TN 1995 to 1996

Data Processing Systems Specialist

American Home Shield, Memphis, TN 1994 to 1995

Programmer Analyst

Dalton Industries, Lexington, TN 1993 to 1994

Information Systems Manager

Wang's International, Incorporated, Memphis, TN 1991 to 1993

Business Applications Programmer

EDUCATION

Union University, Jackson, Tennessee

Bachelor of Science, Mathematics (Minor in Computer Science)

technical training

Microsoft: Visual Basic, Visual Studio, MS SQL Server Administration and

Database Setup

Miscellani: Crystal Reports 10

Oracle: SQL and PL/SQL, Oracle Backup and Recovery Workshop, Complex

Modeling and Relational Database Design

AS/400: RPG/IV Programming. Basic Operations, Advanced Programming in RPG

400, SQL Database Design (DB2), Command Language

hardware and software

Windows

. Visual Basic

. Microsoft Office (Excel, Access, Word)

. Oracle, PL/SQL

. Crystal Reports 8 - 10

. SQL Server 7 - 2005

Mini-Computer

. Hewlett-Packard 3000 MPE/ix, HP Turbo Image, Image/SQL, COBOL II

. Hewlett-Packard 3000 internal utilities for files and system management

(KSAMUtil, DBUtil, DBSchema, NMManager, etc.) and third-party utilities

for databases, files and indices (e.g., DBAdager, VESoft, Minisoft ODBC,

ManMan, Spoolmate, Omnidex, etc.)

. Cognos Powerhouse BI/Reporting tools through v. 7.29

. Financial and Logistics Packages from SATCom, Collier-Jackson (aka GEAC)

including Payroll release 3.02 and Multi-View (using Oracle)

. AS/400



Contact this candidate