SUMMARY:

• Having 9+ years of experience in project technical design , business process, coding, unit testing (QA) and database design. Experience on implementing software development Life cycle (SDLC) of .NET/Oracle/SQL server applications on software design, development, testing, implementation, configuration, and deployment.
• Having good knowledge on Banking and Litigation line of business.
• Composed User Interfaces, Web pages, and Windows Forms.
• Excellent experience in C#.net, VB.net, ASP.net, MVC, Oracle PL/SQL and SQL Server.
• Certified in Microsoft .NET Framework - Application Development Foundation.
• Knowledge in using .Net - Angular JS.
• Good experience with Oracle 8i/9i/10g including PL/SQL programming.
• Proficient in writing SQL, PL/SQL stored procedures, functions, packages and triggers.
• Knowledge in using Oracle/TOAD Developer Suite for Forms development.
• Worked on user friendly user interfaces by incorporating HTML, Java Script, AJAX and JQuery.
• Good experience in performance tuning.
• Strong understanding of and exposure to windows and web based application design, web security, validation, optimization, user controls, data controls and custom controls.
• Experience in creating project documentation, use case class (UCC), unit test case, project exceptions document, deployment document.
• Extensive experience with ADO.NET, Web Application, Windows Application and web/Window services.
• Strong experience in data analysis , System Design and generating technical specifications.
• Worked on all versions of .NET Framework 2.0/3.0/3.5/5.0.
• Experience in Data Structures and Data Analysis.
• Good experience in new ideas and process improvements.
• Have capabilities in analytical, logical, programming and interpersonal skills.
• Have knowledge of SharePoint site area.
• Have knowledge on MVC - Entity Framework and Business Object Model.
• Have knowledge on WCF - Windows Communication Foundation.
• Good experience in SQL Server 2005, SQL Server 2008, SQL Server 2010, SQL Server 2012, SQL Server 2015
• Extremely proficient in database design, stored procedures, views, functions, database triggers, cursors joins, Replication.
• Extensive SQL Development experience in Banking and Healthcare industries with a strong understanding of data & analytics.
• Extensive knowledge in tuning T-SQL (DDL, DCL and DML) queries to improve the database performance and availability.
• Have knowledge on SQL Server - SSIS and SSRS.
• Extensive experience in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reports using SQL Server Reporting Services.
• Good experience in Exstream Software Dialogue.

TECHNICAL SKILLS:

Programming Languages: C#, VB.NET, Win Form, ASP.NET, MVC 4/4.5, WCF, Angular JS, C, C++, HTML 5, JavaScript, VB Script, AJAX, MVVM, Bootstrap and JQuery.

.NET Skill Set: .NET Framework 1.1/2.0/3.0/3.5/4.0 /5.0 , ASP.NET, ADO.NET, XML, master pages, Themes, skins, Web Parts, Unit test, Crystal Reports, QA process.

Databases: Oracle SQL, Oracle PL/SQL, Sql server 2005/2008/2010/2012/2015 , T-SQL, SQL server Replication, SSIS, SSRS.

Operating Systems: Windows /2000/Server/XP.

Software: Visual Studio.NET 2003/2005/2008/2010/2015/2017 , Visual Studio 6.0.

Tool: SharePoint site, HP Quality Centre

Version Control: Team Foundation Server (TFS), IBM Clear case and SVN sub version.

PROFESSIONAL EXPERIENCE:

Confidential

Sr.NET Developer / SQL Server Developer

Application: eSnag Application Development / Quality Control Management - Dubai / Egypt / India

Responsibilities:

