SQL Server and SSIS Developer Resume

CAREER OBJECTIVE:

Seeking a position as SQL Developer in a highly reputed and professional organization.

SUMMARY:

6+ years of experience in Database development using MS SQL Server and exposure to Business Intelligence tools like SSIS and SSRS.
Expert in database activities like Database creation and maintenance, Performance Tuning, Backup/Restore, Scheduling jobs and Migration.
Excellent T - SQL Developer skills including Stored Procedures, Indexes, Constraints, Views, Triggers, User Defined Functions, and Distributed Transactions to facilitate efficient data manipulation and data consistency.
Experienced in programming tasks using Cursors, Error Handling, Transaction control statements, Merge statements, Common Table Expression (CTE), Ranking Functions, etc.
Expertise in Extraction, Transformation and Loading (ETL) data using various tools including Bulk Copy Program (BCP), Import/Export data, DTS packages and SQL server Integration services (SSIS) to extract data from Oracle, SQL Server and Flat File sources, legacy systems and load into various Business Entities.
Created SSIS packages to perform tasks like Fuzzy Lookup, Fuzzy Grouping, Database Backup, etc. and implemented Error Handling, SSIS Logging in them.
Experienced in generating reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
Exposure to Software Development Life Cycle of the projects with support of Data-Flow and E-R Diagrams, requirement gathering from the clients, documentation of functional and technical aspects of the project.
Working knowledge of Visual Basic.Net and Visual Basic 6.0
Excellent verbal/written communication skills and strong analytical abilities, and can perform well both independently and as a team player.

TECHNICAL SKILLS:

Databases: SQL SERVER 2008 R2/2005/2000, MS-Access, Oracle 9i

T: SQL, Visual Basic.Net, Visual Basic 6.0, C, Unix commands

Operating Systems: Windows 7/XP/2000/9x, Windows NT, Linux

Tools: SSIS, SSRS, Visual Studio 2008/2005, Visual Source Safe, Crystal Reports 9/8.5

WORK EXPERIENCE:

Confidential

SQL Server and SSIS Developer

Environment: MS SQL Server 2008 R2, SSIS, J2EE

Responsibilities:

Designed the database using the concept of normalization and constraints to enforce Entity and Referential integrity
Created SSIS packages to export data from various data sources (Excel sheet, Flat file, CSV file, SQL Server, Oracle) to SQL Server database
Written stored procedures and views to carry out the ETL process
Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases
Performed SSIS tasks like Fuzzy Lookup, Fuzzy Grouping, Backup Database, File System Task, SSIS Logging, etc.

Confidential

SQL Server Developer

Environment: MS SQL Server 2005, SSIS, SSRS, Unix Solaris

Responsibilities:

Written stored procedures to perform the business logic
Created SSIS package to load data from CSV files to SQL Server
Generated reports using SSRS
Shell scripting using basic UNIX commands
Smoke testing performed to check the application flow

Confidential

SQL Server Developer

Environment: MS SQL Server 2005, VB Script, JavaScript, HTML

Responsibilities:

Identified the vulnerabilities in the web pages
Created stored procedures to avoid SQL injection
Modified web pages using VB Scripts to remove Cross site scripting and verbose error messages
User Acceptance Testing of the web pages

Confidential

Visual Basic and SQL Server Developer

Environment: MS SQL Server 2000, Visual Basic 6.0, Crystal Reports 8.5

Responsibilities:

Developed functional modules in Visual Basic 6.0 and Visual Basic.Net
Written business logics using stored procedures and user defined functions
Data consistency maintained through triggers
Created linked server to perform distributed transactions
Generated reports using Crystal reports
Created test cases and executed the unit test plans

Confidential

Visual Basic and SQL Server Developer

Environment: MS SQL Server 2000, Visual Basic.Net, Visual Basic 6.0, Crystal Reports 9

Responsibilities:

Developed functional modules in Visual Basic 6.0
Written business logics using stored procedures and user defined functions
Data consistency maintained through triggers
Generated reports using Crystal reports
Created test cases and executed the unit test plans

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship