JOHNICA MELHIRAJ

SUMMARY

Creative and highly motivated professional Software Developer seeking to obtain a challenging position, that utilizes my strong technical skills and experience in the field of software design and development in .Net Technologies.

• Have 6 years of IT experience with exceptional skills in Analysis, Design and Development of Windows Applications, Web Applications using Microsoft Technologies.
• Expertise in Microsoft .Net technologies C .Net, ADO.NET, ASP.NET, VB.Net,MVC .
• Solid knowledge and experience with Web Forms, CSS, ASP.NET AJAX, JavaScript, UI design and development, consuming and manipulating data using ADO. NET.
• Good knowledge and experience in Client/Server Integration and Partial-page updates using AJAX Services.
• Hands-on database design and programming experience. User Defined functions using SQL PL/SQL in SQL Server 2005/2008 and Oracle 11g.
• Knowledge in .Net Framework 3.0/3.5/4.0/4.5 concepts WCF.
• Expert in developing views, stored procedures, cursors and triggers in SQL.
• Proficiency in designing and maintaining Microsoft SQL Server database/Oracle 11g including requirement analysis, design, data conversion, data migration data loading, testing and implementation.
• Involved in developing templates for Class Design Document, Database design Document and developed guidelines for effort estimation of Web based applications. Was involved in reviewing the templates and identifying the techniques to simplify the process of documentation for meeting ISO standards.
• Good knowledge in Data Warehousing concepts and tools like SSIS and SSRS.
• Excellent analytical skills with proficiency in debugging and problem solving.
• Proven technical skills and ability to work in a team for successful completion of project.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Role : Senior DEVELOPER

CRIMINAL BACKGROUND CHECK :

It is a web application developed to do the employment suitability determination for the different SOA OPWDD, OCFS, OASAS, OMH,Justice Center based on the finger print results of state and FBI response given by DCJS.

Responsibilities:

• Developed Web pages in ASP.NET for designing and c code behind to access data from Oracle 11g using Oracle data access.
• Used OOPS Methods for better performance.
• Used Server Side Validate Controls to validate the form fields.
• Used Repeater and grid for data binding from the data base
• Developed PL/ SQL Packages, Stored Procedures, Triggers, Views and Cursors for accessing the database.
• Involved in Unit, Integration testing and system testing.
• Used Team Server Foundation for Source Control.
• Created Program specification, Test cases and Data flow diagrams for new Pages developed.
• Worked on detail documentation .

Environment: Visual Studio 2010/Oracle11g

Confidential

Role : Application Developer

TAPR APPLICATION :

It is an application developed for generating the quaterly report for the federal government regarding employment, unemployment, wages and the retention based on the yearly and monthly basis.

Responsibilities:

• Developed Web pages in ASP.NET for designing and c code behind to access data from Oracle 11g using Oracle data access.
• Used OOPS Methods for better performance.
• Used Server Side Validate Controls to validate the form fields.
• Used Grid view for data binding from the data base
• Developed PL/ SQL Packages, Stored Procedures, Triggers, Views, Dynamic query and Cursors for accessing the database.
• Involved in Integration testing and system testing.
• Used Team Server Foundation for Version Tracking.
• Created Program specification, Test cases and Data flow diagrams for new Pages developed.
• Worked on detail documentation .

Environment: Visual Studio 2010/Oracle11g

Confidential

Role: Application Developer

SIDES STATE INFORMATION DATA EXCHANGE SERVICES :

Unemployment Insurance UI State Information Data Exchange System SIDES is a service that allows electronic transmission of UI information requests from UI agencies to multi-state employers and/or Third Party Administrators TPAs , as well as transmission of replies containing the requested information back to the UI agencies. The service actually post the records on the broker sides and pull the records from the broker sides

Responsibilities:

• Developed C .net application for posting the files in the broker sites.
• Used OOPS Methods for better performance.
• Used WCF service for posting and pulling the files.
• Involved in Integration testing and system testing.
• Used Team Server Foundation for Version Tracking..
• Created Program specification, Test cases and Data flow diagrams for new developement.
• Used log4Net for file logs.
• Worked on detail documentation .

Environment: Visual Studio 2010,C .NET

Confidential

Role: Application Developer

Indiana vital events record registry

Indiana vital records registry is a solution for registering and maintaining vital events for State of Indiana.IVER is based on CDC,NCHS and NAPSIS birth guidlines and is designed to meet current needs,improve data quality and user friendly.Electronic Birth Registration System is enable to do electronic filing of births,including electronic authentication by certifiers.It is a Role based and status based system.IVER previous records have been moved from current data base to new database to share the data with NCH,CDC and other agencies

Responsibilities:

