SUMMARY

• Microsoft - certified SQL 2016 Database Developer
• T-SQL programmingexpert with over 20 years of experience
• Led several full life-cycle database development projects using SQL Server 2008/2012. These projects involved all phases of development from business requirements gathering through transfer to production support.
• As a database administrator, used SQL Server Integration Services (SSIS) for ETL development in working with VLDBs. These SSIS projects involved highly-sensitive security data to control document access.
• Optimized code efficient by using performance tuning skillsforcomplex queries and stored procedures. Analyzed query plans to solve performance problems utilizing indexing strategies, query hints and SQL Server configuration
• Experience in designing and implementing complex logical and physical Data Models including Snowflake/Star schemas used in data warehouses
• Knowledge of implementation of SQL Server best practices gained from 12 years as a database administrator.

TECHNICAL SKILLS

Languages: T-SQL, PL-SQL, VB.NET, ASP.NET, VB6, ASP, HTML, CSS, JavaScript, VBScript, VBA, XML/XSD/XLST, JSON

Databases: MS SQL Server 2005 / 2008 / 2012 / 2014 / 2016 , Oracle 11g

O/S: Windows Server 2012, 2012 R2

Software: SSIS, Erwin, Visio, Excel, Project, PowerPoint, SourceSafe, SourceGear, OpenText Content Server

Tools: DOS batch scripting, RedHat

PROFESSIONAL EXPERIENCE

Confidential

Sql Developer Consultant

Responsibilities:

• Contracted with various companies in NJ, NY and CA
• Designed logical and physical database models and schemas
• Programmed database objects: stored procedures, functions, triggers
• Provided troubleshooting of problem queries using query plans, trace and profiler
• Designed and built ETL flows in SSIS to support data warehouse operations

Confidential, Woodbridge NJ

Database Developer

Responsibilities:

• Technical lead on a 4-year project to replace a customized DMS based on FileNet Content Services with a SQL Server backend with an installation of OpenText Content Server with an Oracle backend. The company successfully transitioned to an up-to-date, powerful document management system providing increased overall efficiency and reliability
• Converted complex T-SQL stored procedures to PL-SQL for enterprise applications that interacted with the DMS (Workflow, Check Processing, Tax Reporting, etc.) resulting in a seamless migration to the new system.
• Administered a SQL Server database which functioned as the backend for a customized DMS based on FileNet Content Services maintaining a high level of user satisfaction until the application was decommissioned.
• Tuned query performance using SQL Server Enterprise Manager to identify necessary indexes, query hints and rewrites which resulted in stellar application performance.
• Created a nightly process to import and reconcile extensive enterprise data into DMS database using SSIS which integrated the DMS into the enterprise.
• Created a reporting system to provide senior managers with reports on all aspects of the application: performance, usage, metadata utilization, data integrity which allowed them to address user concerns and guide needed development.

Confidential, Woodbridge NJ

Database Analyst/Developer

Responsibilities:

• Performed data modeling for a customized DMS for Confidential, including logical and physical design of the database schema.
• Led full life-cycle database development for the application, including complex T-SQL stored procedures which provided access to the DMS front-end as well as other enterprise applications.
• Tuned query performance using SQL Server Enterprise Manager to identify necessary indexes, query hints and rewrites which resulted in excellent application performance.

Confidential, New York NY

Senior Analyst/Developer

Responsibilities:

• Performed business analysis with in-house attorneys to port Legal Case Management System from a DB2 mainframe application to the ConEd Intranet.
• Wrote SQL queries against a DB2 mainframe which allowed the firm to maintain its legacy back-end while moving to more modern front-ends.
• Wrote intranet app using ASP using AJAX-like techniques to provide a web application that performed like a thick-client application.

Confidential, New York NY

Senior Business Analyst placed

• Supervised a team of business analysts in the integration of a new billing system which resulted in a solid requirements document on which the client could base their design.
• Interacted with a national sales team to ensure that business needs were addressed across the organization which resulting in user buy-in from all sales offices.

Confidential, New York NY

Project Manager

Responsibilities:

• Led a team of specialists to maintain and extend a complex portfolio management, analysis and reporting system for Donaldson, Lufkin & Jenrette which enhanced DLJ’s ability to take advantage of rapidly emerging business opportunities.
• Managed the full-development lifecycle for enhancement of DLJ’s Deal modeling method, based on XML, to support a web-based version of the system which allowed DLJ’s traders to quickly access reports in support their trading activities.
• Kept abreast of constantly changing client needs and managed the team to extend the system’s functionality, often resulting in releases on a weekly basis which kept the application relevant in a fast-moving company.

Confidential, New York NY

Intranet Analyst/Developer

Responsibilities:

• Created first company intranet which allowed departments to share information and documents within and between departments.
• Created web pages for each practice area and implemented upload methods for business users which resulted in the business users being in control of their own content.
• Wrote company directory application using ASP and T-SQL which allowed employees to more easily identify and interact with colleagues in a rapidly growing company.