SUMMARY:

• 5+years of experience in system analysis, design, development and implementation in Client/Server technology usingASP.NET with C# & VB programming as frontend &SQL Server & Oracle as backend.
• Expertise in Microsoft Technologies such as ASP.Net 4.0, WCF, WPF, ASP.NET MVC4, ASP. NET Web services, VB.NET, C#.Net, AJAX, ADO.Net, Entity Framework, IIS, SQL Server 2008, SSIS, SSRS, Oracle.
• Strong knowledge in Object Oriented Concepts (OOPs) with best practices like SOLID principles and Design Patterns.
• Good experience in Windows Communication Foundation using SOAP protocol & REST design.
• 4 years of Strong Experience in Oracle PL/SQL programming & Very flexible in writing very Complex SQL queries / Procedures/ Functions/ Triggers, Analyze Execution Plan & improve the Performance by applying best practices.
• Around8 years of experience in scripting languages like VB Script & Java Script.
• Good knowledge in Advanced JavaScript Frameworks like Angular JS, Backbone JS, Bootstrap JS.
• Exposure with Team Foundation Server (TFS)
• Good Knowledge in Data Structures.
• Good Knowledge in Java Script Object Notation (JSON objects)
• Around 4 Years of experience in creating and customizing Client/Server and Web based applications using ASP.Net, VB.Net, ADO.Net, XML, XSL,and Web Services.
• Good Experience in database migration from SQL Server 2005 to Oracle 11g using Oracle SQL developer tool.
• Utilized VB.NET,C#.NET, ASP.NET (1.1/2.0/3.0/3.5 ) and created web forms, win forms, user controls, custom controls, web services, WCF.
• Good experience in developing .NET Removing components and Xml Web Services.
• Knowledge of developing web and client server reports using reporting tools like SSRS, Crystal Reports for .NET.
• Experienced with Agile environment, Win Forms UI designs understanding and experience.
• Having good working experience with the following tools like TOAD for Oracle, SQL Server Management Studio, SQL developer for Oracle, Erwin Data modeling, SQL PLUS, Visual Studio 2005/2008/2012, VSTS (Visual Studio Team System) and Sub Version
• Designed and Developed n - tier (including business and data tier) applications. Well versed with Back end, Middle tier, front end and GUI Development.
• Ability to gather requirements from clients document it and convert it into technical specifications.
• Microsoft Certified Technology Specialist in .NET Framework 2.0 web Applications
• OCA 9i PL/SQL Developer
• Sincere, enthusiastic, hardworking with excellent communication and interpersonal skills and appetite to learn new skills.
• Involved in complete Software Development Life Cycle (SDLC).

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/2000/XP, UNIX

Languages: VB 6.0, VB.NET, C& Data structures, C++, C#.NET, PL/SQL, HTML,CSS, Java Script, XML and XSLT.

Scripting Languages: VB Script, Java Script

Client side UI Frameworks: Angular JS, Backbone JS, Bootstrap JS

RDBMS: Oracle 10g/9i/8i, SQL Server 7.0/2000/2005/2008, MS- Access 2000.

Web Technologies: ASP, ASP.NET, MVC 4

Middle Ware: ADO.Net, .Net Remoting, Web Services, WCF, Windows Services, COM .

GUI: Visual Studio. NET 2003/2005/2008.

Web Servers: IIS 6.0

Reporting Tools: MS Access, SQL Server Reporting Services and Active Reports

Version controls: VSTS, Sub Version, SVN, TFS

PROFESSIONAL EXPERIENCE:

Confidential, Mount laurel, NJ

Sr. Developer

Responsibilities:

• Implemented MVC architecture design for application.
• Implemented Controller Classes to handle requests and execute Application and Data Logic.
• Implemented some of the Razor Views as per the client needs
• Developed and consumed WCF Services to achieve Service Oriented Architecture (SOA) and communication between heterogeneous applications.
• Developed few of the WCF services by creating few Service Contracts and Data Contracts.
• Developed few of the Model Objects by creating few scalable & Maintainable classes by following the best practices ( SOLID Principles in Object Oriented programming concepts)
• Used Factory and Single ton design pattern’s
• Followed Interface segregation principle while defining interfaces.
• Created Stored Procedures, Joins on Key Fields for fast retrieval of Data and Optimizing the Database.
• Troubleshoot lot of the Complex SQL queries by Analyzing query execution plan, applying the required indexes, partitioning the huge tables with Local indexes to improve the query performance.
• Prepared Database deployment installation instructions document.
• Used ADO.Net Entity Framework Model for retrieving and updating Data into the database using Context Object.
• Implemented Test Driven Environment to write Test Cases containing Assert Statements.
• Updated the Requirement Specification document with the latest requirement changes.
• Updated the Design Specification document with the latest client requirement changes.
• Designed and developed base business class and other template classes for business entities using Generics .
• Created Master Pages to maintain consistent layout for the pages for the mobile application.
• Developed and implemented different user controls to provide the rich user interface reusability.
• Performed unit testing, prepared documentation, Debugged and fixed the errors before submitting modules to QA.
• Used Visual Source Safe as version control.

