Sql Server Management

Andrej Friedman Sql Developer Resume

ANDREJ FRIEDMAN5050 S. Lake Shore Dr #3606, Chicago, IL, 60615 **************@*****.*** H: 773-***-**** C: 773-***-**** INFORMATION TECHNOLOGY PROFESSIONAL SQL Developer with experience using SQL Server Management Studio and Visual Studio 2008 Highly analytical candidate with extensive and progressive experience in the design, development, and management of application systems. In-depth understanding of data modeling and ER design. Solutions-oriented working with teams and demonstrated excellence in building complex scripts and queries. Proficient in creating complex packages within SSIS. Skilled at building and deploying multi-valued parameterized reports including matrixes, charts, and gauges in SSRS. Excellent written communication and interpersonal skills. TECHNICAL COMPETENCIESDatabase Management Skills:Microsoft SQL Server 2008 XML Query Performance TuningT-SQL Data Flows DB Security and EncryptionScripting & Custom Components Reporting Services Package Deployment/ManagementSQL Server 2008 Implementation Error Logging & Handling Advanced SQL Querying & ProgrammingTools:SQL Server Management Studio Adobe Photoshop Business Intelligence Development StudioAutodesk Maya Autodesk 3D Studio MaxSoftware:MS SQL Server 2008 Integration Services (SSIS) MS SQL Server 2008 Reporting Services (SSRS)Microsoft Office 2010 EDUCATION & TRAININGSetFocus, LLC www.setfocus.com 9/2010-5/2011SQL Master s Work/ Study ProgramThe SetFocus SQL Server Master s Program is an intensive, hands on, project oriented program where participants gainknowledge and valuable experience putting the SQL Server skill set to use in a simulated work environment.Computer Animation, Film/Video - 9/2003-6/2006Columbia College Chicago, Chicago, IL SQL PROJECT EXPERIENCEAdvanced SQL Programming 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 options, and indexing strategies.SQL Server 2008 Database Design and Implementation Analyzed the business requirements and systematically designed a database for an online-movie (DVD/Blu-Ray) rental company working as a team. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the import and export of data using XML and SSIS. Created various reports according to the business requirements for the movie rental company in a team-oriented environment. Individually authored, installed, deployed and managed reports using SSRS for a library database. Individually designed a bank application according to business requirements, and implemented robust stored procedures, functions, and triggers to implement required functionalities. Created an ETL solution that reads Product, Vendor, and Order data from. CSV files on a network share into a SQL Server database. Solution validated incoming data and performed notifications when jobs complete. The order data thus loaded into SQL Server and was used to generate reports using the new SSRS 2008 reporting functionality (including the Tablix control). Reports were set up for automatic delivery based on standard report subscriptions.ANDREJ FRIEDMAN, page 2 PROFESSIONA L EXPERIENC EADMINISTRATIVE ASSISTANT 4/2001-PresentMaya s Daye Care Manage all daily operations of a running small day care with administrative tasks, such as emailing clients about availability, creating business documents, and advertising availability on associated websites.