Experience

Semiconductor Research Corporation

• United States
• Research Services
• 1 - 100 Employee

• Information Systems Analyst & SQL Server DBA

  • Sep 1999 - Present

  Assist in development of information management infrastructure to support business operations. Perform SQL Server 2012 database administration tasks and provide database support for website and custom database application. Develop Windows forms-based, C# .NET client/server application. Work closely with users to identify and document business requirements and translate them to information and systems specifications. Targeted manually-intensive data entry and management tasks and designed and developed database solutions using triggers, stored procedures, SQL Server Reporting Services (SSRS) or SQL Server Integration Services (SSIS) to automate them. Designed and developed a database infrastructure to enable easier database troubleshooting. This infrastructure included: triggers to log before/after snapshots, triggers to enforce updating auditing fields and an separate auditing log table that's purged by data instead of timeframe. Implemented database unit testing using RedGate SQL Test and tSQLt framework to test stored procedures, functions, triggers and views. The database unit tests are run by a Cruise Control Continuous Integration (CI) project which identifies problems as new code is checked in to Visual Studio TFS 2012 source control. Show less



Abbott Laboratories

• Laurinburg, NC

• Senior Industrial Engineer

  • Jun 1996 - Aug 1999

  Responsible for designing relational databases, complex mainframe and Access queries, forms and reports used to streamline existing processes, eliminate non-value added activities and justify capital purchases. Responsible for designing relational databases, complex mainframe and Access queries, forms and reports used to streamline existing processes, eliminate non-value added activities and justify capital purchases.



Siebert Engineering

• IL

• Project Manager

  • Feb 1995 - Jun 1996

  Responsible for administering all phases of project work, working directly with clients to define project scope, identify project objectives, develop project schedule and budget, planning, design coordination and project implementation. Responsible for administering all phases of project work, working directly with clients to define project scope, identify project objectives, develop project schedule and budget, planning, design coordination and project implementation.



A. Epstein and Sons International

• Chicago, IL

• Project Engineer

  • Sep 1990 - Feb 1995

  Responsible for designing computer simulations and developing complex client-server databases, queries and reports used to design and optimize manufacturing, warehousing and distribution operations. Responsible for designing computer simulations and developing complex client-server databases, queries and reports used to design and optimize manufacturing, warehousing and distribution operations.