SUMMARY

• Dedicated, team player self - motivated IT professional with development and support skills coupled with a "can-do" attitude having 10+ years of IT Experience.
• Worked extensively in ASP, ASP.NET, C#.net, VB.Net, Windows Services, VBA, VB6 and well versed with RDBMS like MS-SQL server and MS Access.
• Extensive experience in developing windows and web applications using ASP.Net, VB.Net and C#.
• Worked on developing web applications using MVC architecture.
• Extensive experience in working with MS-SQL Queries, Stored Procedures, Functions and Triggers.
• Experience in BI Development, Deployment & Maintenance of SSIS packages.
• Developed and maintained ETL-SSIS packages with various transformations, stored procedures, configuration files, Event Handlers and Error Handling.
• Developed reports, Subscriptions using SQL Server Reporting Services (SSRS).
• Worked on designing dynamic, static reports using Crystal Reports and integrated with VB.net application.
• Worked on configuring Websites, deploying applications in IIS and FTS in windows server 2008.
• Worked in developing WCF services.
• Good Experience in tools like TFS (Team Foundation Server), VSS (Visual Source Safe) and SQL Query Analyzer.
• Programmed ADO.NET in the Data Access Layer for communication between application and the SQL Server database and several modules in the n-tier application.
• Good Knowledge in writing test cases for testing. Involved in writing the test cases for manual testing.
• Involved in preparing documentation - SRS, ER Diagram, Data flow diagram, URD, Functional requirements, Use case diagram and Data Dictionary.
• Demonstrated ability to identify root causes of problems, considering both the long and short-term impact of proposed solutions and develop workable solutions.
• Experience in Application support process with SLA (Service Level Agreement).
• Experience in Remedy Ticketing System, Change Management System, Knowledge Management System, Root cause analysis system, Release Management.
• Developed POC (Proof of Concept) in OutSystems (Low Code Platform).

TECHNICAL SKILLS

Framework: .Net 3.5, 4.0, 4.5

Web Technologies: ASP.Net, VB.Net, MVC, HTML5, JavaScript, CSS3, AngularJS

Databases: MS SQL Server 2000, 2005, 2008, MS Access

Architecture & Concepts: ASP.Net MVC, Object Oriented Programming (OOPs Concept)

ORM: Entity Framework

Web Services: WCF

ETL Tools: SSIS (SQL Server Integration Services), SSAS

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

Reporting Tools: SSRS (SQL Server Reporting Services), Crystal Reports X / XI

IDE and Tools: Visual Studio 2008/2010/2012, Remedy Ticketing System, Change Management System, Knowledge Management System, Root cause analysis system, Release Management.

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

Technical Analyst

Tools: ASP.Net MVC, C#, SQL Server, SAP, SSRS, SSIS, TFS, Entity Framework.

Responsibilities:

• Involved in understanding and transmitting the business requirements for the project, and translating these into functional specifications
• Developed application using MVC architecture and Entity Framework to access the data.
• Developed tables, views, stored procedures and Functions and triggers to perform automated rules, updating to related tables using SQL Server.
• Designed Web-based ASP.NET Internet applications linked to firm-wide SQL databases.
• Created separate Data Access Layer (DAL) to interact with the data.
• Using Telerik controls to develop this application.
• Implemented localization and globalization to access application in different user locale.
• Created and deployed packages for importing data from other sources using SSIS packages.
• Designing Reports for the End-User requests using SSRS.
• Reviewing of work products and deploying the application in the test environment and initiate the process of user acceptance testing.
• It includes fixing of bugs and fixing technical errors that may come up during this phase.
• Perform code reviews with the team to ensure the coding standards are met.
• Implemented Agile Practice.
• Leading the team of 6 members.

Confidential, Louisville, KY

Technical Analyst

Tools: ASP.Net MVC, C#, SQL Server, TFS, SSIS, SSRS, SSAS.

Responsibilities:

