PROFESSIONAL SUMMARY

• Senior .Net Developer with over 7 years of professional IT Experience in design & development, testing and implementation of Client/Server and Web - based N-tier architecture systems using Microsoft Technologies.
• Proficient with Software Development Life Cycle (SDLC), including business requirements, analysis, design, development, testing and implementation of application.
• Experience in Oriented Programming (OOP).
• Good experience in Dot Net Framework 2.0, 3.0 &4.0, Window and Web Based applications and expertise in C#.Net,VB.Net, ASP.Net
• Extensive experience working on, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and DTS Packages
• Adept in building web applications with JavaScript and JSON
• Skilled at SQL Server (2000-2012)
• Worked on Visual Studio 2013/2010/2008/2005
• Strong experience in creatingRESTfull Web APIs
• Experienced in Multithreading programming in C#and VB.
• Well Experience using Entity Framework and MVC 5
• Experience in developing complex queries, Stored Procedures, triggers and cursors using SQL Server
• Experience in creating and consuming Web services.
• Experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server using DTS and SSIS packages.
• Skillful on working with Angular.JS andjQuery
• Solid experience in Database design and programming: writing Stored Procedures, Functions, Triggers, Views, Joins, performing Query Optimization and Performance Tuning.
• Used versioning tool Visual Source Safe (VSS) for version controlling of the application
• Widespread Experience in designing, developing of components for the Presentation Layer, Business Access Layer and Database Access Layer for Microsoft Distributed applications, deployment and unit testing of Web based applications
• Good at creating prototypes of workflows - high and low level designs
• Past experience in analyzing technical issues as part of Level 2 & Level 3 Support Handling
• Comprehensive software development life-cycle experience with active involvement in requirements gathering, analysis, design, programming, testing and implementation.
• Self-Motivated and a Team player with good communication and written skills with exemplary analytical and problem solving skills

TECHNICAL SKILLS

Web Technologies: ASP.Net, MVC 5.0 and Classic ASP 3.0

JavaScript Frameworks: JQuery, Angular

Languages: C#.Net and VB.Net

Databases: SQL Server 2000/2005/2008R2/2012, Oracle 11g Sybase

Net Framework: .Net Framework 2.0, 3.0 and 4.5

Reporting Tools: SSRS and Crystal Reports.

UML Tools: Microsoft Visio

Web Services: Web Services, REST Full API

ETL: SQL Server Integration Services (SSIS)

OS and Servers: Windows 2000/ 2003/2008/XP/Win 7

PROFESSIONAL EXPERIENCE

Senior .NET developer

Confidential, Burbank CA

Responsibilities:

• Implemented project by following Software Development Life Cycle (SDLC) steps.
• Part of a team that developed both a WinForms and WebForms application that utilized our Object Oriented .NET Framework.
• Web Applications developed on front end as VB.net and C#.net and backend as MS Access and SQL Server
• Working as first level point of contact for Confidential support project to handle issues
• Designed and developed relational tables in SQL Server database and created stored procedures for web application, utilized web services for data
• Used ASP.NET AJAX Toolkit controls like Script Manager, Update Panel and Timer in some web pages.
• Storing and retrieving Data from MS Access 2010
• Database Architecture: Modeling, Implementing and tuning both new and existing databases.
• Used SMTP mail class of .NET for users to send mail with suggestions, receive any alerts from the bank, receive confirmation notifications etc.
• Designed different components using VB.NET language and used Exception handling, Error providers to handle exceptions.
• Extensively used concepts of Delegates, generics, boxing-unboxing and Inheritance in C#.NET, along with Abstract classes/Interfaces and Polymorphism.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks.
• • Expertise with Table Design, Index Design and Performance Tuning.
• • Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• • Created Store Procedures, Views and User Defined Functions for fetching relevant data to UI for different reports.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Monitoring batch jobs and scheduled jobs on Orsyp Tool

Environment: SQL Server 2008, MSBI-SSIS, VB Scripting, Orsyp Monitoring ToolVB.Net, .NET Framework 4.0, ASP.NET MVC 4.0, C#, CSS, LINQ to SQL, JavaScript, Visual Studio 2012, SQL Server 2012, IIS 7.5, JQuery, Windows 7 and Windows Server 2008

.NET Developer

Confidential

Responsibilities:

• Designing the database in SQL Server 2008
• Involved in requirements gathering, analysis and estimates.
• Writing Procedure and function to handle of 220 Million records in DB
• Designing and Deploying of SSIS Package to Upload and Compare files as per business logic
• Implemented across multiple domains a total of 25 SSIS Packages for different Business
• Extensive use of MSBI (Microsoft Business Intelligence)
• Connecting to FTP location in DMZ (demilitarized zone) to download source files
• Development of Complex T-SQL queries and Stored Procedures.
• Write SQL code to retrieve data from the Oracle 10g database using Linked Server
• Scheduling a 32 bit SSIS package in SQL server 2008 R2
• Involved in the complete Software Development Life Cycle from Requirement Analysis to End-user Training.
• Easily managed the complexity of application by dividing into the model, view and the controller (MVC) patterns.
• Used Master Pages in designing the UI.
• Provided 24x7 support and trouble shoot production support issues on high availability systems.
• Involved in testing several modules as part of the unit testing.

Environment: SSIS 2008, VB Scripting, SQL Server 2008, Oracle 10g,Visual Studio.NET 2005,ASP.NET 3.0, VSS, AngularJS

Confidential

