SUMMARY:

• 31 years of technology experience
• 22 years of experience in data management and application development, deployment and maintenance specializing in relational databases
• Systems administration and networking
• Data migration and integration
• Project management in relation to implementation of commercial and in - house developed software including data migration
• Review and analysis of work flow processes
• Development of training materials using Camtasia Video Editing and PowerPoint and training of end users in commercial and developed software
• SQL Server administration/development, SharePoint administration, Active Directory, Exchange
• Programming experience in Visual Basic, SQL, HTML, FileMaker, MySQL, Java Client / Server
• Also familiar with CSS, PHP, C#, VB.net, Drupal
• Proficient (previously certified) in Microsoft Office products
• Experience with creating and maintaining extensive billing systems, financial /accounting systems, child information systems, authorization systems and tracking systems

WORK HISTORY:

Confidential, Sharon, PA

Data Management Specialist

Responsibilities:

• The person who originally set up the old method was no longer employed there.
• I was asked to come in, find out how the old way worked, clean up the ambiguous, non-standardized and redundant data, develop a new streamlined workflow and automate as much as possible.
• To do this, I was working on getting the data that wasn’t already accessible through GP’s SQL backend into an SQL database where I could add integrity checks and automation.
• I was exploring different options for the front end and looking to expand their use of SharePoint and social media.

Confidential, Exton, PA

Software Developer/Data Manager

Responsibilities:

• Majority of my work was in the installation and development of SQL databases, data integration mainly as a receiver from various other sources but also as a provider and data manipulation / calculations for presentation.
• I started with SQL Server 2008 which was then migrated to 2012.
• Other software that I worked extensively with was Visual Basic, SharePoint, FileMaker, Rediker and MySQL.
• When I arrived none of the systems communicated information automatically and no main database system existed.
• It was my task to evaluate, build and connect the data pieces in a way so that the information could be queried, manipulated, expanded upon, analyzed and reported from in various levels of complexity based on need.
• I accomplished this by working with vendors where needed (Rediker and Moodle) and coworkers who assisted with the networking pieces while I designed, tested and finalized automation processes.
• Automation was set up for both outgoing and incoming data to SQL Server using a number of techniques such as Microsoft Visual Studio (dtsx packages), Powershell, networked server scheduled tasks, SQL server stored procedures run by the job agent FTP and SSH.
• One of my final projects that I was dabbling in during any spare time was a data warehouse build out.
• I used mandated MS Access and VBA code for most of the front-end applications that allowed users to work with the data that resided in the SQL Server.
• I worked in SharePoint 2010 and 2012 developing sites, permissions and some workflows.
• I linked data and reports from the Student SQL Server to SharePoint to create a dashboard of information. In working with SharePoint, I occasionally used HTML, PHP and JavaScript.
• During the last 8 months, I worked heavily in FileMaker as well.
• With the exception of FileMaker, I worked with Active Directory information to set permissions levels for data interactions.

Confidential, Altoona, PA

Software development\database administrator\network administrator

Responsibilities:

• My first job designation was for software development.
• I had worked as an outside contractor with the IU for 9 years doing relational database programming that allowed them to bill their districts and get reimbursed for Medical Access which grew to include several other critical data modules before accepting this full time position.
• After coming on full-time, I reviewed the work flow and data processes implementing several changes, some of which included the creation of data sharing apps.
• The responsibility for converting the business office software from an AS400 system to a purchased Foxpro application soon landed on my desk.
• This included Payroll, Accounting and HR data and functions. I was responsible for working with the vendor, coordination of tasks, defining the schedule within a team atmosphere.
• I also analyzed the data structures of the two systems and coordinated the data manipulation in order to migrate it to the new system.
• During my tenure, I was responsible for the project management of the development and administration of Drupal website that uses MySQL and PHP running on a Linux box.
• I worked with the various departments to assess specific needs and with the designated outside company to get the site up and running.
• While I was the backup network administrator during the first several years, the final two years I was the only network administrator of 5 satellite offices and the main office.
• I was responsible for the maintenance/upgrading of servers and server software, implementation and administration of network security, grant funded initiatives, regional wide area network and local network, email, user creation and access and state mandated compliance.
• I provided services in many areas of computer technology to business and organizations on an as-needed basis.
• The majority of these services were in Access database with heavy SQL and VBA programming.
• I also reviewed data flow procedures, work processes and products and recommend places for improvement.
• In this process, I may research standardized programs and how they may or may not be an asset to the company compared to something that can be done in - house. Services were also provided for PDA’s and other computer related devices.
• In-depth knowledge of numerous software applications, both customized and pre-packaged.
• Training of end users in Microsoft Office products and various site specific software.
• Responsible for networking issues outside of server programming.
• Documentation and maintenance of all technical hardware and software.
• Responsible for setup, documentation and maintenance of communication lines.