.Net Sql Server

Name: Sandeep Reddy

Email: ********.***@*****.***

Phone: 908-***-****

Location: Albany, NY

PROFESSIONAL ABRIDGEMENT

Dynamic, competent and result oriented professional with 8 years of experience in complete Software Development Life Cycle (SDLC) with analysis, design, development, testing, deployment, maintenance and support of Enterprise applications in SOA and N-Tier, Smart Client-Server Architectures.

Experience in working E-Commerce, Financial and Insurance Domains.

Experience with Agile/Scrum development methodology and implementing Design Patterns.

Worked extensively in developing Process Flow Diagrams, Use Case Diagrams, Class Diagrams, and Sequence Diagrams using Microsoft Visio.

Extensive experience in developing applications on Microsoft .Net framework 2.0/3.0/3.5/4.0 using C#, VB.Net, ASP.Net, ADO.Net, MS SQL Server and Visual Studio 08/10.

Expert in web based applications and UI technologies such as HTML5, XHTML, DHTML, CSS, MXML, XML, AJAX, JQuery, JSON and Java Script.

Extensively experienced in designing the Prototype and Mockups using Photoshop, Adobe flash, Adobe Dream Weaver and Microsoft Visual Studio 2013.

Expertise in designing and developing Web Forms, Win Forms and Web Services using C#, XML, XHTML, XSLT, XSD, HTML, CSS3 and SOAP.

Expertise using the data access methods like ADO.Net, LINQ and Entity Framework.

Experience in developing and building rich user interface web applications using Silverlight, AJAX and XAML.

Experience in working with Windows Communication Foundation (WCF), Windows Card Space (WCS), Windows Presentation Foundation (WPF) and Windows Workflow Foundation (WF) and Language Integrated Query (LINQ).

Strong in Object–Oriented Programming concepts like Encapsulation, Inheritance, Polymorphism, Generics and Relational Database Management System (RDBMS) Concepts.

Experience in working with various components of SharePoint Portal server 2003 and Microsoft office SharePoint Server 2007/2010/2013.

Worked in Database Design, Development & Data migration using SQL Server 2000/05/08/12, Oracle 10g/9i, DB2, MySQL and MS Access.

Expertise in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Cursors, User defined data types and Functions using SQL.

Hands on experience with SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and Crystal Reports.

Crystal Reports was used to generate complex reports. The reports could be exported in Excel or PDF formats.

Experience with Microsoft Visual Source Safe (VSS) and Team Foundation Server.

Good understanding and implementation of Word Wide Web Consortium (W3C) standards and Search Engine Optimization (SEO).

Testing which involves unit testing, integration, performance and auditing the code to ensure it works with minimal defects before going to production.

Performed complex bug verification and release testing for several products.

Delivering and implementing the project as per scheduled deadlines and extending post-implementation and maintenance support to the client.

Skilled communicator & Strong experience in handling multiple projects simultaneously. Further, a committed team player, quick thinker and rapid problem solver with commitment and a strong work ethic.

EXPERTISE

Technical

Languages: C#, VB.NET, VBA, SQL, PL/SQL, T-SQL, C++, C

Mark-up/Scripting: JavaScript, AJAX, VBScript, HTML5, DHTML (CSS), XML, XSL, XSLT, PowerShell.

Framework: .NET Framework 4.0/3.5/3.0/2.0/1.1/1.0, SOA

Databases: MS SQL Server 2012/2008/2005/2000, Oracle 10g/9i/8i, MS Access, Sybase 11.

XML Technologies: XSL/XSLT, DOM, XPath, XSD

Web Dev: ASP.NET, Silverlight, Web Service,

Windows Dev: WPF, Win Forms, ATL 3.0/7.0, Win32/Windows API, Familiarity with MFC

Web Servers: Microsoft IIS 7.0/6.0/5.0

Modeling Tools: MS Visio Professional

Business & Portal Tech: Microsoft Office SharePoint Server 2010/2013 (MOSS)

Defect/Bug Tracking: JIRA, Bugzilla, Falcon (ticketing system)

Version Control: Microsoft Visual Source Safe (VSS), Perforce, TFS.

Reporting Tools: Crystal Reports Enterprise, SQL Server Reporting Services (SSRS), Access reports

IDE: Visual Studio 2010/2008/2005, Visual Basic 6

Platform: Win32 (Vista, XP, Win2008, Win 2003, NT, Win 2000, Win PE), Win64 (Vista, XP, Win 2008, Win 2003), DOS

