Professional Summary

Over twelve years of rigorous experience in Client-Server computing, Process Analysis, Design and Development, Object Oriented Analysis and Design OOAD , and Database technologies as a Systems Analyst, Architect, Developer and Tech Lead who has excellent team and communication skills. Strong in VB/VB.NET, ASP.NET, ADO.NET, ASP, MS-SQL, MS Access, MS Excel VBA, JQUERY, Visual Studio 2003 2008 and Crystal Reports. Well versed in Java Script and XML. Fluent in Visual FoxPro, C , PL/SQL and ODBC. Proficient in Windows 95/98/NT/2000/XP and UNIX environments.

Experience

Confidential

Application Developer

• Work management system WMS was developed using .Net technology to track daily work and time reporting. The application included design and development of new .Net screens using VB.NET, C and ASP.NET, Web service to insert records from different groups as well as web enabling over 300 CICS programs using IBM web bridge. I was responsible for the architecture and design of the web framework and led a team of 3-6 developers to deliver the application in a phased manner.
• The WebWMS is a web-based application that provides advanced search, MIS reporting, and scheduling capabilities based on data captured in the field. It also allows to insert and update daily work progress and time entry for different types of field work. This web-based application is developed in VB.NET, C and ASP.net with AJAX JQuery technology. It uses a DB2 database with access via DB2 Connect. XML, XSLT and CICS bridge are also used to web enable CICS screens.
• WebWMS webservice project was developed using .net and SQL server database to transfer service records and get the work status. SQL stored procedures and dynamic queries are used to insert and select records from SQL server. Created MIS reports using Stored procedures and VBA.
• NuCon New construction project was developed to track electric and Gas work for new constructions. The application included design and development of new .Net screens using VB.NET, ASP.NET, and SQL server.
• I was also involved in the analysis, design and architecture of several .NET based forms for integration of ProjectOne, a third-party Oracle based system, with WMS.
• I have successfully upgraded WebWMS to Visual studio 2008, .net Framework 3.5 ASP.NET 2.0.
• Technologies Used

Confidential

• An Confidential was developed to capture stray voltage, visual inspection and different types of equipment such as capacitors, regulators, reclosers, sectionalizers, and switches including GOABS and MOABS.
• The application provides search, reporting, and scheduling capabilities based on data captured in the field as well as inserting and updating locations, inspection, and settings for different devices. This web-based application developed in ASP.net with AJAX technology and uses a DB2 database with access via DB2 Connect, and VB.net development software.
• Technologies Used

Confidential

Systems Analyst / Developer

• Confidential are developed by GT3 for ground transportation providers which provide them a comprehensive back-office software system to manage Network Providers, Limousine, Executive Sedan or Taxi/ASAP service. This Windows and Internet technologies based software fully integrates Reservation, Dispatch and Accounting in one Management System. It has other important features like Automatic flight updates and validation of flight information Online credit card authorization and settlement Real-time reservations from websites, agencies and automated reservations etc.
• Role Involved Process and Data flow analysis for new module development and writing database scripts. Maintaining existing .NET applications and development of various new front-end modules on the .NET platform using ASP.NET, ADO.NET and Java Script. Writing stored procedures, triggers and indexes for SQL Server 2005.
• Technologies Used

Confidential

Systems Analyst / Developer

• Confidential are systems developed in-house at WellChoice to automate/facilitate the core medical insurance business activities of WellChoice. CDR Comparative Distribution Report s is the perfect tool for educating healthcare providers about their performance for specific code family and in selected locality and specialty. The tool generates graphic reports and sends them to the providers. ADS Automated Development System provides data entry screens for historical information of transaction details, search capability on data fields and report generation facilities. IDTF Independent diagnostic testing facility is the system used to lookup permissible procedure codes under which healthcare providers can bill Medicare.
• Role Involved Process and Data flow analysis Database design Development of various front-end modules on the .NET platform using VB.NET, ADO.NET and ASP.NET to interface with IBM mainframe macros Writing stored procedures, triggers and indexes Tuning database queries for optimal execution plans Data transformation using DTS services into MS SQL from IBM mainframe Maintenance of legacy front-end developed in VB 6.0 and ASP.
• Technologies Used

Confidential

Systems Analyst / Systems Analyst

• Confidential is an application for viewing and analyzing customers' point-of-sale data, inventory movement, inventory status, or other business critical data. OrderConX is an application for viewing vendors' inventory availability and order status, and enables the transmission of electronic procurement documents. Both MarketConx and OrderConx use the DataConx application for sharing business critical information in real-time between disparate business systems.
• Role Involved Project Management, Process and Data flow analysis Database and Product architecture design Development of the applications Data transformation using DTS services into MS SQL Writing stored procedures, triggers and indexes Front-end development in VB 6.0 and ASP. Helped developing same project in .net. Created forms using VB.Net and ADO.Net.
• Technologies Used

