** ***** ** ************ ** experience in full life cycle development in designing, developing and implementing Web-based and Client-Server Applications using .NET Framework.

Experience in all phases of software development life cycle like Requirement Analysis, Design, Development and Unit testing of applications.

Extensive experience in working with technologies like Visual Studio .NET 2003/2005/2010/2012, C#.NET, ASP.NET, ASP.NET MVC, VB.NET, .NET Framework 1.1/2.0/3.5/4.0/4.5, ADO.NET, Web services, WCF, Web API, VB6 and SharePoint 2010.

Experience in development with SQL Server 2008/2005/2000 and Oracle.

Experience in using Language-Integrated Query (LINQ), ADO.Net Entity Framework 4.0/5.0 to query and retrieve data.

Good experience in writing SQL queries, and T-SQL blocks like - Stored Procedures, User Defined Functions and Triggers

Experience in creating Web Forms, Win Forms, User Controls, Custom controls and validating user inputs using validation techniques.

Very good exposure to development with Java Script, JQuery, JSON, HTML, DHTML, XML, XPATH, XSLT, Themes, Skins and CSS.

Have working experience in developing MVC Razor views.

Proficient in performance tuning of complex SQL queries and stored procedures by using Explain Plan.

Have working experience in K2 Workflows.

Extensive knowledge of applying Object Oriented Analysis and Design (OOAD) concepts and Design Patterns.

Very good knowledge of CMMI quality processes.

Experienced with Class diagrams, Use Case diagrams and Sequence diagrams using UML with MS VISIO.

Experience with version Controls like Visual Source Safe (VSS), Team Foundation Server (TFS) and Sub Version (SVN).

Worked extensively with Iterative Agile Methodologies (SCRUM), Waterfall methodologies and Test-driven development (TDD).

Researched new technologies, evaluated their usefulness, and incorporated them into the existing architecture.

Ability to work in the complete software development life cycle involving development and testing.

Ability to work well in both a team and individual environment.

Highly motivated, detail oriented, has ability to work independently and as a part of the team with excellent Technical, Analytical and Communication skills.

Capable to deliver into the new leading technologies.

Good at interpersonal skills, committed, result oriented, hard working with a quest and zeal to learn new technologies.

TECHNICAL SKILLS:

Languages

Programming Languages - C#.Net, VB.Net,

Database Query Languages - PL/SQL, T-SQL (DDL, DML).

Scripting Languages – JavaScript and VB script.

Platforms/ Applications

Microsoft Technologies - .Net 1.1/2.0/3.5/4.0/4.5, Win Forms, LINQ, WCF, MVC, Web API, Unit testing Framework, SharePoint 2010, K2 Workflow, MSMQ, VB6 and VBA Macros

Web Technologies - ASP.NET, ASP.NETMVC,

Ajax, Html, JavaScript, ADO.Net, JQuery, CSS and Xml

Databases

SQL Server 2000 / 2005 / 2008, TSQL, PL/SQL, Oracle 10g, My SQL

Software

Design Tools - UML, Web UML Diagrams

GUI Tools - Visual Studio (2003, 2005, 2008, 2010 and 2012) and Visual web developer.

Database Tools:-Microsoft SQL Server2008/2005/2000, Toad, SQL Developer, MY SQL. Deployment/Web Servers - IIS 7.0, 6.0.

Version Controls- VSS, TFS, SVN.

Testing Tools – NUnit Framework

Operating Systems

Windows 7/2000 / XP, Windows Server 2003, Windows Server 2008/2012

CERTIFICATIONS:

MCPDEA: Microsoft Certified Professional Developer

Microsoft SharePoint Certification

OCA: Oracle Certified Associate

PROFESSIONAL EXPERIENCE:

Combined Insurance, Chicago, IL Jan’2015 –Till Date

Role: Senior .NET Developer

eAgent Application

The objective of eAgent application is to enable agents in the field to sell policies using tablets. An important benefit to this application is that it eliminates the manual work in digitalizing all the policy information, and greatly increases the agent’s productivity compared to the previous paper submission process.

