SUMMARY:

• Having more than 12 years of experience as a Full Stack Software Professional worked in all phases of Software Development Life Cycle (SDLC) such as Requirement Gathering & Analysis, Design, Development, Implementation, Testing and Deployment of Client/Server and Web - based using Microsoft Technologies.
• Extensively worked on developing Windows and Web applications using .Net Framework 4.6/4.0/3.5/3.0/2.0, ASP.NET 4.0/3.5, ADO.NET, EF4/ 5, WPF, C#.NET and VB.NET.
• Proficiency includes experience with Retail, Inventory, Banking and Financial domains.
• Hands on experience in Extract, Transform & load (ETL) development using SQL ServerIntegration Services (SSIS).
• Extensively worked in client-side scripting languages like JavaScript, JSON, AJAX and jQuery, Themes, Master Pages, HTML and CSS.
• Good knowledge on FoPro and VB6 programming.
• Good knowledge in creating the WCF services to implement SOA architecture and Experience in building Web Services using WSDL and SOAP.
• Strong abilities in designing & normalization of relational database, creating complex database queries, Stored Procedures, Triggers, Views, Functions, SSIS/DTS Packages and, migration of DTS packages to SSIS in MS SQL Server. Also having Good exposure in reporting tools like SSRS generated dynamic reports and analytics SSAS.
• Worked extensively on ADO.NET, LINQ for data retrieval, CRUD operations, data filtering & sorting and Entity Framework 4/5 to access and update database.
• Extensive experience in development and optimizing of Queries using SQL Query Analyzer, Stored Procedures, Triggers and complex queries
• Supported Autosys jobs and monitor the jobs and alerts for smooth functioning of all the applications. Having knowledge in supporting tools like Service Now, Quality center and BMC Remedy.
• Experience in various software methodologies like Agile Methodologies and Waterfall. Also performed Code reviews, participated in daily SCRUM meetings and worked in Test driven development (TDD).
• Ability to work independently and enhance knowledge and skills on various assignments to effectively complete responsibilities by taking personal responsibility for professional development and training.

TECHNICAL SKILLS:

Technologies: ASP.NET, MVC 5, ASP.NET Core, WCF, WEB API, LINQ, ADO.NET, Web Services, EF5.0

Programming Languages: C#4.0, VB.NET, VB6, SQL, FoxPro, Python, PL/SQL, T-SQL

Database: MS SQL Server 2005, 2008, 2008 R2, 2014, ORACLE, MS-Access

Scripting Languages: JavaScript, JQuery, Angular JS, XML

GUI: HTML and CSS

ETL Tools/ Reporting Tools: SSIS 2005, 2008, Informatica, Crystal Reports, SAP BOXI, SSRS 2005, 2008

Scheduling Tools: Visual studio 2005, 2008, 2010, 2013, 2015, Visio, TFS, Microsoft Visual SourceSafe, ServiceNow, Autosys (CA)

Operating Systems: Windows Family, Linux

PROFESSIONAL EXPERIENCE:

Confidential, OH

Sr. Software Development Analyst

Responsibilities:

• Created new Web pages using ASP.NET MVC and designed web reports to show using report viewer.
• Developed desktop application using VB.net, MVVP & WPF and data between the desktop and web versions are synced using Microsoft’s sync framework.
• By using Ajax calls increased responsiveness, and effectively used JQuery for traversing HTML document and event handling.
• Effectively created easy to use reusable controls, partial views and Master Pages and integrated them into ASP.NET web pages.
• Extensively used LINQ and Entity Framework 5 to exchange data between web applications and database objects.
• Experienced in Client-side scripting JavaScript, jQuery, and AngularJS.
• Performed Modal Validation using Data annotations, Created Entity Model classes.
• Written Stored Procedures and other database operations such as complex SQL queries, views etc. Worked on performance tuning of stored procedures.
• Maintained nearly 10 plus Microsoft technology applications. Which include MVC, WCF services, web applications.
• Monitor Autosys jobs and alerts for smooth functioning of all the applications.
• Good Experience in debugging the application and fixing the production issues.
• Conducted module level work effort estimates and integrated for the whole system.
• Implemented use of best practices and coding standards.
• Communication and co-ordination with offshore and onshore teams for updates/clarification on day to day activities

Environment: Visual Studio2013/2015, SQLServer2012/2014, MVC, MVVP, WPF, ASP.Net, C#.Net,VB.Net, HTML5, LINQ, Entity Framework, Autosys, Azure, SSIS, JavaScript, Angular JS and RDLC reports, JQuery, WCF and AJAX.

Sr. Software Analyst

Responsibilities:

