SKILLS

Programming Languages: ASP.Net, VB.Net, Power Builder, Visual Basic, SQL, VBA, COBOL, COBOL II, PLI, IDEAL, JCL, CICS, Entry Level - C++, Visual C++, C#.

Databases: SQL Server, MS Access, FoxPro, Oracle, DB2.

Tools: Microsoft - Word, Excel, Access.

(Extensive use of Macros, Functions, Modules etc.).:

Photoshop CS4.:

Mainframes - File-Aid, Ager 2000, Object ManagerSuper C/CE, Attachmate, Macro-Editor.:

PROFESSIONAL EXPERIENCE

Confidential, Tulsa

Database Developer/Analyst SQL Server, T - SQL, SSRS, Visual Studio, MS Access, VB.Net, Crystal Reports.

Responsibilities:

• Quickly brought myself up to speed with teh existing Database Structure and teh Tables, Views, Stored
• Procedures and Functions dat were being utilized by teh SSRS Reporting System.
• Created, Modified and Performance-Tuned SSRS Reports & T-SQL Queries and Functions.
• Set up MS Access Application for Manipulation of Data in SQL Server DB.
• Set up VB.Net Application for Manipulation of Data in SQL Server DB & Excel Spreadsheets.

Confidential, Tulsa

Database Developer SQL Server, Oracle, MS Access, VBA, DB2, Terradata

Responsibilities:

• Creation of Numerous Applications for teh creation and automation of daily, weekly and monthly reporting.
• Application Support for Jack Henry & Associates ‘Synergy’ and ‘Kofax’ Banking Software including creation & use of SQL Server 2008 Queries to troubleshot data-related issues .

Access 2010, SQL Server DBA/Query, VBA

Confidential, Enardo, Tulsa

Responsibilities:

• Modifying & adding to MS Access 2007 & 2008 Application.
• An existing business application required additions and modifications including additional Forms and VBA, Additional Tables and Queries & Additional Reports. dis project was VBA intensive.
• Quickly familiarized myself with existing MS Access 2007 Application and created and implemented teh required changes most of which required substantial VBA Coding.
• After initial round of changes were made, teh company switched to MS Access 2008 and from Windows XP to Windows 7. dis required troubleshooting and also some additional functionality changes to application as requested.

Confidential, Tulsa

Programmer / Developer. SQL Server 2008 Stored Procs/Queries, MS Access, VBA.

Responsibilities:

• Modifying & adding to SQL Server 2008 Stored Procedures & Tables, MS Access 2007 Application.
• Teh existing business Time Card Management application required additions and modifications including changes to VB code in Access code-behind modules and creation and modification of SQL Server 2008 Stored Procedures.
• Teh changes required in teh application included changes to VBA code behind some of teh business-critical Employee Time Card Management system Forms and Reports AND extensive changes to teh logic of existing SQL Server Stored Procedures dat were being called from teh Access Forms AND creation of new Stored Procedures to handle additional functionality.

Confidential

Programmer/Developer. VB.Net, SQL Server, Crystal Reports.

Responsibilities:

• Creating and Modifying SQLServer Stored Procedures.
• Creating and Modifying of Reports & Sub Reports using Crystal Reports.
• Modifying VB.Net Code to ensure dat Objects calling teh Crystal Reports and Stored Procedures are directed to teh correct reports & stored procedures depending on User Interaction in teh Application Interface.
• Quickly familiarized myself with existing SQL Server & VB.Net system.
• Taught myself Crystal Reports on teh job to get up to speed with Job Requirements.
• Put in place Crystal Reports dat were immediately useful for Management.
• Became proficient with SQL Server Stored Procedures in order to make required changes and test them to ensure data accuracy.
• Modified existing VB.Net Object Code.

Confidential

Programmer. (SQL Server 2005, FoxPro, PowerBuilder, MS Access).

(ASP.Net, VB.Net, VBA, PowerBuilder, FoxPro).

Responsibilities:

• Developing VB.Net & MS Access Reporting & Tracking Applications dat increased efficiency and productivity.
• Application Support for existing internal & 3rd Party Applications to ensure maximum up time.
• Designed, implemented and maintained a Web-based system Visual FoxPro Databases to provide tracking of Products in various potential bottleneck points in production.
• Designed, implemented and maintained a Web-based system MS Access Database to track precisely when Products had been moved to Shipping even though existing systems did not show them as 'Shipped' coz teh Shipping Department closed at 7:00 PM.
• Designed, implemented and maintained a Web-based system MS Access Database to monitor Products dat were being outsourced and report on Volume and Punctuality.
• Designed, implemented and maintained a Web-based system MS Access Database dat tracked Productivity of Data Entry, Digital Image Editing and other hourly personnel. dis system increased Productivity by placing employees in areas of their strengths, increasing Productivity.
• Designed, implemented and maintained Windows Applications dat reported on Up Time and Productivity of Servers dat uploaded digital images into teh System.
• dis was achieved by parsing output from teh uploading software and presenting it to Management to show teh Productivity of each shift and each sever on each shift.
• Designed, implemented and maintained Windows Applications dat recorded teh contents of all removable drives dat were sent to other facilities for digital processing.
• Was solely responsible for maintaining, updating and ongoing development of Business-Critical Accounting, Billing and Tracking set of applications written in PowerBuilder with a SQLServer 2000 back end.
• Teh application received scanned and typed input on each order entering teh facility using an Order Entry set of Forms, split teh order into its component parts for Tracking, Accounting and Billing purposes and updated teh database with dis information.
• Teh software produced various Labels with Barcoded output at various stages of teh production process for identifying and routing of Job components to various departments and entries to teh Database were made.
• Reports run off teh Database were available either on an automated, daily, weekly or monthly basis – or on demand by Management – depending on user-defined criteria in real-time.

Confidential, TULSA

Consultant Cobol

Responsibilities:

• Provided programmer/analyst services on various Mainframe projects for SPR and it’s clients.
• Analyzed, remediated, tested and documented a cargo tracking system. 6 month project with
• SABRE American Airlines – PLI, SAS, File-Aid, Object-Manager.
• Analyzed, remediated, tested and documented a Payroll & Cargo Shipping System. 6 month project with
• SABRE Canadian Airlines – COBOL, CICS, IMS, DB2, File-Aid, Object- Manager.
• Successfully project-managed Y2K Desktop compliance in teh client-server PC Network. 3 month project with SPR, Tulsa – Viasoft’s OnMark 2000.
• Analyzed, remediated, tested and documented an IDEAL & COBOL On Line and Batch System, Tracking Oil Volume and Cost Projections. 6 month project with Williams Pipeline – IDEAL, DATACOM, Ager-2000.

Confidential

Consultant VB, MS Access Programming

Responsibilities:

• Re-designed a client/server Ticket Audit system which accessed information from an IMS database, downloaded it to MS Access and processed teh information for use.
• Achieved a 65% reduction in processing time by detecting, analyzing and rectifying issues in existing applications and reducing teh error rate.
• TEMPEffected fixes dat ensured update of users’ MS Access database.
• Designed and implemented a process to recover data if it had been overlooked on initial run.
• Designed and implemented programs dat significantly improved interfaces for users.