We provide IT Staff Augmentation Services!

Sql Developer Resume

0/5 (Submit Your Rating)

Dunwoody, GA

SUMMARY

  • Experienced Software developer in software analysis, development, testing and implementation of web and client server applications using Microsoft Technologies in corporate and education industry
  • Experience in design and development of applications using.NET and Web technologies like XML, CSS, Ajax, JavaScript and HTML in n - tier architecture.
  • Hands on in application development using C#,VB Web Forms in ASP.NET using C# as the code behind language and ADO.NET and SQL as the Database Data consumer
  • Experience in IIS, Web Services, WCF, Model View Control (MVC), and LINQ
  • Experience in Telerik KendoUI controls
  • Experience in ADO.NET components such as Data grids, Datasets, Paging, and sorting
  • Experience in SQL development on writing scripts, stored procedures,and SQL reporting service like SSRS,SSIS package
  • Experience in Agile SCRUM methodology to effectively meet project deadlines and production requirements.
  • Completed structured training programs in .NET course
  • Experience with all phases of software Development Life Cycle (SDLC), involved in requirement analysis, designing, developing/implementing, testing and deployment of application.
  • Ability to learn & develop using new technologies quickly.
  • Excellent communication and interpersonal skills.
  • Experience in Agile planning tool RALLY and defect tracking tools like HP Quality Center.
  • Knowledge in S.O.L.I.D principle.
  • Expertise in creating Joins and Sub-Queries for complex queries involving multiple tables.
  • Strong Experience in writing advanced query concepts using having clause, group by etc.
  • Hands on experience in tuningSQLqueries for enhancing the database performance.

TECHNICAL SKILLS

Languages: C#.Net, VB.Net, C, C++, Java

Web Designing: ASP.NET, AJAX, JavaScript, jQuery, HTML, XML, MVC4,T-SQL,CSS,TelerikKendoui

Distributed Technology: WCF, Web Services

Frameworks: .Net Framework 2.0 / 3.5 /4.5

Database Servers: SQL Server /2014

Web Servers: IIS 6.0 /IIS 7.0

Operating System: Windows

PROFESSIONAL EXPERIENCE

Confidential, Dunwoody, GA

SQL Developer

Environment: Sql Server 2008/2014, RALLY, HTML5, XML SQl Server Management Studio,Tortoise SVN,HP Quality Center

Responsibilities:

  • Creation of database objects like tables, views, procedures using PL/SQLDeveloper
  • Involved in SQL Scripting Testing and Implementation
  • Involved in dealing with Financial layer clients policy and facility maintenance
  • Followed Agile scrum Methodology with a sprint of 2 weeks
  • Created stored procedure to implement more efficient means of querying data
  • Used Rally S for collaborative development and version control
  • Involved in reporting, Application Bouncing
  • Built and modified several SSRS reports including critical financial reports and reports used to perform simple data manipulations.
  • Created Cyrstal reports during the project.
  • Developed and Optimized Stored Procedures and Functions using T-SQL
  • Performed analysis to determine data sources and created new reports including several financial reports based on client specifications in Excel/PDF formats
  • Supporting Various applications like UCA
  • Involved in creation of scripts and stored procedures.
  • Worked in Joins and Sub-Queries for complex queries involving multiple tables.
  • Strong Experience in writing advanced query concepts using having clause, group by etc.
  • Hands on experience in tuningSQLqueries for enhancing the database performance.
  • Performed various Production maintenance tasks .
  • Developed batch scripts to schedule file transfers and data exports as requested by the client.Worked on several backend changes to support organizational/policy changes and data updates. Scripts typically involved managing triggers, loading data into temporary tables
  • Worked in a Production Support team, troubleshooting the application and resolving bugs.
  • Worked on urgency per ticket based on provided criteria, triage the situation and respond accordingly
  • Loaded data from flat data files into SQL Server database tables using bcp, bulk insert, and table import
  • Experience in ETL packages using SQL Server SSIS Designer to extract data from flat file and excel file.
  • Worked on client conversions and validation scripts based on mapping documentations.
  • Worked with business analysts to identify and resolve any gaps in the mapping document that defines the transformations to be performed on the client data.
  • Track the defects and bugs found in the code during Unit test in HP QC.
  • Worked on TFS, SVN for version control, source control.
  • UsedSQLProfiler, Execution Plan and Database Engine Tuning Advisor tools to trace the slow running stored procedures and tried to optimize the queries so as to enhance the performance.
  • Provided 24/7 support for production database and also deployed the code in production environment.
  • Perform Unit Testing to check whether the developed code meets the user requirements.

Confidential, Marrieta, GA

