SUMMARY:

• As a consulting professional, over 13 years I have contributed to the successful delivery of large scale projects across all the phases of SDLC. My expertise is focused on extensive experience with Microsoft’s core solution technologies, from the first release of VB, to current .Net and SQL Server products. This expertise, blended with my business - oriented background, enables me to provide proven leadership in the development, and timely deployment of sizeable e-commerce solutions.
• Rapid Web Development - Intranet and Internet applications development utilizing ASPX, XML, XSLT, and XSD for content management, data validation, and presentation.
• Deep understanding of .NET Framework concepts, including experience with Web and Win Form development with C#.NET, ASP.NET, VB.NET, Entity Framework, WebAPI, (Visual Studio 2010/2008, CAB (Composite UI Application Block), HTML, XHTML, JavaScript, SSIS, SSRS
• Applying Multithreading techniques for creating high performance applications.
• High Availability Database Development - SQL Server the right way, using stored procedures, user-defined functions, triggers, indexed views, and indexing strategy, efficiently and effectively.
• Development of SSIS packages, SQL scripts, SQL Agent and AutoSys Jobs for scheduled data transfer and transformation between multiple database platforms or external systems.
• Strong Reporting Services experience in developing web/client server reports using reporting tools like SSRS, Adhoc Reporting, Crystal Reports 7.0
• Good working experience with ADO.NET objects such as SQL Connection, SQL Command, Dataset, Data Reader and Data Adapter Objects in Web applications and Win form applications.
• Well versed in N-Tier and SOA Architecture with extensive experience in XML web services, Windows services and WCF Services development in ASP.NET using C# and AJAX.
• Worked on ASP.NET Web Forms, ASP.NET State Management & ASP.NET Caching.
• Experience using Object Oriented Analysis Design (OOAD), Object Oriented Programming
• Experience building/managing Web Apps using ASP.NET Web Forms, MVC (Razor/ASPX engine)
• Extensively understanding in creating and managing View Models, Views, and Partial Views using ASP.NET MVC. Proficient in LINQ for data retrieval, CRUD operations, data filtering & sorting.
• Good working experience with ADO.NET objects such as SQL Connection, SQL Command, Dataset, Data Reader and Data Adapter Objects in Web applications and Win form applications.
• Experienced working in Agile Software, conducting Code/Test Case review meetings, participated in daily SCRUM meetings.

TECHNICAL SKILLS:

Technologies: NET Framework (4.0, 3.5, 2.0, 1.1), C#, Win Forms, ASP.NET,VB.NET ADO.NET, AJAX, Web Service, WCF, MVC, LINQ, JQuery, JSON, oDataSource and SharePoint List adapter(Codeplex),VB (COM, COM+), ASP

Databases: MS SQL Server 2000/2005/2008/2013 and 2014, MS Access, Oracle, MySQL and Teradata

Tools: SSRS, SQL Server Integration Services (SSIS), MS Office 2007/2003, Microsoft Visual Studio.NET (2008,2005 and 2003), Infragistics, Net Advantage, DSOFramer and MS Application Blocks, CAB

Servers: Windows 2003 server, Microsoft SQL Server 6.0- SQL 2005 and SQL 2008

Web Server:: IIS

Operating Systems: Windows 2000/ XP, MS DOS.

Web Designing: HTML5, HTML4, XHTML, Java Script, CSS, XML, XAML, XSL

Reporting Tools: SSRS, Crystal Reports

Version Control System: Visual Source Safe 6.0, TFS

Testing Tools:: Manual Testing

Scheduling Tools: AutoSys

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Application Developer

Responsibilities:

• Development and supporting Centralized Underwriting web based application using .Net MVC
• Designed Search box (autofill) like custom controls by using web services interact with database to fulfill the auto complete functionality.
• Designed user interactive popup's using jQuery and Ajax
• Utilized Http requests to authenticate users to access resources based on their role registered in a table.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the different business users in CU team Middle Market Banking
• Extensively used SSRS reports subscriptions to automate the delivery of the report to business users from different RCBO’s
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created parameterized reports, Drill down, Drill through reports and dashboard reports using SSRS.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into various destinations like SQL DB, SharePoint lists and Excel files.
• Scheduled packages in AutoSys/Integration Services (SQL Agent)
• Created SSIS packages using SSIS Designer for export heterogeneous data from ODBC source Teradata, Excel spreadsheets and flat files to SQL server 2008 R2/2012.
• Performed operations like Data reconciliation, validation and error handling after extracting data into SQL server
• Used ETL (SSIS) to extract data from SharePoint server list (OData Source, SharePointListAdapter -Codeplex) to SQL server tables and reconcile data with WDM (business data-Teradata) and upload reconciled data to SharePoint Server
• Scheduled all SSIS packages under SQL server agent to import, export and profiling data periodically
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Extensively used package level variables, expressions and config files to configure Origin and destination connection mangers.
• Configure SharePoint List to render the SSRS reports
• Deployed and configured in Azure cloud