Environment: C#: MS sharepoint web parts, web services,microsoft BIDS,Design optimization ASP.net:Webforms,ASP,ASP.net MVC,MVC,ADO.net Microsoft Visual Studio: MS TFS,MS teschnologics, Window forms, crystal reports,unit testing Visual basic.net: Msvisual sourcesafe,VB Script,database design,window services,system analysis and design

Confidential, New York

Sr. Developer

Responsibilities:

• Designed Entity Diagrams using Erwin Data Modeling tools.
• Used SQL Developer for Oracle tool for migrating the Microsoft SQL Server 2000 objects ( procedures/ functions/ triggers ..etc ) to corresponding objects in Oracle
• Prepared database coding standards template and the shared across the team to follow.
• Identify the frequently occurred migration issues.
• Analyzed migration issues and documented the resolution steps and the same is shared across the team to follow.
• Created a structure by creating packages & procedures with in it.
• Implemented Exception Handling and database Transaction management (COMMIT & ROLLBACK).
• Reviewed and provided the comments to the scripts developed by the team.
• Created a log/Audit table in Oracle to mark the success/ failure of the migrated objects.
• Manually converted few complex Microsoft SQL Server 2000 queries to Oracle by identifying and using oracle compatible datatypes & predefined/inbuilt functions.
• Listed down all the SQL Identity columns in SQL server 2000 and created sequences in oracle to implement the auto increment functionality for those columns in oracle.
• Troubleshoot lot of the Complex SQL queries by Analyzing query execution plan, applying the required indexes, partitioning the huge tables with Local indexes to improve the query performance.
• Prepared Database deployment installation instructions document.
• Created and auto scheduled the jobs in oracle.
• Exported the SQL Server table’s data in to CSV files.
• Created SQL Loaded script files to load data from CSV files to corresponding Oracle Target tables.
• Created migration scripts for the one time data load in oracle
• Created scripts for test cases
• Updated the Requirement Specification document with the latest requirement changes.
• Updated the Design Specification document with the latest client requirement changes.
• Performed unit testing, Debugged and fixed the errors before submitting modules to QA.

Environment: WCF: Entity framework,WCF data services,Jquery,ajax,JSON,IOC,Bootstrap,T-SQL, stored procedures,MS eenterprise library, SQL,WWF,WPF,CSS,Migration,Server administration,jscript,azure,object retional mapping, dependency injection MS Access,PL/SQL,DTS,XML,Java,RDBMS,MS SQL Server,C++,Java Script,OOPS,Web applications,web partsConfidential, New York

Sr. Developer

Responsibilities:

• Created few of the ASP.NET web pages using c#.net as part of new client requirements.
• Created few of the business classes in the middle tier.
• Applied exception handling across all the existing web pages in this application
• Developed few of the User controls which are used as Headers and Footer across all pages in the application
• Identified the list of CSV and Fixed Length files shared by SAP team in shared location.
• Created the correcting Temporary tables in Oracle to push data from SAP files to these TEMP tables
• Used SSIS tool to dump data from flat files to target oracle temporary tables.
• Created Stage and final tables for the corresponding TEMP tables
• Written scripts by applying Transformation rules on TEMP tables and load data in to corresponding Stage tables
• Written scripts to filter unwanted data and load it to final master tables.
• Created a structure by creating packages & procedures with in it.
• Implemented Exception Handling and database Transaction management (COMMIT & ROLLBACK).
• Reviewed and provided the comments to the scripts developed by the team.
• Created a log/Audit table in Oracle to mark the success/ failure of the onetime data load process for individual flat file.
• Troubleshoot lot of the Complex SQL queries by Analyzing query execution plan, applying the required indexes, using bulk inserts & updates to improve the query performance.
• Prepared Database deployment installation instructions document.
• Created and auto scheduled the jobs in oracle.
• Created migration scripts for the one time data load in oracle
• Created scripts for test cases
• Updated the Requirement Specification document with the latest requirement changes.
• Updated the Design Specification document with the latest client requirement changes.
• Performed unit testing, Debugged and fixed the errors before submitting modules to QA.

Environment: VS2008, Oracle-Toad, VSS, ASP.NET,SQL Loader

Confidential, Albany, NY

.Net Developer

Responsibilities:

• Analyzed all the requirement and prepared high level architectural diagram for the application
• Prepared High-level design specification document.
• Developed few of the ASP.NET web pages using C#
• Written few business functionalities in Data Access Layer ( DAL ).
• Performed code reviews and provided review comments accordingly with some best practices.
• Created stored procedures/functions/triggers using TSQL.
• Implemented Exception Handling and database Transaction management (COMMIT & ROLLBACK).
• Reviewed and provided the comments to the scripts developed by the team.
• Written lot of Complex SQL queries by Analyzing query execution plan, applying the required indexes, partitioning the huge tables with Local indexes to improve the query performance.
• Performed smoke level testing for the newly developed pages and also integration testing.
• Prepared Database deployment installation instructions document.
• Created scripts for unit test cases.
• Updated the Requirement Specification document with the latest requirement changes.
• Updated the Design Specification document with the latest client requirement changes.
• Performed unit testing, Debugged and fixed the errors before submitting modules to QA.

Environment: VS 2008, Oracle-Toad, VSS, C# .Net, SQL Server 2005