Sign in

Developer Sql Server

Pittsburgh, Pennsylvania, United States
March 08, 2019

Contact this candidate


Swapna G

Sr .Net Developer

Experience Summary

Around 9years of experience in Microsoft Visual Studio.Net, system study, design, development and implementation.

Experience in developing multi-tier applications using .Net Framework with ASP.NET, C#, WCF, MVC, Entity Framework, Ajax, JQuery, Java Script, Angular 2, Web API 2, HTML 5.0, CSS, AJAX, JQUERY, Bootstrap and .Net components like LINQ, LAMDA with MS SQL database.

Good understanding of Software Development Life Cycle (SDLC), Agile, Waterfall and Scrum Methodologies which involves gathering the user requirements, analysis, design, coding, implementation, debugging, testing and deploying of applications.

Experience in Object Oriented programming (OOPS).

Strong experience in all the stages of the full Software Development Life Cycle (SDLC).

Significant experience in developing applications using Agile methodologies.

Completely understand the importance of Quality of work in deliverables given to client.

Solid experience in DB design (SQL DDL & DML), procedural programming (stored procedures, triggers), T SQL, Sql Server Performance Tuning, improvement, storage, index.

Experience working on Web API in .NET using REST.

Expert in Database Design, Application Development, Testing, Implementation, Deployments and support of ETL processes for large-scale Data Warehouses using SQL Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS), Power BI and Tableau.

Experience in configuring AutoSys Jobs, Tivoli and SiteScope monitoring tools.

•Proficiency in systems development, support, technical troubleshooting, quality assurance, problem solving, and documentation.

Educational Qualification

Master of Computer Applications.

Bachelor of Computer Applications.

Technical Skills

Programming Languages: C#, VB.NET, VB, C, C++

Web Technologies: ASP.NET, MVC, WCF, Web-services, Razor, WebAPI.

Databases: SQL Server, Oracle 9i, IBM DB2

Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS), Tableau 10, Power BI.

Development Tools: Visual Studio 2003, 2005, 2008, 2010, 2012 and 2015. NET 1.1, 2.0, 3.0, 3.5, 4.0, 4.5, VS Code, SQL server management Studio

Scripting Languages: HTML, DHTML XML, CSS, Java Script, Ajax, VBScript,

Typescript, Bootstrap, Angular2.

Software Engineering: Agile, Water fall.

Testing Tools/Framework: Jasmine, NUnit,

Web servers: IIS.

Configuration Tools: TFS, GIT, SVN, VSS.

Work item Management tools: JIRA

Professional Experience

T-mobile, Seattle, Wa Oct 2018 – Till Date

Sr .Net Developer


Involved in Design of the application & development of applications.

Collected and Documented user requirements and developed application using Agile/Scrum methodology.

Was involved in development and also responsible for deployment to Dev and Test environment using C#.Net, WCF, and Web services, Store Procedures, Function.

Worked with business analysts, project managers, project lead and other developer to design, develop technical design, specs, and coding as part of SDLC.

Developed Web interface using Visual Studio 2015, framework 4.5, C# and WCF.

Was also involved in developing WebApi for the new applications and consuming.

Involved in writing stored procedures, triggers, function, sql job using PL/SQL Server.

Used Entity Framework and LINQ for querying data from the databases and Object collections.

Technical design and documentation.

Generated reports using SSRS and SSIS

Configuring AutoSys jobs and Tivoli alerts to monitor environment.

Application performance improvement.

Production deployments and deployment meeting.

Pre and Post deployment coordination.

Providing support to L2 and L1 teams.

Application performance monitoring through Tivoli.

Production issue discussion and providing technical solution.

Helped in setting up Test Driven Development (TDD) in writing Unit Test cases for the developed code.

Environment: C#.Net, WCF, Entity Framework, LINQ, Visual Studio 2015, framework 4.5, TFS, Razor, IIS 7.0, ASP.NET MVC5, SQL Server 2008, JavaScript, Entity Framework 5, NuGet, JSON.

Cincinnati Bell Telecom, OH Aug 2015 – Oct 2018

Sr .Net Developer


Involved in design and developing web applications in .NET framework 4.5 in C#

Responsible for the design of the database, design of the entity model, implementation of the business rules and implementation of a WCF based service layer.

Involved in consuming and developing Web Services internal and external.

Was also involved in developing WebApi for the new applications and consuming.

Developed GUI user interface and built reliable C# code by using Object Oriented programming concepts.