Tools / Applications: NUnit, MS Visio

Standards&Trends: Agile Practice, Service Oriented Architecture (SOA), Model Driven Architecture

Office Productivity: MS Word/PowerPoint/Excel/Access/Visio,VSTO, MS Outlook

OtherSkills: ADO.Net, WCF, WPF AJAX.Net, COM+, LINQ, ActiveX, COM/DCOM, Requirements gathering/engineering, COM API,UML, Design patterns, code reviews, test planning

Managerial

Project Planning, Execution and Management, in tune with the core business objectives.

Requirements gathering, risk assessment, finalization of technical specifications.

Implementation of project plans within pre-set budgets and deadlines.

Implementation of Agile Software Development Life Cycle using Pivotal Tracker and AgileZen

Process vision and design, enhancement strategy and transition strategy.

Managing resource allocations and setting up of communication channels across the various horizons of the organization structure.

Proven leadership ability, Customer interaction, On-Site product development/installation/integration & Customer trainings.

Led the team with high degree of initiative and great sense of responsibility.

Professional Experience:

Client: New York State Police, New York (February2015- Current)

Role: Senior .Net Developer/Tracs Developer

Environment: Agile, TRACS Criminal tracking, TOAD 10.0, Microsoft suite 2010, C#, UNIX, Quality Center, Rational Rose and Requisite Pro

Responsibilities:

Created Traffic forms, reports and rules in TraCS SDK (Software Development Kit) environment as necessitated by local law enforcement agency needs.

Developed, test and debug VB.Net and C# (C Sharp) providing patches and installation packages (INNO Setup) for existing TraCS (Traffic and Criminal Software) software.

Developed, design and test logical solutions to resolve end-user and code issues.

Code changes to data transfer application as necessitated by software version changes.

Created release notes, installation and conversion documentation.

Created reporting tools capable of accessing data from MS Access, SQL Server or Oracle databases.

Created stored procedures, functions and views for the related business scenarios in SQL Server.

Responsible for high level testing, troubleshooting and resolutions of technical support issues

Maintained MS Access databases for numerous Law Enforcement Agencies and police stations.

Involved in design review and requirement meetings.

Involved in writing in Unit Test Cases using stub and mock data for testing the response from the services before sending it to the Model Layer.

Performed system testing.

Maintained version control for varied Local Agency TraCS implementations Provided technical assistance to New York State police officers.

Managed Application and Session State. Serialized objects for the purpose of maintaining state within the web application.

Client: J.P. Morgan Chase, New York (May2012– January2015)

Role: Senior .Net Developer

Project: BPC is a project designed to reduce the dependency on bank account communication through emails. This system eliminates the sensitive information transmission through email system. BPC integrates with other systems named as “Falcon”, “Phoenix”, “Expert Portal” & “Institution”. It consists of 3 sub-systems

1. Rich UI for Internal users

2. External Interface through services

3. Admin UI.

Environment: VisualStudio2010, C#, ASP.NET MVC 3.0, WCF, Entity Frame Work 4.0, Java Script, JQuery, SILVERLIGHT 4.0/3.0, Expression Blend 3.0, XAML, TFS 2010, WCF, IIS 7.0, AJAX, ADO.NET, LINQ, XML, Microsoft Enterprise Library, NUNIT, Site core CMS, SQL Server 2008 R2, UML, Windows Server 2008 R2/2008.

Responsibilities:

Designed and developed asp.net 4.0 web forms with integrated custom controls and user controls.

Implemented asp.net membership provider to manager user's base.

Hands on experience in using asp.net Ajax, JQuery and .net controls like chart control.

Implemented technical use cases by designing and developing the appropriate web pages in asp.net using c# code-behind.

Used Telerik controls like Radchart and RadGridview to provide richer user experience.

Used VSTO add in to display the charts in Excel using COM API

Developed web based projects using Sitecore CMS

Generated excel data using COM API interoperability interface in VB.Net

Developed Excel reports from Budget spread sheets, utilizing C++, C# (with VSTO) and VBA.

Responsible for designing the ASP.NET application authentication using .NET Framework, Model View Controller MVC and IIS security model.

Used ASP.NET MVC framework to support the use of Dependency Injection to inject objects into a class, instead of relying on the class to create the object itself.

Used log4net for logging at various levels of the application.

Implemented Business layer using Windows Communication Foundation (WCF).

Developed WCF service endpoints and exposed them over default protocol (soap over http) settings.

Created stored procedures, functions and views for the related business scenarios in SQL Server.

