
Software Engineer at Thermo Fisher Scientific
Greater Pittsburgh Area

Software Engineer at Thermo Fisher Scientific
Greater Pittsburgh Area
Application Developer, Database Administrator, and Project Lead in a wide variety of business applications. Particularly interested in client/server and relational database design using MS-SQL Server Enterprise and Management Studio.
ASP.Net, Coldfusion, Visual Basic 6, Java, CSS, SQL,PL/SQL,PHP
Certified Business Analyst
(Public Company; TMO; Biotechnology industry)
August 2009 — Present (4 months)
(Public Company; CECO; Education Management industry)
April 2009 — August 2009 (5 months)
(Public Company; CECO; Education Management industry)
January 2009 — April 2009 (4 months)
Networking:
Plans and implements additions, deletions and major modifications to the supporting infrastructure campus-wide in coordination with corporate leadership.
Oversees the implementation of network security at the campus level
Anticipates future network needs, identifies proactive solutions to satisfy needs.
Database:
Developed and Monitoring a SQL Server 2005 Data Structure.
Implemented a software application written in VB.Net to help ensure proper tracking of inventory items.
Communication
Ensures department is well informed, at all times, of changes and news worthy events within the campus.
Effectively communicates relevant IT-related information to superiors.
Overall:
Develop Information Technology strategy in support of the company’s mission and core objectives.
Direct the preparation and implementation of policies, procedures and standards relating to information and telecommunication systems.
(Privately Held; 11-50 employees; Biotechnology industry)
May 2008 — December 2008 (8 months)
Responsible for Database Administration of MS SQL Server 2000, SQL Management Studio 2005 & Oracle 11i.
Designed and maintained project databases using both MS SQL Server Management Studio and Oracle; ensured accuracy of information and automated numerous functions.
Created and implemented database design solutions in collaboration with programming team.
Developed software applications using VB.Net, ASP.Net, ColdFusion, Java, PHP, SQL, and Adobe Flex 3.0
Created and maintained MS SQL Stored Procedures, Views, Triggers, Scheduled Jobs, SSRS and SSIS.
(Privately Held; 51-200 employees; Marketing and Advertising industry)
August 2006 — May 2008 (1 year 10 months)
Responsible for Database Administration of SQL Server 2000 and 2005.
Verify backups and error logs on the servers and troubleshoot any failures or alerts.
Actively involve and participate in team meetings and author how-to documents and knowledge base articles for various databases related tasks.
Maintaining the size of the production and test databases.
Maintain Log Files, Adding and Modifying Indexes, Troubleshooting database issues.
Responsible for SQL Server Security, Backing up databases, Archiving Data through automation of Stored Procedures and Scheduled SSIS Jobs.
Software Development of new applications and maintenance of applications written in Coldfusion, PHP, Visual Basic, .Net and XML
Project Lead experience.
Develop SQL Scripting through both SQL Server Enterprise and Management Studio.
Stored Procedure, Trigger, DTS, SSIS, and Function Development.
Automated Data Return through Microsoft Excel 2003 & 2007 that is linked through SQL Server.
(Privately Held; 1001-5000 employees; Computer Software industry)
July 2005 — June 2006 (1 year )
Strong Experience with PL/SQL, Oracle, Unix, SAS, VAX , VB, and Microsoft Office Suite applications.
Developing Microsoft.NET web applications with ADO.NET
Developing Excel and Access macros.
Development of access databases
Developing UNIX shell scripting
Strong analytical and troubleshooting skills
Ability to work independently on multiple tasks
Update, submit and check command procedures and programs for data manipulation purposes.
Build and maintain relational database structures.
Producing Ad-Hoc Reports.
Update and Develop documentation and checklists.
Strong Oracle and SQL Server 2000 skills
Working in Data Warehouse, Data Mart, OLAP, Production and test schema databases.
(Public Company; 10,001 or more employees; cmsk; Broadcast Media industry)
April 2001 — August 2005 (4 years 5 months)
Lead Macro Developer for visual basic and sql programming scripts.
In charge of communicating with other departments to assist on various requests per management.
Advance SQL Developer for multiple functions of the company.
Developing macros for quicker and more efficient methods to make modifications to either the video, high-speed data or telephony database.
Running Macros for either mass updates or a minimal of changes in the system that can assist with the daily workload.
Developing Oracle PL/SQL Language to access reports for various types of different requests for telephony, cable and High Speed Internet.
Developing in-house databases for various support systems.
Developed the rate increase application that Comcast currently utilizes to perform rate increases annually.
Developed an application that automatically detects if a customer account is at a certain amount of days past due then the account will automatically be suspended until payment is made.
Bachelor , Software Engineering / IT , 2003 — 2007
Computer Science 1995 — 1997
Pittsburgh Coldfusion User Group,
Pittsburgh SQL Server User Group,
Pittsburgh Oracle User Group
Graduated College with Honors