• Developed Web pages in ASP.NET for designing and c code behind to access data from Oracle 11g using Oracle data access.
• Used OOPS Methods for better performance.
• Used WCF class library for datasharing and movement.
• Used Server Side Validate Controls to validate the form fields.
• Used Grid view for data binding from the data base
• Implemented Grid view adding, deleting, sorting the vital records
• Developed PL/ SQL Packages, Stored Procedures, Triggers, Views, Dynamic query and Cursors for accessing the database.
• Involved in Integration testing and system testing.
• Used Team Server Foundation for Version Tracking.
• Created Program specification, Test cases and Data flow diagrams for new Pages developed.
• Worked on detail documentation of the Role creation and Dashboard.

Environment: Visual Studio 2012/Oracle11g

Confidential human resource management system

Human Resource Management System is a management asset for Human Resource department. Human Resource Department is the Department where employee information is maintained and payroll is processed. Human Resource Management System assigns the Supervisor for each employee. The Additional information of the employee is also maintained in Human Resource Management System.The payroll processing and Income Tax Calculation is done for all the employees. The leave management, attendance details and time sheet details is also maintained for all the employees. Reports are given for payroll processing and Income tax Calculation.

Responsibilities:

• Developed Windows application C .NET and to access data from MS SQL Server 2008
• Developed Web pages in ASP.NET and to access data from MS SQL Server 2008 for master data
• Used OOPS Methods for better performance.
• Used Server Side Validate Controls to validate the form fields.
• Used File concepts for scanning the check from the Presentment bank to the clearing house.
• Implemented Data Grid view adding, deleting, sorting of rows for all the contacts and addresses of users.
• Developed MS SQL server Stored Procedures, Triggers, Views, Dynamic query and Cursors for accessing the database.
• Used Work flow concept for dynamic loading of buttons
• Involved in Integration testing and system testing.
• Used Team Server Foundation for Configuration Management and Version Tracking.
• Created Program specification, Test cases and Data flow diagrams for new Pages developed.
• Worked on detail documentation of the Role creation and Dashboard.

Environment: C .NET, ASP.NET, ADO.NET, SQL Server 2008.

Confidential Veracious check truncation system

Veracious Check Truncation System contributing to the industry the overall cost saving and improving the bottom line and stay competitive.It is used for optimizing the payment processing system and increasing the cost per transactions.Veracious clearing house is designed to send and receive from multiple touch points in a centralized and decentralized and in a distributed systems.CTS can be done in any touch points.It is used for clearing the check in a optimized payment processing.

Responsibilities:

• Developed Windows application VB.NET and to access data from MS SQL Server 2008
• Developed Web pages in ASP.NET and to access data from MS SQL Server 2008 for master data
• Used OOPS Methods for better performance.
• Used Server Side Validate Controls to validate the form fields.
• Used File concepts for scanning the check from the Presentment bank to the clearing house
• Used Grid control, List View, Tree view for data binding from the data base
• Implemented Data Grid view adding, deleting, sorting of rows for all the contacts and addresses of users.
• Developed MS SQL server Stored Procedures, Triggers, Views, Dynamic query and Cursors for accessing the database.
• Used Work flow concept for dynamic loading of buttons
• Involved in Integration testing and system testing.
• Used Visual Source Safe for Configuration Management and Version Tracking.
• Created Program specification, Test cases and Data flow diagrams for new Pages developed.
• Worked on detail documentation of the Role creation and Dashboard.

Environment: VB.NET, ASP.Net, ADO.NET, SQL Server 2008.

Confidential event management application system This is a management system which allows making reservation and payment.It is a complete web based system. This system efficiently handles Event setup, reservation, payment, cancellation, donation, Workshop management, Tour arrangement and reporting using heterogeneous database servers. Also efficiently interacted with Precept's core application component MPX for customer information where lakhs and lakhs of customer information are maintained.Reservations with at most facilities are provided in such a way that it even allows selecting the requirements in package level where different types of modules are logically grouped. and seasonal offer packages. Regarding the reservation, it can be done both in single as well as group. Rules are applied while making reservations and the reservation details are sent to participants through Email.

Responsibilities:

• Developed Web pages in ASP.NET and to access data from MS SQL Server 2008
• Used Web Form Controls to create web pages.
• Used Server Side Validate Controls to validate the form fields.
• Used Grid View Controls to display data from the database with paging and sorting
• Used Data binding to bind Server controls with the parameters from the tables in the database
• Implemented Data Grid view adding, deleting, sorting of rows for all the contacts and addresses of users.
• Developed MS SQL server Stored Procedures, Triggers, Views, Dynamic query and Cursors for accessing the database.
• Implemented caching services for better performance
• Involved in Integration testing and system testing.
• Used Visual Source Safe for Configuration Management and Version Tracking.
• Created Program specification, Test cases and Data flow diagrams for new Pages developed.
• Worked on detail documentation of the Role creation and Dashboard.