Developed database access components using the ADO.NET Entity Framework and utilized LINQ to Entity.

Implemented error handling for the web pages by displaying appropriate user readable error messages.

Setting up the application development environment by using Microsoft TFS.

Hands on experience creating the technical design documents & maintaining them.

Responsible for writing the code in Microsoft Visual Studio.Net 2010 with ASP.Net using code behind C# & tested with NUNIT.

Hands on experience in using the xml serialization provided by .net.

Used Cascading Style Sheets (CSS) to maintain design consistency across all web forms

Supporting the production support issues/deployment.

Client: Wells Fargo Bank, New Jersey (Apr2010– Mar2012)

Role: Senior .Net Developer

Project Description: Wells Fargo Advisors is one of the nation's premier financial services firm. Its brokerage business is represented by more than 15000 financial advisors and was born out of wells Fargo Company 2009 acquisition of Wachovia Corporation. Wells Fargo is a non-bank affiliate of Wells Fargo Company.

Environment: Visual Studio 2008, .NET Framework 2.0/3.5, C++, Win Form, ASP.NET 2.0/3.5, C#.NET, VB.Net, Web Forms, Server Controls, Crystal Reports.NET, ADO.NET, MVC, Oracle 10g, PL/SQL, Web Services, WCF, LINQ

Responsibilities:

Interacted with the end-users to identify business requirements and gather the requirements for business logic fulfillment. Analysis and coding of the application.

Defined an object oriented business model employing UML for business process analysis using Enterprise Architect.

Created VSTO add-ins and a Distribution Group management Website to fulfill Lotus Notes conversion to Outlook, regulatory compliance requirements, and data loss prevention initiatives

Developed various entity relationship diagrams depicting interaction and business log developed interactive pages of the application using ASP.NET Web Forms pages with C# .NET for the code behind modules.

Used Win forms, for User interface to create accordion like visible areas for each comparison area. This will allow the user to create many comparison sheets, each with unlimited number of devices for comparison.

Responsible for creating Reports in Crystal Reports and to deploy and solving any issues.

Developed Stored Procedures, Triggers using PL/SQL and used accordingly.

Developed Data access assemblies in C# and isolated data access logic from business layer and front end.

Developed Web Forms for User Interfaces using ASP.NET and C#.NET using Server Controls, HTML Controls and User Controls.

Generated excel data using COM API interoperability interface

Created and deployed XML Web Services (WCF) using ASP.NET and C#, used them to generate the proxy class files based on the web services and consumed in web application.

Used Cascading Style Sheets (CSS) to maintain design consistency across all web forms.

Created Custom Validation Controls for validating the data in the User Control and used ASP.NET Validation Controls for server side validation and Java Script for client side validation

Implemented Role based authorization and Form based authentication

Used ADO.NET components like Connection, Command, Data Adapter, Dataset, Data Reader and binded data to Grid View and Details View.

Used AJAX coding techniques to update parts of a web page.

Involved in migrating the application from Access Database to Oracle 10g.

Created a Web service to transfer data from the application to CABS via WPI web services

Managed Application and Session State. Serialized objects for the purpose of maintaining state within the web application.

Used the .NET Framework class library programmed in C#.NET throughout the application for developing Web Forms

Proficient in developing database objects like queries, stored procedures, Packages, PL/SQL Programs, Functions, Cursors, Reference Cursors, Dynamic SQL, PL/SQL Tables and Package Cursors.

Client: Comcast, West Chester, PA (Dec2008- Mar2010)

Application Domain: Commercial Agent Frond End framework (CAFÉ)

Role: Senior .Net Developer

Environment:.NET Framework, LINQ, C#.NET, CSS3,TFS, Visual Studio 2010, Resharper, SQL SERVER 2008, MVC3, JavaScript, Ajax, Jquery, Window XP, TSQL, HPQC, Rally, Team City, TDD.

Description:

Commercial Agent Frond End framework (CAFÉ) is a reusable widget based solution and developed by using MVC3 architecture framework. Widgets are platform independent components that can be easily integrated with web or desktop applications. The output response generated from the widgets either JSON or HTML5.

We were building reusable widget warehouse that can be consumed across multiple business teams within the organization. It reduces duplicate work by the application teams and increase unified user experience. Also widgets are easily configurable for every consumer. Commercial agents are responsible to follow set of tasks to resolve customer compliance and issue tickets. Toolkits and widgets are helpful to achieve 100% customer satisfaction.

Responsibilities:

Designing the existing aspx pages into reusable widgets for widgets inventory that can be used by many application teams.

