Projects: EMMAII

EMMAII is a software solution used to provide equipment maintenance lifecycle (quoting, Rating/Underwriting, Policy Issuance, Claim Processing, Claim payment, Vendor management, etc.) in one place for internal users in order to deliver effective customer service.

Responsibilities:

• Gather requirements and create technical specifications for all projects.

• Helped design team in the creation of effective application architecture for software to be developed.

• Developed and coded GUI and backend logic for modules in EMMAII using C#.

• Created database tables, complicated stored procedures and functions in SQL Server 2008.

• Designed and developed data access layer using ADO.net to communicate with SQL Server databases.

• Employed cutting-edge and powerful technologies, tools and concepts , including advanced .NET 4 features, LINQ, AJAX, Csla.NET, and MVC.

• Business logic is implemented as a common repository for all different modules in EMMAII.

• Reports are designed and generated using SSRS.

• Developed code to export all the data from reports into Excel.

• Have effectively used LINQ techniques as a way to get backend data in certain areas.

• Implemented code to check the validity of the user using Active Directory functionality.

• Implemented secure coding principles.

• Involved in QA testing.

Environment: Microsoft Visual Studio .NET 2010, C#, VB.NET, SQL Server2008, ADO.NET, ASP.NET, Java Script, Web Forms, TFS 2010, Web Services, SOAP, XML, ASP.NET AJAX, IIS, Windows 7, HTML , SSRS, Ms-Excel, WCF, SSIS, Telerik .

Projects: Members Connect, TripTik Connect, Membership Central , Agency Link (TMIC), IOC , EELaunch etc

Members Connect is an intranet application used by all employees to provide the customers with all Member services such as adding new member, upgrading service level, buying new gift membership, adding new associate, providing emergency road service, and generating several reports used by Branch managers.

Responsibilities:

• Gathered requirements and created technical specifications for all projects.

• Designed and developed Membership central application architecture.

• Developed GUI for modules in Members Connect using Web Forms and C#.

• Responsible for 24/7 production support for several applications.

• Re-architected and re-built the application to help clients achieve more than expected load.

• Created database tables, complicated stored procedures, functions and triggers in SQL Server 2000 and SQL Server 2005.

• Designed and developed data access layer using ADO.net to communicate with SQL Server databases.

• Employed cutting-edge and powerful technologies and tools, including reflection, .NET 3.5 features, AJAX, code generation, and nUnit.

• Created Web Service application using C#.NET to do Address verification service.

• Developed Membership Management, Payment , and Gift Membership management modules.

• Assisted and worked closely on integrating several third party vendor applications like IOC (information ordering system) and credit card servicing.

• implemented Business logic as a common repository for all different modules in Members Connect.

• Designed and generated reports using Crystal Reports and Report Viewer.

• Developed code to export all the reports into Excel sheet.

• Used ADO.NET in the Data Access layer and SQL Stored procedures using PL/SQL to access and manipulate data.

• Created service oriented architecture to get data from DB2 database from .NET code.

• Implemented code to check the validity of the user using Active Directory functionality.

• Implemented secure coding principles.

• Involved in QA testing.

Environment: Microsoft Visual Studio .NET 2008/2010, C#, VB.NET, SQL Server2005/2008, ADO.NET, ASP.NET, Java Script, WebForms, Microsoft Reporting Service, VSS, Web Services, SOAP, XML, ASP.NET AJAX, IIS, Windows XP, HTML, DB2 , Change Control, Crystal Reports,Ms-Excel, AS 400, WCF, SSIS .

Project: DCS

Deposit Correction system (DCS) application is a highly configurable web based system for creating corrections for out of balance conditions in financial transactions. DCS provides a means to define and record these errors, create the correcting documents to bring transaction into balance and generate customer notification.

Responsibilities:

• Designed and developed custom .NET components and user controls using ASP.NET and C#.

• Developed custom code to interact with third party vendor applications such as Key Entry, Nexgen Settlement , and Image center.

• Responsible for 24/7 production support to some of the applications.

• Re-architected and re-built the application to help clients achieve more than expected load.

