SUMMARY:

• Over 5+ years of professional experience in all stages of the SDLC (Software Development Life Cycle) involving studying of the user requirements, analyzing, designing, implementation, testing, deployment and delivering high quality web and Windows solutions including analysis, Design, Coding, Testing & Deployment using Microsoft .NET Technologies.
• Troubleshot and resolve bugs in C#.NET application to ensure optimal development environment.
• Identify and resolve project issues, including issue tracking and escalation.
• Experience in technologies like C#.NET, ASP.NET, VB.NET, ADO.NET, SQL, SQL Sentry, JavaScript, JSON, JQuery, web controls, XML, AJAX, SQL,Windows Service and WPF.
• Including 4 years’ experience in writing and optimizing stored procedures in MS SQL Server 2008/2012/2014 . Hands on experience in tuning SQL queries and T - SQL for enhancing the database performance.
• Extensively worked with business analysis and requirements in Agile Methodologies such as SCRUM.
• Hands on experience in design using Object Oriented Programming Principles (OOPS) like Encapsulation, Inheritance, Polymorphism and Abstraction.
• Strong experience with Microsoft Technology .NET Framework using C#, ADO.NET, VB.NET, Visual Studio.NET 2005/2008/2010/2012/2013/2017.
• Exclusively used ASP.NET Web Parts, Master Pages, User Controls and Custom Controls to design the Rich User Interactive Web Pages.
• Created Web user interfaces using JavaScript, Angular 2, HTML and CSS.
• Experience with development of applications using MVC frame work, WCF.
• Experience in relational database design, data extraction, data transformation and loading from large and complex data sources Programming using RDBMS databases like SQL Server 2014/2, MS Access.
• Participated in implementing real-time interfaces includes planning, development, testing and deployment using C#.net Windows Service.
• Worked extensively with ADO .NET objects such as Data Adapter, Dataset, and Data Reader to interact with databases like SQL Server 2014/2 .
• Extensively worked on writing Stored Procedures, Triggers, Views and Database Design. Good knowledge and experience SQL Server integration Services (SSIS), SQL Server Reporting Server (SSRS) and Crystal Reports.
• Experienced with TFS and SVN for versioning and project management.
• Develop application infrastructure component like logging, exception handling, data access.
• Design and executing test plans and gap analysis to ensure that business requirements and functional specifications are tested and fulfilled.
• Good Capable of leading a team of 7 members and working with the team. Leadership qualities, problem solving, multitasking, mentoring team members and ability to prioritize.

SKILL:

Languages: C#.Net, VB.Net, C, C++, SQL, T-SQL.

Technologies: ASP.NET (2.0,3.0, 3.5,4.0), MVC 4.0/3.0, ADO.NET, HTML, HTML 5, AJAX, Windows Services, CSS, WPF, WCF, JavaScript, JSON, Web Services, jQuery, Angular2, Redgate, SQL Sentry.

Database: SQL Server 2005/ 2008/2012/2014 , MS Access 2010/2007/2003 , MYSQL, MYSQL Workbench.

Operating System: Windows 7, 8, 8.1, 10, Vista, XP.

IDE & Tools: Visual Studio 2005/2008/2010/2012/2017 , SQL Server Management Studio.

Version Control Tools: TortoiseSVN, Team Foundation Server.

BI Tools: Webfocus

Reporting Tools: Crystal Reports, Telerik Reports.

WORK EXPERIENCE:

Confidential

Software Engineer, Cincinnati, OH

Responsibilities:

