Over 6 years of experience in the design and development of CRM and Client/Server applications under Windows Operating systems . Actively involved in the full project life cycle from user requirements definition to implementation and testing.

 Over 3 years of experience in database programming and GUI design. Skills include Business systems design, development and programming using Clarify11.2/10.1. Extensive hands on experience in Oracle 8.X RDBMS and MS-SqlServer.

Over 3 years of experience in design, development and programming using VisualBasic, HTML and Crystal Reports.

MS in Computer Applications

BS in Physics

Languages : Clarify11.2/10.1, SQL, PL/SQL, C, Pro *C, Visual Basic.

GUI Tools : Visual Basic, MS-Access, C Sharp, VB.Net, ASP.Net, XML

Systems : PC, Sun Sparc.

Middle Ware : Tuxedo 6.4

Coreon provides support to Service Providers for operational needs for multiple services, like DSL access to Internet Services, Voice Over IP, Wireless, etc.. Coreon will support the Service Provider’s End-Users. The Trouble Management System(TMS) will be used by the Customer, End User, and the Coreon Associates for Customer TT and Network TT. Coreon TMS will be used by the Customer’s Call Center CSR to provide diagnostics on the Web Client. The TMS will be interfacing with Order processing systems to get information about the customer, end-user, SLAs, etc.. Actively involved in the design, development, customization and implementation of Trouble Ticketing of Clarify application in a n-tier environment.  

• Customized existing Clarify forms for Trouble-Ticketing using clear basic code
• Configured Part details, Queues, Task Sets in Clarify for different databases
• Added message handlers to the forms and customized pop-up lists
• Involved in Data Mapping , converted legacy data to Clarify format and performed initial loading to the database using Dataex
• Written CB-batch programs to upload data in tables
• Created new Events, Event Creation Time for business rules
• Created new business rules for cases with different priorities, Queue Notification/Escalation
•  Used DATAEX utility to migrate data from one database to another database
• Added new values in tables gbst_lst, gbst_elm through Dataex
• Created new employees with different privilege classes
• Written CB-batch program for change status of a case
• Written CB-batch program for order processing through web interface for Clear call center
• Actively involved in Detail design creation and test case generation
• Modified ASP code for Sales Force Automation on the Web
• Installed Clarify and Oracle database
• Made schema changes for the tables
• Lead the team and trained all the users in clarify clear support module
• Worked closely with the developers on the client side in resolving their issues and monitoring the logs and troubleshooting the errors
• Involved in pre-production and post-production bug fixing and maintenance

Teradyne Boston, MA Sep ‘00 – Dec ‘00

Teradyne is the interconnection solutions provider of choice for leading companies in the semiconductor, telecommunications, computer and Internet industries. Involved in Clarify application Clear support , Analysis, Design and customization of database and front-end application. Worked on Functional and Technical Specs Design.

• Made Schema changes by adding new field to the existing clarify tables
• Written CB-batch program in clarify for closing a case from Lotus Notes
• Interacted with the customers on site
• Created Detail Design and test plan
• Involved in pre-production and bug fixing and maintenance
• Performed customization with Case and Close Case Screens
• Added message handlers to the forms

Technical Environment: Clarify 10.1(Clear Support, Clear Contracts) Clear Basic, UI Editor, DD Editor , DataEx, CBEX , Windows NT, Oracle 8.0

ISP Channel, Mountain View, CA. July ‘00 – Aug ‘00

As an Analyst/Programmer at ISP Channel was involved in the installation, customization and configuration of Clarify application Clear Call Center. Involved in customization of Data Base, Front-End application.

• Interacted with customers on site to gather user requirements Customization of Database and Front-End application.
• Worked on form Customization, which included adding of new fields, buttons, and drop down list boxes
• Customized Customer interaction screen in Call Center application
• Used Clear Basic code to include the functionality on the modified forms
• Used DD Editor to make changes to the Data Base
• Installed Oracle and Clarify

Technical Environment: Windows NT, Oracle 7.2, Clarify 9.0 (Call Center), Clear Basic, UIEditor, DDEditor , CBEX

F5 Networks Seattle, WA. Jan ‘00 – June ‘00

