SUMMARY:

• 10 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, AnalyzeExecution Plan improve the Performance by applying best practices.
• Around8 years of experience in scripting languages like VB Script Java Script.
• Good knowledge inAdvanced JavaScript Frameworks like AngularJS, BackboneJS, BootstrapJS.
• Exposure with Team Foundation Server TFS
• Good Knowledge in Data Structures.
• Good Knowledge in Java Script Object Notation JSON objects
• Around 4 Yearsof experience in creating and customizing Client/Server and Web based applications using ASP.Net, VB.Net, ADO.Net, XML, XSL,and Web Services.
• Good Experienceindatabase 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 Remoting components and Xml Web Services.
• Knowledge of developing web and client server reports using reporting tools like SSRS, Crystal Reports for .NET.
• Experienced withAgile 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:

PROFESSIONAL EXPERIENCE:

Confidential

Role: 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.NetEntity 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.
• Performed unit testing, prepared documentation, Debugged and fixed the errors before submitting modules to QA.
• Developed and implemented different user controls to provide the rich user interface reusability.
• CreatedMaster Pages to maintain consistent layout for the pages for the mobile application.
• Designed and developed base business class and other template classes for business entities using Generics.
• Used Visual Source Safe as version control.

Environment:Oracle 11g, TOAD, VSS, WCF, ASP.NET MVC 4, VS2010

Confidential

Role: Sr. PL/SQL 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:Oracle 11g, SQL Server 2000, VSS, SQL Developer for Oracle,

Erwin Data modeling tool.

Confidential

Role: 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