.Net Sql Server

Poorna Chandrasekhar Reddy

Mobile: 513-***-****

**********@*****.***

Professional Experience/ Summary

Microsoft Developer with 9+ years of experience in software design, development, implementation and maintenance.

Extensive experience work with ASP.NET (4.5/4.0/3.5/3.0/2.0), C# .NET, VB.NET, WEB API, WCF, MVC and XML.

Strong Object Oriented Analysis and Programming skills.

Experience includes Design, Development, Integration testing and Implementation of Enterprise Distributed systems.

Extensive experience with database development using SQL Server and Oracle

Extensive experience in XML, Web Services and WCF.

Extensive experience in developing Web based and Client/Server applications using C#, ASP.NET ADO.NET, VB.Net, LINQ to SQL, LINQ to Objects, LINQ to Entities, Entity Framework, XML, HTML, XHTML, JavaScript, JQuery, Json, AJAX and CSS.

Extensive eexperience in creating SharePoint sites, sub sites, Web Parts, Lists and Events.

Strong skills in working with version controlling tools using SVN, VSS and TFS.

Ability to learn new technologies and challenging concepts quickly and implement them.

Excellent analytical, problem solving, decision-making and presentation skills with ability to co-ordinate activities in a fast paced team environment.

Good experience in handling multiple projects within the timelines

Extensively involved in interacting with clients and various technology teams in analysis and resolution of production issues.

Expertise in database development, creating stored procedures, and user defined functions and triggers using Microsoft SQL Server 2005/2008/2010, Oracle 9i/10G and Sybase.

Ability to work productively and effectively in a team as well as individually to meet the Project deadlines.

Experience in end-to-end full lifecycle (SDLC) of software developments, including configuration management using Visual SourceSafe and TFS.

Experience in working with Agile using Scrum methodology

Excellent communication and interpersonal skills

Technical Skills:

Programming Languages

Dot NET 1.1/2.0/3.5/4.0/4.5, Vb.Net, C#. Net, ADO.Net, LINQ, SQL, PL/SQL, XML, HTML, XSLT, MVC, Entity Framework,

Web Technologies

ASP.NET, Ajax, Web API, WCF, Web Services, REST, CSS, JavaScript, JSON, JQuery and AngularJS.

DataBase

SQL Server 2005/2008, Oracle 9i/10G and Sybase

Operating Systems

Win 2003/XP/2000/NT.

Version Control

SVN,VSS and TFS

Miscellaneous

TOAD, Oracle SQL Developer, Telerik RadControls and Infragistics Controls for UI.

Testing Methods

NUNIT

Work Experience:

OHL, Nashville TN March 2015 to Till Date

Senior .Net Developer

Project # Web Synapse - YMS

Web Synapse is a Yard Management System (YMS) designed for OHL customers. It offers simplicity and standard functionality for all customers. It focuses on Inbound and Outbound processes performed through Synapse web application. Inbound is a receiving process and outbound is a shipping process. As a part of Inbound, OHL customers can login and schedule an appointment for the trailer in the warehouse for a specific zone or door. Warehouse gate keeper checks the trailer and move to the yard locations for loading/unloading. Outbound is to load/unload the trailer and to shipping.

Responsibilities:

Design and Develop the Synapse - YMS Modules utilizing previous experience in web application development and best practices in test-driven development.

Development using AngularJS, JQuery, C#, Web API services and Oracle 10g

Responsible to design user interface (UI) using AngularJS and Bootstrap.

Developed the controllers to interact with view and modal.

Responsible to create the directives for header, side menu and grid, in order to use in entire application.

Responsible to develop the service layer and modal layers to interact and fetch data from the back-end.

Responsible to create the packages, stored procedures using Oracle SQL Developer.

Used SVN as repository for this Web Synapse – YMS application.

Used Resharper for best code practices

Environment: Visual Studio 2013, C#.NET 4.5, MVC, Web API, REST, AngularJS, Bootstrap, JavaScript, JQuery, CSS, SVN, Oracle 10g, IIS, Rest Services, Resharper and Oracle SQL Developer.

Anthem INC, Mason OH Feb 2014 to March 2015

Team Lead

