Sql Server .Net
Resume:
Bhanu
* *********@*****.***
SUMMARY:-
Over 7 years of IT experience in complete Software Development Life Cycle starting from System Analysis, Design, Development, Implementation, Debugging and Testing of web based, Client-server and N-tier Architectures in Insurance, Banking, Tax and HealthCare domains.
Expertise in using Microsoft Technologies such as .NETFramework(1.x/2.0/3.0/4.0/4.5), C#.NET, VB.NET, ASP.NET, ADO.NET, AJAX, WCF, WPF, Silverlight, Web Services, LINQ, Enterprise Library and Visual Studio 2005/2008/2010/2013.
Experience in working with MVC 2.0/3.0/4.0,WCF, jquery, javascript, knockout.js, telerik, SharePoint 2010/2013, architecture(ntier or SOA or 3tier or MVC pattern ), Entity data model, Linqtosql, SSIS, Razor view, Bootstrap and Biztalk.
Experience in creating dynamic web pages using ASP.NET 3.0/3.5/4.0/4.5, Webforms, User Controls, Custom Controls and AJAX Framework to obtain partial updates and faster response time.
Strong programming experience with web technologies like HTML, WebSocket, JavaScript, CSS, XML, RESTful Api, AngularJS, XSL and XSLT and developed Master pagesto build consistent and maintainable User Interface and applied CSS for a consistent look.
Worked on Database design, Normalization, stored procedures, user defined functions, views, Sitecore, cache DB and triggers for data manipulation using SQL Server 2005/2008/2012& Oracle 11g/10g/9i.
Experience in using LINQ, OOPs and the Ado.Net Entity Framework (ORM model) to query the database and to create stored procedures, triggers and functions for the report generation.
Experience in building Silverlight 2.0 applications using .NET. Involved in building a rich web experiences using Silverlight and JavaScript.
Generated reports, pie charts, layouts and custom expressions, using Crystal Reports, SSRS (SQL Server Reporting Services) and SSIS. Experience in using Web Server – IIS 5.0/6.0/7.0.
Effective result-oriented team player with excellent communication and inter-personal skills with a positive attitude towards work with adherence to time schedules and quality delivery.
TECHNICAL SKILLS:-
.Net Technologies
Microsoft .Net Framework 2.0/3.0/3.5/4.0/4.5, C#.NET, VB.Net, ASP.Net, Ajax, Win Forms, Web Services, ADO.NET, SOAP, WCF, WPF, LINQ, .Net Remoting, Silverlight2.0/3.0/4.0
Languages
C#.NET 1.0/2.0/3.0/4.0, VB.Net,SQL,PL/SQL,C, C++
Operating Systems
WINDOWS 7/Vista/ XP/ NT /2003/2000/98,Windows 2003 Server, UNIX
Web Technologies
XML, XSLT,XAML, ASP, JavaScript, JQuery, VB Script, AJAX, CSS, DHTML, HTML, IIS
Querying Languages/Reports
SQL, PL/SQL, Transact-SQL, Crystal Reports
Databases
SQL Server 2000/2005/2008/2012, MS Access 97/2000,Oracle 9i/10g/11g
Version Controller
Microsoft Visual Source Safe 6.0, Team Foundation Server
Other Tools
Microsoft Visual Studio .Net 2005/2008/2010/2013, MS Office
EDUCATION:-
Bachelor of Technology JNTU, INDIA
PROFESSIONAL EXPERIENCE:-
LexisNexis, Atlanta, GA Mar 2016 – Present
.Net Developer
LexisNexis implements a desktop application for Michigan State Police (MSP) department known as AICS(Automated Incident Capture System) in order to record and track the daily duties performed by MSP officers. Officers can capture the incidents occurred in their daily activities through the application developed.
Responsibilities:
Interacting with client for requirements, discussing the feasibility of requirements, designing the layout of application, architecture and participating in the development.
Developed .NET based multithreaded application using C#, WPF, MVVM, WinForms to enhance the application.
Developed Web Service to share application features and Prototype of SQL Server Reporting Services.
Developed the presentation layer which involved ASP.NET Web Forms, XML, User Controls JavaScript and their associated code-behind files.
Software development using Agile Software Development methodologies which involved regular stand up meetings and code reviews.
Responsible for delivering quality product and maintaining track of requirements along with BA.
Involved in creating the bug cases and resolved many of them within the time frame given.
Designed and modified Sql server 2012 database and created database tables and store procedures.
Used Cache DB to access multiple modes of databases and to increase performance.
Generated Reports using SSRS and integrated with web pages.
Responsible for Coordinating with Offshore team. Knowledge sharing within and outside the team.
Coordinating with business analyst and testing team about the requirements and working of application.
Environment: Visual Studio 2015, MS SQL 2012, WPF, C#, .Net framework 4.5, ASP.NET, AJAX, ADO.NET, Javascript, SSRS, WCF, Scrum, MVVM, Web service, SOAP.
TeleVox, Mobile, AL June 2015 - Mar 2016
.Net Developer
TeleVox software system helps the health clients by providing Medication reminders and encouragements for preventive exams are just a few of messages, TeleVox delivers to support patient wellness. Users primarily manage data & track record of various appointments with respect to large scale of operations handled.
Responsibilities:
Involved in Requirement analysis, Technical design, Database design, and development of the application.
Developed User Interface using MVC 5.0.
Used JavaScript, Typescript, HTML5, WCF controls for Client Side validations.
Used AJAX Control Toolkit extended controls for better user experience and to achieve desired functionality.
Used Master page and CSS for achieving uniformity among all the ASPX Pages.
Developed and used ADO.NET objects for handling database activities.
Assisting DBAs in SQL Queries and its performance tuning.
Wrote SQL queries with Joins on multiple tables, Stored Procedures, Functions, and Triggers.
Responsible in using JQuery for Client Side Validations and Slideshow, Calling the Controller Actions and making calls to the WCF Services.
Worked on web services to consume and to feed the data and provide security.
Used AngularJS for better user interface.
Used RESTful web Api to adopt better browser compatibility.
Designed and modified database tables and wrote complex T-SQL queries, stored procedures, and functions.
Environment: Visual Studio.NET 2013, MS SQL 2012, MVC 5.0, .Net framework 4.5, ASP.NET, AJAX, ADO.NET, Java script, Type script, SSRS,WCF, Scrum, WPF, SOAP.
AT&T, Atlanta, GA Aug 2014 –May 2015
SAS Institute,
.Net Developer
AT&T launched a new financial operating system named Tally, which will enable end-to-end payment processing, advertising budgeting, estimating, forecasting,and spend management. Tally will consolidate AT&T's budget of annual advertising spend into one, online system for easy access and reporting.
Responsibilities:
Built N-tier architecture for presentation layer, Business and Data Access Layers and written program code using C#.
Worked on the User Interface and Business logic.
Developed Web Forms using ASP.NET with C#, JavaScript, CSS.
Developed User Interface using MVC 4.0.
Used AJAX Control Toolkit extended controls for better user experience and to achieve desired functionality.
Developed Windows Services for AT&T Integrations and ecommerce applications.
Using advanced level of HTML5, XML, AJAX, JQuery, RESTful Api and pure CSS layouts
Used AngularJs to bind data Dynamically in the web pages.
Used AngularJs for DOM manipulation and for a better UI applications.
Integrated MVC 4.0 with the Sitecore CMS site to support a massive amount of content.
Created WCF service to transmit the invoiceformatted file to the client end.
Involved in testing of application by Unit Testing, Integration Testing, User Acceptance Testing (UAT) and End User Support.
Used Windows Presentation Foundation (WPF) to develop desktop applications.
Designed and implemented Data Integration and ETL processes with SQL Server Integration Service (SSIS) packages to make data available for reporting purpose within a data warehouse Environment.
Involved in writing complex stored procedures in different servers.
Environment:
IIS 7.5, Visual Studio .NET 2008/10, ADO.NET, ASP.NET, XML, .Net framework 3.5, AJAX, CSS, SSRS,WCF,MVC, SAML, WPF, SOAP, JavaScript, AngularJs, SQL Server 2008.
State Farm Insurance, Bloomington, IL May 2013 - Aug 2014
.Net Developer
The Client is a leading US insurer, one of the 20 largest corporations on the Fortune 500. It includes 79,200 employees and more than 16,700 agents servicing 71.6 million policies mainly Auto, Fire and Life and health in all 50 states of US and 3 Provinces of Canada.
It is completely online insurance based system. By logging into this system users can access their insurance account and do the upgrade/pay the premium to renewal the account. They can also add/update and delete the user profile data. This application totally built on .net technologies.
Responsibilities:
Built N-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C#. Developed application logic using C#.
Worked intensely on the User Interface eCommerce applications, Medical Claims systems and Business logic.
Developed Web Forms using ASP.NET with C#, JavaScript, CSS and Bootstrap.
Responsible for developing the application using ASP.NET MVC 4.0 with Razor syntax.
Used AJAX Control Toolkit extended controls for better user experience and to achieve desired functionality.
Worked with JQuery, HTML, WCF, LINQ for querying different datasets.
Designed custom master pages and custom page layouts. Used sessions for security and proper navigation.
Worked on VB.Net to Develop VB.Net WinForms applications.
Used Web Service to identify the user access rights and provide them access and to coordinate with external applications.
Developed Web Service to share application features and Prototype of SQL Server Reporting Services.
Used Sitecore for a better boosting search results.
Worked on MVVM, MVP design pattern with WPF, Silverlight 4.0 UX platforms.
Involved in Coding and Reviews and worked on Agile methodology.
Assisting DBAs in SQL Queries and its performance tuning.
Communication with End Users/Customer and writing Minutes of Meeting.
Responsible for Coordination with Offshore team.Knowledge sharing within and outside the team.
Environment: IIS 7.5, Entity framework 6.0, ADO.NET, ASP.NET, XML, MVVM, AJAX, Web API, CSS, WPF, Telerik, JavaScript, HTML5, Bootstrap,Sitecore, SharePoint 2010, SOA, SSRS,VB.Net WinForms,SQL Server 2008,T-SQL, DB2.
PricewaterhouseCoopers, Washington, DC Sept 2012 – May 2013
.Net Developer
RPM+ is a web application that provides common approach to preparing tax returns using the firm's standardized process called Return Process Methodology. RPM Framework hosts applications which are used by PwC users to prepare Tax file on behalf of their clients like Individuals,Partnership and Corporate.
Responsibilities:
Interacting with client for requirements, discussing the feasibility of requirements, designing the layout of web pages, architecture and participating in the development..
Designed the application with extensive use of Object Oriented programming techniques such as Inheritance, Abstraction, Encapsulation and Polymorphism.
Involved in developing the Data Access Layer, Business components and Business Layer in C#.NET, where all the Business Objects are written in developing the whole Application.
Created event driven Web Forms using ASP.NET and implemented form validation using JavaScript.
Worked on ASP.NET state Management, Caching features, configuring ASP.NET optimizations, securing ASP.NET web application.
Used various ASP .NET server controls and data controls. Customized .Net Login Controls to implementAuthentication and authorization.
Performed Unit Testing on the modules according to the requirements and development stand.
Worked on Microsoft Team Foundation Server for version control, individual task status and Database server project.
Environment:.Net Framework 3.5/3.0,C#.Net 3.0,ASP.Net3.5/3.0, JQuery, XML Web Services, IIS 7.0, Enterprise Application Blocks,MVC,Scrum, SOAP, SOA, WPF, SharePoint, LINQ, XAML, XML/ XPath, SSRS, SQL Server 2008,Team Foundation Server.
HDFC Bank, India Aug 2011 - Sept 2012
Retail Banking
.Net Developer
This Banking product designed to suit the HDFC bank. It provides complete, comprehensive, integrated solution to HDFC Bank. The Integration of all modules like deposits, loans, clearing, general ledger, DD/Bills, signature/Photo verification, head office solution. Provision for backdated reports, Batch concept for general ledger transfers entry.
Responsibilities:
Involved in all phases of SDLC.
As a team member, developed the components using VB.NET.
Responsible for creating Web Forms using several ASP.NET server controls.
Created User controls and Custom Controls like Calendar Control, Login Control, and Error Control, Header Control and Footer control.
Developed the data binding and Data Access with ADO with SQL Server using VB.Net.
Developed several stored procedures in SQL Server 2005 and optimized Queries.
Configuration management of code done using VSS.
Environment: .Net Framework 3.0, HTML, ASP.NET, VB.NET, Oracle 9i, VSS
Navayuga InfoTech, Hyderabad, India Oct 2010 - June 2011
Financial System for Publishing Companies
Jr.Net Programmer
SOFIA is a financial system for Publishers, which control all the financial aspects of wholesale and retail publishing. The system is able to manage wholesale (to Reselling) and direct sales (to individuals). SOFIA is a typical system that includes modules such as Inventory control,Shipments, Sales, Account Receivables, Account Payables and General Ledger. The System is a Web Application developed on ASP.NET Technology and included building a Windows based front-end interface for managing the system and database.
Responsibilities:
Involved in Design, Development and Testing of Windows Forms, Web Forms and Web Services using IIS, ASP.NET, XML Dataset and .NET Framework.
Design and developed components using C#.NET.
Created Role Based security levels for Windows Forms Authorization.
Implemented server caching techniques, state management, windows and FormsAuthentication in ASP.NET.
Involved in customizing the Windows Forms Data grid.
Developed custom controls for Windows Forms and generating reports.
Involved in the development of SOAP based XML Web Services like Financial account management and Purchase Orders which forms the business logic components of the system.
Prepared Test cases provided technical documentation.Used the N-Unit for unit testing of the classes.
Environment: ASP.NET, C#, IIS 5.0, ADO.NET, Visual Studio.NET and XML, XML Web Services, XSL/XSLT, SOAP, JavaScript, SQL Server 2005, Windows 2000.
Contact this candidate