## BIO
Educational Qualification : Bachelor of Science in Computer Science, University of Madras, 1995 Diploma in Web Technology & Adv Java Technical Skills Primary Skillset : SQL Server 7 Database Administration , T-SQL Programming Additional Skillset : Java 2, PL/SQL , Oracle 8.0, Cloudscape, ANSI SQL Web-Enabling Skillset : HTML, XML, WAP, WML, Servlet, EJB, J2EE Operating System : Windows 95 /98/NT/2000, MSDOS, UNIX Experience Summary Ø Three Years & above of experience in Database Administration/Programming Ø Expertise in software development using MS-SQL Server 6.5/ 7.0, Java 1.2, EJB, Servlet, Web Server, WAP, WML in 2,3,n tire architecture Ø Good Knowledge in SQL Server 7.0 Web Reporting, and implemented the same with using template files Ø Involved in Database Design, Replication setup, Development, Administration, and Implementation of various applications. Ø Involved in monitoring and fine tunning for performance Ø Have upgraded databases from Oracle to SQL Server and vice versa, also transfered of PL/SQL procedures to T-SQL Stored procedures. Ø Hands on experience in installin and upgrading SQL Server 2000 Carrer Profile: DBA – Again technologies (I) Pvt. ltd., Chennai, India - Sep'2000 to till date DBA/Programmer – Nittany Decision Services Pvt Ltd, Chennai, India - Feb'1998 to Sep'2000 Lab-Coordinator – Chennai Computers, Chennai, India – Jan’1997 to Feb’1998 About M/s Again Technologies (Sep 2000 - tilldate) Currently working in M/s Again Technologies, Chennai as SQL SERVER DBA, Again Technologies provides complete software solutions to take the pain out of variable pay. Backed by venture capital firm Artemis Ventures, Again Technologies delivers flexible, scalable solutions, enabling companies such as ALARIS Medical Systems, PacifiCorp, Mitsubishi and Wilson's The Leather Experts to quickly and accurately pay employees whose compensation varies. Named a Red Herring 'Ten to Watch' company, Again Technologies is privately-held, with headquarters in San Mateo, Calif. For more information, visit [login to view URL]. Project Experience: Oct'2k to tilldate Project Name: CompEnterprise 1.0 Position : SQLSERVER Database Administrator/ Programmer Again Technologies has is own product called COMPSENSE 7.0 (Take the Pain out of Variable Pay) is build on Client-Server technology, now the company wants to go for the todays technology such as Java,Wireless communication, in n tire architecture, hence they decided to deliver COMPSENSE into COMPENTERPRISE, CE is a comprehensive, powerful software solution that helps sales, human resources and finance professionals manage all types of variable pay incentive compensation plans-from monthly sales commissions to performance-based bonuses to yearly profit sharing. With this product, companies are able to align variable compensation with strategic objectives and utilize variable compensation plan data as valuable business intelligence, critical to strategic decision-making designed for salespeople and sales management, human resource professionals, and finance professionals,this provides an accurate measurement and tracking system and clear visibility to performance from a number of perspectives. Softwares used : SQL Server 7.0, Java 2.0, Servlet, JSP, XML , JavaScript, EJB, J2EE About M/s Nittany Decision Services (Feb 1998-Sep 2000) Working since February1998 with M/s Nittany Decision Services, Chennai, as Programmer. NITTANY is an India based US Company having operations covering various parts of USA and India. It offers various services in the field of Telemarketing, Medical & Legal Transcriptions, Accounting, Billing and CAD for a number of clients in USA. Project Experience: Feb’2k to August’2k Project Name: Conversion of Data from Medic Database to Proactiv Position : Programmer cum Database Administrator Medic is the biggest billing software which is widely used in US. Clients, using Medic software for their billing migrating into ProActiv Software which was created by our office and this was running successfully more than a year, morever they wanted all the data from medic database is to be placed in Proactiv database Since their work need not to be stopped. This is the big project to convert largest amount of datas into the converting database. From source database, reports will be generated in the form of text file and these file will be formatted according to the proactiv database using PERL. Again the perl formatted text will be inserted into the proactiv using DTS that available in SQL Server 7.0. Software : Data Transformation Service in SQL Enterprise Manger 7.0, Perl ProActiv - A Comprehensive Medical Billing Software September’98 to February’99 Position : Programmer cum Database Administrator This is mainly a billing software which involves four main modules like Patient Demography, Insurance Details, Charge Details, Cash Details, Patient Demography Module is to maintain a detailed report of the patients undergoing treatment in U.S.A. Insurance Master module is maintain the details of the Insurance Company's in U.S.A in which each and every citizen of U.S.A are Policy holders. It also involves maintaining the rules and regulations of this Insurance towards their policyholders. Charge details module is to maintain charges made for the patient for their treatment. This treatment has much subdivision which need to be tracked before charging the patient for treatment. Cash Details module is an important module, which involves maintaining cash, transactions of the patient. Job responsibilities includes designing tables such as Patient Demography, Procedure Fee Schedule, Query analyzer etc. and creation of triggers, stored procedures, views, tables and database administration works like creation of database, replication to remote servers in client places and maintaining periodical backups Automatic execution of the Stored Procedures to increase the Speed and checking of the devices of the database is also done on a periodical basis. Software : SQL Server 7, Crystal Report 6.0, Java
## Area of Expertise
RDBMS, Microsoft SQL Server 6.5/7.0/2000
