SUMMARY

• I am a Software Engineer with over 30 years' experience in maintenance, performance tuning, monitoring and providing high availability to mission critical applications using Microsoft SQL Server 2000, 2005, 2008 & 2008R2 as well as other database systems using Sybase, Informix and Oracle.
• I thrive in both team and individual environments and can easily lead teams. I am capable of mentoring and training junior technical staff and end - users.

• SSIS used for migrating data from production to reporting structures;
• SSRS used for creating reports, both development on report server and Visual Studio;
• Maintenance, Performance and Tuning of MS SQL Server;
• Backup, Recovery, Log Shipping and Replication including Disaster Recovery and
• Business Resumption Planning;
• Expert TSQL and Script writing skills;
• Expert Relational Database Design skills;
• Expert Data Extraction and Report Writing skills
• Skilled at Responsible for network connectivity issues and hardware troubleshooting;
• Training and Support of Windows Mobile devices and applications;
• Assisted IT Manager with operations with all IT department activities; and
• Learned new concepts quickly while working well under pressure.

PROFESSIONAL EXPERIENCE

Confidential

Pharmacy Technical Analyst

Responsibilities:

• Make necessary database changes to turn off customer pharmacy medical replenishments
• Created SQL scripts for database changes
• Tested scripts in staging database
• Checked scripts via svn version control
• Document the termination of terminated pharmacies in Jira

Confidential

Platform Technical Support Engineer

Responsibilities:

• Trouble shoots Confidential Centricity Electronic Medical Records and help customers via trouble ticket support, telephone, or WebEx for SQL and Oracle database issues.
• Received trouble tickets via Siebel from Confidential Centricity Practice Solution and Centricity EMR customers then communicate via WebEx, Phone or email to the customer to diagnose and troubleshoot issue(s)
• Typical issues:
• Locked documents - Somebody is trying to sign a document and it gets locked up in the database. There’s a link that’s missing so they can’t sign it.Consultant will go into the databaseto either connect the link or release it.
• Logging into CPS/EMR
• Failed SQL jobs/nightly database backups
• User permission issues
• Active Directory issues -passwords, configuration/user profile is different or corrupt. Fix rebuild it or reset the password.

Confidential, Collegeville, PA

Health IT Application Specialist

Responsibilities:

• Analysis, development and testing of ETL for EMR and PM data from Allscripts Pro & Enterprise, Greenway EMR, McKesson Practice Partners & Confidential Centricity;
• Created bcp/SQL scripts to import said data into NextGen EMR/HER;
• Created SQL Server Reporting Services (SSRS) reports for multiple clients; and
• Designed STAR Schema for prototype data warehouse implementation.

Confidential, Alpharetta, GA

Senior Database Engineer

Responsibilities:

• Development and testing of TSQL scripts for SQL Server 2008 R2, SQL Server 2008 & SQL Server 2005;
• Analysis, development and testing of ETL scripts for multiple vendor's Electronic Medical Record, (EMR) packages' databases Allscripts Pro EMR, Allscripts Enterprise EMR, Confidential Centricity, Vitera, eClinical Works, Greenway, Amazing Charts, Eaglesoft Dental Software, NextGen & EMD EMR. This includes table structures, views, stored procedures and functions;
• Analysis, development and testing of ETL scripts for multiple vendors' Practice Management, (PM) such as Allscripts PM, Confidential Centricity & Eaglesoft Dental Software. This includes their table structures, views, stored procedures and functions;
• Implementation support of scripts to clients Product Bridge for multiple medical practices.
• SQL Server 2008 R2 Database Design and development of scripts for a prototype ETL using SQL Server Implementation Services SSIS for interface from parent files;
• SQL Server 2008 R2 Database Design and population of demonstration database to support the iNexx application;
• SQL Server 2008 R2 Database Design and implementation of a prototype database and ETL processes to populate a database designed to pull information from Allscripts Pro databases from multiple practices into a database to feed data to the iTriage web application; and
• SQL Server Anywhere - Installation and configuration on several systems. Used Sybase TSQL scripts for above mentioned bridge service. Used management tool to access other ODBC data sources.

