Junior SQL developer Resume

SUMMARY:

1 year of IT experience as Jr SQL Developer with expertise knowledge in Database Management Systems, SSIS & SSRS.
Hands on experience in writing T - SQL queries, procedures, views, indexes and worked on SQL query Optimization and tuning.
Extensive knowledge in creating SSIS packages for ETL purposes.
Experience in designing & developing reports using SSRS.
Sound knowledge and working experience in Agile and waterfall methodology.
Quickly learn and master new technologies. Successfully worked in both team and as individual contributor with exposure to onshore - offshore model.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Microsoft Visual Studio

Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)

Databases: SQL Server 2014/2012/2008 R2

Programming Languages: T-SQL, C# .Net, Java, HTML5.

Development skills: T-SQL, SSIS/SSRS/SSAS.

Operating Systems: Windows, UNIX.

Technologies: MSSQL, MSBI

WORK EXPERIENCE:

Confidential

Junior SQL developer

Roles & Responsibilities:

Involved in complete Software Development Lifecycle (SDLC).
Wrote complex SQL Queries, Stored Procedure, Triggers, Views & Indexes using DML, DDL commands and user defined functions to implement the business logic.
Advised optimization of queries by looking at execution plan for better tuning of Database.
Performed Normalization & De-normalization on existing tables for faster query results.
Wrote T-SQL Queries and procedures to generate DML Scripts that modified database objects dynamically based on inputs.
Created SSIS package to import and export data from various CSV files, Flat files, Excel spread sheets and SQL Server.
Designed and developed different types of reports like matrix, tabular, chart reports using SSRS.
Involved in migration on SQL Server 2012 databases to SQL Server 2014.
Maintained positive communication and working relationship with all business levels.
Coordinating with onshore/offshore & stake holder’s team for task clarification, fixes and review.
Reviewed, analyzed and implemented necessary changes in appropriate areas to enhance and improve existing systems.