SUMMARY:

I have over 20 years of progressive experience in Management, Technical Support, Computer Analysis and Design, Programming and Database design, development and administration. I have extensive knowledge and experience with Microsoft Access, VBA, .Net, and SQL Server. I excel in conversion from one system to another like converting from Microsoft Access to SQL Server, Excel to Access, Crystal Reports to SSRS, Access Reports to Crystal Reports.

EXPERIENCE:

Sr. Developer Manufacturing

Confidential

Senior Analyst/Developer of ERP manufacturing computer systems. Preform analysis and development as well as perform transitional SQL DBA roles. LDC specializes exclusively in turnkey customized complete manufacturing software solutions. The Screen Manufacturing systems and Wire Manufacturing Systems compete with and/or entirely replace SAS and Great Plains. Part of my duties are to strategically plan business decisions, negotiate with customers, budget, and oversee other technical staff in addition to my primary duties of programming in Microsoft Access, VBA, Crystal Reports and VB.Net. As technical analyst and software developer I have designed and coded a Relational DataBase Management System involving all aspects of a manufacturing management system. Form order entry to credit management to terms, rebates and discount to AR to AP with vendor performance benchmarks to costing involving a real time moving average of resources that are both fixed costs as well as highly volatile Comex commodities, to Bill Of Materials to planning what if production scenarios to production scheduling to production monitoring to inventory from production and raw material and outside subassembly inventory to order picking and allocation of inventory to shipping both domestically and foreign to customs documents to route planning to combine LTL shipments to multiple on the way destinations. The manufacturing systems I develop are based upon Microsoft Access, Visual Basic for Applications, and Microsoft SQL Server. Created numerous customizable canned reports for executives using Crystal Reports. Created Dashboards using SSRS, Dashboard Builder for Access, and Excel. Various systems have been developed from standalone systems converted from an existing legacy system to systems interacting with ongoing GP data via SQL Server. I routinely work with outside vendors to implement hardware, cabling, and specialized equipment to make the turnkey system a complete hardware and software solution. I also design specifications for client chosen vendors and pseudo-manage those independent third party vendors.

Confidential

Business Systems Analyst

Contract Business Systems Analyst, Computer Systems Analyst, Programmer, DBA and Network Engineer as needed per each individual contract with periods of inactivity between contracts. Used SSIS to load dissimilar data sources/formats into SQL Server and to migrate legacy databases into SQL Server 2008 using BIDS, Visual Studio and Management Studio. Imported legacy MS Access reports to SSRS/Visual Studio for modification due to data migration. Created Dashboards using SSRS and Acces. Used Microtools AccessToCR to convert Access reports to Crystal Reports. Used Gusiness Inteligence tools BI such as Crystal Reports and SAP. Used Crystal Reports to modify access converted reports and to create new reports using Access and SQL Server data via DAO and ODBC. Used Visual Studio with a mix of MS Access, various ODBC sources, Sybase, Informix and MS SQL Server 2008 SSRS integrated with SharePoint. Created Crystal Reports from Excel data sources. Modifying reports using direct data sources to shared data sources for easy server migration. Report access via ASP.net and output to excel for unique user personal modification. Also conducted training of IT professionals on how to use new system or new IT system features.

Confidential

DBA and Software Engineer

In addition to my project management and team leader duties, I performed numerous technical design and programming tasks. I performed Oracle database administration developed client/server customer database interface application using VB and Access. Created Crystal Reports using Microsoft Access as the back end database. I was the principle Database Analyst who designed the huge multi-year ongoing database project for the DoD called the Occupational Data Base ODB . My project management responsibilities included being the author of numerous proposals, developing a design/solution database and applications/interfaces , budgeting, staffing, overseeing/directing execution, scheduling/planning, performance tuning the databases client and server , and performing technical tasks involving program design and complex coding. I routinely performed designing, coding using MS SQL Server, Oracle, Sybase, MS Access, Visual Basic, C and other databases and languages. I transformed ASM from a 40 person Government contract COBOL, mainframe programming company serving legacy systems to a 100 person company that still serves those lucrative legacy systems but that has also expanded into cutting edge client/server and distributed computing systems. I was responsible for setting up an internal corporate reseller department. This allowed ASM to purchase hardware and software at wholesale prices and skip the middleman reseller. I designed and successfully implemented a plan for certifying ASM as a Microsoft Solution Provider.

Confidential

Supervising Senior Analyst/Software Engineer

I was a hands on project manager for several projects. Some of My projects included a campus Master Events Scheduling system. Confidential is a client/server event scheduling system using MS Access and VB as the clients and Sybase System 10 on Solaris as the server. The system is integrated with cc:Mail to provide individual notification of resource approval. Other client/server based systems included a Financial Management System and an Administrative Management System. These systems involved conversion of many dissimilar autonomous informix based systems to an integrated client/server based system using MS Access /Sybase. I played a major role in project management, database design, data normalization, designing, developing and testing MS Access forms/screens, Macros, Access Basic code, SQL queries, and reports for each of the above projects. Created and modified Crystal reports using SQl Server and Access as the back end databases. I also created database conversion/data preprocessing programs using C . Trained high level military officers many whom had Masters degrees how to use our MIS systems. Before the Software Engineer position I held the Computer support Analyst position where I designed Coleman's first automated Computer Support Department Information System. This help desk system consists of numerous simultaneously open relational client/server databases. I was the resident technical expert for all aspects of the project. I also modified several C DOS networking programs. I was responsible for supervising and performing setup, installation, and customization of hardware and software troubleshooting hardware and software problems and designing and controlling databases with FoxPro 2.x for Windows. Conducted user training on basic Windows and computer operation as wells Microsoft Office Suite Excel, Word, PowerPoint training and proprietary programs training.