Sql Server .Net
Resume:
SUPRATIK GUPTA
**************@*****.***
SUMMARY:
• About 9 years of IT experience with exceptional skills in Analysis, Object Oriented Design, Development and Implementation of Web Applications and Windows Applications using ASP.NET, Silverlight 3.5, WPF, MVVM, MVC, WCF, UML and Web Services.
• Hands on experience in development and implementation of high end applications with Microsoft .Net Framework 1.1/2.0/3.5/4.0, Visual Studio 2010/2008/2005.
• Expertise in Microsoft .Net technologies C#, ASP.NET, VB.NET, ADO.NET, Web Services and Windows Communication Foundation (WCF) and WPF, Telerick Rad Controls .
• Good work experience in MS SQL Server 2008/2005/2000 and Oracle 11g/10g/9i. Knowledge in developing stored procedures functions and triggers using T-SQL and PL/SQL.
• Solid knowledge and experience with Web Forms, LINQ, CSS, AJAX, IIS, JavaScript, UI design and development, consuming and manipulating data using ADO. NET.
• Proficient with WCF, Web Services using WSDL, SOAP and UDDI.
• Extensive experience with process modeling using UML, Flow charts, Sequence diagrams, Activity diagrams and Use cases by using tools like MS Visio and Rational Rose.
• Experience in web development using HTML, XHTML, DHTML, XML, XSD, X-Path and XSLT.
• Expertise in Design and Development of User Interfaces, User Controls and Custom Controls using ASP.NET and C#.
• Strong working knowledge in development and usage of WCF.
• Hands on experience in reports development using SQL Server Reporting Service (SSRS) and Crystal Reports and experience in developing integration packages using SQL Server Integration Service (SSIS).
• Hands on experience in creating content driven and user-friendly application using WPF and Silver light.
• Extensive knowledge of C# object oriented programming language concepts like Abstraction, Polymorphism, Inheritance and Encapsulation.
• Experience in design and development of applications using N-Tier Architecture.
• Experience in implementing .NET Security features like Authentication and Authorization using Forms- based and Windows-based Authentication, Authorizing Users, Roles and User Account Impersonation.
• Good Experience in database development in creating complex database Queries, Views, Stored Procedures, User Defined Functions, Cursors and Triggers.
• Experienced and fully engaged in Software Development Life Cycle (SDLC) which includes gathering and analyzing business requirements, functional/technical specifications, designing, developing, testing, deploying the applications, and providing production support.
• Experience in testing tools like N-Unit, Microsoft Testing Tools.
• Implemented AJAX functionality to improve the responsiveness.
• Involved in developing and organizing Custom Error pages and Exception Handling.
• Implement code version maintenance/tracking using Microsoft Visual Source Safe (VSS) and Microsoft Team Foundation Server (TFS).
• Experienced in methodologies like Agile, Waterfall and Scrum.
• Proven ability to analyze problems, root causes, and develop innovative solutions to business challenges and streamlining operations.
EDUCATION: B.S in Engineering
TECHNICAL SKILLS:
Languages
C#, VB.NET, C++, C, SQL .
.Net Technology .Net Framework 4.0/3.5/3.0, C# 3.5/3.0/2.0, Silverlight 3.0/ 4.0, AJAX, WPF, WCF, SOAP, SOA, LINQ, WSDL.
Web Technologies ASP.NET, HTML, XHTML, DHTML, CSS, ASP, VB script, XML, XSL, JQuery, JavaScript
Database SQL Server 2008/2005/2000,
IDE Tools Visual Studio 2012/2010 /2008/2005, ExpressionBlend. Operating Systems Windows 7 64bit / Windows Vista/ XP/2000, Windows Server 2003/2008, PROFESSIONAL EXPERIENCE:
Barclays Capital. November 2015 to current
New York, New York
The ICE application is using by Market risk analysts for evaluating market risk data. Application generates report market risk data based on available risk dates. The report data contains notional estimated information of market risk and analysts can view the report data by applying filtering on various components and transformation details for better evaluations.
The Excel Add-in component provides the facility to run reports directly in excel sheets by using function UDFs. Without interacting with UI, Analyst uses this Excel add-in for report generation using Excel User defined canned functions. The web based tool supports all the features of Ice client GUI.The risk analysts deals with the business logic layer of various domain including Capital Markets, including quantitative finance, valuation methodologies, cross asset product knowledge, risk management, regulatory, settlement, trading, accounting, market and reference data management.
• Participated in a fully scalable Asp.Net based client application using C#, WCF, Entity Framework and SQL Server.
• Wrote T-SQL scripts for management and maintenance of application databases.
• Created reports using DevExpress Reporting controls.
• Worked with business stakeholders for the application and provided technical insight to business analysts to complete the application functional specification.
• Designed GUI using C# and Asp.Net.
• Designed and coded Business logic and Database layers in C#, XML .
• Involved in Database design using SQL, wrote Stored procedures, triggers etc.
• Developed APIs / Libraries in C# and COM.
• Actively involved in coding and designing ASP.NET Master Pages, Themes, and Skins.
• Developed modules by applying Object Oriented Programming techniques using Polymorphism, Encapsulation and Inheritance.
• Involved in GUI design using Login Controls, Microsoft Menu Control and client side validation is done by Ajax validation extenders.
• Used LINQ to retrieve information from the XML data files and various data sources. Environment
Net Framework 4.0, C#, XML, ASP.NET 3.5, MVC, Visual Studio 2015, Object Oriented Design, AJAX concepts, multi- tiered architecture, Spring.net,
Lenovo Inc,
Morrisville, NC Jan 2015 – Aug 2015
Lenovo Companion / Prism project is preloaded application that comes with new Lenovo system. The application is used for managing Lenovo system health, configure software updates, access Lenovo Support forums and knowledge base, find customized accessories and check the status of warranty. This app is filled with exclusive Lenovo content to help learn about new system. User will also find quick-reference “how to” articles on everything from extending battery life to setting up Bluetooth. And stay up-to-date on technology news with articles and blogs from trusted sources. . The new version of Companion combines both Lenovo Support and Lenovo Companion apps into one. There are three main sections in Lenovo Companion: My System: On select PCs and tablets, user will be able to configure how to handle critical updates from Lenovo for your specific device. Lenovo Exclusive: Provides with tips to help you get up and running quickly with both your device and Windows 8.1 Tech News: The section where you can read the latest technology news and blogs from trusted sources and partners.
Responsibility
• Worked with Script Manager and Update Panel in AJAX Server Control to develop the GUI and
• Involved in implementing AJAX controls to reduce the server trip while modifying Grid View data.
• Worked with data grid controls.
• Provided a concrete explanation of resolutions to issues, inquiries and requests.
• Managed to works in group and independently on side projects.
• Provided feedback and developed production support standards and policies.
• Used Ajax control tool kit controls to minimize postbacks to the server and enhance user experience. Used Angular JS for UI enhancement .
• Used .NET master pages, themes, Validation controls, Content place holders, CSS 3, HTML 5 and Web Forms for UI development in Test Driven Development.
• Involved in Design, Development and Testing of Web Forms and Web Services using IIS, ASP.NET and .NET Framework
• Used ADO .NET for database connectivity and populated back-end data using SQL Server 2008.
• Actively involved in coding and designing ASP.NET Master Pages, Themes, and Skins.
• Developed modules by applying Object Oriented Programming techniques using Polymorphism, Encapsulation and Inheritance.
• Involved in GUI design using Login Controls, Microsoft Menu Control and client side validation is done by Ajax validation extenders.
• Used LINQ to retrieve information from the XML data files and various data sources. Envirnment
Net Framework 4.0, C#, ASP.NET 3.5, Visual Studio 2015, Object Oriented Design, AJAX concepts, multi-tiered architecture, UML (Class/Sequence Diagrams), SQL, Telerik ASP.NET AJAX UI Controls, Spring.net, EBay Inc.
Salt Lake City, Utah July 2014 – Dec 2014
Ebay’s CTE application is a WPF application for its customer care representatives. It’s a tool for communicating with customer or other employees via phone, chat, or email which means this application has its own 5 User Interfaces namely Phone-in, Phone – out, Chat, and Email In and Email out .Its exposed to communication servers like Siebel and Genesis. It’s loaded with features outbound phone, Phone outbound verification flow, Access to AD from CTE, Automatic Login to CSKB, Account Search, Support for Inbound call, CallMe, In-queue Call Back, Phone verification processes, Support for transfers and other phone use cases – placing on hold, hanging up call, MDI – member dissatisfaction index (AKA MCA – multi– contact alert), Pinning Functionality and associated mapping (page –to- topic) . RESPONSIBILITIES:
• Developing the presentation layer using WPF and communicate to business layer using Windows Communication Foundation technology.
• Monitoring application performances and providing recommendation to improve performances.
• Redesign and restructure the existing application according to quality control team’s recommendation.
• Used Microsoft .Net framework ( 4.0) and C# to develop multi-tier web applications
• The project involved MVVM, MEF, and Prism and Unity framework, dependency Injection .
• Involved in complete Life Cycle including Analysis, Design, Development and Testing.
• Analyze new business requirements that come up and find solutions to complex problems arising out of dynamically changing business needs.
• Accessing, retrieving and committing application to source control SVN Tortoise . Environment:
Windows Presentation Foundation, C#, MS SQL server 2008, Prism and Unity, GitHub, Windows 7 64 bit
Farmer’s Mutual Hail Insurance Company of Iowa, Des Moines July, 2013 – July 2014
.NET Developer
FMH provides crop insurance in 15 Midwestern states, and maintains a Reinsurance Department for accepting risks from both domestic and international insurance companies. CloudNet is FMH’s next generation crop insurance policy administration system. Cloudnet focus on several key functions of the new system including Policyholder and Policy Management, APH/Production Reporting, Acreage Reporting, and Mapping and Output, including Reports. Cloudnet project includes features like Policy structure will be at state level, More editing within the system for less review, Reduction in number of application/amendment forms, Ability to share policyholder data; land, SBI, party(entity) data, Crop Fire will be administered in CloudNet, Policyholder output such as Bills, Dec Pages will be automatically generated on specific dates within the system .
RESPONSIBILITIES:
● Planning, developing and documenting Project application for Cloudnet Project at Farmer’s Mutual Hail Insurance
● Developed Custom Controls and Navigation controls using C# and configured the caching policies.
● Designed, developed and implemented project using 3 tire architecture.
● Developed web pages using ASP.NET3.5 for eFile administration to report all the information regarding the tax filing centers, tax preparers and return details.
● Used .NET Master Pages, Validation controls, Content place holders, themes, CSS and Web Forms for UI development.
● Developed Master pages to build consistent and maintainable user interface.
● Performed extensive Data Binding with various Server Controls like Grid View.
● Worked with Script Manager and Update Panel in AJAX Server Control to develop the GUI and
● Involved in implementing AJAX controls to reduce the server trip while modifying Grid View data.
● Worked with data grid controls.
● Used Ajax control tool kit controls to minimize postbacks to the server and enhance user experience.
● Used .NET master pages, themes, Validation controls, Content place holders, CSS and Web Forms for UI development.
● Involved in Design, Development and Testing of Web Forms and Web Services using IIS, ASP.NET and .NET Framework
● Used ADO .NET for database connectivity and populated back-end data using SQL Server 2008.
● Actively involved in coding and designing ASP.NET Master Pages, Themes, and Skins.
● Developed modules by applying Object Oriented Programming techniques using Polymorphism, Encapsulation and Inheritance.
● Involved in GUI design using Login Controls, Microsoft Menu Control and client side validation is done by Ajax validation extenders.
● Used LINQ to retrieve information from the XML data files and various data sources.
● Extensively worked on SQL stored procedures, functions and Triggers to Create and modify existing tables and stored procedures in ADO.Net and tested them on testing and production servers. Environment:
Net Framework 4.0, C#, ASP.NET 3.5, Visual Studio 2012, Object Oriented Design, AJAX concepts, multi- tiered architecture, UML (Class/Sequence Diagrams), SQL, Telerik ASP.NET AJAX UI Controls, Spring.net, iBatis.net, Silverlight, WCF, NUnit, Log4net, MSMQ, Perforce SCM, Oracle 11g, IIS 7, MVP Design Pattern, JQuery, Validation Framework, NServiceBus, Windows Services Compass Group USA, Charlotte, NC Feb’2013 – July 2013
.NET Developer
Webtrition is a web-based proprietary ingredient, recipe and menu management solution from Compass Group. Each ingredient is linked to our preferred product and contains up-to-date costing. This allows chefs and managers to manage production, yield and waste. Best-in-class recipes are built and tested by culinary teams, validated by nutritionists and then utilized to build menus that meet client and customer needs.
Customizable, stream-lined signage and customer-facing websites are powered with the menus and nutrition information. Webtrition’s centralized database helps ensure recipe quality, reliable nutrition data and production management features that result in increased sales and customer satisfaction. RESPONSIBILITIES:
• Developing the UI layer using ASP.NET 3.5 and Javascript Library, CSS HTML, CSS, XML,UML, XSL, JQuery and communicate to business layer using Windows Communication Foundation technology .
• Accessing SQL Server 2008 using WCF, SOA, LINQ.
• Monitoring application performances and providing recommendation to improve performances using .
• Redesign and restructure the existing application according to quality control team’s recommendation ASP.NET 3.5, Ajax, Jquery 1.8.3, Telerick Rad Controls .
• Developed stored procedures for efficient transactions between database and Entity Framework.
• Redefined exsisting stored procedure and monitor their performance using sql profiler to minimize dirty reads, deadlocks
• Used Microsoft .Net framework ( 4.0) and C# to develop multi-tier web applications
• Involved in complete Life Cycle including Analysis, Design, Development and Testing.
• Analyze new business requirements that come up and find solutions to complex problems arising out of dynamically changing business needs.
• Accessing, retrieving and committing application to source control TFS . Envirnment :
Asp.Net 3.5, JavaScript, C#, MS SQL Server 2008, Resharper, Dot net 4.0, TFS, CSS, Windows 7 64 bit
AccessData LLC, San Francisco, CA May 2011 - Dec2012 AccessData Group has pioneered digital investigations and litigation support for more than twenty years and is the maker of the industry-standard computer forensics technology, FTK, as well as the leading legal review technology, Summation . The main task was to prepare Silverlight and WPF based Legal- domain applications under Prism and Unity framework . The end users of this application is law professionals, law firms and paralegals . Main responsibility include develop WPF based wizard which can interact with the main Silverlight Application for interaction of parent and child document repository, Work with the architecture team to implement best practices and design patterns, creating a service layer which can interact with UI and the backend.
RESPONSIBILITIES:
Responsible for requirement gathering from the End-Users and Business Analyst to develop the application and to modify the existing code
Implemented n-tier architectural design pattern
Developed Service Oriented Architecture (SOA)
Implemented Model-View-View Model (MVVM) design pattern Implemented ICommand interface for zero code behind Created Dependency Properties and Routed events in C# and Implemented Styles, Triggers in XAML using VS.NET2010, Blend and Telerick Rad Controls
Implemented asynchronous calling mechanisms to isolate the UI processing with the backend data base call processing
Coded in Presentation Layer, Business Logic layer and in Data Access Layer of the application Developed custom Classes and Business Objects to serve as the Model object Developed Smart Client Presentation Layer using WPF Controls, Windows controls, .NET3.5/4.0, VS.NET2010, C#, XML and XAML. Created custom styles templates, Resource files using Expression Blend. Developed Views using WPF User Controls and Telerik Tools Developed User Controls and Custom Controls Standard Library for the Client Control Repository Used Static Resources and Application Resources for binding different controls Developed custom Classes and Business Objects to serve as the Model object Used Enterprise Libraries (Application Blocks) and ADO.NET for connecting to the database Used LINQ and Lambda Expressions for iterating through collections in .NET Extensively worked on the Web Services and WCF services for retrieving the data Developed User Controls and Custom Controls Standard Library for the Client Control Repository Used XSLT and XML Gen for iterating through the XML object and for generating XML Validated the XML files against custom Data Contract objects. Modified n- layered applications which constitute Presentation Layer, Business Logic Layer and Data Access Layer as per the business requirements.
Created Complex Stored Procedures for retrieving the data from the SQL Server database to fill the Business Objects
Performed n-Unit testing for different modules in the application to ensure a bug-free code in to Production
Analyzed the performance of the application by using Diagnostics class, ANTS profiler Environment: .NET Framework 4.0 Visual Studio.NET 2010, C#.NET, MVVM, n-Unit Test, WPF, CSLA 3.0, HL7 Standards, HIPAA, Expression Blend3.0, Web Services, LINQ, Lambda Expressions, ANTS Profiler, Team Foundation Server, SQL Server, SSRS, Power Tools, Windows 2008, Agile(Scrum) Charles H Mack & Associates, Cincinnati, OH Feb’11 – April ‘11
.NET Developer
The company provide Silverlight based healthcare applications to insurance companies like WellCare Health Plans Inc. Main responsibility include develop common controls used on multiple pages and extend existing controls as necessary, Work with the architecture team to implement best practices and design patterns, creating a service layer which can interact with UI and the backend. RESPONSIBILITIES:
• Involved in User Requirement analysis and Review of Business Requirements from Functional Architects and development of the project using the Scrum methodology.
• Involved in designing the application using the N-Tier SOA Architecture.
• Delivered complex WCF & Web Service solutions for the existing SOA (service oriented Architecture).
• Responsible for developing WCF Services to retrieve and send information from client side without Post Back and consuming the existing Services.
• Responsible for designing web pages using HTML, ASP .NET, C#, CSS, AJAX and Java Script.
• Worked with Script Manager and Update Panel in AJAX Server Control to develop the GUI and involved in implementing AJAX controls to reduce the server trip while modifying Grid View data.
• Worked with data grid controls.
• Used ADO .NET for database connectivity and populated back-end data using SQL Server 2008.
• Actively involved in coding and designing ASP.NET Master Pages, Themes, and Skins.
• Developed modules by applying Object Oriented Programming techniques using Polymorphism, Encapsulation and Inheritance.
• Involved in GUI design using Login Controls, Microsoft Menu Control and client side validation is done by Ajax validation extenders.
• Used LINQ to retrieve information from the XML data files and various data sources.
• Extensively worked on SQL stored procedures, functions and Triggers to Create and modify existing tables and stored procedures in ADO.Net and tested them on testing and production servers.
• Involved in Unit Testing for the complete system.
• Implemented code version maintenance/tracking using Microsoft Team Foundation Server 2008. Environment: .NET Framework 3.5, C# .NET, ADO .NET, ASP .NET 3.5, SQL Server 2008, IIS 7.0, AJAX Toolkit 3.0, XML, Microsoft Visual Studio 2010, HTML, WCF, Microsoft Visual Source Safe (VSS) later upgraded to Microsoft Team Foundation Server 2008, SSIS and JavaScript. Peets Coffee and Tea, San Francisco, CA Oct ’08 – Nov ’10
.NET Developer
Project is about interfacing Peets Coffee & Tea ERP System to Microsoft Dynamics AX Server (DAX).Pay roll Detail flat files in various formats like ‘ACH’ & ‘Positive Pay’ from Wells Fargo bank will be validated, parsed and sent as Journal transactions to DAX Server. Involved in writing Business logic components in C#, developing the user interface for Retail Business, Order Management and writing SQL stored procedures, UDFs, triggers and executing SSIS data packages in SQL Server 2005 RESPONSIBILITIES:
• Used various Silverlight controls such as Button, Calendar, Ellipse, GridPanel, Image, ListBox, MediaElement, ScrollViwer, Slider etc., in designing the UI interface.
• Experienced in Microsft Unified Communicaiton Managed API.
• Designed and developed user controls for accepting customer inputs and presenting records/results to customer using ASP.NET.
• Involved in architecture and development of Custom Controls and User controls to support shared functionality of displaying Customer details common to all pages.
• Used .NET Master Pages, Validation controls, Content place holders, themes, CSS and Web Forms for UI development.
• Used WPF to create rich clients.
• Implemented Service Oriented Architecture using Web Services plugged in to each layer.
• Used Generics for creating object collections in C#.
• Developed User and Custom Controls with Event handling mechanism.
• Extensively used the LINQ feature in .NET 3.5 for querying collections and integrating with SQL.
• Used HTML, XHTML, DHTML and JavaScript for rich User Interface experience and validation.
• Used AJAX Control toolkit and AJAX Update panels.
• Used various features like Partial classes, Anonymous types, Read-Only Properties, polymorphism and inheritance of C# 2.0/3.0 in building data entity model.
• Used .NET Serialization techniques for performance.
• Used various Reflection techniques for dynamic loading of assemblies.
• Developed Java script code & Leveraged Java script debugging feature in .NET 3.5.
• Used ADO.Net for data accessing in the data access layer in n-tier application.
• Used SQL Data Adapters & Datasets extensively for database activity in .NET.
• Used Session state and Cookies for web development and security.
• Used Team Foundation Server for task/bug assignment and Source controlling the code.
• Used Windows Communication Foundation (WCF) for creating Service end points and Service contracts in code.
• Implemented Cancel and Compensation handlers in writing Work Flow using WWF.
• Responsible for creating complex stored procedures, views and packages in SQLSERVER 2005.
• Used Mercury Quality Test Center for logging and downloading test scenarios and results.
• Used SQL Profiler to resolve Dead- Lock Issue in the Project.
• Used SQL Server Notification Services in SQL Server 2005.
• Used MVC Consultant for better clarity of vision and purpose.
• Generated reports in SSRS 2005 for revenue generation and Notifications.
• Developed SQL SERVER 2005 SSIS Data packages that extract/manipulate data from Flat files and store into Database and vice versa.
• Used XML, XSLT and XSD extensively for Data manipulation activities.
• Used Windows Share Point adapter and InfoPath to log Exception Documents.
• Written N Unit scripts for assertions in Unit testing.
• Responsible for developing code and elevating to UAT and production on strict deadlines.
• Involved in creating Technical, Functional specifications and change requirement documentation. ENVIRONMENT:.NET Framework 3.5, C#, ASP.NET,VB.NET, Smart Client, AJAX, XML, XSL, CSS, ADO.NET, T-SQL, Web Services, Windows XP, SQL Server 2005,, WCF, WPF and Windows 2003 Server, SSRS, IIS 5.0/6.0, WWF, Share Point
Contact this candidate