SUMMARY:

• Certified. Net SQL Developer with extensive experience in implementing, developing, testing, maintaining and supporting Web based applications using Microsoft Technologies including .NET Framework (4.5/4.0/3.5/3.0 ), ASP.NET, ASP.NET MVC, C#, WPF, AJAX, LINQ, IIS, Web Services, WCF, HTML, DHTML, XML, CSS, ADO.NET, SQL, Oracle, SSIS, SSRS, JQuery, JavaScript, VB Script and ASP.
• Experience in working with various applications in Finance and Healthcare domains
• Experience in developing User Controls, Grid View, AJAX enabled controls and Event Handlers using C# and ASP.NET.
• Experience in using validation controls and JQuery for front - end validations.
• Extensively implemented Master Pages and Themes for consistent look and layout of webpages.
• Extensively worked on HTML5 and CSS to design rich web pages, JavaScript, and jQuery to create efficient and dynamic web applications
• Extensively used Visual Studio 2005/2008/2010/2012 for development of .Net based applications.
• Experience in using Entity Framework and Language-Integrated Query (LINQ)
• Experience in using ASP .NET AJAX framework for creating efficient and rich UI experience and interactive Web applications including WSDL, UDDI and SOAP
• Strong experience in creating and consuming web services in applications using
• Experience in working with Windows Communication Foundation (WCF)
• Worked with ADO.NET objects such as Data Adapter, Dataset, and Data Reader to interact with databases like SQL Server 2008/2005/2000
• Expert knowledge of SQL Server and Oracle database, Designing, Implementing and Modifying database objects like tables, Stored Procedures, Functions, Views, Indexes and triggers.
• Proficient in writing complex and dynamic SQL queries.
• Experience in Query Optimizations and Performance Tuning of Stored Procedures using SQL Profiler.
• Experience in developing complex reports using SQL Server 2012 Reporting Services (SSRS). Experience in creating reports using Crystal Reports.
• Strong Experience in Creating ETL packages for data transformations using SQL Server 2012 Integration Services (SSIS)
• Have good knowledge of ASP .NET MVC Architecture.
• Have knowledge of SQL Server Analytical Services and Cube development.

TECHNICAL SKILLS:

Programming Languages: C,C++, C#, PL/SQL,VB, JAVA, JSP, XML, HTML5

Databases: SQL Server 2012/ 2008/2005/2000, MS-Access, Oracle 10g.

Web Technologies: .NET Framework 4.5/3.5/3.0/2.0, Asp.Net MVC, ASP, ASP.Net 4.5, WPF, Java Script, VB Script, LINQ, Web Services, WCF, ADO.NET, Web Forms, Window Forms, CSS, AJAX, JQuery, JSON.

Development Tools: Visual Studio 2005/2008/2010/2012, MS-FrontPage 2003, Rational Rose, MS Office.

Operating Systems: Windows 8/7/Vista/XP/2000/NT/98,MS DOS, LINUX and UNIX

Version Control: Microsoft Visual Source Safe, Microsoft Team Foundation Server (TFS)

Reporting & Integration Tools: Crystal Reports, Microsoft SQL Reporting Services (SSRS), DTS, Microsoft SQL Integration Services (SSIS).

Monitoring Tools: Autosys

Web server: I IS 6.0/7.0/7.5, Tomcat

Documentation: TDD (Technical Design Document), UTP (Unit Test Plan)

Testing & Deployments: Unit Test Plans, Unit testing, Production Cut-over run and Conversions, Nlog.

PROFESSIONAL EXPERIENCE:

Confidential

Software Contractor

Responsibilities:

• Involvement in Complete Software Development Life Cycle of the project.
• Involvement in discussions with the Functional Team in gathering requirements to perform impact analysis.
• Working on the Workflow of User Stories, to estimate the time required to complete the task.
• Involvement in discussions on functional review of changes to the application.
• Working on production support, of the existing application and provide bug fixes.
• Setup of environment by installation of required software and configurations in development, test and release environments.
• Implementation of server and client side validations to enhance the application by making it respond more dynamically, for ease of use and better in performance using JQuery and JavaScript.
• Maintenance and development of SSIS packages to get data from Rapport to Leasing portal.
• Development of complex stored procedures to implement the business logic.
• Designing, Implementing and Modifying database objects like tables, Functions, Views, Indexes and triggers.
• Implementation, Deployment and Maintenance of Web Services to Submit the OLS data to Rapport.
• Consumption of the Web services implemented by partner systems to implement Data Access Layer needed for data retrieval.
• Performed Serialization of Data, Created XML files for submittal of Lease Applications to partner systems.
• Development of User Story’s using VB .NET, HTML, CSS and AJAX. Usage of Telerik controls to display list data, User Controls and Master pages.
• Used ADO .NET and LINQ to build application middle layer.
• Configuring IIS to host the web services and Web Applications at the server side.
• Performance of Code Reviews and Document preparation.
• Unit testing for all the deliverables developed.
• Usage of Team Foundation Server for code maintenance and project planning to track development.
• Usage of Agile Methodology for ease of planning and management.

