Sql Server .Net

Pavan Chandra

.Net Developer

Cell: 619-***-****

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

Summary:

Around 6 years of extensive knowledge and strong experience in designing, developing, and testing of Business/Commercial Applications using Visual Studio .NET 2003-13, C#, VB, ASP.NET 3.0-4.5, and SQL Server 2005-12.

Strong experience in all the stages of the full Software Development Life Cycle (SDLC). Completely understand the importance of Quality of work in deliverables given to client.

Experience working with Agile Scrum programming methodologies.

Extensive experience in developing or debugging multi-tier applications using C#, AJAX, Serialization, Java Script, DHTML, IIS and CSS.

Worked with ASP.NET 3.0 Web Parts, Navigation Control, and Master Pages.

Experience in understanding and modifying Stored Procedures, Functions, Packages and Triggers in SQL Server 2005.

Experience in designing and implementing object-oriented applications in ASP.NET using design patterns and best practices include MVC, MVVM.

Strong experience in designing rich and responsive user interfaces using Knockout JS, Angular JS and Bootstrap.

Experience in designing and developing the applications using MVC design patterns.

Knowledge of XML related technologies such as XML/XSL, DTD, XML Schema, SOAP, DOM, Web-Services.

Expertise in implementing client side Java Script, JQuery, HTML, DHTML and CSS.

Designed and implemented Business Processes, & Abstract factory as part of Service Oriented Architecture (SOA).

Experience working on Web Services in .NET using SOAP and REST.

Designing solutions for set-top box User-Interface using Dream-Gallery framework that is the Motorola Proprietary product.

Extensive knowledge and experience in working with new frameworks like JQuery, BackboneJs (used by Appcelerator) and also learning IDE’s like Titanium that works on Backbone.

Very good working knowledge on few tools and concepts like BizTalk, Tableau/CrystalReports/Cognos reporting tools, Sales Force, SharePoint.

Hands-on experience with WCF (Windows Communication Foundation), WPF (Windows Presentation Foundation) and WWF (Windows Workflow Foundation).

Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), and Informatica and ETL package design, and RDBMS systems like SQL Server, Oracle.

Certification:

Microsoft Certified Professional/Microsoft certified Technology Specialist (MCTS - Net Framework 2.0: Web Applications).

Brainbench certified in C#, ASP.Net and .Net Framework 3.5.

Education:

Masters in Engineering Management, St. Cloud State University.

Technical Specification

Programming Languages

C#, VB.Net, VC++, PL/SQL, MySQL, WPF, WCF.

Web Technologies

ASP.NET, HTML, DHTML, XML, CSS, JavaScript, AJAX, Web-Services.

Scripting Language

XML, CSS, Java Script, VBScript, Python, TypeScript, Knockout, Bootstrap

Technology

Net Framework 3.0-4.5, Entity Framework, Biztalk

Database

SQL Server 2005/08/12, Oracle 9i

Tools

Crystal Reports, Microsoft-Office, Visual SourceSafe, Team Foundation Server, Subversion(SVN), ReSharper.

Development Tools

Microsoft Visual Studio .NET 2003/05/08/13, Eclipse IDE, SQL IDE

Web Server

IIS 6.0/7.0, Web Server

Operating Systems

Windows XP/Vista/7, Windows 2005 Server

Work Experience

Insurance Auto Auction June 2015 – Present

Chicago, IL

Position: Full Stack Developer

Roles:

Worked as developer in the team for design and development of application using Microsoft Visual studio with the ASP.Net 4.5.

Involved in design and developing web applications in .NET framework 4.5 in C#

Enhance existing web applications using AJAX, HTML, CSS and Javascript

Create stored procedures to access and manipulate data using SQL Server 2012.

Involved in optimizing C# and SQL code for increased performance

Was also involved in developing WebApi for the new applications OwnerPortal & ProviderPortal along with coordination with offshore team.

Designed and developed the web forms in ASP.NET using C# as the code-behind language and LINQ as the SQL data consumer.

Designed presentation layer and business logic layer using ASP.NET web server controls, HTML control, HTML, cascaded style sheets (CSS3) and AJAX.

The UI and UX is also developed using bootstrap for the responsive design.

Responsible for documenting all technical details, processes and classes used or developed in the application