Sales agents use IPads to draft and sell policies using a mobile application developed in IOS. This application has all the features like predefined policy templates based on the US state the mobile user is licensed. It enables the mobile users to save an incomplete policy as a draft and work offline. The mobile app contains a report where the user can see a summary of the submitted policies. Once the policy is completed with signatures and payment, the mobile user can sync the policy over the Cloud to the eAgent system. Syncing would push all the policy related information to Dynamics CRM which acts as a middleware or intermediary storage. The integration jobs in Dynamics CRM would subsequently move all the new policies to the backend mainframes. Dynamics CRM currently hosts several dashboards and reports that facilitate managers to keep track on agent performance under their responsibility.

Worked on new enhancements and maintenance in Microsoft Dynamics CRM using C#.Net and SQL Server.

Used CRM Web services to retrieve and update entity data.

Designed and coded asynchronous messaging system using MSMQ, reflection, and XML serialization

Involved in Code Review for business logic modules and prepared the code review documentation.

Used MSTS Test suite and Moq for unit testing.

Participate in Business meetings to understand the Production Defects and enhancements.

Monitored all production CRM jobs and providing resolution to any encountered issues.

Involved in Performance Tuning of SQL Stored Procedures.

Team Foundation Server (TFS) administration; support and maintain version control.

Implemented ASP.NET MVC apps to expose business data to non CRM users.

Implemented Web APIs using ASP.NET Web API services.

Perform software branching activities for each release cycle.

Assist in the maintenance and administration of build/release systems.

Report on configuration status of development, test and production environments.

Weekly Code Reviews.

Coordinating with the onshore business users during UAT and make sure in obtaining the signoff in time.

Production Incident management and their respective SLAs.

Acted as interface between Dev team and business people.

Research, diagnose and solve production Defects and Issues.

Environment: Microsoft Visual Studio 2012, Dynamics CRM, IOS App, ASP.NET MVC, C#.Net, Web API, LINQ, Entity Framework 5,SQL Server, Team Foundation Server ( TFS)

Shell Petroleum, Houston, TX Jan’2013 – Dec’2014

Role: Senior .NET Developer

Vendor Setup & Amend (VS&A) and Outline Agreement Setup & Amend (OAS&A)

VS&A and OAS&A are workflow based systems and work items will be routed to other teams like Approvers, Data Analysts and FOD teams. The routing logic will be dynamic and will be based on a number of different parameters like the activity types, company codes, vendor types and account groups.

These systems are having a number of different interfaces to external systems. The interfaces are as follows

OAS&A, VS&A <-> SAP MDM – To search the Vendor record using the vendor name and retrieve the vendor general data like Vendor Golden ID, ERP specific Vendor ID, ERP ID, Vendor Name, Address etc.

OAS&A, VS&A <-> SAP ERPs – Currently it is envisaged to create interfaces to 5 different ERP systems. The interface will be used to search a particular agreement/Vendor in the ERP system and populate/save the data retrieved on the web front-end.

Involved in developing the requirement with C# and WCF services in .Net 4.0 Technologies and unit testing and system testing.

Designed and Implemented K2 Workflow.

Worked on MVC Controllers and views.

Implemented Web APIs using ASP.NET Web API services.

Implemented SSRS Reports.

Written test cases for each module in the development using Unit testing of visual studio.

