Sql Server Developer Resume
SUMMARY:
- Nearly 10 years IT experience specializing in Database Support / Design / Development of MS SQL Server 2012 / 2008 R2 / 2008 / 2005 / 2000 / 7.0 in Production / QA / Test Environments
- Knowledge / Experience creating Logical and Physical Data Models
- Upcoming MCSA Certification in Databases Dec’2017
- Experience using HTML / ASP.Net / C# / VB .Net. ( Approximately 3.0 Years)
- Front End Development (7 years Ago) In WEB and CLIENT / SERVER apps on a 2 tier and 3 tier architecture platform
- Experience of Backups / Restores / Maintenance Plans and Knowledge of various other DBA Tasks
- Experienced in various SQL Server Development tasks like writing SP’S / Triggers / Views Confidential ’s / Databases / Schemas / Table Design / Creating Tables / Indexes / Constraints Confidential
- Experience in SQL Server 2014 / 2012 / 2008 R 2 / 2008 2005 / 2000 / 7.0 Recent experience with MS SQL Server 2014 / 2012 / 2008 R2 / 2008 / 2005
- SSIS Package Development Experience (2.5 Years)
- SSRS Report Development Experience (Table & Matrix Reports On a Native Report Server)
- SSAS Cube Development Experience (6 Months)
- DBA Tasks (1 year)
TECHNICAL SKILLS:
Operating Systems: Windows 10.0 / 7.0 / NT / 2000 / XP / Vista
Languages: C#, VB .NET, Transact SQL, SQL, Office 2010 / 2007 / 2003
Web Applications: HTML, ASP, ASP.NET, ADO.NET, ODBC, OLEDB and Web Services
Databases: MS SQL Server, MS Access
Source Control: Microsoft Visual Source Safe And TFS
Reporting Tools: Server Reporting Services (SSRS) 2012 / 2008R2 / 2008
Front End GUI: Visual Studio 2010 / 2008 / 2005
WORK EXPERIENCE:
Confidential
SQL Server Developer
Responsibilities:
- Wrote various Queries / SP’S / Triggers / Views Confidential and documented the same
- Modified existing SSIS Packages / SSRS Reports
- All SQL work was performed using MS SQL server 2012 / 2014
Confidential, Round Lake, IL
SQL Server Developer
Responsibilities:
- Wrote New / Modified SSIS Packages for SQL Server 2005, and in the process modified various SP’S / Confidential ’FS Confidential .
- Also worked with Oracle and Toad
- Substitute teacher teaching SQL Development for Associate Districts in North Shore.
- Confidential work, writing SP’s, Triggers, and Views Confidential .
- Took approx.1 year off after working at Confidential (Family Medical Reasons)
Confidential, Rosemont, IL
SQL Server Developer
Responsibilities:
- Wrote various Databases / Schemas / Table Design / Creating Tables / Triggers Views / SP’S / Confidential ’S in MS SQL Server 2012 / 2008 R2 / 2008
- Wrote SSIS packages for ETL, scheduled SSIS packages (Agent Jobs) to populate data from various data sources
- Migrated SSIS packages from SQL Server 2005 to SQL Server 2012
- Worked on creating a cube in MS SQL server 2008 R2 (SSAS)
- Worked on migrating several VB .Net reports to SSRS Reports using B.I.D.S
Confidential, Zurich, IL
SQL Server Developer / Report Writer
Responsibilities:
- Placed by RHT to work on a Contract - To-Hire project for the above company
- Wrote Table / Matrix reports in SSDT / B.I.D.S (MS SQL Server 2012 / 2008 R2 / 2008)
- Process involved creating various Queries / SP’S / Confidential ’S and documenting the reports
- All SQL work was performed using MS SQL Server 2012/2008 R2
Confidential, Chicago, IL
SQL Server Developer
Responsibilities:
- Worked exclusively with SSIS. (SSIS Configuration Table)
- Documented existing SSIS Packages created in MS. SQL Server 2008
- Worked to consolidate 15 SSIS packages into 1 SSIS package, in MS SQL Server 2008 R2
- Process involved creating various Tables / Queries / SP’S / Triggers / Views / Indexes Confidential
Confidential, Springfield, IL
Database Programmer
Responsibilities:
- The project was all new development. (Wild Life Habitat Planning)
- Performed database design (Logical and Physical Model) for this project
- Created Tables and their respective relationships for this project
- Inserted test data in all tables using SSIS Packages for this project
- Wrote various SQL Server Queries / SP’S / Confidential ’S / Triggers / Views Confidential
- All SQL work was performed using MS SQL Server 2008
Confidential, Itasca, IL
SQL Server Developer / Reports Writer
Responsibilities:
- Wrote New / Modified SSRS reports (Table / Matrix reports)
- Wrote SP’S / Confidential ’S to enhance their existing Web Application
- Created SQL Server Agent jobs for alerts
- Tuned SQL Server Queries / SP’S / Views / Triggers / Confidential ’s for performance
- All SQL work was performed using SQL Server 2008 / 2005
Confidential, IL
SQL Server DeveloperResponsibilities:
- Wrote various Queries / SP’S / Confidential ’S, SSIS Packages and SSRS reports
- Supported Data Warehouse Structures (OLAP) & various Data Marts
- Developed mappings, sessions, packages as per mapping documents and business requirements
- Performed Table Design / Created Various Tables
- Wrote New / Modified SSRS reports (Table / Matrix)
- Tuned SQL Server Queries / SP’S / Views / Confidential ’s for performance
- Wrote various Web Pages (Asp.Net / C#)
- Wrote SSIS packages to populate data from various data sources