Involved in enhancing code using Knockout and Type-script for the new application.

Responsible for writing the unit test and technical document for all the developed and enhanced code.

Involved in writing UnitTest cases for the developed code.

Environment: Web Services, Agile methodology, MVC4, .Net Framework 4.5, Visual Studio 2013, C#, ASP.NET, ADO.NET, Knockout, Type-Script, SQL Server 2013, JavaScript, Entity Framework, LINQ, Fiddler, NuGet, JSON.

Department of Human Services, State of Georgia Dec’14 – June’15

Atlanta, GA

Position: Fron-end .Net Developer

Roles:

Involved in developing large-scale application architecture, design, and development using major tools such as ASP.NET/Windows.Net.

Also involved in developing the application using object oriented concepts like classes, inheritance, encapsulation, and the tools used in their definition (UML, Use Cases)

Worked on different design concepts like Layered architecture, components, interfaces

Involved in modeling using UML, specifically using Class, Interaction, Sequence, Activity, and State Diagrams, and of documenting deployment using Deployment Diagrams

Responsible in programming and analysis using Web Services, XML, SOAP, object persistence methodologies and application integration.

Involved in implementing full project lifecycle web based applications.

Responsible for troubleshooting, and keep critical systems operational with minimal supervision.

Involved in understanding with triggers, logical and physical modeling, access strategies and tools, concurrency models Oracle database/Data Access/SQL Server.

Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.

Developed SSIS package for data load into SQL Server tables from Excel as a data source.

ASP.Net or Java, Visual Basic C#, MS SQL Server 2010 in implementing web based systems, .Net Framework with emphasis on version 2.0 – 3.5.

Knowledge in Windows Communication Foundation (WCF) and knowledge of WPF.

Environment: Web Services, MVC4, Agile methodology, .Net Framework 4.5, Visual Studio 2010, C#, ASP.NET, ADO.NET, WCF, WPF, Toad for Oracle 11g, SSIS.

Philadelphia Corporation for Aging May’14 – Dec’14

Philadelphia, PA

Position: .Net Developer

Roles:

Responsible for developing design patterns in Object Oriented programming.

Developed UI of the highest quality through strict attention to visual and interaction details.

Responsible in developing custom workflow in C#, Windows Workflow Foundation (Net 4.0) to control the flow of approvals and process escalations.

Used AJAX controls like Calendar Control, Accordion, Modal Popup and Tab Controls in order to improve the performance and appearance of the application.

Responsible for developing the e-forms using ASP.Net, Entity Framework, ADO.Net, HTML 5 and CSS 3.

Involved in developing and consuming WCF (Windows Communication Foundation) service for connecting frontend interface and backend database and redesign SQL server database.

Used JavaScript to create Client-Side Dynamic content UI along with ASP.NET and C# to modify & Add Server Controls for Dynamic Server-Side Code. JavaScript / JQUERY.

Used LINQ to retrieve information from XML data files and database.

Responsible for migrating data from source to destination table using SSIS packages.

Used Team Foundation Server for Source Code Control, project related document sharing and team collaboration.

Performed Unit Testing using Visual Studio integrated testing tools.

Environment: JavaScript, Web Services, Agile methodology,.Net Framework 4.5, Visual Studio 2005/13, C#, ASP.NET, ADO.NET, AJAX, WCF, JQuery, HTML5, CSS 3, TFS, UnitTest, JQuery, XML,SSIS, LINQ.

Motorola Home March'12-May’14

Position: Web Application Developer

Roles:

Responsible for developing design patterns in Object Oriented programming.

Developed UI of the highest quality through strict attention to visual and interaction details

Designing solutions for set-top box User-Interface using Dream-Gallery framework that is the Motorola Proprietary product.

Extensively trained in Dream-Gallery and providing end-to-end solutions, viz. gathering and analyzing requirements from end client on daily or weekly basis, design, development, testing, etc., for all business functionality relating to set-top box software.

Developed well-abstracted, reusable JavaScript and detail-oriented implementation.

Expertise in JavaScript and XHTML/CSS

Working knowledge of the HTML5 specification

Involved in developing the User Interface based on the requirement using SVG and JavaScript.

Correct programmatic, design errors, bug fixes and testing the application with smoke and manual testing.