Environment: ASP.Net, ADO.NET, C .net, SQL Server 2005

Confidential Sale order management system

Sale Order Management System was developed to manage the Sale Order details and also to maintain the Supplier and Customer Details. Blanket Sale Order is also maintained in this system for each item. In the Blanket Sale Order the sale price is maintained the same for the number of years as per the agreement in the Blanket Sale Order. Normal Sale Order the sale price may differ Reports have been prepared based on the Customer and Supplier details.

Responsibilities:

• Developed Stored procedures ,Cursors Views for the Sale Order System
• Designing has been done with the Ramco Virtual works and deployed
• Designing and coding has been done for the Blanket Sale Order
• Reports has been designed and coded for the Blanket sale Order
• Implemented Data Grid control for adding, deleting, sorting of rows for all the contacts and addresses of users.
• Developed Oracle Stored Procedures, Triggers, Views, Dynamic query and Cursors for accessing the database.
• Involved in Integration testing and system testing.
• Used Visual Source Safe for Configuration Management and Version Tracking.
• Created Program specification, Test cases and Data flow diagrams for new Pages developed.
• Worked on detail documentation of the Role creation.

Environment: Rvw2.0, SQL Server 2000/2005, ORACLE 10g

Confidential Confidential

This system was developed to track the record of the current students and also the record of the students who have gone out of the College. This system helps to track in which file all the record of old students are maintained and able to retrieve when they approach the College. It also used to track the record of the current students and gives the details about the academic performance, fees balance, library fine everything can be viewed by the students in the intranet by giving the roll no and password.

Responsibilities:

• Developed Windows applications in VB.NET and to access data from MS SQL Server 2000
• Used Grid Controls to display data from the database
• Reports have been prepared for Old students and new students details
• Implemented Data Grid view adding, deleting, sorting of rows for all the contacts and addresses of users.
• Developed MS SQL server Stored Procedures, Triggers, Views, and Cursors for accessing the database.
• Involved in Integration testing and system testing.
• Used Visual Source Safe for Configuration Management and Version Tracking.
• Created Program specification, Test cases and Data flow diagrams for new Pages developed.
• Worked on detail documentation of the Role creation.

Environment: VB.Net 2003, ADO.NET, Oracle 10g

Project 2 : Confidential

This system was developed for the school to manage the library transactions. Library contains more than 10 millions books and CD's in various languages English, Arabic, French etc. books. All the transactions contain taken and return details. This system provides various query and reporting details. The availability of books/cd, Last transactions date, the frequent visitor details, Books/cd location details, the delayed return details. It also allows to anyone can query the search and find the availability of books/cd.

Responsibilities:

• Developed Windows applications in VB.NET and to access data from MS SQL Server 2000
• Used Grid Controls to display data from the database
• Reports have been prepared for Old students and new students details
• Implemented Data Grid view adding, deleting, sorting of rows for all the contacts and addresses of users.
• Developed MS SQL server Stored Procedures, Triggers, Views, and Cursors for accessing the database.
• Involved in Integration testing and system testing.
• Used Visual Source Safe for Configuration Management and Version Tracking.
• Created Program specification, Test cases and Data flow diagrams for new Pages developed.
• Worked on detail documentation of the Role creation.

Environment: VB.Net 2003, ADO.NET, SQL Server 2000/2005

Project 3 : Confidential

This system was developed to publish the exam results, to print the mark report and leave management. It covers leave types, leave balances, and leave availability. It stores the exam test results and performance analysis by subject wise, printing progress report and percentage of the result. It also helps to manage the school library. This system provides various query and reporting details. The availability of books/cd, Last transactions date, the frequent visitor details, Books/cd location details, the delayed return details. It also allows to anyone can query the search and find the availability of books/cd in the school library.

Responsibilities:

• Developed Windows applications in VB.NET and to access data from MS SQL Server 2000
• Used Grid Controls to display data from the database
• Reports have been prepared for Old students and new students details
• Implemented Data Grid view adding, deleting, sorting of rows for all the contacts and addresses of users.
• Developed MS SQL server Stored Procedures, Triggers, Views, and Cursors for accessing the database.
• Involved in Integration testing and system testing.
• Used Visual Source Safe for Configuration Management and Version Tracking.
• Created Program specification, Test cases and Data flow diagrams for new Pages developed.
• Worked on detail documentation of the Role creation.

Environment: VB.Net 2003, ADO.NET, SQL Server 2000