.Net/SQL Developer

Environment: NetFramework4.5, VisualStudio2012, MVC4, C#, VB.Net, ASP.Net4.0, JavaScript, T-SQLSql Server 2008/2014, Team Foundation Server, HTML5, Entity Framework.

Responsibilities:

  • Involved in the Design, Coding, Testing and Implementation.
  • Involved in SQL Scripting Testing and Implementation
  • Developed web application using MVC 4 design pattern, Razor as view engine and HTML5
  • Used specific Agile Scrum development methods like iterations, teamwork, collaboration, and process adaptability throughout the life-cycle of the project.
  • Followed Agile scrum Methodology with a sprint of 2 weeks
  • Created stored procedure to implement more efficient means of querying data
  • Used LINQ for building and executing a query expression.
  • Created Model classes to contain and manage data and domain logic.
  • Created various Models to pass information from controller actions to the view templates
  • Extensively used Telerik KendoUIcontrols like Grid, Combo box
  • Worked on Production Support, troubleshooting the application and resolving bugs.
  • Used Team Foundation Server for collaborative development and version control.
  • Attending and co-ordinate with offshore and onshore meetings to discuss the progress of the task assigned and the issue faced.
  • UsedSQLProfiler, Execution Plan and Database Engine Tuning Advisor tools to trace the slow running stored procedures and tried to optimize the queries so as to enhance the performance.
  • Perform Unit Testing to check whether the developed code meets the user requirements.

Confidential

Junior .Net/SQL Developer

Environment: ASP.NET 2008, C#, VB.NET,SQL SERVER 2005

Responsibilities:

  • Involved in Design and Development of database in SQL Server 2005.
  • Developed custom controls and user controls for reusability.
  • Followed Agile scrum Methodology with a sprint of 2 weeks
  • Using C# as code behind for aspx page, maintained Data Access Layer and
  • Business Layer.
  • Develop custom Windows Application and Web application for clients and internal
  • Office based on business requirement using VB.Net, ASP.NET, HTML, java script.
  • Work with ASP.NET Web Forms, State Management, Caching features for
  • Optimization and configuration of the web application using C#.
  • Participate in system documentation, unit testing and database design.
  • Develop and maintain applications, databases and reports which support the organization using C#, SQL Server and SQL

Confidential

Junior software developer

Environment: ASP.NET 2005, C#, SQL SERVER 2005

Responsibilities:

  • Develop N-TIER application in .NET using 3 layer approach .Presentation layer developed using ASP.NET with C# Business Layer developed using C#, and Data access layer developed using ADO.NET in C#.
  • Develop custom Windows Application and Web application for clients and internal office based on business requirement using C#, ASP.NET, HTML, java script.
  • Created stored procedure to implement more efficient means of querying data using T-SQL.
  • Developed package to processes the salary calculation on every month; leave settlement calculation and final settlement calculation.
  • Developed reports to generate pay slip, salary details, salary summary, salary history, employee list, document details etc.

Confidential

Environment: ASP.NET 2005, C#, VB.Net, SQL SERVER 2005

Responsibilities:

  • Interacted with project managers to gather business specifications & prepared design documents (use cases, sequence diagrams) using UML
  • Extensively used Master Pages, Web, User and Custom Controls in developing the front end application
  • Involved in Design and Development of database in SQL Server 2005.
  • Developed custom controls and user controls for reusability.
  • Using VB.NET as code behind for aspx page, maintained Data Access Layer and Business Layer.
  • Used ADO.NET to make necessary communication with backend database (SQL Server 2005).
  • Designed and developed the C# components for implementing business logic which is used to do the transactions on database in middle tier using ADO.NET.
  • Used ASP.Net State Server session management for storing session related data.
  • Written Procedure & Functions for back end in SQL Server 2005, which were called from the ASP scripts through ADO, to do various DML operations.
  • Maintained sessions throughout the portal.

Confidential

Project Trainee

Environment: ASP.NET 2005, C#,SQL server 2005

Responsibilities:

  • Involved in different phases of software development Life cycle (SDLC) including designing, programming, testing, and documentation
  • Involved in Design and Development of database in SQL Server 2005.
  • Using C# as code behind for aspx page, maintained Data Access Layer and Business Layer.
  • Used ADO.NET to make necessary communication with backend database (SQL Server 2005).
  • Designed and developed the VB.net components for implementing business logic which is used to do the transactions on database in middle tier using ADO.NET.
  • Used ASP.Net State Server session management for storing session related data.
  • Written Procedure & Functions for back end in SQL Server 2005, which were called from the ASP scripts through ADO, to do various DML operations.

We'd love your feedback!