DAT Duplicate Audit Tool

Responsibilities:

• Design of Database Architecture, Tables, Views, Stored Procedures and Triggers in SQL Server 2008
• Extensively worked with VB.NET for creating classes and Integrating the same with multiple forms
• Involved in designing and coding for win forms of the application withVB.NET.
• Coded stored procedures in SQL Server and used ADO.NET to interact with the back-end database.
• Extensively used various Object-Oriented Concepts (OOPS) such as Polymorphism, Inheritance, Encapsulation and Abstraction
• End to End Requirement Gathering and Documenting
• Defining Purging policies to move old records from primary database to backup database
• Business Logic for Duplicate identification of records Within same File and History file using SQL Server Stored Procedures
• Designing and Deploying of SSIS Package to Upload and Compare files as per business logic
• Encryption of Sensitive data like Credit Card number using Certificates and Master key in SQL Server DB
• Responsible for E2E support and maintenance of application for various releases on production environment.
• Responsible for applying JavaScript on Web Forms for client-side validation.
• Used AJAX extensively for creating User Controls and speed up web applications by providing partial page updates.
• Handled production issues during the deployments and effectively managed client change requests
• ADO.NET objects such as Data Set, Data View, Data Reader and Data Adapter are used in the Data Access layer to communicate with thedatabase to access, update data in the database.

Environment: DTS Packages, SSIS 2008, SQL Server 2008, VB.NET,ASP.NET 2.0, C#. Net, ADO.NET, Web services, HTML, JavaScript, IIS 6.0, CSS, Ajax Toolkit,Visual Studio 2005, jQuery

Confidential

E2E Reconciliation Tool

Responsibilities:

• Creation of SSIS Packages and related Business Logic
• Responsible for implementing the error handling “Exception handling “in the project-using try, catch, finally blocks
• Developed solutions for diverse programming scenarios in C#, employing Object Oriented Programming (OOPS) concepts such as Encapsulation, Inheritance, Polymorphism, and Abstraction
• Client and server side validations using JavaScript and Validation Controls and performing the tasks related Database issues
• Designed cascading style sheets and Themes to set styles on ASP.NET pages
• Created stored procedures and views using T-SQL to provide custom data access
• Participated in Encryption and Decryption of data before it is saved into the SQL Database using XML files for intermediate storage.
• Used AJAX for asynchronous data transfer and to improve the performance of the application.
• Designing and Deploying of SSIS Package to Upload and Compare files as per business logic
• Scheduled Jobs and Alerting using SQL Server Agent.
• Development of Complex T - SQL queries, Stored Procedures, Views, Functions, Creating & Updating tables for data load and checking the database consistency by executing DBCC Commands.
• Encrypting and Decrypting sensitive data like Credit Card details using AES 256 algorithm in SQL 2008

Environment: MSBI-SSIS, SQL Server 2008, Sybase, VB.NET, Oracle 10g

Confidential

Maintenance and Production Support

Responsibilities:

• Developed re-usable components using C# class libraries.
• Analyzing the business requirement of Functional specifications and Service Requests in the release
• Developed Databases using complex Stored Procedures, Triggers, Functions, Constraints, Indexes and Views as required in a SQL Server environment.
• Performed backup/restore the database objects and User Security Management.
• Prepared analysis, design documents, estimation, for different component and functional modules required by the system.
• Dealt with Fine-Tuning stored procedures to improve performance with a Query Plan using SQL Tuning Advisor.
• Created, loaded, and modified new packages added and configured components by using Control Flow Tools and Data Flow Tools in Microsoft SQL Server Integration Services (SSIS).
• Created ETL tools and packages to extract heterogeneous data from Excel, Flat file, XML to SQL Server.
• Implemented error handling and resolved issues by troubleshooting the scripts in failure to load the data into database.
• Deployed SSIS packages dynamically into Development, Testing and Production environments by creating Environment variables and Windows variables.
• Developed SQL Server Reporting Services (SSRS) reports using Global Variables, Expressions, and Functions and worked with Report Servers in SharePoint Integrated Mode.
• Converted existing crystal reports to SSRS.
• Monitored and Tuned SQL server Database Performance and Query Analysis for optimizing report performance.
• Encryption of Decryption of Check Images using Symantec PGP software
• Performed User Acceptance testing (UAT) and System Integrated testing (SIT) to handle deployments in test and production stages
• Handled production issues during the deployments and effectively managed client change requests

Environment: Classic ASP, ASP.NET, VB.NET, C#, ADO.Net, SQL, PL/SQL, SQL Server, PGP

.NET Developer

Confidential

Responsibilities:

• Developed UI components using ASP.NET and VB.Net.
• Interacted with external clients for and requirements gathering.
• Involved in Analysis and Design of all the modules within the application.
• Created ASP.NET Web forms and server controls to display dynamic data obtained through the use of Microsoft ADO.NET and Data binding.
• Used CSS (Cascading Style Sheets) and Themes to maintain design consistency across all web forms.
• Used JavaScript for Client side validation.
• Heavily used .NET Web Controls, Validation Controls and User Controls.
• Performed Unit Testing on the entire application.
• Involved in testing the product during post-production.
• Used cookies, Sessions and View state to store user information.
• Wrote queries and stored procedures, Functions to execute various database routines.
• Involved in developing user manuals and help documents.

Environment: .Net 2.0, ASP.NET, VB.Net, ADO.Net, Java Script, CSS, Oracle PL/SQL, TOAD, Unit Testing.