Post Job Free

Resume

Sign in

Sr SAS Developer & Analyst

Location:
chennai, TN, 600042, India
Salary:
100000$
Posted:
July 26, 2011

Contact this candidate

Resume:

R.N.KARTHIKEYAN m1yttr@r.postjobfree.com

OBJECTIVE:

To lead a team and to work in a dynamic organization with stimulating work environment.

SUMMARY:

Development Lead with more than 9 years of experience in systems analysis, product Maintenance, application development and testing. I also have 3+ years of experience in ETL tool ‘SQL Server Integration Services’. I also have more than 6 years of experience in SQL Server database programming and DTS tools. I have extensive experience in developing offshore applications with Microsoft Technologies having very good understanding of SQL & OOPS Concepts.

Possessing a strong IT understanding coupled with analytical skills; I have participated in executing projects successfully for different clients in UK, Middle East & India with domains like Healthcare, Banking domain.

ABILITY AND STRENGTHS:

• Capability to lead and work as a team to solve complex problems in a fast paced environment.

• Having good exposure to client/server technologies and good knowledge in distributed Systems.

• Having knowledge in database development, data extraction and ETL tools.

• Having knowledge in Full System Development Life Cycle, including analysis, design, coding and testing.

• Ability to work independently.

EXPERIENCE SUMMARY:

• Working as a Development Lead with iSoft R&D Private Ltd., Chennai, from May 2004 to till date

• Worked as a Programmer with Scope International for Esquire Systems., Chennai, from Mar 2003 to May 2004

• Worked as a Software Engineer with Global e-Solutions Ltd., Chennai, from Dec 2001 to Feb 2003

ACADEMIC QUALIFICATION:

• Post Graduate Diploma in Business Administration (Equivalent to MBA), New College Institute of Management, Chennai, 1995 - 1998.

• Bachelor’s Degree in Science (The New College), University of Madras, 1992 – 1995.

TECHNICAL QUALIFICATION:

• Diploma in Computer Applications, MEASI Computer Academy, Chennai, 1992 – 1993.

• Diploma in RDBMS (Oracle 8.0 and D2K 5.0), Software Solution Integrated Limited, Chennai, 1998

TECHNICAL SKILLS:

EXPERTISE IN:

Operating System : Windows 98/2000/XP/2003

Programming Languages : VB 6.0, C#

Databases & Tools : SQL Server 2000/2005/2008, DTS, SSIS, SSRS, Oracle,

MS Access

Other Utilities : Crystal Reports, Crystal Enterprise, CSP, COM, VSS,

CM Synergy,

Web : HTML, XML

KNOWLEDGE IN:

Programming Languages : C, C++, Java,

Databases & Tools : DB2

Other Utilities : IBM On Demand Server

Web Servers : IIS, PWS

PROJECTS HANDLED AT iSOFT R&D PVT. LTD:

PROJECT PROFILE:

Project Title : Patient Management System (i.PM)

Client : NHS, UK

Period : May 2004 – Till Date

Architecture : 2-tier

Platform : Windows 2000/XP

Presentation : Visual Basic 6.0, C#

Database & Tools : MS SQL Server 2000/2005/2008, SSIS, DTS

Other Tools / Technologies : XML, Crystal Reports, COM, VSS

PROJECT DESCRIPTION:

iPM captures indispensable real time information at the point of patient care. Specialized modules such as Inpatient, Out-patient, Accident & Emergency and Theatre module combine to provide integrated tools to improve information quality.

Each healthcare provider organizations is unique, i.PM has been developed with the flexibility to enable specific function to be selected, supporting the precise patient and business management processes of each organization

iPM provides a single patient management and administration suite across suite , community and mental health facilities. This is combined with advanced clinical functionality offering results reporting, order management, clinical data capture

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Role: Development Lead

Responsible for design and development of various extracts and reporting modules in i.PM.

The module includes ‘Master Patient Index’, ‘Outpatient appointment’, ‘Referral’ and ‘Reporting’ modules.

There are other modules which extracts data from the main application for various puposes. These includes Commissioning Data Set(CDS), Mental Health Minimum Data Set(MHMDS), Health Resource Grouping(HRG), Medicode and various management and operational reports. The ‘SQL Server Integration Services’ (SSIS), ‘Data Transformation Service’ are used for extracting and processing these data.

PROJECTS AT SCOPE IINTERNATIONAL:

PROJECT PROFILE:

Project Title : eSUITE

Client : Standard Chartered Bank, UAE.

Period : Mar 2003 – May 2005

Architecture : 3-tier

Platform : Windows 2000/XP

Presentation : Visual Basic 6.0

Database : DB2

Other Tools / Technologies : Crystal Entriprise, Crystal Reports, CSP, ASP, JSP,

IBM On-Demand Server, VSS

PROJECT DESCRIPTION:

eSuite is a solution for complete Banking System. It contains various projects like eBBS, eRAMS, Investments, Internet Banking, eCRM and KYC..eSuite projects are developed basically for Standard Chartered Bank in MESA(Middle East South Asia) region. The project is developed at Scope International, ISCI (International Software Center, India) .

eBBS is a core banking system, presently 8 countries in the MESA region have implemented this product. Currently projects are undergoing for outside MESA region (US and Philippines). The project contains core banking modules for Relationships, Masters, Account, Limits, Sweeps, Charges etc. The project also supports various surround systems through uploads and downloads. Surround system for on-line and off-line reports distribution.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Role: Team Member

I was responsible for development the of Interim Excess module. Development and implementation of Online and offline Report Distribution Architecture using Visual Basic, Crystal Enterprise and IBM On-demand. Statement request module. The Statements are sent to the customer based on the frequency set on the particular Account. Statements are distributed to customers through various modes like Fax, Post, e-Mail etc. The statements are distributed either on-line or during the EOD. The statement extraction program generates statements and distributes it the mode specified that. The Statement by post is given as downloads to the third party vendor for distribution.

PROJECTS AT Global e-Solutions Ltd.

Project Title : SECTRA (Share Transfer System)

Client : Acme Capital Services Pvt. Limited, Chennai.

Period : Dec 2001 – Feb 2003

Architecture : 2-tier

Platform : Windows 2000/XP

Presentation : Visual Basic 6.0

Database : Oracle 8.0

Other Tools / Technologies : Crystal Reports

PROJECT DESCRIPTION:

SECTRA is software developed for Share Transfer Agents. This software contains all the features which are necessary for Share Transfer Agents. This includes Company Details, Share Certificate Details, and Share Holder Details. The Master module contains entry for Company, Controller (SEBI), Share Certificate, Share Holder, Annual General Meeting, Monthly Meeting etc.

This software also provides additional modules for Dividend Entry, Dividend Calculation, Dividend Reconciliation, Warrant Print etc. Other important module provided by this software includes Call Money Entry, Call Collection, Forfeiture of Shares, Paid Up Shares. These are link modules for the Share Issues Software.

Reports in this software are developed using Crystal Reports. The types of reports available in this software include General Reports, MIS Reports, Control Break Reports, Statutory Reports, Registers, Letters, Share Issues, Meeting, History etc.

Special features like Backup and Restore is also included in this software.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Role: Team Member

I was responsible for development of Transaction, Transmission and Transposition module.

Personal Information

Contact Address : No. 2/29, New Secretariat Colony, 3rd street, Velachery,

Chennai - 600042.

Date Of Birth : 6th May 1975

Current CTC : Rs 9.8 lakhs p.a.

Notice Period : 2 Months

Mobile : 984**-*****

Current Location : Chennai



Contact this candidate