SUMMARY

• Result - oriented and motivated SQL Server Developer and Data Base Administrator with over 20 years of experience.
• Proficient in New Database design and optimization in MS-SQL Server.
• Designed, tuned, and improved T-SQL Stored Procedures, Tables, Triggers, Views, and Indexes.
• Built Stored Procedures, Tables and Views and Reports using SSRS and SSIS.
• DBA with Excellent troubleshooting skills and attention to details.
• Experience working in regulated, Pharmaceutical environment.
• Designed Stored Procedures for ETL and built DTS Packages using Business Intelligence SQL Server and Visual Studio.
• Developed Projects using BI, Data Tool, VB.NET, C#, Microsoft SQL Server, Power shell scripting, Share Point.

TECHNICAL SKILLS

Languages: T-SQL, VB6, VBA, SQL, HTML, VB.NET, C#

Databases and Tools: MS SQL SERVER, BI, SSRS, SSIS,MS ACCESS, Crystal Reports

PROFESSIONAL EXPERIENCE

Sr SQL Server Developer/Database Administration - Consultant

Confidential, Franklin Lakes, NJ

Responsibilities:

• MS-SQL database administration and design
• Optimize structure of large-scale databases in data warehouse.
• Perform audit and complex data analysis to identify patterns and anomalies.
• Tune and optimize complicated Stored Procedures to improve performance and accuracy.
• Communicate status, issues, concerns, recommendations, designs and technical decisions to manager.
• Work closely with remote QA in testing, and assist with production and implementation of projects.
• Build and rebuild indexes, tables, views and stored procedures.

Sr SQL Server Developer/Database Administration - Consultant

Confidential, NJ

Responsibilities:

• Analyzed and improved company reporting architecture to expand productivity and automation.
• Upgraded performance of existing financial reports using SSRS, Access, Excel, VBA.
• Worked with MS-SQL server
• Refactoring ETL Process and Reports.
• Performance tuning and optimization.

Database Development and Administration (DBA) - Consultant

Confidential, Parsippany, NJ

Responsibilities:

• Performed multiple SQL Server administration activities (create database, backup, restore, indexing, performance monitoring, security, clustering, log shipping, mirroring, and replication)
• Assisted IT management in prioritizingdatabase administration team's projects
• On-call DBA to resolve SQL server emergency issue.
• Designed, implemented and maintained new and existing database and BI objects including tables, indexes, constraints, stored procedures and user-defined functions.
• Tuned and optimize database objects, queries and scripts for speed and efficiency.
• Supported and improve multiple databases with complex schema, stored procedures, SSIS packages, reports and development team support.
• Data modeling, database optimization, implementation of schemas and complex SQL queries.
• Designed an efficient schema based on the business requirements.
• Designed, developed and executed packages to convert data using stored procedures, functions and SQL scripts in a Microsoft SQL Server environment using Data Tool and BI, Power shell scripting, .NET, SharePoint.
• Collaborated with Project Manager and business analyst to develop data conversion and update packages to meet client business rules.
• Designed highly scalable, reliable transaction databases.
• Performed complex data analysis to identify patterns and anomalies.
• Served as a resource and expert for developers dependent on the data.
• Communicated status, issues, concerns, recommendations, designs and technical decisions to manager.
• Worked closely with QA in testing and with support teams in the production implementation of projects.
• Troubleshoot SQL Server production issues, perform capacity planning, monitor database growth, and design disaster recovery strategies.
• Designed, loaded, process and migrated incoming data feeds and create outgoing data extracts.
• Migrated applications and data throughout the development cycle (development, test, stage, production) following proper policies and procedures.

Sr. SQL Server Developer- Consultant

Confidential, Morristown, NJ

Responsibilities:

• Worked in Large Data Warehousing (over 30Tb) on Requirements, Analysis and Technical Design, Development and Implementation of Data Integration, BI, ETL, Transformation and Reporting Solutions using T-SQL, SSIS and SSRS.
• Tuning performance of stored procedures using T-SQL, Execution plan, temporary tables and changing procedures logic.
• Tuning Reports performance by optimizing stored procedures.
• Designed Stored Procedures and build DTS Packages for ETL using Business Intelligence, SSIS, SQL Server 2012 and Visual Studio 2010.
• Participated in Documentation and Knowledge Transfer for Deployment
• Reviewed, analyzed, and modified programming systems including data transformation, testing, debugging and documenting programs.
• Performed a variety of complicated tasks that required experience in the Financial Industry VLDB (Very Large Database) and operational data store(ODS).
• Lead and coordinated the work of others.

SQL Server developer DBA - Lead

Confidential, Somerville, NJ

Responsibilities:

• SQL Server Database design for E-Commerce solution, data modeling and optimization, built Stored Procedure, Tables and Views.
• Building Reports using SSRS
• Transfer of data and ETL using T-SQL, BI (Data Tools) SSIS.
• Design of B2B interface for order processing, reporting and shipping using VB, VBA.
• Automatic incoming invoice import and verification, E Mail order confirmations.
• HTML product page generation for Internet Store, Search Engine Optimization.
• Interactive communication of main application with third party applications.
• Automatic E Mail data parsing for database update.
• Project development using T-SQL, VB.NET, Microsoft SQL Server, Visual Studio.NET and Microsoft.NET framework.

Sr. Programmer

Confidential, Princeton, NJ

Responsibilities:

• Improvement and optimization of Software Suite for Medical and Pharmaceutical companies and research labs that run on Access, SQL Server and Oracle Databases with convenient VB Interface and various analytical Crystal Reports.
• Worked with data warehousing tool for retrieving and managing large amounts of test data for evaluation and reporting in laboratories and research facility that helps to accelerate the discovery and development of new drugs, chemicals, and pharmaceutical products.