SQL Developer Resume

SUMMARY

Complete 4 years of experience in the software industry. I have been a part of Development, Supporting and Testing. I am proficient in MS SQL Server; Microsoft Business Intelligence tools SSIS, SSRS.
Extensive experience in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services (SSIS).
Proficiency in Creating T - SQL Queries.
Developed, Modified Stored Procedures,Views and other Statements to Handle Complex Buisiness Rules.
Experience with Various Tasks and Containers in SSIS Control flow.
Created Configurations to change the Packages Properties Dynamically.
Experience in managing SSIS packages execution, Applying security and deploying packages to servers.
Experiencing with reports life cycle.
Implementing various types of report execution techniques.
Working with parameters and applying filters on reports.
Maintaining shared schedules, Snapshot history.
Designed Different Types of Reports Like Drill Down, Drill Through, Sub Reports and Parameterized Reports.
Experience on creating Data Sources.
Scheduled Reports Weekly and Monthly Basis as per the client requirements.
Having Knowledge on SSAS.

TECHNICAL SKILLS

Technologies: Microsoft Business Intelligence Tools (MSBI), SQL SERVER Management Studio (SSMS)

Operating Systems: Windows XP, Windows 98, Windows 7.

Databases: SQL Server 2008.

ETL Tools: SQL Server 2008 Integration Services.

Reporting Tools: SQL Server 2008 Reporting Services.

PROFESSIONAL EXPERIENCE

Confidential

Software Developer

Environment: SQLServer 2008

Responsibilities:

Understanding the Functional Requirements of the customers.
Understanding the technical aspects of the project.
Created Complex Stored Procedures,Indexes,Joins and other T-SQL Code to Implement Buisiness rules.
Developed reports as per requirements by using SSRS
Developed SSIS packages as part of Integration with other systems like Payroll and Timesheet and Exit applications.
Optimized the stored procedures for executing in minimum time.
Solved the critical issues within SLA.
As a developer, was responsible enough to take care of implementation of Change Requests received from the Customers.
Delivered all the change requests as per scheduled time period given by the customers.

Confidential

Software Developer

Responsibilities:

Extracting data from multiple sources like flat files and SQL server and transforming, cleansing, validating data and loading into final Destination.
Designed packages Using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, and Data Flow Task.
Extracted data from sources and transformed the data using different transformations like data conversion, derived columns, look up, Conditional Split, Aggregate, Union all, merge join and multi cast transformations.
Created Event Handlers for the Packages Using Event Handler Tab for Error Handling.
Created Configurations to change the package properties dynamically.
Maintained log information in SQL table to tracking Errors and recording package execution status.
Build and Deployed packages to SQL server and Scheduling Packages for Intra Day and End of Day execution.
As per requirements developed the reports in the form of Matrix, Table and Chart using SQL Server 2005 Reporting Services.
Designed Different Types of reports like Drill Down, Drill Through, Sub Reports and Parameterized Reports.
Development of reports using different SSRS Functionalities like sort prompts and cascading parameters, Multi Value Parameters.
Scheduled Reports Weekly and Monthly basis as per the Client Requirements.

Confidential

SQL Developer

Responsibilities:

Involved in Creation of tables, indexes, sequences, constraints, triggers and procedures.
Written triggers, stored procedures and manipulated the data using DDL and DML functions.
Migrated the data (Import & Export of data) from one server to other servers using tools like Data Transformation Services (DTS)
Involved in the Performance analysis of SQL Server databases using SQL server 2005 and tracing.
According to the business requirements made the documentation of the performed tasks.