Sql Server Developer

OFER GOLDSTEIN

*** **** ** ******, ********* *K ( New York, New York 10025

917-***-**** ( ********@*******.***

Senior Database Developer with 10 years of experience in a wide range of

commercial relational databases and implementation of business models to

significantly improve operations and increase profitability. Lead large,

cross-functional efforts through complete project lifecycles. Hands-on

experience with advanced technologies and a wide range of system tools and

applications. Outstanding strategic analyst and tactical planner. Excellent

relationship management skills.

SQL Server 2008 & PostgreSQL T-SQL & PL/pgSQL Coding Schema Design

& Analysis

Performance Tuning ETL (SSIS & Pentaho) SSRS & Crystal Reports

Data Warehousing Object Oriented Programming VB.NET

NYMAGIC, INC. (Publicly Traded Insurance Company) November 2008 -

Present

Senior Database Developer and Analyst

Function as the company knowledge base for its newly acquired insurance

management system.

. Analyze complicated database schemas with over 500 tables in PostgreSQL

8.3 and SQL Server 2005.

. Develop and maintain database schemas for data warehousing and reporting

applications.

. Code, debug, and test database objects such as stored procedures,

functions, triggers, views and indices using SQL, PL/pgSQL and T-SQL.

. Conduct Performance Tuning on large scale systems (> 100 GB) including

performance monitoring, trace execution, index management, SQL query

optimization and normalization and denormalization of schema designs as

needed.

. Develop ETL packages using SSIS and Penthao Data Integration.

. Develop and deploy dynamic reporting solutions using Crystal Reports

and SQL Server 2005 Reporting Services (SSRS).

Rosenfeld and Maidenbaum, LLP (Property Tax Law Firm) 2001 - 2008

SQL Server Database Developer & Administrator 2006 - 2008

Implemented new business models, strategies and software to increase

enrollment and boost revenue for the property tax reduction unit.

. Designed, installed and tuned SQL Server databases, products and

services.

. Used DTS and SSIS to Extract, Transform and Load (ETL) to and from

various RDBMS platforms.

. Executed ad-hoc T-SQL quries based on management request.

. Migrated Microsoft Analysis Services to SQL Server Analysis Services

(SSAS).

Project and Operations Manager; Database Developer 2003 - 2006

Data Management and Operations

Analyzed data from multiple municipal departments to enhance computer

evaluation model. Collaborated on data integration and efficient

information maintenance.

. Introduced version control, CSLA .NET, and One Click Deployment in .Net.

. Managed annual filing of over 30,000 tax relief grievances on behalf of

homeowners in Nassau County.

Customized System Development

Supervised the creation of customized software to manage firm's client base

of 45,000, as well as the data of internal business groups, including

marketing, accounting, billing and case management.

. Provided consultation on SQL Server to the development team.

. Created backup and recovery plans for development and production servers.

. Fine-tuned queries and stored procedures.

. Created custom DTS jobs to automate repetitive task.

Lead Developer and Database Developer 2001-2003

Developed Windows system based on VB.Net and MS SQL-Server to replace

legacy system. Supervised staff of two. Recommended solutions to senior

management and staff.

. Increased volume of direct mail marketing campaigns by 500%.

. Cut processing time by 80% with custom module for speedy data entry,

completion of checks, deposits, refunds, disbursements, and account

balancing.

DMI Technologies (IT Consoulting Firm) 1999 - 2001

Database Administrator/Programmer

Coded classes and methods in Dephi. Developed and maintained large

production Oracle databases for the company's clients.

. Designed a complete relational database for SQL-Server.

. Designed business objects and Windows-based graphical interfaces and

supervised implementations.

Education / Training

. MS in Computer Science, Courant Institue of Mathamatical Sciences, NYU

(Candidate, Excpected 2013, GPA 3.3/4.0)

. BA, Degree in Business and Economics, Academic College of Tel-Aviv - Yafo

. Oracle Database Administration, New Horizons School (100 hours course)

Applications

SQL Server 2005, SSIS, SSRS, pgAdmin, Pentaho Data Integration, Crystal

Reports, SQL Profiler, SQL Compare, SQL Data Compare, FormReader, Visual

Studio .NET, SourceSafe, MS-Project, CSLA, Visio, ERWIN, CodeSmith, Delphi,

Oracle, UML, MS Office

Contact this candidate