Used the Object Oriented Programming (OOP) techniques and created classes (in C#.NET) for database access.

Used ADO.Net Entity Framework as Data Access layer.

Extensively used LINQ to Entities to fetch the data from database.

Responsible for code changes of shared library modules.

Written complex SQL queries and developed the Stored Procedures, Views and User-Defined Functions etc.

Used MSTS Test suite and Moq for unit testing.

Code Cleanup – including try catch blocks, closing all open database connections, logging exceptions etc.

Used TFS for version control and code repository.

Trained developers to get familiar on SQL Stored procedures and .Net coding standards.

Assisted Developers during coding, debugging and Build issues.

Coordinated with the QA team to successfully complete SIT and UAT in time.

Environment: Visual Studio 2010, C#.Net, IIS 7.0, LINQ, ADO.Net, WCF, Sql Server 2008 and K2 Workflow.

Shell Petroleum, Hyderabad, India Jul ’2012 – Dec’2012

Role: Senior .NET Developer

DS SharePoint 2010 Migration

As part of this project, we have migrated SharePoint 2007 and Global Live link sites to SharePoint 2010. I was part of the team that was responsible in remediating two applications SD&A and EMCS.

SD&A: It is an asp.net website which uses SharePoint 2007 site as a document storage location. It communicates with SharePoint 2007 site through web services exposed by SharePoint. During migration activity, we are involved in reconfiguring this application to support new SharePoint 2010 site.

EMCS: It is a BizTalk application that uses SharePoint 2007 site as a document storage location. We worked on reconfiguring this application with new SharePoint 2010 site.

Sync Application: It is a console application developed to synchronize any two SharePoint Lists located in any two SharePoint websites. Users will have an option to define the column mappings and value transformations. It has been developed by using SharePoint client object model so that it can be executed on any client machine.

Created and Configured SharePoint 2010 sites manually.

Developed workflows in SharePoint 2010 site.

Worked on Client Object model and SharePoint Web services in establishing communication between ASP.Net applications to SharePoint site.

Manually migrated data from SharePoint 2007 to SharePoint 2010.

Performed technical validations after the migration.

Involved in Code reviews.

Environment: Visual Studio 2010, SharePoint 2010/2007, Client Object Model.

Canada Post, Hyderabad, India Mar’2011 – Jun ’2012

Role: Senior .NET Developer

Scan To Vehicle (STV)

The Canada Post transportation suite is rooted in legacy systems (STR Mainframe) that are expensive to operate and cannot be enhanced to support changing operational and customer requirements. Transportation dock processes involve manual data capture and entry steps that are inefficient and error-prone, resulting in unreliable data.

STV application is developed to overcome the above problems. Till all the facilities are migrated to STV, both STV and STR systems are operational at the same time. For this we need to synchronize the data between those two systems. To accomplish this we have developed the following interfaces.

ARCS: This interface is developed to retrieve the schedules information from the ARCS mainframe and creates them in STV.

STR Outbound: This interface is developed to retrieve the shipment events from the STR and update the STV with those details.

STR Inbound: This interface is developed to send the shipment events from the STV to STR mainframe system.

Reporting Extract: This interface generates all shipment and shipment detail events information in the form of Xml.

CNEdi Extract: This interface sends shipment details that require railway transport in the form of pre-defined edi format.

Analyzed the requirements and significantly contributed in developing architecture for the application and developed UML Use Cases Diagrams.

Responsible for creating the Class diagrams and Sequence diagrams using Star UML and documenting the project architecture.

Worked on AJAX Control Toolkit in order to increase the performance of the application.

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

Used AJAX controls to retrieve the data from the server without interfering the display and behavior of existing page.

Designed user interface for ASP.NET web forms and implemented application logic using C#.

Created Master pages and Themes in ASP.NET and wrote code behind pages using C#.

Created User and Custom Controls in C# to enable reusability and used rich server controls of ASP.NET.

Designed Client side validations using JavaScript and Server side validation controls in ASP.NET2.0.

Used ASP.NET Web Server controls like Grid View, Data List and Repeater for displaying the records.

Used MSTS Test suite and Moq for unit testing.

Worked on MVC Controllers and views.

Used ADO.NET objects such as Data Reader, Dataset and Data Adapter for consistent access to Oracle and SQL Server data sources.

Performed Application level tracing, debugging, and state maintenance through the Web.Config file under the root directory of the application.

Extensively wrote and used Stored Procedures, Database Triggers and Views in SQL Server 2008.

Contributed towards the security model in .NET framework for the administration module using Windows Authentication based on Role-based security.

Responsible for maintaining versions of source code using TFS.

Implemented test cases for Unit testing in Business, Presenter, and Data Access Layers.

Involved and communicated test results for application level testing, and Integration Testing.

Involved in writing System Documentation and Code Documentation.

Environment: Visual Studio 2010, C#.NET, ASP.NET, WCF, ADO.NET, SQL Server 2008, JQuery, HTML, CSS, MVC4.0 and Telerik UI Controls

Canada Post, Hyderabad, India Nov’2010 – Feb’2011

Role: Senior .NET Developer

Voyageur

Voyageur application is a part of IMSS(Integrated Mail Sortation System) component of the Postal Transformation program which will reduce the amount of Parcel and Packet information that must be entered manually. With this application Canada Post has the opportunity to reduce the volume of mail pieces requiring manual keying of sortation data required to sort Packets and Parcels. By retaining and forwarding sortation data captured at the originating processing facility to the destination processing facilities, Canada Post has a further opportunity to reduce manual keying.

Involved in Business Requirement and prepare analysis document.

Worked in 3 tier architecture.

Designed the Data Access Layer (DAL) module for the project.

Created Web application development using C#, XML and ASP.NET (User Controls, Custom Controls and Data/Business Components)

Implemented all validations on this module to capture accurate data.

Designed the multiple pages to implement the Account Opening module.

Created stored procedure to retrieve the master data and use them in the applications.

Designed pages for Master Queries web module to view the master information.

Built and test the assemblies.

Prepared the master table scripts for deployment release.

Communicated to users for any further change requests and handle those requests.

Environment: Visual Studio 2010, C#.NET, ASP.NET, WCF, ADO.NET, SQL Server 2008, JQuery, HTML, CSS

ClearBenefits, Santa Clara, CA Jan’ 2010 – Oct’ 2010

Client: ClearBenefits

Role: Senior .NET Developer

ClearBenefits Reports Queuing

Reports Queuing module is a part of Clear Benefits system that deals with all the reporting functionality of the product. There are around 80 reports providing insurance details to the Brokers, Employers and Admins. Some of the major reports are as follows:

Monthly Premium Report - gives the monthly premiums to be paid by the employees

Payroll Report - gives all the payroll information of the employees

Deduction Report - gives all the deductions and retro premiums of the employees

To reduce the load on production, we developed this service. It processes requests on a First Come First Serve basis and at any time only one report will be under execution. An email will be sent to the user; once the request was processed. It serves over 100 critical and high processing requests a day. Windows Service was used to implement this.

Interacting with the Services team for identifying various critical and highly generated reports which can be queued.

Designed the xml structure to store the particulars of a Report request.

Involved in designing the windows service component.

Developed a function which intimates users with the estimated time via an alert and Email.

Designed a page where users can see their request status, percentage completed and can also download the report after its completion.

Worked on migrating reports from VB to VB.Net

Have written Complex Queries and Stored Procedures.

Performed testing of the component.

Involved in Understanding the Requirements and provided the review feedback.

Environment : VB.NET 2.0, Windows service, Asp.net 2.0, Ajax and Oracle 10g

ClearBenefits, Solivar Software Dev, Hyderabad, India Jan’ 2009 – Dec’ 2009

Client: ClearBenefits

Role: .NET Developer

ClearBenefits Custom Reports

Custom reports are part of Clear Benefits online system that supports the end user to build reports of their choice. Users can customize the reports by specifying the columns and filters. Users can create more specific reports by extending the functionality of base reports to derived reports by using 'Inheritance' feature.

Designing the database structure

Requirements gathering from the services team regarding various kinds of requests they receive for different reports.

Designing the XML for storing metadata of the filter for Custom Report.

Involved in writing complex SQL queries involving many joins, analytical functions, scalar sub queries and inline views.

Writing Stored Procedures and Functions.

Involved in writing complex stored procedure for reports.

Involved in tuning the database, checking site performance.

Given project demos to Client Managers and clarify doubts in project

Involved in Coding, code review and code inspection for all modules.

Environment : C# 2.0, ASP.Net, Excel, Ajax and Oracle 10g

ClearBenefits, Solivar Software Dev, Hyderabad, India May’ 2005 – Dec’ 2008

Client: ClearBenefits

Role: .NET Developer

ClearBenefits Project Releases

CB Version 3.5: In this release we made our site compatible to .net framework 3.5 and started using AJAX functionality extensively. I was responsible for implementing this for the entire Clear Benefits Reports functionality.

CB Version 3.4: As a Developer implemented 1 ECN's, 20 Feature Requests and fixing 40 bugs over a 3 month release cycle. My role involved designing solutions, coding, time estimation and interacting with spec writers, QA and the Director of Engineering.

CB Version 3.0: As a Developer implemented 5 ECN's, 10 Feature Requests and fixing 30 bugs over a 3 month release cycle. My role involved designing solutions, coding, time estimation and interacting with spec writers, QA and the Director of Engineering. Version 3.0 is now live on Production and is in use by 567 clients.

Bug Fixing and Maintenance: Have been involved at various points in time providing customizations, monitoring system performance, troubleshooting and bug fixing. We support about 280,000 enrollments over 567 clients, in the process maintaining a 80 GB database.

Reviewing and understanding the requirements / Functional Specifications

Involved in designing the database tables and stored procedures

Performing testing of the component

Involved in Coding, code review and code inspection.

Environment : C#, VB.Net, ASP.Net, VB 6.0and Oracle 10g

EDUCATION:

Bachelor of Engineering in Information Technology from Andhra University, India in 2005.

Contact this candidate