• Involved in understanding and transmitting the business requirements for the project, and translating these into functional specifications
• Developed application using MVC architecture and Entity Framework to access the data.
• Developed tables, views, stored procedures and Functions and triggers to perform automated rules, updating to related tables using SQL Server.
• Involved in creating the Excel based reports for formulators to analyze the data.
• Created and deployed packages for exporting data to and from other sources using SSIS packages.
• Configured mail task in SSIS packages to send daily status send to users and error mail to support team.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to the support team and selected users.
• Used XML to create Web-based tools for transactions on SQL and Oracle databases.
• Designed and Deployed Reports for the End-User requests using SSRS.
• Reviewing of work products and deploying the application in the test environment and initiate the process of user acceptance testing.
• It includes fixing of bugs and fixing technical errors that may come up during this phase.

Confidential, Louisville, KY

Technical Analyst

Tools: ASP.Net, VB.Net, SQL Server, TFS, SSIS, SSRS, SAP.

Responsibilities:

• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modelling process.
• Created custom controls and user controls for code and functionality reuse in different forms.
• Created stored procedures, User-defined functions and Triggers.
• Built N-tier architecture for Presentation, Business Access Layer, Data Access layer and GUI.
• Developed and Maintaining 35 SSIS packages for data transfer to and from different sources.
• Developed Test scheduling, Invoicing, Fax report and Blend detail reports using SSRS.
• Created and deployed packages for extracting data from various sources like SQL Server, .CSV, Excel and Text file from Client servers and through FTP using SSIS.
• Requirements gathering and analysis for application enhancements.
• Reviewing of work products and deploying the application in the test environment and initiate the process of user acceptance testing.
• It includes fixing of bugs and fixing technical errors that may come up during this phase.
• Provided On-Call support to Mission Critical Environments and expertise with Disaster Recovery mechanisms.

Confidential, Louisville, KY

.Net Support Lead

Tools: WCF, Windows Service, SQL Server, TFS.

Responsibilities:

• RTB (Run the Business) activities i.e. fixing all the issues and bugs that come up in production.
• Discuss business solutions with Confidential Corporation Business Analysts, resolve existing problems and improve the application stability.
• Deployed code in TFS for version control and create the work items to capture bugs & change request.
• Review the existing defects in the production to provide permanent fix.
• Implement Agile practice for support incidents.
• Conduct SCRUM meetings with the team members.

Confidential, San Ramon, CA

.Net Support Lead

Tools: ASP.Net MVC, C#, TFS.

Responsibilities:

• RTB (Run the Business) activities i.e. fixing all the issues and bugs that come up in production.
• Discuss business solutions with Confidential Corporation Business Analysts, resolve existing problems and improve the application stability.
• Deployed code in TFS for version control and create the work items to capture bugs & change request.
• Review the existing defects in the production to provide permanent fix.
• Implement agile practice for support incidents.
• Conducting SCRUM meetings with the team members.

Confidential, San Ramon, CA

Sr. Software Engineer

Tools: ASP.Net, C#, SQL Server, MVC 4.0, TFS.

Responsibilities:

• In the analysis and design phase including gathering information and software documentation.
• Created stored procedures, User-defined functions, Views, cursors and Triggers.
• Developed application using the MVC architecture.
• Session state management in SQL server 2005 for providing secure platform and long-time session availability.
• Implemented Caching concept for the application performance issue.
• Deployed code in TFS for version control and create the work items to capture bugs, change request, Branching and merging, etc.
• Published the code and deployed in the IIS server of Production environment.

Confidential, San Ramon, CA

Sr. Software Engineer

Tools: ASP.Net, VB.Net, VB6, SQL Server, SSIS, VSS.

Responsibilities:

