SQL Server Developer Resume TX - Hire IT People

SUMMARY

Over 6 years of experience in professional application and database development with thorough development, documentation, deployment and system support.
Experience in designing of database in SQL Server 2012, 2008.
Hands on experience in writing T - SQL queries, Stored Procedures, User Defined Functions (UDF), Views and Triggers.
Knowledge of Transact-SQL (DDL, DML and DQL).
Advance knowledge in RDBMS concepts, logical/physical data models.
Able to install, upgrade and configure of Microsoft SQL Server and Databases.
Experience with ETL Tool: SQL Server Integration Services (SSIS).
Experience in data migration of Data from different database platforms.
Experienced in designing Data Model and Building reports using SQL Server Reporting Services (SSRS) and Report Builder, report server and report manager.
Hands-on experience with scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger.
Knowledge in building cubes via SSAS.
Strong analytical, problem solving and troubleshooting skills.
Able to work collaboratively, quickly understand system architecture and business needs while committed to achieving corporate goals.
Good verbal and written communication skills. Positive attitude towards superiors & peers.
Ability to work independently and in large team environment.
Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

Database Technologies: MS SQL Server 2012/2008

Languages: SQL, T-SQL, PL/SQL, XML

BI Tools: SSRS, SSIS, SSAS

Operating Systems: Windows NT/2000/XP/Vista/Window 7

PROFESSIONAL EXPERIENCE

Confidential, TX

SQL Server Developer

Responsibilities:

Creating database, functions, triggers, stored procedures, views, tables, packages and TSQL script for application and to meet the requirements of the business users.
Installation and Configuration ofSQLServer 2012.
Designed SSIS packages/jobs to migrate and transform data from legacy database system.
Used various Control Flow and Data Flow tasks, like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Columns, to transform and load data using SSIS.
Actively participated in creation of logical database model, physical database design and implementation of large database models.
Migrated data across different data sources and SQL server environments.
Testing data / stored procedures with complex queries, correlated sub queries and joins.
Created log shipping on servers for backup, copy and restore transaction logs.
Created packages to migrate data from different data sources to data warehouse
Created packages for database protection and applied Security roles/permissions to the database users.

Environment: MS SQL Server 2012, SSIS, T-SQL, Windows XP / 7

Confidential, Madison, WI

SQL Server Developer

Responsibilities:

Created reports using SSRS from OLAP and OLTP data sources and deployed on the report server.
Used SQL Server Reporting Services to developed reports.
CreatedSQL Jobs and SSIS packages on SQL Server 2008 to load and transform data between source/target
Migrated data from SQL Server 2005 to SQL Server 2008.
Migrated data from MS Access 07 database toSQLserver 08 database.
Created stored procedures which were being used as queries in the access front end.
Created cubes using SSAS
Created user defined function which would later be usedforcreation of data models.
Worked on laying a foundationforcreation of data warehouse, and created fact and dimension tables.

Environment: SQL Server 2008/2005, SSIS, T-SQL, MS Excel, MS Office

Confidential, Baton Rouge, LA

SQL Server Developer

Responsibilities:

Created and maintained databases for Development and testing Environments using SQL Server 2005.
Created and Modified complex stored procedures, and functions.
Developed SSIS packages to extract and load data between source and targets, applying business rules.
Migration of database from SQL Server 2005 to SQL Server 2008.
Updated the VSS for version control, and granted permission/roles to the users.
Involved in the complete life cycle of the project. Conducted unit and system testing.
Worked with vertical team, Business Analyst, Business Logic, User interface.

Environment: MS SQL Server 2008, SSIS, T-SQL, Windows 2000 Advance Server.