Sql Software Engineer

MANIKANDAN .B

No: *, II Floor, Sai Mansion,

Periyar pathai, ThiruNagar,

Chennai – 600 094.

Ph: 960*******

Email: **************@*****.***

Synopsis of Experience

• 2+ years of progressive IT development/support experience

• Strong experience in Oracle SQL and PL SQL Programming

• Exposure writing complex SQL Queries

• Experience Using PL/SQL Collections, Ref Cursor, Bulk collect and Oracle Supplied Packages

• Create Stored Procedures, Packages, Triggers, Views and Indexes

• Interaction with co-workers and users to high level of service provided to company / customer

• Handled projects individually from front-end user interface design, to back-end relational database design and development

• Involved in fixing Production issues

• Having knowledge in Unix

Education

• B.E (Computer Science) – Roever Engineering College from Anna University.

Work Experience

• Working as Software Engineer in Sphata Systems (June 2010 – Till date)

Expertise

Languages PL SQL Programming, SQL Queries

Database Oracle 11g, Oracle10g, Oracle 9i

Tools SQL Developer, Toad 8.6, PL SQL Developer 5.1.3, SQL Loader

Project Summary:

Mediconnect – Advantage claims Recovery Group (Acrg Business), USA

Mediconnect technology enables clients to custom-select the needed services and systems best suited for their unique needs

The objective of this product is to provide the client with robust software that generates around customized reports, which will either be used by the billing company for maintaining the database of the demographic information of the patients, provider’s treatment information and to maintain the EOB received from the several insurance companies. These reports will be generated based on the daily basis treatment and the reports are automatically sent to the insurance company for the reimbursement of the money and the EOB’s are maintained in terms of the patient.

Roles & Responsibilities:

As a Programmer as involved in the following

Involved in the life cycle of the project.

Involved in database design.

Database designing and preparation of design documents

Database Query tuning and Implementation.

Programmed Packages, stored procedures, queries, and triggers on Oracle 10g.

Understanding the requirements and carrying out impact analysis.

Unit and System Testing.

Add up new features to the product.

Environment: Oracle 10g, PL/SQL, VB script, SQL PLUS, JavaScript, XML, OOAD, Rational Rose.

EPIC – Shelter Insurance, USA

This software provides the practice management systems for the doctors internally inside the hospital and the revenue comes from the insurance company and patients to the hospital are maintained separately, These reports will be generated based on the daily revenue based upon the Inpatient, Outpatient, Emergency cases handled by the doctors.

Roles & Responsibilities:

Designing and preparation of design documents

Database Query tuning and Implementation.

Created Procedures, Triggers, Functions and Packages.

Understanding the requirements and carrying out impact analysis.

Code Walk Through, Review and Testing

Development & System testing.

Implementation of the application on Production Server.

Solving ITT Tickets. Bug Fixing

UAT and Live support.

Coordinate with the team

Environment: Oracle 10g, PL/SQL, VB, Tuxedo, Rational Rose, TOAD, SQL PLUS, SQL Developer

PERSONAL DOSSIER

Date of Birth : 27th March 1989

Nationality : Indian

Gender : Male

Marital Status : Single

Languages Known : English and Tamil

DECLARATION:

I do hereby declare that the particulars of information and facts stated above are true, correct and complete to the best of my knowledge.

Place: (Manikandan)

Date:

Contact this candidate