Project # Virtual processer online Portal

Virtual Processor (VP) is a claim adjudication system. This system adjudicate the ITS, NON-ITS, and adhoc requests for multiple business users through Facets and Automation Anywhere product.

Virtual process online portal is a tool, developed to monitor the claim adjudication process and to reset the instance of ITS and NON-ITS claims. This application has feasibility to upload and view the status of the adhoc requests. An email notification will send to the users to export their adjudicated data after adhoc process completes. This portal also has the summary chart, which shows total, processed and remaining claims.

Responsibilities:

Design and Develop Virtual Processor Modules utilizing previous experience in web application development and best practices in test-driven development.

Development using Asp.net,C#, WCF, JavaScript, JQuery

Perform end-to-end scenario testing before deploying to production environment.

Build automation using PowerShell and build scripting for automatic builds.

Deployment Scripts development for application deployment to QA, pre-production and production environments.

Debugging, troubleshooting issues, fixing bugs and perform regression testing and apply standard troubleshooting techniques when blocked prior to escalation.

Ensuring that the delivered artefacts meet customer requirements & agreed quality standards.

Environment : VS 2010, C#, ASP.Net, WCF, Telerik Control, JavaScript, JQuery, Ajax, CSS, SQLServer 2008, IIS, Rest Services, Sybase.

WellPoint INC, Richmond VA July 2013 to Feb 2014

Senior .Net Developer

Project # BDS Rewrite

BDS (Business Distributor System) is developed to provide the information to direct any contact with the company/our Customers and Members to the system, location, business unit or individual who can address their needs.

BDS can be used by any system or individual to identify where to send a contact. The member information provides a view of the member’s history with the company that cannot be obtained in any one of the processing system. For any given point in that history, it provides the system, phone numbers, and code assigned to an individual or area of the company. The defined routing is independent upon the system sending updates, can be set up to be time sensitive, and provides history capabilities.

Responsibilities:

Developed core Solution and Framework components using MVC, EF to address main business requirements.

Designed the User Interface framework, template layout using Master Page, C#.Net, Advanced CSS and Jquery.

Developed the Custom Controls using grid view which supports Custom Paging, Sorting and Filtering

Used NUNIT for writing testing script and Gallio for Testing Application Functional Logic.

Parsing, querying, scraping, and transforming XML, HTML, and JSON

Experience in consuming, building and implementing Web Services using SOAP and REST Protocols.

Utilized JavaScript to create Server Side and Client-side validations and enhanced using JQuery.

Used Windows Communications Foundation (WCF) for Application implementation.

AJAX calls were made to REST service and data was retrieved in (JavaScript Object Notation) JSON format for display.

Extensively worked with the java scripts and client side validations.

Involved in creating tables, stored procedures in SQL for data manipulation and retrieval.

Developed Queries to fetch data from different tables in SQL database using joins.

Implemented Windows services to run batch job’s and schedule services.

Conducting requirement and code walk thru.

Environment: Microsoft Visual Studio 2010, ASP.NET MVC, REST, C#, LINQ, HTML, IIS 7.0, SQL Server, TFS, and WCF.

Hoag Memorial Hospital Presbyterian, Newport Beach CA Jan 2013 – July 2013

Senior Developer

Project # Community Portal

Hoag SharePoint Community Portal develop is a portal development project wherein the existing legacy portal is being reengineered using SharePoint so that the contents of the portal can be updated dynamically from the back-end of Portal Administrator. The Objective of this portal explains about the Hoag memorial hospital Specialties and Services, Locations, Patients, Visitors and Find a Doctor Search. Viewers can search their doctors with their location, specialty and doctor’s Last Name.

Responsibilities:

Designed and developed user interface using SharePoint 2010 and ASP.Net

Extensively worked for creating the Sub sites, Lists, Libraries, Web parts and Blogs etc.

Extensively worked Creating content pages, templates and Events.

Change the look and feel of the page using SharePoint Designer

Utilized JavaScript to create Server Side and Client-side validations and enhanced using JQuery.

Used Windows Communications Foundation (WCF) for employee data display and validation

Extensively worked with the java scripts and client side validations.

Expertise in Health Insurance Domain.