F5 Networks of Seattle is in the business of providing load sharing software and high-availability hardware systems. Its call center operations can be divided into product Support and Sales support. It integrated the InterLYNX CTI product with their current Clarify Customer Relationship Management software to take advantage of the following functionality. Inbound screenpop based on ANI information, Outbound preview dialing and Intelligent transfer. Involved in the design, development, testing and Implementation of Computer Telephony Integration(CTI) application with Clarify. 

• Customized Clarify forms according to CTI integration component
• Created New Forms adding Clarify functionality through clear basic code
• Used ClearBasic to interact with CTI integration component through a well-defined ActiveX interface
• Used InterLYNX Software to interface with Clarify
• Written Clearbasic code to store customer information using Case, Contact, Site and Product
• CTI Integration has Inbound screenpop, Call transfer and Outbound preview dialing
• CTI has ACD, IVR, PBX , PSTN, DNIS
• Made Schema changes in the existing clarify tables
• Trained the project team in ClearSupport and ClearCallCenter module

Senior Programmer/Analyst

As a programmer analyst was involved in the installation, customization and configuration of Clarify application Clear Sales. Involved in customization of Data Base, Front-End application.

  Role:

• Customized Clarify clear sales forms
• Created functional documents for ClearSales module
• Created new user defined tables
• Modified existing Clarify tables and views
• Integrated Calico application with Clarify using Clear Basic
• Performed Unit testing, Integration testing
• Performed DBA support for training, production and test databases

Technical Environment: Clarify 7.0(Clear Sales ), Clear Basic , SqlServer6.5, Windows NT

 Programmer/Analyst

As a programmer analyst, involved in the installation, customization and configuration of Clarify application Clear Support. Involved in customization of Data Base and Front-End application.

• Worked on form Customization, that included adding of new fields, buttons, and drop down list boxes
• Used Clear Basic code to include the functionality on the modified forms
• Made Schema changes to the existing clarify tables
• Created new business rules for cases with different priorities, Queue Notification/Escalation
• Created Detail Design and Test plans

Technical Environment: Clarify 6.0 (Clear Support), Clear Basic , SqlServer6.5, Windows NT

R & B Inc, PA. June ‘98 – Dec ‘98

The Inventory Analysis system was developed for automating the manual inventory tracking system. QAD software using SQLSERVER was used for this conversion

• Fully involved in the backend and created tables
• Created Master Detail Relationship, Index for tables
• Written stored procedures to replicate tables from QAD to SQLSERVER
• Generated reports using Crystal Reports

Technical Environment: Visual Basic 5.0 , MS-SQL Server 6.5,CrystalReports, Windows' 95.

DSQ Software Ltd., India. June ‘97 - May ‘98

The Network Management System(NMS) for OKI Japan consists of three modules. They are DRC, DSC and CSV. The user can issue a command to the Unix server and get a response from the server. Exchange of data from VB to Unix server can be done through Winsock control in Vb. Extensively used C++ Dlls.

• Involved in the design of the module named Circuit Status Viewer(CSV)
• Designed and developed GUI Screens CSV Trunk Line and CSV Subscriber Status screen
• Used Menubar, Toolbar and MsFlexGrid controls
• Written procedures for the CSV module that will run in Command line arguments
• Written procedures to sort data in Grid control
• Loaded pictures in toolbar controls using resource files
• Created User Requirement Specification(URD), System Requirement Specification (SRS) and Detailed Design (DDD)

Technical Environment: Visual Basic 5.0, MS- Sql Server 6.5, Windows 95

The Maintenance Terminal Software(MTS) for OKI Japan is an enhancement of an existing Internet Telephone Gateway software. This consists of three modules. They are Offline, Office-Data and File control.

• Designed and developed GUI screens for User level password entry screen and MTS Password screen
• Created Detailed Design
• Created Unit and Integration test plans

The ActiveX control is used for a product called LanSneaker in DSQ. This is an enhancement of an existing MS Chart control with some modifications to satisfy the needs of the customers.

• Designed and developed a user control with an existing MS Chart control
• Written procedures to display graph types
• Written procedures for ortho-graphic projection
• Used property pages to build MS-Chart control

(May ‘96 - May ‘97).

• Hofinsoft Services, Pvt., Ltd., India, Programmer (Nov ‘95 - April ‘96).