Environment: ASP.NET 4.5, VB .NET, Visual Studio 2012, Java Script, JQuery, XML, Telerik Controls, SQL Server 2012, Web Services, ADO .NET, LINQ, SSIS, Windows Server 2012, Team Foundation Server 2010, IIS 7.5.

Confidential

Senior Software Engineer

Responsibilities:

• Analyze / understand the requirements for all of the above functionalities by interacting with the users and looking at the technical design documents.
• Developed various abstract classes, interfaces and classes to construct the business logic of the project using C#.NET
• Developed various data access methods using LINQ Queries, which retrieves data for webpages in Data Access Layer using Entity Framework model.
• Responsible for development of the various front end and portal screens with validations, which handles huge amount of data, which contains the core business logic of the application.
• Extensively used ASP.Net Grid view control to display data in good format.
• Involved in development of Custom User control for the project which renders data into Grid view control dynamically and is used by various screen in the project to avoid redundancy in the code and for code reusability.
• Implemented Web Services to integrate the client systems using WCF.
• Developed and consumed WCF services to achieve Service Oriented Architecture (SOA) and communication between heterogeneous applications.
• Developed and used standard CSS files to make controls look similar across the application.
• Implemented form validations for the screen by developing custom server side and extensively used JQuery and JavaScript for development of client side validations.
• Extensively used AJAX and WPF for a rich UI experience and used update panels for making asynchronous calls to the database.
• Involved in the complete Software Development Life Cycle of the project including Analysis, Design, Implementation, Testing and Maintenance.
• Responsible for maintenance and deployment of the SSIS packages developed for migration of project data from Oracle to SQL Server.
• Responsible for maintenance of Scheduled jobs created and development of enhancement for new requirements.
• Developed complex stored procedures to implement the business logic.
• Implemented more efficient way of their month end calculations which reduced their month end run time from 1.5 hours to 5 minutes.
• Developed dynamic SQL queries to provide flexibility for users to search by different filters for the retrieval of user’s information for complex reports using SQL Server Reporting Services.
• Developed new reports using SSRS by gathering requirements from the users for the purpose of enhancing business processes, operations and information process flow.
• Created various database Tables, stored procedures, views and Functions to process and present the data.
• Developed customized Events for the controls to accomplish functionality needed which are not provided for standard controls.
• Moved the business logic and complex calculations from UI layer to SQL Server wherever possible.
• Involved in application enhancement in terms of speed, security and Used Nlog for Error logging and handling.
• Performed Unit Testing for all the deliverables developed.
• Used Team Foundation Server for Version control and for further reference of deliverables in future.
• Responsible for timelines and deliverables for the tasks assigned.

Environment: ASP.NET 4.5, C#, Visual Studio 2012, Java Script, JQuery, SQL Server 2012, WPF, Oracle 10g, LINQ, Web Services, SSRS, SSIS, Windows Server 2012, Team Foundation Server 2010, IIS 7.5.

Confidential

Systems Analyst

Responsibilities:

• Involved in gathering of requirements from the users for developing their new insurance website with enhancements.
• Involved in the Design, Analysis and Development phases of the project.
• Involved in development of their various screens for data entry and maintenance using LINQ to SQL, C#.NET and Web Services.
• Used Microsoft Team Foundation Server (TFS) for all source code maintenance needs.
• Involved in architectural designs of their database.
• Created various database objects such as tables, views, functions, triggers, indexes, and database constraints for maintenance and storage of project data.
• Developed and maintained ETL packages using SQL Server Integrations Services (SSIS) with special focus on data flow, error recovery, and exceptional handling for migration of user’s data from their old Oracle platform to SQL Server platform.
• Created deployment models for the SSIS packages developed to deploy them in production and test environments.
• Created SSIS package to get their providers information from partners systems into Orchestrator database. Performed data transformations and modified the data as per project requirements by interacting with the users.
• Developed and maintained Scheduled SQL Server jobs for database backup.
• Developed Scheduled job for database files cleanup on servers and developed jobs which will move data file across servers and across directories using SSIS.
• Developed complex stored procedures to meet their functional requirements.
• Involved in the development of their security screens which will restrict the users from using screens by assigning roles to them using LINQ.
• Involved in design, development, and deployment of complex reports for retrieval of user information using SQL Server Reporting Services.
• Performed Unit Testing for all the deliverables developed.
• Responsible for timelines and deliverables for the tasks assigned.