Develop end user specific log strings, which are generated based on end user usage. These log string will be used to understand the user behavior and his/her habits.

Checkout the latest Java (used to develop framework), JavaScript and Web technology and setup development environment.

Attending milestone meetings to exchange, update, correct design and programmatic issues.

Involved in developing the UI component architecture and API for using Angular-Js.

Environment: JavaScript, HTML5, Web Services, Agile methodology, MVC, DG Framework, JSON, .Net Framework 4.0, Visual Studio 2012, SVN, CSS 3.0, JQuery, JIRA.

Eli Lilly & Company, Indianapolis, IN Aug’11-March’12

Indianapolis, IN

Position: .Net Developer

Roles:

Designed and developed high performance, user friendly, multi-tier web applications utilizing .NET technologies such as C#, ASP.NET, SQL Server, LINQ and Entity Framework.

Developed a prototype from scratch using ASP.NET MVC 3 and Entity Framework 4.3 for referring clinical data to scientists within the lab network.

Also involved in other web technologies such as HTML, JavaScript (AJAX & jQuery), CSS and web services.

Involved in developing a windows and web applications across the .Net stack.

Worked under Solution delivery Lifecycle environment like Agile, XP, and SCRUM.

Responsible for developing tool which renders a excel file, to parse and modify it as per the business requirements.

The tool is used as a utility application within the existing application.

Developed an XML domain-specific language and web services for loading data files into assay databases.

Involved in building user interfaces leveraging Windows Communication Foundation (WCF) services using MVC.

Developed web services for the clients that can be used by the businesses/application for communication.

Involved in maintaining and enhancing the existing VB.Net application.

Involved in the developing, supporting and enhancing application which is web service’s interface-based, LINQ-centric designed.

Developed extensive unit tests which are executed before pushing into production.

IT workflow process knowledge, including systems development lifecycle, service delivery, and support experience.

Also involved with Software Quality Assurance methods and techniques during team meetings.

Environment: C#, XML, Web Services, WCF, JQuery, JSON, JavaScript, LINQ, PL/SQL, Agile methodology, MVC, IIS Express, ReSharper.

Minnesota Pollution Control Agency, St. Paul, MN March’11-Aug’11

St. Paul, MN

Position: .Net Developer

Roles:

Involved in the knowledge transfer for understanding the business logic and Database schema.

Worked under Agile-scrum methodology fast paced environment.

Involved in designing and development of windows application as per the requirement.

Worked extensively with Panels, XAML and controls in Silverlight.

The main focus of the application is to transfer data from one Database schema to another.

Databases involved during the understanding of database schemas were Oracle, Postgress and Access.

The application copies over all the changes made in live database, which is the legacy database, to a static database, which is strictly for internal use.

The copy over is based on various business logics that involve complex high to low-level business validations and conditions.

The application also creates a log file whenever a SQL query is executed.

Also should log any new rows added or any row deleted in live database.

Involved in developing and designing the Windows Application used to transfer only changed data from one database to another.

Involved in writing lot of complex LINQ-SQL queries.

Used SQL tool, DB-Visualizer, for accessing data-tables and data-views.

Environment: DB-Visualizer, VS 2010, VSS, C#, WPF, Silverlight, Oracle, PL-SQL.

Anderson Fabrics, MN Aug’10-March’11

Blackduck, MN

Position: .Net Developer