Consumed web services developed on various platforms

Developed Stored Procedures, Triggers, Views

Environment: SharePoint 2010, SharePoint Designer 2010, Asp.Net 2010, C#.Net, SQLServer, JavaScript, JQuery, AJAX, HTML, CSS, WCF and IIS

Hoag Memorial Hospital Presbyterian, Newport Beach CA May 2012 to Jan 2013

Senior Developer

Project # Patient Portal

Hoag SharePoint Patient Portal develops is a portal development project. The objective of this project deals with Hoag hospital patients. Patients create their credentials and login into portal to schedule an appointment with specific specialty doctors.

Responsibilities:

Designed and developed user interface using SharePoint 2010 and ASP.Net

Developed Application with ASP.Net and C#

Extensively worked for creating the Sub sites, Lists, Libraries, Web parts and Blogs etc.

Extensively worked Creating content pages, templates and Events.

Change the look and feel of the page using SharePoint Designer

Expertise in Healthcare Domain.

Environment: SharePoint 2010, SharePoint Designer 2010, Asp.Net 2010, C#.Net, SQLServer, JavaScript, JQuery, AJAX, HTML, CSS, WCF and IIS

Client: Walgreen Health and Wellness, India Feb 2011 – May 2012

Senior .Net Developer

Project # EMR & Kiosk - Clinic Closure

The EMR application caters to automate the medical record maintenance for TCH clinics. Together the EMR and KIOSK applications automate the entire process of Registration as well as Diagnosis for the patient. KIOSK Application is used by patients to register in the TCH clinics and schedule an appointment. EMR application is used to maintain and prepare records for Patient Visits.

The goal of the Clinic Closure project is to convey the most up-to-date and accurate clinic status to patients. The kiosk, queue monitor and consumer website are all patient-facing tools that provide patient information, including whether the clinic is open or closed. Successful completion of this project will allow user-control of these tools to update patients on when the clinic is closed for the day, opening late, or closing early.

Responsibilities:

Developed Business, Data and Presentation layers of the application.

Developed framework based Business entities and operations to support many products such as Prudential Insurance products such as Omni Views and, LFA/SFA etc.

Developed WCF services to access Business entities and methods.

Developed WCF services, Business entities and methods required for the Silverlight application.

Utilized LINQ to implement different operations efficiently to integrate data validations and business logic rules..

Worked with DB team, QA team, Business Analysts and users to analyze and implement the requirements efficiently.

Performed client side validation using JavaScript, JQuery.

Implemented Windows Communication Foundation (WCF) services.

Used JQuery extensively to perform JavaScript validations and AJAX updates.

Expertise in Healthcare Domain.

Environment: .NET 3.5, ASP.Net MVC, WCF, VB.Net, CSS, XML, SQL Server, EF, JQuery, JSON, IIS,TFS and Telerik RadControls for UI.

3I-InfoTech, India Mar 2010 – Jan 2011

.Net Developer

V2O [Valley Virtual Office]

V2o is a water application with sprinkler product. The sprinkler package is the part of the machine that delivers water to fields through a series of spans. This application belongs to Irrigation domain where the dealers logged into and apply for designing the sprinkler machine. The design contains the basic information related to the dealer’s and customer information, machine specifications, spans and Endguns configurations, Sprinkler section with available outlets, computer spacing and finally calculating the design. Based on the design selected, order will be generated and send to customer. This Application also has the generating reports and emailing.

Responsibilities:

Created design documents for the requirements.

Involved in all phases of development includes analysis, design, development and Unit Testing.

Involved in designing and developing the GUI for the user interface with various controls (Data Grid, Data List, Textbox, Calendar, List Controls,Dropdown, Validation Controls etc)

Designed Cascading Style Sheets for uniform look of the web pages.

Developed various web user controls for the website.

Developed the pages using ASP.NET, ADO.Net and XML.

Developed SQL, functions and triggers as part of various modules.

Involved in the weekly builds and monthly releases.

Utilized ADO.Net technology extensively for data retrieving, querying, storage and manipulation.

Developed the UI and implementation for important modules.

Responsible in following the agile using Scrum methodologies

Expertise in Irrigation domain