Environment: ASP.NET 4.5, C#, Visual Studio 2012, Java Script, JQuery, SQL Server 2012, Oracle 10g, LINQ, Web Services, SSRS, SSIS, Windows Server 2012, Team Foundation Server 2010, IIS 7.5.

Confidential, New Jersey

Associate Consultant

Responsibilities:

• Involved in the Development, Unit Testing & Post Production Release Support.
• Prepared estimations for the new changes along with the impact analysis.
• Worked as a primary support contact person during the critical situations where project is dealing 3 major enhancements - Frontend migration, Server migration and Major Country Rollouts.
• Actively involved in Country Rollout activities.
• Prepared Country Rollout Scripts
• Responsible for designing and developing ASP.NET web pages using C#, ASP.NET, Java script, ADO.Net, SQL, HTML, CSS and AJAX.
• Used ADO.NET objects such as Data Reader, Dataset and Data Adapter, Data View for consistent access to SQL Server data sources.
• Configured IIS to host the web services at the server side.
• Created data driven dynamic UI pages in ASP.NET to present the data in the front end with client side scripting to make it more users friendly.
• Developed Master Pages and Themes for consistent look and layout of web pages.
• Created various database Tables, Views and Functions to process and present the data.
• Designed and developed complex stored procedures in SQL Server 2008 to implement business logic.
• Responsible for generation of reports using Crystal Reports.
• Performance tuned the code for huge data and scalability using the performance tools provided by SQL Server.
• Responsible for Bug fixing and implementation of enhancements to extend the functionality.
• Responsible for Monitoring SQL Server jobs, which used to fetch huge volumes of transaction data from other partner systems into Credit Control System.
• Developed data transformation packages using SQL Server Integration Services (SSIS) for performing data loads.
• Used Microsoft Visual Source Safe for Version control and for further reference of deliverables in future.

Environment: ASP.NET 3.5, C#, VB Script, Java Script, IBM MQ Series, Autosys, SSIS, Crystal Reports, IIS 7.0, SQL Server 2008, ADO.NET.

Confidential, London

ASP Developer

Responsibilities:

• Involved in production support and Enhancements Development.
• Involved in all the phases of SDLC right form Analysis and Design to Testing and Deployment of software deliverables during release and post implementation activities.
• Involved in preparation of Technical Design Document
• Prepared estimations for the new enhancements along with impact analysis.
• Created database tables, views and implemented triggers on database tables.
• Designed and developed SQL stored procedures in T-SQL to implement business logic.
• Responsible for generation reports using Crystal Reports.
• Developed Web Pages using ASP, VBScript and JavaScript.
• Used Active Database Objects (ADO) to connect and access SQL Server data sources.
• Responsible for timelines and deliverables for the tasks assigned.
• Performed Unit-Testing of all the deliverables developed.
• Responsible for proper documentation of deliverables.
• Responsible for Maintenance of deliverables, documents and test scripts in Versioning tool Visual Source Safe for future use.

Environment: ASP, VB Script, Java Script, Crystal Reports, IIS 6.0, SQL Server 2000, Visual Studio 6.0

Confidential

Software Developer

Responsibilities:

• Participated in architectural design of project.
• Designing Data Access Layer.
• Created physical design of the database.
• Worked on the data loads using SQL Server Integration Services (SSIS).
• Written stored procedures Triggers and jobs in SQLServer2005.
• Created Custom User Controls and GridView control.
• Created an Email component with rich text formatting.
• Worked on configuration and web deployments into SIT, UAT and Production.
• Implemented Unit Testing.
• Involved in preparation of Technical Design Document
• Used Microsoft Visual Source Safe for Version control and for further reference of deliverables in future.
• Responsible for timelines and deliverables for the tasks assigned.

Environment: C#, ASP.Net, ADO.NET, XML, SQLServer2005, IIS6.0.