Confidential, Capitol Heights, MD

Database Administrator

Responsibilities:

• Administration of multiple SQL Server 2005 & 2008 Databases;
• Provided desktop support, operations support, disaster recovery procedures, performance tuning, replication and log shipping;
• Training and Administration of Win WITS Postal Mail Routing Application;
• Training and Administration of BMC Service Desk Express;
• Administration of Windows 2003 & 2008 server and Active Directory;
• Monitored erroneous data entry and modified data by writing and executing SQL scripts;
• Created Enterprise reports across multiple databases using Crystal Reports; and
• Responsible for all SQL and Application software upgrades and patches.

Confidential, Annapolis, MD

Database Administrator

Responsibilities:

• Administration of multiple SQL Server 2005 Databases;
• Performance tuning, maintenance, backup and recovery of SQL server databases;
• Administration of Windows 2003 Server and Active Directory;
• Training and Administration and support of Allscripts Homecare Application;
• Training and Administration of Raisers Edge Database and Application;
• Responsible for all SQL and Application software upgrades and patches;
• Maintained codes tables in application databases;
• Provide end-user and desktop support;
• Applied two major codes tables reduction efforts using SQL scripts; and
• Created and maintained reports as needed.

Confidential

Manager/Key Holder

Responsibilities:

• Responsible for running $12M Flooring business;
• Managed staff of up to 100 employees;
• Managed paint, home decor, flooring, plumbing, and kitchen departments;
• Controlled shrink, inventory management, personnel and customer service; and
• Additional duties included opening/close store, employee management, safety, and loss prevention and vault tasks up to $200K daily.

Confidential, Cherry Hill, NJ

President

Responsibilities:

• Managed day-to-day operations of occupational facilities including renovation, accounting, litigation of legal tenants;
• Procured legal counsel for past due leases and renovation of property; and
• Acquired apartment facility in disrepair and made property presentable to existing and future tenants for resale of the property.

Confidential, Cherry Hill, NJ

Manager Business-to-Business E-Commerce

Responsibilities:

• Served as technical lead and system architect on a Business Intelligence effort for a niche pharmaceutical company;
• Responsible for logical and physical database design in addition to architecture assessment, hardware and software recommendation based upon short-term technology plans;
• Managed multiple implementations of B2B e commerce applications; and
• Managed SQL Server 2000 databases.

Confidential, Greenbelt, MD

Project Manager

Responsibilities:

• Managed a development project for a European Automotive Sales Forecasting, Customer and Vehicle Inventory application;
• Acted as technical lead and lead DBA on same projectusing SQL Server 2000;
• Responsible for conceptual design and database design in addition to managing the day-today project activities; and
• Managed recruiting effort for personnel on the project.

Confidential, Cherry Hill, NJ

Manager Systems Integration

Responsibilities:

• Confidential as a DBA and worked through multiple promotion where I was responsible for all Hardware and Software Infrastructure;
• Responsible for planning the configuration for all enterprise databases Responsible for conceptual design and database design in addition to managing the day-today project activities;
• Responsible for creating and maintaining short-term, mid-term and long term technology plan not only identifying but validating whether these new technologies were viable given the current and planned infrastructure;
• Managed implementation of a corporate intranet and access to the public Internet;
• Acted as Technical Liaison between SOA and contracted operations outsourcer;
• Responsible for coordination of all Desktop, Workgroup, Enterprise systems, Help Desk and modernization projects;
• Responsible for all technical aspects of disaster recovery and business resumption planning practices; and
• Sybase System 10 - Took multiple classes, including FastTrack, DBA class and System Administration class. Gained System 10 DBA certification. Performed multiple Database designs, multiple installations and configurations of peer-to-peer server enablements.