• Developed a web based application using ASP.Net, C#.Net, MVC, LINQ, Entity Framework
• Using ASP.NET MVC developed CRUD operations.
• Implemented LINQ for querying, sorting, filtering the complex objects.
• Worked on Entity Framework in Accessing the Database and manipulating data in Application.
• Debugged the Stored procedures and updated the business logic. Created triggers, UDFs, views, indexes and transactions.
• Performed extract, transform and Load (ETL) data operations from multiple systems to SQL Server using SSIS packages.
• Good Experience in debugging the application and fixing the production issues.
• Followed change management system and version management using TFS.
• Managing the deliverables and release activities and participating in scrum discussions.
• Deployed the site in to Production and Pre-Prod, QA Servers
• Supported Auosys Jobs and windows Jobs.
• Followed SLA and delivered the incidents on time.
• Communication and co-ordination with offshore and onshore teams for updates/clarification on day to day activities

Environment: Microsoft SQLServer2012 and Visual Studio2013 ASP.Net, C#.Net, LINQ, Entity Framework, Autosys, batch files, SSIS, JavaScript, jQuery

Sr. Software Analyst

Responsibilities:

• Individually developed major enhancements like voting screens, admin from/To data and Include/Exclude modules.
• Optimized the SQL procedures and improved the performance for which received appreciations from the client.
• Implemented design patterns and the entire backend of the application in VB.NET, using various object oriented features like classes, interfaces, inheritance, polymorphism etc. and Multi-threading.
• Responsible for managing and executing projects which include Requirement Gathering, analysis, Design and Development and System Testing.
• Involving in handling ASP.NET client side state management (view state, cookies and query strings) and server side state management (application state, session state and profile properties)
• Programmatically accessed Microsoft's Active Directory, involved in Active Directory Management .
• Developed and debugged very big stored procedures and designed data base structures.
• Created reusable user controls and implemented object caching in different pages in ASP.NET.
• Deployed the site in to Production and Pre-Prod, QA Servers

Environment: ASP.Net, C#.Net 4.0, WCF, LINQ, Entity Framework 4.0, SQLServer2008 R2, Visual Studio2010, JavaScript, XML, JQuery, Autosys, batch files, SSIS, Crystal Reports.

Sr. Software Engineer

Responsibilities:

• Developed application and worked with Ado.net, Data Grid, and Data Set.
• Used ASP.NET for front-end and VB.NET in the Business and Data Access Layers to write Validation objects.
• Implemented object oriented programming concepts.
• Used grid view pagination, sorting and data update operations.
• Used windows Based Authentication for the Application to access only in INVESCO network.
• Fixed bugs in the application at the business logic level and created Unit Test cases for the same
• Used SQL Server Integration Services (SSIS) for extraction transformation and loading data from different broker feeds.
• Worked on different data format files and load the scrubbed data into SATRNG system using SSIS packages.
• Created numerous Autosys jobs to run the SSIS packages
• Followed SLA and delivered the incidents on time.
• Used Execution plans and query optimization techniques for performance tuning of SQL in reports.
• Developed Crystal Reports and scheduled in BOXI to access only for compliance officers.
• Communication and co-ordination with onshore team for updates/clarification on day to day activities

Environment: ASP.NET, VB.NET, JavaScript, ADO.NET SQLServer2005 and Visual Studio2005, Crystal Reports, BOXI, SQL Server integration Services (SSIS), Autosys, Batch files

Sr. Software Engineer

Responsibilities:

• Designed and developed Data Access layer, Business layer and Presentation Layer (user interface) for the web application using VB.NET, ADO. NET and ASP. NET.
• Completed Facilities and Profile modules individually.
• Created reusable user controls and implemented object caching in different pages in ASP.NET.
• Written Stored Procedures and other database operations such as complex SQL queries, views etc. Worked on performance tuning of stored procedures.
• Responsible for managing and executing modules which include Requirement Gathering, analysis, Design and Development and System Testing

Environment: ASP.NET, VB.NET, ADO.NET, JavaScript, SQLServer2005 and Visual Studio2005

Analyst Programmer

Responsibilities:

• Individually developed major enhancements like custom links module.
• Developed application and worked with Ado.net, Data Grid, and Data Set.
• Optimized the SQL procedures and improved the performance for which received appreciations from the client.
• Involved in requirement gathering and preparation of specification document
• Responsible for designing, development, deployment and maintenance of the system.
• Fixed bugs in the application at the business logic level and created Unit Test cases for the same.
• Design and develop databases Tables, Stored procedures, cursors, using SQL Server 2000.
• Involved in integration and testing of the system.
• Deployment of the application in client’s server

Environment: VB.NET, ASP.NET, ADO.NET, Web Services, SQLServer2000 and Windows 2002 Professional