Deploying codes along with development team so that they will be familiar with changes that are getting deployed to the production

Handling complex inquiries raised by customers from various sources and solving production issues.

Create stored procedures to access and manipulate data using SQL Server 2012.

Also involved with designers to work through the early stages of a designing and product working strategy.

Responsible for writing the unit test and technical document for all the developed and enhanced code.

Helped in setting up Test Driven Development (TDD) in writing Unit Test cases for the developed code.

Involved in developing an effective build automation, continuous integration and unit test environment that reduced integration issues and improved code quality.

Successfully followed agile methodology steps starting from requirement to deployment for the delivery of the software using Scrum.

Environment: Agile, TFS, .Net Framework 4.5, Razor, IIS 7.0, Visual Studio 2013, C#, ASP.NET MVC5, ADO.NET, SQL Server 2012, PL/SQL, Jenkins, JavaScript, Entity Framework 5, LINQ, Lambda, Fiddler, NuGet, JSON, TDD.

Convergys (NetCracker Technologies Ltd), India Jan 2012 - Oct 2013

Sr .Net Developer


Prepared Technical and Functional specifications from the requirements discussed with the client and the development of the same.

Developed Web Forms using C# and ASP.NET.

UI enhancement of the product.

Used methods using WCF Services.

Creating tables in sql server, developing stored procedures, cursors.

Wrote triggers for sending Emails to clients after transactions.

Worked on exporting to Excel from grids.

Deployment of Application on Test and Production Server.

GUI design using Master Pages, Site Map, Data Grid View, Tree View Controls

Used AJAX.Net to improve the performance of the application.

Developed SSIS,SSRS reports

Bug-fixes, enhancements and deployment.

Analysing the issues related to ad hoc reports and fixing them.

Maintenance and customization of the product.

Code merging activity for the product.

Implement enhancements and change requests

Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.

Developed universe user documentation guide for the end users’ reference

Involved in the complete implementation of the project (Development, Testing & Migration

Environment: .NET Framework 3.0, ASP.NET, Web Services, SOAP Messages, C#. NET, Visual Studio .NET 2005, JavaScript, IIS, HTML, Crystal Reports, SQL Server 2005

NCR Corporation Ltd, India. Feb 2009 - Jan 2012

.Net Developer


Designed web forms for Address Book interface in ASP.NET using ADO.NET, Data Grid and Data list controls.

Validation was done using validation control in ASP.NET.

Used Seagate Crystal Reports to develop tool reports for performance management.

Participated in the whole life cycle of the project including design phase of the project, which was designed using ASP.NET, C# and Web Services.

Developed the front-end screens using Web forms. Analysis of the specifications provided by the clients.

Involved in requirement gathering, functional and technical specification.

Used 3-tier architecture for presentation layer, Business and Data Access Layers using C#.

Coding and debugging using ASP.NET and C#.

Developed web forms using ASP.NET server controls and validated client side using Java Script.

Used ADO.NET objects such as Data Adapter, Data Reader and Dataset for consistent data access.

Writing Database routines, stored procedures and fixing up standard specifications.

Creating reports using the Crystal Report for the report needed by Middle Office, Back Office users. Testing using Nunit testing.

Environment: .NET 3.5, ASP.NET, C#, SQL server, WCF, Windows XP

3i Infotech, India Aug 2007 - Jan 2009

.Net Developer


•Involved in developing effective web forms based on technical design and requirement specifications.

•Incorporated Authentication and Authorization on Web Forms in Web.config file and access privileges are provided as per the user credentials.

•Involved in the development of Data Access layer, Business layer and Application layer (user interface) of the 3-tier architecture web application using C#. NET, ADO. NET and Asp. NET.

•Implemented ASP.NET View state and Session state to store and transfer data within same pages and to other pages.

•Used ADO.NET Components to connect to the database server for data retrieving, querying, storage and manipulation.

•Used ASP.NET Web Server controls like Grid View, List View and Repeater for displaying the records.

•Developed stored procedures in T-SQL for backed communication.

•Analyzed, designed, and implemented changes requested.

•Used WinCVS for version controlling and to keep source-code safe.

•Well experienced in writing Function, Views and generated Crystal Reports.

•Deployed application to IIS server.

Environment: .NET Framework 2, ASP.NET, C# .NET, XML, CSS, Windows XP, WinCVS, Crystal Reports, IIS.

Contact this candidate