Post Job Free

Resume

Sign in

.Net Sql Server

Location:
Richmond, VA
Salary:
90000
Posted:
March 27, 2017

Contact this candidate

Resume:

RAGHU VAMSI CHANDRUPATLA

Ph: 551-***-****

Email: aczikb@r.postjobfree.com

SUMMARY:

Over 8 years of experience in design, development, testing and deployment of secure, multi-tier web and client/server applications.

Experience in Windows and Web Application using .NET Framework 4.5, 4.0, 3.5, 3.0 & 2.0, C#.NET, ASP.NET, VB.NET, WCF SOAP and REST services, Web Services (WSDL, UDDI, DISCO, and SOAP), ADO.NET, and MS SQL Server.

Experience in developing Graphical User Interfaces using HTML, RAZOR, CSS, JavaScript, JQuery, AngularJS, AJAX, XML, Silver Light and WPF.

Have extensively worked on OOPS CONCEPTS Abstraction, Encapsulation, Inheritance, and Polymorphism.

Experienced in using Design patterns like MVC, MVVM, MVP and Factory Patterns.

Experience working with .NET features like Events & Delegates, Generics & Collections, Multi-Threading, Exception Handling, Serialization, LINQ.

Experience on Windows Communication Foundation (WCF) REST and SOAP services.

Exposed and consumed data through Web API applications.

Knowledge in XML transformation languages like XSL, XSLT and X Path.

Experienced in all aspects of SDLC (Software Development Life Cycle) including architectural design, gathering business requirements, project estimation, project schedule planning, resource planning, evaluation of third party solutions, evaluating new technology stack, conducting feasibility studies, documentation and support of systems ranging from stand-alone applications to multi-tiered web architectures.

Experience in creating Unified Modeling Language (UML) diagrams like Class, Sequence and Use Case diagrams using Rational Rose and MS Visio.

Experience in implementing Business Processes, Abstract factory as part of Service Oriented Architecture (SOA).

Expert level experience in SQL Server 2008/2005/2000 and Oracle 9i/10g/11g database design, development of Schemas, Tables, Views, Indexes, Stored Procedures, User Defined Functions and Triggers, DTS, Transaction Management, T-SQL/PL-SQL, Code optimization and performance.

Experience in updating, accessing and version controlling the source code using Visual Source Safe (VSS), Team Foundation Server (TFS).

Experienced in creating test cases in N Unit Testing

Deployed a variety of .NET Framework Applications including Windows and Web Forms.

Good communication, interpersonal and presentation skills.

Excellent work ethics, self-motivated and quick learner.

Willing to learn, adapt new technologies and third party products.

CERTIFICATIONS:

Exam TS 70-519: MCTS in Pro: Designing and Developing Web Applications Using Microsoft .NET Framework 4

TECHNICAL SKILLS:

Languages\ Web Technologies\

C#.NET, VB.NET, SQL, T – SQL, PL/SQL, \ ASP.Net, AJAX, Web Services, Silver Light \

XML, HTML5, RAZOR, JSON, LINQ, \ 3.0/2.0/1.0, Web 2.0, CSS, Java Script, HTML, \

ASP.Net AJAX, C, C++\ VB Script, ASP, MVC, JQuery, AngularJS, MVVM, MVP.\

Database\ Application Tools\

Oracle 9i/10g/11g, SQL Server 2008/2005/\ Visual Interdev 6.0, Visual Studio.Net, Front \

2000 (T-SQL, Stored procedures, Triggers, \ Page, SQL Enterprise Manager, SQL \

DML, DDL, DTS, SSIS and SSAS), MS Access\ Management Studio, Adobe Photoshop 7.0\

Middleware\ Protocols\

ADO.Net, ActiveX, DLL\ SOAP, SSL, FTP, TCP/IP, HTTP\

Reporting Services\ Enterprise Servers\

Crystal Reports, SQL Server Reporting Services \ IIS Server, Commerce Server, Content \

(SSRS), Active Reports.\ Management Server\

Operating Systems\

Windows Server 2003, XP, Windows NT / 2000\

PROFESSIONAL EXPERIENCE:

New York State Insurance Fund (NYSIF) – Albany, NY (May 16 – Till Date)

Oracle PL/SQL Developer/.NET Developer

Project: COMPPAY

NYSIF offers Workers compensation, disability benefits and quality insurance plans for all New York businesses. Services include claims case management and workplace safety programs.

Responsibilities:

Worked on EDI in the processing of insurance information from its initial reporting source to the jurisdiction electronically.

Prototype claim types from end-to- end in the revised MVC front-end, providing a more modern User Interface for the recently migrated claims processing and payment applications CompPay and ATF.

Involved in creating Windows forms applications for handling various batch processes to migrate data across various modules of the Workers compensation system.

