|
|
Title: |
SQL Developer
|
Location: |
US-Florida-Tampa
|
Work History: |
Health Integrated, Inc., Tampa, FL. May 2007 Present - Contact Position
· Responsible for the creation of SQL procedures, triggers, temp tables, and views for the development of Crystal Reports 10. Reporting across multiple databases, multiple servers, multiple applications, within the Wellness Care industry.
· Scheduling and delivery of reports with Crystal Enterprise 10 in multiple formats, to print servers and through email.
· Working with DBAs, network engineers and various other IT professionals to migrate all databases, procedures and reports into a data warehouse, new domain as an ongoing project.
· Modification of legacy code to meet changing reporting requirements.
Publix, Inc. Corporate Offices, Lakeland, FL March 2007 thru April 2007
· Created multiple Crystal Reports based upon SQL databases. Utilized for an Internal, Corporate Wide endeavor.
LabMD, Inc. Savannah / Atlanta, GA 2004 12/2006
Manager of Information Technology - Data Analyst, SQL Developer, Network Administrator, Training & Troubleshooting of all systems, including Pathology & Clinical Laboratory Information Systems, within a Nationwide Pathology Reference Laboratory.
· Installation and upgrades in client / server environments, 6.5, 7.0 and SQL 2000. Backup & Restore, Data Import / Export & DTS services within SQL.
· Created Stored Procedures, triggers, views, temp tables for data manipulation & reporting.
· SQL Development & Troubleshooting included file groups, data access, odbc, indexes, stored procedures, triggers and table structures for application behavior manipulation.
· Created Crystal Reports in versions 9, 10 & 11. Programmed reports to include formulas, mathematical equations, conditions, graphs, graphics and electronic signatures.
· Examples of Crystal Reports include hospital wide billing information, pharmacy correlation with lab therapeutic results, pathology biopsy results including data interpretation with photomicrographs. Cumulative laboratory testing results, percentages, turn around time, workload and quality control reports.
· Moved Windows and SQL Network from Savannah to Atlanta. Maintained Windows, NT & 2000 server network environment, from 15 users, now up to 50+ users to Windows 2003 multiple server environment.
· Managed the migration of mission critical laboratory software from closed database to SQL 2000 third-party structured database. Worked on the implement of web-based portal with HIPPA secure access to SQL database web application 3for order entry & reporting of laboratory results.
· Writing SQL queries, stored procedures, views and triggers to adapt a third-party SQL application for custom use within a Pathology Reference Laboratory. Extensive experience writing Crystal Reports versions 9 & 11.
· Creation and troubleshooting of SQL, HL7, ASTM, VPN, TCP/IP, FTP file transfer communications. Maintained for electronic transfer of demographics, orders and results, inbound and outbound information, within a HIPPA compliant environment.
· 24 x 7 as Primary troubleshooter of pcs, printer, servers, entire network along with SQL based applications in the corporate, billing and laboratory settings.
· Configuring and maintaining networks, LAN, Wan, VPN, routers, firewalls, IIS & Active Directory components. Backup and Restore of multiple applications, multiple servers, multiple networks.
LabSoft, Inc. Tampa, FL 1992 2004
Technical Training & Software Support - On-Site Installation & Training of Laboratory Information Systems within small hospital & large clinic environments.
· Research & Development, Installation & Training, Troubleshooting, Support and Database Administration of MSSQL Database, while implementing and teaching application software that is designed for the Clinical Medical Laboratory.
· Provided On-Site and extensive telephone support of hardware and software.
· Created Crystal Reports in versions 7, 8 & 9. Created ad hoc reports per client specifications. Examples include billing, cost per test, turn around time, workload and quality control.
· Installation and upgrades in both client / server environments, 6.5, 7.0 and SQL 2000. Backup & Restore, Data Extraction and Transformation services within SQL.
· SQL Troubleshooting included file groups, data access, odbc, indexes, stored procedures. Extensive experience with Data importing and exporting.
· Training of laboratory, medical staff and nursing personnel. Installation of Networking (LAN), hardware and associated components, databases, operating systems and proprietary software.
· Programming SQL for data manipulation, used for Crystal Reports based upon MSSQL 6.5, MSSQL.7, SQL 2000 Queries, Procedures, Tables and Triggers,
· Working Knowledge of DOS, Windows 98, NT, 2000, Word, Excel, Paint Shop Pro and MSSQL; extensive troubleshooting experience with Windows and SQL.
· Initiating and problem solving of HL7 & ASTM Interfacing between application software & medical Analyzers, Reference Labs, Hospital/Practice Management, Billing and EMR software systems.
· Primary Customer Service via phone and remote access. Troubleshooting, support, research and development of laboratory software based upon client problems, questions, suggestions or requests.
· Developing third party reporting components for the storage, retrieval and querying of a databases across multiple servers. Also serve as the administrator of SQL client/server for applications.
LifeLink Foundation Tissue Bank, Tampa, FL AATB Certified Tissue Bank Technician. Sterile Tissue Recovery & Processing for Surgical Allografting.
Methodist Hospital of Indianapolis, Indianapolis, IN Organ Procurement Coordinator & Tissue Bank Technician. Logistical Coordination & Surgical Scrub Experience for Solid Organ Recovery (Kidney & Liver programs), utilized for Human Transplantation.
Emanuel Hospital, Portland, OR Medical Laboratory Technician. Evening & graveyard shift positions in a STAT medical laboratory. Learned to think on my feet within the largest Trauma & Burn center in the state of Oregon.
United States Navy, CA, Okinawa,Japan - Hospital Corpsman 3rd Class. 1st & 3rd Marines. Honorable Discharge 1980.
|
Skills: |
MLT (ASCP), MCP, CompTIA Security +, MCSA, MCSE, MCDBA
Have experience teaching & supporting various software and through understanding of Medical procedures & processes, including HIPPA. Have extensive experience with SQL development, administration and with Crystal Reports, 7, 8.5, 9, 10 & XI. Experience with Crystal Enterprise version 10.
Have infinite patience, excellent troubleshooting & people skills. My past experiences have led to a good understanding of IT hardware & software interaction and thinking on my feet.
Would like to find a position within an organization where I can utilize my unique skill sets of databases, Crystal Reports and computer knowledge in conjunction with my experiences in medicine.
|
Education: |
Portland Community College, Portland, Oregon 1984
Associates of Sciences Degree in Medical Laboratory Technology
CERTIFICATIONS
· Medical Laboratory Technical (ASCP) Certified by the American Sociality Clinical Pathologists.
· Certified Tissue Bank Technician (AATB) Certified by the American Association of Tissue Banks.
· MCP, CompTIA Security +.
· MCSE, MCSA
· SQL 2000 MCDBA
|
Endorsements
|
 |