• Troubleshot and resolve bugs in C#.NET application to ensure optimal development environment.
• Identify and resolve project issues, including issue tracking and escalation.
• Involved in Design and Code Construction with OOPs Implementation in MVC Architecture.
• Handled production issues during the deployments and effectively managed client change requests.
• Identifying issues with the database and Implementing DML script to resolving them. Worked on Materializing the views to optimize and provide better performance of the reports.
• Worked with different environments (DEV, QA, RC, Staging and PROD) according to the requirement.
• Using C#.net involved in code optimization and performance tuning of the application. A working knowledge of SQL Profiler, SQL Sentry, Webfocus.
• Used Entity Framework to query the Business and Data objects.
• Prepared and updated documentation to ensure all procedures and knowledge are traceable in future cycles.
• Created and handling the SQL Agent Jobs which are scheduled and process every hour.
• Involved in writing Test cases to run against different environments. Closely worked with QA to verify the results moved to Test servers from the development severs.
• Maintained the version of the project in Microsoft Team Foundation Server (TFS) by using module developed with latest version in TFS.
• Worked in Agile environment. Used to do scrum meeting( to accommodate client's requirements.) on daily bases and discussing the task is in hand and the task to be done in future in the scrum meeting to get the visibility of the project and to know what are the road blocks.
• Adjusting Stored Procedures and Views based on revised logic. Checkin the changes using Red gate.
• Provided WO support. Based on issue used to debug the code and appropriate fix was applied to Code/ Database changes.

Environment: .NET Framework 3.5/4.0, C#.net, MVC, SQL, SQL Server 2014/2008, Visual Studio 2017,TFS, Webfocus, Redgate, SQL Sentry, SQL Profiler, Stackify.

Confidential

Software Engineer, Orlando, FL

Responsibilities:

• Strong technical background, including programming, developing, designing interfaces, testing and debugging code, and administering systems and networks.
• Worked on business layer in C#.Net to handle existing functionality of the system as well as new proposed functionalities.
• Wrote complex stored procedures to migrate data from multiple sources and process into data marts.
• Designed and developed from based standard and automation Windows Desktop applications for common day to day tasks engines which extract the data from excel, XML files and process into database using C#.Net.
• Worked on creating windows service using C#.Net which handles the real time data processing with port to port connectivity without user interaction. I was one of the key person who handles the flow of real time data interface’s. Testing, debugging and deploying on the server.
• Used ADO.NET extensively for retrieving, querying and manipulating data in the database.
• Extensively used joins and sub-queries to simplify complex queries involving multiple tables and used SQL tools like SQL Developer, SQL Server Management Studio.
• Responsible for analyzing, debugged the issue in sending and receiving an ack from the server to client server to notify the client once when we received the HL7 message.
• Worked on HL7 Data, processing the messages from interface and pumping the data in to tables and generated outbound messages to send data through HL7. Good knowledge on different types of HL7 messages (ORU, ADT).
• Written highly complex views, stored procedures, and triggers to handle business requirements and Generate SSRS Reports.
• Involved in designing the database and identifying primary keys, foreign keys and enforced not-null and checked constraints in the table and followed the principles of normalization.
• Analyzing the requirements and problems from customer delivery team in order to automate or improve the existing flow.
• Maintaining client’s databases on our server's up to date with their system. Exported client's data from different source in order to show up on our application.
• Applied SQL server Profiler to traces the stored procedures and queries to improve the data flow performance into the application.
• Designed and developed Lab database ware house which holds different types of lab data coming from different source.
• Report the daily progress and having stand up calls. Leading the team, getting updates and assigning task to the team.
• Used SVN as version control tool.

Environment: .NET Framework 3.5/4.0, C#.net, Vb.Net, SQL, T-SQL, SQL Server 2014/2012/2008 , Windows Service, Visual Studio 2015,2013&2010, ADO.Net, JSON, MYSQL.

Confidential

Graduate Research Assistant (Intern), TX

Responsibilities:

• Collecting, collating, and carrying out complex data analysis in support of management.
• Performed multiple SQL queries using SQL Server and created database driven reports with output to MS Excel and custom reports such as monthly migration reports.
• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Configuring Backend Job's in order to update new data and create automated job using windows.
• Reviewed Stored Procedures and created views for reports and wrote test queries against the source system (SQL Server).
• Generate report's from back-end by using SQL server 2008 & 2012.
• Writing T-SQL scripts to manipulate data for data loads and extracts.
• Responsible for loading, extracting and validation of student data.

Environment: SQL Server 2012/2008, T-SQl, SQL, MS Excel.

Confidential

.Net Developer

Responsibilities:

• Involved in complete life cycle of software development including designing, developing, testing, and deployment of the web portal application.
• Developed multiple projects in Windows and web application in C#.Net, VB.Net, ASP.NET using OOPS concepts and Telerik Controls.
• Used ASP.NET Validation Controls and developed Angular, JavaScript to perform various Client-side validations.
• Designed User Interface with CSS, and HTML. Used Master pages to give a consistent layout to all pages.
• Used Agile (Scrum) Methodology for rapid and more disciplined development during implementation.
• Used ASP.NET MVC design pattern in the design and development, with Razor Syntax in Views .
• ADO.NET objects such as Data Set, Data View, Data Reader and Data Adapter are used in the Data Access layer to communicate with the database to access, update data in the database and SQL Command extensively for retrieving, querying, storage and data manipulation.
• Designed all modules based on MVC pattern. Incorporated the structure error exceptional handling try catch blocks all throughout the development to handle exceptions.
• Developed Desktop application using VB.NET. Migrated some of the low level application from C# to VB.net to make application stable.
• Database design and development of Database objects (Tables, Stored Procedures) in SQL Server 2008 using Microsoft SQL Server Management Studio Express.
• Designed and Developed standard reports in Crystal reports.
• Designed large numbers of Windows Presentation Foundation (WPF) Forms, Custom Controls and User Controls.
• To persist and transfer data between pages Session State, View State, Cookies and Query strings were used.
• Developed Mobile application using jQuery mobile and In-charge of overall design and coding of the module.
• Created provisions for setting up multiple projects along with the budgets approved by the Donors and up cross currency exchange rates for automatic conversions.
• Report the daily progress and impediments to the Scrum Master in the daily stand ups.
• Implemented version controlling using Microsoft Team Foundation Server.

Environment: ASP.NET, C#.Net, VB.Net, SQL Server 2012,ADO.net, Telerik Rad Controls, Telerik Reporting, Java Script, OpenStack.NET Cloud Files, MVC, WPF, HTML,CSS, REST, AJAX, TFS.

Confidential

Software Developer

Responsibilities:

• Responsible for developing Application using ASP.NET 3.5, ADO.NET and C#.
• Used Visual Studio .NET 2012 IDE to design the forms, develop and debug the application.
• Developed User Interface with CSS, HTML and DHTML and also involved in developing web Pages with rich UI, AJAX, JQuery using ASP.NET.
• Worked on WCF services, which are used to communicate to the other departments.
• Worked on Client side validations using Java Script, JQuery, and CSS for validation issues.
• Extensively used State Management Techniques like Sessions state to maintain state between the ASP.NET pages.
• Used Microsoft ADO.NET to access data from database in a web application and SQL Command extensively for retrieving, querying, storage, data manipulation and created tables, stored procedures in SQL Server 2012.

Environment: Visual Studio .net 2012, ASP.NET, C#.Net, MVC, AJAX, JQuery, CSS, HTML, HTML5, JavaScript, ADO.Net, Web services, SQL Server 2012.