Sql Server Database Administrator and Developer

P.O. Box ***

Aquebogue, NY *****

Telephone: 631-***-****

E-mail:***********@*********.***

CAREER SYNOPSIS:

SQL Server developer/DBA and C# Developer with over 25 years experience.

Designed and developed thousands of mission-critical databases as a database developer and Programmer/Analyst for numerous companies and industries. Always looking for ways to improve the performance of your applications!

CERTIFICATIONS:

SQL Server Database Developer, MCP 70-433, MCTS 70-433

Epic Bridges Interfaces Certification

COMPUTER LANGUAGES:

T-SQL, C#, C++, C, VB.Net, Powershell, JavaScript, Crystal Reports 2016, PowerBuilder, Universe Basic, MS Access

SKILL SETS:

Development of SQL Queries, Stored Procedures, Database objects, Business Intelligence, Project Management, Data Warehousing, Design, Data Modeling, Database Administration, Business Analytics.

Experience in DSS using MS SQL Server Analysis Services, OLAP Cubes, ETL, MDX, SSRS, DTS & SSIS.

Experience in Designing Data Mart and Data Warehouse using Star Schema and Snowflake Schema in implementing Decision Support Systems.

Experience in performance tuning of queries and stored procedures.

Experience in Windows Powershell, Cascading Style Sheets, SP Administration.

Experience with C#.Net ASP.Net development.

Exceptional team-management, leadership and communication skills coupled with the technical and functional proficiency required to successfully oversee and complete challenging IT development projects.

Experience with OLAP Reporting tools, Crystal Reports 2011/2016, SSRS, MS Excel

DATABASE PLATFORMS:

MS SQL Server 2017, MS SQL Server 2016, MS SQL Server 2008 R2, MS SQL Server 2005, Sybase ASE 16.0, Oracle 12.1, MS Access, MySQL

SYSTEM ENVIRONMENTS:

MS Visual Studio 2016, MS Visual Studio 2015, MS Visual Studio 2012, MS Windows Server 2012 R2, MS Windows 8,1, Crystal Server BI 4.0, Crystal Server 2011, MS Windows Professional, MS Windows XP Professional, Redhat Enterprise Linux

PROFESSIONAL EXPERIENCE:

Catholic Health Services of Long Island October 2017-April 2018

Integration Analyst - Implementation and support of the interfaces which allow hospital systems to exchange patient information. Designing new interfaces leveraging the integration engine Rhapsody. Providing integration between hospital systems as well as integration with external systems for the purpose of servicing the patient community. Integrating external systems with the Hospital’s EMR system, Epic. Developed complex HL7 interfaces using JavaScript, Windows Powershell, and other languages. Received Epic Bridges Certification in 2017.

KLD Measurement Technologies June 2013-October 2017

Software Engineer

Responsible for the design and Development of Major Web Application for presenting measurement data to clients. Heavy emphasis on performance tuning of data-intensive SQL Server applications. The application stores measurements in a SQL Server 2014 database and provides custom reports to present this data. Reports include various statistical measures which allow clients to make better decisions about the maintenance of equipment. Written in C#.net on an ASP.Net platform. Design and development of data model and implementation via stored procedures. Responsible also for maintenance and backup of dozens of client databases.

Suffolk County National Bank August 2011-June 2013

Programmer/Analyst

Responsible for the design and development of enterprise-wide database and applications using SQL Server 2008 R2 and C#.Net. Administration of SQL Server and Crystal Server 2011. Design and implementation of Crystal Reports and Oracle Database version 12c. Performance tuning of new and existing databases.

Guaranteed Returns November 2010 – August 2011

Senior SQL Server DBA

Responsible for the Design and Maintenance of all SQL databases for this reverse pharmaceutical distribution company. Redesigned Extranet Reporting database. Utilized T-SQL Stored procedures for reporting queries. Designed and implemented data warehouse data using MS SQL Server integration Services. Performance tuning of new and existing SQL Server databases.

Adelphi University April 2008-November 2010

Senior Programmer/Analyst