Environment: .NET Framework 2.0/3.5/4.0, C#, VB.NET, ASP.NET, MVC, JQuery, JavaScript, Windows 2008, MS SQL Server 2008 R2/2012/2014, SQL Integration Services(SSIS), SSRS, Business Intelligence Development Studio, Visual Studio 2008/2010/2013 and Teradata, Azure

Confidential, Atlanta, GA

Sr. Developer

Responsibilities:

• Involved the project from Initiation through the implementation
• Involved all wireframe meetings and documenting the business requirement
• Prepared the FRs(functional requirement)
• Involved creating prototypes and POC (proof of concept).
• Database designing and implementing for SQL Server queries, tables, stored procedures, triggers in Connected and Disconnected mode of ADO.NET
• Conduct code review and validated the design standards & functionality
• I have developed Google search box (autofill) like custom controls by using web services interact with database to fulfill the auto complete functionality.
• Designed user interactive popup's using jQuery and Ajax
• Automated the process of extract data from excel and populated in production db.
• Interacting with QA team and reviewed test cases
• System testing, UAT support and Production Support
• Prepared SQL server script for System, UAT and production deployment
• Prepared production deployment document and backup plan
• Developing reports using SSRS.

Confidential

Responsibilities:

• Involved the project from Initiation through the implementation
• Coordinate with the onsite customer and offshore development team and supporting the existing product enhancements Coordinate with the onsite customer and offshore development team and supporting the existing product enhancements
• Developed web pages using ASP.Net /HTML 5 and Knockout js
• Creating Interfaces for WCF services to communicate between DAL and other business components.
• Designed and developed Business/Data layers using C#, Entity Framework and Web Services (XML/SOAP), WCF
• Database designing and implementing for SQL Server queries, tables, stored procedures, triggers in Connected and Disconnected mode of ADO.NET
• Developed windows service components to interact with other applications
• Used XML as data transfer mechanism between COM and web pages
• Periodic Status report to client manager including the Risks & Mitigation Plan
• Managed & Mentor offshore team, helped the team with Design Standards, Coding, & Troubleshooting
• Conduct code review and validated the design standards & functionality
• Created project plan using MS Project
• System testing, UAT support and Production Support
• Production deployment and setup creation using MSI
• Prepared SQL server script for System, UAT and production deployment
• Prepared production deployment document and backup plan

Confidential

Team Lead

Responsibilities:

• Conducted meeting with Business Team & Gathered Requirement
• Analyzed the functional requirements and convert into technical specifications
• Impact Analysis of the Change Request
• Mentor the offshore team in Process, Design & Coding Standards
• Managed the team and helped them in resolving the issues faced
• Defined WPF application architecture with regards to the presentation layer provided coding standards, demonstrated best practices and approaches to WPF implementation
• Creating Interfaces for WCF to communicate between DAL and other business components
• Designed and developed Business/Data layers using C#, ADO.Net and Web Services (XML/SOAP), WCF
• Developed Listener component using multithreading.
• Conduct code review and validated the Process & design standards were followed
• Developed User interfaces and service layers
• Database designing and implementing for SQL Server queries, tables, stored procedures, triggers in Connected and Disconnected mode of ADO.NET
• Developed reports using MS SQL reporting Service (SSRS)
• Used XML as data transfer mechanism between components
• Reviewed the Unit & Integrations test plans and Test Cases
• System testing, UAT support and Production Support
• Periodic Status report to client manager including the Risks & Mitigation Plan
• Production deployment

Confidential

Sr. Software Engineer

Responsibilities:

• Requirement gathering analysis and end user meetings.
• Converting functional requirements into technical specifications
• Developed web pages using ASP.Net or developing components using VB.Net
• Developed client side scripting using Java Script
• Done code review and involved process related activities
• System testing, UAT support and Production Support
• Status report to client manager and Project manager

Confidential

System Engineer / Developer

Responsibilities:

• Developed client side script to validate UI controls using Java Script
• Responsible taking care of Sev2 and Sev3 level support and bug fixing
• Done Unit testing and deployed components in both system test and UAT server
• Done code review and involved process related activities
• Production Support

Confidential

Developer

Responsibilities:

• Developed client side script to validate UI controls using Java Script
• Responsible for design and developing web pages and components
• Done Unit testing and deployed components in both system test and UAT server

Confidential

Responsibilities:

• Developed client side script to validate UI controls using Java Script
• Responsible for design and developing web pages and components
• Done Unit testing and deployed components in both system test and UAT server
• Involved in production build deployment involved Bug fixing and integration testing
• Developed all reports using Crystal Report

Confidential

Developer

Responsibilities:

• design vb forms UI coding and unit testing creating installing package using install shield involved Bug fixing and involved in production build deployment

Confidential

Developer

Responsibilities:

• design vb forms, coding and unit testing creating installing package using install shield
• Involved in production build deployment and involved Bug fixing

Developer

Responsibilities:

• design vb forms, coding and unit testing creating installing package using install shield
• Involved in production build deployment and involved Bug fixing