Patrick has received 4 endorsements.
|
Patrick has endorsed 0 Members.
|
|
|
| |
Rank |
Title |
Location |
Status |
Actions |
|
7.671 |
IT Administrator |
US-Missouri-St. Louis |
 |
Details
|
|
|
3.063 |
SQL Database Developer |
US-Florida-Tampa |
|
Details
|
|
|
2.578 |
Electrical Test Engineer |
US-Missouri-St. Louis |
|
Details
|
|
|
1.005 |
ETL developer/Data warehouse analyst |
US |
|
Details
|
|
|
|
|
Public Messages
|
|
| From |
Date |
Message |
 |
09.29.07 |
I would like to network with you regarding a position our executive search firm has been retained to fill. It is for a great company in Chicago.
Perhaps someone in your network might be interested in a Senior Exchange Messaging Engineer position. Please see the job description below. Im happy to answer any questions. Feel free to forward on to anyone you like.
Whether this is of interest to you or not, I encourage you to reply with a resume. It would be helpful for us in future searches that might be ideal for your background. Our firm has been in business for 30 years & is a pioneer in diversity. Thank you.
Don McCauley
dmccauley@dgai.com
Position Specification
Title: Senior Exchange Engineer
The Team
Technical Architecture The position is a part of the Research and Development department and fills a senior role in our messaging systems development group. The teams involved consist of managers/staff, Communications Department, Operations, Application Development, contractors, and vendors.
Position description
As a senior member of our messaging R&D department, the candidate will be responsible for maintaining and improving the companys state of the art global messaging environment with some cross platform (Microsoft/Cisco) unified messaging design and support.
The candidate will work with SMTP, Microsoft Exchange Server, Presence, SonicWall, and related email concepts, protocols and methods along with the opportunities to perform major upgrades to our messaging platforms. The candidate will work alongside our Communications department to help design and support our unified messaging environment.
Person
The candidate shall have a broad background in messaging technologies and shall have demonstrated proficiency in the following areas:
Exchange 2003\Exchange 2007
Live Communication server (LCS)\Office Communications Server (OCS)
Mobile Messaging Technologies (Active Sync, BlackBerry, Good Technologies)
Remote Messaging Technologies (OWA, RPC over HTTP)
Anti-Spam Technologies
Anti-Virus Technologies (messaging specific)
Messaging DR best practices
Storage technologies (SANs, FC Switches, HBAs)
Microsoft Outlook 2003/2007
Active Directory
Windows 2003 Server
DNS
SMTP
Understanding the principles of UM (Cisco\Exchange)
Job Responsibilities
The candidate will have the following responsibilities with the potential of expanding:
Researching and developing solutions to meet enterprise wide messaging needs.
Researching, architecting, testing and planning the integration of new messaging technologies and upgrades to existing platforms.
Staying current with new technologies, and industry best practices; particularly those dealing with messaging and storage.
High level maintenance and troubleshooting of the current Exchange 2003 messaging environment based on industry best practices. (Responsibilities include but are not limited to troubleshooting and resolving high level mail routing issues, public folder issues, mailbox issues, Exchange server\services issues; adding\removing messaging servers, configuring servers, services, routing policies, etc., establishing maintenance procedures based on current industry BP).
Maintaining and troubleshooting SMTP internet gateway issues (Currently SonicWall).
Maintaining and troubleshooting Live Communications server 2005.
Establishing DR procedures for all relevant messaging servers. (Exchange, LCS, Blackberry, Good etc).
Maintaining and troubleshooting BlackBerry and Good Technologies servers.
Maintaining and troubleshooting Outlook Web Access \ RPC over HTTP
Maintaining and Configuring EMC SANs and FC Switches.
Working with Communications group to troubleshoot Cisco Unity issues.
Keeping documentation up to date for the messaging environment.
Testing and deployment of upgrades, hot fixes and other updates.
Education and/or Experience
Bachelor's degree in Computer Science or equivalent 7 to 10 years of relevant experience.
Excellent problem solving, written and oral communication skills.
Deep knowledge of SMTP, Microsoft Exchange Server, and related email concepts, protocols and methods are required. |
|
|
