Claims:1. A processor implemented method comprising:
obtaining, by a hardware processor, from a client device associated with a user, an email comprising at least one of a file, or a file identifier, wherein said file comprises a first set of records;
executing (i) a first set of instructions, or (ii) a second set of instructions based on said email, wherein said first set of instructions comprises:
a) parsing said file to identify and validate said first set of records;
b) querying a first record specific database to determine at least one of inconsistent record, new record, missing record, and redundant record based on said first set of records; and
c) automatically updating said first record specific database based on said at least one of determined inconsistent record, new record, missing record, and redundant record,
wherein said second set of instructions comprises:
i. performing a validation of said email and said file identifier, said file identifier is indicative of information stored in a second record specific database;
ii. generating, in at least one format, attachment file comprising information from said second record specific database based on said email and said file identifier being validated; and
iii. communicating an email with said attachment file to said client device.

2. The processor implemented method of claim 1, wherein the step of obtaining, an email is preceded by validating said client device and said user associated with said email.

3. The processor implemented method of claim 1, further comprising validating said file by performing a file level validation on at least one of a filename, a file size, and content type specific to said file.

4. The processor implemented method of claim 1, further comprising generating a report based on said at least one of determined inconsistent record, new record, missing record, and redundant record.

5. The processor implemented method of claim 1, wherein said first record specific database and said second record specific database are identical.

6. A system comprising:
a memory;
one or more communication interfaces; and
one or more hardware processors coupled to said memory through said one or more communication interfaces, wherein said one or more hardware processors are configured to:
obtain, from a client device associated with a user, an email comprising at least one of a file, or a file identifier, wherein said file comprises a first set of records; and
execute (i) a first set of instructions, or (ii) a second set of instructions based on said email, wherein said first set of instructions are executed by said one or more hardware processors to:
a. parse said file to identify and validate said first set of records;
b. query a first record specific database to determine at least one of inconsistent record, new record, missing record, and redundant record based on said first set of records; and
c. automatically update said first record specific database based on said at least one of determined inconsistent record, new record, missing record, and redundant record, and
wherein said second set of instructions are executed by said one or more hardware processors to:
i. perform a validation of said email and said file identifier, said file identifier indicative of information stored in a second record specific database;
ii. generate, in at least one format, an attachment file comprising information from said second record specific database based on said email and said file identifier being validated; and
iii. communicate an email with said attachment file to said client device.

7. The system of claim 6, wherein when said email is obtained, said one or more hardware processor validates said client device and said user associated with said email.

8. The system of claim 6, wherein said one or more hardware processors validate said file by performing a file level validation on at least one of a filename, a file size, and content type specific to said file.

9. The system of claim 6, wherein said one or more hardware processors are further configured to generate a report based on said at least one of determined inconsistent record, new record, missing record, and redundant record.

10. The system of claim 6, wherein said first record specific database and said second record specific database are identical.
, Description:As Attached