Project	Role	Technology	Duration	Company
Intelligent Medical Software (IMS)	Technical Lead	PB 8.0, Pocket PB 2.0 SQL Anywhere 9.0	51 Months	Meditab Software Inc. (USA)
It is one of the best practice management systems of USA. HIPAA complaint, Pen based and Speech Based EMR, HCFA 1500, UB92, Capitated, CMSP and CHDP billing, Document Management, Fax Management, Prescription, PDA synchronization, IVR, User defined reports and many other modules to make doctor's office paperless. * Acted as a Team leader and involved in full project cycle. * Studied system requirement from different sources and Designed database * Developed common classes and object on top of PFC classes and objects * Made changes in PFC framework * Developed EMR (Template, Image and Speech based), Scheduler, Check In/Out, Prescription, Document Management, Patient Demographic, Patient Note, Drug Education, ICD9 Education and Security modules * Involved in interface design for Billing (HCFA 1500, UB92, Capitated, CHDP and CMSP) * Involved in development of Electronic claims (Generate files in NSF 3.0 and 4010 formats) * Developed Super Bill and Scheduler modules for PDA in Pocket PB. * Used many ActiveX controls, which are developed in VB and VC++. * Used Handwritten to Text control for Tablet PC. * Defined Testing process for all the modules. * Developed Installation program and Implemented at client places. * Converted data from many other systems (SQL Server, Advance Database Server, Pervasive SQL, MS Access, FoxPro, Delimited Text File, Fixed Width Text File) * Studied NDC, Medex drug database and incorporated in IMS. * Developed intermediate module to transfer data from IMS to third party applications * Migrated application from version 6.5 to version 8.0
Intelligent Pharmacy Software (IPS)	Technical Lead	PB 8.0, Pocket PB 2.0 SQL Anywhere 9.0	30 Months	Meditab Software Inc. (USA)
It is renovative system for Pharmacy. It can be used for Walk-In and Closed-door pharmacies. It includes Prescription, Refill, Billing, TAR, Fill/Check, Delivery, Fax Management, and Drug Education modules. It works on Tablet PC, transfers data on PDA and sends claim to Insurance by EMC. It allows scanning prescription, sending fax for TAR and Doctor's call, getting signature on PDA. It includes IVR to call patient for pickup or any reminder. * Acted as a Team leader and involved in full project cycle. * Studied system requirement from different sources and designed database. * Developed common classes and objects on top of PFC classes and objects. * Developed Prescription, Filling, Delivery, Rx Refill, Walk-in and PDA modules. * Developed Scanning Rx, Send fax to Doctors and Reminder utilities. * Developed Drug education modules with Drug Interaction, Allergy and Contraindication validations. * Developed delivery signature and HIPPA signature module for PDA in Pocket PB. * Involved in testing of Billing, Fax Management modules. * Developed Installation program and Implemented at client places. * Written Procedures and Triggers for Inventory Maintenance. * Migrated database from SQL Anywhere 5.5 to SQL Anywhere 9.0
Intelligent Facility Software (IFS)	Technical Lead	PB 8.0, Pocket PB 2.0 SQL Anywhere 9.0	12 Months	Meditab Software Inc. (USA)
It extensive system for Facility (Care home). It allows to view required licensing agency forms and send fax to agency. Best Medication Administration module, Document Management, Admission Agreement, Extensive Resident form, Incident, Daily Note, Visitor Note and Billing. It works for Elderly, Child, Mentally disabled and adult facilities. * Acted as a Team Leader and involved in full project cycle. * Studied system requirement from different sources and Designed database. * Developed common classes and object on top of PFC classes and objects. * Developed MAR, Resident detail, Document Management, Billing, Security, Incident, Daily Note, Visitor Note modules * Developed Analytical and Graphical reports. * Involved in making test cases for testing. * Developed Installation program and Implemented at client places. * Installed and Implemented at client places.
MRP	Team Lead	PowerBuilder 7.0 ASA 7.0	6 Months	Meditab Software Inc. (India)
It is developed as a seperate module for existing system, which client has been using since long time. It generates reports by using process for to be delivered item, on hand qty, reorder/minimum qty, to be produced item, bill of material for item, on hand row material, to be ordered row material. * Acted as a Team Leader and involved in design the whole process. * Helped other developer to write process and genreate reports. * Communicated with client personally to understand requirement and implement with existing client system.
ERP	Team Lead	PowerBuilder 8.0 Oracle 8.1	24 Months	Elegant Microweb (India)
It is developed for Small and Medium Enterprise (SME). It has large database with more than 500 tables and 12 modules. It includes Finance, Purchase, Sales, Production, Quality Control, Payroll, MRP, Costing, MIS and Administration. Different level inventory, Import & Export, User defines reports, highly integrated and easy to implement. * Involved in system study of Finance and Sales modules * Involved in database design of all the modules * Involved to define integrity design, database and client level validations * Developed common classes and object on top of PFC classes and objects * Developed Finance, Sales and Security modules * Developed Report Designer and Query builder * Written store procedure and database triggers * Involved with Oracle DBA to define database architecture and improving performance * Tested MRP, Production and Purchase modules * Installed and Implemented system at client places * Successfully completed whole project as a Team leader of 10 members team * Taught PFC to junior programmers
Y2K Conversion Project	Team Lead	PowerBuilder 5.0, 6.5 Oracle 8.1	3 Months	Elegant Microweb (India)
This was a project for Essar Steel, one of the leading steel export companies in the world. Converted an existing application from PB 4.0 and Oracle 7.0 to PB 6.5 and Oracle 8.0.3. It included about 150 PBLs and about 500 tables. * Worked as a project leader. * Studied technical specs of the project. * Migrated project from PB 4.0 to PB 6.5 and defined process to solve technical problems after migration. * Actively involved at the time of testing. * Completed project successfully before deadline.
Banking	Sr. Software Developer	PowerBuilder 6.5 Oracle 7.3	18 Months	Bit 01 (India)
It is designed and developed as per Co-operative banks requirement. It includes 18 integrated modules like Current, Saving, Fixed Deposit, Loan, Investment, Administration, Payroll etc. It is successfully running in more than 300 branches. * Studied functional and technical specs of the system. * Suggested points to improve interface design * Rewritten database triggers to improve performance of the system * Solved Oracle related issues like Table space creation, User administration, Rollback use and Export/Import utilities * Designed module to export data from application by using oracle export utility * Developed Fixed Deposit, Investment and Payroll modules by using PFC * Helped other programmers to solve their technical problems
Discount Card Distribution	Sr. Software Developer	PowerBuilder 6.5 SQL Anywhere 5.5	3 Months	CSP (India)
This was a project for Essar Steel, one of the leading steel export companies in the world. Converted an existing application from PB 4.0 and Oracle 7.0 to PB 6.5 and Oracle 8.0.3. It included about 150 PBLs and about 500 tables. * Worked as a project leader. * Studied technical specs of the project. * Migrated project from PB 4.0 to PB 6.5 and defined process to solve technical problems after migration. * Actively involved at the time of testing. * Completed project successfully before deadline.
Process Control System	Sr. Software Developer	PowerBuilder 6.5 SQL Anywhere 5.5	6 Months	CSP (India)
This real time application can be used to monitor and control operation of any kind of plant. Its data acquisition system module can be used to get real time plant information. User can use other entry screens to enter various parameters for plant in intuitive way and system will configure plant as per entered parameters. * Studied technical specs and programming methodology which was done by Sybase Consultants * Used PFC extensively * Developed Complex interfaces using Tree view, List view and Tab pages * Used MS Flex Grid ActiveX extensively * Used multiple timers for getting real time data from database and show statuses on screen
Drug Distribution System	Sr. Software Developer	PowerBuilder 6.5 Oracle 7.3	6 Months	CSP (India)
This project was developed for a countrywide chain of drug wholesalers. Purpose of the system is to integrate business of different offices and provides all the information needed to control business to main office through data transfer. * Converted SDI application to MDI application * Developed framework like PFC for the company * Developed Purchase Bill, Sales Invoice, Delivery Slip, and Master forms * Written database triggers for updating inventory and account balance updation * Setup databases for Replication
Financial Accouting System (FAS)	Software Developer	PowerBuilder 5.0 SQL Anywhere 5.0	10 Months	Elegant Microweb (India)
It is a full package for retailor's accounting. It includes Sales, Purchase, Ledger, Profit & Loss Account, Balance Sheet and Inventory. It allows to handle mulitple companies by using different database. * Acted as a Software Developer and worked with other 2 team members. * Involved in database design of over all package. * Developed Sales, Purchase, Inventory modules * Used Treeview, Listview and Tab control in PB 5.0 (when it introduced in PB first time) * Written database triggers to maintain account balance, ledger and inventory.
Hospital Management System	Software Developer	PowerBuilder 4.0 Watcom SQL	4 Months	Sterling Computer (India)
It is developed for small hospital (3 to 4 beds) run by individual doctor. It includes inpatient, outpatient, complaint, diagnosis, prescription, cash and credit bills, receipt and followups. * Acted as a Software Developer and worked with other 2 team members. * Used PB 4.0 and Watcom SQL in this project. * Involved in implementation of project at client place.
Radiology Reporting System	Software Developer	PowerBuilder 4.0 Watcom SQL	4 Months	Sterling Computer (India)
It is developed for radiology and pathology reporting system. It includes patient setup, standard report based on Lab Test or XRay category, Cash and Credit Bills and Receipt.
Inventory Management System	Software Developer	FoxPro	4 Months	Sterling Computer (India)
It was my first project to handle incoming and outgoing inventory. There were two forms to enter in/out item and reports by Customer, Supplier, Item and Date.

