Sql Server Management

Sql Ssis Ssrs Developer Resume

ADAM SOUDER**** Irwin Dr., Columbus, IN, 47201 *********@*******.*** H: 812-***-**** INFORMATION TECHNOLO GY 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 complexscripts 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 Query Performance Tuning Advanced SQL Querying & ProgrammingT-SQL Data Flows DB Security and EncryptionSQL Server 2008 Implementation Reporting Services Package Deployment/ManagementError Logging & HandlingTools:SQL Server Management StudioBusiness Intelligence Development StudioSoftware:MS SQL Server 2008 Integration Services (SSIS) MS SQL Server 2008 Reporting Services (SSRS)Microsoft Office 2010 MS Visio EDUCATION &TRAININGSetFocus, LLC www.setfocus.com 12/2011-6/2012SQL Server Work/ StudyProgramThe 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.Bachelors of Science, Business with focus in Computer Information Systems 8/2008-5/2011IUPUC, Columbus, INBachelors of Arts, Geography with focus in Atmospheric Science 8/2002-5/2006Indiana University, Bloomington, IN SQL PROJECT EXPERIENCEAdvanced SQL Programming Created numerous simple to complex queries involving self joins, correlated sub queries, and CTE s 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 CSV 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. ADAM SOUDER, page 2 RELATED COURSEWORK Intro to Object Oriented Programming Managing Information Systems Intro to Systems Development Database Fundamentals Database Programming Information Technology Architectures Systems Software and Networking PROFESSIONAL EXPERIENCELINE COOK 8/2009-PresentScores Sports Bar Prepared food and served customers Trained new employeesCONTRACTOR (SOFTWARE/APPLICATION INSTALLER) 12/2011 - 2/2012Skill Storm Imaged Android tablets Installed Software on Android tablets Unpacking and repacking Android TabletsDATABASE DESIGNER (INTERNSHIP) 2/2011-5/5011IUPUC Designed Microsoft Access database Worked with client to discover database requirements Imported data from existing system Designed user interface for databaseMACHINIST 8/2006-8/2009Cummins Inc. Operated machinery Lead team in operations Controlled quality by checking for bad parts Controlled inventory by tracking partsLINE COOK 5/2003-8/2006Chili s Bar and Grill Prepared food Lead shift in kitchen when I worked Trained new employees Assisted opening and closing the restaurant AWARDSI-Core Outstanding Student Award, IUPUC 12/2010 Award given to student who shows outstanding academic skills and continually adds value to the classroom.Dean s List, IUPUC 2008-20011