Responsible for Designing and Developing the Reusable UI Components Like MVC Master Pages Layouts and Nested Layouts, ViewStart and MVC User Controls Partial Views.

Design classes following OOP principles and implemented them for best code reuse in framework 3.5.

Involved in the development of a User-friendly Batch processing and Web based application using Asp.net 4.0, HTML, CSS, JavaScript, jQuery, AngularJS in an Agile/Scrum methodology.

Involved in creating batch processes using PL/SQL and Microsoft Technologies C# & VB.Net.

Developed the functionality with in 4.0 .Net Framework using C# & VB.Net.

Designed the components using C# & VB.Net with extensive use of Object Oriented Programming Techniques likes Inheritance, Interfaces etc.

Created the Data Access Layer and fetched the data from Oracle using database objects like Stored Procedures and Packages.

Involved in creating PL/SQL Triggers.

Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries.

Involved in project planning, scheduling, System design, Functional Specification, Design specification, coding and system test plan.

Involved in creating different jobs to satisfy business requirements.

Involved in Database Design and responsible for writing Complex Queries, Stored Procedures, User Defined Functions, Views, and Triggers using PL/SQL.

Coded PL-SQL packages and procedures to perform data loading, error handling and logging and used it in the .Net framework using the NYSIF custom assemblies.

Design and implement data flow structure in Oracle and package various components like exception handling etc.

Implemented Oracle 11g as database for the application using SQL Developer tool for DML and DDL operations.

Implemented dynamic SQL queries with ADO.Net for both Oracle data provider & SQL data provider using data reader, data adapter, data set and data table.

Worked with data migration tool and data modeler in oracle for data promotions between environments and to maintain database structure design.

Worked with DBA’s to assign roles and permissions, for application users to perform CRUD operations on data.

Consumed WCF Service Methods using the Net TCP/ HTTP Binding.

Used Team Foundation Server (TFS) for maintaining the history of source code and project documents.

Performed Unit testing for the application.

Involved in developing XML Web Services to communicate with Database

Worked with the resource and portfolio project managements system called Innotas to track the status of the project.

Worked with the Blueprint requirement tool.

Worked on creating and tracking the defects in HP Quality Center.

Environment: .Net Framework 4.0, Agile (SCRUM), ASP.NET, 4.0, Winforms, C#, VB.NET, HTML, CSS, JavaScript, AngularJS, AJAX, JSON, XML, WCF, Visual Studio 2010, Oracle 10g, PL/SQL Developer, Team Foundation Service (TFS), Windows 7, Windows Server 2008, Innotas, Blueprint Requirement Tool, HP Quality Center.

Silver Chair, Charlottesville VA (Mar 13 – Apr 16)

Senior .Net Developer

Standardized Usage Statistics Harvesting Initiative (SUSHI service)

Designed and implemented WCF SOAP service to implement the ePublishing industry’s SUSHI interface. Enabled rapid dissemination of multi-GBs of data to customers’ Enterprise Resource Management software.

Flexible Web Site Design

Enabled a flexible ASP.Net website enabling easy modification and differentiation by customer through a data driven design. Used SCRUM development methodology to deliver frequent, high-quality updates. Code reviewed other developers to ensure usage collection standards were followed.

Responsibilities:

Responsible for designing the ASP.NET application authentication using .NET Framework, C#.NET, Model View Controller (MVC 5).

Followed Scrum and Test Driven Development Methods in Agile Scrum Methodology to produce high Quality software.

Developed application as n-tier application with UI in the presentation layer using ASP.NET 3.5, business logic in the middle layer using C#.NET and data service activities in the backend using MS SQL Server 2008.

