QUALIFICATIONS SUMMARY

• Over 3 years of Information Technology experience in requirement analysis, design, development, deployment, enhancement and support of client/server and n-tier architecture applications.
• Over 2 years of experience in Analysis, Design and Development on ETL(Extraction, Transformation and Loading) mechanism using SQL Server 2005 SQL Server 2008 in complex projects. Worked on SQL Scripting.
• Expertise in design and development of Client/Server, Windows WinForms and Web based applications using Microsoft .NET Technologies such as C#.NET, ASP.NET, ADO.NET, Web services, VS.NET 2005/2008, SQL server 2008, HTML, CSS, jQuery and XML.
• Strong in Object Oriented Design and Programming (OOD/OOP). Experience with working on Entity Framework and Design patterns.
• Exposed to complete software application development life cycle phases starting from business analysis, system study to deployment and support.
• Experience in Agile and Water Fall software development methodologies. Good working knowledge of MVC and WCF.
• Experience in developing different static (structural) and behavioral UML diagrams like Use Case Diagram, Class Diagram, Sequence Diagram, Collaboration Diagram, Activity Diagram using Microsoft Visio.
• Experienced in development of applications using different databases like Oracle and SQL Server.
• Extensive experience in SQL Server Database design, developing stored procedures, Views, UDF’s and triggers using SQL Server 2000/2005/2008.
• Experience with developing reports using SSRS.
• Good in debugging an application using the debugging tools provided by the Visual Studio.Net IDE and resolving bugs.
• Excellent team player with problem solving and trouble-shooting capabilities.

Technical Summary:

Windows XP/7

Database Servers

Oracle 11g Database Server, Microsoft SQL Server

Web Technologies

ASP.NET, HTML, Web Services, XML

Programming Languages

C, C++, C#, ASP.NET, XML, HTML, SQL Scripting

Tools Used

Microsoft Visual Studio 2008, Oracle 11g Enterprise Manager, Microsoft Visio

Databases

SQL Server 2005/2008, Oracle 11g

Query Language

Oracle 11g SQL

Education:
B.E (Bachelor of EngineeringCertification
· 1Z0-051Oracle Database 11g: SQL Fundamentals I

Work Experience:
Charlotte, NC USA
Duration: Feb 2012 till present
.NET Developer
Description: “Quicken” is an internet based Windows stand-alone application developed for personal and corporate financial and banking management services to individuals as well as corporate institutions. Wells Fargo wants to provide Quicken download capability to First Clearing customers through the Enterprise OFX solution by adding First Clearing OFX functionality to the Fiserv developed Voyager platform application system that has been built as the enterprise OFX Server Platform.
Responsibilities

• Responsible for development, integration and testing of application.
• Responsible for creating complex front-end handlers for Sign on, Authentication, Account information retrieval and Investment statement download using C#.
• Designed and implemented Business logic layer, Data access layer-using ADO.NET and C# for accessing and validating the data in Host Plugins developed to transact with OFX Server.
• Created SQL Scripts for modifying and inserting access controls for FCC Customers
• Used Sitemap control to provide the site navigation using XML.
• Designed and developed Web forms using Classic ASP, ASP.Net, jQuery with VB code behind for Customer Service Representative Access.
• Constructed complex stored procedures, Views, Functions (UDF’s) and SQL queries to aid in retrieval of base data from SQL Server and to provide Customer Service Representative Access.
• Created complex Handler codes in C# to handle retrieval and validation of data from OFX Server to Transaction Processor on Voyager platform.
• Responsible for integrating Handler and Host Plugins with the Transaction processor for smooth transfer of data from host server to different product versions of Quicken.
• Responsible for Application debugging and troubleshooting.

Environment: C#.NET, ASP.NET, ADO.NET, Visual Studio 2008, SQL Server 2008, Classic ASP, VB.NET and Windows 7.

Bangalore, India
Duration : Sep 2008 till Jul 2010

USA
Duration : Jan 2010 till Jul 2010
Asp.net developer
Description: Metrics and Reporting is an intranet based web application developed for viewing the reports of the different categories under different departments.
Existing data from diverse data sources were consolidated into a uniform SQL Server 2005 database. SQL Server Integration Services was used to define imports of the data, build scheduling packages, to define integration flow and generated various kinds of reports using SSRS.
Responsibilities

• Responsible for development, integration and testing of application.
• Designed and developed Web forms using ASP.NET with C# code behind.
• Created ASP.NET User Controls to reduce the complexity of user interface design.
• Used Sitemap control to provide the site navigation using XML.
• Responsible for coding using C# and developed reusable classes.
• Designed and implemented Business logic layer, Data access layer-using ADO.NET for accessing and validating the data.
• Created mappings to extract data from Staging area to enterprise data warehouse with applying various business rules.
• Created reports using SSRS.
• Constructed complex stored procedures, Views, Functions (UDF’s) and SQL queries to aid in report generation and to access Rule base data from SQL Server.
• Responsible for Application debugging and troubleshooting.

Environment: C#.NET, ASP.NET, Visual Studio 2005, SQL Server 2005, MS-Access 2003, SSRS, and Windows XP.

New York, NY, USA
Duration : Jul 2009 till Jan 2010
.Net developer
Description: This project was developed to provide interface for reading, writing, updating and deleting the meta-data from the metadata repository and they can view payment history.
Responsibilities

• Involved in requirement analysis, design and development.
• Designed Class Diagrams using Visual Studio class designer.
• Designed and developed Web forms using ASP.NET with VB.Net code behind.
• Caching mechanism is implemented to improve the performance.
• Client side validations are done using .NET validation controls.
• Developed Business logic layers and Data access layers using ADO.NET.
• Writing SQL queries, Stored Procedures and Triggers for data Manipulation and making extensive use of Dataset and Data Reader classes for the same.
• Developing of business logic classes and database transactions related business classes by implementing the best practices of Object Oriented Programming features using VB.Net language.

Environment: VB.NET, ASP.NET, HTML, MS Access, MS Excel, Visual Studio 2005, SQL server 2005, Windows XP, XML, SSIS, SSRS.

New York, NY, USA
Duration : Jan 2009 till Jul 2009
System Analyst
Description: This project involves migration of the existing Visual Basic based Care One application into the .Net based CARE application. The Interfaces architecture consists of business layer, data access layer and file management layer. All layers were developed in C#.
Responsibilities

• Understanding the business requirements of Care One.
• Understanding the existing Care One application
• Involved in the uploading of existing Assessment Data from Excel files into SQL server and MS Access Databases.
• Involved in Design and development of Database.
• Understood the usage of domain layer framework in CARE application.
• Developed the stored procedures and views in SQL Server 2000.
• Developed the business logic layers using C#.Net.
• Used Data Access and Exception Handling Application blocks of MS Enterprise Library.
• Preparing Unit Test Cases to test the functionality of the tool under various scenarios.
• Co-ordinating with the Operations Team in deploying the application on to Production Servers.

Environment: .NET Framework 1.1, ASP.NET, C#.Net, VB Script Visual Studio .NET 2003, SQL Server 2000.