Defect fixes to the existing application and developing the services in WCF, which the application consumed.

Involved in Analysis and improve the performance load some of the widgets.

Understanding the present architecture and the Account Load Process which makes Asynchronous calls to improve the performance when making the service calls.

Involved in Agile development meetings.

Involved in design review and requirement meetings.

Involved in writing in Unit Test Cases using stub and mock data for testing the response from the services before sending it to the Model Layer.

Prepared SOAP test data for WCF service validation.

Update the HP Quality Center defects assigned for CAFÉ applications.

Involved in test driven development, Unit testing, System testing and User Acceptance test throughout the project.

Client: Hanover Insurance Company, NJ (Jan2008- Dec2008)

Application Domain: Auto Insurance Claim Management System

Role: .NET Developer

Environment: C#.NET, ASP.NET, .Net 2.0/3.0, VB.NET, AJAX Control Toolkit, Win Forms, Visual Studio 2005, SQL Server 2005, T-SQL, SSIS, SSRS, VSS, JQuery, JavaScript, Windows XP.

Responsibilities:

Involved in Designing, Developing, Testing and implementing the application using SOA/RAD Methodology.

Interacted closely with the business analysts in finalizing the requirements of content and membership modules.

Prepared the Technical Design Document with Class and Sequence diagrams for the Vendor, Item and Main site and auction feeds generation.

Designed the front end Win Forms using many controls using Visual Studio 2005.

Designed and Developed the Business Logic using C#.Net and Visual Studio 2005.

Involved in implementation of business layer using customized Entity Framework.

Worked extensively with various ASP.NET 3.0 advanced web server controls including List View, Grid View, Tree View and Multi View while developing various web forms.

Developed ASP.NET User Controls for navigation and dynamically build up the contents of a Web Forms.

Implemented Session Management through cookies and Temporary Session Variables.

Used HTML, XHTML and Web Form Controls to create web pages. Developed classes for reuse.

Worked on Microsoft SharePoint 2007, in adding Documents, Links, and Contact List.

Designed tables as per as the business requirements and generated SQL scripts to create tables.

Written Stored Procedures in SQL Server 2005 used Grid View, Data List, Details view, Repeaters, Dataset Classes for data manipulation.

Created Stored Procedures and Triggers to ensure atomicity and consistency on the database transactions.

Enforced strict Role Based Authorization and Forms based Authentication.

Used SSIS, SSRS for the reporting part of the application.

Used Visual Source Safe for version control during development

Client: American Express, Plantation, FL (May2007– Dec2007)

Application Domain: Operational Ranking Report

Role: .Net/SQL Developer

Environment: ASP.NET, VB.NET, ADO.NET, .Net Framework 2.0, HTML, CSS, AJAX, JavaScript, Visual Studio 2005, MS SQL SERVER 2005, T-SQL, Web Services, Crystal Reports, Visual Source Safe, Adobe Dream Weaver.

Description:

Project involved developing various forms and reports like late currency transaction report, Branch Work Preparation Form and Report which is used to support the Proof Errors section of the Operational Ranking Report, Branch Responsibility Checklist form and Report, ATM Events which involves screen scrapping and generating Reports and Operational Ranking Report.

Responsibilities:

Participated in the design architecture and analysis of the project.

Developed new user interface for new features and functionality to the application in HTML using Adobe Dream weaver.

Developed the modules in Visual Studio 2005 using ASP.NET, VB.NET, JavaScript, HTML, CSS, ADO.NET and SQL Server 2005.

Developed new modules in VB.NET based on old source code in VB and migrated from VB to VB.NET.

Used Session Objects for Session Management.

Validations of forms were performed using JavaScript, AJAX and .Net Validation controls.

Used Master Pages and Cascading Style Sheets (CSS) to render a uniform look and feel for the application. Designed rich graphics and backgrounds using Adobe Photoshop.

Created an Administrator’s interface where the Admin could get an access to database data and could access/modify/update the data which would dynamically be reflected in the web forms.

Created multithreaded web services to enable efficient and fast access of these services from the client applications.

Designed and Implemented data access layer using ADO.Net to connect/update/access databases.

Created the database and several stored procedures and views were written to access the database.

Developed Database Triggers to enforce Data integrity and additional Referential Integrity.

Developed T-SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs

Crystal Reports was used to generate complex reports. The reports could be exported in Excel or PDF formats.

EDUCATION

MBA in IT Administration

Missouri State University, Missouri

Contact this candidate