Sql Server Developer

VARDA SUKHTHANKER

PROFESSIONAL SKILLS SUMMARY:

Total 10+ years’ experience in IT industry using Microsoft Technology (C#.NET, Oracle 12g,SQL Server 2008)

Experience of working in the complete Software development life cycle involving development, documentation, testing, maintenance and 24 * 7 production support

Worked with Service Oriented Architecture implementation (SOA).

Expertise in Web Applications using C# ASP.NET, MVC, JavaScript, JQuery

Expertise in Desktop Application using C# .NET WinForms and WCF

Good skills in Web services, ADO.NET, XML, XSL, XSLT, IIS, Team Foundation Server and Visual Studio.NET

Have experience working in Agile methodology. Leading the Team during PI Planning, helping business define features and user stories and Estimations

Have strong expertise in writing PL\SQL Queries, Stored Procedures, Packages and in Query Optimization

COMPUTER EXPERIENCE SUMMARY:

Operating Systems:

Windows 2000/98/XP/8

Programming Languages:

C#, ASP .NET, Web Services, WCF, WPF, ADO.NET, .Net 4.5

Databases & Tools:

Oracle 12g, MS-SQL Server 2008, PL/SQL, Spec Flow, Jet Brains

Other Utilities:

IIS 5.0, Visual Source Safe 6.0, Team Foundation Server

PROFESSIONAL EXPERIENCE:

Cognizant Technologies Solutions April 2008 – Present

Client: Petroleum Place Energy Solutions

Team Lead

Developed complex user interfaces with loosely coupled components using CAB (Composite UI Application Block) framework provided by .Net

Implemented core components in C# that handles business logic

Developed key parts of a large, service-oriented enterprise business workflow solution with multiple UI components, including C# ASP.Net MVC

Worked on MVC design Pattern for the rich user interface

Created multiple UI screens using C# .NET WinForms and made use of Events and Delegates for communication between the screens

Extensively worked with .Net provided collections such as Hash tables, Dictionaries and Lists

MVP (Module View Presenter) pattern was used to link the UI logic with the Data and to perform the UI Validations

Dynamic SQL and stored procedures were written for implementing the CRUD operations and validating the data

Experience in RDBMS and Developed Constraints, Join, Views and Triggers

Used XML web services (.asmx) to fetch data from the backend

Logging and error handling mechanisms were implemented throughout the application for robustness.

Implemented agile process (using Scrum methodology) for development

ADO.NET was used to access data from SQL Server 2008

Have a good knowledge in using Configuration management and code management tools (Team Foundation Server, MS Visual SourceSafe, Visual Team Explorer (VS 2005, 2008)

Created stored procedures, functions and triggers in T-SQ

Made use of Data bound controls such as Data Grid, Data List and third-party controls like Infragistics Grid.

Have written Automation Tests using Specflow in C#

Involved in Development and Bug Fixing

Have ensured no slippage in the SLA’s (Resolution, Response and Delivered defects). Avoided most of the recurring incidents by providing one stop solution

Client: Total (A global energy company) September 2007 – March 2008

Project: Batch Jobs (Export, Import and Timer) (Export, Import and Timer)

Role: Developer

Complete development of the User Interface, Business Logic and Database Objects for Export, Import and Timer batch jobs.

Implemented Batch Jobs in Oracle. Involved in every phase of batch job execution (creation, execution and troubleshooting).

Integration of Batch jobs with Other UI applications, completing the whole chain of Gas transportation system.

Client: Comerica Bank May 2007 – August 2007

Project: Comerica AD FlexExport, Import and Timer)

Developer

Involved in development of enhancement and service Requests.

Designed Graphical User Interface (GUI) for various web pages using, HTML, CSS, C#.Net.

Consumed Inbound WCF services / Web Services to integrate with Adjustment report application as part of STP processing using C#.Net.

Wrote T-SQL Queries, Store Procedures, and SQL User Defined functions for fetching X937 record details, their transaction details.

Created and modified multiple reports using SQL Server Reporting Services (SSRS).

As an onsite coordinator, worked with the offshore team - starting from application knowledge transition, providing requirements clarifications, hand-over business request implementation, code reviews, and ensuring good quality and timely delivery of the products.

Prepared Change control, impact analysis and backup plans for new implementations.

Performed root cause analysis (RCA) and provided detailed report on the issues raised.

EDUCATION:

Goa University

Bachelor’s of Engineering in Computer Science from Padre Conceicao College of Engineering (May 2006).

Contact this candidate