• Created database tables, complicated stored procedures, functions and triggers in SQL Server 2000 and SQL Server 2005.

• Worked solely on converting entire COBOL application into .NET environment using C#.

• Designed and developed data access layer using ADO.net to communicate with SQL Server databases.

• Designed and developed modules such as Account Profiles, Administration and Reports etc using C #, Web Forms, ASP.net, ASP.NET AJAX and ADO.net.

• Worked well with customers to determine requirements, application scope and also responded adeptly to changing requirements.

• Responsible for working with local and international teams to deploy applications to QA and production environments.

• Employed cutting-edge and powerful technologies and tools, including reflection, .NET 2.0 features, AJAX, code generation, nUnit.

• Used agile methodologies , test driven development and automated builds.

• Designed new, and refactored existing, C# class libraries to provide more flexible, intuitive and consistent interfaces.

• Used a rapid application development paradigm, effectively employing object-oriented techniques, code generation and RAD tools.

Environment: Microsoft Visual Studio .NET 2005, C#, SQL Server2000/2005, ADO.NET, ASP.NET, Java Script, WebForms, Microsoft Reporting Service, .NET2.0, VSS, Windows Services, Web Services, SOAP, XML, ASP.NET AJAX, IIS, Windows XP, HTML, COBOL , Harvest, PICCT, Documentum , Change Control

Project: Success Works

SuccessWorks is a system developed for CIC. It operates both in standard and Bank Model and uses TeleTrack service to maintain customer information to make certain decisions.

Responsibilities:

• Designed and developed user controls using ASP.NET and C#.
• Created database tables, stored procedures, functions and triggers in SQL Server 2000 and SQL Server 2005.
• Designed and developed data access layer using ADO.net to communicate with SQL Server databases.
• Worked well with customers to determine requirements, application scope and also responded adeptly to changing requirements.
• Developed extensive reporting modules for data including held check summary, Daily Cash balance report per employee etc.
• Coordinated with offshore team for the design and development of additional modules.
• Designed new, and refactored existing, C# class libraries to provide more flexible, intuitive and consistent interfaces.
• Designed and developed modules such as Customer Information, Checks, Administration and Reports etc using C #, Web Forms, ASP.net, ASP.NET AJAX and ADO.net.
• Implemented .NET Web Services that allowed authenticated processes from client systems.
• Used some of the components from ASP.NET AJAX control toolkit.
• Used a rapid application development paradigm, effectively employing object-oriented techniques, code generation and RAD tools.

Environment: Microsoft Visual Studio .NET 2005, C#, SQL Server2000/2005, ADO.NET, ASP.NET, Java Script, WebForms, Microsoft Reporting Service, .NET2.0, VSS, Windows Services, Web Services, SOAP, XML, ASP.NET AJAX, IIS, Windows XP, HTML, .

Project: Utility Power Net (UPN.NET)

UtilityPOWERnet (UPN) is SEDC’s flagship product aimed at the utilities (power, water, gas) industry. It includes Consumer Billing, General Accounting and Capital Credits systems that allow the customers to take care of their day-to-day operations.

Responsibilities:

• Designed and developed class libraries that comprise the core application framework. The class libraries developed include Data Grid with advanced features, Menu System, Month Year calendar, Application Configuration and various user controls.
• Developed Logging utility that logs various application events.
• Designed and developed data access layer using ADO.net to communicate with existing HP3000 and SQL Server databases.
• Designed and developed modules such as Account History, Search,Payments, and Adjustments etc using C #, Winforms, ASP.net and ADO.net.
• Coordinated with offshore team for the design and development of additional modules.

Environment: Microsoft Visual Studio .NET 2003, C#, SQL Server, ADO.NET, Java, Servlets, Java Script, WinForms,Microsoft Reporting Service, .NET2.0, Windows Sharepoint server , VSS, Windows Services.

Project: Genetic Call Admission

It is an implementation of call admission control scheme and uses the genetic based algorithm to find the solution for the connection for a mobile user in next generation communication systems. This application was developed using Dot NET technology.

Responsibilities:

• Developed Use Case diagrams, Sequence diagrams and Collaboration diagrams using Rational Rose.
• Developed Windows form using .NET, which handles Change Password and Reset Password.
• Designed and developed several GUI Screens using .NET framework 2002.
• Used ADO.NET to perform database programming.
• Coded in C# for several functionalities to be included in to forms (Win Forms).

Environment: C#, Microsoft Visual Studio .NET 2002, Win Forms, Oracle, Windows, ADO.NET, Source Safe, Rational Rose, ASP.NET and UML.

Project: Online Web Portal

The System manages customer requests for information and provides instant on-line access to comprehensive health care centers information.

Responsibilities:

• Developed a Graphical User Interface in Java using Swing.
• Coded in JavaScript for the front-end validation for several GUI forms.
• Used Visual Age for Java 3.5 as an IDE tools for creating classes and beans.
• Developed E-Commerce Web Pages using JSP, JavaScript, HTML, and DHTML.
• Designed and Developed Session Beans and Entity Beans.
• Coded and Deployed EJB Components at server side using WebLogic Server.
• Performed analysis and co-created UML diagrams using Rational Rose.
• Created Session and Entity Beans (stateless and BMP).

Environment: Java2.0, JavaScript EJB1.1, Visual Age for Java, WebLogic5.0, JSP, Servlets, HTML, WindowsNT, JDBC, Oracle8.x, Struts, Solaris.

Project: ATR

The application was basically designed to make all the transactions of Air Ticket Reservation more secured.

Responsibilities:

• Developed a GUI in Java using Applets.
• Included in the coding of JavaScript for several forms.
• Used JDBC driver to establish the connection between the JSP and the database.
• Used Oracle database as the back-end.
• Used XML along with JSP to generate report.
• Used Servlets, JSP and JavaScript for client tier.
• Designed and Coded Session Bean and Entity Bean.

Environment: Java2.0, EJB1.1, Websphere, JSP, Servlets, WindowsNT, JDBC, HTML, JavaScript, Oracle 8.x.

Project: Property Tracking System

This application is an Intranet site developed for city to track property and their taxes. This system maintains all the details of the properties of each individual in the city and their respective taxes. It generates all tax reports about each individual as per the query by name, year, region, and their mortgage.

Responsibilities:

• Involved in the design and development of dynamic, on the fly web pages for the end user support for the customer’s.
• Created UML Design Diagrams using RationalRose for creating Class and Sequence diagrams.
• Responsible for creating the user interfaces using JSP, HTML and JavaScript.
• Involved in the template design and user interface design for the portal.
• Written triggers, Exceptions and Procedures for maintaining the integrity and correctness of the transactions in Oracle.
• Developed Servlets/JSP pages to present user interface.
• Used JDBC to connect to database.
• Implemented Applet-Servlet communication using RMI
• Developed EJB to encapsulate the business functionality and deployed on WebLogic server container.
• Developed stored procedures in Oracle.
• Designed prototyped screens.
• Involved in gathering functional requirements.

• Environment: EJB, Java 1.3, JSDK 2.1, Servlets, Applets, JDBC, JSP, Oracle, Jbuilder, JavaScript, HTML, Windows NT

IT Sector Service Management

This project is developed for its IT Sector. It’s an intranet based application package provides support services for IT sector which deals with software consulting, development, training, standards for technology development and web development. It includes Document Management, Data Administration and Resource Management.

Responsibilities:

• Designed and developed user interface in Java and JSP. JSP was used for server side scripting and JavaScript for client side validation.
• Extensively used XML in SAX/DOM parsers for parsing and data manipulation.
• Developed Stored procedures for select, insert and updating using Oracle.
• Numerous Oracle Stored Procedures, Triggers and Views created.
• Used ADO Stream Object for saving record set in XML stream.
• Designed and Developed a Java Wrapper class for document finding.
• Using Command Object in Oracle Callable Statements to execute the stored procedures
• Designed and Developed the Front End User Interface, Required Graphics, Navigation, HTML Layouts, Cascading Style Sheets.

Environment: JSP, Oracle 8i, XML/XSLT, HTML/DHTML, CSS, Java Script, MTS and WINDOWS NT 4.0