Web Projects

Project	Role	Technology	Duration	Company
B2B (Supply Chain Management)	Team Lead	ASP, MTS, HTML, DHTML, XML	12 Months	Elegant MicroWeb (India)
It is B2B portal for Supply Chain Management. It is developed as an ASP concept. It allows company to add its all members of Supply chain. It includes Inquiry, Quotation, Purchase Order, Sales Order, Goods Receipt, Delivery Slip, Purchase Bill, Sales Invoice, Stock Transfer, Inventory, Geographical and Marketing Hierarchy. It imports and exports data in XML format. * Acted as a Team Leader and involved in System study and Database Design * Defined integrities among all the modules * Developed common functions and business objects in ASP and MTS * Developed generalize functions in JavaScript for client level validation * Developed Purchase Order, Sales Order, Goods Receipt, Delivery Slip, Purchase Bill, Sales Invoice and Security * Developed special module for reports (Sort Order, Rows per page, Column Sequence, Filter by fixed columns, Filter by user defined query, On Screen/Print/Email, Summary and Graph). * User defined themes and logos * Developed pages for Upload and Download files * Developed module for importing or exporting data in XML * Created database, written store procedure and triggers in SQL Server 7.0
www.webecosse.com	Team Lead	ASP, HTML, DHTML	4 Months	Elegant MicroWeb (India)
It is community portal for Scotland. It includes Member Registration, Message Board, Discussion Forum, Advertisement Space and allow member to contact each other. * Acted as Team Leader and involved in system design, database design and prototype design. * It is been devleoped as a web product with vanilla prototypes so it can be sold to any other company with different graphic layout. * Developed member registration, (n)th level dicussion board and advertisement handling module. * Interacted with client actively to understand requirement and enhancement.
www.lincolnpharma.com	Sr. Software Developer	ASP, HTML, DHTML	3 Months	Elegant MicroWeb (India)
It is a company website for product and company details.
www.fincobank.com	Sr. Software Developer	ASP, HTML, DHTML	4 Months	Bit O1 (India)
It is a bank's website including bank detail, interest rates for Loan and FD and allow customer to request view online account balance, request check book and send message to bank.
www.pharma-guide.com	Software Developer	ASP, HTML, DHTML	2 Months	Sterling Computer (India)
It is a portal for pharmaceutical products. It includes Member registration, product dealers and distributors, inquiry, product catalog and bulk drug information.