Environment: .NET 3.5, Asp.Net, C#.Net, CSS, HTML, DHTML, JQuery, Oracle 10g, Java Script, Windows XP, IIS and TFS.

Atlas Systems, India May 2008 – Mar 2010

.Net Developer

Project #1 Xchange System

RegEd implements the Xchange System for various clients to support clients to comply with legal requirements as required by various government agencies. The Xchange integrates with NASD CRD (Central Registration Depository) System for various filing and approval process. NASD registers member firms, governs and examines them for compliance and disciplines non-compliance.

The Xchange provides user interface to its users to enter filing and compliance information from time to time.

Responsibilities:

Involved in SDLC from the requirement gathering, unit testing and deployment of the application module.

Designed and developed the application in ASP#. NET

Developed different types of validation rules as per business requirements.

Designed and implemented rules module that enables user to create custom rules on the fly.

Created C# and ASP.net web pages for user to create different validation rules.

Generated code using code smith for the tables in SQL Database which is in all layers of the Entity Frame work.

Used Infragistics Controls for uniqueness in look and feel of UI pages.

Created stored procedures those gets/updates data required by validation framework and web application.

Involved in Unit testing.

Environment: C#.NET 1.1, ASP.NET, ADO.NET, HTML, XSL, XSLT, XML, Oracle 9i/10g, Java Script, Web Services and VSS

Project #2: Survey Information System Dec 2007 – May 2008

J.D. Power and Associates is a global marketing information firm that conducts Independent and unbiased surveys of customer satisfaction on product quality and buyer behavior. The desktop analyzer is a web based tool where end users can access worldwide and analyze the syndicated studies of Auto mobile industry about Customer Satisfaction Index study (CSI). This application is designed to represent the statistical view to business analyst to measure market performance and customer satisfaction about product. The desktop analyzer tool is fully customized according to meet the requirements of Client such as Toyota and Lexus Motors etc…

Responsibilities:

Created web forms using MS Visual Studio .Net, ASP.Net, C#, XML and HTML.

Created User Controls to be used across the application.

Used ADO.Net in connecting to Data Access management with SQL Server 2000.

Design and implement the GUI (ASP.Net) with web form controls, web-server controls including Data Grid, Data List.

Designed and developed the C# components for implementing business logic in middle tier in 3-tier application interacting with SQL server database using Managed provider using ADO.Net.

Used ADO.Net technology extensively for data retrieving, querying, storage and manipulation.

Implemented windows services to automate mailing and batch process.

Created Cristal reports for Card Enrolments and DTS packages for data transformation.

Worked on master pages, site login controls and common utility functions.

Wrote client scripts in java script for client-side validation.

Environment: .NET 2.0 C#, ASP.NET, HTML, ADO.NET, SQL SERVER 2000, Java Script and VSS.

Project#3 Procity July 2006 – Dec 2007

The ProCity is project management software that allows users to track the issues and tasks during the course of a project and derive statistical information presented in the form of charts. A User depending the roles can define a project(s), assign Issue(s)/Task(s), modify Issue(s)/Task(s), update Time sheet, view various charts provided as a Dash Board, And Run Reports.

Responsibilities:

Implemented business logic and validations using C#.

Created store procedures in SQL Server

Used ADO.NET technology for data retrieving, querying, storage and manipulation.

Created three user controls named as Simple Search, Advanced Search and Search Picker.

Worked on TTD and FSC documentation.

Developed classes and interfaces for the Data Access layer using C#.NET ADO.Net, and SQL Server.

Extensively used Data Grid, Data list and Repeater controls.

Created ASMX Web Services.

Developed custom controls and used validation controls available in .NET environment.

Involved in extensive use of XML in data representing from the back end.

Performed debugging and exception handling in support to the software development.

Responsible for performing unit testing and Integration testing.

Used Cascading Style Sheets (CSS) to attain uniformity of all Forms. Used HTML, CSS and XSLT for styling the Forms

Environment: .NET 2.0, C#, .NET, ADO.NET, SQL SERVER 2000/2005, Java Script and VSS.

Educational Qualification:

Bachelor’s degree in Computer Science from Anna University.

Contact this candidate