• Created stored procedures, User-defined functions, Views and Triggers.
• Developed on GUI Web Forms using ASP.NET with VB.Net and AJAX.Net 2.0.
• Interacted with customer on analysis and design phase for Gadgets to migrate.
• Detailed analysis and study on the Gadgets to be migrated.
• Built N-tier architecture for presentation layer, the Business and Data Access Layers and were coded using C#.
• Migrated application from Classic ASP, VB6 to .Net 2.0.
• Deployed the code in local server for testing.
• Developed SSIS packages to import data from flat file from SAP to SQL Database.
• Configured website in IIS and deploy the code in Production server.
• Responsible for project completion and delivery.

Confidential

Sr. Software Engineer

Tools: ASP.Net, C#, SQL Server, VSS.

Responsibilities:

• In the analysis and design phase including gathering information and software documentation.
• Created custom controls and user controls for code and functionality reuse in different forms.
• MS SQL Server database. It contains information about merchandise, agencies, bus trip and sales details, and also store procedures, functions, triggers and constrains which provide data integrity.
• Business logic components and Web Service. This middle-tier has rights to retrieve and modify data from the SQL Server database using stored procedures and user defined functions.
• Administration tools. It is necessary to maintain the database (as merchandise catalog etc.) and process agencies sales (using Web Service for data exchange).
• Working on GUI Web Forms using ASP.NET with C# and AJAX.Net 2.0, Web Services using C#.
• Developed application using the MVC architecture.
• Created stored procedures, User-defined functions, Views and Triggers.
• Session state management in SQL server 2005 for providing secure platform and longtime session availability.
• Implemented Caching concept for the application performance issue.
• Developed reports for printing tickets, Agency sales information, Schedule timings, Passenger information using Crystal Reports as dynamic PDF files.
• Integrated SMS module to send the ticket information to user mobiles.
• Developed test cases, involved in functional testing and unit testing.
• Published the code and deployed in the IIS server of Production environment.

Confidential

Software Engineer

Tools: VB.Net, SQL Server, Crystal Reports.

Responsibilities:

• In the analysis and design phase including gathering information and software documentation.
• Documentation - SRS, ER Diagram, Data flow diagram, URD, Functional requirements, Use case diagram and Data Dictionary.
• Created stored procedures, User-defined functions, Views and Triggers.
• Developed user interface and business logic using Win Forms, SQL Server 2000 and ADO.
• Accounts details are integrated with the Microsoft Navision. Import data from the backend to Microsoft Navision using the data port.
• Reused the exiting windows service application to back up the database and maintain the backup in servers.
• Developed reports related to invoicing using crystal reports.
• Created common functions which can be reused in the various modules by calling those functions with or without parameters.
• Involved in functional Testing and Unit testing.
• Created deployment packages for installing the application in server.

Confidential

Software Engineer

Tools: ASP.Net, C#, SQL Server, VSS.

Responsibilities:

• Developed Web modules using ASP.NET and C#.
• Documentation - SRS, ER Diagram, Data flow diagram, URD, Functional requirements, Use case diagram and Data Dictionary.
• Worked on Presentation, Business Access Layer, Data Access layer and GUI.
• Design database tables, stored procedures, User-defined functions, Cursors and Views.
• Developed and designed forms using AJAX to call all the other modules into one home module.
• Integrated the WYSIWYG editor in admin module for customizing the ads, gadgets information in the home page.
• Developed master pages, Skin concept accessing single folder with multiple websites.
• Used RSS Feed for Weather and Top Stories in web application.
• Implemented web parts for look and feel of the web application and to customize the page by the user.
• Created common functions to reuse in various modules.
• Deployed the code in VSS for Version control.
• Published the code and deployed in the IIS server.

Confidential

Software Engineer

Tools: VB.Net, SQL Server, Crystal Reports.

Responsibilities:

• Developed user interface and business logic using Win Forms, SQL Server 2000 and ADO.
• Involved in Documentation, Design, Developing, and writing Test cases.
• Created tables, indexes, stored procedures, triggers, and view in Microsoft SQL Server 2000.
• Developed reports using Crystal report.
• Involved in functional testing, unit testing and implementation of the application.
• Developed windows service using VB.Net to back up the database.