Anderson Fabrics is a nationally known COM (Customer's Own Material) workroom in Blackduck, MN that has been making custom products for interior designers and decorators since 1980.

Role:

Involved in developing the Framework designing using .NET Framework 3.5.

Worked with server side language, PHP, for fetching data that is used for validation of the page.

Written validation for the web pages using JavaScript based on the business logics.

Involved in writing the test scripts for the developed application that was part of the responsibilities.

Responsible for storing the data into the database, which would be used by the estimating tool to calculate the ‘estimates’ before placing the order which is developed totally in C# and the web application in ASP.Net.

Developed different User Interfaces that inputs the data and display the data for the developed web Application.

Involved in the designing, developing and maintenance of the tracking tools by utilizing .NET, C# JavaScript.

Responsible in handling the issues related to database and maintenance in the production phase.

Involved in designing and developing an online inventory tracking system.

Designed the web screens based on the Use Case documents. Built the application using ASP.Net Ajax, and Ajax Control Toolkit.

Maintained the company's web application using C#, ASP.NET, JavaScript, XML, and SQL.

Performed negative testing, regression testing and functionality testing to check the performance with the business requirement

Worked on a web-based application that allows the user to know the estimates for the product before placing the order.

Worked on cross browser compatibility, extensively used CSS for Client Side Web Development

Performed data validations by using various server and client-side validation techniques.

Worked with HTML controls, user controls and server controls in the web development.

Used DB-Visualizer as a database tool for testing the data storage.

Environment: VS 2005, DBVisualizer, Open Office, PSPad, HTML, PHP, Java-script, SQL.

Braun Intertec Corporation, MN Sept’09 – July’10

Shakopee, MN

Position: .Net Developer

Braun Intertec has provided thousands of engineering and environmental solutions. They have built a comprehensive scope of services in engineering and environmental consulting, materials and analytical laboratories, and testing services. BIC help clients with site selection and planning, design, construction, operations, and property management.

Role:

Involved in Object-Oriented Analysis and Design, Use-Case-driven development, and the full Software Development Life Cycle (SDLC).

Coordinated with offshore team by giving them the specifications walk through as well as doing the code reviews, peer reviews and review of the unit test plans.

Designed Graphical User Interface (GUI) using Master Pages in ASP.Net, added validations using JavaScript, added styles using CSS classes.

Participated directly in requirement gathering and requirement analysis, meeting with project stakeholders on a regular basis

Worked on UI using AJAX for making smaller, faster and user-friendly web-page application.

Wrote JavaScript Code for client side validations.

Used advanced SQL Reporting Services, created reports with selection criteria pages and SQL Server with an application layer on top of Reporting.

Involved in writing Cascading style sheets for styles on web page, and calling them in ASP.Net pages.

Created T-SQL Store Procedures that fetches relevant data for the UI from different VP Reports and Divisional Reports.

Instrumental in improving the overall quality of software and ensuring that team members follow best practices including test driven development, refactoring, and constant code reviews.

Used Agile Methodologies, test-driven development and automated builds.

Environment: HTML, JavaScript, CSS, ASP.Net, .NET Framework 3.5, VS 2008, C#.Net, SQL Server 2005, Team Foundation Server (TFS).

Novartis Mar’09 - Sept’09

Minneapolis, MN

Position: Front End Developer

Throughout the years, Novartis and its predecessor companies have discovered and developed many innovative products for patients and consumers worldwide. They offer a wide range of healthcare products in pharmaceuticals, vaccines and diagnostics, generics and consumer health.

Role:

Involved in Analysis, design and coding part.

Developed 3- tier logic for various classes, modules and web-forms in ASP.NET 3.5 using C# as a code behind language.

Created (BLL) Business Logic Layer and Presentation layer in Visual Studio .NET 2005 and C#.

Designed user interface for WPF forms and implemented application logic using C#.

Working knowledge of the Composite UI Application Block and its associated patterns.

Created Common Data Access Layer (DAL) Using Visual Studio.NET and ADO.NET.

Designed Web Form, User Interface with HTML and Cascading Style Sheets (CSS) using Macromedia Dreamweaver.

Used ASP.NET 3.0 Server controls, User Controls and HTML controls.

Designed and implemented Business Processes, & followed Abstract factory pattern as part of Service Oriented Architecture (SOA).

Designed and created Relational database tables using Normalization, Managed clustered and non-clustered indexes and implemented Relationships b/w tables.

Involved in creation of application setup and reports using ASP.NET and Validations where performed using VBScript and JavaScript.

Used Object Oriented Analysis and Design Programming (OOP) to make it more efficient.

Used ADO.NET to get the data from database and send it back.

Used Web-Services for project management, architecture, production, application development and ongoing maintenance throughout the site.

Used Design patterns for maintaining relationships between classes and objects with defined responsibilities.

Used GUI testing to check for appearance of the website.

Environment: Visual Studio.NET 2008, .NET Framework 3.5/3.0, C#, ASP.NET 3.0, VSS, PL/SQL, XML, ADO.NET, JavaScript, VBScripts, HTML, DHTML, Web services, CSS.

References are available upon request.

Contact this candidate