Post Job Free
Sign in

Sql Server Developer

Location:
New York, NY
Posted:
October 06, 2013

Contact this candidate

Resume:

SHAUN BROWN

*** ***** *** ******

914-***-****

Mount Vernon, NY 10550

********.*****@*****.***

SUMMARY

SQL Developer with experience using SQL Server Management Studio and Visual Studio 2008. Adept in building

complex scripts and queries. In-depth understanding of data modeling and ER design. Proficient in creating complex

packages within SSIS, as well as building and deploying multi-valued parameterized report including, matrices, charts,

and gauges in SSRS. Excellent written communication and interpersonal skills. Proven leadership abilities and strong

focus on team success, as well as highly capable of solitary work with minimal instruction.

TECHNICAL SKILLS

Database Management Skills: Microsoft SQL Server 2008, XML, Query Performance Tuning, T-SQL, Data Flows, DB

Security and Encryption, Scripting & Custom Components, Reporting Services, Package Deployment/Management, SQL

Server 2008 Implementation, Error Logging & Handling, Advanced SQL Querying & Programming

Tools: SQL Server Management Studio, Microsoft Visio, and Business Intelligence Development Studio

Software/Hardware: MS SQL Server 2008 Integration Services (SSIS), MS SQL Server 2008 Reporting Services

(SSRS), MS Excel

Programming: C#, ASP.NET, HTML, CSS, SQL, XML

Operating System/Server: Windows Server 2008, Ubuntu Server

Certifications: A+, SharePoint Configuration

PROFESSIONAL EXPERIENCE

SetFocus, LLC, Parsippany, NJ 2012

SQL Developer Work

• Created numerous simple to complex queries involving self joins, correlated sub queries, CTE’s and XML

techniques for diverse business requirements. Tuned and optimized queries by altering database design, analyzing

different query SQL Server 2008 Database Design and Implementation.

• Analyzed business requirements and systematically designed database for online-movie (DVD/Blue-Ray) rental

company working as team. Employed best practices in creating complete schema including tables, relationships,

stored procedures, views, clustered and non-clustered indexes and triggers, and implemented import and export

of data using XML and SSIS.

• Produced various reports according to business requirements for movie rental company in team-oriented

environment. Individually authored, installed, deployed and managed reports using SSRS for library database.

Individually designed bank application according to business requirements, and implemented robust stored

procedures, functions, and triggers to implement required functionalities.

• Formulated ETL solution that read Product, Vendor, and Order data from .CSV files on network share into SQL

Server database. Solution validated incoming data and performed notifications when jobs were complete. Loaded

order data into SQL Server and generated reports using new SSRS 2008 reporting functionality (including Tablix

control). Reports were set up for automatic delivery based on standard report subscriptions.

SHAUN BROWN

Page 2

Intertechmedia, Stamford, CT 2011

Contract/Web Developer

• Designed high fidelity, pixel-perfect, and intuitive user-interfaces that helped to simplify and innovate the overall

user-experience of the customer facing application, website, and supplementary explorations.

• Integrated high-fidelity mockups into full-functioning front-end user-interfaces using the latest HTML5, CSS3,

and JQuery tools.

• Developed extensive and interactive wireframes, conceptual diagrams, and conceptual models across all aspects

of the UX.

• Performing comparative market research, usability testing & data analysis as well as created extensive style

guidelines, icons, and imagery to maintain consistency and professionalism.

• Involved in ongoing projects and team dynamics in an agile workflow environment to ensure all products met

deadlines and were served with the highest professional quality.

Independent Contractor, Mount Vernon, NY 2010

Software Developer

• Developed website using CSS, HTML5, JavaScript, and flash for New York based radio station.

• Maximized business value of existing technology platform through delivery of SharePoint-based solutions

created through integration, advanced configuration, design, and client-side development for outsourcing

application support company.

• Web Authoring and Publishing: Authoring, branding and control of the publishing process. It includes custom

master page publishing. Created custom minimal Master Page and associated it with HTML contents page to

make the HTML page an ASPX page with SharePoint controls.

Pace University, New York, NY 2009

Web Developer Intern

• Deployed and customized collaborative and publishing site collections, sites, web parts, document libraries, lists,

and views using SharePoint 2007.

• Provided user software support, software testing, Intranet database applications, and dynamic content

applications.

• Designed security access procedures, supplier order forms, and managed categories forming supplier and retailer

registration forms according to business needs. Performed network troubleshooting/maintenance as part of team.

EDUCATION

M.S., Computer Information Systems, Pace University, New York, NY

B.A.,

Computer Information Systems, Monroe College, New Rochelle, NY



Contact this candidate