Developed core functionality with the ASP.NET MVC Framework (C#.NET, ADO.NET).

Implementation of client side validations using JQuery, AngularJS and ASP.NET MVC Validation implemented at Controller level.

Mixture of new development and maintenance / enhancements (loads and refines content).

HTML 5 and RAZOR are used extensively for views and partial views development for enhanced UI experience.

Used entity framework for data mapping and data modelling middle tier data objects with model class properties.

Serialization and Deserialization techniques are used on JSON data for communicating with Web API’s for data transfer.

AJAX and heavy JQuery, HTML 5 for front-end development.

Apply tags to ensure XML format consistency.

URL re-writing, CSS, etc. for search engine optimization.

Used minification and bundling techniques on .css, .js files improving load time by reducing number of requests to the server and reducing the size of requested assets.

Customized routing configuration for mapping incoming request to controller actions.

Consumed data from Web API’s as JSON objects.

Worked in generating reports using SQL Server Reporting Services (SSRS) with good knowledge of SQL Server Integrated Services (SSIS).

Write stored procedures/ Functions heavily and format.

Building reusable search services and ensure data protection.

Created windows forms application for content management system and XML transformations.

Heavy XML, XSLT, and DTD work & using XSLT to re-shape XML.

Used MS Enterprise Library Blocks for Logging and Exception Handling in the engine.

Extensively wrote and used T-SQL, stored procedures, Database Triggers in SQL Server 2008.

Maintaining the version of the project in Team Foundation Server (TFS) by merging the module developed with latest version in TFS.

Technical Environment:

.NET 2.0/3.5/4.0, C#.NET, ASP.NET, SQL Server 2008, Winforms, AJAX / JQuery / JSON, AngularJS, XML, XSLT, XPath, HTML 5, Web Services, Telerik Controls, Flash, Visual Studio 2005/2010, ASP, LINQ, IIS

Bank of America Pennington, NJ (May 11 – Feb 13)

Senior .Net Developer

This project is aimed at providing bankruptcy due diligence services to the consumer bankruptcy market. Also, maintaining its own proprietary web-based application called Legal Data Services. Legal Data Services affords attorneys access to information such as credit liability data, property valuations, property title information, NADA auto values, as well as IRS tax transcripts. This project is developed on Microsoft’s Visual Studio .NET 2005/2008, Ajax, Web services, Multithreading and MS SQL Server 2008.

Responsibilities:

Involved in all the phases of the Project Life Cycle and also analysis of the system based on n-tier architecture.

Gathered the requirements from the user and Documented the requirements using UML Diagrams

Designed reusable class libraries, implemented those classes using C#. NET, OOPS, WSDL, SOAP and .NET Reflection library to load persisted classes dynamically, simulating Factory pattern.

MVC 4 pattern is used for application architecture facilitating isolation of presentation layer from business layer development.

Model class objects are defined and mapped with database for persistence.

RAZOR with HTML 5 controls are used for enhanced UI.

WCF services are consumed using WCF wrappers for data interchange.

Involved in Developing Rich Interactive GUI using Silverlight 3.0 User Controls, XAML and Microsoft Expression Blend/Designer.

Created Styles, Templates in Silverlight in designing the UI with XAML.

Have worked on Silver Light 3.0 Controls for video streaming plug in for interactivity features.

Used ASP.NET AJAX Toolkit controls like Script Manager, Update Panel and Modal Popup Extender within some web pages.

Used extensively Javascript and ASP.NET for AJAX Implementation and Client Side Validations.

Effectively used CSS, HTML, User Controls, Custom Controls and Master Pages.

More enhanced css and javascript controls (calendars, WYSIWYG) are used from Bootstrap themes and controls.

Javascript and css files are bundled and minified for consistent look and feel of the application.

Best Utilized Microsoft Enterprise Library for designing security components.

XML and SOAP were used to exchange structured and typed information with help of web service over the internet.

All data transfers (requests/ retrievals), XML Schemas and XML namespaces transformation were performed using XSLT.

Used LINQ to query different data source like arrays, xml file, and SQL Server 2008.

Involved in creating services using WCF and used it across various parts of the project.

Experienced in maintaining a session of messages between a client and a service using Windows Communications Foundation (WCF) facilities.

Used WCF for communicating to the API and between the layers.

Have worked in multi-threading and messaging features for the application to pass the message from the client to the server side and extensively implement multi-threading capabilities.

Involved in N-unit testing of the application with different sets of inputs.

Environment:

.NET Framework 3.5/3.0, ASP.NET 3.5/3.0, C#.NET, ADO.NET Entity framework, MS Visual Studio 2008/2005, SQL Server 2008, T-SQL, HTML,IIS 6.0, Silverlight, WCF, Web 2.0, Web services, WSDL, SOAP, XSLT, Javascript, SSRS, AJAX, CSS, XML, XAML, Microsoft Enterprise Library, Nunit, Team Foundation Server (TFS)

Michigan Department of Health Lansing, MI (Jan 10– Apr 11)

.Net Developer

Facilitating the application process for eligible Professionals, Hospitals and Groups includes the delivery of a system for the continuation and completion of the registration and attestation process, a pioneer in the field of government health solutions. This is a web portal for the Medicaid Provider Incentive program. It supports eligible professionals and hospitals throughout this significant Health Information Technology (HIT) transition. It’s a complete solution for meeting the technological guidelines defined by the Medicaid Agency, including the technological design, development and implementation of the support necessary. A cornerstone to the solution serves as a gateway to the entire provider attestation process. Web portal includes all the Provider Registration, Integration of NLR Data, Integration of Multiple State level data resources and attestation via Adopt, Implement, Upgrade (AIU) or Meaningful Use (MU) methods.

Responsibilities:

Designed 3-Tier system having Business Logic Layer (C#.NET), Presentation Layer and Database Layer (Database Connection and Security Settings).

Proficient in designing applications using UML–Modeling by applying Object Oriented Analysis and Design (OOAD) and design patterns concepts and methodologies.

Developed the Applications in ASP.NET using Master Pages, Themes & Skins to maintain the consistent look and feel throughout the application.

Developed web application using ASP.Net. Worked on the modules implementing the business logic in C#.NET.

Developed different User controls which inputs the data and display the data for the web applications using ASP.NET.

Made full use of .NET’s object oriented features, error handling, caching, security, tracing and event logging features.

Developed rich UI for the application using Windows Presentation Foundation (WPF) and done data binding using one way, two ways and one way to source data binding.

Used List, Trees, Toolbars, Menus and Context Menus for navigation in WPF.

Leveraged AJAX to improve the application performance and leveraged all the AJAX tool kit controls.

Involved extensively in developing the client side validations using JavaScript.

Developed multiple web services for feeding data to multiple applications using Windows Communication Foundation (WCF).

Developed Business Façade, Business logic, Common, and Data access Layer for WCF service using WCF, Repository Factory and C#.NET.

Used Microsoft Application Blocks to develop Data Access Layer and perform exception management.

Developed XML Web Services extensively to implement the business logic.

Transformed XML files into specified business format (PDF, MS-Word) using XSLT.

Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.

Wrote SQL Queries to create tables, stored procedures, and triggers using SQL Server 2005.

Created SQL Server Reporting Services on the web page by accessing the database.

Used VSS to protect from accidental file loss and track version.

Responsible for the Unit Testing, Integration Testing and implementation.

Environment:

Visual Studio.NET 2005, .NET Framework 3.0/2.0, C#.NET, ASP.NET 2.0, AJAX, HTML, MVC Pattern, XML, XSLT, CSS, AJAX, JavaScript, SQL Server, Crystal Reports, WCF, WPF, Web Services, Windows services, UML, VSS, IIS 6.0

United America Insurance McKinney, TX (Nov 09 - Jan 10)

.Net Developer

Responsibilities:

Participation in complete project development life cycle.

Designed and Developed Web forms using ASP.NET Server Controls, Data Grids, user controls for reusability. Implemented UML for making case diagrams and coded in C#.NET.

Extensively worked on Cascading Style Sheets (CSS) to provide look and feel for web pages.

Working with ASP.NET Master Pages that were common throughout the application and content pages.

Used various ASP.NET 2.0 web server controls that included Site Map Path, Menu, Tree View, Grid View and Details View to develop web forms.

Created ASP.NET User Controls to reduce the complexity of user interface design.

Extensively worked with ASP.NET web pages to provide good look and feel.

Extensively used SOAP and HTTP for consuming XML Web Services.

Used Data Reader, Data Set and Grid View for retrieving, manipulating and displaying data.

Used JavaScript and ASP.NET Input Validation Controls for client side validations.

Communication between Data Access Layer and Data Base was established by ADO.NET.

Created database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using SQL Server 2005/2000.

Created, Deployed and managed Reports through Crystal Reports.

Used Visual Source Safe (VSS) for Versioning control and configuration management.

Environment:

NETFramework2.0/1.x, C#.NET, ASP.NET1.1, JavaScript, SQLServer2000/2005, JavaScript, HTML, CSS, VisualStudio2003, Visual Source Safe, ADO.NET, Crystal Reports, Windows2000/XP/NT

Exxon Mobil Houston, TX (May 08 – Nov 09)

.Net Developer

Responsibilities:

Designed and developed web forms in ASP.NET & VB.NET using .NET Framework 1.1.

Used Master Pages, CSS for look and feel for Web pages.

Extensively used the ASP.NET features like Grid View, Detail View and other controls.

Designed and developed web forms using user ASP.NET controls Server Controls.

Designed and developed Custom controls to use with Web Forms.

Used ADO.Net components such as Datasets, Data Reader, Data View and Data Table.

Extensive use of Web Services, SOAP, XML, XSL to expose the reports to facilitate information sharing.

Designed and developed .NET components using VB.NET and XML to communicate with Web Services.

Worked on ASP.NET features like state Management, caching features, configuring optimizations and securing web application

Used various ASP.NET client side and server validation Controls, used JavaScript for client side validations.

Developed the Forms authentication module, which will authenticate based on the Login, Membership and Role Providers in ASP.NET.

Maintaining Session objects of application and Implemented Caching techniques.

Responsible in creating the Test Cases, Scenarios and Steps for the new requirements.

Designed and implemented the backend using Oracle.

Created data objects in the business layer for retrieving data from database through the DAL.

Environment:

NET Framework 1.x, ASP.NET 1.1, VB.NET, ADO.NET, AJAX, Visual Studio.NET 2003,Oracle, HTML, XML, XSL, SOAP, JavaScript and MS Source Safe 6.0, AJAX, IIS 5.0

EDUCATION:

Bachelor of Engineering in Electrical Engineering



Contact this candidate