EMPLOYEE MANAGEMENT SYSTEM Resume

SUMMARY: Seeking a full - time position as SQL Developer. Experienced in MS SQL Server 2005/2008/2012/2014 and SSIS 2008/2012/2014

TECHNICAL SKILLS :

PROFESSIONAL EXPERIENCE

EMPLOYEE MANAGEMENT SYSTEM

Confidential

Responsibilities:

Designed and created MS SQL tables, index and triggers to create and maintain employee details.
Created end-to-end SSIS Packages to Extract, Transform and Load (ETL) data into Reporting instance.
Error handling in SSMS and troubleshooting using Logging in SSIS.
Executed SQL Task and Data flow tasks to orchestrate the order of execution.
Used Sequence container to execute all the tasks sequentially.
Built parameterized reports and published the reports using SSRS.

Environment: MS SQL Server 2014, MS BIDS 2014, Windows 8 and .net Framework.

e-Inventory Management System (IMS)

Confidential

Responsibilities:

Designed and created MS SQL tables, views, index, procedures and triggers to maintain and track large inventories.
Designed end-to-end SSIS Packages that Extract inventory data using LookUp task and Sequence Container. Used the slowly changing dimension task and its accompanying wizard to load a new dimension.
Error handling in SSMS and troubleshooting using Logging in SSIS.
Created reports using MS Excel.

Environment: MS SQL Server 2012, MS BIDS 2012, Windows 7 and .net Framework.

Intern

Confidential

Responsibilities:

Cluster Ensemble based Pattern matching and real-time monitoring of specimen.
Generated database design to the highest level of scalability and performance.
Developed numerous queries and parameterized reports to collect and present information that satisfied clients and contributed to achieve organizational goals.
Created numerous processes through MS Visual Studio (SSIS) and MS SQL Server 2008 to develop a data warehouse project.

Environment: MS SQL Server 2008, MS BIDS 2008, Windows 7 and .net Framework.