Sql Server Quality Control

Resume Andrew Copley March ****

Andrew Copley Mt. Juliet, TN 37122 615-***-**** abqffq@r.postjobfree.com Developer with experience using SQL Server Management Studio and Visual Studio 2008with entry level to mid level experience. Demonstrated leadership abilities and team work skillsas well as the ability to accomplish tasks under minimal direction and supervision. Highlymotivated individual with 3 + years computing experience, including computer programmingand IT support skills.http://www.slideshare.net/drewcopley/sql-portfolio-7198558http://www.linkedin.com/in/acopleytnsqlTECHNICAL SKILLSDatabase Management Systems:Microsoft SQL Server 2008Software:MS SQL Server 2008 Integration Services (SSIS), MS SQL Server 2008 Reporting Services(SSRS), Microsoft Office, T-SQL, CSS, HTML, XHTML, Java, JavaScript, XML/XSL, C++,C#Tools:SQL Server Management Studio, Microsoft Visio, Microsoft Access, Microsoft Project, VisualStudio 2008/2010SetFocus, LLC. Nashville, TN 11/10-05/11SQL Master s ProgramThe SetFocus SQL Server Master s Program is an intensive, hands on, project oriented programwhere participants gain knowledge and valuable experience putting the SQL Server skill set touse in a simulated work environment. 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. As part of a team, analyzed the business requirements and systematically designed a database for an online-movie (DVD/Blu- Ray) rental company. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, abqffq@r.postjobfree.com clustered and non-clustered indexes and triggers, and implemented the import and export of data using XML and SSIS. As part of a team, created various reports according to the business requirements for the movie rental company. 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. The solution also validated incoming data and performed notifications when jobs complete. The order data thus loaded into SQL Server was used to generate reports using the new SSRS 2008 reporting functionality (including the Tablix control). The reports were set up for automatic delivery based on standard report subscriptions.PROFESSIONAL EXPERIENCEHoliday Inn, Assistant Chef Nashville, TN 03/2003-CurrentAided the Executive Chef and Sous Chefs in the ordering, receiving, and storage of all kitchencommodities. Assisted in hiring, training, scheduling, and disciplining of staff members.Developed and maintained relations with all outside vendors, including ordering, arranging newproduct testing, receiving, posting of invoices for payment, and follow-up relations.Developed and trained all new staff members to include: working within specified food costcontrol measures, quality control measures, and professional health and sanitation operatingprocedures.Longhorn Steakhouse, Corporate Trainer / Lead Cook Hermitage, TN 07/1997-CurrentTraveled extensively to new store openings as a Corporate Trainer.Facilitated the training and organizing of entirely new to the company staff, while maintainingcompany set levels of quality and consistency and maintaining company timeframe specificschedules for store opening.Aided and assisted the Kitchen Manager in all aspects of kitchen management including:ordering, receiving, storing of products, interviewing, hiring, training, scheduling, anddisciplining of staff members, and control of cost of sales including the costs of perishable, non-perishables, and utilities.EDUCATIONUniversity of Phoenix Nashville, TN Campus 05/11Bachelors of Science, Information Technology - Overall GPA 3.64