Responsible for the Design and Development of administrative systems for this major University. Programmed numerous reports and screens to enhance functionality within the areas of Human Resources, Insurance administration, the new Security application, Purchasing, General Accounting, and attendance. The system is developed on IBM’s Universe Multivalue database and runs on an IBM AIX server. Developed major data conversion program from SQL Server to Universe. Performance tuning of numerous SQL Server databases.

Various Consulting Clients August 1999-April 2008

Nomura Securities International January 1999-August 1999

Senior Programmer/Analyst

Responsible for development of Commercial Real Estate Loan Tracking System. This system tracks all of the details of a $9 Billion loan portfolio for this major investment bank. Responsible for development of numerous stored procedures for update of the General Ledger and implementation of correct transaction processing. Implemented a large number of triggers for the purpose of referential integrity. It was developed with MS SQL Server with front end portions written in PowerBuilder.

Warner Brothers October 1997-January 1999

Senior Level DBA

Development of Pay Television Licensing and Distribution System. The system captures all components of movie licensing to cable television networks. Responsible for development of a large number of highly complex stored procedures in T-SQL implementing transaction processing in coordination with a frontend application. Worked with developers of frontend application to define data relationships and database normalization. Optimized many stored procedures and T-SQL statements to allow for better use of indexes and other database features. The system runs on a MS Windows NT system using MS SQL Server 7 as the server database.

Various Consulting Clients May 1996-October 1997

International Nederlanden Group (ING) December 1994 - May 1996

Consultant for Lextra International

Senior Level DBA of a database redevelopment project. The project consists of the redevelopment of mission critical applications from a desktop environment to a SQL Server environment for this international investment bank. The systems include loan processing, margin finance, risk management, and portfolio tracking. Performed analysis of current systems. Normalization of databases. Responsible for the development of various stored procedures for loading of data into MS SQL Server database. Created and implemented many triggers to enforce data quality and referential integrity.

J. Crew Inc. January 1994-December 1994

Senior DBA

Responsible for development of Merchandise Information System using MS SQL Server version 4.21. The System tracks the merchandising activity for this $5.1 billion annual (sales) company. Developed numerous management reports to forecast the demand for various products and to allow for the planning of production using SQL Server stored procedures. Revamped the database to reduce redundant data and improve relational integrity using triggers. Improved system performance by reworking stored procedures to minimize the use of cursors whenever possible.

N.Y.C. School Construction Authority June 1993-January 1994

Consultant for RCG Vectron

DBA of Professional Contract Management System in Microsoft SQL Server. The System tracks the progress of completion of contracts of 18,000 vendors for this governmental agency. Implemented various stored procedures for the updating of contract status, outputting of reports, and summarization of contract data. Developed stored procedures for nightly batch processing and summarization of contract accounts.

Viacom/MTV Network Television May 1992-June 1993

Consultant for The Allegiance Group

Senior DBA responsible for the development of Nielsen Ratings Tracking System in MS SQL Server. The System stores Nielsen ratings in an Historical file which allows for the comparison of ratings for various dayparts. In addition to providing details such as ratings, share, and HUT (households using television), it also allows for the comparison of this data among all television networks. Developed stored procedures to summarize ratings data. The system runs on a Windows NT Server running MS SQL Server.

USA Network Television Sept. 1990 - May 1992

Consultant for Howard Systems International

DBA responsible for development of Budget Expense Tracking System In MS SQL Server . The System tracks all of the production expenses for this major cable TV Network. It operates in a multi server wide-area-network environment and allows concurrent use by over 400 users from Long Island to Los Angeles. The system runs on a MS SQL Server running Windows NT.

Continuous Forms Printing Co., Inc. Sept. 1987-Sept 1991

Programmer Analyst

Developing a complete accounting system in Foxpro, installing network software, and maintaining the system for a network of over 25 nodes. Extensive reporting functions were integrated into all applications.

EDUCATION:

Brooklyn College, CUNY, Brooklyn, NY: B.S. in Accounting, January 1991

Adelphi University, MBA Candidate

INTERESTING FACT:

In the 1990’s, I was the owner of the PowerBuilder PB-L mailing list.

REFERENCES: Available upon request

Contact this candidate