Sql Server .Net
Resume:
SHASHANK
*********@*****.***
PROFESSIONAL SUMMARY
●7+ years of Software Application Development, testing and implementation experience with Web based and N-tier Architecture involving all stages of Software Development Life Cycle (SDLC).
Experience in Development methodologies like Agile/Scrum, Iterative, and Waterfall models.
●Experience in using VB Script, Themes& Skins, User controls and Custom Controls in ASP.Net.
●Expertise knowledge on HTML5, XHTML, JavaScript, BootStrap, VBScript, COM, DCOM, Classic ASP applications, XML, XSLT, CSS.
●Extensive working experience in database design and development, for creating complex database queries, writing Constraints, Indexes, Views, Stored Procedures, Triggers and Functions using SQL Server 2008/2012.
●Expertise in developing Web-based and Windows-based applications using C#, VB.NET, ASP.NET, ADO.NET, AJAX, SQL-Server 2012/2008/2005 and Visual Studio 2013/2012/2010/2008/2005.
●Experience in C#. NET and ADO.NET to define and implement secure middle-tier components consumed by web applications and windows applications utilizing SQL Server and stored procedures to perform logical business transactions.
●Strong command over VB6 and earlier versions of Visual Basic.
●Used mainframe transactions for the distributed applications having VB front end and DB2 backend.
●Experience in Implementing SOA using .Net Web Services (SOAP, UDDI, and WSDL), WCF.
●Experience in building Web services using ASP.NET Web API and performing CRUD operations using REST API.
●Hands on experience in developing applications to access data and data services in ADO.NET.
●Worked extensively with different ADO.NET objects to interact with database and good experience in using ADO.Net objects such as SQL Connection Object, SQL Command Object, Data Reader, Dataset and Data Adapter.
●Experience in working with IIS, ActiveDirectory and Security in ASP.NET applications.
●Proficient in Implementing Design Patterns like singleton and Abstract Factory for solving some common problems in software design.
●Hand on experience in developing applications using ASP.NET MVC 4/5 and MVVM architectures.
●Skilled inimplementing Design Patterns, LINQ, XML/XSL, Angular JS, JSON, JQuery, Web API, Web Services, WCF,Windows WorkflowFoundation (WWF), Web Parts and Custom Controls.
●Created Entity classes, relationships between entity classes using LINQ (Language Integrated Query) to SQL to manage relational data as objects with Entity Framework 4.0.
●Increased response time and usability using AJAX.
●Expertise with application development using Object Oriented Analysis & Design techniques (OOAD).
●Moderate experience in configuring Virtual machines for SQL Server 2012 and Azure Active Directory in Microsoft Azure.
●Working knowledge of Windows Presentation Foundation (WPF), which provides developers with a unified programming model for building rich windows smart client user experiences that incorporate UI, media and Documents.
●Worked on latest technologies like Telerik Rad Controls for .NET.
●Experience in developing UMLdiagram including Use Case diagram, Class diagram and Sequence diagram, Use Cases modeling.
●Experience in writing SSIS Packages/SSRS in SQL Server
●Experience with using version control tools like Team Foundation Server&Visual Source Safe.
TECHNICAL EXPERTISE
Frameworks:
.NET Framework 4.5/4.0/3.5/2.0
Microsoft Technologies
C#,VB.NET, VB6, ASP.NET 3.5/3.0/2.0, ADO.NET, Web Parts, AJAX, Web Services, WCF, WPF, WWF, Web API, WSDL, Azure, Telerik Rad Controls for .NET.
Other Technologies
JavaScript, jQuery, JSON, jQuery UI, HTML, CSS, Angular JS, Bootstrap, PHP
Operating System:
Windows Server 2012/2008/2003 and Windows 7, Windows 10 and UNIX
ORM:
Entity Framework, LINQ to SQL
Modeling tools:
Microsoft Visio, Rational Rose
Development tools:
Visual Studio 2013/2012/2010/2008/2005
Data bases:
Microsoft SQL Server 2012/2008 R2/2005,
Oracle 11i/9i/8i, MS-Access, SSIS, DB2
Web servers:
Internet Information Server(IIS) 8.0/7.0/7.5/ 6.0
Version Control Tools:
Team Foundation Server, Visual Source Safe
Testing Tools:
Visual Studio Integrated Unit Testing Framework, NUnit 2.4
Qualification:
●Bachelor’s Degree in Computer Science from JNTUH.
Work Experience:
CIGNA Healthcare, Windsor, CT Mar 16 - Till date
Sr .Net Developer
Project Description:
Cigna is a global health service company, dedicated to helping the people improve their health, well-being and sense of security. In my project, which consists of 10 applications, I supported 7 applications among which four are distributed standalone applications and the remaining three are web applications.These applications are used to maintain provider’s data, Direct deposit EFT information, Credentialing data of the providers,Network marketing and Business rules and National Provider Identifier(NPI) information.
Responsibilities:
●Involved in business meetings for all the requirements to give the estimates of the effort for the changes to be made.
●Performed analysis in different stages of SDLC in order to support development.
●Prepared Technical Design Specifications(TDS) for every requirement on the basis of the user stories given in functional specifications.
●As an onsite developer, lead a team of five from the offshore, coordinated with them to walkthrough the requirements and make them work efficiently.
●Extensively worked with Visual Basic(VB6) in four Distributed applications.
●Understanding business logic description under close supervision of senior programmers and experienced software professionals.
●Learning development of proper VB code, VB scripts and use of ActiveX controls and objects while programming
●Participated in updating the existing programs, and making changes in the existing systems.
●Working with DLL and EXE files and understanding VB development in the .Net framework
●Used Mainframe transactions to get data from the DB2 database using COBOL programs.
●The backend resided on mainframe DB2 tables which interfaced with VB via DLL called CICSctrl, which uses Mainframe Transactions.
●Utilized version control and synchronized code through SourceSafe.
●Used Microsoft SQL server 2012 as a backend database for Distributed and Web applications.
●Working knowledge in web applications having VB.net with DB2 backend and C#.net with SQL Backend.
●Worked with a view-only web application developed in Classic ASP and VB Script.
●Deployed code to different environments whenever a change is made to any application, as a part of a release.
●Extensively worked with the stored procedures in SQL Server 2012.
●Team Foundation Server 2013 and 2015 are used as version control for the web applications.
●Used IBM DB2 client for configuring Db2 database, Command editor and Query editor.
●Involved in few migrations tasks i.e. migrating windows SQL servers from W2K3 to W2K12 and also migrating some of the web servers.
●Worked with reporting tools like Hyperion reports and SSRS reports.
Environment: Visual Studio 2015, ASP.Net 4.5, C# 5.0,VB.net, VB6, Classic ASP, VB Script, XML, JavaScript, and SQL Server 2012, IIS 7.5, Web Services, TFS, Toolkit Control., TFS 2013/2015, DB2, SSRS, Hyperion reports
Sterling bank, Houston, TX May 2014 – Feb 2016
Sr .Net Developer
Project Description:
Sterling Bank of Texas is one of the premier financial service organizations in Texas. In this project, I was involved in developing a web portal for the online personal banking module. The bank provides different services like personal banking, business banking, International banking, credit card, brokerage, Home loans, POS and Insurance plans.
Responsibilities:
●My current responsibilities include performing analysis into the different stages of the system development life cycle in order to support development and testing efforts, identify positive and negative trends, and formulate recommendations for process improvements and developments standards.
●Involved in a day-day Scrum Software development methodology and Test Driven Development TDD
●Extensively worked in Entity Data Model for implementing Business logic and Data Layer using Entity Framework 4.0
●Highly Involved in Creating Structure and UML Diagrams (Structure Diagrams, Logical Diagrams, and Use Case Diagrams) in assistance with Business Analyst.
●Developed Application layer using ASP. Net, Server controls, HTML Controls and Validation controls.
●Developed Application using .NET Framework 4.5, Object Oriented Principles (OOP), and n-Tier Architecture.
●Effectively created easy to use, reusable controls and Master Pages and integrated them into ASP.NET web pages with MVC 4.0.
●Designed Graphical User Interface (GUI) for various web pages using, HTML5, CSS 3, JavaScript and JQuery.
●Used Bootstrap 3.0 for Responsive web design.
●Used Angular JS for developing single page applications and calling web services.
●Created Inbound and outbound WCF services / Web Services to integrate with Email client and support applications using C#.Net
●Wrote Data Access Layer Methods, T-SQL Queries, Store Procedures, and SQL User Defined functions for fetching Transaction details, Customer Details, and Product Configuration data.
●Heavily used LINQ to SQL to retrieve data about Customers & Transactions.
●Developed DAL using LINQ Data context object with ADO.NET Entity Framework for LINQ, invoked DB tables and stored procedures and Implemented LINQ Lambda Expressions to query in memory expressions.
●Used Microsoft Team Foundation Server for the purpose of version Control and source code maintenance needs.
●Involved in Unit testing, Modular testing, Integration testing and successful integration of modules and multiple layers in the system.
●Used Microsoft Test Manager in Visual Studio for running Action Recorded Test Cases and Regression Tests.
Environment: C#.Net, Object Oriented Methodologies, Visual Studio 2013, SQL Server 2012, ADO.NET, .NET Framework 4.5, HTML, CSS, jQuery, Bootstrap, Web Service, WCF, XAML, LINQ, IIS 7.5, MS VISIO(UML), N-UNIT, n-tier architecture, Agile Methodology, Team Foundation Server (TFS), MVC 4.0.
United Health Group, Golden Valley, MN Jan 2013 –Apr 2014 Sr.NetDeveloper
Project Description:
United Health Group is a leading provider of health care insurance offering services in all 50 states, serving almost 70 million Americans. They provide a full range of business services to meet the complex needs of national employers and health plans. In addition to health insurance, UHG provides dental coverage, group life, disability, long-term care, pharmacy and more. HRMS is a web based three-tier architecture system that provides information about employee data, new hire, applicants, promotion, demotion, leave of absence, payroll data and change of certain business rules that required development of new modules to the system.
Responsibilities:
●Involved in analysis, design and code different modules using C# which deals with the clearing of checks, updating the corresponding policy in database.
●Used AngularJS to create Rich Internet Application (RIA) with features like Data-binding, Scope, Filters, directives, services, routing.
●Used ADO.Net, LINQ in connecting to Data Access management with SQL Server.
●Designed and developed the C# components for implementing business logic which is used to do the transactions on database in middle tier using ADO.Net Entity Framework.
●Worked on the Claims Management Program in Property & Casualty Module.
●Designed and developed the required SQL stored procedures on SQL Server 2008 R2.
●Deployment of WCF web services for online transactions using C# and exposed them through SOAP and HTTP.
●Conducting meetings to establish and enforce best practices and standards.
●Actively participated in Peer reviewing of the code for maintaining the quality of coding and application.
●Maintained the code in TFS and set up the builds.
●Designed web pages using ASP.net server controls, HTML, AJAX, CSS, Bootstrap and JavaScript.
●Implemented client side scripting using JavaR2Script/JQuery and server side coding using built in ASP.net controls and C#.
●Used Update Panel, Update Progress with Data Grids in AJAX and JavaScript
●Developed web forms with C# to store the customer policy data in Database.
●Used Team Foundation Server (TFS) extensively for version control of the source code along with the maintenance of the builds and the relevant documents of the same.
●Used SSRS Reports to generate reports
Environment: Visual Studio 2010, ASP.Net 3.5, C# 3.0, Angular JS, WPF, ADO.Net, LINQ, HTML/DHTML/CSS, XML, JavaScript, HTML and SQL Server 2008, IIS 7.0, WCF, Win Forms, Web Services, Bootstrap 2.3, TFS, AJAX Toolkit Control., TFS, Oracle.
Mid-American Energy, Des Moines, IA Aug 2011 – Dec 2012
Sr.NET Developer
Project Description:
MidAmerican Energy Company is the largest utility located in the middle of several major markets in the Midwest (Iowa). Provide service to more than a million electric and natural gas customers. This project has been Design and developed of a new Electric Retail Pricing System using .Net technologies by which the system generates electric price quote for a business customer which will be used by several departments.
Responsibilities:
●Participated in requirements gathering and compiled them into design document.
●Followed agile methodologies (Scrum) and Test Driven Development.
●Implemented MVC architecture.
●Developed multi-tiered ASP.NET web applications using C#, HTML5, CSS.
●Created use case and class diagrams in MS Visio using UML notations.
●Involved in Discussion Board for Client Interaction for the change requests and follow-ups.
●Developed middle layer using C#.Net.
●Used ADO.NET Entity Framework for data retrieving, querying, storage and data manipulation.
●Created and consumed Web Services in the services layer.
●Worked with REST based services using MVC, WEB API
●Created WCF service to consume in the middle tier.
●Maintained the WPF and Win Forms applications used by the in-house staff
●Worked with Object Oriented Design Patterns and Object Oriented Programming concepts
●Worked with ADO.NET, LINQ, Entity Framework to integrate the database with the applications
●Created Joins, Views, functions, stored procedures, indexes and triggers as part of the database programming.
●Involved in performance tuning and query optimization.
●Worked on the helpdesk tickets and resolved by debugging the existing applications
●Maintenance/Enhancement of Project and handling/fixing bug on daily basis reported by Help Desk
●Monitored backend processes like ETLs, report generation, and rule engine processing.
Environment: .Net Framework 4.0, Visual Studio 2010, C#.NET, JavaScript, JQuery, Web Services WCF, REST, WEBAPI, Win Forms, XML, XSD, XSLT, WPF, UML, MS Visio.
AmplisoftPvt Limited, Hyderabad Oct 2009– Jun 2011
Jr. Software Developer
The solution tracks and manages the deployed software and hardware assets of the organization through its Agent-Server based system. The agent runs as a windows service on each of the desktops in the organization. While agent gets registered on the desktop it tracks down all the installed software’s and hardware’s and posts the data to the I-TAMS server. The agent also captures events such as application open and close, new installation / un-installation of software’s and posts data to the data base on a pre-configured time. The solution also features alerts & reports, which are generated on user/Desktop/Enterprise basis. These will be accessible only to the management and the administrator.
Responsibilities:
Developing UI Layer, Business Logic Layer, created database Stored Procedures, unit and integration testing of the application.
Created custom ASP.NETuser Controls used in the entire application for reusability.
●Developed Business logic layer using Object Oriented Methodology.
●Extensively worked on ASP.NET
●Created Web Service in ASP.Net as Database Layer.
●Performed data validations using validation controls.
●Created Stored Procedures that encapsulated business rules and data validation.
●Connecting to the backend through ADO.Net for interacting with database objects.
●Involved in PL/SQL programming for SQL Server 2000 for creating triggers, functions and stored procedures.
●Imported Excel data into MS SQL Server 2000.
●Involved in Configuration and Implementation of the entire application.
●Documented the system and all the configuration instructions for every release.
Environment: .NET Framework 2.0, ASP.NET 2.0, VB.NET, Visual Studio 2005, Win forms, Web Services, SQL Server 2000, JavaScript, HTML, CSS, XML, VSS 6.0
Contact this candidate