• Responsible for updating the business requirement document and writing the technical specification document
• Extensive experience in Database query tuning, Performance tuning of Reports and troubleshooting SQL Server objects.
• Coordinate with Business, project team and team members.
• Involved in the preparation of high level design documents.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
• Involved in the design and development of ASP.Net, MVC, Angular JS for eSnag system.
• Hands on experience in design using Object Oriented Programming Principles like Encapsulation, Inheritance, Polymorphism, reusability and Design patterns like Abstract factory, Singleton, Object pool a standard solution to common problems in software design.
• Involved in analysis, design and development of GUI and Database components.
• Implemented ADO.Net data access techniques i.e. Oracle Connection Objects, Oracle Command Objects, Dataset Objects, Data Reader Objects and Data Adapter Objects using Data Grid, Data List and Repeater controls.
• Worked with Entity frame work, SQL Server database 2016.
• Experience in SQL Server database design and development.
• Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business Analyst.
• Development of SQL server stored procedures, packages, functions, triggers, Indexes.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Wrote Packages, Procedures and triggers to capture inserted, deleted and updated data from LSA system.
• Created Triggers to enforce data and referential integrity.
• Created Platform independent schema structure so that the product data can be implemented in any database.
• Generated complex packages, procedures and functions.
• Created indexes for the quick retrieval of the data from the database.
• Defined constraints, rules, indexes and views based on business requirements.
• Created database maintenance planner for the performance of Oracle Server, which covers Database integrity checks and re-indexing.
• Developed Test Cases and Scripts for testing the application.
• Involved in the Unit testing and User Acceptance Testing and ensure the completeness of the testing.
• Involved in the Resolution of technical issues while testing.
• Production support of these applications in a timely manner.
• Ability to perform outstandingly in high-pressure environments and stressful situations
• Excellent communication, analytical, presentation, teaching and interpersonal skills

Environment: .NET Skill Set: .NET Framework 1.1/2.0/3.0/3.5/4.0 /5.0 , C#.NET, VB.NET, ASP.Net, ADO.NET, MVC, AJAX, Java Script, JQuery, XML, Unit test, Crystal Reports, Highcharts,QA process.

Databases: SQL server 2008/2012/2016 , T-SQL, SQL server Replication, stored procedures, functions, triggers, Indexes.

Confidential, Michigan

Sr.NET Developer

Application: Litigation Application

Responsibilities:

• Experienced in requirement analysis, coding and testing various modules in a software development life cycle.
• Responsible for updating the business requirement document and writing the technical specification document
• Extensive experience in Database query tuning, Performance tuning of Reports and troubleshooting Oracle Application issues.
• Coordinate with Business, project team and team members.
• Develop logical and physical data models that capture current state/future state data elements and data flows
• Involved in the preparation of high level design documents.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
• Involved in the design and development of VB.net components, ASP.Net, MVC for LSA system.
• Hands on experience in design using Object Oriented Programming Principles like Encapsulation, Inheritance, Polymorphism, reusability and Design patterns like Abstract factory, Singleton, Object pool a standard solution to common problems in software design.
• Involved in analysis, design and development of GUI and Database components.
• Implemented ADO.Net data access techniques i.e. Oracle Connection Objects, Oracle Command Objects, Dataset Objects, Data Reader Objects and Data Adapter Objects using Data Grid, Data List and Repeater controls.
• Experience in RAD controls, Kendo and Telerik controls.
• Worked with Entity frame work, Oracle 8i, Oracle 11g and Oracle PL/SQL as back end.
• Experience in Oracle and SQL Server database design and development.
• Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business Analyst.
• Development of Oracle PL/SQL server stored procedures, packages, functions, triggers, Indexes.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Wrote Packages, Procedures and triggers to capture inserted, deleted and updated data from LSA system.
• Created Triggers to enforce data and referential integrity.
• Created Platform independent schema structure so that the product data can be implemented in any database.
• Generated complex packages, procedures and functions.
• Created indexes for the quick retrieval of the data from the database.
• Defined constraints, rules, indexes and views based on business requirements.
• Created database maintenance planner for the performance of Oracle Server, which covers Database integrity checks and re-indexing.
• Developed Test Cases and Scripts for testing the application.
• Involved in the Unit testing and User Acceptance Testing and ensure the completeness of the testing.
• Involved in the Resolution of technical issues while testing.
• Production support of these applications in a timely manner.
• Ability to perform outstandingly in high-pressure environments and stressful situations
• Excellent communication, analytical, presentation, teaching and interpersonal skills