Confidential

Systems Analyst / Web Developer / Project Lead

• Confidential business to employee initiative to integrate and centralize all processes of the organization and to facilitate the management of human resources. The system keeps track of the employees from the time of joining the organization and maintains their personal details like skill set, project history, current project information, appraisal information etc. Other features include online timesheet entry, payroll generation, employee project information, invoice generation, salary appraisal, document management etc.
• Role Involved Requirements analysis Data modeling Writing stored procedures, triggers and indexes Front-end development in VB 6.0 Writing ASP pages using VBScript.
• Technologies Used

Confidential

Project Lead

• Confidential is a web-based Client Server enterprise tool developed for reporting and tracking any bugs related to products developed by the company. The tool works as a communication channel between the QA and development teams. Salient features of the tool include web based UI for reporting and viewing of bugs filtering and sorting of bugs role definition of users corresponding to their responsibilities in the project development master data management etc.
• Role Involved Project Management, Web interface design and development in ASP using VBScript Design and implementation of database in SQL Server for bugs and test cases reporting and maintenance.
• Technologies Used

Confidential

Systems Analyst / Developer

• Confidential is a product developed for the chemical business transactions of Balcolor, Germany. This product works as a repository of details of each transaction cycle of the chemical business of Balcolor. A typical transaction starts from a 'Customer Enquiry' or as a 'Request to Customer'. The system generates a 'Supplier Quotation' in case of short supply of a specified product requested by the customer. Once the deal is finalized with a supplier the system raises a 'Supplier Order'. The system then raises an offer to the customer requesting the product. The 'Supplier Quotation' as well as 'Balcolor's Offer' is stored by the system as 'Negotiation of Price'. Once the customer finalizes the order the system generates an Invoice and Shipment for the customer. The system supports generation of word documents for Orders, Invoice, Packing List and Delivery Notes. The product has been developed in VB 6.0, ASP, VBScript and HTML. SQL 7.1 has been used as the backend database.
• Technologies Used

Confidential

Systems Analyst / Developer

• Confidential was developed for Confidential as a complete project management tool. The system takes care of all the projects developed/under development by the company and all details related to those projects as modules, number of programmers involved, start and expected end dates of modules and the actual date of completion. The system also provisions submission of daily report from employees team members and remarks by project leaders. Role involved study of an existing system and database normalization. Designed and developed modules for project status information, payroll system to calculate monthly salary and generating reports.
• Technologies Used
• This system was developed for Confidential to efficiently manage the landing and parking data of its aircrafts at its various sites. Different sites of Confidential generate data feeds in MS Excel format. This system handles data conversion from Excel to FoxPro database. The system applies various business rules to this converted data according to the aircrafts' 'Parking Area type' to calculate the parking charges. The system also provides various customizable reports including data entry error reports that are generated according to the aircrafts' landing and dispatch time.
• Technologies Used

Confidential

Systems Analyst / Developer

Confidential

This package handles complete Purchase order including Quotation and overall stores system of the company. Key modules of this system are Quotation Entry, P.O Generation for different types of raw materials, consumables and job work and P.O. Approval for senior management . The package also includes several generalized routines for system maintenance. Customizable reports can also be generated based on various filters. Was involved in Analyzing and redesigning existing system, determining new requirements and enhancements required in the system, preparing flow-charts, data flow diagrams DFDs , database structure modifications, coding, implementing, testing as well as maintaining other software's.

Technologies Used

Confidential

Systems Analyst / Developer

• Confidential industry. The objective was to computerize all the manual systems of the company such as purchase order, inventory, finance, payroll etc. It also includes computerization of all their daily transaction such as attendance entry, invoice generation, Delivery Tickets etc. Printing of all documents related to purchase orders, delivery of material and payrolls was also to be computerized. Responsibilities included Analyzing current manual system with the aid of a Questionnaire Designing, development and testing of system Regular meetings with users to get new requirements as well as enhancements Complete system testing with a top to bottom approach and final implementation.
• Technologies Used
• VB 6.0, COM, SQL Server 7.x

Confidential

• This system includes inventory, billing, Purchase order generation, expense details etc for Medical Stores. It's mainly used to keep track of non-moving and expired items. The system can generate alerts for about-to-expire as well as non-moving items so that they can be returned to pharmaceutical companies or dealers so as to minimize the loss incurred on those items. The system can also monitor the sales and purchase of medical items and can also be used to find out balance payment to dealers etc. Responsibilities included Analysis and development of the system database designing, flow charts, DFD's and test-plans preparation, forms and reports designing, coding, modules testing, system testing Implementation and demonstration to users.
• Technologies Used
• VB 6.0, MS Access