Post Job Free

Resume

Sign in

Sql Server .Net

Location:
Newark, DE
Posted:
November 19, 2016

Contact this candidate

Resume:

Shyamala Subbiah

610-***-****

acxkid@r.postjobfree.com

Professional Summary:

* ***** ** ********** ** Microsoft Technologies in Designing, Developing and Implementing Intranet, Internet, client/server applications, web development using Microsoft.NET Framework 4.0/3.5/2.0/1.1, ASP.NET, C#, VB.NET, ADO.NET.

Having extensive experience in all phases of Software Development Life Cycle (SDLC) including Architecture, Requirement analysis, Design, Development, Implementation, Debugging, Testing, Documentation and Maintenance of Client/Server and web based applications.

Having good experience in OOP’s, Caching, Authentication, Windows Services, User Controls (ascx) and Web Custom Controls.

Experience in development and usage of Web Services using WSDL, SOA and SOAP.

Effectively used JQuery a concise JavaScript Library for traversing HTML document, event handling and AJAX interactions.

Experience in Database Analysis/Design/Normalization/Manipulation processes using SQL Server, MS Access, and Oracle.

Extensively worked on stored procedures and user defined functions.

Database Design, Development, and Administration using MS SQL Server, MS Access & Oracle.

Strong knowledge in designing, developing reports using MS-Access, SQL Server 2005/2008 Reporting Services (SSRS), Integration Services (SSIS) and Crystal Reports.

Experience in creating, maintaining and designing database diagrams, setting table relationships and indexes.

Worked in a team environment and also coordinated with business/functional team.

Excellent interpersonal and oral/written communication skills.

EDUCATION BACKGROUND:

Bachelors of Engineering Degree in Electronics and communications (B.E., ECE) from Anna University, Chennai.

CERTIFICATIONS:

Chartered Insurance Institute-CF1 exam

Microsoft .Net Windows application-70536

Cleared various Banking(Both US & UK) domain Certificates

TECHNOLOGY SUMMARY

Technologies

Visual Studio .NET, SQL Server 2000 / 2005 /2008, Crystal Reports (.NET), Windows Communication Foundation (WCF), Web Services, .Net Framework 1.1/ 2.0/ 3.0/3.5, SQL Server Integration Services(SSIS).SQL Server Reporting Services(SSRS)

Languages

C#, VB.NET,ASP.NET 1.1/2.0/3.5, ADO.NET, LINQ, XML, AJAX

OS

Windows (all)

Databases

SQL Server 2000/2005 /2008,Oracle 9i/10i,

Version Control

Visual Source Safe(VSS6.0),TFS, Clear Case

PROFESSIONAL EXPERIENCE:

IKEA, Chennai, INDIA Feb’2014 – Mar’2016

Senior .Net Developer

Client: IKEA is a multinational group of companies that designs and sells ready-to-assemble furniture (such as beds, chairs and desks), appliances, small motor vehicles and home accessories.

Environment: MVC, ASP.Net,VB.Net, C#, Java Script, HTML, DHTML, XML, Windows, Oracle, Clear case, IBM Rational Clear Quest, VS.NET 2012

Responsibilities:

Involved in analysis, design and development of the application

Worked on MVC architecture using Razor Syntax

Involved in loading data from XML files to Database

Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, Data View for consistent access to SQL Server data sources

Developed web pages using VB.NET, ASP.NET,JavaScript,Jquery in Visual Studio .NET 2012

Used Third party controls like Obout and Telerik for better look and feel of the application.

Used JQuery, LINQ queries to avoid postback and increase the performance.

Developed Custom User Controls to reduce the Complexity in User Interface Coding and provide better look and feel.

Used ADO.NET in connecting to Data Access management with Oracle 9i.

Designed and developed complex stored procedures in Oracle 9i

Designed and developed the VB.Net and C# components for implementing business logic which is used to do the transactions on database in middle tier using ADO.NET.

Generated the required reports with the help of data grid.

Developed screens in ASP.NET AJAX-Enabled, C#, VB.Net, ADO.NET to display.

Development and Testing of Web Services (A middle tier application on IIS).

Virgin Media, Hook, UK Feb’2012 – Jan‘2014

ASP.Net Developer/Team Lead

Client: Virgin Media plc is a company which provides fixed and mobile telephone, television and broadband internet services to businesses and consumers in the United Kingdom.

Environment:C#,ADO.NET,ASP.Net,JAVAScript,HTML,XML,CSS,C#,Oracle,SSIS,SSRS,HP-ALM,TFS, HP-ALM IIS6.0, Windows 2003 Server,VS 2010,MS SQl 2008,TFS

Responsibilities:

Participated in architectural design of project.

Prepared Requirement Analysis, functional design, technical specification and cost/time estimation documents for the project

Prototyped the system towards understanding the system requirements and involved the user community at all times

Migration of MS Access front end screens to ASP.Net Application using Visual Studio 2010.

Developed screens in ASP.Net,C# used JavaScript for client side validation

Designed LDAP Authentication, Admin screen to manage User access, Status screen which will display the status of various Data loads in SQL server are the additional features in ASP.Net application as a Value Add.

Designed and created Report templates, bar graphs and pie charts based on the reporting data.

Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.

Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.

Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.

Coordinated with front-end for implementing logic in stored procedures and functions.

Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes for migration of MS Access to SQL Server 2008

Worked on the data loads using SQL Server Integration Services (SSIS).

Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.

Data from various sources like flat files, to SQL Server database Using SSIS Package.

Used Lookups Transformation to get the data from reference data sets

Deploy and Schedule the SSIS packages and Jobs in production

Data migration (import & export/BCP) from MS Access to SQL Server.

Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.

Extensive use of the ADO.NET objects such as Data grids, Data Tables, Data Readers and Datasets for data retrieval and manipulation.

Used Cascading Style Sheets (CSS) for achieving uniformity through all the web pages.

Successfully coded Framework Layer, Data Access Layer, Business Logic Layer, Validation Layer and Presentation Layer.

Worked on configuration and web deployments into SIT, UAT and Production.

Designed user interface screens and implemented application logic under Microsoft .NET framework using C# to use .NET features powered with CLR.

Lloyds Bank, Chennai, INDIA Dec 2008-Jan 2012

Junior .Net Developer

Client: Lloyds Bank plc is a British retail and commercial bank

Environment: .Net Framework, ASP.NET, AJAX, ADO.NET, C#, Visual Studio.NET 2005, JavaScript, XML, SQL Server2005, HP-Service Manager, IBM-MQ Series.

Responsibilities:

Handled L1 Production Support for the developed applications for 300+ applications which includes coded in VB,VBA, MS Access, Win Forms, Classic ASP,Asp.Net Web application

Solved high priority tickets within SLA

Worked on problem Management and change Management requests from clients

Involved in Analysis, design, and development of change requests for C# .Net application.

Created Data access classes, which were used to connect to the database using Microsoft ADO.NET and Data binding concepts where objects such as Data Adapter, Dataset, and Data Readers were used.

Used ASP.NET for building dynamic web pages.

Designed User controls (.ascx) for achieving reusability.

Used Java Script for Client Side validation.

Extensively used Data Grid for sorting, paging,

Implemented Application security using Forms authentication mode.

Developed XSLT for transforming XML into HTML.

Extensively used Page Fragments (User Controls) that require high server resources.

Developed Stored Procedures, Functions and Views.

Used ADO.NET Object Model to interact with SQL database.

Used ADO.NET Dataset object to Cache frequently accessed data, reducing round trips to the database and boost performance.

Handled Run Time Errors & Design Time Errors by implementing appropriate Error Handlers.



Contact this candidate