Environment: .NET Skill Set: .NET Framework 1.1/2.0/3.0/3.5/4.0 /5.0 , C#.NET, VB.NET, ASP.Net, ADO.NET, MVC, AJAX, Java Script, JQuery, XML, Unit test, Crystal Reports, QA process.

Databases: Oracle 8i, Oracle 11g and Oracle PL/SQL, SQL server 2008/2012, T-SQL, SQL server Replication, stored procedures, functions, triggers, Indexes.

Confidential, California

Sr.NET Developer\Tech Lead

Application: Bloomfire

Specialties: Skin & Body Care, Cosmetics, Health & Wellness, Anti-Aging, Nutrition, Direct Selling, Network Marketing, Business Opportunity

Responsibilities:

• Understanding of requirements.
• Responsible for updating the business requirement document and writing the technical specification document
• Coordinate with Business, project team and team members.
• Involved in the preparation of high level design documents.
• Involved in the design and development of ASP.net components to call Bloomfire API interface.
• Involved in analysis, design and development of ASP.net/API and Database components.
• Developed scripts in Java Script.
• Created AJAX script for page validation.
• Created CSS file for page design and lookups.
• Developed Java Script and ASP.net page to link to Bloomfire community - US English, US Spanish, Canada English, Canada French, Australia and UK community.
• Worked with Entity frame work, Oracle 8i, Oracle 11g and Oracle PL/SQL and SQL server 2008 as back end.
• Experience in Oracle database design and development.
• Development of Oracle PL/SQL server stored procedures, functions, triggers, Indexes.
• Development of SQL server stored procedures, functions, triggers, Indexes.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Wrote Stored Procedures and triggers to capture inserted, deleted and updated data from OLTP systems.
• Created Triggers to enforce data and referential integrity.
• Generated complex stored procedures and functions for better performance and flexibility.
• Created indexes for the quick retrieval of the data from the database.
• Defined constraints, rules, indexes and views based on business requirements.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Created SSIS Packages using Transformation, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, MS Access and CSV files.
• Responsible for creating the reports based on the requirements using SSRS.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).
• Developed Test Cases and Scripts for testing the application.
• Involved in the Unit testing and User Acceptance Testing and ensure the completeness of the testing.
• Involved in the Resolution of technical issues while testing.
• Production support of these applications in a timely manner.

Environment: .NET Skill Set: .NET Framework 1.1/2.0/3.0/3.5/4.0 , C#.NET, VB.NET, ADO.NET, XML, Unit test, Crystal Reports, QA process.

Databases: Oracle 8i, Oracle 11g and Oracle PL/SQL, SQL server 2008, T-SQL, SQL server Replication, stored procedures, functions, triggers, Indexes.

Confidential, FL

Sr.NET Developer\Tech Lead

Application: JAAMS

Responsibilities:

• Involved in the preparation of high level/low level design documents.
• Involved in the design and development of major user interface components in .net framework.
• Involved in analysis, design and development of GUI and Database components.
• Developed components in VB.net, WinForms, and JANUS Grid control, SQL Server 2005 and SQL Server 2008, Oracle 8i, Oracle 11g and Oracle PL/SQL. HP Quality Centre and IBM Clear case - Version control.
• Hands-on experience with Oracle PL/SQL.
• Development of PL/SQL stored procedures, views, functions, triggers, Indexes.
• Keen focus on performance tuning, testing, and quality assurance.
• Design of tables, databases with Oracle Applications.
• Design and development of UI framework, developed Windows service for file watch watcher and file movement.
• Developed and designed screens for data entry using VB.
• Worked on Interfaces, Inheritance, Method Overload, and Method ridding concepts.
• Worked on Polymorphism, Struct, delegates, and reflections.
• Rewrote some of the forms to reduce the complexity.
• Used 3rd party Janus girds controls for displaying data.
• Worked with Entity frame work, SQL server 2005 and SQL server 2008 as back end.
• Worked on Crystal report to generate various reports.
• Database design for various customers.
• Development of SQL server stored procedures, views, functions, triggers, Indexes.
• Extremely proficient in database design, stored procedures, views, functions, database triggers, cursors joins, Replication, Indexes.
• Involved in performance tuning.
• Worked on indexes - Cluster\Non Cluster\Unique indexes to increase system performance.
• Developed SQL CTE - Common table expressions.
• Involved in the testing phases of the project.
• Developed Test Cases and Scripts for testing the application.
• Involved in the quality check and standards of the program.
• Involved in the Unit testing and User Acceptance Testing and ensure the completeness of the testing.
• Perform usability testing and synthesize data into concrete GUI design proposals; present design ideas using flowcharts, prototypes and mock-ups.
• Involved in the Resolution of technical issues while testing.
• Involved in production HIGH severity bug fixes, enhancements.
• Production support of these applications in a timely manner.
• Worked with Mail Management Team to generate Intelligent Mail Barcode (IMB)

Environment: .NET Skill Set: .NET Framework 1.1/2.0/3.0/3.5/4.0 , C#.NET, VB.NET, ADO.NET, XML, Unit test, Crystal Reports, QA process.

Databases: Oracle 8i, Oracle 11g and Oracle PL/SQL, Sql server 2005 and 2008, T-SQL, SQL server Replication, stored procedures, views, functions, triggers, Indexes.

Confidential

.NET Developer

Responsibilities:

• Understanding of requirements.
• Involved in the preparation of high level/low level design documents.
• Responsible for updating the business requirement document and writing the technical specification document
• Involved in the Development and testing phases of the project.
• Involved in analysis, design and development of GUI and Database components.
• Performed Data analysis on incoming feed from up streams.
• Developed components in WinForms, SQL Server 2005 and SQL Server 2008. HP Quality Centre and IBM Clear case - Version control.
• Created console application to transfer conference data to the database.
• Design and development of UI framework, developed Windows service for file watch watcher and file movement.
• Used different kinds of validation controls for client side validation in ASP .Net
• Worked extensively on User Interface and Business Logic.
• Implemented client side validation using ASP.NET validation controls.
• Used Client as well as Server side validations.
• Extensively used Java Script.
• Extensively used web controls like Data Grid, Master Pages etc.
• Development of Oracle stored procedures, views, functions, triggers, Indexes.
• Development of SQL server stored procedures, views, functions, triggers, Indexes.
• Wrote efficient stored procedures and T-SQL queries to access as well as update data in the database.
• Wrote and implemented queries and stored procedures in SQL Server to access user data and perform data manipulations.
• Developed CTE - Common table expressions.
• Worked on indexes - Cluster\Non Cluster\Unique indexes to increase system performance.
• Defined coding standards and programming strategies as well as standardize the interface between UI and business components to ensure consistency across application.
• Involved in the Unit testing and User Acceptance Testing.
• Developed Test Cases and Scripts for testing the application.
• Validated code, UI standards and approve technical and functional Doc’s.
• Created User Controls and Custom Controls in ASP.Net
• Participated in implementation and production support when system goes live.
• Involved in the Resolution of technical issues while testing.
• Involved in production HIGH severity bug fixes, enhancements.
• Designed and developed .NET components using C# and XML to communicate with Web Services (Exstream Dialogue).
• Used IBM clear case for version control.

Environment: .NET Skill Set: .NET Framework 1.1/2.0/3.0/3.5/4.0 , C#.NET, ASP.NET 2.0, XML, master pages, Themes, skins, Web Parts, Unit test.

Databases: Oracle 8i, Oracle 11g and Oracle PL/SQL, Sql server 2005 and 2008, T-SQL, SQL server Replication, stored procedures, views, functions, triggers, Indexes.